Linkin Park

just edit the update query and set the amount to whatever value you want.

tao gunka card item id: 4302 Execute the following query in your database card0 is the first slot of the item DELETE FROM `inventory` WHERE nameid=4302 UPDATE `inventory` SET card0=0 WHERE card0=4302 DELETE FROM `storage` WHERE nameid=4302 UPDATE `storage` SET card0=0 WHERE card0=4302 DELETE FROM `cart_inventory` WHERE nameid=4302 UPDATE `cart_inventory` SET card0=0 WHERE card0=4302

@Asura, This will only save the backups on the specified directory, I want it to be uploaded on a separate ftp server.

Anyone here can make an automated war event? Like, the Party leader will talk to an NPC, the NPC checks the online party members if they are 3, 4, or 5 depends on what war event they wil register. Once the party is registered, they will be warped to the Event Map and the map has a safezone where they can't walk to the center of the map. When another party has registered on the same war event they registered, the registration will close, then on the event map, the counter begins. Maybe 10 seconds. After 10 seconds, the barriers of the safe zone will be removed and then they can move to the center for battle and PVP will be turned on. During registration, when a party has registered, it'll be announced like "The party [ Party Name Here ] has registered in 3v3 War Event!" And when there are 2 parties registered, the NPC will announce like "3v3 War Event will start. Both [ Party A Here ] and [ Party B Here ] are registered!" During the event, all registrations will be closed (3v3, 4v4, 5v5 registrations). It'll be open once the previous event has ended. When a player is killed, it'll be auto warp back to his/her save point. When a party has no alive members left, the opposing party will win. After the event, PvP will be turned off. When a party won, it'll be announced "Party [ Party Name Here ] has defeated [ Party Name B Here ] party in the War Event!. Registrations are now open!" Restrictions will be No the same jobs for each party. Must be different jobs/class. bumps..

bump...

How to setup a cron job that will automate database backup every 3am and make it upload the backup file to a separate ftp server? Using CentOS.

Read post #11

No need to edit DB files.

Thanks Euphy It's working

It's working perfectly! Thanks Euphy! I thought of something, can this be edited so that when the user has 1 Fusion Ticket, the success rate will be 100%? and if the user has no 1 Fusion Ticket, the specified rate will be used. Also an announcement of successful fusion globally if its not too much to ask of course

Idk if I read your topic right, but you can't really see public chats once you are inside a pub.

I want to request an NPC that can combine headgearA and headgearB and produce headgearA with the effects of headgearA and headgearB. I made this using @item2 command And to be much easy to configure, itemA and itemB should be in an array something like setarray .itemFuse1[0],itemidA,itemidB,fuseRate; setarray .itemFuse2[0],itemidA,itemidB,fuseRate; setarray .itemFuse3[0],itemidA,itemidB,fuseRate; setarray .itemFuse4[0],itemidA,itemidB,fuseRate; .... .... I can add more arrays for .itemFuseN[0] Similar settings for with this from http://rathena.org/b...ro/#entry109922 OnInit: // Format: <%>,<item ID>,<count>{,...}; setarray .P1[0],70,607,25; setarray .P2[0],70,13710,1; setarray .P3[0],40,5471,1; setarray .P4[0],40,5210,1; setarray .P5[0],40,5224,1; setarray .P6[0],50,2357,1,2524,1,2421,1,2115,1; setarray .P7[0],25,2701,1; setarray .P8[0],5,2394,1; setarray .Default[0],12214,1; setarray .Cost[0],7227,300; set .Total,8; end; The menu will show something like: itemname(itemidA) + itemname(itemidB) itemname(itemidA) + itemname(itemidB) itemname(itemidA) + itemname(itemidB) itemname(itemidA) + itemname(itemidB) itemname(itemidA) + itemname(itemidB) the menu will vary on how many arrays are available from the config. Similar with the Quest Shop of Euphy Fusion can fail based on the chance/rate in the array. When it failed, both items will be destroyed or deleted. When fusion is successful, user can obtain the item through delitem itemidA,1; delitem itemidB,1; getitem2 itemidA,1,1,0,0,0,0,0,itemidB;

@Euphy, is it possible to make an item that is lower than 1% rate? something like 0.1 or so...

I suggest you take your time to move to rAthena. If you won't do it now, you'll be left behind with an outdated and bugged eAthena svn.

Thanks. Works just the way I want it. Hope the Thread Starter would find it useful too

Thanks, it works. Can I add more arrays like .P9[0], .P10[0] .....?

@Euphy, tried the script, It's working. Can it be modified just announce the item that has lower than 10% chance? I don't know if this was intended I'm getting all items in this array setarray .P6[0],50,2357,1,2524,1,2421,1,2115,1;

^ It has the same rate for all items. We would like it be able to configure the rates through an array of item ids and array of rates instead of modifying the whole NPC or several lines of the NPC.

maybe get the array value and then divide it by 100? @GM Taku, it kills the point of gambling to an NPC, also with an NPC it's possible to make it announce like 'RaGERO got an apple from Lotti Gurl with a 20% chance' OPB doesn't have it.

I need this too. Prolly somebody could make it like setarray .itemID[1],607,677,676,7711; //random item prizes setarray .itemRates[1],80,80,10,1; // 1000 = 100% or something.. dunno lol I really have no idea about how array works.

For the first request, I think you are looking for the Charm System http://www.eathena.ws/board/index.php?showtopic=246304

Nope, it's not compatible with rAthena.

tradelog table

I support this Nice suggestion. This will somehow motivate more the dev team.

I want to know what 2011 clients has the Custom Aura Sprites and the Ctrl + 1,2,3 shortcuts or the flag emotes.. bumps! anyone?!