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

[makanaboi2]

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

hey, is there any way u could put a different way to open the GM commands/items ID's? i cant get it to open as the excel/spreadsheet >.>

 

[silencrx]

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

use excel viewer google it its a free download 2

 

[Dennnis]

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

cant i lvl donw with a gm command any more ?
with /level i could shoes withs lvl i wanted but now if i write /level 34 i will gett 34 more lvls
ty and good jobb =)

 

[dipi89]

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

Hey does any one kno how to make it do regular players can use /class /go /who /who2 because when i change the access lvl nothing happens what should i do?

 

[j0rg]

i don't want that other GM's can change there stats how can i cancel that?

very nice -.-" i replaced the new server files for the old files and changed the serverip, lanip and the lansubmask. Now if i log in and i double click a character it says: Server Disconnected. If i look to the worldserver it says: [FATAL ERROR] Could not execute query: Unknow colum 'townid' in 'field list'
[INFO] Reconnecting to Mysql

i don't know whats wrong..and i want to play rose again^^
please help me.

 

[qian88]

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

Akai...
** 1st . all my server is runnning fine and able to connect each other
** 2nd . after i type my acc and pass.. it doesnt says acc not exist and i will just connecting forever till i press cancel. at the same time.. the login server detect i connected and disconected at the same time..

Izzit something wrong here? ( it looks like the login server didnt bring me to character selection there )

 

[makanaboi2]

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

um.. whenever i try to go into the world, i always get stuck with a waiting... sign at character selection place... help plx =x

 

[BubbleGum434]

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

ok so i just updated to rev 41 and now i cannot connec to local host it says 1130- localhost is not allowed to connect to this mySQL server

 

[makanaboi2]

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

very nice -.-" i replaced the new server files for the old files and changed the serverip, lanip and the lansubmask. Now if i log in and i double click a character it says: Server Disconnected. If i look to the worldserver it says: [FATAL ERROR] Could not execute query: Unknow colum 'townid' in 'field list'
[INFO] Reconnecting to Mysql

i don't know whats wrong..and i want to play rose again^^
please help me.

actually... this is the exact problem im getting too >.>,,, help plx^

 

[heavensite]

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

akai help<<< why does mobs have low damage << That's fyn BUT i cant hit stronger mobs like when im level 90 i cant hit giant worm dragon why??????
and how to add /go 11 it says at dev c + + project is empty????????

The old one worked at compiling but these new server files says its empty................
AKAI help please and im sorry for triple posting................
HOW can i solve this problem i dont like to miss against a mob
it always does and the DevC++ thing its says project is empty<<<<
why???? REV 30 worked fine with these things................

HELP ME

 

[ThievingSource]

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

hello Akai, if you know the solution to my problem:
I have setted up the server and then updated the roselauncher(real one)
then I changed my graphics stuff ( trigger....exe thing) and I logged on perfectly, made my char, then selected it and it just crashes everytime I try to go into the game with a character.
-THanks

 

[blacksnow]

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

Backup the tables account, characters, item, storage, list_clans, list_friend

I did this but when i select char, it say Server Disconnect and the World Server say WARNING : could not .... feld list
What need i do now

 

[heavensite]

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

I did this but when i select char, it say Server Disconnect and the World Server say WARNING : could not .... feld list
What need i do now

it's like this after u back it up delete all the tables and replace it with the new database akai supplied at server files database folder <<<< THAT's IT inside there will be something called osrose. <<<<execute batch file at navicat or heidi SQL.After that replace ur account table,characters,items with the backup. U have to make back up one by one for those.

-HOPE THIS HELPED-

 

[Akai]

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

Please restrain your self from using: pls, plz, plx! ( Sorry, I just hate that ;p )

Hey does any one kno how to make it do regular players can use /class /go /who /who2 because when i change the access lvl nothing happens what should i do?

I explained that in a couple posts back.

i don't want that other GM's can change there stats how can i cancel that?

very nice -.-" i replaced the new server files for the old files and changed the serverip, lanip and the lansubmask. Now if i log in and i double click a character it says: Server Disconnected. If i look to the worldserver it says: [FATAL ERROR] Could not execute query: Unknow colum 'townid' in 'field list'
[INFO] Reconnecting to Mysql

i don't know whats wrong..and i want to play rose again^^
please help me.

First, don't double post, edit your first post. I'm going to start infracting to get my point across to stop double posting.

For your problem, upgrade your SQL.

Akai...
** 1st . all my server is runnning fine and able to connect each other
** 2nd . after i type my acc and pass.. it doesnt says acc not exist and i will just connecting forever till i press cancel. at the same time.. the login server detect i connected and disconected at the same time..

Izzit something wrong here? ( it looks like the login server didnt bring me to character selection there )

You have to port forward. The ports are: 29000, 29100, 29200.

um.. whenever i try to go into the world, i always get stuck with a waiting... sign at character selection place... help plx =x

You have to port forward. The ports are: 29000, 29100, 29200.

ok so i just updated to rev 41 and now i cannot connec to local host it says 1130- localhost is not allowed to connect to this mySQL server

Edit your database settings..

hello Akai, if you know the solution to my problem:
I have setted up the server and then updated the roselauncher(real one)
then I changed my graphics stuff ( trigger....exe thing) and I logged on perfectly, made my char, then selected it and it just crashes everytime I try to go into the game with a character.
-THanks

What's the worldserver.exe error?

I did this but when i select char, it say Server Disconnect and the World Server say WARNING : could not .... feld list
What need i do now

Run this SQL query:

alter table characters add townid int not null default 56;

 

[heavensite]

man u helped the others why not me..................

why not help me??? u helped the others so far...........

well im sorry what i knew about double posting is the same post 2 times it didnt say differents post's right??? all i need is help and i u'll help me i wont bother again......

Question: how to merge my post?

 

[BubbleGum434]

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

ok so when i did this i accidently deleted local host and thoguht i had to make the password test123 cuase the conf files said that...... and then i got this..
the security settings could not be applied to the data base becuase the connection has failed with the following error
Error Nr. 1130
Host 'localhost' is not allowed to connect to this MySQL server

if a personal firewall is running on ur machine,please make sure u have opened the TCP port 3306 for connections

uninstalled the MySQL server please note that the data directory was not removed automatically.therefore the old password from your last installation is still neded to connect to the server. in this case please select skip now and re-run the configuration wizard from the start menu

 

[Akai]

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

man u helped the others why not me..................

why not help me??? u helped the others so far...........

I'm tired of telling you to stop double posting, do NOT do it again.

ok so when i did this i accidently deleted local host and thoguht i had to make the password test123 cuase the conf files said that...... and then i got this..
the security settings could not be applied to the data base becuase the connection has failed with the following error
Error Nr. 1130
Host 'localhost' is not allowed to connect to this MySQL server

if a personal firewall is running on ur machine,please make sure u have opened the TCP port 3306 for connections

uninstalled the MySQL server please note that the data directory was not removed automatically.therefore the old password from your last installation is still neded to connect to the server. in this case please select skip now and re-run the configuration wizard from the start menu

So..what are you asking?

 

[BubbleGum434]

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

i cant use new connection.. well
i cant do anything i get a CONNECTION ERROR when i run the applying security settings..
the server wont open.. the exe. just says the same error as i said b4
we cant open the server cus we cant connect to the navicat..

 

[Akai]

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

i cant use new connection.. well
i cant do anything i get a CONNECTION ERROR when i run the applying security settings..
the server wont open.. the exe. just says the same error as i said b4
we cant open the server cus we cant connect to the navicat..

Uninstall MySQL. Restart computer. Then reinstall it, and then open Navicat and try adding a new connection. Make sure MySQL is installed though.

Try that first.

 

[makanaboi2]

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

hey, im kinda confused as to how im supposed to get this MySQL thing workin,...: i open the MySQL 5.0 link and install it, then after i run its "server instance config wizard" thingy ,and wen i get to the part right after i enter my password and try to execute, it says "cannot create windows service for MySQL. Error:0" -help please o.o" =x =o =x =o