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','\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n','2011-01-11 14:17:43','0','184.14.31.234','6','1' )
62.
SELECT *
FROM jos_users AS u
LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 114
63.
SELECT *
FROM `jos_cbsubs_subscriptions`
WHERE `id` = '50'
64.
SELECT `name`, `fieldid`
FROM jos_comprofiler_fields
WHERE published = 1
AND fieldid IN (41,34,40,35,66,37,65,43);
65.
SELECT r.*, ru.short_code AS _rule_short_code
FROM `jos_cbsubs_tax_rates` AS r
JOIN `jos_cbsubs_tax_rules` AS ru
ON ru.id = r.`tax_rule_id`
LEFT JOIN `jos_cbsubs_geo_zones` AS b
ON b.id = r.`buyer_geo_zone_id`
LEFT JOIN `jos_cbsubs_geo_zones` AS s
ON s.id = r.`seller_geo_zone_id`
WHERE r.`tax_rule_id` = 1000
AND ( ( r.`buyer_geo_zone_id` = 0 )
OR ( SELECT COUNT(*)
FROM `jos_cbsubs_geo_zones_entries` AS be
WHERE be.geo_zone_id = b.id
AND be.`country_iso_code2` = ''
AND ( be.`province_iso_code` = ''
OR be.`province_iso_code` = 'WV' )
AND ( be.`zip_code_condition` = 0
OR ( be.`zip_code_condition` = 1
AND '25504' REGEXP be.`zip_code_regexp` )
OR ( be.`zip_code_condition` = 2
AND be.`zip_code_min` <= 25504
AND be.`zip_code_max` >= 25504 ) )
) > 0 )
AND ( ( r.`seller_geo_zone_id` = 0 )
OR ( SELECT COUNT(*)
FROM `jos_cbsubs_geo_zones_entries` AS se
WHERE se.geo_zone_id = s.id
AND se.`country_iso_code2` = 'US'
AND ( se.`province_iso_code` = ''
OR se.`province_iso_code` = 'US-WV' )
AND ( se.`zip_code_condition` = 0
OR ( se.`zip_code_condition` = 1
AND '25504' REGEXP se.`zip_code_regexp` )
OR ( se.`zip_code_condition` = 2
AND se.`zip_code_min` <= 25504
AND se.`zip_code_max` >= 25504 ) )
) > 0 )
AND ( r.`tax_outside_of_country` >= 1 )
AND r.`published` = 1
AND r.`owner` = 0
GROUP BY r.`id`
ORDER BY r.`tax_priority`, r.`ordering`
66.
INSERT INTO `jos_cbsubs_payment_baskets` ( `user_id`,`owner`,`time_initiated`,`shared_secret`,`ip_addresses`,`address_name`,`address_street`,`address_city`,`address_state`,`address_zip`,`address_country`,`first_name`,`last_name`,`payer_business_name`,`payer_email`,`contact_phone`,`item_name`,`item_number`,`quantity`,`invoice`,`mc_currency`,`mc_gross`,`subscr_date`,`period3`,`mc_amount3`,`recur_times` )
VALUES ( '114','0','2011-01-11 14:17:43','cbp4d2cbae829039362899928','184.14.31.234','Brandon','address field','city field','WV','25504','US','','Brandon','Law Firm field','no@email.com','phone field','One Year for Brandon','S50-114-2','1','N855802180923566','USD','40','14:17:43 Jan 11, 2011 CST','1 Y','40','0' )
67.
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','Store payment basket','#__cbsubs_payment_baskets','47','','insert','\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n','2011-01-11 14:17:43','0','184.14.31.234','6','1' )
68.
INSERT INTO `jos_cbsubs_payment_items` ( `payment_basket_id`,`quantity`,`artnum`,`description`,`prorate_discount`,`subscription_id`,`plan_id`,`reason`,`start_date`,`stop_date`,`second_stop_date`,`tax_rule_id`,`owner`,`ordering`,`item_type`,`currency`,`rate`,`validity`,`bonustime`,`autorecurring`,`recurring_max_times`,`alias` )
VALUES ( '47','1','S50-114-2','Subscription Plan: One Year for Brandon','0','50','2','N','2011-01-11 09:17:43','2012-01-11 14:17:43','2013-01-11 14:17:43','1000','0','1','usersubscription','USD','40.00000','0001-00-00 00:00:00','0000-00-00 00:00:00','1','0','' )
69.
INSERT INTO `jos_cbsubs_payment_totalizers` ( `payment_basket_id`,`payment_item_id`,`ordering`,`totalizer_type`,`totalizer_id`,`artnum`,`description`,`currency`,`rate` )
VALUES ( '47','0','2','grandtotal','0','','Total per payment','USD','40' )
70.
SELECT s.*
FROM jos_cbsubs_subscriptions s
WHERE s.user_id = 114
AND s.STATUS = 'R'
ORDER BY s.plan_id
71.
SELECT a.*
FROM `jos_cbsubs_gateway_accounts` AS a
WHERE a.enabled > 0
AND a.owner = 0
ORDER BY a.`ordering` ASC
72.
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/cbsubstax/validations'
ORDER BY ordering
73.
SELECT r.*, ru.short_code AS _rule_short_code
FROM `jos_cbsubs_tax_rates` AS r
JOIN `jos_cbsubs_tax_rules` AS ru
ON ru.id = r.`tax_rule_id`
LEFT JOIN `jos_cbsubs_geo_zones` AS b
ON b.id = r.`buyer_geo_zone_id`
LEFT JOIN `jos_cbsubs_geo_zones` AS s
ON s.id = r.`seller_geo_zone_id`
WHERE r.`tax_rule_id` = 1000
AND ( ( r.`buyer_geo_zone_id` = 0 )
OR ( SELECT COUNT(*)
FROM `jos_cbsubs_geo_zones_entries` AS be
WHERE be.geo_zone_id = b.id
AND be.`country_iso_code2` = ''
AND ( be.`province_iso_code` = ''
OR be.`province_iso_code` = 'WV' )
AND ( be.`zip_code_condition` = 0
OR ( be.`zip_code_condition` = 1
AND '25504' REGEXP be.`zip_code_regexp` )
OR ( be.`zip_code_condition` = 2
AND be.`zip_code_min` <= 25504
AND be.`zip_code_max` >= 25504 ) )
) > 0 )
AND ( ( r.`seller_geo_zone_id` = 0 )
OR ( SELECT COUNT(*)
FROM `jos_cbsubs_geo_zones_entries` AS se
WHERE se.geo_zone_id = s.id
AND se.`country_iso_code2` = 'US'
AND ( se.`province_iso_code` = ''
OR se.`province_iso_code` = 'US-WV' )
AND ( se.`zip_code_condition` = 0
OR ( se.`zip_code_condition` = 1
AND '25504' REGEXP se.`zip_code_regexp` )
OR ( se.`zip_code_condition` = 2
AND se.`zip_code_min` <= 25504
AND se.`zip_code_max` >= 25504 ) )
) > 0 )
AND ( r.`tax_outside_of_country` >= 1 )
AND r.`published` = 1
AND r.`owner` = 0
GROUP BY r.`id`
ORDER BY r.`tax_priority`, r.`ordering`
74.
SELECT a.`country_iso_code2` AS `value`, a.`country_name` AS `text`
FROM `jos_comprofiler_countries` AS a
ORDER BY a.`country_name` ASC
75.
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published=1
AND access = 0
76.
UPDATE jos_users
SET block = 0
WHERE id = 114
77.
UPDATE `jos_comprofiler`
SET `cbactivation` = ''
WHERE `id` = 114
78.
UPDATE `jos_users`
SET `activation` = ''
WHERE `id` = 114
79.
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 28 OR mm.menuid = 0 )
ORDER BY position, ordering
80.
SELECT u.id AS `id`, u.name AS `name`, DATE_FORMAT(u.registerDate, "%Y-%m-%d") AS `registerdate`
FROM `jos_users` u, `jos_comprofiler` b
WHERE u.id = b.id
AND b.approved
AND u.block=0
ORDER BY u.lastvisitDate DESC
LIMIT 5
81.
SELECT id
FROM jos_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published=1
AND access = 0
82.
SELECT *
FROM jos_kunena_config
83.
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
84.
SELECT username
FROM jos_users
WHERE id = 64
LIMIT 0, 1
85.
SELECT username
FROM jos_users
WHERE id = 63
LIMIT 0, 1
86.
SELECT username
FROM jos_users
WHERE id = 114
LIMIT 0, 1