Server is up... friends cannot log in

Rocker8956 · #6 09-16-2008, 08:02 PM

If the zone table got deleted you will probably need to run the SQL query below to recreate it. There are a lot of values that go in the table. If you need those shoot me a PM with your email address and I will email them to you. Probably would not be good on the forum to post all the values.

This is the PEQ 1128 zone table

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',
  `graveyard_id` 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` decimal(6,2) NOT NULL default '0.00',
  `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',
  `flag_needed` varchar(128) NOT NULL default '',
  `canbind` tinyint(4) NOT NULL default '1',
  `cancombat` tinyint(4) NOT NULL default '1',
  `canlevitate` tinyint(4) NOT NULL default '1',
  `castoutdoor` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`short_name`),
  UNIQUE KEY `zoneidnumber` (`zoneidnumber`)
) TYPE=InnoDB;