Herleybob - Ascent 2.3.0 Server Setup

[twrabat]

nice, figured everytihng out. all i need to do now is the pach for the npc's, hopefully that will solve it.

got question too, anyone know commcands for .learn? like i can enter few random ones and i get radom spells, just wondering if anyone know spefic ones, i dont want to guess all of them

-------------------------------------------------------------------------------------------
command flag description/syntax of command
-------------------------------------------------------------------------------------------
| commands | h | Shows commands. |
| help | h | Shows help for command. |
| announce | u | Sends msg to all. |
| wannounce | u | Sends widescreen msg to all. |
| appear | v | Teleports to x's position. |
| summon | v | Summons x to your position. |
| banchar | b | Bans character x with or without reason. |
| unbanchar | b | Unbans character x. |
| banreason | b | Shows the reason for ban. |
| kick | b | Kicks player from server. |
| addipban | b | Bans by IP address: .addipban IP Duration. |
| delipban | b | Removes an IP ban: .delipban IP. |
| kill | r | .kill - Kills selected unit. |
| revive | r | Revives target. |
| reviveplr | r | Revives player specified. |
| morph | m | Morphs into model id x. |
| demorph | m | Demorphs from morphed model. |
| mount | m | Mounts into modelid x. |
| dismount | h | Dismounts. |
| gm | p | Shows active GMs. |
| gmoff | t | Sets GM tag off. |
| gmon | t | Sets GM tag on. |
| gps | p | Shows position. |
| info | p | Server info. |
| worldport | v | Teleports to location: .worldport mapId x y z. |
| save | s | Saves your character. |
| saveall | s | Saves all playing characters. |
| security | z | Change x's GM access level. |
| start | m | Teleports you to a starting location. |
| levelup | m | Increases target's level by x. |
| additem | m | Adds item x y times. |
| removeitem | m | Remove item x y times. |
| invincible | j | .invincible - Toggles INVINCIBILITY (mobs won't attack you). |
| invisible | i | .invisible - Toggles INVINCIBILITY and INVISIBILITY. |
| resetreputation | n | .resetreputation - Resets reputation to start levels. |
| resetlevel | n | .resetlevel - Resets a players stats to level 1. |
| resetspells | n | .resetspells - Resets a players spells to starting spells. |
| resettalents | n | .resettalents - Resets all talents of targeted player. |
| resetskills | n | .resetskills - Resets all skills. |
| learn | m | Learns spell. |
| unlearn | m | Unlearns spell. |
| learnskill | m | <skillid> (optional) <value> <maxvalue>. |
| advanceskill | m | <skillid> <amount, (optional) <value>. |
| removeskill | m | .removeskill <skillid> - Removes skill. |
| increaseweaponskill | m | <count> - Increase equipped weapon skill x times. |
| getskilllevel | m | Gets the current level of a skill. |
| getskillinfo | m | Gets all the skills from a player. |
| createaccount | z | Format should be .createaccount username password email. |
| playerinfo | z | Displays information about the character. |
| uptime | h | Shows server uptime. |
| getpos | d | No description. |
| removeauras | m | Removes all auras from target. |
| paralyze | b | Roots/Paralyzes the target. |
| unparalyze | b | Unroots/Unparalyzes the target. |
| setmotd | m | Sets message of the day. |
| additemset | m | Adds item set to inv. |
| gotrig | v | Warps to areatrigger <id>. |
| createinstance | m | Creates instance on map <map>. |
| goinstance | m | Joins instance <instance> <x> <y> <z> <optional mapid>. |
| exitinstance | m | Exits current instance, return to entry point. |
| reloadtable | m | Reloads some of the database tables. |
| spawnspiritguide | m | Spawns a spirit guide (params: 1 = horde, 0 = alliance. |
| servershutdown | z | Initiates server shutdown in <x> seconds. |
| serverrestart | z | Initiates server restart in <x> seconds. |
| allowwhispers | c | Allows whispers from player <s> while in gmon mode. |
| blockwhispers | c | Blocks whispers from player <s> while in gmon mode. |
| advanceallskills | m | Advances all skills <x> points. |
| killbyplayer | f | Disconnects the player with name <s>. |
| killbyaccount | f | Disconnects the session with account name <s>. |
| unlockmovement | m | Unlocks movement for player. |
| castall | z | Makes all players online cast spell <x>. |
| getrate | f | Gets rate <x>. |
| setrate | f | Sets rate <x>. |
| modperiod | m | Changes period of current transporter. |
| npcfollow | m | Sets npc to follow you. |
| nullfollow | m | Sets npc to not follow anything. |
| formationlink1 | m | Sets formation master. |
| formationlink2 | m | Sets formation slave with distance and angle. |
| formationclear | m | Removes formation from creature. |
| masssummon | z | No description. |
| playall | m | No description. |
| addguard | a | Adds a guardentry to the zonetables DB and reloads. |
| renameguild | a | Renames a guild. |
| forcerenamechar | a | No description. |
| renamechar | m | Renames character x to y. |
| createarenateam | g | Creates arena team. |
| clearcooldowns | m | Clears all cooldowns for your class. |
| getstanding | m | Gets standing of faction. |
| setstanding | m | Sets standing of faction. |
| reloadaccounts | z | Reloads accounts on logon server. |
| lookupitem | h | Looks up item string x. |
| lookupquest | h | Looks up quest string x. |
| lookupcreature | h | Looks up creature string x. |
| silentplayer | t | Player cannot chat for x minutes. |
| changepassword | z | Changes your account's password. |
| rehash | z | Reloads config file. |
| whisperblock | g | Blocks like .gmon without the <GM> tag. |

-------------------------------------------------------------------------------------------
.modify
-------------------------------------------------------------------------------------------
| hp | m | Health Points/HP. |
| mana | m | Mana Points/MP. |
| rage | m | Rage Points. |
| energy | m | Energy Points. |
| level | m | Level. |
| armor | m | Armor. |
| holy | m | Holy Resistance. |
| fire | m | Fire Resistance. |
| nature | m | Nature Resistance. |
| frost | m | Frost Resistance. |
| shadow | m | Shadow Resistance. |
| arcane | m | Arcane Resistance. |
| damage | m | Unit Damage Min/Max. |
| scale | m | Size/Scale. |
| gold | m | Gold/Money/Copper. |
| speed | m | Movement Speed. |
| nativedisplayid | m | Native Display ID. |
| displayid | m | Display ID. |
| flags | m | Unit Flags. |
| faction | m | Faction Template. |
| dynamicflags | m | Dynamic Flags. |
| talentpoints | m | Talent Points. |
| loyalty | m | Loyalty. |
| spirit | m | Spirit. |
| boundingradius | m | Bounding Radius. |
| combatreach | m | Combat Reach. |
| emotestate | m | NPC Emote State. |

-------------------------------------------------------------------------------------------
.debug
-------------------------------------------------------------------------------------------
| infront | d | No description. |
| showreact | d | No description. |
| aimove | d | No description. |
| dist | d | No description. |
| face | d | No description. |
| moveinfo | d | No description. |
| setbytes | d | No description. |
| getbytes | d | No description. |
| unroot | d | Frees a rooted target. |
| root | d | Same as .paralyze. Roots the target in place. |
| landwalk | d | No description. |
| waterwalk | d | Allows the target to walk on water. |
| castspell | d | <spellid> - Casts spell on target. |
| castspellne | d | Casts spell on target (only plays animations). |
| celldelete | d | .celldelete YES YES removes everything in a range of 1cell. |
| addrestxp | d | .addrestxp - Adds x rest XP to player. |
| generatename | d | .generatename - Generates name for pet, etc. |
| attackerinfo | d | Shows selected mob/player's attacker's information. |
| showattackers | d | Shows selected mob/player's attacker on the minimap. |
| aggrorange | d | Shows aggro Range of the selected Creature. |
| knockback | d | <value> - Knocks you back. |
| fade | d | <value> - calls ModThreatModifier(). |
| threatMod | d | <value> - calls ModGeneratedThreatModifier(). |
| calcThreat | d | <dmg> <spellId> - calculates threat. |
| threatList | d | returns all AI_Targets of the selected Creature. |
| gettptime | d | grabs transporter travel time. |
| itempushresult | d | sends item push result. |
| weather | d | <type> - sun=0,fog=1,lightrain=2,rain=4,snow=8,sandstorm=16 |
| <value> - min = 0.2 , max = 2. |
| setbit | d | No description. |
| setvalue | d | No description. |
| aispelltestbegin | d | No description. |
| aispelltestcontinue | d | No description. |
| aispelltestskip | d | No description. |
| dumpcoords | d | No description. |
| speedchange | d | No description. |
| sendpacket | d | No description. |
| sqlquery | d | No description. |
| rangecheck | d | Checks the 'yard' range and internal range between the |
| player and the target. |

-------------------------------------------------------------------------------------------
.waypoint
-------------------------------------------------------------------------------------------
| add | w | Add wp at current pos. |
| show | w | Show wp's for creature. |
| hide | w | Hide wp's for creature. |
| delete | w | Delete selected wp. |
| movehere | w | Move to this wp. |
| flags | w | Wp flags. |
| waittime | w | Wait time at this wp. |
| emote | w | Emote at this wp. |
| skin | w | Skin at this wp. |
| change | w | Change at this wp. |
| info | w | Show info for wp. |
| movetype | w | Movement type at wp. |
| generate | w | Randomly generates wps. |
| deletall | w | Deletes all of the selected targets wps. |
| addfly | w | Adds a flying waypoint. |

-------------------------------------------------------------------------------------------
.gobject
-------------------------------------------------------------------------------------------
| select | o | Selects the nearest GameObject to you. |
| delete | o | Deletes selected GameObject. |
| spawn | o | Spawns a GameObject by ID. |
| Adding a 1 to the end of this saves it to db. |
| Ex: .gobject spawn 18 1. |
| info | o | Gives you informations about selected GO. |
| activate | o | Activates/Opens the selected GO. |
| enable | o | Enables the selected GO for use. |
| scale | o | Sets scale of selected GO. |
| animprogress | o | Sets anim progress. |
| export | o | Exports the current GO selected. |
| statelink | o | Links a GO state to a NPC. |
| move | g | Moves gameobject to player xyz. |
| rotate | g | Rotates gameobject x degrees. |

-------------------------------------------------------------------------------------------
.battleground
-------------------------------------------------------------------------------------------
| setbgscore | e | <Teamid> <Score> - Sets battleground score. 2 Arguments. |
| startbg | e | Starts current battleground match. |
| pausebg | e | Pauses current battleground match. |
| bginfo | e | Displays information about current battleground. |
| battleground | e | Shows BG Menu. |
| setworldstate | e | <var> <val> - Var can be in hex. WS Value. |
| playsound | e | <val>. Val can be in hex. |
| setbfstatus | e | .setbfstatus - NYI. |
| leave | e | Leaves the current battleground. |

-------------------------------------------------------------------------------------------
.npc
-------------------------------------------------------------------------------------------
| vendoradditem | n | Adds to vendor. |
| vendorremoveitem | n | Removes from vendor. |
| name | n | Changes creature name. |
| subname | n | Changes creature subname. |
| flags | n | Changes NPC flags. |
| emote | n | .emote - Sets emote state. |
| run | n | No description. |
| addweapon | n | No description. |
| allowmove | n | No description. |
| addgrave | n | No description. |
| addsh | n | No description. |
| addspirit | n | No description. |
| spawn | n | <entry> <flags> <faction> <level> <name>. |
| spawnentry | n | <entry>. |
| delete | n | Deletes mob from db and world. |
| info | n | Displays NPC information. |
| guid | n | Shows selected object guid. |
| addAgent | n | need to summarize this up. |
| delAgent | n | <procEvent> <spellId>. |
| listAgent | n | Lists ai_agents of an NPC. |
| reset | n | resets npc health/dmg from temp table. |
| export | n | Exports the npc to a sql file. |
| say | n | <text> - Makes selected mob say text <text>. |
| yell | n | <text> - Makes selected mob yell text <text>. |
| come | n | come - Makes npc move to your position. |
| return | n | return - Returns ncp to spawnpoint. |

-------------------------------------------------------------------------------------------
.cheat
-------------------------------------------------------------------------------------------
| status | m | Shows active cheats. |
| taxi | m | Enables all taxi nodes. |
| cooldown | m | Enables no cooldown cheat. |
| casttime | m | Enables no cast time cheat. |
| power | m | Disables mana consumption etc. |
| god | m | Sets god mode, prevents you from taking damage. |
| fly | m | Sets fly mode. |
| land | m | Unsets fly mode. |
| explore | m | Reveals the unexplored parts of the map. |
| flyspeed | m | Modifies fly speed. |
| stack | m | Enables aura stacking cheat. |
| triggerpass | m | Ignores area trigger prerequisites. |

-------------------------------------------------------------------------------------------
.honor
-------------------------------------------------------------------------------------------
| getpvprank | m | Gets PVP Rank. |
| setpvprank | m | Sets PVP Rank. |
| addpoints | m | Adds x amount of honor points/currency. |
| addkills | m | Adds x amount of honor kills. |
| globaldailyupdate | m | Daily honor field moves. |
| singledailyupdate | m | Daily honor field moves for selected player only. |
| pvpcredit | m | Sends PVP credit packet, with specified rank and points. |

-------------------------------------------------------------------------------------------
.pet
-------------------------------------------------------------------------------------------
| createpet | m | Creates a pet with <entry>. |
| renamepet | m | Renames a pet to <name>. |
| enablerename | m | Enables pet rename. |
| addspell | m | Teaches pet <spell>. |
| removespell | m | Removes pet spell <spell>. |

-------------------------------------------------------------------------------------------
.recall
-------------------------------------------------------------------------------------------
| list | q | List recall locations. |
| port | q | Port to recalled location. |
| add | q | Add recall location. |
| del | q | Remove a recall location. |
| portplayer | m | recall ports player. |

-------------------------------------------------------------------------------------------
.quest
-------------------------------------------------------------------------------------------
| addboth | 2 | Add quest <id> to the targeted NPC as start & finish. |
| addfinish | 2 | Add quest <id> to the targeted NPC as finisher. |
| addstart | 2 | Add quest <id> to the targeted NPC as starter. |
| delboth | 2 | Delete quest <id> from the targeted NPC as start & finish. |
| delfinish | 2 | Delete quest <id> from the targeted NPC as finisher. |
| delstart | 2 | Delete quest <id> from the targeted NPC as starter. |
| complete | 2 | Complete/Finish quest <id>. |
| finisher | 2 | Lookup quest finisher for quest <id>. |
| item | 2 | Lookup itemid necessary for quest <id>. |
| list | 2 | Lists the quests for the npc <id>. |
| load | 2 | Loads quests from database. |
| lookup | 2 | Looks up quest string x. |
| giver | 2 | Lookup quest giver for quest <id>. |
| remove | 2 | Removes the quest <id> from the targeted player. |
| reward | 2 | Shows reward for quest <id>. |
| status | 2 | Lists the status of quest <id>. |
| spawn | 2 | Port to spawn location for quest <id>. |
| start | 2 | Starts quest <id>. |

-------------------------------------------------------------------------------------------
.account
-------------------------------------------------------------------------------------------
| ban | z | Ban account. .account ban name timeperiod. |
| unban | z | Unbans account x. |
| create | z | Create account. Pass it username password email. |
| email | z | Sets email address on account. |
| Pass it username email_address. |
| flags | z | Sets flags on account. Pass it username and 0 for Non-TBC |
| or 8 for TBC. |
| level | z | Sets gm level on account. Pass it username and 0,1,az,etc. |
| password | z | Sets password on account. Pass it username password. |
| reload | z | Reloads accounts on logon server. |

-------------------------------------------------------------------------------------------
.guild
-------------------------------------------------------------------------------------------
| create | m | Creates a guild. |
| rename | m | Renames a guild. |
| members | m | Lists guildmembers and their ranks. |
| removeplayer | m | Removes a player from a guild. |
| disband | m | Disbands the guild of your target. |

-------------------------------------------------------------------------------------------

To create a custom command level (for instance an account that can allow recall, recall list,
and recall port only) go into Command_overrides and under command name type "recall" then security
level type "t". T is the letter we'll be using to represent a Teleporter account. Then go down
and add "recall port" and "recall list" with the permissions "t". To change someone's account

GM COMMANDS TAKEN FROM Ascent GM wiki
to a teleporter account, change their privileges to "t" <-- without quotes.

[pennybox]

Copy Your Account Database Into your Ascent go into your Ascent, Realms, LogonServer, And Make Sure Nothing is in Caps.

I had the Same Problem as you, And It fixed it! Good luck

[Moonfane]

+Repnice...now for the servers that already exist we need a repack of 2.3 *cough Chrispee* :P or someone!

[Icelighter]

When I try to log in , it gets stuck at "Success". Help please if u have any tips.

[N4P4Lm]

Just what i needed

[Outlands]

Mini Guide:

Ok Start, Thx you Harleybob, You repack is so good. Guys, THIS REPACK HAVE CREEPS, READ THE GUIDE!

-1 : Don't Create 2 Databases on SqlLog... Create only one and called World.


-2 Edit Tool Called Imported and change this:

Change Wdb To World and Cdb to World.

-3 Save and close and execute the tool


1 Step, Click W, wait and close
2 Step, Click C, wait and close
3 Step, Click N, TO FIX CREEPS/NPC!

4- Go To SQL refresh, Click database called world. Now check the database . In the database called world , need have accounts, etc... Rember u only need have 1 database and calleed world. dont create the database called Accounts..

Sorry for my english... bye guys

[jutzal]

Getting this error :

Starting the Character Import Process ---
[Importing] character Tables
ERROR 1049 (42000): Unknown database 'accounts'
[Importing] Finished
Druk op een toets om door te gaan. . .

[jutzal]

Nvm fixed it

[ghostay]

Thanks dude

[Nubbadon]

Ok so i downloaded the repack and it worked smoothly until i were going to start the server. Ok so this is the story.

I pushing logonserver. It says Hooking Signals...

I push Ascent. And when it get down to the end it says "21:42 N LoggonCommClient: Connecting to logonserver on `5.45.147.43:8093`...
21:42 N LoggonCommClient: Authenticating...
21:42 N LoggonCommClient: Authentication failed."

What the heck is this? I have putted up my Hamachi Ip cuz i want it live... But that happend when i had not putted it in... So whats wrong? som1 please help

[Herleybob]

Please delete everyhting you have, Uninstall Mysql, Sqlyog, And delete the repack, and follow this guide i made - Here -

[tesh1234]

Hey i got it all to work except for i cant login and in the acsent.exe it always says errors about sql query failed due to[Table ' ascent.(somthing)' doesn't exsist] somthing being for example server_settings or characters what did i do wrong do i have to fill in all this stuff? that would take for ever and i dont know what to put in the tables

[threehitu]

when ever i try to start the lang thing it will start for like 2 secs and then it will shut off

[Mannyf]

Hey, thanks for the guide everythings working except I get ONE error.. [Sql query failed due to [Table 'ascent.characters_insert_queue' doesn't exist], ! What did I do wrong...?

[Mannyf]

It all works connects good I just can login! and yes I made account is SQLog :/