Why server keep error?

[nickishurt]

Why keep get server error when login?

When people login get server error.. can anyone tell me?

Urgent.Fast Reply

 

[MrNippon]

website resgiter.php

 

[nickishurt]

That is settings paypoint now i mean when i put ID and password then press enter will come out [ Server error ] this only..

Example
website total online 6/50
but
Server Controller 0/50 :huh:

 

[IzzdihaR]

its the pay_gamemyth database table .. just delete them or use my guide i already post it long time ago for auto delete

 

[nickishurt]

Thanks ! i will test it.

 

[IzzdihaR]

wc mate

 

[wck19842003]

i also have this error//// how to fix that...where post

i search many times

 

[inextremi5]

try this, i take no credit i dont remember which user posted this but it worked for me !


go to pay_gamemyth, go to Stored Procedures, go to USPCheckBilling_Login and paste this under GO:

Credits to TyFix for showing me this.

--CHECKING
CREATE PROC dbo.USPCheckBilling_Login @strClientID varchar(20),@UID int,@Check int,@ClientIP varchar(15),@ServerID Tinyint
AS
SET NOCOUNT ON

DECLARE @FLAG INT
DECLARE @BillingType Char(2)
DECLARE @PlayTime INT
DECLARE @Crmindex INT

SET @FLAG = 1 --ERROR
SET @BillingType ='N'
SET @PlayTime = 0
SET @Crmindex = 0

IF EXISTS (SELECT strClientID FROM TblCurrentUser_Disconn WHERE strClientID = @strClientID)
BEGIN
DELETE TblCurrentUser_Disconn
WHERE strClientID = @strClientID
END
ELSE IF EXISTS (SELECT strClientID FROM TblCurrentUser_Temp WHERE strClientID = @strClientID)
BEGIN
DELETE TblCurrentUser_Temp
WHERE strClientID = @strClientID
END
ELSE IF EXISTS (SELECT strClientID FROM TblCurrentUser WHERE strClientID = @strClientID)
BEGIN
DELETE TblCurrentUser
WHERE strClientID = @strClientID
END

INSERT TblCurrentUser_Temp (strClientID,UID,strIP,tinyServerID)
VALUES (@strClientID,@UID,@ClientIP,@ServerID)

IF @@ROWCOUNT <> 1
BEGIN
SELECT @FLAG,@BillingType,@PlayTime,@Crmindex
END
ELSE
BEGIN
SET @FLAG = 0 --SUCCESS
SELECT @FLAG,@BillingType,@PlayTime,@Crmindex
END