Vergleich admin/modules/forum/attachments.php - 1.4.4 - 1.4.7

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 6
 * 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 4304 2009-01-02 01:11:56Z chris $

 */

// Disallow direct access to this file for security reasons

 */

// Disallow direct access to this file for security reasons

Zeile 183Zeile 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'])