<?php
$extensions = get_loaded_extensions();
if (in_array("sqlite3", $extensions) && in_array("pdo_sqlite", $extensions)) {
if (!file_exists('data')) {
mkdir('data');
}
if (!file_exists("data/displo")) {
require_once 'includes/global.php';
global $db;
$sql = array();
// players
$sql[] = "CREATE TABLE IF NOT EXISTS " . diplo_player::TABLE_NAME . "(\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n login VARCHAR(32) NOT NULL,\n password VARCHAR(48) NOT NULL,\n email VARCHAR(255),\n nom VARCHAR(255),\n prenom VARCHAR(255),\n access INT(2) DEFAULT '1')";
$sql[] = "INSERT INTO " . diplo_player::TABLE_NAME . " (login, password, email, nom, prenom, access)\n VALUES ('admin', '" . hashPasswd('admin') . "', 'admin', 'admin', '*****@*****.**', '99')";
// puissances
$sql[] = "CREATE TABLE IF NOT EXISTS " . diplo_puissance::TABLE_NAME . "(\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name VARCHAR(255) NOT NULL,\n color VARCHAR(6) NOT NULL)";
$sql[] = "INSERT INTO " . diplo_puissance::TABLE_NAME . " (name, color)\n VALUES ('France', '0000FF')";
$sql[] = "INSERT INTO " . diplo_puissance::TABLE_NAME . " (name, color)\n VALUES ('Royaume-Uni', 'AFAFAF')";
$sql[] = "INSERT INTO " . diplo_puissance::TABLE_NAME . " (name, color)\n VALUES ('Allemagne', '333333')";
$sql[] = "INSERT INTO " . diplo_puissance::TABLE_NAME . " (name, color)\n VALUES ('Autriche', 'FF0000')";
$sql[] = "INSERT INTO " . diplo_puissance::TABLE_NAME . " (name, color)\n VALUES ('Russie', 'D7AA0D')";
$sql[] = "INSERT INTO " . diplo_puissance::TABLE_NAME . " (name, color)\n VALUES ('Italie', '00FF00')";
$sql[] = "INSERT INTO " . diplo_puissance::TABLE_NAME . " (name, color)\n VALUES ('Turquie', '4EEBFD')";
// parties
$sql[] = "CREATE TABLE IF NOT EXISTS " . diplo_game::TABLE_NAME . "(\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name VARCHAR(255) NOT NULL,\n max_players INT(6) NOT NULL,\n id_user INTERGER NOT NULL,\n date_create datetime)";
$sql[] = "CREATE TABLE IF NOT EXISTS " . diplo_player_game::TABLE_NAME . "(\n id_game INTEGER NOT NULL,\n id_player INTEGER NOT NULL,\n id_puissance INTEGER NOT NULL,\n PRIMARY KEY (id_game, id_player))";
foreach ($sql as $s) {
$db->query($s);
}
}
require_once 'includes/global.php';
<?php
session_start();
require_once 'includes/global.php';
global $db;
if (isset($_SESSION["auth"]) && $_SESSION["auth"]) {
if (isset($_GET['logout']) && $_GET['logout']) {
session_destroy();
redirect('index.php');
}
// page de chargement des données courantes
echo 'Bonjour, ' . $_SESSION["login"] . '.';
include "common/controller.php";
} else {
if (isset($_POST['login']) && isset($_POST['pwd'])) {
$sel = "SELECT\t*\n\t\t\t\tFROM\t" . diplo_player::TABLE_NAME . "\n\t\t\t\tWHERE\tlogin LIKE '" . $_POST['login'] . "'\n\t\t\t\tAND\t\tpassword = '******'pwd']) . "'";
$res = $db->query($sel);
if ($r = $res->fetchArray()) {
$_SESSION['auth'] = 1;
$_SESSION['login'] = $r['login'];
$_SESSION['user'] = $r;
redirect('index.php');
} else {
echo 'Erreur login/password';
}
}
?>
<form method="POST" action="index.php">
<label>Login :</label>
<input type="text" name="login" />
<label>Password :</label>
