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