Difference between revisions of "RC-Summary.php"
From Organic Design wiki
(Select only needed cols) |
m |
||
| Line 4: | Line 4: | ||
$result = $db->query( "SELECT rc_id, rc_timestamp, rc_user_text, rc_namespace, rc_title, rc_comment FROM recentchanges WHERE rc_minor=0 ORDER BY rc_timestamp DESC LIMIT 5" ); | $result = $db->query( "SELECT rc_id, rc_timestamp, rc_user_text, rc_namespace, rc_title, rc_comment 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)) { | ||
| − | foreach ($row as $ | + | foreach ($row as $i) $article .= "$i,"; |
$article .= "<br>"; | $article .= "<br>"; | ||
} | } | ||
?> | ?> | ||
Revision as of 20:04, 23 February 2006
<?
- Appends article with a compact list of last 5 non-minor changes
$db =& wfGetDB( DB_MASTER );
$result = $db->query( "SELECT rc_id, rc_timestamp, rc_user_text, rc_namespace, rc_title, rc_comment FROM recentchanges WHERE rc_minor=0 ORDER BY rc_timestamp DESC LIMIT 5" );
while ($row = mysql_fetch_assoc($result)) {
foreach ($row as $i) $article .= "$i,";
$article .= "
";
}
?>
.jpg){kind=link}
