[Request] Script for working GM commands ( basicly for banning player)

[TeddyBear94]

Hey guys as the title says im lookign for a WORKING script to fix my bugged GM commands such as the Bann Command! ( like BanT for 24h bann and BanP for perm bann)
i did used the search function and found a script but that script didnt helped me so i was wondering of some1 ese could help me out with that!
thanks in advance!

[ShaiyaOmega]

Have you tried

[TeddyBear94]

yh thats what i tried omega :/ didnt worked anyhow..

[..Zeus..]

i Search it too :/

[retrogod]

 Spoiler

-- snip --

SELECT @UserUID=UserUID FROM inserted
SELECT @auth=Status FROM PS_UserData.dbo.Users_Master WHERE @UserUID=UserUID

IF (@auth = 16)
SELECT @ChatData=ChatData from inserted
SELECT * INTO #tmptable FROM dbo.split(@ChatData,' ')
SELECT @cmd=value FROM #tmptable where idx=0
BEGIN
IF (@cmd='\ban')
BEGIN
UPDATE um SET status=-5 FROM PS_UserData.dbo.Users_Master AS um
INNER JOIN PS_GameData.dbo.Chars AS c
ON um.UserUID=c.UserUID
INNER JOIN #tmptable AS tt on
c.CharName=tt.value
END
DROP TABLE #tmptable
END

credits go to abrasive
ps. works for me might work for you guys too.

[TeddyBear94]

Msg 137, Level 15, State 1, Line 3
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 1, Line 4
Must declare the scalar variable "@auth".
Msg 137, Level 15, State 2, Line 6
Must declare the scalar variable "@auth".
Msg 137, Level 15, State 1, Line 7
Must declare the scalar variable "@ChatData".
Msg 137, Level 15, State 2, Line 8
Must declare the scalar variable "@ChatData".
Msg 137, Level 15, State 1, Line 9
Must declare the scalar variable "@cmd".
Msg 137, Level 15, State 2, Line 11
Must declare the scalar variable "@cmd".

"Quiery completed with errors"

[hootzoo]

use these take out every thing but the ban commands and change the % to -ban just cant be be / after that change it from [Commands] to Chat like

USE [PS_ChatLog]
GO
/****** Object: Trigger [dbo].[Commands] Script Date: 09/01/2011 17:48:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[Commands] to [Chat]
ON [PS_ChatLog].[dbo].[ChatLog]
FOR INSERT
AS

and

-- Adde AP zu allen Accounts...
IF (@ChatData like 'addapall %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted WHERE ChatData like 'addapall %')
SET @Admin = (SELECT TOP 1 [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT TOP 1 AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Admin = 1) AND (@AdminLevel >= 10))

change adminlevel from IF ((@Admin = 1) AND (@AdminLevel >= 10)) to 16 or 32 ect

then just run ether 2 querys and whats been done?

ban works just kick after
only staff can use
and REMEMBER 16 admin and 32 GM

do this and its fixed and problems pm me on skype and ill send you mine...

[nick4ever]

Hi everybody , can i just send kick command from SQL server to kick a gamer ? Or i just can do that via commandline of PSM_ServerMgnt? ???

[andr3y_you96]

you can do it in game /kick [player-name]