<?php
error_reporting (E_ALL ^ E_WARNING ^ E_NOTICE);
define("_SECURE",1); // define secure constant
include "admin_header.php"; // display header
$query = '';
$submit = '';
$start = '';
extract (getHttpVars()); // get all the passed input variables
if (isset($query)){ // contains the query string
$query = trim(substr($query,0,50));
}
if (isset($submit)){ // contains search mode (sites, links, keywords)
$submit = substr(trim($submit),0,50);
}
if (isset($start)){ // number of result page to be displayed
$start = substr(trim($start), 0, 6);
if (!preg_match("/^[0-9]+$/", $start)) {
$start = '1';
}
}
// get active database for Admin
if ($dba_act == '1') {
$db_con = db1_connect() ;
$success = @mysql_select_db ($database1, $db_con);
$mysql_table_prefix = $mysql_table_prefix1;
$tables = @mysql_query("select * from ".$mysql_table_prefix."addurl");
}
if ($dba_act == '2') {
$db_con = db2_connect() ;
$success = @mysql_select_db ($database2, $db_con);
$mysql_table_prefix = $mysql_table_prefix2;
$tables = @mysql_query("select * from ".$mysql_table_prefix."addurl");
}
if ($dba_act == '3') {
$db_con = db3_connect() ;
$success = @mysql_select_db ($database3, $db_con);
$mysql_table_prefix = $mysql_table_prefix3;
}
if ($dba_act == '4') {
$db_con = db4_connect() ;
$success = @mysql_select_db ($database4, $db_con);
$mysql_table_prefix = $mysql_table_prefix4;
}
if ($dba_act == '5') {
$db_con = db5_connect() ;
$success = @mysql_select_db ($database5, $db_con);
$mysql_table_prefix = $mysql_table_prefix5;
}
// for any 'submit' AND 'query' AND 'start' input we will produce some useful output
if ($query && $submit && $start) {
// first 'site' search
if ($query && strstr($submit, "sites")) {
// display headline
echo " <h1>Results for 'site' search and query: <span class='red'> $query </span></h1>";
$result = mysql_query("select * from ".$mysql_table_prefix."sites where url like '%$query%'");
if ($debug > '0') echo mysql_error();
if (mysql_num_rows($result) > 0) {
$num_rows = mysql_num_rows($result);
$pages = ceil($num_rows / $results_per_page); // Calculate count of required pages
if($start > $pages) $start = $pages;
if ($start < 1) $start = '1'; // As $start is not yet well defined, this is required for the first result page
if ($start == '1') {
$from = '0'; // Also for first page in order not to multipy with 0
}else{
$from = ($start-1) * $results_per_page; // First $num_row of actual page
}
$fromm = $from+1;
$to = $num_rows; // Last $num_row of actual page
$rest = $num_rows - $start;
if ($num_rows > $results_per_page) { // Display more then one page?
$rest = $num_rows - $from;
$to = $from + $rest; // $to for last page
if ($rest > $results_per_page) $to = $from + ($results_per_page); // Calculate $num_row of actual page
}
// display result header
echo "
<br /><br />
<table width='97%'>
<tr>
<td class='tblhead sml'>Displaying URLs ".$fromm." - ".$to." from ".$num_rows."</td>
</tr>
</table>
<table width='97%'>
<tr>
<td class='tblhead sml'>No.</td>
<td class='tblhead sml'>URL</td>
<td class='tblhead sml'>Indexed</td>
<td class='tblhead sml'>Link count</td>
<td class='tblhead sml'>Site</td>
</tr>";
// prepare all site results
for ($i=$from; $i<$to; $i++) {
$n = $i+1;
$site_id = mysql_result($result, $i, "site_id");
$url = mysql_result($result, $i, "url");
$indexdate = mysql_result($result, $i, "indexdate");
if(!$indexdate) {
$indexdate = "---";
}
// get count of links for this site
$res = mysql_query("select * from ".$mysql_table_prefix."links where site_id like '$site_id'");
if ($debug > '0') echo mysql_error();
if (mysql_num_rows($result) > 0) {
$links = mysql_num_rows($res);
}
if ($class =="evrow") {
$class = "odrow";
} else {
$class = "evrow";
}
// dispaly results for this site
echo "
<tr class='$class'>
<td class='sml cntr'>$n</td>
<td class='sml'> <a href='".stripslashes($url)."' target='_blank' title='Visit site in new window'>".stripslashes($url)."</a></td>
<td class='sml cntr'>".stripslashes($indexdate)."</td>
<td class='sml cntr'>".stripslashes($links)."</td>
<td class='sml cntr'><a href='admin.php?f=20&site_id=$site_id' class='options' title='Click to browse site options'>Options</a></td>
</tr>";
}
echo "
</table>";
} else {
echo " <br /><br />
<p class='cntr'>Nothing found for site query: '$query'<p>
";
}
}
// now 'link' search
if($query && strstr($submit, "links")) {
// display headline
echo " <h1>Results for 'link' search and query: <span class='red'> $query </span></h1>";
$result = mysql_query("select * from ".$mysql_table_prefix."links where url like '%$query%'");
if ($debug > '0') echo mysql_error();
if (mysql_num_rows($result) > 0) {
$links = '0';
$num_rows = mysql_num_rows($result);
$pages = ceil($num_rows / $results_per_page); // Calculate count of required pages
if($start > $pages) $start = $pages;
if ($start < 1) $start = '1'; // As $start is not yet well defined, this is required for the first result page
if ($start == '1') {
$from = '0'; // Also for first page in order not to multipy with 0
}else{
$from = ($start-1) * $results_per_page; // First $num_row of actual page
}
$fromm = $from+1;
$to = $num_rows; // Last $num_row of actual page
$rest = $num_rows - $start;
if ($num_rows > $results_per_page) { // Display more then one page?
$rest = $num_rows - $from;
$to = $from + $rest; // $to for last page
if ($rest > $results_per_page) $to = $from + ($results_per_page); // Calculate $num_row of actual page
}
// display result header
echo "
<br /><br />
<table width='97%'>
<tr>
<td class='tblhead sml'>Displaying URLs ".$fromm." - ".$to." from ".$num_rows."</td>
</tr>
</table>
<table width='97%'>
<tr>
<td class='tblhead sml'>No.</td>
<td class='tblhead sml'>URL</td>
<td class='tblhead sml'>Indexed</td>
</tr>";
// prepare all link results
for ($i=$from; $i<$to; $i++) {
$n = $i+1;
$url = mysql_result($result, $i, "url");
$indexdate = mysql_result($result, $i, "indexdate");
if(!$indexdate) {
$indexdate = "---";
}
if ($class =="evrow") {
$class = "odrow";
} else {
$class = "evrow";
}
// dispaly results for this link
echo "
<tr class='$class'>
<td class='sml cntr'>$n</td>
<td class='sml'> <a href='".stripslashes($url)."' target='_blank' title='Visit site in new window'>".stripslashes($url)."</a></td>
<td class='sml cntr'>".stripslashes($indexdate)."</td>
</tr>";
}
echo "
</table>";
} else {
echo " <br /><br />
<p class='cntr'>Nothing found for link query: '$query'<p>
";
}
}
// now the 'keyword' search
if($query && strstr($submit, "keywords")) {
// display headline
echo " <h1>Results for 'keyword' search and query: <span class='red'> $query </span></h1>";
$result = mysql_query("select * from ".$mysql_table_prefix."keywords where keyword like '%$query%'");
if ($debug > '0') echo mysql_error();
if (mysql_num_rows($result) > 0) {
$num_rows = mysql_num_rows($result);
// display result header
echo "
<br /><br />
<table width='97%'>
<tr>
<td class='tblhead sml'>Displaying ".$num_rows." keywords</td>
</tr>
</table>";
// prepare all keywors results
for ($i=$from; $i<$num_rows; $i++) {
$keywords .= "".(mysql_result($result, $i, "keyword")).", ";
}
//$keywords = preg_replace("/[^a-zAZ0-9,. -\/]+/si","", $keywords);
//$keywords = str_replace("Ãâ", "", $keywords);
echo "<table width='97%'>
<tr>
<td class='sml'><br />$keywords<br /><br /></td>
</tr>";
echo "
</table>";
} else {
echo " <br /><br />
<p class='cntr'>No keyword found for query: '$query'<p>
";
}
}
// finally the 'category' search
if($query && strstr($submit, "categories")) {
// display headline
echo " <h1>Results for 'category' search and query: <span class='red'> $query </span></h1>";
$result = mysql_query("select * from ".$mysql_table_prefix."categories where category like '%$query%'");
if ($debug > '0') echo mysql_error();
if (mysql_num_rows($result) > 0) {
$num_rows = mysql_num_rows($result);
// display result header
echo "
<br /><br />
<table width='97%'>
<tr>
<td class='tblhead sml'>Displaying ".$num_rows." categories</td>
</tr>
</table>";
// prepare all keywors results
for ($i=$from; $i<$num_rows; $i++) {
$categories .= "".(mysql_result($result, $i, "category")).", ";
}
//$keywords = preg_replace("/[^a-zAZ0-9,. -\/]+/si","", $keywords);
//$keywords = str_replace("Ãâ", "", $keywords);
echo "<table width='97%'>
<tr>
<td class='sml'><br />$categories<br /><br /></td>
</tr>";
echo "
</table>";
} else {
echo " <br /><br />
<p class='cntr'>No category found for query: '$query'<p>
";
}
}
if ($pages > 1) { // If we have more than 1 result-page
echo "<br ><br />
<div class='submenu cntr y5'>
Result page: $start from $pages
<br /><br />
<form class='cntr' name='form_page' method='post' action='admin_search.php'>
Page selection:
";
if($start > 1) { // Display 'First'
echo " <a href='admin_search.php?start=1&query=$query&submit=$submit'>First</a>
";
if ($start > 5 ) { // Display '-5'
$minus = $start-5;
echo " <a href='admin_search.php?start=$minus&query=$query&submit=$submit'>- 5</a>
";
}
}
if($start > 1) { // Display 'Previous'
$prev = $start-1;
echo " <a href='admin_search.php?start=$prev&query=$query&submit=$submit'>Previous</a>
";
}
if($rest >= $results_per_page) { // Display 'Next'
$next = $start+1;
echo " <a href='admin_search.php?start=$next&query=$query&submit=$submit' >Next</a>
";
if ($pages-$start > 5 ) { // Display '+5'
$plus = $start+5;
echo " <a href='admin_search.php?start=$plus&query=$query&submit=$submit'>+ 5</a>
";
}
}
if($start < $pages) { // Display 'Last'
echo " <a href='admin_search.php?start=$pages&query=$query&submit=$submit'>Last</a>
";
}
echo " Page no.
<input name='start' id='start' value='$start' type='text' size='4' maxlength='6' title='Enter page number to be displayed.'/>
<input class='sbmt' type='submit' value='Jump' id='submit' title='Click once to jump to that page.' />
<input class='hide' type='hidden' name='query' value='$query' />
<input class='hide' type='hidden' name='submit' value='$submit' />
</form>
</div>";
}
} else {
// display query error warning
echo " <br /><br />
<h1><span class='red'> Invalid query for Admin search ! </span></h1>";
}
echo "
<br /><br />
<a class='bkbtn' href='admin.php?repeat=1' title='Go back'>Back to Admin's Sites view</a>
<br /><br />
</body>
</html>
";
exit();
?>