sader1992 Posted June 22, 2020 Group: Content Moderator Topic Count: 55 Topics Per Day: 0.01 Content Count: 1691 Reputation: 716 Joined: 12/21/14 Last Seen: 8 hours ago Share Posted June 22, 2020 View File @AnalyzeItem count item in your server @aitem this command allows you to check how many of the item in the server command @aitem2 allows you to check also who have the items @aitem is fast, but @aitem2 will take some time to finish the time depend on how big your database is! Keep in mind that this script work with sql , so if you got an item you will need to wait xtime(default 30 sec) to save in sql so you can see it with the command (or relogin or any act in the server that force you data to be saved , it's all depends on your server setting and your usage) you should wait until the command is done , do not logout/talk to npc/ anything until you get the results!'@AnalyzeItem' return the count of the item in the server. '@AnalyzeItem2' return the count of the item and the lst of who have it in the server (take more time). USAGE: @AnalyzeItem <ITEM_ID> @AnalyzeItem2 <ITEM_ID> OR @AItem <ITEM_ID> @AItem2 <ITEM_ID> Wait until you get the results in your chat to add more tables (like other storages) check the array .@tables$ and .@id$ F_GET_REAL_OWNER_NAME(<"string table">,<id>) get the name for id Submitter sader1992 Submitted 06/22/2020 Category Utilities Video Content Author sader1992 2 1 1 Quote Link to comment Share on other sites More sharing options...
darking123 Posted July 8, 2020 Group: Members Topic Count: 318 Topics Per Day: 0.07 Content Count: 931 Reputation: 13 Joined: 12/20/11 Last Seen: November 21, 2020 Share Posted July 8, 2020 Works perfectly however if you are searching a card that is compounded to an item. It will return no results. Maybe you can help improve it. Thanks! 1 Quote Link to comment Share on other sites More sharing options...
Gidz Cross Posted July 13, 2020 Group: Members Topic Count: 133 Topics Per Day: 0.03 Content Count: 682 Reputation: 89 Joined: 04/07/14 Last Seen: 3 hours ago Share Posted July 13, 2020 On 7/8/2020 at 1:35 PM, glemor123 said: Works perfectly however if you are searching a card that is compounded to an item. It will return no results. Maybe you can help improve it. Thanks! I would love this. Quote Link to comment Share on other sites More sharing options...
Kwayzee_Wabbit Posted May 27, 2021 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 11 Reputation: 1 Joined: 12/06/17 Last Seen: June 19, 2021 Share Posted May 27, 2021 (edited) Is it possible to have this converted into an actual NPC instead of a command? Edited May 27, 2021 by Kwayzee_Wabbit Quote Link to comment Share on other sites More sharing options...
sader1992 Posted May 28, 2021 Group: Content Moderator Topic Count: 55 Topics Per Day: 0.01 Content Count: 1691 Reputation: 716 Joined: 12/21/14 Last Seen: 8 hours ago Author Share Posted May 28, 2021 just to make it clear , seems like people miss-understood the command idea , this is not for normal players use , it will effect the performance of your server if every player in your server uses it! this is only for admin use! Quote Link to comment Share on other sites More sharing options...
DEsMOn Posted November 15, 2021 Group: Members Topic Count: 63 Topics Per Day: 0.04 Content Count: 172 Reputation: 1 Joined: 11/16/20 Last Seen: November 4, 2023 Share Posted November 15, 2021 On 6/22/2020 at 1:21 PM, sader1992 said: View File @AnalyzeItem count item in your server @aitem this command allows you to check how many of the item in the server command @aitem2 allows you to check also who have the items @aitem is fast, but @aitem2 will take some time to finish the time depend on how big your database is! Keep in mind that this script work with sql , so if you got an item you will need to wait xtime(default 30 sec) to save in sql so you can see it with the command (or relogin or any act in the server that force you data to be saved , it's all depends on your server setting and your usage) you should wait until the command is done , do not logout/talk to npc/ anything until you get the results!'@AnalyzeItem' return the count of the item in the server. '@AnalyzeItem2' return the count of the item and the lst of who have it in the server (take more time). USAGE: @AnalyzeItem <ITEM_ID> @AnalyzeItem2 <ITEM_ID> OR @AItem <ITEM_ID> @AItem2 <ITEM_ID> Wait until you get the results in your chat to add more tables (like other storages) check the array .@tables$ and .@id$ F_GET_REAL_OWNER_NAME(<"string table">,<id>) get the name for id Submitter sader1992 Submitted 06/22/2020 Category Utilities Video Content Author sader1992 Its working find just 1 small issue. If searching a card that is compounded to an item it will show no results. Quote Link to comment Share on other sites More sharing options...
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.