- $_GET
-
Array(
)
Array(
)
- $_POST
-
Array(
)
Array(
)
- $_COOKIE
-
Array(
81f30cf708470b974874c8a96a6bcdb2 => 4734624439e2db94a41ef158996a7d35,
d482552ea4a74f85...
Array(
81f30cf708470b974874c8a96a6bcdb2
=>
4734624439e2db94a41ef158996a7d35
,
d482552ea4a74f85af0bb3d73890dabc
=>
5 E 45E43105E E 2444543 7406F5D 11B 37E B4A 3 05F41134B514059 4 951135F765817 3 B5C1243 B5612 F16 3 B 2 A1B D F565750 A 0 6 45C 1 655 6 157 5 D 9 356 157 A 9 D5358 F54 3 C1B 3165952 2164044 C 016 A17 25056 31A52 7 356 4 2 051 A 155 25D5B 151 252 95154 6505C D 8525954 0 A D44 B4358 6 A16164A515412 24A 256515C1A 0 5 45152 6 550 B5A 1 B5C 4 9 4 3 6 151 3 8 D 8 9 0 F5952 755 D16 94A
)
- $_SERVER
-
Array(
USER => apache,
HOME => /usr/share/httpd,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AU...
Array(
USER
=>
apache
,
HOME
=>
/usr/share/httpd
,
FCGI_ROLE
=>
RESPONDER
,
REDIRECT_HTTP_AUTHORIZATION
=>
,
REDIRECT_UNIQUE_ID
=>
ZkhIi4Jnvpv-TFn14hozyAAAAAI
,
REDIRECT_SCRIPT_URL
=>
/members/1509/contributions
,
REDIRECT_SCRIPT_URI
=>
https://ielab.info/members/1509/contributions
,
REDIRECT_HTTPS
=>
on
,
REDIRECT_STATUS
=>
200
,
HTTP_AUTHORIZATION
=>
,
UNIQUE_ID
=>
ZkhIi4Jnvpv-TFn14hozyAAAAAI
,
SCRIPT_URL
=>
/members/1509/contributions
,
SCRIPT_URI
=>
https://ielab.info/members/1509/contributions
,
HTTPS
=>
on
,
HTTP_X_FORWARDED_FOR
=>
3.144.1.156
,
HTTP_X_FORWARDED_PROTO
=>
https
,
HTTP_X_FORWARDED_PORT
=>
443
,
HTTP_HOST
=>
ielab.info
,
HTTP_X_AMZN_TRACE_ID
=>
Root=1-6648488b-78dbec634c08154e06e63c30
,
HTTP_ACCEPT
=>
*/*
,
HTTP_USER_AGENT
=>
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
,
HTTP_REFERER
=>
http://ielab.info/members/1509/contributions
,
HTTP_ACCEPT_ENCODING
=>
gzip, br, zstd, deflate
,
HTTP_COOKIE
=>
81f30cf708470b974874c8a96a6bcdb2=4734624439e2db94a41ef158996a7d35; d482552ea4a74f85af0bb3d73890dabc=+5+E+45E43105E+E+2444543+7406F5D+11B+37E+B4A+3+05F41134B514059+4+951135F765817+3+B5C1243+B5612+F16+3+B+2+A1B+D+F565750+A+0+6+45C+1+655+6+157+5+D+9+356+157+A+9+D5358+F54+3+C1B+3165952+2164044+C+016+A17+25056+31A52+7+356+4+2+051+A+155+25D5B+151+252+95154+6505C+D+8525954+0+A+D44+B4358+6+A16164A515412+24A+256515C1A+0+5+45152+6+550+B5A+1+B5C+4+9+4+3+6+151+3+8+D+8+9+0+F5952+755+D16+94A
,
PATH
=>
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
,
SERVER_SIGNATURE
=>
,
SERVER_SOFTWARE
=>
Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips mod_python/3.5.0- Python/2.7.5
,
SERVER_NAME
=>
ielab.info
,
SERVER_ADDR
=>
10.84.154.253
,
SERVER_PORT
=>
443
,
REMOTE_ADDR
=>
10.84.154.202
,
DOCUMENT_ROOT
=>
/var/www/ielab
,
REQUEST_SCHEME
=>
https
,
CONTEXT_PREFIX
=>
,
CONTEXT_DOCUMENT_ROOT
=>
/var/www/ielab
,
SERVER_ADMIN
=>
root@localhost
,
SCRIPT_FILENAME
=>
/var/www/ielab/index.php
,
REMOTE_PORT
=>
52110
,
REDIRECT_URL
=>
/members/1509/contributions
,
GATEWAY_INTERFACE
=>
CGI/1.1
,
SERVER_PROTOCOL
=>
HTTP/1.1
,
REQUEST_METHOD
=>
GET
,
QUERY_STRING
=>
,
REQUEST_URI
=>
/members/1509/contributions
,
SCRIPT_NAME
=>
/index.php
,
PHP_SELF
=>
/index.php
,
REQUEST_TIME_FLOAT
=>
1716013195.5667
,
REQUEST_TIME
=>
1716013195
)
session.client.forwarded ⇒ 3.144.1.156
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ 4734624439e2db94a41ef158996a7d35
tracker.ssid ⇒ 4734624439e2db94a41ef158996a7d35
tracker.rsid ⇒ 4734624439e2db94a41ef158996a7d35
32 MB
85 Queries Logged: 0.030587911605835 seconds
SELECT data
FROM `jos_session`
WHERE `session_id` = '4734624439e2db94a41ef158996a7d35'
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
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 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'
SELECT *
FROM `jos_users`
WHERE `jos_users`.`id` = '1509'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_resources'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_publications'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_projects'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_jobs'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_citations'
SHOW FULL COLUMNS
FROM `jos_jobs_employers`
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_members.component'
GROUP BY b.id, b.rules, b.lft
ORDER BY `b`.`lft` ASC
SELECT *
FROM `jos_assets`
WHERE `jos_assets`.`parent_id` = '0'
SELECT *
FROM `jos_assets`
WHERE `jos_assets`.`id` = '1'
SELECT e.id
FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
ON s.id=e.subscriptionid
AND s.uid=e.uid
WHERE e.uid = '0'
AND s.status=1
AND s.expires > '2024-05-18 06:19:55'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_blog'
SELECT *
FROM `jos_blog_entries`
WHERE `jos_blog_entries`.`scope` = 'member'
AND `jos_blog_entries`.`scope_id` = '1509'
AND `jos_blog_entries`.`state` IN ('1')
AND `jos_blog_entries`.`access` IN ('1','1','4')
AND (`jos_blog_entries`.`publish_up` IS NULL
OR `jos_blog_entries`.`publish_up` <= '2024-05-18 06:19:55'
)
AND (`jos_blog_entries`.`publish_down` IS NULL
OR `jos_blog_entries`.`publish_down` >= '2024-05-18 06:19:55'
)
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_collections'
SHOW FULL COLUMNS
FROM `jos_collections`
SELECT COUNT(DISTINCT b.id)
FROM jos_collections AS b
INNER JOIN `jos_collections_items` AS im
ON im.type='collection'
AND im.object_id=b.id
LEFT JOIN `jos_collections_following` AS f
ON f.following_type='collection'
AND f.following_id=b.id
WHERE b.state='1'
AND b.object_id='1509'
AND b.object_type='member'
SELECT COUNT(DISTINCT b.id)
FROM jos_collections AS b
INNER JOIN `jos_collections_items` AS im
ON im.type='collection'
AND im.object_id=b.id
LEFT JOIN `jos_collections_following` AS f
ON f.following_type='collection'
AND f.following_id=b.id
WHERE b.state='1'
AND b.access='0'
AND b.object_id='1509'
AND b.object_type='member'
SELECT *
FROM `jos_resource_types`
WHERE `jos_resource_types`.`category` = '27'
ORDER BY `type` ASC
SELECT COUNT(jos_resources.id) AS count
FROM `jos_resources`
LEFT JOIN jos_author_assoc
ON jos_author_assoc.subid = jos_resources.id
WHERE `jos_resources`.`standalone` = '1'
AND `jos_resources`.`published` IN ('1')
AND `jos_resources`.`type` = '9'
AND `jos_author_assoc`.`subtable` = 'resources'
AND `jos_author_assoc`.`authorid` = '1509'
AND `jos_author_assoc`.`role` != 'submitter'
AND `jos_resources`.`access` IN ('0','3')
SELECT COUNT(jos_resources.id) AS count
FROM `jos_resources`
LEFT JOIN jos_author_assoc
ON jos_author_assoc.subid = jos_resources.id
WHERE `jos_resources`.`standalone` = '1'
AND `jos_resources`.`published` IN ('1')
AND `jos_resources`.`type` = '3'
AND `jos_author_assoc`.`subtable` = 'resources'
AND `jos_author_assoc`.`authorid` = '1509'
AND `jos_author_assoc`.`role` != 'submitter'
AND `jos_resources`.`access` IN ('0','3')
SELECT COUNT(jos_resources.id) AS count
FROM `jos_resources`
LEFT JOIN jos_author_assoc
ON jos_author_assoc.subid = jos_resources.id
WHERE `jos_resources`.`standalone` = '1'
AND `jos_resources`.`published` IN ('1')
AND `jos_resources`.`type` = '1'
AND `jos_author_assoc`.`subtable` = 'resources'
AND `jos_author_assoc`.`authorid` = '1509'
AND `jos_author_assoc`.`role` != 'submitter'
AND `jos_resources`.`access` IN ('0','3')
SELECT COUNT(jos_resources.id) AS count
FROM `jos_resources`
LEFT JOIN jos_author_assoc
ON jos_author_assoc.subid = jos_resources.id
WHERE `jos_resources`.`standalone` = '1'
AND `jos_resources`.`published` IN ('1')
AND `jos_resources`.`type` = '31'
AND `jos_author_assoc`.`subtable` = 'resources'
AND `jos_author_assoc`.`authorid` = '1509'
AND `jos_author_assoc`.`role` != 'submitter'
AND `jos_resources`.`access` IN ('0','3')
SELECT COUNT(jos_resources.id) AS count
FROM `jos_resources`
LEFT JOIN jos_author_assoc
ON jos_author_assoc.subid = jos_resources.id
WHERE `jos_resources`.`standalone` = '1'
AND `jos_resources`.`published` IN ('1')
AND `jos_resources`.`type` = '39'
AND `jos_author_assoc`.`subtable` = 'resources'
AND `jos_author_assoc`.`authorid` = '1509'
AND `jos_author_assoc`.`role` != 'submitter'
AND `jos_resources`.`access` IN ('0','3')
SELECT COUNT(jos_resources.id) AS count
FROM `jos_resources`
LEFT JOIN jos_author_assoc
ON jos_author_assoc.subid = jos_resources.id
WHERE `jos_resources`.`standalone` = '1'
AND `jos_resources`.`published` IN ('1')
AND `jos_resources`.`type` = '7'
AND `jos_author_assoc`.`subtable` = 'resources'
AND `jos_author_assoc`.`authorid` = '1509'
AND `jos_author_assoc`.`role` != 'submitter'
AND `jos_resources`.`access` IN ('0','3')
SELECT COUNT(jos_resources.id) AS count
FROM `jos_resources`
LEFT JOIN jos_author_assoc
ON jos_author_assoc.subid = jos_resources.id
WHERE `jos_resources`.`standalone` = '1'
AND `jos_resources`.`published` IN ('1')
AND `jos_resources`.`type` = '64'
AND `jos_author_assoc`.`subtable` = 'resources'
AND `jos_author_assoc`.`authorid` = '1509'
AND `jos_author_assoc`.`role` != 'submitter'
AND `jos_resources`.`access` IN ('0','3')
SELECT COUNT(jos_resources.id) AS count
FROM `jos_resources`
LEFT JOIN jos_author_assoc
ON jos_author_assoc.subid = jos_resources.id
WHERE `jos_resources`.`standalone` = '1'
AND `jos_resources`.`published` IN ('1')
AND `jos_resources`.`type` = '2'
AND `jos_author_assoc`.`subtable` = 'resources'
AND `jos_author_assoc`.`authorid` = '1509'
AND `jos_author_assoc`.`role` != 'submitter'
AND `jos_resources`.`access` IN ('0','3')
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_wiki'
SELECT *
FROM `jos_wiki_versions`
WHERE `jos_wiki_versions`.`created_by` = '1509'
AND `jos_wiki_versions`.`approved` = '1'
GROUP BY page_id,id
SELECT COUNT(jos_wiki_pages.id) AS count
FROM `jos_wiki_pages`
WHERE `jos_wiki_pages`.`state` = '1'
AND `jos_wiki_pages`.`scope` = 'site'
AND `jos_wiki_pages`.`id` IN ('')
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_courses'
SHOW FULL COLUMNS
FROM `jos_courses`
SELECT COUNT(*)
FROM `jos_courses` AS c
JOIN `jos_courses_members` AS m
ON m.course_id=c.id
LEFT JOIN `jos_courses_offerings` AS o
ON o.id=m.offering_id
LEFT JOIN `jos_courses_offering_sections` AS s
on s.id=m.section_id
LEFT JOIN `jos_courses_roles` AS r
ON r.id=m.role_id
WHERE m.user_id=1509
AND m.student=0
AND r.alias='instructor'
AND c.state=1
SHOW FULL COLUMNS
FROM `jos_publications`
SELECT *
FROM `jos_publication_categories`
WHERE `jos_publication_categories`.`state` = '1'
ORDER BY `name` ASC
SELECT COUNT(jos_publication_versions.id) AS count
FROM `jos_publication_versions`
INNER JOIN jos_publications
ON jos_publications.id = jos_publication_versions.publication_id
LEFT JOIN jos_publication_authors
ON jos_publication_authors.publication_version_id = jos_publication_versions.id
WHERE `jos_publication_versions`.`state` IN ('1')
AND `jos_publication_authors`.`user_id` = '1509'
AND (`jos_publication_authors`.`role` IS NULL
OR `jos_publication_authors`.`role` != 'submitter'
)
AND `jos_publication_versions`.`access` IN ('0','3')
SELECT *
FROM `jos_wiki_pages`
WHERE `jos_wiki_pages`.`state` = '1'
AND `jos_wiki_pages`.`scope` = 'site'
AND `jos_wiki_pages`.`id` IN ('')
LIMIT 5
SELECT c.id, c.alias, c.title, c.blurb, m.enrolled, s.publish_up AS starts, s.publish_down AS ends, r.alias AS role, o.alias AS offering_alias, o.title AS offering_title, s.alias AS section_alias, s.title AS section_title, s.is_default
FROM `jos_courses` AS c
JOIN `jos_courses_members` AS m
ON m.course_id=c.id
LEFT JOIN `jos_courses_offerings` AS o
ON o.id=m.offering_id
LEFT JOIN `jos_courses_offering_sections` AS s
on s.id=m.section_id
LEFT JOIN `jos_courses_roles` AS r
ON r.id=m.role_id
WHERE m.user_id='1509'
AND m.student=0
AND r.alias='instructor'
AND c.state=1
SELECT jos_publication_versions.*
FROM `jos_publication_versions`
INNER JOIN jos_publications
ON jos_publications.id = jos_publication_versions.publication_id
LEFT JOIN jos_publication_authors
ON jos_publication_authors.publication_version_id = jos_publication_versions.id
WHERE `jos_publication_versions`.`state` IN ('1')
AND `jos_publication_authors`.`user_id` = '1509'
AND (`jos_publication_authors`.`role` IS NULL
OR `jos_publication_authors`.`role` != 'submitter'
)
AND `jos_publication_versions`.`access` IN ('0','3')
ORDER BY `created` DESC
LIMIT 5
SHOW FULL COLUMNS
FROM `jos_courses_offerings`
SHOW FULL COLUMNS
FROM `jos_courses_roles`
SELECT r.*, (SELECT COUNT(m.user_id)
FROM jos_courses_members AS m
WHERE m.role_id=r.id
AND m.`offering_id` IN (0,0)) AS total
FROM jos_courses_roles AS r
WHERE r.`offering_id` IN (0,0)
SELECT COUNT(*)
FROM `jos_courses` AS c
JOIN `jos_courses_members` AS m
ON m.course_id=c.id
LEFT JOIN `jos_courses_offerings` AS o
ON o.id=m.offering_id
LEFT JOIN `jos_courses_offering_sections` AS s
on s.id=m.section_id
LEFT JOIN `jos_courses_roles` AS r
ON r.id=m.role_id
WHERE c.state IN (1, 3)
AND m.user_id=1509
AND m.student=0
AND r.alias='instructor'
SELECT COUNT(*)
FROM `jos_courses` AS c
JOIN `jos_courses_members` AS m
ON m.course_id=c.id
LEFT JOIN `jos_courses_offerings` AS o
ON o.id=m.offering_id
LEFT JOIN `jos_courses_offering_sections` AS s
on s.id=m.section_id
LEFT JOIN `jos_courses_roles` AS r
ON r.id=m.role_id
WHERE c.state IN (1, 3)
AND m.user_id=1509
AND m.student=0
AND r.alias='manager'
SELECT COUNT(*)
FROM `jos_courses` AS c
JOIN `jos_courses_members` AS m
ON m.course_id=c.id
LEFT JOIN `jos_courses_offerings` AS o
ON o.id=m.offering_id
LEFT JOIN `jos_courses_offering_sections` AS s
on s.id=m.section_id
LEFT JOIN `jos_courses_roles` AS r
ON r.id=m.role_id
WHERE c.state=1
AND m.user_id=1509
AND m.student=1
AND (s.publish_down IS NULL OR s.publish_down='0000-00-00 00:00:00' OR s.publish_down < '2024-05-18 06:19:55')
AND s.state=1
AND o.state=1
SELECT *
FROM `jos_xgroups_inviteemails`
WHERE `jos_xgroups_inviteemails`.`email` = 'a.boyd2@lancaster.ac.uk'
( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
FROM `jos_xgroups` AS g, `jos_xgroups_applicants` AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=1509 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
FROM `jos_xgroups` AS g, `jos_xgroups_members` AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=1509 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
FROM `jos_xgroups` AS g, `jos_xgroups_managers` AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=1509 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
FROM `jos_xgroups` AS g, `jos_xgroups_invitees` AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=1509 )
SELECT COUNT(jos_xmessage_recipient.id) AS count
FROM `jos_xmessage_recipient`
INNER JOIN jos_xmessage
ON jos_xmessage.id = jos_xmessage_recipient.mid
LEFT JOIN jos_xmessage_seen
ON jos_xmessage_seen.mid=jos_xmessage.id
AND jos_xmessage_seen.uid=1509
WHERE `jos_xmessage_recipient`.`uid` = '1509'
AND `jos_xmessage_recipient`.`state` = '0'
SELECT COUNT(jos_xmessage.id) AS count
FROM `jos_xmessage`
INNER JOIN jos_xmessage_recipient
ON jos_xmessage.id = jos_xmessage_recipient.mid
WHERE `jos_xmessage_recipient`.`uid` = '1509'
AND `jos_xmessage_recipient`.`state` != '2'
AND jos_xmessage.id NOT IN (SELECT s.mid
FROM `jos_xmessage_seen` AS s
WHERE s.uid=1509)
SHOW TABLES
SELECT *
FROM `jos_users_points`
WHERE `jos_users_points`.`uid` = '1509'
SHOW FULL COLUMNS
FROM `jos_projects`
SELECT count(DISTINCT p.id)
FROM jos_projects AS p
LEFT JOIN jos_project_owners AS o
ON o.projectid=p.id
AND o.userid='1509'
AND o.userid != 0
AND p.state!= 2 JOIN jos_users as x
ON x.id=p.owned_by_user
LEFT JOIN jos_xgroups as g
ON g.gidNumber=p.owned_by_group
WHERE (o.userid='1509'
AND o.status!=2
AND p.state NOT IN (2, 3)
AND ((p.setup_stage >= '2')
OR (o.role = 1
AND p.owned_by_user='1509')))
AND p.provisioned = 0
SHOW FULL COLUMNS
FROM `jos_project_owners`
SELECT p.alias, p.title, o.*
FROM jos_project_owners AS o
INNER JOIN `jos_projects` AS p
ON p.id=o.projectid
WHERE o.userid=0
AND o.status=0
AND o.invited_email='a.boyd2@lancaster.ac.uk'
SELECT e.id
FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
ON s.id=e.subscriptionid
AND s.uid=e.uid
WHERE e.uid = '0'
AND s.status=1
AND s.expires > '2024-05-18 06:19:55'
SELECT e.id
FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
ON s.id=e.subscriptionid
AND s.uid=e.uid
WHERE e.uid = '0'
AND s.status=1
AND s.expires > '2024-05-18 06:19:55'
SELECT e.id
FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
ON s.id=e.subscriptionid
AND s.uid=e.uid
WHERE e.uid = '0'
AND s.status=1
AND s.expires > '2024-05-18 06:19:55'
SHOW TABLES
SELECT jos_citations.*,u.username,F.format AS template,CS.sec_cits_cnt AS sec_cnt
FROM `jos_citations`
LEFT JOIN jos_users AS u
ON jos_citations.uid = u.id
LEFT JOIN jos_citations_secondary AS CS
ON jos_citations.id = CS.cid
LEFT JOIN jos_citations_format AS F
ON jos_citations.format = F.style
WHERE `jos_citations`.`scope` = 'member'
AND `jos_citations`.`scope_id` = '1509'
AND `jos_citations`.`published` IN ('1')
SELECT COUNT(jos_activity_recipients.id) AS count
FROM `jos_activity_recipients`
WHERE `jos_activity_recipients`.`scope` = 'user'
AND `jos_activity_recipients`.`scope_id` = '1509'
AND `jos_activity_recipients`.`state` = '1'
AND `jos_activity_recipients`.`viewed` IS NULL
( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_applicants AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_members AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
FROM jos_xgroups AS g, jos_xgroups_managers AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_invitees AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=0 )
( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_applicants AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=1509 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_members AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=1509 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
FROM jos_xgroups AS g, jos_xgroups_managers AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=1509 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_invitees AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=1509 )
SELECT *
FROM `jos_xprofiles`
WHERE uidNumber = '1509';
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_users'
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-05-18 06:19:55'
)
AND (`m`.`publish_down` IS NULL
OR `m`.`publish_down` >= '2024-05-18 06:19:55'
)
AND `m`.`access` IN ('1','1','4')
AND `m`.`client_id` = '0'
AND (`mm`.`menuid` = '83'
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_support'
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_newsletter'
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_answers'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_kb'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_media'
UPDATE `jos_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:172;s:19:\"session.timer.start\";i:1716013079;s:18:\"session.timer.last\";i:1716013194;s:17:\"session.timer.now\";i:1716013195;s:24:\"session.client.forwarded\";s:11:\"3.144.1.156\";s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":2:{s:9:\"Resources\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":2:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Author\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}s:4:\"Blog\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:5:\"Entry\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:10:\"publish_up\";s:8:\"orderdir\";s:4:\"desc\";}}}}s:5:\"Entry\";O:8:\"stdClass\":2:{s:5:\"start\";d:0;s:5:\"
limit\";i:20;}}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:\"4734624439e2db94a41ef158996a7d35\";s:12:\"tracker.ssid\";s:32:\"4734624439e2db94a41ef158996a7d35\";s:12:\"tracker.rsid\";s:32:\"4734624439e2db94a41ef158996a7d35\";}',`time` = '1716013195',`ip` = '10.84.154.202'
WHERE `session_id` = '4734624439e2db94a41ef158996a7d35'
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
onAfterInitialise — Method — plgSystemReferrerpolicy::onAfterInitialise → /core/plugins/system/referrerpolicy/referrerpolicy.php:21
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
onMembersAreas — Method — plgMembersDashboard::onMembersAreas → /core/plugins/members/dashboard/dashboard.php:62
onMembersAreas — Method — plgMembersProfile::onMembersAreas → /core/plugins/members/profile/profile.php:30
onMembersAreas — Method — plgMembersAccount::onMembersAreas → /core/plugins/members/account/account.php:34
onMembersAreas — Method — plgMembersBlog::onMembersAreas → /core/plugins/members/blog/blog.php:30
onMembersAreas — Method — plgMembersCollections::onMembersAreas → /core/plugins/members/collections/collections.php:30
onMembersAreas — Method — plgMembersContributions::onMembersAreas → /core/plugins/members/contributions/contributions.php:30
onMembersAreas — Method — plgMembersCourses::onMembersAreas → /core/plugins/members/courses/courses.php:30
onMembersAreas — Method — plgMembersGroups::onMembersAreas → /core/plugins/members/groups/groups.php:30
onMembersAreas — Method — plgMembersImpact::onMembersAreas → /core/plugins/members/impact/impact.php:80
onMembersAreas — Method — plgMembersMessages::onMembersAreas → /core/plugins/members/messages/messages.php:30
onMembersAreas — Method — plgMembersPoints::onMembersAreas → /core/plugins/members/points/points.php:30
onMembersAreas — Method — plgMembersProjects::onMembersAreas → /core/plugins/members/projects/projects.php:46
onMembersAreas — Method — plgMembersResume::onMembersAreas → /core/plugins/members/resume/resume.php:60
onMembersAreas — Method — plgMembersUsage::onMembersAreas → /core/plugins/members/usage/usage.php:30
onMembersAreas — Method — plgMembersCitations::onMembersAreas → /core/plugins/members/citations/citations.php:47
onMembersAreas — Method — plgMembersActivity::onMembersAreas → /core/plugins/members/activity/activity.php:30
onMembersContributionsAreas — Method — plgMembersResources::onMembersContributionsAreas → /core/plugins/members/resources/resources.php:63
onMembersContributionsAreas — Method — plgMembersWiki::onMembersContributionsAreas → /core/plugins/members/wiki/wiki.php:28
onMembersContributionsAreas — Method — plgMembersCourses::onMembersContributionsAreas → /core/plugins/members/courses/courses.php:354
onMembersContributionsAreas — Method — plgMembersImpact::onMembersContributionsAreas → /core/plugins/members/impact/impact.php:196
onMembersContributionsAreas — Method — plgMembersPublications::onMembersContributionsAreas → /core/plugins/members/publications/publications.php:65
onMembersContributions — Method — plgMembersResources::onMembersContributions → /core/plugins/members/resources/resources.php:117
onMembersContributions — Method — plgMembersWiki::onMembersContributions → /core/plugins/members/wiki/wiki.php:65
onMembersContributions — Method — plgMembersCourses::onMembersContributions → /core/plugins/members/courses/courses.php:392
onMembersContributions — Method — plgMembersImpact::onMembersContributions → /core/plugins/members/impact/impact.php:241
onMembersContributions — Method — plgMembersPublications::onMembersContributions → /core/plugins/members/publications/publications.php:102
onMembers — Method — plgMembersDashboard::onMembers → /core/plugins/members/dashboard/dashboard.php:88
onMembers — Method — plgMembersProfile::onMembers → /core/plugins/members/profile/profile.php:50
onMembers — Method — plgMembersAccount::onMembers → /core/plugins/members/account/account.php:60
onMembers — Method — plgMembersBlog::onMembers → /core/plugins/members/blog/blog.php:50
onMembers — Method — plgMembersCollections::onMembers → /core/plugins/members/collections/collections.php:50
onMembers — Method — plgMembersContributions::onMembers → /core/plugins/members/contributions/contributions.php:50
onMembers — Method — plgMembersCourses::onMembers → /core/plugins/members/courses/courses.php:53
onMembers — Method — plgMembersGroups::onMembers → /core/plugins/members/groups/groups.php:56
onMembers — Method — plgMembersImpact::onMembers → /core/plugins/members/impact/impact.php:113
onMembers — Method — plgMembersMessages::onMembers → /core/plugins/members/messages/messages.php:56
onMembers — Method — plgMembersPoints::onMembers → /core/plugins/members/points/points.php:56
onMembers — Method — plgMembersProjects::onMembers → /core/plugins/members/projects/projects.php:71
onMembers — Method — plgMembersResume::onMembers → /core/plugins/members/resume/resume.php:160
onMembers — Method — plgMembersUsage::onMembers → /core/plugins/members/usage/usage.php:50
onMembers — Method — plgMembersCitations::onMembers → /core/plugins/members/citations/citations.php:67
onMembers — Method — plgMembersActivity::onMembers → /core/plugins/members/activity/activity.php:54
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