|
You last visited: Today at 21:38
Advertisement
[Request] Script for working GM commands ( basicly for banning player)
Discussion on [Request] Script for working GM commands ( basicly for banning player) within the Shaiya Private Server forum part of the Shaiya category.
10/07/2012, 17:58
|
#1
|
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,627
|
[Request] Script for working GM commands ( basicly for banning player)
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!
|
|
|
10/07/2012, 21:30
|
#2
|
elite*gold: 0
Join Date: Jan 2011
Posts: 238
Received Thanks: 901
|
Have you tried
|
|
|
10/07/2012, 23:19
|
#3
|
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,627
|
yh thats what i tried omega :/ didnt worked anyhow..
|
|
|
10/08/2012, 00:52
|
#4
|
elite*gold: 5
Join Date: Jun 2012
Posts: 176
Received Thanks: 214
|
i Search it too :/
|
|
|
10/08/2012, 01:01
|
#5
|
elite*gold: 0
Join Date: Sep 2012
Posts: 60
Received Thanks: 28
|
-- 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.
|
|
|
10/08/2012, 15:48
|
#6
|
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,627
|
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"
|
|
|
10/08/2012, 20:45
|
#7
|
elite*gold: 0
Join Date: Jun 2011
Posts: 345
Received Thanks: 241
|
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...
|
|
|
07/04/2013, 10:50
|
#8
|
elite*gold: 0
Join Date: Oct 2012
Posts: 173
Received Thanks: 28
|
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? ???
|
|
|
07/04/2013, 11:23
|
#9
|
elite*gold: 0
Join Date: Jul 2012
Posts: 312
Received Thanks: 285
|
you can do it in game /kick [player-name]
|
|
|
|
Similar Threads
|
[Error] vSRO Banning Not Working
10/20/2011 - SRO Private Server - 1 Replies
server cord established : 10 (5.1.74.130:15881)
Query Error!!! Query Result : -1, Query : EXEC _RegisterPunishment 745544,1,'sro_gm2',64,'','','','','','2011-10-13 02:45:10','2011-10-13 02:45:08','2111-10-13 02:45:08','2011-10-13 02:40:57'
SQL Error State:42S02, Native Error Code: D0, ODBC Error: Invalid object name 'sr_member1'.
EXEC _RegisterPunishment 745544,1,'sro_gm2',64,'','','','','','2011-10-13 02:45:10','2011-10-13 02:45:08','2111-10-13 02:45:08','2011-10-13 02:40:57'
I take it...
|
Player commands help
09/19/2010 - CO2 Private Server - 6 Replies
yo i wanna giv normal player commands like /scroll and /job how do i do tha pls anyone tell me i will hit thanks button
|
REQUEST POST 4 a SCRIPT or PLAYER temp.
10/07/2009 - Grand Chase Philippines - 6 Replies
POST here please
|
1st tym but working.... script and player templates
10/07/2009 - Grand Chase Philippines - 2 Replies
READ THE POST UNDER BEFORE DOWNLOADING
Script.kom : Download script.kom from Sendspace.com - send big files the easy way
PlayerTemplates.kom : Domain wurde soeben registriert
ByPass : Create a Shortcut of Main.exe in the desktop then right click and go to properties. After that copy this>>>>>"C:\Program Files\Level Up! Games\Grand Chase PH\main.exe"(Space)__kogstudios_original_serv ice__ and paste it in the Target
:mofo:give comment if its not working:mofo:
My grandchase has MP HACK HP...
|
[Request] Need an 100% working Teleporter Script
03/18/2009 - EO PServer Hosting - 5 Replies
Hello all,
i need badly an 100% working Teleporter script ( with ElephantHill and Arena)
Thanks !
|
All times are GMT +2. The time now is 21:38.
|
|