[GUIDE] OsIROSE Setup guide (Last Edited September 13, 2010)

[merlon]

Ok, so i was using psycoshooter's old guide from like 2007, and many of the links and stuff are outdated, so I am making a guide for all of you.

Sections (Just use ctrl+F to jump to the difrent sections)
SETUPING OSIROSE FILES AND MYSQL
Setting Up Navicat
Installing the Database
Client Downloads
Settuing Up a Simple Launcher
Usefull Guides
CREDITS
EDITS



SETUPING OSIROSE FILES AND MYSQL

ok heres what we do,

First you need to download the file trough the OsIrose SVN: https://osirose.googlecode.com/svn/trunk/

You can download this with TortoiseSVN which can be found here :

32bit :
http://downloads.sourceforge.net/tortoi ... i?download

64bit : http://downloads.sourceforge.net/tortoi ... i?download

Download source code:
Create a folder somewhere, right click on it and choose "SVN checkout".
In the dialog box that says "URL of repository", Enter the URL address of the SVN : https://osirose.googlecode.com/svn/trunk
And the directory should be there ,if not then click the "..." button to browse.
Ok you may need to wait a while for it to load everything up....

Once its finished, go into your folder that you put in the SVN directory, click on the osirose folder:

Then click on the Binary Folder:

Once you get into that you should see this:

double click on the .conf files and open them with notepad.

Now download MySQL and Navicat

64bit MySQL: http://dev.mysql.com/downloads/mirror.php?id=392017
32bit MySQL: http://dev.mysql.com/downloads/mirror.php?id=392016

Navicat Lite (free) : http://download.cnet.com/Navicat-Lite-M ... 70715.html

Now you have that out of the way continue on with your configs putting in the info that you put in set them up with your MySQL data that you put in during installation.
And edit your ip's if you want to let other people come on.

How to get your local IP (LAN IP) :
You have to get your local IP so launch "Command prompt" (Start->Programs->Accessories->Command Prompt).
Once it's launched, type "ipconfig" and enter, you'll have the local IP (LAN IP), the mask and the gateway. (not really
useful)

How to get the LANsubnetmask:
[quote=lmame]The lansubmask is the first three numbers of lanip=192.168.0.103, it's the "generic" part of your local IP.
It allows you playing from your local network as well as outside of it (see this thread).[/quote]

How to get your internet IP ( Server IP):
Simply launch the website http://www.whatisyourip.com and you'll have it.
It'll be at the top ,underlined, and blue letters.


This is what you Loginserver.conf should look like :

Line number On/Off | Expand/Contract | Select all

1.  
2. [DATABASE]
3. mysql_host=(your Mysql host)
4. mysql_user= (your Mysql user)
5. mysql_pass=(your Mysql Password)
6. mysql_database=irose
7. mysql_port=3306
8.  
9. [SERVERDATA]
10. serverid=1
11. servertype=0
12. serverip=127.0.0.1 (replace this with your internet IP: whatimyip.com )
13. serverport=29000
14. servername=(your server name)
15. connection=2
16. lanip=127.0.0.1 (replace this with your LAN ip)
17. lansubmask=127.0.0.1 (replace this with your Lansubnet mask)
18.  
19. [LOGINSERVER]
20. accesslevel=100
21. CreateLoginAccount=1
22. usethreads=0
23.  
24. [PASSWORDS]
25. loginpass=789456
26. charpass=456123
27. worldpass=321654
28.  

And the charserver.conf

Line number On/Off | Expand/Contract | Select all

1.  
2. [DATABASE]
3. mysql_host=(your Mysql host)
4. mysql_user=(your Mysql user)
5. mysql_pass=(your Mysql password)
6. mysql_database=irose
7. mysql_port=3306
8. AutoQueryTime=600
9.  
10. [SERVERDATA]
11. serverid=2
12. servertype=1
13. serverip=127.0.0.1 (replace this with your internet IP: http://whatimyip.com )
14. serverport=29100
15. servername=Channel1
16. parentid=0
17. accesslevel=100
18. connection=2
19. lanip=127.0.0.1 (replace this with your LAN ip)
20. lansubmask=127.0.0.1 (replace this with your Lansubnet mask)
21. CharsPort=29110
22.  
23. [CHARSErVER]
24. deletetime=3600
25. usethreads=0
26.  
27. [PASSWORDS]
28. loginpass=789456
29. charpass=456123
30. worldpass=321654
31.  

And the worldserver.conf

Line number On/Off | Expand/Contract | Select all

1.  
2. [DATABASE]
3. mysql_host=(your Mysql host)
4. mysql_user=(your Mysql user)
5. mysql_pass=(your Mysql password)
6. mysql_database=irose
7. mysql_port=3306
8. AutoQueryTime=600
9.  
10. [SERVERDATA]
11. serverid=3
12. servertype=2
13. serverip=127.0.0.1 (replace this with your internet IP: http://whatimyip.com )
14. serverport=29200
15. servername=Channel 1
16. maxconnections=500
17. parentid=1
18. connection=2
19. lanip=127.0.0.1 (replace this with your LAN ip)
20. lansubmask=127.0.0.1 (replace this with your Lansubnet mask)
21. charip=127.0.0.1 (leave this the same)
22.  
23. [WORLDSERVER]
24. accesslevel=100
25. exp_rate=3
26. drop_rate=1
27. drop_type=2
28. zuly_rate=4
29. welcome_msg=test
30. autosave=1
31. savetime=120
32. mapdelay=10
33. visualdelay=200
34. worlddelay=700
35. partygap=10
36. maxstat=300
37. fairy=1
38. fairystay=45
39. fairywait=30
40. fairytestmode=0
41. playerdmg=120
42. monsterdmg=100
43. cfmode=0
44.  
45. [server2server]
46. charip=127.0.0.1
47.  
48. [PASSWORDS]
49. loginpass=789456
50. charpass=456123
51. worldpass=321654
52.  

Setting Up Navicat


Ok we got all that confusing stuff over with ,now we have to go into navicat...
Click on the connection button.

Then click on "MySQL" on the dropdown menu.
Then a box called "connection" should pop up
Fill it out with you MySQL info, and put "irose" in the top dialog box.

Then click on test connection: And if it works then youre good to go, click "ok"
it should make a connection called irose, double click on it. the dolphin should turn blue.
then right click on the dolphin and click the option "New Database"
A box named "create new database" should pop up name your database irose, dont bother with the "coallation" thing.
Here's what it should look like:

click "ok"
after that and you should see this:

double click on the database "irose" and the barrel thing should turn green:

you're done with this for now, so close Navicat.

Installing the Database


Now you open up your server files folder!
got to this location in you folder :
osirose\Database\
i like to foce it thorugh so i dont deal with all the crap, so i edit it to look like this (you can edit by right clicking and clicking on the "edit" button.)

Line number On/Off | Expand/Contract | Select all

1.  
2. @echo off
3.  
4. REM - Default values
5. set bin=C:\Program Files\MySQL\MySQL Server 5.1\bin
6. set user=root
7. set pass=root
8. set db=iROSE
9. set host=localhost
10. echo.
11. echo                  ===== OSpRose Online Database Installer ======
12. echo.
13.  
14. REM - Menu
15. :menuoptions
16. echo.
17. echo Backing up your database is HIGHLY recommended before installing a new database
18. echo Please select an option
19. echo =======================
20. echo 1) Backup Database
21. echo 2) Install Database
22. echo 3) Quit
23. :menu
24. set option=0
25. set /p option="Select an option: "
26. if %option%==1 goto backup
27. if %option%==2 goto install
28. if %option%==3 goto quit
29. goto menu
30.  
31. REM - Backup
32. :backup
33. echo.
34. echo Backing up MySQL Database %db% on host %host% to file %db%_backup.sql
35. %bin%\mysqldump.exe --add-drop-table -h %host% -u %user% --password=%pass% %db% > %db%_backup.sql
36. echo Database Backed Up
37. echo.
38. goto menuoptions
39.  
40. REM - Install
41. :install
42. echo.
43. echo Installing prose.sql to %db% on %host%
44. %bin%\mysql.exe -h %host% -u %user% --password=%pass% -D %db% < prose.sql
45. echo Database Installed
46. echo.
47. goto menuoptions
48.  
49. REM - Quit
50. :quit
51. echo.
52. echo Thanks for using the OSpRose Database Installer :-) Exiting...
53. pause
54.  

copy and paste this into your db_installer.bat so it'll look like this :

it should install everything if you folllow its instructions.

If that doesnt work, or if its in a foreign language, then just go into Navicat, and execute prose.sql

Client Downloads


Now you're on the final strech, you have to pick a client, which can be found in this thread :
viewtopic.php?f=27&t=1510

ok download the client you want and you have to get the 3DATA out of it and put it in your 3ddata folder, in your binary folder.
I would use the Hrose client with oro if you're a beginner. so download that and use Snipahs VFS extractor to extract the 3ddata and put it in the according folders in the 3ddata folder in your binary folder. Also you should get some other folders. ex: Avatar, control cutscene, effect, eldeon, envobj, event, help, item, AND A LOT MORE. so what you should do is add the STB, AI, and QSD (questdata) of the client you are using: hrose. and If you want to use all the other stuff (which the other things are mostly 3d models, and textures) you can. Also if you rip stuff from jrose, then you can put the jrose stuff in the folders, and still use the hrose client (please tell me if this is too confusing).

After you do that go to your binary folder and double click on (in this order) loginserver.exe charserver.exe and worldserver.exe

Settuing Up a Simple Launcher

then you must make a launcher so open up notepad and put this in it :

Line number On/Off | Expand/Contract | Select all

1. TRose.exe @TRIGGER_SOFT@ _server 127.0.0.1(or your external ip)

save it as launcher.bat and put it in your rose client folder.
now when you have done this launch the launcher.bat and play!
you can create accounts with just login it will say that the account doesn't exist.
login with the same information and you will be in!
when you want to make yourself gm you must go to your navicat MySQL database administration tool open the account table and set you accesslevel to 300 this is for admin, 100 is for normal user.

Usefull Guides
NOTE: credits giving to those who made them in the CREDITS section of this guide.

Port Forwarding Guide:
viewtopic.php?f=18&t=2488

Multiple Channels Guide:
viewtopic.php?f=27&t=1530

Making a skinnable Launcher-Patcher (OsIrose):
viewtopic.php?f=27&t=4148

Changing Junon to snow (with resources) :
viewtopic.php?f=27&t=3715



Hope this will help!

CREDITS
Me (merlon)
Lmame (for support and the port forwarding guide and config instructions.)
Choseal (for helping me make this guide better)
BuzBee (for making the multiple channels guide)
Mini (for the junon to snow guide and the resources)
Maxxon (for helping make this guide better)
Tuweky (for helping with the Database Install thingy)
Pychoshooter (for the originall guide)

EDITS

EDIT: Made the LAN subnetmask, and LANip stuff more readable (thanks Choseal !!!! )
EDIT2: Made the whatismyip.com link working, (and this also goes to choseal)
EDIT3: Made a credits section!
EDIT4: Added a multiple channels guide (made by buzbee)
EDIT5: Updated credits:BuzBee (for making the multiple channels guide)
EDIT6:Added lmame's port forwarding guide.
EDIT7: Updated Credits (lmame for port forwarding guide)
EDIT8:Changing the weather in junon. (credits mini and me)
EDIT9: Added EDITS section.
EDIT10: Added Usefull Guides section.
EDIT11: Deleted Lmame's port forwarding guide and put link in Usefull Guides section.
EDIT12: Deleted buzbee's Multiple channels guide and put link in Usefull guides section.
EDIT13: Added Unknown's Launcher/Patcher guide in the Usefull guides section.
EDIT14: Deleted Mini's guide to changing junon to snow, and put a link in the usefull guides section.
EDIT15: Changed title (last edited #/#/#)
EDIT16: Made edits to the config instructions ,Thanks Lmame!
EDIT17: Made even more edits to the configs with MORE help from lmame
EDIT18: took out the pics that were just listed as attachments, didnt look good.
EDIT19: Changed the Title
EDIT20: Added sections
EDIT21: Added a sections thing up front. With all the sections in it.
EDIT22: Edited the extracting stuff for the client to make it more in-depth (thanks Maxxon)
EDIT23: Added Maxxon in the credits
EDIT24: Changed some thing in Instslling database
EDIT25: Added Tuweky in the credits
EDIT26: Added Pyschoshotter to the Credits section

[merlon]

EDIT: made the MySQL links working. and also made the loginserver.conf ,charserver.conf , and worldserver.conf into code, to minimise space taken up.

[merlon]

If anyone sees any errors in the guide PM me or post, i want to make this as good as possible

[lmame]

Thanks

[merlon]

Thanks for what lmame??

[lmame]

I don't know, the guide?

[merlon]

lol is it stickied?

[lmame]

Obviously it is not since no guide is stickied here.

[merlon]

what about psycoshooters guide? isnt that stickied?

[lmame]

what about psycoshooters guide? isnt that stickied?

It's not... Look at the forum you'll see after you posted your thread went over his.