array:7 [
  "product" => Product {#576
    -_db: DB {#23
      -_prefix: "nl2_"
      -_force_charset: "utf8mb4"
      -_force_collation: "utf8mb4_unicode_ci"
      #_pdo: PDO {#24
        inTransaction: false
        attributes: {
          CASE: NATURAL
          ERRMODE: EXCEPTION
          AUTOCOMMIT: 1
          PERSISTENT: false
          DRIVER_NAME: "mysql"
          SERVER_INFO: "Uptime: 2096270  Threads: 51  Questions: 110472556  Slow queries: 9  Opens: 5513  Open tables: 4000  Queries per second avg: 52.699"
          ORACLE_NULLS: NATURAL
          CLIENT_VERSION: "mysqlnd 8.3.36"
          SERVER_VERSION: "10.11.18-MariaDB-ubu2204"
          STATEMENT_CLASS: array:2 [
            0 => "DebugBar\DataCollector\PDO\TraceablePDOStatement"
            1 => {
              $pdo: DebugBar\DataCollector\PDO\TraceablePDO {#125
                #pdo: PDO {#24}
                #executedStatements: array:42 [
                  0 => DebugBar\DataCollector\PDO\TracedStatement {#26
                    #sql: "SELECT `name`, `value` FROM `nl2_settings` WHERE `module` IS NULL"
                    #rowCount: 54
                    #parameters: []
                    #startTime: 1794700984.7546
                    #endTime: 1794700984.7549
                    #duration: 0.00024819374084473
                    #startMemory: 540384
                    #endMemory: 557712
                    #memoryDelta: 17328
                    #exception: null
                    #preparedId: "00000000000000800000000000000000"
                  }
                  1 => DebugBar\DataCollector\PDO\TracedStatement {#128
                    #sql: "SELECT * FROM nl2_custom_pages WHERE `id` <> ?"
                    #rowCount: 0
                    #parameters: array:1 [
                      1 => 0
                    ]
                    #startTime: 1794700984.7695
                    #endTime: 1794700984.7698
                    #duration: 0.00032997131347656
                    #startMemory: 6640672
                    #endMemory: 6657456
                    #memoryDelta: 16784
                    #exception: null
                    #preparedId: "00000000000000500000000000000000"
                  }
                  2 => DebugBar\DataCollector\PDO\TracedStatement {#80
                    #sql: "SELECT * FROM nl2_integrations WHERE name = ?"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => "Minecraft"
                    ]
                    #startTime: 1794700984.7716
                    #endTime: 1794700984.7718
                    #duration: 0.00017094612121582
                    #startMemory: 6658000
                    #endMemory: 6674656
                    #memoryDelta: 16656
                    #exception: null
                    #preparedId: "00000000000000960000000000000000"
                  }
                  3 => DebugBar\DataCollector\PDO\TracedStatement {#150
                    #sql: "SELECT * FROM nl2_integrations WHERE name = ?"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => "Google"
                    ]
                    #startTime: 1794700984.7719
                    #endTime: 1794700984.772
                    #duration: 0.00014519691467285
                    #startMemory: 6662392
                    #endMemory: 6679032
                    #memoryDelta: 16640
                    #exception: null
                    #preparedId: "00000000000000490000000000000000"
                  }
                  4 => DebugBar\DataCollector\PDO\TracedStatement {#73
                    #sql: "SELECT * FROM nl2_modules WHERE `name` = ?"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => "Core"
                    ]
                    #startTime: 1794700984.774
                    #endTime: 1794700984.7742
                    #duration: 0.0001671314239502
                    #startMemory: 6680936
                    #endMemory: 6697496
                    #memoryDelta: 16560
                    #exception: null
                    #preparedId: "000000000000003e0000000000000000"
                  }
                  5 => DebugBar\DataCollector\PDO\TracedStatement {#62
                    #sql: "SELECT id, link_location, url, icon, title, guest FROM nl2_forms"
                    #rowCount: 1
                    #parameters: []
                    #startTime: 1794700984.7755
                    #endTime: 1794700984.7757
                    #duration: 0.00015902519226074
                    #startMemory: 6995848
                    #endMemory: 7012408
                    #memoryDelta: 16560
                    #exception: null
                    #preparedId: "000000000000003a0000000000000000"
                  }
                  6 => DebugBar\DataCollector\PDO\TracedStatement {#58
                    #sql: "SELECT form_id FROM nl2_forms_permissions WHERE form_id = ? AND post = 1 AND group_id IN(0)"
                    #rowCount: 0
                    #parameters: array:1 [
                      1 => 1
                    ]
                    #startTime: 1794700984.7758
                    #endTime: 1794700984.776
                    #duration: 0.00018692016601562
                    #startMemory: 7001176
                    #endMemory: 7017712
                    #memoryDelta: 16536
                    #exception: null
                    #preparedId: "000000000000003d0000000000000000"
                  }
                  7 => DebugBar\DataCollector\PDO\TracedStatement {#61
                    #sql: "SELECT `name`, `value` FROM `nl2_settings` WHERE `module` = ?"
                    #rowCount: 11
                    #parameters: array:1 [
                      1 => "Store"
                    ]
                    #startTime: 1794700984.7844
                    #endTime: 1794700984.7846
                    #duration: 0.000244140625
                    #startMemory: 8593848
                    #endMemory: 8610568
                    #memoryDelta: 16720
                    #exception: null
                    #preparedId: "00000000000000c10000000000000000"
                  }
                  8 => DebugBar\DataCollector\PDO\TracedStatement {#193
                    #sql: "SELECT * FROM nl2_integrations WHERE name = ?"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => "Discord"
                    ]
                    #startTime: 1794700984.7869
                    #endTime: 1794700984.787
                    #duration: 0.00013089179992676
                    #startMemory: 8655088
                    #endMemory: 8671728
                    #memoryDelta: 16640
                    #exception: null
                    #preparedId: "00000000000000f10000000000000000"
                  }
                  9 => DebugBar\DataCollector\PDO\TracedStatement {#241
                    #sql: "SELECT version, migration_name FROM nl2_phinxlog_lists"
                    #rowCount: 8
                    #parameters: []
                    #startTime: 1794700984.7873
                    #endTime: 1794700984.7874
                    #duration: 0.00012302398681641
                    #startMemory: 8676144
                    #endMemory: 8692704
                    #memoryDelta: 16560
                    #exception: null
                    #preparedId: "00000000000000c70000000000000000"
                  }
                  10 => DebugBar\DataCollector\PDO\TracedStatement {#199
                    #sql: "SELECT * FROM nl2_lists WHERE provider IS NOT NULL AND url IS NOT NULL"
                    #rowCount: 2
                    #parameters: []
                    #startTime: 1794700984.7885
                    #endTime: 1794700984.7887
                    #duration: 0.00015401840209961
                    #startMemory: 8688184
                    #endMemory: 8704968
                    #memoryDelta: 16784
                    #exception: null
                    #preparedId: "00000000000001060000000000000000"
                  }
                  11 => DebugBar\DataCollector\PDO\TracedStatement {#262
                    #sql: "SELECT * FROM `nl2_lists_submissions` WHERE `vanity_url` IS NOT NULL"
                    #rowCount: 1
                    #parameters: []
                    #startTime: 1794700984.7887
                    #endTime: 1794700984.7889
                    #duration: 0.00016903877258301
                    #startMemory: 8691656
                    #endMemory: 8708712
                    #memoryDelta: 17056
                    #exception: null
                    #preparedId: "00000000000000fe0000000000000000"
                  }
                  12 => DebugBar\DataCollector\PDO\TracedStatement {#254
                    #sql: "SELECT * FROM nl2_oauth2_applications WHERE nameless = 1 AND enabled = 1"
                    #rowCount: 0
                    #parameters: []
                    #startTime: 1794700984.7892
                    #endTime: 1794700984.7893
                    #duration: 0.00016188621520996
                    #startMemory: 8709664
                    #endMemory: 8726432
                    #memoryDelta: 16768
                    #exception: null
                    #preparedId: "00000000000000c20000000000000000"
                  }
                  13 => DebugBar\DataCollector\PDO\TracedStatement {#194
                    #sql: "SELECT * FROM nl2_integrations WHERE name = ?"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => "Patreon"
                    ]
                    #startTime: 1794700984.7917
                    #endTime: 1794700984.7919
                    #duration: 0.00017213821411133
                    #startMemory: 9055632
                    #endMemory: 9072272
                    #memoryDelta: 16640
                    #exception: null
                    #preparedId: "00000000000001190000000000000000"
                  }
                  14 => DebugBar\DataCollector\PDO\TracedStatement {#281
                    #sql: "SELECT * FROM nl2_groups WHERE `default_group` = ?"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => "1"
                    ]
                    #startTime: 1794700984.7937
                    #endTime: 1794700984.7939
                    #duration: 0.00020718574523926
                    #startMemory: 9066368
                    #endMemory: 9083168
                    #memoryDelta: 16800
                    #exception: null
                    #preparedId: "000000000000012a0000000000000000"
                  }
                  15 => DebugBar\DataCollector\PDO\TracedStatement {#298
                    #sql: "SELECT * FROM nl2_online_guests WHERE `ip` = ?"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => "216.73.216.72"
                    ]
                    #startTime: 1794700984.7941
                    #endTime: 1794700984.801
                    #duration: 0.0069649219512939
                    #startMemory: 9073104
                    #endMemory: 9089680
                    #memoryDelta: 16576
                    #exception: null
                    #preparedId: "000000000000011a0000000000000000"
                  }
                  16 => DebugBar\DataCollector\PDO\TracedStatement {#282
                    #sql: "UPDATE nl2_online_guests SET `last_seen` = ? WHERE `id` = ?"
                    #rowCount: 0
                    #parameters: array:2 [
                      1 => "1794700984"
                      2 => 17751
                    ]
                    #startTime: 1794700984.8011
                    #endTime: 1794700984.8014
                    #duration: 0.00026583671569824
                    #startMemory: 9077192
                    #endMemory: 9077360
                    #memoryDelta: 168
                    #exception: null
                    #preparedId: "000000000000012b0000000000000000"
                  }
                  17 => DebugBar\DataCollector\PDO\TracedStatement {#299
                    #sql: "SELECT * FROM nl2_store_categories WHERE id = ? AND disabled = 0 AND deleted = 0"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => "1"
                    ]
                    #startTime: 1794700984.8016
                    #endTime: 1794700984.8018
                    #duration: 0.00019717216491699
                    #startMemory: 9079600
                    #endMemory: 9096384
                    #memoryDelta: 16784
                    #exception: null
                    #preparedId: "000000000000012d0000000000000000"
                  }
                  18 => DebugBar\DataCollector\PDO\TracedStatement {#301
                    #sql: "SELECT * FROM nl2_page_descriptions WHERE `page` = ?"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => "/store"
                    ]
                    #startTime: 1794700984.8019
                    #endTime: 1794700984.802
                    #duration: 0.00014519691467285
                    #startMemory: 9084488
                    #endMemory: 9101112
                    #memoryDelta: 16624
                    #exception: null
                    #preparedId: "000000000000012f0000000000000000"
                  }
                  19 => DebugBar\DataCollector\PDO\TracedStatement {#303
                    #sql: "SELECT * FROM nl2_store_products WHERE category_id = ? AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC"
                    #rowCount: 8
                    #parameters: array:1 [
                      1 => 1
                    ]
                    #startTime: 1794700984.8074
                    #endTime: 1794700984.8077
                    #duration: 0.00025701522827148
                    #startMemory: 9671520
                    #endMemory: 9688888
                    #memoryDelta: 17368
                    #exception: null
                    #preparedId: "00000000000001810000000000000000"
                  }
                  20 => DebugBar\DataCollector\PDO\TracedStatement {#385
                    #sql: "SELECT * FROM nl2_store_sales WHERE start_date < ? AND expire_date > ? ORDER BY `expire_date` DESC"
                    #rowCount: 0
                    #parameters: array:2 [
                      1 => "1794700984"
                      2 => "1794700984"
                    ]
                    #startTime: 1794700984.809
                    #endTime: 1794700984.8092
                    #duration: 0.00014495849609375
                    #startMemory: 9691704
                    #endMemory: 9708440
                    #memoryDelta: 16736
                    #exception: null
                    #preparedId: "00000000000002450000000000000000"
                  }
                  21 => DebugBar\DataCollector\PDO\TracedStatement {#581
                    #sql: "SELECT * FROM nl2_store_categories WHERE parent_category IS NULL AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC"
                    #rowCount: 2
                    #parameters: []
                    #startTime: 1794700984.813
                    #endTime: 1794700984.8132
                    #duration: 0.00016188621520996
                    #startMemory: 9715344
                    #endMemory: 9732080
                    #memoryDelta: 16736
                    #exception: null
                    #preparedId: "00000000000002420000000000000000"
                  }
                  22 => DebugBar\DataCollector\PDO\TracedStatement {#578
                    #sql: "SELECT id, `name`, `url` FROM nl2_store_categories WHERE parent_category = ? AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC"
                    #rowCount: 0
                    #parameters: array:1 [
                      1 => 1
                    ]
                    #startTime: 1794700984.8133
                    #endTime: 1794700984.8135
                    #duration: 0.00017595291137695
                    #startMemory: 9721952
                    #endMemory: 9738608
                    #memoryDelta: 16656
                    #exception: null
                    #preparedId: "00000000000002220000000000000000"
                  }
                  23 => DebugBar\DataCollector\PDO\TracedStatement {#546
                    #sql: "SELECT id, `name`, `url` FROM nl2_store_categories WHERE parent_category = ? AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC"
                    #rowCount: 0
                    #parameters: array:1 [
                      1 => 2
                    ]
                    #startTime: 1794700984.8135
                    #endTime: 1794700984.8137
                    #duration: 0.00012803077697754
                    #startMemory: 9727032
                    #endMemory: 9743688
                    #memoryDelta: 16656
                    #exception: null
                    #preparedId: "00000000000001830000000000000000"
                  }
                  24 => DebugBar\DataCollector\PDO\TracedStatement {#387
                    #sql: "SELECT * FROM nl2_mc_servers WHERE `is_default` = ?"
                    #rowCount: 0
                    #parameters: array:1 [
                      1 => 1
                    ]
                    #startTime: 1794700984.8143
                    #endTime: 1794700984.8144
                    #duration: 0.00010514259338379
                    #startMemory: 9744064
                    #endMemory: 9761048
                    #memoryDelta: 16984
                    #exception: null
                    #preparedId: "000000000000018b0000000000000000"
                  }
                  25 => DebugBar\DataCollector\PDO\TracedStatement {#395
                    #sql: "SELECT * FROM nl2_lists WHERE link_location IS NOT NULL"
                    #rowCount: 2
                    #parameters: []
                    #startTime: 1794700984.8167
                    #endTime: 1794700984.8168
                    #duration: 0.00012016296386719
                    #startMemory: 9875936
                    #endMemory: 9892720
                    #memoryDelta: 16784
                    #exception: null
                    #preparedId: "00000000000002290000000000000000"
                  }
                  26 => DebugBar\DataCollector\PDO\TracedStatement {#553
                    #sql: "SELECT * FROM nl2_lists_submissions ORDER BY created DESC LIMIT 6"
                    #rowCount: 6
                    #parameters: []
                    #startTime: 1794700984.8174
                    #endTime: 1794700984.8176
                    #duration: 0.00016188621520996
                    #startMemory: 9883784
                    #endMemory: 9900920
                    #memoryDelta: 17136
                    #exception: null
                    #preparedId: "00000000000002190000000000000000"
                  }
                  27 => DebugBar\DataCollector\PDO\TracedStatement {#537
                    #sql: "SELECT * FROM nl2_users WHERE `id` = ?"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => "5"
                    ]
                    #startTime: 1794700984.8179
                    #endTime: 1794700984.818
                    #duration: 0.00015711784362793
                    #startMemory: 9898712
                    #endMemory: 9915960
                    #memoryDelta: 17248
                    #exception: null
                    #preparedId: "00000000000002130000000000000000"
                  }
                  28 => DebugBar\DataCollector\PDO\TracedStatement {#531
                    #sql: "SELECT nl2_groups.* FROM nl2_users_groups INNER JOIN nl2_groups ON group_id = nl2_groups.id WHERE user_id = ? AND deleted = 0 ORDER BY `order`"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => 5
                    ]
                    #startTime: 1794700984.8182
                    #endTime: 1794700984.8186
                    #duration: 0.00042080879211426
                    #startMemory: 9904528
                    #endMemory: 9921440
                    #memoryDelta: 16912
                    #exception: null
                    #preparedId: "00000000000002100000000000000000"
                  }
                  29 => DebugBar\DataCollector\PDO\TracedStatement {#528
                    #sql: "SELECT * FROM nl2_users WHERE `id` = ?"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => "1"
                    ]
                    #startTime: 1794700984.8188
                    #endTime: 1794700984.8189
                    #duration: 0.00014591217041016
                    #startMemory: 9909240
                    #endMemory: 9926488
                    #memoryDelta: 17248
                    #exception: null
                    #preparedId: "00000000000002140000000000000000"
                  }
                  30 => DebugBar\DataCollector\PDO\TracedStatement {#532
                    #sql: "SELECT nl2_groups.* FROM nl2_users_groups INNER JOIN nl2_groups ON group_id = nl2_groups.id WHERE user_id = ? AND deleted = 0 ORDER BY `order`"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => 1
                    ]
                    #startTime: 1794700984.819
                    #endTime: 1794700984.8194
                    #duration: 0.00036501884460449
                    #startMemory: 9913768
                    #endMemory: 9930680
                    #memoryDelta: 16912
                    #exception: null
                    #preparedId: "000000000000020c0000000000000000"
                  }
                  31 => DebugBar\DataCollector\PDO\TracedStatement {#524
                    #sql: "ALTER TABLE `nl2_resources` ADD `short_description` varchar(64) NULL DEFAULT NULL"
                    #rowCount: 0
                    #parameters: []
                    #startTime: 1794700984.8201
                    #endTime: 1794700984.9347
                    #duration: 0.11460590362549
                    #startMemory: 9912216
                    #endMemory: 9917248
                    #memoryDelta: 5032
                    #exception: PDOException {#526
                      #message: "SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'short_description'"
                      #code: "42S21"
                      #file: "/data/vendor/maximebf/debugbar/src/DebugBar/DataCollector/PDO/TraceablePDOStatement.php"
                      #line: 113
                      +errorInfo: array:3 [
                        0 => "42S21"
                        1 => 1060
                        2 => "Duplicate column name 'short_description'"
                      ]
                      trace: {
                        /data/vendor/maximebf/debugbar/src/DebugBar/DataCollector/PDO/TraceablePDOStatement.php:113 {
                          DebugBar\DataCollector\PDO\TraceablePDOStatement->execute($input_parameters = null): bool …
                          › try {
                          ›     $result = parent::execute($input_parameters);
                          › } catch (PDOException $e) {
                          arguments: {
                            $params: null
                          }
                        }
                        /data/core/classes/Database/DB.php:289 {
                          DB->query(string $sql, array $params = [], ?bool $isSelect = null) …
                          › 
                          › if ($this->_statement->execute()) {
                          ›     // Only fetch the results if this is a SELECT query.
                        }
                        /data/modules/Resources/module.php:184 {
                          Resources_Module::updateTo160($cache) …
                          › try {
                          ›     DB::getInstance()->query('ALTER TABLE `nl2_resources` ADD `short_description` varchar(64) NULL DEFAULT NULL');
                          ›     DB::getInstance()->query('ALTER TABLE `nl2_resources` ADD `has_icon` tinyint(1) NOT NULL DEFAULT \'0\'');
                          arguments: {
                            $sql: "ALTER TABLE `nl2_resources` ADD `short_description` varchar(64) NULL DEFAULT NULL"
                          }
                        }
                        /data/modules/Resources/module.php:88 {
                          Resources_Module->onPageLoad($user, $pages, $cache, $smarty, $navs, $widgets, $template) …
                          › if (!$cache->isCached('160')) {
                          ›     self::updateTo160($cache);
                          › }
                          arguments: {
                            $cache: Cache {#22 …}
                          }
                        }
                        /data/core/classes/Core/Module.php:63 {
                          Module::loadPage(User $user, Pages $pages, Cache $cache, $smarty, iterable $navs, Widgets $widgets, TemplateBase $template): void …
                          › foreach (self::getModules() as $module) {
                          ›     $module->onPageLoad($user, $pages, $cache, $smarty, $navs, $widgets, $template);
                          › }
                          arguments: {
                            $user: User {#115 …}
                            $pages: Pages {#97 …}
                            $cache: Cache {#22 …}
                            $smarty: FakeSmarty {#314 …}
                            $navs: array:3 [ …3]
                            $widgets: Widgets {#313 …}
                            $template: DefaultRevamp_Template {#305 …}
                          }
                        }
                        /data/modules/Store/pages/store/store.php:187 {
                          require …
                          › // Load modules + template\r
                          › Module::loadPage($user, $pages, $cache, $smarty, [$navigation, $cc_nav, $staffcp_nav], $widgets, $template);\r
                          › \r
                          arguments: {
                            $user: User {#115 …}
                            $pages: Pages {#97 …}
                            $cache: Cache {#22 …}
                            $smarty: FakeSmarty {#314 …}
                            $navs: array:3 [ …3]
                            $widgets: Widgets {#313 …}
                            $template: DefaultRevamp_Template {#305 …}
                          }
                        }
                        /data/index.php:142 {
                          › $pages->setActivePage($all_pages[$new_path]);
                          › require($path);
                          › die;
                          arguments: {
                            "/data/modules/Store/pages/store/store.php"
                          }
                        }
                      }
                    }
                    #preparedId: "000000000000020a0000000000000000"
                  }
                  32 => DebugBar\DataCollector\PDO\TracedStatement {#522
                    #sql: "SELECT *, TRUNCATE(currently_entitled_amount_cents / pledge_cadence, 0) AS amount FROM nl2_patreon_users WHERE status = 'active_patron' AND last_charge_status = 'Paid' ORDER BY amount DESC"
                    #rowCount: 0
                    #parameters: []
                    #startTime: 1794700984.9357
                    #endTime: 1794700984.936
                    #duration: 0.00030088424682617
                    #startMemory: 9923824
                    #endMemory: 9940720
                    #memoryDelta: 16896
                    #exception: null
                    #preparedId: "00000000000002160000000000000000"
                  }
                  33 => DebugBar\DataCollector\PDO\TracedStatement {#534
                    #sql: "SELECT U.id FROM nl2_users AS U JOIN nl2_users_groups AS UG ON (U.id = UG.user_id) JOIN nl2_groups AS G ON (UG.group_id = G.id) WHERE G.order = (SELECT min(iG.`order`) FROM nl2_users_groups AS iUG JOIN nl2_groups AS iG ON (iUG.group_id = iG.id) WHERE iUG.user_id = U.id GROUP BY iUG.user_id ORDER BY NULL) AND U.last_online > 1794700684 AND G.staff = 1"
                    #rowCount: 0
                    #parameters: []
                    #startTime: 1794700984.939
                    #endTime: 1794700984.9394
                    #duration: 0.00030899047851562
                    #startMemory: 9942096
                    #endMemory: 9958504
                    #memoryDelta: 16408
                    #exception: null
                    #preparedId: "000000000000020b0000000000000000"
                  }
                  34 => DebugBar\DataCollector\PDO\TracedStatement {#523
                    #sql: "SELECT `name`, `value` FROM `nl2_settings` WHERE `module` = ?"
                    #rowCount: 0
                    #parameters: array:1 [
                      1 => "Forum"
                    ]
                    #startTime: 1794700984.94
                    #endTime: 1794700984.9402
                    #duration: 0.00020980834960938
                    #startMemory: 9960376
                    #endMemory: 9976904
                    #memoryDelta: 16528
                    #exception: null
                    #preparedId: "000000000000019c0000000000000000"
                  }
                  35 => DebugBar\DataCollector\PDO\TracedStatement {#412
                    #sql: "SELECT forum_id FROM nl2_forums_permissions WHERE group_id IN (0) AND `view` = 1 AND view_other_topics = 1"
                    #rowCount: 2
                    #parameters: []
                    #startTime: 1794700984.9404
                    #endTime: 1794700984.9406
                    #duration: 0.00019288063049316
                    #startMemory: 9962784
                    #endMemory: 9979224
                    #memoryDelta: 16440
                    #exception: null
                    #preparedId: "000000000000019b0000000000000000"
                  }
                  36 => DebugBar\DataCollector\PDO\TracedStatement {#411
                    #sql: """
                      SELECT topics.id as id, topics.forum_id as forum_id, topics.topic_title as topic_title, topics.topic_creator as topic_creator, topics.topic_last_user as topic_last_user, topics.topic_date as topic_date, topics.topic_reply_date as topic_reply_date, topics.topic_views as topic_views, topics.locked as locked, topics.sticky as sticky, topics.label as label, topics.deleted as deleted, posts.id as last_post_id\n
                                  FROM nl2_topics topics \n
                                  LEFT JOIN nl2_posts posts ON topics.id = posts.topic_id AND posts.id = (SELECT MAX(id) FROM nl2_posts p WHERE p.topic_id = topics.id AND p.deleted = 0) \n
                                  WHERE topics.deleted = 0 AND topics.forum_id IN (1,2) ORDER BY topics.topic_reply_date DESC LIMIT 5
                      """
                    #rowCount: 2
                    #parameters: []
                    #startTime: 1794700984.9407
                    #endTime: 1794700984.9411
                    #duration: 0.00036716461181641
                    #startMemory: 9969768
                    #endMemory: 9986504
                    #memoryDelta: 16736
                    #exception: null
                    #preparedId: "00000000000001980000000000000000"
                  }
                  37 => DebugBar\DataCollector\PDO\TracedStatement {#408
                    #sql: "SELECT * FROM nl2_forums WHERE `id` = ?"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => 2
                    ]
                    #startTime: 1794700984.9412
                    #endTime: 1794700984.9414
                    #duration: 0.0001981258392334
                    #startMemory: 9975576
                    #endMemory: 9992592
                    #memoryDelta: 17016
                    #exception: null
                    #preparedId: "00000000000001990000000000000000"
                  }
                  38 => DebugBar\DataCollector\PDO\TracedStatement {#409
                    #sql: "SELECT COUNT(*) as c FROM nl2_posts WHERE `topic_id` = ? AND `deleted` = 0"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => 2
                    ]
                    #startTime: 1794700984.9417
                    #endTime: 1794700984.9419
                    #duration: 0.00020885467529297
                    #startMemory: 9980224
                    #endMemory: 9996760
                    #memoryDelta: 16536
                    #exception: null
                    #preparedId: "00000000000001950000000000000000"
                  }
                  39 => DebugBar\DataCollector\PDO\TracedStatement {#405
                    #sql: "SELECT nl2_users_integrations.*, nl2_integrations.name as integration_name FROM nl2_users_integrations LEFT JOIN nl2_integrations ON integration_id=nl2_integrations.id WHERE user_id = ?"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => 1
                    ]
                    #startTime: 1794700984.9421
                    #endTime: 1794700984.9424
                    #duration: 0.00023508071899414
                    #startMemory: 9988384
                    #endMemory: 10005328
                    #memoryDelta: 16944
                    #exception: null
                    #preparedId: "00000000000001900000000000000000"
                  }
                  40 => DebugBar\DataCollector\PDO\TracedStatement {#400
                    #sql: "SELECT * FROM nl2_forums WHERE `id` = ?"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => 2
                    ]
                    #startTime: 1794700984.9427
                    #endTime: 1794700984.9429
                    #duration: 0.00018596649169922
                    #startMemory: 9994248
                    #endMemory: 10011264
                    #memoryDelta: 17016
                    #exception: null
                    #preparedId: "000000000000018f0000000000000000"
                  }
                  41 => DebugBar\DataCollector\PDO\TracedStatement {#399
                    #sql: "SELECT COUNT(*) as c FROM nl2_posts WHERE `topic_id` = ? AND `deleted` = 0"
                    #rowCount: 1
                    #parameters: array:1 [
                      1 => 1
                    ]
                    #startTime: 1794700984.9432
                    #endTime: 1794700984.9434
                    #duration: 0.00022697448730469
                    #startMemory: 9999424
                    #endMemory: 10015960
                    #memoryDelta: 16536
                    #exception: null
                    #preparedId: "00000000000001890000000000000000"
                  }
                ]
                inTransaction: false
                attributes: {
                  CASE: NATURAL
                  ERRMODE: EXCEPTION
                  AUTOCOMMIT: 1
                  PERSISTENT: false
                  DRIVER_NAME: "mysql"
                  SERVER_INFO: "Uptime: 2096270  Threads: 51  Questions: 110472556  Slow queries: 9  Opens: 5513  Open tables: 4000  Queries per second avg: 52.699"
                  ORACLE_NULLS: NATURAL
                  CLIENT_VERSION: "mysqlnd 8.3.36"
                  SERVER_VERSION: "10.11.18-MariaDB-ubu2204"
                  STATEMENT_CLASS: array:2 [
                    0 => "DebugBar\DataCollector\PDO\TraceablePDOStatement"
                    1 => {
                      $pdo: DebugBar\DataCollector\PDO\TraceablePDO {#125}
                    }
                  ]
                  EMULATE_PREPARES: 1
                  CONNECTION_STATUS: "database via TCP/IP"
                  STRINGIFY_FETCHES: false
                  DEFAULT_FETCH_MODE: BOTH
                }
              }
            }
          ]
          EMULATE_PREPARES: 1
          CONNECTION_STATUS: "database via TCP/IP"
          STRINGIFY_FETCHES: false
          DEFAULT_FETCH_MODE: BOTH
        }
      }
      -_statement: DebugBar\DataCollector\PDO\TraceablePDOStatement {#393
        +queryString: "SELECT COUNT(*) as c FROM nl2_posts WHERE `topic_id` = ? AND `deleted` = 0"
        #pdo: DebugBar\DataCollector\PDO\TraceablePDO {#125}
        #boundParameters: array:1 [
          1 => 1
        ]
      }
      -_error: false
      -_results: array:1 [
        0 => {#344
          +"c": 9
        }
      ]
      -_count: 1
      #_query_recorder: QueryRecorder {#25
        -_query_stack: array:43 [
          0 => array:4 [
            "number" => 1
            "frame" => array:6 [
              "number" => 1
              "file" => "/data/core/classes/Database/PhinxAdapter.php"
              "line" => 50
              "start_line" => 30
              "highlight_line" => 21
              "code" => """
                \n
                        if (!$migrationDir) {\n
                            $migrationDir = __DIR__ . &#039;/../../migrations&#039;;\n
                        }\n
                \n
                        $migration_files = array_map(\n
                            static function ($file_name) {\n
                                [$version, $migration_name] = explode(&#039;_&#039;, $file_name, 2);\n
                                $migration_name = str_replace([&#039;.php&#039;, &#039;_&#039;], &#039;&#039;, ucwords($migration_name, &#039;_&#039;));\n
                \n
                                return $version . &#039;_&#039; . $migration_name;\n
                            },\n
                            array_filter(scandir($migrationDir), static function ($file_name) {\n
                                // Pattern that matches Phinx migration file names (eg: 20230403000000_create_stroopwafel_table.php)\n
                                return preg_match(&#039;/^\d{14}_\w+\.php$/&#039;, $file_name);\n
                            }),\n
                        );\n
                \n
                        $migration_database_entries = array_map(static function ($row) {\n
                            return $row-&gt;version . &#039;_&#039; . $row-&gt;migration_name;\n
                        }, DB::getInstance()-&gt;query(&quot;SELECT version, migration_name FROM $table&quot;)-&gt;results());\n
                \n
                        $missing = array_diff($migration_files, $migration_database_entries);\n
                        $extra = array_diff($migration_database_entries, $migration_files);\n
                \n
                        if ($returnResults) {\n
                            return [\n
                                &#039;missing&#039; =&gt; count($missing),\n
                                &#039;extra&#039; =&gt; count($extra),\n
                            ];\n
                        }\n
                \n
                        // Likely a pull from the repo dev branch or migrations\n
                        // weren&#039;t run during an upgrade script.\n
                        if (($missing_count = count($missing)) &gt; 0) {\n
                            echo &quot;There are $missing_count migrations files which have not been executed:&quot; . &#039;&lt;br&gt;&#039;;\n
                            foreach ($missing as $missing_migration) {\n
                                echo &quot; - $missing_migration&quot; . &#039;&lt;br&gt;&#039;;\n
                            }\n
                        }\n
                \n
                """
            ]
            "sql_string" => "SELECT version, migration_name FROM nl2_phinxlog"
            "sql_params" => []
          ]
          1 => array:4 [
            "number" => 2
            "frame" => array:6 [
              "number" => 2
              "file" => "/data/core/classes/Core/Settings.php"
              "line" => 43
              "start_line" => 23
              "highlight_line" => 21
              "code" => """
                    private static function setSettingsCache(?string $module, array $cache): void\n
                    {\n
                        $cache_name = $module !== null ? $module : &#039;core&#039;;\n
                        self::$_cached_settings[$cache_name] = $cache;\n
                    }\n
                \n
                    /**\n
                     * Get a setting from the database table `nl2_settings`.\n
                     *\n
                     * @param  string  $setting  Setting to check.\n
                     * @param  ?string $fallback Fallback to return if $setting is not set in DB. Defaults to null.\n
                     * @param  string  $module   Module name to keep settings separate from other modules. Set module\n
                     *                           to &#039;Core&#039; for global settings.\n
                     * @return ?string Setting from DB or $fallback.\n
                     */\n
                    public static function get(string $setting, ?string $fallback = null, string $module = &#039;core&#039;): ?string\n
                    {\n
                        if (!self::hasSettingsCache($module)) {\n
                            // Load all settings for this module and store it as a dictionary\n
                            if ($module === &#039;core&#039;) {\n
                                $result = DB::getInstance()-&gt;query(&#039;SELECT `name`, `value` FROM `nl2_settings` WHERE `module` IS NULL&#039;)-&gt;results();\n
                            } else {\n
                                $result = DB::getInstance()-&gt;query(&#039;SELECT `name`, `value` FROM `nl2_settings` WHERE `module` = ?&#039;, [$module])-&gt;results();\n
                            }\n
                \n
                            $cache = [];\n
                            foreach ($result as $row) {\n
                                $cache[$row-&gt;name] = $row-&gt;value;\n
                            }\n
                            self::setSettingsCache($module, $cache);\n
                        }\n
                \n
                        $cache = &amp;self::getSettingsCache($module);\n
                \n
                        return $cache[$setting] ?? $fallback;\n
                    }\n
                \n
                    /**\n
                     * Modify a setting in the database table `nl2_settings`.\n
                     *\n
                     * @param string      $setting   Setting name.\n
                """
            ]
            "sql_string" => "SELECT `name`, `value` FROM `nl2_settings` WHERE `module` IS NULL"
            "sql_params" => []
          ]
          2 => array:4 [
            "number" => 3
            "frame" => array:6 [
              "number" => 3
              "file" => "/data/modules/Core/module.php"
              "line" => 146
              "start_line" => 126
              "highlight_line" => 21
              "code" => """
                        }\n
                \n
                        // &quot;More&quot; dropdown\n
                        $cache-&gt;setCache(&#039;navbar_icons&#039;);\n
                        if ($cache-&gt;isCached(&#039;more_dropdown_icon&#039;)) {\n
                            $icon = $cache-&gt;retrieve(&#039;more_dropdown_icon&#039;);\n
                        } else {\n
                            $icon = &#039;&#039;;\n
                        }\n
                \n
                        $cache-&gt;setCache(&#039;navbar_order&#039;);\n
                        if ($cache-&gt;isCached(&#039;more_dropdown_order&#039;)) {\n
                            $order = $cache-&gt;retrieve(&#039;more_dropdown_order&#039;);\n
                        } else {\n
                            $order = 2500;\n
                        }\n
                \n
                        $navigation-&gt;addDropdown(&#039;more_dropdown&#039;, $language-&gt;get(&#039;general&#039;, &#039;more&#039;), &#039;top&#039;, $order, $icon);\n
                \n
                        // Custom pages\n
                        $custom_pages = DB::getInstance()-&gt;get(&#039;custom_pages&#039;, [&#039;id&#039;, &#039;&lt;&gt;&#039;, 0])-&gt;results();\n
                        if (count($custom_pages)) {\n
                            $more = [];\n
                            $cache-&gt;setCache(&#039;navbar_order&#039;);\n
                \n
                            if ($user-&gt;isLoggedIn()) {\n
                                // Check all groups\n
                                $user_groups = $user-&gt;getAllGroupIds();\n
                \n
                                foreach ($custom_pages as $custom_page) {\n
                                    $redirect = null;\n
                \n
                                    // Get redirect URL if enabled\n
                                    if ($custom_page-&gt;redirect == 1) {\n
                                        $redirect = $custom_page-&gt;link;\n
                                    }\n
                \n
                                    $pages-&gt;addCustom(Output::urlEncodeAllowSlashes($custom_page-&gt;url), Output::getClean($custom_page-&gt;title), !$custom_page-&gt;basic);\n
                \n
                                    foreach ($user_groups as $user_group) {\n
                                        $custom_page_permissions = DB::getInstance()-&gt;get(&#039;custom_pages_permissions&#039;, [&#039;group_id&#039;, $user_group])-&gt;results();\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_custom_pages WHERE `id` <> ?"
            "sql_params" => array:1 [
              0 => 0
            ]
          ]
          3 => array:4 [
            "number" => 4
            "frame" => array:6 [
              "number" => 4
              "file" => "/data/core/classes/Integrations/IntegrationBase.php"
              "line" => 27
              "start_line" => 7
              "highlight_line" => 21
              "code" => """
                 * @author Partydragen\n
                 * @version 2.1.0\n
                 * @license MIT\n
                 */\n
                abstract class IntegrationBase\n
                {\n
                    private DB $_db;\n
                    private IntegrationData $_data;\n
                    protected string $_icon;\n
                    private array $_errors = [];\n
                    protected Language $_language;\n
                    protected ?string $_settings = null;\n
                \n
                    protected string $_name;\n
                    protected ?int $_order;\n
                \n
                    public function __construct()\n
                    {\n
                        $this-&gt;_db = DB::getInstance();\n
                \n
                        $integration = $this-&gt;_db-&gt;query(&#039;SELECT * FROM nl2_integrations WHERE name = ?&#039;, [$this-&gt;_name]);\n
                        if ($integration-&gt;count()) {\n
                            $integration = $integration-&gt;first();\n
                \n
                            $this-&gt;_data = new IntegrationData($integration);\n
                            $this-&gt;_order = $integration-&gt;order;\n
                        } else {\n
                            // Register integration to database\n
                            $this-&gt;_db-&gt;query(&#039;INSERT INTO nl2_integrations (name) VALUES (?)&#039;, [\n
                                $this-&gt;_name,\n
                            ]);\n
                \n
                            $integration = $this-&gt;_db-&gt;query(&#039;SELECT * FROM nl2_integrations WHERE name = ?&#039;, [$this-&gt;_name])-&gt;first();\n
                \n
                            $this-&gt;_data = new IntegrationData($integration);\n
                            $this-&gt;_order = $integration-&gt;order;\n
                        }\n
                    }\n
                \n
                    /**\n
                     * Get the name of this integration.\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_integrations WHERE name = ?"
            "sql_params" => array:1 [
              0 => "Minecraft"
            ]
          ]
          4 => array:4 [
            "number" => 5
            "frame" => array:6 [
              "number" => 5
              "file" => "/data/core/classes/Integrations/IntegrationBase.php"
              "line" => 27
              "start_line" => 7
              "highlight_line" => 21
              "code" => """
                 * @author Partydragen\n
                 * @version 2.1.0\n
                 * @license MIT\n
                 */\n
                abstract class IntegrationBase\n
                {\n
                    private DB $_db;\n
                    private IntegrationData $_data;\n
                    protected string $_icon;\n
                    private array $_errors = [];\n
                    protected Language $_language;\n
                    protected ?string $_settings = null;\n
                \n
                    protected string $_name;\n
                    protected ?int $_order;\n
                \n
                    public function __construct()\n
                    {\n
                        $this-&gt;_db = DB::getInstance();\n
                \n
                        $integration = $this-&gt;_db-&gt;query(&#039;SELECT * FROM nl2_integrations WHERE name = ?&#039;, [$this-&gt;_name]);\n
                        if ($integration-&gt;count()) {\n
                            $integration = $integration-&gt;first();\n
                \n
                            $this-&gt;_data = new IntegrationData($integration);\n
                            $this-&gt;_order = $integration-&gt;order;\n
                        } else {\n
                            // Register integration to database\n
                            $this-&gt;_db-&gt;query(&#039;INSERT INTO nl2_integrations (name) VALUES (?)&#039;, [\n
                                $this-&gt;_name,\n
                            ]);\n
                \n
                            $integration = $this-&gt;_db-&gt;query(&#039;SELECT * FROM nl2_integrations WHERE name = ?&#039;, [$this-&gt;_name])-&gt;first();\n
                \n
                            $this-&gt;_data = new IntegrationData($integration);\n
                            $this-&gt;_order = $integration-&gt;order;\n
                        }\n
                    }\n
                \n
                    /**\n
                     * Get the name of this integration.\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_integrations WHERE name = ?"
            "sql_params" => array:1 [
              0 => "Google"
            ]
          ]
          5 => array:4 [
            "number" => 6
            "frame" => array:6 [
              "number" => 6
              "file" => "/data/core/classes/Core/Module.php"
              "line" => 206
              "start_line" => 186
              "highlight_line" => 21
              "code" => """
                \n
                    /**\n
                     * Get this module&#039;s ID.\n
                     *\n
                     * @return int The ID for the module\n
                     */\n
                    public function getId(): int\n
                    {\n
                        return DB::getInstance()-&gt;query(&#039;SELECT `id` FROM nl2_modules WHERE `name` = ?&#039;, [$this-&gt;_name])-&gt;first()-&gt;id;\n
                    }\n
                \n
                    /**\n
                     * Get a module ID from name.\n
                     *\n
                     * @param string $name Module name\n
                     *\n
                     * @return ?int Module ID\n
                     */\n
                    public static function getIdFromName(string $name): ?int\n
                    {\n
                        $query = DB::getInstance()-&gt;get(&#039;modules&#039;, [&#039;name&#039;, $name]);\n
                \n
                        if ($query-&gt;count()) {\n
                            return $query-&gt;first()-&gt;id;\n
                        }\n
                \n
                        return null;\n
                    }\n
                \n
                    /**\n
                     * Get a module name from ID.\n
                     *\n
                     * @param int $id Module ID\n
                     *\n
                     * @return ?string Module name\n
                     */\n
                    public static function getNameFromId(int $id): ?string\n
                    {\n
                        $query = DB::getInstance()-&gt;get(&#039;modules&#039;, [&#039;id&#039;, $id]);\n
                \n
                        if ($query-&gt;count()) {\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_modules WHERE `name` = ?"
            "sql_params" => array:1 [
              0 => "Core"
            ]
          ]
          6 => array:4 [
            "number" => 7
            "frame" => array:6 [
              "number" => 7
              "file" => "/data/modules/Forms/module.php"
              "line" => 57
              "start_line" => 37
              "highlight_line" => 21
              "code" => """
                        $pages-&gt;add(&#039;Forms&#039;, &#039;/user/submissions&#039;, &#039;pages/user/submissions.php&#039;);\r\n
                \r\n
                        // Check if module version changed\r\n
                        $cache-&gt;setCache(&#039;forms_module_cache&#039;);\r\n
                        if (!$cache-&gt;isCached(&#039;module_version&#039;)) {\r\n
                            $cache-&gt;store(&#039;module_version&#039;, $module_version);\r\n
                        } else {\r\n
                            if ($module_version != $cache-&gt;retrieve(&#039;module_version&#039;)) {\r\n
                                // Version have changed, Perform actions\r\n
                                $this-&gt;initialiseUpdate($cache-&gt;retrieve(&#039;module_version&#039;));\r\n
                \r\n
                                $cache-&gt;store(&#039;module_version&#039;, $module_version);\r\n
                \r\n
                                if ($cache-&gt;isCached(&#039;update_check&#039;)) {\r\n
                                    $cache-&gt;erase(&#039;update_check&#039;);\r\n
                                }\r\n
                            }\r\n
                        }\r\n
                \r\n
                        try {\r\n
                            $forms = $this-&gt;_db-&gt;query(&#039;SELECT id, link_location, url, icon, title, guest FROM nl2_forms&#039;)-&gt;results();\r\n
                            if (count($forms)) {\r\n
                                if ($user-&gt;isLoggedIn()) {\r\n
                                    $group_ids = implode(&#039;,&#039;, $user-&gt;getAllGroupIds());\r\n
                                } else {\r\n
                                    $group_ids = implode(&#039;,&#039;, array(0));\r\n
                                }\r\n
                \r\n
                                foreach ($forms as $form) {\r\n
                                    // Register form page\r\n
                                    $pages-&gt;add(&#039;Forms&#039;, $form-&gt;url, &#039;pages/form.php&#039;, &#039;form-&#039; . $form-&gt;id, true);\r\n
                \r\n
                                    $perm = false;\r\n
                                    if (!$user-&gt;isLoggedIn() &amp;&amp; $form-&gt;guest == 1) {\r\n
                                        $perm = true;\r\n
                                    }\r\n
                \r\n
                                    if (!$perm) {\r\n
                                        $hasperm = $this-&gt;_db-&gt;query(&#039;SELECT form_id FROM nl2_forms_permissions WHERE form_id = ? AND post = 1 AND group_id IN(&#039; . $group_ids . &#039;)&#039;, array($form-&gt;id));\r\n
                                        if ($hasperm-&gt;count()) {\r\n
                                            $perm = true;\r\n
                """
            ]
            "sql_string" => "SELECT id, link_location, url, icon, title, guest FROM nl2_forms"
            "sql_params" => []
          ]
          7 => array:4 [
            "number" => 8
            "frame" => array:6 [
              "number" => 8
              "file" => "/data/modules/Forms/module.php"
              "line" => 75
              "start_line" => 55
              "highlight_line" => 21
              "code" => """
                \r\n
                        try {\r\n
                            $forms = $this-&gt;_db-&gt;query(&#039;SELECT id, link_location, url, icon, title, guest FROM nl2_forms&#039;)-&gt;results();\r\n
                            if (count($forms)) {\r\n
                                if ($user-&gt;isLoggedIn()) {\r\n
                                    $group_ids = implode(&#039;,&#039;, $user-&gt;getAllGroupIds());\r\n
                                } else {\r\n
                                    $group_ids = implode(&#039;,&#039;, array(0));\r\n
                                }\r\n
                \r\n
                                foreach ($forms as $form) {\r\n
                                    // Register form page\r\n
                                    $pages-&gt;add(&#039;Forms&#039;, $form-&gt;url, &#039;pages/form.php&#039;, &#039;form-&#039; . $form-&gt;id, true);\r\n
                \r\n
                                    $perm = false;\r\n
                                    if (!$user-&gt;isLoggedIn() &amp;&amp; $form-&gt;guest == 1) {\r\n
                                        $perm = true;\r\n
                                    }\r\n
                \r\n
                                    if (!$perm) {\r\n
                                        $hasperm = $this-&gt;_db-&gt;query(&#039;SELECT form_id FROM nl2_forms_permissions WHERE form_id = ? AND post = 1 AND group_id IN(&#039; . $group_ids . &#039;)&#039;, array($form-&gt;id));\r\n
                                        if ($hasperm-&gt;count()) {\r\n
                                            $perm = true;\r\n
                                        }\r\n
                                    }\r\n
                \r\n
                                    // Check cache first\r\n
                                    $cache-&gt;setCache(&#039;navbar_order&#039;);\r\n
                                    if (!$cache-&gt;isCached(&#039;form-&#039; . $form-&gt;id . &#039;_order&#039;)) {\r\n
                                        // Create cache entry now\r\n
                                        $form_order = 5;\r\n
                                        $cache-&gt;store(&#039;form-&#039; . $form-&gt;id . &#039;_order&#039;, 5);\r\n
                                    } else {\r\n
                                        $form_order = $cache-&gt;retrieve(&#039;form-&#039; . $form-&gt;id . &#039;_order&#039;);\r\n
                                    }\r\n
                \r\n
                                    // Add link location to navigation if user have permission\r\n
                                    if ($perm) {\r\n
                                        switch ($form-&gt;link_location) {\r\n
                                            case 1:\r\n
                                                // Navbar\r\n
                """
            ]
            "sql_string" => "SELECT form_id FROM nl2_forms_permissions WHERE form_id = ? AND post = 1 AND group_id IN(0)"
            "sql_params" => array:1 [
              0 => 1
            ]
          ]
          8 => array:4 [
            "number" => 9
            "frame" => array:6 [
              "number" => 9
              "file" => "/data/core/classes/Core/Settings.php"
              "line" => 45
              "start_line" => 25
              "highlight_line" => 21
              "code" => """
                        $cache_name = $module !== null ? $module : &#039;core&#039;;\n
                        self::$_cached_settings[$cache_name] = $cache;\n
                    }\n
                \n
                    /**\n
                     * Get a setting from the database table `nl2_settings`.\n
                     *\n
                     * @param  string  $setting  Setting to check.\n
                     * @param  ?string $fallback Fallback to return if $setting is not set in DB. Defaults to null.\n
                     * @param  string  $module   Module name to keep settings separate from other modules. Set module\n
                     *                           to &#039;Core&#039; for global settings.\n
                     * @return ?string Setting from DB or $fallback.\n
                     */\n
                    public static function get(string $setting, ?string $fallback = null, string $module = &#039;core&#039;): ?string\n
                    {\n
                        if (!self::hasSettingsCache($module)) {\n
                            // Load all settings for this module and store it as a dictionary\n
                            if ($module === &#039;core&#039;) {\n
                                $result = DB::getInstance()-&gt;query(&#039;SELECT `name`, `value` FROM `nl2_settings` WHERE `module` IS NULL&#039;)-&gt;results();\n
                            } else {\n
                                $result = DB::getInstance()-&gt;query(&#039;SELECT `name`, `value` FROM `nl2_settings` WHERE `module` = ?&#039;, [$module])-&gt;results();\n
                            }\n
                \n
                            $cache = [];\n
                            foreach ($result as $row) {\n
                                $cache[$row-&gt;name] = $row-&gt;value;\n
                            }\n
                            self::setSettingsCache($module, $cache);\n
                        }\n
                \n
                        $cache = &amp;self::getSettingsCache($module);\n
                \n
                        return $cache[$setting] ?? $fallback;\n
                    }\n
                \n
                    /**\n
                     * Modify a setting in the database table `nl2_settings`.\n
                     *\n
                     * @param string      $setting   Setting name.\n
                     * @param string|null $new_value New setting value, or null to delete\n
                     * @param string      $module    Module name to keep settings separate from other modules. Set module\n
                """
            ]
            "sql_string" => "SELECT `name`, `value` FROM `nl2_settings` WHERE `module` = ?"
            "sql_params" => array:1 [
              0 => "Store"
            ]
          ]
          9 => array:4 [
            "number" => 10
            "frame" => array:6 [
              "number" => 10
              "file" => "/data/core/classes/Integrations/IntegrationBase.php"
              "line" => 27
              "start_line" => 7
              "highlight_line" => 21
              "code" => """
                 * @author Partydragen\n
                 * @version 2.1.0\n
                 * @license MIT\n
                 */\n
                abstract class IntegrationBase\n
                {\n
                    private DB $_db;\n
                    private IntegrationData $_data;\n
                    protected string $_icon;\n
                    private array $_errors = [];\n
                    protected Language $_language;\n
                    protected ?string $_settings = null;\n
                \n
                    protected string $_name;\n
                    protected ?int $_order;\n
                \n
                    public function __construct()\n
                    {\n
                        $this-&gt;_db = DB::getInstance();\n
                \n
                        $integration = $this-&gt;_db-&gt;query(&#039;SELECT * FROM nl2_integrations WHERE name = ?&#039;, [$this-&gt;_name]);\n
                        if ($integration-&gt;count()) {\n
                            $integration = $integration-&gt;first();\n
                \n
                            $this-&gt;_data = new IntegrationData($integration);\n
                            $this-&gt;_order = $integration-&gt;order;\n
                        } else {\n
                            // Register integration to database\n
                            $this-&gt;_db-&gt;query(&#039;INSERT INTO nl2_integrations (name) VALUES (?)&#039;, [\n
                                $this-&gt;_name,\n
                            ]);\n
                \n
                            $integration = $this-&gt;_db-&gt;query(&#039;SELECT * FROM nl2_integrations WHERE name = ?&#039;, [$this-&gt;_name])-&gt;first();\n
                \n
                            $this-&gt;_data = new IntegrationData($integration);\n
                            $this-&gt;_order = $integration-&gt;order;\n
                        }\n
                    }\n
                \n
                    /**\n
                     * Get the name of this integration.\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_integrations WHERE name = ?"
            "sql_params" => array:1 [
              0 => "Discord"
            ]
          ]
          10 => array:4 [
            "number" => 11
            "frame" => array:6 [
              "number" => 11
              "file" => "/data/core/classes/Database/PhinxAdapter.php"
              "line" => 50
              "start_line" => 30
              "highlight_line" => 21
              "code" => """
                \n
                        if (!$migrationDir) {\n
                            $migrationDir = __DIR__ . &#039;/../../migrations&#039;;\n
                        }\n
                \n
                        $migration_files = array_map(\n
                            static function ($file_name) {\n
                                [$version, $migration_name] = explode(&#039;_&#039;, $file_name, 2);\n
                                $migration_name = str_replace([&#039;.php&#039;, &#039;_&#039;], &#039;&#039;, ucwords($migration_name, &#039;_&#039;));\n
                \n
                                return $version . &#039;_&#039; . $migration_name;\n
                            },\n
                            array_filter(scandir($migrationDir), static function ($file_name) {\n
                                // Pattern that matches Phinx migration file names (eg: 20230403000000_create_stroopwafel_table.php)\n
                                return preg_match(&#039;/^\d{14}_\w+\.php$/&#039;, $file_name);\n
                            }),\n
                        );\n
                \n
                        $migration_database_entries = array_map(static function ($row) {\n
                            return $row-&gt;version . &#039;_&#039; . $row-&gt;migration_name;\n
                        }, DB::getInstance()-&gt;query(&quot;SELECT version, migration_name FROM $table&quot;)-&gt;results());\n
                \n
                        $missing = array_diff($migration_files, $migration_database_entries);\n
                        $extra = array_diff($migration_database_entries, $migration_files);\n
                \n
                        if ($returnResults) {\n
                            return [\n
                                &#039;missing&#039; =&gt; count($missing),\n
                                &#039;extra&#039; =&gt; count($extra),\n
                            ];\n
                        }\n
                \n
                        // Likely a pull from the repo dev branch or migrations\n
                        // weren&#039;t run during an upgrade script.\n
                        if (($missing_count = count($missing)) &gt; 0) {\n
                            echo &quot;There are $missing_count migrations files which have not been executed:&quot; . &#039;&lt;br&gt;&#039;;\n
                            foreach ($missing as $missing_migration) {\n
                                echo &quot; - $missing_migration&quot; . &#039;&lt;br&gt;&#039;;\n
                            }\n
                        }\n
                \n
                """
            ]
            "sql_string" => "SELECT version, migration_name FROM nl2_phinxlog_lists"
            "sql_params" => []
          ]
          11 => array:4 [
            "number" => 12
            "frame" => array:6 [
              "number" => 12
              "file" => "/data/modules/Lists/module.php"
              "line" => 78
              "start_line" => 58
              "highlight_line" => 21
              "code" => """
                        $pages-&gt;add(&#039;Lists&#039;, &#039;/panel/lists/settings&#039;, &#039;pages/panel/settings.php&#039;);\r\n
                        $pages-&gt;add(&#039;Lists&#039;, &#039;/panel/lists&#039;, &#039;pages/panel/lists.php&#039;);\r\n
                        $pages-&gt;add(&#039;Lists&#039;, &#039;/panel/lists/tags&#039;, &#039;pages/panel/tags.php&#039;);\r\n
                        $pages-&gt;add(&#039;Lists&#039;, &#039;/queries/querysubmissions&#039;, &#039;queries/querysubmissions.php&#039;);\r\n
                \r\n
                        // Register provider connections\r\n
                        Lists::getInstance()-&gt;registerProviderConnection(new DefaultConnection());\r\n
                        Lists::getInstance()-&gt;registerProviderConnection(new MinecraftConnection());\r\n
                        Lists::getInstance()-&gt;registerProviderConnection(new VotifierConnection());\r\n
                        Lists::getInstance()-&gt;registerProviderConnection(new MCStatisticsConnection());\r\n
                        Lists::getInstance()-&gt;registerProviderConnection(new DiscordConnection());\r\n
                        Lists::getInstance()-&gt;registerProviderConnection(new NamelessMCConnection());\r\n
                        Lists::getInstance()-&gt;registerProviderConnection(new BF2142Connection());\r\n
                \r\n
                        EventHandler::registerEvent(ListSubmissionCreatedEvent::class);\r\n
                \r\n
                        // Store Listener\r\n
                        EventHandler::registerListener(PaymentCompletedEvent::class, [StorePaymentListener::class, &#039;paymentCompleted&#039;]);\r\n
                \r\n
                        // Register page for each lists\r\n
                        $lists = DB::getInstance()-&gt;query(&#039;SELECT * FROM nl2_lists WHERE provider IS NOT NULL AND url IS NOT NULL&#039;);\r\n
                        if ($lists-&gt;count()) {\r\n
                            foreach ($lists-&gt;results() as $list) {\r\n
                                // Register page\r\n
                                $pages-&gt;add(&#039;Lists&#039;, $list-&gt;url, &#039;pages/submissions.php&#039;, &#039;lists-&#039; . $list-&gt;id, true);\r\n
                                $pages-&gt;add(&#039;Lists&#039;, $list-&gt;url . &#039;/new&#039;, &#039;pages/new_submission.php&#039;, &#039;lists-&#039; . $list-&gt;id);\r\n
                            }\r\n
                        }\r\n
                \r\n
                        // Register page for each submission that has own vanity url\r\n
                        $submissions = DB::getInstance()-&gt;query(&#039;SELECT * FROM `nl2_lists_submissions` WHERE `vanity_url` IS NOT NULL&#039;);\r\n
                        foreach ($submissions-&gt;results() as $submission) {\r\n
                            $pages-&gt;add(&#039;Lists&#039;, &#039;/&#039; . $submission-&gt;vanity_url, &#039;pages/submission.php&#039;);\r\n
                        }\r\n
                    }\r\n
                \r\n
                    public function onInstall() {\r\n
                        PhinxAdapter::migrate($this-&gt;getName(), __DIR__ . &#039;/includes/migrations&#039;);\r\n
                \r\n
                        mkdir(ROOT_PATH . &#039;/uploads/lists_icons&#039;);\r\n
                        mkdir(ROOT_PATH . &#039;/uploads/lists_images&#039;);\r\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_lists WHERE provider IS NOT NULL AND url IS NOT NULL"
            "sql_params" => []
          ]
          12 => array:4 [
            "number" => 13
            "frame" => array:6 [
              "number" => 13
              "file" => "/data/modules/Lists/module.php"
              "line" => 88
              "start_line" => 68
              "highlight_line" => 21
              "code" => """
                        Lists::getInstance()-&gt;registerProviderConnection(new DiscordConnection());\r\n
                        Lists::getInstance()-&gt;registerProviderConnection(new NamelessMCConnection());\r\n
                        Lists::getInstance()-&gt;registerProviderConnection(new BF2142Connection());\r\n
                \r\n
                        EventHandler::registerEvent(ListSubmissionCreatedEvent::class);\r\n
                \r\n
                        // Store Listener\r\n
                        EventHandler::registerListener(PaymentCompletedEvent::class, [StorePaymentListener::class, &#039;paymentCompleted&#039;]);\r\n
                \r\n
                        // Register page for each lists\r\n
                        $lists = DB::getInstance()-&gt;query(&#039;SELECT * FROM nl2_lists WHERE provider IS NOT NULL AND url IS NOT NULL&#039;);\r\n
                        if ($lists-&gt;count()) {\r\n
                            foreach ($lists-&gt;results() as $list) {\r\n
                                // Register page\r\n
                                $pages-&gt;add(&#039;Lists&#039;, $list-&gt;url, &#039;pages/submissions.php&#039;, &#039;lists-&#039; . $list-&gt;id, true);\r\n
                                $pages-&gt;add(&#039;Lists&#039;, $list-&gt;url . &#039;/new&#039;, &#039;pages/new_submission.php&#039;, &#039;lists-&#039; . $list-&gt;id);\r\n
                            }\r\n
                        }\r\n
                \r\n
                        // Register page for each submission that has own vanity url\r\n
                        $submissions = DB::getInstance()-&gt;query(&#039;SELECT * FROM `nl2_lists_submissions` WHERE `vanity_url` IS NOT NULL&#039;);\r\n
                        foreach ($submissions-&gt;results() as $submission) {\r\n
                            $pages-&gt;add(&#039;Lists&#039;, &#039;/&#039; . $submission-&gt;vanity_url, &#039;pages/submission.php&#039;);\r\n
                        }\r\n
                    }\r\n
                \r\n
                    public function onInstall() {\r\n
                        PhinxAdapter::migrate($this-&gt;getName(), __DIR__ . &#039;/includes/migrations&#039;);\r\n
                \r\n
                        mkdir(ROOT_PATH . &#039;/uploads/lists_icons&#039;);\r\n
                        mkdir(ROOT_PATH . &#039;/uploads/lists_images&#039;);\r\n
                        mkdir(ROOT_PATH . &#039;/uploads/lists_banners&#039;);\r\n
                    }\r\n
                \r\n
                    public function onUninstall() {\r\n
                        PhinxAdapter::rollback($this-&gt;getName(), __DIR__ . &#039;/includes/migrations&#039;);\r\n
                    }\r\n
                \r\n
                    public function onEnable() {\r\n
                        PhinxAdapter::migrate($this-&gt;getName(), __DIR__ . &#039;/includes/migrations&#039;);\r\n
                \r\n
                """
            ]
            "sql_string" => "SELECT * FROM `nl2_lists_submissions` WHERE `vanity_url` IS NOT NULL"
            "sql_params" => []
          ]
          13 => array:4 [
            "number" => 14
            "frame" => array:6 [
              "number" => 14
              "file" => "/data/modules/OAuth2/module.php"
              "line" => 52
              "start_line" => 32
              "highlight_line" => 21
              "code" => """
                \r\n
                        // Check if module version changed\r\n
                        $cache-&gt;setCache(&#039;oauth2_module_cache&#039;);\r\n
                        if (!$cache-&gt;isCached(&#039;module_version&#039;)) {\r\n
                            $cache-&gt;store(&#039;module_version&#039;, $module_version);\r\n
                        } else {\r\n
                            if ($module_version != $cache-&gt;retrieve(&#039;module_version&#039;)) {\r\n
                                // Version have changed, Perform actions\r\n
                                $this-&gt;initialiseUpdate($cache-&gt;retrieve(&#039;module_version&#039;));\r\n
                \r\n
                                $cache-&gt;store(&#039;module_version&#039;, $module_version);\r\n
                \r\n
                                if ($cache-&gt;isCached(&#039;update_check&#039;)) {\r\n
                                    $cache-&gt;erase(&#039;update_check&#039;);\r\n
                                }\r\n
                            }\r\n
                        }\r\n
                \r\n
                        try {\r\n
                            // Register integrations for namelessmc applications\r\n
                            $applications = $this-&gt;_db-&gt;query(&quot;SELECT * FROM nl2_oauth2_applications WHERE nameless = 1 AND enabled = 1&quot;)-&gt;results();\r\n
                            foreach ($applications as $app) {\r\n
                                $application = new Application(null, null, $app);\r\n
                                Integrations::getInstance()-&gt;registerIntegration(new ApplicationIntegration($language, $application));\r\n
                \r\n
                                NamelessOAuth::getInstance()-&gt;registerProvider(strtolower($application-&gt;getName()), &#039;OAuth2&#039;, [\r\n
                                    &#039;class&#039; =&gt; NamelessProvider::class,\r\n
                                    &#039;user_id_name&#039; =&gt; &#039;id&#039;,\r\n
                                    &#039;scope_id_name&#039; =&gt; &#039;identify&#039;,\r\n
                                    &#039;icon&#039; =&gt; &#039;fa-solid fa-globe&#039;,\r\n
                                    &#039;verify_email&#039; =&gt; static fn () =&gt; true,\r\n
                                ]);\r\n
                \r\n
                                // Register group sync for namelessmc application if enabled\r\n
                                if ($application-&gt;data()-&gt;group_sync) {\r\n
                                    GroupSyncManager::getInstance()-&gt;registerInjector(new ApplicationGroupSyncInjector($application));\r\n
                                }\r\n
                            }\r\n
                        } catch (Exception $e) {\r\n
                            // Database tables don&#039;t exist yet\r\n
                        }\r\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_oauth2_applications WHERE nameless = 1 AND enabled = 1"
            "sql_params" => []
          ]
          14 => array:4 [
            "number" => 15
            "frame" => array:6 [
              "number" => 15
              "file" => "/data/core/classes/Integrations/IntegrationBase.php"
              "line" => 27
              "start_line" => 7
              "highlight_line" => 21
              "code" => """
                 * @author Partydragen\n
                 * @version 2.1.0\n
                 * @license MIT\n
                 */\n
                abstract class IntegrationBase\n
                {\n
                    private DB $_db;\n
                    private IntegrationData $_data;\n
                    protected string $_icon;\n
                    private array $_errors = [];\n
                    protected Language $_language;\n
                    protected ?string $_settings = null;\n
                \n
                    protected string $_name;\n
                    protected ?int $_order;\n
                \n
                    public function __construct()\n
                    {\n
                        $this-&gt;_db = DB::getInstance();\n
                \n
                        $integration = $this-&gt;_db-&gt;query(&#039;SELECT * FROM nl2_integrations WHERE name = ?&#039;, [$this-&gt;_name]);\n
                        if ($integration-&gt;count()) {\n
                            $integration = $integration-&gt;first();\n
                \n
                            $this-&gt;_data = new IntegrationData($integration);\n
                            $this-&gt;_order = $integration-&gt;order;\n
                        } else {\n
                            // Register integration to database\n
                            $this-&gt;_db-&gt;query(&#039;INSERT INTO nl2_integrations (name) VALUES (?)&#039;, [\n
                                $this-&gt;_name,\n
                            ]);\n
                \n
                            $integration = $this-&gt;_db-&gt;query(&#039;SELECT * FROM nl2_integrations WHERE name = ?&#039;, [$this-&gt;_name])-&gt;first();\n
                \n
                            $this-&gt;_data = new IntegrationData($integration);\n
                            $this-&gt;_order = $integration-&gt;order;\n
                        }\n
                    }\n
                \n
                    /**\n
                     * Get the name of this integration.\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_integrations WHERE name = ?"
            "sql_params" => array:1 [
              0 => "Patreon"
            ]
          ]
          15 => array:4 [
            "number" => 16
            "frame" => array:6 [
              "number" => 16
              "file" => "/data/core/init.php"
              "line" => 499
              "start_line" => 479
              "highlight_line" => 21
              "code" => """
                                            : [DiscordHook::class, &#039;execute&#039;],\n
                                        &#039;events&#039; =&gt; json_decode($hook-&gt;events, true),\n
                                    ];\n
                                }\n
                                $cache-&gt;store(&#039;hooks&#039;, $hook_array);\n
                            }\n
                        }\n
                    }\n
                    EventHandler::registerWebhooks($hook_array);\n
                \n
                    // Get IP\n
                    $ip = HttpUtils::getRemoteAddress();\n
                \n
                    // Define default group pre validation\n
                    $cache-&gt;setCache(&#039;pre_validation_default&#039;);\n
                    $group_id = null;\n
                \n
                    if ($cache-&gt;isCached(&#039;pre_validation_default&#039;)) {\n
                        $group_id = $cache-&gt;retrieve(&#039;pre_validation_default&#039;);\n
                    } else {\n
                        $group_id = DB::getInstance()-&gt;get(&#039;groups&#039;, [&#039;default_group&#039;, &#039;1&#039;])-&gt;results();\n
                        $group_id = $group_id[0]-&gt;id;\n
                    }\n
                \n
                    define(&#039;PRE_VALIDATED_DEFAULT&#039;, $group_id);\n
                \n
                    // Perform tasks if the user is logged in\n
                    if ($user-&gt;isLoggedIn()) {\n
                        Debugging::setCanViewDetailedError($user-&gt;hasPermission(&#039;admincp.errors&#039;));\n
                        Debugging::setCanGenerateDebugLink($user-&gt;hasPermission(&#039;admincp.core.debugging&#039;));\n
                \n
                        // Ensure a user is not banned\n
                        if ($user-&gt;data()-&gt;isbanned == 1) {\n
                            $user-&gt;logout();\n
                            Session::flash(&#039;home_error&#039;, $language-&gt;get(&#039;user&#039;, &#039;you_have_been_banned&#039;));\n
                            Redirect::to(URL::build(&#039;/&#039;));\n
                        }\n
                \n
                        // Is the IP address banned?\n
                        $ip_bans = DB::getInstance()-&gt;get(&#039;ip_bans&#039;, [&#039;ip&#039;, $ip])-&gt;results();\n
                        if (count($ip_bans)) {\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_groups WHERE `default_group` = ?"
            "sql_params" => array:1 [
              0 => "1"
            ]
          ]
          16 => array:4 [
            "number" => 17
            "frame" => array:6 [
              "number" => 17
              "file" => "/data/core/init.php"
              "line" => 602
              "start_line" => 582
              "highlight_line" => 21
              "code" => """
                        if (isset($forced) &amp;&amp; $forced) {\n
                            // Do they have TFA configured?\n
                            if (!$user-&gt;data()-&gt;tfa_enabled &amp;&amp; rtrim($_GET[&#039;route&#039;], &#039;/&#039;) != &#039;/logout&#039;) {\n
                                if (!str_contains($_SERVER[&#039;REQUEST_URI&#039;], &#039;do=enable_tfa&#039;) &amp;&amp; !isset($_SERVER[&#039;HTTP_X_REQUESTED_WITH&#039;])) {\n
                                    Session::put(&#039;force_tfa_alert&#039;, $language-&gt;get(&#039;admin&#039;, &#039;force_tfa_alert&#039;));\n
                                    Redirect::to(URL::build(&#039;/user/settings&#039;, &#039;do=enable_tfa&#039;));\n
                                }\n
                            }\n
                        }\n
                \n
                        $user_integrations = [];\n
                        foreach ($user-&gt;getIntegrations() as $integrationUser) {\n
                            $user_integrations[$integrationUser-&gt;getIntegration()-&gt;getName()] = [\n
                                &#039;username&#039; =&gt; Output::getClean($integrationUser-&gt;data()-&gt;username),\n
                                &#039;identifier&#039; =&gt; Output::getClean($integrationUser-&gt;data()-&gt;identifier),\n
                            ];\n
                        }\n
                    } else {\n
                        // Perform tasks for guests\n
                        if (!$_SESSION[&#039;checked&#039;] || (isset($_SESSION[&#039;checked&#039;]) &amp;&amp; $_SESSION[&#039;checked&#039;] &lt;= strtotime(&#039;-5 minutes&#039;))) {\n
                            $already_online = DB::getInstance()-&gt;get(&#039;online_guests&#039;, [&#039;ip&#039;, $ip])-&gt;results();\n
                \n
                            $date = date(&#039;U&#039;);\n
                \n
                            if (count($already_online)) {\n
                                DB::getInstance()-&gt;update(&#039;online_guests&#039;, $already_online[0]-&gt;id, [&#039;last_seen&#039; =&gt; $date]);\n
                            } else {\n
                                DB::getInstance()-&gt;insert(&#039;online_guests&#039;, [&#039;ip&#039; =&gt; $ip, &#039;last_seen&#039; =&gt; $date]);\n
                            }\n
                \n
                            $_SESSION[&#039;checked&#039;] = $date;\n
                        }\n
                \n
                        // Auto language enabled?\n
                        if (Settings::get(&#039;auto_language_detection&#039;)) {\n
                            define(&#039;AUTO_LANGUAGE&#039;, true);\n
                        }\n
                    }\n
                \n
                    // Dark mode\n
                    $cache-&gt;setCache(&#039;template_settings&#039;);\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_online_guests WHERE `ip` = ?"
            "sql_params" => array:1 [
              0 => "216.73.216.72"
            ]
          ]
          17 => array:4 [
            "number" => 18
            "frame" => array:6 [
              "number" => 18
              "file" => "/data/core/init.php"
              "line" => 607
              "start_line" => 587
              "highlight_line" => 21
              "code" => """
                                    Redirect::to(URL::build(&#039;/user/settings&#039;, &#039;do=enable_tfa&#039;));\n
                                }\n
                            }\n
                        }\n
                \n
                        $user_integrations = [];\n
                        foreach ($user-&gt;getIntegrations() as $integrationUser) {\n
                            $user_integrations[$integrationUser-&gt;getIntegration()-&gt;getName()] = [\n
                                &#039;username&#039; =&gt; Output::getClean($integrationUser-&gt;data()-&gt;username),\n
                                &#039;identifier&#039; =&gt; Output::getClean($integrationUser-&gt;data()-&gt;identifier),\n
                            ];\n
                        }\n
                    } else {\n
                        // Perform tasks for guests\n
                        if (!$_SESSION[&#039;checked&#039;] || (isset($_SESSION[&#039;checked&#039;]) &amp;&amp; $_SESSION[&#039;checked&#039;] &lt;= strtotime(&#039;-5 minutes&#039;))) {\n
                            $already_online = DB::getInstance()-&gt;get(&#039;online_guests&#039;, [&#039;ip&#039;, $ip])-&gt;results();\n
                \n
                            $date = date(&#039;U&#039;);\n
                \n
                            if (count($already_online)) {\n
                                DB::getInstance()-&gt;update(&#039;online_guests&#039;, $already_online[0]-&gt;id, [&#039;last_seen&#039; =&gt; $date]);\n
                            } else {\n
                                DB::getInstance()-&gt;insert(&#039;online_guests&#039;, [&#039;ip&#039; =&gt; $ip, &#039;last_seen&#039; =&gt; $date]);\n
                            }\n
                \n
                            $_SESSION[&#039;checked&#039;] = $date;\n
                        }\n
                \n
                        // Auto language enabled?\n
                        if (Settings::get(&#039;auto_language_detection&#039;)) {\n
                            define(&#039;AUTO_LANGUAGE&#039;, true);\n
                        }\n
                    }\n
                \n
                    // Dark mode\n
                    $cache-&gt;setCache(&#039;template_settings&#039;);\n
                    $darkMode = $cache-&gt;isCached(&#039;darkMode&#039;) ? $cache-&gt;retrieve(&#039;darkMode&#039;) : &#039;0&#039;;\n
                    if ($user-&gt;isLoggedIn()) {\n
                        $darkMode = $user-&gt;data()-&gt;night_mode !== null ? $user-&gt;data()-&gt;night_mode : $darkMode;\n
                    } else {\n
                        if (Cookie::exists(&#039;night_mode&#039;)) {\n
                """
            ]
            "sql_string" => "UPDATE nl2_online_guests SET `last_seen` = ? WHERE `id` = ?"
            "sql_params" => array:2 [
              "last_seen" => "1794700984"
              0 => 17751
            ]
          ]
          18 => array:4 [
            "number" => 19
            "frame" => array:6 [
              "number" => 19
              "file" => "/data/modules/Store/pages/store/store.php"
              "line" => 30
              "start_line" => 10
              "highlight_line" => 21
              "code" => """
                 */\r\n
                \r\n
                // Always define page name\r\n
                define(&#039;PAGE&#039;, &#039;store&#039;);\r\n
                \r\n
                $directories = explode(&#039;/&#039;, $route);\r\n
                if (!in_array(&#039;category&#039;, $directories)) {\r\n
                    // Load index\r\n
                    $category_query = DB::getInstance()-&gt;query(&#039;SELECT * FROM nl2_store_categories WHERE deleted = 0 ORDER BY `order` ASC LIMIT 1&#039;);\r\n
                \r\n
                } else {\r\n
                    // Load specific category\r\n
                    $category_id = $directories[count($directories) - 1];\r\n
                    if (!strlen($category_id)) {\r\n
                        require_once(ROOT_PATH . &#039;/404.php&#039;);\r\n
                        die();\r\n
                    }\r\n
                \r\n
                    if (is_numeric($category_id)) {\r\n
                        // Query category by id\r\n
                        $category_query = DB::getInstance()-&gt;query(&#039;SELECT * FROM nl2_store_categories WHERE id = ? AND disabled = 0 AND deleted = 0&#039;, [$category_id]);\r\n
                    } else {\r\n
                        // Query category by url\r\n
                        $category_query = DB::getInstance()-&gt;query(&#039;SELECT * FROM nl2_store_categories WHERE url = ? AND disabled = 0 AND deleted = 0&#039;, [$category_id]);\r\n
                    }\r\n
                }\r\n
                \r\n
                if (!$category_query-&gt;count()) {\r\n
                    require_once(ROOT_PATH . &#039;/404.php&#039;);\r\n
                    die();\r\n
                }\r\n
                \r\n
                $category = $category_query-&gt;first();\r\n
                $category_id = $category-&gt;id;\r\n
                $store_url = Store::getStorePath();\r\n
                \r\n
                $page_metadata = DB::getInstance()-&gt;get(&#039;page_descriptions&#039;, [&#039;page&#039;, &#039;=&#039;, $store_url])-&gt;results();\r\n
                if (count($page_metadata)) {\r\n
                    define(&#039;PAGE_DESCRIPTION&#039;, str_replace([&#039;{site}&#039;, &#039;{category_title}&#039;, &#039;{description}&#039;], [SITE_NAME, Output::getClean($category-&gt;name), Output::getClean(strip_tags(Output::getDecoded($category-&gt;description)))], $page_metadata[0]-&gt;description));\r\n
                    define(&#039;PAGE_KEYWORDS&#039;, $page_metadata[0]-&gt;tags);\r\n
                }\r\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_store_categories WHERE id = ? AND disabled = 0 AND deleted = 0"
            "sql_params" => array:1 [
              0 => "1"
            ]
          ]
          19 => array:4 [
            "number" => 20
            "frame" => array:6 [
              "number" => 20
              "file" => "/data/modules/Store/pages/store/store.php"
              "line" => 46
              "start_line" => 26
              "highlight_line" => 21
              "code" => """
                    }\r\n
                \r\n
                    if (is_numeric($category_id)) {\r\n
                        // Query category by id\r\n
                        $category_query = DB::getInstance()-&gt;query(&#039;SELECT * FROM nl2_store_categories WHERE id = ? AND disabled = 0 AND deleted = 0&#039;, [$category_id]);\r\n
                    } else {\r\n
                        // Query category by url\r\n
                        $category_query = DB::getInstance()-&gt;query(&#039;SELECT * FROM nl2_store_categories WHERE url = ? AND disabled = 0 AND deleted = 0&#039;, [$category_id]);\r\n
                    }\r\n
                }\r\n
                \r\n
                if (!$category_query-&gt;count()) {\r\n
                    require_once(ROOT_PATH . &#039;/404.php&#039;);\r\n
                    die();\r\n
                }\r\n
                \r\n
                $category = $category_query-&gt;first();\r\n
                $category_id = $category-&gt;id;\r\n
                $store_url = Store::getStorePath();\r\n
                \r\n
                $page_metadata = DB::getInstance()-&gt;get(&#039;page_descriptions&#039;, [&#039;page&#039;, &#039;=&#039;, $store_url])-&gt;results();\r\n
                if (count($page_metadata)) {\r\n
                    define(&#039;PAGE_DESCRIPTION&#039;, str_replace([&#039;{site}&#039;, &#039;{category_title}&#039;, &#039;{description}&#039;], [SITE_NAME, Output::getClean($category-&gt;name), Output::getClean(strip_tags(Output::getDecoded($category-&gt;description)))], $page_metadata[0]-&gt;description));\r\n
                    define(&#039;PAGE_KEYWORDS&#039;, $page_metadata[0]-&gt;tags);\r\n
                }\r\n
                \r\n
                $page_title = Output::getClean($category-&gt;name);\r\n
                require_once(ROOT_PATH . &#039;/core/templates/frontend_init.php&#039;);\r\n
                require_once(ROOT_PATH . &#039;/modules/Store/core/frontend_init.php&#039;);\r\n
                \r\n
                if (Input::exists()) {\r\n
                    if (Token::check()) {\r\n
                        $errors = [];\r\n
                \r\n
                        if (Input::get(&#039;type&#039;) == &#039;store_login&#039;) {\r\n
                            $validation = Validate::check($_POST, [\r\n
                                &#039;username&#039; =&gt; [\r\n
                                    Validate::REQUIRED =&gt; true,\r\n
                                    Validate::MIN =&gt; 3,\r\n
                                    Validate::MAX =&gt; 16\r\n
                                ]\r\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_page_descriptions WHERE `page` = ?"
            "sql_params" => array:1 [
              0 => "/store"
            ]
          ]
          20 => array:4 [
            "number" => 21
            "frame" => array:6 [
              "number" => 21
              "file" => "/data/modules/Store/pages/store/store.php"
              "line" => 84
              "start_line" => 64
              "highlight_line" => 21
              "code" => """
                                    Validate::MIN =&gt; 3,\r\n
                                    Validate::MAX =&gt; 16\r\n
                                ]\r\n
                            ]);\r\n
                \r\n
                            if ($validation-&gt;passed()) {\r\n
                                // Attempt to load customer\r\n
                                if ($to_customer-&gt;login(Input::get(&#039;username&#039;))) {\r\n
                                    Redirect::to(URL::build($store_url . &#039;/category/&#039; . $category-&gt;id));\r\n
                                } else {\r\n
                                    $errors[] = $language-&gt;get(&#039;user&#039;, &#039;invalid_mcname&#039;);\r\n
                                }\r\n
                            } else {\r\n
                                $errors[] = $store_language-&gt;get(&#039;general&#039;, &#039;unable_to_find_player&#039;);\r\n
                            }\r\n
                        }\r\n
                    }\r\n
                }\r\n
                \r\n
                // Get products\r\n
                $products = DB::getInstance()-&gt;query(&#039;SELECT * FROM nl2_store_products WHERE category_id = ? AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC&#039;, [$category_id]);\r\n
                \r\n
                if (!$products-&gt;count()) {\r\n
                    $template-&gt;getEngine()-&gt;addVariable(&#039;NO_PRODUCTS&#039;, $store_language-&gt;get(&#039;general&#039;, &#039;no_products&#039;));\r\n
                } else {\r\n
                    $category_products = [];\r\n
                \r\n
                    foreach ($products-&gt;results() as $item) {\r\n
                        $product = new Product(null, null, $item);\r\n
                \r\n
                        $renderProductEvent = new RenderProductEvent($product, $shopping_cart);\r\n
                        EventHandler::executeEvent($renderProductEvent);\r\n
                \r\n
                        if ($renderProductEvent-&gt;hidden) {\r\n
                            continue;\r\n
                        }\r\n
                \r\n
                        $category_products[] = [\r\n
                            &#039;id&#039; =&gt; $product-&gt;data()-&gt;id,\r\n
                            &#039;name&#039; =&gt; Output::getClean($renderProductEvent-&gt;name),\r\n
                            &#039;price&#039; =&gt; Store::fromCents($product-&gt;data()-&gt;price_cents),\r\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_store_products WHERE category_id = ? AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC"
            "sql_params" => array:1 [
              0 => 1
            ]
          ]
          21 => array:4 [
            "number" => 22
            "frame" => array:6 [
              "number" => 22
              "file" => "/data/modules/Store/classes/Store.php"
              "line" => 176
              "start_line" => 156
              "highlight_line" => 21
              "code" => """
                     */\r\n
                    public static function formatPrice(int $price_cents, ?string $currencyCode, ?string $currencySymbol, ?string $format = &#039;{currencySymbol}{price} {currencyCode}&#039;): string {\r\n
                        return str_replace([\r\n
                            &#039;{currencyCode}&#039;,\r\n
                            &#039;{currencySymbol}&#039;,\r\n
                            &#039;{price}&#039;\r\n
                        ], [\r\n
                            $currencyCode ?? &#039;??&#039;,\r\n
                            $currencySymbol ?? &#039;??&#039;,\r\n
                            sprintf(&#039;%0.2f&#039;, $price_cents / 100),\r\n
                        ], $format);\r\n
                    }\r\n
                \r\n
                    /**\r\n
                     * Get the active sales.\r\n
                     *\r\n
                     * @return array The active sales.\r\n
                     */\r\n
                    public static function getActiveSales(): array {\r\n
                        return self::$_active_sales ??= (function (): array {\r\n
                            return DB::getInstance()-&gt;query(&#039;SELECT * FROM nl2_store_sales WHERE start_date &lt; ? AND expire_date &gt; ? ORDER BY `expire_date` DESC&#039;, [date(&#039;U&#039;), date(&#039;U&#039;)])-&gt;results();\r\n
                        })();\r\n
                    }\r\n
                \r\n
                    /*\r\n
                     *  Check for Module updates\r\n
                     *  Returns JSON object with information about any updates\r\n
                     */\r\n
                    public static function updateCheck() {\r\n
                        $current_version = Settings::get(&#039;nameless_version&#039;);\r\n
                        $uid = Settings::get(&#039;unique_id&#039;);\r\n
                \r\n
                        $enabled_modules = Module::getModules();\r\n
                        foreach ($enabled_modules as $enabled_item) {\r\n
                            if ($enabled_item-&gt;getName() == &#039;Store&#039;) {\r\n
                                $module = $enabled_item;\r\n
                                break;\r\n
                            }\r\n
                        }\r\n
                \r\n
                        $ch = curl_init();\r\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_store_sales WHERE start_date < ? AND expire_date > ? ORDER BY `expire_date` DESC"
            "sql_params" => array:2 [
              0 => "1794700984"
              1 => "1794700984"
            ]
          ]
          22 => array:4 [
            "number" => 23
            "frame" => array:6 [
              "number" => 23
              "file" => "/data/modules/Store/classes/Store.php"
              "line" => 89
              "start_line" => 69
              "highlight_line" => 21
              "code" => """
                    // Get all connections\r\n
                    public function getAllConnections() {\r\n
                        $connections = $this-&gt;_db-&gt;query(&#039;SELECT * FROM nl2_store_connections&#039;)-&gt;results();\r\n
                \r\n
                        $connections_array = [];\r\n
                        foreach ($connections as $connection) {\r\n
                            $connections_array[] = [\r\n
                                &#039;id&#039; =&gt; Output::getClean($connection-&gt;id),\r\n
                                &#039;name&#039; =&gt; Output::getClean($connection-&gt;name)\r\n
                            ];\r\n
                        }\r\n
                \r\n
                        return $connections_array;\r\n
                    }\r\n
                    \r\n
                    // Get navbar menu\r\n
                    public function getNavbarMenu($active) {\r\n
                        $store_url = $this-&gt;getStoreURL();\r\n
                        $categories = [];\r\n
                \r\n
                        $categories_query = DB::getInstance()-&gt;query(&#039;SELECT * FROM nl2_store_categories WHERE parent_category IS NULL AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC&#039;)-&gt;results();\r\n
                        if (count($categories_query)) {\r\n
                            foreach ($categories_query as $item) {\r\n
                                $subcategories_query = DB::getInstance()-&gt;query(&#039;SELECT id, `name`, `url` FROM nl2_store_categories WHERE parent_category = ? AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC&#039;, [$item-&gt;id])-&gt;results();\r\n
                \r\n
                                $subcategories = [];\r\n
                                $sub_active = false;\r\n
                                if (count($subcategories_query)) {\r\n
                                    foreach ($subcategories_query as $subcategory) {\r\n
                                        $sub_active = Output::getClean($active) == Output::getClean($subcategory-&gt;name);\r\n
                \r\n
                                        $subcategories[] = [\r\n
                                            &#039;url&#039; =&gt; URL::build($store_url . &#039;/category/&#039; . (empty($subcategory-&gt;url) ? $subcategory-&gt;id : $subcategory-&gt;url)),\r\n
                                            &#039;title&#039; =&gt; Output::getClean($subcategory-&gt;name),\r\n
                                            &#039;active&#039; =&gt; $sub_active\r\n
                                        ];\r\n
                                    }\r\n
                                }\r\n
                \r\n
                                $categories[$item-&gt;id] = [\r\n
                                    &#039;url&#039; =&gt; URL::build($store_url . &#039;/category/&#039; . (empty($item-&gt;url) ? $item-&gt;id : $item-&gt;url)),\r\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_store_categories WHERE parent_category IS NULL AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC"
            "sql_params" => []
          ]
          23 => array:4 [
            "number" => 24
            "frame" => array:6 [
              "number" => 24
              "file" => "/data/modules/Store/classes/Store.php"
              "line" => 92
              "start_line" => 72
              "highlight_line" => 21
              "code" => """
                \r\n
                        $connections_array = [];\r\n
                        foreach ($connections as $connection) {\r\n
                            $connections_array[] = [\r\n
                                &#039;id&#039; =&gt; Output::getClean($connection-&gt;id),\r\n
                                &#039;name&#039; =&gt; Output::getClean($connection-&gt;name)\r\n
                            ];\r\n
                        }\r\n
                \r\n
                        return $connections_array;\r\n
                    }\r\n
                    \r\n
                    // Get navbar menu\r\n
                    public function getNavbarMenu($active) {\r\n
                        $store_url = $this-&gt;getStoreURL();\r\n
                        $categories = [];\r\n
                \r\n
                        $categories_query = DB::getInstance()-&gt;query(&#039;SELECT * FROM nl2_store_categories WHERE parent_category IS NULL AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC&#039;)-&gt;results();\r\n
                        if (count($categories_query)) {\r\n
                            foreach ($categories_query as $item) {\r\n
                                $subcategories_query = DB::getInstance()-&gt;query(&#039;SELECT id, `name`, `url` FROM nl2_store_categories WHERE parent_category = ? AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC&#039;, [$item-&gt;id])-&gt;results();\r\n
                \r\n
                                $subcategories = [];\r\n
                                $sub_active = false;\r\n
                                if (count($subcategories_query)) {\r\n
                                    foreach ($subcategories_query as $subcategory) {\r\n
                                        $sub_active = Output::getClean($active) == Output::getClean($subcategory-&gt;name);\r\n
                \r\n
                                        $subcategories[] = [\r\n
                                            &#039;url&#039; =&gt; URL::build($store_url . &#039;/category/&#039; . (empty($subcategory-&gt;url) ? $subcategory-&gt;id : $subcategory-&gt;url)),\r\n
                                            &#039;title&#039; =&gt; Output::getClean($subcategory-&gt;name),\r\n
                                            &#039;active&#039; =&gt; $sub_active\r\n
                                        ];\r\n
                                    }\r\n
                                }\r\n
                \r\n
                                $categories[$item-&gt;id] = [\r\n
                                    &#039;url&#039; =&gt; URL::build($store_url . &#039;/category/&#039; . (empty($item-&gt;url) ? $item-&gt;id : $item-&gt;url)),\r\n
                                    &#039;title&#039; =&gt; Output::getClean($item-&gt;name),\r\n
                                    &#039;subcategories&#039; =&gt; $subcategories,\r\n
                                    &#039;active&#039; =&gt; !$sub_active &amp;&amp; Output::getClean($active) == Output::getClean($item-&gt;name),\r\n
                """
            ]
            "sql_string" => "SELECT id, `name`, `url` FROM nl2_store_categories WHERE parent_category = ? AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC"
            "sql_params" => array:1 [
              0 => 1
            ]
          ]
          24 => array:4 [
            "number" => 25
            "frame" => array:6 [
              "number" => 25
              "file" => "/data/modules/Store/classes/Store.php"
              "line" => 92
              "start_line" => 72
              "highlight_line" => 21
              "code" => """
                \r\n
                        $connections_array = [];\r\n
                        foreach ($connections as $connection) {\r\n
                            $connections_array[] = [\r\n
                                &#039;id&#039; =&gt; Output::getClean($connection-&gt;id),\r\n
                                &#039;name&#039; =&gt; Output::getClean($connection-&gt;name)\r\n
                            ];\r\n
                        }\r\n
                \r\n
                        return $connections_array;\r\n
                    }\r\n
                    \r\n
                    // Get navbar menu\r\n
                    public function getNavbarMenu($active) {\r\n
                        $store_url = $this-&gt;getStoreURL();\r\n
                        $categories = [];\r\n
                \r\n
                        $categories_query = DB::getInstance()-&gt;query(&#039;SELECT * FROM nl2_store_categories WHERE parent_category IS NULL AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC&#039;)-&gt;results();\r\n
                        if (count($categories_query)) {\r\n
                            foreach ($categories_query as $item) {\r\n
                                $subcategories_query = DB::getInstance()-&gt;query(&#039;SELECT id, `name`, `url` FROM nl2_store_categories WHERE parent_category = ? AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC&#039;, [$item-&gt;id])-&gt;results();\r\n
                \r\n
                                $subcategories = [];\r\n
                                $sub_active = false;\r\n
                                if (count($subcategories_query)) {\r\n
                                    foreach ($subcategories_query as $subcategory) {\r\n
                                        $sub_active = Output::getClean($active) == Output::getClean($subcategory-&gt;name);\r\n
                \r\n
                                        $subcategories[] = [\r\n
                                            &#039;url&#039; =&gt; URL::build($store_url . &#039;/category/&#039; . (empty($subcategory-&gt;url) ? $subcategory-&gt;id : $subcategory-&gt;url)),\r\n
                                            &#039;title&#039; =&gt; Output::getClean($subcategory-&gt;name),\r\n
                                            &#039;active&#039; =&gt; $sub_active\r\n
                                        ];\r\n
                                    }\r\n
                                }\r\n
                \r\n
                                $categories[$item-&gt;id] = [\r\n
                                    &#039;url&#039; =&gt; URL::build($store_url . &#039;/category/&#039; . (empty($item-&gt;url) ? $item-&gt;id : $item-&gt;url)),\r\n
                                    &#039;title&#039; =&gt; Output::getClean($item-&gt;name),\r\n
                                    &#039;subcategories&#039; =&gt; $subcategories,\r\n
                                    &#039;active&#039; =&gt; !$sub_active &amp;&amp; Output::getClean($active) == Output::getClean($item-&gt;name),\r\n
                """
            ]
            "sql_string" => "SELECT id, `name`, `url` FROM nl2_store_categories WHERE parent_category = ? AND disabled = 0 AND hidden = 0 AND deleted = 0 ORDER BY `order` ASC"
            "sql_params" => array:1 [
              0 => 2
            ]
          ]
          25 => array:4 [
            "number" => 26
            "frame" => array:6 [
              "number" => 26
              "file" => "/data/modules/Core/module.php"
              "line" => 815
              "start_line" => 795
              "highlight_line" => 21
              "code" => """
                            }\n
                        }\n
                \n
                        // Check page type (frontend or backend)\n
                        if (defined(&#039;FRONT_END&#039;)) {\n
                            // Minecraft integration?\n
                            if (Settings::get(&#039;mc_integration&#039;)) {\n
                                // Query main server\n
                                $cache-&gt;setCache(&#039;mc_default_server&#039;);\n
                \n
                                // Already cached?\n
                                if ($cache-&gt;isCached(&#039;default_query&#039;)) {\n
                                    $result = $cache-&gt;retrieve(&#039;default_query&#039;);\n
                                    $default = $cache-&gt;retrieve(&#039;default&#039;);\n
                                } else {\n
                                    if ($cache-&gt;isCached(&#039;default&#039;)) {\n
                                        $default = $cache-&gt;retrieve(&#039;default&#039;);\n
                                        $sub_servers = $cache-&gt;retrieve(&#039;default_sub&#039;);\n
                                    } else {\n
                                        // Get default server from database\n
                                        $default = DB::getInstance()-&gt;get(&#039;mc_servers&#039;, [&#039;is_default&#039;, true])-&gt;results();\n
                                        if (count($default)) {\n
                                            // Get sub-servers of default server\n
                                            $sub_servers = DB::getInstance()-&gt;get(&#039;mc_servers&#039;, [&#039;parent_server&#039;, $default[0]-&gt;id])-&gt;results();\n
                                            if (count($sub_servers)) {\n
                                                $cache-&gt;store(&#039;default_sub&#039;, $sub_servers);\n
                                            } else {\n
                                                $cache-&gt;store(&#039;default_sub&#039;, []);\n
                                            }\n
                \n
                                            $default = $default[0];\n
                \n
                                            $cache-&gt;store(&#039;default&#039;, $default, 60);\n
                                        } else {\n
                                            $cache-&gt;store(&#039;default&#039;, null, 60);\n
                                        }\n
                                    }\n
                \n
                                    if (!is_null($default) &amp;&amp; isset($default-&gt;ip)) {\n
                                        $full_ip = [&#039;ip&#039; =&gt; $default-&gt;ip . (is_null($default-&gt;port) ? &#039;&#039; : &#039;:&#039; . $default-&gt;port), &#039;pre&#039; =&gt; $default-&gt;pre, &#039;name&#039; =&gt; $default-&gt;name, &#039;id&#039; =&gt; $default-&gt;id];\n
                \n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_mc_servers WHERE `is_default` = ?"
            "sql_params" => array:1 [
              0 => true
            ]
          ]
          26 => array:4 [
            "number" => 27
            "frame" => array:6 [
              "number" => 27
              "file" => "/data/modules/Lists/module.php"
              "line" => 119
              "start_line" => 99
              "highlight_line" => 21
              "code" => """
                        mkdir(ROOT_PATH . &#039;/uploads/lists_banners&#039;);\r\n
                    }\r\n
                \r\n
                    public function onUninstall() {\r\n
                        PhinxAdapter::rollback($this-&gt;getName(), __DIR__ . &#039;/includes/migrations&#039;);\r\n
                    }\r\n
                \r\n
                    public function onEnable() {\r\n
                        PhinxAdapter::migrate($this-&gt;getName(), __DIR__ . &#039;/includes/migrations&#039;);\r\n
                \r\n
                        mkdir(ROOT_PATH . &#039;/uploads/lists_icons&#039;);\r\n
                        mkdir(ROOT_PATH . &#039;/uploads/lists_images&#039;);\r\n
                        mkdir(ROOT_PATH . &#039;/uploads/lists_banners&#039;);\r\n
                    }\r\n
                \r\n
                    public function onDisable() {\r\n
                        // No actions necessary\r\n
                    }\r\n
                \r\n
                    public function onPageLoad($user, $pages, $cache, $smarty, $navs, $widgets, $template) {\r\n
                        $lists = DB::getInstance()-&gt;query(&#039;SELECT * FROM nl2_lists WHERE link_location IS NOT NULL&#039;);\r\n
                        if ($lists-&gt;count()) {\r\n
                            foreach ($lists-&gt;results() as $list) {\r\n
                                // Check cache first\r\n
                                $cache-&gt;setCache(&#039;navbar_order&#039;);\r\n
                                if (!$cache-&gt;isCached(&#039;lists-&#039; . $list-&gt;id . &#039;_order&#039;)){\r\n
                                    $order = 5;\r\n
                                    $cache-&gt;store(&#039;lists-&#039; . $list-&gt;id . &#039;_order&#039;, 5);\r\n
                                } else {\r\n
                                    $order = $cache-&gt;retrieve(&#039;lists-&#039; . $list-&gt;id . &#039;_order&#039;);\r\n
                                }\r\n
                \r\n
                                $cache-&gt;setCache(&#039;navbar_icons&#039;);\r\n
                                if (!$cache-&gt;isCached(&#039;lists-&#039; . $list-&gt;id . &#039;_icon&#039;))\r\n
                                    $icon = &#039;&#039;;\r\n
                                else\r\n
                                    $icon = $cache-&gt;retrieve(&#039;lists-&#039; . $list-&gt;id . &#039;_icon&#039;);\r\n
                \r\n
                                switch ($list-&gt;link_location) {\r\n
                                    case 1:\r\n
                                        // Navbar\r\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_lists WHERE link_location IS NOT NULL"
            "sql_params" => []
          ]
          27 => array:4 [
            "number" => 28
            "frame" => array:6 [
              "number" => 28
              "file" => "/data/modules/Lists/module.php"
              "line" => 175
              "start_line" => 155
              "highlight_line" => 21
              "code" => """
                        // Permissions\r\n
                        PermissionHandler::registerPermissions(&#039;Lists&#039;, [\r\n
                            &#039;lists.edit_all&#039; =&gt; &#039;Allow editing any submission&#039;,\r\n
                            &#039;lists.style&#039; =&gt; &#039;Gives a fancy submission name effect&#039;,\r\n
                            &#039;lists.vanity_url&#039; =&gt; &#039;Set vanity url&#039;,\r\n
                            &#039;lists.auto_bump&#039; =&gt; &#039;Allow user to enable auto bump on their submission&#039;,\r\n
                            &#039;admincp.lists&#039; =&gt; &#039;Manage lists&#039;,\r\n
                            &#039;admincp.lists.tags&#039; =&gt; &#039;Manage tags&#039;\r\n
                        ]);\r\n
                \r\n
                        // User Navigation\r\n
                        $navs[1]-&gt;add(&#039;cc_lists_submissions&#039;, $this-&gt;_lists_language-&gt;get(&#039;general&#039;, &#039;my_submissions&#039;), URL::build(&#039;/user/lists/submissions&#039;));\r\n
                \r\n
                        // Latest submissions\r\n
                        $cache-&gt;setCache(&#039;lists_submissions&#039;);\r\n
                        if ($cache-&gt;isCached(&#039;latest_submissions&#039;)) {\r\n
                            $latest_submissions = $cache-&gt;retrieve(&#039;latest_submissions&#039;);\r\n
                        } else {\r\n
                            $latest_submissions = [];\r\n
                \r\n
                            $submissions = DB::getInstance()-&gt;query(&#039;SELECT * FROM nl2_lists_submissions ORDER BY created DESC LIMIT 6&#039;);\r\n
                            foreach ($submissions-&gt;results() as $item) {\r\n
                                $submission = new Submission(null, null, $item);\r\n
                \r\n
                                $latest_submissions[] = [\r\n
                                    &#039;id&#039; =&gt; Output::getClean($submission-&gt;data()-&gt;id),\r\n
                                    &#039;name&#039; =&gt; Output::getClean($submission-&gt;data()-&gt;name),\r\n
                                    &#039;link&#039; =&gt; $submission-&gt;getLink(),\r\n
                                    &#039;style&#039; =&gt; $submission-&gt;getStyle()\r\n
                                ];\r\n
                            }\r\n
                \r\n
                            $cache-&gt;store(&#039;latest_submissions&#039;, $latest_submissions, 180);\r\n
                        }\r\n
                \r\n
                        $template-&gt;getEngine()-&gt;addVariables([\r\n
                            &#039;LATEST_SUBMISSIONS_LIST&#039; =&gt; $latest_submissions\r\n
                        ]);\r\n
                \r\n
                        if (defined(&#039;BACK_END&#039;)) {\r\n
                            if ($user-&gt;hasPermission(&#039;admincp.lists&#039;)) {\r\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_lists_submissions ORDER BY created DESC LIMIT 6"
            "sql_params" => []
          ]
          28 => array:4 [
            "number" => 29
            "frame" => array:6 [
              "number" => 29
              "file" => "/data/core/classes/Core/User.php"
              "line" => 116
              "start_line" => 96
              "highlight_line" => 21
              "code" => """
                    }\n
                \n
                    /**\n
                     * Find a user by unique identifier (username, ID, email, etc).\n
                     * Loads instance variables for this class.\n
                     *\n
                     * @param string $value Unique identifier.\n
                     * @param string $field What column to check for their unique identifier in.\n
                     *\n
                     * @return bool True/false on success or failure respectfully.\n
                     */\n
                    private function find(string $value, string $field = &#039;id&#039;): bool\n
                    {\n
                        if (isset(self::$_user_cache[&quot;$value.$field&quot;])) {\n
                            $this-&gt;_data = self::$_user_cache[&quot;$value.$field&quot;];\n
                \n
                            return true;\n
                        }\n
                \n
                        if ($field !== &#039;hash&#039;) {\n
                            $data = $this-&gt;_db-&gt;get(&#039;users&#039;, [$field, $value]);\n
                        } else {\n
                            $data = $this-&gt;_db-&gt;query(\n
                                &lt;&lt;&lt;&#039;SQL&#039;\n
                                SELECT\n
                                    nl2_users.*\n
                                FROM nl2_users\n
                                    LEFT JOIN nl2_users_session\n
                                    ON nl2_users.id = nl2_users_session.user_id\n
                                WHERE\n
                                    nl2_users_session.hash = ?\n
                                    AND nl2_users_session.active = 1\n
                                    AND (\n
                                        nl2_users_session.expires_at IS NULL\n
                                        OR nl2_users_session.expires_at &gt; ?\n
                                    )\n
                                SQL,\n
                                [\n
                                    $value,\n
                                    time(),\n
                                ]\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_users WHERE `id` = ?"
            "sql_params" => array:1 [
              0 => "5"
            ]
          ]
          29 => array:4 [
            "number" => 30
            "frame" => array:6 [
              "number" => 30
              "file" => "/data/core/classes/Core/User.php"
              "line" => 614
              "start_line" => 594
              "highlight_line" => 21
              "code" => """
                        ]);\n
                \n
                        Session::delete($this-&gt;_admSessionName);\n
                        Cookie::delete($this-&gt;_cookieName . &#039;_adm&#039;);\n
                    }\n
                \n
                    /**\n
                     * Get the user&#039;s groups.\n
                     *\n
                     * @return array&lt;int, Group&gt; Their groups.\n
                     */\n
                    public function getGroups(): array\n
                    {\n
                        if (isset($this-&gt;_groups)) {\n
                            return $this-&gt;_groups;\n
                        }\n
                \n
                        if (isset(self::$_group_cache[$this-&gt;data()-&gt;id])) {\n
                            $this-&gt;_groups = self::$_group_cache[$this-&gt;data()-&gt;id];\n
                        } else {\n
                            $groups_query = $this-&gt;_db-&gt;query(&#039;SELECT nl2_groups.* FROM nl2_users_groups INNER JOIN nl2_groups ON group_id = nl2_groups.id WHERE user_id = ? AND deleted = 0 ORDER BY `order`&#039;, [$this-&gt;data()-&gt;id]);\n
                            if ($groups_query-&gt;count()) {\n
                                foreach ($groups_query-&gt;results() as $item) {\n
                                    $this-&gt;_groups[$item-&gt;id] = new Group($item);\n
                                }\n
                            } else {\n
                                $this-&gt;_groups = [];\n
                            }\n
                \n
                            self::$_group_cache[$this-&gt;data()-&gt;id] = $this-&gt;_groups;\n
                        }\n
                \n
                        if (!count($this-&gt;_groups)) {\n
                            // Get default group\n
                            // TODO: Use PRE_VALIDATED_DEFAULT ?\n
                            $default_group = Group::find(1, &#039;default_group&#039;);\n
                            $default_group_id = $default_group-&gt;id ?? 1;\n
                \n
                            $this-&gt;addGroup($default_group_id);\n
                        }\n
                \n
                """
            ]
            "sql_string" => "SELECT nl2_groups.* FROM nl2_users_groups INNER JOIN nl2_groups ON group_id = nl2_groups.id WHERE user_id = ? AND deleted = 0 ORDER BY `order`"
            "sql_params" => array:1 [
              0 => 5
            ]
          ]
          30 => array:4 [
            "number" => 31
            "frame" => array:6 [
              "number" => 31
              "file" => "/data/core/classes/Core/User.php"
              "line" => 116
              "start_line" => 96
              "highlight_line" => 21
              "code" => """
                    }\n
                \n
                    /**\n
                     * Find a user by unique identifier (username, ID, email, etc).\n
                     * Loads instance variables for this class.\n
                     *\n
                     * @param string $value Unique identifier.\n
                     * @param string $field What column to check for their unique identifier in.\n
                     *\n
                     * @return bool True/false on success or failure respectfully.\n
                     */\n
                    private function find(string $value, string $field = &#039;id&#039;): bool\n
                    {\n
                        if (isset(self::$_user_cache[&quot;$value.$field&quot;])) {\n
                            $this-&gt;_data = self::$_user_cache[&quot;$value.$field&quot;];\n
                \n
                            return true;\n
                        }\n
                \n
                        if ($field !== &#039;hash&#039;) {\n
                            $data = $this-&gt;_db-&gt;get(&#039;users&#039;, [$field, $value]);\n
                        } else {\n
                            $data = $this-&gt;_db-&gt;query(\n
                                &lt;&lt;&lt;&#039;SQL&#039;\n
                                SELECT\n
                                    nl2_users.*\n
                                FROM nl2_users\n
                                    LEFT JOIN nl2_users_session\n
                                    ON nl2_users.id = nl2_users_session.user_id\n
                                WHERE\n
                                    nl2_users_session.hash = ?\n
                                    AND nl2_users_session.active = 1\n
                                    AND (\n
                                        nl2_users_session.expires_at IS NULL\n
                                        OR nl2_users_session.expires_at &gt; ?\n
                                    )\n
                                SQL,\n
                                [\n
                                    $value,\n
                                    time(),\n
                                ]\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_users WHERE `id` = ?"
            "sql_params" => array:1 [
              0 => "1"
            ]
          ]
          31 => array:4 [
            "number" => 32
            "frame" => array:6 [
              "number" => 32
              "file" => "/data/core/classes/Core/User.php"
              "line" => 614
              "start_line" => 594
              "highlight_line" => 21
              "code" => """
                        ]);\n
                \n
                        Session::delete($this-&gt;_admSessionName);\n
                        Cookie::delete($this-&gt;_cookieName . &#039;_adm&#039;);\n
                    }\n
                \n
                    /**\n
                     * Get the user&#039;s groups.\n
                     *\n
                     * @return array&lt;int, Group&gt; Their groups.\n
                     */\n
                    public function getGroups(): array\n
                    {\n
                        if (isset($this-&gt;_groups)) {\n
                            return $this-&gt;_groups;\n
                        }\n
                \n
                        if (isset(self::$_group_cache[$this-&gt;data()-&gt;id])) {\n
                            $this-&gt;_groups = self::$_group_cache[$this-&gt;data()-&gt;id];\n
                        } else {\n
                            $groups_query = $this-&gt;_db-&gt;query(&#039;SELECT nl2_groups.* FROM nl2_users_groups INNER JOIN nl2_groups ON group_id = nl2_groups.id WHERE user_id = ? AND deleted = 0 ORDER BY `order`&#039;, [$this-&gt;data()-&gt;id]);\n
                            if ($groups_query-&gt;count()) {\n
                                foreach ($groups_query-&gt;results() as $item) {\n
                                    $this-&gt;_groups[$item-&gt;id] = new Group($item);\n
                                }\n
                            } else {\n
                                $this-&gt;_groups = [];\n
                            }\n
                \n
                            self::$_group_cache[$this-&gt;data()-&gt;id] = $this-&gt;_groups;\n
                        }\n
                \n
                        if (!count($this-&gt;_groups)) {\n
                            // Get default group\n
                            // TODO: Use PRE_VALIDATED_DEFAULT ?\n
                            $default_group = Group::find(1, &#039;default_group&#039;);\n
                            $default_group_id = $default_group-&gt;id ?? 1;\n
                \n
                            $this-&gt;addGroup($default_group_id);\n
                        }\n
                \n
                """
            ]
            "sql_string" => "SELECT nl2_groups.* FROM nl2_users_groups INNER JOIN nl2_groups ON group_id = nl2_groups.id WHERE user_id = ? AND deleted = 0 ORDER BY `order`"
            "sql_params" => array:1 [
              0 => 1
            ]
          ]
          32 => array:4 [
            "number" => 33
            "frame" => array:6 [
              "number" => 33
              "file" => "/data/modules/Resources/module.php"
              "line" => 184
              "start_line" => 164
              "highlight_line" => 21
              "code" => """
                \n
                                    $navs[2]-&gt;add(&#039;resources_settings&#039;, $this-&gt;_resource_language-&gt;get(&#039;resources&#039;, &#039;settings&#039;), URL::build(&#039;/panel/resources/settings&#039;), &#039;top&#039;, null, ($order + 0.3), $icon);\n
                                }\n
                \n
                            }\n
                        }\n
                \n
                        // AdminCP\n
                        PermissionHandler::registerPermissions(&#039;Resources&#039;, [\n
                            &#039;admincp.resources&#039; =&gt; $this-&gt;_language-&gt;get(&#039;moderator&#039;, &#039;staff_cp&#039;) . &#039; &amp;raquo; &#039; . $this-&gt;_resource_language-&gt;get(&#039;resources&#039;, &#039;resources&#039;),\n
                            &#039;admincp.resources.categories&#039; =&gt; $this-&gt;_language-&gt;get(&#039;moderator&#039;, &#039;staff_cp&#039;) . &#039; &amp;raquo; &#039; . $this-&gt;_resource_language-&gt;get(&#039;resources&#039;, &#039;categories&#039;),\n
                            &#039;admincp.resources.downloads&#039; =&gt; $this-&gt;_language-&gt;get(&#039;moderator&#039;, &#039;staff_cp&#039;) . &#039; &amp;raquo; &#039; . $this-&gt;_resource_language-&gt;get(&#039;resources&#039;, &#039;downloads&#039;),\n
                            &#039;admincp.resources.settings&#039; =&gt; $this-&gt;_language-&gt;get(&#039;moderator&#039;, &#039;staff_cp&#039;) . &#039; &amp;raquo; &#039; . $this-&gt;_resource_language-&gt;get(&#039;resources&#039;, &#039;settings&#039;),\n
                            &#039;admincp.resources.licenses&#039; =&gt; $this-&gt;_language-&gt;get(&#039;moderator&#039;, &#039;staff_cp&#039;) . &#039; &amp;raquo; &#039; . $this-&gt;_resource_language-&gt;get(&#039;resources&#039;, &#039;manage_licenses&#039;),\n
                        ]);\n
                    }\n
                \n
                    // Update to 1.6.0\n
                    private static function updateTo160($cache) {\n
                        try {\n
                            DB::getInstance()-&gt;query(&#039;ALTER TABLE `nl2_resources` ADD `short_description` varchar(64) NULL DEFAULT NULL&#039;);\n
                            DB::getInstance()-&gt;query(&#039;ALTER TABLE `nl2_resources` ADD `has_icon` tinyint(1) NOT NULL DEFAULT \&#039;0\&#039;&#039;);\n
                            DB::getInstance()-&gt;query(&#039;ALTER TABLE `nl2_resources` ADD `icon` varchar(512) NULL DEFAULT NULL&#039;);\n
                            DB::getInstance()-&gt;query(&#039;ALTER TABLE `nl2_resources` ADD `icon_updated` int(11) NOT NULL DEFAULT \&#039;0\&#039;&#039;);\n
                \n
                            $cache-&gt;store(&#039;160&#039;, true);\n
                \n
                            mkdir(ROOT_PATH . &#039;/uploads/resources_icons&#039;);\n
                        } catch (Exception $e) {\n
                            // continue anyway\n
                        }\n
                    }\n
                \n
                    public function getDebugInfo(): array {\n
                        return [];\n
                    }\n
                }\n
                """
            ]
            "sql_string" => "ALTER TABLE `nl2_resources` ADD `short_description` varchar(64) NULL DEFAULT NULL"
            "sql_params" => []
          ]
          33 => array:4 [
            "number" => 34
            "frame" => array:6 [
              "number" => 34
              "file" => "/data/modules/Patreon/module.php"
              "line" => 110
              "start_line" => 90
              "highlight_line" => 21
              "code" => """
                                // Navbar\n
                                $navs[0]-&gt;add(&#039;patreon_sponsors&#039;, $this-&gt;_patreon_language-&gt;get(&#039;general&#039;, &#039;sponsors&#039;), URL::build(&#039;/sponsors&#039;), &#039;top&#039;, null, $order, $icon);\n
                                break;\n
                            case 2:\n
                                // &quot;More&quot; dropdown\n
                                $navs[0]-&gt;addItemToDropdown(&#039;more_dropdown&#039;, &#039;patreon_sponsors&#039;, $this-&gt;_patreon_language-&gt;get(&#039;general&#039;, &#039;sponsors&#039;), URL::build(&#039;/sponsors&#039;), &#039;top&#039;, null, $icon, $order);\n
                                break;\n
                            case 3:\n
                                // Footer\n
                                $navs[0]-&gt;add(&#039;patreon_sponsors&#039;, $this-&gt;_patreon_language-&gt;get(&#039;general&#039;, &#039;sponsors&#039;), URL::build(&#039;/sponsors&#039;), &#039;footer&#039;, null, $order, $icon);\n
                                break;\n
                        }\n
                \n
                        $cache-&gt;setCache(&#039;patreon_members_list&#039;);\n
                        if ($cache-&gt;isCached(&#039;members_list&#039;)) {\n
                            $members_list = $cache-&gt;retrieve(&#039;members_list&#039;);\n
                        } else {\n
                            $integration = Integrations::getInstance()-&gt;getIntegration(&#039;Patreon&#039;);\n
                \n
                            $members_list = [];\n
                            $patreons = DB::getInstance()-&gt;query(&quot;SELECT *, TRUNCATE(currently_entitled_amount_cents / pledge_cadence, 0) AS amount FROM nl2_patreon_users WHERE status = &#039;active_patron&#039; AND last_charge_status = &#039;Paid&#039; ORDER BY amount DESC&quot;)-&gt;results();\n
                            foreach ($patreons as $patreon) {\n
                                $integration_user = new IntegrationUser($integration, $patreon-&gt;user_id, &#039;identifier&#039;);\n
                                if (!$integration_user-&gt;exists()) {\n
                                    continue;\n
                                }\n
                                $target_user = $integration_user-&gt;getUser();\n
                \n
                                $members_list[] = [\n
                                    &#039;user_id&#039; =&gt; $target_user-&gt;data()-&gt;id,\n
                                    &#039;username&#039; =&gt; $target_user-&gt;getDisplayname(),\n
                                    &#039;user_style&#039; =&gt; $target_user-&gt;getGroupStyle(),\n
                                    &#039;user_profile&#039; =&gt; $target_user-&gt;getProfileURL(),\n
                                    &#039;avatar&#039; =&gt; $target_user-&gt;getAvatar(),\n
                                    &#039;groups&#039; =&gt; $target_user-&gt;getAllGroupHtml(),\n
                                    &#039;user_title&#039; =&gt; Output::getPurified($target_user-&gt;data()-&gt;user_title),\n
                                    &#039;signature&#039; =&gt; Output::getPurified(Text::renderEmojis($target_user-&gt;getSignature())),\n
                                    &#039;currently_entitled_amount&#039; =&gt; $patreon-&gt;amount / 100,\n
                                    &#039;hide_amount&#039; =&gt; $patreon-&gt;hide_amount,\n
                                    &#039;tier_id&#039; =&gt; $patreon-&gt;tier_id\n
                                ];\n
                """
            ]
            "sql_string" => "SELECT *, TRUNCATE(currently_entitled_amount_cents / pledge_cadence, 0) AS amount FROM nl2_patreon_users WHERE status = 'active_patron' AND last_charge_status = 'Paid' ORDER BY amount DESC"
            "sql_params" => []
          ]
          34 => array:4 [
            "number" => 35
            "frame" => array:6 [
              "number" => 35
              "file" => "/data/modules/Core/widgets/OnlineStaffWidget.php"
              "line" => 34
              "start_line" => 14
              "highlight_line" => 21
              "code" => """
                \n
                    private Cache $_cache;\n
                    private Language $_language;\n
                \n
                    public function __construct(TemplateEngine $engine, Language $language, Cache $cache) {\n
                        $this-&gt;_module = &#039;Core&#039;;\n
                        $this-&gt;_name = &#039;Online Staff&#039;;\n
                        $this-&gt;_description = &#039;Displays a list of online staff members on your website.&#039;;\n
                        $this-&gt;_engine = $engine;\n
                \n
                        $this-&gt;_cache = $cache;\n
                        $this-&gt;_language = $language;\n
                    }\n
                \n
                    public function initialise(): void {\n
                        $this-&gt;_cache-&gt;setCache(&#039;online_members&#039;);\n
                \n
                        if ($this-&gt;_cache-&gt;isCached(&#039;staff&#039;)) {\n
                            $online = $this-&gt;_cache-&gt;retrieve(&#039;staff&#039;);\n
                        } else {\n
                            $online = DB::getInstance()-&gt;query(&#039;SELECT U.id FROM nl2_users AS U JOIN nl2_users_groups AS UG ON (U.id = UG.user_id) JOIN nl2_groups AS G ON (UG.group_id = G.id) WHERE G.order = (SELECT min(iG.`order`) FROM nl2_users_groups AS iUG JOIN nl2_groups AS iG ON (iUG.group_id = iG.id) WHERE iUG.user_id = U.id GROUP BY iUG.user_id ORDER BY NULL) AND U.last_online &gt; &#039; . strtotime(&#039;-5 minutes&#039;) . &#039; AND G.staff = 1&#039;)-&gt;results();\n
                            $this-&gt;_cache-&gt;store(&#039;staff&#039;, $online, 120);\n
                        }\n
                \n
                        // Generate HTML code for widget\n
                        if (count($online)) {\n
                            $staff_members = [];\n
                \n
                            foreach ($online as $staff) {\n
                                if (count($staff_members) === 10) {\n
                                    break;\n
                                }\n
                \n
                                $staff_user = new User($staff-&gt;id);\n
                                if ($staff_user-&gt;exists()) {\n
                                    $staff_members[] = [\n
                                        &#039;profile&#039; =&gt; $staff_user-&gt;getProfileURL(),\n
                                        &#039;style&#039; =&gt; $staff_user-&gt;getGroupStyle(),\n
                                        &#039;username&#039; =&gt; $staff_user-&gt;getDisplayname(true),\n
                                        &#039;nickname&#039; =&gt; $staff_user-&gt;getDisplayname(),\n
                                        &#039;avatar&#039; =&gt; $staff_user-&gt;getAvatar(),\n
                """
            ]
            "sql_string" => "SELECT U.id FROM nl2_users AS U JOIN nl2_users_groups AS UG ON (U.id = UG.user_id) JOIN nl2_groups AS G ON (UG.group_id = G.id) WHERE G.order = (SELECT min(iG.`order`) FROM nl2_users_groups AS iUG JOIN nl2_groups AS iG ON (iUG.group_id = iG.id) WHERE iUG.user_id = U.id GROUP BY iUG.user_id ORDER BY NULL) AND U.last_online > 1794700684 AND G.staff = 1"
            "sql_params" => []
          ]
          35 => array:4 [
            "number" => 36
            "frame" => array:6 [
              "number" => 36
              "file" => "/data/core/classes/Core/Settings.php"
              "line" => 45
              "start_line" => 25
              "highlight_line" => 21
              "code" => """
                        $cache_name = $module !== null ? $module : &#039;core&#039;;\n
                        self::$_cached_settings[$cache_name] = $cache;\n
                    }\n
                \n
                    /**\n
                     * Get a setting from the database table `nl2_settings`.\n
                     *\n
                     * @param  string  $setting  Setting to check.\n
                     * @param  ?string $fallback Fallback to return if $setting is not set in DB. Defaults to null.\n
                     * @param  string  $module   Module name to keep settings separate from other modules. Set module\n
                     *                           to &#039;Core&#039; for global settings.\n
                     * @return ?string Setting from DB or $fallback.\n
                     */\n
                    public static function get(string $setting, ?string $fallback = null, string $module = &#039;core&#039;): ?string\n
                    {\n
                        if (!self::hasSettingsCache($module)) {\n
                            // Load all settings for this module and store it as a dictionary\n
                            if ($module === &#039;core&#039;) {\n
                                $result = DB::getInstance()-&gt;query(&#039;SELECT `name`, `value` FROM `nl2_settings` WHERE `module` IS NULL&#039;)-&gt;results();\n
                            } else {\n
                                $result = DB::getInstance()-&gt;query(&#039;SELECT `name`, `value` FROM `nl2_settings` WHERE `module` = ?&#039;, [$module])-&gt;results();\n
                            }\n
                \n
                            $cache = [];\n
                            foreach ($result as $row) {\n
                                $cache[$row-&gt;name] = $row-&gt;value;\n
                            }\n
                            self::setSettingsCache($module, $cache);\n
                        }\n
                \n
                        $cache = &amp;self::getSettingsCache($module);\n
                \n
                        return $cache[$setting] ?? $fallback;\n
                    }\n
                \n
                    /**\n
                     * Modify a setting in the database table `nl2_settings`.\n
                     *\n
                     * @param string      $setting   Setting name.\n
                     * @param string|null $new_value New setting value, or null to delete\n
                     * @param string      $module    Module name to keep settings separate from other modules. Set module\n
                """
            ]
            "sql_string" => "SELECT `name`, `value` FROM `nl2_settings` WHERE `module` = ?"
            "sql_params" => array:1 [
              0 => "Forum"
            ]
          ]
          36 => array:4 [
            "number" => 37
            "frame" => array:6 [
              "number" => 37
              "file" => "/data/modules/Forum/classes/Forum.php"
              "line" => 294
              "start_line" => 274
              "highlight_line" => 21
              "code" => """
                                }\n
                            }\n
                        }\n
                \n
                        return false;\n
                    }\n
                \n
                    /**\n
                     * Get the newest x topics this user/group can view\n
                     *\n
                     * @param array $groups Array of groups the user is in\n
                     * @param int $user_id User ID\n
                     * @param int $limit Limit of topics to return, default 50\n
                     * @return array Latest topics\n
                     */\n
                    public function getLatestDiscussions(array $groups = [0], int $user_id = 0, int $limit = 50): array {\n
                        if (!$user_id) {\n
                            $user_id = 0;\n
                        }\n
                \n
                        $all_topics_forums = DB::getInstance()-&gt;query(&#039;SELECT forum_id FROM nl2_forums_permissions WHERE group_id IN (&#039; . rtrim(implode(&#039;,&#039;, $groups), &#039;,&#039;) . &#039;) AND `view` = 1 AND view_other_topics = 1&#039;)-&gt;results();\n
                \n
                        $own_topics_forums = [];\n
                        if ($user_id &gt; 0) {\n
                            $own_topics_forums = DB::getInstance()-&gt;query(&#039;SELECT forum_id FROM nl2_forums_permissions WHERE group_id IN (&#039; . rtrim(implode(&#039;,&#039;, $groups), &#039;,&#039;) . &#039;) AND `view` = 1 AND view_other_topics = 0&#039;)-&gt;results();\n
                        }\n
                \n
                        if (!count($all_topics_forums) &amp;&amp; !count($own_topics_forums)) {\n
                            return [];\n
                        }\n
                \n
                        $all_topics_forums_string = &#039;&#039;;\n
                        foreach ($all_topics_forums as $forum) {\n
                            $all_topics_forums_string .= $forum-&gt;forum_id . &#039;,&#039;;\n
                        }\n
                        $all_topics_forums_string = rtrim($all_topics_forums_string, &#039;,&#039;);\n
                \n
                        if (count($own_topics_forums)) {\n
                            $own_topics_forums_string = &#039;&#039;;\n
                            foreach ($own_topics_forums as $forum) {\n
                                $own_topics_forums_string .= $forum-&gt;forum_id . &#039;,&#039;;\n
                """
            ]
            "sql_string" => "SELECT forum_id FROM nl2_forums_permissions WHERE group_id IN (0) AND `view` = 1 AND view_other_topics = 1"
            "sql_params" => []
          ]
          37 => array:4 [
            "number" => 38
            "frame" => array:6 [
              "number" => 38
              "file" => "/data/modules/Forum/classes/Forum.php"
              "line" => 328
              "start_line" => 308
              "highlight_line" => 21
              "code" => """
                        }\n
                        $all_topics_forums_string = rtrim($all_topics_forums_string, &#039;,&#039;);\n
                \n
                        if (count($own_topics_forums)) {\n
                            $own_topics_forums_string = &#039;&#039;;\n
                            foreach ($own_topics_forums as $forum) {\n
                                $own_topics_forums_string .= $forum-&gt;forum_id . &#039;,&#039;;\n
                            }\n
                            $own_topics_forums_string = rtrim($own_topics_forums_string, &#039;,&#039;);\n
                \n
                            return DB::getInstance()-&gt;query(\n
                                &quot;(SELECT topics.id as id, topics.forum_id as forum_id, topics.topic_title as topic_title, topics.topic_creator as topic_creator, topics.topic_last_user as topic_last_user, topics.topic_date as topic_date, topics.topic_reply_date as topic_reply_date, topics.topic_views as topic_views, topics.locked as locked, topics.sticky as sticky, topics.label as label, topics.deleted as deleted, posts.id as last_post_id FROM nl2_topics topics LEFT JOIN nl2_posts posts ON topics.id = posts.topic_id AND posts.id = (SELECT MAX(id) FROM nl2_posts p WHERE p.topic_id = topics.id AND p.deleted = 0) WHERE topics.deleted = 0 AND topics.forum_id IN ($all_topics_forums_string) ORDER BY topics.topic_reply_date DESC LIMIT $limit)\n
                                UNION\n
                                (SELECT topics.id as id, topics.forum_id as forum_id, topics.topic_title as topic_title, topics.topic_creator as topic_creator, topics.topic_last_user as topic_last_user, topics.topic_date as topic_date, topics.topic_reply_date as topic_reply_date, topics.topic_views as topic_views, topics.locked as locked, topics.sticky as sticky, topics.label as label, topics.deleted as deleted, posts.id as last_post_id FROM nl2_topics topics LEFT JOIN nl2_posts posts ON topics.id = posts.topic_id AND posts.id = (SELECT MAX(id) FROM nl2_posts p WHERE p.topic_id = topics.id AND p.deleted = 0) WHERE topics.deleted = 0 AND ((topics.forum_id IN ($own_topics_forums_string) AND topics.topic_creator = ?) OR topics.sticky = 1) ORDER BY topics.topic_reply_date DESC LIMIT $limit)\n
                                ORDER BY topic_reply_date DESC LIMIT $limit&quot;,\n
                                [$user_id],\n
                                true\n
                            )-&gt;results();\n
                        }\n
                \n
                        return DB::getInstance()-&gt;query(\n
                            &quot;SELECT topics.id as id, topics.forum_id as forum_id, topics.topic_title as topic_title, topics.topic_creator as topic_creator, topics.topic_last_user as topic_last_user, topics.topic_date as topic_date, topics.topic_reply_date as topic_reply_date, topics.topic_views as topic_views, topics.locked as locked, topics.sticky as sticky, topics.label as label, topics.deleted as deleted, posts.id as last_post_id\n
                            FROM nl2_topics topics \n
                            LEFT JOIN nl2_posts posts ON topics.id = posts.topic_id AND posts.id = (SELECT MAX(id) FROM nl2_posts p WHERE p.topic_id = topics.id AND p.deleted = 0) \n
                            WHERE topics.deleted = 0 AND topics.forum_id IN ($all_topics_forums_string) ORDER BY topics.topic_reply_date DESC LIMIT $limit&quot;,\n
                        )-&gt;results();\n
                    }\n
                \n
                    /**\n
                     * Determine if a topic exists or not.\n
                     *\n
                     * @param int $topic_id The topic ID\n
                     * @return bool Whether the topic exists or not\n
                     */\n
                    public function topicExist(int $topic_id): bool {\n
                        // Does the topic exist?\n
                        $exists = $this-&gt;_db-&gt;get(&#039;topics&#039;, [&#039;id&#039;, $topic_id])-&gt;results();\n
                        return count($exists) &gt; 0;\n
                    }\n
                \n
                    /**\n
                """
            ]
            "sql_string" => """
              SELECT topics.id as id, topics.forum_id as forum_id, topics.topic_title as topic_title, topics.topic_creator as topic_creator, topics.topic_last_user as topic_last_user, topics.topic_date as topic_date, topics.topic_reply_date as topic_reply_date, topics.topic_views as topic_views, topics.locked as locked, topics.sticky as sticky, topics.label as label, topics.deleted as deleted, posts.id as last_post_id\n
                          FROM nl2_topics topics \n
                          LEFT JOIN nl2_posts posts ON topics.id = posts.topic_id AND posts.id = (SELECT MAX(id) FROM nl2_posts p WHERE p.topic_id = topics.id AND p.deleted = 0) \n
                          WHERE topics.deleted = 0 AND topics.forum_id IN (1,2) ORDER BY topics.topic_reply_date DESC LIMIT 5
              """
            "sql_params" => []
          ]
          38 => array:4 [
            "number" => 39
            "frame" => array:6 [
              "number" => 39
              "file" => "/data/modules/Forum/widgets/LatestPostsWidget.php"
              "line" => 58
              "start_line" => 38
              "highlight_line" => 21
              "code" => """
                        $db = DB::getInstance();\n
                        $timeago = new TimeAgo(TIMEZONE);\n
                \n
                        // Get user group IDs\n
                        $user_groups = $this-&gt;_user-&gt;getAllGroupIds();\n
                \n
                        $this-&gt;_cache-&gt;setCache(&#039;forum_discussions_&#039; . rtrim(implode(&#039;-&#039;, $user_groups), &#039;-&#039;));\n
                        if ($this-&gt;_cache-&gt;isCached(&#039;discussions&#039;)) {\n
                            $template_array = $this-&gt;_cache-&gt;retrieve(&#039;discussions&#039;);\n
                \n
                        } else {\n
                            $limit = (int) Settings::get(&#039;latest_posts_limit&#039;, 5, &#039;Forum&#039;);\n
                            // Generate latest posts\n
                            $discussions = $forum-&gt;getLatestDiscussions($user_groups, ($this-&gt;_user-&gt;isLoggedIn() ? $this-&gt;_user-&gt;data()-&gt;id : 0), $limit);\n
                \n
                            $template_array = [];\n
                \n
                            // Generate an array to pass to template\n
                            foreach ($discussions as $discussion) {\n
                                // Get the name of the forum from the ID\n
                                $forum_name = $db-&gt;get(&#039;forums&#039;, [&#039;id&#039;, $discussion-&gt;forum_id])-&gt;results();\n
                                $forum_name = Output::getPurified($forum_name[0]-&gt;forum_title);\n
                \n
                                // Get the number of replies\n
                                $posts = $db-&gt;query(&#039;SELECT COUNT(*) as c FROM nl2_posts WHERE `topic_id` = ? AND `deleted` = 0&#039;, [$discussion-&gt;id])-&gt;first()-&gt;c;\n
                \n
                                // Is there a label?\n
                                if ($discussion-&gt;label != 0) {\n
                                    // Get label\n
                                    $label = $db-&gt;get(&#039;forums_topic_labels&#039;, [&#039;id&#039;, $discussion-&gt;label])-&gt;results();\n
                                    if (count($label)) {\n
                                        $label = $label[0];\n
                \n
                                        $label_html = $db-&gt;get(&#039;forums_labels&#039;, [&#039;id&#039;, $label-&gt;label])-&gt;results();\n
                                        if (count($label_html)) {\n
                                            $label_html = $label_html[0]-&gt;html;\n
                                            $label = str_replace(&#039;{x}&#039;, Output::getClean($label-&gt;name), $label_html);\n
                                        } else {\n
                                            $label = &#039;&#039;;\n
                                        }\n
                                    } else {\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_forums WHERE `id` = ?"
            "sql_params" => array:1 [
              0 => 2
            ]
          ]
          39 => array:4 [
            "number" => 40
            "frame" => array:6 [
              "number" => 40
              "file" => "/data/modules/Forum/widgets/LatestPostsWidget.php"
              "line" => 62
              "start_line" => 42
              "highlight_line" => 21
              "code" => """
                        $user_groups = $this-&gt;_user-&gt;getAllGroupIds();\n
                \n
                        $this-&gt;_cache-&gt;setCache(&#039;forum_discussions_&#039; . rtrim(implode(&#039;-&#039;, $user_groups), &#039;-&#039;));\n
                        if ($this-&gt;_cache-&gt;isCached(&#039;discussions&#039;)) {\n
                            $template_array = $this-&gt;_cache-&gt;retrieve(&#039;discussions&#039;);\n
                \n
                        } else {\n
                            $limit = (int) Settings::get(&#039;latest_posts_limit&#039;, 5, &#039;Forum&#039;);\n
                            // Generate latest posts\n
                            $discussions = $forum-&gt;getLatestDiscussions($user_groups, ($this-&gt;_user-&gt;isLoggedIn() ? $this-&gt;_user-&gt;data()-&gt;id : 0), $limit);\n
                \n
                            $template_array = [];\n
                \n
                            // Generate an array to pass to template\n
                            foreach ($discussions as $discussion) {\n
                                // Get the name of the forum from the ID\n
                                $forum_name = $db-&gt;get(&#039;forums&#039;, [&#039;id&#039;, $discussion-&gt;forum_id])-&gt;results();\n
                                $forum_name = Output::getPurified($forum_name[0]-&gt;forum_title);\n
                \n
                                // Get the number of replies\n
                                $posts = $db-&gt;query(&#039;SELECT COUNT(*) as c FROM nl2_posts WHERE `topic_id` = ? AND `deleted` = 0&#039;, [$discussion-&gt;id])-&gt;first()-&gt;c;\n
                \n
                                // Is there a label?\n
                                if ($discussion-&gt;label != 0) {\n
                                    // Get label\n
                                    $label = $db-&gt;get(&#039;forums_topic_labels&#039;, [&#039;id&#039;, $discussion-&gt;label])-&gt;results();\n
                                    if (count($label)) {\n
                                        $label = $label[0];\n
                \n
                                        $label_html = $db-&gt;get(&#039;forums_labels&#039;, [&#039;id&#039;, $label-&gt;label])-&gt;results();\n
                                        if (count($label_html)) {\n
                                            $label_html = $label_html[0]-&gt;html;\n
                                            $label = str_replace(&#039;{x}&#039;, Output::getClean($label-&gt;name), $label_html);\n
                                        } else {\n
                                            $label = &#039;&#039;;\n
                                        }\n
                                    } else {\n
                                        $label = &#039;&#039;;\n
                                    }\n
                                } else { // no\n
                                    $label = &#039;&#039;;\n
                """
            ]
            "sql_string" => "SELECT COUNT(*) as c FROM nl2_posts WHERE `topic_id` = ? AND `deleted` = 0"
            "sql_params" => array:1 [
              0 => 2
            ]
          ]
          40 => array:4 [
            "number" => 41
            "frame" => array:6 [
              "number" => 41
              "file" => "/data/core/classes/Core/User.php"
              "line" => 654
              "start_line" => 634
              "highlight_line" => 21
              "code" => """
                \n
                        return $this-&gt;_groups;\n
                    }\n
                \n
                    /**\n
                     * Get the user&#039;s integrations.\n
                     *\n
                     * @return IntegrationUser[] Their integrations.\n
                     */\n
                    public function getIntegrations(): array\n
                    {\n
                        if (isset($this-&gt;_integrations)) {\n
                            return $this-&gt;_integrations;\n
                        }\n
                \n
                        $integrations = Integrations::getInstance();\n
                \n
                        if (isset(self::$_integration_cache[$this-&gt;data()-&gt;id])) {\n
                            $integrations_query = self::$_integration_cache[$this-&gt;data()-&gt;id];\n
                        } else {\n
                            $integrations_query = $this-&gt;_db-&gt;query(&#039;SELECT nl2_users_integrations.*, nl2_integrations.name as integration_name FROM nl2_users_integrations LEFT JOIN nl2_integrations ON integration_id=nl2_integrations.id WHERE user_id = ?&#039;, [$this-&gt;data()-&gt;id]);\n
                            if ($integrations_query-&gt;count()) {\n
                                $integrations_query = $integrations_query-&gt;results();\n
                            } else {\n
                                $integrations_query = [];\n
                            }\n
                            self::$_integration_cache[$this-&gt;data()-&gt;id] = $integrations_query;\n
                        }\n
                \n
                        $integrations_list = [];\n
                        foreach ($integrations_query as $item) {\n
                            $integration = $integrations-&gt;getIntegration($item-&gt;integration_name);\n
                            if ($integration != null) {\n
                                $integrationUser = new IntegrationUser($integration, $this-&gt;data()-&gt;id, &#039;user_id&#039;, $item);\n
                \n
                                $integrations_list[$item-&gt;integration_name] = $integrationUser;\n
                            }\n
                        }\n
                \n
                        return $this-&gt;_integrations = $integrations_list;\n
                    }\n
                """
            ]
            "sql_string" => "SELECT nl2_users_integrations.*, nl2_integrations.name as integration_name FROM nl2_users_integrations LEFT JOIN nl2_integrations ON integration_id=nl2_integrations.id WHERE user_id = ?"
            "sql_params" => array:1 [
              0 => 1
            ]
          ]
          41 => array:4 [
            "number" => 42
            "frame" => array:6 [
              "number" => 42
              "file" => "/data/modules/Forum/widgets/LatestPostsWidget.php"
              "line" => 58
              "start_line" => 38
              "highlight_line" => 21
              "code" => """
                        $db = DB::getInstance();\n
                        $timeago = new TimeAgo(TIMEZONE);\n
                \n
                        // Get user group IDs\n
                        $user_groups = $this-&gt;_user-&gt;getAllGroupIds();\n
                \n
                        $this-&gt;_cache-&gt;setCache(&#039;forum_discussions_&#039; . rtrim(implode(&#039;-&#039;, $user_groups), &#039;-&#039;));\n
                        if ($this-&gt;_cache-&gt;isCached(&#039;discussions&#039;)) {\n
                            $template_array = $this-&gt;_cache-&gt;retrieve(&#039;discussions&#039;);\n
                \n
                        } else {\n
                            $limit = (int) Settings::get(&#039;latest_posts_limit&#039;, 5, &#039;Forum&#039;);\n
                            // Generate latest posts\n
                            $discussions = $forum-&gt;getLatestDiscussions($user_groups, ($this-&gt;_user-&gt;isLoggedIn() ? $this-&gt;_user-&gt;data()-&gt;id : 0), $limit);\n
                \n
                            $template_array = [];\n
                \n
                            // Generate an array to pass to template\n
                            foreach ($discussions as $discussion) {\n
                                // Get the name of the forum from the ID\n
                                $forum_name = $db-&gt;get(&#039;forums&#039;, [&#039;id&#039;, $discussion-&gt;forum_id])-&gt;results();\n
                                $forum_name = Output::getPurified($forum_name[0]-&gt;forum_title);\n
                \n
                                // Get the number of replies\n
                                $posts = $db-&gt;query(&#039;SELECT COUNT(*) as c FROM nl2_posts WHERE `topic_id` = ? AND `deleted` = 0&#039;, [$discussion-&gt;id])-&gt;first()-&gt;c;\n
                \n
                                // Is there a label?\n
                                if ($discussion-&gt;label != 0) {\n
                                    // Get label\n
                                    $label = $db-&gt;get(&#039;forums_topic_labels&#039;, [&#039;id&#039;, $discussion-&gt;label])-&gt;results();\n
                                    if (count($label)) {\n
                                        $label = $label[0];\n
                \n
                                        $label_html = $db-&gt;get(&#039;forums_labels&#039;, [&#039;id&#039;, $label-&gt;label])-&gt;results();\n
                                        if (count($label_html)) {\n
                                            $label_html = $label_html[0]-&gt;html;\n
                                            $label = str_replace(&#039;{x}&#039;, Output::getClean($label-&gt;name), $label_html);\n
                                        } else {\n
                                            $label = &#039;&#039;;\n
                                        }\n
                                    } else {\n
                """
            ]
            "sql_string" => "SELECT * FROM nl2_forums WHERE `id` = ?"
            "sql_params" => array:1 [
              0 => 2
            ]
          ]
          42 => array:4 [
            "number" => 43
            "frame" => array:6 [
              "number" => 43
              "file" => "/data/modules/Forum/widgets/LatestPostsWidget.php"
              "line" => 62
              "start_line" => 42
              "highlight_line" => 21
              "code" => """
                        $user_groups = $this-&gt;_user-&gt;getAllGroupIds();\n
                \n
                        $this-&gt;_cache-&gt;setCache(&#039;forum_discussions_&#039; . rtrim(implode(&#039;-&#039;, $user_groups), &#039;-&#039;));\n
                        if ($this-&gt;_cache-&gt;isCached(&#039;discussions&#039;)) {\n
                            $template_array = $this-&gt;_cache-&gt;retrieve(&#039;discussions&#039;);\n
                \n
                        } else {\n
                            $limit = (int) Settings::get(&#039;latest_posts_limit&#039;, 5, &#039;Forum&#039;);\n
                            // Generate latest posts\n
                            $discussions = $forum-&gt;getLatestDiscussions($user_groups, ($this-&gt;_user-&gt;isLoggedIn() ? $this-&gt;_user-&gt;data()-&gt;id : 0), $limit);\n
                \n
                            $template_array = [];\n
                \n
                            // Generate an array to pass to template\n
                            foreach ($discussions as $discussion) {\n
                                // Get the name of the forum from the ID\n
                                $forum_name = $db-&gt;get(&#039;forums&#039;, [&#039;id&#039;, $discussion-&gt;forum_id])-&gt;results();\n
                                $forum_name = Output::getPurified($forum_name[0]-&gt;forum_title);\n
                \n
                                // Get the number of replies\n
                                $posts = $db-&gt;query(&#039;SELECT COUNT(*) as c FROM nl2_posts WHERE `topic_id` = ? AND `deleted` = 0&#039;, [$discussion-&gt;id])-&gt;first()-&gt;c;\n
                \n
                                // Is there a label?\n
                                if ($discussion-&gt;label != 0) {\n
                                    // Get label\n
                                    $label = $db-&gt;get(&#039;forums_topic_labels&#039;, [&#039;id&#039;, $discussion-&gt;label])-&gt;results();\n
                                    if (count($label)) {\n
                                        $label = $label[0];\n
                \n
                                        $label_html = $db-&gt;get(&#039;forums_labels&#039;, [&#039;id&#039;, $label-&gt;label])-&gt;results();\n
                                        if (count($label_html)) {\n
                                            $label_html = $label_html[0]-&gt;html;\n
                                            $label = str_replace(&#039;{x}&#039;, Output::getClean($label-&gt;name), $label_html);\n
                                        } else {\n
                                            $label = &#039;&#039;;\n
                                        }\n
                                    } else {\n
                                        $label = &#039;&#039;;\n
                                    }\n
                                } else { // no\n
                                    $label = &#039;&#039;;\n
                """
            ]
            "sql_string" => "SELECT COUNT(*) as c FROM nl2_posts WHERE `topic_id` = ? AND `deleted` = 0"
            "sql_params" => array:1 [
              0 => 1
            ]
          ]
        ]
        -_query_stack_num: 44
      }
    }
    -_data: ProductData {#569
      +id: 9
      +category_id: 1
      +name: "Sponsored Slot"
      +price_cents: 1000
      +description: """
        <p>With sponsored slot your server will be listed on top for a whole month.</p>\r\n
        <p>Your server will also be announced to several big discord servers including everyone tag in MC Server List discord.</p>
        """
      +image: null
      +durability: "{"interval":"1","period":"month"}"
      +global_limit: "{"limit":"0","interval":"1","period":"no_period"}"
      +user_limit: "{"limit":"0","interval":"1","period":"no_period"}"
      +required_products: "[]"
      +required_groups: "[]"
      +required_integrations: "[]"
      +require_one_product: true
      +allowed_gateways: "["2"]"
      +min_player_age: "{"interval":0,"period":"hour"}"
      +min_player_playtime: "{"playtime":0,"interval":1,"period":"all_time"}"
      +payment_type: 3
      +hidden: false
      +disabled: false
      +hide_if_owned: false
      +order: 2
      +deleted: 0
      +sale_active: false
      +sale_discount_cents: 0
    }
  }
  "shopping_cart" => ShoppingCart {#316
    -_items: ItemList {#318
      -_items: []
    }
    -_order: null
    -_coupon: null
    -_customer: Customer {#317
      -_customer_spending_cache: []
      -_db: DB {#23}
      -_data: null
      -_isLoggedIn: false
    }
    -_recipient: Customer {#317}
    -_subscription_mode: false
  }
  "name" => "Sponsored Slot"
  "content" => """
    <p>With sponsored slot your server will be listed on top for a whole month.</p>\r\n
    <p>Your server will also be announced to several big discord servers including everyone tag in MC Server List discord.</p>
    """
  "image" => null
  "hidden" => false
  "disabled" => false
]
Development

Development

Store » Home

Online Staff

Latest Posts

Testing site

Welcome to NamelessMC!

Development

Links

Social
