To start you need:
MySQL MySQL
SQLyog Webyog
A new repack Chrispee (2.2)
2DGreenGiant 2.3
Dryice 2.3 (Stable) (Reccomended)
there is a video at the bottom for you to follow with, the text will help if you cant see things on the smaller screen or don't understand some steps.
Lets begin!
Begin the MySQL installation
When you are asked, select Detailed Configuration.
Here, put in the password you will be using. Remember this!
You will then be promted to execute for the connection, just hit execute and wait. In the video I get a firewall error. My firewall automaticly updates its configuration so I just hit retry but others may need to open ports or turn off the firewall.
Now install SQLyog.
Its a basic install, not much needed to do.
Turn it on and create your new connection.
Use the MySQL password. Don't change localhost.
After that you are brought to the main screen.
Right click on the connection and create a database.
Now you need to bring in your SQL file.
Right click on your database and click "Restore from SQL dump"
Select the SQL from the repack.
It will begin loading, this can take from 10mins - 1hour depending on comp.
Conf edits. I will highlight anything that should/can be changed. Red is mandatory, blue is optional. I wll explain things after each conf.
Realmserver.conf
Code:
#####################################################################################
# Realms Configuration File #
# #
# ~*~AscentEmu~*~ #
# Revision Author: Gastricpenguin #
# Revision Number: 1752 #
# #
#####################################################################################
#####################################################################################
# LogonServer Section
#
# Address:
# The address (no port) of the server.
#
# Port:
# The port on which the logon server listens. (*** NOT 3724 ***)
#
# Name:
# Not really relavant, but name the logon.
#
# RealmCount:
# The number of realms in the next section.
#
#####################################################################################
<LogonServer Address = "IP ADRESS HERE"
Port = "8093"
Name = "Name of connection, nothing really."
RealmCount = "1">
#####################################################################################
# Realm Section
#
# Name:
# The name of the realm.
#
# Address:
# The address (and port) of that realm.
#
# Icon:
# The type of realm (PVP, Normal, RPPVP, RP)
#
# Colour:
# Realm colour in realm list display.
#
# TimeZone:
# Time zone the realm is in.
#
# Population:
# (0 = low, 1 = medium, 2 = high)
#
#####################################################################################
<Realm1 Name = "Enigma WoW"
Address = "IP ADRESS HERE:8129"
Icon = "Normal"
Colour = "1"
Population = "0"
TimeZone = "1">
IP adress is the important thing here.
127.0.0.1 (Non-Public)
Hamachi - 5.something (Top of hamachi window)
Dynamic- Whatever the dynamic IP is.
Logonserver.conf
Code:
#####################################################################################
# Logonserver Configuration File #
# #
# ~*~AscentEmu~*~ #
# Revision Author: Gastricpenguin #
# Revision Number: 1752 #
# #
#####################################################################################
#####################################################################################
# LogonDatabase Section
#
# These directives are the location of the `realms` and `accounts`
# tables.
#
# LogonDatabase.Host - Either localhost or 127.0.0.1
# LogonDatabase.Username - Mysql Username
# LogonDatabase.Password - Mysql Password
# LogonDatabase.Name - The database name
# LogonDatabase.Port - Port that MySQL listens on. Usually 3306.
# LogonDatabase.Type - 1 = MySQL, 2 = PostgreSQL, 3 = Oracle 10g
#####################################################################################
<LogonDatabase Hostname = "127.0.0.1"
Username = "USERNAME"
Password = "PASSWORD"
Name = "DATABASE NAME"
Port = "3306"
Type = "1">
#####################################################################################
# Host Directive
#
# This is the address that the realmlist will listen on.
# To listen on all addresses, set it to 0.0.0.0
# Default: 127.0.0.1 (localhost)
#
# Note: ISHost is the interserver communication listener.
#####################################################################################
<Listen Host = "0.0.0.0"
ISHost = "0.0.0.0"
RealmListPort = "3724"
ServerPort = "8093">
#####################################################################################
# Server console logging level
#
# This directive controls how much output the server will
# display in it's console. Set to 0 for none.
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 3
#####################################################################################
<LogLevel Screen = "0"
File = "-1">
#####################################################################################
# Account Refresh Time
#
# This controls on which time interval accounts gets
# refreshed. (In seconds)
# Default = 600
#####################################################################################
<Rates AccountRefresh = "600">
#####################################################################################
# Accepted Build Range Setup
#
# Min Build
# Minimum client build that is allowed to access the server
#
# Max Build
# Maximum client build that is allowed to access the server
#
# Latest build for Wow 2.2.0 is 7272
# Default: 7272
#####################################################################################
<Client MinBuild = "6800"
MaxBuild = "7359">
#####################################################################################
# WorldServer Setup
#
# You do not have to change this, as the password is the same in both conf's
#####################################################################################
<LogonServer RemotePassword = "PASSWORD">
Pretty easy, Mx build needs to be put higher whenever a patch goes out. Password (if changed) must be changed on both Logonserver AND ascent. Logondatabase for most repacks is a single DB for all three parts. Just put in your DB name and put in your SQLyog info.
Ascent.conf
Code:
#####################################################################################
# Ascent Configuration File #
# #
# ~*~AscentEmu~*~ #
# Revision Author: Gastricpenguin #
# Revision Number: 1752 #
# #
#####################################################################################
#####################################################################################
# Database Section
#
# Database.Host - Either localhost or 127.0.0.1
# Database.Username - Mysql Username
# Database.Password - Mysql Password
# Database.Name - SQL Database Name
# Database.Port - Please do not modify this port. Unless you know what to do
# Database.Type - 1 = MySQL, 2 = PostgreSQL, 3 = Oracle 10g
#
######################################################################################
<WorldDatabase Hostname = "127.0.0.1"
Username = "USERNAME"
Password = "PASSWORD"
Name = "DATABASE"
Port = "3306"
Type = "1">
<CharacterDatabase Hostname = "127.0.0.1"
Username = "USERNAME"
Password = "PASSWORD"
Name = "DATABASE"
Port = "3306"
Type = "1">
######################################################################################
# Listen Config
#
# Host
# This numbers indicate what address the server will listen on
# If you are making your server live with a DNS name, leave it default
# Default: 0.0.0.0
#
# 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
######################################################################################
<Listen Host = "0.0.0.0"
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
######################################################################################
<LogLevel Screen="0" File="-1" World="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
# Controls the distance a player can see objects and updates.
# Normally, a higher number will consume more bandwith and CPU usage on
# your computer. The default value is always suggested.
# Default: 80
#
# Motd
# Message of the Day
# 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
# Level cap of the server. If a player is higher than this number
# they will not recieve any stat changes per level.
# 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 <x>
# seconds. Use on smaller servers or servers that are memory-limited. The server
# without cellunloading can use over 1.2GB memory with all creatures loaded.
# Default: 0
######################################################################################
<Server PlayerLimit = "100"
PlrUpdateDistance = "80"
Motd = "Enigma WoW is back from the hells of NCDB!"
SendBuildOnJoin = "1"
SendStatsOnJoin = "1"
EnableBreathing = "1"
LevelCap = "60"
Expansion1LevelCap = "70"
SeperateChatChannels = "0"
CompressionThreshold = "1000"
QueueUpdateInterval = "5000"
KickAFKPlayers = "0"
ConnectionTimeout = "180"
RealmType = "1"
AdjustPriority = "0"
RequireAllSignatures = "0"
ShowGMInWhoList = "1"
MapUnloadTime="0">
######################################################################################
# Power regeneration multiplier setup
#
# These directives set up the multiplier in which regen values will be
# multiplied by every 2 seconds.
# Powers:
# Power1 = Mana, Power2 = Rage, Power3 = Energy
#
# Reputation:
# Kill = Rep gained on kill, Quest = rep gained from quests
#
# Honor:
# Honor = multiplier used to calculate honor per-kill.
#
# PvP:
# PvPTimer = in ms, the timeout for pvp after turning it off. default: 5mins
# (300000)
#
# XP:
# The xp that a player receives from killing a creature will be multiplied
# by this value in order to get his xp gain.
#
# RestXP:
# Value is the amount of rest XP a player will recieve per minute of rest time.
#
# Drop(Color):
# These values will be multiplied by the drop percentages of the items for creatures
# to determine which items to drop. All default to 1.
# To allow you better control of drops, separate multipliers have been created for
# items of each quality group.
#
# DropMoney:
# This value will be multiplied by any gold looted and pickpocketed
#
# Save:
# Value in milliseconds (ms) that will be between player autosaves.
# Default: 300000 (5 minutes)
#
# SkillChance:
# The chance that you have to level up a skill in melee or a profession is
# multiplied
# by this value.
# Default: 1
#
# SkillRate:
# The amount of "levels" your skill goes up each time you gain a level is multiplied
# by this value.
#
# ArenaMultiplier
# Every week/day the arena points gained by a player will be multiplied by this value.
######################################################################################
<Rates Health="1"
Power1="1"
Power2="1"
Power3="1"
QuestReputation="5"
KillReputation="20"
Honor="50"
PvPTimer="300000"
Compression="1"
XP="2.5"
QuestXP="3"
RestXP="5"
DropGrey="4"
DropWhite="2"
DropGreen="5"
DropBlue="10"
DropPurple="40"
DropOrange="90"
DropArtifact="9999999999999999999999999999999999999999999999999999"
DropMoney="800"
Save="300000"
SkillChance="50"
SkillRate="50"
ArenaMultiplier2x="2"
ArenaMultiplier3x="3"
ArenaMultiplier5x="4">
######################################################################################
# GM Client Channel
#
# This should be set to 'gm_sync_channel' for the My_Master addon to work.
# Default: gm_sync_channel
######################################################################################
<GMClient ReqGmClient = "0" GmClientChannel = "gm_sync_channel">
######################################################################################
# Terrain Configuration
#
# Set the path to the map_xx.bin files and whether unloading should be enabled
# for the main world maps here. Unloading the main world maps when they go idle
# can save a great amount of memory if the cells aren't being activated/idled
# often. Instance/Non-main maps will not be unloaded ever.
#
# Default:
# MapPath = "maps"
# UnloadMaps = 1
######################################################################################
<Terrain MapPath = "maps" UnloadMaps = "1">
######################################################################################
# Log Settings
#
# Cheaters:
# This directive sets up the cheater logging file, if turned on any
# cheat / packet exploit / speedhack attempts will be logged here.
#
# GMCommands:
# These two directives set up the GM command logging fie. If turned on,
# most gm commands will be logged for this file for abuse investigation, etc.
######################################################################################
<Log Cheaters="0" GMCommands="0">
######################################################################################
# Mail System Setup
#
# These directives control the limits and behaviour of the ingame mail system.
# All options must have Mail prefixed before them.
#
# ReloadDelay
# Controls the delay at which the database is "refreshed". Use it if you're
# inserting mail from an external source, such as a web-based interface.
# 0 turns it off.
# Default: 0
#
# DisablePostageCostsForGM
# Enables/disables the postage costs for GM's. DisablePostageCosts overrides this.
# Default: 1
#
# DisablePostageCosts
# Disables postage costs for all players.
# Default: 0
#
# DisablePostageDelayItems
# Disables the one hour wait time when sending mail with items attached.
# Default: 1
#
# DisableMessageExpiry
# Turns off the 30 day / 3 day after read message expiry time.
# WARNING: A mailbox still cannot show more than 50 items at once
# (stupid limitation in client).
# Default: 0
#
# EnableInterfactionMail
# Removes the faction limitation for sending mail messages. Applies to all players.
# Default: 1
#
# EnableInterfactionMailForGM
# Removes the faction limitation for sending mail messages, but only applies
# to GM's. EnableInterfactionMail overrides this.
# Default: 1
######################################################################################
<Mail ReloadDelay="0"
DisablePostageCostsForGM="1"
DisablePostageCosts="0"
DisablePostageDelayItems="1"
DisableMessageExpiry="1"
EnableInterfactionMail="1"
EnableInterfactionMailForGM="1">
######################################################################################
# Status Dumper Config
#
# These directives set up the status dumper plugin. Filename is an
# absolute or relative path to the server binary. Interval is the
# time that the stats will be dumped to xml.
# Default: stats.xml / 120000 (2 minutes)
######################################################################################
<StatDumper FileName = "stats.xml" Interval = "120000">
######################################################################################
# Startup Options
#
# Preloading
# This directive controls whether the entire world will be spawned at server
# startup or on demand. It is advised to leave it disabled unless you are a
# developer doing testing.
# Default: off
#
# Background Loot Loading
# This directive controls whether loot will be loaded progressively during
# startup or in the background in a seperate thread. Turning it on will
# result in much faster startup times.
# Default: on
#
# Multithreaded Startup
# This controls whether the server will spawn multiple worker threads to
# use for loading the database and starting the server. Turning it on
# increases the speed at which it starts up for each additional cpu in your
# computer.
# Default: on
######################################################################################
<Startup Preloading = "0"
BackgroundLootLoading = "1"
EnableMultithreadedLoading = "1">
######################################################################################
# Flood Protection Setup
#
# Lines
# This is the number of "messages" or lines that it will allow before stopping
# messages from
# being sent. This counter is reset every "Seconds" seconds.
# Default: 0 (disabled)
#
# Seconds
# This is the number of seconds inbetween the Line counter being reset.
# Default: 0 (disabled)
#
# SendMessage
# If this is enabled, a "Your message has triggered serverside flood protection. You
# can speak again in %u seconds."
# message will be sent upon flood triggering.
# Default: 0
######################################################################################
<FloodProtection Lines = "0" Seconds = "0" SendMessage = "0">
######################################################################################
# LogonServer Setup
#
# DisablePings
# Control whether pings will be sent to check if the connection is still "alive".
# Expect problems if it is disabled.
# Default: 0
#
# RemotePassword
# You do not have to change this, as the password is the same in both conf's
######################################################################################
<LogonServer DisablePings = "0"
RemotePassword = "PASSWORD">
######################################################################################
# AntiHack Setup
#
# Teleport
# This directive controls anti-teleport hack checks will be enabled or not.
# Default: 1
#
# Speed
# This directive controls anti-speed hack checks will be performed on player
# movement or not.
# Default: 1
#
# FallDamage
# This directive controls anti-fall damage hack checks will be performed on player
# movement or not.
# Default: 1
#
# Flying
# This directive controls whether flight hacks will be performed on players or not.
# Default: 1
#
# DisableOnGM
# This directive controls hack checks will be disabled for GM's or not.
# Default: 0
######################################################################################
<AntiHack Teleport="1"
Speed="1"
FallDamage="1"
Flying="1"
DisableOnGM="0">
######################################################################################
# Period Setup
#
# These are the periods that the server will wait before doing periodic duties. At the
# moment only arena point calculation and honor point calculation are used here.
#
# Default:
# Arena: weekly
# Honor: daily
# (blizzlike values)
######################################################################################
<Periods HonorUpdate="daily"
ArenaUpdate="weekly">
######################################################################################
# AscentStats Setup
# Info: This sends information to the server to detect any problems
#
# Enable
# To disable stat transmission completely, set this to 0.
#
# ServerGUID
# This is the GUID assigned to your server by the AscentStats server. To register
# your server, go
# to http://www.example.com/ascentstats/register_server.php
#
# ServerKey
# This is the key used to secure stats sent by your server so they can't be forged.
# This key is
# obtained after registering your server.
#
# Default:
# Enabled
# Server Key "NONE"
# Server GUID "NONE"
######################################################################################
<AscentStats Enable="1"
ServerGUID="NONE"
ServerKey="NONE">
######################################################################################
# Channels Setup
#
# These directives control some of the aspects in the channel system.
#
# BannedChannels
# If you would like to ban users from creating or joining a channel specify them
# here in a ';'
# seperated list.
# Default: ""
#
# GeneralChannels
# These are the default channels that the client joins and cannot have leaders.
# Default: "General -;Trade -;LookingForGroup;GuildRecruitment;LocalDefense;WorldDefense;"
######################################################################################
<Channels BannedChannels=""
GeneralChannels="General -;Trade -;LookingForGroup;GuildRecruitment;LocalDefense;WorldDefense;">
######################################################################################
# End of Ascent Configuration File #
# #
# Credits: #
# Thanks for your continued support :D #
# Love, Gastricpenguin and Chrispee #
# #
######################################################################################
Alot of fun stuff here
Need to make sure password is the same as Logonserver. Same changes from Logonserver applies to World and Charcter databases.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[Some repacks will come with afolder called "maps"
[[[[[[[[If you have a maps folder full of files like "map1, map 13, map 16, ect."...
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[Skip this part
Find a application named "ad.exe", this may mave extra things like EN or FR.
If you have En or FR or anything like that, select your language. It shouldnt be hard, EN = English, FR = French, ect.
Put the application in your World of Warcraft and make a folder named "Maps"
Use the app and when promted, say "y".
Now it will load, once done put maps and ad.exe back in your server workspace.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Once everything is loaded you can browse through the Database and add accounts.
First table is Id, just number them.
Then logon and password (Easy)
GM power is next.
az is admin
a is GM with admin power
3 Full GM (No admin)
2 1 (Lesser GMs)
You can also do a lettered GM power to give them certain things, check a GM command list for info.
To get the server up:
Open the MySQL command line client.
Put in your password. I always do \r to be safe after that.
Open Logonserver then after it gets to "Hooking Signals" open Ascent. If it all works you will get a message saying the logon MS.
If you get red text you probably don't have matching passwords. If you get timeout, redo the MySQL command client step as sometimes that bugs out.
To get on:
Open realmlist.wtf with notepad.
Change it to "set realmlist 127.0.0.1" (127.0.0.1 is your own computer)
There are other guides to making your server public but after you have the main means set up have their realmlist set to what your host is.
Alright, heres the video. Had to split it becuase of YouTube caps.
For refrence, links to the videos
http://www.youtube.com/watch?v=2J-xCKOj8h4
http://www.youtube.com/watch?v=jJl6q1oOYJs
[ame="http://www.youtube.com/watch?v=2J-xCKOj8h4"]YouTube - 777's Ascent Guide Part1[/ame]
[ame="http://www.youtube.com/watch?v=jJl6q1oOYJs"]YouTube - 777's Ascent Guide Part2[/ame]
Sorry to JulianX for recording that part.
This is pretty random but my videos, as of November 20th, 07, have been uploaded to 26diffrent sites and in three diffrent languages.
November 22, 07 - 29sites, still three languages. 5000+views.
If anyone has questions, post them here.