NPC & Loot Editor revision

[GeorgeS]

No misspelling that part should not cause a problem.

You need to DL my connection test tool, as it's a basic mysql connection tester.

Also, MyODBC Drivers were installed?
Is the MYSQL service running?


Check also with Heidisql SQl browser (free download), to eliminate other possibilities.

GeorgeS

[Akkadius]

George,

One of your tools performs a mob spawn/grid copy from one version of a zone to the next. Anyway we can incorporate that functionality to include doors/objects?

Also, anyway we can get the same information that is immediately written to the database dumped to a SQL file so it can be transferred to another database with ease instead of manual transfer?

[greed80]

Ok, yeah I did type that out so it was just spelled wrong here (oops). I ran your test connection and it did fail for mysql. I did download and install "MySQL connector/ODBC 5.1" that I found on google. I am not sure if the MySQL service is running or not though, I know nothing about about MySQL except what it lists in the guides, how do I check that?

Thanks again for the help!

[GeorgeS]

Ok, that means either mysql is bad installed, or you did not install the correct ODBC drivers. You must use these

http://www.georgestools.eqemulator.net/ODBC_DRIVERS.zip

GeorgeS

[greed80]

George,

I uninstalled the ODBC I got on google and installed yours (I originally did install yours come to find out, and upon the problem I went to the other). I still get the same thing.

Question, I did figure out one error I had on my way to work after I first posted. I Have Everquest installed on a different drive, I named "Z" so tried changing my "everquest_folder=C:\EverQuest_titanium" to Z:\Everquest_titanium. I don't think that is the issue but figured I would throw it out there.

I should note also... Prior to me reinstalling the MySQL was not running (at least, I checked in the task manager under services), it is listed in there now!

**when running your test connection I still get failed, I need to use my MySQL user name and password there right? just making sure**

[GeorgeS]

Yes the mysql user/pass is correct. I would at this point install heidisql and try to connect to you db directly. I suspect a problem with either user name or password, or a bad install of mysql..

also, to connect directly via a dos/command prompt, type in

mysql -u eq --password=eq

and see if you get in.
type exit to get out/quit

George

[greed80]

Sorry for the delay, I ended up reformating my desktop and starting over. The server set up real smooth and can log in freely, it didn't seem like I had any issues with MySQL but I'm still new with this. I get the same thing!! I did use the SoD client this time rather than the Titanium.

I still feel lost with the configs and user id and passwords.

host=localhost (This should be right, all work being done from my desktop/server)
user=eq (User and Password are both default to "eq" right? I don't make any changes to those regardless of my MySQL user or password?)
password=eq
database=peq (this refers to the main DB right? not the database folder I made on my C drive, which I labeled peqdb?)
everquest_folder=Z:\EverQuest_SoD (does this need to have the "_SoD or _titanium"? or can I leave that as just Everquest only?)
quest_folder=c:\EQEmu\quests

oh, with the new installation I did make sure and install the drivers you linked above, copied all the ".ocx" files from the resources folder over to my system32 folder, and ran the registration... all came back as suceeded, but I get the same message still!


1 more thing, I am still failing your "test connection", but then again I am not sure about the 4 entries. %

1. user name
2. password
3. DB
4. Host

It seems those should match up with the entries on the DB.ini (incidently, the DB.ini file itself doesn't need to be anywhere specific does it? I have it in the same folder it downloaded in, on my desktop.)

[Wolfling]

i will try and make this as clear as i can )

host < this is either localhost or 127.0.0.1 - tells where to find your database
user / user name < this is the user name you used when you installed mysql
password < this is the password you used when you installed mysql
database / db < this is the database where the game data is held within mysql

the other two fields in db.ini are only needed if you want to mess with spells/quests.
db.ini needs to be in same folder as the main exe's, dosn't matter where on your computer

did you install m/s networking when you reinstalled?
make sure you run ODBC_DRIVERS.zip, the one from GeorgeS's main page.
and also run the register_ocx.bat inside the resources folder.

This should allow to connect to mysql, if not, then mysql is probably not running.
Did you set mysql to autostart when windows loads?

And also have you tried what GeorgeS suggested
i.e
try to connect with heidisql or
mysql -u eq --password=eq

eq's = mysql user name & password


Wolf

[greed80]

Thanks for the reply Wolfling, I did go back and check my login's in the DB.ini. Once I changed the user to "root" and use my MySQL password it let me in! Could have sworn I did that last night but it was really late when I was trying lol. Also installed the Heidisql after you reminded me, I forgot I hadn't done this since I reinstalled and was finally able to connect!

Thanks for all the help getting this up and running everyone!

(Georges, I think you were right about the MySQL not being installed right the first time.)

[Emmeric]

Hi George...

Been having a good time with your editors; they're excellent.

Noted on the solo server package (Djerv's) that he had some Amethyst Summonings running around Everfrost. Wife didn't like it, so I went into the NPC Editor and brought up Everfrost. Clicked the Amethyst Summoners and selected Grid_Spawn_Group_Tools (Spawn Editor) and just deleted them from the zone.

Worked great.

However, noted that some goblins were missing from the igloos down in the southwest and figured I could use the tool to put some gobboes there. Clicked the existing ice goblin scout from the main table and selected Grid_Spawn_Group_Tools (Spawn Editor) again. Used Find on 30016 (an_ice_goblin_scout) and selected Everfrost_58 which gave a 100% spawn chance.

Under Spawn Locations, I clicked the [+] Row and added my /loc coordinates for the positions in and around the igloos. I repeated that 4 times for 4 new goblin spawns. Hit Save and even Save Loot on the main table.

Restarted the server: nothing in the 4 new spawn spots.

Went back into the tool and used New_Spawngroup_id button and added in one set of /loc coordinates there to test it. Hit Save and restarted the server. Nothing in the 1 new spawn spot.

I'm sure this is something stupidly simple, but what am I missing? How do I add an NPC using your tool?

[Derision]

Are you sure you got the x and y coordinates the right way round ?

/loc returns y, x, z
#loc returns x, y, z

[saarr]

did you convert the loc from in game? cause the games loc system is different then that of the emu locations, like in emu it is X,Y,Z , now the game uses Y,X,Z for some reason and has always been that way. Not sure if that is the issue you are having cause when i used the tools a few months ago the i had to switch the X and the Y to get them in the spot i wanted them in.

[Emmeric]

Oh?

Well hell. I bet I have a tone of goblins somewhere stuck on some wall.....

I used /loc. Will swap the X and Y.

[Emmeric]

Worked great, thanks!

[Emmeric]

George? Does the NPC Loot Editor support hair color changes?

I've found the texture and helm texture differences, and noted I can change the face. Figured I'd ask before opening up the individual NPC file in the DB and hunting for hair.