<html>
<head>
<title>Estatisticas de acesso</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<link href="style.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<?php if (file_exists("../install.php")) { ?>
alert("\n\nYOU HAVE NOT DELETED \"install.php\". PLEASE DELETE THE FILE!\n\n\n");
<?php if (file_exists("../upgrade_1.0.1.php")) { ?>
alert("\n\nYOU HAVE NOT DELETED \"upgrade_1.0.1.php\". PLEASE DELETE THE FILE!\n\n\n");
<?php
}
}
if ($orderby == "") {
$orderby = "uniq_total";
}
?>
function openwin(what) {
var temp = "";
for (i=0; i<document.form1.trade_id.length; i++) { if (document.form1.trade_id[i].checked) { var temp = document.form1.trade_id[i].value; } }
if (what == "addtrade") { url = "addtrade.php"; features = "width=400,height=310,status=0,resizable=1"; }
if (what == "edit" && temp != "") { url = "edit.php?id="+temp; features = "width=660,height=580,scrollbars=1,resizable=1"; }
if (what == "iplog") { url = "iplog.php?id="+temp; features = "width=340,height=400,status=1,resizable=1,scrollbars=1"; }
if (what == "reflog") { url = "reflog.php?id="+temp; features = "width=500,height=400,status=1,resizable=1,scrollbars=1"; }
if (what == "settings") { url = "settings.php"; features = "width=440,height=500,status=1,resizable=1,scrollbars=1"; }
if (what == "delete") { url = "delete.php?id="+temp; features = "width=400,height=180,status=0,resizable=1,scrollbars=0"; }
if (what == "reset") { url = "reset.php?id="+temp; features = "width=400,height=120,status=0,resizable=1,scrollbars=0"; }
if (what == "turbo" || what == "turbo_off" || what == "turbo_on") {
if (what == "turbo_on") { url = "turbo.php?mode=on"; }
if (what == "turbo_off") { url = "turbo.php?mode=off"; }
features = "width=450,height=120,status=0,resizable=1,scrollbars=0";
}
if (what == "turbotrade") { url = "turbo.php?id="+temp; features = "width=500,height=120,status=0,resizable=1,scrollbars=0"; }
if (what == "toplist") { url = "toplist.php"; features = "width=490,height=550,status=0,resizable=1,scrollbars=1"; }
if (what == "changepass") { url = "settings.php?change=1"; features = "width=400,height=310,status=0,resizable=1"; }
if (what == "links") { url = "links.php"; features = "width=750,height=350,status=0,resizable=1,scrollbars=1"; }
if (what == "daily") { url = "daily.php"; features = "width=490,height=400,status=0,resizable=1,scrollbars=1"; }
if (what == "blacklist") { url = "blacklist.php"; features = "width=600,height=400,status=0,resizable=1,scrollbars=1"; }
window.open(url, "_blank", features);
}
</script>
<style>
<!--
BODY, TD {
font-family : Tahoma;
font-size : 8pt;
}
A {
text-decoration: none;
color: black;
}
A:Hover {
text-decoration: underline;
color: red;
}
-->
</style>
<base target="_blank">
</head>
<body bgcolor="#FFFFFF" text="#000000" link="#000000" vlink="#000000" alink="#000000">
<?php
require("ttt-mysqlvalues.inc.php");
require("ttt-mysqlfunc.inc.php");
open_conn();
$time = localtime();
$thishour = $time[2];
$res = mysql_query("SELECT turbomode, max_trades FROM ttt_settings");
$row = mysql_fetch_array($res);
extract($row);
$res = mysql_query("SELECT COUNT(*) FROM ttt_trades");
$total_trades = mysql_fetch_array($res);
$total_trades = $total_trades[0]-3;
if ($turbomode == 1) { $msg = "Script Currently In Turbo Mode"; }
else { $msg = ""; }
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<form name="form1" action="">
<BR>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center"><font color="#FF0000" size="3" face="Verdana, Arial, Helvetica, sans-serif, tahoma"><strong> Estatisticas de acesso.</strong></font></div></td>
</tr>
</table>
<br>
<table width="100%" border="1" cellpadding="1" cellspacing="2" bordercolor="#000000" bgcolor="#E4E4E4">
<tr class="toprows">
<td colspan="2" rowspan="2" bgcolor="#FF0000"> <div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma">Dominio</font></strong></div></td>
<td colspan="4" bgcolor="#FF0000"> <div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma">Última
Hora</font></strong></div></td>
<td colspan="4" bgcolor="#FF0000"> <div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma">Últimas
23 horas + Última hora</font></strong></div></td>
</tr>
<tr class="toprows">
<td width="8%" bgcolor="#FF0000"><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma">Enviou</font></strong></div></td>
<td width="7%" bgcolor="#FF0000"><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma">Recebeu</font></strong></div></td>
<td width="11%" bgcolor="#FF0000"><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma">Clicks</font></strong></div></td>
<td width="13%" bgcolor="#FF0000"><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma">Produtividade</font></strong></div></td>
<td width="8%" bgcolor="#FF0000"><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma">Enviou</font></strong></div></td>
<td width="7%" bgcolor="#FF0000"><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma">Recebeu</font></strong></div></td>
<td width="11%" bgcolor="#FF0000"><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma">Clicks</font></strong></div></td>
<td width="13%" bgcolor="#FF0000"><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma">Produtividade</font></strong></div></td>
</tr>
<?
$res = mysql_query("SELECT ttt_trades.trade_id, sitedomain, ratio, siteurl, sitename, wm_email, wm_icq, ratio, enabled, in$thishour AS in_hour, uniq$thishour AS uniq_hour, clicks$thishour AS clicks_hour, out$thishour AS out_hour, in0+in1+in2+in3+in4+in5+in6+in7+in8+in9+in10+in11+in12+in13+in14+in15+in16+in17+in18+in19+in20+in21+in21+in22+in23 AS in_total, uniq0+uniq1+uniq2+uniq3+uniq4+uniq5+uniq6+uniq7+uniq8+uniq9+uniq10+uniq11+uniq12+uniq13+uniq14+uniq15+uniq16+uniq17+uniq18+uniq19+uniq20+uniq21+uniq22+uniq23 AS uniq_total, clicks0+clicks1+clicks2+clicks3+clicks4+clicks5+clicks6+clicks7+clicks8+clicks9+clicks10+clicks11+clicks12+clicks13+clicks14+clicks15+clicks16+clicks17+clicks18+clicks19+clicks20+clicks21+clicks22+clicks23 AS clicks_total, out0+out1+out2+out3+out4+out5+out6+out7+out8+out9+out10+out11+out12+out13+out14+out15+out16+out17+out18+out19+out20+out21+out22+out23 AS out_total, fh$thishour AS myforce, fd$thishour AS myforced FROM ttt_trades, ttt_stats, ttt_forces WHERE ttt_trades.trade_id=ttt_stats.trade_id AND ttt_trades.trade_id=ttt_forces.trade_id AND ttt_trades.trade_id!=1 AND ttt_trades.trade_id!=2 AND ttt_trades.trade_id!=3 ORDER BY $orderby DESC") or print_error(mysql_error());
while ($row = mysql_fetch_array($res)) {
extract($row);
if ($in_hour == 0) {
$prod_hour = "no hits";
$return_hour = "no hits";
$uniq_pct_hour = "no hits";
}
else {
$prod_hour = "" . round($clicks_hour/$in_hour*100, 1) . "%";
$return_hour = "" . round($out_hour/$in_hour*100, 1) . "%";
$uniq_pct_hour = "" . round($uniq_hour/$in_hour*100, 1) . "%";
}
if ($in_total == 0) {
$prod_total = "no hits";
$return_total = "no hits";
$uniq_pct_total = "no hits";
}
else {
$prod_total = "" . round($clicks_total/$in_total*100, 1) . "%";
$return_total = "" . round($out_total/$in_total*100, 1) . "%";
$uniq_pct_total = "" . round($uniq_total/$in_total*100, 1) . "%";
}
if ($out_total == 0) { $qvalue = "--"; }
else { $qvalue = number_format($clicks_total/$out_total, 2); }
$ratio = "" . $ratio*100 . "%";
$sum["in_hour"] += $in_hour;
$sum["uniq_hour"] += $uniq_hour;
$sum["clicks_hour"] += $clicks_hour;
$sum["out_hour"] += $out_hour;
$sum["in_total"] += $in_total;
$sum["uniq_total"] += $uniq_total;
$sum["clicks_total"] += $clicks_total;
$sum["out_total"] += $out_total;
$sum["myforce"] += $myforce;
$sum["myforced"] += $myforced;
if ($enabled == 0) { $bg = "bgcolor=\"#0099CC\""; }
elseif ($enabled == 2) { $bg = "bgcolor=\"#FFFF99\""; }
elseif ($turbo == 1) { $bg = "bgcolor=\"#00CC66\""; }
else { $bg = "bgcolor=\"EFEFEF\""; }
print <<<END
<tr $bg class="traderow">
<td colspan="2" align="left"><div align="center"><a href="$siteurl" title="Nome do Site: $sitename">$sitedomain</a></div></td>
<td bgcolor="#80FFFF"><div align="center">$in_hour</div></td>
<td bgcolor="#FFFF00"><div align="center">$out_hour</div></td>
<td bgcolor="#80FF80"><div align="center">$clicks_hour</div></td>
<td bgcolor="#FF80FF"><div align="center">$prod_hour</div></td>
<td bgcolor="#80FFFF"><div align="center">$in_total</div></td>
<td bgcolor="#FFFF00"><div align="center">$out_total</div></td>
<td bgcolor="#80FF80"><div align="center">$clicks_total</div></td>
<td bgcolor="#FF80FF"><div align="center">$prod_total</div></td>
</tr>
END;
}
?>
<?php
$res = mysql_query("SELECT in$thishour AS in_hour, uniq$thishour AS uniq_hour, clicks$thishour AS clicks_hour, out$thishour AS out_hour, in0+in1+in2+in3+in4+in5+in6+in7+in8+in9+in10+in11+in12+in13+in14+in15+in16+in17+in18+in19+in20+in21+in21+in22+in23 AS in_total, uniq0+uniq1+uniq2+uniq3+uniq4+uniq5+uniq6+uniq7+uniq8+uniq9+uniq10+uniq11+uniq12+uniq13+uniq14+uniq15+uniq16+uniq17+uniq18+uniq19+uniq20+uniq21+uniq22+uniq23 AS uniq_total, clicks0+clicks1+clicks2+clicks3+clicks4+clicks5+clicks6+clicks7+clicks8+clicks9+clicks10+clicks11+clicks12+clicks13+clicks14+clicks15+clicks16+clicks17+clicks18+clicks19+clicks20+clicks21+clicks22+clicks23 AS clicks_total, out0+out1+out2+out3+out4+out5+out6+out7+out8+out9+out10+out11+out12+out13+out14+out15+out16+out17+out18+out19+out20+out21+out22+out23 AS out_total FROM ttt_stats WHERE ttt_stats.trade_id=1") or print_error(mysql_error());
$row = mysql_fetch_array($res);
extract($row);
if ($in_hour == 0) { $prod_hour = "no hits"; $uniq_pct_hour = "no hits"; }
else { $prod_hour = "" . round($clicks_hour/$in_hour*100, 1) . "%"; $uniq_pct_hour = "" . round($uniq_hour/$in_hour*100, 1) . "%"; }
if ($in_total == 0) { $prod_total = "no hits"; $uniq_pct_total = "no hits"; }
else { $prod_total = "" . round($clicks_total/$in_total*100, 1) . "%"; $uniq_pct_total = "" . round($uniq_total/$in_total*100, 1) . "%"; }
$sum["in_hour"] += $in_hour;
$sum["uniq_hour"] += $uniq_hour;
$sum["clicks_hour"] += $clicks_hour;
$sum["out_hour"] += $out_hour;
$sum["in_total"] += $in_total;
$sum["uniq_total"] += $uniq_total;
$sum["clicks_total"] += $clicks_total;
$sum["out_total"] += $out_total;
$res = mysql_query("SELECT clicks$thishour AS clicks_hour, clicks0+clicks1+clicks2+clicks3+clicks4+clicks5+clicks6+clicks7+clicks8+clicks9+clicks10+clicks11+clicks12+clicks13+clicks14+clicks15+clicks16+clicks17+clicks18+clicks19+clicks20+clicks21+clicks22+clicks23 AS clicks_total FROM ttt_stats WHERE ttt_stats.trade_id=2") or print_error(mysql_error());
$row = mysql_fetch_array($res);
extract($row);
$sum["clicks_hour"] += $clicks_hour;
$sum["clicks_total"] += $clicks_total;
$res = mysql_query("SELECT out$thishour AS out_hour, out0+out1+out2+out3+out4+out5+out6+out7+out8+out9+out10+out11+out12+out13+out14+out15+out16+out17+out18+out19+out20+out21+out22+out23 AS out_total FROM ttt_stats WHERE ttt_stats.trade_id=3") or print_error(mysql_error());
$row = mysql_fetch_array($res);
extract($row);
close_conn();
print <<<END
<tr bgcolor="#FF0000" class="toprows">
<td colspan="2"><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif">Total</font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma"><a title="Raw In">Enviou</a></font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma"><a title="Out to Trade">Recebeu</a></font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma"><a title="Clicks by Trader">Clicks</a></font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma">Produtividade</font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma"><a title="Raw In">Enviou</a></font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma"><a title="Out to Trade">Recebeu</a></font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma"><a title="Clicks by Trader">Clicks</a></font></strong></div></td>
<td><div align="center"><strong><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma">Produtividade</font></strong></div></td>
</tr>
END;
?>
<?php
if ($sum["in_hour"] == 0) {
$sum["prod_hour"] = "no hits";
$sum["return_hour"] = "no hits";
$sum["uniq_pct_hour"] = "no hits";
}
else {
$sum["prod_hour"] = "" . round($sum["clicks_hour"]/$sum["in_hour"]*100, 1) . "%";
$sum["return_hour"] = "" . round($sum["out_hour"]/$sum["in_hour"]*100, 1) . "%";
$sum["uniq_pct_hour"] = "" . round($sum["uniq_hour"]/$sum["in_hour"]*100, 1) . "%";
}
if ($sum["in_total"] == 0) {
$sum["prod_total"] = "no hits";
$sum["return_total"] = "no hits";
$sum["uniq_pct_total"] = "no hits";
}
else {
$sum["prod_total"] = "" . round($sum["clicks_total"]/$sum["in_total"]*100, 1) . "%";
$sum["return_total"] = "" . round($sum["out_total"]/$sum["in_total"]*100, 1) . "%";
$sum["uniq_pct_total"] = "" . round($sum["uniq_total"]/$sum["in_total"]*100, 1) . "%";
}
print <<<END
<tr class="toprows" height="25">
<td bgcolor="#EFEFEF" colspan="2"><font size="1" face="Verdana, Arial, Helvetica, sans-serif, tahoma"><strong>Todos
os Sites</strong></font></td>
<td bgcolor="#80FFFF">$sum[in_hour]</td>
<td bgcolor="#FFFF00">$sum[out_hour]</td>
<td bgcolor="#80FF80">$sum[clicks_hour]</td>
<td bgcolor="#FF80FF">$sum[prod_hour]</td>
<td bgcolor="#80FFFF">$sum[in_total]</td>
<td bgcolor="#FFFF00">$sum[out_total]</td>
<td bgcolor="#80FF80">$sum[clicks_total]</td>
<td bgcolor="#FF80FF">$sum[prod_total]</td>
</tr>
END;
?>
</table></td>
</tr>
</table>
<br>
</form>
Total de Sites cadastrados: <?php echo $total_trades; ?>
<center>
<font size="2"><b>Total de Sites cadastrados: </b><?php echo $total_trades; ?></font>
<BR>
<table width="800" border="0" cellspacing="0" cellpadding="0" align="center">
<tr class="traderow">
<td width="55%" align="left"><b><font size="3"><u>Estado do Dominio</u>:</font></b></td>
</tr>
<td align="left" valign="top">
<table width="100%" border="0" cellspacing="2" cellpadding="0" class="traderow">
<tr>
<td width="20" bgcolor="#0099CC"> </td>
<td align="left">Trade Suspenso (Admin)</td>
</tr>
<tr>
<td width="20" bgcolor="#FFFF99"> </td>
<td align="left">Trade Suspenso Automaticamente (Force Hits para ser reativado)</td>
</tr>
</table>
<br>
<center>
<a href="/ttt-webmaster.php" target=_self>Trocar Trafego Aqui</a>
<BR><BR>
</body>Se alguem poder me ajudar agradeço, pois estou precisando muito.
