[ Index ] |
PHP Cross Reference of phpwcms V1.4.7 _r403 (01.11.10) |
[Summary view] [Print] [Text view]
1 <?php 2 /************************************************************************************* 3 Copyright notice 4 5 (c) 2002-2010 Oliver Georgi (oliver@phpwcms.de) // All rights reserved. 6 7 This script is part of PHPWCMS. The PHPWCMS web content management system is 8 free software; you can redistribute it and/or modify it under the terms of 9 the GNU General Public License as published by the Free Software Foundation; 10 either version 2 of the License, or (at your option) any later version. 11 12 The GNU General Public License can be found at http://www.gnu.org/copyleft/gpl.html 13 A copy is found in the textfile GPL.txt and important notices to the license 14 from the author is found in LICENSE.txt distributed with these scripts. 15 16 This script is distributed in the hope that it will be useful, but WITHOUT ANY 17 WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A 18 PARTICULAR PURPOSE. See the GNU General Public License for more details. 19 20 This copyright notice MUST APPEAR in all copies of the script! 21 *************************************************************************************/ 22 23 // ---------------------------------------------------------------- 24 // obligate check for phpwcms constants 25 if (!defined('PHPWCMS_ROOT')) { 26 die("You Cannot Access This Script Directly, Have a Nice Day."); 27 } 28 // ---------------------------------------------------------------- 29 30 31 if(isset($_GET["s"])) { 32 33 include_once (PHPWCMS_ROOT.'/include/inc_lib/newsletter.form.inc.php'); 34 35 if(isset($_GET['edit'])) { 36 include_once (PHPWCMS_ROOT.'/include/inc_tmpl/newsletter.form.tmpl.php'); 37 } 38 39 if(isset($_GET['send']) && $show_nl_send) { 40 41 include_once (PHPWCMS_ROOT.'/include/inc_tmpl/newsletter.send.tmpl.php'); 42 43 } 44 45 } else { 46 47 if(isset($_GET['duplicate_nl'])) { 48 @_dbDuplicateRow( 'phpwcms_newsletter', 'newsletter_id', intval($_GET['duplicate_nl']), 49 array('newsletter_active' => 0, 'newsletter_changed' => 'SQL:NOW()', 50 'newsletter_lastsending' => '0000-00-00 00:00:00', 'newsletter_created' => 'SQL:NOW()', 51 'newsletter_subject' => '--SELF-- (copy)')); 52 } 53 54 // check if subscription should be edited 55 56 57 // create paginating for newsletter 58 if(isset($_GET['c'])) { 59 $_SESSION['list_newsletter_count'] = $_GET['c'] == 'all' ? '99999' : intval($_GET['c']); 60 } 61 // set default values for paginating 62 if(empty($_SESSION['list_newsletter_count'])) { 63 $_SESSION['list_newsletter_count'] = 10; 64 } 65 // set page 66 if(isset($_GET['page'])) { 67 $_SESSION['newsletter_page'] = intval($_GET['page']); 68 } 69 // start at page 1 70 if(empty($_SESSION['newsletter_page']) || $_SESSION['newsletter_page'] < 1) { 71 $_SESSION['newsletter_page'] = 1; 72 } 73 74 $_newsletter['count_total'] = _dbQuery("SELECT COUNT(*) FROM ".DB_PREPEND."phpwcms_newsletter WHERE newsletter_trashed=0", 'COUNT'); 75 $_newsletter['pages_total'] = ceil($_newsletter['count_total'] / $_SESSION['list_newsletter_count']); 76 if($_SESSION['newsletter_page'] > $_newsletter['pages_total']) { 77 $_SESSION['newsletter_page'] = $_newsletter['pages_total']; 78 } 79 80 ?> 81 82 <div class="title" style="margin-bottom:10px"><?php echo $BL['be_subnav_msg_newslettersend'] ?></div> 83 84 <div class="navBarLeft imgButton chatlist"> 85 86 <a href="phpwcms.php?do=messages&p=3&s=0&edit=1"><img src="img/famfamfam/email_add.gif" alt="Add" border="0" /><span><?php echo $BL['be_newsletter_new'] ?></span></a> 87 </div> 88 89 90 91 <table width="100%" border="0" cellpadding="0" cellspacing="0" summary=""> 92 <tr> 93 <td><?php 94 if($_newsletter['pages_total'] > 1) { 95 96 echo '<table border="0" cellpadding="0" cellspacing="0" summary=""><tr><td>'; 97 if($_SESSION['newsletter_page'] > 1) { 98 echo '<a href="phpwcms.php?do=messages&p=3&page='.($_SESSION['newsletter_page']-1).'">'; 99 echo '<img src="img/famfamfam/action_back.gif" alt="" border="0" /></a>'; 100 } else { 101 echo '<img src="img/famfamfam/action_back.gif" alt="" border="0" class="inactive" />'; 102 } 103 echo '</td>'; 104 echo '<td><input type="text" name="page" id="page" maxlength="4" size="4" value="'.$_SESSION['newsletter_page']; 105 echo '" class="textinput" style="margin:0 3px 0 5px;width:30px;font-weight:bold;" /></td>'; 106 echo '<td class="chatlist">/'.$_newsletter['pages_total'].' </td>'; 107 echo '<td>'; 108 if($_SESSION['newsletter_page'] < $_newsletter['pages_total']) { 109 echo '<a href="phpwcms.php?do=messages&p=3&page='.($_SESSION['newsletter_page']+1).'">'; 110 echo '<img src="img/famfamfam/action_forward.gif" alt="" border="0" /></a>'; 111 } else { 112 echo '<img src="img/famfamfam/action_forward.gif" alt="" border="0" class="inactive" />'; 113 } 114 echo '</td></tr></table>'; 115 } else { 116 echo ' '; 117 } 118 ?> 119 120 </td> 121 122 <td class="chatlist" align="right"> 123 <a href="phpwcms.php?do=messages&p=3&c=5">5</a> 124 <a href="phpwcms.php?do=messages&p=3&c=10">10</a> 125 <a href="phpwcms.php?do=messages&p=3&c=25">25</a> 126 <a href="phpwcms.php?do=messages&p=3&c=50">50</a> 127 <a href="phpwcms.php?do=messages&p=3&c=100">100</a> 128 <a href="phpwcms.php?do=messages&p=3&c=all"><?php echo $BL['be_ftptakeover_all'] ?></a> 129 </td> 130 131 </tr> 132 </table> 133 <table width="100%" border="0" cellpadding="0" cellspacing="0" summary=""> 134 135 <tr class="tableHeadRow"> 136 <th> </th> 137 <th style="text-align:left"><?php echo $BL['be_msg_subject'] ?></th> 138 <th><?php echo $BL['be_newsletter_changed'] ?></th> 139 <th><?php echo str_replace(' ', '<br />', $BL['be_last_sending']) ?></th> 140 <th><?php echo $BL['be_total'].'/<br />'.$BL['be_cnt_queued'].'/<br />'.$BL['be_msg_senttop'] ?></th> 141 <th> </th> 142 </tr> 143 144 <tr><td colspan="6" bgcolor="#92A1AF"><img src="img/leer.gif" alt="" width="1" height="1" /></td></tr> 145 146 <?php 147 148 // loop listing available newsletters 149 150 $sql = "SELECT * FROM ".DB_PREPEND."phpwcms_newsletter WHERE newsletter_trashed=0 ORDER BY newsletter_changed DESC"; 151 $sql .= " LIMIT ".(($_SESSION['newsletter_page']-1) * $_SESSION['list_newsletter_count']).','.$_SESSION['list_newsletter_count']; 152 $result = _dbQuery($sql); 153 154 if($result) { 155 156 $row_count = 0; 157 158 foreach($result as $row) { 159 160 $row['newsletter_vars'] = unserialize($row['newsletter_vars']); 161 162 echo '<tr'.( ($row_count % 2) ? ' bgcolor="#F3F5F8"' : '' ).' class="listrow">'.LF; 163 echo '<td width="2%" style="padding:2px 5px 2px 4px;">'; 164 165 // sent/queue status 166 $count_sent = _dbQuery('SELECT COUNT(*) FROM '.DB_PREPEND.'phpwcms_newsletterqueue WHERE queue_status=1 AND queue_pid='.$row["newsletter_id"], 'COUNT'); 167 $count_queue = _dbQuery('SELECT COUNT(*) FROM '.DB_PREPEND.'phpwcms_newsletterqueue WHERE queue_status=0 AND queue_pid='.$row["newsletter_id"], 'COUNT'); 168 $count_recipient = countNewsletterRecipients($row['newsletter_vars']['subscription']); 169 170 if(empty($row["newsletter_active"]) || !$count_queue) { 171 echo '<img src="img/famfamfam/email.gif" alt="NL" title="ID:'.$row["newsletter_id"].'" />'; 172 } else { 173 echo '<a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"]; 174 echo '&send=1"><img src="img/famfamfam/email_go.gif" alt="Send" border="0" title="ID:'.$row["newsletter_id"].'"></a>'; 175 } 176 177 echo '</td>'.LF; 178 179 echo '<td class="dir"><strong>'.html_specialchars($row["newsletter_subject"])."</strong></td>\n"; 180 181 // create date 182 echo '<td nowrap="nowrap" class="v10" align="center"> '.@date($BL['be_shortdatetime'], strtotime($row['newsletter_changed'])).' </td>'; 183 // last sending 184 echo '<td nowrap="nowrap" class="v10" align="center"> '.@date($BL['be_shortdatetime'], strtotime($row['newsletter_lastsending'])).' </td>'; 185 186 echo '<td nowrap="nowrap" class="v10" align="center">'.$count_recipient.'/'.$count_queue.'/'.$count_sent; 187 if($count_sent && !$count_queue && $row["newsletter_active"]) { 188 echo '<img src="img/symbole/valid.gif" border="0" alt="valid" style="margin: 0 0 0 3px" />'; 189 } 190 echo ' </td>'; 191 192 // buttons 193 echo '<td align="right" nowrap="nowrap" class="button_td">'; 194 195 // duplicate 196 echo '<a href="phpwcms.php?do=messages&p=3&duplicate_nl='.$row["newsletter_id"]; 197 echo '"><img src="img/button/copy_11x11_0.gif" alt="Duplicate" border="0" style="margin:1px 3px 1px 0" /></a>'; 198 199 // edit 200 echo '<a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"]; 201 echo '&edit=1"><img src="img/button/edit_22x13.gif" alt="Edit" border="0" /></a>'; 202 203 // delete 204 echo '<a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"].'&del='.$row["newsletter_id"]; 205 echo '" title="delete: '.html_specialchars($row["newsletter_subject"]); 206 echo '" onclick="return confirm(\'Delete newsletter: '.js_singlequote(html_specialchars($row["newsletter_subject"])).'\');">'; 207 echo '<img src="img/button/trash_13x13_1.gif" border="0" alt="Delete" /></a>'; 208 209 echo "</td>\n</tr>\n"; 210 211 $row_count++; 212 213 } 214 215 } else { 216 217 echo '<tr><td colspan="4"> no newsletter available</td></tr>'; 218 219 } 220 221 ?> 222 <tr><td colspan="6" bgcolor="#92A1AF"><img src="img/leer.gif" alt="" width="1" height="1" /></td></tr> 223 <tr><td colspan="6"><img src="img/leer.gif" alt="" width="1" height="8" /></td></tr> 224 </table> 225 <?php 226 227 } 228 229 230 ?>
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
Generated: Tue Nov 16 22:51:00 2010 | Cross-referenced by PHPXref 0.7 |