Need help detecting by a user's ip if that certain person is banned

[ShadowIce]

Hi all. After lots of research, I finally got this darn code to work. The only problem is I don't know how to detect which user is banned on the website and which user is not, or which user has a warning, and which 1 does not.

i want to detect which user is who by their ip. if say i banned that person, ONLY THAT PERSON would be banned.

Nobody else would be banned.

how would i do that?

a working example would be GREAT! 🙂

Code:

mysql_select_db($dbname, $con);

error_reporting(E_ALL);
ini_set('display_errors', 1);

$query = "SELECT $ip1, $warning1, $banned1, FROM $tbl;";
var_dump($query."<br>\n"); 
$result = mysql_query($query) or die(mysql_error()); 

//now lets go through every row returned. 
while($row = mysql_fetch_assoc($result)){ 

$ip = $row[$ip1];
$warning = $row[$warning1];
$banned = $row[$banned1];

$rows = mysql_num_rows($result); 

echo "query: ".$query."<br>\n";
echo "result: ".$result."<br>\n";
echo "row: ".$row."<br>\n";
echo "ip: ".$ip."<br>\n";
echo "warning: ".$warning."<br>\n";
echo "banned: ".$banned."<br>\n";
echo "rows: ".$rows."<br>\n";

if($warning > 0){ 

ANY help is GREATLY appreciated! 🙂

[NogDog]

The first problem is that the IP address is a very unreliable way to identify someone. This is due to any of a number of reasons, such as AOL users whose requests may come under a different IP address each time, the user's ISP assigning a different IP each time the user connects to them, or the user going through a proxy server to connect to the internet "anonymously."

[ShadowIce]

so how would i identify them w/ an sql table value?

username?

what?

[johanafm]

If you require them to create an account before they can do anything, and also require an email address to activate the account, then you can at least ban the account. Moreover, you can ban the email address, which at least means they need to create a new email account to create a new account with your service.
Not fail safe, but it makes the process somewhat less demanding.

Banning IP addresses should always be a last resort if you have other options, and that most likely involves having a support staff that can deal with requests from other users being affected by said ban and possibly unban that IP address again.

[ShadowIce]

or cant i use an id of some sort?

[johanafm]

yes

[ShadowIce]

how would i do this? what would be an example?

also, how do i make the id?

[ShadowIce]

can someone show me an example please?

i need to know a 100% efficient way to detect someone and depending on if they're banned or not, display the website normally.