editing database files

[kouhei]

If I understand your question right you want to edit your database. Best thing to do that with is MYSQL FRONT software. There is a couple other programs out there but I use mysql front since its easier for me to use.

[GeorgeS]

Download the MySQL GUI Tools 5.0 and you're good to go. Free!


GeorgeS

[cylocke]

thanks,
I had some other program only had like a 30 day trial worked ok, but I downloaded your suggested program, took me some time to get familiar with it, but got all the first step stuff the way I wanted it
(most notably that oversight where enchanters start with Weaken rather than shallow breath like thier supposed to)

I cleared out the spawn listing for Nexus, and edited all the player choice for starting zone and routed them all to start in Nexus, step one done.

now to figure out how to create NPC's

do I create them from scratch using the GM commands or copy them outside the game using your spawn editor program.
if ingame how are they saved to the DB?
the other confusion is how to set up merchants with specific items rather than copying an existant merchant.
other question is is there a way to make starter zone NPC's invulnerable or flag the zone as NO COMBAT, so that people aren't killing off starter NPC's as safe exp.

[GeorgeS]

Ok that's alot of questions. I'll tackle a few

If you spawn NPC's in game, follow my tutorial at

http://www.wizardportal.shorturl.com/eqemu/spawning_tut/index.html


You can also use the npc editor and then spawn these using the tutorial - it's up to you. I do use my editor to create them and then spawn in game. I would modify spawns with the spawn editor as it can do things you cannot accomplish in-game.

If you don't want npc's getting attacked, then discourage attacks by making the NPC's summon and insta-kill the attacker.

You could also make a perl script that would summon 5 guards when a npc is attacked.

For creating merchants, use my editor. Create/edit/copy a NPC with my editor then change class to merchant (classid=41) then using the merchant editor,
add items to the merchant's sell list.

In the 3 zones that dissallow combat, their flag in zone table (cancombat=0)
Nexus,POK,POT. Just edit your zone field data so cancombat=0

GeorgeS