X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=classes%2Fgroup.php;h=d17562c2f5ffd32078fcce27d732e46163dad85c;hb=12160997cbae052d05f0ef4cb6fd5e9fe27eadb1;hp=c79b0d322d8703fad61640fb99aa12bf7c1dbe0d;hpb=d82359a556779137f8a90d0312b3098a2db6f482;p=platal.git diff --git a/classes/group.php b/classes/group.php index c79b0d3..d17562c 100644 --- a/classes/group.php +++ b/classes/group.php @@ -140,6 +140,26 @@ class Group $data['id']); return new Group(array_merge($data, array('positions' => $positions))); } + + static public function subscribe($group_id, $uid) + { + XDB::execute('DELETE FROM group_former_members + WHERE uid = {?} AND asso_id = {?}', + $uid, $group_id); + XDB::execute('INSERT IGNORE INTO group_members (asso_id, uid) + VALUES ({?}, {?})', + $group_id, $uid); + } + + static public function unsubscribe($group_id, $uid, $remember) + { + XDB::execute('INSERT INTO group_former_members (asso_id, uid, remember, unsubsciption_date) + VALUES ({?}, {?}, {?}, NOW())', + $group_id, $uid, $remember); + XDB::execute('DELETE FROM group_members + WHERE uid = {?} AND asso_id = {?}', + $uid, $group_id); + } } // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: