if (isset($_REQUEST['msg']) && $_REQUEST['msg'] == 4) { echo '<p style=color:red>Message deleted sucessfully.</p>'; } $userName = User('USERNAME'); $user_dt = DBGet(DBQuery('SELECT USER_ID,PROFILE_ID FROM login_authentication WHERE USERNAME=\'' . $userName . '\'')); $user_dt = $user_dt[1]; if (isset($_REQUEST['modfunc']) && $_REQUEST['modfunc'] == 'delete') { if (count($_REQUEST['mail']) != 0) { $count = count($_REQUEST['mail']); if ($count != 1) { $row = "messages"; } else { $row = "message"; } if (DeleteMail($count . ' ' . $row, 'delete', $_REQUEST['modname'], true)) { unset($_REQUEST['modfunc']); $id = array_keys($_REQUEST['mail']); foreach ($id as $idi => $idd) { $idd = explode("_", $idd); if ($idd[1] == 'SENT') { $sent[] = $idd[0]; } else { $recieved[] = $idd[0]; } } if (count($sent) > 0) { $sent = implode(',', $sent); $arr = array(); $qr = 'SELECT (SELECT username FROM login_authentication WHERE USER_ID=ISTRASH AND PROFILE_ID=' . $user_dt['PROFILE_ID'] . ') AS ISTRASH FROM msg_outbox WHERE MAIL_ID IN (' . $sent . ')'; $fetch = DBGet(DBQuery($qr));
} if (isset($_REQUEST['modfunc']) && $_REQUEST['modfunc'] == 'delete') { $group_id = $_REQUEST['group_id']; $members = DBGet(DBQuery("select count(*) as countmember from mail_groupmembers where group_id=" . $group_id . "")); $count_members = $members[1]['COUNTMEMBER']; if ($count_members > 0) { if (DeleteMail("group with " . $count_members . " groupmembers", 'delete', $_REQUEST['modname'], true)) { $member_del = "delete from mail_groupmembers where group_id=" . $group_id . ""; $member_del_execute = DBQuery($member_del); $mail_delete = "delete from mail_group where group_id =" . $group_id . ""; $mail_delete_ex = DBQuery($mail_delete); unset($_REQUEST['modfunc']); echo "<script>window.location='Modules.php?modname=messaging/Group.php'</script>"; } } else { if (DeleteMail('group', 'delete', $_REQUEST['modname'], true)) { $mail_delete = "delete from mail_group where group_id =" . $group_id . ""; $mail_delete_ex = DBQuery($mail_delete); unset($_REQUEST['modfunc']); echo "<script>window.location='Modules.php?modname=messaging/Group.php'</script>"; } } unset($_REQUEST['modfunc']); } if (isset($_REQUEST['modfunc']) && $_REQUEST['modfunc'] == 'groupmember') { PopTable('header', 'Group Members'); echo "<FORM name=sav id=sav action=Modules.php?modname=" . strip_tags(trim($_REQUEST[modname])) . "&modfunc=members&groupid=" . strip_tags(trim($_REQUEST[group_id])) . " method=POST>"; echo '<div style="overflow:auto; width:820px;">'; echo "<div id='members'>"; $member = "select * from mail_groupmembers where GROUP_ID='" . $_REQUEST['group_id'] . "'"; $member_list = DBGet(DBQuery($member));