summaryrefslogtreecommitdiff
path: root/includes
diff options
context:
space:
mode:
authorlsces <lester@lsces.co.uk>2026-02-02 21:05:12 +0000
committerlsces <lester@lsces.co.uk>2026-02-02 21:05:12 +0000
commitbebc6163d8c123b646d068437e06954a745e9f6b (patch)
tree1201acd38954a623edfbc906bbbd3e0e217c4986 /includes
parent302401f8a856a16ea04b0f08c8facb22e4ebd719 (diff)
downloadmessages-bebc6163d8c123b646d068437e06954a745e9f6b.tar.gz
messages-bebc6163d8c123b646d068437e06954a745e9f6b.tar.bz2
messages-bebc6163d8c123b646d068437e06954a745e9f6b.zip
Restructure layout in line with namespace addition and PHP8.4 style rules
Diffstat (limited to 'includes')
-rwxr-xr-x[-rw-r--r--]includes/bit_setup_inc.php1
-rwxr-xr-x[-rw-r--r--]includes/classes/Messages.php14
-rwxr-xr-x[-rw-r--r--]includes/user_preferences_inc.php9
3 files changed, 9 insertions, 15 deletions
diff --git a/includes/bit_setup_inc.php b/includes/bit_setup_inc.php
index 5c5c2b5..38c9e5f 100644..100755
--- a/includes/bit_setup_inc.php
+++ b/includes/bit_setup_inc.php
@@ -15,7 +15,6 @@ define( 'MESSAGES_PKG_CLASS_PATH', BIT_ROOT_PATH . basename( $pRegisterHash['pac
$gBitSystem->registerPackage( $pRegisterHash );
if( $gBitSystem->isPackageActive( 'messages' ) && $gBitUser->hasPermission( 'p_messages_send' ) ) {
- require_once MESSAGES_PKG_CLASS_PATH . 'Messages.php';
$messages = new Messages();
$unreadMsgs = $messages->unreadMessages( $gBitUser->mUserId );
$gBitSmarty->assign( 'unreadMsgs', $unreadMsgs );
diff --git a/includes/classes/Messages.php b/includes/classes/Messages.php
index e53042e..104f02a 100644..100755
--- a/includes/classes/Messages.php
+++ b/includes/classes/Messages.php
@@ -229,8 +229,8 @@ class Messages extends BitBase {
// ====================== insane message mergin and sorting ======================
$sort_mode = $pListHash['sort_mode'];
$ret = [];
- $normalMessageCount = count($normalMessages);
- $systemMessageCount = count($systemMessages);
+ $normalMessageCount = \count($normalMessages);
+ $systemMessageCount = \count($systemMessages);
$normalMsg = $systemMsg = NULL;
if (strpos($sort_mode, '_asc') !== FALSE) {
$sortType = '_asc';
@@ -361,11 +361,7 @@ class Messages extends BitBase {
$bindVars[] = '%'.strtoupper( $pListHash['find'] ).'%';
}
- if( !empty( $pListHash['neighbour'] ) && $pListHash['neighbour'] == 'prev' ) {
- $query = "SELECT MAX(`msg_id`) FROM `".BIT_DB_PREFIX."messages` mm WHERE `to_user_id`=? AND `msg_id` < ? $whereSql";
- } else {
- $query = "SELECT MIN(`msg_id`) FROM `".BIT_DB_PREFIX."messages` mm WHERE `to_user_id`=? AND `msg_id` > ? $whereSql";
- }
+ $query = ( !empty( $pListHash['neighbour'] ) && $pListHash['neighbour'] == 'prev' ) ? "SELECT MAX(`msg_id`) FROM `" . BIT_DB_PREFIX . "messages` mm WHERE `to_user_id`=? AND `msg_id` < ? $whereSql" : "SELECT MIN(`msg_id`) FROM `" . BIT_DB_PREFIX . "messages` mm WHERE `to_user_id`=? AND `msg_id` > ? $whereSql";
$msg_id = $this->mDb->getOne( $query, $bindVars );
return( !empty( $msg_id ) ? $msg_id : FALSE );
@@ -403,9 +399,9 @@ class Messages extends BitBase {
// Standard user to user messages
$normalCount = $this->mDb->getOne( "select count( * ) from `".BIT_DB_PREFIX."messages` where `to_user_id`=? and `is_read`=?", [ $pUserId, 'n' ] );
// Broadcast messages where they have a messages_system_map row but is_read is not yet set
- $broadcastCount = $this->mDb->getOne("SELECT COUNT(mm.`msg_id`) FROM `".BIT_DB_PREFIX."messages` mm INNER JOIN `".BIT_DB_PREFIX."messages_system_map` msm ON (mm.`msg_id` = msm.`msg_id` AND msm.`is_read` <> 'y' AND `is_hidden` <> 'y' AND msm.`to_user_id`= ?) WHERE mm.`to_user_id` = ? AND mm.`group_id` IN (SELECT `group_id` FROM `".BIT_DB_PREFIX."users_groups_map` WHERE `user_id`= ?) ", array($pUserId, ROOT_USER_ID, $pUserId));
+ $broadcastCount = $this->mDb->getOne("SELECT COUNT(mm.`msg_id`) FROM `".BIT_DB_PREFIX."messages` mm INNER JOIN `".BIT_DB_PREFIX."messages_system_map` msm ON (mm.`msg_id` = msm.`msg_id` AND msm.`is_read` <> 'y' AND `is_hidden` <> 'y' AND msm.`to_user_id`= ?) WHERE mm.`to_user_id` = ? AND mm.`group_id` IN (SELECT `group_id` FROM `".BIT_DB_PREFIX."users_groups_map` WHERE `user_id`= ?) ", [ $pUserId, ROOT_USER_ID, $pUserId ]);
// Broadcast messages where they do not yet have a messages_system_map row
- $broadcastCount2 = $this->mDb->getOne("SELECT COUNT(mm.`msg_id`) FROM `".BIT_DB_PREFIX."messages` mm WHERE mm.`to_user_id` = ? AND mm.`group_id` IN (SELECT `group_id` FROM `".BIT_DB_PREFIX."users_groups_map` WHERE `user_id` = ?) AND NOT EXISTS ( SELECT msm.`msg_id` FROM `".BIT_DB_PREFIX."messages_system_map` msm WHERE msm.`msg_id` = mm.`msg_id` AND msm.`to_user_id` = ?)", array(ROOT_USER_ID, $pUserId, $pUserId));
+ $broadcastCount2 = $this->mDb->getOne("SELECT COUNT(mm.`msg_id`) FROM `".BIT_DB_PREFIX."messages` mm WHERE mm.`to_user_id` = ? AND mm.`group_id` IN (SELECT `group_id` FROM `".BIT_DB_PREFIX."users_groups_map` WHERE `user_id` = ?) AND NOT EXISTS ( SELECT msm.`msg_id` FROM `".BIT_DB_PREFIX."messages_system_map` msm WHERE msm.`msg_id` = mm.`msg_id` AND msm.`to_user_id` = ?)", [ ROOT_USER_ID, $pUserId, $pUserId ]);
return $normalCount + $broadcastCount + $broadcastCount2;
}
diff --git a/includes/user_preferences_inc.php b/includes/user_preferences_inc.php
index eca829e..1a2d377 100644..100755
--- a/includes/user_preferences_inc.php
+++ b/includes/user_preferences_inc.php
@@ -10,9 +10,8 @@
$title = "User Messages";
if( isset( $_REQUEST['messprefs'] ) ) {
- $editUser->storePreference( 'messages_alert', !empty( $_REQUEST['messages_alert'] ) ? 'y' : 'n', USERS_PKG_NAME );
- $editUser->storePreference( 'messages_max_records', $_REQUEST['messages_max_records'], USERS_PKG_NAME );
- $editUser->storePreference( 'messages_min_priority', !empty( $_REQUEST['messages_min_priority'] ) ? $_REQUEST['messages_min_priority'] : NULL, USERS_PKG_NAME );
- $editUser->storePreference( 'messages_allow_messages', !empty( $_REQUEST['messages_allow_messages'] ) ? 'y' : 'n', USERS_PKG_NAME );
+ $editUser->storePreference( 'messages_alert', !empty( $_REQUEST['messages_alert'] ) ? 'y' : 'n' );
+ $editUser->storePreference( 'messages_max_records', $_REQUEST['messages_max_records'] );
+ $editUser->storePreference( 'messages_min_priority', !empty( $_REQUEST['messages_min_priority'] ) ? $_REQUEST['messages_min_priority'] : NULL );
+ $editUser->storePreference( 'messages_allow_messages', !empty( $_REQUEST['messages_allow_messages'] ) ? 'y' : 'n' );
}
-?>