Guest User

Fontend user params off

a guest
Aug 3rd, 2011
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.06 KB | None | 0 0
  1. 27 Queries Logged
  2.  
  3. SELECT `data`
  4. FROM `tnzet_session`
  5. WHERE `session_id` = '14v7391onuimsek6dgf2nuslb2'
  6. SELECT folder AS type, element AS name, params
  7. FROM tnzet_extensions
  8. WHERE enabled >= 1
  9. AND type ='plugin'
  10. AND state >= 0
  11. AND access IN (1,1,2,3)
  12. ORDER BY ordering
  13. SELECT extension_id AS "id", element AS "option", params, enabled
  14. FROM tnzet_extensions
  15. WHERE `type` = 'component'
  16. AND `element` = 'com_languages'
  17. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component
  18. FROM tnzet_menu AS m
  19. LEFT JOIN tnzet_extensions AS e
  20. ON m.component_id = e.extension_id
  21. WHERE m.published = 1
  22. AND m.parent_id > 0
  23. AND m.client_id = 0
  24. AND m.access IN (1,1,2,3)
  25. ORDER BY m.lft
  26. SELECT extension_id AS "id", element AS "option", params, enabled
  27. FROM tnzet_extensions
  28. WHERE `type` = 'component'
  29. AND `element` = 'com_comprofiler'
  30. SELECT *
  31. FROM tnzet_languages
  32. WHERE published=1
  33. ORDER BY ordering ASC
  34. SELECT id, home, template, s.params
  35. FROM tnzet_template_styles as s
  36. LEFT JOIN tnzet_extensions as e
  37. ON e.element=s.template
  38. AND e.type='template'
  39. AND e.client_id=s.client_id
  40. WHERE s.client_id = 0
  41. AND e.enabled = 1
  42. SELECT c.*, u.*
  43. FROM tnzet_users AS u
  44. LEFT JOIN tnzet_comprofiler AS c
  45. ON c.id = u.id
  46. WHERE u.id = 42
  47. SHOW FULL COLUMNS
  48. FROM `tnzet_users`
  49. SELECT *
  50. FROM tnzet_users
  51. WHERE id = 42
  52. SELECT g.id, g.title
  53. FROM tnzet_usergroups AS g JOIN tnzet_user_usergroup_map AS m
  54. ON m.group_id = g.id
  55. WHERE m.user_id = 42
  56. SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
  57. FROM tnzet_comprofiler_plugin
  58. WHERE published = 1
  59. AND access <= 8
  60. AND type = 'user'
  61. ORDER BY ordering
  62. SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
  63. FROM tnzet_comprofiler_plugin
  64. WHERE published = 1
  65. AND access <= 8
  66. AND type = 'templates'
  67. ORDER BY ordering
  68. SELECT `group_id`
  69. FROM `tnzet_user_usergroup_map`
  70. WHERE `user_id` = 42
  71. SELECT *
  72. FROM `tnzet_usergroups`
  73. ORDER BY `lft`
  74. SELECT *
  75. FROM `tnzet_usergroups`
  76. ORDER BY `lft`
  77. SELECT *
  78. FROM tnzet_comprofiler_tabs t
  79. WHERE t.enabled=1
  80. AND t.useraccessgroupid IN (1,2,3,4,5,6,7,8,-2,-1)
  81. ORDER BY t.position, t.ordering
  82. SELECT id
  83. FROM tnzet_menu
  84. WHERE link = 'index.php?option=com_comprofiler'
  85. AND published=1
  86. AND access <= 8
  87. SELECT f.*
  88. FROM tnzet_comprofiler_fields f
  89. INNER JOIN tnzet_comprofiler_tabs AS t
  90. ON (f.tabid = t.tabid)
  91. WHERE f.published = 1
  92. AND f.profile != 0
  93. AND t.enabled = 1
  94. AND t.useraccessgroupid IN (1,2,3,4,5,6,7,8,-2,-1)
  95. ORDER BY t.position, t.ordering, f.ordering
  96. SELECT MAX(time)
  97. FROM tnzet_session
  98. WHERE userid = 42
  99. AND guest = 0
  100. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  101. FROM tnzet_modules AS m
  102. LEFT JOIN tnzet_modules_menu AS mm
  103. ON mm.moduleid = m.id
  104. LEFT JOIN tnzet_extensions AS e
  105. ON e.element = m.module
  106. AND e.client_id = m.client_id
  107. WHERE m.published = 1
  108. AND e.enabled = 1
  109. AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-08-04 04:07:26')
  110. AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-08-04 04:07:26')
  111. AND m.access IN (1,1,2,3)
  112. AND m.client_id = 0
  113. AND (mm.menuid = 110 OR mm.menuid <= 0)
  114. ORDER BY m.position, m.ordering
  115. SELECT *
  116. FROM tnzet_banners
  117. WHERE NOW() >= `reset`
  118. AND `reset` != '0000-00-00 00:00:00'
  119. AND `reset`!=NULL
  120. AND (`checked_out` = 0 OR `checked_out` = 0)
  121. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  122. FROM tnzet_banners as a
  123. LEFT JOIN tnzet_banner_clients AS cl
  124. ON cl.id = a.cid
  125. LEFT JOIN tnzet_categories as cat
  126. ON a.catid = cat.id
  127. WHERE a.state=1
  128. AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  129. AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  130. AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  131. AND a.cid = 3
  132. AND cl.state = 1
  133. ORDER BY a.sticky DESC,a.ordering
  134. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  135. FROM tnzet_banners as a
  136. LEFT JOIN tnzet_banner_clients AS cl
  137. ON cl.id = a.cid
  138. LEFT JOIN tnzet_categories as cat
  139. ON a.catid = cat.id
  140. WHERE a.state=1
  141. AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  142. AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  143. AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  144. AND a.cid = 3
  145. AND cl.state = 1
  146. ORDER BY a.sticky DESC,a.ordering
  147. LIMIT 0, 1
  148. SELECT extension_id AS "id", element AS "option", params, enabled
  149. FROM tnzet_extensions
  150. WHERE `type` = 'component'
  151. AND `element` = 'com_content'
  152. SELECT id
  153. FROM tnzet_menu
  154. WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
  155. AND published=1
  156. AND access <= 8
  157. UPDATE `tnzet_session`
  158. SET `data` = '__default|a:7:{s:15:\"session.counter\";i:26;s:19:\"session.timer.start\";i:1312429871;s:18:\"session.timer.last\";i:1312430846;s:17:\"session.timer.now\";i:1312430846;s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:13:\"[email protected]\";s:8:\"password\";s:65:\"d4fe2c57aa14dbc9f7342b3206b323df:k6Gnpx8MDYBluVvSMPdiPeBhWjPpvkyP\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-08-04 03:49:22\";s:13:\"lastvisitDate\";s:19:\"2011-08-04 03:49:28\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{i:0;s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}', `time` = 1312430846
  159. WHERE `session_id` = '14v7391onuimsek6dgf2nuslb2'
  160.  
  161. 21 Query Types Logged, Sorted by Occurrences.
  162. SELECT Tables:
  163.  
  164. 3 × SELECT extension_id AS "id", element AS "option", params, enabled FROM tnzet_extensions
  165. 2 × SELECT id FROM tnzet_menu
  166. 2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM tnzet_banners as a LEFT JOIN tnzet_banner_clients AS cl ON cl.id = a.cid LEFT JOIN tnzet_categories as cat ON a.catid = cat.id
  167. 2 × SELECT * FROM `tnzet_usergroups`
  168. 2 × SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name FROM tnzet_comprofiler_plugin
  169. 1 × SELECT f.* FROM tnzet_comprofiler_fields f INNER JOIN tnzet_comprofiler_tabs AS t ON (f.tabid = t.tabid)
  170. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component FROM tnzet_menu AS m LEFT JOIN tnzet_extensions AS e ON m.component_id = e.extension_id
  171. 1 × SELECT MAX(time) FROM tnzet_session
  172. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM tnzet_modules AS m LEFT JOIN tnzet_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN tnzet_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  173. 1 × SELECT folder AS type, element AS name, params FROM tnzet_extensions
  174. 1 × SELECT * FROM tnzet_banners
  175. 1 × SELECT * FROM tnzet_comprofiler_tabs t
  176. 1 × SELECT * FROM tnzet_languages
  177. 1 × SELECT * FROM tnzet_users
  178. 1 × SELECT c.*, u.* FROM tnzet_users AS u LEFT JOIN tnzet_comprofiler AS c ON c.id = u.id
  179. 1 × SELECT g.id, g.title FROM tnzet_usergroups AS g JOIN tnzet_user_usergroup_map AS m ON m.group_id = g.id
  180. 1 × SELECT `data` FROM `tnzet_session`
  181. 1 × SELECT `group_id` FROM `tnzet_user_usergroup_map`
  182. 1 × SELECT id, home, template, s.params FROM tnzet_template_styles as s LEFT JOIN tnzet_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  183.  
  184. OTHER Tables:
  185.  
  186. 1 × UPDATE `tnzet_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:26;s:19:\"session.timer.start\";i:1312429871;s:18:\"session.timer.last\";i:1312430846;s:17:\"session.timer.now\";i:1312430846;s:22:\"session.client.browser\";s:70:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:13:\"[email protected]\";s:8:\"password\";s:65:\"d4fe2c57aa14dbc9f7342b3206b323df:k6Gnpx8MDYBluVvSMPdiPeBhWjPpvkyP\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-08-04 03:49:22\";s:13:\"lastvisitDate\";s:19:\"2011-08-04 03:49:28\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{i:0;s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}', `time` = 1312430846
  187. 1 × SHOW FULL COLUMNS FROM `tnzet_users
Advertisement
Add Comment
Please, Sign In to add comment