[Peter]

Hello guys!

Ever had the annoying problem of having invalid items in your monmakingitem table, or your mvp table in the script DB?

Well here is a solution! This script will check for invalid item names, it will also check for duplicate item names, as well as duplicate ID's.

Download here

Configuration

sqlConfig.txt:

First Line: Hostname of SQL server
Second Line: Username for script DB
Third Line: password for script DB
Fourth Line: name of script DB

itemNameMapping.txt

This file is used to correct names from drops, I use this for importing monsters from other databases to my server, the first column (before the ->) is the original name, and the second part is the name in the database. When items are specified in here, an SQL query at the end will be displayed that will help you repair your database.

tableConfig.txt

Specify tables that have items in here, add new tables for new classes if needed, only up to advanced class is covered here by default (can be changed).

Example Output

C:\Aegis\checkItemsDb>php -q checkItemsDb.php
Duplicate Item Name detected (event) - Failure (7234)
Duplicate Item Name detected (event) - Failure (7234)
Duplicate Item Name detected (event) - Failure (7234)
Duplicate Item Name detected (event) - Failure (7234)
Duplicate Item Name detected (event) - Failure (7234)
Duplicate Item Name detected (guest) - job_karma (3134)
Invalid item name (monmakingitem) - Rotar_Zairo_Card (ROTAR_ZAIRO)
Invalid item name (mvp) - Solar_Bead (ARCHANGELING)
Invalid item name (mvp) - Solar_Bead (ARCHANGELING)
Invalid item name (mvp) - Grimtooth (DARK_LORD)
Invalid item name (mvp) - Solar_Bead (DOPPELGANGER)
Invalid item name (mvp) - Solar_Bead (DRACULA)
Invalid item name (mvp) - Two_hand_Ice (DRACULA)
Invalid item name (mvp) - Fashion_Sunglasses (EDDGA)
Invalid item name (mvp) - Two_hand_Dark (HOLLOW_PORING)
Invalid item name (mvp) - Solar_Bead (LORD_OF_DEATH)
Invalid item name (mvp) - Two_hand_Ice (LORD_OF_DEATH)
Invalid item name (mvp) - Loard_Circlet (ORC_LORD)
Invalid item name (mvp) - an_Eye_of_Dullah (OSIRIS)
Invalid item name (mvp) - Solar_Bead (SMOKING_ORC)
Invalid item name (mvp) - Solar_Bead (SMOKING_ORC)
Invalid item name (mvp) - Evangelist (TOAD)
Invalid item name (mvp) - Chef_Hat (VOCAL)
Invalid item name (mvp) - Two_hand_Fire (VOCAL)

[ADDKiD]

Sad, the links broken =(

[kevloth]

 checkItemsDb.rar (3.56K)
Number of downloads: 30