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

[dsl302g]

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

Why is it when people try to connect to my server on Hamachi, they get the "server mainanence" error. I can log in fine but everyone else can't?

:/

Edit: Fixed and working yay! Come join roseon123 password 123 I'll make everyone a GM so you can mess around XD

 

[blahx1992]

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

I have the REV 45 files and I configured everything like port fowarding and making sure the access lvl is 100 and also updating my NA_ROSE client. I don`t know what to do anymore. I still get that maintanence thingy.

 

[ziggymojo]

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

A question if i dont have a router can it be from outside playeble than and how:?

 

[oOM3n]

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

Can any1 tell me the Id of the classes?
I need go to Cavicat to edit my classes....

It's said in the first post you just have to read it

 

[grandes]

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

the localhost connections says cant connect somewhy i dunno any help?

 

[aREfiXed]

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

the localhost connections says cant connect somewhy i dunno any help?

have u install mysql?..
mysql should do the job..

 

[Almonjin]

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

[INFO]: Connecting to Mysql
[INFO]: Connected to Mysql
[FATAL ERROR]: Could not execute query: Unknown column 'type' in 'where clause'
[INFO]: Reconnecting to Mysql
[FATAL ERROR]: Could not execute query: Unknown column 'type' in 'field list'
[INFO]: Reconnecting to Mysql
[INFO]: Server started 29000 and is listening.

>_>

that's annoying...wtf do i do

 

[TMapes]

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

sql dump failed...
Query:
CREATE TABLE `areatrigger_involvedrelation` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'

Error occured at:2007-04-05 17:37:21
Line no.:18
Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists

Query:
CREATE TABLE `account` (
`id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Identifier',
`username` varchar(16) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gmlevel` tinyint(3) unsigned NOT NULL default '0',
`sessionkey` longtext,
`v` longtext,
`s` longtext,
`email` varchar(255) NOT NULL default '',
`joindate` timestamp NOT NULL default CURRENT_TIMESTAMP,
`banned` tinyint(3) unsigned NOT NULL default '0',
`last_ip` varchar(30) NOT NULL default '127.0.0.1',
`failed_logins` int(11) unsigned NOT NULL default '0',
`locked` tinyint(3) unsigned NOT NULL default '0',
`last_login` timestamp NOT NULL default '0000-00-00 00:00:00',
`online` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_username` (`username`),
KEY `idx_banned` (`banned`),
KEY `idx_gmlevel` (`gmlevel`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Account System'

Error occured at:2007-04-06 11:29:35
Line no.:34
Error Code: 1050 - Table 'account' already exists

Query:
INSERT INTO `command` VALUES('modify money',1,'Syntax:\r\n.modify money #money\r\n.money #money\r\n\r\nAdd or remove money to the selected player. If no player is selected, modify your money.\r\n\r\n #gold can be negative to remove money.')

Error occured at:2007-04-07 18:49:22
Line no.:2
Error Code: 1062 - Duplicate entry 'modify money' for key 1

Query:
insert into `creature`(`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`state`,`MovementType`,`auras`) values (1,1563,0,-15019,265.174,7.52,4.851,370,0,0,-15019,265.174,7.52,4.851,1894,1253,0,0,NULL),(2,2546,0,-15016,266.913,18.559,0.555,370,0,0,-15016,266.913,18.559,0.555,2574,0,0,2,NULL),(3,1563,0,-15001,266.637,0.136,1.986,370,0,0,-15001,266.637,0.136,1.986,1894,1253,0,0,NULL),(4,1563,0,-15001,267.906,0.198,5.128,370,0,0,-15001,267.906,0.198,5.128,1894,1253,0,0,NULL),(5,1563,0,-14994,259.463,12.721,4.415,370,0,0,-14994,259.463,12.721,4.415,1894,1253,0,0,NULL),(6,1563,0,-14994,274.521,12.699,1.579,370,0,0,-14994,274.521,12.699,1.579,1894,1253,0,0,NULL),(7,1563,0,-14988,258.384,12.763,4.753,370,0,0,-14988,258.384,12.763,4.753,1894,1253,0,0,NULL),(8,1563,0,-14987,274.459,12.787,1.56,370,0,0,-14987,274.459,12.787,1.56,1894,1253,0,0,NULL),(9,1563,0,-14985,268.856,0.198,0.164,370,0,0,-14985,268.856,0.198,0.164,1894,1253,0,0,NULL),(10,1563,0,-14984,267.221,0.198,1.022,370,0,0,-14984,267.221,0.198,1.022,1894,1253,0,0,NULL),(11,1564,0,-14983,266.998,13.043,0.052,370,0,0,-14983,266.998,13.043,0.052,1374,1220,0,0,NULL),(12,1563,0,-14983,269.315,0.198,4.157,370,0,0,-14983,269.315,0.198,4.157,1894,1253,0,0,NULL),(13,1563,0,-14982,259.166,12.881,4.89,370,0,0,-14982,259.166,12.881,4.89,1894,1253,0,0,NULL),(14,1563,0,-14981,267.133,13.062,3.335,370,0,0,-14981,267.133,13.062,3.335,1894,1253,0,0,NULL),(15,1564,0,-14975,349.107,13.033,5.949,370,0,0,-14975,349.107,13.033,5.949,1374,1220,0,0,NULL),(16,1564,0,-14973,348.646,13.035,2.808,370,0,0,-14973,348.646,13.035,2.808,1374,1220,0,0,NULL),(17,1565,0,-14971,302.884,2.915,0.026,370,0,0,-14971,302.884,2.915,0.026,2128,1253,0,0,NULL),(18,1563,0,-14970,351.66,12.918,1.913,370,0,0,-14970,351.66,12.918,1.913,1894,1253,0,0,NULL),(19,1563,0,-14967,337.732,12.909,5.012,370,0,0,-14967,337.732,12.909,5.012,1894,1253,0,0,NULL),(20,1563,0,-14966,298.994,2.536,0.209,370,0,0,-14966,298.994,2.536,0.209,1894,1253,0,0,NULL),(21,1563,0,-14964,352.827,12.835,1.792,370,0,0,-14964,352.827,12.835,1.792,1894,1253,0,0,NULL),(22,1563,0,-14962,307.638,2.502,6.217,370,0,0,-14962,307.638,2.502,6.217,1894,1253,0,0,NULL),(23,1563,0,-14962,340.2,12.842,5.184,370,0,0,-14962,340.2,12.842,5.184,1894,1253,0,0,NULL),(24,1564,0,-14961,347.337,13.014,0.439,370,0,0,-14961,347.337,13.014,0.439,1374,1220,0,0,NULL),(25,1564,0,-14960,347.849,13,3.524,370,0,0,-14960,347.849,13,3.524,1374,1220,0,0,NULL),(26,1563,0,-14958,354.5,12.772,1.819,370,0,0,-14958,354.5,12.772,1.819,1894,1253,0,0,NULL),(27,1563,0,-14955,340.865,12.729,5.11,370,0,0,-14955,340.865,12.729,5.11,1894,1253,0,0,NULL),(28,1563,0,-14949,300.821,2.722,6.166,370,0,0,-14949,300.821,2.722,6.166,1894,1253,0,0,NULL),(29,2549,0,-14936,359.448,12.595,3.496,370,0,0,-14936,359.448,12.595,3.496,2046,0,0,0,NULL),(30,2548,0,-14934,354.41,18.682,3.806,370,0,0,-14934,354.41,18.682,3.806,2471,1286,0,0,NULL),(31,1563,0,-14928,92.277,7.522,0.72,370,0,0,-14928,92.277,7.522,0.72,

 

[Flipper0203]

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

Omg i tried making server and it didnt work... i need help...the part that is fucked up is the "navicat" thing it wont connect! pls help me....

 

[Sexi]

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

First of all, you will NEVER need someone elses trose.exe to run a server. EVERY time your client updates, you should add the new trose.exe from YOUR client folder (C:\Program Files\Triggersoft\Rose Online Evolution\) to your server folder.

i unable to run rosegameguard, i run it and it close again

rosegameguard.exe has no user interface "UI". Just double click it once and then go to your client launcher (whether it be a .bat or an .exe)

*Enter giant picture here from page 82*

WTF? I DID WHAT IT SAID BUT I CAN'T REGISTER!

For all those who can see their website but always get database errors: check my thread
Always remember to double check, triple check , quadruple check, and whatever-comes-after-that check your config.php if you ever see OBDC@localhostUSINGPASSWORD:NO or whatever.

[INFO]: Connecting to Mysql
[INFO]: Connected to Mysql
[FATAL ERROR]: Could not execute query: Unknown column 'type' in 'where clause'
[INFO]: Reconnecting to Mysql
[FATAL ERROR]: Could not execute query: Unknown column 'type' in 'field list'
[INFO]: Reconnecting to Mysql
[INFO]: Server started 29000 and is listening.

>_>

that's annoying...wtf do i do

It looks as though your using an old database with new server exes. Either (1)update your database or (2)wipe your old one and use the newest one.(Recommended for new users). You can always backup your accounts and characters table before wiping and put them back after the new database is installed, but if you still have problems with the database you should wipe again and don't try to restore those tables.

 

[Flipper0203]

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

Help me pls the Navicat doesnt work like it says that: 2003 - Can't connect to server (10061) i tryed everything help me pls...

 

[Aria15]

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

Guys one question i am using v138 if i update it to 139 will that change anything at the server????

 

[DeBOuN]

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

Hi, I continue with when I select char the game crash to the dektop.
Now the charserver.exe says:
[WARNING]: <SID:440> Received unknown packet. Command:0008 Size:0066
:cry_1: :cry_1:

 

[kerebrus]

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

Hey server works great but when i choose my char and start to load that char in trose dies.
never mind found problem

 

[leonthienle]

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

I just reinstall the Window so I redo all this stuff.....now I got a problem is when I got into the game, it just auto kik me out of the game. And I think it's my TriggerDetect.exe .So can any1 help me.
This is the screen:

​

 

[yotam]

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

10x thhats some guide...

 

[Sexi]

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

Help me pls the Navicat doesnt work like it says that: 2003 - Can't connect to server (10061) i tryed everything help me pls...

Check to see if your Mysql server is running. If you not sure what I'm talking about, reread the guide and then check xampp or whatever you use for mysql. If your behind a router, also check that 3306 if forwarded to you computer

Guys one question i am using v138 if i update it to 139 will that change anything at the server????

You need to replace the trose.exe in the server folder with the one in your client folder i.e. C:\Program Files\Triggersoft\Rose Online Evolution\

Hi, I continue with when I select char the game crash to the dektop.
Now the charserver.exe says:
[WARNING]: <SID:440> Received unknown packet. Command:0008 Size:0066
:cry_1: :cry_1:

Check to make sure you have done what I just said above.

Hey server works great but when i choose my char and start to load that char in trose dies.
never mind found problem

"never mind, i figured it out" doesn't help anyone who reads this thread fix there problems. If we all just "figured it out" and kept the information to ourselves, then there would be no guide to follow. If you state a problem, and then fix it, share your details so that others who are starting out may benefit.

I just reinstall the Window so I redo all this stuff.....now I got a problem is when I got into the game, it just auto kik me out of the game. And I think it's my TriggerDetect.exe .So can any1 help me.
This is the screen:

​

Have you tried running triggerdetect.exe before starting your client? ( You will only have to do this once per install )

 

[LastWish]

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

Hi.Everythink is ok but no have monsters and commands /go/who/who2/class pls if u have the commands pls give and answer of my question with monsters pls

 

[LastWish]

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

Quote:
Originally Posted by leonthienle
I just reinstall the Window so I redo all this stuff.....now I got a problem is when I got into the game, it just auto kik me out of the game. And I think it's my TriggerDetect.exe .So can any1 help me.
This is the screen:





wtf just conf it...

 

[soneta]

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

fucking gameguard error

i've give up following this guide