function track_edit($start, $page)
{
global $xoopsDB, $xoopsModuleConfig;
global $tags, $tblstyle;
$tid = $_GET['tid'];
$result = $xoopsDB->query("SELECT track_uri, disable FROM " . TBL . " WHERE track_id={$tid}");
list($uri, $disable) = $xoopsDB->fetchRow($result);
echo "<h4 style='text-align:left;'>" . _AM_REFPAGE_PAGE . "</h4>";
$result = $xoopsDB->query("SELECT count(ref_id) FROM " . TBR . " WHERE track_from={$tid}");
list($nrec) = $xoopsDB->fetchRow($result);
$result = $xoopsDB->query("SELECT * FROM " . TBR . " WHERE track_from={$tid} ORDER BY linked DESC, ref_url", $xoopsModuleConfig['list_max'], $start);
echo "<p>" . _AM_TRACK_TARGET . ": <a href='index.php'>" . _AM_TRACK_LIST . "</a> >> <a href='{$uri}'>" . uri_to_name($uri) . "</a>" . ($disable ? " - " . _AM_DISABLE_MODE : "") . "</p>";
$pctrl = make_page_index(_AM_PAGE, $nrec, $page, " <a href='index.php?op=edit&tid={$tid}&page=%d'>(%d)</a>");
echo $pctrl;
if ($nrec) {
echo "<form action='index.php' method='post'>";
echo "<table {$tblstyle}>\n";
echo "<tr class='bg1'><th>" . _AM_REF_URL . "</th></tr>\n";
$nc = 1;
while ($data = $xoopsDB->fetchArray($result)) {
$bg = $tags[$nc++ % 2];
$rid = $data['ref_id'];
$mkl = $data['linked'] ? "checked" : "";
$start++;
$fbox = $data['mtime'] > 10 ? " " . _AM_FLUSH_INFO . ":<input type='checkbox' name='flush[{$rid}]' />" : "";
echo "<tr class='{$bg}'><td>" . "<input type='checkbox' name='link[{$rid}]' {$mkl} />" . "<input type='hidden' name='refid[{$rid}]' value='ok' />" . "{$start}. " . ($data['checked'] ? "" : " (" . _AM_UNCHECK . ")") . make_track_item($data, $fbox) . "</td>" . "</tr>\n";
}
echo "</table>\n";
echo "<input type='hidden' name='op' value='edit_update' />" . "<input type='hidden' name='tid' value='{$tid}' />" . "<input type='submit' value='" . _AM_SUBMIT_LINK . "' />" . "</form>\n";
}
echo $pctrl;
}
$nrec = $xoopsDB->GetRowsNum($result);
}
$start = $page > 1 ? ($page - 1) * $xoopsModuleConfig['list_max'] : 0;
$breadcrumbs[] = array('name' => uri_to_name($uri));
$xoopsTpl->assign('xoops_breadcrumbs', $breadcrumbs);
if ($detail) {
// summary by "title"
$sql = "SELECT * FROM " . TBR . " WHERE {$cond} ORDER BY {$order}";
} else {
$sql = "SELECT SUM(nref) nref,COUNT(ref_id) n, title, " . " MAX(mtime) mtime, MIN(since) since," . " MIN(ref_url) ref_url, MAX(context) context" . " FROM " . TBR . " WHERE {$cond}" . " GROUP BY title ORDER BY {$order}";
}
$result = $xoopsDB->query($sql, $xoopsModuleConfig['list_max'], $start);
if ($nrec) {
$popt = $page > 1 ? "&page={$page}" : "";
$ordstr = sprintf($order == "nref DESC" ? "<b>%s</b>" : "<a href='index.php?id={$track_id}{$popt}'>%s</a>", _TB_ORDER_NREF) . " | " . sprintf($order == "mtime DESC" ? "<b>%s</b>" : "<a href='index.php?id={$track_id}&order=time{$popt}'>%s</a>", _TB_ORDER_TIME);
$xoopsTpl->assign('page_control', make_page_index("{$ordstr} - " . _TB_PAGE, $nrec, $page, " <a href='index.php?id={$track_id}{$opt}&page=%d'>(%d)</a>"));
$referers = array();
while ($data = $xoopsDB->fetchArray($result)) {
$data['seq'] = ++$start;
$data['cdate'] = formatTimestamp($data['since'], "m");
$data['mdate'] = formatTimestamp($data['mtime'], "m");
if (!$detail && $data['n'] > 1) {
// url list
$rsub = $xoopsDB->query("SELECT nref, ref_url, mtime FROM " . TBR . " WHERE {$cond} AND title=" . $xoopsDB->quoteString($data['title']) . " ORDER BY {$order}", 20);
$refs = array();
$refn = array();
while (list($nref, $url) = $xoopsDB->fetchRow($rsub)) {
$refs[] = $url;
$refn[] = $nref;
}
$data["refs"] = $refs;
