1. Guest, do you need help starting your own server? Take a look at our new guide with information and links to tutorials here.
  2. Guest, remember to add your server at our serverlist!

Basic Install Uniform Server and ZnoteAAC

Discussion in 'Windows' started by HalfAway, Feb 10, 2017.

  1. HalfAway

    HalfAway #1 Staff Member Administrator

    Joined:
    Feb 6, 2017
    Messages:
    219
    Likes Received:
    144
    Welcome to "How to Install Uniform Server and ZnoteAAC" on Windows tutorial.

    First we need to download Uniform Server which can be found here:
    https://sourceforge.net/projects/miniserver/files/
    You should always use the latest version.

    Once you've downloaded Uniform Server, open it and this window should show up.
    [​IMG]

    After the program extracted all the files you can find Uniform Server installed in the location you choose, the best place would be to extract it directly into your C: drive.
    Inside that folder you'll find the launcher for Uniform Server named UniController.exe, when you launch it this window should show up.
    [​IMG]
    When you first launch the program you should see a popup window, asking you to change your MySQL password then follow the guide to change it.
    If you do not get a popup window about MySQL password you can change it easily by clicking in the menu.
    MySQL -> Change MySQL Password.
    [​IMG]

    Remember to always use safe passwords.

    You can now start Apache and MySQL by clicking on these buttons.
    [​IMG]
    When Apache is successfully running your browser should start and you'll be redirected to a page that looks like this.
    [​IMG] [​IMG]

    The status images beside start/stop apache and mysql should now both be green.[​IMG]
    [​IMG]

    Creating a user and a database with phpMyAdmin
    In the UniformController you can find a link to phpMyAdmin.
    [​IMG]
    [​IMG]

    We are now going to create a new user with a strong password, to do this you click on the tab Users in the top menu in phpMyAdmin.
    [​IMG]
    You can now press Add user account.
    Click on the Generate button to generate a strong password.
    Check the Create database with same name and grant all privileges.
    Then hit Go at the bottom of the page.
    If you host your MySQL database on another location than localhost use the IP instead.

    Once the user is added, we can now insert the engines mysql schema, in this case we use TFS 1.X.
    First click on the database name in the database overview, we use otrealm as an example.
    Then hit the SQL tab and insert the engine/servers MySQL-schema.
    [​IMG]

    Once you've pasted/inserted the schema into the SQL window, press Go at the bottom of the page.

    You've now setup Uniform Server and created a phpMyAdmin user for the server/AAC, good job!

    You can now delete all files inside the www directory of Uniform Server.
    Next step, download and extract ZnoteAAC into the www directory.
    You can download latest ZnoteAAC 1.5 here:
    https://github.com/Znote/ZnoteAAC/archive/master.zip

    You should extract the files into the www folder like this.
    [​IMG]
    [​IMG]
    Now we need to insert ZnoteAAC's database tables, so visit your website by clicking View www.
    [​IMG]
    [​IMG]

    If you get a error that says php cURL is not enabled, then Stop Apache and under PHP in the menubar of Uniform Server click Edited selected configuration file.
    [​IMG]
    Search for extension=php_curl.dll and remove the semicolon ; in front of it, save the file and Start Apache.


    After you started Apache you should now see this page.
    [​IMG]
    [​IMG]
    Copy the schema in the text field like the picture below.
    [​IMG]
    [​IMG]
    Now go to phpMyAdmin again and paste the schema you just copied the same way you did with the engines MySQL schema from the SQL Tab.
    [​IMG]
    [​IMG]
    Then click Go.

    If you didn't get this error below, skip this step.
    If your server do not have guild war system, you might get an error like this when you try to insert ZnoteAAC MySQL schema.
    [​IMG]
    That means the server you are using do not have any guild war system.

    If no tables got inserted in the database you need to remove this.
    Code (SQL):
    1.  
    2. CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
    3.   `id` INT(11) NOT NULL AUTO_INCREMENT,
    4.   `limit` INT(11) NOT NULL DEFAULT '0',
    5.   PRIMARY KEY (`id`),
    6.   FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
    7. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    8.  
    Then hit go again.


    You've now inserted all tables ZnoteAAC requires, time to edit the config.php and get the AAC running!
    Inside your www directory open the file config.php with your favourite text-editor.

    First we need to set the correct TFS version, find this line
    Code (Text):
    1. $config['TFSVersion'] = 'TFS_10';
    Now when you've set the correct TFS version we need to edit the MySQL details, find this and set the correct details.
    Code (Text):
    1. // phpmyadmin username for OT server: (DONT USE "root" if ur hosting to public.).
    2.     $config['sqlUser'] = 'tfs10';
    3.  
    4.     // phpmyadmin password for OT server:
    5.     $config['sqlPassword'] = 'tfs10';
    6.  
    7.     // The database name to connect to. (This is usually same as username).
    8.     $config['sqlDatabase'] = 'tfs10';
    9.  
    10.     // Hostname is usually localhost or 127.0.0.1.
    11.     $config['sqlHost'] = '127.0.0.1';

    For example

    Code (Text):
    1. // phpmyadmin username for OT server: (DONT USE "root" if ur hosting to public.).
    2.     $config['sqlUser'] = 'otrealm';
    3.  
    4.     // phpmyadmin password for OT server:
    5.     $config['sqlPassword'] = '9lbKnWYwHYydax40';
    6.  
    7.     // The database name to connect to. (This is usually same as username).
    8.     $config['sqlDatabase'] = 'otrealm';
    9.  
    10.     // Hostname is usually localhost or 127.0.0.1.
    11.     $config['sqlHost'] = '127.0.0.1';
    You can now save the file and refresh the website and it should now work.

    You can now create a account and a character.
    To become a website admin you need to add your account name in config.php.

    Code (Text):
    1. $config['page_admin_access'] = array(
    2.         'halfaway',
    3.         'account2'
    4.     );
    Remember to seperate the account names with a comma.


    Congratulations, you've successfully setup Uniform Server and ZnoteAAC.
    Thank you for following this tutorial!
     
    LordVissie and Damon like this.
  2. Damon

    Damon Web Developer Staff Member Global Moderator

    Joined:
    Feb 7, 2017
    Messages:
    108
    Likes Received:
    49
    Great tutorial although I do neither like UniServer nor Windows when it comes to hosting :p
     
  3. Tarek1337

    Tarek1337 Member

    Joined:
    Feb 7, 2017
    Messages:
    64
    Likes Received:
    27
    It's great to use if you are planing on having a beta on your ot and doesn't have a VPS or a dedic yet.
     
  4. Damon

    Damon Web Developer Staff Member Global Moderator

    Joined:
    Feb 7, 2017
    Messages:
    108
    Likes Received:
    49
    Fair enough^^
     
  5. Split

    Split Member

    Joined:
    Aug 23, 2018
    Messages:
    6
    Likes Received:
    0
    i cant get it to let me make a character when doing these steps
     
  6. HalfAway

    HalfAway #1 Staff Member Administrator

    Joined:
    Feb 6, 2017
    Messages:
    219
    Likes Received:
    144
    What are you trying to do?
    Create a character using ZnoteAAC?
    Any errors?
     
  7. Split

    Split Member

    Joined:
    Aug 23, 2018
    Messages:
    6
    Likes Received:
    0
    only error i got right now is username and password isnt right but it is

    [​IMG]
     
    Last edited by a moderator: Sep 14, 2018
  8. Split

    Split Member

    Joined:
    Aug 23, 2018
    Messages:
    6
    Likes Received:
    0
    Can help me Fix that or no
     
  9. HalfAway

    HalfAway #1 Staff Member Administrator

    Joined:
    Feb 6, 2017
    Messages:
    219
    Likes Received:
    144
    Create a new account using ZnoteAAC and try to login with that new one.
     
  10. Split

    Split Member

    Joined:
    Aug 23, 2018
    Messages:
    6
    Likes Received:
    0
    tried that and no
    the Error i get still "
    We tried to log you in, but...
    • Username and password combination is wrong.
     
  11. Split

    Split Member

    Joined:
    Aug 23, 2018
    Messages:
    6
    Likes Received:
    0
    hey i got everything working but when playing Create character on website again and on tibia itself saying players name existed [​IMG] And [​IMG]
     
  12. HalfAway

    HalfAway #1 Staff Member Administrator

    Joined:
    Feb 6, 2017
    Messages:
    219
    Likes Received:
    144
    Make sure you've set the correct server version in config.php.
    The skill_fist column in your database does not exist on your server.
     
  13. Split

    Split Member

    Joined:
    Aug 23, 2018
    Messages:
    6
    Likes Received:
    0
    i have honestly tried that and didn work
     
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.