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