Скачать или смотреть How to: Make Flyff server With Official v15 Files (Part 5/5)!!!!!!!!!!!

creating account guide:

first: Open mssq express managament studio
2. Click: New querry
3: Select: ACCOUNT_DBF (not master)
4: copy this querry:
_________________________________________________________________

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
_________________________________________________________________
5: Click Execute, when it finish restart MSSQL, don't need to save querry.
6: now click on New querry again and select: ACCOUNT_DBF.
7: paste this querry:
_________________________________________________________________

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
_________________________________________________________________
where it say 'here put YourUsername', put your account name.
'pass in md5(serus+pass)', here put your password . hash for the files = serus.

so if you want to make a password, go to any md5 generator and generate it, the password will be serus+password, for example if you want password: test
you have to put before serus (serustest) then click generate and your password in flyff will be test.

MD5 generator: http://www.adamek.biz/md5-generator.php

Credits.:
Querry: Ragezone
Guide by kenzy