Triedge

A Database Error OccurredError Number: 1222The used SELECT statements have a different number of columnsSELECT * FROM ((SELECT * FROM (`tcp_shop`) JOIN `item_db2` ON `item_db2`.`id`=`tcp_shop`.`item_id`) UNION (SELECT * FROM (`tcp_shop`) JOIN `item_db_re` ON `item_db_re`.`id`=`tcp_shop`.`item_id`)) a ORDER BY `name_japanese` asc LIMIT 0, 10Filename: F:AppServwwwcorasystemdatabaseDB_driver.phpLine Number: 330  
 
 
 
Solved. Just adding Bindonequip to item_db2
 

In application/controller/shop.php
if(isset($_GET['cat'])) { switch($_GET['cat']) { case 'consume': $cond = array('index'=>'item_db.type','val'=>array(0,2,11,18)); break; case 'head': $cond = array('index'=>'equip_locations','val'=>array(1,256,257,512,513,768,769)); break; case 'weapon': $cond = array('index'=>'item_db.type','val'=>array(5)); break; case 'shield': $cond = array('index'=>'equip_locations','val'=>array(32)); break; case 'armor': $cond = array('index'=>'equip_locations','val'=>array(16)); break; case 'robe': $cond = array('index'=>'equip_locations','val'=>array(4)); break; case 'shoes': $cond = array('index'=>'equip_locations','val'=>array(64)); break; case 'accessories': $cond = array('index'=>'equip_locations','val'=>array(8,128,136)); break; case 'pets': $cond = array('index'=>'item_db.type','val'=>array(7,8)); break; case 'cards': $cond = array('index'=>'item_db.type','val'=>array(6)); break; case 'costumes': $cond = array('index'=>'equip_locations','val'=>array(1024,2048,3072,4096,5120,6144,7168,8192)); case 'misc': $cond = array('index'=>'item_db.type','val'=>array(3,10)); break; } } Change for:
if(isset($_GET['cat'])) { switch($_GET['cat']) { case 'consume': $cond = array('index'=>'type','val'=>array(0,2,11,18)); break; case 'head': $cond = array('index'=>'equip_locations','val'=>array(1,256,257,512,513,768,769)); break; case 'weapon': $cond = array('index'=>'type','val'=>array(5)); break; case 'shield': $cond = array('index'=>'equip_locations','val'=>array(32)); break; case 'armor': $cond = array('index'=>'equip_locations','val'=>array(16)); break; case 'robe': $cond = array('index'=>'equip_locations','val'=>array(4)); break; case 'shoes': $cond = array('index'=>'equip_locations','val'=>array(64)); break; case 'accessories': $cond = array('index'=>'equip_locations','val'=>array(8,128,136)); break; case 'pets': $cond = array('index'=>'type','val'=>array(7,8)); break; case 'cards': $cond = array('index'=>'type','val'=>array(6)); break; case 'costumes': $cond = array('index'=>'equip_locations','val'=>array(1024,2048,3072,4096,5120,6144,7168,8192)); case 'misc': $cond = array('index'=>'type','val'=>array(3,10)); break; } }

I have script (Capitalism System) and source mod.
 
Which controls the price of consumables based on several factors, such as flow zenys, supply and demand for consumable items.
if demand is currently very high, it is increasing the price of the object based on 5%.
Otherwise, it reduces the object's base price 3%.
The base price is controlled depending on the flow of current zenys on the server.

@@malufett Any updates?

But that does not overwrite the previous value?
 
Previous value => .@test [4]  = 5
New Value => .@test [4]  = 6

you can also use setarray
 
for example
 
setarray .@test [0],1,2,3,4,5;
 
if(Class == Swordman)
setarray .@test [getarraysize(.@test)-1],6,7,8;

if(Baselevel > 90)
setarray .@test [getarraysize(.@test)-1],9,10;

How you do that ? Mind share ? @@xathenx

get
mapreg->readreg( script->add_str("$abc");
 
set
mapreg->setreg( script->add_str("$@cde"), 1000 );

in: npc/custom/jobmaster.txt
Search line:
set .ThirdClass,1;    // Enable third classes? (1: yes / 0: no)
Change for:
set .ThirdClass,0;    // Enable third classes? (1: yes / 0: no)

Hi,
 
The DL link is dead.

prontera,150,150,0 script Sample 100,{ if ( getcharid( 1 ) ) { getpartymember getcharid( 1 ), 1; getpartymember getcharid( 1 ), 2; do { .index = rand( $@partymembercount ); .random_member$ = rid2name( $@partymemberaid[ .index ] ); } while ( !isloggedin( $@partymemberaid[ .index ], $@partymembercid[ .index ] ) ); mes "Random member : " +.random_member$; } close;} A template

As this has been pointed out
Also the queue feature provided in hercules makes a alternative to adding people to games/events without chatrooms.

I did bg_pvp script in rathena forumwithout source modification
http://rathena.org/board/topic/73801-can-someone-fix-this-for-me-thank-you/?p=154091
http://rathena.org/board/topic/90734-annieruru-custom-bg/?p=236961
 
with source modification
http://rathena.org/board/topic/73755-requesting-3v3-event-semi-bg-type-blue-team-vs-red-team/?p=172997
 
what you need to do is, use source modification and put every party member into a team with setbgid
 
and if you test my script, you'll immediately notice there is an advantage over party system
-> the party system counted every single player on the map,
if there is 3 players on team A and 4 players on team B, it will display 1/7 at the right down corner of the screen
-> the battleground system has bg_updatescore, which you can use the scoreboard manually display the score in any way you like

Hello,
*setcell "<map name>",<x1>,<y1>,<x2>,<y2>,<type>,<flag>;  
basic example is
setcell "arena",0,0,300,300,cell_basilica,1;
 
for more information visit Wiki: Setcell

yeap
ASC_BREAKER have:
Cooldown: 10 sec
Delay in level 10: 2.8 sec.
cast and fixed cast in: 0.25 sec.

1000:1200:1400:1600:1800:2000:2200:2400:2600:2800 Skill Delay in Level 1: 1 sec
Skill Delay in Level 2: 1.2 sec
Skill Delay in Level 3: 1.4 sec
Skill Delay in Level 4: 1.6sec
Skill Delay in Level 5: 1.8 sec
Skill Delay in Level 6: 2 sec
Skill Delay in Level 7: 2.2 sec
Skill Delay in Level 8: 2.4 sec
Skill Delay in Level 9: 2.6 sec
Skill Delay in Level 10: 2.8 sec

I don't think that rA's source code is that different than Hercules', just some functions have changed in those files as far as I'm aware of. Instead of using a diff patcher you could do those changes manually.
Regards.

done problem solved <3 hehehehe

with Renewal Features:
In src/map/status.c
str = (int)(rstr + (float)dex/5 + (float)st->luk/3 + (float)((TBL_PC*)bl)->status.base_level/4); change for:
str = (int)(rstr + (float)dex/5 + ((rstr/10)*(rstr/10))+ (float)st->luk/3 + (float)((TBL_PC*)bl)->status.base_level/4);

with Renewal Features:
In src/map/status.c
str = (int)(rstr + (float)dex/5 + (float)st->luk/3 + (float)((TBL_PC*)bl)->status.base_level/4); change for:
str = (int)(rstr + (float)dex/5 + ((rstr/10)*(rstr/10))+ (float)st->luk/3 + (float)((TBL_PC*)bl)->status.base_level/4);

OMG!  this type of codebox  crashes my firefox
 
http://herc.ws/board/public/js/3rd_party/prettify/prettify.js:1

Ragnarok Costume Job - Oktoberfest


Job ID: OKTOBERFEST = 29
Effect State: OPTION_OKTOBERFEST = 0x10000000
Item: 22625 = Oktoberfest_Bag (Activates the costume for 10 minutes)
 
// Oktoberfest Outfit22625,Oktoberfest_Bag,Oktoberfest Bag,2,0,,100,,,,,0xFFFFFFFF,7,2,,,,,,{ sc_start SC_OKTOBERFEST,600000,0; },{},{}  
Ragnarok Oktoberfest Job Sprites.rar

Note: This is a official costume job released exclusively for European RO server from the Oktoberfest event. I don't know if it works on the latest kRO clients we can connect with.
 
Thanks goes to jaBote for sending me the sprites.

in: npc/custom/jobmaster.txt
Search line:
set .ThirdClass,1;    // Enable third classes? (1: yes / 0: no)
Change for:
set .ThirdClass,0;    // Enable third classes? (1: yes / 0: no)

in: npc/custom/jobmaster.txt
Search line:
set .ThirdClass,1;    // Enable third classes? (1: yes / 0: no)
Change for:
set .ThirdClass,0;    // Enable third classes? (1: yes / 0: no)