EQEmulator Forums

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)

Smarto 03-26-2003 12:42 PM

I love you Drawde
 
Your the best ;)

Thanks for your hard work!

larry1024 03-27-2003 03:43 AM

admin errors
 
any one else getting errors when running the admin program?

Smarto 03-27-2003 08:28 AM

Can Someone please help me?
 
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 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 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 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 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 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 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 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 03-31-2003 07:26 AM

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

VeoMorphine 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 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 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 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


All times are GMT -4. The time now is 06:49 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.