habe heute mal einen ArcEmu 3.3.2 Testserver erstellt.
Wenn ich mich jetzt einlogge hab ich folgende Probleme.
1.) Mein Skillfenster ist leer.
2.) Egal was ich schreibe, ich kann die Sprache angeblich nicht sprechen (siehe Punkt 1)
Server:
- WhyDB (getestet auch mit ifdb)
- letzte ArcEmu Rev
- 3.3.2er Client
Wie im Sql-Dump zu sehen ist, kann der Chars ja die verschiedenen Spells/Skills.
Sql-Dump meines Testchars:
Code:
CREATE TABLE `characters` ( `guid` int(6) unsigned NOT NULL default '0', `acct` int(20) unsigned NOT NULL default '0', `name` varchar(21) NOT NULL default '', `race` smallint(3) NOT NULL, `class` smallint(3) NOT NULL, `gender` tinyint(1) NOT NULL, `custom_faction` int(30) NOT NULL default '0', `level` int(3) NOT NULL, `xp` int(30) NOT NULL, `active_cheats` int(10) unsigned NOT NULL default '0', `exploration_data` longtext NOT NULL, `skills` longtext NOT NULL, `watched_faction_index` bigint(40) NOT NULL, `selected_pvp_title` int(30) NOT NULL, `available_pvp_titles` bigint(10) unsigned NOT NULL default '0', `available_pvp_titles1` bigint(10) NOT NULL, `gold` int(30) NOT NULL, `ammo_id` int(30) NOT NULL, `available_prof_points` int(30) NOT NULL, `current_hp` int(30) NOT NULL, `current_power` int(30) NOT NULL, `pvprank` int(30) NOT NULL, `bytes` int(30) NOT NULL, `bytes2` int(30) NOT NULL, `player_flags` int(30) NOT NULL, `player_bytes` int(30) NOT NULL, `positionX` float NOT NULL default '0', `positionY` float NOT NULL default '0', `positionZ` float NOT NULL default '0', `orientation` float NOT NULL default '0', `mapId` int(8) unsigned NOT NULL default '0', `zoneId` int(8) unsigned NOT NULL default '0', `taximask` longtext NOT NULL, `banned` int(40) unsigned NOT NULL default '0', `banReason` varchar(255) NOT NULL, `timestamp` int(30) default NULL, `online` int(11) default NULL, `bindpositionX` float NOT NULL default '0', `bindpositionY` float NOT NULL default '0', `bindpositionZ` float NOT NULL default '0', `bindmapId` int(8) unsigned NOT NULL default '0', `bindzoneId` int(8) unsigned NOT NULL default '0', `isResting` int(3) NOT NULL default '0', `restState` int(5) NOT NULL default '0', `restTime` int(5) NOT NULL default '0', `playedtime` text NOT NULL, `deathstate` int(5) NOT NULL default '0', `TalentResetTimes` int(5) NOT NULL default '0', `first_login` tinyint(1) NOT NULL default '0', `forced_rename_pending` tinyint(1) NOT NULL default '0', `arenaPoints` int(10) NOT NULL, `totalstableslots` int(10) unsigned NOT NULL default '0', `instance_id` int(10) NOT NULL, `entrypointmap` int(10) NOT NULL, `entrypointx` float NOT NULL, `entrypointy` float NOT NULL, `entrypointz` float NOT NULL, `entrypointo` float NOT NULL, `entrypointinstance` int(10) NOT NULL, `taxi_path` int(10) NOT NULL, `taxi_lastnode` int(10) NOT NULL, `taxi_mountid` int(10) NOT NULL, `transporter` int(10) NOT NULL, `transporter_xdiff` float NOT NULL, `transporter_ydiff` float NOT NULL, `transporter_zdiff` float NOT NULL, `spells` longtext NOT NULL, `deleted_spells` longtext NOT NULL, `reputation` longtext NOT NULL, `actions1` longtext NOT NULL, `actions2` longtext NOT NULL, `auras` longtext NOT NULL, `finished_quests` longtext NOT NULL, `finisheddailies` longtext NOT NULL, `honorRolloverTime` int(30) NOT NULL default '0', `killsToday` int(10) NOT NULL default '0', `killsYesterday` int(10) NOT NULL default '0', `killsLifeTime` int(10) NOT NULL default '0', `honorToday` int(10) NOT NULL default '0', `honorYesterday` int(10) NOT NULL default '0', `honorPoints` int(10) NOT NULL default '0', `difficulty` int(4) NOT NULL default '0', `drunkValue` int(30) NOT NULL default '0', `glyphs1` longtext NOT NULL, `talents1` longtext NOT NULL, `glyphs2` longtext NOT NULL, `talents2` longtext NOT NULL, `numspecs` int(10) NOT NULL default '1', `currentspec` int(10) NOT NULL default '0', `talentpoint_override` longtext NOT NULL, `phase` int(10) unsigned NOT NULL default '1', `CanGainXp` int(10) unsigned NOT NULL default '1', `data` longtext, PRIMARY KEY (`guid`), KEY `acct` (`acct`), KEY `name` (`name`), KEY `b` (`banned`), KEY `c` (`online`), KEY `d` (`forced_rename_pending`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of characters -- ---------------------------- INSERT INTO `characters` VALUES ('1', '390', 'Nooby', '11', '5', '0', '0', '1', '0', '0', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1073741824,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '54;1;5;56;1;1;78;1;1;95;1;5;136;1;5;142;1;1;162;1;5;173;1;5;183;1;1;226;1;5;228;1;5;415;1;1;613;1;1;760;5;5;769;1;1;', '4008636142', '0', '0', '0', '20000000', '0', '5', '51', '175', '0', '50661384', '33554435', '0', '8', '-3961.64', '-13931.2', '100.615', '0', '530', '3524', '0 0 536870912 0 0 0 0 0 0 0 0 0 ', '0', '', '1267620532', '0', '-3961.64', '-13931.2', '100.615', '530', '3524', '0', '2', '0', '56 56 55 ', '0', '0', '0', '0', '0', '0', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '81,198,203,204,522,585,668,669,670,671,672,813,2050,2382,2479,3018,3050,3127,3365,5009,5019,6233,6246,6247,6477,6478,6603,7266,7267,7341,7355,8386,9078,9125,17737,20579,21651,21652,22027,22810,28875,28878,28880,29932,', '', '21,64,500,500,46,4,0,0,47,17,3100,3100,54,17,3100,3100,59,16,0,0,67,14,-42000,-42000,68,6,-42000,-42000,69,17,3100,3100,70,2,-10000,-10000,72,17,3100,3100,76,6,-42000,-42000,81,6,-42000,-42000,83,4,2999,2999,86,4,2999,2999,87,2,-6500,-6500,92,2,2000,2000,93,2,2000,2000,169,12,500,500,270,16,0,0,289,4,0,0,349,0,0,0,369,64,500,500,469,25,3300,3300,470,64,500,500,471,20,150,150,509,16,0,0,510,2,-42000,-42000,529,0,200,200,530,6,-42000,-42000,549,4,2999,2999,550,4,2999,2999,551,4,2999,2999,569,4,0,0,570,4,0,0,571,4,0,0,574,4,0,0,576,2,-3500,-3500,577,64,500,500,589,0,0,0,609,0,0,0,729,2,-42000,-42000,730,16,0,0,749,0,0,0,809,16,0,0,889,6,-42000,-42000,890,16,0,0,891,24,0,0,909,16,0,0,910,0,-42000,-42000,911,6,-42000,-42000,922,6,-42000,-42000,930,17,4000,4000,932,80,3500,3500,933,16,0,0,934,80,-3500,-3500,935,16,0,0,936,28,0,0,941,6,-42000,-42000,942,16,0,0,946,16,0,0,947,0,-42000,-42000,948,8,0,0,949,24,0,0,952,0,0,0,967,16,0,0,970,0,-2500,-2500,978,16,-1200,-1200,989,16,0,0,990,16,0,0,1005,4,3000,3000,1011,16,0,0,1012,16,0,0,1015,2,-42000,-42000,1031,16,0,0,1037,136,0,0,1038,16,0,0,1050,16,0,0,1052,0,-42000,-42000,1064,6,-42000,-42000,1067,0,-42000,-42000,1068,16,0,0,1073,16,0,0,1077,16,0,0,1082,4,0,0,1085,6,-42000,-42000,1090,16,0,0,1091,16,0,0,1094,16,0,0,1098,16,0,0,1104,16,0,0,1105,16,0,0,1106,16,0,0,1117,12,0,0,1118,12,0,0,1119,0,-42000,-42000,1124,6,-42000,-42000,1126,16,0,0,1136,4,0,0,1137,4,0,0,1154,4,0,0,1155,4,0,0,1156,16,0,0,', '6603,0,0,585,0,0,2050,0,0,20577,0,0,2481,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,159,0,128,20857,0,128,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4540,0,128,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '', '', '', '7209021', '0', '0', '0', '0', '0', '0', '0', '0', '0,0,0,0,0,0,', '', '0,0,0,0,0,0,', '', '1', '0', '0 0', '1', '1', '');