Server Verification Error

[CheezSmith]

Hello Elitepvers I need your help to fix my problem .
i want to ask how i can fix this Server Verification Error Own my Server




Response on my Thread Please !
Please Help me !

Thankyou !

[xTwiLightx]

Looks like you have some problems with the database.


Check your CQuery-LogFile, it should state something with "LOGIN_STR".

[CheezSmith]

Originally Posted by xTwiLightx

Looks like you have some problems with the database.


Check your CQuery-LogFile, it should state something with "LOGIN_STR".

2015/09/22 01:16:16
query:LOGIN_STR ?, ?, ?, ?
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near 'LOGIN_STR'.
2015/09/22 01:20:46
query:LOGIN_STR ?, ?, ?, ?
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near 'LOGIN_STR'.
2015/09/22 01:23:24
query:LOGIN_STR ?, ?, ?, ?
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near 'LOGIN_STR'.
2015/09/22 01:23:26
query:LOGIN_STR ?, ?, ?, ?
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near 'LOGIN_STR'.
2015/09/22 01:23:47
query:LOGIN_STR ?, ?, ?, ?
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near 'LOGIN_STR'.
2015/09/22 01:30:31
query:LOGIN_STR ?, ?, ?, ?
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near 'LOGIN_STR'.

What i need to do ?? Please Help me !

Thankyou !

[xTwiLightx]

Show us the code of your LOGIN_STR (from SQL Server Management Studio).

[CheezSmith]

i dont have use any code of LOGIN_STR

can you help me too fix my This Problem Please !

See here This is Database is Use :

Thankyou !

[xTwiLightx]

We can't really analyse with no code.

If you can't get how to view your stored procedures in SQL Management Studio, we can't help you out.

[CheezSmith]

i see it on my LOGIN_STR

 Spoiler

USE [ACCOUNT_DBF]
GO
/****** Object: StoredProcedure [dbo].[LOGIN_STR] Script Date: 09/22/2015 02:37:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[LOGIN_STR]
@iaccount VARCHAR(32),
@ipassword char(32)
-- Ver. 14 PCZoneIP
,@i_IPAddress varchar(15) = '0.0.0.0'
/************************************************** *********************************
************************************************** *********************************
************************************************** *********************************
************************************************** *********************************



ACCOUNT_STR ????
??? : ???
??? : 2004.01.18

ex) ACCOUNT_STR 'beat','1234'
SELECT * FROM ACCOUNT_TBL_DETAIL WHERE account='aeonsoft'

************************************************** *********************************
************************************************** *********************************
************************************************** *********************************
************************************************** *********************************/
AS
set nocount on

-- Ver 14. PCZoneIP_Check
declare @o_Grade tinyint
exec dbo.USP_PCZoneIP_Check @i_IPAddress, @o_Grade output

IF EXISTS(SELECT a.account FROM ACCOUNT_TBL a,ACCOUNT_TBL_DETAIL b
WHERE a.account = b.account AND a.account = @iaccount ) -- AND gamecode = 'A000')
BEGIN

DECLARE @curDate char(8)

IF EXISTS(SELECT account FROM ACCOUNT_TBL
WHERE account = @iaccount AND password = @ipassword) BEGIN

SELECT @curDate=CONVERT(CHAR(8), getdate(), 112)

SELECT fError=CASE
-- WHEN session<>@isession OR sessionExpireDt<getdate() THEN '91'
WHEN BlockTime>=@curDate THEN '9'
ELSE '0' END,
fText= CASE
-- WHEN session<>@isession OR sessionExpireDt<getdate() THEN 'Session Expired'
WHEN BlockTime>=@curDate THEN 'Block' ELSE 'OK' END,
fCheck=tester,
f18='1'
-- Ver14. PCZoneIP
,fPCZone = @o_Grade
FROM ACCOUNT_TBL a INNER JOIN ACCOUNT_TBL_DETAIL b ON (a.account=b.account)
WHERE a.account=@iaccount
END
ELSE BEGIN
SELECT fError = '1', fText = 'Wrong Password !!',fCheck ='',f18='1', fPCZone = '0' -- PCZoneIP (, fPCZone = '0' ??)
END
END
ELSE BEGIN
SELECT fError = '2', fText = 'Account Not Exists !!',fCheck ='',f18='1', fPCZone = '0' -- PCZoneIP (, fPCZone = '0' ??)
END

RETURN

-- ?? ?? Rule
-- 1. (fError=2 ??) ????? ??. ????? "gamecode = A000" ? ??? ??.
-- 2. (fError=1 ??) ????.
-- 3. (fError=0 ??) ?? ? ?? ??( id_no1? a0000 )?? ??.??.??? ??
-- 4. (fError=3 ??) ?????, ???? ??.
-- 5. (fError=4 ??) ????.
-- 6. (fError=5 ??) 12? ???? ??. ???? "???? 12? ?? ??? ??? ]
-- ????? ?? ????." ?? ??.
-- 7. (fError=6 ??) ?????? ?? ?? ?? tester = 0 ?? "14? ?? ??? ???
-- ?????? ????? ?? ??? ?????"?? ??.
-- 8. (fError=0 ??) ?? ???? ?? ???? ??.
set nocount off

[xTwiLightx]

Your server is sending 4 arguments for LOGIN_STR, but the procedure just accepts 3.

Are you using LANG_TWN as language?

[-Venom']

Delete my Mac Ban form My Source and compile new.

[CheezSmith]

Thanks for Helping !

#CLOSE