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

[Akai]

I'm extremely sorry for my recent in-activity in this thread. I've been a little bit lazy. I will answer your problems from now on, sorry for the last few days. Here's an update for you. Enjoy.



Our last files were Rev 20, well here is Rev 23! With new additions and bug fixes. Here is the info:

Rev 21

Fixed:

* almost all the stats
* create/disorganize clan (not full, but you will not appaer two times anymore)
* server crash when go back to char
* disconnect when use muted command
* Cloths stats [thanks to tomiz]
* Command.ini levels

Added:

* Added weight
* Added refine stats defense/accury/attack/magic defense (still not 100% correct)
* Mysql Mutex
* Added MaxHP/MaxMP/HPReg/MPReg plus from passive skills

Changed:

* Some changes to allow multiple channels/servers
* The file for every server are separate now, and you can specifie the file name (to multiple servers)
* You don't have to add channels to the database, will be added automatic the server start
* Other files to allow linux compatibility [still not working correctly]


channels table

DROP TABLE IF EXISTS `channels`;
CREATE TABLE `channels` (
  `id` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `name` varchar(255) default NULL,
  `host` varchar(255) default NULL,
  `port` int(11) default NULL,
  `connected` int(11) default NULL,
  `maxconnections` int(11) default NULL,
  `owner` int(11) default NULL
);

Configuration files:

[SERVERDATA]
serverid=0 <--- this will be the server id (in worldserver will be channel number)
servertype=0 <--- server type [0 = login server | 1 = char server | 2 = world server]
serverip=127.0.0.1 <---- external ip
serverport=29000 <--- port
servername=LoginServer <--- name [in charserver will be server name | in worldserver willbe channel name]
parentid=0 <--- in charserver parentid will be the serverid from login | in worldserver parentid will be serverid from charserver
sameserver=1 <----- sameserver should be 1 if the parent server are in the same computer

how to specifie configuration file
just run the exe with parameter the filename
ex. loginserver.exe myfile.conf

you don't have to add nothing to the channels table when server started it will deleted row(with same id) and add the newone.
two server from the same type should not have same serverid, but can have sameid from other server type
ex.
loginserver.conf
serverid=0
servertype=0

charserver.conf [this will connect to loginserver 0]
serverid=0
servertype=1
parentid=0

charserver2.conf [this will connect to loginserver 0]
serverid=1
servertype=1
parentid=0

worldserver.conf [this will connect to charserver 0]
serverid=1 <-- this will be the channel
servertype=2
parentid=0

worldserver2.conf [this will connect to charserver 1]
serverid=2 <--- channel 2
servertype=2
parentid=1

Rev 22

Changed byte variable for weight (sorry i forget to change it)

Rev 23

Added
- Drop rate implemented [for now only affect equips,jewel and pat]
- Experience depend from mob color
- Server status

Changed
- Rewrite drop system (better one?)
- Minor changes in attack system
- Drop changed to the correct packet [799 when the mob die]

Fixed
- Move time when respawn a new mob
- Some buffs
- client crash in some drops
- fixed the packet from mob skill [still not used but is fixed]

you will need the last drop table to work correctly

(Credits to Drauk as always)


Fullserver_v10
Link:

To view the content, you need to sign in or register

Sources
Link:

To view the content, you need to sign in or register

CompiledEXE's
Link:

To view the content, you need to sign in or register

 

[ricetehroni]

sweetness nice..

 

[Almonjin]

i wonder if anyone can make dex add to move speed...i want move speed D:

 

[Akai]

i wonder if anyone can make dex add to move speed...i want move speed D:

You can add dex in the database (characters table).

 

[Di3Go_SM]

how much for 100% ?
looks nice =)

 

[doneb]

100% is not impossible but only Akai(and friends) are working on it.
he will take his time on fixing/adding stuff.
i dont know if he can make it 100% working without bugs, but as you can see.
he gives us some awesome results.

great job Akai! cant wait for the next update ^_^

 

[Akai]

Again, I don't make the files. I just made the guide for people and compiled it and gave you the links. Credits goes to Drauk for making the files.

 

[shadowedice]

when i try to do that navicat with the local host name
what do i do i just type that in cuz when i do it has an error 2003-cant connect to mysqual

 

[n0f3ai2]

done

 

[oioioioioi]

I think you need a other sql file to execute


@shadowedice

download easyphp, install it, run it, then run Navicat

 

[Miltown]

This is the error i get when making the thing for navicat 1045 - access denied for use 'root'@'localhost'

 

[jooker69]

Hey... can any 1 help me i cant download things from rapidshare site....

and where can i get my own database ???

 

[superman007]

this version doesn't work at all

 

[superman007]

missing a lot of files
and i'm unknown files for example: .svn(in each folder)
and why is there Dev files (Char,Long,World Dev.)?

 

[Akai]

Before I begin answering question I need to say a few things:

- The server files have changed, specifically the "config.ini" isn't used anymore. I will update the guide in just a few seconds.

- I'm going to add MySQL to the guide, because you do NEED it.

- I'm going to add more things to the problems section to help you more.

- U P D A T E your files. I see people still using "Fullserver_v5" which is extremely old! This guide updates daily, so should your files!

when i try to do that navicat with the local host name
what do i do i just type that in cuz when i do it has an error 2003-cant connect to mysqual

You need to install MySQL.

Link:

To view the content, you need to sign in or register

Ello all.

I have gotten as far as logging in but my LoginServer is crashing with an error report.. What is wrong here? Thanks.

master= my username for the server.

Your using ancient server files, that's version 5, we have version 10 out. Updated them NOW.

This is the error i get when making the thing for navicat 1045 - access denied for use 'root'@'localhost'

You need to install MySQL.

Link:

To view the content, you need to sign in or register

Hey... can any 1 help me i cant download things from rapidshare site....

and where can i get my own database ???

When clicking the link to rapidshare, click "FREE" and you will need to wait about 30 seconds, then you input the text in the image and click "Download".

And the database is inside the "Fullserver_v10" and "Sources" files. Either one you can use.

this version doesn't work at all

I need to update the guide for configuring your server, it does work. Perfectly to be right. Anyways I will update it within seconds of this post.

missing a lot of files
and i'm unknown files for example: .svn(in each folder)
and why is there Dev files (Char,Long,World Dev.)?

Keep the .dev files where they are (dont' move them). And they are used for compiling. No files are missing.

 

[superman007]

K thanks for the information
wht should i see with the pThreat? Should i install in the rose folder with the rest?

 

[Krawallski]

I have a littel Problem i can`t load the new Database.. i became only this massage

Error1065-Query was empty

what can i do that i can updating my DB?

 

[Miltown]

i downloaded MySQL didnt work reinstalled it still said the same thing =x

 

[superman007]

Miltown
Newbie


Rank: Omicron
Posts: 9
Join Date: Oct 2006 Today, 10:35 PM

--------------------------------------------------------------------------------

i downloaded MySQL didnt work reinstalled it still said the same thing =x

Try to install wampp

 

[Akai]

Please do not post any questions about the Database for a few minutes. I'm currently working to get up a proper updated guide for it. Please be patient, thank you.