Demo:

Code: [Select]

Updated V1:
Structure changed, scanning speed 3 times faster, using CPU resources 2 times less.
Can be used for the whole ZTeam database (will say "Invalid object name", but still work normally).
Removed Warehouse, ExtendedWarehouse, GuildWarehouse, Character Tabs.
The program will automatically create TXT files with the same folder corresponding to the above tabs and save the report there.
Add a clock to count the scan execution time for you to experience the speed for yourself.

Update V2:
Minimize connections and change the method of reading/processing data from SQL.
New item analysis structure.
New form selection analysis structure.
Fixed timeout and delay for too large database.
More performance, more accuracy.
Scan speed: ~150000 items / 1.1 seconds.
Special thanks to ThangVTV3 to test this version.

1> User manual:
1. Database configuration item fill in your database information
2. Section Scan by feature tick the features you want to find:
Check = Filter those properties (for example, check Option 4: the program will only find items with Option 4).
Don't check = don't filter that feature (eg, don't check Type/ID: program will find all items).

3. Checkbox Delete item:
Check = Find and delete automatically.
No check = Just find and report results.

4. Results after scanning will be saved to TXT files in the same folder (Warehouse, ExtendedWarehouse...).
5. Install .NET to run, at least .NET Framework 4 Client Profile.
6. Backup DB before deleting item, should delete during maintenance to ensure thorough deletion.
7. Code for DB Titanstech v11 and above (Item binary 16 bytes = 32 characters, ie versions with item socket function).
8. Works great on SQL 2000, 2005 and 2008. Higher SQL versions have not been tested.
9. Run as Administrator to ensure the report is fully logged.

Download:


Credits: hieunova

  Đm con mồn lèo này, share share cc

Work for all files and DB?

The highest level of scanned items only shows 7 or the options also have this problem.