Storage npc

[Fresh prince]

Hello rathena,

Requesting a npc that will tell you the account ids that has 400+ items on their storage.

Example is when you click a npc, it will say

Users:

10000

13000

13669

14778

16876

Has more than 400 items on their storage.

Thanks!!

This is for only a game master's use ofcourse. Thanks you!

Little help here please?

[Capuche]

Try

SELECT `account_id`,COUNT( `nameid` ) AS `total` FROM `storage` GROUP BY `account_id` HAVING `total` >= 400 ORDER BY `total` DESC

[Emistry]

try

query_sql( "SELECT `account_id`,COUNT( `nameid` ) AS `total` FROM `storage` WHERE `total` >= 400 GROUP BY `account_id` ORDER BY `total` DESC",.@aid,.@total );
.@aid_size = getarraysize( .@aid );
for ( .@i = 0; .@i < .@aid_size; .@i++ ) 
	mes .@aid[.@i]+" - "+.@total[.@i]+" items";
close;

[Fresh prince]

Thanks Master Emistry,

 

it produced an error like this.

 

: DB error - unknown column 'total' in 'where clause'

 

regards

[Fresh prince]

Thanks very much Sir Capuche and Emistry!