Jump to content

diegcarlos

Member
  • Content Count

    4
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by diegcarlos

  1. diegcarlos

    223 GAMECP source (custom, feature rich)

    Good night I'm trying to use this game cp, but I stopped in this part, I already imported the banks I need, more when I access time of this message Fatal error: Call to undefined function sqlsrv_query() in C:\xampp\htdocs\gamecp\core\db.php on line 1651
  2. diegcarlos

    Wrong Account input

    the person in the razezone quotes you rum, if I'm not mistaken, it was you who helped him http://forum.ragezone.com/f479/sql-fix-normal-player-authentication-909175/ @Ron
  3. diegcarlos

    Wrong Account input

    Problem solved, who helped me with the ploblema was Exathena in the discord, he passed me a ragezone link, with a script to get ordinary users to log in, code below 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
  4. diegcarlos

    Wrong Account input

    Good Morning I'm having a problem, I'm trying to log in as a user on the server but the same does not go in, if I try to login as adm, the accounts are saved in tbl_rfaccount, and zone and the RU, can anyone help me?
×
×
  • Create New...