/wp-content/plugins/statpress-reloaded/statpress.php
PHP | 2143 lines | 1802 code | 196 blank | 145 comment | 297 complexity | dc13578254ba6f93217fd565059f1d82 MD5 | raw file
Possible License(s): GPL-2.0, AGPL-1.0, LGPL-2.0, LGPL-3.0, BSD-3-Clause, GPL-3.0, LGPL-2.1, AGPL-3.0, CC-BY-SA-3.0
Large files files are truncated, but you can click here to view the full file
- <?php
- /*
- Plugin Name: StatPress Reloaded
- Plugin URI: http://blog.matrixagents.org/wp-plugins/
- Description: Improved real time stats for your blog
- Version: 1.5.21
- Author: Manuel Grabowski
- Author URI: http://blog.matrixagents.org/
- */
-
- $_STATPRESS['version'] = '1.5.21';
- $_STATPRESS['feedtype'] = '';
-
-
- if ($_GET['statpress_action'] == 'exportnow')
- {
- iriStatPressExportNow();
- }
-
- function iri_add_pages()
- {
- // Create table if it doesn't exist
- global $wpdb;
- $table_name = $wpdb->prefix . 'statpress';
- if ($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name)
- {
- iri_StatPress_CreateTable();
- }
-
- // add submenu
- $mincap = get_option('statpress_mincap');
- if ($mincap == '')
- {
- $mincap = 'level_8';
- }
-
-
- add_menu_page('StatPress Reloaded', 'StatPress', $mincap, __FILE__, 'iriStatPress');
- add_submenu_page(__FILE__, __('Details', 'statpress'), __('Details', 'statpress'), $mincap, __FILE__ . '&statpress_action=details', 'iriStatPressDetails');
- add_submenu_page(__FILE__, __('Spy', 'statpress'), __('Spy', 'statpress'), $mincap, __FILE__ . '&statpress_action=spy', 'iriStatPressSpy');
- add_submenu_page(__FILE__, __('Search', 'statpress'), __('Search', 'statpress'), $mincap, __FILE__ . '&statpress_action=search', 'iriStatPressSearch');
- add_submenu_page(__FILE__, __('Export', 'statpress'), __('Export', 'statpress'), $mincap, __FILE__ . '&statpress_action=export', 'iriStatPressExport');
- add_submenu_page(__FILE__, __('Options', 'statpress'), __('Options', 'statpress'), $mincap, __FILE__ . '&statpress_action=options', 'iriStatPressOptions');
- add_submenu_page(__FILE__, __('User Agents', 'statpress'), __('User Agents', 'statpress'), $mincap, __FILE__ . '&statpress_action=agents', 'iriStatPressAgents');
- add_submenu_page(__FILE__, __('StatPressUpdate', 'statpress'), __('StatPressUpdate', 'statpress'), $mincap, __FILE__ . '&statpress_action=up', 'iriStatPressUpdate');
- //add_submenu_page(__FILE__, __('Support','statpress'), __('Support','statpress'), $mincap, 'http://matrixagents.org/phpBB/viewforum.php?f=3');
- }
-
- function permalinksEnabled()
- {
- global $wpdb;
-
- $result = $wpdb->get_row('SELECT `option_value` FROM `' . $wpdb->prefix . 'options` WHERE `option_name` = "permalink_structure"');
- if ($result->option_value != '')
- {
- return true;
- }
- else
- {
- return false;
- }
- }
-
- function my_substr($str, $x, $y = 0)
- {
- if($y == 0)
- {
- $y = strlen($str) - $x;
- }
- if(function_exists('mb_substr'))
- {
- return mb_substr($str, $x, $y);
- }
- else
- {
- return substr($str, $x, $y);
- }
- }
-
-
- function iriStatPress()
- {
- if ($_GET['statpress_action'] == 'export')
- {
- iriStatPressExport();
- }
- elseif ($_GET['statpress_action'] == 'up')
- {
- iriStatPressUpdate();
- }
- elseif ($_GET['statpress_action'] == 'spy')
- {
- iriStatPressSpy();
- }
- elseif ($_GET['statpress_action'] == 'search')
- {
- iriStatPressSearch();
- }
- elseif ($_GET['statpress_action'] == 'details')
- {
- iriStatPressDetails();
- }
- elseif ($_GET['statpress_action'] == 'options')
- {
- iriStatPressOptions();
- }
- elseif ($_GET['statpress_action'] == 'overview')
- {
- iriStatPressMain();
- }
- elseif ($_GET['statpress_action'] == 'agents')
- {
- iriStatPressAgents();
- }
- else
- {
- iriStatPressMain();
- }
- }
-
- function iriStatPressOptions()
- {
- if ($_POST['saveit'] == 'yes')
- {
- update_option('statpress_collectloggeduser', $_POST['statpress_collectloggeduser']);
- update_option('statpress_autodelete', $_POST['statpress_autodelete']);
- update_option('statpress_daysinoverviewgraph', $_POST['statpress_daysinoverviewgraph']);
- update_option('statpress_mincap', $_POST['statpress_mincap']);
- update_option('statpress_donotcollectspider', $_POST['statpress_donotcollectspider']);
- update_option('statpress_autodelete_spider', $_POST['statpress_autodelete_spider']);
-
- // update database too
- iri_StatPress_CreateTable();
- print "<br /><div class='updated'><p>" . __('Saved', 'statpress') . "!</p></div>";
- }
- else
- {
- ?>
- <div class='wrap'><h2><?php
- _e('Options', 'statpress');
- ?></h2>
- <form method=post><table width=100%>
- <?php
- print "<tr><td><input type=checkbox name='statpress_collectloggeduser' value='checked' " . get_option('statpress_collectloggeduser') . "> " . __('Collect data about logged users, too.', 'statpress') . "</td></tr>";
- print "<tr><td><input type=checkbox name='statpress_donotcollectspider' value='checked' " . get_option('statpress_donotcollectspider') . "> " . __('Do not collect spiders visits', 'statpress') . "</td></tr>";
- ?>
- <tr><td><?php
- _e('Automatically delete visits older than', 'statpress');
- ?>
- <select name="statpress_autodelete">
- <option value="" <?php
- if (get_option('statpress_autodelete') == '')
- print "selected";
- ?>><?php
- _e('Never delete!', 'statpress');
- ?></option>
- <option value="1 month" <?php
- if (get_option('statpress_autodelete') == "1 month")
- print "selected";
- ?>>1 <?php
- _e('month', 'statpress');
- ?></option>
- <option value="3 months" <?php
- if (get_option('statpress_autodelete') == "3 months")
- print "selected";
- ?>>3 <?php
- _e('months', 'statpress');
- ?></option>
- <option value="6 months" <?php
- if (get_option('statpress_autodelete') == "6 months")
- print "selected";
- ?>>6 <?php
- _e('months', 'statpress');
- ?></option>
- <option value="1 year" <?php
- if (get_option('statpress_autodelete') == "1 year")
- print "selected";
- ?>>1 <?php
- _e('year', 'statpress');
- ?></option>
- </select></td></tr>
-
- <tr><td><?php _e('Automatically delete spider visits older than','statpress'); ?>
- <select name="statpress_autodelete_spider">
- <option value="" <?php if(get_option('statpress_autodelete_spider') =='' ) print "selected"; ?>><?php _e('Never delete!','statpress'); ?></option>
- <option value="1 day" <?php if(get_option('statpress_autodelete_spider') == "1 day") print "selected"; ?>>1 <?php _e('day','statpress'); ?></option>
- <option value="1 week" <?php if(get_option('statpress_autodelete_spider') == "1 week") print "selected"; ?>>1 <?php _e('week','statpress'); ?></option>
- <option value="1 month" <?php if(get_option('statpress_autodelete_spider') == "1 month") print "selected"; ?>>1 <?php _e('month','statpress'); ?></option>
- <option value="1 year" <?php if(get_option('statpress_autodelete_spider') == "1 year") print "selected"; ?>>1 <?php _e('year','statpress'); ?></option>
- </select></td></tr>
-
- <tr><td><?php
- _e('Days in Overview graph', 'statpress');
- ?>
- <select name="statpress_daysinoverviewgraph">
- <option value="7" <?php
- if (get_option('statpress_daysinoverviewgraph') == 7)
- print "selected";
- ?>>7</option>
- <option value="10" <?php
- if (get_option('statpress_daysinoverviewgraph') == 10)
- print "selected";
- ?>>10</option>
- <option value="20" <?php
- if (get_option('statpress_daysinoverviewgraph') == 20)
- print "selected";
- ?>>20</option>
- <option value="30" <?php
- if (get_option('statpress_daysinoverviewgraph') == 30)
- print "selected";
- ?>>30</option>
- <option value="50" <?php
- if (get_option('statpress_daysinoverviewgraph') == 50)
- print "selected";
- ?>>50</option>
- </select></td></tr>
-
- <tr><td><?php
- _e('Minimum capability to view stats', 'statpress');
- ?>
- <select name="statpress_mincap">
- <?php
- iri_dropdown_caps(get_option('statpress_mincap'));
- ?>
- </select>
- <a href="http://codex.wordpress.org/Roles_and_Capabilities" target="_blank"><?php
- _e("more info", 'statpress');
- ?></a>
- </td></tr>
-
- <tr><td><br><input type=submit value="<?php
- _e('Save options', 'statpress');
- ?>"></td></tr>
- </tr>
- </table>
- <input type=hidden name=saveit value=yes>
- <input type=hidden name=page value=statpress><input type=hidden name=statpress_action value=options>
- </form>
- </div>
- <?php
- } // chiude saveit
- }
-
-
- function iri_dropdown_caps($default = false)
- {
- global $wp_roles;
- $role = get_role('administrator');
- foreach ($role->capabilities as $cap => $grant)
- {
- print "<option ";
- if ($default == $cap)
- {
- print "selected ";
- }
- print ">$cap</option>";
- }
- }
-
-
- function iriStatPressExport()
- {
- ?>
- <div class='wrap'><h2><?php
- _e('Export stats to text file', 'statpress');
- ?> (csv)</h2>
- <form method=get><table>
- <tr><td><?php
- _e('From', 'statpress');
- ?></td><td><input type=text name=from> (YYYYMMDD)</td></tr>
- <tr><td><?php
- _e('To', 'statpress');
- ?></td><td><input type=text name=to> (YYYYMMDD)</td></tr>
- <tr><td><?php
- _e('Fields delimiter', 'statpress');
- ?></td><td><select name=del><option>,</option><option>;</option><option>|</option></select></tr>
- <tr><td></td><td><input type=submit value=<?php
- _e('Export', 'statpress');
- ?>></td></tr>
- <input type=hidden name=page value=statpress><input type=hidden name=statpress_action value=exportnow>
- </table></form>
- </div>
- <?php
- }
-
-
- function iriStatPressExportNow()
- {
- global $wpdb;
- $table_name = $wpdb->prefix . "statpress";
- $filename = get_bloginfo('title') . "-statpress_" . $_GET['from'] . "-" . $_GET['to'] . ".csv";
- header('Content-Description: File Transfer');
- header("Content-Disposition: attachment; filename=$filename");
- header('Content-Type: text/plain charset=' . get_option('blog_charset'), true);
- $qry = $wpdb->get_results("SELECT * FROM $table_name WHERE date>='" . (date("Ymd", strtotime(my_substr($_GET['from'], 0, 8)))) . "' AND date<='" . (date("Ymd", strtotime(my_substr($_GET['to'], 0, 8)))) . "';");
- $del = my_substr($_GET['del'], 0, 1);
- print "date" . $del . "time" . $del . "ip" . $del . "urlrequested" . $del . "agent" . $del . "referrer" . $del . "search" . $del . "nation" . $del . "os" . $del . "browser" . $del . "searchengine" . $del . "spider" . $del . "feed\n";
- foreach ($qry as $rk)
- {
- print '"' . $rk->date . '"' . $del . '"' . $rk->time . '"' . $del . '"' . $rk->ip . '"' . $del . '"' . $rk->urlrequested . '"' . $del . '"' . $rk->agent . '"' . $del . '"' . $rk->referrer . '"' . $del . '"' . urldecode($rk->search) . '"' . $del . '"' . $rk->nation . '"' . $del . '"' . $rk->os . '"' . $del . '"' . $rk->browser . '"' . $del . '"' . $rk->searchengine . '"' . $del . '"' . $rk->spider . '"' . $del . '"' . $rk->feed . '"' . "\n";
- }
- die();
- }
-
- function iriStatPressMain()
- {
- global $wpdb;
- $table_name = $wpdb->prefix . "statpress";
-
- // OVERVIEW table
- $unique_color = "#114477";
- $web_color = "#3377B6";
- $rss_color = "#f38f36";
- $spider_color = "#83b4d8";
- $lastmonth = iri_StatPress_lastmonth();
- $thismonth = gmdate('Ym', current_time('timestamp'));
- $yesterday = gmdate('Ymd', current_time('timestamp') - 86400);
- $today = gmdate('Ymd', current_time('timestamp'));
- $tlm[0] = my_substr($lastmonth, 0, 4);
- $tlm[1] = my_substr($lastmonth, 4, 2);
-
- print "<div class='wrap'><h2>" . __('Overview', 'statpress') . "</h2>";
- print "<table class='widefat'><thead><tr>
- <th scope='col'></th>
- <th scope='col'>" . __('Total', 'statpress') . "</th>
- <th scope='col'>" . __('Last month', 'statpress') . "<br /><font size=1>" . gmdate('M, Y', gmmktime(0, 0, 0, $tlm[1], 1, $tlm[0])) . "</font></th>
- <th scope='col'>" . __('This month', 'statpress') . "<br /><font size=1>" . gmdate('M, Y', current_time('timestamp')) . "</font></th>
- <th scope='col'>" . __('Target', 'statpress') . " " . __('This month', 'statpress') . "<br /><font size=1>" . gmdate('M, Y', current_time('timestamp')) . "</font></th>
- <th scope='col'>" . __('Yesterday', 'statpress') . "<br /><font size=1>" . gmdate('d M, Y', current_time('timestamp') - 86400) . "</font></th>
- <th scope='col'>" . __('Today', 'statpress') . "<br /><font size=1>" . gmdate('d M, Y', current_time('timestamp')) . "</font></th>
- </tr></thead>
- <tbody id='the-list'>";
-
- //###############################################################################################
- // VISITORS ROW
- print "<tr><td><div style='background:$unique_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>" . __('Visitors', 'statpress') . "</td>";
-
- //TOTAL
- $qry_total = $wpdb->get_row("
- SELECT count(DISTINCT ip) AS visitors
- FROM $table_name
- WHERE feed=''
- AND spider=''
- ");
- print "<td>" . $qry_total->visitors . "</td>\n";
-
- //LAST MONTH
- $qry_lmonth = $wpdb->get_row("
- SELECT count(DISTINCT ip) AS visitors
- FROM $table_name
- WHERE feed=''
- AND spider=''
- AND date LIKE '" . mysql_real_escape_string($lastmonth) . "%'
- ");
- print "<td>" . $qry_lmonth->visitors . "</td>\n";
-
- //THIS MONTH
- $qry_tmonth = $wpdb->get_row("
- SELECT count(DISTINCT ip) AS visitors
- FROM $table_name
- WHERE feed=''
- AND spider=''
- AND date LIKE '" . mysql_real_escape_string($thismonth) . "%'
- ");
- if ($qry_lmonth->visitors <> 0)
- {
- $pc = round(100 * ($qry_tmonth->visitors / $qry_lmonth->visitors) - 100, 1);
- if ($pc >= 0)
- $pc = "+" . $pc;
- $qry_tmonth->change = "<code> (" . $pc . "%)</code>";
- }
- print "<td>" . $qry_tmonth->visitors . $qry_tmonth->change . "</td>\n";
-
- //TARGET
-
- $qry_tmonth->target = round($qry_tmonth->visitors / (time() - mktime(0,0,0,date('m'),date('1'),date('Y'))) * (86400 * date('t')));
- if ($qry_lmonth->visitors <> 0)
- {
- $pt = round(100 * ($qry_tmonth->target / $qry_lmonth->visitors) - 100, 1);
- if ($pt >= 0)
- $pt = "+" . $pt;
- $qry_tmonth->added = "<code> (" . $pt . "%)</code>";
- }
- print "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";
-
- //YESTERDAY
- $qry_y = $wpdb->get_row("
- SELECT count(DISTINCT ip) AS visitors
- FROM $table_name
- WHERE feed=''
- AND spider=''
- AND date = '" . mysql_real_escape_string($yesterday) . "'
- ");
- print "<td>" . $qry_y->visitors . "</td>\n";
-
- //TODAY
- $qry_t = $wpdb->get_row("
- SELECT count(DISTINCT ip) AS visitors
- FROM $table_name
- WHERE feed=''
- AND spider=''
- AND date = '" . mysql_real_escape_string($today) . "'
- ");
- print "<td>" . $qry_t->visitors . "</td>\n";
- print "</tr>";
-
- //###############################################################################################
- // PAGEVIEWS ROW
- print "<tr><td><div style='background:$web_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>" . __('Pageviews', 'statpress') . "</td>";
-
- //TOTAL
- $qry_total = $wpdb->get_row("
- SELECT count(date) as pageview
- FROM $table_name
- WHERE feed=''
- AND spider=''
- ");
- print "<td>" . $qry_total->pageview . "</td>\n";
-
- //LAST MONTH
- $prec = 0;
- $qry_lmonth = $wpdb->get_row("
- SELECT count(date) as pageview
- FROM $table_name
- WHERE feed=''
- AND spider=''
- AND date LIKE '" . mysql_real_escape_string($lastmonth) . "%'
- ");
- print "<td>" . $qry_lmonth->pageview . "</td>\n";
-
- //THIS MONTH
- $qry_tmonth = $wpdb->get_row("
- SELECT count(date) as pageview
- FROM $table_name
- WHERE feed=''
- AND spider=''
- AND date LIKE '" . mysql_real_escape_string($thismonth) . "%'
- ");
- if ($qry_lmonth->pageview <> 0)
- {
- $pc = round(100 * ($qry_tmonth->pageview / $qry_lmonth->pageview) - 100, 1);
- if ($pc >= 0)
- $pc = "+" . $pc;
- $qry_tmonth->change = "<code> (" . $pc . "%)</code>";
- }
- print "<td>" . $qry_tmonth->pageview . $qry_tmonth->change . "</td>\n";
-
- //TARGET
- $qry_tmonth->target = round($qry_tmonth->pageview / (time() - mktime(0,0,0,date('m'),date('1'),date('Y'))) * (86400 * date('t')));
- if ($qry_lmonth->pageview <> 0)
- {
- $pt = round(100 * ($qry_tmonth->target / $qry_lmonth->pageview) - 100, 1);
- if ($pt >= 0)
- $pt = "+" . $pt;
- $qry_tmonth->added = "<code> (" . $pt . "%)</code>";
- }
- print "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";
-
- //YESTERDAY
- $qry_y = $wpdb->get_row("
- SELECT count(date) as pageview
- FROM $table_name
- WHERE feed=''
- AND spider=''
- AND date = '" . mysql_real_escape_string($yesterday) . "'
- ");
- print "<td>" . $qry_y->pageview . "</td>\n";
-
- //TODAY
- $qry_t = $wpdb->get_row("
- SELECT count(date) as pageview
- FROM $table_name
- WHERE feed=''
- AND spider=''
- AND date = '" . mysql_real_escape_string($today) . "'
- ");
- print "<td>" . $qry_t->pageview . "</td>\n";
- print "</tr>";
- //###############################################################################################
- // SPIDERS ROW
- print "<tr><td><div style='background:$spider_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>" . __('Spiders', 'statpress') . "</td>";
- //TOTAL
- $qry_total = $wpdb->get_row("
- SELECT count(date) as spiders
- FROM $table_name
- WHERE feed=''
- AND spider<>''
- ");
- print "<td>" . $qry_total->spiders . "</td>\n";
- //LAST MONTH
- $prec = 0;
- $qry_lmonth = $wpdb->get_row("
- SELECT count(date) as spiders
- FROM $table_name
- WHERE feed=''
- AND spider<>''
- AND date LIKE '" . mysql_real_escape_string($lastmonth) . "%'
- ");
- print "<td>" . $qry_lmonth->spiders . "</td>\n";
-
- //THIS MONTH
- $prec = $qry_lmonth->spiders;
- $qry_tmonth = $wpdb->get_row("
- SELECT count(date) as spiders
- FROM $table_name
- WHERE feed=''
- AND spider<>''
- AND date LIKE '" . mysql_real_escape_string($thismonth) . "%'
- ");
- if ($qry_lmonth->spiders <> 0)
- {
- $pc = round(100 * ($qry_tmonth->spiders / $qry_lmonth->spiders) - 100, 1);
- if ($pc >= 0)
- $pc = "+" . $pc;
- $qry_tmonth->change = "<code> (" . $pc . "%)</code>";
- }
- print "<td>" . $qry_tmonth->spiders . $qry_tmonth->change . "</td>\n";
-
- //TARGET
- $qry_tmonth->target = round($qry_tmonth->spiders / (time() - mktime(0,0,0,date('m'),date('1'),date('Y'))) * (86400 * date('t')));
- if ($qry_lmonth->spiders <> 0)
- {
- $pt = round(100 * ($qry_tmonth->target / $qry_lmonth->spiders) - 100, 1);
- if ($pt >= 0)
- $pt = "+" . $pt;
- $qry_tmonth->added = "<code> (" . $pt . "%)</code>";
- }
- print "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";
-
- //YESTERDAY
- $qry_y = $wpdb->get_row("
- SELECT count(date) as spiders
- FROM $table_name
- WHERE feed=''
- AND spider<>''
- AND date = '" . mysql_real_escape_string($yesterday) . "'
- ");
- print "<td>" . $qry_y->spiders . "</td>\n";
-
- //TODAY
- $qry_t = $wpdb->get_row("
- SELECT count(date) as spiders
- FROM $table_name
- WHERE feed=''
- AND spider<>''
- AND date = '" . mysql_real_escape_string($today) . "'
- ");
- print "<td>" . $qry_t->spiders . "</td>\n";
- print "</tr>";
- //###############################################################################################
- // FEEDS ROW
- print "<tr><td><div style='background:$rss_color;width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>" . __('Feeds', 'statpress') . "</td>";
- //TOTAL
- $qry_total = $wpdb->get_row("
- SELECT count(date) as feeds
- FROM $table_name
- WHERE feed<>''
- AND spider=''
- ");
- print "<td>" . $qry_total->feeds . "</td>\n";
-
- //LAST MONTH
- $qry_lmonth = $wpdb->get_row("
- SELECT count(date) as feeds
- FROM $table_name
- WHERE feed<>''
- AND spider=''
- AND date LIKE '" . mysql_real_escape_string($lastmonth) . "%'
- ");
- print "<td>" . $qry_lmonth->feeds . "</td>\n";
-
- //THIS MONTH
- $qry_tmonth = $wpdb->get_row("
- SELECT count(date) as feeds
- FROM $table_name
- WHERE feed<>''
- AND spider=''
- AND date LIKE '" . mysql_real_escape_string($thismonth) . "%'
- ");
- if ($qry_lmonth->feeds <> 0)
- {
- $pc = round(100 * ($qry_tmonth->feeds / $qry_lmonth->feeds) - 100, 1);
- if ($pc >= 0)
- $pc = "+" . $pc;
- $qry_tmonth->change = "<code> (" . $pc . "%)</code>";
- }
- print "<td>" . $qry_tmonth->feeds . $qry_tmonth->change . "</td>\n";
-
- //TARGET
- $qry_tmonth->target = round($qry_tmonth->feeds / (time() - mktime(0,0,0,date('m'),date('1'),date('Y'))) * (86400 * date('t')));
- if ($qry_lmonth->feeds <> 0)
- {
- $pt = round(100 * ($qry_tmonth->target / $qry_lmonth->feeds) - 100, 1);
- if ($pt >= 0)
- $pt = "+" . $pt;
- $qry_tmonth->added = "<code> (" . $pt . "%)</code>";
- }
- print "<td>" . $qry_tmonth->target . $qry_tmonth->added . "</td>\n";
-
- $qry_y = $wpdb->get_row("
- SELECT count(date) as feeds
- FROM $table_name
- WHERE feed<>''
- AND spider=''
- AND date = '" . mysql_real_escape_string($yesterday) . "'
- ");
- print "<td>" . $qry_y->feeds . "</td>\n";
-
- $qry_t = $wpdb->get_row("
- SELECT count(date) as feeds
- FROM $table_name
- WHERE feed<>''
- AND spider=''
- AND date = '" . mysql_real_escape_string($today) . "'
- ");
- print "<td>" . $qry_t->feeds . "</td>\n";
-
- print "</tr></table><br />\n\n";
-
- //###############################################################################################
- //###############################################################################################
- // THE GRAPHS
-
- // last "N" days graph NEW
- $gdays = get_option('statpress_daysinoverviewgraph');
- if ($gdays == 0)
- {
- $gdays = 20;
- }
- // $start_of_week = get_settings('start_of_week');
- $start_of_week = get_option('start_of_week');
- print '<table width="100%" border="0"><tr>';
- $qry = $wpdb->get_row("
- SELECT count(date) as pageview, date
- FROM $table_name
- GROUP BY date HAVING date >= '" . gmdate('Ymd', current_time('timestamp') - 86400 * $gdays) . "'
- ORDER BY pageview DESC
- LIMIT 1
- ");
- $maxxday = $qry->pageview;
- if ($maxxday == 0)
- {
- $maxxday = 1;
- }
- // Y
- $gd = (90 / $gdays) . '%';
- for ($gg = $gdays - 1; $gg >= 0; $gg--)
- {
- //TOTAL VISITORS
- $qry_visitors = $wpdb->get_row("
- SELECT count(DISTINCT ip) AS total
- FROM $table_name
- WHERE feed=''
- AND spider=''
- AND date = '" . gmdate('Ymd', current_time('timestamp') - 86400 * $gg) . "'
- ");
- $px_visitors = round($qry_visitors->total * 100 / $maxxday);
-
- //TOTAL PAGEVIEWS (we do not delete the uniques, this is falsing the info.. uniques are not different visitors!)
- $qry_pageviews = $wpdb->get_row("
- SELECT count(date) as total
- FROM $table_name
- WHERE feed=''
- AND spider=''
- AND date = '" . gmdate('Ymd', current_time('timestamp') - 86400 * $gg) . "'
- ");
- $px_pageviews = round($qry_pageviews->total * 100 / $maxxday);
-
- //TOTAL SPIDERS
- $qry_spiders = $wpdb->get_row("
- SELECT count(ip) AS total
- FROM $table_name
- WHERE feed=''
- AND spider<>''
- AND date = '" . gmdate('Ymd', current_time('timestamp') - 86400 * $gg) . "'
- ");
- $px_spiders = round($qry_spiders->total * 100 / $maxxday);
-
- //TOTAL FEEDS
- $qry_feeds = $wpdb->get_row("
- SELECT count(ip) AS total
- FROM $table_name
- WHERE feed<>''
- AND spider=''
- AND date = '" . gmdate('Ymd', current_time('timestamp') - 86400 * $gg) . "'
- ");
- $px_feeds = round($qry_feeds->total * 100 / $maxxday);
-
- $px_white = 100 - $px_feeds - $px_spiders - $px_pageviews - $px_visitors;
-
- print '<td width="' . $gd . '" valign="bottom"';
- if ($start_of_week == gmdate('w', current_time('timestamp') - 86400 * $gg))
- {
- print ' style="border-left:2px dotted gray;"';
- }
- // week-cut
- print "><div style='float:left;height: 100%;width:100%;font-family:Helvetica;font-size:7pt;text-align:center;border-right:1px solid white;color:black;'>
- <div style='background:#ffffff;width:100%;height:" . $px_white . "px;'></div>
- <div style='background:$unique_color;width:100%;height:" . $px_visitors . "px;' title='" . $qry_visitors->total . " " . __('visitors', 'statpress')."'></div>
- <div style='background:$web_color;width:100%;height:" . $px_pageviews . "px;' title='" . $qry_pageviews->total . " " . __('pageviews', 'statpress')."'></div>
- <div style='background:$spider_color;width:100%;height:" . $px_spiders . "px;' title='" . $qry_spiders->total . " " . __('spiders', 'statpress')."'></div>
- <div style='background:$rss_color;width:100%;height:" . $px_feeds . "px;' title='" . $qry_feeds->total . " " . __('feeds', 'statpress')."'></div>
- <div style='background:gray;width:100%;height:1px;'></div>
- <br />" . gmdate('d', current_time('timestamp') - 86400 * $gg) . ' ' . gmdate('M', current_time('timestamp') - 86400 * $gg) . "</div></td>\n";
- }
- print '</tr></table>';
-
- print '</div>';
- // END OF OVERVIEW
- //###################################################################################################
-
-
-
-
- $querylimit = "LIMIT 20";
-
- // Tabella Last hits
- print "<div class='wrap'><h2>" . __('Last hits', 'statpress') . "</h2><table class='widefat'><thead><tr><th scope='col'>" . __('Date', 'statpress') . "</th><th scope='col'>" . __('Time', 'statpress') . "</th><th scope='col'>" . __('IP', 'statpress') . "</th><th scope='col'>" . __('Threat', 'statpress') . "</th><th scope='col'>" . __('Domain', 'statpress') . "</th><th scope='col'>" . __('Page', 'statpress') . "</th><th scope='col'>" . __('OS', 'statpress') . "</th><th scope='col'>" . __('Browser', 'statpress') . "</th><th scope='col'>" . __('Feed', 'statpress') . "</th></tr></thead>";
- print "<tbody id='the-list'>";
-
- $fivesdrafts = $wpdb->get_results("SELECT * FROM $table_name WHERE (os<>'' OR feed<>'') order by id DESC $querylimit");
- foreach ($fivesdrafts as $fivesdraft)
- {
- print "<tr>";
- print "<td>" . irihdate($fivesdraft->date) . "</td>";
- print "<td>" . $fivesdraft->time . "</td>";
- print "<td>" . $fivesdraft->ip . "</td>";
- print "<td>" . $fivesdraft->threat_score;
- if ($fivesdraft->threat_score > 0)
- {
- print "/";
- if ($fivesdraft->threat_type == 0)
- print "Sp"; // Spider
- else
- {
- if (($fivesdraft->threat_type & 1) == 1)
- print "S"; // Suspicious
- if (($fivesdraft->threat_type & 2) == 2)
- print "H"; // Harvester
- if (($fivesdraft->threat_type & 4) == 4)
- print "C"; // Comment spammer
- }
- }
- print "<td>" . $fivesdraft->nation . "</td>";
- print "<td>" . iri_StatPress_Abbrevia(iri_StatPress_Decode($fivesdraft->urlrequested), 30) . "</td>";
- print "<td>" . $fivesdraft->os . "</td>";
- print "<td>" . $fivesdraft->browser . "</td>";
- print "<td>" . $fivesdraft->feed . "</td>";
- print "</tr>";
- }
- print "</table></div>";
-
-
- // Last Search terms
- print "<div class='wrap'><h2>" . __('Last search terms', 'statpress') . "</h2><table class='widefat'><thead><tr><th scope='col'>" . __('Date', 'statpress') . "</th><th scope='col'>" . __('Time', 'statpress') . "</th><th scope='col'>" . __('Terms', 'statpress') . "</th><th scope='col'>" . __('Engine', 'statpress') . "</th><th scope='col'>" . __('Result', 'statpress') . "</th></tr></thead>";
- print "<tbody id='the-list'>";
- $qry = $wpdb->get_results("SELECT date,time,referrer,urlrequested,search,searchengine FROM $table_name WHERE search<>'' ORDER BY id DESC $querylimit");
- foreach ($qry as $rk)
- {
- print "<tr><td>" . irihdate($rk->date) . "</td><td>" . $rk->time . "</td><td><a href='" . $rk->referrer . "'>" . urldecode($rk->search) . "</a></td><td>" . $rk->searchengine . "</td><td><a href='" . irigetblogurl() . ((strpos($rk->urlrequested, 'index.php') === FALSE) ? $rk->urlrequested : '') . "'>" . __('page viewed', 'statpress') . "</a></td></tr>\n";
- }
- print "</table></div>";
-
- // Referrer
- print "<div class='wrap'><h2>" . __('Last referrers', 'statpress') . "</h2><table class='widefat'><thead><tr><th scope='col'>" . __('Date', 'statpress') . "</th><th scope='col'>" . __('Time', 'statpress') . "</th><th scope='col'>" . __('URL', 'statpress') . "</th><th scope='col'>" . __('Result', 'statpress') . "</th></tr></thead>";
- print "<tbody id='the-list'>";
- $qry = $wpdb->get_results("SELECT date,time,referrer,urlrequested FROM $table_name WHERE ((referrer NOT LIKE '" . get_option('home') . "%') AND (referrer <>'') AND (searchengine='')) ORDER BY id DESC $querylimit");
- foreach ($qry as $rk)
- {
- print "<tr><td>" . irihdate($rk->date) . "</td><td>" . $rk->time . "</td><td><a href='" . $rk->referrer . "'>" . iri_StatPress_Abbrevia($rk->referrer, 80) . "</a></td><td><a href='" . irigetblogurl() . ((strpos($rk->urlrequested, 'index.php') === FALSE) ? $rk->urlrequested : '') . "'>" . __('page viewed', 'statpress') . "</a></td></tr>\n";
- }
- print "</table></div>";
-
- // Last Agents
- print "<div class='wrap'><h2>" . __('Last agents', 'statpress') . "</h2><table class='widefat'><thead><tr><th scope='col'>" . __('Date', 'statpress') . "</th><th scope='col'>" . __('Time', 'statpress') . "</th><th scope='col'>" . __('Agent', 'statpress') . "</th><th scope='col'>" . __('What', 'statpress') . "</th></tr></thead>";
- print "<tbody id='the-list'>";
- $qry = $wpdb->get_results("SELECT date,time,agent,os,browser,spider FROM $table_name WHERE (agent <>'') ORDER BY id DESC $querylimit");
- foreach ($qry as $rk)
- {
- print "<tr><td>" . irihdate($rk->date) . "</td><td>" . $rk->time . "</td><td>" . $rk->agent . "</td><td> " . $rk->os . " " . $rk->browser . " " . $rk->spider . "</td></tr>\n";
- }
- print "</table></div>";
-
- // Last pages
- print "<div class='wrap'><h2>" . __('Last pages', 'statpress') . "</h2><table class='widefat'><thead><tr><th scope='col'>" . __('Date', 'statpress') . "</th><th scope='col'>" . __('Time', 'statpress') . "</th><th scope='col'>" . __('Page', 'statpress') . "</th><th scope='col'>" . __('What', 'statpress') . "</th></tr></thead>";
- print "<tbody id='the-list'>";
- $qry = $wpdb->get_results("SELECT date,time,urlrequested,os,browser,spider FROM $table_name WHERE (spider='' AND feed='') ORDER BY id DESC $querylimit");
- foreach ($qry as $rk)
- {
- print "<tr><td>" . irihdate($rk->date) . "</td><td>" . $rk->time . "</td><td>" . iri_StatPress_Abbrevia(iri_StatPress_Decode($rk->urlrequested), 60) . "</td><td> " . $rk->os . " " . $rk->browser . " " . $rk->spider . "</td></tr>\n";
- }
- print "</table></div>";
-
- // Last Spiders
- print "<div class='wrap'><h2>" . __('Last spiders', 'statpress') . "</h2>";
- print "<table class='widefat'><thead><tr>";
- print "<th scope='col'>" . __('Date', 'statpress') . "</th>";
- print "<th scope='col'>" . __('Time', 'statpress') . "</th>";
- print "<th scope='col'>" . __('Spider', 'statpress') . "</th>";
- print "<th scope='col'>" . __('Page', 'statpress') . "</th>";
- print "<th scope='col'>" . __('Agent', 'statpress') . "</th>";
- print "</tr></thead><tbody id='the-list'>";
- $qry = $wpdb->get_results("SELECT date,time,agent,spider,urlrequested,agent FROM $table_name WHERE (spider<>'') ORDER BY id DESC $querylimit");
- foreach ($qry as $rk)
- {
- print "<tr><td>" . irihdate($rk->date) . "</td>";
- print "<td>" . $rk->time . "</td>";
- print "<td>" . $rk->spider . "</td>";
- print "<td>" . iri_StatPress_Abbrevia(iri_StatPress_Decode($rk->urlrequested), 30) . "</td>";
- print "<td> " . $rk->agent . "</td></tr>\n";
- }
- print "</table></div>";
-
-
- print "<br />";
- print " <i>" . __('StatPress table size', 'statpress') . ": <b>" . iritablesize($wpdb->prefix . "statpress") . "</b></i><br />";
- print " <i>" . __('StatPress current time', 'statpress') . ": <b>" . current_time('mysql') . "</b></i><br />";
- print " <i>" . __('RSS2 url', 'statpress') . ": <b>" . get_bloginfo('rss2_url') . ' (' . iri_StatPress_extractfeedreq(get_bloginfo('rss2_url')) . ")</b></i><br />";
- print " <i>" . __('ATOM url', 'statpress') . ": <b>" . get_bloginfo('atom_url') . ' (' . iri_StatPress_extractfeedreq(get_bloginfo('atom_url')) . ")</b></i><br />";
- print " <i>" . __('RSS url', 'statpress') . ": <b>" . get_bloginfo('rss_url') . ' (' . iri_StatPress_extractfeedreq(get_bloginfo('rss_url')) . ")</b></i><br />";
- print " <i>" . __('COMMENT RSS2 url', 'statpress') . ": <b>" . get_bloginfo('comments_rss2_url') . ' (' . iri_StatPress_extractfeedreq(get_bloginfo('comments_rss2_url')) . ")</b></i><br />";
- print " <i>" . __('COMMENT ATOM url', 'statpress') . ": <b>" . get_bloginfo('comments_atom_url') . ' (' . iri_StatPress_extractfeedreq(get_bloginfo('comments_atom_url')) . ")</b></i><br />";
- }
-
- function iriStatPressDetails()
- {
- global $wpdb;
- $table_name = $wpdb->prefix . "statpress";
-
- $querylimit = "LIMIT 10";
-
- // Top days
- iriValueTable("date", __('Top days', 'statpress'), 5);
-
- // O.S.
- iriValueTable("os", __('O.S.', 'statpress'), 0, "", "", "AND feed='' AND spider='' AND os<>''");
-
- // Browser
- iriValueTable("browser", __('Browser', 'statpress'), 0, "", "", "AND feed='' AND spider='' AND browser<>''");
-
- // Feeds
- iriValueTable("feed", __('Feeds', 'statpress'), 5, "", "", "AND feed<>''");
-
- // SE
- iriValueTable("searchengine", __('Search engines', 'statpress'), 10, "", "", "AND searchengine<>''");
-
- // Search terms
- iriValueTable("search", __('Top search terms', 'statpress'), 20, "", "", "AND search<>''");
-
- // Top referrer
- iriValueTable("referrer", __('Top referrer', 'statpress'), 10, "", "", "AND referrer<>'' AND referrer NOT LIKE '%" . get_bloginfo('url') . "%'");
-
- // Countries
- iriValueTable("nation", __('Countries (domains)', 'statpress'), 10, "", "", "AND nation<>'' AND spider=''");
-
- // Spider
- iriValueTable("spider", __('Spiders', 'statpress'), 10, "", "", "AND spider<>''");
-
- // Top Pages
- iriValueTable("urlrequested", __('Top pages', 'statpress'), 5, "", "urlrequested", "AND feed='' and spider=''");
-
-
- // Top Days - Unique visitors
- iriValueTable("date", __('Top Days - Unique visitors', 'statpress'), 5, "distinct", "ip", "AND feed='' and spider=''");
- /* Maddler 04112007: required patching iriValueTable */
-
- // Top Days - Pageviews
- iriValueTable("date", __('Top Days - Pageviews', 'statpress'), 5, "", "urlrequested", "AND feed='' and spider=''");
- /* Maddler 04112007: required patching iriValueTable */
-
- // Top IPs - Pageviews
- iriValueTable("ip", __('Top IPs - Pageviews', 'statpress'), 5, "", "urlrequested", "AND feed='' and spider=''");
- /* Maddler 04112007: required patching iriValueTable */
- }
-
-
- function iriStatPressSpy()
- {
- global $wpdb;
- $table_name = $wpdb->prefix . "statpress";
-
- $LIMIT = 20;
-
- if(isset($_GET['pn']))
- {
- // Get Current page from URL
- $page = $_GET['pn'];
- if($page <= 0)
- {
- // Page is less than 0 then set it to 1
- $page = 1;
- }
- }
- else
- {
- // URL does not show the page set it to 1
- $page = 1;
- }
-
- // Create MySQL Query String
- $strqry = "SELECT id FROM $table_name WHERE (spider='' AND feed='') GROUP BY ip";
- $query = $wpdb->get_results($strqry);
- $TOTALROWS = $wpdb->num_rows;
- $NumOfPages = $TOTALROWS / $LIMIT;
- $LimitValue = ($page * $LIMIT) - $LIMIT;
-
-
- // Spy
- $today = gmdate('Ymd', current_time('timestamp'));
- $yesterday = gmdate('Ymd', current_time('timestamp') - 86400);
- print "<div class='wrap'><h2>" . __('Spy', 'statpress') . "</h2>";
- $sql = "SELECT ip,nation,os,browser,agent FROM $table_name WHERE (spider='' AND feed='') GROUP BY ip ORDER BY id DESC LIMIT $LimitValue, $LIMIT";
- $qry = $wpdb->get_results($sql);
- ?>
- <script>
- function ttogle(thediv){
- if (document.getElementById(thediv).style.display=="inline") {
- document.getElementById(thediv).style.display="none"
- } else {document.getElementById(thediv).style.display="inline"}
- }
- </script>
- <div align="center">
- <div id="paginating" align="center">Pages:
- <?php
-
- // Check to make sure we’re not on page 1 or Total number of pages is not 1
- if($page == ceil($NumOfPages) && $page != 1) {
- for($i = 1; $i <= ceil($NumOfPages)-1; $i++) {
- // Loop through the number of total pages
- if($i > 0) {
- // if $i greater than 0 display it as a hyperlink
- echo '<a href="' . $_SERVER['SCRIPT_NAME'] . '?page=statpress-reloaded/statpress.php&statpress_action=spy&pn=' . $i . '">' . $i . '</a> ';
- }
- }
- }
- if($page == ceil($NumOfPages) ) {
- $startPage = $page;
- } else {
- $startPage = 1;
- }
- for ($i = $startPage; $i <= $page+6; $i++) {
- // Display first 7 pages
- if ($i <= ceil($NumOfPages)) {
- // $page is not the last page
- if($i == $page) {
- // $page is current page
- echo " [{$i}] ";
- } else {
- // Not the current page Hyperlink them
- echo '<a href="' . $_SERVER['SCRIPT_NAME'] . '?page=statpress-reloaded/statpress.php&statpress_action=spy&pn=' . $i . '">' . $i . '</a> ';
- }
- }
- }
- ?>
- </div>
- <table id="mainspytab" name="mainspytab" width="99%" border="0" cellspacing="0" cellpadding="4">
- <?php
- foreach ($qry as $rk)
- {
- print "<tr><td colspan='2' bgcolor='#dedede'><div align='left'>";
- print "<IMG SRC='http://api.hostip.info/flag.php?ip=" . $rk->ip . "' border=0 width=18 height=12>";
- print " <strong><span><font size='2' color='#7b7b7b'>" . $rk->ip . "</font></span></strong> ";
- print "<span style='color:#006dca;cursor:pointer;border-bottom:1px dotted #AFD5F9;font-size:8pt;' onClick=ttogle('" . $rk->ip . "');>" . __('more info', 'statpress') . "</span></div>";
- print "<div id='" . $rk->ip . "' name='" . $rk->ip . "'>" . $rk->os . ", " . $rk->browser;
- // print "<br><iframe style='overflow:hide;border:0px;width:100%;height:15px;font-family:helvetica;paddng:0;' scrolling='no' marginwidth=0 marginheight=0 src=http://showip.fakap.net/txt/".$rk->ip."></iframe>";
- print "<br><iframe style='overflow:hide;border:0px;width:100%;height:40px;font-family:helvetica;paddng:0;' scrolling='no' marginwidth=0 marginheight=0 src=http://api.hostip.info/get_html.php?ip=" . $rk->ip . "></iframe>";
- if ($rk->nation)
- {
- print "<br><small>" . gethostbyaddr($rk->ip) . "</small>";
- }
- print "<br><small>" . $rk->agent . "</small>";
- print "</div>";
- print "<script>document.getElementById('" . $rk->ip . "').style.display='none';</script>";
- print "</td></tr>";
- $qry2 = $wpdb->get_results("SELECT * FROM $table_name WHERE ip='" . $rk->ip . "' AND (date BETWEEN '$yesterday' AND '$today') order by id LIMIT 10");
- foreach ($qry2 as $details)
- {
- print "<tr>";
- print "<td valign='top' width='151'><div><font size='1' color='#3B3B3B'><strong>" . irihdate($details->date) . " " . $details->time . "</strong></font></div></td>";
- print "<td><div><a href='" . irigetblogurl() . ((strpos($details->urlrequested, 'index.php') === FALSE) ? $details->urlrequested : '') . "' target='_blank'>" . iri_StatPress_Decode($details->urlrequested) . "</a>";
- if ($details->searchengine != '')
- {
- print "<br><small>" . __('arrived from', 'statpress') . " <b>" . $details->searchengine . "</b> " . __('searching', 'statpress') . " <a href='" . $details->referrer . "' target=_blank>" . urldecode($details->search) . "</a></small>";
- }
- elseif ($details->referrer != '' && strpos($details->referrer, get_option('home')) === false)
- {
- print "<br><small>" . __('arrived from', 'statpress') . " <a href='" . $details->referrer . "' target=_blank>" . $details->referrer . "</a></small>";
- }
- print "</div></td>";
- print "</tr>\n";
- }
- }
- ?>
- </table>
- </div>
- <?php
- }
-
-
- function iriStatPressSearch($what = '')
- {
- global $wpdb;
- $table_name = $wpdb->prefix . "statpress";
-
- $f['urlrequested'] = __('URL Requested', 'statpress');
- $f['agent'] = __('Agent', 'statpress');
- $f['referrer'] = __('Referrer', 'statpress');
- $f['search'] = __('Search terms', 'statpress');
- $f['searchengine'] = __('Search engine', 'statpress');
- $f['os'] = __('Operative system', 'statpress');
- $f['browser'] = __('Browser', 'statpress');
- $f['spider'] = __('Spider', 'statpress');
- $f['ip'] = __('IP', 'statpress');
- ?>
- <div class='wrap'><h2><?php
- _e('Search', 'statpress');
- ?></h2>
- <form method=get><table>
- <?php
- for ($i = 1; $i <= 3; $i++)
- {
- print "<tr>";
- print "<td>" . __('Field', 'statpress') . " <select name=where$i><option value=''></option>";
- foreach (array_keys($f) as $k)
- {
- print "<option value='$k'";
- if ($_GET["where$i"] == $k)
- {
- print " SELECTED ";
- }
- print ">" . $f[$k] . "</option>";
- }
- print "</select></td>";
- print "<td><input type=checkbox name=groupby$i value='checked' " . $_GET["groupby$i"] . "> " . __('Group by', 'statpress') . "</td>";
- print "<td><input type=checkbox name=sortby$i value='checked' " . $_GET["sortby$i"] . "> " . __('Sort by', 'statpress') . "</td>";
- print "<td>, " . __('if contains', 'statpress') . " <input type=text name=what$i value='" . $_GET["what$i"] . "'></td>";
- print "</tr>";
- }
- ?>
- </table>
- <br>
- <table>
- <tr>
- <td>
- <table>
- <tr><td><input type=checkbox name=oderbycount value=checked <?php
- print $_GET['oderbycount']
- ?>> <?php
- _e('sort by count if grouped', 'statpress');
- ?></td></tr>
- <tr><td><input type=checkbox name=spider value=checked <?php
- print $_GET['spider']
- ?>> <?php
- _e('include spiders/crawlers/bot', 'statpress');
- ?></td></tr>
- <tr><td><input type=checkbox name=feed value=checked <?php
- print $_GET['feed']
- ?>> <?php
- _e('include feed', 'statpress');
- ?></td></tr>
- <tr><td><input type=checkbox name=distinct value=checked <?php
- print $_GET['distinct']
- ?>> <?php
- _e('SELECT DISTINCT', 'statpress');
- ?></td></tr>
- </table>
- </td>
- <td width=15> </td>
- <td>
- <table>
- <tr>
- <td><?php
- _e('Limit results to', 'statpress');
- ?>
- <select name=limitquery><?php
- if ($_GET['limitquery'] > 0)
- {
- print "<option>" . $_GET['limitquery'] . "</option>";
- }
- ?><option>1</option><option>5</option><option>10</option><option>20</option><option>50</option><option>100</option><option>250</option><option>500</option></select>
- </td>
- </tr>
- <tr><td> </td></tr>
- <tr>
- <td align=right><input type=submit value=<?php
- _e('Search', 'statpress');
- ?> name=searchsubmit></td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- <input type=hidden name=page value='statpress-reloaded/statpress.php'><input type=hidden name=statpress_action value=search>
- </form><br>
- <?php
- if (isset($_GET['searchsubmit']))
- {
- // query builder
- $qry = "";
- // FIELDS
- $fields = "";
- for ($i = 1; $i <= 3; $i++)
- {
- if ($_GET["where$i"] != '')
- {
- $fields .= $_GET["where$i"] . ",";
- }
- }
- $fields = rtrim($fields, ",");
- // WHERE
- $where = "WHERE 1=1";
- if ($_GET['spider'] != 'checked')
- {
- $where .= " AND spider=''";
- }
- if ($_GET['feed'] != 'checked')
- {
- $where .= " AND feed=''";
- }
- for ($i = 1; $i <= 3; $i++)
- {
- if (($_GET["what$i"] != '') && ($_GET["where$i"] != ''))
- {
- $where .= " AND " . $_GET["where$i"] . " LIKE '%" . mysql_real_escape_string($_GET["what$i"]) . "%'";
- }
- }
- // ORDER BY
- $orderby = "";
- for ($i = 1; $i <= 3; $i++)
- {
- if (($_GET["sortby$i"] == 'checked') && ($_GET["where$i"] !=…
Large files files are truncated, but you can click here to view the full file