Difference between revisions of "RC-Summary.php"
From Organic Design wiki
(time only) |
(Construct formatted line for each change) |
||
| Line 1: | Line 1: | ||
<? | <? | ||
# Appends article with a compact list of last 5 non-minor changes | # Appends article with a compact list of last 5 non-minor changes | ||
| − | global $wgLang; | + | global $wgLang, $wgContLang; |
$db =& wfGetDB( DB_MASTER ); | $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" ); | $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)) { | ||
| − | $row['rc_timestamp'] = $ | + | $time = $wgLang->time( $row['rc_timestamp'], true ); |
| − | $article .= | + | $ns = $wgContLang->getNsText( $row['rc_namespace'] ); |
| + | $title = $ns ? "$ns:".$row['rc_title'] : $row['rc_title']; | ||
| + | $article .= $row['rc_id'].",$time,".$row['rc_user_text'].",$title,".$row['rc_comment']; | ||
$article .= "<br>"; | $article .= "<br>"; | ||
} | } | ||
?> | ?> | ||
Revision as of 20:25, 23 February 2006
<?
- Appends article with a compact list of last 5 non-minor changes
global $wgLang, $wgContLang;
$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)) {
$time = $wgLang->time( $row['rc_timestamp'], true );
$ns = $wgContLang->getNsText( $row['rc_namespace'] );
$title = $ns ? "$ns:".$row['rc_title'] : $row['rc_title'];
$article .= $row['rc_id'].",$time,".$row['rc_user_text'].",$title,".$row['rc_comment'];
$article .= "
";
}
?>
.jpg){kind=link}
