Welcome to the new RFPSC !

Hi Guest , Welcome to the new RFPSC ! We had several updates includes themes and many more. You can see the changelog here


New to RFPSC? Dont know how to make a topic?

Hi Guest , Now you can create fast topic on the right widget! Give it a try!


We got new Features!

Hi Guest , We got a new features called "Cover Profile Picture" , now you upload your own cover picture for
your profile!
You can do that by clicking here and modify the Profile Cover Photo form with your Image URL !
Give it a try!

You are not connected. Please login or register

error ID Normal

By

reply in this page topic

ea7z8

ea7z8

Member
Walk 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..

Messi

Messi

RF Support
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

btw, salah room nih thread  Ngiler @rfpsc.bot

Thank you for the reports @Messi the thread has been moved.

Sponsored content



View previous topic View next topic Back to top  Message [Page 1 of 1]

Create an account or log in to leave a reply

You need to be a member in order to leave a reply.

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here


Sign In Now