Difference between revisions of "RC-Summary.php"
From Organic Design wiki
m |
(Select only needed cols) |
||
| Line 2: | Line 2: | ||
# Appends article with a compact list of last 5 non-minor changes | # Appends article with a compact list of last 5 non-minor changes | ||
$db =& wfGetDB( DB_MASTER ); | $db =& wfGetDB( DB_MASTER ); | ||
| − | $result = $db->query( "SELECT | + | $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 $k => $v) $article .= "$k = $v, "; | foreach ($row as $k => $v) $article .= "$k = $v, "; | ||
Revision as of 19:59, 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 $k => $v) $article .= "$k = $v, ";
$article .= "
";
}
?>
