[Lua-Release] Zul'Drak Arena Boss Scripts

[Kaidos]

[ Zul'Drak Arena Boss Scripts ]




Hi MMOwned!

This is my first Release in this Section.

It's an arena script for the Amphitheater of Anguish in Zul'drak!




[ DOWNLOAD ]

Version: 1.1

Filebeam - Free Fast File Hosting


* Death event update include

* all sql's include


[ Updates: ]

*1 To add the correct Sound and Chat Meesage if the Champion die, open the script with Editor and went to line 1017 and replace the Death Event with this:

function Champion_Death(pUnit, event)
 pUnit:RemoveEvents()
 pUnit:PlaySoundToSet(14156)
 pUnit:SendChatMessage(14,0,"How can it be...? Flesh is not... stronger!")
 Dargan:RegisterEvent("Dargan_Champion_yell", 100, 1)
end

[ Features: ]

* an over 1000 lines lua Script.

* Arenamaster to start fights

* Questgiver with quests to defeating the bosses

* Four different bosses and one Champion!

* Arenamaster anouncing fights




[ Video of one of the Bosses (Champion) ]

[Lua] Champion of the Zul'Drak Arena(Boss script) | Free SciFi & Fantasy Videos - Watch SciFi & Fantasy Videos Online | Veoh

(Sorry but youtube doesn't work, dunno why...)




[ Pictures ] (Wall of photos inc)















[ Bosses ]


* Firion -

Firion is a Giant.
He does a lightning nova with an emote and some strikes.
Also he can charge.


* Amanorum -

Amanorum is an arcane mage which transform into a dragon at 50% health.
He can do a flame breath and use mostly arcane spells.


* Stinkbeard -

Stinkbeard is an magnataur. (name and model like the real Zul'drak q-event)
He can use kick, thunderclap, a shock, stormstrike and stomp.
He enrage after 70 seconds.


* Orinoko -

Orinoko is an Tuskarr and have a pet called whisker. (name and model like the real Zul'drak q-event)
He can charge, aoe and melee strikes.
He enrage at 30% health. He also enrage, if you kill his pet.


* Varksun, Champion of the Amphitheater of Anguish -

Varksun is an Vrykul.
The fight against him, start with a little cinematic.
You must defeat 2 Storm giants and 2 protodrakes.
After that, you can attack Varksun itself.

Note: You can not pull only one of the adds, because this would cause a despawn and will reset the event.


Note 2: If Bosses stay 10 sec without any challenger in the arena, they will despawn. Also if they leave combat or all of you die.






[ How To: ]

*1. Right Click onto your world database and hit 'Console'

*2. Copy these lines into the Console and hit Enter:

creature_names and creature_proto:

INSERT INTO `creature_names` VALUES ('72340', 'Arenamaster Dargan', 'Anguish Arenamaster', '', '3', '7', '0', '3', '0', '0', '28127', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO `creature_names` VALUES ('72336', 'Gladiator Mortok', '', '', '7', '7', '0', '1', '0', '0', '24700', '0', '0', '0', '1', '1', '0', '0');



INSERT INTO `creature_names` VALUES ('72341', 'Watcher Firion', '', '', '2', '5', '0', '1', '0', '0', '27045', '0', '0', '0', '1', '1', '0', '0');

INSERT INTO `creature_names` VALUES ('72342', 'Archmage Amanorum', '', '', '0', '2', '0', '1', '0', '0', '27800', '0', '0', '0', '1', '1', '0', '0');


INSERT INTO `creature_names` VALUES ('72343', 'Orinoko Tuskbreaker', '', '', '2', '7', '0', '1', '0', '0', '26695', '0', '0', '0', '1', '1', '0', '0');

INSERT INTO `creature_names` VALUES ('72347', 'Whisker', '', '', '0', '1', '0', '1', '0', '0', '26768', '0', '0', '0', '1', '1', '0', '0');


INSERT INTO `creature_names` VALUES ('72344', 'Stinkbeard', '', '', '0', '7', '0', '1', '0', '0', '24954', '0', '0', '0', '1', '1', '0', '0');



INSERT INTO `creature_names` VALUES ('72345', 'Varksun, Champion of the Anguish', '', '', '1', '7', '0', '3', '0', '0', '27301', '0', '0', '0', '1', '1', '0', '0');

INSERT INTO `creature_names` VALUES ('72350', 'Black Proto-drake', 'Minion of Varksun', '', '0', '2', '0', '1', '0', '0', '26709', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO `creature_names` VALUES ('72351', 'Black Proto-drake', 'Minion of Varksun', '', '0', '2', '0', '1', '0', '0', '26709', '0', '0', '0', '1', '1', '0', '0');

INSERT INTO `creature_names` VALUES ('72349', 'Garodar', 'Minion of Varksun', '', '0', '5', '0', '1', '0', '0', '27092', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO `creature_names` VALUES ('72348', 'Ortanon', 'Minion of Varksun', '', '0', '5', '0', '1', '0', '0', '27092', '0', '0', '0', '1', '1', '0', '0');



INSERT INTO `creature_proto` VALUES ('72336', '82', '82', '1852', '2040000', '2040000', '0', '1.3', '7', '1500', '0', '0', '0', '1', '0', '0', '0', '0', '6000', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '2', '8', '14', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `creature_proto` VALUES ('72340', '83', '83', '1852', '2040000', '2040000', '0', '1', '3', '2000', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '1', '0', '0', '0', '2', '8', '14', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `creature_proto` VALUES ('72341', '82', '82', '14', '565200', '565200', '76200', '1', '2', '2000', '0', '13460', '13530', '0', '0', '0', '0', '0', '5000', '0', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '0', '2', '8', '14', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `creature_proto` VALUES ('72342', '82', '82', '1852', '565200', '565200', '345000', '1.5', '0', '2000', '0', '11240', '11430', '0', '0', '0', '0', '0', '3000', '0', '0', '0', '0', '0', '0', '1', '0', '0', '1', '230000', '0', '0', '2', '8', '14', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `creature_proto` VALUES ('72343', '82', '82', '1852', '565200', '565200', '0', '1', '2', '2000', '0', '13460', '13530', '0', '0', '0', '0', '0', '5000', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '120000', '0', '0', '2', '8', '14', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `creature_proto` VALUES ('72344', '80', '80', '1852', '345000', '345000', '72300', '1', '0', '2000', '0', '7120', '7230', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '120000', '0', '0', '2', '8', '14', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `creature_proto` VALUES ('72345', '83', '83', '1852', '565200', '565200', '126000', '1', '0', '2000', '0', '13210', '13423', '0', '0', '0', '0', '0', '9104', '0', '0', '0', '0', '0', '0', '2', '0', '0', '1', '0', '0', '0', '2', '8', '14', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `creature_proto` VALUES ('72347', '80', '80', '14', '198500', '198500', '0', '1', '0', '2000', '0', '4230', '4420', '0', '0', '0', '0', '0', '5600', '0', '0', '0', '0', '0', '0', '1', '1', '0', '1', '0', '0', '0', '2', '8', '14', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `creature_proto` VALUES ('72348', '81', '81', '14', '236000', '236000', '0', '1', '0', '2000', '0', '8490', '8520', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3', '1', '0', '1', '0', '0', '0', '2', '8', '14', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `creature_proto` VALUES ('72349', '81', '81', '14', '236000', '236000', '0', '1', '0', '2000', '0', '8490', '8520', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3', '1', '0', '1', '0', '0', '0', '2', '8', '14', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `creature_proto` VALUES ('72350', '80', '80', '1852', '345000', '345000', '72300', '1', '0', '2000', '0', '7120', '7230', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '1', '0', '0', '0', '2', '8', '14', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `creature_proto` VALUES ('72351', '80', '80', '1852', '345000', '345000', '72300', '1', '0', '2000', '0', '7120', '7230', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '1', '0', '0', '0', '2', '8', '14', '0', '0', '0', '0', '0', '0', '0');

*3. Repeat with these two:

Spawns:

INSERT INTO `creature_spawns` VALUES ('409982', '72340', '571', '5793.2', '-3020.14', '286.292', '2.00077', '0', '28127', '35', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '27240', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('409983', '72336', '571', '5788.23', '-3023.52', '286.306', '2.0121', '0', '24700', '1852', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

Gossip:

INSERT INTO `npc_gossip_textid` VALUES ('72340', '72340');
INSERT INTO `npc_text` VALUES ('72340', '0', 'Welcome in the Amphitheater of Anguish. Want to challange one of the Gladiator?', 'Welcome in the Amphitheater of Anguish. Want to challange one of the Gladiator?', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0');

If you want the Quests too, copy these and hit Enter again

INSERT INTO `creature_quest_starter` VALUES ('72336', '72344');
INSERT INTO `creature_quest_starter` VALUES ('72336', '72345');
INSERT INTO `creature_quest_starter` VALUES ('72340', '72346');
INSERT INTO `creature_quest_starter` VALUES ('72340', '72347');
INSERT INTO `creature_quest_starter` VALUES ('72340', '72348');
INSERT INTO `creature_quest_starter` VALUES ('72340', '72349');
INSERT INTO `creature_quest_starter` VALUES ('72340', '72350');
INSERT INTO `creature_quest_starter` VALUES ('72340', '72351');


INSERT INTO `creature_quest_finisher` VALUES ('72340', '72344');
INSERT INTO `creature_quest_finisher` VALUES ('72340', '72345');
INSERT INTO `creature_quest_finisher` VALUES ('72340', '72346');
INSERT INTO `creature_quest_finisher` VALUES ('72340', '72347');
INSERT INTO `creature_quest_finisher` VALUES ('72340', '72348');
INSERT INTO `creature_quest_finisher` VALUES ('72340', '72349');
INSERT INTO `creature_quest_finisher` VALUES ('72340', '72350');
INSERT INTO `creature_quest_finisher` VALUES ('72340', '72351');

INSERT INTO `quests` VALUES ('72346', '0', '1', '4', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '72344', '72349', '0', '0', 'First Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Watcher Firion and Archmage Amanorum.', 'Defeat Watcher Firion and Archmage Amanorum.', 'Nice to meet you again. Ah, you beat them?$BCongratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72341', '72342', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44914', '44912', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '42123', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '72344', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72347', '0', '1', '4', '80', '80', '1', '690', '1535', '0', '0', '0', '0', '0', '0', '72345', '72348', '0', '0', 'First Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Watcher Firion and Archmage Amanorum.', 'Defeat Watcher Firion and Archmage Amanorum.', 'Nice to meet you again. Ah! You beat them? Congratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72341', '72342', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44914', '44912', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '42122', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72348', '0', '1', '2', '80', '80', '1', '690', '1535', '0', '0', '0', '0', '0', '0', '72347', '72350', '0', '0', 'Second Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Orinoko Tuskbreaker and Stinkbeard!', 'Defeat Orinoko Tuskbreaker and Stinkbeard.', 'Nice to meet you again. Ah! You beat them?$BCongratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72343', '72344', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '42114', '42115', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72344', '0', '1', '4', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '0', '72346', '0', '0', 'Enter the Arena', 'Welcome to the Amphitheater of Anguish! This is the great arena, where you can fight for equipment. Arenamaster Dargan is the leader of this event.', 'If you want to join the battle, speak with Arenamaster Dargan. Its recommend to bring friends, if you want to challenge one of the Gladiators.', 'Welcome in the Amphitheater of Anguish! You can register your batttles here.', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '234900', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72349', '0', '1', '2', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '72346', '72350', '0', '0', 'Second Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Orinoko Tuskbreaker and Stinkbeard!', 'Defeat Orinoko Tuskbreaker and Stinkbeard.', 'Nice to meet you again. Ah! You beat them?$BCongratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72343', '72344', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '42114', '42115', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '72346', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72350', '0', '1', '2', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Ultimate Challenge.', 'You defeated all Gladiators. Now it is time for Varksun, the Champion of the Amphitheater of Anguish!', 'Defeat Varksun, the Champion of the Amphitheater of Anguish.', 'You beat the champion! Now you are one of the new champions of the Amphitheater of Anguish! Congratulation!', '', '$B', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72345', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44160', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '659900', '0', '0', '0', '0', '0', '72349', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72351', '0', '1', '2', '80', '80', '1', '690', '1535', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Ultimate Challenge.', 'You defeated all Gladiators. Now it is time for Varksun, the Champion of the Amphitheater of Anguish!', 'Defeat Varksun, the Champion of the Amphitheater of Anguish.', 'You beat the champion! Now you are one of the new champions of the Amphitheater of Anguish! Congratulation!', '', 'It\'s time to challenge the Champion. If your team wins, you are the new champions!$B', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72345', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44160', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '649900', '0', '0', '0', '0', '0', '72348', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

For older Revisions take this:

INSERT INTO `quests` VALUES ('72346', '0', '1', '4', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '72344', '72349', '0', '0', 'First Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Watcher Firion and Archmage Amanorum.', 'Defeat Watcher Firion and Archmage Amanorum.', 'Nice to meet you again. Ah, you beat them?$BCongratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72341', '72342', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44914', '44912', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '42123', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '72344', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72347', '0', '1', '4', '80', '80', '1', '690', '1535', '0', '0', '0', '0', '0', '0', '72345', '72348', '0', '0', 'First Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Watcher Firion and Archmage Amanorum.', 'Defeat Watcher Firion and Archmage Amanorum.', 'Nice to meet you again. Ah! You beat them? Congratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72341', '72342', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44914', '44912', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '42122', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72348', '0', '1', '2', '80', '80', '1', '690', '1535', '0', '0', '0', '0', '0', '0', '72347', '72350', '0', '0', 'Second Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Orinoko Tuskbreaker and Stinkbeard!', 'Defeat Orinoko Tuskbreaker and Stinkbeard.', 'Nice to meet you again. Ah! You beat them?$BCongratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72343', '72344', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '42114', '42115', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72344', '0', '1', '4', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '0', '72346', '0', '0', 'Enter the Arena', 'Welcome to the Amphitheater of Anguish! This is the great arena, where you can fight for equipment. Arenamaster Dargan is the leader of this event.', 'If you want to join the battle, speak with Arenamaster Dargan. Its recommend to bring friends, if you want to challenge one of the Gladiators.', 'Welcome in the Amphitheater of Anguish! You can register your batttles here.', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '234900', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72349', '0', '1', '2', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '72346', '72350', '0', '0', 'Second Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Orinoko Tuskbreaker and Stinkbeard!', 'Defeat Orinoko Tuskbreaker and Stinkbeard.', 'Nice to meet you again. Ah! You beat them?$BCongratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72343', '72344', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '42114', '42115', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '72346', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72350', '0', '1', '2', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Ultimate Challenge.', 'You defeated all Gladiators. Now it is time for Varksun, the Champion of the Amphitheater of Anguish!', 'Defeat Varksun, the Champion of the Amphitheater of Anguish.', 'You beat the champion! Now you are one of the new champions of the Amphitheater of Anguish! Congratulation!', '', '$B', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72345', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44160', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '659900', '0', '0', '0', '0', '0', '72349', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72351', '0', '1', '2', '80', '80', '1', '690', '1535', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Ultimate Challenge.', 'You defeated all Gladiators. Now it is time for Varksun, the Champion of the Amphitheater of Anguish!', 'Defeat Varksun, the Champion of the Amphitheater of Anguish.', 'You beat the champion! Now you are one of the new champions of the Amphitheater of Anguish! Congratulation!', '', 'It\'s time to challenge the Champion. If your team wins, you are the new champions!$B', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72345', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44160', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '649900', '0', '0', '0', '0', '0', '72348', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

Thanks to gimmeurlife for the one for older revisions.




Otional:

INSERT INTO `recall` VALUES ('829', 'ZArena', '571', '5822.29', '-3081.13', '301.398');

.recall port ZArena


I think you can also copy all into one .sql file and batch it in your world database.



To make sure the script works, look into your world.exe,
it should look like this:





The script was tested on: ArcEmu rev. 2676+ ArcScript for 3.0.9.



[ Credits and infos ]

At first, you can fully edit the script, but please leave credits where they should be.

And second, sorry if there are grammar mistakes!^^
English is not my mother tongue. But maybe you can edit the things, which are wrong. I hope you still like the script.


Please post suggestions and report all bugs in this thread.

I will shortly upload a video, if someone is interested^^


Have fun with the script!

[makis5]

INSERT INTO `quests` VALUES ('72346', '0', '1', '4', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '72344', '72349', '0', '0', 'First Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Watcher Firion and Archmage Amanorum.', 'Defeat Watcher Firion and Archmage Amanorum.', 'Nice to meet you again. Ah, you beat them?$BCongratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72341', '72342', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44914', '44912', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '42123', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '72344', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72347', '0', '1', '4', '80', '80', '1', '690', '1535', '0', '0', '0', '0', '0', '0', '72345', '72348', '0', '0', 'First Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Watcher Firion and Archmage Amanorum.', 'Defeat Watcher Firion and Archmage Amanorum.', 'Nice to meet you again. Ah! You beat them? Congratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72341', '72342', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44914', '44912', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '42122', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72348', '0', '1', '2', '80', '80', '1', '690', '1535', '0', '0', '0', '0', '0', '0', '72347', '72350', '0', '0', 'Second Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Orinoko Tuskbreaker and Stinkbeard!', 'Defeat Orinoko Tuskbreaker and Stinkbeard.', 'Nice to meet you again. Ah! You beat them?$BCongratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72343', '72344', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '42114', '42115', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72344', '0', '1', '4', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '0', '72346', '0', '0', 'Enter the Arena', 'Welcome to the Amphitheater of Anguish! This is the great arena, where you can fight for equipment. Arenamaster Dargan is the leader of this event.', 'If you want to join the battle, speak with Arenamaster Dargan. Its recommend to bring friends, if you want to challenge one of the Gladiators.', 'Welcome in the Amphitheater of Anguish! You can register your batttles here.', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '234900', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72349', '0', '1', '2', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '72346', '72350', '0', '0', 'Second Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Orinoko Tuskbreaker and Stinkbeard!', 'Defeat Orinoko Tuskbreaker and Stinkbeard.', 'Nice to meet you again. Ah! You beat them?$BCongratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72343', '72344', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '42114', '42115', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '72346', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72350', '0', '1', '2', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Ultimate Challenge.', 'You defeated all Gladiators. Now it is time for Varksun, the Champion of the Amphitheater of Anguish!', 'Defeat Varksun, the Champion of the Amphitheater of Anguish.', 'You beat the champion! Now you are one of the new champions of the Amphitheater of Anguish! Congratulation!', '', '$B', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72345', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44160', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '659900', '0', '0', '0', '0', '0', '72349', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72351', '0', '1', '2', '80', '80', '1', '690', '1535', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Ultimate Challenge.', 'You defeated all Gladiators. Now it is time for Varksun, the Champion of the Amphitheater of Anguish!', 'Defeat Varksun, the Champion of the Amphitheater of Anguish.', 'You beat the champion! Now you are one of the new champions of the Amphitheater of Anguish! Congratulation!', '', 'It\'s time to challenge the Champion. If your team wins, you are the new champions!$B', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72345', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44160', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '649900', '0', '0', '0', '0', '0', '72348', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

Have error on me!Error says "Column count doesn't match value count at row 1"What to do man?

[gimmeurlife]

You didn't give us a DL link or code box to the script O.o

And I got the same error on the quests as he did, using ArcEmu r2387

[Kaidos]

Sorry, i will try to change it.

Updated first post with downlaodlink!

Here was something wrong lolz.

Try this.If it work, i will update the first post with it!

[gimmeurlife]

Sorry, i will try to change it.

Updated first post with downlaodlink!

It's np man, as I said in pm i'll see if i can get the quests fixed as well cuz it seems that your quest table has 109 columns whereas mine only has 104 according to your sql for INSERT INTO 'quests' VALUES. So if I have time right now i'll see if I can manually enter the data and then post the sql for those of us who are having the same problem if you're unable to figure out what it is


+Rep



Edit: The quests sql you posted above here isn't working either, I think your quests table may be different since its a newer revision of ArcEmu, were there any recent changes to the quest table?

[Kaidos]

It's np man, as I said in pm i'll see if i can get the quests fixed as well cuz it seems that your quest table has 109 columns whereas mine only has 104 according to your sql for INSERT INTO 'quests' VALUES. So if I have time right now i'll see if I can maually enter the data and then post the sql for those of us who are having the same problem if you're unable to figure out what it is

Thanks, would be nice!

Edit: i have no idea... quest has so many coulumns xD i would look manually, but i dont have a database which is working with 2387^^

[gimmeurlife]

Ok I just went through and added everything manually, Hopefully I didnt set anything in the wrong column but this entered into my DB correctly so I'll give it a shot and change it if it's not working. Just wanna help you out if I can because I know you put some work into this

INSERT INTO `quests` VALUES ('72346', '0', '1', '4', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '72344', '72349', '0', '0', 'First Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Watcher Firion and Archmage Amanorum.', 'Defeat Watcher Firion and Archmage Amanorum.', 'Nice to meet you again. Ah, you beat them?$BCongratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72341', '72342', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44914', '44912', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '42123', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '72344', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72347', '0', '1', '4', '80', '80', '1', '690', '1535', '0', '0', '0', '0', '0', '0', '72345', '72348', '0', '0', 'First Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Watcher Firion and Archmage Amanorum.', 'Defeat Watcher Firion and Archmage Amanorum.', 'Nice to meet you again. Ah! You beat them? Congratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72341', '72342', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44914', '44912', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '42122', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72348', '0', '1', '2', '80', '80', '1', '690', '1535', '0', '0', '0', '0', '0', '0', '72347', '72350', '0', '0', 'Second Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Orinoko Tuskbreaker and Stinkbeard!', 'Defeat Orinoko Tuskbreaker and Stinkbeard.', 'Nice to meet you again. Ah! You beat them?$BCongratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72343', '72344', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '42114', '42115', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72344', '0', '1', '4', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '0', '72346', '0', '0', 'Enter the Arena', 'Welcome to the Amphitheater of Anguish! This is the great arena, where you can fight for equipment. Arenamaster Dargan is the leader of this event.', 'If you want to join the battle, speak with Arenamaster Dargan. Its recommend to bring friends, if you want to challenge one of the Gladiators.', 'Welcome in the Amphitheater of Anguish! You can register your batttles here.', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '234900', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72349', '0', '1', '2', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '72346', '72350', '0', '0', 'Second Challenge!', 'If you want to fight against the Champion, you need to defeat all other Gladiator before.$B$BDefeat Orinoko Tuskbreaker and Stinkbeard!', 'Defeat Orinoko Tuskbreaker and Stinkbeard.', 'Nice to meet you again. Ah! You beat them?$BCongratulation!', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72343', '72344', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '42114', '42115', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '322100', '0', '0', '0', '0', '0', '72346', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72350', '0', '1', '2', '80', '80', '1', '1101', '1535', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Ultimate Challenge.', 'You defeated all Gladiators. Now it is time for Varksun, the Champion of the Amphitheater of Anguish!', 'Defeat Varksun, the Champion of the Amphitheater of Anguish.', 'You beat the champion! Now you are one of the new champions of the Amphitheater of Anguish! Congratulation!', '', '$B', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72345', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44160', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '659900', '0', '0', '0', '0', '0', '72349', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `quests` VALUES ('72351', '0', '1', '2', '80', '80', '1', '690', '1535', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Ultimate Challenge.', 'You defeated all Gladiators. Now it is time for Varksun, the Champion of the Amphitheater of Anguish!', 'Defeat Varksun, the Champion of the Amphitheater of Anguish.', 'You beat the champion! Now you are one of the new champions of the Amphitheater of Anguish! Congratulation!', '', 'It\'s time to challenge the Champion. If your team wins, you are the new champions!$B', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '72345', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '44160', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '649900', '0', '0', '0', '0', '0', '72348', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

There you go man, hopefully this works for older revisions

[Kaidos]

Nice gimmeurlife! If someone could test this? on confirmation i will add it to the main post.

Edit: btw. the other ones work? like the creature_names/proto/spawns...

[gimmeurlife]

Nice gimmeurlife! If someone could test this? on confirmation i will add it to the main post.

Edit: btw. the other ones work? like the creature_names/proto/spawns...

Yeah everything else is working perfectly It was just the quests that had extra columns. GREAT work man, thnx a bunch for this. I'll be doing some editing to it for my server but I'll definitely leave all credits in there so people know it's yours



I tested it on my server and it seems to be working perfectly quests and all with the updated sql for earlier revisions.

[Kaidos]

Hehe, thanks! I am gladly you like it^^

Added your sql to the main post

[stoneharry]

Looks good, I was planning on doing something like this but could never be bothered Noticed you changed the flags and all so people cant do more than one at once and bug it out, your using the players names so people know who summoned it and such. Looks well thought out and done The only thing which could be improved is possible the boss fights them selves, since they are often very simple with just a couple of spells being cast. +Rep

[Kaidos]

Looks good, I was planning on doing something like this but could never be bothered Noticed you changed the flags and all so people cant do more than one at once and bug it out, your using the players names so people know who summoned it and such. Looks well thought out and done The only thing which could be improved is possible the boss fights them selves, since they are often very simple with just a couple of spells being cast. +Rep

Hehe thanks.

Yeah 2 of the bosses i was scripting a long time ago^^

I only copied those two and change some spells, but at the champion i was scipting like 3 hours or something

[svedin]

Nice work
+Rep

[Kaidos]

Thanks

I will uploading a video of the Champion fight at the moment, i will add this to the main post.

Edit: / Video added.

[Kaidos]

/a little bump!