Wicher's phpBB2 Mods Forum Index Wicher's phpBB2 Mods
On this board you will find all phpBB2 mods that i have created over the years. Most mods are on this board installed. Before asking for support, be sure to have your board updated to the latest phpBB2 version.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 Simple db_update generatorSimple db_update generator   Advanced db_update generatorAdvanced db_update generator 
 This board is protected by Phpbbantispam 

Adjusted ViewAttachment

 
Board Alert Board Message
There are in this topic 8 posts to view if you are logged in.

You can log in or register via the login / registerlink here or in the header.
Back to top  Login here and be redirected to this TopicLogin here and be redirected to this Topic RegisterRegister
Reply to topic    Wicher's phpBB2 Mods Forum Index -> Wicher's phpBB Mods Was this Topic Helpful?  
Points for this topic: 0
Topic gradiation: 
View previous topic :: View next topic  
Author Adjusted ViewAttachment
Wicher
Site Admin


Joined: 16 Dec 2005
Posts: 1144
User's local time:
2023 Mar 30 - 9:46 AM
Country IP         : Netherlands
Country of choice: Netherlands


Was This Post Helpful?
 
Users postingpoints:
58
Posts points:
0
Post gradiation:
PostPosted: Wed Dec 21, 2005 6:42 pm    Post subject: Reply with quote
I changed some code in the viewattachment mod so it now displayes no longer only the links to the attachments but shows the images that are attached.
This only works oke with images that are attached, not with zips or txt or whatever.
The attachments can be show user by user by clicking on the users name.

For the rest: USE AT OWN RISK AND MAKE BACKUPS!!!!
(with thanks to thoul for pointing me in some right directions without knowing where is was for.)


You can view an example at: http://www.wichersmods.nl/attachments.php
When your there, click on a username at the right of the image to see the attachments from that user only.

Before u can use this u willl have to install also:
http://www.phpbbhacks.com/download/4863

Also download the attachment at the bottom of this posting, extract the zip in your images folder.


ATTACHMENTS.PHP:
Code:
  2. <?php
  3. /***************************************************************************
  4.  *                        attachments.php
  5.  *                            -------------------
  6.  *   begin                : Friday, Aug 23, 2002
  7.  *   copyright            : (C) 2002 Meik Sievertsen
  8.  *   email                : acyd.burn@gmx.de
  9.  *
  10.  *   $Id: attachments.php,v 1.0.2 2003/08/31 meik Exp $
  11.  *
  12.  *   This version of attachments.php is heavely adjusted for my own needs.
  13.  *   Use at own risk.
  14.  *   
  15.  ***************************************************************************/
  17. /***************************************************************************
  18.  *
  19.  *   This program is free software; you can redistribute it and/or modify
  20.  *   it under the terms of the GNU General Public License as published by
  21.  *   the Free Software Foundation; either version 2 of the License, or
  22.  *   (at your option) any later version.
  23.  *
  24.  ***************************************************************************/
  26. define('IN_PHPBB', true);
  27. $phpbb_root_path = './';
  28. include($phpbb_root_path . 'extension.inc');
  29. include($phpbb_root_path . 'common.'.$phpEx);
  31. //
  32. // Start session management
  33. //
  34. $userdata = session_pagestart($user_ip, PAGE_INDEX);
  35. init_userprefs($userdata);
  36. //
  37. // End session management
  38. //
  41. if( !$userdata['session_logged_in'] || !isset($userdata))
  42. {
  43. redirect("login.$phpEx?redirect=attachments.$phpEx");
  44. }
  47. $attachment_mod_installed = ( defined('ATTACH_CONFIG_TABLE') ) ? TRUE : FALSE;
  49. if (!$attachment_mod_installed)
  50. {
  51.    message_die(GENERAL_MESSAGE, "The Attachment Mod have to be installed in order to see the Attachment List.");
  52. }
  54. $sql = 'SELECT config_value
  55.    FROM ' . ATTACH_CONFIG_TABLE . "
  56.    WHERE config_name = 'attach_version'";
  58. if (!($result = $db->sql_query($sql)))
  59. {
  60.    message_die(GENERAL_ERROR, "Unable to query config table.", '', __LINE__, __FILE__, $sql);
  61. }
  63. if (!($row = $db->sql_fetchrow($result)))
  64. {
  65.    message_die(GENERAL_MESSAGE, 'Wrong Attachment Version detected.<br />Please update your Attachment Mod (V' . ATTACH_VERSION . ') to at least Version 3.0.0.');
  66. }
  68. $attachment_version = $row['config_value'];
  70. $real_filename = 'real_filename';
  71. $attach_table = ATTACHMENTS_TABLE;
  72. $attach_desc_table = ATTACHMENTS_DESC_TABLE;
  74. $sql = 'SELECT config_value
  75.    FROM ' . CONFIG_TABLE . "
  76.    WHERE config_name = 'default_lang'";
  78. if (!($result = $db->sql_query($sql)))
  79. {
  80.    message_die(GENERAL_ERROR, "Unable to query config table.", '', __LINE__, __FILE__, $sql);
  81. }
  83. $default_lang = $db->sql_fetchrow($result);
  84. $default_lang = $default_lang['config_value'];
  86. $language = $board_config['default_lang'];
  88. if( !file_exists($phpbb_root_path . 'language/lang_' . $language . '/lang_admin_attach.'.$phpEx) )
  89. {
  90.    $language = $default_lang;
  91. }
  93. include($phpbb_root_path . 'language/lang_' . $language . '/lang_admin_attach.' . $phpEx);
  95. //
  96. // Start user modifiable variables
  97. //
  99. //
  100. // Define the default forum by forum-id OR by Forum Name
  101. // If both are set, the forum id is used
  102. // To display the Attachments of all Forums, please set the display_all variable to true
  103. //
  104. $default_forum_id = '';
  105. $default_forum_name = '';
  107. // Set this to FALSE or fill the above values for a specific forum to be displayed
  108. $display_all_forums = TRUE;
  110. //
  111. // File extensions to show
  112. // If not present here, viewattachments will show an empty tablecell
  113. $image_files = array(
  114.            'bmp',
  115.            'jpg',
  116.            'png',
  117.            'tga',
  118.            'gif',
  119.            'peg');
  120. $flash_files = array(
  121.            'swf');
  122. $zip_files = array(
  123.            'tar',
  124.            'ace',
  125.            'zip',
  126.            'rar',
  127.            '.gz');
  128. $doc_files = array(
  129.            'doc',
  130.            'xls',
  131.            'dot',
  132.            'pdf',
  133.            '.ps',
  134.            '.ai',
  135.            'pps',
  136.            'ppt');
  137. $txt_files = array(
  138.            'txt',
  139.            'cpp',
  140.            'diz',
  141.            'inf',
  142.            'hpp');
  143. $video_files = array(
  144.            'avi',
  145.            'mpg',
  146.            '.rm',
  147.            'wma',
  148.            'wmv');
  149. $sound_files = array(
  150.            'mp3',
  151.            'wav',
  152.            'mid');
  154. //
  155. // Define the default Sort.
  156. // Valid values are: filename, comment, filesize, downloads, post_time
  157. //
  158. $default_sort_method = 'filename';
  160. //
  161. // Default Sort Order: ASC or DESC
  162. //
  163. $default_sort_order = 'ASC';
  164. //
  165. // End user modifiable variables
  166. //
  168. //
  169. // Determine the variables we need for sorting and such
  170. //
  171. $start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0;
  172. if(isset($HTTP_POST_VARS['order']))
  173. {
  174.    $sort_order = ($HTTP_POST_VARS['order'] == 'ASC') ? 'ASC' : 'DESC';
  175. }
  176. else if(isset($HTTP_GET_VARS['order']))
  177. {
  178.    $sort_order = ($HTTP_GET_VARS['order'] == 'ASC') ? 'ASC' : 'DESC';
  179. }
  180. else
  181. {
  182.    $sort_order = $default_sort_order;
  183. }
  185. if(isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode']))
  186. {
  187.    $mode = (isset($HTTP_POST_VARS['mode'])) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];
  188. }
  189. else
  190. {
  191.    $mode = $default_sort_method;
  192. }
  194. // Sort and Mode Select
  195. $mode_types_text = array($lang['Sort_Filename'], $lang['Sort_Comment'], $lang['Sort_Size'], $lang['Sort_Downloads'], $lang['Sort_Posttime']);
  196. $mode_types = array('filename', 'comment', 'filesize', 'downloads', 'post_time');
  198. $select_sort_mode = '<select name="mode">';
  199. for($i = 0; $i < count($mode_types_text); $i++)
  200. {
  201.    $selected = ( $mode == $mode_types[$i] ) ? ' selected="selected"' : '';
  202.    $select_sort_mode .= '<option value="' . $mode_types[$i] . '"' . $selected . '>' . $mode_types_text[$i] . '</option>';
  203. }
  204. $select_sort_mode .= '</select>';
  206. $select_sort_order = '<select name="order">';
  207. if($sort_order == 'ASC')
  208. {
  209.    $select_sort_order .= '<option value="ASC" selected="selected">' . $lang['Sort_Ascending'] . '</option><option value="DESC">' . $lang['Sort_Descending'] . '</option>';
  210. }
  211. else
  212. {
  213.    $select_sort_order .= '<option value="ASC">' . $lang['Sort_Ascending'] . '</option><option value="DESC" selected="selected">' . $lang['Sort_Descending'] . '</option>';
  214. }
  215. $select_sort_order .= '</select>';
  217. switch ($mode)
  218. {
  219.    case 'filename':
  220.       $order_by = '' . $real_filename . ' ' . $sort_order . ' LIMIT ' . $start . ', ' . $board_config['posts_per_page'];
  221.       break;
  222.    case 'comment':
  223.       $order_by = 'comment ' . $sort_order . ' LIMIT ' . $start . ', ' . $board_config['posts_per_page'];
  224.       break;
  225.    case 'filesize':
  226.       $order_by = 'filesize ' . $sort_order . ' LIMIT ' . $start . ', ' . $board_config['posts_per_page'];
  227.       break;
  228.    case 'downloads':
  229.       $order_by = 'download_count ' . $sort_order . ' LIMIT ' . $start . ', ' . $board_config['posts_per_page'];
  230.       break;
  231.    case 'post_time':
  232.       $order_by = 'filetime ' . $sort_order . ' LIMIT ' . $start . ', ' . $board_config['posts_per_page'];
  233.       break;
  234.    default:
  235.       message_die(GENERAL_MESSAGE, "Please have a look at the attachments.php file and define valid sort order default values.");
  236.       break;
  237. }
  239. // Forum Select
  240. if(isset($HTTP_GET_VARS[POST_FORUM_URL]) || isset($HTTP_POST_VARS[POST_FORUM_URL]))
  241. {
  242.    $forum_id = (isset($HTTP_POST_VARS[POST_FORUM_URL])) ? $HTTP_POST_VARS[POST_FORUM_URL] : $HTTP_GET_VARS[POST_FORUM_URL];
  243.   if ($forum_id == -1)
  244.   {
  245.     $forum_id = '*';
  246.     $display_all_forums = true;
  247.   }
  248. }
  249. else
  250. {
  251.    $default_forum_id = intval($default_forum_id);
  252.    if ($default_forum_id)
  253.    {
  254.       $forum_id = intval($default_forum_id);
  255.    }
  256.    else if ($default_forum_name != '')
  257.    {
  258.       $sql = "SELECT forum_id
  259.       FROM " . FORUMS_TABLE . "
  260.       WHERE forum_name='" . $default_forum_name . "'";
  261.    
  262.       if ( !($result = $db->sql_query($sql) ))
  263.       {
  264.          message_die(GENERAL_MESSAGE, "Please specify a valid Forum Name.'" . $default_forum_name . "' could not be found.");
  265.       }
  267.       $row = $db->sql_fetchrow($result);
  268.       $forum_id = $row['forum_id'];
  269.    }
  270.    else if (!$display_all_forums)
  271.    {
  272.       message_die(GENERAL_MESSAGE, "Please have a look at the attachments.php file and define valid forum default values.");
  273.    }
  275.    if ($forum_id)
  276.    {
  277.       $sql = "SELECT forum_id
  278.       FROM " . FORUMS_TABLE . "
  279.       WHERE forum_id = $forum_id
  280.       LIMIT 1";
  282.       if ( !($result = $db->sql_query($sql) ))
  283.       {
  284.          message_die(GENERAL_ERROR, "Couldn't query forums table.", '', __LINE__, __FILE__, $sql);
  285.       }
  287.       if ($db->sql_numrows($result) == 0)
  288.       {
  289.          message_die(GENERAL_MESSAGE, "The default forum id/name does not exist, please check your default values.");
  290.       }
  291.    }
  292. }
  294. //
  295. // Search forum - first delete those the user have not access to and then those the user have no permission to download to.
  296. //
  297. $sql = "SELECT c.cat_title, c.cat_id, f.forum_name, f.forum_id 
  298.    FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f
  299.    WHERE f.cat_id = c.cat_id
  300.    ORDER BY c.cat_id, f.forum_order";
  302. if ( !($result = $db->sql_query($sql)) )
  303. {
  304.    message_die(GENERAL_ERROR, 'Could not obtain forum_name/forum_id', '', __LINE__, __FILE__, $sql);
  305. }
  307. $is_auth_ary = auth(AUTH_READ, AUTH_LIST_ALL, $userdata);
  308. $is_download_auth_ary = auth(AUTH_DOWNLOAD, AUTH_LIST_ALL, $userdata);
  310. $forum_ids = array();
  311. $select_forums = '';
  312. while( $row = $db->sql_fetchrow($result) )
  313. {
  314.    if ( ( $is_auth_ary[$row['forum_id']]['auth_read'] ) && ( $is_download_auth_ary[$row['forum_id']]['auth_download'] ) )
  315.    {
  316.       $selected = ( $forum_id == $row['forum_id'] ) ? ' selected="selected"' : '';
  317.       $select_forums .= '<option value="' . $row['forum_id'] . '"' . $selected . '>' . $row['forum_name'] . '</option>';
  318.       $forum_ids[] = $row['forum_id'];
  319.    }
  320. }
  322. if ( $select_forums != '' )
  323. {
  324.    $select_forums = '<select name="' . POST_FORUM_URL . '"><option value="-1">' . $lang['All_available'] . '</option>' . $select_forums . '</select>';
  325. }
  327. else
  328. {
  329.    message_die(GENERAL_MESSAGE, "You are not authorized to view Attachments at all.");
  330. }
  332. $forum_id = intval($forum_id);
  334. $page_title = $lang['Statistics'];
  335. include($phpbb_root_path . 'includes/page_header.'.$phpEx);
  337. $template->set_filenames(array(
  338.    'body' => 'attachments.tpl')
  339. );
  340. $sql = '';
  342. $user = ( isset($_REQUEST['gebruiker']) ) ? htmlspecialchars(strip_tags(trim($_REQUEST['gebruiker']))) : '';
  343. if ($user != '')
  344. {
  345.    if (!$forum_id && $display_all_forums)
  346.    {
  347.       $sql = "SELECT a.*, t.topic_title, d.*, u.*
  348.          FROM " . $attach_table . " a, " . $attach_desc_table . " d, "  . POSTS_TABLE . " p, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u
  349.          WHERE (a.post_id = p.post_id)
  350.          AND (p.forum_id IN (" . implode(', ', $forum_ids) . "))
  351.          AND (p.topic_id = t.topic_id)
  352.          AND (a.attach_id = d.attach_id)
  353.          AND (a.user_id_1 = u.user_id)
  354.             AND (u.username = '" . $user . "')
  355.          ORDER BY $order_by";
  356.    }
  357.    else if (($is_auth_ary[$forum_id]['auth_read']) && ($is_download_auth_ary[$forum_id]['auth_download']))
  358.    {
  359.       $sql = "SELECT a.*, t.topic_title, d.*, u.*
  360.          FROM " . $attach_table . " a, " . $attach_desc_table . " d, "  . POSTS_TABLE . " p, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u
  361.          WHERE (a.post_id = p.post_id)
  362.          AND (p.forum_id = " . $forum_id . ")
  363.          AND (p.topic_id = t.topic_id)
  364.          AND (a.attach_id = d.attach_id)
  365.          AND (a.user_id_1 = u.user_id)
  366.             AND (u.username = '" . $user . "')
  367.          ORDER BY $order_by";
  368.    }
  369. $backtobegin = '<a href="attachments.php">' . $lang['BackToAll'] . '</a>';
  370. $useronly = $lang['Attachmentsfrom'] . $user;
  371. }
  372. else
  373. {
  374.    if (!$forum_id && $display_all_forums)
  375.    {
  376.       $sql = "SELECT a.*, t.topic_title, d.*, u.*
  377.          FROM " . $attach_table . " a, " . $attach_desc_table . " d, "  . POSTS_TABLE . " p, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u
  378.          WHERE (a.post_id = p.post_id)
  379.          AND (p.forum_id IN (" . implode(', ', $forum_ids) . "))
  380.          AND (p.topic_id = t.topic_id)
  381.          AND (a.attach_id = d.attach_id)
  382.          AND (a.user_id_1 = u.user_id)
  383.          ORDER BY $order_by";
  384.    }
  385.    else if (($is_auth_ary[$forum_id]['auth_read']) && ($is_download_auth_ary[$forum_id]['auth_download']))
  386.    {
  387.       $sql = "SELECT a.*, t.topic_title, d.*, u.*
  388.          FROM " . $attach_table . " a, " . $attach_desc_table . " d, "  . POSTS_TABLE . " p, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u
  389.          WHERE (a.post_id = p.post_id)
  390.          AND (p.forum_id = " . $forum_id . ")
  391.          AND (p.topic_id = t.topic_id)
  392.          AND (a.attach_id = d.attach_id)
  393.          AND (a.user_id_1 = u.user_id)
  394.          ORDER BY $order_by";
  395.    }
  396. $backtobegin = '';
  397. $useronly = $lang['AllAttachments'];
  398. }
  400. $tussen = '»';
  401. $nodesc = $lang['no_desc'];
  403. $template->set_filenames(array(
  404.    'body' => 'attachments.tpl')
  405. );
  407. $template->assign_vars(array(
  408.    'L_SELECT_SORT_METHOD' => $lang['Select_sort_method'],
  409.    'L_ORDER' => $lang['Order'],
  410.    'L_SORT' => $lang['Sort'],
  411.    'L_SUBMIT' => $lang['Submit'],
  412.    'L_FORUM' => $lang['Forum'],
  414.    'L_ATTACHMENTS' => $lang['Attachments'],
  415.    'L_FILENAME' => $lang['File_name'],
  416.    'L_FILECOMMENT' => $lang['File_comment'],
  417.    'L_SIZE' => $lang['Size_in_kb'],
  418.    'L_DOWNLOADS' => $lang['Downloads'],
  419.    'L_POST_TIME' => $lang['Post_time'],
  420.    'L_POSTED_IN_TOPIC' => $lang['Posted_in_topic'],
  421.    
  422.    'S_MODE_SELECT' => $select_sort_mode,
  423.    'S_ORDER_SELECT' => $select_sort_order,
  424.    'S_FORUM_SELECT' => $select_forums,
  425.    'USERONLY' => $useronly,
  426.    'BYUSER' => $lang['From'],
  427.    'IMG_NUM' => $lang['number'],
  428.    'SEEN' => $lang['seen'],
  429.    'POSTED_IN' => $lang['posted_in'],
  430.    'DESC_IMG' => $lang['desc_img'],
  431.    'CLICKTOENLARGE' => $lang['click_to_enlarge'],
  432.    'IMG_' => $lang['img_'],
  433.    'TUSSEN' => $tussen,
  434.    'ONLYUSERATTACH' => $lang['only_user_attach'],
  435.    'FILE_NAME' => $lang['file_name'],
  436.    'FILE_NAME' => $lang['file_name'],
  437.    'S_MODE_ACTION' => append_sid("attachments.$phpEx"))
  438. );
  440.    
  441. if ($sql != '')
  442. {
  443.    if (!($result = $db->sql_query($sql)))
  444.    {
  445.       message_die(GENERAL_ERROR, 'Couldn\'t query attachments', '', __LINE__, __FILE__, $sql);
  446.    }
  447.    
  448.    $attachments = $db->sql_fetchrowset($result);
  449.    $num_attachments = $db->sql_numrows($result);
  450. }
  451. else
  452. {
  453.    $attachments = array();
  454.    $num_attachments = 0;
  455. }
  457. for ($i = 0; $i < $num_attachments; $i++)
  458. {
  459.    $class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
  460.   $filename = $attachments[$i][$real_filename];
  461.   $file_ext = substr($filename, (strlen($filename) - 3), strlen($filename));
  462.   $file_ext = strtolower($file_ext);
  464.    $post_title = $attachments[$i]['topic_title'];
  465.    $post_title_2 = '';
  466.    
  467.    if (strlen($post_title) > 32)
  468.    {
  469.       $post_title_2 = substr($post_title, 0, 30) . '...';
  470.    }
  472.    $view_topic = append_sid('viewtopic.' . $phpEx . '?' . POST_POST_URL . '=' . $attachments[$i]['post_id'] . '#' . $attachments[$i]['post_id']);
  473.    if ($post_title_2 != '')
  474.    {
  475.       $post_title = '<a href="' . $view_topic . '" class="gen" title="' . $post_title . '" target="_blank">' . $post_title_2 . '</a>';
  476.    }
  477.    else
  478.    {
  479.       $post_title = '<a href="' . $view_topic . '" class="gen" target="_blank">' . $post_title . '</a>';
  480.    }
  482.    $comment = htmlspecialchars($attachments[$i]['comment']);
  483.    $comment_2 = '';
  485.    if (strlen($comment) > 298)
  486.    {
  487.       $comment_2 = substr($comment, 0, 300) . '...';
  488.    }
  490.    if ($comment_2 != '')
  491.    {
  492.       $comment_field = '<span title="' . $comment . '">' . $comment_2 . '</span>';
  493.    }
  494.    else
  495.    {
  496.       $comment_field = $comment;
  497.    }
  499.    if (strlen($comment) < 1)
  500.    {
  501.       $comment_field = $nodesc;
  502.    }
  505.    
  506. //   $filename = $attachments[$i][$real_filename];
  507.    $filename_2 = '';
  508.    
  509.    if (strlen($filename) > 25)
  510.    {
  511. $filename = strrev($filename);
  512.       $filename_2 = substr($filename, 0, 23) . '...';
  513. $filename_2 = strrev($filename_2);
  514. $filename = strrev($filename);
  515.    }
  516.    else
  517.    {
  518.    $filename_2 = $filename;
  519.    }
  521. $view_attachment = 'files/' . ($attachments[$i]['physical_filename']);
  524. if ( in_array($file_ext, $image_files) )
  525. {
  526.    if ($filename_2 != '')
  527.    {
  528.       $filename_link = '<a href="' . $view_attachment . '" class="gen" title="' . $filename . '" target="_blank"><img src="size.php?pic=' . $view_attachment . '"></a>';
  529.       }
  530.    else
  531.    {
  532.          $filename_link = '<a href="' . $view_attachment . '" class="gen" target="_blank"><img src="size.php?pic=' . $view_attachment . '"></a>';
  533.    }
  534. }
  535. else
  536. {
  537.    if ( in_array($file_ext, $flash_files) )
  538.    {
  539.          if ($filename_2 != '')
  540.          {
  541.          $filename_link = '<a href="' . $view_attachment . '" class="gen" title="' . $filename . '" target="_blank"><img src="images/flash.gif"></a>';
  542.          }
  543.          else
  544.          {
  545.                $filename_link = '<a href="' . $view_attachment . '" class="gen" target="_blank"><img src="images/flash.gif"></a>';
  546.          }
  547.    }
  548.    elseif ( in_array($file_ext, $zip_files) )
  549.    {
  550.          if ($filename_2 != '')
  551.          {
  552.          $filename_link = '<a href="' . $view_attachment . '" class="gen" title="' . $filename . '" target="_blank"><img src="images/zip.gif"></a>';
  553.          }
  554.          else
  555.          {
  556.                $filename_link = '<a href="' . $view_attachment . '" class="gen" target="_blank"><img src="images/zip.gif"></a>';
  557.          }
  558.    }
  559.    elseif ( in_array($file_ext, $txt_files) )
  560.    {
  561.          if ($filename_2 != '')
  562.          {
  563.          $filename_link = '<a href="' . $view_attachment . '" class="gen" title="' . $filename . '" target="_blank"><img src="images/txt.gif"></a>';
  564.          }
  565.          else
  566.          {
  567.                $filename_link = '<a href="' . $view_attachment . '" class="gen" target="_blank"><img src="images/txt.gif"></a>';
  568.          }
  569.    }
  570.    elseif ( in_array($file_ext, $doc_files) )
  571.    {
  572.          if ($filename_2 != '')
  573.          {
  574.          $filename_link = '<a href="' . $view_attachment . '" class="gen" title="' . $filename . '" target="_blank"><img src="images/doc.gif"></a>';
  575.          }
  576.          else
  577.          {
  578.                $filename_link = '<a href="' . $view_attachment . '" class="gen" target="_blank"><img src="images/doc.gif"></a>';
  579.          }
  580.    }
  581.    elseif ( in_array($file_ext, $video_files) )
  582.    {
  583.          if ($filename_2 != '')
  584.          {
  585.          $filename_link = '<a href="' . $view_attachment . '" class="gen" title="' . $filename . '" target="_blank"><img src="images/mpg.gif"></a>';
  586.          }
  587.          else
  588.          {
  589.                $filename_link = '<a href="' . $view_attachment . '" class="gen" target="_blank"><img src="images/mpg.gif"></a>';
  590.          }
  591.    }
  592.    elseif ( in_array($file_ext, $sound_files) )
  593.    {
  594.          if ($filename_2 != '')
  595.          {
  596.          $filename_link = '<a href="' . $view_attachment . '" class="gen" title="' . $filename . '" target="_blank"><img src="images/mp3.gif"></a>';
  597.          }
  598.          else
  599.          {
  600.                $filename_link = '<a href="' . $view_attachment . '" class="gen" target="_blank"><img src="images/mp3.gif"></a>';
  601.          }
  602.    }
  603. }
  606. $userfinds = '<a href="attachments.php?gebruiker=' . $attachments[$i]['username'] . '">' . $attachments[$i]['username'] . '</a>';
  608.    $template->assign_block_vars('attachrow', array(
  609.       'ROW_NUMBER' => $i + ( $HTTP_GET_VARS['start'] + 1 ),
  610.       'ROW_CLASS' => $class,
  612.       'FILENAME' => $filename,
  613.      'FILENAME_2' => $filename_2,
  614.       'COMMENT' => $comment_field,
  615.       'SIZE' => round(($attachments[$i]['filesize'] / 1024), 2),
  616.       'DOWNLOAD_COUNT' => $attachments[$i]['download_count'],
  617.       'POST_TIME' => create_date($board_config['default_dateformat'], $attachments[$i]['filetime'], $board_config['board_timezone']),
  618.       'POST_TITLE' => $post_title,
  620.       'VIEW_ATTACHMENT' => $filename_link,
  621.       'BACKTOBEGIN' => $backtobegin,
  622.       'BY_USER' => $userfinds)
  623.    );
  624. }
  626. $sql = '';
  629. if ($user != '')
  630. {
  631.    if (!$forum_id && $display_all_forums)
  632.    {
  633.       $sql = "SELECT count(*) AS total
  634.          FROM " . $attach_table . " a, " . USERS_TABLE . " u
  635.          WHERE (a.user_id_1 = u.user_id)
  636.             AND (u.username = '" . $user . "')";
  637.    }
  638.    else if ( ( $is_auth_ary[$forum_id]['auth_read'] ) && ( $is_download_auth_ary[$forum_id]['auth_download'] ) && ($num_attachments > 0) )
  639.    {
  640.       $sql = "SELECT count(*) AS total
  641.          FROM " . $attach_table . " a, " . USERS_TABLE . " u
  642.          WHERE (a.user_id_1 = u.user_id)
  643.             AND (u.username = '" . $user . "')";
  644.    }
  646.    if ($sql != '')
  647.    {
  648.       if (!($result = $db->sql_query($sql)))
  649.       {
  650.          message_die(GENERAL_ERROR, 'Error getting total users', '', __LINE__, __FILE__, $sql);
  651.       }
  653.       if ( $total = $db->sql_fetchrow($result) )
  654.       {
  655.          $total = $total['total'];
  656.          $total = $total-2;
  657.          $pagination = generate_pagination("{$phpbb_root_path}attachments.$phpEx?mode=$mode&amp;gebruiker=" . $user . "&amp;order=$sort_order&amp;" . POST_FORUM_URL . "=$forum_id", $total, $board_config['posts_per_page'], $start). '&nbsp;';
  658.       }
  660.       $template->assign_vars(array(
  661.          'PAGINATION' => $pagination,
  662.          'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / $board_config['posts_per_page'] ) + 1 ), ceil( $total / $board_config['posts_per_page'] )),
  663.          'USER_ID' => 'User ID',
  664.          'L_GOTO_PAGE' => $lang['Goto_page'])
  665.       );
  666.    }
  667. }
  668. else
  669. {
  670.    if (!$forum_id && $display_all_forums)
  671.    {
  672.       $sql = "SELECT count(*) AS total
  673.          FROM " . $attach_table . " a, " . POSTS_TABLE . " p
  674.          WHERE (a.post_id = p.post_id) AND (p.forum_id IN (" . implode(', ', $forum_ids) . "))";
  675.    }
  676.    else if ( ( $is_auth_ary[$forum_id]['auth_read'] ) && ( $is_download_auth_ary[$forum_id]['auth_download'] ) && ($num_attachments > 0) )
  677.    {
  678.       $sql = "SELECT count(*) AS total
  679.          FROM " . $attach_table . " a, " . POSTS_TABLE . " p
  680.          WHERE (a.post_id = p.post_id) AND (p.forum_id = " . $forum_id . ")";
  681.    }
  683.    if ($sql != '')
  684.    {
  685.       if (!($result = $db->sql_query($sql)))
  686.       {
  687.          message_die(GENERAL_ERROR, 'Error getting total users', '', __LINE__, __FILE__, $sql);
  688.       }
  690.       if ( $total = $db->sql_fetchrow($result) )
  691.       {
  692.          $total = $total['total'];
  693.          $total = $total-2;
  694.          $pagination = generate_pagination("{$phpbb_root_path}attachments.$phpEx?mode=$mode&amp;order=$sort_order&amp;" . POST_FORUM_URL . "=$forum_id", $total, $board_config['posts_per_page'], $start). '&nbsp;';
  695.       }
  697.       $template->assign_vars(array(
  698.          'PAGINATION' => $pagination,
  699.          'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / $board_config['posts_per_page'] ) + 1 ), ceil( $total / $board_config['posts_per_page'] )),
  700.          'USER_ID' => 'User ID',
  701.          'L_GOTO_PAGE' => $lang['Goto_page'])
  702.       );
  703.    }
  704. }
  709. $template->pparse('body');
  711. include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
  713. ?>


ATTACHMENTS.TPL:
Code:
  2. <table width="100%" cellspacing="0" cellpadding="0" border="0">
  3.   <tr>
  4.    <td><span class="nav">{PAGE_NUMBER}</span></td>
  5.    <td align="right"><span class="nav">{PAGINATION}</span></td>
  6.   </tr>
  7. </table>
  8. <form method="post" action="{S_MODE_ACTION}">
  9.   <table width="100%" cellspacing="2" cellpadding="2" border="0" align="center">
  10.    <tr>
  11.      <td align="left"><span class="nav"><a href="{U_INDEX}" class="nav">{L_INDEX}</a> {TUSSEN} {USERONLY}</span></td>
  12.    </tr>
  13.    <tr>
  14.      <td align="right" nowrap="nowrap"><span class="genmed">{L_SELECT_SORT_METHOD}:&nbsp;{S_MODE_SELECT}&nbsp;&nbsp;{L_ORDER}&nbsp;{S_ORDER_SELECT}&nbsp;&nbsp;{L_FORUM}&nbsp;{S_FORUM_SELECT}&nbsp;&nbsp;
  15.       <input type="submit" name="submit" value="{L_SUBMIT}" class="liteoption" />
  16.       </span></td>
  17.    </tr>
  18.   </table>
  20.   {ERROR_BOX}
  21.    
  22.   {USERONLY}
  23.    
  24.   <table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
  25.    <tr>
  26.      <th width="610" class="thTop" nowrap="nowrap">{IMG_}</th>
  27.      <th class="thCornerR" nowrap="nowrap">{L_POSTED_IN_TOPIC}</th>
  28.    </tr>
  30.    <!-- BEGIN attachrow -->
  31.    <tr>
  32.    <td class="row" align="center"><span class="gen">{attachrow.VIEW_ATTACHMENT}</span></td>
  33.    <td valign="top" class="row4" align="left" valign="middle"><span class="gen">
  34.    <br><br>{IMG_NUM} <b>{attachrow.ROW_NUMBER}</b>
  35.    <br />{FILE_NAME} <b>{attachrow.FILENAME_2}</b>
  36.    <br />{BYUSER}: <b>{attachrow.BY_USER}</b>
  37.    <br />{ONLYUSERATTACH}
  38.    <br />{SEEN} <b>{attachrow.DOWNLOAD_COUNT}</b>
  39.    <br />{POSTED_IN} <b>{attachrow.POST_TITLE}</b>
  40.    <br /><br />{DESC_IMG} <b>{attachrow.COMMENT}</b>
  41.    <br /><br />{CLICKTOENLARGE}
  42.    <br /><br />{attachrow.BACKTOBEGIN}</span></td>
  43.    </tr>
  44.    <!-- END attachrow -->
  45.    <tr>
  46.      <td class="catbottom" colspan="8" height="28">&nbsp;</td>
  47.    </tr>
  48.   </table>
  50. <table width="100%" cellspacing="0" cellpadding="0" border="0">
  51.   <tr>
  52.    <td><span class="nav">{PAGE_NUMBER}</span></td>
  53.    <td align="right"><span class="nav">{PAGINATION}</span></td>
  54.   </tr>
  55. </table>
  56.   <table width="100%" cellspacing="2" cellpadding="2" border="0" align="center">
  57.    <tr>
  58.      <td align="right" nowrap="nowrap"><span class="genmed">{L_SELECT_SORT_METHOD}:&nbsp;{S_MODE_SELECT}&nbsp;&nbsp;{L_ORDER}&nbsp;{S_ORDER_SELECT}&nbsp;&nbsp;{L_FORUM}&nbsp;{S_FORUM_SELECT}&nbsp;&nbsp;
  59.       <input type="submit" name="submit" value="{L_SUBMIT}" class="liteoption" />
  60.       </span></td>
  61.    </tr>
  62.    <tr>
  63.      <td align="left"><span class="nav"><a href="{U_INDEX}" class="nav">{L_INDEX}</a> {TUSSEN} {USERONLY}</span></td>
  64.    </tr>
  65.   </table>
  67. </form>


LANGMAIN.PHP INSERTS:
If English:
Code:
  2. // View_Attachments_with_image
  3. $lang['number'] = 'Number:';
  4. $lang['seen'] = 'Seen:';
  5. $lang['posted_in'] = 'Posted in:';
  6. $lang['desc_img'] = 'Description:';
  7. $lang['click_to_enlarge'] = 'Click the image to see it at original size.';
  8. $lang['img_'] = 'Image';
  9. $lang['only_user_attach'] = '(Click to see only this users attachments)';
  10. $lang['AllAttachments'] = 'All Attachments';
  11. $lang['Attachmentsfrom'] = 'Attachments from ';
  12. $lang['BackToAll'] = 'To all Attachments';
  13. $lang['file_name'] = 'Filename';
  14. $lang['no_desc'] = 'No description availible';


If Dutch
Code:
  2. // View_Attachments_with_image
  3. $lang['number'] = 'Nummer:';
  4. $lang['seen'] = 'Maal bekeken:';
  5. $lang['posted_in'] = 'Gepost in:';
  6. $lang['desc_img'] = 'Beschrijving:';
  7. $lang['click_to_enlarge'] = 'Klik op de afbeelding om de afbeelding op de <br />originele grootte te bekijken.';
  8. $lang['img_'] = 'Afbeelding';
  9. $lang['only_user_attach'] = '(klik om de vondsten van deze gebruiker te bekijken)';
  10. $lang['AllAttachments'] = 'Alle Vondsten';
  11. $lang['Attachmentsfrom'] = 'Vondsten van ';
  12. $lang['BackToAll'] = 'Naar alle vondsten.';
  13. $lang['file_name'] = 'Bestandsnaam: ';
  14. $lang['no_desc'] = 'Geen beschrijving aanwezig';

_________________

Wicher's phpBB2 Mods | Wicher's phpBB3 Mods | Statistics Mod 4.x.x

Last edited by Wicher on Mon Feb 19, 2007 12:28 pm; edited 5 times in total
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Post new topic    Reply to topic    Wicher's phpBB2 Mods Forum Index -> Wicher's phpBB Mods
Author Adjusted ViewAttachment Replies
Display posts from previous:   
Post new topic   Reply to topic    Wicher's phpBB2 Mods Forum Index -> Wicher's phpBB Mods All times are GMT

Was this Topic Helpful?  
Points for this topic: 0
Topic gradiation: 
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

This board is protected by Phpbbantispam
Powered by phpBB © 2001, 2005 phpBB Group

Googlepage: GooglePullerPage
IP Country Flag 2.9.4 © 2005, 2007 - 3Di (aka 3D)