Making An Account in v15?

[Ciell]

Delete this please.

[MentaL]

[TheWordless]

OMG NOOB!!!!!!!!!!!!!!!!!!!!!
Post it in the right section..

Naah im just kidding, at least you notice it, no worries, just had to troll on that part.

Anyways on topic: I have no idea on how to fix it, i never had that problem, try setting up a webpage with jsut an register script and use that.

[PapaAmericano]

cielle want to merge up with me?

[Detox]

I assume you got the help you needed in the help section.

If you edit your post you're able to close the thread. I'd suggest you to do so.

[rebora2007]

i've already cleared this up for you ..

[Creeps]

Hi, I followed Dell Honne's tutorial on making a server and got one up and running, and even logged in with a test account named like Zackx or something... but anyway, I found a tutorial on making your own account via ACCOUNT_DBF > Programmability > Stored Procedures > dbo.CreateNewAccount so I do all that but I get...

Msg 2601, Level 14, State 1, Procedure usp_CreateNewAccount, Line 15
Cannot insert duplicate key row in object 'dbo.ACCOUNT_TBL' with unique index 'ACCOUNT_ID1'.

So whats another way to make a v15 account? Or how can I fix that error? Thanks

---------- Post added at 09:45 PM ---------- Previous post was at 09:33 PM ----------

Wow... how did I put this in the wrong section...

I was looking at Flyff Help and this was meant for that, sorry :l

i already did that but i just dont work




1: 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')

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.



NOTE:I didn't do this, all credits to Tempacy from youtube (i think this query is from there too