mirror of
https://github.com/trickerer/Trinity-Bots
synced 2026-08-22 16:29:09 -04:00
1f07eae770
Drop 2013 version. Fix int16 overflow in item randomPropertyId saving. Add shell scripts for merging SQL files (kind of tested). Fix a mistake in `4_world_generate_bot_equips.sql`. Ref #88.
18 lines
1.6 KiB
SQL
18 lines
1.6 KiB
SQL
DELETE FROM `creature_template` WHERE `entry` = 70000;
|
|
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');
|
|
|
|
DELETE FROM `npc_text` WHERE `ID` BETWEEN 70201 AND 70204;
|
|
INSERT INTO `npc_text` (`ID`,`text0_0`,`VerifiedBuild`) VALUES
|
|
('70201','There are always dudes ready to kill for money.','-1'),
|
|
('70202','Mercenaries are always in demand. Here is what available right now.','-1'),
|
|
('70203','Mercenaries are always in demand. Here is what available right now.','-1'),
|
|
('70204','Seems like there is nobody available right now, check again later.','-1');
|