PHP removeallgroupmembers Examples

Example #1

File: stugroups.php Project: ericvanboven/IMathAS

function deletegroup($grpid, $delposts = true)
{
    removeallgroupmembers($grpid);
    if ($delposts) {
        $query = "SELECT id FROM imas_forum_threads WHERE stugroupid='{$grpid}'";
        $result = mysql_query($query) or die("Query failed : " . mysql_error());
        $todel = array();
        while ($row = mysql_fetch_row($result)) {
            $todel[] = $row[0];
        }
        if (count($todel) > 0) {
            $dellist = implode(',', $todel);
            $query = "DELETE FROM imas_forum_threads WHERE id IN ({$dellist})";
            mysql_query($query) or die("Query failed : " . mysql_error());
            $query = "DELETE FROM imas_forum_posts WHERE threadid IN ({$dellist})";
            mysql_query($query) or die("Query failed : " . mysql_error());
        }
    } else {
        $query = "UPDATE imas_forum_threads SET stugroupid=0 WHERE stugroupid='{$grpid}'";
        mysql_query($query) or die("Query failed : " . mysql_error());
    }
    $query = "DELETE FROM imas_stugroups WHERE id='{$grpid}'";
    mysql_query($query) or die("Query failed : " . mysql_error());
    $query = "DELETE FROM imas_wiki_revisions WHERE stugroupid='{$grpid}'";
    mysql_query($query) or die("Query failed : " . mysql_error());
}

Example #2

File: managestugrps.php Project: ericvanboven/IMathAS

         exit;
     } else {
         $query = "SELECT name FROM imas_stugroups WHERE id='{$_GET['rengrp']}'";
         $result = mysql_query($query) or die("Query failed : " . mysql_error());
         $page_grpname = mysql_result($result, 0, 0);
         $query = "SELECT name FROM imas_stugroupset WHERE id='{$grpsetid}'";
         $result = mysql_query($query) or die("Query failed : " . mysql_error());
         $page_grpsetname = mysql_result($result, 0, 0);
     }
     $curBreadcrumb .= " &gt; <a href=\"managestugrps.php?cid={$cid}\">Manage Student Groups</a> &gt; <a href=\"managestugrps.php?cid={$cid}&grpsetid={$grpsetid}\">{$page_grpsetname}</a> &gt; Rename Group";
 } else {
     if (isset($_GET['removeall'])) {
         //removing all group members
         if (isset($_GET['confirm'])) {
             //if name is set
             removeallgroupmembers($_GET['removeall']);
             header('Location: ' . $urlmode . $_SERVER['HTTP_HOST'] . rtrim(dirname($_SERVER['PHP_SELF']), '/\\') . "/managestugrps.php?cid={$cid}&grpsetid={$grpsetid}");
             exit;
         } else {
             $query = "SELECT name FROM imas_stugroups WHERE id='{$_GET['removeall']}'";
             $result = mysql_query($query) or die("Query failed : " . mysql_error());
             $page_grpname = mysql_result($result, 0, 0);
             $query = "SELECT name FROM imas_stugroupset WHERE id='{$grpsetid}'";
             $result = mysql_query($query) or die("Query failed : " . mysql_error());
             $page_grpsetname = mysql_result($result, 0, 0);
         }
         $curBreadcrumb .= " &gt; <a href=\"managestugrps.php?cid={$cid}\">Manage Student Groups</a> &gt; <a href=\"managestugrps.php?cid={$cid}&grpsetid={$grpsetid}\">{$page_grpsetname}</a> &gt; Remove all group members";
     } else {
         if (isset($_GET['remove']) && isset($_GET['grpid'])) {
             //removing one group member
             if (isset($_GET['confirm'])) {