Leaderboard

Thank you very much. It helped me with my Error.

i think you can fix it in db, try to check what you have in realmd --> realmlist realmflags i have standart and all works fine

Hey Fyre! Appreciate the guide. I've been playing around with private servers lately and learning how to do a few things. Your guide is super helpful! I created my first quest today and put my cat in the game. Super fitting for her lol.

Hi phraggers, Your error is actually showing you that you have not updated your database to where it's expected to be. You need to apply some database updates first. When you're looking to integrate your new table into your core, you will use C++ for the communication. You can see an example of this when I did something similar: https://github.com/mangoszero/server/commit/6483e7de74211b02aa1c716ba4cc063ff86f4265 May I ask what your added tables do?

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;

Nice!