[Guide]How to make GM Accounts

[baltais99]

GM Accounts
UP2

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

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

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 = [COLOR="Magenta"]2[/COLOR]     
SELECT @subgrade = [COLOR="Cyan"]4[/COLOR]     
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 , 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

 

[Deadmax]

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 ^^

 

[baltais99]

I dunno, it worked for me

 

[Andrix9743]

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 ?

 

[baltais99]

check zoneserver

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

check zoneserver

 

[lifestream]

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)

 

[Midnite123]

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.

 

[lifestream]

grade4 subgrade 4? what about the dev field?

 

[Midnite123]

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

 

[mangoking]

Midnite123, Do u have a Rose online PVP server?

when u have it?

are you looking GM's for ur server?

Regards,

Mitch

 

[chepotjr]

different is

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

if user player

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

its rights??????

 

[baltais99]

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

 

[fajun]

wohooooooo
keep share baltais...

 

[flames0fhell]

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

 

[CromAr]

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

 

[flames0fhell]

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

no it doesn't work too...

mmmmm maybe in 2.2.3 it doesn't work?

 

[jm_lapido]

Yes, it wont work because you need to have the stored procedure (rf_account.dbo.pInsert_Staff)

 

[papawhisky]

tanks for sharing this very nice guide

 

[jenzeil]

@baltais

sir can u help me to make a 24/7 rf online private server?

 

[aroudika]

in this sql execute successfully, but the game login account is always wrong. how is this?