Congrats Drawde on getting your DB updated and released.

To people having having trouble loading the DB, go back and re-read Drawde's instructions and follow them. Also take a little time and read the mySQL documentation. Look up the error and fix it. Then send Drawde a polite message with the problem, file and line it is on, nad it's solution. He can then fix it for everyone for the next release. And don't bother him with the dupe tradeskill lines that are intentional.

For those complaining, go spend a year making your own DB and show us just how easy it is. :twisted:

Thanks for mentioning those bugs anyway, I've fixed some of them now.
However this DB addon is a beta and so isn't 100% complete or error free, plus it's very easy for errors to creep in in hand-typed data like the merchant lists and loot (the NPC and faction data is auto-generated, but even that can have errors when there are typos in the source file.

so, if you want i can help you... i'll find those errors and i'll report to you... then you can fix them in the way you want ( i noticed that some dupe key are really mistyped numbers, and in this case i'll send you the file already patched).

The only thing i need is your updated db, because we don't have a CVS for it, and i don't wont to fix errors you already fixed, or lose your recent changes :)

you can send it in my email (info@darkangel.net) or via icq 104459
i'll test it as quick as possible.

Hi, i run a server (Dexter's EQ Server) and i use other people's DB's and edit them a small amount. the small edits i do are very complicated.. i couldent imagine starting one from scratch. I consider Drawde and Telmet as gods for doing this. I am currently using Telmet's DB, which i have edited to make mobs attack, and cast, also added in some loot to some named mods(doomshade, rumblecrush, ect.) i have tested Drawde's DB and it is great! only reason im still using telmets as it has most the mobs in ALL zones. But i cant wait till drawde's is done, im looking forward to quests and easyer tradeskills and other things he has implanted. KEEP UP THE GOOD WORK GUYS!!

I love you Drawde
 

Your the best ;)

Thanks for your hard work!

I love you Drawde
 

Your the best ;)

Thanks for your hard work!

admin errors
 

any one else getting errors when running the admin program?

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

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!! :)

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!

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?

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?

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

Why hates you french ??????

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

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

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?

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.

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!

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

Items with 1.1b5
 

I've been playing around with this DB and tcsmyworld's moving mob's DB. I've noticed that some of the items (mostly high-end) do not function properly and cannot be summoned.

I tried fixing them in the DB, but my skills there are severely lacking currently.

I first tried sourcing the items.sql from 4.1 and got a ton of 1136's, so that was a no-go.

However, I did find that using the ItemEditor and exporting SQL from the 4.1DB and then sourcing them into the 1.1b5 DB makes them work.

I'd love to help you guys out by updating the items to be more full-featured but I'm not sure what's entailed. (outside of exporting every item and then sourcing it back into your DB)

Thoughts?

PS. A particular item to see that is broken in this and tcsmyworld's DB (based on Drawde's): item 30385: Ring of Dain Frostreaver IV. It shows up in eqemu-admin, but cannot be summoned/searched.

--
Veto

error when doing soure reloaddb.sql
 

I followed the instructions, When I do source reloaddb.sql
it runs good forawhile, then the error starts.
First I get
ERROR 1054: Unknown column 'deityid' in 'field list'
then
the mass errors start...
ERROR 1136: Column count doesn't match value count at row 1


It does these until i can't stand the computer beeping :(

Any suggestions?

Problems, please help if you can
 

I installed both sets of files and while I have all the NPC's now I dont have any items at all. None on merchants or mobs or that can be summoned by the GM(Me) even

Download the items from here
http://edwardpinniger.bctalk.net/eq/itemsbooks.zip

Cant someone just post a working version of of the files and items all zipped and nicely put together than all this edit file, take out these lines, parse this edit that delete this. Just a working version. First to do it should get all the praise!!!

Files

eqemu version ???
worlddata version ???
db.sql

plus any other files...

:lol: Just a lil love

-Zear

I will even host the files for everyone. Just email me at miritek@10oh.com

-Zear

try this....
 

the DB and exe's in the reply to this post are one zip for DB and the matching working exe's for it.

http://forums.eqemu.net/viewtopic.php?t=6717

Velious and Luclin mobs?
 

Does this DB have Velious and Luclin mobs in it, and if not does the telmet version? What are the differences in the two DBs, basically?

*edit* actually read the thread :oops: I am going to attempt to combine the telmet and drawde DBs

This is a great project, and I would like to thank everyone involved for thier time and hard work. After a few hours of toying with it, I got a local LAN server up with very little problems, except a good working DB. The one I am using has no mob pathing, and no Velious or Luclin mobs.

Thanks again! :)