All pastes #970185 Raw Edit

Someone

public text v1 · immutable
·published 2008-04-03 21:38 UTC
rendered paste body
... (line 762 and further of linkwatcher.pl)
                $query="INSERT INTO $settings{'mysqltableprefix'}linklog (edit_id,lang,pagename,namespace,diff,revid,oldid,wikidomain,user,fullurl,domain,indexedlink) VALUES (";
                $query .= $mysql->quote($edit_id) . ",";
                $query .= $mysql->quote($lang) . ",";
                $query .= $mysql->quote($pagename) . ",";
                $query .= $mysql->quote($namespace) . ",";
                $query .= $mysql->quote($diffurl) . ",";
                $query .= $mysql->quote($revid) . ",";
                $query .= $mysql->quote($oldid) . ",";
                $query .= $mysql->quote($wikidomain) . ",";
                $query .= $mysql->quote($username) . ",";
                $query .= $mysql->quote($thislink) . ",";
                $query .= $mysql->quote($domain) . ",";
                $query .= $mysql->quote($index) . ")";
                print ("QUERY: $query\n");
                &query($query);
...


... (line 826 and further of linkwatcher.pl)
sub query {
    my $query=shift;
    print ("QR: $query\n");
    if ( $query !~ m/^select/i ) {
        my $status = 0;
        eval {
            my $status=$mysql->do($query);
        };
        if ($@) {
            return -1;
        } else {
            return $status;
        }
    } else {
        my $query_handle=$mysql->prepare($query);
        $query_handle->execute;
        my $results=$query_handle->fetchall_arrayref( {} );
        if ( $query_handle->rows > 0 ) {
            return $results;
        } else {
            return undef;
        }
    }
}