Jump to content

Recommended Posts

Posted

@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
  • 3 weeks later...
Posted
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. ?

  • 10 months later...
Posted

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!

  • 5 months later...
Posted
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.

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.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...