<?php
//----------------------------------------------------------------------
// CrawlTrack 3.2.2
//----------------------------------------------------------------------
// Crawler Tracker for website
//----------------------------------------------------------------------
// Author: Jean-Denis Brun
//----------------------------------------------------------------------
// Website: www.crawltrack.net
//----------------------------------------------------------------------
// That script is distributed under GNU GPL license
//----------------------------------------------------------------------
// file: menusite.php
//----------------------------------------------------------------------
// Last update: 13/03/2010
//----------------------------------------------------------------------
if (!defined('IN_CRAWLT'))
{
echo"<h1>Hacking attempt !!!!</h1>";
exit();
}
//initialize array
$listsites=array();
$urlsite=array();
$listidsite=array();
$nbrpagestotal=0;
if($_SESSION['rightsite']==0)
{
//mysql query
$sqlsite = "SELECT * FROM crawlt_site";
$requetesite = db_query($sqlsite, $connexion);
$nbrresult=mysql_num_rows($requetesite);
if($nbrresult>=1)
{
while ($ligne = mysql_fetch_object($requetesite))
{
$sitename=$ligne->name;
$siteurl=$ligne->url;
$siteid=$ligne->id_site;
$listsites[$siteid]=$sitename;
$urlsite[$siteid]=$siteurl;
$listsiteid[]=$siteid;
}
//case site 1 not in the base
if(!in_array($site, $listsiteid))
{
$site=min($listsiteid);
}
$sitename2=$listsites[$site];
//to avoid problem if the url is enter in the database with http://
if (!eregi("^http://", $urlsite[$site]))
{
$hostsite="http://".$urlsite[$site];
}
else
{
$hostsite= $urlsite[$site];
}
//preparation of site list display
if($navig==2 OR $navig==3)
{
if(!isset($_SESSION[$sitename2]))
{
//query to have the total number of page for the site
$sqlstats = "SELECT DISTINCT crawlt_pages_id_page FROM crawlt_visits
WHERE crawlt_site_id_site='".sql_quote($site)."'
AND crawlt_crawler_id_crawler !='0'
AND crawlt_crawler_id_crawler !='65500'
AND crawlt_crawler_id_crawler !='65501'
";
$requetestats = db_query($sqlstats, $connexion);
$nbrpagestotal = mysql_num_rows($requetestats);
$_SESSION[$sitename2]=$nbrpagestotal;
}
else
{
$nbrpagestotal=$_SESSION[$sitename2];
}
}
//display
echo"<div class=\"menusite\" align=\"center\">\n";
echo"<form action=\"index.php\" method=\"POST\">\n";
echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n";
echo "<input type=\"hidden\" name ='search' value=\"$search\">\n";
echo "<input type=\"hidden\" name ='period' value=\"$period\">\n";
echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n";
echo "<input type=\"hidden\" name ='validform' value=\"$validform\">\n";
echo "<input type=\"hidden\" name ='displayall' value=\"$displayall\">\n";
echo "<input type=\"hidden\" name ='order' value=\"$order\">\n";
echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n";
echo"<select onchange=\"form.submit()\" size=\"1\" name=\"site\" style=\" font-size:13px; font-weight:bold; color: #003399;
font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif; \">\n";
asort($listsites);
foreach($listsites as $id=>$sitename3)
{
if($id==$site && isset($_SESSION[$sitename3]))
{
echo"<option value=\"$id\" selected style=\" font-size:13px; font-weight:bold; color: #003399;
font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif;\">".$sitename3." • ".$_SESSION[$sitename3]." ".$language['page']."</option>\n";
}
elseif($id==$site && !isset($_SESSION[$sitename3]))
{
echo"<option value=\"$id\" selected style=\" font-size:13px; font-weight:bold; color: #003399;
font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif;\">".$sitename3."</option>\n";
}
elseif(isset($_SESSION[$sitename3]))
{
echo"<option value=\"$id\" style=\" font-size:13px; font-weight:bold; color: #003399;
font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif;\">".$sitename3." • ".$_SESSION[$sitename3]." ".$language['page']."</option>\n";
}
else
{
echo"<option value=\"$id\" style=\" font-size:13px; font-weight:bold; color: #003399;
font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif;\">".$sitename3."</option>\n";
}
}
if(count($listsites) > 1)
{
echo"<option value='0' style=\" font-size:13px; font-weight:bold; font-style:italic; color: #003399;
font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif;\">".$language['summary']."</option>\n";
}
echo"</select></form></div>\n";
}
}
else
{
//mysql query
$site=$_SESSION['rightsite'];
$sqlsite = "SELECT * FROM crawlt_site
WHERE id_site='".sql_quote($site)."'";
$requetesite = db_query($sqlsite, $connexion);
$nbrresult=mysql_num_rows($requetesite);
if($nbrresult>=1)
{
while ($ligne = mysql_fetch_object($requetesite))
{
$sitename=$ligne->name;
$siteurl=$ligne->url;
$siteid=$ligne->id_site;
$urlsite[$siteid]=$siteurl;
}
//to avoid problem if the url is enter in the database with http://
if (!eregi("^http://", $urlsite[$site]))
{
$hostsite="http://".$urlsite[$site];
}
else
{
$hostsite= $urlsite[$site];
}
if(!isset($_SESSION[$sitename]))
{
//query to have the total number of page for the site
$sqlstats = "SELECT DISTINCT crawlt_pages_id_page FROM crawlt_visits
WHERE crawlt_site_id_site='".sql_quote($site)."'
AND crawlt_crawler_id_crawler !='0'
AND crawlt_crawler_id_crawler !='65500'
AND crawlt_crawler_id_crawler !='65501'
";
$requetestats = db_query($sqlstats, $connexion);
$nbrpagestotal = mysql_num_rows($requetestats);
$_SESSION[$sitename]=$nbrpagestotal;
}
else
{
$nbrpagestotal=$_SESSION[$sitename];
}
//display
echo"<div class=\"menusite\" >\n";
echo"<form action=\"index.php\" method=\"POST\" >\n";
echo "<input type=\"hidden\" name ='navig' value=\"$navig\">\n";
echo "<input type=\"hidden\" name ='search' value=\"$search\">\n";
echo "<input type=\"hidden\" name ='period' value=\"$period\">\n";
echo "<input type=\"hidden\" name ='crawler' value=\"$crawler\">\n";
echo "<input type=\"hidden\" name ='validform' value=\"$validform\">\n";
echo "<input type=\"hidden\" name ='displayall' value=\"$displayall\">\n";
echo "<input type=\"hidden\" name ='order' value=\"$order\">\n";
echo "<input type=\"hidden\" name ='graphpos' value=\"$graphpos\">\n";
echo"<select size=\"1\" name=\"site\" style=\" font-size:13px; font-weight:bold; color: #003399;
font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif; width:244px;\">\n";
if(isset($_SESSION[$sitename]))
{
echo"<option value=\"$site\" selected style=\" font-size:13px; font-weight:bold; color: #003399;
font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif;\">".$sitename." • ".$_SESSION[$sitename]."</option>\n";
}
else
{
echo"<option value=\"$site\" selected style=\" font-size:13px; font-weight:bold; color: #003399;
font-family: Verdana,Geneva, Arial, Helvetica, Sans-Serif;\">".$sitename."</option>\n";
}
echo"</select></form></div>\n";
}
}
?>