Vergleich admin/moderate.php - 1.00 - 1.02

Keine Änderungen Hinzugefügt Modifiziert Entfernt
Zeile 6	Zeile 6
* Website: http://www.mybboard.com * License: http://www.mybboard.com/eula.html *	* Website: http://www.mybboard.com * License: http://www.mybboard.com/eula.html *
* $Id$	* $Id: moderate.php 879 2005-11-02 00:21:11Z chris $
*/ require "./global.php";	*/ require "./global.php";
Zeile 128	Zeile 128
} if($mybb->input['action'] == "attachments") {	} if($mybb->input['action'] == "attachments") {
$query = $db->query("SELECT a.*, p.subject AS postsubject, p.pid AS postpid, p.tid, p.username AS postusername, p.uid AS postuid, t.subject AS threadsubject, f.name AS forumname, p.fid FROM ".TABLE_PREFIX."attachments a, ".TABLE_PREFIX."posts p, ".TABLE_PREFIX."threads t LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=t.fid) WHERE a.pid=p.pid AND t.tid=p.tid AND a.visible!='1' ORDER BY p.dateline DESC");	$query = $db->query("SELECT a.*, p.subject AS postsubject, p.pid AS postpid, p.tid, p.username AS postusername, p.uid AS postuid, t.subject AS threadsubject, f.name AS forumname, p.fid FROM (".TABLE_PREFIX."attachments a, ".TABLE_PREFIX."posts p, ".TABLE_PREFIX."threads t) LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=t.fid) WHERE a.pid=p.pid AND t.tid=p.tid AND a.visible!='1' ORDER BY p.dateline DESC");
$count = $db->num_rows($query); if(!$count) {	$count = $db->num_rows($query); if(!$count) {
Zeile 180	Zeile 180
if($mybb->input['action'] == "threads" \|\| $mybb->input['action'] == "threadsposts") { $done = 0;	if($mybb->input['action'] == "threads" \|\| $mybb->input['action'] == "threadsposts") { $done = 0;
$query = $db->query("SELECT t.*, f.name AS forumname, u.username AS username, p.message AS postmessage, p.pid AS postpid FROM ".TABLE_PREFIX."threads t, ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=t.fid) LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=t.uid) WHERE t.visible=0 AND p.tid=t.tid ORDER BY t.lastpost DESC");	$query = $db->query("SELECT t.*, f.name AS forumname, u.username AS username, p.message AS postmessage, p.pid AS postpid FROM (".TABLE_PREFIX."threads t, ".TABLE_PREFIX."posts p) LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=t.fid) LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=t.uid) WHERE t.visible=0 AND p.tid=t.tid ORDER BY t.lastpost DESC");
$tcount = $db->num_rows($query); if($tcount < 1 && $mybb->input['action'] != "threadsposts")	$tcount = $db->num_rows($query); if($tcount < 1 && $mybb->input['action'] != "threadsposts")