My sql update don't work in cavedude database because it don't have same fields on zone table than peq. You need some work for correct it :
Cavedude :
Code:
CREATE TABLE `zone` (
`short_name` varchar(16) NOT NULL default '',
`file_name` varchar(16) default NULL,
`long_name` text NOT NULL,
`safe_x` float NOT NULL default '0',
`safe_y` float NOT NULL default '0',
`safe_z` float NOT NULL default '0',
`min_level` tinyint(3) unsigned NOT NULL default '0',
`min_status` tinyint(3) unsigned NOT NULL default '0',
`zoneidnumber` int(4) NOT NULL default '0',
`timezone` int(5) NOT NULL default '0',
`maxclients` int(5) NOT NULL default '0',
`weather` smallint(6) NOT NULL default '1',
`underworld` float NOT NULL default '0',
`minclip` float NOT NULL default '450',
`maxclip` float NOT NULL default '450',
`fog_minclip` float NOT NULL default '450',
`fog_maxclip` float NOT NULL default '450',
`fog_blue` tinyint(3) unsigned NOT NULL default '0',
`fog_red` tinyint(3) unsigned NOT NULL default '0',
`fog_green` tinyint(3) unsigned NOT NULL default '0',
`sky` tinyint(3) unsigned NOT NULL default '1',
`ztype` tinyint(3) unsigned NOT NULL default '1',
`zone_exp_multiplier` float NOT NULL default '1',
`walkspeed` float NOT NULL default '0.4',
`time_type` tinyint(3) unsigned NOT NULL default '2',
`ldondungeon` tinyint(1) NOT NULL default '0',
`qflagreq` int(2) NOT NULL default '0',
`fog_red2` tinyint(3) unsigned NOT NULL default '0',
`fog_green2` tinyint(3) unsigned NOT NULL default '0',
`fog_blue2` tinyint(3) unsigned NOT NULL default '0',
`fog_minclip2` float NOT NULL default '450',
`fog_maxclip2` float NOT NULL default '450',
`fog_red3` tinyint(3) unsigned NOT NULL default '0',
`fog_green3` tinyint(3) unsigned NOT NULL default '0',
`fog_blue3` tinyint(3) unsigned NOT NULL default '0',
`fog_minclip3` float NOT NULL default '450',
`fog_maxclip3` float NOT NULL default '450',
`fog_red4` tinyint(3) unsigned NOT NULL default '0',
`fog_green4` tinyint(3) unsigned NOT NULL default '0',
`fog_blue4` tinyint(3) unsigned NOT NULL default '0',
`fog_minclip4` float NOT NULL default '450',
`fog_maxclip4` float NOT NULL default '450',
PEQ:
Code:
CREATE TABLE `zone` (
`short_name` varchar(16) NOT NULL default '',
`file_name` varchar(16) default NULL,
`long_name` text NOT NULL,
`safe_x` float NOT NULL default '0',
`safe_y` float NOT NULL default '0',
`safe_z` float NOT NULL default '0',
`min_level` tinyint(3) unsigned NOT NULL default '0',
`min_status` tinyint(3) unsigned NOT NULL default '0',
`zoneidnumber` int(4) NOT NULL default '0',
`timezone` int(5) NOT NULL default '0',
`maxclients` int(5) NOT NULL default '0',
`weather` smallint(6) NOT NULL default '1',
`note` varchar(80) default NULL,
`underworld` float NOT NULL default '0',
`minclip` float NOT NULL default '450',
`maxclip` float NOT NULL default '450',
`fog_minclip` float NOT NULL default '450',
`fog_maxclip` float NOT NULL default '450',
`fog_blue` tinyint(3) unsigned NOT NULL default '0',
`fog_red` tinyint(3) unsigned NOT NULL default '0',
`fog_green` tinyint(3) unsigned NOT NULL default '0',
`sky` tinyint(3) unsigned NOT NULL default '1',
`ztype` tinyint(3) unsigned NOT NULL default '1',
`zone_exp_multiplier` float NOT NULL default '1',
`walkspeed` float NOT NULL default '0.4',
`time_type` tinyint(3) unsigned NOT NULL default '2',
`fog_red1` tinyint(3) unsigned NOT NULL default '0',
`fog_green1` tinyint(3) unsigned NOT NULL default '0',
`fog_blue1` tinyint(3) unsigned NOT NULL default '0',
`fog_minclip1` float NOT NULL default '450',
`fog_maxclip1` float NOT NULL default '450',
`fog_red2` tinyint(3) unsigned NOT NULL default '0',
`fog_green2` tinyint(3) unsigned NOT NULL default '0',
`fog_blue2` tinyint(3) unsigned NOT NULL default '0',
`fog_minclip2` float NOT NULL default '450',
`fog_maxclip2` float NOT NULL default '450',
`fog_red3` tinyint(3) unsigned NOT NULL default '0',
`fog_green3` tinyint(3) unsigned NOT NULL default '0',
`fog_blue3` tinyint(3) unsigned NOT NULL default '0',
`fog_minclip3` float NOT NULL default '450',
`fog_maxclip3` float NOT NULL default '450',
`fog_red4` tinyint(3) unsigned NOT NULL default '0',
`fog_green4` tinyint(3) unsigned NOT NULL default '0',
`fog_blue4` tinyint(3) unsigned NOT NULL default '0',
`fog_minclip4` float NOT NULL default '450',
`fog_maxclip4` float NOT NULL default '450',
Add missing zone fields and that can work i think 
__________________
__________________________________________________ _____________________________________
I speak english like a spanish cow..., I speak spanish like a english pudding...
But I try to speak good french !!! (Non au langage SMS sur forum)
http://eqfroggy.new.fr : Froggy French Server Website.
|