M!ssing the Old Times.

[BlackSelection#]

let us use the normal vsro 1.188 db and fix the bugs and start the server. ?

this would be awesome.

[Syloxx]

Originally Posted by BlackSelection#

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

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')

just to show that i still code some shit D

[BlackSelection#]

would you start a server project with me ?

for sure iam from germany too.

[Syloxx]

Originally Posted by BlackSelection#

would you start a server project with me ?

for sure iam from germany too.

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

[BlackSelection#]

Ok ! Nice please keep it original

iam still fixing something on my own database right now i stopped 4 months ago :P

[CriZ-]

Originally Posted by Syloxx

this is what i'am doing at the moment.. try to fix JSRO

i already got JSRO working without any bugs just have to rebuild SHARD db because atm its based on BR

here some images i made:

Good job my friend

[AceSpace]

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.

[Syloxx]

Originally Posted by ²²Rock²²

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 collect money by helping other servers.

[GlavierMe]

Originally Posted by Syloxx

i collect money by helping other servers.

then he's totally right !

[Syloxx]

Originally Posted by GlavierMe

then he's totally right !

nope, because hes talking about "use the own server as money source"

my money source are other servers (server administrators)

[BlackSelection#]

I had more fun on original silkroad servers (psro and isro) as on this full overedited servers.

If there would be an original server without edits just were the rates are higher i would join directly & my friends too.

[Memoirs]

Syloxx, manage to add Fortress on jsro files, and ofc get a bot then you will succeed.

[melow]

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.

[smenul]

how nice wuld it be one new project 30 cap and evry mounth raise the cap with 5 lvl`s like the old days...how cool wuld that be

[Syloxx]

Originally Posted by Memoirs

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