The Grand Melee and Among the Champions

These quest are bugged in revision 582 Trinity 11043

Quests are:
http://www.wowhead.com/search?q=among+the+champions
http://www.wowhead.com/search?q=The+Grand+Melee

These quests are important for Argent Tournament - without these quests it is not a Tournament. Maybe fixing these with smart AI functions? These quests should somehow share the same system. Thank you.

Still no helpe here?

[NeatElves]

id npc ?

For quests http://www.wowhead.com/search?q=The+...quests:0-4+1+2

NPC for alliance: 33562, 33561, 33564, 33558, 33559
NPC gor horde: 33384, 33383, 33382, 33285, 33306


http://www.wowhead.com/search?q=among+the+champions

NPC for alliance: 33740, 33743, 33747, 33738, 33739
NPC gor horde: 33749, 33745, 33744, 33748, 33746

But these should be able for both sides I think in quest Among the Champions you can challange any NPC from big circle so all:

IDs: 33740, 33743, 33747, 33738, 33739, 33749, 33745, 33744, 33748, 33746

[NeatElves]

Vol1, http://www.wowhead.com/search?q=The+...quests:0-4+1+2 - test))

REPLACE INTO `gossip_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES
(10464, 0, 0, 0, 0, 0, 0, 4, 2000000449, 2000000450, 2000000451, 0, 0, 0, 0, 0, ''),
(10464, 1, 15, 39996, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(10465, 0, 0, 0, 0, 0, 0, 4, 2000000449, 2000000450, 2000000451, 0, 0, 0, 0, 0, ''),
(10465, 1, 15, 39996, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(10466, 0, 0, 0, 0, 0, 0, 4, 2000000449, 2000000450, 2000000451, 0, 0, 0, 0, 0, ''),
(10466, 1, 15, 39996, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(10467, 0, 0, 0, 0, 0, 0, 4, 2000000449, 2000000450, 2000000451, 0, 0, 0, 0, 0, ''),
(10467, 1, 15, 39996, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(10468, 0, 0, 0, 0, 0, 0, 4, 2000000449, 2000000450, 2000000451, 0, 0, 0, 0, 0, ''),
(10468, 1, 15, 39996, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(10469, 0, 0, 0, 0, 0, 0, 4, 2000000449, 2000000450, 2000000451, 0, 0, 0, 0, 0, ''),
(10469, 1, 15, 39996, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(10470, 0, 0, 0, 0, 0, 0, 4, 2000000449, 2000000450, 2000000451, 0, 0, 0, 0, 0, ''),
(10470, 1, 15, 39996, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(10471, 0, 0, 0, 0, 0, 0, 4, 2000000449, 2000000450, 2000000451, 0, 0, 0, 0, 0, ''),
(10471, 1, 15, 39996, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(10472, 0, 0, 0, 0, 0, 0, 4, 2000000449, 2000000450, 2000000451, 0, 0, 0, 0, 0, ''),
(10472, 1, 15, 39996, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(10473, 0, 0, 0, 0, 0, 0, 4, 2000000449, 2000000450, 2000000451, 0, 0, 0, 0, 0, ''),
(10473, 1, 15, 39996, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
REPLACE INTO `db_script_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES
(2000000449, 'I yield to you.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2000000450, 'Prepare yourself!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2000000451, 'Let it begin!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
REPLACE INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`) VALUES
(10464, 0, 0, 'I am ready to fight!', 1, 1, -1, 0, 10464, 0, 0, NULL, 1, 62853, 0, 0, 0, 0, 0, 0, 0),
(10465, 0, 0, 'I am ready to fight!', 1, 1, -1, 0, 10465, 0, 0, NULL, 1, 62853, 0, 0, 0, 0, 0, 0, 0),
(10466, 0, 0, 'I am ready to fight!', 1, 1, -1, 0, 10466, 0, 0, NULL, 1, 62853, 0, 0, 0, 0, 0, 0, 0),
(10467, 0, 0, 'I am ready to fight!', 1, 1, -1, 0, 10467, 0, 0, NULL, 1, 62853, 0, 0, 0, 0, 0, 0, 0),
(10468, 0, 0, 'I am ready to fight!', 1, 1, -1, 0, 10468, 0, 0, NULL, 1, 62853, 0, 0, 0, 0, 0, 0, 0),
(10469, 0, 0, 'I am ready to fight!', 1, 1, -1, 0, 10469, 0, 0, NULL, 1, 62853, 0, 0, 0, 0, 0, 0, 0),
(10470, 0, 0, 'I am ready to fight!', 1, 1, -1, 0, 10470, 0, 0, NULL, 1, 62853, 0, 0, 0, 0, 0, 0, 0),
(10471, 0, 0, 'I am ready to fight!', 1, 1, -1, 0, 10471, 0, 0, NULL, 1, 62853, 0, 0, 0, 0, 0, 0, 0),
(10472, 0, 0, 'I am ready to fight!', 1, 1, -1, 0, 10472, 0, 0, NULL, 1, 62853, 0, 0, 0, 0, 0, 0, 0),
(10473, 0, 0, 'I am ready to fight!', 1, 1, -1, 0, 10473, 0, 0, NULL, 1, 62853, 0, 0, 0, 0, 0, 0, 0);
REPLACE INTO `creature_ai_scripts` VALUES ('3356251', '33562', '8', '0', '100', '1', '39996', '-1', '5000', '5000', '13', '100', '6', '0', '2', '14', '0', '0', '0', '0', '0', '0', 'ytdb');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '33562';
REPLACE INTO `creature_ai_scripts` VALUES ('3356151', '33561', '8', '0', '100', '1', '39996', '-1', '5000', '5000', '13', '100', '6', '0', '2', '14', '0', '0', '0', '0', '0', '0', 'ytdb');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '33561';
REPLACE INTO `creature_ai_scripts` VALUES ('3356451', '33564', '8', '0', '100', '1', '39996', '-1', '5000', '5000', '13', '100', '6', '0', '2', '14', '0', '0', '0', '0', '0', '0', 'ytdb');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '33564';
REPLACE INTO `creature_ai_scripts` VALUES ('3355851', '33558', '8', '0', '100', '1', '39996', '-1', '5000', '5000', '13', '100', '6', '0', '2', '14', '0', '0', '0', '0', '0', '0', 'ytdb');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '33558';
REPLACE INTO `creature_ai_scripts` VALUES ('3355951', '33559', '8', '0', '100', '1', '39996', '-1', '5000', '5000', '13', '100', '6', '0', '2', '14', '0', '0', '0', '0', '0', '0', 'ytdb');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '33559';
REPLACE INTO `creature_ai_scripts` VALUES ('3338451', '33384', '8', '0', '100', '1', '39996', '-1', '5000', '5000', '13', '100', '6', '0', '2', '14', '0', '0', '0', '0', '0', '0', 'ytdb');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '33384';
REPLACE INTO `creature_ai_scripts` VALUES ('3338351', '33383', '8', '0', '100', '1', '39996', '-1', '5000', '5000', '13', '100', '6', '0', '2', '14', '0', '0', '0', '0', '0', '0', 'ytdb');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '33383';
REPLACE INTO `creature_ai_scripts` VALUES ('3338251', '33382', '8', '0', '100', '1', '39996', '-1', '5000', '5000', '13', '100', '6', '0', '2', '14', '0', '0', '0', '0', '0', '0', 'ytdb');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '33382';
REPLACE INTO `creature_ai_scripts` VALUES ('3328551', '33285', '8', '0', '100', '1', '39996', '-1', '5000', '5000', '13', '100', '6', '0', '2', '14', '0', '0', '0', '0', '0', '0', 'ytdb');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '33285';
REPLACE INTO `creature_ai_scripts` VALUES ('3330651', '33306', '8', '0', '100', '1', '39996', '-1', '5000', '5000', '13', '100', '6', '0', '2', '14', '0', '0', '0', '0', '0', '0', 'ytdb');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '33306';
REPLACE INTO `creature_ai_texts` VALUES ('-335621', 'I have been defeated. Good fight!', '', '', '', '', '', '', '', '', '0', '0', '0', '0', 'ytdb');
REPLACE INTO `creature_ai_scripts` VALUES ('3356252', '33562', '2', '0', '100', '1', '2', '1', '0', '0', '1', '-335621', '0', '0', '2', '35', '0', '0', '11', '62724', '6', '6', 'ytdb');
REPLACE INTO `creature_ai_scripts` VALUES ('3356152', '33561', '2', '0', '100', '1', '2', '1', '0', '0', '1', '-335621', '0', '0', '2', '35', '0', '0', '11', '62724', '6', '6', 'ytdb');
REPLACE INTO `creature_ai_scripts` VALUES ('3356452', '33564', '2', '0', '100', '1', '2', '1', '0', '0', '1', '-335621', '0', '0', '2', '35', '0', '0', '11', '62724', '6', '6', 'ytdb');
REPLACE INTO `creature_ai_scripts` VALUES ('3355852', '33558', '2', '0', '100', '1', '2', '1', '0', '0', '1', '-335621', '0', '0', '2', '35', '0', '0', '11', '62724', '6', '6', 'ytdb');
REPLACE INTO `creature_ai_scripts` VALUES ('3355952', '33559', '2', '0', '100', '1', '2', '1', '0', '0', '1', '-335621', '0', '0', '2', '35', '0', '0', '11', '62724', '6', '6', 'ytdb');
REPLACE INTO `creature_ai_scripts` VALUES ('3338452', '33384', '2', '0', '100', '1', '2', '1', '0', '0', '1', '-335621', '0', '0', '2', '35', '0', '0', '11', '62724', '6', '6', 'ytdb');
REPLACE INTO `creature_ai_scripts` VALUES ('3338352', '33383', '2', '0', '100', '1', '2', '1', '0', '0', '1', '-335621', '0', '0', '2', '35', '0', '0', '11', '62724', '6', '6', 'ytdb');
REPLACE INTO `creature_ai_scripts` VALUES ('3338252', '33382', '2', '0', '100', '1', '2', '1', '0', '0', '1', '-335621', '0', '0', '2', '35', '0', '0', '11', '62724', '6', '6', 'ytdb');
REPLACE INTO `creature_ai_scripts` VALUES ('3328552', '33285', '2', '0', '100', '1', '2', '1', '0', '0', '1', '-335621', '0', '0', '2', '35', '0', '0', '11', '62724', '6', '6', 'ytdb');
REPLACE INTO `creature_ai_scripts` VALUES ('3330652', '33306', '2', '0', '100', '1', '2', '1', '0', '0', '1', '-335621', '0', '0', '2', '35', '0', '0', '11', '62724', '6', '6', 'ytdb');

Thank you - will test but after it will be for Trinity DB :-)

[NeatElves]

For test -> condition you can temporarily throw, interested in the text, agro and the final fight)

`cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`

There are many more such as
Unknown column 'datalong3' in 'field list'

Добавлено через 1 час 37 минут
I will just wait for trinity version for sure to test it without my mistakes ...

[NeatElves]

Hack spell 39996 not work, need script sd2...(

[YuruY]

Дак удалять тогда надо .))

I have tested with 583 on trinity and still it does not work either ...

When you challange NPC (which are not all only some of them) they attack you and at the end they turn to "green" flag and you can not attack but NPC is still attacking and saying I was defeted as long as NPC has agro on you ...

[YuruY]

Need scripts.

[NeatElves]

2 gibatul

UPDATE `creature_ai_scripts` SET `action2_type` = '41',`action2_param1` = '1000' WHERE `id` =3338352;
UPDATE `creature_ai_scripts` SET `action2_type` = '41',`action2_param1` = '1000' WHERE `id` =3330652;
UPDATE `creature_ai_scripts` SET `action2_type` = '41',`action2_param1` = '1000' WHERE `id` =3328552;
UPDATE `creature_ai_scripts` SET `action2_type` = '41',`action2_param1` = '1000' WHERE `id` =3355952;
UPDATE `creature_ai_scripts` SET `action2_type` = '41',`action2_param1` = '1000' WHERE `id` =3338252;
UPDATE `creature_ai_scripts` SET `action2_type` = '41',`action2_param1` = '1000' WHERE `id` =3356252;
UPDATE `creature_ai_scripts` SET `action2_type` = '41',`action2_param1` = '1000' WHERE `id` =3338452;
UPDATE `creature_ai_scripts` SET `action2_type` = '41',`action2_param1` = '1000' WHERE `id` =3355852;
UPDATE `creature_ai_scripts` SET `action2_type` = '41',`action2_param1` = '1000' WHERE `id` =3356452;
UPDATE `creature_ai_scripts` SET `action2_type` = '41',`action2_param1` = '1000' WHERE `id` =3356152;

Maybe using smart script from trinity would be better also for receiving quest items?

What will be the script if I would use item directly not with spell? Thank you.

[NeatElves]

http://www.youtube.com/watch?v=G8ZHhBiNJ4w&f=22

Yes this should be possible to sctipt with Smart AI from trinity maybe convert thiss script i have found here http://pastebin.com/31KiYpeB

When I change 62724 to 62770 - it is working so can you make similar script for http://www.wowhead.com/search?q=among+the+champions and ids:
33740, 33743, 33747, 33738, 33739, 33749, 33745, 33744, 33748, 33746

Thank you.