582 Bugs

[cyrex]

This is the console messages that were found using 581 and then 582 (About 4 hours of work cleaning up the messages)

SCRIPT_COMMAND_CAST_SPELL ('waypoint_scripts' script id: 784) no target unit found for spell 46400
SCRIPT_COMMAND_CAST_SPELL ('waypoint_scripts' script id: 784) no target unit found for spell 46400
SCRIPT_COMMAND_CAST_SPELL ('waypoint_scripts' script id: 784) no target unit found for spell 46400

when i go to Argent Tournament

I checked in waypoint_scripts with the id 784 and found this:

mysql> SELECT * FROM world.waypoint_scripts where id=784\G
*************************** 1. row ***************************
id: 784
delay: 0
command: 15
datalong: 46400
datalong2: 0
dataint: 0
x: 0
y: 0
z: 0
o: 0
guid: 1065


The other ones i get are:
Creature 95160 (Entry: 40405) have UNIT_NPC_FLAG_TRAINER but have empty trainer spell list.--Fixed by YuruY & NeatElves

CreatureEventAI: Event 2780851 ACTION_T_UPDATE_TEMPLATE call with param1 == current entry. Creature 27809
CreatureEventAI: Event 2712251 ACTION_T_UPDATE_TEMPLATE call with param1 == current entry. Creature 27807
CreatureEventAI: Event 2684151 ACTION_T_UPDATE_TEMPLATE call with param1 == current entry. Creature 27821-- Fixed by NeatElves

CreatureTextMgr: Could not find Text for Creature(Argent Skytalon) Entry 30228 in 'creature_text' table. Ignoring.
CreatureTextMgr: Could not find Text for Creature(Squirrel) Entry 1412 in 'creature_text' table. Ignoring.

SmartScript: Entry 30224 SourceType 0 Event 1 Action 80 is using TARGET_NONE(0) for Script9 target. Please correct target_type in database.
SmartScript: Entry 30377 SourceType 0 Event 1 Action 80 is using TARGET_NONE(0) for Script9 target. Please correct target_type in database.

Achievement system call ACHIEVEMENT_CRITERIA_DATA_INSTANCE_SCRIPT (18) for achievement criteria 1824 for non-dungeon/non-raid map 489
Achievement system call ACHIEVEMENT_CRITERIA_DATA_INSTANCE_SCRIPT (18) for achievement criteria 1237 for non-dungeon/non-raid map 529
Achievement system call ACHIEVEMENT_CRITERIA_DATA_INSTANCE_SCRIPT (18) for achievement criteria 1240 for non-dungeon/non-raid map 566

Achievement system call ACHIEVEMENT_CRITERIA_DATA_INSTANCE_SCRIPT (18) for achievement criteria 7182 for map 616 but map does not have a instance script
Achievement system call ACHIEVEMENT_CRITERIA_DATA_INSTANCE_SCRIPT (18) for achievement criteria 7183 for map 616 but map does not have a instance script


Fishable areaId 2597 are not properly defined in `skill_fishing_base_level`.NOTE: Fishing areaId SHOULD BE removed from Alterac Valley as pointed below in my Post.

Table 'fishing_loot_template' loot id #2597 used but it doesn't have records.NOTE: Fishing areaId SHOULD BE removed from Alterac Valley as pointed below in my Post.

NOTE - It took me almost 4 hours to remove of the spam messages that were together. This was the final ones that were left. This are the only ones that appear after 1 full week using 581 and then 582. Hope it helps cause it was hell for me.

[NeatElves]

zone 2597 - Alterac Valley - 2.1: Fishing ceases in battlegrounds.

UPDATE `creature_ai_scripts` SET `action1_param2` = '-1',`action2_type` = '0',`action2_param1` = '0' WHERE `id` =2780851;
UPDATE `creature_ai_scripts` SET `action1_param2` = '-1',`action2_type` = '0',`action2_param1` = '0' WHERE `id` =2712251;
UPDATE `creature_ai_scripts` SET `action1_param2` = '-1',`action2_type` = '0',`action2_param1` = '0' WHERE `id` =2684151;
UPDATE `creature_ai_scripts` SET `action1_param2` = '-1',`action2_type` = '11',`action2_param1` = '3019',`action3_type` = '0',`action3_param1` = '0' WHERE `id` =2077451;

[cyrex]

Excellent NeatElves. Am searching how to fix the other ones. For a 100% error free console.

[cyrex]

Just wanted to mention that i can finally login to ytdb but only at night. In the morning and afternoon i am blocked. But at least in the night i can login.

[YuruY]

Fishable areaId 2597 are not properly defined in `skill_fishing_base_level`.
http://ru.wowhead.com/zone=2597#fishing ..... :eek:

Creature 95160 (Entry: 40405) have UNIT_NPC_FLAG_TRAINER but have empty trainer spell list.
UPDATE `creature_template` SET `npcflag` = 1 WHERE `entry` = 40405;

ACHIEVEMENT_CRITERIA_DATA_INSTANCE_SCRIPT
Need scripts.

[NeatElves]

Creature 95160 (Entry: 40405) have UNIT_NPC_FLAG_TRAINER - & analog - pet trainer - gossip option:
(0, 15, 2, 'I wish to unlearn my pet''s skills', 17, 16, 0, 0, 0, 0, 0, '');

[cyrex]

About the Fishing in Alterac Valley: http://www.elsanglin.com/fish/alterac_valley.html

So it was removed many versions ago because players would fish instead of fight.

INSERT INTO fishing_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (2597, 13889, 10, 0, 1, 1);
INSERT INTO skill_fishing_base_level (2597, 330);


This will remove the console spam for errors AND will not deliver the fish that was fished there in patch 2.1 or below. I put 0% chance.

[YuruY]

CreatureTextMgr: Could not find Text for Creature(Argent Skytalon) Entry 30228 in 'creature_text' table. Ignoring.
CreatureTextMgr: Could not find Text for Creature(Squirrel) Entry 1412 in 'creature_text' table. Ignoring.
У первого скрипты без использования текста, у второго вообще скриптов в базе нет.

[schmoozerd]

"ACHIEVEMENT_CRITERIA_DATA_INSTANCE_SCRIPT "
Need scripts.
no :P

[cyrex]

No why?

[YuruY]

no :P

??????????????
http://udbwiki.no-ip.org/index.php/Achievement_criteria_requirement#type
18 TYPE_INSTANCE_SCRIPT

11 TYPE_DISABLED

Выключить это решить проблему?

[schmoozerd]

only achievement-criterias that must be checked by instance script, can have type18.
From short look over the posted criteria none of them are to be checked by instance script, so type18 is wrong for them.

[schmoozerd]

to be a bit more detailed:

'1237', '159', '1', '360', 'Win in 6 Min' <-- needs core support to start the timed event
'1240', '214', '1', '360', 'Win in 6 Min' <-- --------------- " ----------------
'1824', '204', '1', '0', 'Win in der WS (something related to 3 flags captured)' <-- research, but BGs aren't handled in sd2
'7182', '1874', '0', '360', 'Malygos' <-- timed achievement, will only need entry for heroid/normal
'7183', '1875', '0', '360', 'Malygos' <--- -------- " -----------

[cyrex]

ok but to solve it what would be needed.