0 ) $filters[] = "userplan_plan_id = '$f_plan'"; else /* * userplan_state * 0 - active * 1 - active_trial * 2 - expired * 3 - cancelled * 4 - suspended(?) * 5 - created - waiting for payment confirmation * 6 - future??? - subscribed but not yet activated, when previous plan is still active and "downgrading" plan * 7 - suspended - failed payment * */ switch($f_plan) { // Not subscribed (no plan or expired(2) ) case -1: $filters[] = "(ISNULL(userplan_plan_id) OR userplan_state = 2)"; break; // Only subscribed & active ( active(0), active_trial(1), cancelled(3), suspended(4), 5,7 ) case -2: $filters[] = "userplan_state IN(0,1,3,4,5,7)"; break; // suspended (4,7) case -3: $filters[] = "userplan_state IN(4,7)"; break; } } !empty($filters) ? $sql_body .= " WHERE " . implode( " AND ", $filters):0; } $sql_count = 'SELECT COUNT(*)' . ' ' . $sql_body; $sql_users = $sql_head . ' ' . $sql_body . ' ' . $sql_tail; // GET TOTAL USERS $total_users = semods::db_query_count( $sql_count ); // MAKE USER PAGES $users_per_page = 50; $page_vars = make_page($total_users, $users_per_page, $p); $page_array = Array(); for($x=0;$x<=$page_vars[2]-1;$x++) { if($x+1 == $page_vars[1]) { $link = "1"; } else { $link = "0"; } $page_array[$x] = Array('page' => $x+1, 'link' => $link); } $sql_users .= " ORDER BY $sort LIMIT $page_vars[0], $users_per_page"; $level_array = semods::load_userlevels(); $subnet_array = semods::load_subnets(); // LOOP OVER PLANS $rows = $database->database_query("SELECT * FROM se_semods_plans plan_name"); while($row = $database->database_fetch_assoc($rows)) { $plans[] = $row; } // PULL USERS INTO AN ARRAY $user = Array(); $user_count = 0; $users_dbr = $database->database_query($sql_users); while($user_info = $database->database_fetch_assoc($users_dbr)) { $user_info['user_level'] = $level_array[$user_info['user_level_id']]['level_name']; $user_info['user_subnet'] = $subnet_array[$user_info['user_subnet_id']]['subnet_name']; $user_info['userplan_statetext'] = $userplan_states[ $user_info['userplan_state'] ]; semods_utils::create_user_displayname_ex( $user_info ); $users[] = $user_info; } // PRELOAD LANG foreach($userplan_states as $userplan_state) { SE_Language::_preload( $userplan_state ); } // ASSIGN VARIABLES AND SHOW VIEW USERS PAGE $smarty->assign('total_users', $total_users); $smarty->assign('pages', $page_array); $smarty->assign('subscriptionid', $subscriptionid); $smarty->assign('users', $users); $smarty->assign('i', $i); $smarty->assign('u', $u); $smarty->assign('em', $em); $smarty->assign('v', $v); $smarty->assign('sd', $sd); $smarty->assign('pc', $pc); $smarty->assign('tp', $tp); $smarty->assign('p', $page_vars[1]); $smarty->assign('s', $s); $smarty->assign('f_user', $f_user); $smarty->assign('f_email', $f_email); $smarty->assign('f_level', $f_level); $smarty->assign('f_subnet', $f_subnet); $smarty->assign('f_enabled', $f_enabled); $smarty->assign('f_plan', $f_plan); $smarty->assign('levels', array_values($level_array)); $smarty->assign('subnets', array_values($subnet_array)); $smarty->assign('plans', $plans); include "admin_footer.php"; ?>