$whichdepartmentsql = " AND department=" . intval($UNTRUSTED['whichdepartment']) . " "; $query = "SELECT * FROM livehelp_leavemessage WHERE dateof>{$whatYm_b} AND dateof<{$whatYm_e} {$whichdepartmentsql} order by dateof DESC"; $refer_a = $mydatabase->query($query); $total_p = $refer_a->numrows(); $perpage = intval($UNTRUSTED['perpage']); $top = intval($UNTRUSTED['top']); $show = $UNTRUSTED['show']; $pageUrl = "data.php"; $varstring = "&tab=" . $UNTRUSTED['tab'] . "&show=trans&month=" . $UNTRUSTED['month'] . "&year=" . $UNTRUSTED['year']; if (empty($UNTRUSTED['perpage'])) { $UNTRUSTED['perpage'] = 25; } if (empty($UNTRUSTED['offset'])) { $UNTRUSTED['offset'] = 0; } print pagingLinks($pageUrl, $total_p, $varstring, $UNTRUSTED['offset'], $UNTRUSTED['perpage']); ?> <table width=600> <td bgcolor=#FFFFFF><b><?php echo $lang['date']; ?> </b></td> <?php // get list of fields for this department.. $q = "SELECT headertext,id FROM livehelp_questions WHERE module='leavemessage' AND department=" . intval($UNTRUSTED['whichdepartment']) . " order by ordering "; $qRes = $mydatabase->query($q); $fields = array(); while ($qRow = $qRes->fetchRow(DB_FETCHMODE_ORDERED)) { print "<td bgcolor=#FFFFFF><b>" . $qRow[0] . "</b></td>"; $fields[] = "field_" . $qRow[1]; }
$q = "SELECT SUM(visits) as numvisits FROM livehelp_paths_monthly WHERE dateof=" . intval($whatYm) . " AND visit_recno='" . intval($parent) . "'"; $q_count = "SELECT count(*) as totalrows FROM livehelp_paths_monthly WHERE dateof=" . intval($whatYm) . " AND visit_recno='" . intval($parent) . "'"; } $visits_b = $mydatabase->query($q); $tmp = $visits_b->fetchRow(DB_FETCHMODE_ASSOC); $visittotal = $tmp['numvisits']; if ($visittotal < 1) { $visittotal = 1; } $sth = $mydatabase->query($q_count); $row = $sth->fetchRow(DB_FETCHMODE_ASSOC); $num_rows = $row['totalrows']; $visits_a = $mydatabase->query($query); $pageUrl = "data.php"; $varstring = "typeofview=" . $UNTRUSTED['typeofview'] . "&show=visit&tab=" . $UNTRUSTED['tab'] . "&month=" . $UNTRUSTED['month'] . "&year=" . $UNTRUSTED['year']; print pagingLinks($pageUrl, $num_rows, $varstring, $UNTRUSTED['offset'], $UNTRUSTED['perpage']); print "<table width=600><tr bgcolor=\"#FFFFFF\"><td><b>Clicks to:</b></td><td> <b>%</b> </td><td><b>" . $lang['numclicks'] . "</b></td><td><b>" . $lang['graph'] . "</b></td></tr>"; $bgcolor = "F0F1E1"; while ($visits = $visits_a->fetchRow(DB_FETCHMODE_ASSOC)) { if ($bgcolor == $color_alt2) { $bgcolor = $color_alt1; } else { $bgcolor = $color_alt2; } print "<tr bgcolor=" . $bgcolor . "><td>" . lookupparent($visits['exit_recno']) . "</td><td> <b>" . sprintf("%.2f", $visits['visits'] / $visittotal * 100) . " %</b> </td><td>" . $visits['visits'] . "</td><td><a href=data.php?typeofview=" . $UNTRUSTED['typeofview'] . "&tab=" . $UNTRUSTED['tab'] . "&parent=" . $visits['exit_recno'] . "&prevpath={$parent}&month=" . $UNTRUSTED['month'] . "&year=" . $UNTRUSTED['year'] . ">View Path</a> </td></tr>"; } print "</table>"; ?> <table width=600><tr><td><?php echo $lang['txt216']; ?>
/** * 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; } } } }