tsfix

[lhc/web/wiklou.git] / irc / rcdumper.php

diff --git a/irc/rcdumper.php b/irc/rcdumper.php
index 41052bc..684f53a 100644 (file)
--- a/irc/rcdumper.php
+++ b/irc/rcdumper.php
@@ -4,7 +4,7 @@
 Example command-line:
        php rcdumper.php | irc -d -c \#channel-to-join nick-of-bot some.irc.server
 where irc is the name of the ircII executable.
-The name of the the IRC should match $ircServer below.
+The name of the IRC server should match $ircServer below.
 */
 
 $ircServer = "irc.freenode.net";
@@ -32,16 +32,18 @@ $wgCommandLineMode = true;
 set_time_limit(0);
 
 sleep(30);
+$dbr =& wfGetDB( DB_SLAVE );
+$recentchanges = $dbr->tableName( 'recentchanges' );
 
-$res = wfQuery( "SELECT rc_timestamp FROM recentchanges ORDER BY rc_timestamp DESC LIMIT 1", DB_READ ); 
-$row = wfFetchObject( $res );
+$res = $dbr->query( "SELECT rc_timestamp FROM $recentchanges ORDER BY rc_timestamp DESC LIMIT 1" ); 
+$row = $dbr->fetchObject( $res );
 $oldTimestamp = $row->rc_timestamp;
 $serverCount = 0;
 
 while (1) {
-       $res = wfQuery( "SELECT * FROM recentchanges WHERE rc_timestamp>'$oldTimestamp' ORDER BY rc_timestamp", DB_READ );
+       $res = $dbr->query( "SELECT * FROM $recentchanges WHERE rc_timestamp>'$oldTimestamp' ORDER BY rc_timestamp" );
        $rowIndex = 0;
-       while ( $row = wfFetchObject( $res ) ) {
+       while ( $row = $dbr->fetchObject( $res ) ) {
                if ( ++$serverCount % 20 == 0 ) {
                        print "/server $ircServer\n";
                }
@@ -72,11 +74,8 @@ while (1) {
                $title = str_replace("_", " ", $title);
                 # see http://www.irssi.org/?page=docs&doc=formats for some colour codes. prefix is \003, 
                # no colour (\003) switches back to the term default
-               $fullString = "\0033$title \0037$flag \00310$url \0037*\003 $user \0037*\003 $comment\n";
+               $fullString = "\00303$title\0037 $flag\00310 $url \0037*\003 $user \0037*\003 $comment\n";
 
-               if ( $fullString{0} == "/" ) {
-                       $fullString = " $fullString";
-               }
                print( $fullString );
                $oldTimestamp = $row->rc_timestamp;
                sleep(2);