Bug to create normal account

Hello , i have problem when i create normal account .
When i go to log with this account create , i have this message "wrong account input"
Anyone can help ?

here try this sql query:



INSERT INTO rf_user.dbo.tbl_rfaccount (id,password,accounttype,birthdate)


VALUES ((CONVERT(binary, 'angeizual')), (CONVERT(binary, '123456')),0, '3/06/2013')

Worng nation code for login server I believe I'm having same problem it's
Using tbl_rftestaccount cuz of nation code issue there are fixes
On forum but they don't work for me so idk if they will workfor you

Don't Work Mica17 .
I don't understand demonlord1

ok ty this
INSERT INTO rf_user.dbo.tbl_RFTestAccount (id,password,BCodeTU,Email)


VALUES ((CONVERT(binary, 'test')), (CONVERT(binary, 'test')),0, '3/06/2013')

that will create a account test with pass test
and make sure u do /open in the login server if u can login with this account ur using [RF_User].dbo.tbl_RFTestAccount tbl for accounts which is caused by nation code i belive but i dont know how to fix it

Don't work too :( .

try checking the login log, maybe there's a procedure in your database that's missing

I have find this on dberror RF USER :
0 03/06/13 16:34:19 : Query : { CALL pSelect_AccountPass_China ( 'test2' ) }
1 03/06/13 16:34:19 : SqlState:42000, NativeError:2812 Msg:[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'pSelect_AccountPass_China'.
2 03/06/13 16:34:19 : SQLExecDirect Returns : SQL_ERROR

Can you help me to resolve this ?

try execute this script

Code:

---

USE [RF_USER]
GO

/****** Object:  StoredProcedure [dbo].[pSelect_AccountPass_China]    Script Date: 03/06/2013 22:51:05 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO


CREATE  PROCEDURE [dbo].[pSelect_AccountPass_China]
@id varchar(13)
AS

        DECLARE @curdate        DATETIME
        DECLARE @birthdate        DATETIME
        DECLARE @plusdate        DATETIME
        DECLARE @AgeResult        TINYINT

        SET @curdate = GETDATE()
        SET @birthdate = (SELECT birthdate FROM tbl_rfaccount WHERE ID = CONVERT(BINARY, @id))

        IF(ISDATE(@birthdate) = 1)
        BEGIN
                SET @plusdate = DATEADD(yy, 18, CONVERT(DATETIME, @birthdate))
        END

        IF(ISDATE(@curdate) = 1) AND (@curdate >= @plusdate)
        BEGIN
                SET @AgeResult = 0
        END
        ELSE
        BEGIN
                SET @AgeResult = 1
        END

        SELECT RTRIM( CONVERT( VARCHAR(24), password) ), accounttype, AgeResult= @AgeResult FROM tbl_rfaccount WHERE ID = CONVERT(BINARY, @id)


GO

---

not good "wrong account input"

if youve error like this with nation RU in AccountServer and LoginServer..
Use this
http://forum.ragezone.com/f479/sql-f...cation-909175/


spikey have solve this prob

When i past account server and LoginServer to RU i have login server failure ( my zone server is US )