- $_GET
-
Array(
)
Array(
)
- $_POST
-
Array(
)
Array(
)
- $_COOKIE
-
Array(
)
Array(
)
- $_SERVER
-
Array(
TEMP => /var/www/tmp,
TMPDIR => /var/www/tmp,
TMP => /var/www/tmp,
PATH => /usr/lo...
Array(
TEMP
=>
/var/www/tmp
,
TMPDIR
=>
/var/www/tmp
,
TMP
=>
/var/www/tmp
,
PATH
=>
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
,
USER
=>
apache
,
HOME
=>
/var/www
,
FCGI_ROLE
=>
RESPONDER
,
REDIRECT_HTTP_AUTHORIZATION
=>
,
REDIRECT_UNIQUE_ID
=>
Z0uhuEQ8-uY4FdjAmzG6XQAAAE8
,
REDIRECT_SCRIPT_URL
=>
/courses/hui/offerings
,
REDIRECT_SCRIPT_URI
=>
https://shunko.aws.hubzero.org/courses/hui/offerings
,
REDIRECT_HTTPS
=>
on
,
REDIRECT_SSL_TLS_SNI
=>
shunko.aws.hubzero.org
,
REDIRECT_STATUS
=>
200
,
HTTP_AUTHORIZATION
=>
,
UNIQUE_ID
=>
Z0uhuEQ8-uY4FdjAmzG6XQAAAE8
,
SCRIPT_URL
=>
/courses/hui/offerings
,
SCRIPT_URI
=>
https://shunko.aws.hubzero.org/courses/hui/offerings
,
HTTPS
=>
on
,
SSL_TLS_SNI
=>
shunko.aws.hubzero.org
,
HTTP_ACCEPT
=>
*/*
,
HTTP_USER_AGENT
=>
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
,
HTTP_ACCEPT_ENCODING
=>
gzip, br, zstd, deflate
,
HTTP_HOST
=>
shunko.aws.hubzero.org
,
SERVER_SIGNATURE
=>
,
SERVER_SOFTWARE
=>
Apache
,
SERVER_NAME
=>
shunko.aws.hubzero.org
,
SERVER_ADDR
=>
10.68.128.8
,
SERVER_PORT
=>
443
,
REMOTE_ADDR
=>
3.17.181.122
,
DOCUMENT_ROOT
=>
/var/www/shunko
,
REQUEST_SCHEME
=>
https
,
CONTEXT_PREFIX
=>
,
CONTEXT_DOCUMENT_ROOT
=>
/var/www/shunko
,
SERVER_ADMIN
=>
root@localhost
,
SCRIPT_FILENAME
=>
/var/www/shunko/index.php
,
REMOTE_PORT
=>
32630
,
REDIRECT_URL
=>
/courses/hui/offerings
,
GATEWAY_INTERFACE
=>
CGI/1.1
,
SERVER_PROTOCOL
=>
HTTP/1.1
,
REQUEST_METHOD
=>
GET
,
QUERY_STRING
=>
,
REQUEST_URI
=>
/courses/hui/offerings
,
SCRIPT_NAME
=>
/index.php
,
PHP_SELF
=>
/index.php
,
REQUEST_TIME_FLOAT
=>
1733009848.9401
,
REQUEST_TIME
=>
1733009848
)
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ ad7e67c446bb584339494b73f9cb3433
tracker.ssid ⇒ ad7e67c446bb584339494b73f9cb3433
tracker.rsid ⇒ ad7e67c446bb584339494b73f9cb3433
8 MB
49 Queries Logged: 0.031020641326904 seconds
SELECT data
FROM `jos_session`
WHERE `session_id` = 'a867991f6738df4dedfac6786373d1dd'
DELETE
FROM `jos_session`
WHERE `session_id` = 'a867991f6738df4dedfac6786373d1dd'
SELECT data
FROM `jos_session`
WHERE `session_id` = 'ad7e67c446bb584339494b73f9cb3433'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT session_id
FROM `jos_session`
WHERE `session_id` = 'ad7e67c446bb584339494b73f9cb3433'
LIMIT 1
INSERT INTO `jos_session`
(`session_id`,`client_id`,`time`,`ip`)
VALUES ('ad7e67c446bb584339494b73f9cb3433','0','1733009848','3.17.181.122')
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` >= '0'
AND `access` IN ('1','1','4')
ORDER BY `ordering` ASC
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` > '0'
AND `m`.`client_id` = '0'
ORDER BY `m`.`lft` ASC
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_courses'
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` = '0'
AND `jos_extensions`.`enabled` = '1'
AND `jos_extensions`.`type` = 'template'
AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
ORDER BY `home` DESC
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_tags'
SHOW FULL COLUMNS
FROM `jos_courses`
SELECT *
FROM `jos_courses`
WHERE `alias` = 'hui'
SELECT *
FROM `jos_courses`
WHERE `id` = '2'
SHOW FULL COLUMNS
FROM `jos_courses_offerings`
SELECT a.rules
FROM `jos_assets` AS `a`
WHERE `a`.`id` = '1'
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM `jos_assets` AS `a`
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE `a`.`name` = 'com_courses'
GROUP BY b.id, b.rules, b.lft
ORDER BY `b`.`lft` ASC
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_forum'
SELECT *
FROM `jos_item_comments`
WHERE `jos_item_comments`.`item_id` = '2'
AND `jos_item_comments`.`item_type` = 'courses'
AND `jos_item_comments`.`parent` = '0'
AND `jos_item_comments`.`state` = ('1')
SELECT ci.*, c.alias AS course_alias
FROM jos_courses_offerings AS ci
INNER JOIN jos_courses AS c
ON c.id=ci.course_id
WHERE c.id='2'
AND ci.state='1'
ORDER BY publish_up ASC
SHOW FULL COLUMNS
FROM `jos_courses_offering_sections`
SELECT *
FROM `jos_courses_offering_sections`
WHERE `is_default` = '1'
AND `offering_id` = '4'
SELECT os.*
FROM jos_courses_offering_sections AS os
INNER JOIN jos_courses_offerings AS o
ON o.id=os.offering_id
WHERE os.offering_id='4'
AND (os.publish_up IS NULL OR os.publish_up = '0000-00-00 00:00:00' OR os.publish_up <= '2024-11-30 23:37:29')
AND (os.publish_down IS NULL OR os.publish_down = '0000-00-00 00:00:00' OR os.publish_down >= '2024-11-30 23:37:29')
ORDER BY os.title ASC
SHOW FULL COLUMNS
FROM `jos_courses_members`
SELECT *
FROM jos_courses_members
WHERE `user_id`='0'
AND `section_id`='5'
LIMIT 1
SHOW FULL COLUMNS
FROM `jos_courses_pages`
SELECT r.*
FROM jos_courses_pages AS r
WHERE r.`course_id`='2'
AND r.`offering_id` IN (0)
AND r.`active`='1'
ORDER BY ordering ASC
SELECT ci.*, c.alias AS course_alias
FROM jos_courses_offerings AS ci
INNER JOIN jos_courses AS c
ON c.id=ci.course_id
WHERE c.id='2'
AND (ci.publish_up IS NULL OR ci.publish_up = '0000-00-00 00:00:00' OR ci.publish_up <= '2024-11-30 23:37:29')
AND (ci.publish_down IS NULL OR ci.publish_down = '0000-00-00 00:00:00' OR ci.publish_down >= '2024-11-30 23:37:29')
AND ci.state='1'
ORDER BY publish_up DESC
SELECT *
FROM jos_courses_members
WHERE `student`='0'
AND `user_id`='0'
AND `course_id`='2'
AND `offering_id` IN (0,0)
AND `section_id` IN (0,0)
ORDER BY student ASC, section_id ASC, offering_id ASC
LIMIT 1
SHOW FULL COLUMNS
FROM `jos_courses_roles`
SELECT jos_tags_object.label,jos_tags.*
FROM `jos_tags`
INNER JOIN jos_tags_object
ON jos_tags_object.tagid = jos_tags.id
WHERE `jos_tags_object`.`tbl` = 'courses'
AND `jos_tags_object`.`objectid` = '2'
AND `jos_tags`.`admin` NOT IN ('1')
GROUP BY jos_tags_object.label,jos_tags.id
SELECT *
FROM `jos_xgroups`
WHERE gidNumber = '1000';
(select uidNumber, 'invitees' AS role
from jos_xgroups_invitees
where gidNumber='1000')
UNION
(select uidNumber, 'applicants' AS role
from jos_xgroups_applicants
where gidNumber='1000')
UNION
(select uidNumber, 'members' AS role
from jos_xgroups_members
where gidNumber='1000')
UNION
(select uidNumber, 'managers' AS role
from jos_xgroups_managers
where gidNumber='1000')
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_groups'
SELECT COUNT(*)
FROM jos_courses_members AS m
JOIN jos_users AS u
ON u.id=m.user_id
LEFT JOIN jos_courses_roles AS r
ON r.id=m.role_id
WHERE m.`course_id`='2'
AND m.`student`='1'
SHOW FULL COLUMNS
FROM `jos_courses_certificates`
SELECT *
FROM `jos_courses_certificates`
WHERE `course_id` = '2'
SELECT os.*
FROM jos_courses_offering_sections AS os
INNER JOIN jos_courses_offerings AS o
ON o.id=os.offering_id
WHERE os.offering_id='4'
AND os.state='1'
AND os.is_default='0'
AND os.enrollment IN (0,1)
AND (os.publish_up IS NULL OR os.publish_up = '0000-00-00 00:00:00' OR os.publish_up <= '2024-11-30 23:37:29')
AND (os.publish_down IS NULL OR os.publish_down = '0000-00-00 00:00:00' OR os.publish_down >= '2024-11-30 23:37:29')
AND (os.start_date IS NULL OR os.start_date = '0000-00-00 00:00:00' OR os.start_date <= '2024-11-30 23:37:29')
AND (os.end_date IS NULL OR os.end_date = '0000-00-00 00:00:00' OR os.end_date >= '2024-11-30 23:37:29')
ORDER BY os.title ASC
SELECT m.*, u.name, u.email, u.username, r.alias AS role_alias, r.title AS role_title, r.permissions AS role_permissions
FROM jos_courses_members AS m
JOIN jos_users AS u
ON u.id=m.user_id
LEFT JOIN jos_courses_roles AS r
ON r.id=m.role_id
WHERE m.`course_id`='2'
AND m.`offering_id`='0'
AND m.`section_id`='0'
AND r.`alias`='instructor'
AND m.`student`='0'
SELECT m.*, u.name, u.email, u.username, r.alias AS role_alias, r.title AS role_title, r.permissions AS role_permissions
FROM jos_courses_members AS m
JOIN jos_users AS u
ON u.id=m.user_id
LEFT JOIN jos_courses_roles AS r
ON r.id=m.role_id
WHERE m.`course_id`='2'
AND m.`offering_id`='0'
AND m.`section_id`='0'
AND r.`alias`='instructor'
AND m.`student`='0'
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` <= '2024-11-30 23:37:29'
)
AND (`m`.`publish_down` IS NULL
OR `m`.`publish_down` >= '2024-11-30 23:37:29'
)
AND `m`.`access` IN ('1','1','4')
AND `m`.`client_id` = '0'
AND (`mm`.`menuid` = '143'
OR `mm`.`menuid` <= '0'
)
ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
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_search'
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'
UPDATE `jos_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1733009848;s:18:\"session.timer.last\";i:1733009848;s:17:\"session.timer.now\";i:1733009848;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\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"ad7e67c446bb584339494b73f9cb3433\";s:12:\"tracker.ssid\";s:32:\"ad7e67c446bb584339494b73f9cb3433\";s:12:\"tracker.rsid\";s:32:\"ad7e67c446bb584339494b73f9cb3433\";}',`time` = '1733009849',`ip` = '3.17.181.122'
WHERE `session_id` = 'ad7e67c446bb584339494b73f9cb3433'
onAfterInitialise — Method — plgSystemP3p::onAfterInitialise → /core/plugins/system/p3p/p3p.php:21
onAfterInitialise — Method — plgSystemRemember::onAfterInitialise → /core/plugins/system/remember/remember.php:20
onAfterInitialise — Method — plgSystemHubzero::onAfterInitialise → /core/plugins/system/hubzero/hubzero.php:21
onAfterInitialise — Method — plgSystemXFeed::onAfterInitialise → /core/plugins/system/xfeed/xfeed.php:21
onAfterInitialise — Method — plgSystemSupergroup::onAfterInitialise → /core/plugins/system/supergroup/supergroup.php:113
onAfterRoute — Method — plgSystemJquery::onAfterRoute → /core/plugins/system/jquery/jquery.php:21
onAfterRoute — Method — plgSystemSpamjail::onAfterRoute → /core/plugins/system/spamjail/spamjail.php:21
onAfterRoute — Method — plgSystemIncomplete::onAfterRoute → /core/plugins/system/incomplete/incomplete.php:21
onAfterRoute — Method — plgSystemUnconfirmed::onAfterRoute → /core/plugins/system/unconfirmed/unconfirmed.php:21
onAfterRoute — Method — plgSystemUnapproved::onAfterRoute → /core/plugins/system/unapproved/unapproved.php:21
onAfterRoute — Method — plgSystemPassword::onAfterRoute → /core/plugins/system/password/password.php:21
onCourseView — Method — plgCoursesOverview::onCourseView → /core/plugins/courses/overview/overview.php:30
onCourseView — Method — plgCoursesReviews::onCourseView → /core/plugins/courses/reviews/reviews.php:32
onCourseView — Method — plgCoursesOfferings::onCourseView → /core/plugins/courses/offerings/offerings.php:30
onCourseViewAfter — Method — plgCoursesRelated::onCourseViewAfter → /core/plugins/courses/related/related.php:29
onAfterDispatch — Method — plgSystemMobile::onAfterDispatch → /core/plugins/system/mobile/mobile.php:22
onAfterDispatch — Method — plgSystemDebug::onAfterDispatch → /core/plugins/system/debug/debug.php:60
onAfterDispatch — Method — PlgSystemHighlight::onAfterDispatch → /core/plugins/system/highlight/highlight.php:25
onAfterRender — Method — plgSystemSef::onAfterRender → /core/plugins/system/sef/sef.php:21