forked from johnl0l/AdobeRO
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathCheckItem.txt
21 lines (21 loc) · 917 Bytes
/
CheckItem.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
izlude,156,141,4 script ºÃÔ¡ÒÃàªç¤äÍà·Á 533,{
mes "ÊÇÑÊ´Õ¤èеéͧ¡ÒÃàªç¤äÍà·ÁªÔé¹ä˹¤èÐ";
mes "¡ÃÍ¡ÃËÑÊäÍà·Áä´éàŤèÐ";
next;
input .@item_id;
query_sql( "SELECT SUM(`amount`) FROM `inventory` WHERE `nameid` = '"+.@item_id+"';", .@inventory );
query_sql( "SELECT SUM(`amount`) FROM `cart_inventory` WHERE `nameid` = '"+.@item_id+"';", .@cart );
query_sql( "SELECT SUM(`amount`) FROM `storage` WHERE `nameid` = '"+.@item_id+"';", .@storage );
query_sql( "SELECT SUM(`amount`) FROM `guild_storage` WHERE `nameid` = '"+.@item_id+"';", .@g_storage );
mes "ª×èÍäÍà·Á: "+getitemname(.@item_id)+" /"+.@item_id;
mes " ";
mes "ã¹µÑǼÙéàÅè¹: "+.@inventory+"ªÔé¹";
mes "ã¹Ã¶à¢ç¹: "+.@cart+"ªÔé¹";
mes "㹤Åѧ: "+.@storage+"ªÔé¹";
mes "㹤Åѧ¡ÔÅ: "+.@g_storage+"ªÔé¹";
mes "ÃÇÁ·Ñé§ËÁ´ = "+(.@inventory+.@cart+.@storage+.@g_storage)+"ªÔé¹";
close;
OnInit:
waitingroom "ºÃÔ¡ÒÃàªç¤äÍà·Á",0;
end;
}