PDA

View Full Version : adding mobs to the zones?


hunlah146
04-08-2002, 08:42 AM
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
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