Bandor
05-24-2014, 09:26 PM
Ok so in my mission to set my start zones im having some problems. First I tried using mysql commands to update them,and kept getting syntax errors,no I gave up and just manually edited the data for start_zones. I dumped the structure and data to a sql file and sourced it to my db. and its still not working. When a character is created I get a message saying no start_zone file found in db using defaults. And it keeps saying something about SoF Start Zone but I can't find that in navicat/heidi for nothing. Upon further inspection of my sql file I saw it reads
-- Table structure for start_zones
-- ----------------------------
DROP TABLE IF EXISTS `start_zones`;
CREATE TABLE `start_zones` (
`x` float NOT NULL DEFAULT '0',
`y` float NOT NULL DEFAULT '0',
`z` float NOT NULL DEFAULT '0',
`heading` float NOT NULL DEFAULT '0',
`zone_id` int(4) NOT NULL DEFAULT '0',
`bind_id` int(4) NOT NULL DEFAULT '0',
`player_choice` int(2) NOT NULL DEFAULT '0',
`player_class` int(2) NOT NULL DEFAULT '0',
`player_deity` int(4) NOT NULL DEFAULT '0',
`player_race` int(4) NOT NULL DEFAULT '0',
`start_zone` int(4) NOT NULL DEFAULT '0',
`bind_x` float NOT NULL DEFAULT '0',
`bind_y` float NOT NULL DEFAULT '0',
`bind_z` float NOT NULL DEFAULT '0',
`select_rank` tinyint(3) unsigned NOT NULL DEFAULT '50',
PRIMARY KEY (`player_choice`,`player_race`,`player_class`,`pla yer_deity`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Is there something in that long line of nonsense that has to be edited aswell? Or am I just missing something?
-- Table structure for start_zones
-- ----------------------------
DROP TABLE IF EXISTS `start_zones`;
CREATE TABLE `start_zones` (
`x` float NOT NULL DEFAULT '0',
`y` float NOT NULL DEFAULT '0',
`z` float NOT NULL DEFAULT '0',
`heading` float NOT NULL DEFAULT '0',
`zone_id` int(4) NOT NULL DEFAULT '0',
`bind_id` int(4) NOT NULL DEFAULT '0',
`player_choice` int(2) NOT NULL DEFAULT '0',
`player_class` int(2) NOT NULL DEFAULT '0',
`player_deity` int(4) NOT NULL DEFAULT '0',
`player_race` int(4) NOT NULL DEFAULT '0',
`start_zone` int(4) NOT NULL DEFAULT '0',
`bind_x` float NOT NULL DEFAULT '0',
`bind_y` float NOT NULL DEFAULT '0',
`bind_z` float NOT NULL DEFAULT '0',
`select_rank` tinyint(3) unsigned NOT NULL DEFAULT '50',
PRIMARY KEY (`player_choice`,`player_race`,`player_class`,`pla yer_deity`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Is there something in that long line of nonsense that has to be edited aswell? Or am I just missing something?