Leaderboard

///////////////////////////////////////////////////////////////////////// //---------------------------------------------------------------------// // MINING (EXPLOSION TYPE) // // AUTHOR: LIL TROLL//COLDFIRE // //---------------------------------------------------------------------// // RATHENA SCRIPT // //---------------------------------------------------------------------// // Version 1 // //---------------------------------------------------------------------// // Credits to: // // - Sir Emistry(For teaching me OnTouch). // // - Lesbie for requesting the script. // // FEATURES: // // - Set the configuration, run the script. // // - Add duplicates. // // - Player set the explosion and run for it! // // - Wait till the explosion off then grab the items. // // - NPC AutoHides after set of explosions. // //---------------------------------------------------------------------// ///////////////////////////////////////////////////////////////////////// explosive_mining.txt

E - Script Collection Last Update : September 10, 2013 Refine Function SQL Mission Board Monster Marching Vendor Control Advanced Stylist Coin Exchanger Doppelganger Race Of The Day Limited Items Multi Currency Shop Random News GM Online List Link Broken E-Inquiry DotA Runes Flower Counting Game Class Restriction Chain Quest Build Manager Misc Scripts : Freebies Script Card Trader Gold Room [ Pick Gold ] Gold Room [ Guild Tax ] Map Restriction [ GM Based ] Daily Reward Monthly Reward Monster Spawner Monster Summoner with Last Summoned Display Players Stats & Equipments 3rd Job Item Giver Exchanger [ Cashpoint to Coins ] Exchanger [ Poring Coin - Zeny ] Exchanger [ Points to Tickets ] Exchanger [ Item to Item ] Exchanger [ Item to Item ] Exchanger [ Multi Item to 1 Item ] Party Match Auto Ban Over Stats Users Soul Link Buff Kill Players gain Cash Points Party Members All Get Items [ Snippet ] Message Board Stalker Class Skill Reproduce NPC Multiple Selection Quest [ Template ] In-Game Item Rewarder In-Game Points Rewarder Invasion Event Custom Item Rate Status Point Seller [ Snippet ] Anti Bot Security Script Anti Bot Script [ Code / Question ] Item Combo Restriction [ LHZ Card ] Drop Item Upon Death PVP Switcher + Announcer [ Guild Master ] Rotating Waitingroom Messages +10 Refiner [ Specific Items ] Random Rate Item Exchanger MVP Invasion Premium Users [ Boost Rates ] Display Cutin Image upon Login Custom Randomed Box Items Kick GM during WOE Custom Crafting NPC Restrict Same IP [ Certain Map ] Coloured Items Exchanger Guild Master Changer Party Team PK Match Gambling Game IRC Channel Crafting NPC Guild Storage Restriction Stage Game [ Version 4 ] Monster Wiki Event [ Version 3 ] Special Thank you for my Tutor : Notes : I am a bit lazy to write all those Script Descriptions, i do believe that all of you able to get how this script works. Anyway, i will still doing my best to write the Updated Changelog or informations about the script as detail as possible. All the Scripts above are uploaded to Pastebin . Abide the Following Rule : Scripts Error / Not Working , you have to Explain it in Details. ( Add in Images / Modified Scripts ) Do not SPAM / BUMP in my Topic. Do not ask for Support stuffs for other Scripts in this Topic. Link Down , then drop [ @Emistry ] a message. I Reserved the Right for NOT Answering your Posts if you did not abide my Topic's Rules. Keep This In Your Mind : All the Scripts i distribute here are NOT FOR COMMERCIAL USES . DO NOT remove my Credits if you are using part of the scripts to modify your own. DO NOT re-release the scripts in any form / way. If you ♥ these Scripts , Click on to Vote this Topic up. Or you may also click on at above the Topic

conf/battle/misc.conf#L102 // Set this to the amount of minutes autotrade chars will be kicked from the server. at_timeout: 0

Change disablenpc "Banker"; to : disablenpc "Mr.Banker";

Use tabulators instead of spaces to separate the values of the NPC header (first line of a script). http://rathena.org/wiki/Basic_Scripting#NPC

$sql_ip = "".$_SERVER['SERVER_ADDR'].""; $sql_user = "ragnarok"; $sql_pass = "ragnarok"; $sql_db = array( 'ragnarok' ); //Warning: Be sure not to use POST variables inside the query because of SQL Injection $itemid = 4363; $string = "WHERE `nameid` LIKE '".$itemid."' OR `card0` LIKE '".$itemid."' OR `card1` LIKE '".$itemid."' OR `card2` LIKE '".$itemid."' OR `card3` LIKE '".$itemid."'"; $sql = mysql_connect($sql_ip, $sql_user, $sql_pass); if(!$sql) die("Failed to connect to $sql_ip SQL Server.<br>"); $query = mysql_query("SHOW DATABASES"); $dbss = array(); $db = array(); while($row = mysql_fetch_array($query)) $dbss[] = "".$row[0].""; foreach($sql_db as $dbs) { if(!in_array($dbs, $dbss)) die("Database $dbs has not been found on the server.<br>"); $query = mysql_query("SHOW TABLES FROM `$dbs`"); while($row = mysql_fetch_array($query)) $db[$row[0]] = $dbs; } heres the script for the amount of items ingame $amt = 0; $query = mysql_query("SELECT * FROM ".$db['inventory'].".`inventory` ".$string.""); while ($row = mysql_fetch_object($query)) {$amt += $row->amount;} $query = mysql_query("SELECT * FROM ".$db['cart_inventory'].".`cart_inventory` ".$string.""); while ($row = mysql_fetch_object($query)) {$amt += $row->amount;} $query = mysql_query("SELECT * FROM ".$db['storage'].".`storage` ".$string.""); while ($row = mysql_fetch_object($query)) {$amt += $row->amount;} echo "Item ID ".$itemid." exists ".$amt." times!"; heres the script for the amount of player owning the item (not counting the storage) $ItemOwner = array(); $query = mysql_query("SELECT * FROM ".$db['cart_inventory'].".`cart_inventory` ".$string.""); while ($row = mysql_fetch_object($query)) { if(!in_array($row->char_id, $ItemOwner)) $ItemOwner[] = $row->char_id; } $query = mysql_query("SELECT * FROM ".$db['inventory'].".`inventory` ".$string.""); while ($row = mysql_fetch_object($query)) { if(!in_array($row->char_id, $ItemOwner)) $ItemOwner[] = $row->char_id; } echo "".count($ItemOwner)." Player own Item ID: ".$itemid."";

if (select("Enter PVP. ["+getmapusers(""+$@lista$+"") +"]:I'm out of potions today.") == 1) { warp ""+$@lista$+"",0,0; end; } change to if (select("Enter PVP. ["+getmapusers( $@lista$ ) +"]:I'm out of potions today.") == 1) { warp $@lista$,0,0; announce strcharinfo(0)+" entered "+$@lista$,0; end; }