Fresh prince Posted January 5, 2015 Group: Members Topic Count: 69 Topics Per Day: 0.02 Content Count: 295 Reputation: 6 Joined: 10/14/12 Last Seen: June 12, 2021 Share Posted January 5, 2015 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? Quote Link to comment Share on other sites More sharing options...
1 Capuche Posted January 8, 2015 Group: Developer Topic Count: 10 Topics Per Day: 0.00 Content Count: 2407 Reputation: 616 Joined: 07/05/12 Last Seen: March 20 Share Posted January 8, 2015 Try SELECT `account_id`,COUNT( `nameid` ) AS `total` FROM `storage` GROUP BY `account_id` HAVING `total` >= 400 ORDER BY `total` DESC 1 Quote Link to comment Share on other sites More sharing options...
Emistry Posted January 6, 2015 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2369 Joined: 10/28/11 Last Seen: Yesterday at 05:32 PM Share Posted January 6, 2015 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; 1 Quote Link to comment Share on other sites More sharing options...
Fresh prince Posted January 6, 2015 Group: Members Topic Count: 69 Topics Per Day: 0.02 Content Count: 295 Reputation: 6 Joined: 10/14/12 Last Seen: June 12, 2021 Author Share Posted January 6, 2015 Thanks Master Emistry, it produced an error like this. : DB error - unknown column 'total' in 'where clause' regards Quote Link to comment Share on other sites More sharing options...
Fresh prince Posted January 9, 2015 Group: Members Topic Count: 69 Topics Per Day: 0.02 Content Count: 295 Reputation: 6 Joined: 10/14/12 Last Seen: June 12, 2021 Author Share Posted January 9, 2015 Thanks very much Sir Capuche and Emistry! Quote Link to comment Share on other sites More sharing options...
Question
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?
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.