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 (http://bossmob.com/Myra/)

[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*

WOOHOO Myra!

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

[Myra]

*sitting in chair polishing the barrell of my shotgun*

WOOHOO Myra!

'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! :D

[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]

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

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

[Myra]

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

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]

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?


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.

[jimmy6154]

Hiyas... I must be doing something wrong.


Fresh install

Sourced db.sql from you website - no problem
Sourced dumpeditems.sql - No problem
Sourced myradb.sql - Got a ton of duplicated error. I think it ran for about 6 hours b4 it finished. I would say 90% of it was duplicates
Sourced myraitems - no problem

I log into with no issues, though I got no mobs... I'm forgetting something?

[Conan]

the error I think you were seeing is lastname cannot be null, I sourced this morning with this and that was the error I seen,

[Scorpious2k]

The latest dumpeditems.sql has a different structure than the db.sql file. A good reason to dump the table structure with the data.

I didn't know it had changed... only looks like some things got moved around and a couple of new things added.

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.

It will be, that one is just a little ahead of released code.

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

Trump is a good sport and a great guy.

As for the db: I changed db.sql for her (new one with changes on her download page), since she is in school and won't be home until late because of a field trip.

I think there may still be problems with items, but the rest should be fine.

[jimmy6154]

So if I start from scratch again

souce db downloaded from the her site
source dumpeditems
source myradb
source myra items

I sould be ok then?

[Scorpious2k]

yes, except for the items - the tables are in different order for some reason. Spawns/mobs should be good.

[Trumpcard]

Trump is a good sport and a great guy.


My wife disagrees vehemently... I am the archangel of fury and darkness...

She just doesnt understand me... Maybe I should scream louder and throw more pots....

[Monrezz]

Heh, must be great living with you ;)

Try throwing other things at her as well. The harder it hits the more points you get! :o

Monrezz

[Trumpcard]

I told her a joke the other day, she didnt appreciate it..

'What do you tell your wife when she has 2 black eyes?'

'Nothing, she obviously wasnt listening the 1st 2 times you tried to tell her!'


Poster note: I am no way condoning violence against women in any way, shape or form. I am a firm believer that no man should ever strike a woman in anything other than self defense. I am merely expressing my desire to punch my wife in the face at times (which has never happened, at least as far as the courts are concerned (HAHAHA, J/K) )

[samandhi]

I am no way condoning violence against women in any way, shape or form Yeah I dont condone or practice violence against women, but I UNDERSTAND it! j/k of course <smile>

[jimmy6154]

whew got this to work with no error...

Great job everything looks great though some of the poair mob locs are a bit off. Everything looks great

here is what I did.

downloaded everything from myra's website.

Sourced the db
sourced myradb
sourced dumpeditems
sourced myraitems

no errors works great!

[hoser2x]

Sorry but I feel kinda lost here. What should be the proper order for sourcing the sql data? I did the following order and now everytime a client connects my world server basicly dumps.

db.sql (Myra's)
MyraDB.sql
dumpeditems.sql
MyraItems.sql

I'm a novice w/ mysql so any help is appreciated!

It appears that my problem may actually be more of an issue during new character creation, as I'm working with the patched to eqlive current version. Going to see if i can insert a precreated character and see if the same problems still exists.

[jimmy6154]

I started from scratch. I had a clean slate. Try that and see if it helps.

[hoser2x]

It's definitely a character creation problem, was able to source the above again w/o any errors. Does anyone have an export of a level 1 character that i can use to to just get back in game? I tried my luck at creating a new one w/o going thru the in game wizard using the eqemu admin tool 5.1 without success. Everytime I sign on the server, the console says "Received unknown opcode: 0x00f0 size:0 bytes".


Not a big deal cause I know these problems won't exist once the latest version is available, but more of a learning experience.

[Monrezz]

[code]DROP TABLE character_;
CREATE TABLE character_ (
id int(11) NOT NULL auto_increment,
account_id int(11) NOT NULL default '0',
name varchar(64) NOT NULL default '',
profile blob,
guild int(11) default '0',
guildrank tinyint(2) unsigned default '5',
timelaston int(11) unsigned default '0',
x float NOT NULL default '0',
y float NOT NULL default '0',
z float NOT NULL default '0',
zonename varchar(30) NOT NULL default '',
alt_adv blob,
zoneid smallint(6) NOT NULL default '0',
pktime int(8) NOT NULL default '0',
inventory blob,
publicnote varchar(100) NOT NULL default '',
groupid int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY name (name)
) TYPE=MyISAM;

INSERT INTO character_ VALUES (1,1,'Monrezz','

[hoser2x]

I was able to source it w/o issues, but as soon as I sign on it gives me "Got a bogus character <Monrezz>, deleting it.". Is it possible that it's not pointing to the account I'd logged in with?

[Monrezz]

Yes, probably. Open it with EQAdmin and change the account name and id to the one you signed in with. Sorry, forgot to mention that.

[Conan]

Myra I was wondering if you had a zone spawn list of all the zones currently spawned?

[Holy_Templar]

From the readme:




When you are done, you will have the following zones fully populated and ready to play in:

+---------------+
| zone
+---------------+
| acrylia
| airplane
| akanon
| akheva
| bazaar
| befallen
| beholder
| blackburrow
| bothunder
| burningwood
| butcher
| cabeast
| cabwest
| cauldron
| cazicthule
| charasis
| chardok
| citymist
| cobaltscar
| codecay
| commons
| crushbone
| crystal
| dalnir
| dawnshroud
| dreadlands
| droga
| eastkarana
| eastwastes
| echo
| ecommons
| emeraldjungle
| erudnext
| erudnint
| erudsxing
| everfrost
| fearplane
| feerrott
| felwithea
| felwitheb
| fieldofbone
| firiona
| freporte
| freportn
| freportw
| frontiermtns
| frozenshadow
| fungusgrove
| gfaydark
| greatdivide
| griegsend
| grimling
| grobb
| growthplane
| gukbottom
| guktop
| halas
| hateplane
| highkeep
| highpass
| hohonora
| hohonorb
| hole
| hollowshade
| iceclad
| innothule
| jaggedpine
| kael
| kaesora
| kaladima
| kaladimb
| karnor
| katta
| kedge
| kerraridge
| kithicor
| kurn
| lakeofillomen
| lakerathe
| lavastorm
| letalis
| lfaydark
| maiden
| mischiefplane
| mistmoore
| misty
| mseru
| najena
| necropolis
| nektulos
| neriaka
| neriakb
| neriakc
| netherbian
| nexus
| nightmareb
| northkarana
| nro
| nurga
| oasis
| oggok
| oot
| overthere
| paineel
| paw
| permafrost
| poair <--- NEW
| podisease
| poinnovation
| pojustice
| poknowledge
| ponightmare
| postorms
| potranquility
| povalor
| qcat
| qey2hh1
| qeynos
| qeynos2
| qeytoqrg
| qrg
| rathemtn
| rivervale
| runnyeye
| scarlet
| sebilis
| shadeweaver
| shadowhaven
| sharvahl
| sirens
| skyfire
| skyshrine
| sleeper
| soldunga
| soldungb
| solrotower
| soltemple
| southkarana
| sro
| sseru
| ssratemple
| steamfont
| stonebrunt
| swampofnohope
| templeveeshan
| tenebrous
| thedeep
| thegrey
| thurgadina
| thurgadinb
| timorous
| tox
| trakanon
| tutorial
| twilight
| umbral
| unrest
| veeshan
| velketor
| vexthal
| wakening
| warrens
| warslikswood
| westwastes
+---------------+

[Chicomalo]

So, let me get this straight. If you patch after Feb 10th and you then replace the eqgame.exe with one before Feb 10th, you should be able to play?

I am assuming this is on 0.5.3-dr3 Right?

[Monrezz]

You *can* play.

If you don't have an older version of eqgame.exe, play on the [0.5.5-Dr1] servers, or wait until release.

[Chicomalo]

I know, I was just saying, I am helping with bugs on 0.5.5-DR1 but I do have an eqgame.exe from before Feb 10th. I am just wondering.

Can I run 0.5.3-DR3 with the eqgame.exe from Before Feb 10th patch?

[Monrezz]

Yes

[samandhi]

Can I run 0.5.3-DR3 with the eqgame.exe from Before Feb 10th patch? Yes you can, but there ARE bugs. EG.. if you try and make a new char you will not see the name field, so you cant go any further in the creation, you will have to create your char through direct access to the db..
What you need to do to correct that is to restore (not only eqgame.exe), but also your ui directory.

[Chicomalo]

Update 2:11am Pacific Time

Got my server back running. Needed to doit a little different but got it all running and working which is the must importan part. Everything else is a matter of fix, updates etc... any how time for me to sleep. :wink:

[Swiftwing]

wow I simply cannot get this to work, sorry I tried I just don,t have the know how. My database works fine, but this one I just cant seem to get the items sourced in, error on every live.

[samandhi]

wow I simply cannot get this to work, sorry I tried I just don,t have the know how. My database works fine, but this one I just cant seem to get the items sourced in, error on every live.

You sure it telling you that it is an error or is it just telling you it is a duplicate table 0 rows changed...

[AekaGSR]

I am using DR3.
I don't know if I'm an idiot or what, but I don't have, nor do I know where to get, a droppeditems.sql

Sourcing the db.sql provided by myra works fine.
Sourcing MyraDB.sql works fine.
I cannot find a droppeditems.sql
and sourcing MyraItems.sql throws coloum/row errors at every line.

[hoser2x]

Thanks again Monrezz for the export I changed the id / name to reflect the account we're testing, but keep getting "PP length =4950" and that the character was purged. I'll keep tinkering with it and wait for the new release.

[Monrezz]

Np, sorry it didn't work :(

Release should soon just as soon as Shawn moves his ass :P

^_^