Okie fixed the problem, seems the character SQL file had default values missing so you could never create a character.
open up the characters.sql file and paste the following into it (overwriting the original code:
Code:
DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
`guid` bigint(20) unsigned NOT NULL auto_increment,
`acct` bigint(20) unsigned NOT NULL default '0',
`Name` longtext NOT NULL,
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`positionR` float NOT NULL default '0',
`MapId_ZoneID` int(10) unsigned NOT NULL default '0',
`Flags` int(10) unsigned NOT NULL default '0',
`AtInn_AFK_DND_inFly` int(10) unsigned NOT NULL default '0',
`LastLogout` double NOT NULL default '0',
`BindingPointX` float NOT NULL default '0',
`BindingPointY` float NOT NULL default '0',
`BindingPointZ` float NOT NULL default '0',
`BindingPointR` float NOT NULL default '0',
`BindingPointMapID_ZoneID` float NOT NULL default '0',
`pgcr` int(10) unsigned NOT NULL default '0',
`Level` int(10) unsigned NOT NULL default '0',
`xp` int(10) unsigned NOT NULL default '0',
`rest_xp` int(10) unsigned NOT NULL default '0',
`rest_state_f_hair` int(10) unsigned NOT NULL default '0',
`HairFaceSkin` int(10) unsigned NOT NULL default '0',
`Copper` int(10) unsigned NOT NULL default '0',
`CurrHealth` int(10) unsigned NOT NULL default '0',
`CurrRMEnergy` int(10) unsigned NOT NULL default '0',
`Items` longtext NOT NULL default '',
`ActiveQuests` longtext NOT NULL default '',
`DoneQuests` longtext NOT NULL default '',
`Spells` longtext NOT NULL default '',
`Skills` longtext NOT NULL default '',
`ExploredZones` longtext NOT NULL default '',
`Tutorials` longtext NOT NULL default '',
`TaxiMask` longtext NOT NULL default '',
`FriendList` longtext NOT NULL default '',
`IgnoreList` longtext NOT NULL default '',
`Ammo` int(10) unsigned NOT NULL default '0',
`stable_slots` int(11) NOT NULL default '0',
`resting` int(11) NOT NULL default '0',
`rested_bonus` int(11) NOT NULL default '0',
`talents` longtext NOT NULL default '',
PRIMARY KEY (`guid`)
) ;
I added the text default '' at the end of some of the fileds the emu complained about and this resolved the problem. I was able to create characters and log in.
Going to have a mess around and see how much of the game world works.
Enjoy,
Fz