Myra db update

[Myra]

Sorry it took so long. I have a new release! It's up-to-date with the current dr3 plus has the following fixes...

- Fixed mindmg and maxdmg so the mobs hit for amounts that are more correct for their levels
- Updated bodytypes
- Fixed HP so it is closer to what it should be for the levels
- Updated npc_types table to match current EQEmu release
- Updated loot tables
- Updated sleeper. The warders are there now, loot is correct
- added zone poair

download here

[Trumpcard]

WOOHOO Myra!

[psycox]

Sweet new myra db. Now to decide wether to try and merge, or start over with it hehe =)

[Scorpious2k]

*sitting in chair polishing the barrell of my shotgun*

Originally Posted by Trumpcard

WOOHOO Myra!

'scuse me sir, did you just woohoo my daughter??

[Myra]

Originally Posted by Scorpious2k

*sitting in chair polishing the barrell of my shotgun*

'scuse me sir, did you just woohoo my daughter??

Ignore him, he's just a perfect stranger who gives me my allowance.

[Trumpcard]

Erm.. That was a polite 'touchdown' woohoo.. Or a Homer Simpson 'Woohoo'

Not a construction worker 'Woohoo'

Not until your 18 Myra!

[samandhi]

AWESOME job Myra... I will get that IMMEDIATELY.... Thank you for taking the time to do this. And I too say WOHOOOO (only homer simpson kind here also )

<shhh this is a secret Myra>... I would say that Dad should up your allowance, your thoughts? <smile>

[Scorpious2k]

Originally Posted by Myra

Ignore him, he's just a perfect stranger who gives me my allowance.

You mean USED TO give you your allowance....

[Myra]

Originally Posted by Scorpious2k

You mean USED TO give you your allowance....

Oh wait, it's all coming back now, DADDY!!!!

[wize_one]

need a little help here..(wanting to see the good work i keep hearing about)

following the readme

To use this: (new installation for server)

source the db.sql file that came with eqemu, if you don't have it you can download it from my web site
source the items db from eqemu
source MyraDB.sql
source MyraItems.sql (you may see some duplicate entry errors with this, it is OK to ignore them)

i do the:
db.sql(no probs)
dumpeditems.sql(no probs)
myra(get errors)

looking at it,

INSERT INTO npc_types VALUES (11312,'#an_apparition_of_dust',NULL,67,210,1,0,54 40,2,0,0,0,2,0,11900,0,0,0,75,249,'',0,65,0,0,0,0, 0,0,0,0,0,250,250,25,25,25,25,25,0,0,1,0);

there are 43 fields, standard db(without jan24 patch) has 40, with jan24 patch only 42. what needs to be added to fix the errors?

[Timothius]

Originally Posted by wize_one

need a little help here..(wanting to see the good work i keep hearing about)

following the readme

i do the:
db.sql(no probs)
dumpeditems.sql(no probs)
myra(get errors)

looking at it,

there are 43 fields, standard db(without jan24 patch) has 40, with jan24 patch only 42. what needs to be added to fix the errors?

I didnt have this exact problem, but I did have a problem with the npc_types table, where 'lastname' was set to be not null, and mysql was freaking out on every npc. I just changed the column to allow for null and it works great! This is one of the best databases that I have used to date, GREAT work Myra!

Timothius the Ultra Lurker

[jimmy6154]

Hiyas - great job btw..

Though I'm getting this error when I souce the myradb after I source the db and dumperitems

ERROR:1136 Column count doesn't match value count at row 1


I get this error over and over and over again hehe

[Myra]

There are 43 fields in the latest version I thought there might be a problem so I put a correct version of db.sql for download from my site. Download it and start with it instead and you should be okay.

[Lurker_005]

Nice to see a new update to this DB Myra.

The latest dumpeditems.sql has a different structure than the db.sql file. A good reason to dump the table structure with the data. There are some changes besides the last few columns, but here is the differance at the end:

dumpeditems.sql

  updated datetime NOT NULL default '0000-00-00 00:00:00',
  weight int(11) NOT NULL default '0',
  comment varchar(255) NOT NULL default '',
  loreflag tinyint(3) unsigned NOT NULL default '0',
  pendingloreflag tinyint(3) unsigned NOT NULL default '0',
  artifactflag tinyint(3) unsigned NOT NULL default '0',
  summonedflag tinyint(3) unsigned NOT NULL default '0',
  unknown113 int(11) NOT NULL default '0',
  unknown115 int(11) NOT NULL default '0',

Vs.
db.sql

  updated datetime default NULL,
  md5sum tinyblob NULL,
  weight int(11) NULL,
  comment varchar(255) default NULL,

Vs.
MyraItems.sql data structure (best as I can tell)

  weight int(11) NOT NULL default '0',
  comment varchar(255) NOT NULL default '',
  loreflag tinyint(3) unsigned NOT NULL default '0',
  pendingloreflag tinyint(3) unsigned NOT NULL default '0',
  artifactflag tinyint(3) unsigned NOT NULL default '0',
  summonedflag tinyint(3) unsigned NOT NULL default '0',
 updated datetime NOT NULL default '0000-00-00 00:00:00',

---  Add Quest_globalbs table that is missing from db.sql
DROP TABLE IF EXISTS quest_globals;
CREATE TABLE quest_globals (
  id int(11) NOT NULL auto_increment,
  charid int(11) NOT NULL default 0,
  npcid int(11) NOT NULL default 0,
  zoneid int(11) NOT NULL default 0,
  name varchar(65) NOT NULL,
  value varchar(65) NOT NULL default "?",
  expdate int(11) NOT NULL default 0,
  PRIMARY KEY  (id),
  UNIQUE KEY qname (name,charid,npcid,zoneid)
) TYPE=MyISAM;



--- Reorder npc_types to same as default eqemu db.sql

ALTER TABLE `npc_types` ADD `mysqlfront_temp_fieldname` TINYINT(4)  DEFAULT "0" NOT NULL AFTER `runspeed`
UPDATE `npc_types` SET `mysqlfront_temp_fieldname`=`see_invis`
ALTER TABLE `npc_types` DROP `see_invis`
ALTER TABLE `npc_types` CHANGE `mysqlfront_temp_fieldname` `see_invis` TINYINT(4)  DEFAULT "0" NOT NULL

ALTER TABLE `npc_types` ADD `mysqlfront_temp_fieldname` TINYINT(4)  DEFAULT "1" NOT NULL AFTER `see_invis`
UPDATE `npc_types` SET `mysqlfront_temp_fieldname`=`see_invis_undead`
ALTER TABLE `npc_types` DROP `see_invis_undead`
ALTER TABLE `npc_types` CHANGE `mysqlfront_temp_fieldname` `see_invis_undead` TINYINT(4)  DEFAULT "1" NOT NULL

I also noticed

  revoked tinyint(3) unsigned NOT NULL default '0',

in the accounts table. I don't know if this is needed, or will cause problems.

PS. the Trump, Scorp, Myra exchange gave me a good chuckle, thanks

[wize_one]

the groupid patch is missing..no big deal..had to change the lastname field in npc type..remove the NOT in it.. so it is just NULL.