From af4a4dbcfbac6c48103fedaa0b42c6aa17d447ed Mon Sep 17 00:00:00 2001 From: Marcel Werk Date: Sat, 14 Dec 2024 14:40:29 +0100 Subject: [PATCH] Adjust join type --- .../files/lib/system/gridView/ACPSessionLogGridView.class.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/wcfsetup/install/files/lib/system/gridView/ACPSessionLogGridView.class.php b/wcfsetup/install/files/lib/system/gridView/ACPSessionLogGridView.class.php index d59bf8bf9c..88c45dde84 100644 --- a/wcfsetup/install/files/lib/system/gridView/ACPSessionLogGridView.class.php +++ b/wcfsetup/install/files/lib/system/gridView/ACPSessionLogGridView.class.php @@ -39,6 +39,7 @@ final class ACPSessionLogGridView extends DatabaseObjectListGridView GridViewColumn::for('userID') ->label('wcf.user.username') ->sortable(true, 'user_table.username') + ->titleColumn() ->renderer(new UserLinkColumnRenderer(UserEditForm::class)) ->filter(new UserFilter()), GridViewColumn::for('ipAddress') @@ -91,7 +92,7 @@ final class ACPSessionLogGridView extends DatabaseObjectListGridView FROM wcf1_acp_session_access_log WHERE sessionLogID = " . $list->getDatabaseTableAlias() . ".sessionLogID ) AS accesses"; - $list->sqlJoins = $list->sqlConditionJoins .= " JOIN wcf" . WCF_N . "_user user_table ON (user_table.userID = " . $list->getDatabaseTableAlias() . ".userID)"; + $list->sqlJoins = $list->sqlConditionJoins .= " LEFT JOIN wcf" . WCF_N . "_user user_table ON (user_table.userID = " . $list->getDatabaseTableAlias() . ".userID)"; return $list; } -- 2.20.1