<?
include("cdub_config.php");
if($action =="deleteall") {
$deleteall = mysql_query("DELETE FROM cdub_visitors");
$deletepages = mysql_query("DELETE FROM cdub_pagviews");
cdub_alertgo("All logs have been deleted.", "logs.php");
}
if($action =="deleteallnic") {
$deleteall = mysql_query("DELETE FROM cdub_visitors WHERE nic =''");
$deletepages = mysql_query("DELETE FROM cdub_pagviews WHERE nic =''");
cdub_alertgo("All logs with no nicname have been deleted.", "logs.php");
}
if($action =="delete") {
$deleteperson = mysql_query("DELETE FROM cdub_visitors WHERE id = '$deid'");
if(!$deleteperson) {
cdub_error("could not delete the entry, please try again");
} else {
cdub_alertgo ("Your selection has been deleted, Thanks!", "logs.php");
}
$deletepageviews = mysql_query("DELETE FROM cdub_pagviews WHERE ip = '$ipad'");
if(!$deletepageviews) {
cdub_error ("Could not delete the pageviews from database, please try again.");
} else {
cdub_alertgo ("PageViews have been deleted also.", "logs.php");
}
}
$limit = 5;
if ($offset == "") {
$offset = 0;
}
$Result=mysql_query("SELECT * FROM cdub_visitors WHERE ref LIKE '%$refer%'");
$countResult = mysql_num_rows($Result);
if ($offset == "") {
$num = 0;
} else {
$num = $offset+1;
}
?>
<div align="center">
<table width="619" border="0" cellpadding="0" cellspacing="0" background="http://www.snagaurl.com/i/intromid.gif">
<!--DWLayoutTable-->
<tr valign="middle">
<td colspan="3" align="right" bgcolor="white"><div align="center"> <font color="#993300" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>
<font color="#006699" size="1" face="Verdana, Arial, Helvetica, sans-serif">
<?
$pages=intval($countResult/$limit);
if ($countResult%$limit) {
$pages++;
}
if ($offset>1) {
$prevoffset=$offset-$limit;
echo ( "<a href=\"$PHP_SELF?offset=$prevoffset&refer=$refer\"><<</a> \n" );
} else {
echo ( "<< " );
}
for ($i=1;$i<=$pages;$i++) {
$newoffset=$limit*($i-1);
echo ( " <a href=\"$PHP_SELF?offset=$newoffset&refer=$refer\">$i</a> \n" );
}
if ($countResult>($offset+$limit)) {
$nextoffset=$offset+$limit;
echo ( " <a href=\"$PHP_SELF?offset=$nextoffset&refer=$refer\">>></i></a><p>\n" );
} else {
echo ( " >>" );
}
?>
</font> </strong></font></div></td>
</tr>
<tr valign="middle">
<td height="22" colspan="3" align="right" background="http://www.snagaurl.com/i/domaintop.gif"><div align="left"> <font color="#993300" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>
Visitor Logs</strong></font></div></td>
</tr>
<tr>
<td width="25" height="86" valign="top"><!--DWLayoutEmptyCell--> </td>
<td width="571" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="571" valign="top" class="bluetxtbotborder" >
<?
$limit = 5;
if ($offset == "") {
$offset = 0;
}
if ($offset == "") {
$num = 0;
} else {
$num = $offset+1;
}
?>
<?
$Result=mysql_query("Select * FROM cdub_vips");
$totalv = mysql_num_rows($Result);
$gettotalp = mysql_query("SELECT views FROM cdub_logs_views");
while ($row = mysql_fetch_array($gettotalp)) {
$totalp = $row["views"];
$average = $totalp / $totalv;
$average = round($average, 2);
?>
<font color="#006699" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Total
Unique Visitors : <font color='red'>
<?=$totalv?>
<font color="#006699">- Total Page Views</font></font></strong></font>
: <font color="#006699" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color='red'>
<?=$totalp?>
- <a href="logs.php?action=deleteall">Delete All Logs</a></font></strong></font>
<br>
<br>
<font color="#006699" size="2" face="Verdana, Arial, Helvetica, sans-serif"><font color="#009900" size="1">Average
Page views Per Visitor :<strong>
<?=$average?>
</strong></font></font> <font size="1"><strong><font color="#009900">
<?
}
$yahoo=mysql_query("Select * FROM cdub_visitors WHERE ref LIKE '%yahoo%'");
$yahooc = mysql_num_rows($yahoo);
$google=mysql_query("Select * FROM cdub_visitors WHERE ref LIKE '%google%'");
$googlec = mysql_num_rows($google);
$aol=mysql_query("Select * FROM cdub_visitors WHERE ref LIKE '%aol%'");
$aolc = mysql_num_rows($aol);
?>
</font></strong></font><strong><font color="#009900"> </font></strong> <br>
<hr size="1" noshade>
<div align="left"><font color="#CC0000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Hits
from Search Engines:</strong></font> <font size="1" face="Verdana, Arial, Helvetica, sans-serif"> <a href="logs.php?refer=yahoo"><font color="#FF9900">yahoo
-
<?=$yahooc?>
</font></a></font><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> <a href="logs.php?refer=google"><font color="#3300CC">google
-
<?=$googlec?>
</font> </a> <a href="logs.php?refer=aol"><font color="#999900">Aol
-
<?=$aolc?>
</font></a><font color="#999900">
</font> <strong><a href="logs.php"><font color="#666666">View
All Logs</font></a></strong></font></div>
<hr size="1" noshade></td>
</tr>
<tr>
<td width="571" valign="top" class="bluetxtbotborder" > <div align="left"><font size="1">
<?
$limit = 5;
if ($offset == "") {
$offset = 0;
}
$Result=mysql_query("SELECT * FROM cdub_visitors WHERE ref LIKE '%$refer%'");
$countResult = mysql_num_rows($Result);
$Result2=mysql_query("Select * FROM cdub_pagviews");
$countResult2 = mysql_num_rows($Result2);
if ($offset == "") {
$num = 0;
} else {
$num = $offset+1;
}
?>
<font color="#0066CC" face="Verdana, Arial, Helvetica, sans-serif">From
Logs Listed : Unique :</font><font color="#006699" face="Verdana, Arial, Helvetica, sans-serif"><font color='red'>
<?=$countResult?>
<font color="#0066CC">- Page Views</font></font></font><font color="#0066CC">
:</font> <font color="#006699" face="Verdana, Arial, Helvetica, sans-serif"><font color='red'>
<?=$countResult2?>
</font></font><a href="logs.php?action=deleteallnic"><font color="#FF00FF" face="Verdana, Arial, Helvetica, sans-serif">Delete
All with no nickname</font></a></font>
<hr size="3" noshade>
</div></td>
</tr>
<?
$getvisitors = mysql_query("SELECT * FROM cdub_visitors WHERE ref LIKE '%$refer%' ORDER BY id DESC LIMIT $offset, $limit");
while ($row = mysql_fetch_array($getvisitors)) {
$id = $row["id"];
$ip = $row["ip"];
$ref = $row["ref"];
$browse = $row["browse"];
$hits = $row["hits"];
$fvisit = $row["fvisit"];
$lvisit = $row["lvisit"];
$nic = $row["nic"];
if($ref =="") {
$ref = "Reached manually or through link via instant messenger.";
}
?>
<tr>
<td width="571" height="86" valign="top" class="bluetxtbotborder"><p><strong><font color="#006699" size="1" face="Verdana, Arial, Helvetica, sans-serif">I.P.
Address : </font></strong><font color="#006699" size="1" face="Verdana, Arial, Helvetica, sans-serif">
<?=$ip?>
-
<?
if($nic !="") {
echo("<b>nicname : </b>$nic");
} else {
?>
<a href='javascript:;' onClick="window.open('<?=$cdub_site?>/givnic.php?ipid=<? echo($id); ?>&ip=<?=$ip?>','newwindow','height=200,width=400,dependent=1,directories=0,locationA35=30,menubar=0,resizable=1,scrollbars=1,toolbar=0')">Assign
Nicname</a>
<?
}
?>
</font></p>
<p><font color="#006699" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Reffering
Site :</strong>
<?
if($ref =="Reached manually or through link via instant messenger.") {
?>
<font color='red'>
<?=$ref?>
</font>
<?
} else {
?>
<a href="<?=$ref?>" target="_blank"><font color='green'>
<?=$ref?>
</font></a>
<?
}
?>
</font></p>
<p><font color="#006699" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Browser
: </strong>
<?=$browse?>
</font></p>
<p><font color="#FF6600" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Total
Page Views : </strong>
<?=$hits?>
</font></p>
<p><font color="#666666" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><a href='javascript:;' onClick="window.open('<?=$cdub_site?>/pageviews.php?ip=<? echo($ip); ?>','newwindow','height=200,width=400,dependent=1,directories=0,locationA35=30,menubar=0,resizable=1,scrollbars=1,toolbar=0')">Click
to see Page Views</a></strong></font></p>
<p><font color="#006699" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>First
Visit : </strong> </font><font color="#FF6600" size="1" face="Verdana, Arial, Helvetica, sans-serif">
<?=$fvisit?>
</font><font color="#666666" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><br>
</strong></font><font color="#006699" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>Last
Visit :</strong></font><font color="#666666" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>
</strong></font><font color="#FF00FF" size="1" face="Verdana, Arial, Helvetica, sans-serif">
<?=$lvisit?>
</font></p>
<p><a href="../My%20Documents/websites/dupyup%20new/logs.php?action=delete&deid=<?=$id?>&ipad=<?=$ip?>"><font color="#666666" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>>>
Delete This Entry </strong></font></a><a href="../My%20Documents/websites/dupyup%20new/logs.php?action=delete&deid=<?=$id?>&ipad=<?=$ip?>"><font color="#666666" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong><<</strong></font></a></p>
<hr size="1"></td>
</tr>
<?
}
?>
</table></td>
<td width="23" valign="top" class="introtext"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="11" colspan="3" valign="top"><img src="http://www.snagaurl.com/i/introbot.gif" width="619" height="11"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="15" colspan="3" valign="top"><div align="center"><strong><font color="#006699" size="1" face="Verdana, Arial, Helvetica, sans-serif"><img src="http://www.snagaurl.com/i/spacer.gif" width="1" height="1">
<?
$pages=intval($countResult/$limit);
if ($countResult%$limit) {
$pages++;
}
if ($offset>1) {
$prevoffset=$offset-$limit;
echo ( "<a href=\"$PHP_SELF?offset=$prevoffset&refer=$refer\"><<</a> \n" );
} else {
echo ( "<< " );
}
for ($i=1;$i<=$pages;$i++) {
$newoffset=$limit*($i-1);
echo ( " <a href=\"$PHP_SELF?offset=$newoffset&refer=$refer\">$i</a> \n" );
}
if ($countResult>($offset+$limit)) {
$nextoffset=$offset+$limit;
echo ( " <a href=\"$PHP_SELF?offset=$nextoffset&refer=$refer\">>></i></a><p>\n" );
} else {
echo ( " >>" );
}
?>
</font></strong> </div></td>
</tr>
</table>
</div>