diff options
| author | lsces <lester@lsces.co.uk> | 2026-02-02 21:05:12 +0000 |
|---|---|---|
| committer | lsces <lester@lsces.co.uk> | 2026-02-02 21:05:12 +0000 |
| commit | bebc6163d8c123b646d068437e06954a745e9f6b (patch) | |
| tree | 1201acd38954a623edfbc906bbbd3e0e217c4986 /includes | |
| parent | 302401f8a856a16ea04b0f08c8facb22e4ebd719 (diff) | |
| download | messages-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.php | 1 | ||||
| -rwxr-xr-x[-rw-r--r--] | includes/classes/Messages.php | 14 | ||||
| -rwxr-xr-x[-rw-r--r--] | includes/user_preferences_inc.php | 9 |
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' ); } -?> |
