Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation on 02/23/14 in all areas

  1. 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
    1 point
  2. You could just add OR to the query to add an additional item, or you could create a script-based query to delete an array of items; here is the former: DELETE FROM `inventory` WHERE `id` = '7179' OR `id` = '909'; DELETE FROM `cart_inventory` WHERE `id` = '7179' OR `id` = '909'; DELETE FROM `storage` WHERE `id` = '7179' OR `id` = '909'; DELETE FROM `guild_storage` WHERE `id` = '7179' OR `id` = '909'; You can load this script and it will (in theory) automatically delete all the items from the array .@item_id from player inventories and storages, regardless of whether or not they are online; this is untested: - script delete_all -1,{ OnInit: // List of item IDs to delete setarray .@item_id[0], 909, 910, 911; // Build list of account IDs query_sql "SELECT `account_id` FROM `login`", .@account_id; // Loop for each account for (.@i = 0; .@i < getarraysize(.@account_id); .@i++) { // Loop for each item for (.@j = 0; .@j < getarraysize(.@item_id); .@j++) { // Check if account is logged in if (isloggedin(.@account_id[.@i])) { // Delete items from online player inventory attachrid .@account_id[.@i]; delitem .@item_id[.@j], countitem(.@item_id[.@j]); detachrid; } } } // Loop for each item for (.@i = .@j = 0; .@i < getarraysize(.@item_id); .@i++) { // Delete items from all inventories/storages query_sql "DELETE FROM `inventory` WHERE `id` = '"+ .@item_id[.@i] +"'"; query_sql "DELETE FROM `cart_inventory` WHERE `id` = '"+ .@item_id[.@i] +"'"; query_sql "DELETE FROM `storage` WHERE `id` = '"+ .@item_id[.@i] +"'"; query_sql "DELETE FROM `guild_storage` WHERE `id` = '"+ .@item_id[.@i] +"'"; // Build list of item names .@item_name$[.@j++] = getitemname(.@item_id[.@i]); } // Announce deleted items announce "The following items have been deleted: "+ implode(.@item_name$, ", "), bc_all; end; }
    1 point
  3. Name : Bron_G Game : Trickster Online File Size: 584 KB Author: ToZorMan Download : Mob - Bron_G [ToZorMan].zip Link : www.green-peach.net ----------------------------------------------------------------- Name : Bell Game : Trickster Online File Size: 410 KB Author: ToZorMan Download : Mob - Bell [ToZorMan].zip Link : www.green-peach.net ----------------------------------------------------------------- Name : Taurus_Crown Categorie : Up Headgear File Size: 329 KB Author: Gravity Download : Hat - Taurus_Crown [ToZorMan].zip Link : www.green-peach.net ----------------------------------------------------------------- Name : Taurus_Diadem Categorie : Up Headgear File Size: 306 KB Author: Gravity Download : Hat - Taurus_Diadem [ToZorMan].zip Link : www.green-peach.net ----------------------------------------------------------------- Name : Pokeball Categorie : Pokemon File Size: 119 KB Author: Unknown Download : Item - Pokeball [ToZorMan].zip Link : www.green-peach.net
    1 point
×
×
  • Create New...