How to: Create FREYA SQL/TXT Server

[an2ny_18]

How to: Create FREYA SQL/TXT Server Part 1

Things To Download (not finish)

1.

You must be registered to see links

2.

You must be registered to see links

3.

You must be registered to see links

and also the

You must be registered to see links

files which is a compulsory to download.

4.

You must be registered to see links

5.

You must be registered to see links

6.

You must be registered to see links

-=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

You must be registered to see links

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.

2. Choose Typical Installation.

3. Click Install and the program will start setting up to program to your server.

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.

5. Click FINISH to start configure your installed MySQL server.

6. Click Next to proceed.

7. Choose Detailed Configuration and then click Next to proceed.

8. Choose Server Machine and click Next to proceed.

9. Choose Multifunctional Database and click Next to proceed.

10. Define your installation path and Click Next to proceed. In this manual all are default locations.

11. Choose Online Transaction Processing (OLTP) or Manually Define base on your server load.

12. Enable the TCP/IP Networking and Port Number 3306.

13. Choose standard character set for English or Manual select your own desired character set.

14. Tick Install As Windows Service and Launch the MySQL Server Automatically.

15. Uncheck the Modify Security Settings and click Next to proceed.

16. Click Execute to finish the configuration.

17. There you are your own MySQL Server.

-=MySQL Control Center Installation and Configurations Guide =-

1. Double click on the setup.exe to begin installation.

2. Accept the License Agreement and proceed to the NEXT ALL THE WAY. CONTINUE NEXT TILL THE END OF THE INSTALLATION.

3. After done the installation part, double click the MySQL Control Center icon on your desktop. It will launch the Register Server screen.

4. Key in the Name : ragnarok and Host Name : localhost Username : root Password : <leave it blank> and the click Test.

5. It will show a CONNECTION SUCCESSFUL SCREEN

6. Click OK and proceed with the Add Button.

7. The console manager will indicate that the database server ragnarok have been created but is not running. It is shown in red.

8. Double click on it and it will run itself.

9. Right click on the Databases and select New Database.

10. Enter ragnarok as your database name.

11. The database ragnarok is created. Double click on it and it will shown as below.

12. Right click on it and choose New Window from Here.

13. At the New Window from Here screen, click on the SQL button on the top right or press CTRL+Q

14. From the Query window, click the Open button or CTRL+O.

15. Point to the newly downloaded + extracted Freya SVN\sql folder.

16. Choose the main.sql and click open button.

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.

18. Press CTRL+O or click Open button to process the next sql.

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.

20. After you have done with the upgrade_2.0.2_database.sql then close the MySQL Control Center.

21. Go back in to the MySQL Control Center and click on the database ragnarok > tables

22. Look for Login under the Tables and double click on it.

23. Right Click on the account_id field on the 15'th line amd select Insert Record

24. It will show a [NULL] field.

25. Double click on it and put in 2000001 and press ENTER

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.

27. Close the MySQL Control Center.

28. Go back in to the MySQL Control Center and double click the User Administration

29. Right click on the User Administration and select New User

30. The Add User Screen is shown as below.

31. Fill in Username : ragnarok Host : localhost Password : ragnarok . Tick All Priviledges as shown in the picture. Click Add and then Close.

32. MySQL Control Panel settings is complete for SVN settings.

-=PHP 4.3.11 Installation and Configurations Guide =-

1. Double click the installation file to start installation.

2. Click On Agree

3. Choose Standard.

4. Click Next to proceed.

5. Click Next to proceed.

6. Choose Microsoft IIS4 or higher and click Next to proceed.

7. Click Next to proceed.

8. Click OK to ignore the error message. It is NORMAL.

9. Click OK to proceed.

10. Installation End

 

[kim04]

Hey Nice Guide ^_^ Check Your Private Message i have a PM for you ^_^

 

[an2ny_18]

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

2. Click NEXT

3. Specify your desired folder to install and click Install to proceed.

4. Click on the Install as a Windows Service and Start automatically on computer startup and click OK to proceed.

5. Click OK and you are done with ABYSS web server installation.

6. Click YES to start the webserver.

7. If you are installing it on a WinXP Service Pack 2 machine, you will be prompted to BLOCK/UNBLOCK screen. Click on UNBLOCK

8. Click OK to proceed.

9. The access console access configuration will appear and choose English / Your desired language to proceed.

10. Put in your desired admin name and the password and click OK

11. Login with the admin username and password which you created on the previous step.

12. You will be redirect to the Abyss Web Server Console as shown below.

13. Click on the Configure to enter the settings page.

14. Click on Scripting Parameters.

15. Under the interpreters, click the Add button.

16. Click on the Browse button next to the interpreter box.

17. Browse to C:\PHP\php.exe which you setup earlier on previous steps.

18. Select Type PHP Style and click ADD under the Associated Extensions part.

19. Type in php and click OK

20. Click OK to finish the current page configuration.

21. Under Custom Environment Variables click Add

22. In the Name box, type in REDIRECT_STATUS and 200 in the value box. Click OK to complete.

23. Click OK to proceed.

24. Click Restart to restart the webserver. Your web server is ready now.

-=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.

2. Launch MySQL control panel and create a new database.

3. Create the database called cp and then double click to start it.

4. Right click on the cp database and select the New Window From Here.

5. Click on the SQL button or press CTRL+Q to go into Query Window.

6. Click on the OPEN button.

7. Point it to C:\Program Files\Abyss Web Server\htdocs\cp\install

8. Select the Athena & Freya folder.

9. Select the install.sql file.

10. Click on the Execute or Press CTRL+E to start compile.

11. Turn off the MYSQLCC and go back in. Then double click to start CP.

12. Right click on the cp database and select the New Window From Here.

13. Click on the SQL button or press CTRL+Q to go into Query Window.

14. Type in UPDATE mysql.user .......... as per shown in the picture and then click Execute.

15. Exit from MySQL Control Center and reload it again. Double click on the privilege section.

16. Right click on the empty area and select INSERT RECORD.

17. Key in 2000001 for the account id field and 4 for the priviledge.

18. Turn off the MySQLCC when done and relaunch it. Go to the User Administration and Add a New User.

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.

20. Tick ragnarok database also and All Privileges and With GRANT option and then click ADD.

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

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 ............

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)

Back To Main Page





-=NO-IP Setup Guide For Dynamic IP Hoster=-

1. go to

You must be registered to see links

directly.


2. Register yourself an A/C and then activate the account upon receiving the email.

3. Login to the page at

You must be registered to see links

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.

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)

6. After that, go and download the No-IP DUC Update Client For Windows.

7. Double click on the file that you have downloaded to begin installation.

8. Uncheck the View Readme and View Changes to bypass the readmes.

9. Click FINISH to complete the installation.

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.

11. Lastly check on the domain name which you have registered and the smilie icon will turn to laugh if successful.

 

[an2ny_18]

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..........

 

[SApIt0LoC0]

1- Freya Latest Compiled SVN [The SQL Type]
2- Abyss Web Server

Error Links!!

 

[herobladex]

nice guides, but the links don't work..... must've taken a while lol

 

[an2ny_18]

LOL all links are fine..

 

[kim04]

Having a problem

Ok i have a problem with that in my log in server here the pic



and my problem in my RoCP



for An2ny Pinoy TYO ipakita sa Mundo

 

[WaRiOz]

Does it work on version 10.0 part 1 Einbroch IRO Client?

 

[kim04]

Nahh..Noob Question yah it works all But using SQL is hard...:chair:

 

[Josh]

Dont use abyss - so old!
Use appserv/WAMP or whatever.

 

[kim04]

abbys is nice for noob..

 

[Snow0001]

abyss is nice even for older web admin

Anyway same error as Kim04. RoCP gives a weird mysql error.

 

[an2ny_18]

your problem is dont follow the guide for abbys web server. you need to add php dll's to accept the php file and to encode using abbys web server.

give me 1 week to finish the xampp and easyphp guide.

 

[an2ny_18]

New SVN Version release download now

You must be registered to see links

 

[siput]

ro have item mall??

 

[HabbXPrivate]

Very nice guide.

 

[F.O.X]

- 04-22-2007, 06:17 PM

Don't Bump a thread older then 2 month! I suggest you read the Rules first, Newbiass.
Thread Close!

-F.O.X