item tracker and character name

[IvanD]

does anyone have this script?

-NPC that only accessable by admin account

when clicked, it shows list of all character who has the item number 30001

ex

SERVER: 40 PCS                     (TOTAL amount of item "30001" in the server)

Kathryn02 has 10

JayR has 7

Jeff has 23

and so on

 

 

[Balfear]

1 hour ago, IvanD said:

does anyone have this script?
-NPC that only accessable by admin account
when clicked, it shows list of all character who has the item number 30001
ex

SERVER: 40 PCS                     (TOTAL amount of item "30001" in the server)
Kathryn02 has 10
JayR has 7
Jeff has 23
and so on

	.@nameid = 30001;
	.@list = query_sql("SELECT `name`, amount FROM `inventory` LEFT OUTER JOIN `char` ON `char`.char_id = `inventory`.char_id WHERE nameid = "+.@nameid, .@char_name$, .@amount);
	for( .@i = 0; .@i < .@list; .@i++ ) {
		dispbottom "[" + .@char_name$[.@i] + "] has " + getitemname(.@nameid) + " " + .@amount[.@i] + " ea.";
		.@total_amount += .@amount[.@i];
	}
	dispbottom "[Total amount of " + getitemname(.@nameid) + " " + .@total_amount + " ea.]", 0x00FFFF;
	end;	

Try this.
Script read items only from inventory table.

[IvanD]

2 hours ago, Balfear said:

	.@nameid = 30001;
	.@list = query_sql("SELECT `name`, amount FROM `inventory` LEFT OUTER JOIN `char` ON `char`.char_id = `inventory`.char_id WHERE nameid = "+.@nameid, .@char_name$, .@amount);
	for( .@i = 0; .@i < .@list; .@i++ ) {
		dispbottom "[" + .@char_name$[.@i] + "] has " + getitemname(.@nameid) + " " + .@amount[.@i] + " ea.";
		.@total_amount += .@amount[.@i];
	}
	dispbottom "[Total amount of " + getitemname(.@nameid) + " " + .@total_amount + " ea.]", 0x00FFFF;
	end;	

Try this.
Script read items only from inventory table.

thank u it worked!