Lid |
|
Hey,
Normaal moeten alle leden onder elkaar komen te staan maar nu rkijg ik dit... http://www.d-base.net/fout.JPG
Hier is mijn code
echo "<table width='100%' border='0' cellpadding='4' cellspacing='0'>
<tr>
<td bgcolor='#D3ECA0' width='14'></td>
<td bgcolor='#D3ECA0' width='210'><b>Gebruikersnaam</b></td>
<td bgcolor='#D3ECA0' width='150'><b>Aangemeld op</b></td>
<td bgcolor='#D3ECA0' width='100'><b>PB</b></td>
</tr>";
if(isset($_GET['letter']) AND !empty($_GET['letter'])){
$where = $_GET['letter'];
} else {
$where = "";
}
$query = mysql_query("SELECT * FROM user WHERE username LIKE '".$where."%' ORDER BY username ASC");
$aantal = mysql_num_rows($query);
if($aantal == FALSE){
echo "<tr>
<td width='14'></td>
<td width='220'><i>Geen gebruiker(s) gevonden...</i></td>
<td></td>
</tr>";
} else {
while($row = mysql_fetch_assoc($query)){
$status = $row['status'];
$status = str_replace("4", "<img src='images/point_red.jpg'>", $status);
$status = str_replace("3", "<img src='images/point_blue.jpg'>", $status);
$status = str_replace("2", "<img src='images/point_blue.jpg'>", $status);
$status = str_replace("1", "<img src='images/point_green.jpg'>", $status);
$status = str_replace("0", "<img src='images/point_green.jpg'>", $status);
echo "<tr onMouseOver=\"this.style.backgroundColor='#B3E44C';this.style.cursor='hand'\"; onMouseOut=\"this.style.backgroundColor='';\" onClick=\"window.location.href='".$_SERVER['PHP_SELF']."?actie=profiel&id=".$row['userid']."'\">
<td width='14'>".$status."</td>
<td width='210'>".$row['username']."</td>
<td width='150'>". date('d/m/Y H:i',$row['joindate']) ."</td>
<td width='100' valign='left'><a href=pm.php?actie=nieuw&naar=".$row['username'].">PB Sturen</td>
</tr>";
}
}
echo "</table>";
eindetabel();
} elseif($actie == "ban"){
begintabel("Verbannen Leden");
$query = mysql_query("SELECT * FROM leden WHERE status='0'");
$aantal = mysql_num_rows($query);
echo "<table width='100%' border='0' cellpadding='4' cellspacing='0'>
<tr>
<td bgcolor='#D3ECA0' width='14'></td>
<td bgcolor='#D3ECA0' width='210'><b>Gebruikersnaam</b></td>
<td bgcolor='#D3ECA0' width='150'><b>Aangemeld op</b></td>
<td bgcolor='#D3ECA0' width='150'><b>Geschiedenis</b></td>
</tr>";
if(!$aantal){
echo'<i>Er zijn geen leden verbannen!';
} else {
while($assoc = mysql_fetch_assoc($query)){
echo "<tr onMouseOver=\"this.style.backgroundColor='#B3E44C';this.style.cursor='hand'\"; onMouseOut=\"this.style.backgroundColor='';\" onClick=\"window.location.href='".$_SERVER['PHP_SELF']."?actie=profiel&id=".$assoc['id']."'\">";
echo'<td width=14><img src=images/point_green.jpg></td><td width=210><a href=ledenlijst.php?actie=profiel&id='.$assoc['id'].'>'.$assoc['gebruikersnaam'].'</a></td><td width=150>'.$assoc['aangemeldop'].'</td><td width=150><a href=geschiedenis.php?nick='.$assoc['gebruikersnaam'].'>Bekijk Geschiedenis</a><td>';
echo'</tr>';
}
}
echo'</table>';
eindetabel();
}
include("footer.php");
?>
echo "<table width='100%' border='0' cellpadding='4' cellspacing='0'> <tr> <td bgcolor='#D3ECA0' width='14'></td> <td bgcolor='#D3ECA0' width='210'><b>Gebruikersnaam</b></td> <td bgcolor='#D3ECA0' width='150'><b>Aangemeld op</b></td> <td bgcolor='#D3ECA0' width='100'><b>PB</b></td> </tr>"; if(isset($_GET['letter']) AND !empty($_GET['letter'])){ $where = $_GET['letter']; } else { $where = ""; } $query = mysql_query("SELECT * FROM user WHERE username LIKE '".$where."%' ORDER BY username ASC"); if($aantal == FALSE){ <td width='14'></td> <td width='220'><i>Geen gebruiker(s) gevonden...</i></td> <td></td> </tr>"; } else { $status = $row['status']; $status = str_replace("4", "<img src='images/point_red.jpg'>", $status); $status = str_replace("3", "<img src='images/point_blue.jpg'>", $status); $status = str_replace("2", "<img src='images/point_blue.jpg'>", $status); $status = str_replace("1", "<img src='images/point_green.jpg'>", $status); $status = str_replace("0", "<img src='images/point_green.jpg'>", $status); echo "<tr onMouseOver=\"this.style.backgroundColor='#B3E44C';this.style.cursor='hand'\"; onMouseOut=\"this.style.backgroundColor='';\" onClick=\"window.location.href='".$_SERVER['PHP_SELF']."?actie=profiel&id=".$row['userid']."'\"> <td width='14'>".$status."</td> <td width='210'>".$row['username']."</td> <td width='150'>". date('d/m/Y H:i',$row['joindate']) ."</td> <td width='100' valign='left'><a href=pm.php?actie=nieuw&naar=".$row['username'].">PB Sturen</td> </tr>"; } } eindetabel(); } elseif($actie == "ban"){ begintabel("Verbannen Leden"); $query = mysql_query("SELECT * FROM leden WHERE status='0'"); echo "<table width='100%' border='0' cellpadding='4' cellspacing='0'> <tr> <td bgcolor='#D3ECA0' width='14'></td> <td bgcolor='#D3ECA0' width='210'><b>Gebruikersnaam</b></td> <td bgcolor='#D3ECA0' width='150'><b>Aangemeld op</b></td> <td bgcolor='#D3ECA0' width='150'><b>Geschiedenis</b></td> </tr>"; if(!$aantal){ echo'<i>Er zijn geen leden verbannen!'; } else { echo "<tr onMouseOver=\"this.style.backgroundColor='#B3E44C';this.style.cursor='hand'\"; onMouseOut=\"this.style.backgroundColor='';\" onClick=\"window.location.href='".$_SERVER['PHP_SELF']."?actie=profiel&id=".$assoc['id']."'\">"; echo'<td width=14><img src=images/point_green.jpg></td><td width=210><a href=ledenlijst.php?actie=profiel&id='.$assoc['id'].'>'.$assoc['gebruikersnaam'].'</a></td><td width=150>'.$assoc['aangemeldop'].'</td><td width=150><a href=geschiedenis.php?nick='.$assoc['gebruikersnaam'].'>Bekijk Geschiedenis</a><td>'; } } eindetabel(); } include("footer.php"); ?>
|