Myra spawn db

[Wumpas]

For those with problems with that link try rightclick save worked for me

Is this a complete database I tried sourcing it by itself and it gave alot of 1046 errors next I tried sourcing it into the db.sql with 0.5.2-Update then it gave me colum number dosent match value errors.

how exactly does one source the myra database?

Do i create all the tables manuly before sorcing and if so what are the table and field parameters?

thank you for your help im going to continue to dink around with it mabe ill solve my own problem

[cybermax]

This is a "spawn only" db Womp.. You need to eg. modify the MW db to use theese spawns instead.

Ill do some testing, and see what i can come up with.. (Now if someone would fix the still messed up zone points, i would be happy as a .. well.. whatever)

[Wumpas]

Ok thanks makes more sense now hehe

Do I drop tables then and then source this if so which tables need to go?
I will experiment with this myself (not on my working DB) ill see if i can figure it out thank you the help

most zone points have been right on for me im using

MW_051_052_alpha1.sql
0.5.2-Update.sql

only unfinished one ive found are on luclin and the hole

EDIT -- I remeberd I can brows though the sql in notepad ill figure out the tables I need to drop myself I think---

i discoverd droping the tables is a bad idea as well instead i think i half to clear the data in tables

faction_list
items
lootdrop
lootdrop_entries
loottable
loottable_entries
merchantlist
npc_faction
npc_faction_entries
npc_spells
npc_spells_entries
npc_types
spawn2
spawnentry
spawngroup

after this source Myradb.sql?

Am i correct with this asumption?

[Scorpious2k]

Originally Posted by Wumpas

Am i correct with this asumption?

Yes, she fixed it so that it could be used after the standard release db is installed

[cybermax]

Since the myradb does not contain how to create the different tables, you need to not only drop them, but create them new..

I got the create strings from db.sql that comes with 5.2, and then did this to each different table in myradb :

DROP TABLE npc_faction;
CREATE TABLE npc_faction (
id int(11) NOT NULL auto_increment,
name tinytext,
primaryfaction int(11) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

Ie.. first i drop the table npc_faction, then i create it (with the data from the db.sql), then i source in myradb info here..

DROP TABLE npc_faction;
CREATE TABLE npc_faction (
id int(11) NOT NULL auto_increment,
name tinytext,
primaryfaction int(11) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

INSERT INTO npc_faction VALUES (1,'Aagron_Faction',311);
INSERT INTO npc_faction VALUES (2,'Aanina_Rockfinder_Faction',10;
INSERT INTO npc_faction VALUES (3,'Aarina_Ratsbone_Faction',10;
INSERT INTO npc_faction VALUES (4,'abandoned_heretic_pet_Faction',302);

And so on.. this has to be done for each table listed in the db.

And it worked

EDIT: Dont delete the items table tho.. cos myra db only have some adds for this, and not the complete db items. (Due to some spawn loots was not listed in the default items db)

the only problems i see so far, is some faction issues (wich i should be able to tweak myself if i can figure out how to).. ie. no "mobs" are kos to me..

Still have some difficulties with the zone points tho.. Could you try to create some NEW characters Wumpas? Ie. not just #zone your current caracter around, but create new one.. Human agnostic monk++ cos i cant seem to get much working other than the froglok pally starting in gukta. (i can then move my human monk over to the bazaar and start playing tho..)

[Wumpas]

all i did was ( you did alot mroe than you needed to hehe)

sourced MW_051_052_alpha1.sql
sourced 0.5.2-Update.sql

describe faction_list

look at the id field and use that with a comparison operator to clear the data

DELETE FROM faction_list WHERE id >= 0;

I repeated for every table in my above post

i then sourced myrasdb did my grant and account insert

P.S. im in freeport right now with human monk works great

EDITED ***Myra has fixed this now all bow to her***

[AK1122]

create database eq;
use eq
source db.sql
source myradb.sql
source itemdump.sql

thats it
dont need to drop create n stuff

[AK1122]

uploading new archives.. included in there is a for dummies file =)

[Wumpas]

Thank you myra and ak1122 i love your documentation

Sword of Banning+1

That is going in my favorite_quotes.txt

Hilarious

Im going to set this database up right now

As to the method I explained in above posts for he original version of this file It may be flawwed all the merchants tell me to leave them alone im not in the magition class guild blah blah

But mob factions worked well those orcs hated me heh

Ill run this version and see if the merchant issues are anny diffrent.

resaults pending

thank you so much myra and ak1122

RESULTS

This could be my error but ak1122 I think thers a problem

for one itemdumps.sql??? you mean dumpeditems.sql correct?

this was my order

create database myrab;
source db.sql;
source myradb.sql

(this is as far as i got as my pc speaker made my head explode)

I also tried using your sourcethisfordummies.sql and this prodeced the same result.

not sure whats up there but Im going to mess around with it some more and if I find anything ill let you all know.

Thanks again Myra

I sourced db.sql

then sourced myradb.sql

got about 5 billion
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1

and it's not logging in I would say this one needs a little more twinking probbly just a small fix before it's useable.
great add on tho once you get it working I had to remove a few things and it works fine.

[Bearik]

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

Getting the same.

[Scorpious2k]

sounds like a table changed. any idea which one is producing the error?

[cybermax]

P.S. im in freeport right now with human monk works great

Hmm.. If i create a Human monk on "Tranquil" deity, it will have starting city of West Freeport. I can create the character, but when i press "Enter World", zone.exe will crash.. over.. and over.. and over.. and guess what? over again..

Same for a "Agnostic" monk that start in Qeynos. Also same for many many others.. Ie. High Elf Palladin, Halfling Ranger.. i can make a list, but i frankly think i wont bother cos it has to be some weird stuff happening at my house then?

I have done this :
Created database named eq.
Sourced MW_051_052_alpha1.sql Dated 27.11.2003 (11:14)
Sourced 0.5.2-Update.sql (that came with the precompiled 052 binaries)

Made my accounts, made characters.. but very few of them i can create a NEW character and press "Enter World" without a crash.

I can however (as i posted before), create a Froglok Paladin in Gukta. Then when i log this on, i use #movechar Mymonk Bazaar, and i can then log on my monk wich then is in the bazaar.

Please verify that you have created a NEW human monk, both agnostic and tranquil, and pressed "Enter World" with using the above database and the update. (Not only use #zone freportw).

If this works for you with the above dated DB, i am totally lost.. :P

[cybermax]

And to why the myradb is not 100% up date with the 052 db.sql, here is what i found to be different :

Table structure of npc_types has ADDED this :
lastname varchar(32),

There is also some changes in the "items" table.. i cannot figure out how to change this to be right tho.. :( I tried to compare the items table structure from the one i got working to the default "db.sql", but could not find any differences.. its getting late here.. hehe.. going bliiiing :P

[Scorpious2k]

Originally Posted by cybermax

And to why the myradb is not 100% up date with the 052 db.sql, here is what i found to be different :

Table structure of npc_types has ADDED this :
lastname varchar(32),

Caught that and fixed it, thanks.

There is also some changes in the "items" table

The items in her DB are actually right - db.sql is wrong for items. If you d/l the items dump db and source it first, the items in her db will be fine. She will have the other fixed soon.