PDA

Просмотр полной версии : The Grand Melee and Among the Champions

gibatul
01.02.2011, 08:50
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.
gibatul
02.02.2011, 19:10
Still no helpe here?
NeatElves
02.02.2011, 19:31
id npc ?
gibatul
03.02.2011, 19:24
For quests http://www.wowhead.com/search?q=The+Grand+Melee#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
03.02.2011, 21:24
Vol1, http://www.wowhead.com/search?q=The+Grand+Melee#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');
gibatul
03.02.2011, 22:24
Thank you - will test but after it will be for Trinity DB :-)
NeatElves
03.02.2011, 23:31
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`
gibatul
04.02.2011, 01:19
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
04.02.2011, 18:18
Hack spell 39996 not work, need script sd2...(
YuruY
04.02.2011, 18:37
Дак удалять тогда надо .))
gibatul
04.02.2011, 20:24
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
04.02.2011, 21:02
Need scripts.
NeatElves
05.02.2011, 11:16
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;
gibatul
05.02.2011, 17:11
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
06.02.2011, 14:48
http://www.youtube.com/watch?v=G8ZHhBiNJ4w&f=22
gibatul
06.02.2011, 15:06
Yes this should be possible to sctipt with Smart AI from trinity maybe convert thiss script i have found here http://pastebin.com/31KiYpeB
gibatul
08.02.2011, 04:53
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.