prontera,155,181,5  script  Sample  757,{
 
mes "Input Item ID";
do{
    input .@itemid,0,32767;
    if( !.@itemid ) close;
}while( getitemname( .@itemid ) == "null" );
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 );
}
mes "Found "+.@total_count+" x "+getitemname( .@itemid );
close;
 
OnInit:
setarray .sql_table$,
    "auction",
    "cart_inventory",
    "guild_storage",
    "inventory",
    "mail",
    "storage";
.sql_table_size = getarraysize( .sql_table$ );
end;
}