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 Vertrigo Server and ZnoteAAC

Discussion in 'Windows' started by HalfAway, Apr 17, 2018.

  1. HalfAway

    HalfAway #1 Staff Member Administrator

    Joined:
    Feb 6, 2017
    Messages:
    219
    Likes Received:
    144
    This tutorial will explain how to install VertrigoServ with ZnoteAAC.

    VertrigoServ is a complete free WAMP server allowing PHP development for Windows. It installs Apache 2.4, PHP, MySQL and PhpMyAdmin, both installing and setting up the environment.


    Download and Installation
    First we need to download and install Vertrigo, you should always download the latest stable version.
    VertrigoServ Download.

    Start the installation file you just downloaded.
    [​IMG]
    Select a language and run the installer by clicking OK.
    Click next and agree to the terms.

    I recommend to install webservers directly on C.
    [​IMG]

    Continue the installation until its done.

    Now start VertrigoServ and this window should show up.
    [​IMG]
    Click on "Hide this window and start server".
    Allow the services to run through your firewall, if such boxes shows up.

    Now its time to change the password for the root user in phpMyAdmin.

    Right click on the icon in the tray and navigate to 'Tools' -> and 'PhpMyAdmin'.
    [​IMG]

    [​IMG]
    Login using:
    Username:
    root
    Password: vertrigo

    In the top menu bar locate 'User accounts' and click it.
    [​IMG]

    Find the root user and click on 'Edit privileges', like the image below.
    [​IMG]

    Now click 'Change password'.
    [​IMG]

    Enter a new password and re-type the password then hit. GO.
    [​IMG]
    Remember to always use safe passwords.
    You are now done with the VertrigoServ setup.

    Setup ZnoteAAC on VertrigoServ
    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.
    Because you should never use the root details as login information for the website/server.

    [​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 created a phpMyAdmin user for the server/AAC, good job!

    You can now delete all files inside the WWW directory of VertrigoServer.
    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]

    Now we need to insert ZnoteAAC's database tables, so visit your website folder by clicking WWW folder.
    [​IMG]

    When you try to visit your website by either right-clicking on the Vertrigo icon or navigating to http://127.0.0.1 in your browser, you will see this.
    [​IMG]

    Copy the schema in the text field like the picture below.
    [​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]
    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.
     
    Last edited: Apr 17, 2018
  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.