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

Status
Not open for further replies.
/item (id) (type) 1 2 1 1

find out the last 4 things for yourself :P
1 == refine
2 === slotted
1 === stats
1 === amount
 
hy i am a rookie i have followed your instruction for the website everything works exept for the
what must i do?
 
Update 2/8/07 - IMPORTANT UPDATE

Rev 16 has been released! (Credits to Drauk). So what does this mean? The FULLSERVER, Sources, and Compiled links have been updated to the new version!


This version should fix so many peoples problems, it NO longer requires the use of TRose.exe inside your server folder, and has fixed many bugs. Such as the bug of crashing when killing a monster. It's the same setup but 1 step is required! Please read the step below.

Please execute the "account.sql" just like you did with the normal .sql file.

1.) Right click your database and click "Execute batch file"
2.) Point it to the "account.sql" and click "Ok".
3.) Success!

What did it do? It added two new fields required for Rev 16 and dropped a table.

Now, information about the new Rev 16!

Fixed:

* Trade Bug
* Unquiep Arrows/Bullets/Cannons
* Clanname Bug
* Fixed some possibles crashes
1. when kill a monster
2. when pickup a drop
3. when a player disconnect
4. when have a summon and change of map

* Selling Crash

Added:

* Commands from rl2171/Crash/tomiz
1. /class
2. /hide
3. /gotomap
4. /killinrange
5. /heal
6. /serverinfo

* Almost all the commands are logged
* Save every sql query in a file
* Party Skills
* Modified version from the buying price posted from serega81
* Added Signal Hook
* when you close the console (save all the users before close [worldserver])
* In some crashes (try to save before close, and don't show the windows error)
* New encrption in a static library (i didn't used the .dll from deathcode because i'm trying to make the server compatible with linux)
* Packet size check (for now only loginserver,charserver)
* CleanUp connected clients when worldserver start
* Create Login Account (You will can create login in the client [can be activated/deactivated in config.ini)
* Sockets thread (i haven't test to much so try to don't use it [unsafe])
* Monster skill support (still not used)

Changed:

* Command /reload, now relad all the config.ini only in world
* Modified /info command (now show more player information)
* Stats formulas, still need some work
* begintread for pthread_create
* CritialSection fro pthread_mutex
* CMonster struct for class
* the way that calculate the stats (now is calculed in some events [change equip, level up, ...]
* the way to load config.ini (now is more organized)
* Separeted the delay and each thread
* More code changed (more organized) [i can't remember all]
* Removed list_connected table, use now accounts table (online field) to see the connected players

Fullserver v5
Link:

Compiled EXE's (If you loose yours)
Link:

Sources
Link:

STB ver 134
Link:

(The Fullserver v5 is the fullserver ready to start like the old one, just need to edit the config.ini). USE your old .SQL file but execute the "account.sql" I have provided in the Fullserver v5.

All help questions before this post that I have not answered will not be answered. Why? Try this version and your problem may be fixed! I will answer questions from here on.
 
Last edited:
you maybe added the new Fullserver_v5.rar but deleted the old one with the database, if a new customer wants to setup a server, he doesnt have any sql files.
 
you maybe added the new Fullserver_v5.rar but deleted the old one with the database, if a new customer wants to setup a server, he doesnt have any sql files.

Fixed, Fullserver v5 has been updated.
 
great Akai ... u rock!! but still my npc dont work :(
plzz helpme with it .

Explain your problem, like there are no NPC's in game? Or they have no dialog, or what? Explain your problem, and post your details here, such as your Client your using (Na, kr, etc) and the version.
 
there's a change to adding items here it is:

/item (id) (type) (amount) (refine) (slotted) (stats)
 
oh akai... everything is working fine now.. i updated the version to 134!!
can u help me with Castle gear bug pweezz.. its goin too fast,like its not running but zooms like a bullet :P and there is no creeps in Forest of Wandering :S
 
um ive encountred a problem, i keep recieving a Trose error
when a monster dies.
im currently usinf Trose 128
and the verion is the 121 rose client
any help is greatly appreciated.
i can connect fine with IP 127.0.0.1
however when i use my wan IP like the guide says, i cannot log on.
thanks again

fixed the monster dying thing..
it was a problem with my .config, i had item type at 5
i changed it to a 2
however the problem with making the server accept other players.. im clueless, when i use my wan IP it wont work, it only works with 127.0.0.1 and only i an get on
 
Last edited:
well can u tell me the path where u saved the file??
see for me its (bcoz i have saved it here C:\Program Files\xampp\htdocs\rose)
 
Hi Akai
I have problem with login on server. In website I create acc, but in game when Im loging, then game is writing wrong password for my acc. And in servers windows is notice: Disconected xxx.xxx.xxx.xxx IP
Can u help me pls?

2nd problem is in website. Status server is always red :-( never green.
 
I have edited the old server status in the new website... it's quite simple.. just compy an dpaste some stuff from the old one into the new website :)
btw is there a command or an example on how to change all skills to max (example: Cleric skills)
 
Status
Not open for further replies.
Back