[SUCHE] Dynamische Memberliste [MySQL|PHP]

<?php


header('Content-Type: image/png');






/// Konfiguration ///


$db[0] = "accounts"; // Die Tabelle wo die Benutzerdaten liegen
$db[1] = "admin"; // Die Spalte wo der Admin Rank steht
$db[2] = "online"; // Die Spalte wo der Online-Status steht
$db[3] = "lastlogout"; // Die Spalte wo der Letzte-Login steht (Unix-Timestamp)
$db[4] = "username"; // Die Spalte wo der Name steht


$connect[0] = "IP"; // Datenbank IP 
$connect[1] = "USER"; // Datenbank User
$connect[2] = "PASS"; // Datenbank Passwort
$connect[3] = "DATABASE"; // Datenbank DB




/////////////////////


$conn = mysql_connect($connect[0], $connect[1], $connect[2]);
mysql_select_db($connect[3], $conn);


function getRank($admin) { // Hier die Admin-Ränge anpassen
    if($admin == 1) { // $admin == X ( das X ist der Admin-Rank )
        $adminrank = "Jun. Supporter";
    } else if($admin == 2) {
        $adminrank = "Sen. Supporter";
    }
    else if($admin == 3) { 
        $adminrank = "Moderator";
    }
    else if($admin == 4) {
        $adminrank = "Admin";
    }
    else if($admin == 5) {
        $adminrank = "Full Admin";
    }
    else if($admin == 6) {
        $adminrank = "Projektleiter";
    } 
    else if($admin == 0) {
        $adminrank = "Spieler";
    }
    return $adminrank;
}


$signaturQuery = mysql_query("SELECT * FROM `{$db[0]}` WHERE `{$db[1]}` != 0 ORDER BY `{$db[1]}` DESC");


while($row = mysql_fetch_array($signaturQuery)) {
    $admins[] = $row;    
}


$line_background = ImageCreateFromPNG("Offline.png");
$line_height = ImageSY($line_background);
$line_height_margin = 0;
$currentHeight = $line_height_margin;


$image_height = $line_height*sizeof( $admins ) + $line_height_margin*sizeof( $admins );
$img = ImageCreate( ImageSX( $line_background ), $image_height );
$transparent = ImageColorAllocate( $img, 245, 245, 245 );
ImageColorTransparent( $img, $transparent );
$weiß = ImageColorAllocate( $img, 255, 255, 255);


foreach( $admins as $admin ) {

    if($admin["{$db[2]}"] == 1) {
        $line_background = ImageCreateFromPNG("Online.png");
    } else if($admin["{$db[2]}"] == 0) {
        $line_background = ImageCreateFromPNG("Offline.png");


    }    


    $_lastonline = date("d.m.Y",$admin["{$db[3]}"]);


    ImageCopy($img, $line_background, 0, $currentHeight, 0, 0, ImageSX( $line_background ), ImageSY( $line_background ) );
    ImageTTFText ($img, 14, 0, 15, $currentHeight + 27, $weiß, "fonts/arial.ttf", $admin["{$db[4]}"]); 
    ImageTTFText ($img, 14, 0, 200, $currentHeight + 27, $weiß, "fonts/arial.ttf", getRank($admin["{$db[1]}"])); 
    ImageTTFText ($img, 14, 0, 380, $currentHeight + 27, $weiß, "fonts/arial.ttf", $_lastonline); 
    $currentHeight = $currentHeight + $line_height + $line_height_margin;
}


ImagePNG( $img );
ImageDestroy( $img );






?>