yuhsing

Untitled

Nov 15th, 2012
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. prontera,155,181,5 script Sample#countdb 757,{
  2. mes "Input Item ID...";
  3. do{
  4. input .@ItemID;
  5. }while( getitemname( .@ItemID ) == "null" );
  6. query_sql( "SELECT SUM(`amount`) FROM `inventory` WHERE `nameid`='"+.@ItemID+"'",.@Sum );
  7. set .@Total,.@Total + .@Sum;
  8. query_sql( "SELECT SUM(`amount`) FROM `cart_inventory` WHERE `nameid`='"+.@ItemID+"'",.@Sum );
  9. set .@Total,.@Total + .@Sum;
  10. query_sql( "SELECT SUM(`amount`) FROM `storage` WHERE `nameid`='"+.@ItemID+"'",.@Sum );
  11. set .@Total,.@Total + .@Sum;
  12. query_sql( "SELECT SUM(`amount`) FROM `guild_storage` WHERE `nameid`='"+.@ItemID+"'",.@Sum );
  13. set .@Total,.@Total + .@Sum;
  14.  
  15. mes "Found Total of ^0055FF"+.@Total+" x "+getitemname( .@ItemID )+"^000000 in Server";
  16. close;
  17. }
Advertisement
Add Comment
Please, Sign In to add comment