[GUIDE]Server sided problems? Come & Ask.

03/30/2015 01:43 _Miss_AngeL_#46
i'm having a shitty 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 ?
03/30/2015 01:54 Royalblade*#47
Quote:
Originally Posted by _Miss_AngeL_ View Post
i'm having a shitty 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.
04/03/2015 06:14 PortalDark#48
#reopened and approved by me
04/05/2015 20:16 CrisomSnake#49
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:
[Only registered and activated users can see links. Click Here To Register...]
After:
[Only registered and activated users can see links. Click Here To Register...]
04/06/2015 02:20 sarkoplata#50
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
Code:
 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.
04/06/2015 18:44 TheBlanker#51
Quote:
Originally Posted by CrisomSnake View Post
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:
[Only registered and activated users can see links. Click Here To Register...]
After:
[Only registered and activated users can see links. Click Here To Register...]
Get srPatcher, you have to spoof the machinemanager's IP also (which isnt in the cfg files).
04/07/2015 03:35 Royalblade*#52
Quote:
Originally Posted by sarkoplata View Post
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
Code:
 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.
04/08/2015 16:02 pakkux#53
Do you know if it is possible to run server behind nat? Like amazon aws
04/08/2015 17:10 Royalblade*#54
Quote:
Originally Posted by pakkux View Post
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?
04/08/2015 17:20 pakkux#55
Quote:
Originally Posted by Royalblade* View Post
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.
04/08/2015 19:33 Royalblade*#56
Quote:
Originally Posted by pakkux View Post
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.
It's simple to fix if amazon allows you to run the same session over the same instance.
04/08/2015 19:53 thatislove#57
I have err, when i start SR_gameSever, in the folder Blitzkrieq_Bin_Data run as pic

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

Pls help, thank you very much
04/08/2015 20:02 Royalblade*#58
Quote:
Originally Posted by thatislove View Post
I have err, when i start SR_gameSever, in the folder Blitzkrieq_Bin_Data run as pic

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

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.
04/09/2015 01:53 bissag#59
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.
04/09/2015 16:12 Royalblade*#60
Quote:
Originally Posted by bissag View Post
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 fucked 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.