also i wanna ask, with this database can i put the max exp ? ( and how much is the max exp) thxQuote:
Originally Posted by =Ady=
Printable View
also i wanna ask, with this database can i put the max exp ? ( and how much is the max exp) thxQuote:
Originally Posted by =Ady=
Quote:
Originally Posted by insain3338
well ..... theres ur problem really
in the "name =" part ur supposed to put the name of the database .... not root
so imma guess that ur world database is names "ascent" in mySQL ok, it should look liek this
<WorldDatabase Hostname = "localhost" Username = "root" Password = "------" Name = "ascent" Port = "3306" Type = "1">
u gets in now? also do the same thing for ur character database, from a later post i saw that u used "?logon" as the name for that so
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "------" Name = "logon" Port = "3306" Type = "1">
.... if u allrdy knew this then sry 4 useless post, hopes it wurx :)
i dont see any monsters/NPC! did the last part where u copy those syntax on ascent query and then Execute All Queries but it doesnt work!
HELP PLS!
oh.. i see now.. but i dunno really know what i did...
tnx alot for the help and this Guide is AWESOME!!
If I Start Ascent It Shows This
http://img205.imageshack.us/img205/1640/errornq8.th.png
And Than It Close.
Pls Help :dontgetit
Ok Here again using your guide as well as others im getting this error after filling the root section and trying to execute the Mysql Server
"The service could not be started. Error: 0"
The apears after pressing Execute
anyone can answer?Quote:
Originally Posted by =Ady=
ya still doesnt work. here is my whole file.
#######################################################################
# Ascent Configuration File
# Last updated at revision 1457 by 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 = "xxxxxx" Name = "ascent" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "xxxxxx" 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 = "127.0.0.1"
WorldServerPort = "3306">
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# 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
# 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 <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
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
<Server PlayerLimit = "100"
PlrUpdateDistance = "80"
Motd = "No MOTD specified."
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.
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
<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">
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# 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 = "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
# 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 = "monkey">
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# 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">
Max exp can really be anything u want , any number over the max exp will still act as maxQuote:
Originally Posted by =Ady=
Changing rates , level , ect ect can be done in your ascent.conf
For server setting like max player limit and stuff liek that look through your ascent conf till u find
<Server PlayerLimit = "100"
PlrUpdateDistance = "80"
Motd = "No MOTD specified."
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">
For rates and drops look for this just under it and it looks like this
<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">
thanks
which is the max lvl i can set up in this srv?
Hello, please give me the sql log codes so i can see npc & indications !
as fast as possible, thx !
Hatched forgot to update his page:((
Anyone know why mysql is being stupid and giving me Error:0
I Can Not See Any Npcs and Monsters...
How Do I Fix That ?
Pls Help.
there were few codes in STEP 11, but the posted didn t included step 11 in his site :((
Please someone put the codes to run in sql log here
This should do it...Quote:
Originally Posted by =Ady=
Code:alter table creature_proto change health minhealth int(30) unsigned not null;
alter table creature_proto add column maxhealth int(30) unsigned not null after minhealth;
update creature_proto set maxhealth=minhealth;
alter table creature_proto change level minlevel int(30) unsigned not null;
alter table creature_proto add column maxlevel int(30) unsigned not null after minlevel;
update creature_proto set maxlevel=minlevel;
alter table creature_proto add column invisibility_type int(30) unsigned not null;
alter table creature_proto add column death_state int(30) unsigned not null;
WOW! Thanks man! I will use it!
omg where are the codes for?
Hi everyone, I followed the quide which was very helpfull but i do not have any npc's or mobs. I tried to do the last part but i just cant figuire it out. any help would be helpfull so i can get this fixed.
Thanks so much
would apreciate any input on how to actually get mobs/NPC:s into the world.. read through the entire post and tried lots of stuff but still came out with an empty world..
If someone might be able to help it would be lovely.
Great Guide btw..
How do you add the config files and the ascent.exe onto your db? And where do you put it?
I have the message to pls helpQuote:
Originally Posted by Apollo54
Blacky when you put the fix in the querry make sure u select the DB you execute it in
I selected Ascent and it's not working.Quote:
Originally Posted by soulbound
I Am Noob ....
Please I need help! When i load WoW it works but there is no NPC or any mosters. I really need help i also need to make it public but right now i need to know how to fix the problem with the NPC and mosters.
Thanks!
I just learned how to update your data base to work on the new patch 2.2.3. If u want to learn how to do it answer my question up about the NPC's or someother reason.
lol