diff options
Diffstat (limited to 'admin/comments.php')
| -rw-r--r-- | admin/comments.php | 273 |
1 files changed, 0 insertions, 273 deletions
diff --git a/admin/comments.php b/admin/comments.php deleted file mode 100644 index f6672e5a2..000000000 --- a/admin/comments.php +++ /dev/null @@ -1,273 +0,0 @@ -<?php -// +-----------------------------------------------------------------------+ -// | comments.php | -// +-----------------------------------------------------------------------+ -// | application : PhpWebGallery <http://phpwebgallery.net> | -// | branch : BSF (Best So Far) | -// +-----------------------------------------------------------------------+ -// | file : $RCSfile$ -// | last update : $Date$ -// | last modifier : $Author$ -// | revision : $Revision$ -// +-----------------------------------------------------------------------+ -// | This program is free software; you can redistribute it and/or modify | -// | it under the terms of the GNU General Public License as published by | -// | the Free Software Foundation | -// | | -// | This program is distributed in the hope that it will be useful, but | -// | WITHOUT ANY WARRANTY; without even the implied warranty of | -// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | -// | General Public License for more details. | -// | | -// | You should have received a copy of the GNU General Public License | -// | along with this program; if not, write to the Free Software | -// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, | -// | USA. | -// +-----------------------------------------------------------------------+ -include_once( './admin/include/isadmin.inc.php' ); -$page['plain_structure'] = get_plain_structure(); -//------------------------------------------------------------------- functions -function display_pictures( $mysql_result, $maxtime, $validation_box = false ) -{ - global $vtp,$sub,$lang,$conf, - $array_cat_directories,$array_cat_site_id,$array_cat_names; - - while ( $row = mysql_fetch_array( $mysql_result ) ) - { - $vtp->addSession( $sub, 'picture' ); - // 2. for each picture, getting informations for displaying thumbnail and - // link to the full size picture - $query = 'SELECT name,file,storage_category_id as cat_id,tn_ext'; - $query.= ' FROM '.PREFIX_TABLE.'images'; - $query.= ' WHERE id = '.$row['image_id']; - $query.= ';'; - $subresult = mysql_query( $query ); - $subrow = mysql_fetch_array( $subresult ); - - if ( !isset( $array_cat_directories[$subrow['cat_id']] ) ) - { - $array_cat_directories[$subrow['cat_id']] = - get_complete_dir( $subrow['cat_id'] ); - $cat_result = get_cat_info( $subrow['cat_id'] ); - $array_cat_site_id[$subrow['cat_id']] = $cat_result['site_id']; - $array_cat_names[$subrow['cat_id']] = - get_cat_display_name( $cat_result['name'], ' > ', '' ); - } - - $file = get_filename_wo_extension( $subrow['file'] ); - // name of the picture - $name = $array_cat_names[$subrow['cat_id']].' > '; - if ( isset( $subrow['name'] ) and $subrow['name'] != '' ) - { - $name.= $subrow['name']; - } - else - { - $name.= str_replace( '_', ' ', $file ); - } - $name.= ' [ '.$subrow['file'].' ]'; - $vtp->setVar( $sub, 'picture.title', $name ); - // source of the thumbnail picture - $src = $array_cat_directories[$subrow['cat_id']]; - $src.= 'thumbnail/'.$conf['prefix_thumbnail']; - $src.= $file.'.'.$subrow['tn_ext']; - $vtp->setVar( $sub, 'picture.thumb_src', $src ); - // link to the full size picture - $url = './picture.php?cat='.$subrow['cat_id']; - $url.= '&image_id='.$row['image_id']; - $vtp->setVar( $sub, 'picture.thumb_url', add_session_id( $url ) ); - // 3. for each picture, retrieving all comments - $query = 'SELECT id,date,author,content'; - $query.= ' FROM '.PREFIX_TABLE.'comments'; - $query.= ' WHERE image_id = '.$row['image_id']; - $query.= ' AND date > '.$maxtime; - if ( $validation_box ) $query.= " AND validated = 'false'"; - $query.= ' ORDER BY date DESC'; - $query.= ';'; - $subresult = mysql_query( $query ); - while ( $subrow = mysql_fetch_array( $subresult ) ) - { - $vtp->addSession( $sub, 'comment' ); - $author = $subrow['author']; - if ( $subrow['author'] == '' ) $author = $lang['guest']; - $vtp->setVar( $sub, 'comment.author', $author ); - $displayed_date = format_date( $subrow['date'], 'unix', true ); - $vtp->setVar( $sub, 'comment.date', $displayed_date ); - - $content = nl2br( $subrow['content'] ); - - // replace _word_ by an underlined word - $pattern = '/_([^\s]*)_/'; - $replacement = '<span style="text-decoration:underline;">\1</span>'; - $content = preg_replace( $pattern, $replacement, $content ); - - // replace *word* by a bolded word - $pattern = '/\*([^\s]*)\*/'; - $replacement = '<span style="font-weight:bold;">\1</span>'; - $content = preg_replace( $pattern, $replacement, $content ); - - // replace /word/ by an italic word - $pattern = '/\/([^\s]*)\//'; - $replacement = '<span style="font-style:italic;">\1</span>'; - $content = preg_replace( $pattern, $replacement, $content ); - - $vtp->setVar( $sub, 'comment.content', $content ); - - $vtp->addSession( $sub, 'delete' ); - $url = './admin.php?page=comments'; - if ( isset( $_GET['last_days'] ) ) $url.= '&last_days='.MAX_DAYS; - if ( isset( $_GET['show_unvalidated'] ) ) - $url.= '&show_unvalidated=true'; - $url.= '&del='.$subrow['id']; - $vtp->setVar( $sub, 'delete.link', add_session_id( $url ) ); - $vtp->closeSession( $sub, 'delete' ); - // if the comment has to be validated, we display a checkbox - if ( $validation_box ) - { - $vtp->addSession( $sub, 'validation' ); - $vtp->setVar( $sub, 'validation.id', $subrow['id'] ); - $vtp->closeSession( $sub, 'validation' ); - } - $vtp->closeSession( $sub, 'comment' ); - } - $vtp->closeSession( $sub, 'picture' ); - } -} -//------------------------------------------------------------ comment deletion -if ( isset( $_GET['del'] ) and is_numeric( $_GET['del'] ) ) -{ - $query = 'DELETE FROM '.PREFIX_TABLE.'comments'; - $query.= ' WHERE id = '.$_GET['del']; - $query.= ';'; - mysql_query( $query ); -} -//--------------------------------------------------------- comments validation -if ( isset( $_POST['submit'] ) ) -{ - $query = 'SELECT id'; - $query.= ' FROM '.PREFIX_TABLE.'comments'; - $query.= " WHERE validated = 'false'"; - $query.= ';'; - $result = mysql_query( $query ); - while ( $row = mysql_fetch_array( $result ) ) - { - if ( $_POST['validate-'.$row['id']] == 'true' ) - { - $query = 'UPDATE '.PREFIX_TABLE.'comments'; - $query.= " SET validated = 'true'"; - $query.= ' WHERE id = '.$row['id']; - $query.= ';'; - mysql_query( $query ); - } - } -} -//----------------------------------------------------- template initialization -$sub = $vtp->Open( './template/'.$user['template'].'/admin/comments.vtp' ); -$tpl = array( 'stats_last_days','delete','close','submit','open' ); -templatize_array( $tpl, 'lang', $sub ); -$vtp->setGlobalVar( $sub, 'user_template', $user['template'] ); -//--------------------------------------------------- number of days to display -if ( isset( $_GET['last_days'] ) ) define( 'MAX_DAYS', $_GET['last_days'] ); -else define( 'MAX_DAYS', 0 ); -//----------------------------------------- non specific section initialization -$array_cat_directories = array(); -$array_cat_names = array(); -$array_cat_site_id = array(); -//------------------------------------------------------- last comments display -$vtp->addSession( $sub, 'section' ); -$vtp->setVar( $sub, 'section.title', $lang['comments_last_title'] ); -$vtp->addSession( $sub, 'last_days' ); -foreach ( $conf['last_days'] as $option ) { - $vtp->addSession( $sub, 'last_day_option' ); - $vtp->setVar( $sub, 'last_day_option.option', $option ); - $url = './admin.php?page=comments'; - $url.= '&last_days='.($option - 1); - $vtp->setVar( $sub, 'last_day_option.link', add_session_id( $url ) ); - if ( $option == MAX_DAYS + 1 ) - { - $vtp->setVar( $sub, 'last_day_option.style', 'font-weight:bold;'); - } - $vtp->closeSession( $sub, 'last_day_option' ); -} -$vtp->closeSession( $sub, 'last_days' ); -if ( isset( $_GET['last_days'] ) ) -{ - $vtp->addSession( $sub, 'close' ); - $url = './admin.php?page=comments'; - if ( isset( $_GET['show_unvalidated'] ) ) - { - $url.= '&show_unvalidated='.$_GET['show_unvalidated']; - } - $vtp->setVar( $sub, 'close.url', add_session_id( $url ) ); - $vtp->closeSession( $sub, 'close' ); - // 1. retrieving picture ids which have comments recently added - $date = date( 'Y-m-d', time() - ( MAX_DAYS*24*60*60 ) ); - list($year,$month,$day) = explode( '-', $date); - $maxtime = mktime( 0,0,0,$month,$day,$year ); - $query = 'SELECT DISTINCT(image_id) as image_id'; - $query.= ' FROM '.PREFIX_TABLE.'comments'; - $query.= ', '.PREFIX_TABLE.'images as images'; - $query.= ' WHERE image_id = images.id'; - $query.= ' AND date > '.$maxtime; - $query.= ' ORDER BY date_available DESC'; - $query.= ';'; - $result = mysql_query( $query ); - display_pictures( $result, $maxtime ); -} -$vtp->closeSession( $sub, 'section' ); -//---------------------------------------------- non validated comments display -$vtp->addSession( $sub, 'section' ); -$vtp->setVar( $sub, 'section.title', $lang['comments_non_validated_title'] ); -if ( isset( $_GET['show_unvalidated'] ) ) -{ - // form starts - $vtp->addSession( $sub, 'start_form' ); - $action = './admin.php?page=comments'; - if ( isset( $_GET['last_days'] ) ) - { - $action.= '&last_days='.$_GET['last_days']; - } - $action.= '&show_unvalidated=true'; - $vtp->setVar( $sub, 'start_form.action', add_session_id( $action ) ); - $vtp->closeSession( $sub, 'start_form' ); - // close this section ? - $vtp->addSession( $sub, 'close' ); - $url = './admin.php?page=comments'; - if ( isset( $_GET['last_days'] ) ) - { - $url.= '&last_days='.$_GET['last_days']; - } - $vtp->setVar( $sub, 'close.url', add_session_id( $url ) ); - $vtp->closeSession( $sub, 'close' ); - // retrieving all picture ids which have unvalidated comments - $query = 'SELECT DISTINCT(image_id) as image_id'; - $query.= ' FROM '.PREFIX_TABLE.'comments as comments'; - $query.= ', '.PREFIX_TABLE.'images as images'; - $query.= ' WHERE image_id = images.id'; - $query.= " AND comments.validated = 'false'"; - $query.= ' ORDER BY date_available DESC'; - $query.= ';'; - $result = mysql_query( $query ); - display_pictures( $result, 0, true ); - $vtp->addSession( $sub, 'submit' ); - $vtp->closeSession( $sub, 'submit' ); - // form ends - $vtp->addSession( $sub, 'end_form' ); - $vtp->closeSession( $sub, 'end_form' ); -} -else -{ - $vtp->addSession( $sub, 'open' ); - $url = './admin.php?page=comments'; - if ( isset( $_GET['last_days'] ) ) - { - $url.= '&last_days='.$_GET['last_days']; - } - $url.= '&show_unvalidated=true'; - $vtp->setVar( $sub, 'open.url', add_session_id( $url ) ); - $vtp->closeSession( $sub, 'open' ); -} -$vtp->closeSession( $sub, 'section' ); -//----------------------------------------------------------- sending html code -$vtp->Parse( $handle, 'sub', $sub ); -?> |