function LinksAdminPerm()
{
global $context, $mbname, $txt, $db_prefix;
isAllowedTo('links_manage_cat');
adminIndex('links_settings');
DoLinksAdminTabs();
$context['page_title'] = $mbname . $txt['smflinks_title'] . ' - ' . $txt['smflinks_catpermlist'];
$context['sub_template'] = 'catpermlist';
//Show the member groups
$dbresult = db_query("\n\t\t \tSELECT \n\t\t \t\tc.ID_CAT, c.ID, c.view, c.addlink, c.editlink, c.dellink, c.ID_GROUP, m.groupName,a.title catname \n\t\t \tFROM ({$db_prefix}links_catperm as c, {$db_prefix}membergroups AS m,{$db_prefix}links_cat as a) \n\t\t \tWHERE c.ID_GROUP = m.ID_GROUP AND a.ID_CAT = c.ID_CAT", __FILE__, __LINE__);
$context['links_membergroups'] = array();
while ($row = mysql_fetch_assoc($dbresult)) {
$context['links_membergroups'][] = $row;
}
mysql_free_result($dbresult);
// Regular Member Groups
$dbresult = db_query("\n\t\t \tSELECT \n\t\t \t\tc.ID_CAT, c.ID, c.view, c.addlink, c.editlink, c.dellink, c.ID_GROUP,a.title catname \n\t\t \tFROM {$db_prefix}links_catperm as c,{$db_prefix}links_cat as a \n\t\t \tWHERE c.ID_GROUP = 0 AND a.ID_CAT = c.ID_CAT LIMIT 1", __FILE__, __LINE__);
$context['links_reggroups'] = array();
while ($row = mysql_fetch_assoc($dbresult)) {
$context['links_reggroups'][] = $row;
}
mysql_free_result($dbresult);
// Guests
$dbresult = db_query("\n\t\t \tSELECT \n\t\t \t\tc.ID_CAT, c.ID, c.view, c.addlink, c.editlink, c.dellink, c.ID_GROUP,a.title catname \n\t\t \tFROM {$db_prefix}links_catperm as c,{$db_prefix}links_cat as a \n\t\t \tWHERE c.ID_GROUP = -1 AND a.ID_CAT = c.ID_CAT LIMIT 1", __FILE__, __LINE__);
$context['links_guestsgroups'] = array();
while ($row = mysql_fetch_assoc($dbresult)) {
$context['links_guestsgroups'][] = $row;
}
mysql_free_result($dbresult);
}
function LinksAdminPerm()
{
global $context, $mbname, $txt, $smcFunc;
isAllowedTo('links_manage_cat');
DoLinksAdminTabs();
$context['page_title'] = $mbname . $txt['smflinks_title'] . ' - ' . $txt['smflinks_catpermlist'];
$context['sub_template'] = 'catpermlist';
// Show the member groups
$dbresult = $smcFunc['db_query']('', '
SELECT c.ID_CAT, c.ID, c.view, c.addlink, c.editlink,
c.dellink, c.ID_GROUP, m.group_name,a.title catname
FROM ({db_prefix}links_catperm AS c, {db_prefix}membergroups AS m, {db_prefix}links_cat AS a)
WHERE c.ID_GROUP = m.ID_GROUP AND a.ID_CAT = c.ID_CAT');
$context['links_m_groups'] = array();
while ($row = $smcFunc['db_fetch_assoc']($dbresult)) {
$context['links_m_groups'][] = $row;
}
$smcFunc['db_free_result']($dbresult);
//Show Regular members
$dbresult = $smcFunc['db_query']('', '
SELECT c.ID_CAT, c.ID, c.view, c.addlink,
c.editlink, c.dellink, c.ID_GROUP,a.title catname
FROM {db_prefix}links_catperm AS c,{db_prefix}links_cat AS a
WHERE c.ID_GROUP = 0
AND a.ID_CAT = c.ID_CAT LIMIT 1');
$context['links_reg_groups'] = array();
while ($row = $smcFunc['db_fetch_assoc']($dbresult)) {
$context['links_reg_groups'][] = $row;
}
$smcFunc['db_free_result']($dbresult);
// Show Guests
$dbresult = $smcFunc['db_query']('', '
SELECT c.ID_CAT, c.ID, c.view, c.addlink,
c.editlink, c.dellink, c.ID_GROUP,a.title catname
FROM {db_prefix}links_catperm AS c,{db_prefix}links_cat AS a
WHERE c.ID_GROUP = -1
AND a.ID_CAT = c.ID_CAT LIMIT 1');
$context['links_guests_groups'] = array();
while ($row = $smcFunc['db_fetch_assoc']($dbresult)) {
$context['links_guests_groups'][] = $row;
}
$smcFunc['db_free_result']($dbresult);
}
