Upravil jsem data co se vkládají do DB, core jsem neupravil, jenom je možnost přidat char ručně..
SQL:
INSERT INTO `characters` (guid,account,`name`, race,class,gender,`level`,xp,money, playerBytes,playerBytes2,playerFlags,map, dungeon_difficulty, position_x, position_y, position_z, orientation, taximask, online, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, death_expire_time, taxi_path, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk, health, power1, power2, power3, power4, power5, power6, power7, specCount, activeSpec, ammoId, exploredZones, equipmentCache, knownTitles, actionBars) VALUES
(2, 1, 'Wlkwlezley', 5, 8, 0, 1, 0, 100000, 33621508, 33554444, 0, 0, 0, 1676, 1677, 122, 0, '1024 0 0 4 0 0 0 0 0 0 0 0 ', 0, 0, 0, 0, 0, 1273337208, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 32, 85, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 4294967295, 0, 62, 135, 0, 0, 100, 0, 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ', '0 0 0 0 0 0 0 0 6140 0 0 0 1395 0 55 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 35 0 0 0 0 0 0 ', '0 0 0 0 0 0 ',0);
Upravte si to podle sebe, já to budu dál nějak vyvíjet.
EDIT: WORGEN (bez spellů, vytvořen z podle undeada/mage - je to blbost, vím o tom..)
insert into `characters`(`guid`,`account`,`name`,`race`,`class`,`gender`,`level`,`xp`,`money`,`playerBytes`,`playerBytes2`,`playerFlags`,`position_x`,`position_y`,`position_z`,`map`,`dungeon_difficulty`,`orientation`,`taximask`,`online`,`cinematic`,`totaltime`,`leveltime`,`logout_time`,`is_logout_resting`,`rest_bonus`,`resettalents_cost`,`resettalents_time`,`trans_x`,`trans_y`,`trans_z`,`trans_o`,`transguid`,`extra_flags`,`stable_slots`,`at_login`,`zone`,`death_expire_time`,`taxi_path`,`arenaPoints`,`totalHonorPoints`,`todayHonorPoints`,`yesterdayHonorPoints`,`totalKills`,`todayKills`,`yesterdayKills`,`chosenTitle`,`knownCurrencies`,`watchedFaction`,`drunk`,`health`,`power1`,`power2`,`power3`,`power4`,`power5`,`power6`,`power7`,`specCount`,`activeSpec`,`exploredZones`,`equipmentCache`,`ammoId`,`knownTitles`,`actionBars`,`deleteInfos_Account`,`deleteInfos_Name`,`deleteDate`) values
(2,1,'Wlkwlezley',22,8,0,1,0,100000,33621508,33554444,0,1676,1677,122,0,0,0,'1024 0 0 4 0 0 0 0 0 0 0 0 ',0,0,0,0,1273337208,0,0,0,0,0,0,0,0,0,2,0,32,85,0,'',0,0,0,0,0,0,0,0,0,4294967295,0,62,135,0,0,100,0,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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ','0 0 0 0 0 0 0 0 6140 0 0 0 1395 0 55 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 35 0 0 0 0 0 0 ',0,'0 0 0 0 0 0 ',0,NULL,NULL,NULL);
Je důležité nahrát data z prvního postu do DB, jinak to nefunguje!
Musím opravit core, aby to ukládalo správně ty data, jinak se zblázním (nic to neukládá, proto to padá po času, kdy se mají ukládat všechny postavy (mě třeba i příkaz .save vyvolá crash)