RCT3 FAQs

•Profile Information•

•Memory Usage•

•84 queries logged•

1. SELECT *
     FROM jos_session
     WHERE session_id = '37098452b94145169beb69a8934bb2b3'
2. DELETE
     FROM jos_session
     WHERE ( time < '1337590732' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '37098452b94145169beb69a8934bb2b3'
4. UPDATE `jos_session`
     SET `time`='1337591632',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:10:{s:15:\"session.counter\";i:8;s:19:\"session.timer.start\";i:1337590915;s:18:\"session.timer.last\";i:1337591425;s:17:\"session.timer.now\";i:1337591451;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:6:\"global\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"limit\";i:12;}}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":20:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:66:\"/home/goopedg1/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}s:6:\"avatar\";s:82:\"http://www.goopedgamers.com/components/com_jsocialsuite/images/no_avatar_small.png\";}s:9:\"myfriends\";s:6:\"a:0:{}\";s:13:\"session.token\";s:32:\"9bb54317737ee32f239f73feaea272f5\";s:19:\"socialites_cachtime\";i:1337591229;}'
     WHERE session_id='37098452b94145169beb69a8934bb2b3'
5. SELECT *
     FROM jos_components
     WHERE parent = 0
6. SELECT folder AS type, element AS name, params
     FROM jos_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
7. SELECT id, parent_id, value, name, lft, rgt
     FROM jos_core_acl_aro_groups
     WHERE id=23
8. SELECT id, parent_id, value, name, lft, rgt
     FROM jos_core_acl_aro_groups
     WHERE id=21
9. SELECT id, parent_id, value, name, lft, rgt
     FROM jos_core_acl_aro_groups
     WHERE id=23
10. SELECT id, parent_id, value, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=25
11. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
12. SELECT *
      FROM jos_jss_hooks
      WHERE `published` = '1'
      ORDER BY `hook`, `ord`
13. SELECT p.`folder_name`
                                   
      FROM jos_jss_plugins p
      WHERE p.`published` = '1'
14. SELECT a.`folder_name`
                                           
      FROM jos_jss_apps a
      WHERE a.`published` = '1'
15. SELECT `file`, `params`
      FROM `jos_sefexts`
16. SELECT *
      FROM jos_sefurls
      WHERE ((`sefurl` = 'community/faq/1-rct3faq/1-My-icons-are-not-displaying-correctly-in-game..html') OR (`sefurl` = 'community/faq/1-rct3faq/1-My-icons-are-not-displaying-correctly-in-game..html/'))
      AND (`origurl` != '')
      ORDER BY `priority`
      LIMIT 1
17. SELECT *
      FROM `jos_sefmoved`
      WHERE (`old` = 'community/faq/1-rct3faq/1-My-icons-are-not-displaying-correctly-in-game..html') OR (`old` = 'community/faq/1-rct3faq/1-My-icons-are-not-displaying-correctly-in-game..html/')
18. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 24)
      ORDER BY menuid DESC
      LIMIT 0, 1
19. SELECT *
      FROM jos_jcomments_settings
20. SELECT i.*, (i.plus / (i.plus + i.minus) ) * 100 AS votes, c.access AS cataccess, c.id AS catid, c.published AS catpublished, u.name AS author, u.usertype, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS categoryslug
      FROM jos_quickfaq_items AS i
      LEFT JOIN jos_quickfaq_cats_item_relations AS rel
      ON rel.itemid = i.id
      LEFT JOIN jos_quickfaq_categories AS c
      ON c.id = rel.catid
      LEFT JOIN jos_users AS u
      ON u.id = i.created_by
      WHERE i.id = 1
21. SELECT name
      FROM jos_users
      WHERE id = 62
22. UPDATE jos_quickfaq_items
      SET hits = ( hits + 1 )
      WHERE id='1'
23. SELECT DISTINCT t.name, CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END AS slug
      FROM jos_quickfaq_tags AS t
      LEFT JOIN jos_quickfaq_tags_item_relations AS i
      ON i.tid = t.id
      WHERE i.itemid = 1
      AND t.published = 1
      ORDER BY t.name
24. SELECT DISTINCT c.id, c.title, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug
      FROM jos_quickfaq_categories AS c
      LEFT JOIN jos_quickfaq_cats_item_relations AS rel
      ON rel.catid = c.id
      WHERE rel.itemid = 1
25. SELECT COUNT(id) AS favs
      FROM jos_quickfaq_favourites
      WHERE itemid = 1
26. SELECT COUNT(id) AS fav
      FROM jos_quickfaq_favourites
      WHERE itemid = 1
      AND userid= 0
27. SELECT DISTINCT rel.fileid, f.filename, f.altname
      FROM jos_quickfaq_files AS f
      LEFT JOIN jos_quickfaq_files_item_relations AS rel
      ON rel.fileid = f.id
      WHERE rel.itemid = 1
28. SELECT parent_id
      FROM jos_quickfaq_categories
      WHERE id = 1
29. SELECT parent_id
      FROM jos_quickfaq_categories
      WHERE id = 1
30. SELECT parent_id
      FROM jos_quickfaq_categories
      WHERE id = 0
31. SELECT id, title, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END AS categoryslug
      FROM jos_quickfaq_categories
      WHERE id =1
      AND published = 1
32. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_quickfaq.xml'
      LIMIT 1
33. SELECT DISTINCT SQL_CALC_FOUND_ROWS u1.id, u1.name, u1.username, u1.email, u1.usertype, u1.block,
                                            u1.registerDate, u1.lastvisitDate, u2.sex, u2.dob, u2.descr, u2.show_email, u2.show_dob, u2.show_name,
                                            u2.views_count, u2.friends_count, u2.rating, u2.votes_count, u2.apps_count, u2.tmplid, u2.avatarid, u2.acceptedterms
                                   
      FROM jos_jss_users u2
                                    JOIN jos_users u1
      ON u1.`id` = u2.`user_id`
                                    JOIN jos_jss_user_friends f
      ON u2.`user_id` = f.`friend_id`
                                           
      AND f.`confirmed` = '1'
                                   
      WHERE f.`user_id` = 0
      LIMIT 0, 12
34. SELECT m.*, am.params AS adv_params
      FROM jos_modules AS m
      LEFT JOIN jos_advancedmodules AS am
      ON am.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      ORDER BY m.ordering, m.id
35. SELECT *
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND cid = 1
      AND catid = 7
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
36. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 1
37. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_banners.xml'
      LIMIT 1
38. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_banners&bid=1&task=click'
39. SELECT id
      FROM jos_menu
      WHERE link = 'index.php?option=com_jdownloads'
40. SELECT cat_id
      FROM jos_jdownloads_cats
      WHERE published = 1
      AND cat_access <= 01
41. SELECT *
      FROM jos_jdownloads_files
      WHERE published = 1
      AND cat_id IN (4,5,6,3,7,8,9,10,11,12,13,14,15,16,17)
      ORDER BY downloads DESC
      LIMIT 3
42. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_jdownloads.xml'
      LIMIT 1
43. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=17&cid=17&task=view.download'
44. SELECT id
      FROM jos_menu
      WHERE link = 'index.php?option=com_jdownloads'
45. SELECT cat_id
      FROM jos_jdownloads_cats
      WHERE published = 1
      AND cat_access <= 01
46. SELECT *
      FROM jos_jdownloads_files
      WHERE published = 1
      AND cat_id IN (4,5,6,3,7,8,9,10,11,12,13,14,15,16,17)
      ORDER BY downloads DESC
      LIMIT 5
47. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=17&cid=17&task=view.download'
48. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=4&cid=47&task=view.download'
49. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=4&cid=49&task=view.download'
50. SELECT cat_id
      FROM jos_jdownloads_cats
      WHERE published = 1
      AND cat_access <= 01
51. SELECT COUNT(*)
      FROM jos_jdownloads_files
      WHERE published = 1
      AND cat_id IN (4,5,6,3,7,8,9,10,11,12,13,14,15,16,17)
52. SELECT SUM(downloads)
      FROM jos_jdownloads_files
      WHERE published = 1
      AND cat_id IN (4,5,6,3,7,8,9,10,11,12,13,14,15,16,17)
53. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_agora.xml'
      LIMIT 1
54. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_user.xml'
      LIMIT 1
55. SELECT `value`
      FROM jos_jss_config
      WHERE `optname` = 'allow_user_registration'
56. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_jsocialsuite.xml'
      LIMIT 1
57. SELECT *
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND cid = 2
      AND catid = 52
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
58. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 2
59. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_banners&bid=2&task=click'
60. SELECT DISTINCT u.id, u.username, u.name, u.email, au.id AS `agora_user_id` 
      FROM jos_session s, jos_users u, jos_agora_users au 
      WHERE s.userid = u.id
      AND u.id = au.jos_id
      AND s.client_id = 0
      ORDER BY u.`username`
61. SELECT DISTINCT `data`
      FROM jos_session
      WHERE guest <> 0
      AND client_id = 0 
      AND `data` NOT LIKE '%bot%'
      AND `data` NOT LIKE '%igdeSpyder%'
      AND `data` NOT LIKE '%Mail.Ru%'
      AND `data` NOT LIKE '%StackRambler%'
      AND `data` NOT LIKE '%Yandex%'
      AND `data` NOT LIKE '%Yanga%'
      AND `data` NOT LIKE '%Yahoo%'
      AND `data` NOT LIKE '%Snoopy%'
62. SELECT w.tstamp, w.this_user, w.that_user, w.output, w.app_id, w.plg_id, w.icon, w.STATUS, u1.name AS this_name, u1.username AS this_username, u2.name AS that_name, u2.username AS that_username, a.name AS appname, p.name AS plgname, ju1.show_name AS this_showname, ju1.avatarid AS this_avatarid, ju1.sex AS this_sex, ju2.show_name AS that_showname, ju2.avatarid AS that_avatarid, ju2.sex AS that_sex 
      FROM (
                                                    SELECT DISTINCT w1.*, w2.userid, w2.tstamp
                                                   
      FROM jos_jss_thewall w1
                                                    JOIN jos_jss_thewall_users w2
      ON w1.id = w2.wall_id
                                                           
      AND w1.this_user = w2.userid
                                                   
                                            ) w JOIN `jos_jss_users` AS ju1
      ON ju1.user_id = w.this_user  JOIN `jos_users` AS u1
      ON u1.id = w.this_user 
      LEFT JOIN `jos_users` AS u2
      ON u2.id = w.that_user 
      LEFT JOIN `jos_jss_users` AS ju2
      ON ju2.user_id = w.that_user 
      LEFT JOIN `jos_jss_apps` AS a
      ON w.`app_id` = a.`id`
      LEFT JOIN `jos_jss_plugins` AS p
      ON w.`plg_id` = p.`id`
      GROUP BY w.tstamp
      ORDER BY w.tstamp DESC 
      LIMIT 10
63. SELECT id
      FROM jos_menu
      WHERE link = 'index.php?option=com_jdownloads'
64. SELECT cat_id
      FROM jos_jdownloads_cats
      WHERE published = 1
      AND cat_access <= 01
65. SELECT *
      FROM jos_jdownloads_files
      WHERE published = 1
      AND cat_id IN (4,5,6,3,7,8,9,10,11,12,13,14,15,16,17)
      ORDER BY date_added DESC
      LIMIT 5
66. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=7&cid=96&task=view.download'
67. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=7&cid=95&task=view.download'
68. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=12&cid=94&task=view.download'
69. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=16&cid=93&task=view.download'
70. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads&catid=14&cid=92&task=view.download'
71. SELECT cc.id, cc.userid, cc.comment, cc.name, cc.username, cc.email, cc.date, cc.object_id, cc.object_group, '' AS avatar
     
      FROM jos_jcomments AS cc
     
      LEFT JOIN jos_content AS c
      ON c.id = cc.object_id
     
      WHERE cc.published = 1
       
      AND c.access <= '0'
       
      AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= NOW())
       
      AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= NOW())
       
      AND cc.object_group = 'com_content'
       
      AND (c.sectionid IN (5) )
     
      ORDER BY cc.date DESC
     
      LIMIT 5
72. SELECT a.id, a.sectionid, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      WHERE a.id = 19
73. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_content.xml'
      LIMIT 1
74. SELECT title
      FROM jos_content
      WHERE id = 19
75. SELECT `catid`
      FROM `jos_content`
      WHERE `id` = '4'
76. SELECT `catid`
      FROM `jos_content`
      WHERE `id` = '2'
77. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_content&catid=1&id=2&view=article'
78. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_aikadmin.xml'
      LIMIT 1
79. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_weblinks.xml'
      LIMIT 1
80. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_chronocontact.xml'
      LIMIT 1
81. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_jdownloads'
82. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_lyftenbloggie.xml'
      LIMIT 1
83. SELECT `filters`
      FROM `jos_sefexts`
      WHERE `file` = 'com_phocadocumentation.xml'
      LIMIT 1
84. SELECT `sefurl`, `Itemid`
      FROM `jos_sefurls`
      WHERE `origurl` = 'index.php?option=com_content&layout=form&view=article'

•Language Files Loaded•

• /home/goopedg1/public_html/language/en-GB/en-GB.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.plg__.ini
• /home/goopedg1/public_html/language/en-GB/en-GB.plg_system_sourcerer.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.jss_app_friendsonline.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.jss_app_rssreader.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.jss_app_thewall.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.jss_app_friendssuggestions.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.jss_plg_jcoterie.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.jss_plg_comments.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.jss_plg_photos.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.jss_app_birthday_reminder.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.jss_app_google_weather.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.jss_plg_agora3.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.jss_plg_mce.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.jss_plg_twitter.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.jss_app_twitter.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.com_jsocialsuite.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.plg_system_debug.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.com_jcomments.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.com_quickfaq.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.com_k2.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.tpl_mystique.ini
• /home/goopedg1/public_html/language/en-GB/en-GB.mod_banners.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.mod_jdownloads_pics.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.mod_jdownloads_top.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.mod_jdownloads_stats.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.mod_pixsearch.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.mod_uddeim.ini
• /home/goopedg1/public_html/language/en-GB/en-GB.mod_vitallogin.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.mod_jsocialites.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.mod_jssactivity.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.mod_jdownloads_latest.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.mod_jcomments.ini 1
• /home/goopedg1/public_html/language/en-GB/en-GB.mod_paypal_donate.ini
• /home/goopedg1/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1

•Untranslated Strings Diagnostic•

MYDETAILS	::LyftenBloggieBuildRoute()	[/home/goopedg1/public_html/components/com_sef/joomsef.php:215]
MYENTRIES	::LyftenBloggieBuildRoute()	[/home/goopedg1/public_html/components/com_sef/joomsef.php:215]

•Untranslated Strings Designer•

# /home/goopedg1/public_html/components/com_sef/joomsef.php

MYDETAILS=MYDETAILS
MYENTRIES=MYENTRIES