[GUIDE]Server sided problems? Come & Ask.

[_Miss_AngeL_]

i'm having a ****** problem.
to get protected, i've to use proxy & packet filters. so i lose player's login ip.
so i can't create any ip limit, anti-cheat...etc
any idea to make anti-cheats or limits in another ways?
any idea to get protected without losing ips ?
i know HWID could fix the problem but i've no idea about how to do it.
so is there any way without using HWID ?

[Royalblade*]

Originally Posted by _Miss_AngeL_

i'm having a ****** problem.
to get protected, i've to use proxy & packet filters. so i lose player's login ip.
so i can't create any ip limit, anti-cheat...etc
any idea to make anti-cheats or limits in another ways?
any idea to get protected without losing ips ?
i know HWID could fix the problem but i've no idea about how to do it.
so is there any way without using HWID ?

Who cares about the players IP? I dont think I ever cared about it.
Also before you ask anymore, go and have a chat with Hyperfilter. It'll help you.

[PortalDark]

#reopened and approved by me

[CrisomSnake]

Trying to create a server for Silkroad with files of vSRO when activating the manager, the Machine Manager to open it closes immediately , I read everything and nothing has made me find the solution.

Before opening the Machine Manager:

After:

[sarkoplata]

Hai
Since you have such a nice thread
1- Sometimes people get their chars bugged in an *EPIC* way. The problem is their Male characters are equipped Female items and vice-versa. Insta-dc at login, gameserver gives an error too. Im forced to mess with _Inventory table which i hate doing, any idea? It's really rare and didnt happen before
2- In my bridge i keep getting this error

 at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command)
   at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

I close all the ******* DataReaders after i use them. Reviewed the code a million times.

[TheBlanker]

Originally Posted by CrisomSnake

Trying to create a server for Silkroad with files of vSRO when activating the manager, the Machine Manager to open it closes immediately , I read everything and nothing has made me find the solution.

Before opening the Machine Manager:

After:

Get srPatcher, you have to spoof the machinemanager's IP also (which isnt in the cfg files).

[Royalblade*]

Originally Posted by sarkoplata

Hai
Since you have such a nice thread
1- Sometimes people get their chars bugged in an *EPIC* way. The problem is their Male characters are equipped Female items and vice-versa. Insta-dc at login, gameserver gives an error too. Im forced to mess with _Inventory table which i hate doing, any idea? It's really rare and didnt happen before
2- In my bridge i keep getting this error

 at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command)
   at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

I close all the goddamn DataReaders after i use them. Reviewed the code a million times.

So you've got two problems. One of them is the female male items shit. #2 is the SQL Server problem.

For your SQL connection, use a singleton. DONT open new connections each time, otherweise the server gets overloaded.

The male female problem has to be backtracked. Now here, I can think of 10 different scenarios.

Examples:
NPC fucked up. You buy a Male chest. After teleporting, this thing becomes a female chest. Reason: Client & Server TXTData not the same, refpackagescrap != refpackageXX, Joymax' gayness.

Solution:
Go to every NPC and buy everything. Teleport right away and see if any of the items have changed. Shouldn't take long to find out which NPC is fucked.

Example#2:
You have some sorta item switcher/giver/changer/modifier that isn't limited enough in the WHERE clause so it switches multiple items.

[pakkux]

Do you know if it is possible to run server behind nat? Like amazon aws

[Royalblade*]

Originally Posted by pakkux

Do you know if it is possible to run server behind nat? Like amazon aws

Never really tried amazon, but yeah it should work out pretty fine since nginx works fine with it.

I wouldn't recommend it though, if people start ddosing you, you wont go down. HOWEVER, your costs are going to increase immensely. I guess you don't want that eh?

[pakkux]

Originally Posted by Royalblade*

Never really tried amazon, but yeah it should work out pretty fine since nginx works fine with it.

I wouldn't recommend it though, if people start ddosing you, you wont go down. HOWEVER, your costs are going to increase immensely. I guess you don't want that eh?

The cost isn't problem right now, the problem I am facing is that when I try to login to silkroad server from client I get C9 error and in Agent server I have "Token timeout". My theory is that because in service like amazon you have lan ip on vps. If silkroad server is configured to lan ip then gateway server send wrong ip to client and causes C9 errror.

[Royalblade*]

Originally Posted by pakkux

The cost isn't problem right now, the problem I am facing is that when I try to login to silkroad server from client I get C9 error and in Agent server I have "Token timeout". My theory is that because in service like amazon you have lan ip on vps. If silkroad server is configured to lan ip then gateway server send wrong ip to client and causes C9 errror.

That's because the OriginGatewayConnectionIP is different from the agents.

Open TCPView or something and see which IPs are connecting when you login. It has to be the same one for gateway AND agent.

 Spoiler

skype:akasch93

It's simple to fix if amazon allows you to run the same session over the same instance.

[thatislove]

I have err, when i start SR_gameSever, in the folder Blitzkrieq_Bin_Data run as pic



Pls help, thank you very much

[Royalblade*]

Originally Posted by thatislove

I have err, when i start SR_gameSever, in the folder Blitzkrieq_Bin_Data run as pic



Pls help, thank you very much

How about you show me the whole error so that I can at least see what opcode it is. Generally, this error shouldn't do any harm since its being handled.

[bissag]

There is a bug regarding avatar magic options, someone in my server found a way to add blues which are now showing at the blacksmith NPC, like STR 3 on the avatar hat or accessory which should only show STR 1 but he can add STR 3 or damage resistance 25% on the dress which is not showing for others. I checked both tables _refmagicopt and _refmagicoptassign and they are the default tables, I even deleted both tables and imported the default tables from untouched original database and still the bug is there.

[Royalblade*]

Originally Posted by bissag

There is a bug regarding avatar magic options, someone in my server found a way to add blues which are now showing at the blacksmith NPC, like STR 3 on the avatar hat or accessory which should only show STR 1 but he can add STR 3 or damage resistance 25% on the dress which is not showing for others. I checked both tables _refmagicopt and _refmagicoptassign and they are the default tables, I even deleted both tables and imported the default tables from untouched original database and still the bug is there.

Hmm, that is indeed weird. Can you gimme the item line of 2-3 items that have this "problem"? (From the table _Items, need the whole line)

Basically, I wanna check what REAL parameters are put on the item. Sometimes, there is a DB <-> PK2 problem. Things not being the same or simple overlaps.

If there are indeed 25% dmg resistance on the item, we can check if the blacksmith triggers any stored procedures. Haven't had a bug like this so far, thus, I haven't traced if the blacksmith does execute any procs.

In case any procedure is executed, I can give you a small calculation that checks for invalid blues

If no procedures are executed, then the chance that something else is still ****** and you haven't seen it yet, is very high. If this was a bug that people can "exploit" with default tables, it would be happening on every server.