echo $lang['txt216'];
?>
</td></tr></table><?php
if (empty($UNTRUSTED['top'])) {
$UNTRUSTED['top'] = 0;
}
$bgcolor = "";
$lastfive = "<tr><td colspan=4>Last five Query Strings for this refering page:</td></tr>";
if ($bgcolor == $color_alt2) {
$bgcolor = $color_alt1;
} else {
$bgcolor = $color_alt2;
}
if ($UNTRUSTED['typeofview'] == "levelvisits") {
print "<table width=600><tr bgcolor=#FFFFFF><td>.</td><td><b>" . $lang['url'] . "</b></td><td><b># Total </b></td><td><b># Direct</b></td><td><b>" . $lang['graph'] . "</b></td></tr>";
showchildrenof(0, 10, $whatYm, $expand_array, 'livehelp_referers_monthly', "refer", "", "", $UNTRUSTED['whichdepartment']);
print "</table>";
} else {
$query = "SELECT count(*) as totalrows FROM livehelp_referers_monthly WHERE dateof=" . intval($whatYm) . " AND directvisits!=0 AND department='" . intval($UNTRUSTED['whichdepartment']) . "' ORDER by directvisits DESC";
$sth = $mydatabase->query($query);
$row = $sth->fetchRow(DB_FETCHMODE_ASSOC);
$num_rows = $row['totalrows'];
if (empty($UNTRUSTED['offset'])) {
$UNTRUSTED['offset'] = 0;
}
if (empty($UNTRUSTED['perpage'])) {
$UNTRUSTED['perpage'] = 25;
}
$query = "SELECT * FROM livehelp_referers_monthly WHERE dateof=" . intval($whatYm) . " AND directvisits!=0 AND department='" . intval($UNTRUSTED['whichdepartment']) . "' ORDER by directvisits DESC LIMIT " . intval($UNTRUSTED['offset']) . "," . intval($UNTRUSTED['perpage']);
$visits_a = $mydatabase->query($query);
$pageUrl = "data.php";
echo $lang['txt216'];
?>
</td></tr></table><?php
if (empty($UNTRUSTED['top'])) {
$UNTRUSTED['top'] = 0;
}
$bgcolor = "";
$lastfive = "<tr><td colspan=4>" . $lang['txt220'] . ":</td></tr>";
if ($bgcolor == $color_background) {
$bgcolor = "F0F1E1";
} else {
$bgcolor = $color_background;
}
if ($UNTRUSTED['typeofview'] == "levelvisits") {
print "<table width=600><tr bgcolor=\"#FFFFFF\"><td>.</td><td><b>" . $lang['url'] . "</b></td><td><b># Total </b></td><td><b># Direct</b></td><td><b>" . $lang['graph'] . "</b></td></tr>";
showchildrenof(0, 10, $whatYm, $expand_array, 'livehelp_visits_monthly', 'visit', '', '', $whichdepartment);
print "</table>";
} else {
$query = "SELECT count(*) as totalrows FROM livehelp_visits_monthly WHERE dateof=" . intval($whatYm) . " AND directvisits!=0 AND department='" . intval($UNTRUSTED['whichdepartment']) . "' ORDER by directvisits DESC";
$sth = $mydatabase->query($query);
$row = $sth->fetchRow(DB_FETCHMODE_ASSOC);
$num_rows = $row['totalrows'];
if (empty($UNTRUSTED['offset'])) {
$UNTRUSTED['offset'] = 0;
}
if (empty($UNTRUSTED['perpage'])) {
$UNTRUSTED['perpage'] = 25;
}
$query = "SELECT * FROM livehelp_visits_monthly WHERE dateof=" . intval($whatYm) . " AND directvisits!=0 AND department='" . intval($UNTRUSTED['whichdepartment']) . "' ORDER by directvisits DESC LIMIT " . intval($UNTRUSTED['offset']) . "," . intval($UNTRUSTED['perpage']);
$visits_a = $mydatabase->query($query);
$pageUrl = "data.php";
/**
* Shows the child links of a common url as <tr> rows.
*
* @param int $recno the recno of the parent
* @param int $spacer the amount of space to indent.
*
* @global object $mydatabase mysql database object.
* @global array $UNTRUSTED array of user inputed variables.
*/
function showchildrenof($recno, $spacer, $whatYm, $expand_array, $tablename, $typeof = "refer", $parentstring = "", $urlsofar = "", $whichdepartment)
{
global $UNTRUSTED, $lang, $bgcolor, $color_background, $mydatabase, $color_alt2, $color_alt1;
$query = "SELECT count(*) as totalrows FROM {$tablename} WHERE parentrec=" . intval($recno) . " AND dateof=" . intval($whatYm) . " AND department='" . intval($whichdepartment) . "' ORDER by levelvisits DESC";
$sth = $mydatabase->query($query);
$row = $sth->fetchRow(DB_FETCHMODE_ASSOC);
$num_rows = $row['totalrows'];
$bgcolor = $color_alt2;
$lastfive = true;
$leveltop = "p" . $recno;
if (empty($UNTRUSTED[$leveltop])) {
$UNTRUSTED[$leveltop] = 0;
}
$nextparentsstring = $parentstring . "&{$leveltop}=" . $UNTRUSTED[$leveltop];
print "<tr bgcolor=#dedede><td> </td><td colspan=4>";
$pageUrl = "data.php";
$perPage = 25;
$varstring = "&tab=" . $UNTRUSTED['tab'] . "&typeofview=levelvisits&show=" . $UNTRUSTED['show'] . "&month=" . $UNTRUSTED['month'] . "&year=" . $UNTRUSTED['year'] . "&expand=" . $UNTRUSTED['expand'] . $parentstring . "&whichdepartment=" . $UNTRUSTED['whichdepartment'];
print pagingLinks($pageUrl, $num_rows, $varstring, $UNTRUSTED[$leveltop], $perPage, $leveltop);
print "</td></tr>";
$query = "SELECT * FROM {$tablename} WHERE parentrec=" . intval($recno) . " AND dateof=" . intval($whatYm) . " AND department='" . intval($whichdepartment) . "' ORDER by levelvisits DESC LIMIT {$UNTRUSTED[$leveltop]},{$perPage}";
$sth = $mydatabase->query($query);
while ($row = $sth->fetchRow(DB_FETCHMODE_ASSOC)) {
$contract = $UNTRUSTED['expand'];
$reg1 = "/," . $row['recno'] . "\$/";
$contract = preg_match($reg1, "", $contract);
$reg2 = "/," . $row['recno'] . ",/";
$contract = preg_match($reg2, "", $contract);
$reg3 = "/^" . $row['recno'] . ",/";
$contract = preg_match($reg3, "", $contract);
if (in_array($row['recno'], $expand_array)) {
$bgcolor = "#CED9FA";
}
if ($urlsofar != "") {
$displaytxt = str_replace($urlsofar, "", $row['pageurl']);
} else {
$displaytxt = $row['pageurl'];
}
if ($row['levelvisits'] == 0) {
if ($lastfive) {
print "<tr bgcolor={$bgcolor}><td> </td><td colspan=3>Last five Query Strings for this refering page:</td></tr>";
$lastfive = false;
}
print "\n<tr bgcolor={$bgcolor}><td>";
print " ";
print "</td><td NOWRAP><img src=images/blank.gif width={$spacer} height=10 border=0><a href=" . str_replace(" ", "+", $row['pageurl']) . " target=_blank>" . $displaytxt . "</a></td><td colspan=2> - </td></tr>\n\n";
} else {
print "\n<tr bgcolor={$bgcolor}><td>";
if (!in_array($row['recno'], $expand_array)) {
print "<a href=data.php?&tab=" . $UNTRUSTED['tab'] . "&month=" . $UNTRUSTED['month'] . "&year=" . $UNTRUSTED['year'] . "&typeofview=levelvisits&{$leveltop}=" . $UNTRUSTED[$leveltop] . "&show=" . $UNTRUSTED['show'] . "&expand=" . $UNTRUSTED['expand'] . "," . $row['recno'] . $parentstring . "&whichdepartment=" . $UNTRUSTED['whichdepartment'] . "><img src=images/plus.gif border=0></a>";
} else {
$contract = $UNTRUSTED['expand'];
$reg1 = "/," . $row['recno'] . "\$/";
$contract = preg_match($reg1, "", $contract);
$reg2 = "/," . $row['recno'] . ",/";
$contract = preg_match($reg2, "", $contract);
$reg3 = "/^" . $row['recno'] . ",/";
$contract = preg_match($reg3, "", $contract);
print "<a href=data.php?tab=" . $UNTRUSTED['tab'] . "&typeofview=levelvisits&{$leveltop}=" . $UNTRUSTED[$leveltop] . "&show=" . $UNTRUSTED['show'] . "&expand={$contract}" . $parentstring . "&whichdepartment=" . $UNTRUSTED['whichdepartment'] . "><img src=images/minus.gif border=0></a>";
}
print "</td><td NOWRAP><img src=images/blank.gif width={$spacer} height=10 border=0><a href=" . str_replace(" ", "+", $row['pageurl']) . " target=_blank>" . substr($displaytxt, 0, 100) . "</a> <font color=#999999>(#" . $row['levelvisits'] . ")</font></td><td>" . $row['levelvisits'] . " </td><td>" . $row['directvisits'] . " </td><td NOWRAP> <a href=graph.php?item=" . $row['recno'] . "&type=" . $typeof . "&typeof=levelvisits&whichdepartment=" . intval($whichdepartment) . " target=_blank>" . $lang['graph'] . "</a></td></tr>\n\n";
if (in_array($row['recno'], $expand_array)) {
$spacer2 = $spacer + 10;
?>
<tr><td> </td><td colspan=4><table width=100%><?php
showchildrenof($row['recno'], $spacer2, $whatYm, $expand_array, $tablename, $typeof, $nextparentsstring, $row['pageurl'], $whichdepartment);
print "<tr bgcolor=#000000><td colspan=5><img scr=images/blank.gif width=1 height=1></td></tr>";
print "<tr ><td colspan=5><img scr=images/blank.gif width=1 height=10></td></tr>";
?>
</table></td></tr><?php
}
if ($bgcolor == $color_alt2) {
$bgcolor = $color_alt1;
} else {
$bgcolor = $color_alt2;
}
}
}
}
