function unrecord($id, $db, $login)
{
$res = $db->querySingle("SELECT rowid, * FROM workshops WHERE rowid = {$id}", true);
$tab = explode(",", $res["persons"]);
unset($tab[array_search($login, $tab)]);
$res["persons"] = join(",", $tab);
$db->exec("UPDATE workshops SET persons = '" . $res["persons"] . "' WHERE rowid = {$id}");
@av_sendmail($db, $res["persons"] . "," . $res["followers"] . "," . $login, $res["rowid"], "{$login} vient de se désinscrire de l'atelier", "");
}
$persons = $login . "," . $persons;
}
$stmt = $db->prepare("insert into workshops(creator,date,location,topic,persons,comments) values( :login, :date ,:loc,:topic,:persons,:comment);");
$stmt->bindValue(':date', $timestamp, SQLITE3_INTEGER);
$stmt->bindValue(':loc', $loc, SQLITE3_TEXT);
$stmt->bindValue(':topic', $topic, SQLITE3_TEXT);
$stmt->bindValue(':login', $login, SQLITE3_TEXT);
$stmt->bindValue(':persons', $persons, SQLITE3_TEXT);
$stmt->bindValue(':comment', $login . "§" . $comment, SQLITE3_TEXT);
$stmt->execute();
$id = $db->lastInsertRowID();
$result = $db->query("select * from users;");
$to = "";
while ($res = $result->fetchArray(SQLITE3_ASSOC)) {
$to = $to . $res["trigramme"] . ",";
}
@av_sendmail($db, $to, $id, "Creation d'un nouvel atelier", "");
echo "OK";
} else {
$id = $_GET["id"];
$res = $db->querySingle("SELECT rowid, * FROM workshops WHERE rowid = {$id}", true);
$stmt = $db->prepare("UPDATE workshops SET date= :date, location= :loc, topic= :topic WHERE rowid = :id");
$stmt->bindValue(':id', $id, SQLITE3_INTEGER);
$stmt->bindValue(':date', $timestamp, SQLITE3_INTEGER);
$stmt->bindValue(':loc', $loc, SQLITE3_TEXT);
$stmt->bindValue(':topic', $topic, SQLITE3_TEXT);
$stmt->execute();
$to = $res["persons"] . "," . $res["followers"];
@av_sendmail($db, $to, $id, "Modification d'un nouvel atelier", "");
echo "OK";
}
<?php
require_once "open_db.php";
require_once "sendmail.php";
$action = $_GET["action"];
if ($action == "change") {
$pwd = $_GET["pwd"];
$stmt = $db->prepare("update users set password= :pwd where trigramme = :login;");
$stmt->bindValue(':pwd', $pwd, SQLITE3_TEXT);
$stmt->bindValue(':login', $login, SQLITE3_TEXT);
$stmt->execute();
echo "OK";
} else {
$login = strtoupper($_GET["login"]);
$rest = $db->querySingle("select * from users where trigramme = '{$login}';", true);
if (count($rest) != 0) {
@av_sendmail($db, $login, -1, "Votre mot de passe atelier avarap", "Votre mot de passe est :" . $rest["password"]);
echo "OK";
} else {
echo "Utilisateur inconnu";
}
}
