function getGroupNameById($id)
{
return executeResult("SELECT `name` FROM `nf_groups` WHERE `id`=?", array($id))[0];
}
function getDataValue($key)
{
return executeResult("SELECT `value` FROM `nf_data` WHERE `name`=?", array($key))[0];
}
function loadPermissions($userid)
{
$permissions = array();
$permissions['user'] = listUserPermissions($userid);
$groups = json_decode(executeResult("SELECT `groups` FROM `nf_users` WHERE `id`=?", array($userid))[0], true);
$permissions['groups'] = array();
foreach ($groups as $value) {
$permissions['groups'][$value] = listGroupPermissions($value);
}
return $permissions;
}
function getLatestPostByForumId($id)
{
return executeResult("SELECT `title` FROM `nf_posts` WHERE `forumid`=? ORDER BY DESC LIMIT 1", array($id))[0];
}
function getActiveTheme()
{
return executeResult("SELECT `value` FROM `nf_data` WHERE `name`=?", array("activetheme"))[0];
}
function getUserIdByName($username)
{
return executeResult("SELECT `id` FROM `nf_users` WHERE `username`=?", array($username))[0];
}
