<div style="background-color:#eeeeff;padding:2px">
<font size="1"><a href="<{$xoops_url}>/modules/addresses/cpanel/cpanel.php?status=1"><{$mylinks}></a></font>
<center>
<form name="activelinksform" id="activelinksform">
<select name="selectactivelink" onchange="location.href='/modules/addresses/cpanel/cpanel.php?status=1'">
<option value="null">------------</option>
<{foreach item=links from=$links}>
<option value="<{$links.id}>"><{$links.title}></option>
<{/foreach}>
</select>
</form>
</center>
</div>
<{if count($waitinglinks) gt 0}>
<div style="background-color:#FFAAEE;margin-top:3px;padding:2px">

<font size="1"><a href="<{$xoops_url}>/modules/addresses/cpanel/cpanel.php?status=0"><{$linkswaiting}></a></font>
<center>
<form name="submitedlinksform" id="submitedlinksform">
<select name="submitedlink" onchange="location.href='/modules/addresses/cpanel/cpanel.php?status=0'">
<option value="null">------------</option>
<{foreach item=links from=$waitinglinks}>
<option value="<{$links.id}>"><{$links.title}></option>
<{/foreach}>
</select>
</form>
</center>

</div>
<{/if}>
<div style="background-color:#ff9966;margin-top:3px;padding:2px">
<{if count($expiredlinks) gt 0}>
<font size="1"><a href="<{$xoops_url}>/modules/addresses/cpanel/cpanel.php?status=2"><{$linksexpired}></a></font>
<center>
<form name="expiredlinksform" id="expiredlinksform">
<select name="selectexpiredlink" onchange="location.href='/modules/addresses/cpanel/cpanel.php?status=2'">
<option value="null">------------</option>
<{foreach item=links from=$expiredlinks}>
<option value="<{$links.id}>"><{$links.title}></option>
<{/foreach}>
</select>
</form>
</center>
<{/if}>
<{if count($expiredlinks) == 0}>
<{$noexpiredlinks}>
<{/if}>
</div>

<?php
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;
}
?>