EQEmulator Forums - 4.3/4.4dr1 compatible DB addon (1.1 beta 5)

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)

- - 4.3/4.4dr1 compatible DB addon (1.1 beta 5) - finally! (https://www.eqemulator.org/forums/showthread.php?t=6160)

4.3/4.4dr1 compatible DB addon (1.1 beta 5) - finally!

(edited to fix URLs and add items link)
http://www.edwardpinniger.bctalk.net...ta1.1beta5.zip
This version requires the 4.4dr1 binaries which you can download from http://www.edwardpinniger.bctalk.net/eq/44dr1.zip
(the zip includes an up-to-date db.sql)
also an updated items DB - http://www.edwardpinniger.bctalk.net/eq/itemsbooks.zip (edit: added books to zip file)
It'll probably work OK with 4.3 but tradeskills definitely won't work, as
the tradeskill table structure has been changed in 4.4, and new characters won't have any starting items.

Improvements in this version:
Compatible with 4.3 (new faction structure, NPC spell lists etc)
Fixed + added spawns for all Kunark outdoor zones
Working zonepoints and safepoints for most Norrath zones (no Luclin or PoP ATM)
More loot tables
More tradeskill recipes, including many created by Lurker_005 - all fletching and jewelcraft recipes, and most alchemy ones.
Merchants in Cabilis (and other Kunark zones) are now assigned the correct lists
Visible equipment for NPCs, guildmasters etc. (incomplete)
Included Lurker's up-to-date starting_items data (until I get round to creating my own)

Hopefully, the next version will be 1.1 final and will be as finished as possible - it should
include proper spawn locs and itemisation for most old-world and Kunark dungeons, finished tradeskills
(apart from PoP recipes), loot tables for all basic creature types, and finished merchant lists for tradeskill and
spell vendors. Also hopefully a full faction list, and the ability to raise factions by killing orcs and similar creaures.
So it might take me a while to finish, it'll be "done when it's done".
However if a future version of EQEmu "breaks" this DB addon version by changing the DB table structs, before I finish the
final version, I'll release another beta compatible with the new EQEmu version.

Let me be the first to say thank you ; )

Gonna check it out and give you some feedback later this evening.

Greetz DazL

wow this is indeed excellent! I will try this out as well tonite.

As a pre-caution to dissaster, what is the best recommended way to back up everything before attempting to source in new db's?

Id like to make sure all the accounts/characters of players are safe etc before doing this. Is there a sure-safe methode in mysql to save this information?

thx again for all the hard work!

Great work Drawde! I'll check this out ASAP.

BTW, you got your slashes mixed up in the links you gave above. ;) The corrected (clickable) links are:

http://www.edwardpinniger.bctalk.net...ta1.1beta5.zip
http://www.edwardpinniger.bctalk.net/eq/44dr1.zip

dangerdan30: To back up/restore your old database, do the following:

Code:

Go to the mysql\bin directory from a command prompt window. 



Type mysqldump &lt;put your database name here> > somefilenameyoulike.SQL 



Example. If my database was named eq and the file I wanted it put in was eqbackup.sql - I would type: 



mysqldump eq > eqbackup.sql 



(note:check the file and make sure the contents are there and not some error text). 



To restore it, you would go into a mysql prompt. 

Drop your existing database with: drop database &lt;yourdatabasename>; 



Create the database again: create database &lt;yourdatabasename>; 



and then source the database with your file... 

use &lt;yourdatabasename>; 

source &lt;path to somenameyoulike.sql>somenameyoulike.sql

great! thanks alot for explaining how to make a back up of the files. Yes, my database is just named: eq

so by following your steps, this should go fine.

thanks again

Awesome job Drawde..

There are a couple of problems in faction_list and loot tables though.

use a mysql -f eq < Reload to source the database in, and it will move on other the bugs (dupe primary keys for the most part).

Hmm, the backup down't work for me.

My database name is: eq

So I type in "mysqldump eq > eqbackup.sql" (no "'s)...but then I get a new line with a "-->"

Then no commands work. (exit, use eq etc....)

And I have to exit...help please!

monrezz: Are you trying to run the command from mysql.exe? If so, there's your problem. As stated...

Quote:

Go to the mysql\bin directory from a command prompt window.

Type mysqldump eq > eqbackup.sql

Don't start up mysql.exe. This uses a different command file (mysqldump.exe).

Oh yes - thank you very much! Didn't notice that :)

I am getting a ton of errors

Error 1136: Column count does not match value count at row 1.

This is when I am reloading over telmets database.

Same happening to me :(

Perhaps you should take to telmet... He is the one that made his database after all...

My guess is you havent updated your db.sql in awhile. I'd completely drop my database and source the db.sql, then load in drawdes addon. (you will still need an items addon).

A very newbie question, what are the steps to updating/loading the worlddata1.1beata5.zip files.

What happened to the items? there's no items.sql (or .txt) file in the database zip. Tried to source in someone elses but just got a bunch of errors

Heyas,

I like what Ive seen so far;) Gonna see some more tomorrow. Great job !

I had a problem sourcing in telmets items.sql.
Ik keep getting the following error. Tried telmets items.sql.

1136 Collum count doesnt match...at row one.

Anyone got any advise?

Greetz DazL