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

Smarto · #46 03-26-2003, 12:42 PM

Your the best

Thanks for your hard work!

larry1024 · #47 03-27-2003, 03:43 AM

any one else getting errors when running the admin program?

Smarto · #48 03-27-2003, 08:28 AM

Hello there, i recently successfully updated to Telmet's and Drawde's database, but something is terribly wrong!

Most Velious and all Luclin zones have no spawns at all. My old database from Telmet did..... but that isnt compatible with drawde's new one or Telmet's 0.4.4.DR1. Can anyone help me find a way to import the Mob spawns from my old database to the new one? Thanks

cybermax · #49 03-27-2003, 09:05 AM

VERY good work!! I just LOVE the new mob aggro

Finally able to actually try to get some good pulls and similar..

I did have to use some time tho.. hehe.. This is what i did to have a very good and easy setup of the database WITH loads of spawns as well (from Telmet)

1. Backup your characters by : mysqldump.exe -t eq account character_ > charbackup.sql
2. Drop database
3. Create new database eq
4. Download 44dr1.zip, items_44dr1.zip and worlddata1.1beta5.zip (see above)
5. Download Telmet's EQEmu-0.4.3+Telmet-DB-Test.zip
6. Source db.sql, then items from items_44dr1.zip and worlddata1.1beta5 (follow instructions in readme)
7. So.. to use the spawn entries from Telmet's database, you have to add a field in spawn2 table : ALTER TABLE `Spawn2` ADD `Temp` INT DEFAULT "0" NOT NULL
Next take the "spawns.sql" file from telmet's db, and edit it. Delete everything in the file EXEPT the lines that start with :
INSERT INTO spawn2 VALUES ..
INSERT INTO lootdrop VALUES..
INSERT INTO loottable VALUES..
INSERT INTO merchantlist VALUES..
INSERT INTO npc_types VALUES..
INSERT INTO spawnentry VALUES..
INSERT INTO spawngroup VALUES..
EDIT: INSERT INTO lootdrop_entries VALUES..

The file should then contain ONLY a shitload of lines starting with the above.. (ie. no lines with "DROP..." and similar)
This will create some "duplicate entry" errors, but just let it keep going.
8. When the above is sourced, delete the "Temp" entry you made earlier by : ALTER TABLE `spawn2` DROP `Temp`
9. Import any character backup you made in point 1, and you should be GOOD TO GO!!

This is a rather "brute force" way to add Telmet's spawns database, AND use the new setup, but hopefully Drawde will complete his DB, and we all be rocking with a more complete db than this..

ADD: After a small bit of testing in the zones that were empty with Drawde's database, it seems that the "new" mobs does not have the functioning faction.. Perhaps sumtin can be done with the EQEmuAdmin tool tho.. Well..

Happy hunting!!

Memener · #50 03-27-2003, 05:01 PM

I tied installing this and in mysql.exe i tried use eq; then source reloaddb.sql and i get alot of error saying unknown colurm .
so i did this drop database eq;
then create database eq;
source db.sql (the one that came with this up date)
and then source reloaddb.sql and it dose the same thing what should i do? i played on the server and it is nice i would like to make a server like that... now i copy everthing befor i did this so i still have my old 4.3 database

any help would kick ass!

Paglioni · #51 03-28-2003, 11:38 AM

I'm missing something here...
why do some of you install Telmnet AND Drawde DB??
don't you understand that both delete the data in the tables before inserting?

Paglioni · #52 03-28-2003, 11:40 AM

I'm missing something here...
why do some of you install Telmnet AND Drawde DB??
don't you understand that both delete the data in the tables before inserting?

Trumpcard · #53 03-28-2003, 11:53 AM

His instructions tell you to delete out the 'deletes' in telmets sql...

He's just combining the 2 into a more fully populated database....

Good idea if you ask me

ghilt · #54 03-31-2003, 01:22 AM

Quote:

Originally Posted by Trumpcard

Its not a problem, don't worry about it a bit. We're just a big, happy global community around here

Except for the french...
We hate the french... Paglioni sounds Italian to me...

Why hates you french ??????

Tugurce · #55 03-31-2003, 07:13 AM

I think it's a joke...and if it isn't, I don't think it's worth caring about.

Trumpcard · #56 03-31-2003, 07:26 AM

It was.. I actually love french women...

VeoMorphine · #57 04-04-2003, 12:11 AM

Im running my server on a linux red hat(7.3) machine. Would i be able to use this database if i dont use the world.exe and zone.exe you have in the 44dr1.zip? If not can you send me the source for the linux binarys so i may compile them?

Trumpcard · #58 04-04-2003, 01:02 AM

Pull them out of the CVS code on sourceforge, they will work..
Instructions for downloading from CVS are on the sourceforge page, it's very easy for linux.

Drawde doesnt have the source, I sent him compiled binaries.

bpogue99 · #59 04-04-2003, 03:18 AM

I've been out for a while and was going to help Drawde with the quests, but looks like that got handled... I just wanted to say ... WOW! Awesome work Drawde. This update is very very nice. With the updated binaries and items database as well as the zone fixes and such... just wow.

Trakanon in Old Seb is spawning in the wrong loc though. I'll get the loc number and send you a note.

Again, awesome work!

xelnagan · #60 04-10-2003, 11:04 AM

There is... NO JPF >_< Haha... I was lookign through the database today and noticed there is no jaggedpine zone data, it's not even listed =P

- Xelnagan