EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Development (https://www.eqemulator.org/forums/forumdisplay.php?f=621)
-   -   adding mobs to the zones? (https://www.eqemulator.org/forums/showthread.php?t=1071)

hunlah146 04-08-2002 08:42 AM

adding mobs to the zones?
 
i have no clue as to how to ass mob's/npc's into the

would be nice to check out the mobs in st and vex thal.

any help would be greatly appriciated

hunlah146 04-08-2002 09:14 AM

wtb: edit command! :P



anywho, i was reading along and seen what i have do now now...


can soemone tell me a good site that had a db that populates zones?!

Tauben 04-08-2002 11:43 AM

Yes i need a good DB that populates zones besides Ariak's... his messes up for some reason

fiveohhh 04-08-2002 03:59 PM

How doi you get the zones populated once you get the DB? I got Ariaks DB, but can't figure out how to ge a zone to spawn, I tried to spawn kael... also is there a way to get a list of what can be spawned in a zone,? Want to spawn the sleeper and a few others, but don't feel like guessing numbers

xxxjustinxxx 04-08-2002 07:30 PM

Download Drawde's DB ~

I'm out.

j

hunlah146 04-09-2002 12:21 AM

where are all these db's u are talking about??

ibleet 04-09-2002 08:17 AM

Just use Drawde's db and the zones will be populated automatically when you start the server.

Lurker_005 04-09-2002 04:12 PM

Drawde's is in a message stuck in the top of the Development forum

Baltar 04-10-2002 06:00 AM

you can also try wc's eqadmin. it worked for 2.6, i'm not sure of 3.0 but I think it should work.

hunlah146 04-10-2002 07:17 PM

well i got Drawde's db and i think im going about wrong on installing it into the game but heres what i did, and see if anyone can spot out where i went wrong.

1) i backedup the old db.sql and deleted it from the eqemu folder and mysql folder

2) i opened sql and deleted the database "eq"

3) i put in Drawde's new db into the eqemu folder and the mysql/bin foler and opened mysql again, created a new databast named "eq" and then closed it again

4) i opened mysql.exe and typed: use eq
source db.sql
(everything went fine, no beeps throughout the process, totally smooth)

5) i opened up the server again and got this:


Using database 'eq' at localhost
Loading items & NPC's...DB Query Error
Error #1054: Unknown column 'banish' in 'field list'
Error in LoadNPCTypes query 'SELECT id, name, level, race, class, hp, gender, texture, helemtexture, size, loottable_id, merchant_id, banish, mindmg, maxdmg, npcspecialattks FROM npc_types' #1054: Unknown column 'banish' in 'field list'
done.

after all that it still connected like normal

but when i go onto my server and create a char, it beeps a couple times and just kinda freezes and have to exit


anyone see something im doing wrong?

Shortlived 04-10-2002 08:28 PM

goto http://www.shownomercy.net to get the latest DB files. I try hard to keep them as up todate as posible.

Drawde 04-10-2002 11:27 PM

It sounds like you're using a version of EQEmu earlier than 0.30, since the "banish" flag in npc_types isn't recognised.

sintor 04-11-2002 05:48 AM

Only need to add the db to mysql/bin
 
Also, you only need the db.sql file to the mysql/bin directory. And as a mater of fact after you type : source db.sql and it builds the database, you dont even need it there anymore.

Trumpcard 04-11-2002 07:17 AM

You dont even need to put it into the bin directory for that matter... I always do a

mysql eq < c:\eqemu\db.sql

instead...

sintor 04-11-2002 09:12 AM

bow
 
BOW


All times are GMT -4. The time now is 09:58 AM.

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