[SOLVED] error ID Normal

3 posters

RFWorld :: Rising Force :: RF General Discussion :: RF Offline Solved Thread

[SOLVED] error ID NormalMarch 20th 2019, 08:42

untuk para master mohon bantuannya, saya ada masalah, di game rf offline saya, client tidak mengenali id normal yang dibuat di SQL (notice: akun tidak terdaftar/akun salah), tapi kalo pake id GM bisa login, tolong solusinya.. terim kasih sebelumnya..

Re: [SOLVED] error ID NormalMarch 20th 2019, 23:57

Coba pakai query yg ini bro.

Code:


USE [RF_USER]
GO

/****** Object:  StoredProcedure [dbo].[pSelect_AccountPass]    Script Date: 02/05/2013 10:33:02 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pSelect_AccountPass]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[pSelect_AccountPass]
GO

USE [RF_USER]
GO

/****** Object:  StoredProcedure [dbo].[pSelect_AccountPass]    Script Date: 02/05/2013 10:33:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO


CREATE   PROCEDURE [dbo].[pSelect_AccountPass]
@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