Jump to content

!Tomatosz

Support
  • Content count

    50
  • Joined

  • Last visited

Community Reputation

8 Neutral

About !Tomatosz

  • Rank
    Game Master
  1. [Item] Zen'vorka's cache

    Bugtracker link: noneDescribe your fix: Fixed the groupid of the loot in Zen'vorka's cache so it will always drop something.Account name: TomatoszComment: - SQL fix: UPDATE item_loot_template SET groupid=1 WHERE entry=71631;
  2. [Quests] AQ10 rings and weapons

    Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9842Describe your fix: Added the creature_quest_ender to several quests. Also updated the position of the hand-in mark on the world map.Account name: TomatoszComment: - SQL fix: DELETE FROM creature_quest_ender WHERE quest IN (8697, 8702, 8705, 8558, 8710); INSERT INTO creature_quest_ender (id, quest) VALUES (15498, 8697), (15498, 8702), (15498, 8704), (15499, 8558), (15499, 8710); UPDATE quest_poi_points SET x=-8413, y=1486 WHERE QuestId IN (SELECT quest FROM creature_quest_starter WHERE id=15498) AND id=1; UPDATE quest_poi_points SET x=-8413, y=1483 WHERE QuestId IN (SELECT quest FROM creature_quest_starter WHERE id=15499) AND id=0; UPDATE quest_poi_points SET x=-8411, y=1481 WHERE QuestId IN (SELECT quest FROM creature_quest_starter WHERE id=15500) AND id=1;
  3. [Quest] Return to Obedai

    Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/8295Describe your fix: Fixed the quest requirements for Return to ObedaiAccount name: TomatoszComment: Apparently it doesn't work when a quest is (indirectly) its own requirement... who knew =D? SQL fix: UPDATE quest_template SET NextQuestId=9423, ExclusiveGroup=0 WHERE entry=9390; UPDATE quest_template SET ExclusiveGroup=-9423 WHERE entry=9423; UPDATE quest_template SET ExclusiveGroup=-9423 WHERE entry=9424;
  4. [NPC] Matthias Lehner

    Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/9820Describe your fix: Made Matthias Lehner visible in Argent Tournament daily phase too.Account name: TomatoszComment: - SQL fix: UPDATE creature SET phaseMask=phaseMask|256 WHERE id=32497;
  5. [NPC] Eye of C'thun Dark Glare Rotation

    @TheGreatKiller The reason is that the fixes that were implemented were SQL fixes, and most of Gecko32's fixes are c++ fixes. They have to be implemented differently and also require more testing because it may not be compatible with our core. So it's a matter of a dev finding time to test/implement it properly.
  6. [NPC] Kwee Q. Peddlefeet

    Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/6535Describe your fix: Deleted the duplicate Kwee Q. Peddlefeet.Account name: TomatoszComment: The other has 2 min spawn timer, so the id+spawn timer is enough to uniquely define it. SQL fix: DELETE FROM creature WHERE id=38040 AND spawntimesecs=300;
  7. [Quests] Love is in the Air dailies

    Bugtracker link: https://github.com/Atlantiss/BugTracker/issues/6536Describe your fix: Made either Bonbon Blitz or Perfume+Cologne quest available. Also made Perfume and Cologne quests available depending on gender. Account name: TomatoszComment: - SQL fix: SET @ENTRY:=24629; SET @ENTRY2:=24636; SET @ENTRY3:=24635; DELETE FROM pool_template WHERE entry IN (@ENTRY, @ENTRY2, @ENTRY3); INSERT INTO pool_template (entry, max_limit, description) VALUES (@ENTRY, 2, "Perfume dailies Love is in the Air"), (@ENTRY2, 1, "Bonbon Blitz daily Love is in the Air"), (@ENTRY3, 1, "Perfume+bonbon dailies Love is in the Air"); DELETE FROM pool_quest WHERE entry IN (@ENTRY, @ENTRY2); INSERT INTO pool_quest (entry, pool_entry, description) VALUES (24635, @ENTRY, "A Cloudlet of Classy Cologne"), (24629, @ENTRY, "A Perfect Puff of Perfume"), (24636, @ENTRY2, "Bonbon Blitz"); DELETE FROM pool_pool WHERE pool_id IN (@ENTRY, @ENTRY2); INSERT INTO pool_pool (pool_id, mother_pool, chance, can_repeat, description) VALUES (@ENTRY, @ENTRY3, 50, 1, "Perfume dailies Love is in the Air"), (@ENTRY2, @ENTRY3, 50, 1, "Bonbon Blitz daily Love is in the Air"); DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (24635, 24629) AND ConditionTypeOrReference=20; INSERT INTO conditions (SourceTypeOrReferenceId, SourceEntry, ConditionTypeOrReference, ConditionValue1, Comment) VALUES (19, 24635, 20, 0, "A Cloudlet of Classy Cologne is only available for male characters"), (19, 24629, 20, 1, "A Perfect Puff of Perfume is only available for female characters");
  8. [Item] Winter Veil Stolen Present

    I just tested on PTR, and it works fine. For reference entries: If GroupId > 0 only the referenced items with said GroupId will drop. Seems like it should work with GroupId=0.
  9. [Gameobject] Deepsea Sagefish School loot

    Oops you're right, forgot to copy that into the post.
  10. [Item] Winter Veil Stolen Present

    Bugtracker link: noneDescribe your fix: Used a reference loot template to make the loot of the Stolen Present closer to Blizzlike.Account name: TomatoszComment: Correction of the quick fix done here: https://community.atlantiss.eu/index.php?/topic/15501-item-winter-veil-lootboxes SQL fix: DELETE FROM reference_loot_template WHERE entry=73792; INSERT INTO reference_loot_template (entry,item,ChanceOrQuestChance,groupid, mincountOrRef, maxcount) VALUES (73792, 34498, 0, 1, 1, 1), (73792, 37710, 5.3, 1, 1, 1), (73792, 44481, 0, 1, 5, 5), (73792, 44482, 0, 1, 5, 5), (73792, 44599, 0, 1, 5, 5), (73792, 44601, 0, 1, 5, 5), (73792, 46709, 5.3, 1, 1, 1), (73792, 54438, 4.3, 1, 1, 1), (73792, 54437, 4.3, 1, 1, 1), (73792, 73797, 2.5, 1, 1, 1), (73792, 46725, 2.5, 1, 1, 1), (73792, 66540, 0.8, 1, 1, 1), (73792, 44606, 2.5, 1, 1, 1), (73792, 54436, 2.5, 1, 1, 1), (73792, 34425, 2.5, 1, 1, 1); DELETE FROM item_loot_template WHERE entry=73792; INSERT INTO item_loot_template (entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount) VALUES (73792, 1, 100, 0, -73792, 1), (73792, 2, 20, 0, -73792, 1);
  11. [Item] Lovely Dress Box loot

    Bugtracker link: noneDescribe your fix: Made sure all dresses are in the same groupid and have equal dropchance so a drop is guaranteed.Account name: TomatoszComment: - SQL fix: UPDATE item_loot_template SET groupid=1, ChanceOrQuestChance=0 WHERE entry=50160;
  12. [Gameobject] Iron Veins in Cape of Stranglethorn (2)

    haha yeah i just copied what User101 did, but already saw Piklo commenting about that. Will update soon, can I be sure that the coordinates are exactly the same @Herkor?
  13. [Gameobject] Iron Veins in Cape of Stranglethorn

    You ask, we deliver =D
  14. Bugtracker link: none (response to https://community.atlantiss.eu/index.php?/topic/18146-gameobject-iron-veins-in-cape-of-stranglethorn/ )Describe your fix: Updated z-coordinate of the iron veins/gold veins in stranglethorn so that they are inside a cave instead of on top of the mountain above it.Account name: TomatoszComment: SQL fix: UPDATE gameobject SET position_z = 5.965284 WHERE guid = 46865 AND id = 1735; UPDATE gameobject SET position_z = 8.875212 WHERE guid = 46866 AND id = 1735; UPDATE gameobject SET position_z = 7.623076 WHERE guid = 46867 AND id = 1735; UPDATE gameobject SET position_z = 16.628172 WHERE guid = 46868 AND id = 1735; UPDATE gameobject SET position_z = 8.906137 WHERE guid = 46869 AND id = 1735; UPDATE gameobject SET position_z = 17.068415 WHERE guid = 46870 AND id = 1735; UPDATE gameobject SET position_z = 17.403341 WHERE guid = 46871 AND id = 1735; UPDATE gameobject SET position_z = 19.822237 WHERE guid = 46872 AND id = 1735; UPDATE gameobject SET position_z = 9.419770 WHERE guid = 46873 AND id = 1735; UPDATE gameobject SET position_z = 10.471601 WHERE guid = 46874 AND id = 1735; UPDATE gameobject SET position_z = 9.070621 WHERE guid = 46875 AND id = 1735; UPDATE gameobject SET position_z = 8.422338 WHERE guid = 46876 AND id = 1735; UPDATE gameobject SET position_z = 19.961760 WHERE guid = 46877 AND id = 1735; UPDATE gameobject SET position_z = 10.968311 WHERE guid = 46878 AND id = 1735; UPDATE gameobject SET position_z = 18.362907 WHERE guid = 46879 AND id = 1735; UPDATE gameobject SET position_z = 9.208426 WHERE guid = 46880 AND id = 1735; UPDATE gameobject SET position_z = 9.180579 WHERE guid = 46881 AND id = 1735; UPDATE gameobject SET position_z = 10.630461 WHERE guid = 46882 AND id = 1735; UPDATE gameobject SET position_z = 17.694248 WHERE guid = 46883 AND id = 1735; UPDATE gameobject SET position_z = 6.982142 WHERE guid = 46884 AND id = 1735; UPDATE gameobject SET position_z = 12.535450 WHERE guid = 46885 AND id = 1735;
  15. Disconnected from server

    Did they log in with their username or with their email address? It should be username, email address will give this error.
×