prontera,155,181,5 script Sample 757,{
do{
for( .@i = 0; .@i < .sql_table_size; .@i++ ){
query_sql( "SELECT COUNT( `nameid` ) FROM `"+.
sql_table$
[.@i
]+"` WHERE `nameid` = "+.@itemid,.@count
);
query_sql( "SELECT COUNT( `nameid` ) FROM `"+.
sql_table$
[.@i
]+"` WHERE `card0` = "+.@itemid,.@count1
);
query_sql( "SELECT COUNT( `nameid` ) FROM `"+.
sql_table$
[.@i
]+"` WHERE `card1` = "+.@itemid,.@count2
);
query_sql( "SELECT COUNT( `nameid` ) FROM `"+.
sql_table$
[.@i
]+"` WHERE `card2` = "+.@itemid,.@count3
);
query_sql( "SELECT COUNT( `nameid` ) FROM `"+.
sql_table$
[.@i
]+"` WHERE `card3` = "+.@itemid,.@count4
);
.@total_count += ( .@count + .@count1 + .@count2 + .@count3 + .@count4 );
}
OnInit:
"auction",
"cart_inventory",
"guild_storage",
"inventory",
"mail",
"storage";
}