$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';
function search($query, $min, $orderby, $show)
{
global $prefix, $db, $admin, $bgcolor2, $module_name;
include "modules/{$module_name}/l_config.php";
include "header.php";
if (!isset($min)) {
$min = 0;
}
if (!isset($max)) {
$max = $min + $linksresults;
}
if (isset($orderby)) {
$orderby = convertorderbyin($orderby);
} else {
$orderby = "title ASC";
}
if ($show != "") {
$linksresults = $show;
} else {
$show = $linksresults;
}
$query = check_html($query, nohtml);
$query = addslashes($query);
$result = $db->sql_query("SELECT lid, cid, sid, title, url, description, date, hits, linkratingsummary, totalvotes, totalcomments from " . $prefix . "_links_links where title LIKE '%{$query}%' OR description LIKE '%{$query}%' ORDER BY {$orderby} LIMIT {$min},{$linksresults}");
$fullcountresult = $db->sql_query("SELECT lid, title, description, date, hits, linkratingsummary, totalvotes, totalcomments from " . $prefix . "_links_links where title LIKE '%{$query}%' OR description LIKE '%{$query}%'");
$totalselectedlinks = $db->sql_numrows($fullcountresult);
$nrows = $db->sql_numrows($result);
$x = 0;
$the_query = stripslashes($query);
$the_query = str_replace("\\'", "'", $the_query);
menu(1);
echo "<br>";
OpenTable();
if ($query != "") {
if ($nrows > 0) {
echo "<font class=\"option\">" . _SEARCHRESULTS4 . ": <b>{$the_query}</b></font><br><br>" . "<table width=\"100%\" bgcolor=\"{$bgcolor2}\"><tr><td><font class=\"option\"><b>" . _USUBCATEGORIES . "</b></font></td></tr></table>";
$result2 = $db->sql_query("SELECT cid, title from " . $prefix . "_links_categories where title LIKE '%{$query}%' ORDER BY title DESC");
while ($row2 = $db->sql_fetchrow($result2)) {
$cid = intval($row2['cid']);
$stitle = stripslashes(check_html($row2['title'], "nohtml"));
$res = $db->sql_query("SELECT * from " . $prefix . "_links_links where cid='{$cid}'");
$numrows = $db->sql_numrows($res);
$row3 = $db->sql_fetchrow($db->sql_query("SELECT cid,title,parentid from " . $prefix . "_links_categories where cid='{$cid}'"));
$cid3 = intval($row3['cid']);
$title3 = stripslashes(check_html($row3['title'], "nohtml"));
$parentid3 = intval($row3['parentid']);
if ($parentid3 > 0) {
$title3 = getparent($parentid3, $title3);
}
$title3 = ereg_replace($query, "<b>{$query}</b>", $title3);
echo "<strong><big>·</big></strong> <a href=\"modules.php?name={$module_name}&l_op=viewlink&cid={$cid}\">{$title3}</a> ({$numrows})<br>";
}
echo "<br><table width=\"100%\" bgcolor=\"{$bgcolor2}\"><tr><td><font class=\"option\"><b>" . _LINKS . "</b></font></td></tr></table>";
$orderbyTrans = convertorderbytrans($orderby);
echo "<br><font class=\"content\">" . _SORTLINKSBY . ": " . "" . _TITLE . " (<a href=\"modules.php?name={$module_name}&l_op=search&query={$the_query}&orderby=titleA\">A</a>\\<a href=\"modules.php?name={$module_name}&l_op=search&query={$the_query}&orderby=titleD\">D</a>)" . "" . _DATE . " (<a href=\"modules.php?name={$module_name}&l_op=search&query={$the_query}&orderby=dateA\">A</a>\\<a href=\"modules.php?name={$module_name}&l_op=search&query={$the_query}&orderby=dateD\">D</a>)" . "" . _RATING . " (<a href=\"modules.php?name={$module_name}&l_op=search&query={$the_query}&orderby=ratingA\">A</a>\\<a href=\"modules.php?name={$module_name}&l_op=search&query={$the_query}&orderby=ratingD\">D</a>)" . "" . _POPULARITY . " (<a href=\"modules.php?name={$module_name}&l_op=search&query={$the_query}&orderby=hitsA\">A</a>\\<a href=\"modules.php?name={$module_name}&l_op=search&query={$the_query}&orderby=hitsD\">D</a>)" . "<br>" . _SITESSORTED . ": {$orderbyTrans}<br><br>";
while ($row = $db->sql_fetchrow($result)) {
$lid = intval($row['lid']);
$cid = intval($row['cid']);
$sid = intval($row['sid']);
$title = stripslashes(check_html($row['title'], "nohtml"));
$url = stripslashes($row['url']);
$description = stripslashes($row['description']);
$time = $row['date'];
$hits = intval($row['hits']);
$linkratingsummary = $row['linkratingsummary'];
$totalvotes = intval($row['totalvotes']);
$totalcomments = $row['totalcomments'];
$linkratingsummary = number_format($linkratingsummary, $mainvotedecimal);
$transfertitle = str_replace(" ", "_", $title);
$title = ereg_replace($query, "<b>{$query}</b>", $title);
echo "<a href=\"modules.php?name={$module_name}&l_op=visit&lid={$lid}\" target=\"new\">{$title}</a>";
newlinkgraphic($datetime, $time);
popgraphic($hits);
echo "<br>";
$description = ereg_replace($query, "<b>{$query}</b>", $description);
echo "" . _DESCRIPTION . ": {$description}<br>";
setlocale(LC_TIME, $locale);
ereg("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $time, $datetime);
$datetime = strftime("" . _LINKSDATESTRING . "", mktime($datetime[4], $datetime[5], $datetime[6], $datetime[2], $datetime[3], $datetime[1]));
$datetime = ucfirst($datetime);
echo "" . _ADDEDON . ": {$datetime} " . _HITS . ": {$hits}";
/* voting & comments stats */
if ($totalvotes == 1) {
$votestring = _VOTE;
} else {
$votestring = _VOTES;
}
if ($linkratingsummary != "0" || $linkratingsummary != "0.0") {
echo " " . _RATING . ": {$linkratingsummary} ({$totalvotes} {$votestring})";
}
echo "<br><a href=\"modules.php?name={$module_name}&l_op=ratelink&lid={$lid}&ttitle={$transfertitle}\">" . _RATESITE . "</a>";
if ($totalvotes != 0) {
echo " | <a href=\"modules.php?name={$module_name}&l_op=viewlinkdetails&lid={$lid}&ttitle={$transfertitle}\">" . _DETAILS . "</a>";
}
if ($totalcomments != 0) {
echo " | <a href=\"modules.php?name={$module_name}&l_op=viewlinkcomments&lid={$lid}&ttitle={$transfertitle}>" . _SCOMMENTS . " ({$totalcomments})</a>";
}
detecteditorial($lid, $transfertitle);
echo "<br>";
$row4 = $db->sql_fetchrow($db->sql_query("SELECT cid,title,parentid from " . $prefix . "_links_categories where cid='{$cid}'"));
$cid3 = intval($row4['cid']);
$title3 = stripslashes(check_html($row4['title'], "nohtml"));
$parentid3 = intval($row4['parentid']);
if ($parentid3 > 0) {
$title3 = getparent($parentid3, $title3);
}
echo "" . _CATEGORY . ": {$title3}<br><br>";
$x++;
}
echo "</font>";
$orderby = convertorderbyout($orderby);
} else {
echo "<br><br><center><font class=\"option\"><b>" . _NOMATCHES . "</b></font><br><br>" . _GOBACK . "<br></center>";
}
/* Calculates how many pages exist. Which page one should be on, etc... */
$linkpagesint = $totalselectedlinks / $linksresults;
$linkpageremainder = $totalselectedlinks % $linksresults;
if ($linkpageremainder != 0) {
$linkpages = ceil($linkpagesint);
if ($totalselectedlinks < $linksresults) {
$linkpageremainder = 0;
}
} else {
$linkpages = $linkpagesint;
}
/* Page Numbering */
if ($linkpages != 1 && $linkpages != 0) {
echo "<br><br>" . "" . _SELECTPAGE . ": ";
$prev = $min - $linksresults;
if ($prev >= 0) {
echo " <b>[ <a href=\"modules.php?name={$module_name}&l_op=search&query={$the_query}&min={$prev}&orderby={$orderby}&show={$show}\">" . " << " . _PREVIOUS . "</a> ]</b> ";
}
$counter = 1;
$currentpage = $max / $linksresults;
while ($counter <= $linkpages) {
$cpage = $counter;
$mintemp = $perpage * $counter - $linksresults;
if ($counter == $currentpage) {
echo "<b>{$counter}</b> ";
} else {
echo "<a href=\"modules.php?name={$module_name}&l_op=search&query={$the_query}&min={$mintemp}&orderby={$orderby}&show={$show}\">{$counter}</a> ";
}
$counter++;
}
$next = $min + $linksresults;
if ($x >= $perpage) {
echo " <b>[ <a href=\"modules.php?name={$module_name}&l_op=search&query={$the_query}&min={$max}&orderby={$orderby}&show={$show}\">" . " " . _NEXT . " >></a> ]</b>";
}
}
echo "<br><br><center><font class=\"content\">" . "" . _TRY2SEARCH . " \"{$the_query}\" " . _INOTHERSENGINES . "<br>" . "<a target=\"_blank\" href=\"http://www.altavista.com/cgi-bin/query?pg=q&sc=on&hl=on&act=2006&par=0&q={$the_query}&kl=XX&stype=stext\">Alta Vista</a> - " . "<a target=\"_blank\" href=\"http://www.hotbot.com/?MT={$the_query}&DU=days&SW=web\">HotBot</a> - " . "<a target=\"_blank\" href=\"http://www.infoseek.com/Titles?qt={$the_query}\">Infoseek</a> - " . "<a target=\"_blank\" href=\"http://www.dejanews.com/dnquery.xp?QRY={$the_query}\">Deja News</a> - " . "<a target=\"_blank\" href=\"http://www.lycos.com/cgi-bin/pursuit?query={$the_query}&maxhits=20\">Lycos</a> - " . "<a target=\"_blank\" href=\"http://search.yahoo.com/bin/search?p={$the_query}\">Yahoo</a>" . "<br>" . "<a target=\"_blank\" href=\"http://es.linuxstart.com/cgi-bin/sqlsearch.cgi?pos=1&query={$the_query}&language=&advanced=&urlonly=&withid=\">LinuxStart</a> - " . "<a target=\"_blank\" href=\"http://search.1stlinuxsearch.com/compass?scope={$the_query}&ui=sr\">1stLinuxSearch</a> - " . "<a target=\"_blank\" href=\"http://www.google.com/search?q={$the_query}\">Google</a> - " . "<a target=\"_blank\" href=\"http://www.linuxlinks.com/cgi-bin/search.cgi?query={$the_query}&engine=Links\">LinuxLinks</a> - " . "<a target=\"_blank\" href=\"http://www.freshmeat.net/search/?q={$the_query}&section=projects\">Freshmeat</a> - " . "<a target=\"_blank\" href=\"http://www.justlinux.com/bin/search.pl?key={$the_query}\">JustLinux</a>" . "</font>";
} else {
echo "<center><font class=\"option\"><b>" . _NOMATCHES . "</b></font></center><br><br>";
}
CloseTable();
include "footer.php";
}
function search($query, $min, $orderby, $show)
{
global $linksprefix, $db, $bgcolor2, $module_name, $weblinks_config;
require_once 'header.php';
$perpage = $weblinks_config['perpage'];
$linksresults = $weblinks_config['linksresults'];
if (!isset($min)) {
$min = 0;
}
if (!isset($max)) {
$max = $min + $linksresults;
}
$orderby = isset($_GET['orderby']) ? convertorderbyin($_GET['orderby']) : 'title ASC';
if ($show != '') {
$linksresults = $show;
} else {
$show = $linksresults;
}
$the_query = htmlprepare($query);
$query = Fix_Quotes($query, true);
$result = $db->sql_query("SELECT lid, cid, title, url, description, date, hits, linkratingsummary, totalvotes, totalcomments FROM " . $linksprefix . "_links WHERE title LIKE '%{$query}%' OR description LIKE '%{$query}%' ORDER BY {$orderby} LIMIT {$min},{$linksresults}");
$fullcountresult = $db->sql_query("SELECT COUNT(*) FROM " . $linksprefix . "_links WHERE title LIKE '%{$query}%' OR description LIKE '%{$query}%'");
list($totalselectedlinks) = $db->sql_fetchrow($fullcountresult);
$nrows = $db->sql_numrows($result);
$x = 0;
menu(1);
echo '<br />';
OpenTable();
if ($query != '') {
if ($nrows > 0) {
echo '<span class="option">' . _SEARCHRESULTS4 . ': <b>' . $the_query . '</b></span><br /><br />' . '<table width="100%" style="background:' . $bgcolor2 . ';"><tr><td><span class="option"><b>' . _USUBCATEGORIES . '</b></span></td></tr></table>';
$result2 = $db->sql_query("SELECT cid, title FROM " . $linksprefix . "_categories WHERE title LIKE '%{$query}%' ORDER BY title DESC");
while (list($cid, $stitle) = $db->sql_fetchrow($result2)) {
$res = $db->sql_query("SELECT * FROM " . $linksprefix . "_links WHERE cid={$cid}");
$numrows = $db->sql_numrows($res);
$result3 = $db->sql_query("SELECT cid,title,parentid FROM " . $linksprefix . "_categories WHERE cid={$cid}");
list($cid3, $title3, $parentid3) = $db->sql_fetchrow($result3);
if ($parentid3 > 0) {
$title3 = getparent($parentid3, $title3);
}
$title3 = ereg_replace($query, "<b>{$query}</b>", $title3);
}
echo '<br /><table width="100%" style="background:' . $bgcolor2 . ';"><tr><td class="option"><b>' . _LINKS . '</b></td></tr></table>';
$orderbyTrans = isset($_GET['orderby']) ? convertorderbytrans($_GET['orderby']) : _TITLEAZ;
echo '<br /><span class="content">' . _SORTLINKSBY . ': ' . _TITLE . ' (<a href="' . URL::index("&l_op=search&query={$the_query}&orderby=titlea") . '">A</a>\\<a href="' . URL::index("&l_op=search&query={$the_query}&orderby=titled") . '">D</a>)' . _DATE . ' (<a href="' . URL::index("&l_op=search&query={$the_query}&orderby=datea") . '">A</a>\\<a href="' . URL::index("&l_op=search&query={$the_query}&orderby=dated") . '">D</a>)' . _RATING . ' (<a href="' . URL::index("&l_op=search&query={$the_query}&orderby=ratinga") . '">A</a>\\<a href="' . URL::index("&l_op=search&query={$the_query}&orderby=ratingd") . '">D</a>)' . _POPULARITY . ' (<a href="' . URL::index("&l_op=search&query={$the_query}&orderby=hitsa") . '">A</a>\\<a href="' . URL::index("&l_op=search&query={$the_query}&orderby=hitsd") . '">D</a>)' . '<br />' . _SITESSORTED . ": {$orderbyTrans}<br /><br />";
while (list($lid, $cid, $title, $url, $description, $time, $hits, $linkratingsummary, $totalvotes, $totalcomments) = $db->sql_fetchrow($result)) {
$linkratingsummary = number_format($linkratingsummary, $weblinks_config['mainvotedecimal']);
$transfertitle = str_replace(' ', '_', $title);
$title = ereg_replace($query, "<b>{$query}</b>", $title);
echo '<a href="' . URL::index('&l_op=visit&lid=' . $lid) . '" target="_blank">' . $title . '</a>';
$datetime = formatDateTime($time . ' 00:00:00', _DATESTRING3);
newlinkgraphic($datetime);
popgraphic($hits);
echo '<br />';
$description = ereg_replace($query, "<b>{$query}</b>", $description);
echo _DESCRIPTION . ": {$description}<br />";
echo _ADDEDON . ": {$datetime} " . _HITS . ": {$hits}";
/* voting & comments stats */
$votestring = $totalvotes == 1 ? _VOTE : _VOTES;
if ($linkratingsummary != '0' || $linkratingsummary != '0.0') {
echo ' ' . _RATING . ": {$linkratingsummary} ({$totalvotes} {$votestring})";
}
echo '<br /><a href="' . URL::index('&l_op=ratelink&lid=' . $lid . '&ttitle=' . $transfertitle) . '">' . _RATESITE . '</a>';
if ($totalvotes != 0) {
echo ' | <a href="' . URL::index("&l_op=viewlinkdetails&lid={$lid}&ttitle={$transfertitle}") . '">' . _DETAILS . '</a>';
}
if ($totalcomments != 0) {
echo ' | <a href="' . URL::index('&l_op=viewlinkcomments&lid=' . $lid . '&ttitle=' . $transfertitle) . '">' . _SCOMMENTS . ' (' . $totalcomments . ')</a>';
}
detecteditorial($lid, $transfertitle);
echo '<br />';
$result3 = $db->sql_query("SELECT cid,title,parentid FROM " . $linksprefix . "_categories WHERE cid={$cid}");
list($cid3, $title3, $parentid3) = $db->sql_fetchrow($result3);
if ($parentid3 > 0) {
$title3 = getparent($parentid3, $title3);
}
echo _CATEGORY . ": {$title3}<br /><br />";
$x++;
}
echo '</span>';
$orderby = isset($_GET['orderby']) ? convertorderbyout($_GET['orderby']) : 'title ASC';
} else {
echo '<br /><br /><div style="text-align:center;" class="option"><b>' . _NOMATCHES . '</b><br /><br />' . _GOBACK . '<br /></div>';
}
/* Calculates how many pages exist. Which page one should be on, etc... */
$linkpagesint = $totalselectedlinks / $linksresults;
$linkpageremainder = $totalselectedlinks % $linksresults;
if ($linkpageremainder != 0) {
$linkpages = ceil($linkpagesint);
if ($totalselectedlinks < $linksresults) {
$linkpageremainder = 0;
}
} else {
$linkpages = $linkpagesint;
}
/* Page Numbering */
if ($linkpages != 1 && $linkpages != 0) {
echo '<br /><br />' . _SELECTPAGE . ': ';
$prev = $min - $linksresults;
if ($prev >= 0) {
echo ' <b>[ <a href="' . URL::index("&l_op=search&query={$the_query}&min={$prev}&orderby={$orderby}&show={$show}") . '">' . ' « ' . _PREVIOUSPAGE . '</a> ]</b> ';
}
$counter = 1;
$currentpage = $max / $linksresults;
while ($counter <= $linkpages) {
$cpage = $counter;
$mintemp = $perpage * $counter - $linksresults;
if ($counter == $currentpage) {
echo "<b>{$counter}</b> ";
} else {
echo '<a href="' . URL::index("&l_op=search&query={$the_query}&min={$mintemp}&orderby={$orderby}&show={$show}") . '">' . $counter . '</a> ';
}
$counter++;
}
$next = $min + $linksresults;
if ($x >= $perpage) {
echo ' <b>[ <a href="' . URL::index("&l_op=search&query={$the_query}&min={$max}&orderby={$orderby}&show={$show}") . '"> ' . _NEXTPAGE . ' »</a> ]</b>';
}
}
} else {
echo '<div style="text-align:center;" class="option"><b>' . _NOMATCHES . '</b></div><br /><br />';
}
echo '<br /><br /><p style="text-align:left;">' . _TRY2SEARCH . ' "' . $the_query . '" ' . _INOTHERSENGINES . '<br />
<ul><li><a href="http://groups.google.com/groups?q=' . $the_query . '" target="_blank">Google Groups</a></li>
<li><a href="http://images.google.com/images?q=' . $the_query . '" target="_blank">Google Images</a></li>
<li><a href="http://news.google.com/news?q=' . $the_query . '" target="_blank">Google News</a></li>
<li><a href="http://froogle.google.com/froogle?q=' . $the_query . '" target="_blank">Froogle</a></li>
<li><a target="_blank" href="http://www.altavista.com/cgi-bin/query?pg=q&sc=on&hl=on&act=2006&par=0&q=' . $the_query . '&kl=XX&stype=stext">Alta Vista</a></li>
<li><a target="_blank" href="http://www.hotbot.com/?MT=' . $the_query . '&DU=days&SW=web">HotBot</a></li>
<li><a target="_blank" href="http://www.infoseek.com/Titles?qt=' . $the_query . '">Infoseek</a></li>
<li><a target="_blank" href="http://www.dejanews.com/dnquery.xp?QRY=' . $the_query . '">Deja News</a></li>
<li><a target="_blank" href="http://www.lycos.com/cgi-bin/pursuit?query=' . $the_query . '&maxhits=20">Lycos</a></li>
<li><a target="_blank" href="http://search.yahoo.com/bin/search?p=' . $the_query . '">Yahoo</a></li>
</ul>
</p>';
CloseTable();
}
}
if ($affich) {
$title = stripslashes($title);
$description = stripslashes($description);
settype($datetime, 'string');
echo '
<div class="card">
<div class="card-block ibid_descr">';
if ($url == '') {
echo '
<h4 class="text-muted"><i class="fa fa-external-link"></i> ' . aff_langue($title);
} else {
echo '
<h4><a href="modules.php?ModStart=' . $ModStart . '&ModPath=' . $ModPath . '&op=visit&lid=' . $lid . '" target="_blank" ><i class="fa fa-external-link"></i> ' . aff_langue($title) . '</a>';
}
echo ' ' . newlinkgraphic($datetime, $time) . '</h4>';
if (!empty($xcid)) {
$result3 = sql_query("SELECT title FROM " . $links_DB . "links_categories WHERE cid='{$xcid}'");
$result4 = sql_query("SELECT title FROM " . $links_DB . "links_subcategories WHERE sid='{$xsid}'");
list($ctitle) = sql_fetch_row($result3);
list($stitle) = sql_fetch_row($result4);
if ($stitle == '') {
$slash = '';
} else {
$slash = '/';
}
echo translate("Category: ") . "<strong>" . aff_langue($ctitle) . "</strong> {$slash} <b>" . aff_langue($stitle) . "</b>";
}
global $links_topic;
if ($links_topic and $topicid_card != 0) {
list($topicLX) = sql_fetch_row(sql_query("SELECT topictext FROM " . $NPDS_Prefix . "topics WHERE topicid='{$topicid_card}'"));
} else {
$affich = true;
}
if ($affich) {
$title = stripslashes($title);
$description = stripslashes($description);
settype($datetime, 'string');
echo '
<tr>
<td>';
if ($url == '') {
echo '<h4 class="text-muted"><i class="fa fa-external-link"></i> ' . aff_langue($title);
} else {
echo '<h4><a href="modules.php?ModStart=' . $ModStart . '&ModPath=' . $ModPath . '&op=visit&lid=' . $lid . '" target="_blank" ><i class="fa fa-external-link"></i> ' . aff_langue($title) . '</a>';
}
echo newlinkgraphic($datetime, $time) . '</h4>';
if (!empty($xcid)) {
$result3 = sql_query("SELECT title FROM " . $links_DB . "links_categories WHERE cid='{$xcid}'");
$result4 = sql_query("SELECT title FROM " . $links_DB . "links_subcategories WHERE sid='{$xsid}'");
list($ctitle) = sql_fetch_row($result3);
list($stitle) = sql_fetch_row($result4);
if ($stitle == '') {
$slash = '';
} else {
$slash = '/';
}
echo translate("Category: ") . "<b>" . aff_langue($ctitle) . "</b> {$slash} <b>" . aff_langue($stitle) . "</b>";
}
echo '<div class="ibid_descr">' . aff_langue($description) . '</div>';
global $links_topic;
if ($links_topic and $topicid_card != 0) {
