Login details incorrect after creating account

hey, i always get the error that the login details are incorrect, i dont know why.
i generated a MD5 password with different salts, not even one is working, i checked the Neuz.cpp

analraudiv1, patom and nothing is not working.

any ideas?

should i not have this empty?

Change it in database func too, not only source..

where is it? can u tell me?

Quote:

Originally Posted by iLogix'. hey, i always get the error that the login details are incorrect, i dont know why. i generated a MD5 password with different salts, not even one is working, i checked the Neuz.cpp analraudiv1, patom and nothing is not working. any ideas? Code: void CNeuzApp::HashMD5( char* szResult, LPCTSTR szPWD ) { char szBuffer[256]; char* szKey = ""; #ifdef __INTERNALSERVER switch( LANG_KOR ) #else // __INTERNALSERVER switch( ::GetLanguage() ) #endif // __INTERNALSERVER { case LANG_JAP: szKey = "analraudiv1"; break; case LANG_TWN: szKey = "analraudiv1"; break; case LANG_HK: szKey = "analraudiv1"; break; #ifdef __NO_SUB_LANG case LANG_USA: szKey = "analraudiv1"; break; #else // __NO_SUB_LANG case LANG_ENG: { szKey = "patom"; } break; #endif // __NO_SUB_LANG case LANG_KOR: szKey = "analraudiv1"; break; case LANG_GER: szKey = "analraudiv1"; break; case LANG_SPA: szKey = "analraudiv1"; break; case LANG_POR: szKey = "analraudiv1"; break; case LANG_FRE: szKey = "analraudiv1"; // "gjgusdbfjq" break; case LANG_VTN: szKey = "analraudiv1"; break; case LANG_RUS: szKey = "analraudiv1"; break; } sprintf( szBuffer, "%s%s", szKey, szPWD ); md5( szResult, szBuffer ); } should i not have this empty?

Go to CreatenNewAccount and use this prodezur

USE [ACCOUNT_DBF]
GO
/****** Object: StoredProcedure [dbo].[usp_CreateNewAccount] Script Date: 05/16/2010 20:07:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER proc [dbo].[usp_CreateNewAccount]
@[Only registered and activated users can see links. Click Here To Register...] varchar(32),
@pw varchar(32),
@[Only registered and activated users can see links. Click Here To Register...] int = 0,
@[Only registered and activated users can see links. Click Here To Register...] varchar(100) = ''
as
set nocount on
set xact_abort on

select * from ACCOUNT_TBL where account = @[Only registered and activated users can see links. Click Here To Register...]


begin tran
INSERT ACCOUNT_TBL(account,password,isuse,member,id_no1,i d_no2,realname, cash)
VALUES @[Only registered and activated users can see links. Click Here To Register...], @pw, 'T', 'A', '', @pw, '', @[Only registered and activated users can see links. Click Here To Register...])
INSERT ACCOUNT_TBL_DETAIL(account,gamecode,tester,m_chLog inAuthority,regdate,BlockTime,EndTime,WebTime,isus e,secession, email)
VALUES @[Only registered and activated users can see links. Click Here To Register...],'A000','2','F',GETDATE(),CONVERT(CHAR(8),GETDATE( )-1,112),CONVERT(CHAR(8),DATEADD(year,10,GETDATE()), 112),CONVERT(CHAR(8),GETDATE()-1,112),'T',NULL, @[Only registered and activated users can see links. Click Here To Register...])
insert AccountPlay (Account, PlayDate)
select @[Only registered and activated users can see links. Click Here To Register...], convert(int, convert(char(8), getdate(), 112))

if @@error <> 0
begin
rollback tran
select -1
end
else
begin
commit tran
select 1
end

Quote:

Originally Posted by Katakuris Go to CreatenNewAccount and use this prodezur USE [ACCOUNT_DBF] GO /****** Object: StoredProcedure [dbo].[usp_CreateNewAccount] Script Date: 05/16/2010 20:07:35 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc [dbo].[usp_CreateNewAccount] @[Only registered and activated users can see links. Click Here To Register...] varchar(32), @pw varchar(32), @[Only registered and activated users can see links. Click Here To Register...] int = 0, @[Only registered and activated users can see links. Click Here To Register...] varchar(100) = '' as set nocount on set xact_abort on select * from ACCOUNT_TBL where account = @[Only registered and activated users can see links. Click Here To Register...] begin tran INSERT ACCOUNT_TBL(account,password,isuse,member,id_no1,i d_no2,realname, cash) VALUES @[Only registered and activated users can see links. Click Here To Register...], @pw, 'T', 'A', '', @pw, '', @[Only registered and activated users can see links. Click Here To Register...]) INSERT ACCOUNT_TBL_DETAIL(account,gamecode,tester,m_chLog inAuthority,regdate,BlockTime,EndTime,WebTime,isus e,secession, email) VALUES @[Only registered and activated users can see links. Click Here To Register...],'A000','2','F',GETDATE(),CONVERT(CHAR(8),GETDATE( )-1,112),CONVERT(CHAR(8),DATEADD(year,10,GETDATE()), 112),CONVERT(CHAR(8),GETDATE()-1,112),'T',NULL, @[Only registered and activated users can see links. Click Here To Register...]) insert AccountPlay (Account, PlayDate) select @[Only registered and activated users can see links. Click Here To Register...], convert(int, convert(char(8), getdate(), 112)) if @@error <> 0 begin rollback tran select -1 end else begin commit tran select 1 end

where "createnewaccount" ? if i wanna make it a new query it has some errors in.

EDIT: i found it but it has alot of syntax errors and stuff.

next edit, account seems to be fine, but password issues.

Quote:

Originally Posted by iLogix'. where "createnewaccount" ? if i wanna make it a new query it has some errors in. EDIT: i found it but it has alot of syntax errors and stuff.

You use this script for the database so that the accounts are accepted by flyff.


1. open SQL database and make new query
2. click on the database.
3. then ACCOUNT_DBF.
4. then click programmability
5. then click saved procedures
6. right click on the CreateNewAccount and click the first from the top menü
7. copy pasta this script in the middle window.
8. SQL excute on the red exclamation mark, did you find top left.


Edit: when you create an account, you must put a kikugalanet in front of the password e.g. if your password is test123, you must convert this to kikugalanettest123 and encrypt this to MD5.

the MD5 would be e.g. e07bba0ec8a36844b09d8e2b942634e1

Msg 102, Level 15, State 1, Procedure usp_CreateNewAccount, Line 22
Falsche Syntax in der Nähe von 'd_no2'.
Msg 102, Level 15, State 1, Procedure usp_CreateNewAccount, Line 24
Falsche Syntax in der Nähe von 'inAuthority'.


getting syntax problems when trying to use yours.

EDIT: well i see i have this script in already, i only have password problems it seems. i always get 5min ban for logging in with wrong account

Quote:

Originally Posted by iLogix'. Msg 102, Level 15, State 1, Procedure usp_CreateNewAccount, Line 22 Falsche Syntax in der Nähe von 'd_no2'. Msg 102, Level 15, State 1, Procedure usp_CreateNewAccount, Line 24 Falsche Syntax in der Nähe von 'inAuthority'. getting syntax problems when trying to use yours. EDIT: well i see i have this script in already, i only have password problems it seems. i always get 5min ban for logging in with wrong account

it is possible that you get errors displayed, you can ignore this as long as the script is executed.

Give me your script, what do you use for creating an account.

Ok my only problem now is this:

when i enter the world, everything else is working.

Quote:

Originally Posted by iLogix'. Ok my only problem now is this: Code: Wed Feb 26 12:43:26 2020 0 - CERT_CONNECTED Wed Feb 26 12:43:26 2020 2 - CERT_SRVR_LIST Wed Feb 26 12:43:27 2020 4 - LOGIN_CONNECTED Wed Feb 26 12:43:27 2020 8 - LOGIN_CACHE_ADDR Wed Feb 26 12:43:27 2020 15 - CERT_DISCONNECT network error:64 Wed Feb 26 12:43:28 2020 6 - LOGIN_PLAYER_LIST Wed Feb 26 12:43:29 2020 9 - CACHE_CONNECTED Wed Feb 26 12:43:30 2020 11 - LOGIN_REQ_PREJOIN Wed Feb 26 12:43:30 2020 12 - LOGIN_ACK_PREJOIN when i enter the world, everything else is working.

Only this, is nice :P there are 1000 of Prejoin Errors.
Did you have any other lock? Try to use MSSQL Profiler and check your database problem. Its not the salt.