EQEmulator Forums - EQEmu 0.4.1 Database addon

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::News (https://www.eqemulator.org/forums/forumdisplay.php?f=615)

- - EQEmu 0.4.1 Database addon (https://www.eqemulator.org/forums/showthread.php?t=4887)

EQEmu 0.4.1 Database addon

This is the 4.1 Database addon for 4.1 servers...
Read the readme included on how to use.. if you've used the previous Addons please remove it and use this one...

This release has cut down duped spawns.. added updated magelo item data.. and doors ... and zone points..

EQEmu-0.4.1-DB-Addon.zip

gj kh0ng.

Edit:
Still some... ALOT of dupe spawns.

Lolz, sorry.. didn't know you liked your banana so much.

bitch thats my banana

Does the new database support wandering monsters? I mean will the monsters be wandering or pathing in the game now?

Just out of interest, has anyone tried this with 0.4.2-DR1 from Telmets website?

-Auldar

I havn't tried to do wanders yet, that may be quite a while before I try to tackle it.

I am not aware of any database changes in 4.2... but I really havn't checked into it either. It should work, give it a try.

I'm getting lots of errors on loading the npc_types table from spawns.sql.

It seems that there is an extra "1" prior to HP bring defined, which is taking the place of the HP field and pushing all other columns out by 1, and therefore causing errors due to having 1 extra field.

Looking at the db.sql from both 0.4.1, and Telmet's 0.4.2-DR1 distribution, shows no extra field defined prior to HP, so I'm not sure what this extra "1" is meant to be.

Any ideas? I'd rather not have to manually delete that 1 for every spawn entry..

-Auldar

Just to clarify..

Here's a row from Telmet's spawns.sql that defines an NPC:

npc_types (id, name, level, race, class, hp, gender, texture, helmtexture, size, loottable_id, merchant_id, face, walkspeed, runspeed)

VALUES (2247,'a_clockwork_alchemist',40,88,32,3776,0,0,0, 3,4,2247,-1,0.67,1.25);

In many other DB's, I'm seeing an extra "1" inserted between what should be (according to the db.sql's I have anyway), class and HP. So instead of looking like the above, it looks like this:

npc_types (id, name, level, race, class, ?, hp, gender, texture, helmtexture, size, loottable_id, merchant_id, face, walkspeed, runspeed)

VALUES (2247,'a_clockwork_alchemist',40,88,32,1,3776,0,0, 0,3,4,2247,-1,0.67,1.25);

I put in the ?, since I don't know what it's meant to be. Seems I don't have the same db.sql you guys are working off.'

Guess I'll keep looking for it..

-Auldar

Found db.sql on cvs

Ok, so I found the latest db.sql on the cvs nightly dump that fnemo, linked to on another thread in this forum.

Looks like Body has been inserted between Class and HP.

After copy/pasting the definition of npc_types into my db.sql, then commenting out the resist definitions, I was able to load the DB :)

Now to test it :)

-Auldar

Wondering npc's are easy to add
there is a forum on this but ill try to make a simple explenation on all of this

frist you need to make a grid the slantax for it is

#grid add gridnum wondertype pausetype

for pause and wondertype i ususaly just use 2 which is random
so to make your first grid you would type

#grid add 1 2 2

next click on the npc you want to add the grid to then type

#Gassign 1

the 1 is the number of the grid
next you need to add some waypoints
the slantax for adding waypoints is

#wp add gridnum pauselenth wpnum

so to add your first wp you would type

#wp add 1 15 1

the next wp would look like this

#wp add 1 15 2

you can change the pause type also

hope this helps some of you i know the other forum says to repop the zone but sometimes that does somthing to my database so i reccomend zoning out and then zoning back in make sure you dont assign 2 mobs the the same grid this will cause zone to crash

I found it added so much realism to the game when NPC's responded to your Hails in Drawde's Database.

How hard would it be to incorporate Drawde's quests with this DB?

Is it just a matter of remapping all the npc IDs in the quests? If so, how would I go about it? Is there a downloadable quest editor?

-Auldar

Quote:

Originally Posted by Auldar

I'm having the same exact problem as Auldar. Could someone explain to me in moron terms :? what i need to do to fix this? Thanks in advance. - Zabon :)

The problem I had was that the data I was trying to load into the database had one extra entry in each row that the table was not expecting. That entry was "bodytype". The db.sql that comes with 0.4.1 does NOT contain the correct formatting for that table.

In order to correct it, you need to replace the npc_types structure in your db.sql with the following:

Code:

--

-- Table structure for table 'npc_types'

--



CREATE TABLE npc_types (

  id int(11) NOT NULL auto_increment,

  name text NOT NULL,

  level tinyint(2) unsigned NOT NULL default '0',

  race smallint(5) unsigned NOT NULL default '0',

  class tinyint(2) unsigned NOT NULL default '0',

  bodytype int(11),

  hp int(11) NOT NULL default '0',

  gender tinyint(2) unsigned NOT NULL default '0',

  texture tinyint(2) unsigned NOT NULL default '0',

  helmtexture tinyint(2) unsigned NOT NULL default '0',

  size float NOT NULL default '0',

  hp_regen_rate int(11) unsigned NOT NULL default '0',

  mana_regen_rate int(11) unsigned NOT NULL default '0',

  loottable_id int(11) unsigned NOT NULL default '0',

  merchant_id int(11) unsigned NOT NULL default '0',

  mindmg int(10) unsigned NOT NULL default '0',

  maxdmg int(10) unsigned NOT NULL default '0',

  usedspells varchar(70) NOT NULL default '',

  npcspecialattks varchar(36) NOT NULL default '',

  banish int(10) unsigned NOT NULL default '0',

  aggroradius int(10) unsigned NOT NULL default '0',

  social int(10) unsigned NOT NULL default '0',

  face int(10) unsigned NOT NULL default '1',

  luclin_hairstyle int(10) unsigned NOT NULL default '1',

  luclin_haircolor int(10) unsigned NOT NULL default '1',

  luclin_eyecolor int(10) unsigned NOT NULL default '1',

  luclin_beardcolor int(10) unsigned NOT NULL default '1',

  fixedz tinyint(2) unsigned NOT NULL default '0',

  d_meele_texture1 int(10) unsigned NOT NULL default '0',

  d_meele_texture2 int(10) unsigned NOT NULL default '0',

  walkspeed float NOT NULL default '0',

  runspeed float NOT NULL default '0',

  MR smallint(5) NOT NULL default '0',

  CR smallint(5) NOT NULL default '0',

  DR smallint(5) NOT NULL default '0',

  FR smallint(5) NOT NULL default '0',

  PR smallint(5) NOT NULL default '0',

  PRIMARY KEY  (id)

) TYPE=MyISAM;

Then drop your database, create a new one, and source db.sql again. Then when you load your DB, it shouldn't error on npc_types.

I think I did get a few other errors, but all in all it was ok.

FYI, I got this from the cvs dump here:

http://cvs.sourceforge.net/cgi-bin/v...mu/NightDumps/

-Auldar

this is telmet, i have put the new db.sql from cvs inside the new binaries that i release. so all should work well its in the DR3 release on my site. http://cecugfile.net enjoy :p

I'm getting this error again with the new db (0.4.2) and it even has what Auldar told me to paste in. :?

Now all I wanna know is when the official 4.2 addon will be released :wink:

Just a small sql file to update your DB for changes made by 4.2

I suggest using "mysql.exe -f eq < 41to42fix.sql" to load it. The -f means it will ignore any errors, like if you already added the resists stuff to your npc_types

41to42fix.sql

Code:

-- Update EQEmu 4.1 DB to a 4.2 compatable DB



ALTER TABLE `account` CHANGE `password` `password` VARCHAR(50)  NOT NULL;



ALTER TABLE `npc_types` CHANGE `npcspecialattks` `npcspecialattks` varchar(36) default '' NOT NULL;

ALTER TABLE `npc_types` ADD `MR` SMALLINT(5)  DEFAULT "0" NOT NULL;

ALTER TABLE `npc_types` ADD `CR` SMALLINT(5)  DEFAULT "0" NOT NULL;

ALTER TABLE `npc_types` ADD `DR` SMALLINT(5)  DEFAULT "0" NOT NULL;

ALTER TABLE `npc_types` ADD `FR` SMALLINT(5)  DEFAULT "0" NOT NULL;

ALTER TABLE `npc_types` ADD `PR` SMALLINT(5)  DEFAULT "0" NOT NULL;





ALTER TABLE `variables` ADD `ts` timestamp;



INSERT INTO variables VALUES ('AILevel','0','');

INSERT INTO variables VALUES ('ZSPassword', 'EQEMu', '');