user_exists == 0) { header("Location: admin_subscriber_viewusers.php?s=$s&p=$p&f_user=$f_user&f_email=$f_email&f_level=$f_level&f_enabled=$f_enabled"); exit(); } // SET USER SORT-BY VARIABLES FOR HEADING LINKS $i = "mid"; // MSG_ID $d = "d"; // DATE // SET SORT VARIABLE FOR DATABASE QUERY if($s == "d") { $sort = "userplanactivity_date"; $d = "dd"; } elseif($s == "dd") { $sort = "userplanactivity_date DESC"; $d = "d"; } else { $sort = "userplanactivity_id DESC"; $i = "mi"; } $sql_head = "SELECT U.user_id, U.user_username, M.*"; $sql_body = "FROM se_semods_userplanactivity M LEFT JOIN se_users U ON M.userplanactivity_user_id = U.user_id"; $filters = array(); $f_user != "" ? $filters[] = "user_username LIKE '%$f_user%'" :0; $user_id != "" ? $filters[] = "user_id = $user_id" :0; $f_text != "" ? $filters[] = "userplanactivity_text LIKE '%$f_text%'" :0; if($f_type != -1) { if($f_type == 1000) $filters[] = "userplanactivity_type >= 1000"; else $filters[] = "userplanactivity_type = $f_type"; } !empty($filters) ? $sql_body .= " WHERE " . implode( " AND ", $filters):0; $sql_count = 'SELECT COUNT(*)' . ' ' . $sql_body; $sql_items = $sql_head . ' ' . $sql_body; // GET TOTAL MESSAGES $total_items = semods::db_query_count( $sql_count ); // MAKE PAGES $items_per_page = 50; $page_vars = make_page($total_items, $items_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_items .= " ORDER BY $sort LIMIT $page_vars[0], $items_per_page"; // PULL MESSAGES INTO AN ARRAY $messages = Array(); $rows = $database->database_query($sql_items); while($row = $database->database_fetch_assoc($rows)) { $row['userplanactivity_typetext'] = $row['userplanactivity_type'] > 1000 ? 100014063 : $activity_msg_types[$row['userplanactivity_type']]; SE_Language::_preload($row['userplanactivity_typetext']); if(is_numeric($row['userplanactivity_text'])) { SE_Language::_preload($row['userplanactivity_text']); SE_Language::load(); $row['userplanactivity_text'] = SE_Language::_get($row['userplanactivity_text']); } $messages[] = $row; } foreach($activity_msg_types as $key => $value ) { $messagetypes[] = array( 'messagetype_id' => $key, 'messagetype_name' => $value ); SE_Language::_preload( $value ); } // ASSIGN VARIABLES AND SHOW VIEW USERS PAGE $smarty->assign('total_items', $total_items); $smarty->assign('pages', $page_array); $smarty->assign('messages', $messages); $smarty->assign('messagetypes', $messagetypes); $smarty->assign('i', $i); $smarty->assign('d', $d); $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('user_username', $setting['setting_username'] ? $user->user_info['user_username'] : $user->user_displayname ); $smarty->assign('user_id', $user_id); $smarty->assign('f_type', $f_type); $smarty->assign('f_text', $f_text); include "admin_footer.php"; ?>