[Ascent] Server Guide

1. MySQL Server 5.1

2. SQLyog MySQL GUI - Community Edition (For importing) and Navicat for MySQL (For editing, optional)

3. Microsoft .NET Framework 2.0

4. Ascent Compile: Ascent Server Files

5. Character Database: Ascent Server Files

6. World Database: Ascent Server Files

7. 2.2.3 or 2.3.0 Maps (Ascent Server Files): You can download the ones I have prepacked which are for enUS, or you can use the map extractor in the Ascent Compile to extract your own. If you are extracting your own skip down to Extracting Your Own Maps.

8. 2.2.3 or 2.3.0 DBC: Included in all of the Ascent Compiles.


- Run the executable you downloaded from the requirements.
- Choose Typical as the setup type.
- Install the program.
- When it's done installing, make sure Configure the MySQL Server now box is checked.
- Choose Standard Configuration.
- Check Install As Windows Service.
- On the security settings, check Modify Security Settings and enter whatever you want as the password.
- Hit Next, then Execute, then Finish.
2. Importing the Databases
- Install SQLyog. Navicat is optional since it's mainly used for editing, but SQLyog is necessary.
- Once it's installed, open SQLyog.
- Create two databases: One called world and another called character.
- Right click on the character database and click Restore From SQL Dump.
- Find the character database I provided, choose it, and click Execute.
- Now it's time for the world database. Go into the world folder you downloaded. There will be a batch file called Tool.
- Right click the file and select Edit.
- There will be two things that you must change: username, passwd.
- Change username to root.
- Change passwd to whatever you made it in the MySQL setup.
- Save the file and run it.
- It will ask for a letter to do an option, type w to import the database.
- After it is done, close the program.
3. Configuring the Ascent Files [LAN]
- There will be three files that you need to edit: ascent.conf, logonserver.conf, and realms.conf.
- Open ascent.conf with Notepad. Everything that needs to be edited is in red.

Code:
[size=7]#######################################################################
# Ascent Configuration File
# Last Update: $Id: ascent.conf 2080 2007-10-27 13:48:07Z burlex $
#######################################################################

/********************************************************************************
* How to use this config file: *
* Config files are in a block->variable->setting format. *
* A < signifies the opening of a block, the block name is expected after that. *
* After the block name, a space and then the settings sperated by = / ' '. *
* *
* e.g. *
* *
* *
* Comments can be in C format, e.g. /* some stuff */, with a // at the start *
* of the line, or in shell format (#). *
********************************************************************************/

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Database Section
#
# Database.Host - The hostname that the database is located on
# Database.Username - The username used for the mysql connection
# Database.Password - The password used for the mysql connection
# Database.Name - The database name
# Database.Port - Port that MySQL listens on. Usually 3306.
# Database.Type - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = Oracle 10g
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

host" Username = "username" Password = "passwd" Name = "database" Port = "3306" Type = "1">
host" Username = "username" Password = "passwd" Name = "database" Port = "3306" Type = "1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Listen Config
#
# Host
# This is the address that the server will listen on.
# To listen on all addresses, set it to 0.0.0.0
# Default: 127.0.0.1 (localhost)
#
# WorldServerPort
# This is the port that the world server listens on.
# It has to be the same as what is specified in the
# realms table in the LogonDatabase.
# Default: 8129
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#


WorldServerPort = "8129">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Log Level Setup
#
# Console Logging Level
# This directive controls how much output the server will
# display in it's console. Set to 0 for none, or -1 to disable.
# -1 = Disabled; 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 3
#
# World server packet logging feature
# If this directive is turned on, a file called `world.log`
# will be created in the server's directory and all packets
# sent and received by clients will be dumped here in bfg
# format.
# Default: 0
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#




#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Server Settings
#
# PlayerLimit
# This directive controls the amount of sessions that will be
# accepted by the server before it starts to add people to
# the server queue.
# Default: 100
#
# PlrUpdateDistance
# This directive controls the distance (internal yards) that the player can "see" up to
# and receieve updates for. For smaller servers, you can probably increase this number.
# Increasing this number will also increase the servers bandwidth consumption and CPU usage.
# Default: 80
#
# Motd
# This message will be displayed by the server in the chat
# box every time any user logs on. Colors can be used in the
# standard WoW format.
# Default: "No MOTD specified
#
# Send Build On Join
# This directive controls whether the server's internal revision
# will be sent to clients upon entering the world. Use it to help
# testers report bugs.
#
# Send Stats On Join
# This directive controls whether the server will send the online player
# count to a cilent when it enters the world.
#
# Breathing Setup
# If the breathing code is causing problems or you want to run a fun server, you can disable
# water checks by enabling this directive.
# Default: 1
#
# Level Cap
# This variable controls the level that stats will be generated up to internally.
# Beyond this level players can still see a higher level visually but their stats won't
# increase beyond this point.
# Default: 60
#
# Expansion 1 Level Cap
# This variable does the same thing as Level Cap above, except it applies to those who
# have the first expansion: The Burning Crusade.
# Default: 70
#
# Seperate Channels Control
# This directive controls whether horde and alliance chats will be seperated across channels.
# Set to 1 for blizzlike seperated channels, or 0 to allow horde/alliance to speak to each other
# across channels.
# Default: 0
#
# Compression Threshold
# This directive controls the limit when update packets will be compressed using deflate.
# For lower-bandwidth servers use a lower value at the cost of cpu time.
# Default: 1000
#
# Queue Update Rate
# This directive controls how many milliseconds (ms) between the updates
# that the queued players receieve telling them their position in the queue.
# Default: 5000 (5 seconds).
#
# Kick AFK Players
# Time in milliseconds (ms) that a player will be kicked after they go afk.
# Default: 0 (disabled)
#
# Connection Timeout
# This directive specifies the amount of seconds that the client will be disconnected
# after if no ping packet is sent. It is advised to leave it at the default.
# Default: 180
#
# Realm Type
# This is the realm type that will be used by the server to handle world pvp.
# Default: 0 (pve)(RPPVE)
# Other values: 1(pvp)(RPPVP)
#
# AdjustPriority
# Set the server to high process priority?
# Default: 0
#
# RequireAllSignatures
# This directive controls whether the full 10 signatures will be required in order
# to turn in a petition. Smaller servers would be better off having it turned off.
# Default: off
#
# ShowGMInWhoList
# This directive controls whether GM's will be shown in player's who lists or not.
# Default: on
#
# MapUnloadTime
# This directive controls whether to unload map cells after an idle period of seconds.
# Use on smaller servers or servers that are memory-limited. The server without cell unloading
# can use over 1.2GB memory with all creatures loaded.
# Default: 0
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#