Add GM Battle of the Immortals

How to add GM
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.

Insert Into auth
(userid,zoneid,rid)
Values
(1,904,1)

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

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

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'

NanayaQ
Ragezone

Private Server

Pages

Add GM Battle of the Immortals