3 * Site Mailings Subscription Maintenance page
5 * This page is used to maintain site mailings (currently, just
6 * unsubscribe specific user).
8 * Copyright 1999-2001 (c) VA Linux Systems
12 * This file is part of GForge.
14 * GForge is free software; you can redistribute it and/or modify
15 * it under the terms of the GNU General Public License as published by
16 * the Free Software Foundation; either version 2 of the License, or
17 * (at your option) any later version.
19 * GForge is distributed in the hope that it will be useful,
20 * but WITHOUT ANY WARRANTY; without even the implied warranty of
21 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
22 * GNU General Public License for more details.
24 * You should have received a copy of the GNU General Public License
25 * along with GForge; if not, write to the Free Software
26 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
30 require_once('../env.inc.php');
31 require_once('pre.php');
32 require_once('www/admin/admin_utils.php');
33 session_require(array('group'=>'1','admin_flags'=>'A'));
35 $user_name = getStringFromRequest('user_name');
36 if (getStringFromRequest('submit') && $user_name) {
37 $type = getStringFromRequest('type');
42 Show form for unsubscription type selection
45 site_admin_header(array('title'=>$Language->getText('admin_unsubscribe','title')));
48 <h4><?php echo $Language->getText('admin_unsubscribe','unsubscribe_user'); ?> <?php echo $user_name; ?></h4>
50 <?php echo $Language->getText('admin_unsubscribe','you_can_unsubscribe'); ?>
52 <form action="<?php echo getStringFromServer('PHP_SELF'); ?>" method="post">
53 <input type="hidden" name="user_name" value="<?php echo $user_name?>" />
54 Unsubscription type: <?php echo html_build_select_box_from_arrays(
55 array($Language->getText('admin_unsubscribe','mail'),$Language->getText('admin_unsubscribe','all')),
56 array($Language->getText('admin_unsubscribe','admin_initiaded_mail'),$Language->getText('admin_unsubscribe','all_site_mailing')),
59 <input type="submit" name="submit" value="<?php echo $Language->getText('admin_unsubscribe','unsubscribe'); ?>" />
63 site_admin_footer(array());
68 Perform unsubscription
71 $u =& user_get_object_by_name($user_name);
72 if (!$u || !is_object($u)) {
73 exit_error('Error','Could Not Get User');
74 } elseif ($u->isError()) {
75 exit_error('Error',$u->getErrorMessage());
78 if (!$u->unsubscribeFromMailings($type=='ALL' ? 1 : 0)) {
80 $Language->getText('admin_unsubscribe','error_unsubscribe_user') .$u->getErrorMessage()
84 $feedback .= $Language->getText('admin_unsubscribe','user_unsubscribed').'<br />';
88 site_admin_header(array('title'=>$Language->getText('admin_unsubscribe','subscription_maintance')));
93 <?php echo $Language->getText('admin_unsubscribe','subscription_maintance'); ?>
97 <?php echo $Language->getText('admin_unsubscribe','use_fields_bellow',array($GLOBALS['sys_name'])); ?>
100 <form action="<?php echo getStringFromServer('PHP_SELF'); ?>" method="post">
101 Pattern: <input type="text" name="pattern" value="<?php echo $pattern; ?>" />
102 <input type="submit" name="submit" value="<?php echo $Language->getText('admin_unsubscribe','show_user_matching'); ?>" />
107 $pattern = getStringFromRequest('pattern');
112 if ( $sys_database_type == "mysql" ) {
114 WHERE user_name LIKE '%$pattern%'
115 OR realname LIKE '%$pattern%'
116 OR email LIKE '%$pattern%'
120 WHERE user_name LIKE '%$pattern%'
121 OR realname ILIKE '%$pattern%'
122 OR email ILIKE '%$pattern%'
125 $res = db_query($sql);
129 $title[]=$Language->getText('admin_unsubscribe','user_id');
130 $title[]=$Language->getText('admin_unsubscribe','username');
131 $title[]=$Language->getText('admin_unsubscribe','real_name');
132 $title[]=$Language->getText('admin_unsubscribe','email');
133 $title[]=$Language->getText('admin_unsubscribe','site_mail');
134 $title[]=$Language->getText('admin_unsubscribe','comm_mail');
136 echo $GLOBALS['HTML']->listTableTop($title);
138 while ($row = db_fetch_array($res)) {
140 <tr '.$GLOBALS['HTML']->boxGetAltRowStyle($i++).'>
142 <td>'.$row['user_id'].'</td>
143 <td><a href="unsubscribe.php?submit=1&user_name='.$row['user_name'].'">'.$row['user_name'].'</a></td>
144 <td>'.$row['realname'].'</td>
145 <td> '.$row['email'].'</td>
146 <td>'.$row['mail_siteupdates'].'</td>
147 <td> '.$row['mail_va'].'</td>
152 echo $GLOBALS['HTML']->listTableBottom();
156 site_admin_footer(array());