function get_fdescription($folderid, $uname, $pid = 0) { if ($folderid == "-1") { $description = T_("Group folders"); } else { include 'conn.php'; if ($pid == -1) { include 'groups_functions.php'; $description = returnGroupDesc(returnGroupID(returnFolderName($folderid))); } else { $Query = "select description from " . TABLE_PREFIX . "folders where id='{$folderid}' and name='{$uname}'"; //echo($Query . "<br>\n"); $dbResult = $dblink->query($Query); if ($row =& $dbResult->fetchRow(DB_FETCHMODE_ASSOC)) { $description = "{$row["description"]}"; } } } return $description; }
} else { $Query = sprintf("select group_name from " . TABLE_PREFIX . "groups where group_id=" . $group_id . " and password='******'"); //echo($Query . "<br>\n"); $dbResult = $dblink->query($Query); $check = 0; while ($row =& $dbResult->fetchRow(DB_FETCHMODE_ASSOC)) { $check++; } if ($check == 1) { //Insert member into the gsubscriptions table $Query = "INSERT INTO " . TABLE_PREFIX . "gsubscriptions ( Group_ID , Name , Date_Join , Priv ) VALUES ('{$group_id}', '{$username}', now(), '1')"; //echo($Query . "<br>\n"); $AffectedRows = $dblink->exec($Query); if ($AffectedRows == 1) { //Create the folder under the member's Groups folder with the Group name and description of the group $success = createMemberGroupFolder($username, returnGroupName($group_id), returnGroupDesc($group_id)); if ($success == 1) { $success = true; echo "<p class=\"success\">" . T_("Your are now a member of this group") . ".</p><p><b>" . T_("Details of the group") . "</b><br><br>"; include 'includes/gdetails_body.php'; } else { echo "<p class=\"error\">" . T_("A problem occured when creating the folder of this group") . ".</p>"; } } else { echo "<p class=\"error\">" . T_("A problem occured when adding you to this group") . ".</p>"; } } else { echo "<p class=\"error\">" . T_("The password you entered is invalid") . ".</p>"; } } }