Jump to content

OnNplay

Members
  • Content Count

    49
  • Joined

  • Last visited

  • Days Won

    4

Reputation Activity

  1. Upvote
    OnNplay got a reaction from Quazi in [ tutorial ] Preparing database ragnarok for pre-compiled Hercules   
    Working around in MySQL console for database ragnarok.     This tutorial is mainly to support the release of pre-compiled Hercules for Win32 by me, OnNplay. Never-the-less it also closer to linux command line instead of using phpMyAdmin, HeidiSQL, Navicat, MySQL Workbench and other MySQL GUI client program. Hopefully, you will getting more confident to use PuTTY when you subscribe service such as VPS or dedicated server.     Lets do our first mysql database "ragnarok" and also our first mysql user "ragnarok". To state the command I used quote character "command here;". Please ignore it when you type or select and copy.     1. Download, install WAMP Server and start it. On desktop taskbar near the clock, click WAMPSERVER - server Online > MySQL > MySQL console .     2. Now active MySQL console window is open asking you to "Enter password:". By default WAMP Server logging into MySQL console as "root" and no password. So just press Enter. Now you in the MySQL service enviroment. You should see "Welcome" followed by some texts ending with line "mysql>".     3. You need to change your user "root" password. Type "use mysql;" and you should see "Database changed". Command "UPDATE user SET password=PASSWORD('newpassword') WHERE user='root';". Type "update user set password=password('w4mps3rv3r') where user='root';" and press Enter.
    The "newpassword" is at your own wish. After pressing Enter, you should see "Query OK," followed by some texts ending with line "mysql>".     4. For the change to take effect on MySQL service, you need to type "flush privileges;" and press Enter.     5. Now you should test the new root's password. Type "quit;" and press Enter. MySQL console window will close. Do step no.1. Enter your new root's password and press Enter. After the line of "mysql>" appear, MySQL service enviroment is ready to execute mysql's commands. When you type a wrong or incomplete command, console will response with "->".  What you need to do is just type ";" and press Enter.     6. Now you going to create a database to be used by Hercules emulator. By default Hercules will connecting to IP "127.0.0.1" port "3306" on database "ragnarok". Command "CREATE DATABASE database-name;". For deleting database, command "DROP DATABASE database-name;". Type "use mysql;" and press Enter.
    Next type "create database ragnarok;" and press Enter. Check the existence of your database, type "use mysql; show databases;" and press Enter.     7. Now you going to create one mysql user for Hercules to use. Do not let Hercules to use user "root". By default Hercules used mysql user "ragnarok" and it's password also "ragnarok". Command "CREATE USER 'user-name'@'host-name/IP' IDENTIFIED BY 'password';".For deleting user, command "DROP USER user-name;". Now type "create user 'ragnarok'@'localhost' identified by 'ragnarok';" and press Enter.
    Next you should do step no.4. To check the existence of user "ragnarok", type "use mysql; select user from mysql.user;" and press Enter.     8. You already create database "ragnarok" and user "ragnarok" in MySQL service. MySQL user can't simply access database without permission. Now you as a user "root" need to allow user "ragnarok" to access database "ragnarok". Command "GRANT ALL PRIVILEGES ON database-name.table-name TO 'user-name'@'host-name/IP';".For removing user to acces any database, command "REVOKE ALL PRIVILEGES ON *.* FROM 'user-name'@'host-name/IP';". Now type "grant all privileges on ragnarok.* to 'ragnarok'@'localhost';" and press Enter.
    Next you should do step no.4.     9. You should test the user "ragnarok". Type "quit;" and press Enter. MySQL console window will close. Now open folder where WAMP Server is installed and find where is file "mysql.exe" is located. During the making of this tutorial "mysql.exe" appear as "mysql" is located in "C:wampbinmysqlmysql5.6.12bin". Do not select any file inside the folder, if any one of the files is selected clear the select by clicking area after column "Size". Point arrow inside the folder, hold down the Shift key and at the same time do a right-click. Click "Open command window here". Type "mysql -uragnarok -p" and press Enter. You should see "Enter password:". Now type "ragnarok" and press Enter.     10. Here you going to prepare a text file for later use. Find and open folder "sql-files" which come with Hercules package. All the required files are with an extension ".sql" and can be read using Notepad++. Don't waste your time now to read it. Those files are containing default tables for database preparation. To get the full path of each file is by hold down the Shift key and do a right-click on the file, click "Copy as path". Next paste it in Notepad or Notepad++. Alternatively you also able to select all files and "Copy as path" too. The full path will come with quote character " " at beginning and ending. Delete it. Before file full path, add "source " with one space after it. Prepare file full path line by line so it easy for you to select and copy. Maybe you named the text file as "hercules-source-sql.txt".   Before "C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db2.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2_re.sql""C:UsersOnnplayDesktopHerculestrunksql-fileslogs.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmain.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db2.sql"  
    After source C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db2.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-fileslogs.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmain.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db2.sql  
    11. Now you going to fill up database "ragnarok" with default tables. Back to step no.9 and file "hercules-source-sql.txt" opened for select and copy. Type "use ragnarok;" and press Enter. You should see "Database changed". Next inside the console, copy and paste "source C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sql" and press Enter. You should see many "Query OK," running till "mysql>" appear again. Repeat with other full path of your sql files. After filling up database "ragnarok", you may check how many tables are created. Type "show tables;" and press Enter. Total row is a total table in database. During the making of this tutorial, Hercules is at Revision 12214 supplied with 12 sql files producing total of 52 tables.     12. If you follow correctly this tutorial, Hercules emulator can run smoothly by now. Type "quit;"  and press Enter to close the MySQL console.
  2. Upvote
    OnNplay got a reaction from Avian in [ tutorial ] Preparing database ragnarok for pre-compiled Hercules   
    Working around in MySQL console for database ragnarok.     This tutorial is mainly to support the release of pre-compiled Hercules for Win32 by me, OnNplay. Never-the-less it also closer to linux command line instead of using phpMyAdmin, HeidiSQL, Navicat, MySQL Workbench and other MySQL GUI client program. Hopefully, you will getting more confident to use PuTTY when you subscribe service such as VPS or dedicated server.     Lets do our first mysql database "ragnarok" and also our first mysql user "ragnarok". To state the command I used quote character "command here;". Please ignore it when you type or select and copy.     1. Download, install WAMP Server and start it. On desktop taskbar near the clock, click WAMPSERVER - server Online > MySQL > MySQL console .     2. Now active MySQL console window is open asking you to "Enter password:". By default WAMP Server logging into MySQL console as "root" and no password. So just press Enter. Now you in the MySQL service enviroment. You should see "Welcome" followed by some texts ending with line "mysql>".     3. You need to change your user "root" password. Type "use mysql;" and you should see "Database changed". Command "UPDATE user SET password=PASSWORD('newpassword') WHERE user='root';". Type "update user set password=password('w4mps3rv3r') where user='root';" and press Enter.
    The "newpassword" is at your own wish. After pressing Enter, you should see "Query OK," followed by some texts ending with line "mysql>".     4. For the change to take effect on MySQL service, you need to type "flush privileges;" and press Enter.     5. Now you should test the new root's password. Type "quit;" and press Enter. MySQL console window will close. Do step no.1. Enter your new root's password and press Enter. After the line of "mysql>" appear, MySQL service enviroment is ready to execute mysql's commands. When you type a wrong or incomplete command, console will response with "->".  What you need to do is just type ";" and press Enter.     6. Now you going to create a database to be used by Hercules emulator. By default Hercules will connecting to IP "127.0.0.1" port "3306" on database "ragnarok". Command "CREATE DATABASE database-name;". For deleting database, command "DROP DATABASE database-name;". Type "use mysql;" and press Enter.
    Next type "create database ragnarok;" and press Enter. Check the existence of your database, type "use mysql; show databases;" and press Enter.     7. Now you going to create one mysql user for Hercules to use. Do not let Hercules to use user "root". By default Hercules used mysql user "ragnarok" and it's password also "ragnarok". Command "CREATE USER 'user-name'@'host-name/IP' IDENTIFIED BY 'password';".For deleting user, command "DROP USER user-name;". Now type "create user 'ragnarok'@'localhost' identified by 'ragnarok';" and press Enter.
    Next you should do step no.4. To check the existence of user "ragnarok", type "use mysql; select user from mysql.user;" and press Enter.     8. You already create database "ragnarok" and user "ragnarok" in MySQL service. MySQL user can't simply access database without permission. Now you as a user "root" need to allow user "ragnarok" to access database "ragnarok". Command "GRANT ALL PRIVILEGES ON database-name.table-name TO 'user-name'@'host-name/IP';".For removing user to acces any database, command "REVOKE ALL PRIVILEGES ON *.* FROM 'user-name'@'host-name/IP';". Now type "grant all privileges on ragnarok.* to 'ragnarok'@'localhost';" and press Enter.
    Next you should do step no.4.     9. You should test the user "ragnarok". Type "quit;" and press Enter. MySQL console window will close. Now open folder where WAMP Server is installed and find where is file "mysql.exe" is located. During the making of this tutorial "mysql.exe" appear as "mysql" is located in "C:wampbinmysqlmysql5.6.12bin". Do not select any file inside the folder, if any one of the files is selected clear the select by clicking area after column "Size". Point arrow inside the folder, hold down the Shift key and at the same time do a right-click. Click "Open command window here". Type "mysql -uragnarok -p" and press Enter. You should see "Enter password:". Now type "ragnarok" and press Enter.     10. Here you going to prepare a text file for later use. Find and open folder "sql-files" which come with Hercules package. All the required files are with an extension ".sql" and can be read using Notepad++. Don't waste your time now to read it. Those files are containing default tables for database preparation. To get the full path of each file is by hold down the Shift key and do a right-click on the file, click "Copy as path". Next paste it in Notepad or Notepad++. Alternatively you also able to select all files and "Copy as path" too. The full path will come with quote character " " at beginning and ending. Delete it. Before file full path, add "source " with one space after it. Prepare file full path line by line so it easy for you to select and copy. Maybe you named the text file as "hercules-source-sql.txt".   Before "C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db2.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2_re.sql""C:UsersOnnplayDesktopHerculestrunksql-fileslogs.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmain.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db2.sql"  
    After source C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db2.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-fileslogs.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmain.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db2.sql  
    11. Now you going to fill up database "ragnarok" with default tables. Back to step no.9 and file "hercules-source-sql.txt" opened for select and copy. Type "use ragnarok;" and press Enter. You should see "Database changed". Next inside the console, copy and paste "source C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sql" and press Enter. You should see many "Query OK," running till "mysql>" appear again. Repeat with other full path of your sql files. After filling up database "ragnarok", you may check how many tables are created. Type "show tables;" and press Enter. Total row is a total table in database. During the making of this tutorial, Hercules is at Revision 12214 supplied with 12 sql files producing total of 52 tables.     12. If you follow correctly this tutorial, Hercules emulator can run smoothly by now. Type "quit;"  and press Enter to close the MySQL console.
  3. Upvote
    OnNplay got a reaction from Ragno in [ tutorial ] Preparing database ragnarok for pre-compiled Hercules   
    Working around in MySQL console for database ragnarok.     This tutorial is mainly to support the release of pre-compiled Hercules for Win32 by me, OnNplay. Never-the-less it also closer to linux command line instead of using phpMyAdmin, HeidiSQL, Navicat, MySQL Workbench and other MySQL GUI client program. Hopefully, you will getting more confident to use PuTTY when you subscribe service such as VPS or dedicated server.     Lets do our first mysql database "ragnarok" and also our first mysql user "ragnarok". To state the command I used quote character "command here;". Please ignore it when you type or select and copy.     1. Download, install WAMP Server and start it. On desktop taskbar near the clock, click WAMPSERVER - server Online > MySQL > MySQL console .     2. Now active MySQL console window is open asking you to "Enter password:". By default WAMP Server logging into MySQL console as "root" and no password. So just press Enter. Now you in the MySQL service enviroment. You should see "Welcome" followed by some texts ending with line "mysql>".     3. You need to change your user "root" password. Type "use mysql;" and you should see "Database changed". Command "UPDATE user SET password=PASSWORD('newpassword') WHERE user='root';". Type "update user set password=password('w4mps3rv3r') where user='root';" and press Enter.
    The "newpassword" is at your own wish. After pressing Enter, you should see "Query OK," followed by some texts ending with line "mysql>".     4. For the change to take effect on MySQL service, you need to type "flush privileges;" and press Enter.     5. Now you should test the new root's password. Type "quit;" and press Enter. MySQL console window will close. Do step no.1. Enter your new root's password and press Enter. After the line of "mysql>" appear, MySQL service enviroment is ready to execute mysql's commands. When you type a wrong or incomplete command, console will response with "->".  What you need to do is just type ";" and press Enter.     6. Now you going to create a database to be used by Hercules emulator. By default Hercules will connecting to IP "127.0.0.1" port "3306" on database "ragnarok". Command "CREATE DATABASE database-name;". For deleting database, command "DROP DATABASE database-name;". Type "use mysql;" and press Enter.
    Next type "create database ragnarok;" and press Enter. Check the existence of your database, type "use mysql; show databases;" and press Enter.     7. Now you going to create one mysql user for Hercules to use. Do not let Hercules to use user "root". By default Hercules used mysql user "ragnarok" and it's password also "ragnarok". Command "CREATE USER 'user-name'@'host-name/IP' IDENTIFIED BY 'password';".For deleting user, command "DROP USER user-name;". Now type "create user 'ragnarok'@'localhost' identified by 'ragnarok';" and press Enter.
    Next you should do step no.4. To check the existence of user "ragnarok", type "use mysql; select user from mysql.user;" and press Enter.     8. You already create database "ragnarok" and user "ragnarok" in MySQL service. MySQL user can't simply access database without permission. Now you as a user "root" need to allow user "ragnarok" to access database "ragnarok". Command "GRANT ALL PRIVILEGES ON database-name.table-name TO 'user-name'@'host-name/IP';".For removing user to acces any database, command "REVOKE ALL PRIVILEGES ON *.* FROM 'user-name'@'host-name/IP';". Now type "grant all privileges on ragnarok.* to 'ragnarok'@'localhost';" and press Enter.
    Next you should do step no.4.     9. You should test the user "ragnarok". Type "quit;" and press Enter. MySQL console window will close. Now open folder where WAMP Server is installed and find where is file "mysql.exe" is located. During the making of this tutorial "mysql.exe" appear as "mysql" is located in "C:wampbinmysqlmysql5.6.12bin". Do not select any file inside the folder, if any one of the files is selected clear the select by clicking area after column "Size". Point arrow inside the folder, hold down the Shift key and at the same time do a right-click. Click "Open command window here". Type "mysql -uragnarok -p" and press Enter. You should see "Enter password:". Now type "ragnarok" and press Enter.     10. Here you going to prepare a text file for later use. Find and open folder "sql-files" which come with Hercules package. All the required files are with an extension ".sql" and can be read using Notepad++. Don't waste your time now to read it. Those files are containing default tables for database preparation. To get the full path of each file is by hold down the Shift key and do a right-click on the file, click "Copy as path". Next paste it in Notepad or Notepad++. Alternatively you also able to select all files and "Copy as path" too. The full path will come with quote character " " at beginning and ending. Delete it. Before file full path, add "source " with one space after it. Prepare file full path line by line so it easy for you to select and copy. Maybe you named the text file as "hercules-source-sql.txt".   Before "C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db2.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2_re.sql""C:UsersOnnplayDesktopHerculestrunksql-fileslogs.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmain.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db2.sql"  
    After source C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db2.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-fileslogs.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmain.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db2.sql  
    11. Now you going to fill up database "ragnarok" with default tables. Back to step no.9 and file "hercules-source-sql.txt" opened for select and copy. Type "use ragnarok;" and press Enter. You should see "Database changed". Next inside the console, copy and paste "source C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sql" and press Enter. You should see many "Query OK," running till "mysql>" appear again. Repeat with other full path of your sql files. After filling up database "ragnarok", you may check how many tables are created. Type "show tables;" and press Enter. Total row is a total table in database. During the making of this tutorial, Hercules is at Revision 12214 supplied with 12 sql files producing total of 52 tables.     12. If you follow correctly this tutorial, Hercules emulator can run smoothly by now. Type "quit;"  and press Enter to close the MySQL console.
  4. Upvote
    OnNplay got a reaction from darkxxcrow in RO Client Package for Private Server   
    File Name: RO Client Package for Private Server
    File Submitter: OnNplay
    File Submitted: 16 Jul 2013
    File Category: Client Resources
     
    Basically this package allow you to start build up your 1st client.
    Many of us call this "data" folder.
    Data folder is what you looking for before making your server grf.
    File is packed using 7zip (Ultra) for just 40.3MB. (normal size = 328MB)
    Folder "Tools" in this package is not part of "data" folder.
     
    Source
    Client Side Translation Project
    Texture Translation Project
     
    Click here to download this file
  5. Upvote
    OnNplay got a reaction from Uzieal in [ tutorial ] Preparing database ragnarok for pre-compiled Hercules   
    Working around in MySQL console for database ragnarok.     This tutorial is mainly to support the release of pre-compiled Hercules for Win32 by me, OnNplay. Never-the-less it also closer to linux command line instead of using phpMyAdmin, HeidiSQL, Navicat, MySQL Workbench and other MySQL GUI client program. Hopefully, you will getting more confident to use PuTTY when you subscribe service such as VPS or dedicated server.     Lets do our first mysql database "ragnarok" and also our first mysql user "ragnarok". To state the command I used quote character "command here;". Please ignore it when you type or select and copy.     1. Download, install WAMP Server and start it. On desktop taskbar near the clock, click WAMPSERVER - server Online > MySQL > MySQL console .     2. Now active MySQL console window is open asking you to "Enter password:". By default WAMP Server logging into MySQL console as "root" and no password. So just press Enter. Now you in the MySQL service enviroment. You should see "Welcome" followed by some texts ending with line "mysql>".     3. You need to change your user "root" password. Type "use mysql;" and you should see "Database changed". Command "UPDATE user SET password=PASSWORD('newpassword') WHERE user='root';". Type "update user set password=password('w4mps3rv3r') where user='root';" and press Enter.
    The "newpassword" is at your own wish. After pressing Enter, you should see "Query OK," followed by some texts ending with line "mysql>".     4. For the change to take effect on MySQL service, you need to type "flush privileges;" and press Enter.     5. Now you should test the new root's password. Type "quit;" and press Enter. MySQL console window will close. Do step no.1. Enter your new root's password and press Enter. After the line of "mysql>" appear, MySQL service enviroment is ready to execute mysql's commands. When you type a wrong or incomplete command, console will response with "->".  What you need to do is just type ";" and press Enter.     6. Now you going to create a database to be used by Hercules emulator. By default Hercules will connecting to IP "127.0.0.1" port "3306" on database "ragnarok". Command "CREATE DATABASE database-name;". For deleting database, command "DROP DATABASE database-name;". Type "use mysql;" and press Enter.
    Next type "create database ragnarok;" and press Enter. Check the existence of your database, type "use mysql; show databases;" and press Enter.     7. Now you going to create one mysql user for Hercules to use. Do not let Hercules to use user "root". By default Hercules used mysql user "ragnarok" and it's password also "ragnarok". Command "CREATE USER 'user-name'@'host-name/IP' IDENTIFIED BY 'password';".For deleting user, command "DROP USER user-name;". Now type "create user 'ragnarok'@'localhost' identified by 'ragnarok';" and press Enter.
    Next you should do step no.4. To check the existence of user "ragnarok", type "use mysql; select user from mysql.user;" and press Enter.     8. You already create database "ragnarok" and user "ragnarok" in MySQL service. MySQL user can't simply access database without permission. Now you as a user "root" need to allow user "ragnarok" to access database "ragnarok". Command "GRANT ALL PRIVILEGES ON database-name.table-name TO 'user-name'@'host-name/IP';".For removing user to acces any database, command "REVOKE ALL PRIVILEGES ON *.* FROM 'user-name'@'host-name/IP';". Now type "grant all privileges on ragnarok.* to 'ragnarok'@'localhost';" and press Enter.
    Next you should do step no.4.     9. You should test the user "ragnarok". Type "quit;" and press Enter. MySQL console window will close. Now open folder where WAMP Server is installed and find where is file "mysql.exe" is located. During the making of this tutorial "mysql.exe" appear as "mysql" is located in "C:wampbinmysqlmysql5.6.12bin". Do not select any file inside the folder, if any one of the files is selected clear the select by clicking area after column "Size". Point arrow inside the folder, hold down the Shift key and at the same time do a right-click. Click "Open command window here". Type "mysql -uragnarok -p" and press Enter. You should see "Enter password:". Now type "ragnarok" and press Enter.     10. Here you going to prepare a text file for later use. Find and open folder "sql-files" which come with Hercules package. All the required files are with an extension ".sql" and can be read using Notepad++. Don't waste your time now to read it. Those files are containing default tables for database preparation. To get the full path of each file is by hold down the Shift key and do a right-click on the file, click "Copy as path". Next paste it in Notepad or Notepad++. Alternatively you also able to select all files and "Copy as path" too. The full path will come with quote character " " at beginning and ending. Delete it. Before file full path, add "source " with one space after it. Prepare file full path line by line so it easy for you to select and copy. Maybe you named the text file as "hercules-source-sql.txt".   Before "C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db2.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2_re.sql""C:UsersOnnplayDesktopHerculestrunksql-fileslogs.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmain.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db2.sql"  
    After source C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db2.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-fileslogs.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmain.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db2.sql  
    11. Now you going to fill up database "ragnarok" with default tables. Back to step no.9 and file "hercules-source-sql.txt" opened for select and copy. Type "use ragnarok;" and press Enter. You should see "Database changed". Next inside the console, copy and paste "source C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sql" and press Enter. You should see many "Query OK," running till "mysql>" appear again. Repeat with other full path of your sql files. After filling up database "ragnarok", you may check how many tables are created. Type "show tables;" and press Enter. Total row is a total table in database. During the making of this tutorial, Hercules is at Revision 12214 supplied with 12 sql files producing total of 52 tables.     12. If you follow correctly this tutorial, Hercules emulator can run smoothly by now. Type "quit;"  and press Enter to close the MySQL console.
  6. Upvote
    OnNplay got a reaction from Omniface in [ tutorial ] Preparing database ragnarok for pre-compiled Hercules   
    Working around in MySQL console for database ragnarok.     This tutorial is mainly to support the release of pre-compiled Hercules for Win32 by me, OnNplay. Never-the-less it also closer to linux command line instead of using phpMyAdmin, HeidiSQL, Navicat, MySQL Workbench and other MySQL GUI client program. Hopefully, you will getting more confident to use PuTTY when you subscribe service such as VPS or dedicated server.     Lets do our first mysql database "ragnarok" and also our first mysql user "ragnarok". To state the command I used quote character "command here;". Please ignore it when you type or select and copy.     1. Download, install WAMP Server and start it. On desktop taskbar near the clock, click WAMPSERVER - server Online > MySQL > MySQL console .     2. Now active MySQL console window is open asking you to "Enter password:". By default WAMP Server logging into MySQL console as "root" and no password. So just press Enter. Now you in the MySQL service enviroment. You should see "Welcome" followed by some texts ending with line "mysql>".     3. You need to change your user "root" password. Type "use mysql;" and you should see "Database changed". Command "UPDATE user SET password=PASSWORD('newpassword') WHERE user='root';". Type "update user set password=password('w4mps3rv3r') where user='root';" and press Enter.
    The "newpassword" is at your own wish. After pressing Enter, you should see "Query OK," followed by some texts ending with line "mysql>".     4. For the change to take effect on MySQL service, you need to type "flush privileges;" and press Enter.     5. Now you should test the new root's password. Type "quit;" and press Enter. MySQL console window will close. Do step no.1. Enter your new root's password and press Enter. After the line of "mysql>" appear, MySQL service enviroment is ready to execute mysql's commands. When you type a wrong or incomplete command, console will response with "->".  What you need to do is just type ";" and press Enter.     6. Now you going to create a database to be used by Hercules emulator. By default Hercules will connecting to IP "127.0.0.1" port "3306" on database "ragnarok". Command "CREATE DATABASE database-name;". For deleting database, command "DROP DATABASE database-name;". Type "use mysql;" and press Enter.
    Next type "create database ragnarok;" and press Enter. Check the existence of your database, type "use mysql; show databases;" and press Enter.     7. Now you going to create one mysql user for Hercules to use. Do not let Hercules to use user "root". By default Hercules used mysql user "ragnarok" and it's password also "ragnarok". Command "CREATE USER 'user-name'@'host-name/IP' IDENTIFIED BY 'password';".For deleting user, command "DROP USER user-name;". Now type "create user 'ragnarok'@'localhost' identified by 'ragnarok';" and press Enter.
    Next you should do step no.4. To check the existence of user "ragnarok", type "use mysql; select user from mysql.user;" and press Enter.     8. You already create database "ragnarok" and user "ragnarok" in MySQL service. MySQL user can't simply access database without permission. Now you as a user "root" need to allow user "ragnarok" to access database "ragnarok". Command "GRANT ALL PRIVILEGES ON database-name.table-name TO 'user-name'@'host-name/IP';".For removing user to acces any database, command "REVOKE ALL PRIVILEGES ON *.* FROM 'user-name'@'host-name/IP';". Now type "grant all privileges on ragnarok.* to 'ragnarok'@'localhost';" and press Enter.
    Next you should do step no.4.     9. You should test the user "ragnarok". Type "quit;" and press Enter. MySQL console window will close. Now open folder where WAMP Server is installed and find where is file "mysql.exe" is located. During the making of this tutorial "mysql.exe" appear as "mysql" is located in "C:wampbinmysqlmysql5.6.12bin". Do not select any file inside the folder, if any one of the files is selected clear the select by clicking area after column "Size". Point arrow inside the folder, hold down the Shift key and at the same time do a right-click. Click "Open command window here". Type "mysql -uragnarok -p" and press Enter. You should see "Enter password:". Now type "ragnarok" and press Enter.     10. Here you going to prepare a text file for later use. Find and open folder "sql-files" which come with Hercules package. All the required files are with an extension ".sql" and can be read using Notepad++. Don't waste your time now to read it. Those files are containing default tables for database preparation. To get the full path of each file is by hold down the Shift key and do a right-click on the file, click "Copy as path". Next paste it in Notepad or Notepad++. Alternatively you also able to select all files and "Copy as path" too. The full path will come with quote character " " at beginning and ending. Delete it. Before file full path, add "source " with one space after it. Prepare file full path line by line so it easy for you to select and copy. Maybe you named the text file as "hercules-source-sql.txt".   Before "C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db2.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2_re.sql""C:UsersOnnplayDesktopHerculestrunksql-fileslogs.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmain.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db2.sql"  
    After source C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db2.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-fileslogs.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmain.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db2.sql  
    11. Now you going to fill up database "ragnarok" with default tables. Back to step no.9 and file "hercules-source-sql.txt" opened for select and copy. Type "use ragnarok;" and press Enter. You should see "Database changed". Next inside the console, copy and paste "source C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sql" and press Enter. You should see many "Query OK," running till "mysql>" appear again. Repeat with other full path of your sql files. After filling up database "ragnarok", you may check how many tables are created. Type "show tables;" and press Enter. Total row is a total table in database. During the making of this tutorial, Hercules is at Revision 12214 supplied with 12 sql files producing total of 52 tables.     12. If you follow correctly this tutorial, Hercules emulator can run smoothly by now. Type "quit;"  and press Enter to close the MySQL console.
  7. Upvote
    OnNplay got a reaction from Slowpoker in Hercules Win32 for Ragexe 20130703   
    1. This pre-compiled release is only modification on file src/common/mmo.h
    #ifndef PACKETVER #define PACKETVER 20130703#endif// Comment the following line if your client is NOT ragexeRE (required because of conflicting packets in ragexe vs ragexeRE).//#define PACKETVER_RE 2. Packaging included all source code and compressed using 7zip at Ultra level. To avoid any decompressing error please use 7zip freeware.
    3. Label for each package is based on git commit date and time + date of Ragexe.exe.
    4. Revision no. that followed version no. is based on svn checkout https://github.com/HerculesWS/Hercules.git/ .
    5. Download Client Ragexe.exe 2013-07-03.
    6. Download Tool xDiff Patcher.
    7. Download Diff for Ragexe.exe 2013-07-03 v1.
    8. Download Client Package for Private Server v1 @r37.
    9. Download all-in-one web server WampServer. (guide preparing database)
    10. Read more here.
  8. Upvote
    OnNplay got a reaction from Slowpoker in Hercules Win32 for Ragexe 20130703   
    File Name: Hercules Win32 for Ragexe 20130703
    File Submitter: OnNplay
    File Submitted: 16 Jul 2013
    File Category: Pre-Compiled Server
     
    This is a ready to go Hercules for Windows 7 32 Bit and 64 Bit.
    Compiled using Visual Studio Ultimate 2012 in Windows 7 Ultimate 64 Bit.
    File is packed using 7zip (Ultra) for just 9.71MB. (normal size = 61.70MB)
     
    1. Ragexe source.
     
    2. Svn repository.
     
    3. Tutorial preparing database ragnarok.
     
    Click here to download this file
  9. Upvote
    OnNplay got a reaction from Lassander in StarGames Control Panel for Hercules 3rd Job   
    File Name: StarGames Control Panel for Hercules 3rd Job
    File Submitter: OnNplay
    File Submitted: 30 Jul 2013
    File Category: Web Resources
     
    StarGames Control Panel is a Control Panel used for Private Ragnarok Online Servers.
    It's integrated with it's very own Community Board System, Self Locking System, Server Status, and a Bug Report / Contact System.
     
    Before installing Stargames Control Panel on your webhost, you need to make sure your webhost provider offers you:
     
    * PHP 5.2
    * PDO and PDO-MYSQL extensions for PHP5 (including PHP_MYSQL support)
    * MySQL 5
    * GD2 (for guild emblems and registration CAPTCHA)
    * Tidy (for cleaner HTML output)
    * Optional: mod_rewrite support for UseCleanUrls feature
     
    You can view this demo by going to this link: http://sgcp.hostei.com/index.php?act=idx
     
    Click here to download this file
  10. Upvote
    OnNplay got a reaction from madtoyz in [ tutorial ] Preparing database ragnarok for pre-compiled Hercules   
    Working around in MySQL console for database ragnarok.     This tutorial is mainly to support the release of pre-compiled Hercules for Win32 by me, OnNplay. Never-the-less it also closer to linux command line instead of using phpMyAdmin, HeidiSQL, Navicat, MySQL Workbench and other MySQL GUI client program. Hopefully, you will getting more confident to use PuTTY when you subscribe service such as VPS or dedicated server.     Lets do our first mysql database "ragnarok" and also our first mysql user "ragnarok". To state the command I used quote character "command here;". Please ignore it when you type or select and copy.     1. Download, install WAMP Server and start it. On desktop taskbar near the clock, click WAMPSERVER - server Online > MySQL > MySQL console .     2. Now active MySQL console window is open asking you to "Enter password:". By default WAMP Server logging into MySQL console as "root" and no password. So just press Enter. Now you in the MySQL service enviroment. You should see "Welcome" followed by some texts ending with line "mysql>".     3. You need to change your user "root" password. Type "use mysql;" and you should see "Database changed". Command "UPDATE user SET password=PASSWORD('newpassword') WHERE user='root';". Type "update user set password=password('w4mps3rv3r') where user='root';" and press Enter.
    The "newpassword" is at your own wish. After pressing Enter, you should see "Query OK," followed by some texts ending with line "mysql>".     4. For the change to take effect on MySQL service, you need to type "flush privileges;" and press Enter.     5. Now you should test the new root's password. Type "quit;" and press Enter. MySQL console window will close. Do step no.1. Enter your new root's password and press Enter. After the line of "mysql>" appear, MySQL service enviroment is ready to execute mysql's commands. When you type a wrong or incomplete command, console will response with "->".  What you need to do is just type ";" and press Enter.     6. Now you going to create a database to be used by Hercules emulator. By default Hercules will connecting to IP "127.0.0.1" port "3306" on database "ragnarok". Command "CREATE DATABASE database-name;". For deleting database, command "DROP DATABASE database-name;". Type "use mysql;" and press Enter.
    Next type "create database ragnarok;" and press Enter. Check the existence of your database, type "use mysql; show databases;" and press Enter.     7. Now you going to create one mysql user for Hercules to use. Do not let Hercules to use user "root". By default Hercules used mysql user "ragnarok" and it's password also "ragnarok". Command "CREATE USER 'user-name'@'host-name/IP' IDENTIFIED BY 'password';".For deleting user, command "DROP USER user-name;". Now type "create user 'ragnarok'@'localhost' identified by 'ragnarok';" and press Enter.
    Next you should do step no.4. To check the existence of user "ragnarok", type "use mysql; select user from mysql.user;" and press Enter.     8. You already create database "ragnarok" and user "ragnarok" in MySQL service. MySQL user can't simply access database without permission. Now you as a user "root" need to allow user "ragnarok" to access database "ragnarok". Command "GRANT ALL PRIVILEGES ON database-name.table-name TO 'user-name'@'host-name/IP';".For removing user to acces any database, command "REVOKE ALL PRIVILEGES ON *.* FROM 'user-name'@'host-name/IP';". Now type "grant all privileges on ragnarok.* to 'ragnarok'@'localhost';" and press Enter.
    Next you should do step no.4.     9. You should test the user "ragnarok". Type "quit;" and press Enter. MySQL console window will close. Now open folder where WAMP Server is installed and find where is file "mysql.exe" is located. During the making of this tutorial "mysql.exe" appear as "mysql" is located in "C:wampbinmysqlmysql5.6.12bin". Do not select any file inside the folder, if any one of the files is selected clear the select by clicking area after column "Size". Point arrow inside the folder, hold down the Shift key and at the same time do a right-click. Click "Open command window here". Type "mysql -uragnarok -p" and press Enter. You should see "Enter password:". Now type "ragnarok" and press Enter.     10. Here you going to prepare a text file for later use. Find and open folder "sql-files" which come with Hercules package. All the required files are with an extension ".sql" and can be read using Notepad++. Don't waste your time now to read it. Those files are containing default tables for database preparation. To get the full path of each file is by hold down the Shift key and do a right-click on the file, click "Copy as path". Next paste it in Notepad or Notepad++. Alternatively you also able to select all files and "Copy as path" too. The full path will come with quote character " " at beginning and ending. Delete it. Before file full path, add "source " with one space after it. Prepare file full path line by line so it easy for you to select and copy. Maybe you named the text file as "hercules-source-sql.txt".   Before "C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db2.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2.sql""C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2_re.sql""C:UsersOnnplayDesktopHerculestrunksql-fileslogs.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmain.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db_re.sql""C:UsersOnnplayDesktopHerculestrunksql-filesmob_db2.sql"  
    After source C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_skill_db2.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesitem_db2_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-fileslogs.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmain.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db_re.sqlsource C:UsersOnnplayDesktopHerculestrunksql-filesmob_db2.sql  
    11. Now you going to fill up database "ragnarok" with default tables. Back to step no.9 and file "hercules-source-sql.txt" opened for select and copy. Type "use ragnarok;" and press Enter. You should see "Database changed". Next inside the console, copy and paste "source C:UsersOnnplayDesktopHerculestrunksql-filesitem_db.sql" and press Enter. You should see many "Query OK," running till "mysql>" appear again. Repeat with other full path of your sql files. After filling up database "ragnarok", you may check how many tables are created. Type "show tables;" and press Enter. Total row is a total table in database. During the making of this tutorial, Hercules is at Revision 12214 supplied with 12 sql files producing total of 52 tables.     12. If you follow correctly this tutorial, Hercules emulator can run smoothly by now. Type "quit;"  and press Enter to close the MySQL console.
  11. Upvote
    OnNplay got a reaction from JulioCF in StarGames Control Panel for Hercules 3rd Job   
    File Name: StarGames Control Panel for Hercules 3rd Job
    File Submitter: OnNplay
    File Submitted: 30 Jul 2013
    File Category: Web Resources
     
    StarGames Control Panel is a Control Panel used for Private Ragnarok Online Servers.
    It's integrated with it's very own Community Board System, Self Locking System, Server Status, and a Bug Report / Contact System.
     
    Before installing Stargames Control Panel on your webhost, you need to make sure your webhost provider offers you:
     
    * PHP 5.2
    * PDO and PDO-MYSQL extensions for PHP5 (including PHP_MYSQL support)
    * MySQL 5
    * GD2 (for guild emblems and registration CAPTCHA)
    * Tidy (for cleaner HTML output)
    * Optional: mod_rewrite support for UseCleanUrls feature
     
    You can view this demo by going to this link: http://sgcp.hostei.com/index.php?act=idx
     
    Click here to download this file
  12. Upvote
    OnNplay got a reaction from dhaisuke in StarGames Control Panel for Hercules 3rd Job   
    File Name: StarGames Control Panel for Hercules 3rd Job
    File Submitter: OnNplay
    File Submitted: 30 Jul 2013
    File Category: Web Resources
     
    StarGames Control Panel is a Control Panel used for Private Ragnarok Online Servers.
    It's integrated with it's very own Community Board System, Self Locking System, Server Status, and a Bug Report / Contact System.
     
    Before installing Stargames Control Panel on your webhost, you need to make sure your webhost provider offers you:
     
    * PHP 5.2
    * PDO and PDO-MYSQL extensions for PHP5 (including PHP_MYSQL support)
    * MySQL 5
    * GD2 (for guild emblems and registration CAPTCHA)
    * Tidy (for cleaner HTML output)
    * Optional: mod_rewrite support for UseCleanUrls feature
     
    You can view this demo by going to this link: http://sgcp.hostei.com/index.php?act=idx
     
    Click here to download this file
  13. Upvote
    OnNplay got a reaction from mkbu95 in This latest KRO updated 17July2013   
    This KRO is updated and packed up to 17th July 2013 by me.

    http://5.178.71.18/Ragnarok16072013.7z
    http://188.165.187.164/Ragnarok16072013.7z
    http://192.210.208.214/Ragnarok16072013.7z
    http://192.210.208.217/Ragnarok16072013.7z

    MD5: 5e716f849e938a8cc94b44c510b160dc
    Size: 2.11GB
    Password: not available
    MD5 Tool: http://keir.net/hash.html

     
  14. Upvote
    OnNplay got a reaction from mrlongshen in client crash on level 99   
    Yes that is true. Client failed to load aura.
  15. Upvote
    OnNplay got a reaction from Avian in This latest KRO updated 17July2013   
    This KRO is updated and packed up to 17th July 2013 by me.

    http://5.178.71.18/Ragnarok16072013.7z
    http://188.165.187.164/Ragnarok16072013.7z
    http://192.210.208.214/Ragnarok16072013.7z
    http://192.210.208.217/Ragnarok16072013.7z

    MD5: 5e716f849e938a8cc94b44c510b160dc
    Size: 2.11GB
    Password: not available
    MD5 Tool: http://keir.net/hash.html

     
  16. Upvote
    OnNplay got a reaction from insidemybrain in This latest KRO updated 17July2013   
    This KRO is updated and packed up to 17th July 2013 by me.

    http://5.178.71.18/Ragnarok16072013.7z
    http://188.165.187.164/Ragnarok16072013.7z
    http://192.210.208.214/Ragnarok16072013.7z
    http://192.210.208.217/Ragnarok16072013.7z

    MD5: 5e716f849e938a8cc94b44c510b160dc
    Size: 2.11GB
    Password: not available
    MD5 Tool: http://keir.net/hash.html

     
  17. Upvote
    OnNplay got a reaction from Igniz in This latest KRO updated 17July2013   
    This KRO is updated and packed up to 17th July 2013 by me.

    http://5.178.71.18/Ragnarok16072013.7z
    http://188.165.187.164/Ragnarok16072013.7z
    http://192.210.208.214/Ragnarok16072013.7z
    http://192.210.208.217/Ragnarok16072013.7z

    MD5: 5e716f849e938a8cc94b44c510b160dc
    Size: 2.11GB
    Password: not available
    MD5 Tool: http://keir.net/hash.html

     
  18. Upvote
    OnNplay got a reaction from madtoyz in RO Client Package for Private Server   
    I am collecting input or feed back from all.
    My first release v1 @r37 just a starting point for us to work with.
    Please keep in mind this data folder mainly to support clients in year 2013 and later.
     
    Some files are not there, for example clientinfo.xml , sclientinfo.xml .
    I will try to link from here additional info to minimize user from hunting the related materials.
  19. Upvote
    OnNplay got a reaction from akbare in Hercules Win32 for Ragexe 20130703   
    File Name: Hercules Win32 for Ragexe 20130703
    File Submitter: OnNplay
    File Submitted: 16 Jul 2013
    File Category: Pre-Compiled Server
     
    This is a ready to go Hercules for Windows 7 32 Bit and 64 Bit.
    Compiled using Visual Studio Ultimate 2012 in Windows 7 Ultimate 64 Bit.
    File is packed using 7zip (Ultra) for just 9.71MB. (normal size = 61.70MB)
     
    1. Ragexe source.
     
    2. Svn repository.
     
    3. Tutorial preparing database ragnarok.
     
    Click here to download this file
  20. Upvote
    OnNplay got a reaction from madtoyz in Hercules Win32 for Ragexe 20130618   
    File Name: Hercules Win32 for Ragexe 20130618
    File Submitter: OnNplay
    File Submitted: 08 Jul 2013
    File Category: Pre-Compiled Server
     
    This is a ready to go Hercules for Windows 7 32 Bit and 64 Bit.
    Compiled using Visual Studio Ultimate 2012 in Windows 7 Ultimate 64 Bit.
    File is packed using 7zip (Ultra) for just 8.31MB.
    (Thanks to Ind. to allow 7z)
     
    Ragexe source
    http://k3dt.eu/Ragexe/unpacked/
     
    Click here to download this file
  21. Upvote
    OnNplay got a reaction from madtoyz in Hercules Win32 for Ragexe 20130618   
    1. This pre-compiled release is only modification on file src/common/mmo.h
    #ifndef PACKETVER #define PACKETVER 20130618#endif// Comment the following line if your client is NOT ragexeRE (required because of conflicting packets in ragexe vs ragexeRE).//#define PACKETVER_RE  2. Packaging included all source code and compressed using 7zip at Ultra level. To avoid any decompressing error please use 7zip freeware.
    3. Label for each package is based on git commit date and time + date of Ragexe.exe.
    4. Revision no. that followed version no. is based on svn checkout https://github.com/HerculesWS/Hercules.git/ .
    5. Download Client Ragexe.exe 2013-06-18.
    6. Download Tool xDiff Patcher.
    7. Download Diff for Ragexe.exe 2013-06-18 v2.
    8. Download Client Package for Private Server v1 @r37.
    9. Download all-in-one web server WampServer. (guide preparing database)
    10. Read more here.
  22. Upvote
    OnNplay got a reaction from madtoyz in This latest KRO updated 17July2013   
    This KRO is updated and packed up to 17th July 2013 by me.

    http://5.178.71.18/Ragnarok16072013.7z
    http://188.165.187.164/Ragnarok16072013.7z
    http://192.210.208.214/Ragnarok16072013.7z
    http://192.210.208.217/Ragnarok16072013.7z

    MD5: 5e716f849e938a8cc94b44c510b160dc
    Size: 2.11GB
    Password: not available
    MD5 Tool: http://keir.net/hash.html

     
  23. Upvote
    OnNplay got a reaction from madtoyz in RO Client Package for Private Server   
    1. This "RO Client Package for Private Server" is a package that I stripped out from svn checkout  https://subversion.assembla.com/svn/client-side-translation/ .
    2. These 2 topics Client Side Translation Project and Texture Translation Project inspired me to compile a basic data folder for Hercules user.
    3. Mainly to support RO clients in year 2013.
    4. Get some missing file from Alexandria's data folder v4.0. ( I will fix it in next coming version.)
    5. To avoid any decompressing error please use 7zip freeware.
    6. Download KRO Client.
    7. Read more here.
  24. Upvote
    OnNplay got a reaction from madtoyz in RO Client Package for Private Server   
    File Name: RO Client Package for Private Server
    File Submitter: OnNplay
    File Submitted: 16 Jul 2013
    File Category: Client Resources
     
    Basically this package allow you to start build up your 1st client.
    Many of us call this "data" folder.
    Data folder is what you looking for before making your server grf.
    File is packed using 7zip (Ultra) for just 40.3MB. (normal size = 328MB)
    Folder "Tools" in this package is not part of "data" folder.
     
    Source
    Client Side Translation Project
    Texture Translation Project
     
    Click here to download this file
  25. Upvote
    OnNplay got a reaction from jTynne in [Atcommand]afk   
    This afk very popular since eathena. Why not just to have this command in Hercules directly, please any one of core developer interesting to explain why not?
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.