Jump to content

Fyre

Members
  • Posts

    15
  • Joined

  • Last visited

  • Days Won

    1
  • Donations

    0.00 GBP 

Fyre last won the day on March 10

Fyre had the most liked content!

Core Infomation

  • Core
    Zero
    One
    Two
    Three

Contact Methods

  • Discord
    @Fyre#0477
  • Website URL
    https://github.com/i-am-fyre

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Fyre's Achievements

Member

Member (2/3)

1

Reputation

  1. Sauranok Will Point The Way - Quest Text When going in to complete this quest, Sauranok had very strange text. It only read: "mage." It wasn't capitalized, it didn't have any structure to it, etc. First I needed to find the quest id. I used the SQL 'LIKE' statement to search with wildcards - I could have just done it with an = and no %'s... but I wanted to show you some other methods. I could have gone LIKE "%Sauranok%", and it may have given me more options in the output that I would need to pick from. SELECT `Entry`, `Title` FROM `quest_template` WHERE `Title` LIKE "%Sauranok Will Point The Way%"; The output was: +-------+-----------------------------+ | Entry | Title | +-------+-----------------------------+ | 28909 | Sauranok Will Point the Way | +-------+-----------------------------+ Okay - so Quest ID/Entry = 28909. Because I couldn't remember the correct column name for the part of the window that was showing me "mage.", I needed to do the following: SELECT * FROM `quest_template` WHERE `Entry` = 28049; I'm not going to post the output this time, because it would be very long and messy. But I noticed that OfferRewardText was equal to: "$c." $c is a variable for "class", so... because I was playing a Mage, it displayed "mage." I needed to find the correct text for this, so I went to Youtube and found a 10 year old video (around the time of actual Cataclysm). It showed me the following text: <Sauranok nods toward you> Paladin. So, oddly enough the text quest was essentially correct - it's just the class name. However, there does seem to be an extra line above it, and the class name should be capitalised. The formatting for this uses "$B" to go to a new line. For more information on these variables, see here. The final SQL fix for this one was: UPDATE `quest_template` SET `OfferRewardText` = "<Sauranok nods toward you.>$B$B$C." WHERE `Entry` = 28909;
  2. Echo Island Tiki Targets Are Chasing Me! When attacking these Tiki Targets on Echo Isles, they were moving around towards the player. That's incorrect behaviour - they should remain stationary. I began by using the ingame chat command: ".npc info" to get the creature Entry #38038. Now I could go into my database and begin looking to see what the UnitFlags were (this is where I suspected I would need to apply my fix). SELECT `Entry`, `Name`, `UnitFlags` FROM `creature_template` WHERE `Entry` = 38038; The output was: +-------+-------------+-----------+ | Entry | Name | UnitFlags | +-------+-------------+-----------+ | 38038 | Tiki Target | 393216 | +-------+-------------+-----------+ Time to go to the creature template documentation for UnitFlags. Starting with the UnitFlags value, let's subtract the largest possible flag. 393216 - 262144 (UNIT_FLAG_STUNNED) = 131072 131072 - 131072 (UNIT_FLAG_PACIFIED) = 0 Stunned and Pacified made sense to me. I did do some comparisons with other Target Dummies (who also stay stationary when attacked), they - most of the time - had the same flags. So I guess the flags weren't the problem this time. I did do a lot of trial and error with numerous different strategies, values, etc. and finally the thing that worked was... AIName (see documentation here). SELECT `Entry`, `Name`, `AIName` FROM `creature_template` WHERE `Entry` = 38038; The output was: +-------+-------------+--------+ | Entry | Name | AIName | +-------+-------------+--------+ | 38038 | Tiki Target | | +-------+-------------+--------+ I didn't really like the description for any of the AIName values in the documentation. The one that sounded most correct was NullAI --> Do nothing. Same as empty string. > Do nothing... that sounds perfect! > Same as empty string... but I already have an empty string? I decided to try putting NullAI into there - couldn't hurt, right? IT WORKED! It actually worked! My final SQL fix for this was: UPDATE `creature_template` SET `AIName` = "NullAI" WHERE `Entry` = 38038;
  3. Auctioneer Drezmit's Gossip Window Fix When clicking on the auctioneers to open the auction house, Auctioneer Drezmit would open up a gossip dialog window. Based on a comparison of him and his three neighbours (using the ingame chat command: .npc info), I determined that the NpcFlag was probably the culprit. I did a nice quick comparison in my mangos_world3 database. SELECT `Entry`, `Name`, NpcFlags` FROM `creature_template` WHERE `Entry` IN (44865, 44866, 44867, 44868); The output was as such: +----------+---------------------+-----------+ | Entry | Name | NpcFlags | +----------+---------------------+-----------+ | 44865 | Auctioneer Fazdran | 2097152 | | 44866 | Auctioneer Drezmit | 2097155 | | 44867 | Auctioneer Ralinza | 2097152 | | 44868 | Auctioneer Xifa | 2097152 | +----------+---------------------+-----------+ I used the creature template documentation (NpcFlags) to determine what the NpcFlags meant. The best way is to start with the largest value that fits into the flag. With a flag of 2097152, there is a perfect fitting "2097152" flag which is for: UNIT_NPC_FLAG_AUCTIONEER. Well - that makes sense for Fazdran, Ralinza, and Xifa. Drezmit however has some flags left over. 2097155 - 2097152 = 3 The next largest flag that fits into there is "2" which is for: UNIT_NPC_FLAG_QUESTGIVER, which, as I'm sure you have already guessed... is for quest givers. That leaves us with: 3 - 2 = 1. And now we can fit one last flag into there with a value of "1": UNIT_NPC_FLAG_GOSSIP. Well, I've never heard of auctioneers handling out quests or providing gossip. So I was pretty sure that I could change Drezmit's NpcFlags to 2097152. "Fun" story about this one. I had originally submitted a fix to the GitHub repo which removed the extra NPCFlags for quest giver and gossip, only to have a recurring thought in the back of my head... "check the quests." So I needed to find a quest that was started by Drezmit in order to confirm this. I used the quest_relations table to find this. SELECT * FROM `quest_relations` WHERE `entry` = 44866; The output was: +-------+-------+-------+------+ | actor | entry | quest | role | +-------+-------+-------+------+ | 0 | 44866 | 29416 | 1 | | 0 | 44866 | 29425 | 0 | +-------+-------+-------+------+ Role of 0 = starts a quest, Role of 1 = ends a quest. So we know that he starts quest #29425 and ends quest #29416. For the purpose of this tutorial, it doesn't really matter what those quests are - we just needed to know if he was Quest Giver or not. So I had to provide a 2nd pull request on Github to fix this mistake. My final SQL fix was: UPDATE `creature_template` SET `NpcFlags` = 2097154 WHERE `Entry` = 44866; NpcFlags value of 2097154 = Quest Giver + Auctioneer. So in the end, we just removed the Gossip flag. I did go back and test a few things to make sure his behaviour was still correct when the quest was available and after it was completed. Things seemed appropriate, so I felt comfortable with that final fix.
  4. Hello everyone! Over the past couple of weeks, I have begun to tackle some database fixes for the MaNGOS Three core (Cataclysm). I wanted to share with you the process in how each one was accomplished. Hopefully this helps you to learn some new techniques and can try applying them to improve the MaNGOS projects! I'll post the link to the video, and a written description below for each one as well. Each week (hopefully), I'll upload another one, and continue to post them here. I'm usually hanging around the MaNGOS Discord if you ever want to chat, work on something together, or get some ideas. Thanks! Fyre 🔥 Quest Fixes Sauranok Will Point The Way - Quest Text NPC Fixes Auctioneer Drezmit's Gossip Window Fix Echo Island Tiki Targets Are Chasing Me!
  5. Glad to hear that you figured it out!
  6. Hi tinytomcruise, I was checking out that video you linked. That's for a repack. Unfortunately we don't support the repacks here, but there should be a readme in the files for a discord link. That being said, we would love to encourage you to stick around with MaNGOS and build from scratch using the link following guide from Antz: https://www.getmangos.eu/wiki/documentation/installation-guides/guideswindows/installing-mangos-on-windows-using-easybuild-r20064/
  7. Nalorakk has a starting script that he sends a group of adds down to fight you, then he runs up the next flight of stairs, and repeats until he's at his platform. However, currently he sets down the first set of adds and then never moves. So he is unfightable. Video (@ ~5:15):
  8. Terestian Illhoof in Karazhan currently has two Kil'rek imps spawned. One is a creature the other is a pet. What is supposed to happen: - Kil'rek is spawned beside Terestian Illhoof. - ~45 seconds after Kil'rek is killed, he is summoned again. So right now, there are too many Kil'rek imps spawned at the start of the fight. Video:
  9. Prince Malchezaar in Karazhan is supposed to summon infernals around his platform throughout the duration of the fight. These infernals should be non-targetable, stationary, and produce a hellfire for the duration they are spawned. I checked M2, and they seem to be working properly. MaNGOS SD3 link: https://github.com/mangos/ScriptDev3/blob/master/scripts/eastern_kingdoms/karazhan/boss_prince_malchezaar.cpp I also looked up a few other scripts from different cores: - https://github.com/cmangos/mangos-tbc/blob/master/src/game/AI/ScriptDevAI/scripts/eastern_kingdoms/karazhan/boss_prince_malchezaar.cpp - https://github.com/ccshiro/corecraft/blob/master/scriptdev2/scripts/eastern_kingdoms/karazhan/boss_prince_malchezaar.cpp
  10. Another good place to take a look for some ideas would be the Eluna Releases forum here. https://www.getmangos.eu/forums/forum/121-releases/ You can open up some of those links and check out how people did some really cool stuff!
  11. Hi! Are you able to provide any screenshots, logs, etc? Without knowing exactly what is wrong, it is difficult for anyone to help you out. Thanks, Fyre
  12. When looking at the `db_scripts` table, I noticed that `script_guid` 631 spawns "Spectral Chalice". MariaDB [mangos_world1]> SELECT `script_guid`, `id`, `datalong`, `comments` FROM `db_scripts` WHERE `id`=194502; +-------------+--------+----------+------------------------+ | script_guid | id | datalong | comments | +-------------+--------+----------+------------------------+ | 631 | 194502 | 19214 | spawn Spectral Chalice | +-------------+--------+----------+------------------------+ 1 row in set (0.002 sec) The `datalong` has a value of 19214 and indicates that it should spawn the corresponding object from the `gameobject` table. When we look at the corresponding guid we get... MariaDB [mangos_world1]> SELECT `guid`, `id` FROM `gameobject` WHERE `guid`=19214; +-------+--------+ | guid | id | +-------+--------+ | 19214 | 176583 | +-------+--------+ 1 row in set (0.001 sec) Now the `id` in this table corresponds to an object in the `gameobject_template` table, which brings us to... MariaDB [mangos_world1]> SELECT `entry`, `name` FROM `gameobject_template` WHERE `entry`=176583; +--------+---------------+ | entry | name | +--------+---------------+ | 176583 | Golden Sansam | +--------+---------------+ 1 row in set (0.000 sec) -- Wait a second... Golden Sansam? Should be "Spectral Chalice". MariaDB [mangos_world1]> SELECT `entry`, `name` FROM `gameobject_template` WHERE `name`="Spectral Chalice"; +--------+------------------+ | entry | name | +--------+------------------+ | 164869 | Spectral Chalice | +--------+------------------+ 1 row in set (0.001 sec) Note: I did not confirm whether or not this is odd behaviour in M1 - just noticed it within the db itself.
  13. @汪可微 @onixiyaI noticed that on line #47 it says INSERT INTO `creature_TEMPLATE` where it should say INSERT INTO `creature_template`. Change the capital TEMPLATE to all lowercase, and it will work. I've spoken with @Necrovoice and he should be updating the github repo as well.
  14. On MangosZero, tooltip states: "You carry the Touch of Zanzil. The poison courses through your veins. Seek aid!" Based on WowHead comments, it is supposed to do the following: It reduces your Agility by 15 and enemies can see you through stealth as if you were not even stealthed. However, by casting "Stealth" it removed the poison permanently.
  15. Spell Name: Wyvern Sting (Rank 1-3) DB Links: Rank 1: https://classicdb.ch/?spell=19386 Rank 2: https://classicdb.ch/?spell=24132 Rank 3: https://classicdb.ch/?spell=24133 Problem: Rank 1 does not break sleep when the mob is attacked (melee, range, or spell damage). After 12 seconds sleep does break (as is per tooltip), but does not apply a DoT. Rank 2 does not break sleep when the mob is attacked (melee, range, or spell damage). After 12 seconds sleep does break (as is per tooltip), but does not apply a DoT. Rank 3 does not break sleep when the mob is attacked (melee, range, or spell damage). After 12 seconds sleep does break (as is per tooltip), but does not apply a DoT.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use