[MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

Status
Not open for further replies.
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

i looked for the "install" file its not there so in the config folder where do i put it
Code: 
<?php
#############################################################################
# Since I've had enough of the complaints, Im not doing an install script.  #
# Just fill this out and all is well.           #
# And yes, the configuration is a little different...       #               #############################################################################
/* Database Configuration */
$db['Host']   =   ''; // Database Host
$db['User']   =   ''; // Database User
$db['pass']   =   ''; // Database Pass
$db['name']   =   ''; // Database Name
/* End Database Configuration */
/* Site / Server Configuration */
$serv['title']  =   '-ElementRose'; // Server "Name"
$serv['exp']  =   '300x'; // Server Exp Rate
$serv['drop']  =   '250x'; // Server Drop Rate
$serv['admin']  =   '-Element'; // Adminstrators Name
$serv['dev']  =   '-Element'; // Head Developer
$serv['gmh']  =   '-Element'; // Head GameMasters 
$serv['gm1']  =   '-Element';
$serv['gm2']  =   '-Element';
$serv['gm3']  =   '-Element';
$serv['gm4']  =   '-Element';
/* End Site / Server Configuration */
/* Links */
$link['forum']  =   ''; // Link to your forum  ==================INCLUDE THE HTTP IF EXTERNAL!!!======================
$link['client']  =   ''; // Client
$link['patch']  =   ''; // Patch
$link['launcher'] =   ''; // Link to your launcher!
?>
now where it says host for both i put it in the first one or both?

here i took a picture
Akai - [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More - RaGEZONE Forums
 
Last edited:
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

rellis6619 said:
i looked for the "install" file its not there so in the config folder where do i put it
Code: 
<?php
#############################################################################
# Since I've had enough of the complaints, Im not doing an install script.  #
# Just fill this out and all is well.           #
# And yes, the configuration is a little different...       #               #############################################################################
/* Database Configuration */
$db['Host']   =   ''; // Database Host
$db['User']   =   ''; // Database User
$db['pass']   =   ''; // Database Pass
$db['name']   =   ''; // Database Name
/* End Database Configuration */
/* Site / Server Configuration */
$serv['title']  =   '-ElementRose'; // Server "Name"
$serv['exp']  =   '300x'; // Server Exp Rate
$serv['drop']  =   '250x'; // Server Drop Rate
$serv['admin']  =   '-Element'; // Adminstrators Name
$serv['dev']  =   '-Element'; // Head Developer
$serv['gmh']  =   '-Element'; // Head GameMasters 
$serv['gm1']  =   '-Element';
$serv['gm2']  =   '-Element';
$serv['gm3']  =   '-Element';
$serv['gm4']  =   '-Element';
/* End Site / Server Configuration */
/* Links */
$link['forum']  =   ''; // Link to your forum  ==================INCLUDE THE HTTP IF EXTERNAL!!!======================
$link['client']  =   ''; // Client
$link['patch']  =   ''; // Patch
$link['launcher'] =   ''; // Link to your launcher!
?>
now where it says host for both i put it in the first one or both?

here i took a picture
Akai - [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More - RaGEZONE Forums
Click to expand...

"host for both" What are you talking about?
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

I have 2 questions:
1.) I set up the Navi and MYSQl server properly. But when I try to run login/world/character.exe, it says:

Fatal error: error connecting to Mysql server, Unknown database "localhost".

2.) How do I update between Rev.? Do i just download them and replace the old files?

Any help will be appericated.
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

hey i got a question,, when i do the batch file on Navicat i get this error can someone help me fix it


[Err] 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 43
[Msg] Finished - Unsuccessfully
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

A slightly different question now :)

I have the servers up and working almost perfectly, but there are a couple of hiccups. Firstly, from time to time people have problems with quests. One person had a problem where he couldn't do the job advance quest. He spoke to the person and it did all the quest talk, but it wasn't added to his quest book, and talking to the NPC again gave the text which should come up when you've accepted and started the quest.

I had a similar problem with the Zant quest thingy with the children. I got up to the part where I spoke with one of the children, and he is supposed to transform into a monster and attack you. The quest log updated saying he transformed, but no monster appeared. Talking to the child game the same text that happened when talking to any of the other children that weren't in the quest.

Is this a problem with the code?


Secondly, item drops don't seem to be working. I have drop_rate = 100 and drop_type = 2
All that monsters are dropping is food like apples and milk. Rarely zuly, and never items it seems. Also, nothing drops when I kill things in my GM account :/
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

Hi Akai,
I notice that some quest dont work at all.
Certain quest have certain error.
Could you help?
Sorry for the trouble cause.
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

I got Navicat and I have everything down right, but its doesn't work.
"2003 - Can't connect to MySQL server on 'localhost' (10061)
What is wrong?
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

Also in addition to my above problem is there a way to input GM commands without being in-game, such as giving players zuly, reloading the config etc.

Because whenever the server crashes for whatever reason (such as a GM accidently killing an NPC) when I restart the server, it has the default rates. I have to log into the server and /reload to get the rates back to 100 ._.

Edit: Problem solved, didn't edit the worldserver.conf ._.
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

Do you need a previously made account on ROSE online?
Im trying this game out, and i thought it would be fun to start it out by hacking.
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

hello,

i cant join clanhouse. He says it is deactivatet. How i can reactivate it?

greets
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

iviv said:
A slightly different question now :)

I have the servers up and working almost perfectly, but there are a couple of hiccups. Firstly, from time to time people have problems with quests. One person had a problem where he couldn't do the job advance quest. He spoke to the person and it did all the quest talk, but it wasn't added to his quest book, and talking to the NPC again gave the text which should come up when you've accepted and started the quest.

I had a similar problem with the Zant quest thingy with the children. I got up to the part where I spoke with one of the children, and he is supposed to transform into a monster and attack you. The quest log updated saying he transformed, but no monster appeared. Talking to the child game the same text that happened when talking to any of the other children that weren't in the quest.

Is this a problem with the code?


Secondly, item drops don't seem to be working. I have drop_rate = 100 and drop_type = 2
All that monsters are dropping is food like apples and milk. Rarely zuly, and never items it seems. Also, nothing drops when I kill things in my GM account :/
Click to expand...

I guess u're not alone iviv... i had that kinda prob too, the quests are kinda weird...

Since i'm following the exact setup n everything is in working order, my server is online and playable... i really hope someone can lend us a hand here... just pinpoint us where to change and that's all

Thank you
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

After the libmysql package is installed, we need to change a few lib paths. Open up your project (such as worldserver.dev, which can be found in the "worldserver" folder) Go to menu "Project>project option".
2. Go to "parameters" tab and change the "C:/Dev-Cpp/lib/libws2_32.a" and "C:/Dev-Cpp/lib/libmysql.a"
for you correct path.

Open DEV C++ and in the menu go to "Project>Project Option". Then go to the tab "Parameters" and change the "C:/Dev-Cpp/lib/libws2_32.a" and "C:/Dev-Cpp/lib/libmysql.a" to their correct paths, (look for files in the "lib" folder, and just copy and path).

Now, to compile the .exe, open the .dev (loginserver.dev, charserver.dev, worldserver.dev) and click on the menu "Execute>Rebuild All". And you have the .exe inside the sources folder!
Click to expand...

sorry i cant understand this part anyone can make it easy?
when i open the project using Dev-C++ it came out wif a message
"Could not create executable output directory:"Binary"Check setting"
anyone know that means? pls help me xD
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

i did re install but nothing stil cant open :S



PS:I Run with hamachi (should it work with hamachi too???)
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

hey ive got 2 problems

1.when i do the
To view the content, you need to sign in or register
thing it says object not found on the page


2.i know i didnt set up a account or nothin but when i try to log in its saying server is down for maintenance


do i really need the website if its just me playing?
 
re: [MEGA GUIDE] Rose Server Setup + Compiling + SQL & More

patrickstar said:
I have 2 questions:
1.) I set up the Navi and MYSQl server properly. But when I try to run login/world/character.exe, it says:

Fatal error: error connecting to Mysql server, Unknown database "localhost".

2.) How do I update between Rev.? Do i just download them and replace the old files?

Any help will be appericated.
Click to expand...

1.) ...Why would you put "localhost" for your database name?
2.) Yes.

letarte said:
hey i got a question,, when i do the batch file on Navicat i get this error can someone help me fix it


[Err] 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 43
[Msg] Finished - Unsuccessfully
Click to expand...

What SQL are you trying to import? (name).

iviv said:
A slightly different question now :)

I have the servers up and working almost perfectly, but there are a couple of hiccups. Firstly, from time to time people have problems with quests. One person had a problem where he couldn't do the job advance quest. He spoke to the person and it did all the quest talk, but it wasn't added to his quest book, and talking to the NPC again gave the text which should come up when you've accepted and started the quest.

I had a similar problem with the Zant quest thingy with the children. I got up to the part where I spoke with one of the children, and he is supposed to transform into a monster and attack you. The quest log updated saying he transformed, but no monster appeared. Talking to the child game the same text that happened when talking to any of the other children that weren't in the quest.

Is this a problem with the code?


Secondly, item drops don't seem to be working. I have drop_rate = 100 and drop_type = 2
All that monsters are dropping is food like apples and milk. Rarely zuly, and never items it seems. Also, nothing drops when I kill things in my GM account :/
Click to expand...

I don't edit the sources, you'll have to ask OSrose.

Set "drop_type" to 1, and lower the drop rate to 50.

sgsnow said:
Hi Akai,
I notice that some quest dont work at all.
Certain quest have certain error.
Could you help?
Sorry for the trouble cause.
Click to expand...

Client version and server files version?

Duel said:
I got Navicat and I have everything down right, but its doesn't work.
"2003 - Can't connect to MySQL server on 'localhost' (10061)
What is wrong?
Click to expand...

You need to install MySQL. Link and directions are in the guide (This is NOT Navicat).

mageish said:
Do you need a previously made account on ROSE online?
Im trying this game out, and i thought it would be fun to start it out by hacking.
Click to expand...

No, and do NOT dicuss hacking here or I'm going to have to report you.

mageish said:
Also, do you repeat these steps every log in?
Click to expand...

Repeat what steps?

aukemon0 said:
login server dont work!!!!

thanks for looking
Click to expand...

Can you give me more info than "login server dont work!!!!!".

wolle12 said:
hello,

i cant join clanhouse. He says it is deactivatet. How i can reactivate it?

greets
Click to expand...

Client version (NA/KR?)?

taffzimo said:
i did re install but nothing stil cant open :S



PS:I Run with hamachi (should it work with hamachi too???)
Click to expand...

Yes try using hamachi, sometimes that fixes it for people.

Miltown said:
hey ive got 2 problems

1.when i do the
To view the content, you need to sign in or register
thing it says object not found on the page


2.i know i didnt set up a account or nothin but when i try to log in its saying server is down for maintenance


do i really need the website if its just me playing?
Click to expand...

If it says it can't find "install" then quit trying to type that in lol. Look for the "config.php" file and edit that with your correct Database settings.

Set up an account first..thats an obvious thing?
 
Status
Not open for further replies.

RaGEZONE Sponsor

    HyperFilter

About RaGEZONE

RaGEZONE® is a leading MMO and MMORPG development community offering source codes, server files, tutorials, tools, and private servers for developers and gamers.

Forum Statistics

Members online
1,376
Guests online
21,518
Total visitors
22,894
Totals may include hidden visitors.

RaGEZONE Partners

    non GamStop casinos
Back