Difference between revisions of "RC-Summary.php"

From Organic Design wiki
(doh - forgot php tags!)
m
Line 4: Line 4:
 
$result = $db->query( "SELECT * FROM recentchanges WHERE rc_minor=0 ORDER BY rc_timestamp DESC LIMIT 5" );
 
$result = $db->query( "SELECT * FROM recentchanges WHERE rc_minor=0 ORDER BY rc_timestamp DESC LIMIT 5" );
 
while ($row = mysql_fetch_assoc($result)) {
 
while ($row = mysql_fetch_assoc($result)) {
$msg = '';
+
foreach ($row as $k => $v) $article .= "$k = $v, ";
foreach ($row as $k => $v) $msg .= "$k = $v, ";
+
$article .= "<br>";
$msg .= "\n";
 
 
}
 
}
$article = "\n;Last 5 changes\n$msg";
 
 
?>
 
?>

Revision as of 01:14, 23 February 2006

<?

  1. Appends article with a compact list of last 5 non-minor changes

$db =& wfGetDB( DB_MASTER ); $result = $db->query( "SELECT * FROM recentchanges WHERE rc_minor=0 ORDER BY rc_timestamp DESC LIMIT 5" ); while ($row = mysql_fetch_assoc($result)) { foreach ($row as $k => $v) $article .= "$k = $v, "; $article .= "
"; } ?>