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

Ruby Shah

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 MBRequestSessionTimelineDatabase94Events59
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( REDIRECT_SCRIPT_URL => /members/2357/usage, REDIRECT_SCRIPT_URI => https://itmig.curie... Array(
REDIRECT_SCRIPT_URL => /members/2357/usage,
REDIRECT_SCRIPT_URI => https://itmig.curie.fr/members/2357/usage,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => itmig.curie.fr,
REDIRECT_STATUS => 200,
SCRIPT_URL => /members/2357/usage,
SCRIPT_URI => https://itmig.curie.fr/members/2357/usage,
HTTPS => on,
SSL_TLS_SNI => itmig.curie.fr,
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 => itmig.curie.fr,
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 => itmig.curie.fr,
SERVER_ADDR => 192.168.25.26,
SERVER_PORT => 443,
REMOTE_ADDR => 18.208.187.128,
DOCUMENT_ROOT => /var/www/itmig,
REQUEST_SCHEME => https,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/itmig,
SERVER_ADMIN => [no address given],
SCRIPT_FILENAME => /var/www/itmig/index.php,
REMOTE_PORT => 49000,
REDIRECT_URL => /members/2357/usage,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /members/2357/usage,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1664176680.849,
REQUEST_TIME => 1664176680
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid bc55abcf60152defda52698e81157c42
tracker.ssid bc55abcf60152defda52698e81157c42
tracker.rsid bc55abcf60152defda52698e81157c42
session.token ae2b78a04aa081061fa2c5f5182239d1
  • site 0.013 seconds (+0.013); 3.75 MB (+3.750) - afterInitialise
  • site 0.020 seconds (+0.007); 4.25 MB (+0.500) - afterRoute
  • site 0.087 seconds (+0.067); 12.25 MB (+8.000) - afterDispatch
  • site 0.092 seconds (+0.005); 12.25 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.093 seconds (+0.001); 12.50 MB (+0.250) - afterRenderModule mod_custom (Hub Footer)
  • site 0.093 seconds (+0.000); 12.50 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.095 seconds (+0.002); 12.75 MB (+0.250) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.095 seconds (+0.000); 12.75 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.100 seconds (+0.005); 12.75 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.100 seconds (+0.000); 12.75 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.101 seconds (+0.001); 12.75 MB (0.000) - afterRenderModule mod_search (Search)
  • site 0.101 seconds (+0.000); 12.75 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.105 seconds (+0.004); 12.75 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.107 seconds (+0.002); 12.75 MB (0.000) - onAfterRender
  • site 0.108 seconds (+0.001); 12.75 MB (0.000) - sessionStore
13 MB

94 Queries Logged: 0.01289176940918 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '9fdccf52379b05b985460089d726bc73'
  2. DELETE
      FROM`jos_session`
      WHERE `session_id` = '9fdccf52379b05b985460089d726bc73'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'bc55abcf60152defda52698e81157c42'
  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` = 'bc55abcf60152defda52698e81157c42'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('bc55abcf60152defda52698e81157c42','0','1664176680','18.208.187.128')
  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` = '2357'
  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 > '2022-09-26 07:18:00'
  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` = '2357'
      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` <= '2022-09-26 07:18:00' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2022-09-26 07:18:00' )
  28. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` IN ('2357')
  29. SELECT id,entry_id
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`state` IN ('1','3')
      AND `jos_blog_comments`.`entry_id` IN ('1936','2708')
  30. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  31. SHOW FULL COLUMNS
      FROM `jos_collections`
  32. 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='2357'
      AND b.object_type='member'
  33. 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='2357'
      AND b.object_type='member'
  34. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  35. 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` = '2357'
      AND `jos_author_assoc`.`role` != 'submitter'
      AND `jos_resources`.`access` IN ('0','3')
  36. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  37. SELECT *
      FROM `jos_wiki_versions`
      WHERE `jos_wiki_versions`.`created_by` = '2357'
      AND `jos_wiki_versions`.`approved` = '1'
      GROUP BY page_id,id
  38. 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 ('')
  39. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  40. SHOW FULL COLUMNS
      FROM `jos_courses`
  41. 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=2357
      AND m.student=0
      AND r.alias='instructor'
      AND c.state=1
  42. SHOW FULL COLUMNS
      FROM `jos_publications`
  43. SELECT *
      FROM `jos_publication_categories`
      WHERE `jos_publication_categories`.`state` = '1'
      ORDER BY `name` ASC
  44. 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` = '2357'
      AND (`jos_publication_authors`.`role` IS NULL OR `jos_publication_authors`.`role` != 'submitter' )
      AND `jos_publication_versions`.`access` IN ('0','3')
  45. SHOW FULL COLUMNS
      FROM `jos_courses_offerings`
  46. SHOW FULL COLUMNS
      FROM `jos_courses_roles`
  47. 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)
  48. 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=2357
      AND m.student=0
      AND r.alias='instructor'
  49. 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=2357
      AND m.student=0
      AND r.alias='manager'
  50. 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=2357
      AND m.student=1
      AND (s.publish_down IS NULL OR s.publish_down='0000-00-00 00:00:00' OR s.publish_down < '2022-09-26 07:18:00')
      AND s.state=1
      AND o.state=1
  51. SELECT *
      FROM `jos_xgroups_inviteemails`
      WHERE `jos_xgroups_inviteemails`.`email` = 'rubyshah8564@gmail.com'
  52. ( 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=2357 ) 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=2357 ) 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=2357 ) 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=2357 )
  53. 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=2357
      WHERE `jos_xmessage_recipient`.`uid` = '2357'
      AND `jos_xmessage_recipient`.`state` = '0'
  54. 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` = '2357'
      AND `jos_xmessage_recipient`.`state` != '2'
      AND jos_xmessage.id NOT IN (SELECT s.mid
      FROM `jos_xmessage_seen` AS s
      WHERE s.uid=2357)
  55. SHOW TABLES
  56. SELECT *
      FROM `jos_users_points`
      WHERE `jos_users_points`.`uid` = '2357'
  57. SHOW FULL COLUMNS
      FROM `jos_projects`
  58. 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='2357'
      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='2357'
      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='2357')))
      AND p.provisioned = 0
  59. SHOW FULL COLUMNS
      FROM `jos_project_owners`
  60. 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='rubyshah8564@gmail.com'
  61. 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 > '2022-09-26 07:18:00'
  62. 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 > '2022-09-26 07:18:00'
  63. 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 > '2022-09-26 07:18:00'
  64. SHOW TABLES
  65. 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 = '2357'
      AND aa.role!='submitter'
      AND res.standalone = 1
      AND res.published = 1
      AND (res.access=0 OR res.access=3)
      AND aa.subtable = 'resources'
  66. 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
  67. SELECT tool_users
      FROM `jos_author_stats`
      WHERE authorid = '2357'
      AND period = '14'
      ORDER BY datetime DESC
      LIMIT 1
  68. SELECT andmore_users
      FROM `jos_author_stats`
      WHERE authorid = '2357'
      AND period = '14'
      ORDER BY datetime DESC
      LIMIT 1
  69. 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 = '2357'
  70. SELECT classes
      FROM `jos_metrics_author_cluster`
      WHERE authorid = '2357'
  71. SELECT users
      FROM `jos_metrics_author_cluster`
      WHERE authorid = '2357'
  72. SELECT schools
      FROM `jos_metrics_author_cluster`
      WHERE authorid = '2357'
  73. 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="2357")
      AND r.access IN (0,3)
      ORDER BY r.publish_up DESC
  74. SELECT tool_users
      FROM `jos_author_stats`
      WHERE authorid = '2357'
      AND period = '12'
      ORDER BY datetime DESC
      LIMIT 1
  75. SELECT tool_users
      FROM `jos_author_stats`
      WHERE authorid = '2357'
      AND period = '14'
      ORDER BY datetime DESC
      LIMIT 1
  76. 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='2357'
      AND aa.role!='submitter'
      AND r.access IN (0,3)
      ORDER BY r.publish_up DESC
  77. SELECT andmore_users
      FROM `jos_author_stats`
      WHERE authorid = '2357'
      AND period = '12'
      ORDER BY datetime DESC
      LIMIT 1
  78. SELECT andmore_users
      FROM `jos_author_stats`
      WHERE authorid = '2357'
      AND period = '14'
      ORDER BY datetime DESC
      LIMIT 1
  79. 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` = '2357'
      AND `jos_citations`.`published` IN ('1')
  80. SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
      WHERE `jos_activity_recipients`.`scope` = 'user'
      AND `jos_activity_recipients`.`scope_id` = '2357'
      AND `jos_activity_recipients`.`state` = '1'
      AND `jos_activity_recipients`.`viewed` IS NULL
  81. ( 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 )
  82. ( 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=2357 ) 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=2357 ) 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=2357 ) 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=2357 )
  83. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  84. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  85. 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` <= '2022-09-26 07:18:00' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2022-09-26 07:18:00' )
      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
  86. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  87. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  88. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  89. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  90. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  91. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  92. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  93. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  94. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1664176680;s:18:\"session.timer.last\";i:1664176680;s:17:\"session.timer.now\";i:1664176680;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:\"bc55abcf60152defda52698e81157c42\";s:12:\"tracker.ssid\";s:32:\"bc55abcf60152defda52698e81157c42\";s:12:\"tracker.rsid\";s:32:\"bc55abcf60152defda52698e81157c42\";s:13:\"session.token\";s:32:\"ae2b78a04aa081061fa2c5f5182239d1\";}',`time` = '1664176680',`ip` = '18.208.187.128'
      WHERE `session_id` = 'bc55abcf60152defda52698e81157c42'
  • 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
  • onAfterInitialise Method plgSystemReferrerpolicy::onAfterInitialise /core/plugins/system/referrerpolicy/referrerpolicy.php:21
  • 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
  • onMembersContributionsAreas Method plgMembersPublications::onMembersContributionsAreas /core/plugins/members/publications/publications.php:90
  • 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
  • onMembersContributions Method plgMembersPublications::onMembersContributions /core/plugins/members/publications/publications.php:127
  • 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:85
  • 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