onchange("go_sort()"); $drop->add('Order by Date',''); $drop->add('Order by Views','views'); $drop->add('Order by Type','type'); $drop->run($SR_jforms); $drop->select($request->get('sort')); ?> onchange("go_shown()"); $drop->add('Seen by Visitors',''); $drop->add('Seen by Bots','bots'); $drop->add('Show All','all'); $drop->run($SR_jforms); $drop->select($request->get('shown')); ?>

onchange("go_country()"); $drop->add('All Countries',''); $countries = $wpdb->get_results("select country from " . SR_database::WP_SEO_404_links() . " where blog='" . get_current_blog_id() . "' group by country;"); foreach ( $countries as $country ) { $drop->add($country->country, $country->country); } $drop->run($SR_jforms); $drop->select($request->get('country')); ?> onchange("go_link_type()"); $drop->add('All Types',''); $drop->add('Links','1'); $drop->add('Images','2'); $drop->add('CSS/JS','3'); $drop->add('Other Files','4'); $drop->run($SR_jforms); $drop->select($request->get('link_type')); ?> Search All

get('search')!='') { $search = urldecode($request->get('search')); if($where=="") { $where = " where (ctime like '%%$search%%' or link like '%%$search%%' or referrer like '%%$search%%' or ip like '%%$search%%' or country like '%%$search%%' or os like '%%$search%%' or browser like '%%$search%%' ) "; }else { $where = $where . " and (ctime like '%%$search%%' or link like '%%$search%%' or referrer like '%%$search%%' or ip like '%%$search%%' or country like '%%$search%%' or os like '%%$search%%' or browser like '%%$search%%' ) "; } } if($request->get('link_type')!='') { $link_type=$request->get('link_type'); if($where=="") { $where = " where link_type='$link_type' "; }else { $where = $where . " and link_type='$link_type' "; } } if($request->get('country')!='') { $country=$request->get('country'); if($where=="") { $where = " where country='$country' "; }else { $where = $where . " and country='$country' "; } } if($request->get('shown')!='all') { $shown=$request->get('shown'); $sql="(browser<>'GoogleBot' and browser<>'SearchBot' and os<>'GoogleBot' and os<>'SearchBot')"; if($request->get('shown')=='bots') { $sql="(browser='GoogleBot' or browser='SearchBot' or os='GoogleBot' or os='SearchBot')"; } if($where=="") { $where = " where $sql "; }else { $where = $where . " and $sql "; } } $order = "order by ctime desc "; if($request->get('sort')!='') { $sort = $request->get('sort'); if($sort == 'views') { $order=" order by counter desc "; } else if($sort == 'type') { $order=" order by link_type asc "; } } $pagination= new clogica_pagination($table_name,$where); $pagination->set_rows(10); $limit = $pagination->get_sql_limit(); $links_404 = $wpdb->get_results("select * from " . SR_database::WP_SEO_404_links() . " $where $order $limit "); $i=0; foreach($links_404 as $link){ $i++; ?>

Discovered	404 Path		Ref	IP Address
ctime; ?>	link;?>	counter;?>	referrer!=''){?>	ip;?>
No data available!