Welcome to the RaGEZONE - MMORPG development forums.

IP ban by database

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

LyncusMU
Results 1 to 6 of 6
  1. #1
    Banned
    Rank
    Banned
    Join Date
    Jun 2010
    Posts
    19
    Liked
    5

    IP ban by database

    Tabo Hotel
    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.

  2. HostKey.com: Unmetered Dedicated servers in the Netherlands
  3. #2
    I'm Back.
    Rank
    Gamma
    Join Date
    Jun 2009
    Location
    My Own World
    Posts
    3,168
    Liked
    355

    Re: IP ban by database

    I don't understand what you mean

    @Off 1K Posts.

  4. #3
    Banned
    Rank
    Banned
    Join Date
    Jun 2010
    Posts
    19
    Liked
    5

    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?

  5. #4
    Banned
    Rank
    Banned
    Join Date
    Jun 2010
    Posts
    19
    Liked
    5

    Re: IP ban by database

    Bump, anyone?

  6. #5
    Veni, Vidi, Vici
    Rank
    Alpha Member
    Join Date
    Jan 2010
    Location
    Delhi, India
    Posts
    1,601
    Liked
    242

    Re: IP ban by database

    4th last line.

  7. #6
    Banned
    Rank
    Banned
    Join Date
    Jun 2010
    Posts
    19
    Liked
    5

    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.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •