[GUIDE] Adding Custom Items to a Quest

[razordemon]

RAZORDEMON GUIDES

If you've been looking for a tutorial on how to create and correctly import custom items, as well as import standard Blizzard quests, you've come to the right place to acquire the knowhow. Feel free to link this tutorial on other sites, or copy it and put it up at another location as long as you give your references (to the AC team for the wonderful repack, and me for making the tutorial and offering an easy-access-place to download files). I also update this tutorial often, and if you send me private requests to either type up your tutorial for you, or make a new one on request, simply send me a private message saying so. I've also added a text document copy to my file share for all to download and redistribute.

Before I begin, I need to say that I greatly appreciate the opportunities that Ascent offers me and everyone else. If you run into trouble, don't give up! If worst comes to worst, simply reinstall your repack and start over. Injecting things into a MySQL database of any kind is easy if you have the proper tools, guidance, and determination. I once knew absolutely nothing about how to do any of this, just like you.

This will be easy to follow, and easy to do. Some portions may seem complicated, but in all actuality, if you follow my provided instructions, it should be a breeze.

Note: I'll do my best to answer any questions, but don't make your question sound like you have Tourettes Syndrome or like you don't have any grasp on the English language (don't be scared, I don't flame people ever; I'm friendly, and I'll help you if I can).

For the importing of quests, you will need:

- HeidiSQL v3.2

- Quests and Quests2 from my file share.

- I recommend the latest repack for practically guaranteed compatibility [AC-WEB 7.7]. And yes, Ascent is far superior in all aspects to MaNGOS.

To Import Quests (includes some troubleshooting information):

1.) Install HeidiSQL if you haven't already. When asked whether or not to associate SQL files with HeidiSQL, choose yes. Once completed with that process, move on to step two.

2.) Open your server control panel, and boot up the entire server; MySQL, Apache2, the Logonserver, and Ascent. Open HeidiSQL as well. To connect to your server with HeidiSQL, use whatever description you'd like, enter 127.0.0.1 for your server if it is private for you, or, if it happens to be remote, use your remote server's address. Use "root" for the user name, and "ascent" for the password. If you changed your SQL login at some point before this tutorial, obviously you will need to use your new login username and password. Port 3306. Connect.

3.) In the menu on the very left, it will have something like...

+information_schema
+ascent
+forum
+joomla

etc. Select Ascent if it is not already selected. In the large list that popped up in the inner window, scroll down, and double click on "Quests". Not "Quests Localized". Not that one, Quests is the one. On the tabs above that list, select "Query". The buttons in the Query tab: blue arrow, speeding blue arrow, folder, binoculars, etc. We want the folder button. Press it. Remember the "Quests and Quests2" files that you downloaded? Time for those. Search for where you downloaded them (hopefully you chose your desktop... would make it plenty easier) select "quests" (not quests2), and hit the open button.

4.) * * * Read this entire step before continuing! Press the plain blue arrow. When you have started injecting the quest files, do not disturb your PC (open any windows or anything), because if you do, it may crash HeidiSQL. Just wait for it to finish, about ten minutes or so for each separate Quests file. If it does crash, reopen HeidiSQL and go to your Quests table where you were just attempting to inject the files in to, and right click on the Quests table itself. Select the option "Empty...", and then attempt to reload the files. DO NOT DELETE THE TABLE. Make sure that you close Instant Messengers and other things in order to avoid interrupting HeidiSQL. * * *

5.) When you have finished importing "Quests", do the exact same process with "Quests2". Remember to pay attention to my warning!

6.) When it is all finished, close HeidiSQL and your entire server down, restart the server, and enjoy Blizzard's quests.



For the importing of items, you will need:

- HeidiSQL as well, there's a link to download it toward the beginning of the post.

- An account registered at this website. When you have an account registered, log in and go to the following links for the creation of items:

- Weapons

- Armors

- Bags

- Jewelry

- Ammo

Use this picture as reference. First, make sure that you have everything selected as it is in the picture. Copy this (click the link to see) and paste it into the larger white area that I have circled with an arrow pointing to it, and then click the plain blue arrow to inject it.

- Go to Item ID Finder, and punch in the name of the Item you want your custom item to look like, and select it from the options that appear. I recommend instead of punching in "Lord General's Sword" that you put in "Lord". The website doesn't seem to like to respond to direct searches. When it comes back with the items, hit "Ctrl+F" and simply search for your item. Select your item, and hit the "Query" button at the bottom.

It will appear with something like this: "The display ID of Lord General's Sword, with an entry ID of 11817, is 21809." You want that last number in the sentence. It is the display ID. It will make your item look like what it is supposed to in the game world, but, of course, with your custom stats. I recommend booting up your server and typing in ".recall port gmis" to get to the GM Island with custom vendors. They sell some nice looking gear that you can search for and get the Display ID for.

Note: look at the note after these steps for an important notes that may clarify a couple things that may be confusing, and, it may save a server operator from having his server crash all the time. So yes, you should read the notes.

How to Inject Items:

1.) Boot up your server. Apache, MySQL, all of it.

2.) Start up HeidiSQL, and connect to your Ascent MySQL database.

3.) Go to Ascent in the left menu, and scroll down to "Items". Select it, and click on the "Query" tab.

4.) Create your item at WoW Vendetta, and, in the FIRST BOX OF SQL TEXT it come back with, select ALL OF THE TEXT, copy it, go back to HeidiSQL, paste it into "SQL-Query on Database *whatever-you-named-your-database-description*:" REMEMBER THE ENTRY NUMBER YOU GAVE YOUR ITEM, better yet, write the number down and put the Item's name along with it for a note.

5.) Hit the blue arrow, and after it imports it into your Ascent (it should finish right after you click the button), close Heidi (or if you made more items, repeat steps 3-5 until you are finished importing items) and restart your server. If you followed these steps correctly, the weapon will work according to the stats you gave it, and will look like the item you used for its Display ID (the item's icon may simply be a question mark, and if it happens to be a bag, when you equip it [if it is a question mark] the bag will not show up in bags one through backpack, but you will be able to click on them and open them just the same).


Notes:

First of all, I hope you enjoyed this tutorial, and I hope it works for you. If not, please feel free to ask me questions, and I will do my best to answer it and help you.

Now, to the main point. While creating your item, you are probably tempted to make it amazingly powerful. Massive damage, huge resistances, and loads of stats and armor, etc. That is fine, it will not malfunction if you slap huge numbers on it (keep everything under 75000, regardless of what it is). While creating your weapon, you probably noticed that the site warned you in red text about the server not being able to calculate the stats and numbers correctly because they were huge. Well, for the most part, this is not correct. If you are doing a private server just for yourself, it will not do anything except perhaps gobble more of your CPU and memory/pagefile usage.

If you give a bunch of people in your server gear with crazy stats, it will make your server a'splode. Be smart; you know that not everyone should be getting "Donor and GM/Admin Gear", and that it may cause some CPU and Memory hogging, if not a complete crash of the server due to too large of calculations to make from extremely overpowered gear (gear like 1,000,000 dps with +10000000000 stamina and strength, for example).

If you have any questions please post.
Look for more RAZORDEMON GUIDES

[Sambah]

nice guid! I knew some of it but you helped me out on more parts! thanks! (if i could give rep i would) Thanks for the info!

[Jackie Moon]

WoW man a WoW-V guide how fail and do put a item in a quest just go to where you made your quest and change the rewitem column and put the WoW-V ID

[antid2]

omg been wondering this, thank you SO MUCH

[Warlord540]

Nice guide but i use mangos can i get a guide for tht? +rep

[darkyslay]

ok but i dont understand i cant get the quest files to work

[darkyslay]

do i need the lates .net framework??