mangos 汉化,保留人物数据,加传送师数据库完整版

以前发过帖子,写怎么来做这个,但是可能好多人都懒得做,或者也有不会写的,这里好事做到底,方便大家吧!也让mangos的数据库能百花齐放:
操作步骤:
  将原来的数据库改名,这里举例改为mangos1118(请自己换),新建空库mangos,下载mangos SDB数据库最新完整版导入,并打上可能的更新补丁,然后就可以用如下操作了:
(以下内容支持最新2666,当然一般都不用更改,如果creature,creature_template结构变化之后请作相应更新)

1.保留人物数据下面的内容粘帖进文本文件改名为save.sql,导入方法我这里不说了)

TRUNCATE `character`;
TRUNCATE `character_action`;
TRUNCATE `character_aura`;
TRUNCATE `character_homebind`;
TRUNCATE `character_inventory`;
TRUNCATE `character_kill`;
TRUNCATE `character_pet`;
TRUNCATE `character_queststatus`;
TRUNCATE `character_reputation`;
TRUNCATE `character_social`;
TRUNCATE `character_spell`;
TRUNCATE `character_spell_cooldown`;
TRUNCATE `character_stable`;
TRUNCATE `character_ticket`;
TRUNCATE `character_tutorial`;
TRUNCATE `item_instance`;

insert into `character` select * from mangos1118.`character`;
insert into `character_action` select * from mangos1118.`character_action`;
insert into `character_aura` select * from mangos1118.`character_aura`;
insert into `character_homebind` select * from mangos1118.`character_homebind`;
insert into `character_inventory` select * from mangos1118.`character_inventory`;
insert into `character_kill` select * from mangos1118.`character_kill`;
insert into `character_pet` select * from mangos1118.`character_pet`;
insert into `character_queststatus` select * from mangos1118.`character_queststatus`;
insert into `character_reputation` select * from mangos1118.`character_reputation`;
insert into `character_social` select * from mangos1118.`character_social`;
insert into `character_spell` select * from mangos1118.`character_spell`;
insert into `character_spell_cooldown` select * from mangos1118.`character_spell_cooldown`;
insert into `character_stable` select * from mangos1118.`character_stable`;
insert into `character_ticket` select * from mangos1118.`character_ticket`;
insert into `character_tutorial` select * from mangos1118.`character_tutorial`;
insert into `item_instance` select * from mangos1118.`item_instance`;

2.从原来的库中提取数据进入汉化:下面的内容粘帖进文本文件改名为hh.sql,导入方法我这里不说了)

update mangos.areatrigger_template,mangos1118.areatrigger_template set mangos.areatrigger_template.name=mangos1118.areatrigger_template.name where mangos.areatrigger_template.id=mangos1118.areatrigger_template.id;

update mangos.creature_template,mangos1118.creature_template set mangos.creature_template.name=mangos1118.creature_template.name where mangos.creature_template.entry=mangos1118.creature_template.entry;

update mangos.creature_template,mangos1118.creature_template set mangos.creature_template.subname=mangos1118.creature_template.subname where mangos.creature_template.entry=mangos1118.creature_template.entry;

update mangos.gameobject_template,mangos1118.gameobject_template set mangos.gameobject_template.name=mangos1118.gameobject_template.name where mangos.gameobject_template.entry=mangos1118.gameobject_template.entry;

update mangos.item_template,mangos1118.item_template set mangos.item_template.name=mangos1118.item_template.name where mangos.item_template.entry=mangos1118.item_template.entry;

update mangos.item_template,mangos1118.item_template set mangos.item_template.name2=mangos1118.item_template.name2 where mangos.item_template.entry=mangos1118.item_template.entry;

update mangos.item_template,mangos1118.item_template set mangos.item_template.name3=mangos1118.item_template.name3 where mangos.item_template.entry=mangos1118.item_template.entry;

update mangos.item_template,mangos1118.item_template set mangos.item_template.name4=mangos1118.item_template.name4 where mangos.item_template.entry=mangos1118.item_template.entry;

update mangos.npc_option,mangos1118.npc_option set mangos.npc_option.option=mangos1118.npc_option.option where mangos.npc_option.id=mangos1118.npc_option.id;

update mangos.npc_text,mangos1118.npc_text set mangos.npc_text.text0_0 =mangos1118.npc_text.text0_0 where mangos.npc_text.id=mangos1118.npc_text.id;

update mangos.npc_text,mangos1118.npc_text set mangos.npc_text.text0_1 =mangos1118.npc_text.text0_1 where mangos.npc_text.id=mangos1118.npc_text.id;

update mangos.quest_template,mangos1118.quest_template set mangos.quest_template.title=mangos1118.quest_template.title where mangos.quest_template.entry=mangos1118.quest_template.entry;

update mangos.quest_template,mangos1118.quest_template set mangos.quest_template.details=mangos1118.quest_template.details where mangos.quest_template.entry=mangos1118.quest_template.entry;

update mangos.quest_template,mangos1118.quest_template set mangos.quest_template.Objectives=mangos1118.quest_template.Objectives where mangos.quest_template.entry=mangos1118.quest_template.entry;

3.新库里面是没有传送师的,所以下面的数据导入加入传送师,取自990100的数据库:
INSERT INTO `creature_template` (`entry`, `modelid_m`, `modelid_f`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `mount`, `dynamicflags`, `size`, `family`, `bounding_radius`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `combat_reach`, `type`, `civilian`, `flag1`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `equipinfo1`, `equipinfo2`, `equipinfo3`, `equipslot1`, `equipslot2`, `equipslot3`, `lootid`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `ScriptName`) VALUES (99999, 14946, 0, '????', '?????', 1, 1, 304087, 334496, 999, 999, 5000, 1080, 65, 1.23, 0, 2, 2, 100, 100, 100, 0, 0, 0, 1, 0, 0.51, 0, 0, 0, 0, 1000, 2000, 100, 2, 7, 1, 0, 22802, 0, 0, 218171138, 234948100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 'npc_teler');

INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimemin`, `spawntimemax`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `respawntimer`, `state`, `npcflags`, `faction`, `MovementType`, `auras`) VALUES
(187195, 99999, 0, -5045.65, -817.718, 495.132, 0.702927, 25000, 25000, 0, 0, -5045.65, -817.718, 495.132, 0, 99990, 9999, 0, 0, 65, 1080, 0, ''),
(187090, 99999, 1, 9968.89, 2065.28, 1328.9, 3.89558, 25000, 25000, 0, 0, 9968.89, 2065.28, 1328.9, 0, 99990, 100, 0, 0, 65, 1080, 0, ''),
(187094, 99999, 1, 1334.44, -4398.5, 27.9064, 1.65327, 25000, 25000, 0, 0, 1334.44, -4398.5, 27.9064, 0, 99990, 100, 0, 0, 65, 1080, 0, ''),
(187193, 99999, 1, -1301.75, 136.068, 131.404, 2.05775, 25000, 25000, 0, 0, -1301.75, 136.068, 131.404, 0, 99990, 9999, 0, 0, 65, 1080, 0, ''),
(187102, 99999, 0, 1916.55, 251.274, 51.4951, 5.10509, 25000, 25000, 0, 0, 1916.55, 251.274, 51.4951, 0, 99990, 100, 0, 0, 65, 1080, 0, ''),
(187106, 99999, 1, -966.797, -3780.81, 5.59356, 2.57733, 25000, 25000, 0, 0, -966.797, -3780.81, 5.59356, 0, 99990, 100, 0, 0, 65, 1080, 0, ''),
(187192, 99999, 1, 10312.3, 840.66, 1327.66, 5.39569, 25000, 25000, 0, 0, 10312.3, 840.66, 1327.66, 0, 99990, 9999, 0, 0, 65, 1080, 0, ''),
(187110, 99999, 0, -14302.4, 535.154, 8.66335, 5.91798, 25000, 25000, 0, 0, -14302.4, 535.154, 8.66335, 0, 99990, 100, 0, 0, 65, 1080, 0, ''),
(187191, 99999, 169, -2038.78, -1063.4, 124.299, 3.74738, 25000, 25000, 0, 0, -2038.78, -1063.4, 124.299, 0, 99990, 9999, 0, 0, 65, 1080, 0, ''),
(187203, 99999, 0, -8847.39, 488.338, 109.598, 0.671513, 25000, 25000, 0, 0, -8847.39, 488.338, 109.598, 0, 99990, 99990, 0, 0, 65, 1080, 0, ''),
(187205, 99999, 0, -6219.9, 343.143, 383.14, 3.05128, 25000, 25000, 0, 0, -6219.9, 343.143, 383.14, 0, 99990, 99990, 0, 0, 65, 1080, 0, ''),
(187216, 99999, 0, -8931.27, -108.552, 83.0799, 4.44104, 25000, 25000, 0, 0, -8931.27, -108.552, 83.0799, 0, 99990, 99990, 0, 0, 65, 1080, 0, ''),
(187219, 99999, 1, -2909.14, -276.073, 53.9165, 1.44513, 25000, 25000, 0, 0, -2909.14, -276.073, 53.9165, 0, 99990, 99990, 0, 0, 65, 1080, 0, ''),
(187220, 99999, 1, -641.357, -4265.81, 38.8264, 0.530144, 25000, 25000, 0, 0, -641.357, -4265.81, 38.8264, 0, 99990, 99990, 0, 0, 65, 1080, 0, ''),
(187259, 99999, 0, -9060.9, 415.793, 93.2968, 2.23315, 25000, 25000, 0, 0, -9060.9, 415.793, 93.2968, 0, 99990, 99990, 0, 0, 65, 1080, 0, ''); 商业版发布站程序下载：www.98youx.com商业版发布站程序下载：www.98youx.com