I don't understand what you mean
@Off 1K Posts.
This is a discussion on IP ban by database within the Gunz Online forums, part of the MMORPG Developments category; The error gives wrong password, is it changeable to userid banned from gunz online? USE [GunzDB] GO /****** Object: StoredProcedure ...

The error gives wrong password, is it changeable to userid banned from gunz online?
USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spGetLoginInfo] Script Date: 08/09/2009 07:13:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* LoginInfo 얻어옴 */
ALTER PROC [dbo].[spGetLoginInfo]
@UserID varchar(20)
AS
SET NOCOUNT ON
DECLARE @IP VARCHAR(40)
SELECT @IP=LastIP FROM LOGIN(NOLOCK) WHERE UserID=@UserID
DECLARE @IP2 VARCHAR(40)
SELECT @IP2=IP FROM ipbans(NOLOCK) WHERE IP=@IP
IF @IP = @IP2
BEGIN
RETURN 1 -- Wrong Password
/* UPDATE ACCOUNT SET UGradeID = 253 WHERE UserID = @UserID -- Ban Any New Accounts */
END
SELECT AID, UserID, Password FROM Login(nolock) WHERE UserID = @UserID
Last edited by Daemonz; 18-06-10 at 03:27 PM.
I don't understand what you mean
@Off 1K Posts.
4th last line.