<{$mylinks}>



------------
<{foreach item=links from=$links}>
<{$links.title}>
<{/foreach}>

<{if count($waitinglinks) gt 0}>

<{$linkswaiting}>

------------
<{foreach item=links from=$waitinglinks}>
<{$links.title}>
<{/foreach}>

<{/if}>

<{if count($expiredlinks) gt 0}>
<{$linksexpired}>

------------
<{foreach item=links from=$expiredlinks}>
<{$links.title}>
<{/foreach}>

<{/if}>
<{if count($expiredlinks) == 0}>
<{$noexpiredlinks}>
<{/if}>

function b_cpanel_menu() {
global $xoopsDB,$xoopsUser,$xoopsTpl,$xoopsConfig;
$uid = $xoopsUser->uid();

//load links
$result=$xoopsDB->query("SELECT lid, title FROM ".$xoopsDB->prefix("addresses_links")." WHERE submitter = $uid and status = 1 ORDER BY title") or exit("Error");
list($countactive)=$xoopsDB->fetchRow($result);
$q=0;
$links=array();

while($myrow2 = $xoopsDB->fetchArray($result)) {
$links[$q]['id'] = $myrow2['lid'];
$links[$q]['title'] = $myrow2['title'];
$q++;
}
$xoopsTpl->assign('links', $links);
$xoopsTpl->assign('uid', $uid);

$xoopsTpl->assign('countactive', $countactive);
$xoopsTpl->assign('nowaitinglinks', _MD_NOLINKSWAITING);
$xoopsTpl->assign('noexpiredlinks', "_MD_NOLINKSEXPIRED");
$xoopsTpl->assign('linksexpired', _MD_LINKSEXPIRED);
$xoopsTpl->assign('mylinks', _MD_MYLINKS);
$xoopsTpl->assign('linkswaiting', _MD_LINKSWAITING);
expired_links();
waiting_links();

return $links;
}

function expired_links() {
global $xoopsDB,$xoopsUser,$xoopsTpl;
$uid = $xoopsUser->uid();

$result2=$xoopsDB->query("SELECT lid, title FROM ".$xoopsDB->prefix("addresses_links")." WHERE submitter = $uid and status = 2 ORDER BY title") or exit("Error");
$q=0;
$expiredlinks=array();

while($myrow2 = $xoopsDB->fetchArray($result2)) {
$expiredlinks[$q]['id'] = $myrow2['lid'];
$expiredlinks[$q]['title'] = $myrow2['title'];
$q++;
}
$xoopsTpl->assign('expiredlinks', $expiredlinks);

return $expiredlinks;
}
function waiting_links() {
global $xoopsDB,$xoopsUser,$xoopsTpl,$xoopsConfig;
$uid = $xoopsUser->uid();

//load links
$result3=$xoopsDB->query("SELECT lid, title FROM ".$xoopsDB->prefix("addresses_links")." WHERE submitter = $uid and status = 0 ORDER BY title") or exit("Error");
$qq=0;
$waitinglinks=array();

while($myrow3 = $xoopsDB->fetchArray($result3)) {
$waitinglinks[$qq]['id'] = $myrow3['lid'];
$waitinglinks[$qq]['title'] = $myrow3['title'];
$qq++;
}
$xoopsTpl->assign('waitinglinks', $waitinglinks);

return $waitinglinks;
}
?>