Minilogin and SVN code

[Malketh]

I just checked out all the source code and compiled the world server from scratch. As far as I can tell it works just fine, but depending on which minilogin executable I use, different things happen and none of them good. Now I'm posting this because I've already checked everything (settings, opcodes, database entries) to the best of my ability.

When I use the public login server it works perfect, and I can make a character, run around, etc.

When using the 1.0 or 1.01 release of minilogin, world.exe attempts to connect to minilogin and shows "Login Server returned a fatal error: Incorrect version". As I've said, I've already added an entry to login_versions for this version of world (which happens to be 0.7-dev). Other than the stated message I see no other messages of any kind and increasing the debugging/logging level doesn't help to clarify this message.

When using the minilogin executable that comes from the SVN, world.exe supposedly connects to minilogin, but minilogin shows that the server connects to it and then spits out "DBCore: #1054: Unknown column 'login_version' in 'field list'" and nothing else. I can connect to the server with the client, authenticate and the character that I've made is displayed but the game tells me that the world server is down.

I have no idea how to fix this other than using the public login sever (which would be fine if I had a reliable internet connection).

[John Adams]

I think you're stumbling onto a cross between new code and old DB. Try replacing your login_worldservers table with this:

Code: Select all

CREATE TABLE `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,
  `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=6 DEFAULT CHARSET=latin1

or adding this column: `login_version` varchar(32) NOT NULL default '0'

I started providing the new EQ2Minilogin.exe a while ago, but forgot some of the database structures have changed. If I have time this weekend, I'll see about posting a new eq2ls DB for ServerPack users.

[John Adams]

Here's another table that might have changed to support Equipment Appearances at Character Select:

Code: Select all

CREATE TABLE `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=1 DEFAULT CHARSET=latin1

log_type errors:

Code: Select all

CREATE TABLE `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=1 DEFAULT CHARSET=latin1

lc.soga_model_type errors:

Code: Select all

CREATE TABLE `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_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=1 DEFAULT CHARSET=latin1

ls_world_zones doesn't exist error:

Code: Select all

CREATE TABLE `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=1 DEFAULT CHARSET=latin1