let us use the normal vsro 1.188 db and fix the bugs and start the server. ?
this would be awesome.
why should "we" use the vsro 1.188 db if "we" can rebuild the db to keep it clean?
this query is required to fix the JSRO map by 100% without any error msgs :P
Code:
USE SRO_BR_SHARD
SELECT ID =
CASE
WHEN ID BETWEEN 10 AND 13
THEN ID -8
WHEN ID = 29
THEN 6
ELSE
ID
END,
WorldCodeName128,
Type,
WorldMaxCount,
WorldMaxUserCount,
GameConfig1,
GameConfig2,
GameConfig3,
GameConfig4,
GameConfig5,
GameConfig6,
GameConfig7,
GameConfig8,
GameConfig9,
GameConfig10,
GameConfig11,
GameConfig12,
GameConfig13,
GameConfig14,
GameConfig15,
GameConfig16,
GameConfig17,
GameConfig18,
GameConfig19,
GameConfig20,
ConfigData1,
ConfigData2,
ConfigData3,
ConfigData4,
ConfigData5,
ConfigData6,
ConfigData7,
ConfigData8,
ConfigData9,
ConfigData10,
ConfigData11,
ConfigData12,
ConfigData13,
ConfigData14,
ConfigData15,
ConfigData16,
ConfigData17,
ConfigData18,
ConfigData19,
ConfigData20
FROM _RefGame_World
WHERE ID IN (1, 10, 11, 12, 13, 29)
SELECT WorldID =
CASE
WHEN WorldID BETWEEN 10 AND 13
THEN WorldID -8
WHEN WorldID = 29
THEN 6
ELSE
WorldID
END,
RegionID
FROM _RefInstance_World_Region
WHERE WorldID IN (1, 10, 11, 12, 13, 29)
AND RegionID NOT IN (22454, 25792)
SELECT WorldID =
CASE
WHEN WorldID BETWEEN 10 AND 13
THEN WorldID -8
WHEN WorldID = 29
THEN 6
ELSE
WorldID
END,
RegionID,
PosX,
PosY,
PosZ,
Param
FROM _RefInstance_World_Start_Pos
WHERE WorldID IN (10,
11,
12,
13)
SELECT DISTINCT wRegionID , X , Z , ContinentName , AreaName , IsBattleField , Climate , MaxCapacity , 0 , 0 , 'xxx' , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0
FROM _RefRegion RR
JOIN _RefInstance_World_Region WR
ON WR.RegionID = RR.wRegionID
WHERE WR.WorldID IN (1, 10, 11, 12, 13, 29)
AND RR.ContinentName IN ('CHINA', 'West_China', 'Oasis_Kingdom', 'Thief Village', 'Roc', 'Eu', 'Am', 'Ca')
AND RR.wRegionID NOT IN (22454, 25792)
SELECT AreaName , 0
FROM _RefRegionBindAssocServer
WHERE AreaName IN ('CHINA',
'West_China',
'Oasis_Kingdom',
'Thief Village',
'Roc',
'Eu',
'Am',
'Ca')
i prefer to develop alone, if i need help i can ask friends so atm i see no reason to hire a developer team and i wanna keep as much as possible unedited so there is seriously no developer team required ^^
all what i need is some beta testers they test the files of bugs ^^
but i´ll request some if the time is come
but if u wanna keep up2date i send u a skype request just accept it
Just stop dreaming, a lot of people tried doing that before and the result was: "Players online: 200(Max)" --server is not making money -> closes in 1/2 months.
Developers are creating these server with 100x/200x exp and overpowered stuff because that's what the players actually WANT.
Have you ever thought before why these 'developers' keep working on a server for a month or two or maybe 7 months?
Its like investing money on stocks then waiting for a while to get your money back and more, you don't even know how long it'll take. You might lose all your money and you might not. That's a risk taken by developers.
They're learning SQL and PK2 just to make money. No developer will create a server without filling item mall with loads of *****.
Just stop dreaming, a lot of people tried doing that before and the result was: "Players online: 200(Max)" --server is not making money -> closes in 1/2 months.
Developers are creating these server with 100x/200x exp and overpowered stuff because that's what the players actually WANT.
Have you ever thought before why these 'developers' keep working on a server for a month or two or maybe 7 months?
Its like investing money on stocks then waiting for a while to get your money back and more, you don't even know how long it'll take. You might lose all your money and you might not. That's a risk taken by developers.
They're learning SQL and PK2 just to make money. No developer will create a server without filling item mall with loads of *****.
Regarding your idea, It'll fail.
actually you are wrong, since i don't pay for anything (not even my root server) i develop on my own serverfiles for fun.
I think ppl usually lose interest in private servers because of the ease of getting to top, it shouldn't be so easy to get to the max lvl or get the best equipments in 1-2 days. It should all be balanced and server owners should make it interesting and keep it as neat as possible.
Syloxx, manage to add Fortress on jsro files, and ofc get a bot then you will succeed.
add Fortress War in JSRO is not possible for me (idk if this is even possible)
any Fortress War Query / Schedule is missing, the client wont load the Fortress War textfiles. i heard from someone that you can add it via codecave but i dont know
DB-Bot 2 Times 05/12/2010 - SRO Private Server - 0 Replies Anyone Know whitch way i can play 2 times
1 on Sw1
and second on SW 2 whit the bot?
[Times]???????? 03/24/2009 - EO PServer Hosting - 5 Replies Well, it's me again the question asker....
I have a request for someone to point out how to change the times of:
Family War
Legion War
Pk Tournament
And the server date,time like when you're unsealing an eudemon... and such.
I'm almost positive it's in cq_action... i just don't know where
GM times 08/22/2008 - Dekaron - 13 Replies Hello all
i would like to know if anyone knows when gms are most active?
are they active at night? like 22.00-3.00?
thx in advance
Mvp Times? 09/25/2006 - Ragnarok Online - 2 Replies Gibts nen tool wie ich die Mvps Times sehen kann?
Oder irgend etwas in der richtung?
mfg Hartz!
? 
