GeorgeS Database tools updated

[GeorgeS]

Also, updated the source for my tools - this inlcudes everything except vb6 to run them.

GeorgeS

[TheLieka]

I just want to throw out some kudos to you man. I set up my server a few weeks ago, and (like many silent others, I'm sure) these things have been a lifesaver for me.

Thanks for all you do for the community; we really do appreciate it (even if we are quiet at times).

Dax

[GeorgeS]

I have updated many of the tools already. I'm in blitz mode and programing like crazy today. Must be the wine...

about the Quest Editor
Anyway, I did forget - someone asked how to rename a quest they added as a template. You simply hit the spacebar and type in the new name.
The new version has this shown below the button.

GeorgeS

[ChaosSlayer]

oh George, do you plan on revisiting your Tradeskill Editor?
I belive its long due for an update =)

overall it is tremendosly slow (well perhaps thsi due to sheer number of recepies...) also the clicking back and forth bitween 2 views (recepie list and detaisl) kind of bad (IMHO).
Perhaps the entire thing coudl be placed on a single window screen: list of recepies on the left and recepie editing details on the right.

can't think of anything else right now (must admit I don't use it very often since I haven't realy gotten to TS part on my custom world project)

[GeorgeS]

I'll look into this and see what can be improved. I realized it's slow as hell when loading again and again. This can be fixed.

Removing the tabs so it works on one page may be a great idea...

I'll let you know how it goes.


GeorgeS

[trevius]

GeorgeS,

As I have said before, all of your tools are amazing. The NPC loot editor is awesome for multiple purposes.

There is something that has me puzzled about editing certain NPCs. The NPCs I am wondering about are NPCs that are spawned through a quest event. Since the NPC isn't actually listed for any particular zone (as far as I know), they don't appear to show up in the list.

One example is the Tower of Frozen Shadows. There are quests set in place for the key droppers and certain named to spawn that aren't in the NPC database for that zone. I am not exactly sure where they are unless they are just out there not assigned to any zone. This is much more apparent in potimeb. In potimeb, there is only 1 spawn in the database table, and it is a trigger spawn. Because Potimeb is a series of events, there are no real static spawns, they are all triggered. I am wondering if there is a way to list all triggered spawns for a zone, or even all spawns that aren't set to any specific zone that might be used for events such as these.

Maybe there is a way to set the mobs that aren't in the spawn table in any zone to be changed so they are actual normal spawns in the zone they are supposed to be for. Even if that change is a manual one.

As is, I am planning to completely respawn all of potimeb myself and set it up so it doesn't use triggers at all. It will be a fair amount of work to get it halfway decent, but if there was an option to move in the spawns that already exist, but aren't in that zones' database, it would really quicken things up.

Thanks in advance for any insight you may have on this. If you have any questions, or need more specific examples let me know. An easy way to see this is to pull up potimeb in your npc loot editor, and then look at that zone in your quest editor as well. You will see the spawn trigger has a large series of events assigned to it. Although as far as I can tell, it is only complete up to the end of phase 1 (I don't see phase 2-5).

[ChaosSlayer]

there are 2 easy ways to edit such npcs:
a) add them to any spawn group in the same zone with 0% chance to spawn, then they will pop up in Georges npc editor
b) edit them directly in mySQl browser