Telmet/Drawde Combined Working Database

[Monrezz]

**DOWNLOAD INSTRUCTIONS AT BOTTOM OF POST**

This database is a combination of Drawde's and Telmets. It contains Drawdes spawns and zone points, and all of Telmets spawns / items / npc_types / loots etc etc.

It contains spawns and loots for (Pretty much) every zone. It's got every item (except new PoP ones), and pretty much every #zone command you use takes you to a safe place (No 20k drops or under the world).

I have added a few new items and a few custom spawns.
I recommend you go to The Arena and have a look around :twisted: .

Full credit goes to Drawde and Telmet for their work :o

TO USE: *NOTE* This assumes you have already got EQEmu Installed (to C:\EQEmu) and mySQL Installed (to C:\mysql)

1. Backup your old database! In a command promt type:

cd C:\Mysql\bin
mysqldump eq > OldDatabaseBackup.sql

2. Copy "Working_Database.sql" to your C:\Mysql\bin directory.

3. Go to C:\Mysql\bin and open mysql.exe. Type:

drop database eq;
create database eq;
use eq;
source Working_Database.sql

4. Wait for about 3-5 minutes while it loads all the data into your database. You should see lots of lines that look something like this:
"Query OK, 1 row affected (0.00 sec)"
- there shouldn't be any errors come up (!! :!: !!) Close mysql.exe.

5. Run FQAdmin (I recommend 4.2 - been the most stabe for me :P ).

6. Wait for it to load your database, then click on a few tabs at the top. Make sure the important ones have lots of lines in them. (Especially: Items, NPC's, Spawns, Loot, Variables, Zones, Zonepoints.) If you don't see anything make sure you have set it up to look in your database. Click on "Preferences" on the bottom and make sure everything there is pointing to your database.

7. Go back into your C:\mysql\bin directory and run mysql.exe again. Type in:

use eq
INSERT INTO account SET name='eqemu', password='eqemu', status=200;
GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';

Change the first 'eqemu' to what you want the account name to be, and the second one to say what password you want.

10. Close all the open prompts and directories and everything. Go into C:\EQEmu and run MiniLogin.exe, World.exe, Boot5Zones.bat...

11. Log into your server!

*DOWNLOAD INSTRUCTIONS*
Sorry this is a little more complicated then it should be. I had to get a 35Mb file down to 3Mbs!
Step 1 - Download the files:

Working_Database1.zip
Working_Database2.zip
Working_Database3.zip

Step 2 - *Important* Rename the extension of Working_Database1.zip to .exe (i.e. "Working_Database1.exe")

Step 3 - *Important* Rename the extension of Working_Database2.zip to .CAB (i.e. "Working_Database2.CAB")

Step 4 - *Important* Rename the extension of Working_Database3.zip to .CAB (i.e. "Working_Database3.CAB")

Step 5 - Double Click on Working_Database1.exe. A command prompt should pop up, then disapear. Hopefully you'll have a 3Mb zip file called Working_Database.zip on your desktop now.

Step 4 - Use WinZip to extract Working_Database.zip to your desktop.

Step 5 - Copy Working_Database.sql to your C:\mysql\bin directory.

[Shando]

Very nice work :wink: Thanks

[devlor]

Great monrezz! :) I'm sure this'll help a lot of people.

One thing though: when I inserted Telmet's spawns into Drawde's, I got a ton of duplicate NPCs everywhere. It got to be pretty frustrating to have to pixel-hunt between two or more stacked NPCs to access the one I wanted, so I just went back to using one of the two databases. Does your DB have the same problem, or was correcting this one of the improvements you made?

[Garrfish]

It looks like the npc's won't attack and factions all show dubious. I will dump database and source it again to check and see if I did something wrong on this end.
Following your instructions the first install worked without a problem, and no errors were encountered. Very nice job..Well Done!!

[_OZZY_]

Which set of quests should I use from here for this database?

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

I want to make sure that I use the right one.

Thanks.

[Bigpull]

Quests are tied to npc_types so you'd want the telmet version of quests.

7. Go back into your C:\mysql\bin directory and run mysql.exe again. Type in:

use eq
INSERT INTO account SET name='eqemu', password='eqemu', status=200;
GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';

Change the first 'eqemu' to what you want the account name to be, and the second one to say what password you want.

8. Open another command prompt and type in:

cd C:\EQEmu\
world.exe flag eqemu 200

This is redundant, you've already set the account status in the INSERT

[Bigpull]

Also, this looks more like telmets spawn2's than drawde's, the lowlevel mobs are missing.
The merchant tables or atleast the assignment in npc_types are also Telmets. Did you actualy combine these or just source one over the other?

[Trumpcard]

Yep, I tested it out and noticed that mobs were misssing from qeynos2, and a few other low end zones.

Drawdes is a better solution still for good legit playing/testing..

[Monrezz]

Thanks for the feedback! :D

This database has about 3 or 4 duplicates that I've found...simply use the command #npcspawn delete and then when you reload your server it will have got rid of it. Simple to remove :)

I don't think that faction works right in this. Pretty much all mobs are dubious and none will attack, even if you attack their friends :( Must have used Telmets factions....

_OZZY_ - I believe you use Telmets quests.

Bigpull - Thanks, updating that now :) I combined a bits from both. My first try at combining though so I could have messed thing up. I noticed in Drawde's Oasis had about 5 named SG's - Hiritiz, Firitz, Feritz - names like that. I used telmets for most spawns, then combined a few of Drawdes using a post on forums ( I think I did it right...)

Trump -
It contains spawns and loots for (Pretty much) every zone

:o

[Trumpcard]

Its a great idea, dont get me wrong, I think though you should use Drawde's for a base, and apply Telmets on top of that as opposed to the other way around. As Drawde's is hand created/editted, it tends to be more complete. Telmets has a multitude of other zones, but tends to be alot more buggy...

Try it the other way around using Drawdes as the base, then overlaying Telmets, and I bet it will be more complete and playable..

[Monrezz]

Drawde's zonelines and zone-in points are great, Telmets are a little ermm....*off* (no offence :)). I think every loves Drawde's work, but would like to see a few more spawns. Thats why I used Telmets as a base, so I wouldn't get as many duplicates :D .

Once Drawde has spawns in all the zones (or at least loads :wink: ) I think everyone will use Drawde's, because of the fact that it has a more *EQLive* feel to it....Maybe if Drawde and Telmet worked on it together we could see some great artwork piece together :o

Few reasons why people use <Drawde | Telmet> databse:
(found in posts on forum! :wink: )

Drawde's:
Hand-made (so very few bugs)
Merchants (with items)
Working faction and agro (Yey!)
Few spawns in low level zones (EQLive legit feel)

Telmet's:
Spawns and loot in near every zone (Yey!)

[DEXTER78]

im running telmet's DB on my server (Dexter's EQ Server) with many edits made by me. Mobs aggro, some factions work, quests added(including cleric epic!), loots fixed, zones fixed, custom mobs(bot in nexus), casting mobs, and a few other "twinks". ive looked into Drawde's and i like it alot. but like someone else posted, i use telmets cuase of the spawns. give my server a try let me know what you think.. im waiting for telmet to update his DB.. if he dont i will post mine.. which is his with twinks.

[freakydeekey]

i play on dexters server, his spawn agro is awsome, and custom jobs rock. i cannot wait for him to post his database!

[morpheus014]

Will the npc spell info included in Telmets/dwarde's DB work with this database or are the id's different?

[Ethereal]

No Download links for that DB in this post :(

[Monrezz]

Hmmmm it seems the links have been removed. Probably because the server went down....?

Will post a new one as soon as I get it done :(

[Crey]

Hey guys. Thought I'd offer some quick feedback on the DB. You've got a ton of stuff set up, and that's really cool.

I did notice that all the hillgiants in Rathe Mountains seem to be corrupted hill giants and there are multiple brother z's all around the hill top. I also saw two avatar of wars around outside the arena.

Another thing is the aggro radius of 85 doesn't work for all zones. For example, I tried battling some gnolls at the entrance of BB and I had elite gnoll guards aggro me from beneigh floor. Also, I attacked a death beetle in the Unrest Courtyard and had basement mobs aggro me and come up through the ground. The ghost even showed up.

It's a really cool DB. I'm not sure if you're looking for feedback, but just thought I'd mention what I noticed. I look forward to trying your future releases.

[Monrezz]

Few zones are messed up a lil =/

I think agro of 85 is from Drawde's....?

Just #npcspawn delete any duplicates you find.

Theres meant to be 2 AoW =)

[Crey]

Wow. Two AoW? Party on!

[Edgar1898]

Just #npcspawn delete any duplicates you find.

heh, I think your wanting the #npcspawn remove command in this case. unless you really want to completely delete the target npc from the npc_types table.

[killspree]

Theres meant to be 2 AoW =)

No there isn't. :P

[Monrezz]

There is in the arena, they custom =P

Lol

[eq-chris]

Is there an updated list of commands? #npcspawn isn't in the readme file.

[haywards6]

Does anyone have a link for this whole DB the three files wont change type for me, XP still thinks they are zip files and wont act right

[Monrezz]

I'm using Windows Xp too,

Open a folder (My Documents for example), click:

Tools --> Folder Options...

Click on the "View" tab.

There will be a box labled:

Hide Extensions for Known File Types.

Uncheck it, then you'll see the *.* extensions.

[haywards6]

Excellant I will try that when I get off work. I cant wait to see how it works, I am a bit unhappy with my curent database,

[loudent2]

followed the instructions on the first post and it appears to have populated my world. However there are 2 problems that I'm not sure the cause of:

1) Everything cons dubious. I popped around to a number of zones to check it out and nothing aggored on me.

2) Zoning from one zone to another normally(not using the #zone command) had a tendency to zone me way high up which resulted in me falling to my death just about every time.


Any Ideas?

Thanks.

[vetoeq]

1) Everything cons dubious. I popped around to a number of zones to check it out and nothing aggored on me.

You are probably a GM, hence the dubious. I'm not sure if you can #gm off or not.

--
VetoEQ

[loudent2]

1) Everything cons dubious. I popped around to a number of zones to check it out and nothing aggored on me.

You are probably a GM, hence the dubious. I'm not sure if you can #gm off or not.

--
VetoEQ

I thought that might be it but had another player on and everything conned dubious to him as well. Although he only checked out the newbie zones.

[Makem]

I'd love to try this but for some reason the ZIP files I'm downloading are corrupt or invalid. Any suggestions?

[Makem]

Nevermind, I just read the post.....sorry :-)

/em slaps himself

[Mortenson721]

DO you have the link for FQAdmin's latest version? I'm useing the EQEMU Admin utility and I get tons of error messages trying to open up the DB,

When I try and edit an NPC it says

Unknown Colum 'npc id' in 'where clause'


Not sure what to do there, Maybe someone could help me fix that...

King Mortenson
SySop of RAID ADDICTS ANON (Semi Legit)

[haywards6]

I absolutly love this combination, I had some trouble in a couple dungeons with bath zone points when zoning and fixed them and also a few duplicate spawns. but all and all this is excellant work. I still have no agro oocuring and with my Ogre Warrior that I have legit leveled to level 9 most stuff cons amiable to him, even skelletons in Befallen. I am very happy that I was able to actualy make my server legit but I see having no working faction a big problem.
I would love to know what you have done to make it work on your servers. Thankyou

[tcsmyworld]

the npcs in the telmets portion of the combo DB don't have any npc faction info , so they won't aggro.
the npcs from the Drawdes portion of the DB have the npc faction info , but you need the correct EXE's for them to work.
the EXE's in this post work to get the aggro working for Drawdes npcs.

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

[haywards6]

Ok, that didn't work. It looks like I allready had the files I needed, since they were the same time and date modified and the same size. I switched them anyways and still no agro, allmost everything I run into is amiable or dubious and nothing is below that unless I am beating it bloddy with my axe :)

[tcsmyworld]

check the npc faction, sounds like there are none, or they don't match up to the npcs.
if you over-wrote Drawdes files with telmets , it may have corrupted or removed the npc faction.

[haywards6]

I never changed anything, I used the procedure this post was opened with, I take the 3 files and create the zip file and unzip it. I am then left with one .sql file that I source to an emptie database and this gives me a complete database. At this point I have gone in and changed a couple spawn points and such but nothing more, no factions work but the rest of this database id absolutly outstanding.

[Sandabus]

What version is this database for? I could very well be blind
but I looked and couldn't find which version of EQEMu it was
intended for.
I've tried using it with 0.4.3 which I've managed to compile on my
Linux box and it gave errors and crashed my world server.
I have yet to manage to successfully get any add on database
to work with my server.... anyone know of a good one that
is compatible with my version? (I haven't managed to get 0.4.4DR
to compile yet).
From what I've seen most of these database releases don't seem
to list the version they are for (Which is confusing me to no end
with some of them talking about not being compatible with this release or that release).
Any suggestions/help would be appreciated.

Sandabus - Da Ganomie Archon

[nono]

I use your great compiled Database, but I have one problem ..
The AA attribution won't works :(
Please help

[fnemo]

The AAs bug with the binaries. It's not a DB problem.

[nono]

How can I do for resolve this big ?? please :)

[fnemo]

read the code and find out what need improve and (re)code that part.

[a_Guest03]

AAs need a lot of work, but you need a lot of other parts of the code cleaned up before AAs will all work correctly.