tomatosz

Members
  • Content count

    48
  • Joined

  • Last visited

Community Reputation

11 Neutral

About tomatosz

  • Rank
    Commoner
  • Birthday 07/27/1995

Profile Information

  • Gender
    Female

Recent Profile Visitors

169 profile views
  1. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/6973 Describe your fix: I have added Scourge Curio to the loot table of a lot of scourge. Account name: Tomatosz Comment: As a source I've used both the wowhead database and the mobs that drop it in the Trinity database. In the latter I have taken some MoP mobs out. I have also taken the 33% drop chance from the Trinity database. SQL fix: https://gist.github.com/tomatosz/7d760e0d14ce983d7664ff1010e0dd0d
  2. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/8852 Describe your fix: I made Christi Stockton the quest ender for Waterlogged Recipe. Account name: Tomatosz Comment: I've updated both ID's of the quest Waterlogged recipe (this and this) as I'm not sure which one is the actual quest people are getting. I think it's the latter though, as (on my local server) the former gives xp which is not listed on wowhead. SQL fix: DELETE FROM creature_questender WHERE quest IN (14203, 24431); INSERT INTO creature_questender (id, quest) VALUES (32337, 14203), (32337, 24431);
  3. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9102 Describe your fix: I have added the 6 possible rewards to the quest Teron Gorefiend, I Am. Account name: Tomatosz Comment: - SQL fix: UPDATE quest_template SET RewardChoiceItemID1 = 31104, RewardChoiceItemQuantity1 = 1, RewardChoiceItemID2 = 31110, RewardChoiceItemQuantity2 = 1, RewardChoiceItemID3 = 31109, RewardChoiceItemQuantity3 = 1, RewardChoiceItemID4 = 31107, RewardChoiceItemQuantity4 = 1, RewardChoiceItemID5 = 31106, RewardChoiceItemQuantity5 = 1, RewardChoiceItemID6 = 31105, RewardChoiceItemQuantity6 = 1 WHERE ID = 10639;
  4. "The main chat channel is "world" and its obligatory language is English. The website and the forum are English. Comments must be written in English."
  5. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/2691 Describe your fix: I have made the Reins of the Kor'kron Annihilator and the Reins of the Golden King each others horde/alliance equivalent for faction change (and hopefully for mailing cross-faction). Account name: Tomatosz Comment: I'm not 100% sure whether this fixes the mailing issue, but figured it was worth a try. SQL fix: DELETE FROM player_factionchange_items WHERE alliance_id=62298; INSERT INTO player_factionchange_items ('alliance_id', 'commentA', 'horde_id', 'commentH') VALUES (62298, "Reins of the Golden King", 67107, "Reins of the Korkron Annihilator");
  6. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/8325 Describe your fix: The quests Gaining Acceptance and Gaining Even More Acceptance now reward 60 and 1500 reputation to the Thorium Brotherhood respectively. Account name: Tomatosz Comment: - SQL fix: UPDATE quest_template SET RewardFactionOverride1 = 6000 WHERE ID = 13662; UPDATE quest_template SET RewardFactionOverride1 = 150000 WHERE ID = 7737;
  7. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9248 Describe your fix: Added quest item Riding Training Pamphlet to the mail players get when they reach level 20. A different entry/item for each race. Account name: Tomatosz Comment: - SQL fix: DELETE FROM mail_loot_template WHERE Entry IN (224, 225, 226, 227, 228, 229, 230, 231, 232, 233); INSERT INTO mail_loot_template ('Entry', 'Item', 'Reference', 'Chance', 'QuestRequired', 'LootMode', 'GroupId', 'MinCount', 'MaxCount') VALUES (224, 46875, 0, 100, 0, 1, 0, 1, 1), (225, 46876, 0, 100, 0, 1, 0, 1, 1), (226, 46877, 0, 100, 0, 1, 0, 1, 1), (227, 46879, 0, 100, 0, 1, 0, 1, 1), (228, 46878, 0, 100, 0, 1, 0, 1, 1), (229, 46884, 0, 100, 0, 1, 0, 1, 1), (230, 46883, 0, 100, 0, 1, 0, 1, 1), (231, 46880, 0, 100, 0, 1, 0, 1, 1), (232, 46882, 0, 100, 0, 1, 0, 1, 1), (233, 46881, 0, 100, 0, 1, 0, 1, 1);
  8. haha didn't see your post yet, tried just that (along with installing different versions of some of the programs) and my current problems are solved
  9. Yes, more specifically after i've made full.sql from all the update files, I can't run that file in MySQL Workbench.
  10. Thanks, that makes sense
  11. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/7337 Describe your fix: Mobs in the Underbog (normal difficulty) give 21 Sporeggar reputation and 7 Cenarion Expedition reputation, and the bosses give 210 to the Sporeggar and 70 to the Cenarion Expedition. Cenarion Expedition is only until Honored, except Hungarfen, Swamplord Musel'ek and giants, which give till revered. Account name: Tomatosz Comment: This fix reflects a change made in 4.3. I wasn't sure whether the Cenarion Expedition reputation was granted (or if some part of Sporeggar rep was already there on either RewOnKillRepFaction1 or 2), so I decided to delete and insert instead of update. Source: (http://www.wowhead.com/faction=970/sporeggar#comments) http://wow.gamepedia.com/index.php?title=Cenarion_Expedition&oldid=2856571 (about cenarion expedition till honored/revered) SQL fix: DELETE FROM creature_onkill_reputation WHERE creature_id IN (18105, 17770, 17826, 17882, 17723, 17731, 19632, 17732, 17730, 17771, 17729, 17728, 17724, 17734, 17725, 17871, 17726, 17727, 17735); INSERT INTO creature_onkill_reputation ('creature_id', 'RewOnKillRepFaction1', 'RewOnKillRepFaction2', 'MaxStanding1', 'IsTeamAward1', 'RewOnKillRepValue1', 'MaxStanding2', 'IsTeamAward2', 'RewOnKillRepValue2', 'TeamDependent') VALUES (18105, 970, 942, 7, 0, 210, 5, 0, 70, 0), -- bosses (17770, 970, 942, 7, 0, 210, 6, 0, 70, 0), (17826, 970, 942, 7, 0, 210, 6, 0, 70, 0), (17882, 970, 942, 7, 0, 210, 5, 0, 70, 0), (17723, 970, 942, 7, 0, 21, 6, 0, 7, 0), -- normal mobs (17731, 970, 942, 7, 0, 21, 5, 0, 7, 0), (19632, 970, 942, 7, 0, 21, 5, 0, 7, 0), (17732, 970, 942, 7, 0, 21, 5, 0, 7, 0), (17730, 970, 942, 7, 0, 21, 5, 0, 7, 0), (17771, 970, 942, 7, 0, 21, 5, 0, 7, 0), (17729, 970, 942, 7, 0, 21, 5, 0, 7, 0), (17728, 970, 942, 7, 0, 21, 5, 0, 7, 0), (17724, 970, 942, 7, 0, 21, 5, 0, 7, 0), (17734, 970, 942, 7, 0, 21, 6, 0, 7, 0), (17725, 970, 942, 7, 0, 21, 5, 0, 7, 0), (17871, 970, 942, 7, 0, 21, 5, 0, 7, 0), (17726, 970, 942, 7, 0, 21, 5, 0, 7, 0), (17727, 970, 942, 7, 0, 21, 5, 0, 7, 0), (17735, 970, 942, 7, 0, 21, 5, 0, 7, 0); 18105 = Ghaz’an (boss) 17770 = Hungarfen (boss) 17826 = Swamplord Musel’ek (boss) 17882 = The Black Stalker (boss) 17723 = Bog Giant 17731 = Fen Ray 19632 = Lykul Stinger 17732 = Lykul Wasp 17730 = Murkblood Healer 17771 = Murkblood Oracle 17729 = Murkblood Spearman 17728 = Murkblood Tribesman 17724 = Underbat 17734 = Underbog Lord 17725 = Underbog Lurker 17871 = Underbog Shambler 17726 = Wrathfin Myrmidon 17727 = Wrathfin Sentry 17735 = Wrathfin Warrior
  12. I was wondering which content on this server should currently be as it was in 4.2, and which should be as 4.3. Aside from the obvious 4.3 dungeons/4.3 raids/tier gear/season gear of course. Some things are explained as being the way they are because we're at 4.2 (most notably the current Darkmoon Faire), while others are explained as being the way they are because the server is 4.3. The first example of this that I can think of is the lack of Coilfang Armaments turn in. I'd like to know the pattern behind this so I know what belongs on the bugtracker (and potentially what i can try to make a fix for).
  13. Bugtracker link: not reported Describe your fix: Fel Ember should grant Thrallmar reputation instead of Honor Hold. Account name: Tomatosz Comment: This is a Horde quest, so it shouldn't give Honor Hold reputation (since that is an alliance faction). Proof on Wowpedia: http://wow.gamepedia.com/Quest:Fel_Ember (Somehow wowhead does list Honor Hold: http://www.wowhead.com/quest=29650/fel-ember) SQL fix: UPDATE quest_template SET RewardFactionId1 = 947 WHERE ID = 29650; Edit: changed "RewardFactionId" into "RewardFactionId1"
  14. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9242 Describe your fix: Give Agal his rare status. Account name: Tomatosz Comment: SQL fix: UPDATE creature_template SET rank = 4 WHERE entry = 2162;
  15. Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9240 Describe your fix: Update Ethereal Beacon (hc) to give 8 consortium reputation instead of 16 and update Ethereal Apprentice (hc) to give 21 reputation instead of none. Account name: Tomatosz Comment: I apologize in advance if this doesn't work, it's my first attempt at a fix =D SQL fix: Ethereal Beacon: UPDATE creature_onkill_reputation SET RewOnKillRepValue1 = 8 WHERE creature_id = 20254; Ethereal Apprentice: (assuming there may not have been any rep reward set for this mob at all) DELETE FROM creature_onkill_reputation WHERE creature_id = 20253; INSERT INTO creature_onkill_reputation ('creature_id', 'RewOnKillRepFaction1', 'RewOnKillRepFaction2', 'MaxStanding1', 'IsTeamAward1', 'RewOnKillRepValue1', 'MaxStanding2', 'IsTeamAward2', 'RewOnKillRepValue2', 'TeamDependent') VALUES (20253, 933, 0, 7, 0, 21, 0, 0, 0, 0);