Jump to content

Utility: @AnalyzeItem count item in your server


Recommended Posts


  • Group:  Content Moderator
  • Topic Count:  55
  • Topics Per Day:  0.02
  • Content Count:  1676
  • Reputation:   702
  • Joined:  12/21/14
  • Last Seen:  

@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
  • Submitted
    06/22/2020
  • Category
  • Video
  • Content Author
    sader1992

 

  • Upvote 2
  • Love 1
  • Like 1
Link to comment
Share on other sites

  • 3 weeks later...

  • Group:  Members
  • Topic Count:  318
  • Topics Per Day:  0.07
  • Content Count:  931
  • Reputation:   13
  • Joined:  12/20/11
  • Last Seen:  

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!

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  123
  • Topics Per Day:  0.03
  • Content Count:  640
  • Reputation:   82
  • Joined:  04/07/14
  • Last Seen:  

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. ?

Link to comment
Share on other sites

  • 10 months later...

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   1
  • Joined:  12/06/17
  • Last Seen:  

Is it possible to have this converted into an actual NPC instead of a command?

Edited by Kwayzee_Wabbit
Link to comment
Share on other sites


  • Group:  Content Moderator
  • Topic Count:  55
  • Topics Per Day:  0.02
  • Content Count:  1676
  • Reputation:   702
  • Joined:  12/21/14
  • Last Seen:  

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!

Link to comment
Share on other sites

  • 5 months later...

  • Group:  Members
  • Topic Count:  63
  • Topics Per Day:  0.05
  • Content Count:  172
  • Reputation:   1
  • Joined:  11/16/20
  • Last Seen:  

On 6/22/2020 at 1:21 PM, sader1992 said:

@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
  • Submitted
    06/22/2020
  • Category
  • 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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...