[GUIDE] A Guide To Working MySQL

[daithi112]

This is a guide on how to use MySQL.

Once you're ready, go to this website to download Navicat Lite. (Navicat Lite is 100% like Navicat, only its free.)
Freeware Navicat MySQL Manager Lite at DirFile - Business & Productivity Tools > Database Management (I've never read everything on the site, all I know is if you go to the 2nd purple bar you will see in small text "Download. ")
If you have the McAfee SiteAdvisor, here's a note: It WILL disapprove of this site, and it will make downloading more complicated, but it can still be done. But other then that, save the file and then go back and run it. (Make sure you save it to the DESKTOP!) After that, go to your desktop and look for an icon labelled, "navicat8lite..." click on it, keep skimming through the stuff and be SURE to check "Create a desktop icon." Once thats done, a new desktop icon will appear: "Navicat Lite for MySQL." Click on it twice, and look for a big button labelled "Connection," near the top left side on the new window.
Let's say for example you get some DataBase information. Here's what the input would sort of look like:

Connection Name: Example
Hostname/IP address: 5.433.195.34
Username: Example
Password: Example45

Then you would click "OK," and then double-click on the "Example" DataBase that just appeared on the left-side list below "Connection." Now that you have the DataBase download, uploaded, and working, its time to make some weapons. Go to this website: WoW Vendetta - Wage Your War and register an account there if you haven't already. Now, once all that is done, look at the middle-bar. Do you see the icons, "Armor Creator, Bag Creator, Jewelry Creator, Weapon Creator, Ammo Creator, Vendor Creator," well, this guide is for making weapons so click on Weapon Creator. You'll see Name (The item's name), Quote (The quote you want on it), Quality, Entry # (The ID you have to enter to get the item in-game. it's the numbers on the end of your URL when your on Wowhead.com or thottbot), and Display ID, The display ID is what the item will look like, you can find it a few ways, the easiest I find is go to http://wow.allakhazam.com/ and go to items look for the one you want it to look like and click on XML (Under the Picture) then look for

 <displayinfo>Display ID of your weapon</displayinfo> 

. Find the display id you want, insert it into the "dispay id" on WoW-V.com, finish the stats and everything you want on the weapon, submit it, download the 1st batch that comes up, right-click on the DataBase Connection, look for "Execute Batch File," click on "..." find the file you made, put it in, download it, and it should work.
If it doesn't work, here are some of the possible problems:

The Entry (.additem) ID you entered is either too long, or already in use.
The batch you downloaded might be a triax batch. (Impossible to download those. =\)
Windows users should download the first batch after making the item on WoW-V. If you download the second and not the first, the download probably will not work.


If you need more help heres my email

[email protected]

P.S. I'm just a n00bie trying to give something back to the community so don't flame me too bad :wave::wave:

[daithi112]

No posts? * Filler*

[daithi112]

26 Views and still no new posts :S /cry

[nilinhow]

only spaming for reputation :P

[daithi112]

No, no i'm not :?

[slate1337]

thankyou for the guide, it helped me.

[project anthrax]

Most guides explain this when a repack is released and you were a little unclear in the weapon part for people just starting they wouldn't know what a display id is or where to get it

[daithi112]

Most guides explain this when a repack is released and you were a little unclear in the weapon part for people just starting they wouldn't know what a display id is or where to get it

Thanks for the feedback :-). I'll add where to get the display ID and what it is now :-) Please leave more feedback after (I want to make the guide better)

[project anthrax]

no problem good try +Rep

[daithi112]

no problem good try +Rep

Thanks :-)

[iPoe]

If nothing else, thanks for the Navicat-Lite. I'm new to the ballgame and was tired of 30 day trial crap, and Heidi incessantly pisses me off. If I could rep you for that, I would.

Edit: I could +rep you for that.

[Umbrielik]

Worked perfect

Thank you so much

[daithi112]

Worked perfect

Thank you so much

How do you have 2 +rep power?

[daithi112]

No longer leecher