How to make a ascent server easy +making it public!!!

[Confucius]

Hapkidomaster’s guide on setting up a 2.3.x server with Spartansp repackv3

Ok guys this is my very first guide I am hoping to get some rep from it btw I take no credit for the repack!!!!!
I have used a lot of guides but noticed that they left gaps this guide will leave none!

What you need: MySQL Navicat Repack Winrar


Ok now that you have that downloaded here are steps to download MYSQL:
1. Click run
2. Click next
3.typical
4.install
5. Wait a few minutes
Ok now that that is done to config it click next then next
Check the box configure now then click finish
1. Click next
2. Click Standard Configuration then next
3. Install as window server service name MySQL then next
4. Type in a password in this guide I will be using root as the pass
5. Click next then execute (if you get unable to apply security settings that just means you have no password so leave pass blank later on)
6. Click finish
________________________________________________________________________________ __________________________________________
Ok just install Navicat you should be able to do that your self!!
Ok save repack into you c: drive then make a folder called the name of what you want your server and extract it into that folder (the repack).

Now open Navicat
1. Click on “connection” a big box on the top left hand corner
2. Type in the name of your server for connection name
3. Leave everything else how it is Except type in the pass you used when installing MySQL for your pass (unless you had security error then leave pass blank).
4. Click test connection if it says connection was successful then click ok and then ok. If it says it failed try leaving pass blank or your pass is just wrong!
Ok now right click the new connection and click new database name it spdb double click spdb then right click it and select Execute batch file
Click on the … go into your server folder or repack and select fullspdb.sql then start this may take a while…
Once it is done go into you repack and click the folder ascent3639 then ascent-logon server.conf go to where it says and change what is in red

<LogonDatabase Hostname = "localhost"
Username = "your MySQL user name default root"
Password = "the MySQL pass remember I used root if u got error then leave it like Password=“”"
Name = "spdb"
Port = "3306"
Type = "1">
Close and save that then open ascent-world and change what is in red
<WorldDatabase Hostname = "localhost"
Username = "your MySQL username"
Password = "your MySQL pass"
Name = "spdb"
Port = "3306"
Type = "1">
<CharacterDatabase Hostname = "localhost"
Username = "your MySQL username"
Password = "your MySQL pass"
Name = "spdb"
Port = "3306"
Type = "1">>

Now you can scoll down to
<Server PlayerLimit = "100"
Motd = "No MOTD specified."
SendBuildOnJoin = "1"
SendStatsOnJoin = "1"
EnableBreathing = "1"
LevelCap = "70"
GenLevelCap = "70"
SeperateChatChannels = "0"
CompressionThreshold = "1000"
QueueUpdateInterval = "5000"

And change the level cap and motd

Then scoll a bit more to

<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">

And choose your server rates!!
Go into Navicat and click on spdb database click on account table and make yourself an account!! Make sure you set gm to az scroll to the side more to flags and put 8 if you have tbc if not then put a 0.
Now start up ascent-logon server.exe then ascent-world.exe and change you realm list to 127.0.0.1 play!!



How to make your server public with hamachi (which is best for routers and it is more secure)
Create some hamachi networks

Ok do you see those numbers at the top of hamachi something like 5.17.21.187 that is your ip right it down *btw that one is mine yours will be different*

Now go back to your repack and open ascent-logon config file and find this part change what is in red to your hamachi IP



# Host Directive
#
# This is the address that the realmlist will listen on.
# To listen on all addresses, set it to 0.0.0.0
# Default: 127.0.0.1 (localhost)
#
# Note: ISHost is the interserver communication listener.
#
<Listen Host = "0.0.0.0"
ISHost = "0.0.0.0"
RealmListPort = "3724"
ServerPort = "8093">

Close and save then open ascent world and find this part and change what is in red to your hamachi IP

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# 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">

Save and close now go into your ascent-realms and change what is in red to your hamachi IP




<LogonServer Address = "127.0.0.1"
Port = "8093"
Name = "Default Logon"
RealmCount = "1">
Scroll down a bit more and find
<Realm1 Name = "Your realm name"
Address = "127.0.0.1:8129"
Icon = "Normal"
Colour = "1"
Population = "1.0"
TimeZone = "1">


Now to have others play with you have them change their realm list to your hamachi IP and have them join one of your hamachi networks!!!
Your done! Start up ascent-logonserver.exe when it says hooking signals open ascent-world.exe login and play!!!
I hope you liked this guide this is a custom guide made by me!! Not a repost and no one can repost it with out giving me credit!!! P.S. hoping for +Rep for this guide!!!
All the repack credit goes to Spartansp

[jerry809]

nice mate ...+Rep ... put some pics for the beginers

[Confucius]

Will do and ty i just gained a rank

[beuw]

sweet guide man, thanks, 1 problem, when my friend trys to join, it says logging into game server then brings him back. i did all the stuff right plz help.

[Lich King]

Pretty good, pics would be nice, but +Rep anyways

[ilox]

nice guide

[finmere]

Hi geart pack btw but one prob ever time i try to load the ascent-realmserver keeps saying access denied for user moocow'@'localhost you solve this +Rep

[Priveonic]

Hi geart pack btw but one prob ever time i try to load the ascent-realmserver keeps saying access denied for user moocow'@'localhost you solve this +Rep

yeah i get the same problam, :S

[Confucius]

"Hi geart pack btw but one prob ever time i try to load the ascent-realmserver keeps saying access denied for user moocow'@'localhost you solve this"


Ok guys you do not need the ascent-realmserver up for it to work it should work just fine without it I do not use it myself there is no need for it but leave it there! but it is just like voice chat you don't need that so there is no need for Ascent-realmserver to be running!! hope this helps.

[Confucius]

sweet guide man, thanks, 1 problem, when my friend trys to join, it says logging into game server then brings him back. i did all the stuff right plz help.

Hmmm.... did you click ascent-logonserver.exe first and then when it says hooking signals click ascent-world.exe ? if not that may be it because you have to remeber to always hit ascent-logonserver first if that did not work did you remeber to edit all of the conf files fully? sometimes ascent will exit so make sure that is still up if you did theese things please tell me so i can help your more!

[MathiasB]

I cant start the exe files,

Error:
Can not initalize properly (0xc0150002)

[Confucius]

I really hate it when that happens!! you gotta re-install or take ascent-world and ascent-logonserver from another repack u may have

[igorigs]

nice guide but how can i invite my friends to join?

[Confucius]

Once you make hamachi networks have them "join exisiting net work" type in the name of it and pass have them change their realmlist to your hamachi IP and go into navicat and make them acc or you could do this open "ascent-world.exe" bo x and tpye in createaccount username password email and8iftheyhaveTbcifnot0

[Confucius]

Fixmathais the fix link may fix it too