IP ban by database

Results 1 to 6 of 6
  1. #1
    Banned Daemonz is offline
    BannedRank
    Jun 2010 Join Date
    19Posts

    IP ban by database

    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 04:27 PM.


  2. #2
    Doggie And Rice. Military is offline
    MemberRank
    Jun 2009 Join Date
    Here and AboutLocation
    3,302Posts

    Re: IP ban by database

    I don't understand what you mean

    @Off 1K Posts.

  3. #3
    Banned Daemonz is offline
    BannedRank
    Jun 2010 Join Date
    19Posts

    Re: IP ban by database

    Quote Originally Posted by Military View Post
    I don't understand what you mean

    @Off 1K Posts.
    If you execute this into your database and add an ip to the ipbans table. it says wrong password.

    how to make the message user-id banned?

  4. #4
    Banned Daemonz is offline
    BannedRank
    Jun 2010 Join Date
    19Posts

    Re: IP ban by database

    Bump, anyone?

  5. #5
    Veni, Vidi, Vici Arcelor is offline
    MemberRank
    Jan 2010 Join Date
    Delhi, IndiaLocation
    1,763Posts

    Re: IP ban by database

    4th last line.

  6. #6
    Banned Daemonz is offline
    BannedRank
    Jun 2010 Join Date
    19Posts

    Re: IP ban by database

    Quote Originally Posted by Arcelor View Post
    4th last line.
    I've tryd changing that in different things won't work.
    That's why I'm posting lmao.



Advertisement