Support

Support Options

Report a problem

About you
This is a randomly generated image of letters and numbers. Letters not clear? Click to renew CAPTCHA.
About the problem

Murilo Pagotto

Usage

Usage is calculated on the last day of every month. For more information on usage data, visit the Usage Overview page.

Table 1: Overview
Item Value
Contributions: 0
Rank by Contributions: -
First Contribution:
Last Contribution:
Citations on Contributions: -
Table 2: Simulation Tool Usage
# Tool Name Users served in last 12 months Simulation Runs in last 12 months Total users served Total Simulation Runs Citations Published On
No data found.
Table 3: "and more" Usage
# Resource Title Users served in last 12 months Total users served Citations Published On
No data found.

* Total only includes versions of the tools this author contributed to.

Debug Console

Close13 MBRequestSessionTimelineDatabase90Events56
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( REDIRECT_SCRIPT_URL => /members/1030/usage, REDIRECT_SCRIPT_URI => https://ielab.info/... Array(
REDIRECT_SCRIPT_URL => /members/1030/usage,
REDIRECT_SCRIPT_URI => https://ielab.info/members/1030/usage,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => ielab.info,
REDIRECT_STATUS => 200,
SCRIPT_URL => /members/1030/usage,
SCRIPT_URI => https://ielab.info/members/1030/usage,
HTTPS => on,
SSL_TLS_SNI => ielab.info,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_ACCEPT_ENCODING => br,gzip,
HTTP_HOST => ielab.info,
HTTP_CONNECTION => Keep-Alive,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.4.10 (Debian),
SERVER_NAME => ielab.info,
SERVER_ADDR => 149.171.189.2,
SERVER_PORT => 443,
REMOTE_ADDR => 44.200.112.172,
DOCUMENT_ROOT => /var/www/example,
REQUEST_SCHEME => https,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/example,
SERVER_ADMIN => [no address given],
SCRIPT_FILENAME => /var/www/example/index.php,
REMOTE_PORT => 33316,
REDIRECT_URL => /members/1030/usage,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /members/1030/usage,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1686272711.718,
REQUEST_TIME => 1686272711
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 16a349ae364ef83808a2ec4290df529d
tracker.ssid 16a349ae364ef83808a2ec4290df529d
tracker.rsid 16a349ae364ef83808a2ec4290df529d
session.token 1578f077d094946a7b4c51996f9541de
  • site 0.016 seconds (+0.016); 3.50 MB (+3.500) - afterInitialise
  • site 0.028 seconds (+0.011); 4.25 MB (+0.750) - afterRoute
  • site 0.123 seconds (+0.095); 12.00 MB (+7.750) - afterDispatch
  • site 0.130 seconds (+0.007); 12.25 MB (+0.250) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.131 seconds (+0.001); 12.50 MB (+0.250) - afterRenderModule mod_custom (Hub Footer)
  • site 0.131 seconds (+0.000); 12.50 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.132 seconds (+0.001); 12.50 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.132 seconds (+0.000); 12.50 MB (0.000) - beforeRenderModule mod_menu (Community)
  • site 0.133 seconds (+0.001); 12.50 MB (0.000) - afterRenderModule mod_menu (Community)
  • site 0.134 seconds (+0.000); 12.50 MB (0.000) - beforeRenderModule mod_menu (Support)
  • site 0.134 seconds (+0.000); 12.50 MB (0.000) - afterRenderModule mod_menu (Support)
  • site 0.134 seconds (+0.000); 12.50 MB (0.000) - beforeRenderModule mod_menu (Analyse)
  • site 0.134 seconds (+0.000); 12.50 MB (0.000) - afterRenderModule mod_menu (Analyse)
  • site 0.134 seconds (+0.000); 12.50 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.137 seconds (+0.002); 12.50 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.137 seconds (+0.000); 12.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.148 seconds (+0.011); 12.50 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.148 seconds (+0.000); 12.50 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.149 seconds (+0.001); 12.75 MB (+0.250) - afterRenderModule mod_search (Search)
  • site 0.149 seconds (+0.000); 12.75 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.154 seconds (+0.005); 12.75 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.156 seconds (+0.003); 12.75 MB (0.000) - onAfterRender
  • site 0.158 seconds (+0.002); 12.75 MB (0.000) - sessionStore
13 MB

90 Queries Logged: 0.021673440933228 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '1c025f651a986cd11c74f647e96ff61b'
  2. DELETE
      FROM`jos_session`
      WHERE `session_id` = '1c025f651a986cd11c74f647e96ff61b'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '16a349ae364ef83808a2ec4290df529d'
  4. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = '16a349ae364ef83808a2ec4290df529d'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('16a349ae364ef83808a2ec4290df529d','0','1686272711','44.200.112.172')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. 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'
  9. SELECT *
      FROM `jos_viewlevels`
  10. 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
  11. 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
  12. 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
  13. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  14. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1030'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  16. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  17. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  18. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_jobs'
  19. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  20. SHOW FULL COLUMNS
      FROM `jos_jobs_employers`
  21. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  22. 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
  23. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`parent_id` = '0'
  24. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`id` = '1'
  25. 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 > '2023-06-09 01:05:11'
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  27. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '1030'
      AND `jos_blog_entries`.`state` = '1'
      AND `jos_blog_entries`.`access` IN ('1','1','4')
      AND (`jos_blog_entries`.`publish_up` = '0000-00-00 00:00:00' OR `jos_blog_entries`.`publish_up` <= '2023-06-09 01:05:11' )
      AND (`jos_blog_entries`.`publish_down` = '0000-00-00 00:00:00' OR `jos_blog_entries`.`publish_down` >= '2023-06-09 01:05:11' )
  28. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  29. SHOW FULL COLUMNS
      FROM `jos_collections`
  30. 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='1030'
      AND b.object_type='member'
  31. 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='1030'
      AND b.object_type='member'
  32. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  33. 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_author_assoc`.`subtable` = 'resources'
      AND `jos_author_assoc`.`authorid` = '1030'
      AND `jos_author_assoc`.`role` != 'submitter'
      AND `jos_resources`.`access` IN ('0','3')
  34. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  35. SELECT *
      FROM `jos_wiki_versions`
      WHERE `jos_wiki_versions`.`created_by` = '1030'
      AND `jos_wiki_versions`.`approved` = '1'
      GROUP BY page_id
  36. 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 ('')
  37. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  38. SHOW FULL COLUMNS
      FROM `jos_courses`
  39. 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=1030
      AND m.student=0
      AND r.alias='instructor'
      AND c.state=1
  40. SHOW FULL COLUMNS
      FROM `jos_publications`
  41. SHOW FULL COLUMNS
      FROM `jos_courses_offerings`
  42. SHOW FULL COLUMNS
      FROM `jos_courses_roles`
  43. 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)
  44. 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=1030
      AND m.student=0
      AND r.alias='instructor'
  45. 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=1030
      AND m.student=0
      AND r.alias='manager'
  46. 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=1030
      AND m.student=1
      AND (s.publish_down='0000-00-00 00:00:00' OR s.publish_down < '2023-06-09 01:05:11')
      AND s.state=1
      AND o.state=1
  47. SELECT *
      FROM `jos_xgroups_inviteemails`
      WHERE `jos_xgroups_inviteemails`.`email` = 'm.pagotto@uq.edu.au'
  48. ( 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=1030 ) 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=1030 ) 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=1030 ) 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=1030 )
  49. 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=1030
      WHERE `jos_xmessage_recipient`.`uid` = '1030'
      AND `jos_xmessage_recipient`.`state` = '0'
  50. 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` = '1030'
      AND `jos_xmessage_recipient`.`state` != '2'
      AND jos_xmessage.id NOT IN (SELECT s.mid
      FROM `jos_xmessage_seen` AS s
      WHERE s.uid=1030)
  51. SHOW TABLES
  52. SELECT *
      FROM `jos_users_points`
      WHERE `jos_users_points`.`uid` = '1030'
  53. SHOW FULL COLUMNS
      FROM `jos_projects`
  54. 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='1030'
      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='1030'
      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='1030')))
      AND p.provisioned = 0
  55. SHOW FULL COLUMNS
      FROM `jos_project_owners`
  56. 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='m.pagotto@uq.edu.au'
  57. 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 > '2023-06-09 01:05:11'
  58. 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 > '2023-06-09 01:05:11'
  59. 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 > '2023-06-09 01:05:11'
  60. SHOW TABLES
  61. SELECT COUNT(DISTINCT aa.subid) as contribs, DATE_FORMAT(MIN(res.publish_up), '%d %b %Y') AS first_contrib, DATE_FORMAT(MAX(res.publish_up), '%d %b %Y') AS last_contrib
      FROM `jos_resources` AS res, `jos_author_assoc` AS aa, `jos_resource_types` AS restypes
      WHERE res.id = aa.subid
      AND res.type = restypes.id
      AND aa.authorid = '1030'
      AND aa.role!='submitter'
      AND res.standalone = 1
      AND res.published = 1
      AND (res.access=0 OR res.access=3)
      AND aa.subtable = 'resources'
  62. SELECT a.id AS aid, COUNT(DISTINCT aa.subid) AS contribs
      FROM `jos_users` a, `jos_resources` res, `jos_author_assoc` aa
      WHERE a.id = aa.authorid
      AND res.id = aa.subid
      AND res.published=1
      AND (res.access=0 OR res.access=3)
      AND aa.subtable = "resources"
      AND res.standalone=1
      GROUP BY aid
      ORDER BY contribs DESC
  63. SELECT tool_users
      FROM `jos_author_stats`
      WHERE authorid = '1030'
      AND period = '14'
      ORDER BY datetime DESC
      LIMIT 1
  64. SELECT andmore_users
      FROM `jos_author_stats`
      WHERE authorid = '1030'
      AND period = '14'
      ORDER BY datetime DESC
      LIMIT 1
  65. SELECT COUNT(DISTINCT (c.id))
      FROM `jos_citations` c, `jos_citations_assoc` ca, `jos_author_assoc` aa, `jos_resources` r
      WHERE c.id = ca.cid
      AND r.id = ca.oid
      AND r.id = aa.subid
      AND aa.subtable = 'resources'
      AND ca.tbl = 'resource'
      AND r.published=1
      AND r.standalone=1
      AND aa.authorid = '1030'
  66. SELECT classes
      FROM `jos_metrics_author_cluster`
      WHERE authorid = '1030'
  67. SELECT users
      FROM `jos_metrics_author_cluster`
      WHERE authorid = '1030'
  68. SELECT schools
      FROM `jos_metrics_author_cluster`
      WHERE authorid = '1030'
  69. SELECT DISTINCT r.id, r.type AS type_id, r.title, DATE_FORMAT(r.publish_up, "%d %b %Y") AS publish_up, rt.type
      FROM `jos_resources` AS r
      LEFT JOIN `jos_resource_types` AS rt
      ON r.TYPE=rt.id
      LEFT JOIN `jos_author_assoc` AS aa
      ON aa.subid=r.id
      AND aa.subtable="resources"
      WHERE r.standalone=1
      AND r.published=1
      AND r.type=7
      AND (aa.authorid="1030")
      AND (r.access=0 OR r.access=3)
      ORDER BY r.publish_up DESC
  70. SELECT tool_users
      FROM `jos_author_stats`
      WHERE authorid = '1030'
      AND period = '12'
      ORDER BY datetime DESC
      LIMIT 1
  71. SELECT tool_users
      FROM `jos_author_stats`
      WHERE authorid = '1030'
      AND period = '14'
      ORDER BY datetime DESC
      LIMIT 1
  72. SELECT DISTINCT r.id, r.type AS type_id, r.title, DATE_FORMAT(r.publish_up, '%d %b %Y') AS publish_up, rt.type
      FROM `jos_resources` AS r
      LEFT JOIN `jos_resource_types` AS rt
      ON r.TYPE=rt.id
      LEFT JOIN `jos_author_assoc` AS aa
      ON aa.subid=r.id
      AND aa.subtable='resources'
      WHERE r.standalone=1
      AND r.published=1
      AND r.type<>7
      AND aa.authorid='1030'
      AND aa.role!='submitter'
      AND (r.access=0 OR r.access=3)
      ORDER BY r.publish_up DESC
  73. SELECT andmore_users
      FROM `jos_author_stats`
      WHERE authorid = '1030'
      AND period = '12'
      ORDER BY datetime DESC
      LIMIT 1
  74. SELECT andmore_users
      FROM `jos_author_stats`
      WHERE authorid = '1030'
      AND period = '14'
      ORDER BY datetime DESC
      LIMIT 1
  75. 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` = '1030'
      AND `jos_citations`.`published` IN ('1')
  76. SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
      WHERE `jos_activity_recipients`.`scope` = 'user'
      AND `jos_activity_recipients`.`scope_id` = '1030'
      AND `jos_activity_recipients`.`state` = '1'
      AND `jos_activity_recipients`.`viewed` = '0000-00-00 00:00:00'
  77. ( 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 )
  78. ( 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=1030 ) 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=1030 ) 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=1030 ) 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=1030 )
  79. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1030';
  80. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  81. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  82. 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` = '0000-00-00 00:00:00' OR `m`.`publish_up` <= '2023-06-09 01:05:11' )
      AND (`m`.`publish_down` = '0000-00-00 00:00:00' OR `m`.`publish_down` >= '2023-06-09 01:05:11' )
      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
  83. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  84. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  85. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_newsletter'
  86. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  87. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  88. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  89. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  90. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1686272711;s:18:\"session.timer.last\";i:1686272711;s:17:\"session.timer.now\";i:1686272711;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{s:9:\"Resources\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}}}}}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:\"16a349ae364ef83808a2ec4290df529d\";s:12:\"tracker.ssid\";s:32:\"16a349ae364ef83808a2ec4290df529d\";s:12:\"tracker.rsid\";s:32:\"16a349ae364ef83808a2ec4290df529d\";s:13:\"session.token\";s:32:\"1578f077d094946a7b4c51996f9541de\";}',`time` = '1686272711',`ip` = '44.200.112.172'
      WHERE `session_id` = '16a349ae364ef83808a2ec4290df529d'
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:45
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:44
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:46
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:46
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:138
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:46
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:46
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:46
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:46
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:46
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:46
  • onMembersAreas Method plgMembersDashboard::onMembersAreas /core/plugins/members/dashboard/dashboard.php:87
  • onMembersAreas Method plgMembersProfile::onMembersAreas /core/plugins/members/profile/profile.php:55
  • onMembersAreas Method plgMembersAccount::onMembersAreas /core/plugins/members/account/account.php:59
  • onMembersAreas Method plgMembersBlog::onMembersAreas /core/plugins/members/blog/blog.php:55
  • onMembersAreas Method plgMembersCollections::onMembersAreas /core/plugins/members/collections/collections.php:55
  • onMembersAreas Method plgMembersContributions::onMembersAreas /core/plugins/members/contributions/contributions.php:55
  • onMembersAreas Method plgMembersCourses::onMembersAreas /core/plugins/members/courses/courses.php:55
  • onMembersAreas Method plgMembersGroups::onMembersAreas /core/plugins/members/groups/groups.php:55
  • onMembersAreas Method plgMembersImpact::onMembersAreas /core/plugins/members/impact/impact.php:105
  • onMembersAreas Method plgMembersMessages::onMembersAreas /core/plugins/members/messages/messages.php:55
  • onMembersAreas Method plgMembersPoints::onMembersAreas /core/plugins/members/points/points.php:55
  • onMembersAreas Method plgMembersProjects::onMembersAreas /core/plugins/members/projects/projects.php:71
  • onMembersAreas Method plgMembersResume::onMembersAreas /core/plugins/members/resume/resume.php:85
  • onMembersAreas Method plgMembersUsage::onMembersAreas /core/plugins/members/usage/usage.php:55
  • onMembersAreas Method plgMembersCitations::onMembersAreas /core/plugins/members/citations/citations.php:72
  • onMembersAreas Method plgMembersActivity::onMembersAreas /core/plugins/members/activity/activity.php:54
  • onMembersContributionsAreas Method plgMembersResources::onMembersContributionsAreas /core/plugins/members/resources/resources.php:88
  • onMembersContributionsAreas Method plgMembersWiki::onMembersContributionsAreas /core/plugins/members/wiki/wiki.php:53
  • onMembersContributionsAreas Method plgMembersCourses::onMembersContributionsAreas /core/plugins/members/courses/courses.php:379
  • onMembersContributionsAreas Method plgMembersImpact::onMembersContributionsAreas /core/plugins/members/impact/impact.php:221
  • onMembersContributions Method plgMembersResources::onMembersContributions /core/plugins/members/resources/resources.php:142
  • onMembersContributions Method plgMembersWiki::onMembersContributions /core/plugins/members/wiki/wiki.php:90
  • onMembersContributions Method plgMembersCourses::onMembersContributions /core/plugins/members/courses/courses.php:417
  • onMembersContributions Method plgMembersImpact::onMembersContributions /core/plugins/members/impact/impact.php:266
  • onMembers Method plgMembersDashboard::onMembers /core/plugins/members/dashboard/dashboard.php:113
  • onMembers Method plgMembersProfile::onMembers /core/plugins/members/profile/profile.php:75
  • onMembers Method plgMembersAccount::onMembers /core/plugins/members/account/account.php:85
  • onMembers Method plgMembersBlog::onMembers /core/plugins/members/blog/blog.php:75
  • onMembers Method plgMembersCollections::onMembers /core/plugins/members/collections/collections.php:75
  • onMembers Method plgMembersContributions::onMembers /core/plugins/members/contributions/contributions.php:75
  • onMembers Method plgMembersCourses::onMembers /core/plugins/members/courses/courses.php:78
  • onMembers Method plgMembersGroups::onMembers /core/plugins/members/groups/groups.php:81
  • onMembers Method plgMembersImpact::onMembers /core/plugins/members/impact/impact.php:138
  • onMembers Method plgMembersMessages::onMembers /core/plugins/members/messages/messages.php:81
  • onMembers Method plgMembersPoints::onMembers /core/plugins/members/points/points.php:81
  • onMembers Method plgMembersProjects::onMembers /core/plugins/members/projects/projects.php:96
  • onMembers Method plgMembersResume::onMembers /core/plugins/members/resume/resume.php:185
  • onMembers Method plgMembersUsage::onMembers /core/plugins/members/usage/usage.php:75
  • onMembers Method plgMembersCitations::onMembers /core/plugins/members/citations/citations.php:92
  • onMembers Method plgMembersActivity::onMembers /core/plugins/members/activity/activity.php:78
  • onAfterDispatch Method plgSystemMobile::onAfterDispatch /core/plugins/system/mobile/mobile.php:47
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:87
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:49
  • onDisplay Method plgCaptchaImage::onDisplay /core/plugins/captcha/image/image.php:80
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:45