= 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 = 100; $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']]; semods_utils::create_user_displayname_ex( $row ); $messages[] = $row; SE_Language::_preload( $row['userplanactivity_typetext'] ); } 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('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_type', $f_type); $smarty->assign('f_text', $f_text); include "admin_footer.php"; ?>