[hapkidomaster]

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: [Only registered and activated users can see links. ] [Only registered and activated users can see links. ] [Only registered and activated users can see links. ] [Only registered and activated users can see links. ]


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 for this guide!!!
All the repack credit goes to Spartansp

[hapkidomaster]

WTB replies

[hapkidomaster]

PLEASE REPLY!!!!!!!!!!!!!!!!!!!

[terradragon]

Man just wait a bit. +rep for you.

[alcha]

Great guide + rep

[Thrashed]

Great guide, should add that its public with hamachi near the beginning, and you did great detail, but at the end, you just kind of didn't give detail on how to make accounts like you gave detail for everything else.

[hapkidomaster]

I thought I did you go into Navicat duoble click your connection to open it then double click on the spdb database the on the right were all the tables areyou double click on accounts and fill out the info and create yourself an account and for flags 0 for non tbc and 8 for tbc

[Janno]

Nice guide.. got it work

[Orrix]

Ok I got everything done but when I try to launch the ascent-logon and ascent-worlds they just crash here is the error I get...

the application failed to initialize properly (0xc0150002). click on OK to terminate the application.

PLEASE help me this also happened when I tryed to use Deranged Taco's guide

I am also getting this when I execute the fullspdb.sql with navcat:

[Err] 1074 - Column length too big for column 'regex_ignore_if_matched' (max = 255); use BLOB or TEXT instead
[Err] 1074 - Column length too big for column 'regex_ignore_if_matched' (max = 255); use BLOB or TEXT instead
[Msg] Finished - Unsuccessfully

[Janno]

i got that same message first too on laptop.. then installed to my main computer and now working fine, but i think it is because you dont have newest version Net framework. i think its work after you get that.

[joestyle2]

Nice guide !

+ rep

[hapkidomaster]

YEP YOU GOTTA HAVE THE LATEST NET FRAME WORKS!!

[hapkidomaster]

btw saying +rep doesn't give me it you gotta click on the rep button

[razordemon]

GOOD GUIDE!!! +rep

[balmug19]

i got a realm loop problem any ideas how to fix?