EQEmulator Forums
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)
-   -   Myra db update (https://www.eqemulator.org/forums/showthread.php?t=11866)

Myra 02-11-2004 09:52 AM
Myra db update
 
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 02-11-2004 10:17 AM
WOOHOO Myra!

psycox 02-11-2004 11:03 AM
Sweet new myra db. Now to decide wether to try and merge, or start over with it hehe =)

Scorpious2k 02-11-2004 11:40 AM
*sitting in chair polishing the barrell of my shotgun*

Quote:
Originally Posted by Trumpcard
WOOHOO Myra!
'scuse me sir, did you just woohoo my daughter??

Myra 02-11-2004 11:56 AM
Quote:
Originally Posted by Scorpious2k
*sitting in chair polishing the barrell of my shotgun*

Quote:
Originally Posted by Trumpcard
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 02-11-2004 11:58 AM
Erm.. That was a polite 'touchdown' woohoo.. Or a Homer Simpson 'Woohoo'

Not a construction worker 'Woohoo'

Not until your 18 Myra! :D

samandhi 02-11-2004 12:07 PM
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 02-11-2004 12:42 PM
Quote:
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 02-11-2004 12:44 PM
Quote:
Originally Posted by Scorpious2k
Quote:
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....
Oh wait, it's all coming back now, DADDY!!!!

wize_one 02-11-2004 01:33 PM
need a little help here..(wanting to see the good work i keep hearing about)

following the readme
Quote:
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,
Quote:
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 02-11-2004 02:02 PM
Quote:
Originally Posted by wize_one
need a little help here..(wanting to see the good work i keep hearing about)

following the readme
Quote:
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,
Quote:
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 02-11-2004 02:40 PM
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 02-11-2004 02:59 PM
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 02-11-2004 04:24 PM
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
Code:
  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
Code:
  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)
Code:
  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',
Code:
---  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
Code:
  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 02-11-2004 05:36 PM
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 02-12-2004 04:26 AM
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 02-12-2004 05:04 AM
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 02-12-2004 06:38 AM
Quote:
Originally Posted by Lurker_005
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.

Quote:
I also noticed
Code:
  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.

Quote:
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 02-12-2004 07:45 AM
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 02-12-2004 09:02 AM
yes, except for the items - the tables are in different order for some reason. Spawns/mobs should be good.

Trumpcard 02-12-2004 09:40 AM
Quote:
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 02-12-2004 09:41 AM
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 02-12-2004 10:16 AM
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 02-12-2004 01:05 PM
Quote:
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 02-12-2004 01:30 PM
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 02-13-2004 04:32 AM
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 02-13-2004 05:20 AM
I started from scratch. I had a clean slate. Try that and see if it helps.

hoser2x 02-13-2004 07:44 AM
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 02-13-2004 08:04 AM
[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 02-13-2004 08:57 AM
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 02-13-2004 09:00 AM
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 02-13-2004 12:19 PM
Myra I was wondering if you had a zone spawn list of all the zones currently spawned?

Holy_Templar 02-13-2004 02:06 PM
From the readme:

Quote:


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 02-15-2004 01:46 PM
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 02-15-2004 01:49 PM
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 02-15-2004 01:52 PM
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 02-15-2004 01:54 PM
Yes

samandhi 02-15-2004 02:02 PM
Quote:
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 02-15-2004 02:41 PM
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 02-16-2004 02:34 AM
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.


All times are GMT -4. The time now is 09:46 AM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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