[help]Create Account .

[kobilan]

Hello

i open anew v15 private server with the official server files ..
i follow this guid http://forum.ragezone.com/f457/flyff...repack-658914/

the server is ON and its online -.-
but how the hell i create account to log into the game ? ..
i mean when i try to log in its say login incorrect ... thats mean server is up .. please help me or give me quick quide about open new account ... =/// ty forhelpp

[MentaL]

[Cait]

Creating An Account

This is how you create an account, the CORRECT way.

Find the dbo.CREATEACCOUNT procedure in the release section, it is posted by Reimniess.
DO NOT USE the dbo.ASP.createaccount OR ANYTHING like that, they DO NOT WORK!

Execute the SQL you get from his post 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 MD5 GENERATOR 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.

Hopefully this will be the LAST time i have to post about making an account since it is VERY VERY easy to make an account.

NOTES: serus is the SALT, you need to use this SALT everytime you create an account, i don't know what a SALT is nor do i really care, all i know is that you MUST use this SALT to make your account work. Or ASK SERUS to remove the salt from the neuz.exe or do it yourself.

PS: The CAPS are used only so that it becomes more clear, I'm neither flaming or yelling XD


To create an account an admin, run this query.

Admin Query

I found this:

CreateAccount Function by Reim (If you don't already have it):

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

[kobilan]

Thanks i create account but how i make aGM?

[Cait]

Thanks i create account but how i make aGM?

To create an account an admin, run this query.

Admin Query

[kobilan]

thanks i did it ... where i can find gm commands?..

[Cait]

thanks i did it ... where i can find gm commands?..

This file.

[kobilan]

The link is not work ;/

[Cait]

The link is not work ;/

Here then: http://rapidshare.com/files/425221540/Commands.html