View Single Post
  #7  
Old 06-14-2005, 11:25 PM
sdabbs65
Dragon
 
Join Date: Dec 2003
Location: Earth
Posts: 818
Default

Quote:
Originally Posted by WildcardX
Looks like it failed to load the "adventures" table in your database. You said this was a PEQ modified database. Does that mean you have installed one of the PEQ databases and then added custom tables? Would you mind posting the schema of your adventures table?
the adventures table I use is from CVS. only thing I can think of is maybe ldondungeon bool is tripping it.
I think it would be a good idea if you could choose the tables you wanted to load if that was possable.

CREATE TABLE `adventures` (
`QuestID` int(11) NOT NULL default '0',
`NPCID` int(11) NOT NULL default '0',
`Type` tinyint(4) NOT NULL default '0',
`Text` text NOT NULL,
`Objetive` int(11) NOT NULL default '0',
`ObjetiveValue` int(11) NOT NULL default '0',
`Minutes` int(11) NOT NULL default '0',
`Points` int(11) NOT NULL default '0',
`ShowCompass` tinyint(1) NOT NULL default '0',
`zoneid` int(11) NOT NULL default '0',
`zonedungeonid` int(11) NOT NULL default '0',
`X` float NOT NULL default '0',
`Y` float NOT NULL default '0',
`status` int(11) NOT NULL default '0',
`char1` int(11) NOT NULL default '0',
`char2` int(11) NOT NULL default '0',
`char3` int(11) NOT NULL default '0',
`char4` int(11) NOT NULL default '0',
`char5` int(11) NOT NULL default '0',
`char6` int(11) NOT NULL default '0',
`in_use` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE `adventures_maintext` (
`NPCID` int(11) NOT NULL default '0',
`Text` text NOT NULL
) TYPE=MyISAM;

alter table zone add column ldondungeon bool not null default 0;
__________________
hosting Eqemu/Runuo/wow Emulators.

www.cheaterz.info
Reply With Quote