I'm a bit stuck here. This script works fine where it's both active AND expired bans, but not if there is only expired bans. So is there anyone that got some tips for how I can solve this?
ebid = expired ban id
bid = ban id
Code: Select all
if(preg_match("^user_\d{1,10}$^",trim(strtoupper($_GET["s"])))) {
mysql_connect('xxx','xxx','xxx');
@mysql_select_db('xxx') or die("Unable to select database");
$query = mysql_query("SELECT * from lol_old WHERE user_id='".$_GET['s']."'") or die(mysql_error());
$query1 = mysql_query("SELECT * from lol_oldbans WHERE user_id='".$_GET['s']."'") or die(mysql_error());
if(mysql_num_rows($query)) {
while($myrow = mysql_fetch_array($query)) {
if($myrow['ban_length'] == 0) {
$length = 'perm';
}
else {
$length = $myrow['ban_length'].'min';
}
$result = ' <p>'.$myrow['ban_reason'].' ('.$length.') - <a target="_blank" href="/?bid='.$myrow['bid'].'">?bid='.$myrow['bid'].'</a> (ACTIVE)</p>'."\r\n";
}
}
elseif(mysql_num_rows($query1)) {
while($myrow1 = mysql_fetch_array($query1)) {
if($myrow1['ban_length'] == 0) {
$length = 'perm';
}
else {
$length = $myrow1['ban_length'].'min';
}
$oldres .= ' <p>'.$myrow1['ban_reason'].' ('.$length.') - <a target="_blank" href="/ebid='.$myrow1['ebid'].'">?ebid='.$myrow1['ebid'].'</a></p>'."\r\n";
}
}
else {
$result = " <p>Not banned.</p>"."\r\n";
}
}
else {
$result = " <p>Error! The search has to start with 'user_'</p>"."\r\n";
}
echo $result;
echo $oldres;