IPBanning script

[fuxpro321]

a script that the admins can add the USER ID OR Character name and it just look for the IP in the DB and add it to the Ipbans.dbo

[MentaL]

[Phoenix]

No lifex's MPOG web has that function.

[fuxpro321]

EDIT:i need one that dosent need the to Enter the Users IP Adress

just the Charname or the User ID

[alfredao]

DECLARE @IP VARCHAR(40)
DECLARE @UserID VARCHAR(20)

SET @UserID = 'xxxxx'

SELECT @IP = LastIP FROM Login WHERE UserID = @UserID

INSERT INTO [IPBans] (UserID, IP) VALUES (@UserID, @IP)


Execute in SQL Server management

[fuxpro321]

and?

what dose it do?

and could be provide the script?

[alfredao]

<?php

if(isset($_POST['submit']))
{
    
    $userid = $_POST['userid'];
    
    $a = mssql_query("SELECT LastIP FROM Login WHERE UserID = " . $userid);
    
    if(mssql_num_rows($a) == 0)
    {
        echo "Invalid userid";
        die();
    }
    
    $b = mssql_fetch_array($a);
    
    if($b['LastIP'] == "")
    {
        echo "User ip not exists";
        die();
    }
    else
    {
        mssql_query("INSERT INTO [IPBans] (UserID, IP) VALUES ('$userid', '{$b['LastIP']}')");
        echo "UserID " . $userid . " ip banned";
    }
}
?>

<form method="POST" action="">
  UserID: 
  <input type="text" name="userid" id="userid" />
  <input name="submit" type="submit" id="submit" value="Ban">
</form>

[fuxpro321]

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'lol'. (severity 16) in C:\AppServ\www\web\BANIP.PHP on line 8

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\web\BANIP.PHP on line 8

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\web\BANIP.PHP on line 10
Invalid userid

Here is the script i added to my DB..

I Edited abit cause it dosent Execute to the DB

Use [GunzDB]
GO

DECLARE @IP VARCHAR(40)
DECLARE @UserID VARCHAR(20)

SET @UserID = 'xxxxx'

SELECT @IP = LastIP FROM Login WHERE UserID = @UserID

INSERT INTO [IPBans] (UserID, IP) VALUES (@UserID, @IP)

so any idea?

screenie before

[alfredao]

Edit this

$a = mssql_query("SELECT LastIP FROM Login WHERE UserID = " . $userid); 

to

$a = mssql_query("SELECT LastIP FROM Login WHERE UserID = '" . $userid . "'"); 

[fuxpro321]

now it says Invalid userid

yes i am sure i entered the correct info

[alfredao]

Are you sure the userid exists?

[fuxpro321]

Yeah1

[notbanned]

BUMP! i am fuxpro321

[notbanned]

bump!