http://oldforums.eq2classic.com/
This sounds like world is not running, so maybe it is crashing?Skywalker646 wrote: Sun Dec 09, 2018 9:04 pm when i try to enter the world, it goes back to the screen asking if i want to create a basic char or a 90th level one and i never see the other characters i created
Code: Select all
DROP TABLE IF EXISTS `account`;
CREATE TABLE IF NOT EXISTS `account` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL DEFAULT '',
`passwd` varchar(64) NOT NULL DEFAULT '',
`ip_address` varchar(50) NOT NULL DEFAULT '0',
`email_address` varchar(50) NOT NULL DEFAULT 'Unknown',
`last_client_version` varchar(50) NOT NULL DEFAULT 'Unknown',
PRIMARY KEY (`id`),
UNIQUE KEY `Name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
Code: Select all
DROP TABLE IF EXISTS `login_characters`;
CREATE TABLE IF NOT EXISTS `login_characters` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`account_id` int(10) unsigned NOT NULL DEFAULT 0,
`server_id` int(10) unsigned NOT NULL DEFAULT 0,
`name` varchar(64) NOT NULL DEFAULT '',
`race` tinyint(3) unsigned NOT NULL DEFAULT 0,
`class` tinyint(3) unsigned NOT NULL DEFAULT 0,
`gender` tinyint(3) unsigned NOT NULL DEFAULT 0,
`deity` tinyint(3) unsigned NOT NULL DEFAULT 0,
`body_size` float NOT NULL DEFAULT 0,
`body_age` float NOT NULL DEFAULT 0,
`current_zone_id` int(10) unsigned NOT NULL DEFAULT 253,
`level` int(10) unsigned NOT NULL DEFAULT 1,
`tradeskill_class` tinyint(3) unsigned NOT NULL DEFAULT 0,
`tradeskill_level` int(10) unsigned NOT NULL DEFAULT 1,
`soga_wing_type` mediumint(8) unsigned NOT NULL,
`soga_chest_type` mediumint(8) unsigned NOT NULL,
`soga_legs_type` mediumint(8) unsigned NOT NULL,
`soga_hair_type` mediumint(8) unsigned NOT NULL,
`soga_model_type` mediumint(8) unsigned NOT NULL,
`legs_type` mediumint(8) unsigned NOT NULL,
`chest_type` mediumint(8) unsigned NOT NULL,
`wing_type` mediumint(8) unsigned NOT NULL,
`hair_type` mediumint(8) unsigned NOT NULL,
`model_type` mediumint(8) unsigned NOT NULL,
`deleted` tinyint(3) unsigned NOT NULL DEFAULT 0,
`unix_timestamp` int(10) NOT NULL DEFAULT 0,
`created_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`last_played` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`char_id` int(11) NOT NULL DEFAULT 0,
`facial_hair_type` mediumint(8) unsigned NOT NULL,
`soga_facial_hair_type` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
Code: Select all
DROP TABLE IF EXISTS `login_worldservers`;
CREATE TABLE IF NOT EXISTS `login_worldservers` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(250) NOT NULL DEFAULT '',
`disabled` tinyint(3) unsigned NOT NULL DEFAULT 0,
`account` varchar(30) NOT NULL DEFAULT '',
`chat_shortname` varchar(20) NOT NULL DEFAULT '',
`description` text NOT NULL,
`server_type` varchar(15) NOT NULL DEFAULT '0',
`password` varchar(32) NOT NULL,
`serverop` varchar(64) NOT NULL DEFAULT '',
`lastseen` int(10) unsigned NOT NULL DEFAULT 0,
`admin_id` int(11) unsigned NOT NULL DEFAULT 0,
`greenname` tinyint(1) unsigned NOT NULL DEFAULT 0,
`showdown` tinyint(4) NOT NULL DEFAULT 0,
`chat` varchar(20) NOT NULL DEFAULT '0',
`note` tinytext NOT NULL,
`ip_address` varchar(50) NOT NULL DEFAULT '0',
`reset_needed` tinyint(3) unsigned NOT NULL DEFAULT 0,
`created_date` int(10) unsigned NOT NULL DEFAULT 0,
`hide_status` tinyint(1) unsigned NOT NULL DEFAULT 0,
`hide_details` tinyint(1) unsigned NOT NULL DEFAULT 0,
`hide_admin` tinyint(1) unsigned NOT NULL DEFAULT 0,
`server_url` varchar(250) DEFAULT '',
`server_category` enum('Standard','Preferred','Premium','Development') DEFAULT 'Standard',
`server_admin` varchar(64) NOT NULL DEFAULT '',
`server_sticky` tinyint(1) unsigned NOT NULL DEFAULT 0,
`gm_list` text DEFAULT NULL,
`reset_zone_descriptions` tinyint(1) unsigned NOT NULL DEFAULT 0,
`reset_login_appearances` tinyint(1) unsigned NOT NULL DEFAULT 0,
`login_version` varchar(32) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `account` (`account`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
Code: Select all
DROP TABLE IF EXISTS `login_worldstats`;
CREATE TABLE IF NOT EXISTS `login_worldstats` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`world_id` int(11) unsigned NOT NULL DEFAULT 0,
`world_status` int(11) NOT NULL DEFAULT -1,
`current_players` int(11) unsigned NOT NULL DEFAULT 0,
`current_zones` int(11) unsigned NOT NULL DEFAULT 0,
`connected_time` timestamp NOT NULL DEFAULT current_timestamp(),
`last_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`world_max_level` tinyint(3) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `NewIndex` (`world_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
Code: Select all
DROP TABLE IF EXISTS `log_messages`;
CREATE TABLE IF NOT EXISTS `log_messages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`log_time` int(10) unsigned NOT NULL DEFAULT 0,
`log_type` varchar(64) NOT NULL,
`message` text NOT NULL,
`account` varchar(64) NOT NULL DEFAULT '',
`client_data_version` int(10) unsigned NOT NULL DEFAULT 0,
`log_entry_archived` tinyint(1) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3899 DEFAULT CHARSET=latin1;
Code: Select all
DROP TABLE IF EXISTS `login_char_colors`;
CREATE TABLE IF NOT EXISTS `login_char_colors` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`login_characters_id` int(10) unsigned NOT NULL,
`signed_value` tinyint(4) NOT NULL DEFAULT 0,
`type` varchar(32) NOT NULL,
`red` smallint(6) NOT NULL DEFAULT 0,
`green` smallint(6) NOT NULL DEFAULT 0,
`blue` smallint(6) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `id_2` (`id`),
KEY `CharID` (`login_characters_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4325 DEFAULT CHARSET=latin1;
Code: Select all
DROP TABLE IF EXISTS `ls_world_zones`;
CREATE TABLE IF NOT EXISTS `ls_world_zones` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`server_id` int(10) unsigned NOT NULL DEFAULT 0,
`zone_id` int(10) unsigned NOT NULL DEFAULT 0,
`name` varchar(128) NOT NULL DEFAULT '',
`description` varchar(128) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
UNIQUE KEY `IDXServerZone` (`server_id`,`zone_id`),
KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2239 DEFAULT CHARSET=latin1;
Code: Select all
DROP TABLE IF EXISTS `login_equipment`;
CREATE TABLE IF NOT EXISTS `login_equipment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`login_characters_id` int(10) unsigned NOT NULL DEFAULT 0,
`equip_type` smallint(5) unsigned NOT NULL DEFAULT 0,
`red` tinyint(3) unsigned NOT NULL DEFAULT 255,
`green` tinyint(3) unsigned NOT NULL DEFAULT 255,
`blue` tinyint(3) unsigned NOT NULL DEFAULT 255,
`highlight_red` tinyint(3) unsigned NOT NULL DEFAULT 255,
`highlight_green` tinyint(3) unsigned NOT NULL DEFAULT 255,
`highlight_blue` tinyint(3) unsigned NOT NULL DEFAULT 255,
`slot` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `CharSlotIDX` (`login_characters_id`,`slot`)
) ENGINE=MyISAM AUTO_INCREMENT=918 DEFAULT CHARSET=latin1;