I got my server running, set my ip to 127.0.0.1 and port to 15400 inside the .exe. One thing I can't do is, I don't know how to register. Please explain me how to register an account, I want to get inside the game. Thank you
Printable View
I got my server running, set my ip to 127.0.0.1 and port to 15400 inside the .exe. One thing I can't do is, I don't know how to register. Please explain me how to register an account, I want to get inside the game. Thank you
well, that is ACCOUNT_TBL open it, go to programmability and than to stored procedures. look for createaccount or something like that. fill it, in and done.
Well heres the guide where i learned how to make accounts:
"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: MD5 generator - Calculate MD5 for the typed string."
credits to : Tenpacy
Tenpacy = cKenzy at ragezone ^^
OT:
Let me make this easier for you.
1) Copy this code and execute it in your mssql:
Spoiler:
Credit for the code:
TheJacob I guess '.'
2) Go find your dbo.createaccount and right click and then click on execute stored procedure.
account: "your acc name"
pass: go to step 3)
3)
Go to this site "click me" and type your md5 code e.x. kikugalanet"pass here" without the " ". Copy the code u get into the pass tab in your mssql and click "OK", and u are done.
:):
i get login details incorrect i followed this step