Make account and make it GM

[Cait]

This is how you create an account, the CORRECT way.
Use the dbo.CREATEACCOUNT procedure it is posted by Reimniess.

Spoiler

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[createaccount] 
	@account 	VARCHAR(15),
	@password 	VARCHAR(32)

AS

SET NOCOUNT  ON

DECLARE @DateActivated AS CHAR(8)

IF NOT EXISTS (SELECT account FROM ACCOUNT_TBL WHERE account = @account) BEGIN
	INSERT INTO ACCOUNT_TBL (account, [password], id_no2, isuse, member, realname) 
		VALUES (@account, @password, @password, 'T', 'A', 'F')

	SET @DateActivated =  CONVERT(CHAR(8), GETDATE()-1, 112 ) --Is the date today - 1
	--UPDATE ACCOUNT_TBL_DETAIL SET BlockTime = @DateYesterday WHERE account = @userid		
	--INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
	--	VALUES (@account, 'A000', '2', 'F', GETDATE(), '20990101', '20990101', '20050101', 'O')

	INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
		VALUES (@account, 'A000', '2', 'F', GETDATE(), @DateActivated, '20990101', '20050101', 'O')

END

Execute the SQL and make sure it is executed in the ACCOUNT_DBF databases.

Then go to the procedure and EXECUTE it.

You should see two fields you need to fill. Put in your USERNAME in the first one. MAKE SURE IT IS ALL LOWERCASE.

Then go to here

To view the content, you need to sign in or register

and in the field put in serusadmin.

Then click the md5 button at the bottom and you should get

ef9e8ddbf4e00ffef8991065a3fdef8c

copy and paste that and put it into the password field under your username.

Now press EXECUTE and execute the script, now you should have an account with the password "admin" with no "" around it.

NOTES: serus is the SALT, you need to use this SALT everytime you create an account.
If you want your password to, for example "test" (without "") then encrypt serustest and you get

05ee860e46697c872db9a3dd9c664383

To create an account an admin, run this query.
Make sure servers are down, and change the Character name and Account name.
You need to make the character befor you can be a GM.

Spoiler

/*******Server Needs to be Down for this*******/

USE [CHARACTER_01_DBF]

UPDATE CHARACTER_TBL SET m_chAuthority='Z'
	WHERE m_szName='YourCharaNameHere' and serverindex='01'


USE [ACCOUNT_DBF]

UPDATE ACCOUNT_TBL_DETAIL SET m_chLoginAuthority='Z'
	WHERE account='YourAccount ID here' and gamecode='A000'

/*******Server Needs to be Down for this*******/


/******* Just Enter the Details inside the quotes account='' and mszName=''*******/

Credits to:
Dell Honne (Alot from his guide)
Reimniess (Posting the dbo.CREATEACCOUNT)

---------- Post added at 12:18 PM ---------- Previous post was at 12:11 PM ----------

I havent worked with databases much at all, so I asking for someone who knows if you can make it easier, by in the dbo.CREATEACCOUNT type

USE [ACCOUNT_DBF]
GO

and then be able to run the query from start without go to ACCUNT_DBF, am I right?
And it still shows up in
Databases -> ACCOUNT_DBF -> Programmability -> Stored Procedures -> dbo.createaccount
(as it does for me)

 

[boboytj12]

-.- .... i've seen soo many tutorials on how to create an account..

Gud job though..

 

[Cait]

-.- .... i've seen soo many tutorials on how to create an account..

Gud job though..

Some using a query that in Dell Honne's guide, is not good.
And since still many posts about making a new account with GM power.
Some other uses files to download that sometimes expired.
If i know that you can change the query to "USE [ACCOUNT_DBF]
GO" and ends up in Databases -> ACCOUNT_DBF -> Programmability -> Stored Procedures -> dbo.createaccount, I can make screens so you cant missunderstand.

 

[Dell Honne]

Thats the same query in the file dude.

 

[Cait]

Thats the same query in the file dude.

Yep, but people still have problem to find the file.

 

[Cookiezzz]

Wasn't this posted a long ass time ago? Like exactly the same guide...
/*******Server Needs to be Down for this*******/ -> REMEMBER TO DO ET!
Remember to go to your xampp directory and put your mssql passes in a html file called mypasses.html. Then PM Cookiezzz and link him to file.

 

[langme2009]

lol Server doesn't need to go down to make someone a GM. Just make them a GM, have them relog and done. Anyone who actually does that is lulworthy.

 

[benjaginov]

Create Account :crutch: (if yu cant get other way to work)
make a new query and use ACCOUNT.DBF (((NOT "master"))) if yu use master this will not work same with admin
Where it says "user" enter yur login name that yu wish to use.
for the Password read up on this trend.

Spoiler

USE [ACCOUNT_DBF]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[createaccount]
@account = N'user',
@password = N'pass in md5(serus+pass)'

SELECT 'Return Value' = @return_value

GO

How to test and use an Admin Account:
There is no cali GM commands anymore unless you run a seprate script so the commands like ".cheerpoint" will not work to test the admin here is a list of commands:

To view the content, you need to sign in or register

or yu can download a program called "GM tool": http://forum.ragezone.com/f457/rocknetwork-gm-tool-v5-extended-680060/ ( /ci "Ancient Bow" ) or ( /ci "Champion's Demol Earring" )
<--- if yu create an item with the name yu must use caps and spaces. go to yur propitem.txt to find a list of every item in yur server.
If this helps:
Thank Cait I came to this because of Cait. Thank You Cait.
:amen:

---------- Post added at 07:42 AM ---------- Previous post was at 07:33 AM ----------

lol Server doesn't need to go down to make someone a GM. Just make them a GM, have them relog and done. Anyone who actually does that is lulworthy.

so....what.

thats the original script(i have it), it was writen in there for a reason. Its better to follow like that to avoid making errors.:O:

 

[langme2009]

so....what.

thats the original script(i have it), it was writen in there for a reason. Its better to follow like that to avoid making errors.:O:

There are NO errors when you do it right. Besides, making an Admin Query script is as easy as finding out what account and character has what authority level and changing it with an update query. Then you cna just apply that to the account creation query as well (which will affect all characters made within it). So simple.

 

[Improved]

Some using a query that in Dell Honne's guide, is not good.

Thats the same query in the file dude.

Yep, but people still have problem to find the file.

-.- do you REALLY have to re-make guides on such obvious stuff?

 

[Blaken]

I cant get ether of these to work.... it wont modify the account DB at all...