How to: Create FREYA SQL/TXT Server Part 1
Things To Download (not finish)
1. MySQL 4.1.14
2. MySQL Control Center
3. Freya Latest Compiled SVN [The SQL Type] and also the CYGWINDLL files which is a compulsory to download.
4. Abyss Web Server
5. PHP 4.3.11
6. RO Control Panel 4.3.4a
-=First Thing To Do Before Setup=-
1. Check your local IP by clicking the windows START > RUN. Type in cmd and click OK.
2. At the command prompt type /ipconfig and write down the IP address. ie. Something like 192.168.1.2
3. Go to www.ipchicken.com and write down what is your WAN IP (Internet IP).
-=Freya SVN SQL & TXT Installation=-
1. Use Win RAR to extract the program files.
2. Extract it to anywhere you want but not in your desktop.
3. Go to Conf folder, open grf-files.txt and edit the patch to where your RO folder is but default is C:\Program Files\Gravity\RO\
4. Files we need to edit are char_athena.conf, login_athena.conf and map_athena.conf.
Use Notepad to edit .conf files.
char_athena.conf
Remove // for login_ip:, char_ip: and change 127.0.0.1 to your Internet IP (IP for letting ppl to connect to your server) but if you just want to test out, then just use 127.0.0.1, which is Local IP/Computer IP.
SAVE and exit.
login_athena.conf
Look for new_account: and change the value to 0 to disable using _M/_F registration. (Don't Change for TXT users. Player registration by typing Account_M or Account_F to account registration)
SAVE and exit.
map_athena.conf
Remove // for char_ip:, map_ip: and change 127.0.0.1 to your Internet IP (read char_athena.conf)
SAVE and exit.
-=MySQL Installation and Configurations Guide =-
1. Double click the installation file to start installation.
http://pascom.com.my/freya/MySQL/01.jpg
2. Choose Typical Installation.
http://pascom.com.my/freya/MySQL/02.jpg
3. Click Install and the program will start setting up to program to your server.
http://pascom.com.my/freya/MySQL/03.jpg
4. When done you will be asked for MySQL.com mdone you will be asked for MySQL.com membership sign up. Click SKIP SIGN UP and Next.
http://pascom.com.my/freya/MySQL/04.jpg
5. Click FINISH to start configure your installed MySQL server.
http://pascom.com.my/freya/MySQL/05.jpg
6. Click Next to proceed.
http://pascom.com.my/freya/MySQL/06.jpg
7. Choose Detailed Configuration and then click Next to proceed.
http://pascom.com.my/freya/MySQL/07.jpg
8. Choose Server Machine and click Next to proceed.
http://pascom.com.my/freya/MySQL/08.jpg
9. Choose Multifunctional Database and click Next to proceed.
http://pascom.com.my/freya/MySQL/09.jpg
10. Define your installation path and Click Next to proceed. In this manual all are default locations.
http://pascom.com.my/freya/MySQL/10.jpg
11. Choose Online Transaction Processing (OLTP) or Manually Define base on your server load.
http://pascom.com.my/freya/MySQL/11.jpg
12. Enable the TCP/IP Networking and Port Number 3306.
http://pascom.com.my/freya/MySQL/12.jpg
13. Choose standard character set for English or Manual select your own desired character set.
http://pascom.com.my/freya/MySQL/13.jpg
14. Tick Install As Windows Service and Launch the MySQL Server Automatically.
http://pascom.com.my/freya/MySQL/14.jpg
15. Uncheck the Modify Security Settings and click Next to proceed.
http://pascom.com.my/freya/MySQL/15.jpg
16. Click Execute to finish the configuration.
http://pascom.com.my/freya/MySQL/16.jpg
17. There you are your own MySQL Server.
http://pascom.com.my/freya/MySQL/17.jpg
-=MySQL Control Center Installation and Configurations Guide =-
1. Double click on the setup.exe to begin installation.
http://pascom.com.my/freya/mysqlcc/01.jpg
2. Accept the License Agreement and proceed to the NEXT ALL THE WAY. CONTINUE NEXT TILL THE END OF THE INSTALLATION.
http://pascom.com.my/freya/mysqlcc/02.jpg
3. After done the installation part, double click the MySQL Control Center icon on your desktop. It will launch the Register Server screen.
http://pascom.com.my/freya/mysqlcc/03.jpg
4. Key in the Name : ragnarok and Host Name : localhost Username : root Password : <leave it blank> and the click Test.
http://pascom.com.my/freya/mysqlcc/04.jpg
5. It will show a CONNECTION SUCCESSFUL SCREEN
http://pascom.com.my/freya/mysqlcc/05.jpg
6. Click OK and proceed with the Add Button.
http://pascom.com.my/freya/mysqlcc/06.jpg
7. The console manager will indicate that the database server ragnarok have been created but is not running. It is shown in red.
http://pascom.com.my/freya/mysqlcc/07.jpg
8. Double click on it and it will run itself.
http://pascom.com.my/freya/mysqlcc/08.jpg
9. Right click on the Databases and select New Database.
http://pascom.com.my/freya/mysqlcc/09.jpg
10. Enter ragnarok as your database name.
http://pascom.com.my/freya/mysqlcc/10.jpg
11. The database ragnarok is created. Double click on it and it will shown as below.
http://pascom.com.my/freya/mysqlcc/11.jpg
12. Right click on it and choose New Window from Here.
http://pascom.com.my/freya/mysqlcc/12.jpg
13. At the New Window from Here screen, click on the SQL button on the top right or press CTRL+Q
http://pascom.com.my/freya/mysqlcc/13.jpg
14. From the Query window, click the Open button or CTRL+O.
http://pascom.com.my/freya/mysqlcc/14.jpg
15. Point to the newly downloaded + extracted Freya SVN\sql folder.
http://pascom.com.my/freya/mysqlcc/15.jpg
16. Choose the main.sql and click open button.
http://pascom.com.my/freya/mysqlcc/16.jpg
17. Then click CTRL+E or click on the Execute button to process it. The Executing Query will turn black during the execution process and will be gray off when completed.
http://pascom.com.my/freya/mysqlcc/17.jpg
18. Press CTRL+O or click Open button to process the next sql.
http://pascom.com.my/freya/mysqlcc/18.jpg
19. Select the db_tables.sql and press CTRL+E or click Execute button to process. Repeat this step with item_db.sql, mob_db.sql and upgrade_2.0.2_database.sql.
http://pascom.com.my/freya/mysqlcc/19.jpg
20. After you have done with the upgrade_2.0.2_database.sql then close the MySQL Control Center.
http://pascom.com.my/freya/mysqlcc/20.jpg
21. Go back in to the MySQL Control Center and click on the database ragnarok > tables
http://pascom.com.my/freya/mysqlcc/21.jpg
22. Look for Login under the Tables and double click on it.
http://pascom.com.my/freya/mysqlcc/22.jpg
23. Right Click on the account_id field on the 15'th line amd select Insert Record
http://pascom.com.my/freya/mysqlcc/23.jpg
24. It will show a [NULL] field.
http://pascom.com.my/freya/mysqlcc/24.jpg
25. Double click on it and put in 2000001 and press ENTER
http://pascom.com.my/freya/mysqlcc/25.jpg
26. Fill in the userid [Your User ID] and the user_pass [Your Password] . After that at the level field, put in 99. This will be your Admin/GM account. Repeat the same thing to add more GM account.
http://pascom.com.my/freya/mysqlcc/26.jpg
27. Close the MySQL Control Center.
http://pascom.com.my/freya/mysqlcc/27.jpg
28. Go back in to the MySQL Control Center and double click the User Administration
http://pascom.com.my/freya/mysqlcc/28.jpg
29. Right click on the User Administration and select New User
http://pascom.com.my/freya/mysqlcc/29.jpg
30. The Add User Screen is shown as below.
http://pascom.com.my/freya/mysqlcc/30.jpg
31. Fill in Username : ragnarok Host : localhost Password : ragnarok . Tick All Priviledges as shown in the picture. Click Add and then Close.
http://pascom.com.my/freya/mysqlcc/31.jpg
32. MySQL Control Panel settings is complete for SVN settings.
http://pascom.com.my/freya/mysqlcc/32.jpg
-=PHP 4.3.11 Installation and Configurations Guide =-
1. Double click the installation file to start installation.
http://pascom.com.my/freya/PHP/01.jpg
2. Click On Agree
http://pascom.com.my/freya/PHP/02.jpg
3. Choose Standard.
http://pascom.com.my/freya/PHP/03.jpg
4. Click Next to proceed.
http://pascom.com.my/freya/PHP/04.jpg
5. Click Next to proceed.
http://pascom.com.my/freya/PHP/05.jpg
6. Choose Microsoft IIS4 or higher and click Next to proceed.
http://pascom.com.my/freya/PHP/06.jpg
7. Click Next to proceed.
http://pascom.com.my/freya/PHP/07.jpg
8. Click OK to ignore the error message. It is NORMAL.
http://pascom.com.my/freya/PHP/08.jpg
9. Click OK to proceed.
http://pascom.com.my/freya/PHP/09.jpg
10. Installation End
http://pascom.com.my/freya/PHP/10.jpg
How to: Create FREYA SQL/TXT Server Part 2
-=Abyss Web Server Installation And Configurations Guide=-
1. Double click the installation file to start installation. Click on I AGREE
http://pascom.com.my/freya/Abyss/001.jpg
2. Click NEXT
http://pascom.com.my/freya/Abyss/002.jpg
3. Specify your desired folder to install and click Install to proceed.
http://pascom.com.my/freya/Abyss/003.jpg
4. Click on the Install as a Windows Service and Start automatically on computer startup and click OK to proceed.
http://pascom.com.my/freya/Abyss/004.jpg
5. Click OK and you are done with ABYSS web server installation.
http://pascom.com.my/freya/Abyss/005.jpg
6. Click YES to start the webserver.
http://pascom.com.my/freya/Abyss/006.jpg
7. If you are installing it on a WinXP Service Pack 2 machine, you will be prompted to BLOCK/UNBLOCK screen. Click on UNBLOCK
http://pascom.com.my/freya/Abyss/007.jpg
8. Click OK to proceed.
http://pascom.com.my/freya/Abyss/008.jpg
9. The access console access configuration will appear and choose English / Your desired language to proceed.
http://pascom.com.my/freya/Abyss/009.jpg
10. Put in your desired admin name and the password and click OK
http://pascom.com.my/freya/Abyss/010.jpg
11. Login with the admin username and password which you created on the previous step.
http://pascom.com.my/freya/Abyss/011.jpg
12. You will be redirect to the Abyss Web Server Console as shown below.
http://pascom.com.my/freya/Abyss/012.jpg
13. Click on the Configure to enter the settings page.
http://pascom.com.my/freya/Abyss/013.jpg
14. Click on Scripting Parameters.
http://pascom.com.my/freya/Abyss/014.jpg
15. Under the interpreters, click the Add button.
http://pascom.com.my/freya/Abyss/015.jpg
16. Click on the Browse button next to the interpreter box.
http://pascom.com.my/freya/Abyss/016.jpg
17. Browse to C:\PHP\php.exe which you setup earlier on previous steps.
http://pascom.com.my/freya/Abyss/017.jpg
18. Select Type PHP Style and click ADD under the Associated Extensions part.
http://pascom.com.my/freya/Abyss/018.jpg
19. Type in php and click OK
http://pascom.com.my/freya/Abyss/019.jpg
20. Click OK to finish the current page configuration.
http://pascom.com.my/freya/Abyss/020.jpg
21. Under Custom Environment Variables click Add
http://pascom.com.my/freya/Abyss/021.jpg
22. In the Name box, type in REDIRECT_STATUS and 200 in the value box. Click OK to complete.
http://pascom.com.my/freya/Abyss/022.jpg
23. Click OK to proceed.
http://pascom.com.my/freya/Abyss/023.jpg
24. Click Restart to restart the webserver. Your web server is ready now.
http://pascom.com.my/freya/Abyss/024.jpg
-=Ragnarok Online Control Panel Installation and Configurations Guide =-
1. Extract the file that you have downloaded to C:\Program Files\Abyss Web Server\htdocs\cp. Then edit the config.php with notepad as shown below. Save and then exit from notepad.
http://pascom.com.my/freya/rocp/001.jpg
2. Launch MySQL control panel and create a new database.
http://pascom.com.my/freya/rocp/002.jpg
3. Create the database called cp and then double click to start it.
http://pascom.com.my/freya/rocp/003.jpg
4. Right click on the cp database and select the New Window From Here.
http://pascom.com.my/freya/rocp/004.jpg
5. Click on the SQL button or press CTRL+Q to go into Query Window.
http://pascom.com.my/freya/rocp/005.jpg
6. Click on the OPEN button.
http://pascom.com.my/freya/rocp/006.jpg
7. Point it to C:\Program Files\Abyss Web Server\htdocs\cp\install
http://pascom.com.my/freya/rocp/007.jpg
8. Select the Athena & Freya folder.
http://pascom.com.my/freya/rocp/008.jpg
9. Select the install.sql file.
http://pascom.com.my/freya/rocp/009.jpg
10. Click on the Execute or Press CTRL+E to start compile.
http://pascom.com.my/freya/rocp/010.jpg
11. Turn off the MYSQLCC and go back in. Then double click to start CP.
http://pascom.com.my/freya/rocp/011.jpg
12. Right click on the cp database and select the New Window From Here.
http://pascom.com.my/freya/rocp/012.jpg
13. Click on the SQL button or press CTRL+Q to go into Query Window.
http://pascom.com.my/freya/rocp/013.jpg
14. Type in UPDATE mysql.user .......... as per shown in the picture and then click Execute.
http://pascom.com.my/freya/rocp/014.jpg
15. Exit from MySQL Control Center and reload it again. Double click on the privilege section.
http://pascom.com.my/freya/rocp/015.jpg
16. Right click on the empty area and select INSERT RECORD.
http://pascom.com.my/freya/rocp/016.jpg
17. Key in 2000001 for the account id field and 4 for the priviledge.
http://pascom.com.my/freya/rocp/017.jpg
18. Turn off the MySQLCC when done and relaunch it. Go to the User Administration and Add a New User.
http://pascom.com.my/freya/rocp/018.jpg
19. Fill in as shown below. Username : cp Host : localhost Password : cp . Tick ALL Priviledge, Global Priviledges, cp on the right and with GRANT Option below.
http://pascom.com.my/freya/rocp/019.jpg
20. Tick ragnarok database also and All Privileges and With GRANT option and then click ADD.
http://pascom.com.my/freya/rocp/020.jpg
21. Go to C:\Program Files\MySQL\MySQL Server 4.1 and open up my.ini with notepad. Go to the bottom and type in this sentence. old_passwords
http://pascom.com.my/freya/rocp/021.jpg
22. Lastly go to C:\WINDOWSand open up php.ini and add in the 2 lines as highlighted in the picture below. Starting from the ;Note that ODBC ............
http://pascom.com.my/freya/rocp/022.jpg
23. Your ROCP is successfully setup now. You can try it by open up your Internet Explorer and type in localhost/cp/index.php at the address bar. Login with the account admin and password admin. (This admin account is the in-game GM account that you have created in MySQLCC 2000001)
http://pascom.com.my/freya/rocp/023.jpg
Back To Main Page
-=NO-IP Setup Guide For Dynamic IP Hoster=-
1. go to www.no-ip.com directly.
2. Register yourself an A/C and then activate the account upon receiving the email.
3. Login to the page at www.no-ip.com with the email address as the username and password which you key in during the registration.
4. When you are successfully logged on, click on the Add under the Host / Redirects Category.
http://pascom.com.my/freya/noip/002.jpg
5. Put in your desired hostname and choose from one of the FREE No-IP Domains. (eg. hostname : kambing / Free Domain no-ip.biz will become kambing.no-ip.biz)
http://pascom.com.my/freya/noip/003.jpg
6. After that, go and download the No-IP DUC Update Client For Windows.
http://pascom.com.my/freya/noip/004.jpg
7. Double click on the file that you have downloaded to begin installation.
http://pascom.com.my/freya/noip/005.jpg
8. Uncheck the View Readme and View Changes to bypass the readmes.
http://pascom.com.my/freya/noip/006.jpg
9. Click FINISH to complete the installation.
http://pascom.com.my/freya/noip/007.jpg
10. After you click the FINISH button, a screen will appear for you to key-in your email address and the password which you use for the No-IP Registration.
http://pascom.com.my/freya/noip/008.jpg
11. Lastly check on the domain name which you have registered and the smilie icon will turn to laugh if successful.
http://pascom.com.my/freya/noip/009.jpg
How to: Create FREYA SQL/TXT Server Part 3
-=Start Your Server=-
1. Extract all the cygwindlls.rar and the launcher.bat to the same folder of your Freya. Then create a short cut of your runserver.bat to the DESKTOP for convenient sake.
2. Double click the runserver.bat to start the server.
Your DONE Congratz..........
