$xoopsTpl->assign('lang_lastupdate', _MD_LASTUPDATEC);
$xoopsTpl->assign('lang_hits', _MD_HITSC);
$xoopsTpl->assign('lang_rating', _MD_RATINGC);
$xoopsTpl->assign('lang_ratethissite', _MD_RATETHISSITE);
$xoopsTpl->assign('lang_reportbroken', _MD_REPORTBROKEN);
$xoopsTpl->assign('lang_tellafriend', _MD_TELLAFRIEND);
$xoopsTpl->assign('lang_modify', _MD_MODIFY);
$xoopsTpl->assign('lang_latestlistings', _MD_LATESTLIST);
$xoopsTpl->assign('lang_category', _MD_CATEGORYC);
$xoopsTpl->assign('lang_visit', _MD_VISIT);
$xoopsTpl->assign('lang_comments', _COMMENTS);
$result = $xoopsDB->query("SELECT l.lid, l.cid, l.title, l.url, l.logourl, l.status, l.date, l.hits, l.rating, l.votes, l.comments, t.description FROM " . $xoopsDB->prefix("mylinks_links") . " l, " . $xoopsDB->prefix("mylinks_text") . " t where l.status>0 and l.lid=t.lid ORDER BY date DESC", $xoopsModuleConfig['newlinks'], 0);
while (list($lid, $cid, $ltitle, $url, $logourl, $status, $time, $hits, $rating, $votes, $comments, $description) = $xoopsDB->fetchRow($result)) {
if ($isadmin) {
$adminlink = '<a href="' . XOOPS_URL . '/modules/mylinks/admin/?op=modLink&lid=' . $lid . '"><img src="' . XOOPS_URL . '/modules/mylinks/images/editicon.gif" border="0" alt="' . _MD_EDITTHISLINK . '" /></a>';
} else {
$adminlink = '';
}
if ($votes == 1) {
$votestring = _MD_ONEVOTE;
} else {
$votestring = sprintf(_MD_NUMVOTES, $votes);
}
$path = $mytree->getPathFromId($cid, "title");
$path = substr($path, 1);
$path = str_replace("/", " <img src='" . XOOPS_URL . "/modules/mylinks/images/arrow.gif' board='0' alt=''> ", $path);
$new = newlinkgraphic($time, $status);
$pop = popgraphic($hits);
$xoopsTpl->append('links', array('id' => $lid, 'cid' => $cid, 'rating' => number_format($rating, 2), 'title' => $myts->makeTboxData4Show($ltitle) . $new . $pop, 'category' => $path, 'logourl' => $myts->makeTboxData4Show($logourl), 'updated' => formatTimestamp($time, "m"), 'description' => $myts->makeTareaData4Show($description, 0), 'adminlink' => $adminlink, 'hits' => $hits, 'votes' => $votestring, 'comments' => $comments, 'mail_subject' => rawurlencode(sprintf(_MD_INTRESTLINK, $xoopsConfig['sitename'])), 'mail_body' => rawurlencode(sprintf(_MD_INTLINKFOUND, $xoopsConfig['sitename']) . ': ' . XOOPS_URL . '/modules/mylinks/singlelink.php?cid=' . $cid . '&lid=' . $lid)));
}
include XOOPS_ROOT_PATH . '/footer.php';
$xoopsTpl->assign('lang_category', _ALBM_CATEGORY);
$xoopsTpl->assign('lang_hits', _ALBM_HITS);
$xoopsTpl->assign('lang_rating', _ALBM_RATING);
$xoopsTpl->assign('lang_vote', _ALBM_VOTE);
$crs = $xoopsDB->query("SELECT cid,title FROM {$table_cat} WHERE pid=0 ORDER BY title");
$rankings = array();
$i = 0;
while (list($cid, $cat_title) = $xoopsDB->fetchRow($crs)) {
$rankings[$i] = array('title' => sprintf(_ALBM_TOP10, $myts->htmlSpecialChars($cat_title)), 'count' => $i);
// get all child cat ids for a given cat id
$children = $cattree->getAllChildId($cid);
$whr_cid = 'cid IN (';
foreach ($children as $child) {
$whr_cid .= "{$child},";
}
$whr_cid .= "{$cid})";
$sql = "SELECT lid, cid, title, submitter, hits, rating, votes FROM {$table_photos} WHERE status>0 AND ({$whr_cid}) ORDER BY {$odr}";
$prs = $xoopsDB->query($sql, 10, 0);
$rank = 1;
while (list($lid, $cid, $title, $submitter, $hits, $rating, $votes) = $xoopsDB->fetchRow($prs)) {
$catpath = $cattree->getPathFromId($cid, "title");
$catpath = substr($catpath, 1);
$catpath = str_replace("/", " <span class='fg2'>»»</span> ", $catpath);
$title = $myts->makeTboxData4Show($title);
$rankings[$i]['photo'][] = array('lid' => $lid, 'cid' => $cid, 'rank' => $rank, 'title' => $title, 'submitter' => $submitter, 'submitter_name' => myalbum_get_name_from_uid($submitter), 'category' => $catpath, 'hits' => $hits, 'rating' => number_format($rating, 2), 'votes' => $votes);
$rank++;
}
$i++;
}
$xoopsTpl->assign_by_ref('rankings', $rankings);
include XOOPS_ROOT_PATH . "/footer.php";
$xoopsTpl->assign('lang_category', _MD_CATEGORY);
$xoopsTpl->assign('lang_hits', _MD_HITS);
$xoopsTpl->assign('lang_rating', _MD_RATING);
$xoopsTpl->assign('lang_vote', _MD_VOTE);
$arr = array();
$result = $xoopsDB->query("select cid, title from " . $xoopsDB->prefix("mylinks_cat") . " where pid=0");
$e = 0;
$rankings = array();
while (list($cid, $ctitle) = $xoopsDB->fetchRow($result)) {
$rankings[$e]['title'] = sprintf(_MD_TOP10, $myts->htmlSpecialChars($ctitle));
$query = "select lid, cid, title, hits, rating, votes from " . $xoopsDB->prefix("mylinks_links") . " where status>0 and (cid={$cid}";
// get all child cat ids for a given cat id
$arr = $mytree->getAllChildId($cid);
$size = count($arr);
for ($i = 0; $i < $size; $i++) {
$query .= " or cid=" . $arr[$i] . "";
}
$query .= ") order by " . $sortDB . " DESC";
$result2 = $xoopsDB->query($query, 10, 0);
$rank = 1;
while (list($lid, $lcid, $ltitle, $hits, $rating, $votes) = $xoopsDB->fetchRow($result2)) {
$catpath = $mytree->getPathFromId($lcid, "title");
$catpath = substr($catpath, 1);
$catpath = str_replace("/", " <span class='fg2'>»</span> ", $catpath);
$rankings[$e]['links'][] = array('id' => $lid, 'cid' => $cid, 'rank' => $rank, 'title' => $myts->htmlSpecialChars($ltitle), 'category' => $catpath, 'hits' => $hits, 'rating' => number_format($rating, 2), 'votes' => $votes);
$rank++;
}
$e++;
}
$xoopsTpl->assign('rankings', $rankings);
include XOOPS_ROOT_PATH . '/footer.php';
$query .= " or categoryid=".$arr[$i]."";
}
$query .= ") order by ".$sortDB." DESC";
// go back lines 20 -> 10
// display lines 10 -> 20
$result2 = $xoopsDB->query($query,10,0);
// $result2 = $xoopsDB->query($query,20,0);
$rank = 1;
while(list($darticleid, $dcategoryid, $dtitle, $counter, $rating, $votes, $dgroupid)=$xoopsDB->fetchRow($result2)){
if(checkAccess($dgroupid)) {
$catpath = $mytree->getPathFromId($dcategoryid, "title");
$catpath= substr($catpath, 1);
$catpath = str_replace("/"," <span class='fg2'>»»</span> ",$catpath);
$dtitle = $myts->makeTboxData4Show($dtitle);
$rankings[$e]['file'][] = array('id' => $darticleid, 'cid' => $dcategoryid, 'rank' => $rank, 'title' => $dtitle, 'category' => $catpath, 'hits' => $counter, 'rating' => number_format($rating, 2), 'votes' => $votes);
$rank++;
}
}
$e++;
}
}
$xoopsTpl->assign('rankings', $rankings);
include XOOPS_ROOT_PATH.'/footer.php';
include "footer.php";
