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'); $f['date'] = __('Date', 'statpress'); $f['time'] = __('Time', 'statpress'); ?>
"; print ""; print ""; print ""; print ""; print ""; } ?>
" . __('Field', 'statpress') . " " . __('Group by', 'statpress') . " " . __('Sort by', 'statpress') . ", " . __('if contains', 'statpress') . "

>
>
>
>
 

" . __('Results', 'statpress') . ""; $sql = "SELECT $fields FROM $table_name $where $groupby $orderby $limit;"; // print "$sql
"; print ""; for ($i = 1; $i <= 10; $i++) { if ($_GET["where$i"] != '') { print ""; } } if ($groupby != '') { print ""; } print ""; $qry = $wpdb->get_results($sql, ARRAY_N); foreach ($qry as $rk) { print ""; for ($i = 1; $i <= 10; $i++) { print ""; } print ""; } print "
" . ucfirst($_GET["where$i"]) . "" . __('Count', 'statpress') . "
"; if ($_GET["where$i"] == 'urlrequested') { print sps_Decode($rk[$i - 1]); } else { print $rk[$i - 1]; } print "
"; print "

sql: $sql"; } ?>