Release | SR Proxy the best way to protect your private server!

[Ciryon]

1 Player get no silk from killing Unique
i get this message from SR_Proxy:
GIVE_SILK_by_StrUserID opeation has failed and returned string.Empty

how i can fix it ?

help

[Isoline*]

Originally Posted by Ciryon

1 Player get no silk from killing Unique
i get this message from SR_Proxy:
GIVE_SILK_by_StrUserID opeation has failed and returned string.Empty

how i can fix it ?

help

your table is empty so the system cannot get the latest order number

execute this so you will have at least one dummy record:

INSERT " + Settings.MSSQL_ACC_DB + ".dbo.SK_SilkBuyList(UserJID,Silk_Type,Silk_Reason,Silk_Offset,Silk_Remain,ID,BuyQuantity,OrderNumber,SlipPaper,RegDate) VALUES ( 0,0,0,0,0,0,0,0,'dummy',GETDATE())

[b0ykoe]

Originally Posted by b0ykoe

We've bought the Filter about two weeks ago for our project. I'm surprised, its exactly what he advertised!

Also it comes with great support and he installs it for you.

Looking forward for news features

Some time has passed. I'm still happy with the overall product. There is only one case that ***** me up. Not only a little bit because a feature which is described in the Thread, as today 29.05.2019 - 16:22 GMT +2, is simply wrong.



The feature says "You can get all of YOUR AVAIBLE titles in your server dynamically.." Most people, like me, will understand it as you can somewhat connect titles to a user and have a "whitelist" for each person.
For example a normal user can't get the Admin / Game Master title, but the truth is that they can. They have access to every title on the server and there is no option to limit it.

Also it comes with a VIP system, which is not named here and neither well documented on the filter itself, there is a table which is kinda easy to understand but oh well.

Just for futher customers, don't think that there is a "chat title system" in it. You can basically give the VIP status to your admin and switch titles in real time - thats it.

[bende16]

Originally Posted by Isoline*

your table is empty so the system cannot get the latest order number

execute this so you will have at least one dummy record:

INSERT " + Settings.MSSQL_ACC_DB + ".dbo.SK_SilkBuyList(UserJID,Silk_Type,Silk_Reason,Silk_Offset,Silk_Remain,ID,BuyQuantity,OrderNumber,SlipPaper,RegDate) VALUES ( 0,0,0,0,0,0,0,0,'dummy',GETDATE())

Sr Proxy 3.0 Please share

[ryaneichner]

Originally Posted by Isoline*

Introduction:


Hello everyone, these days a solid filter has become a mandatory part rather than a luxurious part of your server, whether its protection, features, control, you name it, every good server uses one.
Honestly, i kept seeing many filters over time, few has last long, even fewer supplied what they claimed.

The main goal of SR_Proxy is to be efficient, light, easy to use, and above all - safe.
Regardless of its ultimate goal, it will also help you to maintain your server ongoing routine easily, all in all - its just gonna make your life easier.

Important Notes:

• SR_Proxy is FREE and always will be.
  
  
• There are many tips and notes and info labels on the UI panel itself it will help you know how and what to do to get all the systems working, use it well.
  
  
• The filter will automatically install the required mssql related database for you, you wont have to install anything, just set your settings & enjoy.
  
  
• If you have any ideas to improve / have feature suggestion / your under attack / have questions - feel free to contact me.
  
  
• The filter is based on a working vSRO v.188 server, if you have messed your server with your edits, dont expect me to fix your server, you have been warned!
  
  

Preview:




Setup / Installation Guide:

 Single Module Installation (1x AgentServer):

1) First you will have to download the latest supported .NET Framework 4.7.2 Runtime from the official Microsoft website - .

If you use a lower version of the .NET Framework, you will experience crashes.
If you dont have .NET Framework at all, the application wont start at all.
Installing or updating .NET Framework requires your machine to be restarted.

2) Next, make sure your server is up and running and all services are green in your SMC, now we can define our MSSQL Settings:



First tab on the right called "Units", fill your MSSQL settings, make sure your DB names are correct and so is your server name, id and password once you are done click "Save Settings" and you can click on "Check" button and it will check if a proper connection can be established.

If your MSSQL connection is remote, specify the IP address of the host, instead of the MSSQL server name in the "Instance Name" field and tick "Remote SQL" Connection".

If you use a custom port for your remote connection, specify the port number in the port field.

Remote SQL Connection is only required if you outsource your server, you dont have to use it with single module architecture.

Once you have confirmed the filter can reach your MSSQL server, click "Save Settings" and then "Restart Filter", after that the filter will restart and install the required MSSQL database called "SRO_VT_PROXY".


3) Lastly, lets move on the the final stage, the IP's and Ports settings on that same tab:




Framework IP & Modules IPs, should match each other and be the primary public IP of your machine, assuming that you are not outsourcing your server.

Public Ports, can be basically anything, you can use whatever ports you want, just make sure that they are properly forwarded (Opened) in your firewall.

Private Ports, are the ports of your inner redirection, or in other words, those who are specified in your .ini files at your certification server.

Once you are done with all of those, make sure your client (Media.pk2) gateway server IP and Ports matches the GatewayServer IP of the filter and of course, the Public GatewayServer port.

Once a proper connection through the filter can be established you will see the connection counters increase or decrease accordingly.


4) Add the missing lines to your Media.pk2/Server_dep/textdata/TextUISystem.txt located at your filter directory to see your custom filter messages.

 A peek into SR_Proxy V2.5.0 Features

This is just a glimpse of the features that SR_Proxy provides, download to take a fresh look on all of its features

• AFK Bubbles:
  If you stay idle in game for a few minutes a bubbles effect will appear on top of your character.
  
  
  
  
• AFK Detector:
  You will have the ability to DC AFK players on Battle Arena, CTF, FW and even restrict AFK players to be rewarded by the silk/h system.
  
  
• Silk per hour:
  An ability to reward players a with silk for each hour they are online.
  You will be able to set restrictions on the system such as minimum required level or afk.
  
  
• MSSQL based logs:
  You will be able to record real-time events such as:
  - All,private,guild,union,gm chats
  - Global Chat
  - Unique Kills
  - Magic Pop win/lose actions
  - Real-time table that holds your current connections
  All of these are useful if you wanna give your players further information on your website!
  
  
• Custom Notices:
  You will be able to send a player or all players a custom notice with a simple insert statement from your db side, all based on real-time.
  
  
• Item Plus Notice:
  You will be able set a minimum plus, from which, a server notice will be seen on their alchemy success actions.
  
  
  
  
  The system will automatically get the real item name & advanced elixir type which is on effect.
  
  
  
  
• Custom Titles Commands:
  You will be able to set your yellow titles by typing !settitle <number>, the system is based on real-time.
  You can get all of your available titles in your server dynamically by typing:
  !gettitles in your "all" chat.
  All real-time, there is no need for a teleport.
  
  
  
  
• Characters Session Lock:
  Players will be able to lock their account
  temporarily if they are playing in an internet cafe nor away from their keyboard, type !lock <4-digit-password> (in your all chat) to lock your character, once locked you wont be able to trade/drop/exchange/stall/move items.
  type !unlock <yourpassword> to unlock your character.
  the lock will be automatically revoked if the character is disconnected.
  
  
  
  
  
• Custom Uniques Reward:
  These days, all servers have str uniques or some other kind of editted unique mobs, with this system you will be able to add an unlimited amount of uniques dynamically with each of its reward value, that the killers will be rewarded once they have slayed them.
  
  
  
  
• Automatic Events: (More Events will be added soon)
  I promised that with SR_Proxy your server routine will be easy to handle!
  Why pay for another Automatic Events program when you can have all-in-one?
  You will be able to run events automatically on your server, those are the list of the available events:
  
  
• Retype Event:
  A notice with a given word will be seen on the entire server, first player to type it wins the event (case sensitive).
  
  
• Trivia Event:
  A notice with a trivia question will be seen on the entire server, first one to reply with the correct answer, wins the event. (All chat)
  
  
• Lucky Staller Event:
  A notice will be seen on the server with instructions to open a stall & when to close it, a lucky winner will be picked.
  
  
• Alchemy Event:
  A notice will be seen on the entire server with a task of achieving a specific plus, first players who completes the alchemy task, wins the event.
  You will be able to control the random pluses ranges.
  
  
• First Type Event:
  A notice with a given word will be seen on the entire server, first player to type it wins the event (not case sensitive).
  
  
• Longest Online Event:
  The system will automatically detect and reward the longest online player on the server.
  
  
• Math Event:
  A notice with a math problem will be seen on the entire server, the first person who writes the correct asnwer (All chat) wins the event.
  
  
• Lottery Event:
  a notice with a registeration period will be seen by the whole server, write /register in your all chat to participate the event, a winner will be randomly picked.
  
  
• Lucky party number Event:
  A notice will be seen on the server with a lucky party number, the player who reaches that pt number wins the event.
  
  
• Uniques Event:
  
  
  
• You will be able to set your own customized unique monsters directly from you database, set a delay for each summon phase, the system will spread the spawns across the spawning area.
  
  
• All of this events has a customizable text files where you can add your own texts, you will also be able to set a timeout for each event round and a reward amount aswell.
  
  
• PC/HWID limit (Premium Only):
  This feature has become a must-have feature on servers to allow a fair game-play.
  You will be able to view all of your connections HWID
  You will be able to set a limit for PCs (HWID) to enter the game a.k.a Server PC limit.
  You will be able to set PC limit on specified regions or states such as:
  - Fortress War PC limit
  - Job Mode PC limit
  - CTF PC limit
  - BA PC limit
  
  
• Protection (Exploits/Flood):
  Needless to say that with SR_Proxy your server is protected!
  All of the exploits are hardcoded in the filter.
  
  Additionally, you will have an advanced packets & bytes per second limitation applied to your incoming connections, and if thats not enough you can even set a broad spectrum of packet processor.
  
  The advanced AI protection system will automatically drop verified legit connections to save system resources, that being said, it will still be able to reacquire the target once an exceptional pattern has been detected, the system automatically "learns" your clients behavior overtime, thus making it easier to detect and handle malicious intentions.
  You will have the ability to determine which action will be taken once a malicious pattern has been found:
  1. Disconnect the client
  2. Ban the client (Firewall)
  
  Packet-based exploits or floods are a thing of the past now!
  
  
• Automatic Databases Backup & Upload (MEGA Drive):
  Data integrity, every server has to make his highest priorities to ensure its data is intact.
  
  You will be able to automatically create a backup of your databases on your specified path.
  You will be able to automatically upload the backup set your created to a remote drive (MEGA Drive)
  All of this will happen behind the scenes while your server runs, you wont need to do anything!
  
  
• Multiple AgentServer Support (Unlimited amount of modules):
  SR_Proxy supports multiple AgentServers (some modifications might be required)
  let the filter do all the hard work regarding networking ;-)
  In a nutshell, you will have 1 asynchronous server that will redirect to all of your AgentModules dynamically and the coolest part? you wont even need to specify each of them, the filter AI system recognize this for you!
  
  
  
  
• Easy Control & Setup:
  Upon first setup, the filter will automatically create your filter db "SRO_VT_PROXY"
  it will add all the required tables/functions/stored procedures for its operation.
  
  You will be able to easily search & filter through your connections, dynamically view their info.
  reward players with Silk/SP/Gold, teleport them.
  You will be able to view or save their latest packet dump (from a specific user) or the entire module.
  You will be able to disconnect / ban a selected connection.
  You can send a notice to a specific player (notice will be seen by him only)
  You can send notice to everyone spawned in the game
  
  
  
  
  
• Field Tested, Stability & Accuracy:
  Stability is a very important thing, without it the server is useless.
  
  With SR_Proxy you wont need an extra computing power for your server machine, it is designed to require as little resources as possible from the machine while utilizing many of the cutting edge computer science optimizations to keep the responsiveness of your server & latency unaffected by the filter.
  
  Furthermore, all pre-released builds will go under a series of stress tests to insure they pass peaks of stress at once & overtime.
  You will have the ability to meticulously inspect & monitor all of your connections with the ease of pressing a button !
  
  The idea of a filter is not difficult to make, but difficult to maintain at a flawless level.
  here we are, handling over 1,000 concurrent players with little or no effort while using a low-end testmachine.
  
  
  
  
  
• Restricted GM commands:
  These days GMs are a very important part of your server community, but trusting someone u dont know? hursh.
  With this feature you will be able to specifically assign GMs commands permission per gm character.
  Get that trustworthy issue off your chest.
  
  [GM]
  AllowedIP=127.0.0.1
  VerifyIPCheck=0
  AllowedCharName16=[GM]SRProxy
  PinkNotice=1
  /invisible=1
  /invincible=1
  /Loadmonster=1
  /Zoe2,Zoe=1
  /mobkill1,mobkill0=1
  /Makeitem=0
  /recalluser=1
  /movetouser=1
  
  
  
  
• Restrict Server Access by Region:
  Running a local server? this feature is meant for you!
  You will be able to set an access to the server by a specified country only.
  All other connections but the specified country will be ignored.
  
  
• Real-Time Currencies:
  These days, every server has its own way of managing its economy, whether it would be coins, golds, silk or anything else.
  
  Many server uses stored procedures to reward their players with their server currency, problem is, it is not real-time and it leads to some weird bugs in the game since the db & server files are not synced.
  
  so basically what we did, is we fixed the silk package update,
  that means that (Points,Gift) silks will update on a real-time base & not just the silk currency.
  
  
  
• Skill disable based on regions:
  Every server has its own set out of agenda or rules to make it a fair game-play, some skills are too weak, some are overpowered.
  
  With this feature ,you will be able to block a specific skill on a variety of in-game positions or states (Battle Arena, CTF, FTW, JOB).
  
  each of these positions will have their own customizable list that will hold your blocked SkillsIDs, all of which can be updated on real-time, you can add or remove skills as you like, how many you like, without any restart to your server.
  
  
• Compatibility:
  The filter is built for vSRO 1.88 only.
  The filter is compatible with any reverse proxies DDoS protection (ex: hyperfilter,CloudFlare tested)
  The filter has a list of "NETCAFE" IPs that you can add, all of those will be exluded from the limitations such as PC/IP limits.
  SR_Proxy Does not interfere with any Bot program (mBot / sBot/ vSRO helper(vietnamese bot)) tested).
  SR_Proxy is not a substitute for a solid DDoS solution.
  All changes made to the filter are real-time based, you wont need to restart the filter for any of the changes you made, only click "Save Settings" button & you're good to go.
  

 A detailed list of SR_Proxy V2.5.0 Features

Version 2.5.0 - Scan:


|
The application is packed & encrypted and there might be some false-positive results, if anybody holds any doubt, i will gladly share a view of the source.

Changelogs:

 V2.5.0 Changelogs:

• Fixed a logic mistake in the plus notice system
• Fixed missing module name in cons was cuased because accessed the dict solved by settings the auto implemetned property directly
• Fixed missing name on rawmodule cons tab, (was not suuporting ag2)
• Recoded the async server now it will support unlimited amount of agentservers, and it will redirect them dynamically
• Fixed a tiny bug in the did not report his hwid block
• Fixed a bug in the regions detetions and the teleport gate detector
• Added FW, Job pc limit implementations.
• sql con type will be chosen according to user settings.
• Added Job,FGW PC limit
• figure out why sometimes there are empty columns in connections tab (CharName16/ProxyModule) mostly, cn16 was caused by in-accurate spawn packet
• Added the missing db tables creation on startup (ThievesStacks), adjusted the _Players table columns accordingly.
• fixed a disable adv on specfici dg exception
• Changed the way the security modules access the auto implemented properties (avoiding key not exists excpetions, while multithreading)
• Fixed a bug in the hwid assign -> multiple ag modules can generate same TokenIDs
• Forced DC() func after ag redirection
• Fixed null exceptions on HWID_COUNT(), CORRESPONGING GW MODULE ASSIGN()
• Added clear button on connections tab
• commented the botsengine sql queries
• add some if contains check in botsengine system, avoding key not exists exceptions.
• Recoded silk_pack related made it and its related stuff async
• Recoded the messages send funcs in UTILS engine
• Fixed the silk msg spam bug, also checked its related stuff, reocded them to be async.
• Fixed a bug while filter results in connections manager
• Realigned the cons tabl columns
• Fixed the right-click dc selected connection menustrip
• Recoded ExportLog(), gracefully handles multi-threaded log writing.
• Fixed a bug in the AG/GW CTRS() missing brackets was causing malfunctions
• Merged the disposed sockets & disposed gw sessions made it more simple, will save some RAM usage.
• Changed if pc limit restriction while adding disp sock/gw on async svr dc() func
• Recoded async server to be double based, the filter will internally redirect to the corrsponding agentmodule
• Recoded the redirection handler, automatically redirecting to corresponding ag modules dynamically, (auto learn nr of ag modules, act acordingly in case of failure)
• Changed auto events, not spawn phases will be spreaded across a square area for each spawn phase
  

 V3.0.0 Changelogs:

• Not released yet

Future Updates / to-do list:

 Future Updates:

• This section will be updated once your suggested features are accepted & added into the to-do list.

Pricing / Donations / Premium (Optional):

• SR_Proxy will always be for free, however, you can show your appreciation by adding the filter logo to your website footer.
  

Get_LastOrderID operation has failed and returned 0

Is bug ?
or its normal ?
how i fix ?

[denise456]

@Isoline*
Bro why disable job reverser Get This erro

Get_RegionID_by_CHARNAME16 operation has failed and returned 0. System.NullReferenceException: Referência de objeto não definida para uma instância de um objeto.
   em SR_PROXY.SQL.Queries.<Get_RegionID_by_CHARNAME16>d__54.MoveNext()

[Isoline*]

Originally Posted by Isoline*

your table is empty so the system cannot get the latest order number

execute this so you will have at least one dummy record:

INSERT " + Settings.MSSQL_ACC_DB + ".dbo.SK_SilkBuyList(UserJID,Silk_Type,Silk_Reason,Silk_Offset,Silk_Remain,ID,BuyQuantity,OrderNumber,SlipPaper,RegDate) VALUES ( 0,0,0,0,0,0,0,0,'dummy',GETDATE())

Originally Posted by ryaneichner

Get_LastOrderID operation has failed and returned 0

Is bug ?
or its normal ?
how i fix ?

You should have read 1 post before that.

Originally Posted by denise456

@Isoline*
Bro why disable job reverser Get This erro

Get_RegionID_by_CHARNAME16 operation has failed and returned 0. System.NullReferenceException: Referência de objeto não definida para uma instância de um objeto.
   em SR_PROXY.SQL.Queries.<Get_RegionID_by_CHARNAME16>d__54.MoveNext()

How about not changing your CharName16 manually from your db while the filter is running, have you thought about that ?

[denise456]

Originally Posted by Isoline*

You should have read 1 post before that.


How about not changing your CharName16 manually from your db while the filter is running, have you thought about that ?

bro why disable job reverse not work my version is 2.5.0.0 the filter have new version?

[XxGhostSpiriTxX]

Can you give bans for HWID? the filter brings it ?

[Isoline*]

Originally Posted by denise456

bro why disable job reverse not work my version is 2.5.0.0 the filter have new version?

Because the packets for CSRO are different lol.

Originally Posted by esteve458

Can you give bans for HWID? the filter brings it ?

Yes, you can.

[zuleidy1201]

isoline you can contribute sleep effect ?

[mylove09]

Sometime Billing Server Is Dead and ShardManager has stopped
If use another Fillter , All ok

I dont sure that someone try to exploit or reason by your filter
I try many time , and result always same

[Isoline*]

Originally Posted by zuleidy1201

isoline you can contribute sleep effect ?

Sure tell me what do you want to know, there are tons of way to implement that.

Originally Posted by mylove09

Sometime Billing Server Is Dead and ShardManager has stopped
If use another Fillter , All ok

I dont sure that someone try to exploit or reason by your filter
I try many time , and result always same

the billing manager has nothing to do with the filter, and no one is trying to exploit you via your billing server.

[Owner Storm]

add silk every hour free

[Isoline*]

Originally Posted by Owner Storm

add silk every hour free

Will be added once i release v3.0.0
Among with some other feartures as well.