| Zeile 1 | Zeile 1 |
|---|
<?php
/**
* MyBB 1.4
|
<?php
/**
* MyBB 1.4
|
* Copyright � 2008 MyBB Group, All Rights Reserved
| * Copyright © 2008 MyBB Group, All Rights Reserved
|
*
* Website: http://www.mybboard.net
* License: http://www.mybboard.net/about/license
*
|
*
* Website: http://www.mybboard.net
* License: http://www.mybboard.net/about/license
*
|
* $Id: attachments.php 4258 2008-10-30 20:04:19Z Tikitiki $
| * $Id: attachments.php 4481 2009-10-13 08:53:34Z Tomm $
|
*/
// Disallow direct access to this file for security reasons
| */
// Disallow direct access to this file for security reasons
|
| Zeile 183 | Zeile 183 |
|---|
$table->construct_header($lang->username);
$table->construct_header($lang->total_size, array('width' => '20%', 'class' => 'align_center'));
|
$table->construct_header($lang->username);
$table->construct_header($lang->total_size, array('width' => '20%', 'class' => 'align_center'));
|
$query = $db->query("
SELECT a.*, u.uid AS useruid, u.username, SUM(a.filesize) as totalsize
FROM ".TABLE_PREFIX."attachments a
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=a.uid)
GROUP BY a.uid
ORDER BY totalsize DESC
LIMIT 5
");
| switch($db->type)
{
case "pgsql":
$query = $db->query("
SELECT a.*, u.uid AS useruid, u.username, SUM(a.filesize) as totalsize
FROM ".TABLE_PREFIX."attachments a
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=a.uid)
GROUP BY ".$db->build_fields_string("attachments", "a.").",u.uid,u.username
ORDER BY totalsize DESC
LIMIT 5
");
break;
default:
$query = $db->query("
SELECT a.*, u.uid AS useruid, u.username, SUM(a.filesize) as totalsize
FROM ".TABLE_PREFIX."attachments a
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=a.uid)
GROUP BY a.uid
ORDER BY totalsize DESC
LIMIT 5
");
}
|
while($user = $db->fetch_array($query))
{
if(!$user['useruid'])
| while($user = $db->fetch_array($query))
{
if(!$user['useruid'])
|
| Zeile 650 | Zeile 664 |
|---|
}
// LESS THAN or GREATER THAN
|
}
// LESS THAN or GREATER THAN
|
if($mybb->input['dateuploaded'])
| if($mybb->input['dateuploaded'] && $mybb->request_method == "post")
|
{
|
{
|
$mybb->input['dateuploaded'] = TIME_NOW-60*60*24;
| $mybb->input['dateuploaded'] = TIME_NOW-$mybb->input['dateuploaded']*60*60*24;
|
}
|
}
|
if($mybb->input['filesize'])
| if($mybb->input['filesize'] && $mybb->request_method == "post")
|
{
$mybb->input['filesize'] *= 1024;
}
| {
$mybb->input['filesize'] *= 1024;
}
|
| Zeile 820 | Zeile 834 |
|---|
$form_container->output_row($lang->username_is, "", $form->generate_text_box('username', $mybb->input['username'], array('id' => 'username')), 'username');
$more_options = array(
|
$form_container->output_row($lang->username_is, "", $form->generate_text_box('username', $mybb->input['username'], array('id' => 'username')), 'username');
$more_options = array(
|
"greater_than" => $lang->more_than,
"less_than" => $lang->less_than
| "less_than" => $lang->more_than,
"greater_than" => $lang->less_than
|
);
$greater_options = array(
| );
$greater_options = array(
|