魔兽世界私服单机版：让所有职业出生就带BB宠物

首先你要学会一些召唤技能，否则要出错
就用召唤小鬼吧
出生得带几个技能

.learn 688 召唤小鬼

.learn 24394  召唤宠物  

.learn 982  复活宠物  

.learn 2641 解散野兽

其他技能需求，你可以到魔兽世界数据库网站去查查，或则直接在游戏里面查查也行


然后执行下面的SQL代码。让SQL导入到你的魔兽世界数据库中

insert into playercreateinfo_spell values('0','6','spellid','spellname');

insert into playercreateinfo_spell values('0','7','spellid','spellname');

insert into playercreateinfo_spell values('0','9','spellid','spellname');

insert into playercreateinfo_spell values('1','1','spellid','spellname');

insert into playercreateinfo_spell values('1','2','spellid','spellname');

insert into playercreateinfo_spell values('1','4','spellid','spellname');

insert into playercreateinfo_spell values('1','5','spellid','spellname');

insert into playercreateinfo_spell values('1','6','spellid','spellname');

insert into playercreateinfo_spell values('1','8','spellid','spellname');

insert into playercreateinfo_spell values('1','9','spellid','spellname');

insert into playercreateinfo_spell values('2','1','spellid','spellname');

insert into playercreateinfo_spell values('2','3','spellid','spellname');

insert into playercreateinfo_spell values('2','4','spellid','spellname');

insert into playercreateinfo_spell values('2','6','spellid','spellname');

insert into playercreateinfo_spell values('2','7','spellid','spellname');

insert into playercreateinfo_spell values('2','9','spellid','spellname');

insert into playercreateinfo_spell values('3','1','spellid','spellname');

insert into playercreateinfo_spell values('3','2','spellid','spellname');

insert into playercreateinfo_spell values('3','3','spellid','spellname');

insert into playercreateinfo_spell values('3','4','spellid','spellname');

insert into playercreateinfo_spell values('3','5','spellid','spellname');

insert into playercreateinfo_spell values('3','6','spellid','spellname');

insert into playercreateinfo_spell values('4','1','spellid','spellname');

insert into playercreateinfo_spell values('4','3','spellid','spellname');

insert into playercreateinfo_spell values('4','4','spellid','spellname');

insert into playercreateinfo_spell values('4','5','spellid','spellname');

insert into playercreateinfo_spell values('4','6','spellid','spellname');

insert into playercreateinfo_spell values('4','11','spellid','spellname');

insert into playercreateinfo_spell values('5','1','spellid','spellname');

insert into playercreateinfo_spell values('5','4','spellid','spellname');

insert into playercreateinfo_spell values('5','5','spellid','spellname');

insert into playercreateinfo_spell values('5','6','spellid','spellname');

insert into playercreateinfo_spell values('5','8','spellid','spellname');

insert into playercreateinfo_spell values('5','9','spellid','spellname');

insert into playercreateinfo_spell values('6','1','spellid','spellname');

insert into playercreateinfo_spell values('6','3','spellid','spellname');

insert into playercreateinfo_spell values('6','6','spellid','spellname');

insert into playercreateinfo_spell values('6','7','spellid','spellname');

insert into playercreateinfo_spell values('6','11','spellid','spellname');

insert into playercreateinfo_spell values('7','1','spellid','spellname');

insert into playercreateinfo_spell values('7','4','spellid','spellname');

insert into playercreateinfo_spell values('7','6','spellid','spellname');

insert into playercreateinfo_spell values('7','8','spellid','spellname');

insert into playercreateinfo_spell values('7','9','spellid','spellname');

insert into playercreateinfo_spell values('8','1','spellid','spellname');

insert into playercreateinfo_spell values('8','3','spellid','spellname');

insert into playercreateinfo_spell values('8','4','spellid','spellname');

insert into playercreateinfo_spell values('8','5','spellid','spellname');

insert into playercreateinfo_spell values('8','6','spellid','spellname');

insert into playercreateinfo_spell values('8','7','spellid','spellname');

insert into playercreateinfo_spell values('8','8','spellid','spellname');

insert into playercreateinfo_spell values('10','2','spellid','spellname');

insert into playercreateinfo_spell values('10','3','spellid','spellname');

insert into playercreateinfo_spell values('10','4','spellid','spellname');

insert into playercreateinfo_spell values('10','5','spellid','spellname');

insert into playercreateinfo_spell values('10','6','spellid','spellname');

insert into playercreateinfo_spell values('10','8','spellid','spellname');

insert into playercreateinfo_spell values('10','9','spellid','spellname');

insert into playercreateinfo_spell values('11','1','spellid','spellname');

insert into playercreateinfo_spell values('11','2','spellid','spellname');

insert into playercreateinfo_spell values('11','3','spellid','spellname');

insert into playercreateinfo_spell values('11','5','spellid','spellname');

insert into playercreateinfo_spell values('11','6','spellid','spellname');

insert into playercreateinfo_spell values('11','7','spellid','spellname');

insert into playercreateinfo_spell values('11','8','spellid','spellname');


然后是修改小鬼对应的技能和模型，对应技能spell1-spell8,有前四个就够了，可以自己修改，还可以改出一些BOSS技能，法术ID自己查吧。

执行下边这条SQL就行了，我用的模型是熊（改成过蛋蛋二阶，太大了，挡视野）。


REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `vehicle_id`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (416, 0, 0, 0, 0, 0, 27821, 0, 0, 0, '装甲棕熊', '', '', 0, 70, 70, 4050, 4050, 0, 0, 6719, 14, 14, 0, 3, 1.38571, 1, 0, 252, 357, 0, 304, 1, 2000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 215, 320, 44, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 26064, 23931, 39270, 23040, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 140, 1, 0, 0, 0, 0, 0, 0, '');


其中39270无CD低吼是10级以后才会自出来的.


至于改BB的属性如下，数字就是倍数，改太多会超过最大值（库表定义时有限制，要么就是mysql只支持那么点，不细究了）。

update player_levelstats set str = str*5,

agi = agi*2,

sta = sta*2,

inte = inte*2,

spi = spi*2 where creature_entry=416;

现在重启服务器，进游戏创建人物使用召唤小鬼，你的BB就出来了。