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