HalfAway
Thanatos
Welcome to "How to Install Uniform Server and ZnoteAAC" on Windows tutorial.
I'm sure everyone knows I'm a fan of ZnoteAAC, so I'll provide a tutorial to easily set it up on Windows.
Welcome to "How to Install Uniform Server and ZnoteAAC" on Windows tutorial.
First we need to download Uniform Server which can be found here:
Uniform Server - Browse Files at SourceForge.net
You should always use the latest version.
Once you've downloaded Uniform Server, open it and this window should show up.
http://************/OTLand/tutorials/extract.png
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.
http://************/OTLand/tutorials/folder.png
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.
http://************/OTLand/tutorials/mysql.png
Remember to always use safe passwords.
You can now start Apache and MySQL by clicking on these buttons.
http://************/OTLand/tutorials/uniserver_start.png
When Apache is successfully running your browser should start and you'll be redirected to a page that looks like this.
http://************/OTLand/tutorials/splash.png
The status images beside start/stop apache and mysql should now both be green.
http://************/OTLand/tutorials/running.png
Creating a user and a database with phpMyAdmin
In the UniformController you can find a link to phpMyAdmin.
http://************/OTLand/tutorials/phpmyadmin.png
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.
http://************/OTLand/tutorials/addUser.gif
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 ******* as an example.
Then hit the SQL tab and insert the engine/servers MySQL-schema.
http://************/OTLand/tutorials/sqlInsert.png
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.
http://************/OTLand/tutorials/extracted.png
Now we need to insert ZnoteAAC's database tables, so visit your website by clicking View www.
http://************/OTLand/tutorials/view_www.png
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.
http://************/OTLand/tutorials/selected_conf.png
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.
http://************/OTLand/tutorials/znoteaac.png
Copy the schema in the text field like the picture below.
http://************/OTLand/tutorials/copySchema.png
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.
http://************/OTLand/tutorials/znoteSchema.png
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.
http://************/OTLand/tutorials/noWar.png
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.
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
Now when you've set the correct TFS version we need to edit the MySQL details, find this and set the correct details.
For example
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.
Remember to seperate the account names with a comma.
Congratulations, you've successfully setup Uniform Server and ZnoteAAC.
Thank you for following this tutorial!
I'm sure everyone knows I'm a fan of ZnoteAAC, so I'll provide a tutorial to easily set it up on Windows.
Welcome to "How to Install Uniform Server and ZnoteAAC" on Windows tutorial.
First we need to download Uniform Server which can be found here:
Uniform Server - Browse Files at SourceForge.net
You should always use the latest version.
Once you've downloaded Uniform Server, open it and this window should show up.
http://************/OTLand/tutorials/extract.png
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.
http://************/OTLand/tutorials/folder.png
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.
http://************/OTLand/tutorials/mysql.png
Remember to always use safe passwords.
You can now start Apache and MySQL by clicking on these buttons.
http://************/OTLand/tutorials/uniserver_start.png
When Apache is successfully running your browser should start and you'll be redirected to a page that looks like this.
http://************/OTLand/tutorials/splash.png
The status images beside start/stop apache and mysql should now both be green.
http://************/OTLand/tutorials/running.png
Creating a user and a database with phpMyAdmin
In the UniformController you can find a link to phpMyAdmin.
http://************/OTLand/tutorials/phpmyadmin.png
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.
http://************/OTLand/tutorials/addUser.gif
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 ******* as an example.
Then hit the SQL tab and insert the engine/servers MySQL-schema.
http://************/OTLand/tutorials/sqlInsert.png
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.
http://************/OTLand/tutorials/extracted.png
Now we need to insert ZnoteAAC's database tables, so visit your website by clicking View www.
http://************/OTLand/tutorials/view_www.png
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.
http://************/OTLand/tutorials/selected_conf.png
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.
http://************/OTLand/tutorials/znoteaac.png
Copy the schema in the text field like the picture below.
http://************/OTLand/tutorials/copySchema.png
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.
http://************/OTLand/tutorials/znoteSchema.png
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.
http://************/OTLand/tutorials/noWar.png
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.
SQL:
CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`limit` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;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:
$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:
// phpmyadmin username for OT server: (DONT USE "root" if ur hosting to public.).
$config['sqlUser'] = 'tfs10';
// phpmyadmin password for OT server:
$config['sqlPassword'] = 'tfs10';
// The database name to connect to. (This is usually same as username).
$config['sqlDatabase'] = 'tfs10';
// Hostname is usually localhost or 127.0.0.1.
$config['sqlHost'] = '127.0.0.1';For example
Code:
// phpmyadmin username for OT server: (DONT USE "root" if ur hosting to public.).
$config['sqlUser'] = '*******';
// phpmyadmin password for OT server:
$config['sqlPassword'] = '9lbKnWYwHYydax40';
// The database name to connect to. (This is usually same as username).
$config['sqlDatabase'] = '*******';
// Hostname is usually localhost or 127.0.0.1.
$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:
$config['page_admin_access'] = array(
'halfaway',
'account2'
);Congratulations, you've successfully setup Uniform Server and ZnoteAAC.
Thank you for following this tutorial!
Last edited:
