3 function wfSpecialStatistics()
5 global $wgUser, $wgOut, $wgLang, $wgIsPg;
6 $fname = "wfSpecialStatistics";
8 $wgOut->addHTML( "<h2>" . wfMsg( "sitestats" ) . "</h2>\n" );
10 $sql = "SELECT COUNT(cur_id) AS total FROM cur";
11 $res = wfQuery( $sql, DB_READ
, $fname );
12 $row = wfFetchObject( $res );
15 $sql = "SELECT ss_total_views, ss_total_edits, ss_good_articles " .
16 "FROM site_stats WHERE ss_row_id=1";
17 $res = wfQuery( $sql, DB_READ
, $fname );
18 $row = wfFetchObject( $res );
19 $views = $row->ss_total_views
;
20 $edits = $row->ss_total_edits
;
21 $good = $row->ss_good_articles
;
23 $text = wfMsg( "sitestatstext",
24 $wgLang->formatNum( $total ),
25 $wgLang->formatNum( $good ),
26 $wgLang->formatNum( $views ),
27 $wgLang->formatNum( $edits ),
28 $wgLang->formatNum( sprintf( "%.2f", $total ?
$edits / $total : 0 ) ),
29 $wgLang->formatNum( sprintf( "%.2f", $edits ?
$views / $edits : 0 ) ) );
31 $wgOut->addWikiText( $text );
32 $wgOut->addHTML( "<h2>" . wfMsg( "userstats" ) . "</h2>\n" );
34 $usertable=$wgIsPg?
'"user"':'user';
35 $sql = "SELECT COUNT(user_id) AS total FROM $usertable";
36 $res = wfQuery( $sql, DB_READ
, $fname );
37 $row = wfFetchObject( $res );
40 $sql = "SELECT COUNT(user_id) AS total FROM $usertable " .
41 "WHERE user_rights LIKE '%sysop%'";
42 $res = wfQuery( $sql, DB_READ
, $fname );
43 $row = wfFetchObject( $res );
44 $admins = $row->total
;
46 $sk = $wgUser->getSkin();
47 $ap = "[[" . wfMsg( "administrators" ) . "]]";
49 $text = wfMsg( "userstatstext",
50 $wgLang->formatNum( $total ),
51 $wgLang->formatNum( $admins ), $ap );
52 $wgOut->addWikiText( $text );