News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Checking bans

Started by Frozenball, April 07, 2006, 04:35:02 PM

Previous topic - Next topic

Frozenball

Hello. My bancheck script doesn't work correctly.


function isbanned_ip($ip,$userid="")
{

// Alkuvarit
$banned = false;

// Puretaan
$explode = explode(".",$ip);

$query = query("SELECT *
FROM pivotforum_ban_items
WHERE ip_low1 >= ".$explode[0]." AND ".$explode[0]." <=  ip_high1 AND
  ip_low2 >= ".$explode[1]." AND ".$explode[1]." <=  ip_high2 AND
  ip_low3 >= ".$explode[2]." AND ".$explode[2]." <=  ip_high3 AND
  ip_low4 >= ".$explode[3]." AND ".$explode[3]." <=  ip_high4
");


// Katsotaan
while ($array = mysql_fetch_array($query))
{

$ryhma = $array['ID_BAN_GROUP'];

// Uh.
$pie = query("SELECT *
FROM pivotforum_ban_groups
WHERE expire_time     >=     ".time()." AND
  ID_BAN_GROUP     =     ".$ryhma."
");

$montako = mysql_num_rows($pie);
$pie = mysql_fetch_array($pie);

// Nyt on tulokset :]
if ($montako >= 1)
{
$banned = true;
$expire = $pie['expire_time'];
$reason = $pie['reason'];
break;
}

} // LOOPin loppu

if ($banned == false) { return false; }
else
{

// Oletko mode (:
if (is_numeric($userid))
{
list($bob) = mysql_fetch_row(query("SELECT mode FROM pivot_users WHERE userid = '".$userid."'"));
if ($bob >= 3) { return false; }
}


return array(
"banned" => true,
"expire" => $expire,
"reason" => $reason
);


// Loppu
}


}

Advertisement: