'; if( $action == 'Delete' ) { if( is_array( $del ) ) { reset( $del ); while( list( $key, $val ) = each( $del ) ) { $query = "DELETE FROM referer_visitLog WHERE visitID = '".$val."' AND blogID = '".$wpblog."'"; $result = $wpdb->query($query); } } $action = "listday"; } elseif( $action == 'deletedirect' ) { $query = "DELETE FROM referer_visitLog WHERE dayofmonth='".$day."' AND referingURL = 'DIRECT' AND blogID = '".$wpblog."'"; $result = $wpdb->query($query); printf ("Records deleted: %d\n", $wpdb->rows_affected); $action = "listday"; } elseif( $action == 'Add To Blacklist' ) { if( is_array( $del ) ) { reset( $del ); while( list( $key, $val ) = each( $del ) ) { $query = "SELECT referingURL FROM referer_visitLog WHERE visitID = '".$val."' AND blogID = '".$wpblog."'"; $result=$wpdb->get_var( $query ); if( $result ) { $query = "INSERT INTO referer_blacklist VALUES( NULL, '".$wpblog."', '".$result."', NOW() )"; $result = $wpdb->query($query); } } } $action = "listday"; } elseif( $action == 'deleteblacklist' ) { if( is_array( $del ) ) { reset( $del ); while( list( $key, $val ) = each( $del ) ) { $query = "DELETE FROM referer_blacklist WHERE ID='".$val."' AND blogID = '".$wpblog."'"; $result = $wpdb->query($query); } } $action = "blacklist"; } switch( $action ) { case "blacklist": $query = "SELECT * FROM referer_blacklist WHERE blogID = '".$wpblog."'"; $result = $wpdb->get_results($query, ARRAY_A ); if( $result ) { print ""; } else { print "No URLs in blacklist yet!"; } break; case "listday": $query = "select visitTimes,referingURL,date_format( visitTime, '%k:%i' ) as visitTime2, visitURL, visitID from referer_visitLog where dayofmonth='".$day."'"; if( $wpblog != 'root' ) $query .= " and blogID='".$wpblog."'"; if( $internal == 'yes' ) $query .= " and referingURL NOT LIKE '".get_settings( "siteurl" )."%'"; if( $ignoreDIRECT == 'yes' ) $query .= " and referingURL != 'DIRECT'"; if( $order == '' || $order == 'time' ) { $query .= " order by visitTime desc"; } elseif( $order == 'hits' ) { $query .= " order by visitTimes desc"; } elseif( $order == 'url' ) { $query .= " order by visitURL desc"; } if( $num == '' ) { $num = 0; } if( $more == '' || $more == '0' ) $more = '30'; $query .= " limit $num,$more"; $result = $wpdb->get_results($query, ARRAY_A ); $rows = $wpdb->num_rows; if( $result ) { // javascript from http://www.experts-exchange.com/Web/Web_Languages/JavaScript/Q_10105441.html and // http://members.aol.com/grassblad/html/chkAllBut.html print ""; $c = $num+1; $nav = "
"; include("admin-footer.php"); ?>