function callSQL($server, $table, $colonne)
{
initSQL($server);
$queryID = 'SELECT player_id FROM stats_players WHERE name="' . $_SESSION['login'] . '"';
$sendQueryID = @mysql_query($queryID) or die('Erreur SQL !<br />' . $queryID . '<br />' . @mysql_error());
$getID = @mysql_fetch_array($sendQueryID);
$requestGTA = 'SELECT ' . $colonne . ' FROM ' . $table . ' WHERE player_id="' . $getID['player_id'] . '"';
$sendQueryGTA = @mysql_query($requestGTA) or die('Erreur SQL !<br />' . $requestGTA . '<br />' . @mysql_error());
$resultGTA = @mysql_fetch_array($sendQueryGTA);
if ($getID == NULL) {
return "0";
} else {
return "{$resultGTA[$colonne]}";
}
}
function getTimeLatest($table)
{
initSQL();
$checkExist = 'SELECT pseudo FROM ' . $table . ' WHERE pseudo="' . $_SESSION['login'] . '"';
// Check si le joueur est dans la table $table
if (@mysql_num_rows($checkExist) == 0) {
// Si le joueur n'est pas dans la table $table
@mysql_query('INSERT INTO ' . $table . ' (pseudo, time) VALUES ("' . $_SESSION['login'] . '", 0)');
// Alors on l'inscris dans la table
}
$hasVoted = @mysql_query('SELECT * FROM ' . $table . ' WHERE pseudo="' . $_SESSION['login'] . '"');
while ($data = @mysql_fetch_array($hasVoted)) {
$time_latest = $data['time'];
// On recupère le temps du dernier vote (0 si aucun vote)
return $time_latest;
break;
}
}
<?php include_once '../include/config.php'; include_once '../classes/databasePDO.php'; include_once '../classes/class.search.php'; include_once '../classes/class.searchEngine.php'; initSQL($config);
