THIS IS THE CONCEPT HOW DOES RAGNAROK ONLINE RUNS USING MySQL
INDEX
Downloads:
1. Server Files
2. MySql Community Server
2.1 MySql GUI TOOLS
Guides:
I. – How to setup your Server Files
II. – MySql Setup
III. – Client Data Editing/Server Client Hexing
V. – Web CP
DOWNLOADS:
1. Server Files Revision – 14260 eAthena SVN Trunk Version Main
-Only works to RagexeRE 2010-02-17 client, or you can also edit mmo.h and compile it to your own.
2. MySql Community Server 5.1 – For windows XP and Vista or 32bit computer For Windows 7 or x64 bit computer
2.1 MySql GUI TOOLS 5.0 – CLICK ME HERE
-for those who can’t configure your own MySQL you need to recover your pc or “reformat” or the hardiest is to search on how to uninstall you previous MySQL(complete UNINSTALL,this is an issue about MySQL)
GUIDES:
I – How to setup your Server Files:
-Go to your Server Folder, Then Click “conf” Folder
-open the “char_athena.conf” using WORDPAD or NOTEPAD
-find userid: s1 – change “s1” into what you wan’t!(REMEMBER THIS ONE)
-find passwd: p1 – change “p1” into what you wan’t!(REMEMBER THIS ONE)
-find server_name: eAthena – change this to your own RO server Name
-find //login_ip: 127.0.0.1 – Delete the “//” a.k.a Double Slash, and change it to your LAN IP Address – go to your “START” and click CMD and write “ipconfig” without the ”
NEXT:
-open the “login_athena.conf” using WORDPAD or NOTEPAD
-find new_account: yes – if you want your server to use _M to create accounts, you can also change it to “no” if you wan’t your.
NEXT:
-open the “map_athena” using WORDPAD or NOTEPAD
-find userid: s1 – change “s1” into what you wan’t!(REMEMBER THIS ONE)
-find passwd: p1 – change “p1” into what you wan’t!(REMEMBER THIS ONE)
-find //char_ip: 127.0.0.1 – Delete the “//” a.k.a Double Slash, and change it to your LAN IP Address – go to your “START” and click CMD and write “ipconfig” without the ”
-find //map_ip: 127.0.0.1 – Delete the “//” a.k.a Double Slash, and change it to your WAN IP Address – go to! http://whatismyipaddress.com/
IF!!! your IP address is Dynamic! then go to http://www.no-ip.com and use there applications and instructions.
Example of Word WAN IP ADDRESS(or DNS in short term):
-pakman.no-ip.biz
-cpanel.servegame.com
-ragnarok.no-ip.biz
-ekotan.no-ip.org
etc…
___________
-Open motd.txt
EDIT:
// Internal default is limited to 128 lines. If you need more, you will need to modify the MOTD_LINE_SIZE definition in pc.c
Welcome to eAthena SVN Version! Enjoy! Please report any bugs you find. – DELETE ALL OF THIS AND CHANGE IT TO:
Welcome to “YourServerName” ENTER
“YOUR SERVER MESSAGE”
___________
-open subnet_athena.conf
-put like this —>
subnet: 255.0.0.0:127.0.0.1:127.0.0.1
subnet: 255.255.255.0:192.168.1.2:192.168.1.2
___________
-click the “grf-files.txt
grf: <data file path>
sample: grf: C:/Program Files/Gravity/Ragnarok Online/data.grf
—–> THIS IS 2nd Backup about MAPCACHE, some of other players editing some of our maps then they will make a “memo” with that map it’s world of stock, just like that guys
-find data_dir: “Then your Server data directory”
SERVER FILES EDITING, IS NOW DONE!!
II. – MySql Setup:
-Install the MySQL Gui
-Install the MySQL Community Server
:::::IF YOUR PC CAN’T INSTALL AND CONFIGURE YOUR SECURITY WINDOW, then YOU NEED TO RECOVER OR REFORMAT YOUR PC!:::::
Run Your MySql Query
Server Host:localhost
Username:root
Password: YOUR_PASSWORD
Default Schema: ragnarok
then click “OK” if not exist
————–
-then click the file > Open Script > “GO TO YOUR SERVER FILES FOLDER > click sql-files folder > click the “main.sql” file
-script 1 tab should POP-UP > then click the green button “EXECUTE” > scroll it down! > double click the “login”
-change the s1 to your PASSWORD from the previous that has (REMEMBER THIS ONE)
-change the p1 to your PASSWORD from the previous that has (REMEMBER THIS ONE)
– then click the “APPLY CHANGES” > then close “ALT+F4”
Open it again, The MySql Query
Server Host:localhost
Username:root
Password: YOUR_PASSWORD
Default Schema: log
then click “OK” if not exist
————–
-then click the file > Open Script > “GO TO YOUR SERVER FILES FOLDER > click sql-files folder > click the “log.sql” file
-script 1 tab should POP-UP > then click the green button “EXECUTE” > then close “ALT+F4”
PROTECT SECTION:
Run your MySql Administrator:
Server Host:localhost
Username:root
Password: YOUR_PASSWORD
then click “OK”
-CLICK THE “USER ADMINISTRATION”
-click “add new user” button
-MySql Username: ragnarok
-Password: PUT A PASSWORD(KEEP THIS)
-Confirm Password: PUT A PASSWORD(KEEP THIS)
-“ANY PASSWORD YOUR WANT TO PROTECT IT FROM HACKERS”
Then Click “Schema Privileges”
-click the “ragnarok” then click the button “<<“
-click the “log” then click the button “<<“
-click apply changes
Go to Your ServerFolder/Conf/inter_athena.conf
EDIT:
// Global SQL settings
// overriden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: ragnarok
sql.db_password: ragnarok – change this to your “PUT A PASSWORD(KEEP THIS)” –> go back find that word!
sql.db_database: ragnarok
sql.codepage:
// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: ragnarok
char_server_pw: ragnarok – change this to your “PUT A PASSWORD(KEEP THIS)” –> go back find that word!
char_server_db: ragnarok
// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: ragnarok
map_server_pw: ragnarok – change this to your “PUT A PASSWORD(KEEP THIS)” –> go back find that word!
map_server_db: ragnarok
// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok – change this to your “PUT A PASSWORD(KEEP THIS)” –> go back find that word!
log_db_db: log
log_codepage:
YOUR NOW DONE MYSQL!
III CLIENT DATA EDITING/Server Client Hexing:
-1st download the HEX EDITOR form http://www.download.com search “Hex Edit” use HxD editor(Simple and no bug encounter)
Small Instructions: Please if you wan’t to remove a HEX value, don not use your BACK SPACE, instead use the HEX windows and make it “00” to make it no value
STEPS:
-install and open it
-click “FILE(TAB)” select “OPEN” open your client.exe
-NOW WE NEED TO EDIT THE (DATA.INI and Your Server Name)
-so use CTRL+F(to open the FIND window)
-your now in the window of “FIND”
-so go to dropdown menu on it then click “Datatype” scroll it down, then choose String
-before that, backup 1st to your client!
-then go search for: 2010-02-17RagexeRe(It depends on what client you used) change it to “YourRO” (DON’T USE BACKSPACE TO REMOVE!)
-then search the: “Data.ini” change it to DATA.SRO or DATA.ROO whatever!(DON’T USE BACKSPACE TO REMOVE!)
-then close it
-go to your ragnarok folder, then make a txt file, then put these
CODE
[Data]
1=yourro.grf
2=rdata.grf
3=data.grf
then “SAVE AS” put “all type” then rename it into DATA.SRO or DATA.RRO whatever word that you put to your client!
then thats all!
IV Web Cp Using CeresCP:
-1st your need is to download this files!
—Ceres CP
—FileZilla FTP transferer
–SIGNUP to any Free Websites that supports PHP and MySQL
-then login, make a website, login to your website using there control panel
-then install your FileZilla.exe
-then you need to know what is your FTP accounts by searching it to your account info TO YOUR WEBHOSTER
-then open your FileZilla then put your HOST: mine is “ragnarokph.uuuq.com” that was my FTP host then put your USERNAME: mine is “ragnarokph” THEN YOUR PASSWORD: mine is “********” LOL
-then using your KEYBOARD PRESS “ENTER”
-you’ll need to go to your WEBSITE folders, how fast right????
-so create a folder there then nameit “cp” or whatever
-then put all your CERES CP files
-then go to your WEBSITE NOW, ofcourse by using FIREFOX OR any Website Browser
-then you can now install your website
IMAGE OF MY FILEZILLA FTP:
-yellow circle = my WEBSITE FILES
-brown circle = the FTP accounts
Reduced: 90% of original size [ 800 x 450 ] – Click to view full image
THIS IS NOW MY COMPLETE GUIDE!, HOPE YOU LIKE IT GUYS!
Credits : eAthena