How to import a database for ascent

[boone2515]

-Open up Navicat or what ever you use,and connect

-Now create a new database and name it what ever you want

-Now go to the database you created and click execute batch file

-Then and find the database you downloaded

-Now execute the file, this will take a while

-When that is done go into your ascent conf. and change the red word to your database name.

-Enjoy
-------------------------------------------------------------------------------------------------------

[boone2515]

continued

#######################################################################
# Ascent Configuration File
# Last Update: $Id: ascent.conf 2733 2007-12-28 08:06:58Z 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. *
* <block setting="0" someval = "1"> *
* *
* 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
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<WorldDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "ascent" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "logon" 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
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<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
#
# 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: 70
#
# Generated Level Level Cap
# This variable controls the level at which stats will generate up to. Generally the formulas go
# crazy after level 70 so this way you can keep the high visual but stats at a reasonable value.
# 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 cell unloading
# can use over 1.2GB memory with all creatures loaded.
# Default: 0
#
# LimitedNames
# This directive forces all character names to be a-z and A-Z compliant.
# Default: 1
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Server PlayerLimit = "1000"
Motd = "Thank you for using AC Web Ultimate Repack 7.4! Visit AC Web for more information."
SendBuildOnJoin = "1"
SendStatsOnJoin = "1"
EnableBreathing = "1"
LevelCap = "70"
GenLevelCap = "70"
SeperateChatChannels = "0"
CompressionThreshold = "1000"
QueueUpdateInterval = "5000"
KickAFKPlayers = "0"
ConnectionTimeout = "180"
RealmType = "1"
AdjustPriority = "0"
RequireAllSignatures = "0"
ShowGMInWhoList = "1"
MapUnloadTime="0"
LimitedNames="1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Die Directive
#
# If this triggers it means you didn't read your config file!
# Just comment it or remove it when you've read this.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

#<die msg="I am a newb who didn't even read half my config file!">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# 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="1"
KillReputation="1"
Honor="1"
PvPTimer="300000"
Compression="1"
XP="1"
QuestXP="1"
RestXP="1"
DropGrey="1"
DropWhite="1"
DropGreen="1"
DropBlue="1"
DropPurple="1"
DropOrange="1"
DropArtifact="1"
DropMoney="1"
Save="300000"
SkillChance="1"
SkillRate="1"
ArenaMultiplier2x="1"
ArenaMultiplier3x="1"
ArenaMultiplier5x="1">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# 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="0"
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 = "C:/AC Web Ultimate Repack/Server/htdocs/stats/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
#
# Additional Table Binding
# You can load static item/creature/etc data into the server using this directive.
# This way throughout database updates your custom data can be preserved.
# Format: "sourcetable destination table,sourcetable destinationtable"
# Example: "myitems items,mynpcs creature_names"
# Default: ""
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<Startup Preloading = "0"
BackgroundLootLoading = "1"
EnableMultithreadedLoading = "1"
LoadAdditionalTables="">

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# 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 &#37;u seconds."
# message will be sent upon flood triggering.
# Default: 0
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<FloodProtection Lines = "0" Seconds = "0" SendMessage = "0">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# LogonServer Setup
#
# DisablePings
# This directive controls whether pings will be sent to the logonserver to check
# if the connection is still "alive". Expect problems if it is disabled.
# Default: 0
#
# RemotePassword
# This directive controls the password used to authenticate with the logonserver.
# It must be the same between the two configs. If it is not, your server will
# not register.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<LogonServer DisablePings = "0"
RemotePassword = "ascent">


#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# AntiHack Setup
#
# Teleport
# This directive controls anti-teleport hack checks will be enabled or not.
# Default: 1
#
here is a good site to get databases
AC Web