[Release] Arena Tournament 2009 Server

[Lilltimmy]

And what do i do with the DBC_Maps, if i may ask?

[Dythzer]

And what do i do with the DBC_Maps, if i may ask?

Extract dbc and map files. Read step 3

100% imbah exept mangos :P its so ##dumb##

What's so dumb about it? You just make yourself look dumb.

[Flake0207]

maby one updates to 3.0?

[TedoPK]

Dythzer you said that you'll upload the source,can you upload only the scripts?

[Grabben]

Basic installation guide

1. Install MySQL if you haven't already: Download
2. Open up ServerSettings.conf and change to your mysql password: (you can edit other server settings as well in this file)
   

   LoginDatabaseInfo     = "127.0.0.1;3306;root;PASSWORD;arena_realm"
   WorldDatabaseInfo     = "127.0.0.1;3306;root;PASSWORD;arena_world"
   CharacterDatabaseInfo = "127.0.0.1;3306;root;PASSWORD;arena_characters"

   • Do the same with RealmSettings.conf
3. Copy Maps_DBC.exe from the Tools folder to your WoW folder (2.4.3 client!) and run it. It will extract DBC and map files.
4. Move the maps and dbc to the DATA folder in the server folder
5. Run DatabaseImporter.bat (Tools folder) and import all the databases
6. Click .exe files to start the server. Type "help" in console to see all console commands for account creation etc.

When I try to start .exe I get "This program coulden't launch becuse it's not configured correctly". It's the same on both .exe files.

I've follow'd your guide, don't know what I'm doing wrong. Hope someone know what I'm doing wrong since I'm dying to get this up and going

[Dythzer]

[/LIST]When I try to start .exe I get "This program coulden't launch becuse it's not configured correctly". It's the same on both .exe files.

You might need this:
Download details: Visual C++ 2008 Redistributable Package (x86)

Dythzer you said that you'll upload the source,can you upload only the scripts?

Yes, I was gonna upload it with next update but I haven't made it yet. I'm mostly at my laptop where I don't have the source, but I will when I can.

[Grabben]

Bear with me I'm really new with this >_<'

I've tryed to get this up and running with hamachi aswell, no success yet I'm afraid I've followed a few different guides but it's just not the same thing. A quick tutorial would be awesome!

Cheers Grabben

On a side note, this works like a charm. Really good work Dythzer!

[Dythzer]

I'm having a hard time figuring out how to make my accounts so that I can make BE/Dranei chars. Also I can't find s2 vendor It's probably really easy but I just seem to not get it right :P

Type "account set addon 1" in console to enable burning crusade for an account. Type help for all console commands. For example account set gm 3.

I've tryed to get this up and running with hamachi aswell, no success yet I'm afraid I've followed a few different guides but it's just not the same thing. A quick tutorial would be awesome!

Change the IP in the realmlist table in the arena_realm database to your hamachi IP. If you want to host without hamachi you just open the ports and set the IP to your public IP.

[[Shon3m]]

what's the id stand for the vendors?

[Sounddead]

When I try to start .exe I get "This program coulden't launch becuse it's not configured correctly". It's the same on both .exe files.

Download .NET Framework 3.5

[Grabben]

Thanks for all the help, I've now managed to make everything work just fine... Just one small sidenote, when people try to connect to my server they find it and all. Start to log onto my realm then it freeze at "logging into game server". I've been trying to change alot and followed guides and tryed to change some things on my own that might would have worked. Any Ideas?

Could post my realmdb if any1 want to take a look at it

Cheers Grabben

[Dythzer]

Thanks for all the help, I've now managed to make everything work just fine... Just one small sidenote, when people try to connect to my server they find it and all. Start to log onto my realm then it freeze at "logging into game server". I've been trying to change alot and followed guides and tryed to change some things on my own that might would have worked. Any Ideas?

Could post my realmdb if any1 want to take a look at it

Cheers Grabben

Make sure they got the same IP in their realmlist.wtf file as your realmlist table, also make sure port 8085 and 3724 are forwarded. If it still doesn't work post your config files and realm DB.

[Grabben]

When people try to connect to my server they find it and all. Start to log onto my realm then it freeze at "logging into game server". I've been trying to change alot and followed guides and tryed to change some things on my own that might would have worked. They find my server and everything but they just freeze. Any Ideas?


Realm DB

 
-- MySQL dump 10.11
--
-- Host: 5.150.130.179    Database: realmd
-- ------------------------------------------------------
-- Server version 5.0.45-Debian_1ubuntu3.1-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `realmd_db_version`
--
DROP TABLE IF EXISTS `realmd_db_version`;
CREATE TABLE `realmd_db_version` (
  `required_2008_11_07_04_realmd_account` bit(1) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB';
--
-- Dumping data for table `realmd_db_version`
--
LOCK TABLES `realmd_db_version` WRITE;
/*!40000 ALTER TABLE `realmd_db_version` DISABLE KEYS */;
INSERT INTO `realmd_db_version` VALUES
(NULL);
/*!40000 ALTER TABLE `realmd_db_version` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `account`
--
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
  `id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Identifier',
  `username`      varchar(32) NOT NULL default '',
  `sha_pass_hash` varchar(40) NOT NULL default '',
  `gmlevel` tinyint(3) unsigned NOT NULL default '0',
  `sessionkey` longtext,
  `v` longtext,
  `s` longtext,
  `email` text,
  `joindate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `last_ip` varchar(30) NOT NULL default '127.0.0.1',
  `failed_logins` int(11) unsigned NOT NULL default '0',
  `locked` tinyint(3) unsigned NOT NULL default '0',
  `last_login` timestamp NOT NULL default '0000-00-00 00:00:00',
  `online` tinyint(4) NOT NULL default '0',
  `expansion` tinyint(3) unsigned NOT NULL default '0',
  `mutetime` bigint(40) unsigned NOT NULL default '0',
  `locale` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `idx_username` (`username`),
  KEY `idx_gmlevel` (`gmlevel`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC COMMENT='Account System';
--
-- Table structure for table `account_banned`
--
DROP TABLE IF EXISTS `account_banned`;
CREATE TABLE `account_banned` (
  `id` int(11) NOT NULL default '0' COMMENT 'Account id',
  `bandate` bigint(40) NOT NULL default '0',
  `unbandate` bigint(40) NOT NULL default '0',
  `bannedby` varchar(50) NOT NULL,
  `banreason` varchar(255) NOT NULL,
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id`,`bandate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Ban List';
--
-- Dumping data for table `account_banned`
--
LOCK TABLES `account_banned` WRITE;
/*!40000 ALTER TABLE `account_banned` DISABLE KEYS */;
/*!40000 ALTER TABLE `account_banned` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ip_banned`
--
DROP TABLE IF EXISTS `ip_banned`;
CREATE TABLE `ip_banned` (
  `ip` varchar(32) NOT NULL default '127.0.0.1',
  `bandate` bigint(40) NOT NULL,
  `unbandate` bigint(40) NOT NULL,
  `bannedby` varchar(50) NOT NULL default '[Console]',
  `banreason` varchar(255) NOT NULL default 'no reason',
  PRIMARY KEY  (`ip`,`bandate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Banned IPs';
--
-- Dumping data for table `ip_banned`
--
LOCK TABLES `ip_banned` WRITE;
/*!40000 ALTER TABLE `ip_banned` DISABLE KEYS */;
/*!40000 ALTER TABLE `ip_banned` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `realmcharacters`
--
DROP TABLE IF EXISTS `realmcharacters`;
CREATE TABLE `realmcharacters` (
  `realmid` int(11) unsigned NOT NULL default '0',
  `acctid` bigint(20) unsigned NOT NULL,
  `numchars` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`realmid`,`acctid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm Character Tracker';
--
-- Dumping data for table `realmcharacters`
--
LOCK TABLES `realmcharacters` WRITE;
/*!40000 ALTER TABLE `realmcharacters` DISABLE KEYS */;
/*!40000 ALTER TABLE `realmcharacters` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `realmlist`
--
DROP TABLE IF EXISTS `realmlist`;
CREATE TABLE `realmlist` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(32)'5.150.130.179',
  `address` varchar(32)'5.150.130.179',
  `port` int(11)'3724',
  `icon` tinyint(3)'PVP',
  `color` tinyint(3) unsigned NOT NULL default '2',
  `timezone` tinyint(3) unsigned NOT NULL default '0',
  `allowedSecurityLevel` tinyint(3) unsigned NOT NULL default '0',
  `population` float unsigned'100',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `idx_name` (`5.150.130.179`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm System';
--
-- Dumping data for table `realmlist`
--
LOCK TABLES `realmlist` WRITE;
/*!40000 ALTER TABLE `realmlist` DISABLE KEYS */;
INSERT INTO `realmlist` VALUES
(1,'Arena Tournament',5.150.130.179 ',8085,1,0,8,0,0);
/*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2008-01-10 11:37:06

[code]

Realm Settings

 
############################################
# Realmd configuration file #
############################################
ConfVersion=2007062001
###################################################################################################################
# REALMD SETTINGS
#
# LoginDatabaseInfo
# Database connection settings for the realm server.
# Default: hostname;port;username;password;database
# .;somenumber;username;password;database - use named pipes at Windows
# Named pipes: mySQL required adding "enable-named-pipe" to [mysqld] section my.ini
# .;/path/to/unix_socket;username;password;database - use Unix sockets at Unix/Linux
# Unix sockets: experimental, not tested
#
###################################################################################################################
LoginDatabaseInfo = "127.0.0.1;3306;root;monkeyisland;arena_realm"
 
 
###################################################################################################################
# LogsDir
# Logs directory setting.
# Important: Logs dir must exists, or all logs be disable
# Default: "" - no log directory prefix, if used log names isn't absolute path then logs will be
# stored in current directory for run program.
#
# MaxPingTime
# Settings for maximum database-ping interval (minutes between pings)
#
# RealmServerPort
# 3724
#
# BindIP
# 5.150.130.179
#
# PidFile
# Realmd daemon PID file
# Default: "" - do not create PID file
# "./realmd.pid" - create PID file (recommended name)
#
# LogLevel
# Server console level of logging
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 0
#
# LogTime
# Include time in server console output [hh:mm:ss]
# Default: 0 (no time)
# 1 (print time)
#
# LogFile
# Logfile name
# Default: "Realmd.log"
# "" - empty name disable creating log file
#
# LogTimestamp
# Logfile with timestamp of server start in name
# Default: 0 - no timestamp in name
# 1 - add timestamp in name in form Logname_YYYY-MM-DD_HH-MM-SS.Ext for Logname.Ext
#
# LogFileLevel
# Server file level of logging
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 0
#
# LogColors
# Color for messages (format "normal_color details_color debug_color error_color)
# Colors: 0 - BLACK, 1 - RED, 2 - GREEN, 3 - BROWN, 4 - BLUE, 5 - MAGENTA, 6 - CYAN, 7 - GREY,
# 8 - YELLOW, 9 - LRED, 10 - LGREEN, 11 - LBLUE, 12 - LMAGENTA, 13 - LCYAN, 14 - WHITE
# Default: "" - none colors
# "13 7 11 9" - for example :)
#
# UseProcessors
# Used processors mask for multi-processors system (Used only at Windows)
# Default: 0 (selected by OS)
# number (bitmask value of selected processors)
#
# ProcessPriority
# Process proirity setting (Used only at Windows)
# Default: 1 (HIGH)
# 0 (Normal)
#
# RealmsStateUpdateDelay
# Realm list Update up delay (updated at realm list request if delay expired).
# Default: 20
# 0 (Disabled)
#
# WrongPass.MaxCount
# Number of login attemps with wrong password before the account or IP is banned
# Default: 0 (Never ban)
#
# WrongPass.BanTime
# Duration of the ban in seconds (0 means permanent ban)
# Default: 600
#
# WrongPass.BanType
# Ban the IP or account on which login is attempted
# Default: 0 (Ban IP)
# 1 (Ban Account)
#
###################################################################################################################
## Optional settings
LogsDir = ""
MaxPingTime = 30
RealmServerPort = 3724
PidFile = ""
LogLevel = 0
LogTime = 0
LogFile = ""
LogTimestamp = 0
LogFileLevel = 0
LogColors = ""
UseProcessors = 0
ProcessPriority = 1
RealmsStateUpdateDelay = 20
WrongPass.MaxCount = 0
WrongPass.BanTime = 600
WrongPass.BanType = 0
BindIP = "0.0.0.0"
## Note: You can add more realms in the arena_realm database, edit realmlist tabletable

Server Settings

 
 
 
#####################################
# Configuration file #
#####################################
ConfVersion=2008080101
###################################################################################################################
# CONNECTIONS AND DIRECTORIES
#
# RealmID
# RealmID must match the realmlist inside the realmd database
#
# DataDir
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may contain space characters.
# Example: "@prefix@/share/mangos"
#
# LogsDir
# Logs directory setting.
# Important: Logs dir must exists, or all logs need to be disabled
# Default: "" - no log directory prefix, if used log names isn't absolute path
# then logs will be stored in current directory for run program.
#
#
# LoginDatabaseInfo
# WorldDatabaseInfo
# CharacterDatabaseInfo
# Database connection settings for the world server.
# Default: hostname;port;username;password;database
# .;somenumber;username;password;database - use named pipes at Windows
# Named pipes: mySQL required adding "enable-named-pipe" to [mysqld] section my.ini
# .;/path/to/unix_socket;username;password;database - use Unix sockets at Unix/Linux
# Unix sockets: experimental, not tested
#
# MaxPingTime
# Settings for maximum database-ping interval (minutes between pings)
#
# WorldServerPort
# Default WorldServerPort
#
###################################################################################################################
RealmID = 1
DataDir = "./DATA"
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;monkeyisland;arena_realm"
WorldDatabaseInfo = "127.0.0.1;3306;root;monkeyisland;arena_world"
CharacterDatabaseInfo = "127.0.0.1;3306;root;monkeyisland;arena_characters"
MaxPingTime = 30
WorldServerPort = 8085
###################################################################################################################
#
# Rated arena matches config
#
# MaxRatingDifference: the maximum rating difference between two groups in rated matches
# Default: 0 (disable, rating difference is discarded)
#
# RatingDiscardTimer: after the specified milliseconds has passed,
# rating information will be discarded when selecting teams for matches
# also initiates an update by this timer
# Default: 60000
#
# AutoDistributePoints: set if arena points should be distributed automatically, or by GM command
# Default: 0 (disable) (recommended): use gm command or sql query to distribute the points
# 1 (enable): arena points are distributed automatically
#
# AutoDistributeInterval: how often should the distribution take place
# if automatic distribution is enabled
# in days
# Default: 7 (weekly)
#
###################################################################################################################
Arena.MaxRatingDifference = 0
Arena.RatingDiscardTimer = 60000
Arena.AutoDistributePoints = 0
Arena.AutoDistributeInterval = 7
###################################################################################################################
#
# Battleground config
#
# PrematureFinishTimer: the time to end the bg if there are less than minplayersperteam on one side
# in milliseconds
# Default: 300000
# 0 - disable
#
###################################################################################################################
BattleGround.PrematureFinishTimer = 300000
###################################################################################################################
# PERFORMANCE SETINGS
#
# UseProcessors
# Used processors mask for multi-processors system (Used only at Windows)
# Default: 0 (selected by OS)
# number (bitmask value of selected processors)
#
# ProcessPriority
# Process priority setting (Used only at Windows)
# Default: 1 (HIGH)
# 0 (Normal)
#
# Compression
# Compression level for update packages sent to client (1..9)
# Default: 1 (speed)
# 9 (best compression)
#
# PlayerLimit
# Maximum number of players in the world. Excluding Mods, GM's and Admins
# Default: 100
# 0 (for infinite players)
# -1 (for Mods, GM's and Admins only)
# -2 (for GM's and Admins only)
# -3 (for Admins only)
#
# SaveRespawnTimeImmediately
# Save respawn time for creatures at death and for gameobjects at use/open
# Default: 1 (save creature/gameobject respawn time without waiting grid unload)
# 0 (save creature/gameobject respawn time at grid unload)
#
# MaxOverspeedPings
# Maximum overspeed ping count before player kick (minimum is 2, 0 used for disable check)
# Default: 2
#
# GridUnload
# Unload grids (if you have lot memory you can disable it to speed up player move to new grids second time)
# Default: 1 (unload grids)
# 0 (do not unload grids)
#
# SocketSelectTime
# Socket select time (in milliseconds)
# Default: 10000
#
# GridCleanUpDelay
# Grid clean up delay (in milliseconds)
# Default: 300000 (5 min)
#
# MapUpdateInterval
# Map update interval (in milliseconds)
# Default: 100
#
# ChangeWeatherInterval
# Weather update interval (in milliseconds)
# Default: 600000 (10 min)
#
# PlayerSaveInterval
# Player save interval (in milliseconds)
# Default: 900000 (15 min)
#
# vmap.enableLOS
# vmap.enableHeight
# Enable/Disable VMmap support for line of sight and height calculation
# Default: 1 (true)
# 0 (false)
#
# vmap.ignoreMapIds
# Map id that will be ignored by VMaps
# List of ids with delimiter ','
# If more then one id is defined and spaces are included, the string has to be enclosed by "
# Example: "369,0,1,530"
#
# vmap.ignoreSpellIds
# These spells are ignored for LoS calculation
# List of ids with delimiter ','
#
# DetectPosCollision
# Check final move position, summon position, etc for visible collision with other objects or
# wall (wall only if vmaps are enabled)
# Default: 1 (enable, required more CPU power usage)
# 0 (disable, less nice position selection but will less CPU power usage)
#
# TargetPosRecalculateRange
# Max distance from movement target point (+moving unit size) and targeted object (+size)
# after that new target movmeent point calculated. Max: melee attack range (5), min: contact range (0.5)
# More distance let have better performence, less distance let have more sensitive reaction at target move.
# Default: 1.5
#
# UpdateUptimeInterval
# Update realm uptime period in minutes (for save data in 'uptime' table). Must be > 0
# Default: 10 (minutes)
#
# MaxCoreStuckTime
# Periodically check if the process got freezed, if this is the case force crash after the specified
# amount of seconds. Must be > 0. Recommended > 10 secs if you use this.
# Default: 0 (Disabled)
#
# AddonChannel
# Permit/disable the use of the addon channel through the server
# (some client side addons can stop work correctly with disabled addon channel)
# Default: 1 (permit addon channel)
# 0 (do not permit addon channel)
#
###################################################################################################################
UseProcessors = 0
ProcessPriority = 1
Compression = 1
PlayerLimit = 100
SaveRespawnTimeImmediately = 1
MaxOverspeedPings = 2
GridUnload = 1
SocketSelectTime = 10000
GridCleanUpDelay = 300000
MapUpdateInterval = 100
ChangeWeatherInterval = 600000
PlayerSaveInterval = 900000
vmap.enableLOS = 0
vmap.enableHeight = 0
vmap.ignoreMapIds = "369"
vmap.ignoreSpellIds = "7720"
DetectPosCollision = 1
TargetPosRecalculateRange = 1.5
UpdateUptimeInterval = 10
MaxCoreStuckTime = 0
AddonChannel = 1
###################################################################################################################
# SERVER LOGGING
#
# LogSQL
# Enable logging of GM commands - all SQL code will be written to a log file
# All commands are written to a file: YYYY-MM-DD_logSQL.sql
# If a new day starts (00:00:00) then a new file is created - the old file will not be deleted.
# Default: 1 - Write SQL code to logfile
# 0 - Do not log
#
# PidFile
# World daemon PID file
# Default: "" - do not create PID file
# "./worldd.pid" - create PID file (recommended name)
#
# LogLevel
# Server console level of logging
# 0 = Minimum; 1 = Basic&Error; 2 = Detail; 3 = Full/Debug
# Default: 3
#
# LogTime
# Include time in server console output [hh:mm:ss]
# Default: 0 (no time)
# 1 (print time)
#
# LogFile
# Logfile name
# Default: "Server.log"
# "" - Empty name disable creating log file
#
# LogTimestamp
# Logfile with timestamp of server start in name
# Default: 0 - no timestamp in name
# 1 - add timestamp in name in form Logname_YYYY-MM-DD_HH-MM-SS.Ext for Logname.Ext
#
# LogFileLevel
# Server file level of logging
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 0
#
# LogFilter_TransportMoves
# LogFilter_CreatureMoves
# LogFilter_VisibilityChanges
# Log filters
# Default: 1 - not include with any log level
# 0 - include in log if log level permit
#
# WorldLogFile
# Packet logging file for the worldserver
# Default: "world.log"
#
# DBErrorLogFile
# Log file of DB errors detected at server run
# Default: "DBErrors.log"
#
# CharLogFile
# Character operations logfile name
# Default: "Char.log"
# "" - Empty name disable creating log file
#
# CharLogTimestamp
# Logfile with timestamp of server start in name
# Default: 0 - no timestamp in name
# 1 - add timestamp in name in form Logname_YYYY-MM-DD_HH-MM-SS.Ext for Logname.Ext
#
# CharLogDump
# Write character dump before deleting in Char.log
# For restoration, cut character data from log starting from
# line == START DUMP == to line == END DUMP == (without its) in file and load it using loadpdump command
# Default: 0 - don't include dumping chars to log
# 1 - include dumping chars to log
#
# GmLogFile
# GM Log file of gm commands
# Default: "" (Disable)
#
# GmLogTimestamp
# GM Logfile with timestamp of server start in name
# Default: 0 - no timestamp in name
# 1 - add timestamp in name in form Logname_YYYY-MM-DD_HH-MM-SS.Ext for Logname.Ext
#
# GmLogPerAccount
# GM Logfiles with GM account id (Note: logs not created if GmLogFile not set)
# Default: 0 - add gm log data to single log file
# 1 - add gm log data to account specific log files with name
# in form Logname_#ID_YYYY-MM-DD_HH-MM-SS.Ext
# or form Logname_#ID.Ext
#
# RaLogFile
# Log file of RA commands
# Default: "Ra.log"
# "" - Empty name for disable
#
# LogColors
# Color for messages (format "normal_color details_color debug_color error_color")
# Colors: 0 - BLACK, 1 - RED, 2 - GREEN, 3 - BROWN, 4 - BLUE, 5 - MAGENTA, 6 - CYAN, 7 - GREY,
# 8 - YELLOW, 9 - LRED, 10 - LGREEN, 11 - LBLUE, 12 - LMAGENTA, 13 - LCYAN, 14 - WHITE
# Default: "" - none colors
# Example: "13 7 11 9"
#
###################################################################################################################
LogSQL = 1
PidFile = ""
LogLevel = 0
LogTime = 0
LogFile = ""
LogTimestamp = 0
LogFileLevel = 0
WorldLogFile = ""
DBErrorLogFile = ""
CharLogFile = ""
CharLogTimestamp = 0
CharLogDump = 0
GmLogFile = ""
GmLogTimestamp = 0
GmLogPerAccount = 0
RaLogFile = ""
LogColors = "14 7 11 7"
###################################################################################################################
# SERVER SETTINGS
#
# GameType
# Server realm style
# 0 = NORMAL;1 = PVP; 4 = NORMAL; 6 = RP; 8 = RPPVP
# also custom type: 16 FFA_PVP (free for all pvp mode like arena PvP in all zones except rest
# activated places and sanctuaries)
#
# DBC.Locale
# DBC Language Settings
# 0 = English; 1 = Korean; 2 = French; 3 = German; 4 = Chinese; 5 = Taiwanese; 6 = Spanish; 7 = Spanish Mexico
# 8 = Russian; 255 = Auto Detect (Default)
#
# CharactersCreatingDisabled
# Disable characters creating for specific team or any (non-player accounts not affected)
# Default: 0 - enabled
# 1 - disabled only for Alliance
# 2 - disabled only for Horde
# 3 - disabled for both teams
#
# CharactersPerAccount
# Limit numbers of characters per account (at all realms).
# Note: this setting limit character creating at _current_ realm base at characters amount at all realms
# Default: 50
# The number must be >= CharactersPerRealm
#
# CharactersPerRealm
# Limit numbers of characters for account at realm
# Default: 10 (client limitation)
# The number must be between 1 and 10
#
# SkipCinematics
# Disable in-game script movie at first character's login(allows to prevent buggy intro in case of custom start location coordinates)
# Default: 0 - show intro for each new characrer
# 1 - show intro only for first character of selected race
# 2 - disable intro show in all cases
#
# MaxPlayerLevel
# Max level that can be reached by player for experience (in range from 1 to 255).
# Change not recommended
# Default: 70
#
# StartPlayerLevel
# Staring level that have character at creating (in range 1 to MaxPlayerLevel)
# Default: 1
#
# StartPlayerMoney
# Amount of money that new players will start with.
# If you want to start with silver, use for example 100 (100 copper = 1 silver)
# Default: 0
#
# MaxHonorPoints
# Max honor points that player can have.
# Default: 75000
#
# StartHonorPoints
# Amount of honor that new players will start with
# Default: 0
#
# MaxArenaPoints
# Max arena points that player can have.
# Default: 5000
#
# StartArenaPoints
# Amount of arena points that new players will start with
# Default: 0
#
# AlwaysMaxSkillForLevel
# Players will automatically gain max level dependent (weapon/defense) skill when logging in, leveling up etc.
# Default: 0 (false)
# 1 (true)
#
# ActivateWeather
# Activate weather system
# Default: 1 (true)
# 0 (false)
#
# Battleground.CastDeserter
# Cast or not Deserter spell at player who leave battleground in progress
# Default: 1 (true)
# 0 (false)
#
# Battleground.QueueAnnouncer.Enable
# Enable queue announcer posting to chat
# Default: 0 (false)
# 1 (true)
#
# Battleground.QueueAnnouncer.PlayerOnly
# Enable queue announcer posting to chat
# Default: 0 (false)
# 1 (true)
#
# Arena.QueueAnnouncer.Enable: Enable queue announcer posting to chat
# Default: 0 (false)
# 1 (true)
#
# CastUnstuck
# Allow cast or not Unstuck spell at .start or client Help option use
# Default: 1 (true)
# 0 (false)
#
# MaxPrimaryTradeSkill
# Max count that player can learn the primary trade skill.
# Default: 2
# Max : 10
#
# MinPetitionSigns
# Min signatures count to creating guild (0..9).
# Default: 9
#
# MailDeliveryDelay
# Mail delivery delay time for item sending
# Default: 3600 sec (1 hour)
#
# BeepAtStart
# Beep at mangosd start finished (mostly work only at Unix/Linux systems)
# Default: 1 (true)
# 0 (false)
#
# Motd
# Message of the Day. Displayed at worldlogin for every user ('@' for a newline).
#
###################################################################################################################
GameType = 1
DBC.Locale = 255
CharactersCreatingDisabled = 0
CharactersPerAccount = 50
CharactersPerRealm = 10
SkipCinematics = 2
MaxPlayerLevel = 70
StartPlayerLevel = 70
StartPlayerMoney = 50000000
MaxHonorPoints = 75000
StartHonorPoints = 0
MaxArenaPoints = 5000
StartArenaPoints = 0
AlwaysMaxSkillForLevel = 1
ActivateWeather = 0
Battleground.CastDeserter = 1
Battleground.QueueAnnouncer.Enable = 0
Battleground.QueueAnnouncer.PlayerOnly = 0
Arena.QueueAnnouncer.Enable = 0
CastUnstuck = 1
MaxPrimaryTradeSkill = 2
MinPetitionSigns = 9
MailDeliveryDelay = 3600
BeepAtStart = 1
Motd = "Welcome to the Arena Tournament server!"
###################################################################################################################
# PLAYER INTERACTION
#
# AllowTwoSide.Accounts
# Allow or not accounts to create characters in the 2 teams in any game type.
# Default: 0 (Not allowed)
# 1 (Allowed)
#
# AllowTwoSide.Interaction.Chat
# AllowTwoSide.Interaction.Channel
# AllowTwoSide.Interaction.Group
# AllowTwoSide.Interaction.Guild
# AllowTwoSide.Interaction.Auction
# AllowTwoSide.Interaction.Mail
# Allow or not common :chat(say,yell);channel(chat)group(join)guild(join);merge all auction houses for players from
# different teams, send mail to different team.
# Default: 0 (Not allowed)
# 1 (Allowed)
#
# AllowTwoSide.WhoList
# Allow or not show player from both team in who list.
# Default: 0 (Not allowed)
# 1 (Allowed)
#
# AllowTwoSide.AddFriend
# Allow or not adding friends from other team in friend list.
# Default: 0 (Not allowed)
# 1 (Allowed)
#
# TalentsInspecting
# Allow other players see character talents in inspect dialog (Characters in Gamemaster mode can
# inspect talents always)
# Default: 1 (allow)
# 0 (not allow)
#
###################################################################################################################
AllowTwoSide.Accounts = 0
AllowTwoSide.Interaction.Chat = 0
AllowTwoSide.Interaction.Channel = 0
AllowTwoSide.Interaction.Group = 0
AllowTwoSide.Interaction.Guild = 0
AllowTwoSide.Interaction.Auction = 0
AllowTwoSide.Interaction.Mail = 0
AllowTwoSide.WhoList = 1
AllowTwoSide.AddFriend = 0
TalentsInspecting = 1
###################################################################################################################
# CHAT SETTINGS
#
# ChatFakeMessagePreventing
# Chat protection from creating fake messages using a lot spaces (other invisible symbols),
# not applied to addon language messages, but can prevent working old addons
# that use normal languages for sending data to another clients.
# Default: 0 (disible fake messages preventing)
# 1 (enabled fake messages preventing)
#
# ChatFlood.MessageCount
# Chat anti-flood protection, haste message count to activate protection
# Default: 10
# 0 (disible anti-flood protection)
#
# ChatFlood.MessageDelay
# Chat anti-flood protection, minimum message delay to count message
# Default: 1 (in secs)
#
# ChatFlood.MuteTime
# Chat anti-flood protection, mute time at activation flood protection (not saved)
# Default: 10 (in secs)
#
# Channel.RestrictedLfg
# Restrict use LookupForGroup channel only registered in LFG tool players
# Default: 1 (allow join to channel only if active in LFG)
# 0 (allow join to channel in any time)
#
# Channel.SilentlyGMJoin
# Silently join GM characters (security level > 1) to channels
# Default: 0 (join announcement in normal way)
# 1 (GM join without announcement)
#
###################################################################################################################
ChatFakeMessagePreventing = 0
ChatFlood.MessageCount = 10
ChatFlood.MessageDelay = 1
ChatFlood.MuteTime = 10
Channel.RestrictedLfg = 1
Channel.SilentlyGMJoin = 0
###################################################################################################################
# GAME MASTER SETTINGS
#
# GM.LoginState
# GM mode at login
# Default: 2 (last save state)
# 0 (disable)
# 1 (enable)
#
# GM.Visible
# GM visibility at login
# Default: 2 (last save state)
# 0 (invisible)
# 1 (visible)
#
# GM.AcceptTickets
# Is GM accepting tickets from player by default or not.
# Default: 2 (last save state)
# 0 (disable)
# 1 (enable)
#
# GM.Chat
# GM chat mode at login
# Default: 2 (last save state)
# 0 (disable)
# 1 (enable)
#
# GM.WhisperingTo
# Is GM accepting whispers from player by default or not.
# Default: 2 (last save state)
# 0 (disable)
# 1 (enable)
#
# GM.InGMList
# Is GM showed in GM list (if visible) in non-GM state (.gmoff)
# Default: 0 (false)
# 1 (true)
#
# GM.InWhoList
# Is GM showed in who list (if visible).
# Default: 0 (false)
# 1 (true)
#
# GM.LogTrade
# Include GM trade and trade slot enchanting operations in GM log if it enable
# Default: 1 (include)
# 0 (not include)
#
# GM.StartLevel
# GM starting level (1-255)
# Default: 1
#
# GM.LowerSecurity
# Disallow a lower security member to interact with a higher one using commands
# Default: 0 (disable)
# 1 (enable)
#
###################################################################################################################
GM.LoginState = 2
GM.Visible = 2
GM.AcceptTickets = 2
GM.Chat = 2
GM.WhisperingTo = 2
GM.InGMList = 1
GM.InWhoList = 0
GM.LogTrade = 1
GM.StartLevel = 70
GM.LowerSecurity = 0
###################################################################################################################
# VISIBILITY AND RADIUSES
#
# Visibility.GroupMode
# Group visibility modes
# Default: 0 (standard setting: only members from same group can 100% auto detect invisible player)
# 1 (raid members 100% auto detect invisible player from same raid)
# 2 (players from same team can 100% auto detect invisible player)
#
# Visibility.Distance.Creature
# Visibility.Distance.Player
# Visibility distance for different in game object
# Max limited by active player zone: ~ 166
# Min limit dependent from objects
# Default: 66 (cell size)
# Min limit is max aggro radius (45) * Rate.Creature.Aggro
#
# Visibility.Distance.Object
# Visible distance for gameobject, dynobject, bodies, corpses, bones
# Min limit is iteraction distance (5)
#
# Visibility.Distance.InFlight
# Visible distance for player in flight
# Min limit is 0 (not show any objects)
#
# Visibility.Distance.Grey.Unit
# Visibility grey distance for creatures/players (fast changing objects)
# addition to appropriate object type Visibility.Distance.* use in case visibility removing to
# object (except corpse around distences) If is distance and G is grey distance then object
# make visible if distance to it <= D but make non visible if distance > D+G
# Default: 1 (yard)
#
# Visibility.Distance.Grey.Object
# Visibility grey distance for dynobjects/gameobjects/corpses/creature bodies
# Default: 10 (yards)
#
#
###################################################################################################################
Visibility.GroupMode = 0
Visibility.Distance.Creature = 66
Visibility.Distance.Player = 66
Visibility.Distance.Object = 66
Visibility.Distance.InFlight = 66
Visibility.Distance.Grey.Unit = 1
Visibility.Distance.Grey.Object = 10
###################################################################################################################
# SERVER RATES
#
# Rate.Health
# Rate.Mana
# Rate.Rage.Income
# Rate.Rage.Loss
# Rate.Focus
# Rate.Loyalty
# Health and power regeneration and rage income from damage.
# Default: 1
#
# Rate.Damage.Fall
# Damage after fall rate. (1 - standard, 2 - double damage, 0.5 - half damage, etc)
#
# Rate.Honor
# Honor gain rate
#
# Rate.Mining.Amount
# Rate.Mining.Next
# Mining Rates (Mining.Amount changes minimum/maximum usetimes of a deposit,
# Mining.Next changes chance to have next use of a deposit)
#
# Rate.Talent
# Talent Point rates
# Default: 1
#
# Death.SicknessLevel
# Starting Character start gain sickness at spirit resurrection (1 min)
# Default: 11
# -10 - character will have full time (10min) sickness at 1 level
# maxplayerlevel+1 - chaarcter will not have sickess at any level
#
# Death.CorpseReclaimDelay.PvP
# Death.CorpseReclaimDelay.PvE
# Enabled/disabled increase corpse reclaim delay at often PvP/PvE deaths
# Default: 1 (enabled)
# 0 (disabled)
#
# Death.Bones.World
# Death.Bones.BattlegroundOrArena
# Enabled/disabled creating bones instead corpse at resurrection (in normal zones/instacnes, or battleground/arenas)
# Default: 1 (enabled)
# 0 (disabled)
#
###################################################################################################################
Rate.Health = 1
Rate.Mana = 1
Rate.Rage.Income = 1
Rate.Rage.Loss = 1
Rate.Focus = 1
Rate.Loyalty = 500
Rate.Damage.Fall = 1
Rate.Honor = 1
Rate.Talent = 1
Death.SicknessLevel = 11
Death.CorpseReclaimDelay.PvP = 1
Death.CorpseReclaimDelay.PvE = 1
Death.Bones.World = 1
Death.Bones.BattlegroundOrArena = 1
###################################################################################################################
#
# NETWORK CONFIG
#
# Network.Threads
# Number of threads for network, recommend 1 thread per 1000 connections.
# Default: 1
#
# Network.OutKBuff
# The size of the output kernel buffer used ( SO_SNDBUF socket option, tcp manual ).
# Default: -1 (Use system default setting)
#
# Network.OutUBuff
# Userspace buffer for output. This is amount of memory reserved per each connection.
# Default: 65536
#
# Network.TcpNoDelay:
# TCP Nagle algorithm setting
# Default: 0 (enable Nagle algorithm, less traffic, more latency)
# 1 (TCP_NO_DELAY, disable Nagle algorithm, more traffic but less latency)
#
###################################################################################################################
Network.Threads = 1
Network.OutKBuff = -1
Network.OutUBuff = 65536
Network.TcpNodelay = 1
###################################################################################################################
# CONSOLE AND REMOTE ACCESS
#
# Console.Enable
# Enable console
# Default: 1 - on
# 0 - off
#
# Ra.Enable
# Enable remote console
# Default: 0 - off
# 1 - on
#
# Ra.IP
# Default remote console ip address, use 0.0.0.0 for every address
#
# Ra.Port
# Default remote console port
#
# Ra.MinLevel
# Minimum level that's required to login,3 by default
#
# Ra.Secure
# Kick client on wrong pass
#
###################################################################################################################
Console.Enable = 1
Ra.Enable = 0
Ra.IP = 0.0.0.0
Ra.Port = 3443
Ra.MinLevel = 3
Ra.Secure = 1
###################################################################################################################
# MISC
#
# RealmZone
# Server realm zone (set allowed alphabet in character names/etc). See also Strict*Names options.
#
# 1 Development - any language (Default)
# 2 United States - extended-Latin
# 3 Oceanic - extended-Latin
# 4 Latin America - extended-Latin
# 5 Tournament - basic-Latin at create, any at login
# 6 Korea - East-Asian
# 7 Tournament - basic-Latin at create, any at login
# 8 English - extended-Latin
# 9 German - extended-Latin
# 10 French - extended-Latin
# 11 Spanish - extended-Latin
# 12 Russian - Cyrillic
# 13 Tournament - basic-Latin at create, any at login
# 14 Taiwan - East-Asian
# 15 Tournament - basic-Latin at create, any at login
# 16 China - East-Asian
# 17 CN1 - basic-Latin at create, any at login
# 18 CN2 - basic-Latin at create, any at login
# 19 CN3 - basic-Latin at create, any at login
# 20 CN4 - basic-Latin at create, any at login
# 21 CN5 - basic-Latin at create, any at login
# 22 CN6 - basic-Latin at create, any at login
# 23 CN7 - basic-Latin at create, any at login
# 24 CN8 - basic-Latin at create, any at login
# 25 Tournament - basic-Latin at create, any at login
# 26 Test Server - any language
# 27 Tournament - basic-Latin at create, any at login
# 28 QA Server - any language
# 29 CN9 - basic-Latin at create, any at login
#
# BindIP
# Bind World Server to IP/hostname
#
# Expansion
# Allow server use content from expansion
# 2 - check expansion 2 maps existence, and if client support expansion 2 and account have
# expansion 2 setting then allow visit expansion 2 maps, allow create new class character)
# Default: 1 - check expansion 1 maps existence, and if client support expansion 1 and account have
# expansion 1 setting then allow visit expansion 1 maps, allow create new races character)
# 0 - not check expansion maps existence, not allow wisit its, not allow create new race or new class
# characters, ignore account expansion setting)
#
###################################################################################################################
RealmZone = 8
BindIP = "0.0.0.0"
Expansion = 1

Dythzer; I've made a list of bugged spells and a few ideas that would improve this server abit. I'll post it when I've tryed it out alittle bit more and when i've got the server up and working with hamachi.

Cheers Grabben

[simonsamiiee]

nice m8 I love this rly

[Grabben]

There must be some1 with some serious skill that can help me out there! I'm basically ripping my hair off, been trying to get this going for 3 weeks but can't get people to join my server.

Would be awesome and alot of fun, hope some1 can help me!

Thanks for the cleanup "2dgreengiant", just checked trought my posts and realised that they looked like shit and was just about to do it myself anyhow thanks for helping me there!

Cheers Grabben