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..)
Threaded Mode
