128 lines
3.8 KiB
PHP
128 lines
3.8 KiB
PHP
|
|
<?php
|
||
|
|
$page = "admin_subscriber_usermessages";
|
||
|
|
include "admin_header.php";
|
||
|
|
|
||
|
|
|
||
|
|
$s = semods::getpost('s', "mid"); // sort default by msgid desc
|
||
|
|
$p = semods::getpost('p', 1);
|
||
|
|
$f_user = semods::getpost('f_user', "");
|
||
|
|
$f_text = semods::getpost('f_text', "");
|
||
|
|
$f_type = semods::getpost('f_type', -1);
|
||
|
|
|
||
|
|
$task = semods::getpost('task', "main");
|
||
|
|
|
||
|
|
$user_id = semods::getpost('user_id', 0);
|
||
|
|
|
||
|
|
// VALIDATE USER ID OR RETURN TO VIEW USERS
|
||
|
|
$user = new se_user(Array($user_id));
|
||
|
|
if($user->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";
|
||
|
|
?>
|