X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fprofile.php;h=18faa1be7e25c5558e16aa9c8d1e7f2192af23c6;hb=257ae4081d1b5da12c4458f0642b9d2b7843abee;hp=fe1126e100da8057bdbc7d0f6827ca52c0876900;hpb=706f830dcc5b982da3464b9bc25ce098d05b6b84;p=platal.git diff --git a/modules/profile.php b/modules/profile.php index fe1126e..18faa1b 100644 --- a/modules/profile.php +++ b/modules/profile.php @@ -181,23 +181,23 @@ class ProfileModule extends PLModule XDB::execute('DELETE FROM profile_photos WHERE pid = {?}', S::user()->profile()->id()); - XDB::execute('DELETE FROM requests - WHERE user_id = {?} AND type="photo"', + XDB::execute("DELETE FROM requests + WHERE uid = {?} AND type = 'photo'", S::v('uid')); $globals->updateNbValid(); $page->trigSuccess("Ta photo a bien été supprimée. Elle ne sera plus visible sur le site dans au plus une heure."); } elseif (Env::v('cancel')) { S::assert_xsrf_token(); - $sql = XDB::query('DELETE FROM requests - WHERE user_id={?} AND type="photo"', + $sql = XDB::query("DELETE FROM requests + WHERE uid = {?} AND type = 'photo'", S::v('uid')); $globals->updateNbValid(); } - $sql = XDB::query('SELECT COUNT(*) + $sql = XDB::query("SELECT COUNT(*) FROM requests - WHERE user_id={?} AND type="photo"', + WHERE uid = {?} AND type = 'photo'", S::v('uid')); $page->assign('submited', $sql->fetchOneCell()); $page->assign('has_trombi_x', file_exists($trombi_x));