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);