以前发过帖子,写怎么来做这个,但是可能好多人都懒得做,或者也有不会写的,这里好事做到底,方便大家

吧!也让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, ’’);