From 3aff4f0bfec650d7a080b919b299ddcf6fc6ee59 Mon Sep 17 00:00:00 2001 From: rvelices Date: Fri, 24 Feb 2006 01:16:30 +0000 Subject: fix: remove all php warnings and notices git-svn-id: http://piwigo.org/svn/trunk@1056 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/rating.php | 518 +++++++++++++++++++++++++++---------------------------- 1 file changed, 259 insertions(+), 259 deletions(-) (limited to 'admin/rating.php') diff --git a/admin/rating.php b/admin/rating.php index a28eaba50..3c30e07b8 100644 --- a/admin/rating.php +++ b/admin/rating.php @@ -1,260 +1,260 @@ - ' . $conf['guest_id']; - $template->assign_vars( array( - 'DISPLAY_FILTER_USER_CHECKED'=>'checked="checked"' - ) - ); - } - elseif ( $_GET['display_filter']=='guest' ) - { - $display_filter= ' AND r.user_id =' . $conf['guest_id']; - $template->assign_vars( array( - 'DISPLAY_FILTER_GUEST_CHECKED'=>'checked="checked"' - ) - ); - } -} -if ($display_filter=='') -{ - $template->assign_vars( array( - 'DISPLAY_FILTER_ALL_CHECKED'=>'checked="checked"' - ) - ); -} - -if (isset($_GET['del'])) -{ - $del_params = urldecode( $_GET['del'] ); - parse_str($del_params, $vars); - if ( !is_numeric($vars['e']) or !is_numeric($vars['u']) ) - { - die('Hacking attempt'); - } - $query = ' -DELETE FROM '. RATE_TABLE .' -WHERE element_id=' . $vars['e'] . ' -AND user_id=' . $vars['u'] . ' -AND anonymous_id=\'' . $vars['a'] . '\' -;'; - pwg_query($query); - update_average_rate( $vars['e'] ); -} - -$users = array(); -$query = ' -SELECT '.$conf['user_fields']['username'].' as username, '.$conf['user_fields']['id'].' as id - FROM '.USERS_TABLE.' -;'; -$result = pwg_query($query); -while ($row = mysql_fetch_array($result)) -{ - $users[$row['id']]=$row['username']; -} - - -$query = 'SELECT COUNT(DISTINCT(i.id)) -FROM '.RATE_TABLE.' AS r, '.IMAGES_TABLE.' AS i -WHERE r.element_id=i.id'. $display_filter . -';'; -list($nb_images) = mysql_fetch_row(pwg_query($query)); - - -// +-----------------------------------------------------------------------+ -// | template init | -// +-----------------------------------------------------------------------+ - -$template->set_filenames(array('rating'=>'admin/rating.tpl')); - -$navbar = create_navigation_bar( - PHPWG_ROOT_PATH.'admin.php'.get_query_string_diff(array('start','del')), - $nb_images, - $start, - $elements_per_page, - ''); -$template->assign_vars(array('NAVBAR' => $navbar)); - - -$template->assign_vars( - array( - 'F_ACTION' => PHPWG_ROOT_PATH.'admin.php', - 'DISPLAY' => $elements_per_page, - 'NB_ELEMENTS' => $nb_images - ) - ); - -$available_order_by= array( - array(l10n('Rate date'), 'recently_rated DESC'), - array(l10n('Average rate'), 'average_rate DESC'), - array(l10n('Number of rates'), 'nb_rates DESC'), - array(l10n('Sum of rates'), 'sum_rates DESC'), - array(l10n('Controversy'), 'std_rates DESC'), - array(l10n('File name'), 'file DESC'), - array(l10n('Creation date'), 'date_creation DESC'), - array(l10n('Availability date'), 'date_available DESC'), - - ); - -for ($i=0; $iassign_block_vars( - 'order_by', - array( - 'VALUE' => $i, - 'CONTENT' => $available_order_by[$i][0], - 'SELECTED' => $i==$order_by_index ? 'SELECTED' : '' - ) - ); -} - -$query = 'SELECT i.id, i.path, i.file, i.tn_ext, i.average_rate, i.storage_category_id, - MAX(r.date) as recently_rated, COUNT(r.rate) as nb_rates, - SUM(r.rate) as sum_rates, ROUND(STD(r.rate),2) as std_rates -FROM '.RATE_TABLE.' AS r LEFT JOIN '.IMAGES_TABLE.' AS i -ON r.element_id=i.id -WHERE 1=1 ' . $display_filter . ' -GROUP BY r.element_id -ORDER BY ' . $available_order_by[$order_by_index][1] .' -LIMIT '.$start.','.$elements_per_page . -';'; - -$images = array(); -$result = pwg_query($query); -while ($row = mysql_fetch_array($result)) -{ - array_push($images, $row); -} - -foreach ($images as $image) -{ - $thumbnail_src = get_thumbnail_src( - $image['path'], $image['tn_ext'] - ); - - $image_url = PHPWG_ROOT_PATH.'picture.php?'. - 'cat=' . $image['storage_category_id']. - '&image_id=' . $image['id']; - - $query = 'SELECT * -FROM '.RATE_TABLE.' AS r -WHERE r.element_id='.$image['id'] . ' -ORDER BY date DESC;'; - $result = pwg_query($query); - $nb_rates = mysql_num_rows($result); - - $template->assign_block_vars('image', - array( - 'U_THUMB' => $thumbnail_src, - 'U_URL' => $image_url, - 'AVG_RATE' => $image['average_rate'], - 'STD_RATE' => $image['std_rates'], - 'SUM_RATE' => $image['sum_rates'], - 'NB_RATES' => $image['nb_rates'], - 'NB_RATES_TOTAL' => $nb_rates, - 'FILE' => $image['file'], - 'NB_RATES_PLUS1' => $nb_rates+1, - ) - ); - - while ($row = mysql_fetch_array($result)) - { - - $url_del = PHPWG_ROOT_PATH.'admin.php'. - get_query_string_diff(array('del')); - - $del_param = 'e='.$image[id]. - '&u='.$row['user_id']. - '&a='.$row['anonymous_id']; - - $url_del .= '&del='.urlencode(urlencode($del_param)); - - if ( isset($users[$row['user_id']]) ) - { - $user = $users[$row['user_id']]; - } - else - { - $user = '? '. $row['user_id']; - } - if ( strlen($row['anonymous_id'])>0 ) - { - $user .= '('.$row['anonymous_id'].')'; - } - - $template->assign_block_vars('image.rate', - array( - 'DATE' => format_date($row['date']), - 'RATE' => $row['rate'], - 'USER' => $user, - 'U_DELETE' => $url_del - ) - ); - } -} -//print_r($template->_tpldata); -// +-----------------------------------------------------------------------+ -// | sending html code | -// +-----------------------------------------------------------------------+ -$template->assign_var_from_handle('ADMIN_CONTENT', 'rating'); + ' . $conf['guest_id']; + $template->assign_vars( array( + 'DISPLAY_FILTER_USER_CHECKED'=>'checked="checked"' + ) + ); + } + elseif ( $_GET['display_filter']=='guest' ) + { + $display_filter= ' AND r.user_id =' . $conf['guest_id']; + $template->assign_vars( array( + 'DISPLAY_FILTER_GUEST_CHECKED'=>'checked="checked"' + ) + ); + } +} +if ($display_filter=='') +{ + $template->assign_vars( array( + 'DISPLAY_FILTER_ALL_CHECKED'=>'checked="checked"' + ) + ); +} + +if (isset($_GET['del'])) +{ + $del_params = urldecode( $_GET['del'] ); + parse_str($del_params, $vars); + if ( !is_numeric($vars['e']) or !is_numeric($vars['u']) ) + { + die('Hacking attempt'); + } + $query = ' +DELETE FROM '. RATE_TABLE .' +WHERE element_id=' . $vars['e'] . ' +AND user_id=' . $vars['u'] . ' +AND anonymous_id=\'' . $vars['a'] . '\' +;'; + pwg_query($query); + update_average_rate( $vars['e'] ); +} + +$users = array(); +$query = ' +SELECT '.$conf['user_fields']['username'].' as username, '.$conf['user_fields']['id'].' as id + FROM '.USERS_TABLE.' +;'; +$result = pwg_query($query); +while ($row = mysql_fetch_array($result)) +{ + $users[$row['id']]=$row['username']; +} + + +$query = 'SELECT COUNT(DISTINCT(i.id)) +FROM '.RATE_TABLE.' AS r, '.IMAGES_TABLE.' AS i +WHERE r.element_id=i.id'. $display_filter . +';'; +list($nb_images) = mysql_fetch_row(pwg_query($query)); + + +// +-----------------------------------------------------------------------+ +// | template init | +// +-----------------------------------------------------------------------+ + +$template->set_filenames(array('rating'=>'admin/rating.tpl')); + +$navbar = create_navigation_bar( + PHPWG_ROOT_PATH.'admin.php'.get_query_string_diff(array('start','del')), + $nb_images, + $start, + $elements_per_page, + ''); +$template->assign_vars(array('NAVBAR' => $navbar)); + + +$template->assign_vars( + array( + 'F_ACTION' => PHPWG_ROOT_PATH.'admin.php', + 'DISPLAY' => $elements_per_page, + 'NB_ELEMENTS' => $nb_images + ) + ); + +$available_order_by= array( + array(l10n('Rate date'), 'recently_rated DESC'), + array(l10n('Average rate'), 'average_rate DESC'), + array(l10n('Number of rates'), 'nb_rates DESC'), + array(l10n('Sum of rates'), 'sum_rates DESC'), + array(l10n('Controversy'), 'std_rates DESC'), + array(l10n('File name'), 'file DESC'), + array(l10n('Creation date'), 'date_creation DESC'), + array(l10n('Availability date'), 'date_available DESC'), + + ); + +for ($i=0; $iassign_block_vars( + 'order_by', + array( + 'VALUE' => $i, + 'CONTENT' => $available_order_by[$i][0], + 'SELECTED' => $i==$order_by_index ? 'SELECTED' : '' + ) + ); +} + +$query = 'SELECT i.id, i.path, i.file, i.tn_ext, i.average_rate, i.storage_category_id, + MAX(r.date) as recently_rated, COUNT(r.rate) as nb_rates, + SUM(r.rate) as sum_rates, ROUND(STD(r.rate),2) as std_rates +FROM '.RATE_TABLE.' AS r LEFT JOIN '.IMAGES_TABLE.' AS i +ON r.element_id=i.id +WHERE 1=1 ' . $display_filter . ' +GROUP BY r.element_id +ORDER BY ' . $available_order_by[$order_by_index][1] .' +LIMIT '.$start.','.$elements_per_page . +';'; + +$images = array(); +$result = pwg_query($query); +while ($row = mysql_fetch_array($result)) +{ + array_push($images, $row); +} + +foreach ($images as $image) +{ + $thumbnail_src = get_thumbnail_src( + $image['path'], $image['tn_ext'] + ); + + $image_url = PHPWG_ROOT_PATH.'picture.php?'. + 'cat=' . $image['storage_category_id']. + '&image_id=' . $image['id']; + + $query = 'SELECT * +FROM '.RATE_TABLE.' AS r +WHERE r.element_id='.$image['id'] . ' +ORDER BY date DESC;'; + $result = pwg_query($query); + $nb_rates = mysql_num_rows($result); + + $template->assign_block_vars('image', + array( + 'U_THUMB' => $thumbnail_src, + 'U_URL' => $image_url, + 'AVG_RATE' => $image['average_rate'], + 'STD_RATE' => $image['std_rates'], + 'SUM_RATE' => $image['sum_rates'], + 'NB_RATES' => $image['nb_rates'], + 'NB_RATES_TOTAL' => $nb_rates, + 'FILE' => $image['file'], + 'NB_RATES_PLUS1' => $nb_rates+1, + ) + ); + + while ($row = mysql_fetch_array($result)) + { + + $url_del = PHPWG_ROOT_PATH.'admin.php'. + get_query_string_diff(array('del')); + + $del_param = 'e='.$image['id']. + '&u='.$row['user_id']. + '&a='.$row['anonymous_id']; + + $url_del .= '&del='.urlencode(urlencode($del_param)); + + if ( isset($users[$row['user_id']]) ) + { + $user = $users[$row['user_id']]; + } + else + { + $user = '? '. $row['user_id']; + } + if ( strlen($row['anonymous_id'])>0 ) + { + $user .= '('.$row['anonymous_id'].')'; + } + + $template->assign_block_vars('image.rate', + array( + 'DATE' => format_date($row['date']), + 'RATE' => $row['rate'], + 'USER' => $user, + 'U_DELETE' => $url_del + ) + ); + } +} +//print_r($template->_tpldata); +// +-----------------------------------------------------------------------+ +// | sending html code | +// +-----------------------------------------------------------------------+ +$template->assign_var_from_handle('ADMIN_CONTENT', 'rating'); ?> \ No newline at end of file -- cgit v1.2.3