| Zeile 6 | Zeile 6 |
|---|
* Website: http://mybb.com
* License: http://mybb.com/about/license
*
|
* Website: http://mybb.com
* License: http://mybb.com/about/license
*
|
* $Id: attachments.php 5453 2011-04-21 23:58:33Z jammerx2 $
| * $Id$
|
*/
// Disallow direct access to this file for security reasons
| */
// Disallow direct access to this file for security reasons
|
| Zeile 365 | Zeile 365 |
|---|
$query = $db->simple_select("attachments", "*", "aid IN (".implode(",", $aids).")");
while($attachment = $db->fetch_array($query))
{
|
$query = $db->simple_select("attachments", "*", "aid IN (".implode(",", $aids).")");
while($attachment = $db->fetch_array($query))
{
|
| | $attachment['filename'] = htmlspecialchars_uni($attachment['filename']);
|
if($missing_attachment_files[$attachment['aid']])
{
$reason = $lang->reason_file_missing;
| if($missing_attachment_files[$attachment['aid']])
{
$reason = $lang->reason_file_missing;
|
| Zeile 379 | Zeile 381 |
|---|
}
$table->construct_cell($form->generate_check_box('orphaned_attachments[]', $attachment['aid'], '', array('checked' => true)));
$table->construct_cell(get_attachment_icon(get_extension($attachment['filename'])), array('width' => 1));
|
}
$table->construct_cell($form->generate_check_box('orphaned_attachments[]', $attachment['aid'], '', array('checked' => true)));
$table->construct_cell(get_attachment_icon(get_extension($attachment['filename'])), array('width' => 1));
|
$table->construct_cell("<span class=\"float_right\">".get_friendly_size($attachment['filesize'])."</span><a href=\"../attachment.php?aid={$attachment['aid']}\" target=\"_blank\">{$attachment['filename']}</a>", array('class' => $cell_class));
| $table->construct_cell("<span class=\"float_right\">".get_friendly_size($attachment['filesize'])."</span>{$attachment['filename']}", array('class' => $cell_class));
|
$table->construct_cell($reason, array('class' => 'align_center'));
if($attachment['dateuploaded'])
{
| $table->construct_cell($reason, array('class' => 'align_center'));
if($attachment['dateuploaded'])
{
|
| Zeile 586 | Zeile 588 |
|---|
{
$bad_attachments = serialize($bad_attachments);
echo $form->generate_hidden_field("bad_attachments", $bad_attachments);
|
{
$bad_attachments = serialize($bad_attachments);
echo $form->generate_hidden_field("bad_attachments", $bad_attachments);
|
}
| }
|
$form->end();
echo "<script type=\"text/javascript\">Event.observe(window, 'load', function() {
window.setTimeout(
| $form->end();
echo "<script type=\"text/javascript\">Event.observe(window, 'load', function() {
window.setTimeout(
|
| Zeile 714 | Zeile 716 |
|---|
// Now we fetch the results if there were 100% no errors
if(!$errors)
{
|
// Now we fetch the results if there were 100% no errors
if(!$errors)
{
|
| | $mybb->input['perpage'] = intval($mybb->input['perpage']);
|
if(!$mybb->input['perpage'])
{
$mybb->input['perpage'] = 20;
}
|
if(!$mybb->input['perpage'])
{
$mybb->input['perpage'] = 20;
}
|
$mybb->input['perpage'] = intval($mybb->input['perpage']);
| |
$mybb->input['page'] = intval($mybb->input['page']);
if($mybb->input['page'])
|
$mybb->input['page'] = intval($mybb->input['page']);
if($mybb->input['page'])
|
| Zeile 733 | Zeile 735 |
|---|
switch($mybb->input['sortby'])
{
|
switch($mybb->input['sortby'])
{
|
case "lastactive":
| case "filesize":
|
$sort_field = "a.filesize";
break;
case "downloads":
| $sort_field = "a.filesize";
break;
case "downloads":
|
| Zeile 750 | Zeile 752 |
|---|
$mybb->input['sortby'] = "filename";
}
|
$mybb->input['sortby'] = "filename";
}
|
if($mybb->input['sortorder'] != "desc")
| if($mybb->input['order'] != "desc")
|
{
|
{
|
$mybb->input['sortorder'] = "asc";
| $mybb->input['order'] = "asc";
|
}
$page->add_breadcrumb_item($lang->results);
| }
$page->add_breadcrumb_item($lang->results);
|
| Zeile 779 | Zeile 781 |
|---|
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=a.uid)
WHERE {$search_sql}
|
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=a.uid)
WHERE {$search_sql}
|
ORDER BY {$sort_field} {$mybb->input['sortorder']}
| ORDER BY {$sort_field} {$mybb->input['order']}
|
LIMIT {$start}, {$mybb->input['perpage']}
");
while($attachment = $db->fetch_array($query))
| LIMIT {$start}, {$mybb->input['perpage']}
");
while($attachment = $db->fetch_array($query))
|
| Zeile 791 | Zeile 793 |
|---|
if($num_results > $mybb->input['perpage'])
{
$pagination_url = "index.php?module=forum-attachments&results=1";
|
if($num_results > $mybb->input['perpage'])
{
$pagination_url = "index.php?module=forum-attachments&results=1";
|
$pagination_vars = array('filename', 'mimetype', 'username', 'fid', 'downloads', 'downloads_dir', 'dateuploaded', 'dateuploaded_dir', 'filesize', 'filesize_dir');
| $pagination_vars = array('perpage', 'sortby', 'order', 'filename', 'mimetype', 'username', 'fid', 'downloads', 'downloads_dir', 'dateuploaded', 'dateuploaded_dir', 'filesize', 'filesize_dir');
|
foreach($pagination_vars as $var)
{
if($mybb->input[$var])
| foreach($pagination_vars as $var)
{
if($mybb->input[$var])
|
| Zeile 875 | Zeile 877 |
|---|
function build_attachment_row($attachment, &$table, $use_form=false)
{
global $mybb, $form;
|
function build_attachment_row($attachment, &$table, $use_form=false)
{
global $mybb, $form;
|
$attachment['filename'] = htmlspecialchars($attachment['filename']);
| $attachment['filename'] = htmlspecialchars_uni($attachment['filename']);
|
// Here we do a bit of detection, we want to automatically check for removal any missing attachments and any not assigned to a post uploaded > 24hours ago
// Check if the attachment exists in the file system
|
// Here we do a bit of detection, we want to automatically check for removal any missing attachments and any not assigned to a post uploaded > 24hours ago
// Check if the attachment exists in the file system
|
| Zeile 926 | Zeile 928 |
|---|
$attachment['username'] = $attachment['username'];
}
$table->construct_cell(build_profile_link($attachment['username'], $attachment['uid'], "_blank"), array("class" => "align_center"));
|
$attachment['username'] = $attachment['username'];
}
$table->construct_cell(build_profile_link($attachment['username'], $attachment['uid'], "_blank"), array("class" => "align_center"));
|
$table->construct_cell("<a href=\"../".get_post_link($attachment['pid'])."\" target=\"_blank\">".htmlspecialchars($attachment['subject'])."</a>", array("class" => "align_center"));
| $table->construct_cell("<a href=\"../".get_post_link($attachment['pid'])."\" target=\"_blank\">".htmlspecialchars_uni($attachment['subject'])."</a>", array("class" => "align_center"));
|
$table->construct_cell(my_number_format($attachment['downloads']), array("class" => "align_center"));
if($attachment['dateuploaded'] > 0)
{
| $table->construct_cell(my_number_format($attachment['downloads']), array("class" => "align_center"));
if($attachment['dateuploaded'] > 0)
{
|