Portail PHP

<?php 
include('config.php');
include("lib.php");

$link = opendb();

$query = doquery("SELECT latitude,longitude FROM rpg_users WHERE id='$id' LIMIT 1", "users");
$latitude = 0; 
echo "<table width="100%" border="1">"; 
while ($latitude <= 5) { 
echo "<tr>"; 
$longitude = 0; 
while ($longitude <= 5) { 
$sql = "SELECT id FROM rpg_users WHERE latitude='$latitude' AND longitude='$longitude'"; 
$query = mysql_query($sql); 
$fetch = mysql_fetch_array($query); 
$username = $fetch['username']; 
echo "<td>".$username."&nbsp;</td>"; 
$longitude++; 
} 
echo "</tr>"; 
$latitude++; 
} 
echo "</table>"; 
?>

function opendb() { // Ouverture de la bdd.

    include('config.php');
    extract($dbsettings);
    $link = mysql_connect($server, $user, $pass) or die(mysql_error());
    mysql_select_db($name) or die(mysql_error());
    return $link;

}

function doquery($query, $table) { // Selection des tables.
    
    include('config.php');
    global $numqueries;
    $sqlquery = mysql_query(str_replace("{{table}}", $dbsettings["prefix"] . "_" . $table, $query)) or die(mysql_error());
    $numqueries++;
    return $sqlquery;

}

function gettemplate($templatename) { // SQL query pour les templates.

    $filename = "templates/" . $templatename . ".php";
    include("$filename");
    return $template;
    
}

function parsetemplate($template, $array) { // Replacement des templates avec proper content.
    
    foreach($array as $a => $b) {
        $template = str_replace("{{{$a}}}", $b, $template);
    }
    return $template;
    
}

<?php // config.php :: Infos pour l'installation du script à remplir.

$dbsettings = Array(
        "server"        => "localhost",     // Nom du serveur MySQL. (Default: localhost)
        "user"          => "..........",              // Nom de votre login MySQL.
        "pass"          => "..........",              // Nom de votre password MySQL.
        "name"          => "........",              // Nom de votre base MySQL.
        "prefix"        => "rpg",            // Prefixe des tables MySQL. (Default: rpg)
        "secretword"    => "????");             // Mot secret utilisé lors de la mise a jour des cookies.

?>