[mxbb-commits] mx_pafiledb dload_lists.php,1.10,1.11

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_pafiledb
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15490/modules/mx_pafiledb

Modified Files:
	dload_lists.php 
Log Message:
updated

- "latest updated" entries instead of "date added". affects many files
- updated quickdl block

Index: dload_lists.php
===================================================================
RCS file: /cvsroot/mxbb/mx_pafiledb/dload_lists.php,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** dload_lists.php	1 Oct 2005 14:15:19 -0000	1.10
--- dload_lists.php	22 Oct 2005 10:56:15 -0000	1.11
***************
*** 172,176 ****
  	if ( $allowed_cat != '' )
  	{
! 		$sql = "SELECT p.file_ssurl, p.file_id, p.file_name, p.file_desc, p.user_id, p.poster_ip, p.file_creator, p.file_time, p.file_catid, p.file_dls, u.user_id, u.username, r.votes_file, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comments_id) AS comments
  				FROM " . PA_FILES_TABLE . " AS p
  					LEFT JOIN " . USERS_TABLE . " AS u ON p.user_id = u.user_id
--- 172,176 ----
  	if ( $allowed_cat != '' )
  	{
! 		$sql = "SELECT p.file_ssurl, p.file_id, p.file_name, p.file_desc, p.user_id, p.poster_ip, p.file_creator, p.file_time, p.file_update_time, p.file_catid, p.file_dls, u.user_id, u.username, r.votes_file, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comments_id) AS comments
  				FROM " . PA_FILES_TABLE . " AS p
  					LEFT JOIN " . USERS_TABLE . " AS u ON p.user_id = u.user_id
***************
*** 232,235 ****
--- 232,236 ----
  							'POSTER' => $recent_poster,
  							'TIME' => create_date( $board_config['default_dateformat'], $recentrow[$j]['file_time'], $board_config['board_timezone'] ),
+ 							'UPDATED' => create_date( $board_config['default_dateformat'], $recentrow[$j]['file_update_time'], $board_config['board_timezone'] ),
  
  							'VIEW' => $recentrow[$j]['file_dls'],
***************
*** 269,273 ****
  	if ( $allowed_cat != '' )
  	{
! 		$sql = "SELECT p.file_ssurl, p.file_id, p.file_name, p.file_desc, p.user_id, p.poster_ip, p.file_creator, p.file_time, p.file_catid, p.file_dls, u.user_id, u.username, r.votes_file, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comments_id) AS comments
  				FROM " . PA_FILES_TABLE . " AS p
  					LEFT JOIN " . USERS_TABLE . " AS u ON p.user_id = u.user_id
--- 270,274 ----
  	if ( $allowed_cat != '' )
  	{
! 		$sql = "SELECT p.file_ssurl, p.file_id, p.file_name, p.file_desc, p.user_id, p.poster_ip, p.file_creator, p.file_time, p.file_update_time, p.file_catid, p.file_dls, u.user_id, u.username, r.votes_file, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comments_id) AS comments
  				FROM " . PA_FILES_TABLE . " AS p
  					LEFT JOIN " . USERS_TABLE . " AS u ON p.user_id = u.user_id
***************
*** 329,332 ****
--- 330,334 ----
  							'POSTER' => $most_poster,
  							'TIME' => create_date( $board_config['default_dateformat'], $mostrow[$j]['file_time'], $board_config['board_timezone'] ),
+ 							'UPDATED' => create_date( $board_config['default_dateformat'], $mostrow[$j]['file_update_time'], $board_config['board_timezone'] ),
  
  							'VIEW' => $mostrow[$j]['file_dls'],
***************
*** 367,371 ****
  	if ( $allowed_cat != '' )
  	{
! 		$sql = "SELECT p.file_ssurl, p.file_id, p.file_name, p.file_desc, p.user_id, p.poster_ip, p.file_creator, p.file_time, p.file_catid, p.file_dls, u.user_id, u.username, r.votes_file, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comments_id) AS comments
  				FROM " . PA_FILES_TABLE . " AS p
  					LEFT JOIN " . USERS_TABLE . " AS u ON p.user_id = u.user_id
--- 369,373 ----
  	if ( $allowed_cat != '' )
  	{
! 		$sql = "SELECT p.file_ssurl, p.file_id, p.file_name, p.file_desc, p.user_id, p.poster_ip, p.file_creator, p.file_time, p.file_update_time, p.file_catid, p.file_dls, u.user_id, u.username, r.votes_file, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comments_id) AS comments
  				FROM " . PA_FILES_TABLE . " AS p
  					LEFT JOIN " . USERS_TABLE . " AS u ON p.user_id = u.user_id
***************
*** 427,430 ****
--- 429,433 ----
  							'H_POSTER' => $highest_poster,
  							'H_TIME' => create_date( $board_config['default_dateformat'], $highestrow[$j]['file_time'], $board_config['board_timezone'] ),
+ 							'UPDATED' => create_date( $board_config['default_dateformat'], $highestrow[$j]['file_update_time'], $board_config['board_timezone'] ),
  
  							'H_VIEW' => $highestrow[$j]['file_dls'],
***************
*** 465,469 ****
  	if ( $allowed_cat != '' )
  	{
! 		$sql = "SELECT p.file_id, p.file_name, p.file_desc, p.user_id, p.poster_ip, p.file_creator, p.file_time, p.file_catid, p.file_dls, p.file_ssurl, u.user_id, u.username, r.votes_file, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comments_id) AS comments
  				FROM " . PA_FILES_TABLE . " AS p
  					LEFT JOIN " . USERS_TABLE . " AS u ON p.user_id = u.user_id
--- 468,472 ----
  	if ( $allowed_cat != '' )
  	{
! 		$sql = "SELECT p.file_id, p.file_name, p.file_desc, p.user_id, p.poster_ip, p.file_creator, p.file_time, p.file_update_time, p.file_catid, p.file_dls, p.file_ssurl, u.user_id, u.username, r.votes_file, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comments_id) AS comments
  				FROM " . PA_FILES_TABLE . " AS p
  					LEFT JOIN " . USERS_TABLE . " AS u ON p.user_id = u.user_id
***************
*** 525,528 ****
--- 528,532 ----
  							'POSTER' => $rand_poster,
  							'TIME' => create_date( $board_config['default_dateformat'], $randrow[$j]['file_time'], $board_config['board_timezone'] ),
+ 							'UPDATED' => create_date( $board_config['default_dateformat'], $randrow[$j]['file_update_time'], $board_config['board_timezone'] ),
  
  							'VIEW' => $randrow[$j]['file_dls'],
***************
*** 592,595 ****
--- 596,600 ----
  		'L_POSTER' => $lang['Poster'],
  		'L_POSTED' => $lang['Posted'],
+ 		'L_UPDATE_TIME' => $lang['Update_time'],
  		'L_PUBLIC_CATS' => $lang['Public_Categories'] ) 
  	);