PSM_Agent

[GM Wifo]

Hello everyone,

I’ve created this GitHub repository to share open‑source work.
This space will include meaningful developments, experiments, and other projects that I want to make available to the community.

My goal is to document progress, share code, and provide resources that others may find useful or inspiring.


SecureTech CLR Command Procedure
This project provides a SQL Server CLR stored procedure that acts as a secure bridge between SQL Server and the Shaiya game server.

It enables administrators to send server commands directly from SQL while enforcing strict validation, logging, and security controls.

Environment
Windows
Visual Studio 2026
.NET Framework 4.8.1
C#


AgentProcedures.cs
*Entry point for SQL Server.

Exposes RunServiceCommand as a SQL CLR procedure
Receives parameters from SQL
Calls CommandExecutor
Sends output back via SqlPipe

CommandExecutor.cs
*Core execution logic.

Validates the command via CommandRules
Enforces rate limits via RequestThrottle
Builds the packet via PacketFactory
Sends it to ps_game via socket
Logs the result via ActivityLogger
Uses centralized constants (BufferSize, Host, Port) from ServiceConfig

CommandRules.cs
*Ensures commands are safe.

Checks format and length
Requires that all commands start with /
Throws exceptions for invalid input
Uses ServiceConfig.MaxCommandLength for length validation

ActivityLogger.cs
*Handles logging of command attempts.

Appends success or error entries to the log file
Records timestamp, service, command, and error message
Uses ServiceConfig.LogFilePath for centralized log location

PacketFactory.cs
*Constructs the binary packet to send to ps_game.

Uses fixed header size and marker from ServiceConfig
Combines header, service name, and command text
Produces correct byte structure

RequestThrottle.cs
*Prevents flooding.

Reads the last log entry timestamp from ServiceConfig.LogFilePath
Blocks if a new command is issued within ServiceConfig.MinIntervalSeconds

SocketHelper.cs
*Handles socket communication.

Connects to ServiceConfig.Host:ServiceConfig.Port
Sends packet data
Receives server response

ServiceConfig.cs
*Centralized configuration.

Host, Port, HeaderSize, HeaderMarker
MaxCommandLength
BufferSize
LogFilePath (combines directory + filename)
MinIntervalSeconds

ErrorHandler.cs
*Standardized error formatting.

Produces consistent error strings for logging and SQL output

Utilities.cs
*Helper methods.

Timestamp formatting
String checks and other small utilities

[[DEV]Elessar]

Why are you reposting topics from 10 years ago?

[GM Wifo]

Originally Posted by [DEV]Elessar

Why are you reposting topics from 10 years ago?

I didn’t repost the topic because my release was described as open source, while Betalfa’s topic focused only on DLLs and databases. I replicated the other functions so that the scripts and procedures from other developers would still work. Developers can also change the @cmmd and @servicename values to help prevent SQL Server hacking. In addition, I included built‑in security features in my release.

[[DEV]Elessar]

That topic already has source code?

[GM Wifo]

I’ve organized the context and attached the

PSM_Agent.rar

so you can download them directly here. If you notice any problems, please leave a comment so I can fix them. Thank you!