+- For-rum 3server.cz (http://for-rum.3server.cz)
+-- Forum: TEAM ONLY (http://for-rum.3server.cz/forumdisplay.php?fid=4)
+--- Forum: SQL (http://for-rum.3server.cz/forumdisplay.php?fid=6)
+---- Forum: Solved (http://for-rum.3server.cz/forumdisplay.php?fid=10)
+---- Thread: Repair NPC ID 26793 combat bug in Nexus (/showthread.php?tid=54)
Repair NPC ID 26793 combat bug in Nexus - Hendy - 12-27-2018
NPC Name = Crystalline Frayer
Update Data
UPDATE `newlive_world`.`creature_template `unit_flags` = '32832' , ` SET `type_flags` = '8' , `AIName` = 'AggressorAI' , `movementId` = '1' WHERE `entry` = '26793';
RE: Repair NPC ID 26793 combat bug in Nexus - mirra - 12-27-2018
UPDATE newlive_world.`creature_template` SET unit_flags = '32832' WHERE entry = '26793';
UPDATE newlive_world.`creature_template` SET type_flags = '64' WHERE entry = '26793';
2 queries executed, 2 success, 0 errors, 0 warnings
Query: UPDATE newlive_world.`creature_template` SET unit_flags = '32832' WHERE entry = '26793'
1 row(s) affected
Execution Time : 0.197 sec
Transfer Time : 0 sec
Total Time : 0.198 sec
--------------------------------------------------
Query: UPDATE newlive_world.`creature_template` SET type_flags = '64' WHERE entry = '26793'
1 row(s) affected
Execution Time : 0.266 sec
Transfer Time : 0 sec
Total Time : 0.266 sec
Prošlo. GUT!
RE: Repair NPC ID 26793 combat bug in Nexus - Hendy - 01-02-2019
na LIVE nefungují takže to sem dám celé.
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`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `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`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) values('26793','30528','0','0','0','0','25570','0','0','0','Crystalline Frayer','','','0','71','71','2','16','0','1','1.14286','1','0','299','426','0','308','1','2000','0','1','32832','2048','8','0','0','0','0','0','262','389','48','4','8','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','AggressorAI','0','3','1','0.376709','1','1','0','0','0','0','0','0','0','1','1','0','0','','12340');
RE: Repair NPC ID 26793 combat bug in Nexus - leo - 01-02-2019
@Mirra
Zmeň INSERT INTO na REPLACE INTO
Inak schválené