function get_contentgroups_data_where_perm($data, $perm) { // returns an indexed array containing all fields speicfied in $data in an assoc array where user has permission $perm global $db, $config_vars, $userdata; $where = get_allowed_contentgroups_where($userdata['user_id'], $perm, 'id'); $sql = "select {$data} from {$config_vars['table_prefix']}groups where {$where}"; if (!($result = $db->sql_query($sql))) { error_report(SQL_ERROR, 'get_contentgroups_data_where_perm', __LINE__, __FILE__, $sql); } // generate catgroup array for each catgroup that is returned by the query return generate_array_from_row($row); }
function get_surrounding_content($cat_id) { // Returns an Array of album_content objects of all content which is in the categorie with id $cat_id global $db, $config_vars, $userdata, $filetypes; // get auth where $auth_where = get_allowed_contentgroups_where($userdata['user_id'], "view", 'content.contentgroup_id'); // get all content $sql = 'SELECT content.id,content.file,content_in_cat.place_in_cat FROM ' . $config_vars['table_prefix'] . "content as content," . $config_vars['table_prefix'] . "content_in_cat as content_in_cat\n\t\t\tWHERE ({$auth_where}) and \n\t\t\t\t(content.id = content_in_cat.content_id) and (content_in_cat.cat_id = {$cat_id})\n\t\t\tORDER BY content_in_cat.place_in_cat"; if (!($result = $db->sql_query($sql))) { $error = new phreak_error(E_WARNING, SQL_ERROR, __LINE__, __FILE__, 'get_surrounding_content', $this->id, 0, 0, $sql); $error->commit(); //error_report(SQL_ERROR, 'get_surrounding_content' , __LINE__, __FILE__,$sql); } $objarray['place'] = 1; $objarray['amount'] = $db->sql_affectedrows(); while ($row = $db->sql_fetchrow($result)) { if ($row['id'] == $this->id) { $objarray['prev'] = get_content_from_row($lastrow); $objarray['next'] = get_content_from_row($db->sql_fetchrow($result)); return $objarray; } $objarray['place']++; $lastrow = $row; } }