M!ssing the Old Times.

12/10/2014 17:03 BlackSelection##16
let us use the normal vsro 1.188 db and fix the bugs and start the server. :D ?

this would be awesome.
12/10/2014 17:05 Syloxx#17
Quote:
Originally Posted by BlackSelection# View Post
let us use the normal vsro 1.188 db and fix the bugs and start the server. :D ?

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')
just to show that i still code some shit :DD
12/10/2014 17:33 BlackSelection##18
would you start a server project with me ?

for sure iam from germany too.
12/10/2014 17:40 Syloxx#19
Quote:
Originally Posted by BlackSelection# View Post
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
12/10/2014 17:51 BlackSelection##20
Ok ! Nice please keep it original :)

iam still fixing something on my own database right now i stopped 4 months ago :P
12/10/2014 19:30 CriZ-#21
Quote:
Originally Posted by Syloxx View Post
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:
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
Good job my friend
12/10/2014 19:36 AceSpace#22
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 shits.

Regarding your idea, It'll fail.
12/10/2014 20:36 Syloxx#23
Quote:
Originally Posted by ˛˛Rock˛˛ View Post
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 shits.

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.
12/11/2014 09:16 GlavierMe#24
Quote:
Originally Posted by Syloxx View Post
i collect money by helping other servers.
then he's totally right !
12/11/2014 09:39 Syloxx#25
Quote:
Originally Posted by GlavierMe View Post
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)
12/11/2014 16:15 BlackSelection##26
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.
12/11/2014 21:55 Memoirs#27
Syloxx, manage to add Fortress on jsro files, and ofc get a bot then you will succeed.
12/12/2014 00:01 melow#28
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.
12/12/2014 02:46 smenul#29
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:D
12/12/2014 08:00 Syloxx#30
Quote:
Originally Posted by Memoirs View Post
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