All credit for custom items and vendors goes to Pico, and credit for the sql setup goes to lord tom. The purpose of this pack is to make setting up your own private server as EASY and QUICK and PAINLESS as possible. The instructions are incredibly simple:
Download the noobpack:
Filebeam - Free Fast File Hosting
http://filebeam.com/9dc6bd08844b08df76036977c5ab4a48
1) Extract the pack. Extract "extract me..." to your wow directory and run ad.exe. When it's done, move /maps/ to your pico-noobpack folder.
2) Run "start mysql console" and "Ascent Restarter", and click all three start buttons.
3) Set your realmlist to 127.0.0.1 and run wow. Log in with username "test" and password "test".
All done.
COMMON PROBLEMS/FAQ:
The mysql console closes as soon as I open it
Solution: You installed mysql when following someone else's guide. You need to disable or uninstall it before running the included mysql server.
I have a MySQL installation I need to disable
Solution: Press control+alt+delete and click task manager. Open the "Processes" tab and sort by "image name". Find the one that starts with "MySQL", click it, and click End Process.
Ad.exe isn't working/I can't extract my maps
Solution: Make sure ad.exe and the maps folder are in your Program Files/World of Warcraft/ folder (and NOT the /pico-noobpack/ folder). Ad.exe needs to access files from your wow/tbc install to extract the maps.
When I try to log in, I get stuck at the "Connected" dialog
Solution: Click cancel and wait a few seconds. Then select picoswowserver and click okay. Repeat until you successfully log in. This problem usually doesn't repeat itself past the first instance.
I can't extract the repack!
Solution: You need to download winrar. Once it's installed, right click the archive and click "Extract Here".
http://www.rarlab.com/rar/wrar371.exe
How do I edit the database?
Answer: Log in to localhost with username 'root' and password 'root' using your favorite SQL software. I prefer SQLyog:
MySQL GUI Tools, MySQL Monitor, MySQL Manager, MySQL Performance Tuning and Optimization
How do I create more accounts?
Answer: Run the following command sequence after logging in with the test account. Omit ".account flags..." for non-TBC and omit ".account level..." for non-GM.
.createaccount [username] [password] 1
.account flags [username] 8
.account level [username] az
.reloadaccounts
What are some gm commands?
Answer: some basic commands are '.modify level #" to level up, ".invincible" to make mobs ignore you, and ".modify gold #" to add money (sometimes more than 2,000,000,000(cp) will mess you up. Use ".modify gold -#" to remove money). See a full list at:
[Ascent] & [Mangos] GM Commands
How do I change the server's name?
Answer: Open realms.conf in notepad and at the bottom, replace "picoswowserver" with "your desired name".
How do I make this server public?
Answer: This is a (comparatively) long process, and not for noobs. As such, I won't cover it here in this guide. If you're willing to give it a try anyway, try this thread:
How To make your Server Public [Hamachi AND Non-Hamachi] - MMOwned - World of Warcraft Exploits, Hacks, Bots and Guides
How do I create weapons/armor/items/vendors/mobs?
Answer: I suggest you give Ascent Database Editor a try. You can find the link here:
Ascent Database Editor [Update: Dec 12 2007] - MMOwned - World of Warcraft Exploits, Hacks, Bots and Guides
How can I minimize all these consoles to the system tray?
Answer: Use trayit! Once it's running, just ctrl+click the minimize button, and your windows are in the system tray.
http://www.trayit.com/trayit/trayit.zip