How to make a ascent server simple and fast + making it public menu

These ads disappear when you log in.

User Tag List

Results 1 to 15 of 15
  1. #1
    Confucius's Avatar Panda of Worlds The Idiot

    CoreCoins Purchaser Authenticator enabled
    Reputation
    1340
    Join Date
    Oct 2007
    Posts
    2,538
    Thanks G/R
    245/260
    Trade Feedback
    5 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to make a ascent server simple and fast + making it public

    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

    These ads disappear when you log in.

  2. #2
    Confucius's Avatar Panda of Worlds The Idiot

    CoreCoins Purchaser Authenticator enabled
    Reputation
    1340
    Join Date
    Oct 2007
    Posts
    2,538
    Thanks G/R
    245/260
    Trade Feedback
    5 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    WTB replies

  3. #3
    Confucius's Avatar Panda of Worlds The Idiot

    CoreCoins Purchaser Authenticator enabled
    Reputation
    1340
    Join Date
    Oct 2007
    Posts
    2,538
    Thanks G/R
    245/260
    Trade Feedback
    5 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    PLEASE REPLY!!!!!!!!!!!!!!!!!!!

  4. #4
    terradragon's Avatar Master Sergeant
    Reputation
    24
    Join Date
    Feb 2008
    Posts
    82
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Man just wait a bit. +rep for you.
    Last edited by terradragon; 03-16-2008 at 06:52 AM.

  5. #5
    alcha's Avatar Private
    Reputation
    1
    Join Date
    Mar 2008
    Posts
    10
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Great guide + rep

  6. #6
    Thrashed's Avatar Private
    Reputation
    1
    Join Date
    Mar 2008
    Posts
    3
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.
    Last edited by Thrashed; 03-16-2008 at 05:56 AM.

  7. #7
    Confucius's Avatar Panda of Worlds The Idiot

    CoreCoins Purchaser Authenticator enabled
    Reputation
    1340
    Join Date
    Oct 2007
    Posts
    2,538
    Thanks G/R
    245/260
    Trade Feedback
    5 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

  8. #8
    Janno's Avatar Private
    Reputation
    1
    Join Date
    Oct 2007
    Posts
    3
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nice guide.. got it work
    Last edited by Janno; 03-16-2008 at 04:11 PM.

  9. #9
    Orrix's Avatar Private
    Reputation
    1
    Join Date
    Mar 2008
    Posts
    5
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Ascent applications crashing

    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

    Last edited by Orrix; 03-16-2008 at 10:03 PM.

  10. #10
    Janno's Avatar Private
    Reputation
    1
    Join Date
    Oct 2007
    Posts
    3
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  11. #11
    joestyle2's Avatar Sergeant
    Reputation
    5
    Join Date
    Jan 2008
    Posts
    58
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nice guide !

    + rep

  12. #12
    Confucius's Avatar Panda of Worlds The Idiot

    CoreCoins Purchaser Authenticator enabled
    Reputation
    1340
    Join Date
    Oct 2007
    Posts
    2,538
    Thanks G/R
    245/260
    Trade Feedback
    5 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    YEP YOU GOTTA HAVE THE LATEST NET FRAME WORKS!!

  13. #13
    Confucius's Avatar Panda of Worlds The Idiot

    CoreCoins Purchaser Authenticator enabled
    Reputation
    1340
    Join Date
    Oct 2007
    Posts
    2,538
    Thanks G/R
    245/260
    Trade Feedback
    5 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    btw saying +rep doesn't give me it you gotta click on the rep button

  14. #14
    razordemon's Avatar Sergeant
    Reputation
    19
    Join Date
    Feb 2008
    Posts
    62
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    GOOD GUIDE!!! +rep

  15. #15
    balmug19's Avatar Member
    Reputation
    1
    Join Date
    Oct 2006
    Posts
    81
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i got a realm loop problem any ideas how to fix?
    Keep your friends close and your enimes 6 feet under

Similar Threads

  1. [Tutorial] How to make a public server non hamachi [WORKING][ASCENT/ARCEMU]
    By PBDJ1 in forum WoW EMU Guides & Tutorials
    Replies: 5
    Last Post: 06-30-2012, 07:50 AM
  2. How to Make Ascent Server 2.3.3+ and How to make it public with hamachi
    By Joonak in forum WoW EMU Guides & Tutorials
    Replies: 25
    Last Post: 03-06-2008, 04:29 PM
  3. Replies: 4
    Last Post: 02-08-2008, 11:34 PM
  4. Learn how to make a public wow server,website,latest patch 2.3.0
    By Respawn in forum WoW EMU Guides & Tutorials
    Replies: 15
    Last Post: 01-23-2008, 10:15 AM
  5. [How to]: change your IP simple and fast
    By Job For a Cowboy in forum World of Warcraft Bots and Programs
    Replies: 27
    Last Post: 09-04-2007, 07:55 PM
All times are GMT -5. The time now is 01:27 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2020 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search