Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Database - Updates]

Status
Not open for further replies.
Legendary Battlemage
Joined
Aug 11, 2006
Messages
632
Reaction score
1
These files work with osRose ver 15, but might work with the others. They have not been tested with anything else except osRose.

osRose Forums:

SQL


- by Tomiz - 1/21/07
1/21/07 : v0.5 mapdrop updated (mobdrop update will come later :p ) (ver130)

- by rl2171 - 1/6/07
1/6/07 : V0.5 Corrected all maps, added Prison.

- by rl2171 - 1/20/07
1/20/07 : V0.7 Birth Island NPCs added, but commented out.

- by rl2171 - 1/6/07
1/6/07 : V0.5 Pedion, Luna & Junon Clan Fields & DoD added.

- by Tomiz - 1/9/07
1/9/07 : v0.6 Added sikuku underground prison respawnzones

- by rl2171 - 1/6/07
1/6/07 : V0.7 Prison telegates added.

- by Tomiz - 1/20/07

- by Tomiz - 1/22/07
1/20/07 : v0.6 second job quest added + luna quest added (need some fix in the code ) + some quest added
1/22/07 : v0.65 Some Quest reward corrected - thks DoubleU + Teleport noob fix by me
/ You also need to update Quest.cpp and recompile your server (check the readme file in the package).

- by Tomiz - 12/30/06
30/12/06 : v0.5 Summon added/fixed

list_spawnareas :

- by Tomiz - 1/20/07

- by rl2171 - 1/14/07

- by rl2171 - 1/14/07

- by rl2171 - 1/14/07

- by Tomiz - 1/20/07

- by Tomiz - 1/20/07


Other


- 1/20/07

- by rl2171 - 1/17/07
1/17/07 : V0.6 Updated all jobs, more to be fixed.

- by rl2171 - 1/14/07



All Files here are by Tomiz and rl2171 unless otherwise noted and work with the latest STBs.
For Question/Bug/Report about the database, please, use the Database subforum

- by Crash - 1/21/07
--------------------

<------------------------------------------------------------------->
<--- Check our new Pinned topic for the updated SQL files --->
<- ->
<------------------------------------------------------------------->
 
Last edited:
Initiate Mage
Joined
Jan 24, 2005
Messages
0
Reaction score
0
Hehe thanks even more :) Great Job !!
This is one is even better as last one, i try them 2morrow when i wake up.
btw: Hi TomiZ, i think he'll remember me from euRose ^_^

ps: i just need to execute .sql one by one i presume ... and recompile for new quest data.
 
Last edited:

Jvd

Junior Spellweaver
Joined
Dec 17, 2006
Messages
133
Reaction score
0
Nice work!
I realy love it that you release these good spawns and other stuff.
Keep it up!
GrtZ
 
Joined
Aug 16, 2006
Messages
1,251
Reaction score
199
THis is GUNZ DATA BASE right? :S

wow this is probably one of the most ignorant things i have seen so far on this forum.


A little hint...

This is the Rose Online section

Question?

  • Why would you ask if this is the Gunz data base when the topic is posted in the Rose Online secion?
That is all, good bye.

(p.s. Thanks for putting this all in one rl2171)
:raincloud
 
Initiate Mage
Joined
Jan 24, 2005
Messages
0
Reaction score
0
I tried everything and the spawns etc. are all working. Thanks for that.

But i have a problem... i editted quests.cpp and recompiled it with compile-guide.

When i start Worldserver.exe everything seems working. But when i try to login it stays connecting... when i try to enter the world. (login/char-server are working).

It doesn't give me an error when i compile.

This is the error Worldserver.exe receives:
 
Last edited:
Newbie Spellweaver
Joined
Oct 7, 2006
Messages
15
Reaction score
0
it is really very good work, but you gave us the data and not the tables. :S
does somebody have the tables has to make divide? these sources are not update.

somebody has the tables and will be able to give them to us. please
 
Junior Spellweaver
Joined
May 20, 2006
Messages
156
Reaction score
2
cuz these are updates

meaning they update on wat u have already rofl
 
Legendary Battlemage
Joined
Aug 11, 2006
Messages
632
Reaction score
1
it is really very good work, but you gave us the data and not the tables. :S
does somebody have the tables has to make divide? these sources are not update.

somebody has the tables and will be able to give them to us. please

The spawnareas are updated, you can delete the data in your table and execute the batch file for each spawn.

If I recall, the others are full table that require you to delete the actual table and execute them.

What ones are you having problems with, it seems to be working with everyone else, so far, so if there is something wrong with our sql files, we do need to hear back on them

Thanks
 
Newbie Spellweaver
Joined
Oct 7, 2006
Messages
15
Reaction score
0
INSERT INTO `list_spawnareas`
VALUES (
'1500', '38', '303', '15', '40', '15', '12|5083,5225|5097,5211|5092,5195|5062,5186|5066,5209|5059,5213|5044,5199|5045,5220|5037,5235|5045,5242|5057,5242|5070,5237', '0'
)

MySQL:
#1136 - Column count doesn't match value count at row 1

Code:
CREATE TABLE `list_spawnareas` (
  `id` int(11) NOT NULL auto_increment,
  `map` int(11) default NULL,
  `montype` int(11) default NULL,
  `count` int(11) default '1',
  `respawntime` int(11) default '0',
  `points` text,
  `aggrocount` int(11) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Sorry I was badly explained, it would be necessary for me the Champs of the table `list_spawnareas `
mine are not update,
Thanks you


cuz these are updates

meaning they update on wat u have already rofl
instead of you to make fun, gives me the good link
 
Last edited:
Newbie Spellweaver
Joined
Jan 13, 2007
Messages
84
Reaction score
0
hi
how to put this files to my database (roseon_beta)?
i have Dev C++ and wamp no navicat.
help me out pls
 
Kaotic Owner
Loyal Member
Joined
Oct 12, 2005
Messages
1,282
Reaction score
70
can u put all these into one file dl? cuz i dont have time to wait 30 hrs for each file


also after were all done does this use 128 rev or 130? even tho its new?
 
Last edited:
Legendary Battlemage
Joined
Aug 11, 2006
Messages
632
Reaction score
1
can u put all these into one file dl? cuz i dont have time to wait 30 hrs for each file

30 hrs, many are very small, it won't take that long to download.

maybe 10 or 15 min at the most.
 
Junior Spellweaver
Joined
May 20, 2006
Messages
156
Reaction score
2
it will take u like 10 - 15 mins

might have to wait awhile after 4 straight D/L's...cuz they think ur botting rofl
 
Newbie Spellweaver
Joined
Oct 7, 2006
Messages
15
Reaction score
0
All this does not give me an answer to my questions!

-Do You Have the table “list_spawnareas” (without data).

- Do You Have a link to download the last server of rose-online
 

Jvd

Junior Spellweaver
Joined
Dec 17, 2006
Messages
133
Reaction score
0
I hope you release the mobdrops soon, cant wait!.
Also, i need v128 compatible login,channel and worldserver.exe files, i had itzmenx his files but when i attacked a monster, world server crashed.
i need some new ones which work.
Thanks in advance.
GrtZ
 
Newbie Spellweaver
Joined
Sep 23, 2006
Messages
39
Reaction score
0
Very good WORK! i want try this week end thanks a lot!
 
Status
Not open for further replies.
Back
Top