p4lm0r3
02-27-2003, 08:48 PM
For you coders out there I have an application request, I have limited skils my self in Turbo Pascal (hold the laughs) lol but it's been years since I've touched a program, and I know Pascal wont be the best route for this request..
Basically, a program that would scan either the MySQL server database of your choosing, or even a database txt file dump, for Duplicate spawn types, entry's and so on, i.e. 4 of the same gaurds grouped together at the freeport west gate.
It would search npc types, spawn2, spawn entrys etc for dupelicate entries. Then display a list of each duplicate spawn located if a list box, giving you the option of what to remove..
Maybe have locs of each spawn next to the names on the list i.e. expanding trees with full list of dupes, list how many dupes exist etc and the option to delete all or X number of spawns from al aspects of the database (spawnentrys/spawn2 so on)
The basic idea of this shouldn't be tooo hard as you can create a dynamic array that populates it self with each scanned spawn entry and check each new one against itself so on..
I'm sure this would help some of us out ALOT we can combine all current spawn databases into one massive DB, compile it, and rip out any dupe ground spawns fast and easy, my current database for spawns is 23meg, and it's kinda disappointing seeing 4 -5 of the same merchant standing next to each other lol.
I've tried manually removing each dupe, and using EQadmin with the dupe spawn check box under the spawns tab, but scrolling through a few thousand lines of mobs becomes very confusing and midwracking =(
If anyone would Please help, it would help alot of us out I'm sure
You can also contact me at Palmore@hotmail.com.
Thanks for your time =)
Basically, a program that would scan either the MySQL server database of your choosing, or even a database txt file dump, for Duplicate spawn types, entry's and so on, i.e. 4 of the same gaurds grouped together at the freeport west gate.
It would search npc types, spawn2, spawn entrys etc for dupelicate entries. Then display a list of each duplicate spawn located if a list box, giving you the option of what to remove..
Maybe have locs of each spawn next to the names on the list i.e. expanding trees with full list of dupes, list how many dupes exist etc and the option to delete all or X number of spawns from al aspects of the database (spawnentrys/spawn2 so on)
The basic idea of this shouldn't be tooo hard as you can create a dynamic array that populates it self with each scanned spawn entry and check each new one against itself so on..
I'm sure this would help some of us out ALOT we can combine all current spawn databases into one massive DB, compile it, and rip out any dupe ground spawns fast and easy, my current database for spawns is 23meg, and it's kinda disappointing seeing 4 -5 of the same merchant standing next to each other lol.
I've tried manually removing each dupe, and using EQadmin with the dupe spawn check box under the spawns tab, but scrolling through a few thousand lines of mobs becomes very confusing and midwracking =(
If anyone would Please help, it would help alot of us out I'm sure
You can also contact me at Palmore@hotmail.com.
Thanks for your time =)