function getTabHistory($idMember, $type) { $sqlQuery = "SELECT * FROM qcs_history WHERE type = '" . $type . "' AND idMember = '" . $idMember . "' ORDER BY createdDate ASC"; // echo $sqlQuery . "<br/>"; $sqlLink = startSQLSession(); $result = mysql_query($sqlQuery, $sqlLink); closeSQLSession($sqlLink); $tabHistory = array(); while ($line = mysql_fetch_array($result)) { $tabHistory[] = $line; } // echo $sqlQuery . "<br/>"; return $tabHistory; }
function checkLoginAndPassword($username, $password) { // echo "password = "******"<br/>"; $password = getMD5($username, $password); // echo "password MD5 = " . $password . "<br/>"; $sqlQuery = "SELECT username FROM qcs_users WHERE username = '******' AND password = '******'"; logMessage(__FUNCTION__ . " - " . $sqlQuery, LOG_LEVEL_DEBUG); $sqlLink = startSQLSession(); $result = mysql_query($sqlQuery, $sqlLink); closeSQLSession($sqlLink); $login = ''; if (mysql_num_rows($result) == 1) { $line = mysql_fetch_assoc($result); $login = $line['username']; } return $login; }
function updateUser($id, $login, $password, $lastname, $firstname, $email, $company, $codeEmetteur, $notify, $photo) { $sqlQuery = "UPDATE users SET login = '******' , password = '******' , lastname = '" . $lastname . "' , firstname = '" . $firstname . "' , email = '" . $email . "' , company = '" . $company . "' , codeEmetteur = '" . $codeEmetteur . "' , notify = '" . $notify . "' , photo = '" . $photo . "' WHERE id = " . $id; logMessage(__FUNCTION__ . " - " . $sqlQuery, LOG_LEVEL_DEBUG); $sqlLink = startSQLSession(); mysql_query($sqlQuery, $sqlLink); closeSqlSession($sqlLink); }