{"issue":{"state":"open","pull_request":{"diff_url":null,"html_url":null,"patch_url":null},"user":{"avatar_url":"https://secure.gravatar.com/avatar/1ba10162757e49008642aca2e0f661a1?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"1ba10162757e49008642aca2e0f661a1","url":"https://api.github.com/users/shlomi1515","login":"shlomi1515","id":1033904},"milestone":null,"assignee":null,"labels":[{"name":"Database-Quests","color":"02d7e1","url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Database-Quests"}],"updated_at":"2011-11-02T02:13:01Z","comments":3,"closed_at":null,"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/3763","body":"Hey guys\r\n\r\njust wanted to bring this problem to your attetion that these 2 factions, Oracle & Frenzyheart\r\nare bugged cuz their daily quests are missing and no rep can be gain...\r\n\r\nplease check this....\r\n\r\nHash: 199bcf1\r\nTdb: 335.11.42+","html_url":"https://github.com/TrinityCore/TrinityCore/issues/3763","number":3763,"title":"[Oracle & Frenzyheart] Daliy Quest are missing","id":2099558,"created_at":"2011-10-31T17:22:26Z"},"action":"created","comment":{"user":{"avatar_url":"https://secure.gravatar.com/avatar/25ebefcabb278f5416fde8bb03f44e9f?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"25ebefcabb278f5416fde8bb03f44e9f","url":"https://api.github.com/users/tREAk","login":"tREAk","id":649401},"updated_at":"2011-11-02T02:13:00Z","url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/2598875","body":"works fine on 'my' server - i work on scripts till they are working :). if they aren't i wouldn't commit them ^^\r\n\r\nmay trey another `entry` because is used customized number's\r\n\r\n```sql\r\nSET @POOL_ENTRY :=XXXXX;\r\n\r\nDELETE FROM `pool_template` WHERE `entry` IN (@POOL_ENTRY+0,@POOL_ENTRY+1,@POOL_ENTRY+2,@POOL_ENTRY+3);\r\nINSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES\r\n(@POOL_ENTRY+0,1,'Oracle Soo-nee - Oracle Dailies'),\r\n(@POOL_ENTRY+1,1,'Oracle Soo-dow - Oracle Dailies'),\r\n(@POOL_ENTRY+2,1,'Rejek - Frenzyheart Tribe Dailies'),\r\n(@POOL_ENTRY+3,1,'Vekgar - Frenzyheart Tribe Dailies');\r\n\r\nDELETE FROM `pool_quest` WHERE `entry` IN (12735,12736,12737,12726,12761,12762,12705,12758,12734,12741,12732,12703,12760,12759);\r\nINSERT INTO `pool_quest` (`entry`,`pool_entry`,`description`) VALUES\r\n-- ORACLE\r\n-- Oracle Soo-nee\r\n(12735,@POOL_ENTRY+0,'A Cleansing Song / Oracle Daily / Oracle Soo-nee'),\r\n(12736,@POOL_ENTRY+0,'Song of Fecundity / Oracle Daily / Oracle Soo-nee'),\r\n(12737,@POOL_ENTRY+0,'Song of Reflection / Oracle Daily / Oracle Soo-nee'),\r\n(12726,@POOL_ENTRY+0,'Song of Wind and Water / Oracle Daily / Oracle Soo-nee'),\r\n-- Oracle Soo-dow\r\n(12761,@POOL_ENTRY+1,'Mastery of the Crystals / Oracle Daily / Oracle Soo-dow'),\r\n(12762,@POOL_ENTRY+1,'Power of the Great Ones / Oracle Daily / Oracle Soo-dow'),\r\n(12705,@POOL_ENTRY+1,'Will of the Titans / Oracle Daily / Oracle Soo-dow'),\r\n-- FRENZYHEART TRIBE\r\n-- Rejek\r\n(12758,@POOL_ENTRY+2,'A Heros''s Headgear / Frenzyheart Tribe Daily / Rejek'),\r\n(12734,@POOL_ENTRY+2,'Rejek: First Blood / Frenzyheart Tribe Daily / Rejek'),\r\n(12741,@POOL_ENTRY+2,'Strength of the Tempest / Frenzyheart Tribe Daily / Rejek'),\r\n(12732,@POOL_ENTRY+2,'The Heartblood''s Strength / Frenzyheart Tribe Daily / Rejek'),\r\n-- Vekgar\r\n(12703,@POOL_ENTRY+3,'Kartak''s Rampage / Frenzyheart Tribe Daily / Vekgar'),\r\n(12760,@POOL_ENTRY+3,'Secret Strength of the Frenzyheart / Frenzyheart Tribe Daily / Vekgar'),\r\n(12759,@POOL_ENTRY+3,'Tools of War / Frenzyheart Tribe Daily / Vekgar');\r\n```\r\ni also fixed all quests which were not working. if you want to look at my scripts ask me :)","id":2598875,"created_at":"2011-11-02T02:13:00Z"}}