- $_GET
-
Array(
sortby => date,
start => 500
)
Array(
sortby => date,
start => 500
)
- $_POST
-
Array(
)
Array(
)
- $_COOKIE
-
Array(
cookie => 43a25f71035b89b5,
81f30cf708470b974874c8a96a6bcdb2 => c9319f1504530deb6a7138...
Array(
cookie => 43a25f71035b89b5,
81f30cf708470b974874c8a96a6bcdb2 => c9319f1504530deb6a71381a618ad5a7,
d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 2444543 7406F5D 11B 37E B4A 3 05F41134B514059 4 951135F765817 3 B5C1243 B5612 F16 3 B 2 A1B5A 156525F5E 5 7 75151 7 1 05D 15258 F57 3 85353 6 55D585C 551 E1B 3165952 2164044 C 016 A17 25056 31A 5 9 353 B56 550 9 C 5 3 95D5D 755 7 F 5 1 F54 5 2 05C59 75158 F44 B4358 6 A16164A515412 24A 256515C1A57 B 4545D52 051 85751 A 8 255525453 7 556 1 951 6 8 159 156 7 F16 94A,
8512ae7d57b1396273f76fe6ed341a23 => en-GB
)
- $_SERVER
-
Array(
REDIRECT_HTTPS => on,
REDIRECT_SCRIPT_URL => /en/publications/browse/14,
REDIRECT_SC...
Array(
REDIRECT_HTTPS => on,
REDIRECT_SCRIPT_URL => /en/publications/browse/14,
REDIRECT_SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/en/publications/browse/14,
REDIRECT_STATUS => 200,
HTTPS => on,
SCRIPT_URL => /en/publications/browse/14,
SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/en/publications/browse/14,
HTTP_HOST => hsscommons.rs-dev.uvic.ca,
HTTP_USER_AGENT => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com),
HTTP_ACCEPT => */*,
HTTP_ACCEPT_ENCODING => gzip, br, zstd, deflate,
HTTP_COOKIE => cookie=43a25f71035b89b5; 81f30cf708470b974874c8a96a6bcdb2=c9319f1504530deb6a71381a618ad5a7; d482552ea4a74f85af0bb3d73890dabc=%205%20E%2045E43105E%20E%202444543%207406F5D%2011B%2037E%20B4A%203%2005F41134B514059%204%20951135F765817%203%20B5C1243%20B5612%20F16%203%20B%202%20A1B5A%20156525F5E%205%207%2075151%207%201%2005D%2015258%20F57%203%2085353%206%2055D585C%20551%20E1B%203165952%202164044%20C%20016%20A17%2025056%2031A%205%209%20353%20B56%20550%209%20C%205%203%2095D5D%20755%207%20F%205%201%20F54%205%202%2005C59%2075158%20F44%20B4358%206%20A16164A515412%2024A%20256515C1A57%20B%204545D52%20051%2085751%20A%208%20255525453%207%20556%201%20951%206%208%20159%20156%207%20F16%2094A; 8512ae7d57b1396273f76fe6ed341a23=en-GB,
HTTP_X_FORWARDED_FOR => 18.222.183.63,
HTTP_X_FORWARDED_HOST => hsscommons.rs-dev.uvic.ca,
HTTP_X_FORWARDED_PORT => 443,
HTTP_X_FORWARDED_PROTO => https,
HTTP_X_FORWARDED_SERVER => traefik-b8d8564f8-2whv9,
HTTP_X_REAL_IP => 18.222.183.63,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin,
SERVER_SIGNATURE =>
SERVER_SOFTWARE => Apache/2.4.62 (Debian),
SERVER_NAME => hsscommons.rs-dev.uvic.ca,
SERVER_ADDR => 10.233.98.122,
SERVER_PORT => 80,
REMOTE_ADDR => 10.233.94.22,
DOCUMENT_ROOT => /var/www/html,
REQUEST_SCHEME => http,
CONTEXT_PREFIX =>
CONTEXT_DOCUMENT_ROOT => /var/www/html,
SERVER_ADMIN => webmaster@localhost,
SCRIPT_FILENAME => /var/www/html/index.php,
REMOTE_PORT => 32812,
REDIRECT_URL => /en/publications/browse/14,
REDIRECT_QUERY_STRING => sortby=date&start=500,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => sortby=date&start=500,
REQUEST_URI => /en/publications/browse/14?sortby=date&start=500,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1745175479.9047,
REQUEST_TIME => 1745175479
)
session.client.forwarded ⇒ 18.222.183.63
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
always ⇒
0 ⇒ registerDate
1 ⇒ registerIP
2 ⇒ access
renew ⇒
tracker.sid ⇒ c9319f1504530deb6a71381a618ad5a7
tracker.ssid ⇒ c9319f1504530deb6a71381a618ad5a7
tracker.rsid ⇒ c9319f1504530deb6a71381a618ad5a7
session.token ⇒ 06e31b4bb9f4478112f364356ec95eec
18 MB
80 Queries Logged: 0.65684413909912 seconds
SELECT data
FROM `jos_session`
WHERE `session_id` = 'c9319f1504530deb6a71381a618ad5a7'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_languages'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_members'SELECT b.id, b.title
FROM `jos_usergroups` AS `a`
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE `a`.`id` = '1'SELECT *
FROM `jos_viewlevels`SELECT folder AS type,element AS name,protected,params
FROM `jos_extensions`
WHERE `enabled` >= '1'
AND `type` = 'plugin'
AND `state` >= ''
AND `access` IN ('1','1','4')
ORDER BY `ordering` ASCSELECT *
FROM `jos_languages`
WHERE `published` = '1'
ORDER BY `ordering` ASCSELECT language,id
FROM `jos_menu`
WHERE `home` = '1'
AND `published` = '1'
AND `client_id` = ''SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
FROM `jos_menu` AS `m`
LEFT JOIN jos_extensions AS e
ON e.extension_id = m.component_id
WHERE `m`.`published` = '1'
AND `m`.`parent_id` > ''
AND `m`.`client_id` = ''
ORDER BY `m`.`lft` ASCSELECT con.`id`
FROM `jos_content` AS con
LEFT JOIN `jos_categories` AS cat
ON con.catid = cat.id
WHERE con.state=1
AND con.`alias` = '14'
AND cat.`path` = 'publications/browse'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_publications'SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
FROM `jos_template_styles`
INNER JOIN jos_extensions
ON jos_extensions.element = jos_template_styles.template
WHERE `jos_template_styles`.`client_id` = ''
AND `jos_extensions`.`enabled` = '1'
AND `jos_extensions`.`type` = 'template'
AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
ORDER BY `home` DESCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_tags'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_projects'SHOW FULL COLUMNS
FROM `jos_publication_categories`SELECT *
FROM jos_publication_categories as C
WHERE C.state=1
ORDER BY C.name ASCSHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SHOW FULL COLUMNS
FROM `jos_publication_master_types`SHOW FULL COLUMNS
FROM `jos_publication_categories`SHOW FULL COLUMNS
FROM `jos_publications`SELECT C.id
FROM
jos_publication_versions V
LEFT JOIN jos_publications C
ON V.publication_id = C.id
LEFT JOIN jos_projects PP
ON PP.id = C.project_id
LEFT JOIN jos_publication_master_types MT
ON MT.id = C.master_type
LEFT JOIN jos_publication_categories AS t
ON t.id = C.category
WHERE 1
AND V.version_number = (SELECT MAX(version_number)
FROM jos_publication_versions
WHERE publication_id=C.id
AND state=1 )
AND (V.state=1)
AND C.category=14
AND (V.published_up IS NULL OR V.published_up = '0000-00-00 00:00:00' OR V.published_up <= '2025-04-20 18:58:00')
AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2025-04-20 18:58:00')
AND V.state != 2
AND (V.access != 2)
GROUP BY C.id, V.id SELECT V.*, C.id as id, C.category, C.project_id, C.access as master_access,
C.checked_out, C.checked_out_time, C.rating as master_rating,
C.group_owner, C.master_type, C.master_doi,
C.ranking as master_ranking, C.times_rated as master_times_rated,
C.alias, V.id as version_id, t.name AS cat_name, t.alias as cat_alias,
t.url_alias as cat_url, PP.alias as project_alias, PP.title as project_title,
PP.state as project_status, PP.private as project_private,
PP.provisioned as project_provisioned, MT.alias as base, MT.params as type_params, (SELECT vv.version_label
FROM `jos_publication_versions` as vv
WHERE vv.publication_id=C.id
AND vv.state=3
ORDER BY ID DESC
LIMIT 1) AS dev_version_label , (SELECT COUNT(*)
FROM `jos_publication_versions`
WHERE publication_id=C.id
AND state!=3) AS versions
FROM
jos_publication_versions V
LEFT JOIN jos_publications C
ON V.publication_id = C.id
LEFT JOIN jos_projects PP
ON PP.id = C.project_id
LEFT JOIN jos_publication_master_types MT
ON MT.id = C.master_type
LEFT JOIN jos_publication_categories AS t
ON t.id = C.category
WHERE 1
AND V.version_number = (SELECT MAX(version_number)
FROM jos_publication_versions
WHERE publication_id=C.id
AND state=1 )
AND (V.state=1)
AND C.category=14
AND (V.published_up IS NULL OR V.published_up = '0000-00-00 00:00:00' OR V.published_up <= '2025-04-20 18:58:00')
AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2025-04-20 18:58:00')
AND V.state != 2
AND (V.access != 2)
GROUP BY C.id, V.id
ORDER BY V.published_up DESC
LIMIT 500, 20SHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SELECT *
FROM `jos_publication_categories`
WHERE `id` = '14'SHOW FULL COLUMNS
FROM `jos_publication_authors`SELECT A.*, PO.invited_name, PO.invited_email
FROM jos_publication_authors as A JOIN jos_project_owners as PO
ON PO.id=A.project_owner_id
WHERE A.publication_version_id='2591'
AND A.status=1
AND (A.role != 'submitter' || A.role IS NULL)
ORDER BY A.ordering ASC SELECT *
FROM `jos_users`
WHERE `jos_users`.`id` = ''SELECT *
FROM `jos_user_profiles`
WHERE `jos_user_profiles`.`user_id` = NULLSELECT A.*, PO.invited_name, PO.invited_email
FROM jos_publication_authors as A JOIN jos_project_owners as PO
ON PO.id=A.project_owner_id
WHERE A.publication_version_id='2592'
AND A.status=1
AND (A.role != 'submitter' || A.role IS NULL)
ORDER BY A.ordering ASC SELECT A.*, PO.invited_name, PO.invited_email
FROM jos_publication_authors as A JOIN jos_project_owners as PO
ON PO.id=A.project_owner_id
WHERE A.publication_version_id='2593'
AND A.status=1
AND (A.role != 'submitter' || A.role IS NULL)
ORDER BY A.ordering ASC SELECT A.*, PO.invited_name, PO.invited_email
FROM jos_publication_authors as A JOIN jos_project_owners as PO
ON PO.id=A.project_owner_id
WHERE A.publication_version_id='2594'
AND A.status=1
AND (A.role != 'submitter' || A.role IS NULL)
ORDER BY A.ordering ASC SELECT A.*, PO.invited_name, PO.invited_email
FROM jos_publication_authors as A JOIN jos_project_owners as PO
ON PO.id=A.project_owner_id
WHERE A.publication_version_id='2595'
AND A.status=1
AND (A.role != 'submitter' || A.role IS NULL)
ORDER BY A.ordering ASC SELECT A.*, PO.invited_name, PO.invited_email
FROM jos_publication_authors as A JOIN jos_project_owners as PO
ON PO.id=A.project_owner_id
WHERE A.publication_version_id='2596'
AND A.status=1
AND (A.role != 'submitter' || A.role IS NULL)
ORDER BY A.ordering ASC SELECT A.*, PO.invited_name, PO.invited_email
FROM jos_publication_authors as A JOIN jos_project_owners as PO
ON PO.id=A.project_owner_id
WHERE A.publication_version_id='2597'
AND A.status=1
AND (A.role != 'submitter' || A.role IS NULL)
ORDER BY A.ordering ASC SELECT A.*, PO.invited_name, PO.invited_email
FROM jos_publication_authors as A JOIN jos_project_owners as PO
ON PO.id=A.project_owner_id
WHERE A.publication_version_id='2598'
AND A.status=1
AND (A.role != 'submitter' || A.role IS NULL)
ORDER BY A.ordering ASC SELECT A.*, PO.invited_name, PO.invited_email
FROM jos_publication_authors as A JOIN jos_project_owners as PO
ON PO.id=A.project_owner_id
WHERE A.publication_version_id='2599'
AND A.status=1
AND (A.role != 'submitter' || A.role IS NULL)
ORDER BY A.ordering ASC SELECT A.*, PO.invited_name, PO.invited_email
FROM jos_publication_authors as A JOIN jos_project_owners as PO
ON PO.id=A.project_owner_id
WHERE A.publication_version_id='2600'
AND A.status=1
AND (A.role != 'submitter' || A.role IS NULL)
ORDER BY A.ordering ASC SELECT A.*, PO.invited_name, PO.invited_email
FROM jos_publication_authors as A JOIN jos_project_owners as PO
ON PO.id=A.project_owner_id
WHERE A.publication_version_id='2601'
AND A.status=1
AND (A.role != 'submitter' || A.role IS NULL)
ORDER BY A.ordering ASC SELECT A.*, PO.invited_name, PO.invited_email
FROM jos_publication_authors as A JOIN jos_project_owners as PO
ON PO.id=A.project_owner_id
WHERE A.publication_version_id='2614'
AND A.status=1
AND (A.role != 'submitter' || A.role IS NULL)
ORDER BY A.ordering ASC SELECT t.tag, t.raw_tag, t.admin, tj.tagid, tj.objectid, COUNT(tj.tagid) AS tcount
FROM jos_tags AS t JOIN jos_tags_object AS tj
ON t.id=tj.tagid
LEFT JOIN jos_publication_versions AS V
ON V.id=tj.objectid
AND tj.tbl='publications'
WHERE t.id=tj.tagid
AND t.admin=0
AND tj.tbl='publications'
AND V.state=1
AND V.main=1
AND V.access!=4
AND V.published_up < '2025-04-20 18:58:00'
AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down > '2025-04-20 18:58:00')
GROUP BY tj.tagid
ORDER BY tcount DESC
LIMIT 20SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_search'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_register'SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
FROM `jos_modules` AS `m`
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE `m`.`published` = '1'
AND `e`.`enabled` = '1'
AND (`m`.`publish_up` IS NULL
OR `m`.`publish_up` <= '2025-04-20 18:58:00'
)
AND (`m`.`publish_down` IS NULL
OR `m`.`publish_down` >= '2025-04-20 18:58:00'
)
AND `m`.`access` IN ('1','1','4')
AND `m`.`client_id` = ''
AND (`mm`.`menuid` = ''
OR `mm`.`menuid` <= ''
)
AND `m`.`language` IN ('en-GB','*')
ORDER BY `m`.`position` ASC,`m`.`ordering` ASCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_menus'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_categories'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_collections'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_events'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_blog'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_groups'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_forum'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_answers'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_support'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_kb'UPDATE `jos_session`
SET `data` = '__default|a:11:{s:15:\"session.counter\";i:8;s:19:\"session.timer.start\";i:1745175478;s:18:\"session.timer.last\";i:1745175479;s:17:\"session.timer.now\";i:1745175479;s:24:\"session.client.forwarded\";s:13:\"18.222.183.63\";s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:1:\"0\";s:7:\"session\";}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:17:\"Hubzero\\User\\User\":1:{s:5:\"guest\";b:1;}s:11:\"tracker.sid\";s:32:\"c9319f1504530deb6a71381a618ad5a7\";s:12:\"tracker.ssid\";s:32:\"c9319f1504530deb6a71381a618ad5a7\";s:12:\"tracker.rsid\";s:32:\"c9319f1504530deb6a71381a618ad5a7\";s:13:\"session.token\";s:32:\"06e31b4bb9f4478112f364356ec95eec\";}',`time` = '1745175480',`ip` = '10.233.94.22'
WHERE `session_id` = 'c9319f1504530deb6a71381a618ad5a7'
onAfterInitialise — Method — plgSystemLanguageFilter::onAfterInitialise → /app/plugins/system/languagefilter/languagefilter.php:186onAfterInitialise — Method — plgSystemP3p::onAfterInitialise → /core/plugins/system/p3p/p3p.php:21onAfterInitialise — Method — plgSystemRemember::onAfterInitialise → /core/plugins/system/remember/remember.php:20onAfterInitialise — Method — plgSystemHubzero::onAfterInitialise → /core/plugins/system/hubzero/hubzero.php:21onAfterInitialise — Method — plgSystemXFeed::onAfterInitialise → /core/plugins/system/xfeed/xfeed.php:21onAfterInitialise — Method — plgSystemSupergroup::onAfterInitialise → /core/plugins/system/supergroup/supergroup.php:113onAfterInitialise — Method — plgSystemReferrerpolicy::onAfterInitialise → /core/plugins/system/referrerpolicy/referrerpolicy.php:21onAfterRoute — Method — plgSystemJquery::onAfterRoute → /core/plugins/system/jquery/jquery.php:21onAfterRoute — Method — plgSystemSpamjail::onAfterRoute → /core/plugins/system/spamjail/spamjail.php:21onAfterRoute — Method — plgSystemIncomplete::onAfterRoute → /core/plugins/system/incomplete/incomplete.php:21onAfterRoute — Method — plgSystemUnconfirmed::onAfterRoute → /core/plugins/system/unconfirmed/unconfirmed.php:21onAfterRoute — Method — plgSystemUnapproved::onAfterRoute → /core/plugins/system/unapproved/unapproved.php:21onAfterRoute — Method — plgSystemPassword::onAfterRoute → /app/plugins/system/password/password.php:21onAfterDispatch — Method — plgSystemMobile::onAfterDispatch → /core/plugins/system/mobile/mobile.php:22onAfterDispatch — Method — plgSystemLanguageFilter::onAfterDispatch → /app/plugins/system/languagefilter/languagefilter.php:554onAfterDispatch — Method — plgSystemDebug::onAfterDispatch → /core/plugins/system/debug/debug.php:60onAfterDispatch — Method — PlgSystemHighlight::onAfterDispatch → /core/plugins/system/highlight/highlight.php:25onAfterRender — Method — plgSystemSef::onAfterRender → /core/plugins/system/sef/sef.php:21
