2021.02.9 NPCBOT的几个关键表格

CREATE TABLE `creature_template_npcbot_appearance` (
`entry` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,//唯一标示
`name*` char(16) DEFAULT 'unk' COMMENT 'unused',//名称
`gender` tinyint(3) unsigned NOT NULL DEFAULT '0',//性别
`skin` tinyint(3) unsigned NOT NULL DEFAULT '0',//皮肤
`face` tinyint(3) unsigned NOT NULL DEFAULT '0',//脸型
`hair` tinyint(3) unsigned NOT NULL DEFAULT '0',//发型
`haircolor` tinyint(3) unsigned NOT NULL DEFAULT '0',//头发颜色
`features` tinyint(3) unsigned NOT NULL DEFAULT '0',//其他特性
PRIMARY KEY (`entry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

CREATE TABLE `creature_template_npcbot_extras` (
`entry` mediumint(8) unsigned NOT NULL,//唯一标示
`class` tinyint(3) unsigned NOT NULL DEFAULT '1',//职业
`race` tinyint(3) unsigned NOT NULL DEFAULT '1',//种族
PRIMARY KEY (`entry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

creature_equip_template

INSERT INTO `creature_equip_template` (`CreatureID`,`ID`,`itemID1`,`itemID2`,`itemID3`,`VerifiedBuild`) //设置NPCBOT初始的武器

 

//BOTGiver

INSERT INTO `creature_template`
(`entry`,`difficulty_entry_1`,`difficulty_entry_2`,`difficulty_entry_3`,`KillCredit1`,`KillCredit2`,
`modelid1`,`modelid2`,`modelid3`,`modelid4`,`name`,`subname`,`IconName`,`gossip_menu_id`,`minlevel`,`maxlevel`,`exp`,
`faction`,`npcflag`,`speed_walk`,`speed_run`,`scale`,`rank`,`dmgschool`,`BaseAttackTime`,`RangeAttackTime`,
`BaseVariance`,`RangeVariance`,`unit_class`,`unit_flags`,`unit_flags2`,`dynamicflags`,`family`,`type`,`type_flags`,`lootid`,
`pickpocketloot`,`skinloot`,`PetSpellDataId`,`VehicleId`,`mingold`,`maxgold`,`AIName`,`MovementType`,
`HoverHeight`,`HealthModifier`,`ManaModifier`,`ArmorModifier`,`DamageModifier`,`ExperienceModifier`,`RacialLeader`,`movementId`,`RegenHealth`,
`mechanic_immune_mask`,`spell_school_immune_mask`,`flags_extra`,`ScriptName`,`VerifiedBuild`)
VALUES
('70000','0','0','0','0','0','27541','0','0','0','Lagretta','Bots for hire','','0','83','83','2','35','1','1.4','1.14286','0.7','4','0','0','0','1','1','1','33088','2048','0','0','0','0','0','0','0','0','0','0','0','','0','1','4.8','1','1','1','1','0','0','1','0','0','0','script_bot_giver','-1');

 

 

//