- Joined
- Jul 2, 2012
- Messages
- 790
- Reaction score
- 125
Ok I spent over 3 hours inputting some GM account but I have found a easy way to do it, here the input i wrote.
userid = your account id
rid = your character role id
after you input this restart either mssql/mysql(linux) or both and if that don't work restart your computer its will work. GM will be infront of your character name.
-------
OR
-------
OzzyGT's GM Query
remove GM
Video tutorial on adding GM
Credit: Kev, OzzyGT and whoever that made the gm script.
Code:
Insert Into auth
(userid,zoneid,rid)
Values
(1,904,1)
rid = your character role id
after you input this restart either mssql/mysql(linux) or both and if that don't work restart your computer its will work. GM will be infront of your character name.
-------
OR
-------
OzzyGT's GM Query
Code:
USE [PassportBOIOLD] <----- input your database name
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[addGM]
@name varchar(64) = NULL
AS
BEGIN
DECLARE @id int
DECLARE @rid int = 0
BEGIN TRAN
SELECT @id=id FROM account WHERE name = @name
IF (@id IS NOT NULL)
BEGIN
WHILE (@rid < 12)
BEGIN
INSERT INTO auth VALUES (@id,904,@rid)
SET @rid = @rid + 1
END
SET @rid = 100;
WHILE (@rid < 106)
BEGIN
INSERT INTO auth VALUES (@id,904,@rid)
SET @rid = @rid + 1
END
SET @rid = 200;
WHILE (@rid < 215)
BEGIN
INSERT INTO auth VALUES (@id,904,@rid)
SET @rid = @rid + 1
END
SET @rid = 500;
WHILE (@rid < 519)
BEGIN
INSERT INTO auth VALUES (@id,904,@rid)
SET @rid = @rid + 1
END
UPDATE account SET usertype = 131072 WHERE id = @id
END
COMMIT TRAN
END
GO
remove GM
Code:
USE [PassportBOIOLD]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[removeGM]
@name varchar(64) = null
AS
BEGIN
DECLARE @id int
BEGIN TRAN
SELECT @id=id FROM account WHERE name = @name
IF (@id IS NOT NULL)
BEGIN
DELETE FROM auth WHERE userid = @id
UPDATE account SET usertype = 0 WHERE id = @id
END
COMMIT TRAN
END
GO
Just put them in a new query windows and execute them, aftewards you can use this to add or remove a GM:
EXEC addGM 'username'
EXEC removeGM 'username'
Video tutorial on adding GM
You must be registered to see links
You must be registered to see links
Credit: Kev, OzzyGT and whoever that made the gm script.
Attachments
You must be registered for see attachments list
Last edited: