The Preparation

1. Download Navicat
2. Download MySQL
3. Download the Server Files(download the Druid fix)
4. Download the Database


The Installation

1. Install and Run MySQL and Navicat. Screen Shot
2. 2x click on Localhost or click on connection connect to your DB.
3. Add a new database by right clicking anywhere in the whitebox under the Localhost. New database > use WoW for the name
4. You should now see your WoW database, right click on it and hit execute batch file and locate the WoW.sql file.
5. After the installation you should get NO errors.
6. You should see a list of tables in the box to the right (Accounts, Char_accounts, Characters...etc)
7. 2x click on the Accounts Table
8. Click on the "+" on the bottom and fill in the fields. Altought passwords do not work yet, they are still required to use the !Login feature which requires the password(GM is also the admin/moderation level, 127 is full access, 0 is normal user)
9. Goto Navicat and click on manage users; Add user
Username: WoW
Host: localhost
Password: Root(or what you want to use)
Password Confirm: Same as above
Click ok
10. (while still in manage users) Click on Wow@localhost > Grant All and then exit out and click Yes when it asks you to flush privelages


Setting up the Server

1. run Wowpython.exe
2. Type
host localhost
db localhost WoW password WoW
Start
and you should see the server start without warnings


Log On!

1. Open World of Warcraft and goto the console (by press "~")
2. type Realmlist localhost or realmlist your-ip-here
3. Type in the Account name from above and any password. Select the Server and start playing.


All Alone? Edit the Server!

1. type !login password (the password is the one you set in the table)
2. Tp spawn a creature/npc type !npc mobs <ID> <Flags> <Faction> <Level> <Name>
E.X !npc mobs 57 0 2 3 Tester
Results: Produces a Pink monster with a level of 3: Name Tester and its an Enemy.
Lets break it down
57 = Model ID number ; Each number has a different character, but many ma result in a box with a face on it
0 = npc type (see below)
Code:
0: Common npc, no stuff   1: Talking npc, no stuff
  2: Questgiver         4: Vendor         8: Taxi       16: Trainer     64: Banker  
128: BagSlotVendor 256: Inn Keeper 512: Tabard 1024: Talking   2048: Auction

2 = Faction (or what side)
Code:
0 = neutral
1= Friendly
3 = Enemy

3 = the level (0-255)
tester = name (pick what you want)
And they spawn at your current location


Other Information

I wil edit this post with more info on things later but this should get you going for now
Look at the Commands table in Navicat click on the memo button and then a text box should appear on the lower 1/2 of the screen. For each command in the table highlight the (memo) to get the information on the command


马上要去上课了，上课回来再补上图
有不明白的地方问我哈
相关程序请到FTP下载

全英文啊

如果我每天都不上课，倒还有时间翻译

我扎没有国度呢

图图

图和文字有点不一样
以文字为准

还是不太明白



主要是不会sql..


老是说连不上sql...