| 1 |  |  | <?php | 
            
                                                                                                            
                            
            
                                    
            
            
                | 2 |  |  | /****************************************************************************** | 
            
                                                                                                            
                            
            
                                    
            
            
                | 3 |  |  |  * Wikipedia Account Creation Assistance tool                                 * | 
            
                                                                                                            
                            
            
                                    
            
            
                | 4 |  |  |  * ACC Development Team. Please see team.json for a list of contributors.     * | 
            
                                                                                                            
                            
            
                                    
            
            
                | 5 |  |  |  *                                                                            * | 
            
                                                                                                            
                            
            
                                    
            
            
                | 6 |  |  |  * This is free and unencumbered software released into the public domain.    * | 
            
                                                                                                            
                            
            
                                    
            
            
                | 7 |  |  |  * Please see LICENSE.md for the full licencing statement.                    * | 
            
                                                                                                            
                            
            
                                    
            
            
                | 8 |  |  |  ******************************************************************************/ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 9 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 10 |  |  | namespace Waca\Helpers; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 11 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 12 |  |  | use Exception; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 13 |  |  | use PDO; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 14 |  |  | use Waca\DataObject; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 15 |  |  | use Waca\DataObjects\Ban; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 16 |  |  | use Waca\DataObjects\Comment; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 17 |  |  | use Waca\DataObjects\Domain; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 18 |  |  | use Waca\DataObjects\EmailTemplate; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 19 |  |  | use Waca\DataObjects\JobQueue; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 20 |  |  | use Waca\DataObjects\Log; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 21 |  |  | use Waca\DataObjects\Request; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 22 |  |  | use Waca\DataObjects\RequestForm; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 23 |  |  | use Waca\DataObjects\RequestQueue; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 24 |  |  | use Waca\DataObjects\User; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 25 |  |  | use Waca\DataObjects\WelcomeTemplate; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 26 |  |  | use Waca\Helpers\SearchHelpers\LogSearchHelper; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 27 |  |  | use Waca\Helpers\SearchHelpers\UserSearchHelper; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 28 |  |  | use Waca\PdoDatabase; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 29 |  |  | use Waca\Security\ISecurityManager; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 30 |  |  | use Waca\SiteConfiguration; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 31 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 32 |  |  | class LogHelper | 
            
                                                                                                            
                            
            
                                    
            
            
                | 33 |  |  | { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 34 |  |  |     /** | 
            
                                                                                                            
                            
            
                                    
            
            
                | 35 |  |  |      * @param int             $requestId | 
            
                                                                                                            
                            
            
                                    
            
            
                | 36 |  |  |      * | 
            
                                                                                                            
                            
            
                                    
            
            
                | 37 |  |  |      * @return DataObject[] | 
            
                                                                                                            
                            
            
                                    
            
            
                | 38 |  |  |      */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 39 |  |  |     public static function getRequestLogsWithComments( | 
            
                                                                                                            
                            
            
                                    
            
            
                | 40 |  |  |         $requestId, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 41 |  |  |         PdoDatabase $db, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 42 |  |  |         ISecurityManager $securityManager | 
            
                                                                                                            
                            
            
                                    
            
            
                | 43 |  |  |     ): array { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 44 |  |  |         // FIXME: domains | 
            
                                                                                                            
                            
            
                                    
            
            
                | 45 |  |  |         $logs = LogSearchHelper::get($db, 1)->byObjectType('Request')->byObjectId($requestId)->fetch(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 46 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 47 |  |  |         $currentUser = User::getCurrent($db); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 48 |  |  |         $showRestrictedComments = $securityManager->allows('RequestData', 'seeRestrictedComments', $currentUser) === ISecurityManager::ALLOWED; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 49 |  |  |         $showCheckuserComments = $securityManager->allows('RequestData', 'seeCheckuserComments', $currentUser) === ISecurityManager::ALLOWED; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 50 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 51 |  |  |         $comments = Comment::getForRequest($requestId, $db, $showRestrictedComments, $showCheckuserComments, $currentUser->getId()); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 52 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 53 |  |  |         $items = array_merge($logs, $comments); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 54 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 55 |  |  |         $sortKey = function(DataObject $item): int { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 56 |  |  |             if ($item instanceof Log) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 57 |  |  |                 return $item->getTimestamp()->getTimestamp(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 58 |  |  |             } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 59 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 60 |  |  |             if ($item instanceof Comment) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 61 |  |  |                 return $item->getTime()->getTimestamp(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 62 |  |  |             } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 63 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 64 |  |  |             return 0; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 65 |  |  |         }; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 66 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 67 |  |  |         do { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 68 |  |  |             $flag = false; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 69 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 70 |  |  |             $loopLimit = (count($items) - 1); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 71 |  |  |             for ($i = 0; $i < $loopLimit; $i++) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 72 |  |  |                 // are these two items out of order? | 
            
                                                                                                            
                            
            
                                    
            
            
                | 73 |  |  |                 if ($sortKey($items[$i]) > $sortKey($items[$i + 1])) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 74 |  |  |                     // swap them | 
            
                                                                                                            
                            
            
                                    
            
            
                | 75 |  |  |                     $swap = $items[$i]; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 76 |  |  |                     $items[$i] = $items[$i + 1]; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 77 |  |  |                     $items[$i + 1] = $swap; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 78 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 79 |  |  |                     // set a flag to say we've modified the array this time around | 
            
                                                                                                            
                            
            
                                    
            
            
                | 80 |  |  |                     $flag = true; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 81 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 82 |  |  |             } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 83 |  |  |         } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 84 |  |  |         while ($flag); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 85 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 86 |  |  |         return $items; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 87 |  |  |     } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 88 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 89 |  |  |     public static function getLogDescription(Log $entry): string | 
            
                                                                                                            
                            
            
                                    
            
            
                | 90 |  |  |     { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 91 |  |  |         $text = "Deferred to "; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 92 |  |  |         if (substr($entry->getAction(), 0, strlen($text)) == $text) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 93 |  |  |             // Deferred to a different queue | 
            
                                                                                                            
                            
            
                                    
            
            
                | 94 |  |  |             // This is exactly what we want to display. | 
            
                                                                                                            
                            
            
                                    
            
            
                | 95 |  |  |             return $entry->getAction(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 96 |  |  |         } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 97 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 98 |  |  |         $text = "Closed custom-n"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 99 |  |  |         if ($entry->getAction() == $text) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 100 |  |  |             // Custom-closed | 
            
                                                                                                            
                            
            
                                    
            
            
                | 101 |  |  |             return "closed (custom reason - account not created)"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 102 |  |  |         } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 103 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 104 |  |  |         $text = "Closed custom-y"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 105 |  |  |         if ($entry->getAction() == $text) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 106 |  |  |             // Custom-closed | 
            
                                                                                                            
                            
            
                                    
            
            
                | 107 |  |  |             return "closed (custom reason - account created)"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 108 |  |  |         } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 109 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 110 |  |  |         $text = "Closed 0"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 111 |  |  |         if ($entry->getAction() == $text) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 112 |  |  |             // Dropped the request - short-circuit the lookup | 
            
                                                                                                            
                            
            
                                    
            
            
                | 113 |  |  |             return "dropped request"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 114 |  |  |         } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 115 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 116 |  |  |         $text = "Closed "; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 117 |  |  |         if (substr($entry->getAction(), 0, strlen($text)) == $text) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 118 |  |  |             // Closed with a reason - do a lookup here. | 
            
                                                                                                            
                            
            
                                    
            
            
                | 119 |  |  |             $id = substr($entry->getAction(), strlen($text)); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 120 |  |  |             /** @var EmailTemplate|false $template */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 121 |  |  |             $template = EmailTemplate::getById((int)$id, $entry->getDatabase()); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 122 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 123 |  |  |             if ($template !== false) { | 
                            
                    |  |  |  | 
                                                                                        
                                                                                     | 
            
                                                                                                            
                            
            
                                    
            
            
                | 124 |  |  |                 return 'closed (' . $template->getName() . ')'; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 125 |  |  |             } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 126 |  |  |         } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 127 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 128 |  |  |         // Fall back to the basic stuff | 
            
                                                                                                            
                            
            
                                    
            
            
                | 129 |  |  |         $lookup = array( | 
            
                                                                                                            
                            
            
                                    
            
            
                | 130 |  |  |             'Reserved'            => 'reserved', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 131 |  |  |             'Email Confirmed'     => 'email-confirmed', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 132 |  |  |             'Manually Confirmed'  => 'manually confirmed the request', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 133 |  |  |             'Unreserved'          => 'unreserved', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 134 |  |  |             'Approved'            => 'approved', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 135 |  |  |             'DeactivatedUser'     => 'deactivated user', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 136 |  |  |             'RoleChange'          => 'changed roles', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 137 |  |  |             'GlobalRoleChange'    => 'changed global roles', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 138 |  |  |             'RequestedReactivation' => 'requested reactivation', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 139 |  |  |             'Banned'              => 'banned', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 140 |  |  |             'Edited'              => 'edited interface message', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 141 |  |  |             'EditComment-c'       => 'edited a comment', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 142 |  |  |             'EditComment-r'       => 'edited a comment', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 143 |  |  |             'FlaggedComment'      => 'flagged a comment', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 144 |  |  |             'UnflaggedComment'    => 'unflagged a comment', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 145 |  |  |             'Unbanned'            => 'unbanned', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 146 |  |  |             'BanReplaced'         => 'replaced ban', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 147 |  |  |             'Promoted'            => 'promoted to tool admin', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 148 |  |  |             'BreakReserve'        => 'forcibly broke the reservation', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 149 |  |  |             'Prefchange'          => 'changed user preferences', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 150 |  |  |             'Renamed'             => 'renamed', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 151 |  |  |             'Demoted'             => 'demoted from tool admin', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 152 |  |  |             'ReceiveReserved'     => 'received the reservation', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 153 |  |  |             'SendReserved'        => 'sent the reservation', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 154 |  |  |             'EditedEmail'         => 'edited email', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 155 |  |  |             'DeletedTemplate'     => 'deleted template', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 156 |  |  |             'EditedTemplate'      => 'edited template', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 157 |  |  |             'CreatedEmail'        => 'created email', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 158 |  |  |             'CreatedTemplate'     => 'created template', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 159 |  |  |             'SentMail'            => 'sent an email to the requester', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 160 |  |  |             'Registered'          => 'registered a tool account', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 161 |  |  |             'JobIssue'            => 'ran a background job unsuccessfully', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 162 |  |  |             'JobCompleted'        => 'completed a background job', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 163 |  |  |             'JobAcknowledged'     => 'acknowledged a job failure', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 164 |  |  |             'JobRequeued'         => 'requeued a job for re-execution', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 165 |  |  |             'JobCancelled'        => 'cancelled execution of a job', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 166 |  |  |             'EnqueuedJobQueue'    => 'scheduled for creation', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 167 |  |  |             'Hospitalised'        => 'sent to the hospital', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 168 |  |  |             'QueueCreated'        => 'created a request queue', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 169 |  |  |             'QueueEdited'         => 'edited a request queue', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 170 |  |  |             'DomainCreated'       => 'created a domain', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 171 |  |  |             'DomainEdited'        => 'edited a domain', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 172 |  |  |             'RequestFormCreated'  => 'created a request form', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 173 |  |  |             'RequestFormEdited'   => 'edited a request form', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 174 |  |  |         ); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 175 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 176 |  |  |         if (array_key_exists($entry->getAction(), $lookup)) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 177 |  |  |             return $lookup[$entry->getAction()]; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 178 |  |  |         } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 179 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 180 |  |  |         // OK, I don't know what this is. Fall back to something sane. | 
            
                                                                                                            
                            
            
                                    
            
            
                | 181 |  |  |         return "performed an unknown action ({$entry->getAction()})"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 182 |  |  |     } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 183 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 184 |  |  |     public static function getLogActions(PdoDatabase $database): array | 
            
                                                                                                            
                            
            
                                    
            
            
                | 185 |  |  |     { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 186 |  |  |         $lookup = array( | 
            
                                                                                                            
                            
            
                                    
            
            
                | 187 |  |  |             "Requests" => [ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 188 |  |  |                 'Reserved'            => 'reserved', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 189 |  |  |                 'Email Confirmed'     => 'email-confirmed', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 190 |  |  |                 'Manually Confirmed'  => 'manually confirmed', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 191 |  |  |                 'Unreserved'          => 'unreserved', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 192 |  |  |                 'EditComment-c'       => 'edited a comment (by comment ID)', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 193 |  |  |                 'EditComment-r'       => 'edited a comment (by request)', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 194 |  |  |                 'FlaggedComment'      => 'flagged a comment', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 195 |  |  |                 'UnflaggedComment'    => 'unflagged a comment', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 196 |  |  |                 'BreakReserve'        => 'forcibly broke the reservation', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 197 |  |  |                 'ReceiveReserved'     => 'received the reservation', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 198 |  |  |                 'SendReserved'        => 'sent the reservation', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 199 |  |  |                 'SentMail'            => 'sent an email to the requester', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 200 |  |  |                 'Closed 0'            => 'dropped request', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 201 |  |  |                 'Closed custom-y'     => 'closed (custom reason - account created)', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 202 |  |  |                 'Closed custom-n'     => 'closed (custom reason - account not created)', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 203 |  |  |             ], | 
            
                                                                                                            
                            
            
                                    
            
            
                | 204 |  |  |             'Users' => [ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 205 |  |  |                 'Approved'            => 'approved', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 206 |  |  |                 'DeactivatedUser'     => 'deactivated user', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 207 |  |  |                 'RoleChange'          => 'changed roles', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 208 |  |  |                 'GlobalRoleChange'    => 'changed global roles', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 209 |  |  |                 'Prefchange'          => 'changed user preferences', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 210 |  |  |                 'Renamed'             => 'renamed', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 211 |  |  |                 'Promoted'            => 'promoted to tool admin', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 212 |  |  |                 'Demoted'             => 'demoted from tool admin', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 213 |  |  |                 'Registered'          => 'registered a tool account', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 214 |  |  |                 'RequestedReactivation' => 'requested reactivation', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 215 |  |  |             ], | 
            
                                                                                                            
                            
            
                                    
            
            
                | 216 |  |  |             "Bans" => [ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 217 |  |  |                 'Banned'              => 'banned', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 218 |  |  |                 'Unbanned'            => 'unbanned', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 219 |  |  |                 'BanReplaced'         => 'replaced ban', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 220 |  |  |             ], | 
            
                                                                                                            
                            
            
                                    
            
            
                | 221 |  |  |             "Site notice" => [ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 222 |  |  |                 'Edited'              => 'edited interface message', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 223 |  |  |             ], | 
            
                                                                                                            
                            
            
                                    
            
            
                | 224 |  |  |             "Email close templates" => [ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 225 |  |  |                 'EditedEmail'         => 'edited email', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 226 |  |  |                 'CreatedEmail'        => 'created email', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 227 |  |  |             ], | 
            
                                                                                                            
                            
            
                                    
            
            
                | 228 |  |  |             "Welcome templates" => [ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 229 |  |  |                 'DeletedTemplate'     => 'deleted template', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 230 |  |  |                 'EditedTemplate'      => 'edited template', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 231 |  |  |                 'CreatedTemplate'     => 'created template', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 232 |  |  |             ], | 
            
                                                                                                            
                            
            
                                    
            
            
                | 233 |  |  |             "Job queue" => [ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 234 |  |  |                 'JobIssue'            => 'ran a background job unsuccessfully', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 235 |  |  |                 'JobCompleted'        => 'completed a background job', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 236 |  |  |                 'JobAcknowledged'     => 'acknowledged a job failure', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 237 |  |  |                 'JobRequeued'         => 'requeued a job for re-execution', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 238 |  |  |                 'JobCancelled'        => 'cancelled execution of a job', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 239 |  |  |                 'EnqueuedJobQueue'    => 'scheduled for creation', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 240 |  |  |                 'Hospitalised'        => 'sent to the hospital', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 241 |  |  |             ], | 
            
                                                                                                            
                            
            
                                    
            
            
                | 242 |  |  |             "Request queues" => [ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 243 |  |  |                 'QueueCreated'        => 'created a request queue', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 244 |  |  |                 'QueueEdited'         => 'edited a request queue', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 245 |  |  |             ], | 
            
                                                                                                            
                            
            
                                    
            
            
                | 246 |  |  |             "Domains" => [ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 247 |  |  |                 'DomainCreated'       => 'created a domain', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 248 |  |  |                 'DomainEdited'        => 'edited a domain', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 249 |  |  |             ], | 
            
                                                                                                            
                            
            
                                    
            
            
                | 250 |  |  |             "Request forms" => [ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 251 |  |  |                 'RequestFormCreated'        => 'created a request form', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 252 |  |  |                 'RequestFormEdited'         => 'edited a request form', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 253 |  |  |             ], | 
            
                                                                                                            
                            
            
                                    
            
            
                | 254 |  |  |         ); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 255 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 256 |  |  |         $databaseDrivenLogKeys = $database->query(<<<SQL | 
            
                                                                                                            
                            
            
                                    
            
            
                | 257 |  |  | SELECT CONCAT('Closed ', id) AS k, CONCAT('closed (',name,')') AS v FROM emailtemplate | 
            
                                                                                                            
                            
            
                                    
            
            
                | 258 |  |  | UNION ALL | 
            
                                                                                                            
                            
            
                                    
            
            
                | 259 |  |  | SELECT CONCAT('Deferred to ', logname) AS k, CONCAT('deferred to ', displayname) AS v FROM requestqueue; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 260 |  |  | SQL | 
            
                                                                                                            
                            
            
                                    
            
            
                | 261 |  |  |         ); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 262 |  |  |         foreach ($databaseDrivenLogKeys->fetchAll(PDO::FETCH_ASSOC) as $row) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 263 |  |  |             $lookup["Requests"][$row['k']] = $row['v']; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 264 |  |  |         } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 265 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 266 |  |  |         return $lookup; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 267 |  |  |     } | 
            
                                                                                                            
                                                                
            
                                    
            
            
                | 268 |  |  |  | 
            
                                                                        
                            
            
                                    
            
            
                | 269 |  |  |     public static function getObjectTypes(): array | 
            
                                                                        
                            
            
                                    
            
            
                | 270 |  |  |     { | 
            
                                                                        
                            
            
                                    
            
            
                | 271 |  |  |         return array( | 
            
                                                                        
                            
            
                                    
            
            
                | 272 |  |  |             'Ban'             => 'Ban', | 
            
                                                                        
                            
            
                                    
            
            
                | 273 |  |  |             'Comment'         => 'Comment', | 
            
                                                                        
                            
            
                                    
            
            
                | 274 |  |  |             'EmailTemplate'   => 'Email template', | 
            
                                                                        
                            
            
                                    
            
            
                | 275 |  |  |             'JobQueue'        => 'Job queue item', | 
            
                                                                        
                            
            
                                    
            
            
                | 276 |  |  |             'Request'         => 'Request', | 
            
                                                                        
                            
            
                                    
            
            
                | 277 |  |  |             'SiteNotice'      => 'Site notice', | 
            
                                                                        
                            
            
                                    
            
            
                | 278 |  |  |             'User'            => 'User', | 
            
                                                                        
                            
            
                                    
            
            
                | 279 |  |  |             'WelcomeTemplate' => 'Welcome template', | 
            
                                                                        
                            
            
                                    
            
            
                | 280 |  |  |             'RequestQueue'    => 'Request queue', | 
            
                                                                        
                            
            
                                    
            
            
                | 281 |  |  |             'Domain'          => 'Domain', | 
            
                                                                        
                            
            
                                    
            
            
                | 282 |  |  |             'RequestForm'     => 'Request form' | 
            
                                                                                                            
                            
            
                                    
            
            
                | 283 |  |  |         ); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 284 |  |  |     } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 285 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 286 |  |  |     /** | 
            
                                                                                                            
                            
            
                                    
            
            
                | 287 |  |  |      * This returns an HTML representation of the object | 
            
                                                                                                            
                            
            
                                    
            
            
                | 288 |  |  |      * | 
            
                                                                                                            
                            
            
                                    
            
            
                | 289 |  |  |      * @param int               $objectId | 
            
                                                                                                            
                            
            
                                    
            
            
                | 290 |  |  |      * @param string            $objectType | 
            
                                                                                                            
                            
            
                                    
            
            
                | 291 |  |  |      * | 
            
                                                                                                            
                            
            
                                    
            
            
                | 292 |  |  |      * @category Security-Critical | 
            
                                                                                                            
                            
            
                                    
            
            
                | 293 |  |  |      */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 294 |  |  |     private static function getObjectDescription( | 
            
                                                                                                            
                            
            
                                    
            
            
                | 295 |  |  |         $objectId, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 296 |  |  |         $objectType, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 297 |  |  |         PdoDatabase $database, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 298 |  |  |         SiteConfiguration $configuration | 
            
                                                                                                            
                            
            
                                    
            
            
                | 299 |  |  |     ): ?string { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 300 |  |  |         if ($objectType == '') { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 301 |  |  |             return null; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 302 |  |  |         } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 303 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 304 |  |  |         $baseurl = $configuration->getBaseUrl(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 305 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 306 |  |  |         switch ($objectType) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 307 |  |  |             case 'Ban': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 308 |  |  |                 /** @var Ban $ban */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 309 |  |  |                 $ban = Ban::getById($objectId, $database); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 310 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 311 |  |  |                 if ($ban === false) { | 
                            
                    |  |  |  | 
                                                                                        
                                                                                     | 
            
                                                                                                            
                            
            
                                    
            
            
                | 312 |  |  |                     return 'Ban #' . $objectId; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 313 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 314 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 315 |  |  |                 return <<<HTML | 
            
                                                                                                            
                            
            
                                    
            
            
                | 316 |  |  | <a href="{$baseurl}/internal.php/bans/show?id={$objectId}">Ban #{$objectId}</a> | 
            
                                                                                                            
                            
            
                                    
            
            
                | 317 |  |  | HTML; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 318 |  |  |             case 'EmailTemplate': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 319 |  |  |                 /** @var EmailTemplate $emailTemplate */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 320 |  |  |                 $emailTemplate = EmailTemplate::getById($objectId, $database); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 321 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 322 |  |  |                 if ($emailTemplate === false) { | 
                            
                    |  |  |  | 
                                                                                        
                                                                                     | 
            
                                                                                                            
                            
            
                                    
            
            
                | 323 |  |  |                     return 'Email Template #' . $objectId; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 324 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 325 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 326 |  |  |                 $name = htmlentities($emailTemplate->getName(), ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 327 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 328 |  |  |                 return <<<HTML | 
            
                                                                                                            
                            
            
                                    
            
            
                | 329 |  |  | <a href="{$baseurl}/internal.php/emailManagement/view?id={$objectId}">Email Template #{$objectId} ({$name})</a> | 
            
                                                                                                            
                            
            
                                    
            
            
                | 330 |  |  | HTML; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 331 |  |  |             case 'SiteNotice': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 332 |  |  |                 return "<a href=\"{$baseurl}/internal.php/siteNotice\">the site notice</a>"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 333 |  |  |             case 'Request': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 334 |  |  |                 /** @var Request $request */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 335 |  |  |                 $request = Request::getById($objectId, $database); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 336 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 337 |  |  |                 if ($request === false) { | 
                            
                    |  |  |  | 
                                                                                        
                                                                                     | 
            
                                                                                                            
                            
            
                                    
            
            
                | 338 |  |  |                     return 'Request #' . $objectId; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 339 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 340 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 341 |  |  |                 $name = htmlentities($request->getName(), ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 342 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 343 |  |  |                 return <<<HTML | 
            
                                                                                                            
                            
            
                                    
            
            
                | 344 |  |  | <a href="{$baseurl}/internal.php/viewRequest?id={$objectId}">Request #{$objectId} ({$name})</a> | 
            
                                                                                                            
                            
            
                                    
            
            
                | 345 |  |  | HTML; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 346 |  |  |             case 'User': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 347 |  |  |                 /** @var User $user */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 348 |  |  |                 $user = User::getById($objectId, $database); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 349 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 350 |  |  |                 // Some users were merged out of existence | 
            
                                                                                                            
                            
            
                                    
            
            
                | 351 |  |  |                 if ($user === false) { | 
                            
                    |  |  |  | 
                                                                                        
                                                                                     | 
            
                                                                                                            
                            
            
                                    
            
            
                | 352 |  |  |                     return 'User #' . $objectId; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 353 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 354 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 355 |  |  |                 $username = htmlentities($user->getUsername(), ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 356 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 357 |  |  |                 return "<a href=\"{$baseurl}/internal.php/statistics/users/detail?user={$objectId}\">{$username}</a>"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 358 |  |  |             case 'WelcomeTemplate': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 359 |  |  |                 /** @var WelcomeTemplate $welcomeTemplate */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 360 |  |  |                 $welcomeTemplate = WelcomeTemplate::getById($objectId, $database); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 361 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 362 |  |  |                 // some old templates have been completely deleted and lost to the depths of time. | 
            
                                                                                                            
                            
            
                                    
            
            
                | 363 |  |  |                 if ($welcomeTemplate === false) { | 
                            
                    |  |  |  | 
                                                                                        
                                                                                     | 
            
                                                                                                            
                            
            
                                    
            
            
                | 364 |  |  |                     return "Welcome template #{$objectId}"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 365 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 366 |  |  |                 else { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 367 |  |  |                     $userCode = htmlentities($welcomeTemplate->getUserCode(), ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 368 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 369 |  |  |                     return "<a href=\"{$baseurl}/internal.php/welcomeTemplates/view?template={$objectId}\">{$userCode}</a>"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 370 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 371 |  |  |             case 'JobQueue': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 372 |  |  |                 /** @var JobQueue $job */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 373 |  |  |                 $job = JobQueue::getById($objectId, $database); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 374 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 375 |  |  |                 $taskDescriptions = JobQueue::getTaskDescriptions(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 376 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 377 |  |  |                 if ($job === false) { | 
                            
                    |  |  |  | 
                                                                                        
                                                                                     | 
            
                                                                                                            
                            
            
                                    
            
            
                | 378 |  |  |                     return 'Job Queue Task #' . $objectId; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 379 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 380 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 381 |  |  |                 $task = $job->getTask(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 382 |  |  |                 if (isset($taskDescriptions[$task])) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 383 |  |  |                     $description = $taskDescriptions[$task]; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 384 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 385 |  |  |                 else { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 386 |  |  |                     $description = 'Unknown task'; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 387 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 388 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 389 |  |  |                 return "<a href=\"{$baseurl}/internal.php/jobQueue/view?id={$objectId}\">Job #{$job->getId()} ({$description})</a>"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 390 |  |  |             case 'RequestQueue': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 391 |  |  |                 /** @var RequestQueue $queue */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 392 |  |  |                 $queue = RequestQueue::getById($objectId, $database); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 393 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 394 |  |  |                 if ($queue === false) { | 
                            
                    |  |  |  | 
                                                                                        
                                                                                     | 
            
                                                                                                            
                            
            
                                    
            
            
                | 395 |  |  |                     return "Request Queue #{$objectId}"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 396 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 397 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 398 |  |  |                 $queueHeader = htmlentities($queue->getHeader(), ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 399 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 400 |  |  |                 return "<a href=\"{$baseurl}/internal.php/queueManagement/edit?queue={$objectId}\">{$queueHeader}</a>"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 401 |  |  |             case 'Domain': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 402 |  |  |                 /** @var Domain $domain */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 403 |  |  |                 $domain = Domain::getById($objectId, $database); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 404 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 405 |  |  |                 if ($domain === false) { | 
                            
                    |  |  |  | 
                                                                                        
                                                                                     | 
            
                                                                                                            
                            
            
                                    
            
            
                | 406 |  |  |                     return "Domain #{$objectId}"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 407 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 408 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 409 |  |  |                 $domainName = htmlentities($domain->getShortName(), ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 410 |  |  |                 return "<a href=\"{$baseurl}/internal.php/domainManagement/edit?domain={$objectId}\">{$domainName}</a>"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 411 |  |  |             case 'RequestForm': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 412 |  |  |                 /** @var RequestForm $queue */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 413 |  |  |                 $queue = RequestForm::getById($objectId, $database); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 414 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 415 |  |  |                 if ($queue === false) { | 
                            
                    |  |  |  | 
                                                                                        
                                                                                     | 
            
                                                                                                            
                            
            
                                    
            
            
                | 416 |  |  |                     return "Request Form #{$objectId}"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 417 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 418 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 419 |  |  |                 $formName = htmlentities($queue->getName(), ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 420 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 421 |  |  |                 return "<a href=\"{$baseurl}/internal.php/requestFormManagement/edit?form={$objectId}\">{$formName}</a>"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 422 |  |  |             case 'Comment': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 423 |  |  |                 /** @var Comment $comment */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 424 |  |  |                 $comment = Comment::getById($objectId, $database); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 425 |  |  |                 /** @var Request $request */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 426 |  |  |                 $request = Request::getById($comment->getRequest(), $database); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 427 |  |  |                 $requestName = htmlentities($request->getName(), ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 428 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 429 |  |  |                 return "<a href=\"{$baseurl}/internal.php/editComment?id={$objectId}\">Comment {$objectId}</a> on request <a href=\"{$baseurl}/internal.php/viewRequest?id={$comment->getRequest()}#comment-{$objectId}\">#{$comment->getRequest()} ({$requestName})</a>"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 430 |  |  |             default: | 
            
                                                                                                            
                            
            
                                    
            
            
                | 431 |  |  |                 return '[' . $objectType . " " . $objectId . ']'; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 432 |  |  |         } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 433 |  |  |     } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 434 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 435 |  |  |     /** | 
            
                                                                                                            
                            
            
                                    
            
            
                | 436 |  |  |      * @param Log[] $logs | 
            
                                                                                                            
                            
            
                                    
            
            
                | 437 |  |  |      * @throws Exception | 
            
                                                                                                            
                            
            
                                    
            
            
                | 438 |  |  |      * | 
            
                                                                                                            
                            
            
                                    
            
            
                | 439 |  |  |      * @returns User[] | 
            
                                                                                                            
                            
            
                                    
            
            
                | 440 |  |  |      */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 441 |  |  |     private static function loadUsersFromLogs(array $logs, PdoDatabase $database): array | 
            
                                                                                                            
                            
            
                                    
            
            
                | 442 |  |  |     { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 443 |  |  |         $userIds = array(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 444 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 445 |  |  |         foreach ($logs as $logEntry) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 446 |  |  |             if (!$logEntry instanceof Log) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 447 |  |  |                 // if this happens, we've done something wrong with passing back the log data. | 
            
                                                                                                            
                            
            
                                    
            
            
                | 448 |  |  |                 throw new Exception('Log entry is not an instance of a Log, this should never happen.'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 449 |  |  |             } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 450 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 451 |  |  |             $user = $logEntry->getUser(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 452 |  |  |             if ($user === -1) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 453 |  |  |                 continue; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 454 |  |  |             } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 455 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 456 |  |  |             if (!array_search($user, $userIds)) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 457 |  |  |                 $userIds[] = $user; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 458 |  |  |             } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 459 |  |  |         } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 460 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 461 |  |  |         $users = UserSearchHelper::get($database)->inIds($userIds)->fetchMap('username'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 462 |  |  |         $users[-1] = User::getCommunity()->getUsername(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 463 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 464 |  |  |         return $users; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 465 |  |  |     } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 466 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 467 |  |  |     /** | 
            
                                                                                                            
                            
            
                                    
            
            
                | 468 |  |  |      * @param Log[] $logs | 
            
                                                                                                            
                            
            
                                    
            
            
                | 469 |  |  |      * | 
            
                                                                                                            
                            
            
                                    
            
            
                | 470 |  |  |      * @throws Exception | 
            
                                                                                                            
                            
            
                                    
            
            
                | 471 |  |  |      */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 472 |  |  |     public static function prepareLogsForTemplate( | 
            
                                                                                                            
                            
            
                                    
            
            
                | 473 |  |  |         array $logs, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 474 |  |  |         PdoDatabase $database, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 475 |  |  |         SiteConfiguration $configuration, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 476 |  |  |         ISecurityManager $securityManager | 
            
                                                                                                            
                            
            
                                    
            
            
                | 477 |  |  |     ): array { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 478 |  |  |         $users = self::loadUsersFromLogs($logs, $database); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 479 |  |  |         $currentUser = User::getCurrent($database); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 480 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 481 |  |  |         $allowAccountLogSelf = $securityManager->allows('UserData', 'accountLogSelf', $currentUser) === ISecurityManager::ALLOWED; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 482 |  |  |         $allowAccountLog = $securityManager->allows('UserData', 'accountLog', $currentUser) === ISecurityManager::ALLOWED; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 483 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 484 |  |  |         $protectedLogActions = [ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 485 |  |  |             'RequestedReactivation', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 486 |  |  |             'DeactivatedUser', | 
            
                                                                                                            
                            
            
                                    
            
            
                | 487 |  |  |         ]; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 488 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 489 |  |  |         $logData = array(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 490 |  |  |         foreach ($logs as $logEntry) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 491 |  |  |             $objectDescription = self::getObjectDescription($logEntry->getObjectId(), $logEntry->getObjectType(), | 
            
                                                                                                            
                            
            
                                    
            
            
                | 492 |  |  |                 $database, $configuration); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 493 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 494 |  |  |             // initialise to sane default | 
            
                                                                                                            
                            
            
                                    
            
            
                | 495 |  |  |             $comment = null; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 496 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 497 |  |  |             switch ($logEntry->getAction()) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 498 |  |  |                 case 'Renamed': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 499 |  |  |                     $renameData = unserialize($logEntry->getComment()); | 
                            
                    |  |  |  | 
                                                                                        
                                                                                     | 
            
                                                                                                            
                            
            
                                    
            
            
                | 500 |  |  |                     $oldName = htmlentities($renameData['old'], ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 501 |  |  |                     $newName = htmlentities($renameData['new'], ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 502 |  |  |                     $comment = 'Renamed \'' . $oldName . '\' to \'' . $newName . '\'.'; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 503 |  |  |                     break; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 504 |  |  |                 case 'RoleChange': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 505 |  |  |                 case 'GlobalRoleChange': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 506 |  |  |                     $roleChangeData = unserialize($logEntry->getComment()); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 507 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 508 |  |  |                     $removed = array(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 509 |  |  |                     foreach ($roleChangeData['removed'] as $r) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 510 |  |  |                         $removed[] = htmlentities($r, ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 511 |  |  |                     } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 512 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 513 |  |  |                     $added = array(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 514 |  |  |                     foreach ($roleChangeData['added'] as $r) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 515 |  |  |                         $added[] = htmlentities($r, ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 516 |  |  |                     } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 517 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 518 |  |  |                     $reason = htmlentities($roleChangeData['reason'], ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 519 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 520 |  |  |                     $roleDelta = 'Removed [' . implode(', ', $removed) . '], Added [' . implode(', ', $added) . ']'; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 521 |  |  |                     $comment = $roleDelta . ' with comment: ' . $reason; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 522 |  |  |                     break; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 523 |  |  |                 case 'JobIssue': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 524 |  |  |                     $jobIssueData = unserialize($logEntry->getComment()); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 525 |  |  |                     $errorMessage = $jobIssueData['error']; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 526 |  |  |                     $status = $jobIssueData['status']; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 527 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 528 |  |  |                     $comment = 'Job ' . htmlentities($status, ENT_COMPAT, 'UTF-8') . ': '; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 529 |  |  |                     $comment .= htmlentities($errorMessage, ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 530 |  |  |                     break; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 531 |  |  |                 case 'JobIssueRequest': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 532 |  |  |                 case 'JobCompletedRequest': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 533 |  |  |                     $jobData = unserialize($logEntry->getComment()); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 534 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 535 |  |  |                     /** @var JobQueue $job */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 536 |  |  |                     $job = JobQueue::getById($jobData['job'], $database); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 537 |  |  |                     $descs = JobQueue::getTaskDescriptions(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 538 |  |  |                     $comment = htmlentities($descs[$job->getTask()], ENT_COMPAT, 'UTF-8'); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 539 |  |  |                     break; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 540 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 541 |  |  |                 case 'JobCompleted': | 
            
                                                                                                            
                            
            
                                    
            
            
                | 542 |  |  |                     break; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 543 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 544 |  |  |                 default: | 
            
                                                                                                            
                            
            
                                    
            
            
                | 545 |  |  |                     $comment = $logEntry->getComment(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 546 |  |  |                     break; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 547 |  |  |             } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 548 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 549 |  |  |             if (in_array($logEntry->getAction(), $protectedLogActions) && $logEntry->getObjectType() === 'User') { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 550 |  |  |                 if ($allowAccountLog) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 551 |  |  |                     // do nothing, allowed to see all account logs | 
            
                                                                                                            
                            
            
                                    
            
            
                | 552 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 553 |  |  |                 else if ($allowAccountLogSelf && $currentUser->getId() === $logEntry->getObjectId()) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 554 |  |  |                     // do nothing, allowed to see own account log | 
            
                                                                                                            
                            
            
                                    
            
            
                | 555 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 556 |  |  |                 else { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 557 |  |  |                     $comment = null; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 558 |  |  |                 } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 559 |  |  |             } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 560 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 561 |  |  |             $logData[] = array( | 
            
                                                                                                            
                            
            
                                    
            
            
                | 562 |  |  |                 'timestamp'         => $logEntry->getTimestamp(), | 
            
                                                                                                            
                            
            
                                    
            
            
                | 563 |  |  |                 'userid'            => $logEntry->getUser(), | 
            
                                                                                                            
                            
            
                                    
            
            
                | 564 |  |  |                 'username'          => $users[$logEntry->getUser()], | 
            
                                                                                                            
                            
            
                                    
            
            
                | 565 |  |  |                 'description'       => self::getLogDescription($logEntry), | 
            
                                                                                                            
                            
            
                                    
            
            
                | 566 |  |  |                 'objectdescription' => $objectDescription, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 567 |  |  |                 'comment'           => $comment, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 568 |  |  |             ); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 569 |  |  |         } | 
            
                                                                                                            
                            
            
                                    
            
            
                | 570 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 571 |  |  |         return array($users, $logData); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 572 |  |  |     } | 
            
                                                                                                            
                                                                
            
                                    
            
            
                | 573 |  |  | } | 
            
                                                        
            
                                    
            
            
                | 574 |  |  |  |