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

Status
Not open for further replies.
Hi,

I've been looking for a guide like this, now i found one ty:)
But ihave a problem, When I try to login, I get "The Servers are currently undergoing maintenance", but ive updated gameguard and the rose client. What do i do wrong?

-edit: sorry I reacted to fast. i need to forward my ports first :$
-edit2: Now i am hving the problem that it gets stuck on connecting to server. What did i do wrong?
 
There is a trick if you're port forwarding your ports and playing from your local lan:
 
Hi - I got small (i hope small) problem; I got server installed, as guide says (I had problem with SQL error while starting WorldServer - changed SELECT from list of fields to * - it helped; - maybe key to my problem was there)...

So my problem is - I log in, I create char, I press Start with this char - Client simply closes with no messages, in WorldServer window I can see - Data saved to my char, and my char disconnects;

I'm runing on all Windows XP x64;
Server and Client are on the same computer all IP's set to 127.0.0.1 (localhost);
 
Oh noo..

I rebooted my PC and many things got messed up.

I run the triggerdetect.exe but I when I click the Agree in the loading screen, I got the error Send/ Don't Send. It works fine before I rebooted my computer.

When I click the Database tab in WinMySQLadmin 1.4, I dont see the connection there anymore thats why my website can't connect to MySQL.

Please help me.
 
if i can help anybody i will help but now i cant i downloaded xamplite 1.6.1 now i try dowload 1.7.1 maybe its work i post there if its wont work i help you are but you are help me ! pls
 
when ever i select my character in the tree house i always get an trose error... >.<

and when i log in my account it says server is currently being inspected
how can i fix this..??
 
this guide works beautifully. Thanks
but I have one small issue. Whenever I log in and attack monsters their HP is always in half. Is there a way to fix this?
 
Nice guide, but my client crashes when I bought a skillbook in junon, is there a way to fix it?

It is only when i buy the meditation skillbook of muse skills.
 
Last edited:
I have a little problem, When Im choosing char and press start to get in to the world everything dies, what have i missed or what should i do?
 
Hi.How can I play without port forwarding?Can I put it on hamachi?
And,when I try to configure MySQL,I get a problem(the third option,start service have an error)
 
I can't import database into mysql Any idea? :thumbdown:
----------------------------------------
CREATE TABLE skills_data(
id int( 11 ) NOT NULL default 0,
LEVEL int( 11 ) NOT NULL ,
sp int( 11 ) NOT NULL ,
TYPE int( 11 ) NOT NULL ,
RANGE int( 11 ) NOT NULL ,
target int( 11 ) NOT NULL ,
power int( 11 ) NOT NULL ,
duration int( 11 ) NOT NULL ,
mp int( 11 ) NOT NULL ,
success int( 11 ) NOT NULL ,
weapon varchar( 200 ) NOT NULL ,
class varchar( 200 ) NOT NULL ,
rskills varchar( 200 ) NOT NULL ,
lskills varchar( 200 ) NOT NULL ,
buff1 int( 11 ) NOT NULL ,
buffv11 int( 11 ) NOT NULL ,
buffv12 int( 11 ) NOT NULL ,
buff2 int( 11 ) NOT NULL ,
buffv21 int( 11 ) NOT NULL ,
buffv22 int( 11 ) NOT NULL ,
buff3 int( 11 ) NOT NULL ,
buffv31 int( 11 ) NOT NULL ,
buffv32 int( 11 ) NOT NULL ,
clevel int( 11 ) NOT NULL ,
aoe tinyint( 1 ) NOT NULL ,
aoeradius int( 11 ) NOT NULL ,
script int( 11 ) NOT NULL default 0,
value1 int( 11 ) NOT NULL default 0,
PRIMARY KEY ( id )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

Mensagens do MySQL :
#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 'range int(11) NOT NULL,
target int(11) NOT NULL,
power int(11) NOT NULL,
d' at line 6
 
Mensagens do MySQL :
#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 'range int(11) NOT NULL,
target int(11) NOT NULL,
power int(11) NOT NULL,
d' at line 6

Open the SQL file with a text editor.
Look at the syntax of the query. Search for the word range
put smart quotes around it so it reads 'range' instead of range
save the file.
run the database installer again
 
Status
Not open for further replies.
Back