Detect & Delete Modded Items (Bonus Exceded)

[Mutulic 615]

Hello, community!

Script searches through the database to identify items that have exceeded the bonus limit.
 Once identified, it compiles a convenient list for your consideration.

Now, you have the power to review and manage your players inventory with ease!
This script offers you the possibility to delete items that are modded or over bonus limit.

Bonus and limits stored in JSON format, encompassing all bonuses.
Now, with just a simple modification, you can adjust the limits according to your needs.

Please give me a review 

 

This is the hidden content, please

• Sign In
• or
• Sign Up

Alternative download links → 

This is the hidden content, please

• Sign In
• or
• Sign Up

Edited February 3, 2024 by Metin2 Dev International
Core X - External 2 Internal

[Takuma 247]

Hi!

Thanks for sharing. I have a couple of questions:

• Why use a JSON file when the bonuses are already stored in the database?
• Why pull all the data from PHP and then process it?

I believe it would be more efficient (and maybe better for your learning ? if you're trying to) to try joining the item and item_attr tables to perform this processing entirely in the database. Then, you could simply retrieve the result to display it.

[Denizeri24 40]

I think this can do with mysql macro(from navicat)

[Mutulic 615]

2 hours ago, Takuma said:

Hi!

Thanks for sharing. I have a couple of questions:

• Why use a JSON file when the bonuses are already stored in the database?
• Why pull all the data from PHP and then process it?

I believe it would be more efficient (and maybe better for your learning ? if you're trying to) to try joining the item and item_attr tables to perform this processing entirely in the database. Then, you could simply retrieve the result to display it.

In mysql is not saved all bonus, a server have +100 bonus and in navicat are stored 15-20 i think

1 hour ago, Denizeri24 said:

I think this can do with mysql macro(from navicat)

yes, but dont work with all bonus, only with bonus stored in navicat

[Takuma 247]

19 hours ago, Mutulic said:

In mysql is not saved all bonus, a server have +100 bonus and in navicat are stored 15-20 i think

All available bonuses need to be in item_attr table no? If you find another bonus it's a modded item.

Unless specifically modified in the sources*

[Mutulic 615]

1 hour ago, Takuma said:

All available bonuses need to be in item_attr table no? If you find another bonus it's a modded item.

Unless specifically modified in the sources*

It is not true, there are many more bonuses in the server source that are not in item_attr and are not custom