Count Item NPC

prontera,155,181,5	script	Sample	757,{
mes "Enter item ID";
input .@item_id;
if( getitemname( .@item_id ) != "null" ){

	if( .@item_id ){
		for( set .@i,0; .@i < .sql_size; set .@i,.@i + 1 ){
			query_sql( "SELECT SUM(`amount`) FROM `"+.sql_table$[.@i]+"` WHERE `nameid`='"+.@item_id+"'",.@amount );
			query_sql( "SELECT COUNT(`card0`) FROM `"+.sql_table$[.@i]+"` WHERE `card0`='"+.@item_id+"'",.@card0 );
			query_sql( "SELECT COUNT(`card1`) FROM `"+.sql_table$[.@i]+"` WHERE `card1`='"+.@item_id+"'",.@card1 );
			query_sql( "SELECT COUNT(`card2`) FROM `"+.sql_table$[.@i]+"` WHERE `card2`='"+.@item_id+"'",.@card2 );
			query_sql( "SELECT COUNT(`card3`) FROM `"+.sql_table$[.@i]+"` WHERE `card3`='"+.@item_id+"'",.@card3 );
			set .@total,.@total + ( .@amount + .@card0 + .@card1 + .@card2 + .@card3 );
		}

		mes "Found "+.@total+" x "+getitemname( .@item_id );
	}
}else{
	mes "Invalid Item ID";
}
close;

OnInit:
setarray .sql_table$[0],"inventory","cart_inventory","guild_storage","storage","mail";
set .sql_size,getarraysize( .sql_table$ );
end;
}