[Guide]How to make GM Accounts

GM Accounts
UP2

Code:

---

DECLARE @RC int
DECLARE @id varchar(13)
DECLARE @pw varchar(13)
DECLARE @depart varchar(32)
DECLARE @class varchar(12)
DECLARE @name varchar(12)
DECLARE @birthday varchar(10)
DECLARE @grade int
DECLARE @subgrade int
SELECT @id = 'your login'
SELECT @pw = 'youre password'
SELECT @depart = 'none'
SELECT @class = 'GM'
SELECT @name = 'name'
SELECT @birthday = 'None'
SELECT @grade = 2
SELECT @subgrade = 4
EXEC @RC = [rf_account].[dbo].[pInsert_Staff] @id, @pw, @depart, @class, @name, @birthday, @grade, @subgrade
DECLARE @PrnLine nvarchar(4000)
PRINT 'Stored Procedure: rf_account.dbo.pInsert_Staff'
SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)
PRINT @PrnLine

---

UP5,6 and 2.2.1, 2.2.2

Code:

---

DECLARE @RC int
DECLARE @id varchar(13)
DECLARE @pw varchar(13)
DECLARE @depart varchar(32)
DECLARE @class varchar(12)
DECLARE @name varchar(12)
DECLARE @birthday varchar(10)
DECLARE @grade int
DECLARE @subgrade int
SELECT @id = 'your login'
SELECT @pw = 'youre password'
SELECT @depart = 'none'
SELECT @class = 'GM'
SELECT @name = 'name'
SELECT @birthday = 'None'
SELECT @grade = 2
SELECT @subgrade = 4
EXEC @RC = [RF_User].[dbo].[pInsert_Staff] @id, @pw, @depart, @class, @name, @birthday, @grade, @subgrade
DECLARE @PrnLine nvarchar(4000)
PRINT 'Stored Procedure: RF_User.dbo.pInsert_Staff'
SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)
PRINT @PrnLine

---

2.2.3 BSB

Code:

---

DECLARE @RC int   
DECLARE @id varchar(13)   
DECLARE @pw varchar(13)   
DECLARE @depart varchar(32)   
DECLARE @class varchar(12)   
DECLARE @name varchar(12)   
DECLARE @birthday varchar(10)   
DECLARE @grade int   
DECLARE @subgrade int   
SELECT @id = 'Youre Login'   
SELECT @pw = 'Youre Password'   
SELECT @depart = 'none'   
SELECT @class = 'GM'   
SELECT @name = 'name'   
SELECT @birthday = 'None'   
SELECT @grade = 2   
SELECT @subgrade = 4   
EXEC @RC = [rf_user].[dbo].[pInsert_Staff] @id, @pw, @depart, @class, @name, @birthday, @grade, @subgrade   
DECLARE @PrnLine nvarchar(4000)   
PRINT 'Stored Procedure: rf_user.dbo.pInsert_Staff'   
SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)

---

Important

Before, we used 2,4, all the time, and were happy:p , but with the 2.2.3 the situation has changed a bit
2 4 - with this ACC, you can write in the GM chat, but can't use commands such as% lv% * @ ^, etc.
4 4 - Can do everything, but can't write in the GM chat
2 3 - Same as 2 4
255 255 - same as 4 4, but players can loot gm things

hey im wondering if u could add the GM account for EP2P1 Update 5 server .___. because ive tried every single one of those and it doesnt work xD

ty ^^

I dunno, it worked for me :p

Hey, is there anything I'm missing. Or every GM command for 255 grade GM doesnt work at all. I am always receiving error(authority)

Is there a way to fix it ?

check zoneserver

---------- Post added at 12:01 PM ---------- Previous post was at 11:15 AM ----------

check zoneserver

any idea why in giga 4 ep 2 server i cant use ! for notice chat, i tried different grade combinations (2,4, 4,4, 255 etc)

well the correct GM code for notice would be DEV 44, pink GM is 24 so yeah if 44 doesn't work then its your client.

grade4 subgrade 4? what about the dev field?

doesnt matter. ive never found it to do anything in g4 ep2

Midnite123, Do u have a Rose online PVP server?

when u have it?

are you looking GM's for ur server?

Regards,

Mitch

different is

"SELECT @grade = 2
SELECT @subgrade = 4" > >> GM Player

if user player

"SELECT @grade = 0
SELECT @subgrade = 0" >>>Player only

its rights??????

NO, player go in rfaccount and GMs go in staffaccount. And for players you need (id,pass,email,birthdate).

wohooooooo
keep share baltais...

why %start holy still Error(Authority) in 24 grade and Fail (Grammar or Logic) in 44 grade..??

tried with 255|255 ?
I dont know excactly ...