1. SELECT * FROM jos_session WHERE session_id = 'abifb2t8f5ph4drbu281lgmt06' 2. DELETE FROM jos_session WHERE ( time < '1294773463' ) 3. SELECT * FROM jos_session WHERE session_id = 'abifb2t8f5ph4drbu281lgmt06' 4. UPDATE `jos_session` SET `time`='1294777063',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:34;s:19:\"session.timer.start\";i:1294771915;s:18:\"session.timer.last\";i:1294776402;s:17:\"session.timer.now\";i:1294777006;s:22:\"session.client.browser\";s:93:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6 Glue/4.5\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{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:76:\"/var/www/vhosts/jagbook.net/httpdocs/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:{}}}' WHERE session_id='abifb2t8f5ph4drbu281lgmt06' 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 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 9. SELECT * FROM `jos_cbsubs_config` WHERE `id` = '1' 10. SELECT a.* FROM `jos_cbsubs_plans` AS a LEFT JOIN `jos_cbsubs_plans` AS b ON b.`id` = a.`parent` WHERE a.published = 1 GROUP BY a.id ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC 11. SELECT template FROM jos_templates_menu WHERE client_id = 0 AND (menuid = 0 OR menuid = 28) ORDER BY menuid DESC LIMIT 0, 1 12. SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name FROM jos_comprofiler_plugin WHERE published = 1 AND access <= 0 AND type = 'user' ORDER BY ordering 13. SELECT * FROM jos_users AS u LEFT JOIN jos_comprofiler AS c ON c.id = u.id WHERE u.`username` = 'Brandon' LIMIT 0, 1 14. SELECT id FROM jos_core_acl_aro_groups WHERE value='Registered' 15. SELECT f.*, t.ordering_register AS tab_ordering_register, t.position AS tab_position, t.ordering AS tab_ordering FROM jos_comprofiler_fields f INNER JOIN jos_comprofiler_tabs AS t ON (f.tabid = t.tabid) WHERE f.published = 1 AND f.registration = 1 AND t.enabled = 1 ORDER BY t.ordering_register, t.position, t.ordering, f.ordering 16. SELECT a.* FROM `jos_cbsubs_plans` AS a LEFT JOIN `jos_cbsubs_plans` AS b ON b.`id` = a.`parent` WHERE a.published = 1 AND a.allow_newsubscriptions = 1 AND a.allow_registration = 1 AND a.allow_frontend = 1 GROUP BY a.id ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC 17. SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name FROM jos_comprofiler_plugin WHERE published = 1 AND access <= 0 AND type = 'user/plug_cbpaidsubscriptions/plugin' ORDER BY ordering 18. SELECT `gid` FROM `jos_users` WHERE `id` = 0 19. SELECT g1.`id` AS group_id, g1.`name` FROM `jos_core_acl_aro_groups` AS g1 LEFT JOIN `jos_core_acl_aro_groups` AS g2 ON g2.`lft` >= g1.`lft` WHERE g2.`id` = 0 ORDER BY g1.`name` 20. SELECT * FROM jos_comprofiler_tabs t WHERE t.enabled=1 AND t.useraccessgroupid IN (-2) ORDER BY t.position, t.ordering 21. SELECT fieldtitle AS id FROM jos_comprofiler_field_values WHERE fieldid = 93 ORDER BY ordering 22. SELECT fieldtitle AS id FROM jos_comprofiler_field_values WHERE fieldid = 94 AND fieldtitle = 'Active' 23. SELECT fieldtitle AS id FROM jos_comprofiler_field_values WHERE fieldid = 95 ORDER BY ordering 24. SELECT fieldtitle AS id FROM jos_comprofiler_field_values WHERE fieldid = 96 ORDER BY ordering 25. SELECT name FROM jos_core_acl_aro_groups WHERE id = 18 26. SELECT * FROM `jos_comprofiler_sessions` WHERE `session_id` = 'QRQjN8iniXTJIVtQI87RT0CoZDIimXgD' AND `expiry_time` >= UNIX_TIMESTAMP() 27. UPDATE `jos_comprofiler_sessions` SET `session_data` = 'a:3:{s:17:\"cbsessions.verify\";s:32:\"3lmxNQc3oLscO0EsSduopqE7BCEoE2Jv\";s:15:\"cbsession.agent\";s:93:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6 Glue/4.5\";s:15:\"cb.plug.captcha\";a:0:{}}', `expiry_time` = UNIX_TIMESTAMP()+43200, `ui` = 1 WHERE `session_id` = 'QRQjN8iniXTJIVtQI87RT0CoZDIimXgD' 28. DELETE FROM `jos_comprofiler_sessions` WHERE `expiry_time` < UNIX_TIMESTAMP(); 29. SELECT name FROM jos_core_acl_aro_groups WHERE id = 18 30. SELECT id FROM jos_users WHERE username = 'Brandon' AND id != 0 31. SELECT id FROM jos_users WHERE email = 'no@email.com' AND id != 0 32. INSERT INTO `jos_users` ( `id`,`name`,`username`,`email`,`password`,`usertype`,`block`,`sendEmail`,`gid`,`registerDate`,`params` ) VALUES ( '0','Brandon','Brandon','no@email.com','a609c376f7878892f001f849053cfffc:0W0cMx8ih5DhovO4iPYhI6p70yaJYErA','Registered','0','0','18','2011-01-11 20:17:44','\n' ) 33. SELECT CASE WHEN o.id IS NULL THEN 0 ELSE 1 END AS object_exists FROM jos_core_acl_aro_sections s LEFT JOIN jos_core_acl_aro o ON (s.value=o.section_value AND o.value='114') WHERE s.value='users' 34. SELECT MAX(id) FROM jos_core_acl_aro 35. INSERT INTO jos_core_acl_aro (id,section_value,value,order_value,name,hidden) VALUES(0,'users','114',0,'Brandon',0) 36. SELECT o.id AS id,g.id AS group_id,gm.group_id AS member FROM jos_core_acl_aro o LEFT JOIN jos_core_acl_aro_groups g ON g.id=18 LEFT JOIN jos_core_acl_groups_aro_map gm ON (gm.aro_id=o.id AND gm.group_id=g.id) WHERE (o.section_value='users' AND o.value='114') 37. INSERT INTO jos_core_acl_groups_aro_map (group_id,aro_id) VALUES (18,62) 38. INSERT INTO `jos_comprofiler` ( `id`,`user_id`,`approved`,`confirmed`,`registeripaddr`,`acceptedterms`,`company`,`address`,`cb_countrydropdown`,`cb_countrydropdown_desc`,`cb_statedropdown`,`zipcode`,`phone`,`fax`,`website`,`city`,`cb_companyinfo`,`cb_branchofservice`,`cb_servicestatus`,`cb_statepratice`,`cb_areasofpractice2`,`cb_languages` ) VALUES ( '114','114','1','1','184.14.31.234','1','Law Firm field','address field','US','United States','WV','25504','phone field','fax field','','city field','
Enter a quick statement about your firm here. (This can be edited later from your members profile page)
','Army','Active','Alaska','No Preference','languages spoken' ) 39. SELECT a.id AS aro_id, m.group_id FROM jos_core_acl_aro AS a INNER JOIN jos_core_acl_groups_aro_map AS m ON m.aro_id = a.id WHERE a.value = 114 40. SELECT * FROM jos_comprofiler_tabs t WHERE t.enabled = 1 ORDER BY t.ordering_register, t.position, t.ordering 41. SELECT `username`, `gid`, `block` FROM `jos_users` WHERE `id` = 114 42. SELECT name FROM jos_core_acl_aro_groups WHERE id = 18 43. SELECT id FROM jos_users WHERE username = 'Brandon' AND id != 114 44. SELECT id FROM jos_users WHERE email = 'no@email.com' AND id != 114 45. SELECT * FROM jos_users WHERE id = '114' 46. UPDATE `jos_users` SET `name`='Brandon',`username`='Brandon',`email`='no@email.com',`password`='a609c376f7878892f001f849053cfffc:0W0cMx8ih5DhovO4iPYhI6p70yaJYErA',`usertype`='Registered',`block`='0',`sendEmail`='0',`gid`='18',`registerDate`='2011-01-11 20:17:44',`params`='\n' WHERE id='114' 47. SELECT id FROM jos_core_acl_aro WHERE section_value='users' AND value='114' 48. SELECT gm.group_id FROM jos_core_acl_groups_aro_map gm WHERE gm.aro_id=62 49. SELECT id FROM jos_core_acl_aro WHERE section_value='users' AND value='114' 50. DELETE FROM jos_core_acl_groups_aro_map WHERE group_id=18 AND aro_id=62 51. SELECT o.id AS id,g.id AS group_id,gm.group_id AS member FROM jos_core_acl_aro o LEFT JOIN jos_core_acl_aro_groups g ON g.id=18 LEFT JOIN jos_core_acl_groups_aro_map gm ON (gm.aro_id=o.id AND gm.group_id=g.id) WHERE (o.section_value='users' AND o.value='114') 52. INSERT INTO jos_core_acl_groups_aro_map (group_id,aro_id) VALUES (18,62) 53. SELECT value, section_value FROM jos_core_acl_aro WHERE id=62 54. UPDATE jos_core_acl_aro SET section_value='users', value='114', order_value=0, name='Brandon', hidden=0 WHERE id=62 55. UPDATE `jos_comprofiler` SET `user_id`=114,`approved`=1,`confirmed`=1,`registeripaddr`='184.14.31.234',`acceptedterms`=1,`company`='Law Firm field',`address`='address field',`cb_countrydropdown`='US',`cb_countrydropdown_desc`='United States',`cb_statedropdown`='WV',`zipcode`='25504',`phone`='phone field',`fax`='fax field',`website`='',`city`='city field',`cb_companyinfo`='Enter a quick statement about your firm here. (This can be edited later from your members profile page)
',`cb_branchofservice`='Army',`cb_servicestatus`='Active',`cb_statepratice`='Alaska',`cb_areasofpractice2`='No Preference',`cb_languages`='languages spoken' WHERE id='114' 56. SELECT a.id AS aro_id, m.group_id FROM jos_core_acl_aro AS a INNER JOIN jos_core_acl_groups_aro_map AS m ON m.aro_id = a.id WHERE a.value = 114 57. SELECT b.* FROM jos_cbsubs_payment_baskets b WHERE b.user_id = 114 AND b.payment_status = 'NotInitiated' ORDER BY b.time_initiated DESC LIMIT 0, 1 58. SELECT * FROM `jos_cbsubs_subscriptions` WHERE `user_id` = 114 AND `plan_id` = 2 LIMIT 0, 1 59. SELECT a.* FROM `jos_cbsubs_plans` AS a WHERE a.`id` = 2 60. INSERT INTO `jos_cbsubs_subscriptions` ( `subscription_date`,`last_renewed_date`,`autorenew_type`,`autorecurring_type`,`regular_recurrings_total`,`regular_recurrings_used`,`previous_recurrings_used`,`ip_addresses`,`status`,`user_id`,`plan_id`,`parent_plan`,`parent_subscription`,`integrations` ) VALUES ( '2011-01-11 14:17:43','2011-01-11 14:17:43','0','0','0','0','0','184.14.31.234','R','114','2','0','0','' ) 61. INSERT INTO `jos_cbsubs_history` ( `event_type`,`message`,`table_name`,`table_key_id`,`field_changed`,`change_type`,`new_value`,`event_time`,`user_id`,`ip_addresses`,`log_priority`,`log_version` ) VALUES ( '2','User subscription record created with status: R','#__cbsubs_subscriptions','50','','insert','