Instead of using too many things just add a trigger to dbo.Users_Master AFTER UPDATE and check if status is -5 via IF UPDATE(Status). If true make it kick the acc/player and all in all thats it.
[RELEASE]Call PSMagent Commands via sql 02/22/2022 - Shaiya PServer Guides & Releases - 32 Replies Hello guys this tutorial is from call this commands http://www.elitepvpers.com/forum/shaiya-pserver-de velopment/2496677-server-commands-game.html via sql code
1-Put the PSMagent inside C:\ShaiyaServer\SERVER\PSM_Client\PSMagent.dll
2-
--You need to set up your environment to handle the CLR:
--allow you to use it run this:
ALTER DATABASE OMG_GameWEB SET TRUSTWORTHY ON;
About Call PSMagent via SQL 10/30/2019 - Shaiya PServer Development - 2 Replies Hello,
I use Alex's script (bad word filter).
I have already do this tutorial and when i try to execute this
USE
GO
DECLARE ReTuRn_value int
EXEC ReTuRn_value = .
serviceName = N'ps_game',
...' line there, will return many results, not just one.
