GM OJ Status by Command

[dylanwijnen1]

#UPDATED
Fixes:
GMs can do it now to

Working on :
Making the script easyier to use.
first 5 slots in first bag will be changed.




I've had a splended idea about making a GM OJ Status set to max just by using a command.

i thank the following people for helping me:
[Dev]Haox. for his script
Teddybear94
Philipp.
Abrasive for his amazing help with SQL



Guide : Run the Script

Just make sure you have the item in bag 1 and in first slot
now type this in normal chat without /

GMRoll STR40 DEX40 REC40 INT40 WIS40 LUC40 HP40 MP40 SP40 ENCH20
it has to be in the current order else it wont register

 Spoiler

USE [PS_Chatlog]
GO
/****** Object: Trigger [dbo].[Commands] Script Date: 02/19/2013 03:56:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Commands]
ON [PS_Chatlog].[dbo].[ChatLog]
FOR INSERT
AS


-- ********* SHAIYA ALLIANCE ********* --
-- By [Dev]HoaX (c)2011

DECLARE
@NewCraftName CHAR(20),
@STR Char(2),
@DEX Char(2),
@REC Char(2),
@LUC Char(2),
@WIS Char(2),
@INT Char(2),
@HP Char(2),
@MP Char(2),
@SP Char(2),
@ENCH Char(2),
@ChatData varchar(128),
@Char varchar(60),
@row int,
@ChatTime datetime,
@UserUID int,
@UserID varchar(30),
@Admin bit,
@AdminLevel int,
@Status smallint,
@CharID int,
@CharName varchar(30),
@Family tinyint,
@GM tinyint,
@GS tinyint,
@TargetUserUID int,
@TargetUserID varchar(30),
@T_CharID int,
@T_GS tinyint,
@TargetFamily tinyint,
@TargetStatus smallint,
@TargetAdmin bit,
@TargetAdminLevel int,
@dead bit,
@PosX real,
@PosY real,
@PosZ real,
@MapID tinyint,
@user varchar(20),
@IP varchar(17),
@BlockENDDate datetime,
@bantime smallint,
@mhd char(1),
@point int

SELECT @ChatData = ChatData FROM inserted WHERE ChatType = 1


-- Report_player
IF (@ChatData like 'report_player %')
BEGIN
SET @ChatData = substring(@ChatData,15,128)
SET @Char = substring(@ChatData,CHARINDEX(' ', @ChatData)+1,110)
SET @ChatData = substring(@ChatData,1,CHARINDEX(' ', @ChatData)-1)

SET @Row= (SELECT TOP 1 Row FROM inserted)
SET @ChatTime= (SELECT TOP 1 ChatTime FROM inserted)
SET @MapID= (SELECT TOP 1 MapID FROM inserted)
SET @UserUID= (SELECT TOP 1 UserUID FROM inserted)
SET @CharID= (SELECT TOP 1 CharID FROM inserted)
SET @UserID= (SELECT UserID FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @CharName= (SELECT CharName FROM PS_GameData.dbo.Chars WHERE CharID = @CharID)
SET @PosZ= (SELECT Posz CharName FROM PS_GameData.dbo.Chars WHERE CharID = @CharID)
SET @PosX= (SELECT PosX CharName FROM PS_GameData.dbo.Chars WHERE CharID = @CharID)

INSERT INTO PS_ChatLog.dbo.Reported_Players
(UserUID,UserID,CharID,CharName,Map,PosX,PosZ,[Reported Character],Reason,Time)
VALUES
(@UserUID,@UserID,@CharID,@CharName,@MapID,@PosX,@ PosZ,@ChatData,@Char,@ChatTime)
DELETE FROM dbo.ChatLog WHERE Row = @Row
END



-- Adde AP To All 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 (@AdminLevel >= 9)
BEGIN
SET @ChatData = substring(@ChatData,10,20)
SET @point = CONVERT(INT,@ChatData)
UPDATE PS_UserData.dbo.Users_Master
SET point = point+@point
END
END




--GM Reroll
IF (@ChatData LIKE 'GMRoll STR[0-9][0-9] DEX[0-9][0-9] REC[0-9][0-9] INT[0-9][0-9] WIS[0-9][0-9] LUC[0-9][0-9] HP[0-9][0-9] MP[0-9][0-9] SP[0-9][0-9] ENCH[0-9][0-9]')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @CharID= (SELECT TOP 1 CharID FROM inserted)
SET @AdminLevel = (SELECT TOP 1 AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @STR = SUBSTRING (@ChatData,10,12)
SET @DEX = SUBSTRING (@ChatData,16,18)
SET @REC = SUBSTRING (@ChatData,22,24)
SET @INT = SUBSTRING (@ChatData,28,30)
SET @WIS = SUBSTRING (@ChatData,34,36)
SET @LUC = SUBSTRING (@ChatData,40,42)
SET @HP = SUBSTRING (@ChatData,45,47)
SET @MP = SUBSTRING (@ChatData,50,52)
SET @SP = SUBSTRING (@ChatData,55,57)
SET @ENCH = SUBSTRING (@ChatData,62,64)
SET @NewCraftName = @STR + @DEX + @REC + @INT + @WIS + @LUC + @HP + @MP + @SP + @ENCH

IF ((@AdminLevel >= 9))
BEGIN
UPDATE ps_gamedata.dbo.charitems
SET craftname= @NewCraftName
WHERE bag=1 and slot=0 and CharID =@CharID
END
END



-- Promote GM
IF (@ChatData like 'promote %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel= (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Admin = 1) AND (@AdminLevel >= 10))
BEGIN
SET @Char = substring(@ChatData,9,29)

SET @TargetUserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE Charname = @Char)
SET @TargetAdmin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @TargetUserUID)
SET @TargetAdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @TargetUserUID)
SET @TargetStatus = (SELECT [Status] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @TargetUserUID)

-- Überprüfen ob GM Rechte vorhanden sind...
IF ((@TargetStatus = 16) OR (@TargetStatus = 32) OR (@TargetStatus = 48))
BEGIN
-- Kann ein Admin level von über 9 nicht erreichen... Nur über DB änderbar.
IF (@TargetAdminLevel < 9)
BEGIN
UPDATE PS_UserData.dbo.Users_Master SET AdminLevel = (@TargetAdminLevel+1) WHERE UserUID = @TargetUserUID
END
END
END
END



-- Demote GM - Target muss GM sein und kann ein Admin Level unter 0 nicht erreichen...
IF (@ChatData like 'demote %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Admin = 1) AND (@AdminLevel >= 10))
BEGIN
SET @Char = substring(@ChatData,8,25)
SET @TargetUserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharName = @Char)
SET @TargetAdmin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @TargetUserUID)
SET @TargetAdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @TargetUserUID)
SET @TargetStatus = (SELECT [Status] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @TargetUserUID)

IF ((@TargetStatus = 16) OR (@TargetStatus = 32) OR (@TargetStatus = 48))
BEGIN
IF (@TargetAdminLevel > 0)
BEGIN
SET @TargetAdminLevel = (@TargetAdminLevel-1)
UPDATE PS_UserData.dbo.Users_Master SET AdminLevel = @TargetAdminLevel WHERE UserUID = @TargetUserUID
END
END
END
END



-- Full ban command für Admins. Ban für alle Accounts mit gleicher IP + IP Range ban.
IF (@ChatData like 'fullban %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @UserID = (SELECT UserID FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Admin = 1) AND (@AdminLevel >= 10))
BEGIN
SET @Char = substring(@ChatData,9,25)
SET @TargetUserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE Charname = @Char)
SET @TargetUserID = (SELECT UserID FROM PS_UserData.dbo.Users_Master WHERE UserUID = @TargetUserUID)
SET @IP = (SELECT UserIP FROM PS_UserData.dbo.Users_Master WHERE UserUID = @TargetUserUID)

UPDATE PS_UserData.dbo.Users_Master
SET Status = -5
WHERE UserIP = @IP

INSERT INTO [PS_UserData].[dbo].[Users_BlockIpRange]
(IP,[Time],Reason)
VALUES (@IP,getdate(),'Banned by Admin Account: '+@UserID)

INSERT INTO [PS_UserData].[dbo].[Users_BlockLog]
(UserUID,[Status],BlockENDDate,GmID,InsertDate)
VALUES (@TargetUserUID , -9 , '' , @UserID, getdate() )
END
END



-- unban command
IF (@ChatData like 'unban %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
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 >= 9))
BEGIN
SET @Char = substring(@ChatData,7,25)
SET @TargetUserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharName = @Char)

DELETE FROM PS_UserData.dbo.Users_Block WHERE UserUID = @TargetUserUID
UPDATE PS_UserData.dbo.Users_Master
SET status = 0
WHERE UserUID = @TargetUserUID
END
END



-- Make [GSL] (GS-Leader)
IF (@ChatData like 'makegsl %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF (@AdminLevel >= 9)
BEGIN
SET @Char = substring(@ChatData,9,25)
SET @TargetUserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharName = @Char)
UPDATE PS_GameData.dbo.Chars SET GS = 10 WHERE CharName = @Char
UPDATE PS_GameData.dbo.Chars SET CharName = '[GSL]'+@Char WHERE CharName = @Char
END
END



-- Remove [GSL] (GS-Leader)
IF (@ChatData like 'removegsl %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

SET @Char = substring(@ChatData,16,30)
SET @T_GS = (SELECT TOP 1 GS FROM PS_GameData.dbo.Chars WHERE CharName = '[GSL]'+@Char)

IF (@AdminLevel >= 10 AND @T_GS >= 3 )
BEGIN
-- Löschen von 'message to server' aus CharInventar und W-Lager.
SET @T_CharID = (SELECT TOP 1 CharID FROM PS_GameData.dbo.Chars WHERE CharName = '[GSL]'+@Char AND del = 0)
SET @UserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharName = '[GSL]'+@Char AND del = 0)
DELETE FROM PS_GameData.dbo.CharItems WHERE ItemID = 100064 AND CharID = @T_CharID
DELETE FROM PS_GameData.dbo.UserStoredItems WHERE ItemID = 100064 AND UserUID = @UserUID

UPDATE PS_GameData.dbo.Chars SET GS = 0 WHERE CharName = '[GSL]'+@Char
UPDATE PS_GameData.dbo.Chars SET CharName = @Char WHERE CharName = '[GSL]'+@Char
END
END



-- Make [GS]
IF (@ChatData like 'makegs %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @CharID = (SELECT TOP 1 CharID FROM inserted)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @Family = (SELECT Family FROM PS_GameData.dbo.Chars WHERE CharID = @CharID)
SET @GS = (SELECT GS FROM PS_GameData.dbo.Chars WHERE CharID = @CharID)

IF ((@Admin = 1 AND @AdminLevel >= 9) OR (@GS >= 3))
BEGIN
SET @Char = substring(@ChatData,8,20)
SET @TargetFamily = (SELECT TOP 1 Family FROM PS_GameData.dbo.Chars WHERE Charname = @Char)

IF ((@Family <= 1) AND (@TargetFamily <= 1) OR (@Family >= 2) AND (@TargetFamily >= 2) OR (@AdminLevel >= 9))
BEGIN
SET @TargetUserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE Charname = @Char)
UPDATE PS_GameData.dbo.Chars SET GS = 1 WHERE CharName = @Char
UPDATE PS_GameData.dbo.Chars SET CharName = '[GS]'+@Char WHERE CharName = @Char
END
END
END



-- Remove [GS]
IF (@ChatData like 'removegs %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @CharID = (SELECT TOP 1 CharID FROM inserted)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @GS = (SELECT GS FROM PS_GameData.dbo.Chars WHERE CharID = @CharID)

SET @Char = substring(@ChatData,14,30)
SET @T_GS = (SELECT TOP 1 GS FROM PS_GameData.dbo.Chars WHERE CharName = '[GS]'+@Char)

IF ((@GS >= 3 AND @T_GS = 1) OR (@Admin = 1 AND @AdminLevel >= 9 AND @T_GS = 1))
BEGIN
-- Löschen von 'message to server' aus CharInventar und W-Lager
SET @T_CharID = (SELECT TOP 1 CharID FROM PS_GameData.dbo.Chars WHERE CharName = '[GS]'+@Char AND del = 0)
SET @UserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharName = '[GS]'+@Char AND del = 0)
DELETE FROM PS_GameData.dbo.CharItems WHERE ItemID = 100064 AND CharID = @T_CharID
DELETE FROM PS_GameData.dbo.UserStoredItems WHERE ItemID = 100064 AND UserUID = @UserUID

-- GS Status und Tag entfernen --
SET @TargetUserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE Charname = @Char)
UPDATE PS_GameData.dbo.Chars SET GS = 0 WHERE CharName = '[GS]'+@Char
UPDATE PS_GameData.dbo.Chars SET CharName = @Char WHERE CharName = '[GS]'+@Char
END
END



-- Make [GM]
IF (@ChatData like 'makegm %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Admin = 1) AND (@AdminLevel >= 10))
BEGIN
SET @Char = substring(@ChatData,8,29)
SET @TargetUserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE Charname = @Char)
UPDATE PS_GameData.dbo.Chars SET GM = 1 WHERE CharName = @Char
UPDATE PS_GameData.dbo.Chars SET CharName = '[GM]'+@Char WHERE CharName = @Char
UPDATE PS_UserData.dbo.Users_Master SET [Status] = 32 WHERE UserUID = @TargetUserUID
END
END



-- Remove [GM]
IF (@ChatData like 'removegm %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Admin = 1) AND (@AdminLevel >= 10))
BEGIN
SET @Char = substring(@ChatData,14,34)
UPDATE PS_GameData.dbo.Chars SET GM = 0 WHERE CharName = '[GM]'+@Char
UPDATE PS_GameData.dbo.Chars SET CharName = @Char WHERE CharName = '[GM]'+@Char
UPDATE PS_UserData.dbo.Users_Master SET [Status] = 0 WHERE UserUID = @TargetUserUID
END
END



-- Make [A]
IF (@ChatData like 'makea %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Admin = 1) AND (@AdminLevel >= 10))
BEGIN
SET @Char = substring(@ChatData,7,25)
SET @TargetUserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE Charname = @Char)
SET @TargetUserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE Charname = @Char)
UPDATE PS_GameData.dbo.Chars SET GM = 1 WHERE CharName = @Char
UPDATE PS_GameData.dbo.Chars SET CharName = '[A]'+@Char WHERE CharName = @Char
UPDATE PS_UserData.dbo.Users_Master SET [Status] = 16 WHERE UserUID = @TargetUserUID
END
END



-- Remove [A]
IF (@ChatData like 'removea %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Admin = 1) AND (@AdminLevel >= 10))
BEGIN
SET @Char = substring(@ChatData,13,30)
SET @TargetUserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE Charname = @Char)
UPDATE PS_GameData.dbo.Chars SET GM = 0 WHERE CharName = '[A]'+@Char
UPDATE PS_GameData.dbo.Chars SET CharName = @Char WHERE CharName = '[A]'+@Char
UPDATE PS_UserData.dbo.Users_Master SET [Status] = 0 WHERE UserUID = @TargetUserUID
UPDATE PS_UserData.dbo.Users_Master SET [Admin] = 0 WHERE UserUID = @TargetUserUID
UPDATE PS_UserData.dbo.Users_Master SET AdminLevel = 0 WHERE UserUID = @TargetUserUID
END
END


-- Reschar
IF (@ChatData like 'reschar %')
BEGIN
SET @UserUID = (SELECT UserUID FROM inserted WHERE ChatData like 'reschar %')
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Admin = 1) AND (@AdminLevel >= 2))
BEGIN
SET @Char = substring(@ChatData,9,25)
SET @dead = (SELECT TOP 1 Del FROM PS_GameData.dbo.Chars WHERE CharName = @Char)
IF (@dead = 1)
BEGIN
UPDATE PS_GameData.dbo.Chars SET Del = 0 WHERE CharName = @Char
UPDATE PS_GameData.dbo.Chars SET Map = 42 WHERE CharName = @Char
UPDATE PS_GameData.dbo.Chars SET PosX = 50 WHERE CharName = @Char
UPDATE PS_GameData.dbo.Chars SET PosY = 2 WHERE CharName = @Char
UPDATE PS_GameData.dbo.Chars SET Posz = 54 WHERE CharName = @Char
END
END
END


-- delete character
IF (@ChatData like 'delchar %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Admin = 1) AND (@AdminLevel >= 5))
BEGIN
SET @Char = substring(@ChatData,9,26)
UPDATE PS_GameData.dbo.Chars SET Del = 1 WHERE CharName = @Char
END
END


-- disableacc (Account does not exist)
IF (@ChatData like 'disableacc %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Admin = 1) AND (@AdminLevel >= 9))
BEGIN
SET @Char = substring(@ChatData,12,30)
SET @TargetUserUID = (SELECT UserUID FROM PS_GameData.dbo.Chars WHERE CharName = @Char)
UPDATE PS_UserData.dbo.Users_Master
SET leave = 1
WHERE UserUID = @TargetUserUID
END
END


-- enableacc
IF (@ChatData like 'enableacc %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF (@AdminLevel >= 9)
BEGIN
SET @char = substring(@ChatData,11,30)
SET @TargetUserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE Charname = @Char)
UPDATE [PS_UserData].[dbo].[Users_Master]
SET leave = 0
WHERE UserUID = @TargetUserUID
END
END


-- Ban command für GM
IF (@ChatData like 'ban %')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @Status = (SELECT [Status] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Status = 16) OR (@Status = 32))
BEGIN
SET @Char = substring(@ChatData,5,25)
SET @TargetUserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharName = @Char)
UPDATE PS_UserData.dbo.Users_Master
SET status = -9
WHERE UserUID = @TargetUserUID

INSERT INTO [PS_UserData].[dbo].[Users_BlockLog]
(UserUID,Status,BlockENDDate,GmID,InsertDate)
VALUES (@TargetUserUID , -9 , '' , @CharName, getdate() )
END
END


-- tempBan command für GM
IF (@ChatData like 'tempban %')
BEGIN
SET @Char = substring(@ChatData,9,30)

SET @bantime = substring(@Char,CHARINDEX(' ', @Char)+1,1)
SET @mhd = substring(@ChatData,len(@ChatData),1)
SET @Char = substring(@Char,1,CHARINDEX(' ', @Char)-1)

SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @Status = (SELECT [Status] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Status = 16) OR (@Status = 32))
BEGIN
SET @CharID = (SELECT TOP 1 CharID FROM inserted)
SET @CharName = (SELECT CharName FROM PS_GameData.dbo.Chars WHERE CharID = @CharID)
SET @TargetUserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharName = @Char AND del = 0)

-- Default ban by day.
SET @BlockENDDate = DateAdd("d", @bantime, getdate())
IF @mhd = 'm' SET @BlockENDDate = DateAdd("n", @bantime, getdate())
IF @mhd = 'h' SET @BlockENDDate = DateAdd("hh", @bantime, getdate())
IF @mhd = 'd' SET @BlockENDDate = DateAdd("d", @bantime, getdate())

INSERT INTO [PS_UserData].[dbo].[Users_Block]
(UserUID, BlockENDDate)
VALUES (@TargetUserUID, @BlockENDDate)
INSERT INTO [PS_UserData].[dbo].[Users_BlockLog]
(UserUID,[Status],BlockENDDate,GmID,InsertDate)
VALUES (@TargetUserUID , 5 , @BlockENDDate , @CharName, getdate() )

UPDATE PS_UserData.dbo.Users_Master
SET status = 5
WHERE UserUID = @TargetUserUID
END
END


-- Give AP to player
IF (@ChatData like 'addpoints %')
BEGIN
-- Parameter von command entfernen.
SET @Char = substring(@ChatData,11,40)
-- Alle vorderen parameter entfernen.
SET @point = substring(@Char,CHARINDEX(' ', @Char)+1,9)
-- hintere parameter entfernen dass nur noch Character übrig bleibt.
SET @Char = substring(@Char,1,CHARINDEX(' ', @Char)-1)

SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @Admin = (SELECT [Admin] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
SET @AdminLevel = (SELECT AdminLevel FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Admin = 1) AND (@AdminLevel >= 9))
BEGIN
SET @TargetUserUID = (SELECT UserUID FROM PS_GameData.dbo.Chars WHERE CharName = @Char)
UPDATE PS_UserData.dbo.Users_Master
SET point = point+@point
WHERE UserUID = @TargetUserUID
END
END



-- getpoints für GM
IF (@ChatData like 'getpoints')
BEGIN
SET @UserUID = (SELECT TOP 1 UserUID FROM inserted)
SET @Status = (SELECT [Status] FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)

IF ((@Status = 16) OR (@Status = 32))
BEGIN
SET @point = (SELECT point FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
UPDATE PS_UserData.dbo.Users_Master
SET point = 500000
WHERE UserUID = @UserUID
END
END

[nubness]

It's really nice. I'm now thinking that it can be improved a little bit by making it available for players to use it. For example, a player has the GM Reroll Ticket in their inventory, they write the command which checks if they have the GM Reroll Ticket. The Trigger automatically removes the GM Reroll Ticket from the inventory and then adds specific stats to a specific item.

[[ADMIN]Cryptic]

Originally Posted by nubness

It's really nice. I'm now thinking that it can be improved a little bit by making it available for players to use it. For example, a player has the GM Reroll Ticket in their inventory, they write the command which checks if they have the GM Reroll Ticket. The Trigger automatically removes the GM Reroll Ticket from the inventory and then adds specific stats to a specific item.

I imagine that would be something like this:

--GM Reroll
IF (@ChatData like 'GMRoll %')
BEGIN
SET @UserUID =	(SELECT TOP 1 UserUID FROM inserted)
SET @CharID =	(SELECT [CharID] FROM PS_GameData.dbo.Chars WHERE UserUID = @UserUID)
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)


BEGIN
UPDATE ps_gamedata.dbo.charitems
SET craftname= '40404040404040404020'
WHERE ((bag=1 and slot=0 and CharID = @CharID) and (itemid = 'itemid for gm reroll ticket here' and bag = 1 and slot = 1))
END
END

havent tested this yet but what it should do is check if the ticket is in the itemslot next to the item you want to gm reroll and if it is it will reroll it. However im noob with sql compared to most people here so probably an easier way to do it


But what I really wanna know if theres a way to modify it so you set the stats instead of it being set to a static amount. like you type in 'GMRoll 40404000000040000020' and it will give those stats.

[rempieremco153]

My opinion is that GM Rerolls kill a server.
People will get overpowered and PVP will be boring.

THOUGH, for the people that actually want this, it's a really good idea.
Good thinking and Good Luck with coding it further

[dylanwijnen1]

Originally Posted by [ADMIN]Cryptic

havent tested this yet but what it should do is check if the ticket is in the itemslot next to the item you want to gm reroll and if it is it will reroll it. However im noob with sql compared to most people here so probably an easier way to do it


But what I really wanna know if theres a way to modify it so you set the stats instead of it being set to a static amount. like you type in 'GMRoll 40404000000040000020' and it will give those stats.

no it will have to check if the item is there so it will be like in the script it checks if ur an ADM in DB it will have to be like IF ...... 'itemid' BEGIN and then then the script to lazy to type it out for now but yes it will be a great idea to do that and a specific amount i was working on that to tough

[abrasive]

You'd have to specify an offline character name for this to work, as non-stale data for online characters is in memory. If you try to do it to an online character, once they log off the CraftName in the database will be overwritten by data from memory, so your change will have no effect.

[[ADMIN]Cryptic]

didnt even think about that

[Mirror.]

Not sure if it is my Nub side or something, but if this Custom GM Command is to be used should there not be 2? This one would work perfectly fine for Weapons as the CraftName for the [20] Enchantment is the Number 20 but for Gear it is 70 to make the peice of gear [20].

Inserting this CraftName '40404040404040404020' will make it look as if the Gear is [20] but no Absorption is added into the peice of gear. This is just a observation I had while looking at it, let me know if I am not as rusty as I think I am.

Thanks,

Mirror.

[nubness]

Your point is right and I guess what was released here is just a basic example of what you can do. If you want something more advanced, you could work on it by yourself.

[rempieremco153]

Originally Posted by Mirror.

Not sure if it is my Nub side or something, but if this Custom GM Command is to be used should there not be 2? This one would work perfectly fine for Weapons as the CraftName for the [20] Enchantment is the Number 20 but for Gear it is 70 to make the peice of gear [20].

Inserting this CraftName '40404040404040404020' will make it look as if the Gear is [20] but no Absorption is added into the peice of gear.

You could edit the code, so the item id's which start with type 1 to 15, use 20 and the rest 70.
something like
IF (TypeID <= 15) (No idea if TypeID is actually in the column)
SET craftname= '40404040404040404020'
ELSE
SET craftname= '40404040404040404070'

(I suck at making SQL's, so fix the **** yourself)

[ADM]Hyperion

[[ADMIN]Cryptic]

yeah I was talking about custom stats not different enchant hehe. but yeah you should do that anyway.

[abrasive]

You could parse the CraftName from the chat and treat it as an argument like this:

DECLARE @NewCraftName CHAR(20) --CraftNames always have a length of 20


-- Make sure the argument provided is a valid a CraftName string
IF (@ChatData LIKE 'GMRoll [0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
BEGIN
	SET @NewCraftName = SUBSTRING(@ChatData,7,20) -- Parse the CraftName from the chat
	
	-- Make sure character to modify is offline
	-- Check if the item is armor or weapon, or neither
	-- Run update statement to set the CraftName to @NewCraftName
	-- etc...
END

You'd still need to specify a character name so you know who you are trying to modify, as well as an equipment slot (the simplest way I can think of, as opposed to ItemUID, etc) on that character to modify.

[EndComplete]

Originally Posted by rempieremco153

My opinion is that GM Rerolls kill a server.
People will get overpowered and PVP will be boring.

THOUGH, for the people that actually want this, it's a really good idea.
Good thinking and Good Luck with coding it further

I have to agree with the idea that GM rerolls are more of a problem than they are good. Why? Because there are some of us that are only casual players. Those rerolls do get a bit overpowered and tend to drive people away from pvp.

[dylanwijnen1]

The last number at the craft name is the enchant level [20] wich if u change it in the DB it will give u the absorbtion wich it did on my server 0.0 , tough im trying to update the script so u wont have to relogg all the time.

[abrasive]

Originally Posted by dylanwijnen1

The last number at the craft name is the enchant level [20] wich if u change it in the DB it will give u the absorbtion wich it did on my server 0.0 , tough im trying to update the script so u wont have to relogg all the time.

If you don't want to relog, you'd need to update ps_game.exe no? Updating the script wouldn't have any effect on needing to relog or not.