Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- prontera,155,181,5 script Sample#countdb 757,{
- mes "Input Item ID...";
- do{
- input .@ItemID;
- }while( getitemname( .@ItemID ) == "null" );
- query_sql( "SELECT SUM(`amount`) FROM `inventory` WHERE `nameid`='"+.@ItemID+"'",.@Sum );
- set .@Total,.@Total + .@Sum;
- query_sql( "SELECT SUM(`amount`) FROM `cart_inventory` WHERE `nameid`='"+.@ItemID+"'",.@Sum );
- set .@Total,.@Total + .@Sum;
- query_sql( "SELECT SUM(`amount`) FROM `storage` WHERE `nameid`='"+.@ItemID+"'",.@Sum );
- set .@Total,.@Total + .@Sum;
- query_sql( "SELECT SUM(`amount`) FROM `guild_storage` WHERE `nameid`='"+.@ItemID+"'",.@Sum );
- set .@Total,.@Total + .@Sum;
- mes "Found Total of ^0055FF"+.@Total+" x "+getitemname( .@ItemID )+"^000000 in Server";
- close;
- }
Advertisement
Add Comment
Please, Sign In to add comment