[ 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 $_entry['query'] = ''; 32 33 // create pagination 34 if(isset($_GET['c'])) { 35 $_SESSION['list_user_count'] = $_GET['c'] == 'all' ? '99999' : intval($_GET['c']); 36 } 37 if(isset($_GET['page'])) { 38 $_SESSION['glossary_page'] = intval($_GET['page']); 39 } 40 41 // set default values for paginating 42 if(empty($_SESSION['list_user_count'])) { 43 $_SESSION['list_user_count'] = 25; 44 } 45 46 // paginate and search form processing 47 if(isset($_POST['do_pagination'])) { 48 49 $_SESSION['list_active'] = empty($_POST['showactive']) ? 0 : 1; 50 $_SESSION['list_inactive'] = empty($_POST['showinactive']) ? 0 : 1; 51 52 $_SESSION['filter'] = clean_slweg($_POST['filter']); 53 if(empty($_SESSION['filter'])) { 54 unset($_SESSION['filter']); 55 } else { 56 $_SESSION['filter'] = convertStringToArray($_SESSION['filter'], ' '); 57 $_POST['filter'] = $_SESSION['filter']; 58 } 59 60 $_SESSION['glossary_page'] = intval($_POST['page']); 61 62 } 63 64 if(empty($_SESSION['glossary_page'])) { 65 $_SESSION['glossary_page'] = 1; 66 } 67 68 $_entry['list_active'] = isset($_SESSION['list_active']) ? $_SESSION['list_active'] : 1; 69 $_entry['list_inactive'] = isset($_SESSION['list_inactive']) ? $_SESSION['list_inactive'] : 1; 70 71 72 // set correct status query 73 if($_entry['list_active'] != $_entry['list_inactive']) { 74 75 if(!$_entry['list_active']) { 76 $_entry['query'] .= 'glossary_status=0'; 77 } 78 if(!$_entry['list_inactive']) { 79 $_entry['query'] .= 'glossary_status=1'; 80 } 81 82 } else { 83 $_entry['query'] .= 'glossary_status!=9'; 84 } 85 86 if(isset($_SESSION['filter']) && is_array($_SESSION['filter']) && count($_SESSION['filter'])) { 87 88 $_entry['filter_array'] = array(); 89 90 foreach($_SESSION['filter'] as $_entry['filter']) { 91 //usr_name, usr_login, usr_email 92 $_entry['filter_array'][] = "CONCAT(glossary_title, glossary_tag, glossary_keyword, glossary_text) LIKE '%".aporeplace($_entry['filter'])."%'"; 93 } 94 if(count($_entry['filter_array'])) { 95 96 $_SESSION['filter'] = ' AND ('.implode(' OR ', $_entry['filter_array']).')'; 97 $_entry['query'] .= $_SESSION['filter']; 98 99 } 100 101 } elseif(isset($_SESSION['filter']) && is_string($_SESSION['filter'])) { 102 103 $_entry['query'] .= $_SESSION['filter']; 104 105 } 106 107 108 // paginating values 109 $_entry['count_total'] = _dbQuery('SELECT * FROM '.DB_PREPEND.'phpwcms_glossary WHERE '.$_entry['query'], 'COUNT'); 110 $_entry['pages_total'] = ceil($_entry['count_total'] / $_SESSION['list_user_count']); 111 if($_SESSION['glossary_page'] > $_entry['pages_total']) { 112 $_SESSION['glossary_page'] = empty($_entry['pages_total']) ? 1 : $_entry['pages_total']; 113 } 114 115 116 117 ?> 118 <h1 class="title" style="margin-bottom:10px"><?php echo $BLM['listing_title'] ?></h1> 119 120 <div class="navBarLeft imgButton chatlist"> 121 122 <a href="<?php echo GLOSSARY_HREF ?>&edit=0" title="<?php echo $BLM['create_new'] ?>"><img src="img/famfamfam/tag_blue_add.gif" alt="Add" border="0" /><span><?php echo $BLM['create_new'] ?></span></a> 123 </div> 124 125 126 <form action="<?php echo GLOSSARY_HREF ?>" method="post" name="paginate" id="paginate"><input type="hidden" name="do_pagination" value="1" /> 127 <table width="100%" border="0" cellpadding="0" cellspacing="0" class="paginate" summary=""> 128 <tr> 129 <td><table border="0" cellpadding="0" cellspacing="0" summary=""> 130 <tr> 131 132 <td><input type="checkbox" name="showactive" id="showactive" value="1" onclick="this.form.submit();"<?php is_checked(1, $_entry['list_active'], 1) ?> /></td> 133 <td><label for="showactive"><img src="img/button/aktiv_12x13_1.gif" alt="" style="margin:1px 1px 0 1px;" /></label></td> 134 <td><input type="checkbox" name="showinactive" id="showinactive" value="1" onclick="this.form.submit();"<?php is_checked(1, $_entry['list_inactive'], 1) ?> /></td> 135 <td><label for="showinactive"><img src="img/button/aktiv_12x13_0.gif" alt="" style="margin:1px 1px 0 1px;" /></label></td> 136 137 <?php 138 if($_entry['pages_total'] > 1) { 139 140 echo '<td class="chatlist">| </td>'; 141 echo '<td>'; 142 if($_SESSION['glossary_page'] > 1) { 143 echo '<a href="'.GLOSSARY_HREF.'&page='.($_SESSION['glossary_page']-1).'">'; 144 echo '<img src="img/famfamfam/action_back.gif" alt="" border="0" /></a>'; 145 } else { 146 echo '<img src="img/famfamfam/action_back.gif" alt="" border="0" class="inactive" />'; 147 } 148 echo '</td>'; 149 echo '<td><input type="text" name="page" id="page" maxlength="4" size="4" value="'.$_SESSION['glossary_page']; 150 echo '" class="textinput" style="margin:0 3px 0 5px;width:30px;font-weight:bold;" /></td>'; 151 echo '<td class="chatlist">/'.$_entry['pages_total'].' </td>'; 152 echo '<td>'; 153 if($_SESSION['glossary_page'] < $_entry['pages_total']) { 154 echo '<a href="'.GLOSSARY_HREF.'&page='.($_SESSION['glossary_page']+1).'">'; 155 echo '<img src="img/famfamfam/action_forward.gif" alt="" border="0" /></a>'; 156 } else { 157 echo '<img src="img/famfamfam/action_forward.gif" alt="" border="0" class="inactive" />'; 158 } 159 echo '</td><td class="chatlist"> | </td>'; 160 161 } else { 162 163 echo '<td class="chatlist">| <input type="hidden" name="page" id="page" value="1" /></td>'; 164 165 } 166 ?> 167 <td><input type="text" name="filter" id="filter" size="10" value="<?php 168 169 if(isset($_POST['filter']) && is_array($_POST['filter']) ) { 170 echo html_specialchars(implode(' ', $_POST['filter'])); 171 } 172 173 ?>" class="textinput" style="margin:0 2px 0 0;width:110px;text-align:left;" title="filter results by username, name or email" /></td> 174 <td><input type="image" name="gofilter" src="img/famfamfam/action_go.gif" style="margin-right:3px;" /></td> 175 176 </tr> 177 </table></td> 178 179 <td class="chatlist" align="right"> 180 <a href="<?php echo GLOSSARY_HREF ?>&c=10">10</a> 181 <a href="<?php echo GLOSSARY_HREF ?>&c=25">25</a> 182 <a href="<?php echo GLOSSARY_HREF ?>&c=50">50</a> 183 <a href="<?php echo GLOSSARY_HREF ?>&c=100">100</a> 184 <a href="<?php echo GLOSSARY_HREF ?>&c=250">250</a> 185 <a href="<?php echo GLOSSARY_HREF ?>&c=all"><?php echo $BL['be_ftptakeover_all'] ?></a> 186 </td> 187 188 </tr> 189 </table> 190 </form> 191 192 <table width="100%" border="0" cellpadding="0" cellspacing="0" summary=""> 193 194 <tr><td colspan="5"><img src="img/leer.gif" alt="" width="1" height="3"></td></tr> 195 <tr><td colspan="5" bgcolor="#92A1AF"><img src="img/leer.gif" alt="" width="1" height="1"></td></tr> 196 197 <?php 198 // loop listing available newsletters 199 $row_count = 0; 200 201 $sql = 'SELECT * FROM '.DB_PREPEND.'phpwcms_glossary WHERE '.$_entry['query'].' '; 202 $sql .= 'LIMIT '.(($_SESSION['glossary_page']-1) * $_SESSION['list_user_count']).','.$_SESSION['list_user_count']; 203 $data = _dbQuery($sql); 204 205 foreach($data as $row) { 206 207 echo '<tr'.( ($row_count % 2) ? ' bgcolor="#F3F5F8"' : '' ).'>'.LF.'<td width="20" style="width:20px;padding:2px 1px 2px 3px;">'; 208 echo '<img src="img/famfamfam/'; 209 echo $row["glossary_highlight"] ? 'tag_blue_key.gif' : 'tag_blue.gif'; 210 echo '" alt="'.$BLM['glossary_entry'].'" /></td>'.LF; 211 echo '<td class="dir" width="50%">'.html_specialchars($row["glossary_title"])." </td>\n"; 212 213 echo '<td class="dir">'.html_specialchars($row["glossary_keyword"])." </td>\n"; 214 215 echo '<td class="dir">'.html_specialchars($row["glossary_tag"])." </td>\n"; 216 217 echo '<td align="right" nowrap="nowrap" class="button_td">'; 218 219 echo '<a href="'.GLOSSARY_HREF.'&edit='.$row["glossary_id"].'">'; 220 echo '<img src="img/button/edit_22x13.gif" border="0" alt="" /></a>'; 221 222 echo '<a href="'.GLOSSARY_HREF.'&editid='.$row["glossary_id"].'&verify='; 223 echo (($row["glossary_status"]) ? '0' : '1').'">'; 224 echo '<img src="img/button/aktiv_12x13_'.$row["glossary_status"].'.gif" border="0" alt="" /></a>'; 225 226 echo '<a href="'.GLOSSARY_HREF.'&delete='.$row["glossary_id"]; 227 echo '" title="delete: '.html_specialchars($row["glossary_title"]).'"'; 228 echo ' onclick="return confirm(\''.$BLM['delete_entry'].' '.js_singlequote($row["glossary_title"]).'\');">'; 229 echo '<img src="img/button/trash_13x13_1.gif" border="0" alt=""></a>'; 230 231 echo "</td>\n</tr>\n"; 232 233 $row_count++; 234 } 235 236 if($row_count) { 237 echo '<tr><td colspan="5" bgcolor="#92A1AF"><img src="img/leer.gif" alt="" width="1" height="1"></td></tr>'; 238 } 239 240 ?> 241 242 <tr><td colspan="5"><img src="img/leer.gif" alt="" width="1" height="15"></td></tr> 243 </table>
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 |