function cw_faq_get_membership_faq($membership_id) { global $tables; $ret['main_category'] = cw_query_first("select * from {$tables['faq_rubrik']} where ars_id = '{$membership_id}' and ars_type = 'member'"); if ($ret['main_category']) { $ret['subcategories'] = cw_faq_get_subcategories($ret['main_category']['rubrik_id']); $ret['articles'] = cw_faq_get_articles($ret['main_category']['rubrik_id']); } else { # kornev, create the appropriate membership faq cw_faq_create_membership($membership_id); $ret['main_category'] = cw_query_first("select * from {$tables['faq_rubrik']} where ars_id = '{$membership_id}' and ars_type = 'member'"); } $ret['is_faq'] = (bool) (count($ret['articles']) || count($ret['subcategories'])); return $ret; }
if ($addons['faq']) { cw_faq_create_membership(0); foreach ($posted_data as $id => $v) { cw_faq_create_membership($id); } } cw_header_location("index.php?target={$target}"); } if ($action == 'add' && !empty($add['membership'])) { if (empty($add['orderby'])) { $add['orderby'] = cw_query_first_cell("SELECT MAX(orderby) FROM {$tables['memberships']} WHERE area = '{$add['area']}'") + 1; } $add['active'] = $add['active']; $id = cw_array2insert("memberships", $add); if ($addons['faq']) { cw_faq_create_membership($id); } db_query("INSERT INTO {$tables['memberships_lng']} VALUES ('{$id}','{$edited_language}','{$add['membership']}')"); if ($add['area'] == 'C' || $add['area'] == 'R') { cw_load("category"); cw_recalc_subcat_count(0, 100); } // Copy default fields setting for new membership db_query("INSERT INTO {$tables['register_fields_avails']} ( `field_id` , `area` , `is_avail` , `is_required` ) (\n SELECT field_id, CONCAT(area, '_{$id}' ) , is_avail, is_required\n FROM {$tables['register_fields_avails']}\n WHERE area IN ('{$add['area']}', '#{$add['area']}')\n )"); cw_header_location("index.php?target={$target}"); } if ($action == 'delete' && !empty($to_delete)) { cw_call('cw_user_delete_memberships', array($to_delete)); cw_header_location("index.php?target={$target}"); } $memberships = array();