[RELEASE/QUEST] +rep for 2D

[Tobii]

Well, let's say i was bored!
Its a basic gold farming quest..

Code:

UPDATE `creature_names` SET `name` = 'Tobii', `subname` = 'MMOWNED MEMBER', `info_str` = '', `type` = '7', `family` = '0', `rank` = '2', `male_displayid` = '21560', `female_displayid` = '0', `civilian` = '0', `Leader` = NULL WHERE `entry` = 6003001 LIMIT 1;
INSERT INTO `creature_names` (`name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `civilian`, `Leader`, `entry`) VALUES ('2DGREENGIANT', 'MMOWNED ELITE', '', '5', '0', '1', '10043', '0', '0', NULL, '6008001');
INSERT INTO `creature_proto` (`minlevel`, `maxlevel`, `Faction`, `minhealth`, `maxhealth`, `mana`, `Scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `combat_reach`, `boss`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `respawntime`, `auras`, `invisibility_type`, `death_state`, `entry`) VALUES ('70', '70', '1770', '5000', '5000', '5000', '1.3', '2', '1316', '207', '295', '0', '0', '0', '1', '0', '2839', '0', '0', '0', '0', '0', '0', '6008001');
INSERT INTO `creature_names` (`name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `civilian`, `Leader`, `entry`) VALUES ('Tobii', 'MMOWNED MEMBER', '', '7', '0', '2', '20130', '0', '0', NULL, '6008002');
INSERT INTO `creature_proto` (`minlevel`, `maxlevel`, `Faction`, `minhealth`, `maxhealth`, `mana`, `Scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `combat_reach`, `boss`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `respawntime`, `auras`, `invisibility_type`, `death_state`, `entry`) VALUES ('70', '70', '1770', '5000', '5000', '0', '1.50', '2', '2000', '624', '871', '0', '0', '0', '1', '0', '41752', '41753', '0', '36000', '0', '0', '0', '6008002');
INSERT INTO `items` (`class`, `subclass`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `buyprice`, `sellprice`, `itemlevel`, `ContainerSlots`, `unique`, `maxcount`, `bonding`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `delay`, `range`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `armor`, `block`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `allowableclass`, `allowablerace`, `RequiredSkill`, `RequiredSkillRank`, `RequiredFaction`, `RequiredFactionStanding`, `requiredlevel`, `inventorytype`, `quest_id`, `sheathID`, `itemset`, `MaxDurability`, `Description`, `socket_color_1`, `socket_color_2`, `socket_color_3`, `socket_bonus`, `page_id`, `entry`) VALUES ('12', '-1', '+rep', '', '', '', '32550', '2', '0', '0', '70', '0', '5', '5', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '-1', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '-1', '0', '-1', '-1', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'A little text says: Belongs to 2D', '0', '0', '0', '0', '0', '6008001');
INSERT INTO `quests` (`ZoneId`, `sort`, `flags`, `MinLevel`, `questlevel`, `Type`, `RequiredRaces`, `RequiredClass`, `RequiredTradeskill`, `RequiredRepFaction`, `RequiredRepValue`, `LimitTime`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `srcItem`, `SrcItemCount`, `Title`, `Details`, `Objectives`, `CompletionText`, `IncompleteText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqKillMobOrGOId1`, `ReqKillMobOrGOId2`, `ReqKillMobOrGOId3`, `ReqKillMobOrGOId4`, `ReqKillMobOrGOCount1`, `ReqKillMobOrGOCount2`, `ReqKillMobOrGOCount3`, `ReqKillMobOrGOCount4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepValue1`, `RewRepValue2`, `RewRepLimit`, `RewMoney`, `RewXP`, `RewSpell`, `CastSpell`, `RequiredMoney`, `ExploreTrigger1`, `ExploreTrigger2`, `ExploreTrigger3`, `ExploreTrigger4`, `RequiredQuest1`, `RequiredQuest2`, `RequiredQuest3`, `RequiredQuest4`, `ReceiveItemId1`, `ReceiveItemId2`, `ReceiveItemId3`, `ReceiveItemId4`, `ReceiveItemCount1`, `ReceiveItemCount2`, `ReceiveItemCount3`, `ReceiveItemCount4`, `IsRepeatable`, `ReqCastSpellId1`, `ReqCastSpellId2`, `ReqCastSpellId3`, `ReqCastSpellId4`, `entry`) VALUES ('0', '0', '1', '1', '1', '1', '1791', '1503', '0', '0', '0', '0', '0', '0', '0', '0', '0', '+rep for 2D', 'Some new member\'s on MMOWNED will not give 2D +rep for he\'s good work.. So i need your help , go show them how we do on MMOWNED!', 'Get +rep from the newbies!', '', 'You still need to get 2D\'s +rep!', '', '', '', '', '', '6008001', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '500000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '6008001');
INSERT INTO `creature_names` (`name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `civilian`, `Leader`, `entry`) VALUES ('Newbie', 'MMOWNED NEWBIE', '', '7', '0', '0', '10038', '0', '0', NULL, '6008003');
INSERT INTO `creature_proto` (`minlevel`, `maxlevel`, `Faction`, `minhealth`, `maxhealth`, `mana`, `Scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `combat_reach`, `boss`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `respawntime`, `auras`, `invisibility_type`, `death_state`, `entry`) VALUES ('1', '5', '0', '150', '150', '0', '0.8', '0', '1970', '9', '11.61', '0', '0', '0', '1', '0', '22893', '0', '0', '36000', '0', '0', '0', '6008003');
UPDATE `quests` SET `ReqKillMobOrGOId1` = '6008003', `ReqKillMobOrGOCount1` = '10' WHERE `entry` = 6008001 LIMIT 1;
UPDATE `quests` SET `CompletionText` = '2DGREENGIANT PWN YOU ALL!' WHERE `entry` = 6008001 LIMIT 1;
DELETE FROM `creature_quest_starter` WHERE `quest` = 6008001;
DELETE FROM `creature_quest_finisher` WHERE `quest` = 6008001;
DELETE FROM `gameobject_quest_starter` WHERE `quest` = 6008001;
DELETE FROM `gameobject_quest_finisher` WHERE `quest` = 6008001;
UPDATE `items` SET `quest_id` = 0 WHERE `quest_id` = '6008001';
INSERT INTO `creature_quest_starter` (`id`, `quest`) VALUES ('6008002', '6008001');
INSERT INTO `creature_quest_finisher` (`id`, `quest`) VALUES ('6008001', '6008001');
DELETE FROM `creatureloot` WHERE `entryid` = 6008003;
INSERT INTO `creatureloot` (`entryid`, `itemid`, `percentchance`, `heroicpercentchance`, `mincount`, `maxcount`) VALUES ('6008003', '6008001', '20', '20', '1', '2');
UPDATE `quests` SET `ReqItemCount1` = '10', `ReqKillMobOrGOId1` = '0', `ReqKillMobOrGOCount1` = '0', `RewMoney` = '100000' WHERE `entry` = 6008001 LIMIT 1;
DELETE FROM `creatureloot` WHERE `entryid` = 6008003;
INSERT INTO `creatureloot` (`entryid`, `itemid`, `percentchance`, `heroicpercentchance`, `mincount`, `maxcount`) VALUES ('6008003', '6008001', '5', '20', '1', '2');

Changes:
1. Changed the amount of "+rep" from 50 to 10
2. Changed drop chance from 20% to 5%
3. Removed "Newbie Slayen". Doesn't work with repeatable.
4. Changed amount of gold from 50g to 10g.

Spawn:
2D spawn ID: 6008001
Tobii Spawn ID: 6008002
Newbie Spawn ID: 6008003

Quest:
Quest ID: 6008001

Download:


Screenshots:

[Mr. Herbert]

Not Bad +2 rep

[2dgreengiant]

zomfg that legit dude

[EcHoEs]

HAHA!
+4 Rep!

[Cursed]

Awesome +rep 3x

[King Shaun]

Great work mate, keep it up.

Rep added (x

[Traz]

rofl , i hate emu server but this is funny
+2 +Rep

[2dgreengiant]

emus are epix, thats y i spend liek my whole day in here XD

[Romis]

Lol, epic! ^^

+2 rep