Utility: @AnalyzeItem count item in your server

[sader1992]

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 [email protected]$ and [email protected]$
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

 

[darking123]

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!

[Gidz Cross]

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.

[Kwayzee_Wabbit]

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

Edited May 27, 2021 by Kwayzee_Wabbit

[sader1992]

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!

[DEsMOn]

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 [email protected]$ and [email protected]$
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.