Half Moon Bay Wood Stoves

Array
(
    [id] => 46
    [type] => package
    [url] => /
    [items] => a:2:{i:0;a:3:{s:4:"item";s:8:"listings";s:7:"package";s:9:"directory";s:10:"url_fields";s:11:"title_alias";}i:1;a:3:{s:4:"item";s:6:"categs";s:7:"package";s:9:"directory";s:10:"url_fields";s:11:"title_alias";}}
    [title] => Half Moon Bay Wood Stoves
    [name] => view_listing
    [unixperms] => 484
    [unique_url] => listing/
    [extras] => directory
    [filename] => view
    [description] => test
    [keywords] => test
    [body] => listing_view
    [header] => header
    [footer] => footer
    [pages] => Array
        (
            [index] => 
            [search] => search/
            [advsearch] => advsearch/
            [captcha] => captcha
            [cron] => cron/
            [actions] => actions/
            [validate] => validate/
            [pay] => pay/
            [favorites] => favorites/
            [accounts] => accounts/
            [login] => login/
            [account_password_forgot] => forgot/
            [edit_account] => accounts/edit/
            [view_account] => accounts/info/
            [account_balance] => account/balance/
            [register_account] => register/
            [account_messages] => messages/
            [register_confirm] => confirm/
            [page] => page/
            [about] => about/
            [policy] => policy/
            [terms] => terms/
            [help] => help/
            [advertise] => advertise/
            [listing_edit] => manage/listings/edit/
            [listing_add] => manage/listings/add/
            [my_listings] => my_listings/
            [random_listings] => random_listings/
            [top_listings] => top_listings/
            [new_listings] => new_listings/
            [rss_listings] => rss/
            [view_listing] => listing/
            [reviews] => reviews/
            [directory_home] => directory/
        )

    [css_files] => ,jquery.tabs
    [js_files] => ,jquery/plugins/jquery.tabs
)

Array
(
    [0] => inventory
    [1] => main
    [2] => account
    [3] => bottom
    [4] => addthis
    [5] => googleaddleft
    [6] => googleaddright
    [7] => directory
    [8] => dir_cats
    [9] => footer
    [10] => woodburningstoves
    [11] => googleaddcenter
)

Array
(
    [phpCoreFactoryBeforeLoadClassDb] => 
    [phpCoreFactoryBeforeCreateClassDb] => 
    [phpCoreFactoryBeforeLoadClassLang] => 
    [phpCoreFactoryBeforeCreateClassLang] => 
    [phpCoreFactoryBeforeLoadClassCacher] => 
    [phpCoreFactoryBeforeCreateClassCacher] => 
    [phpCoreFactoryBeforeLoadClassUsers] => 
    [phpCoreFactoryBeforeCreateClassUsers] => 
    [init] => 
    [phpCoreGetUrlBeforeParseUrl] => Array
        (
            [0] => url
        )

    [phpCoreGetUrlBeforeConstantDefine] => 
    [phpCoreBeforeGetLang] => 
    [phpCoreBeforeSessionCheck] => 
    [phpCoreBeforePageSecure] => 
    [phpCoreBeforeAuth] => 
    [phpCoreBeforeMsgFromSession] => 
    [phpCoreBeforePageDefine] => 
    [phpCoreDefineAfterGetPages] => 
    [phpCoreDefineBeforeSetConstant] => Array
        (
            [0] => gPageCfg
        )

    [phpCoreBeforeTypeInit] => 
    [phpCoreFactoryBeforeLoadClassAcl] => 
    [phpCoreFactoryBeforeCreateClassAcl] => 
    [phpCoreFactoryBeforeLoadClassSmarty] => 
    [phpCoreFactoryBeforeCreateClassSmarty] => 
    [bootstrap] => 
    [phpCoreCodeBeforeStart] => 
    [phpViewListingBeforeStart] => Array
        (
            [0] => listing
            [1] => item
            [2] => title
            [3] => desc
        )

    [phpCoreCodeAfterAll] => 
    [phpCoreBeforePageDisplay] => 
    [phpCoreFactoryBeforeLoadClassMailbox] => 
    [phpCoreFactoryBeforeCreateClassMailbox] => 
    [phpCoreDisplayBeforeShowHeader] => 
    [smartyFrontBeforeHeadSection] => 
    [smartyFrontAfterHeadSection] => 
    [smartyFrontBeforeBreadcrumb] => 
    [smartyFrontBeforeNotifications] => 
    [smartyFrontBeforeMainContent] => 
    [phpCoreDisplayBeforeShowBody] => 
    [smartyViewListingBeforeFooter] => 
    [phpCoreDisplayBeforeShowFooter] => 
    [beforeCloseTag] => 
    [smartyFrontAfterMainContent] => 
    [phpCoreBeforeJsCache] => 
    [finalize] => 
)

Array
(
    [directory] => Array
        (
            [name] => directory
            [url] => http://www.wood-burning-stove-dealers.com/dir//
            [title] => Web Directory
            [ajax_url] => http://www.wood-burning-stove-dealers.com/dir/ajax//
            [tpl_url] => http://www.wood-burning-stove-dealers.com/dir/packages/directory/templates/
            [tpl] => /home/wood/public_html/dir/packages/directory/templates/
            [tpl_admin] => /home/wood/public_html/dir/packages/directory/templates/admin/
            [tpl_design] => /home/wood/public_html/dir/packages/directory/templates/wood/
            [tpl_common] => /home/wood/public_html/dir/packages/directory/templates/common/
        )

)

Array
(
    [0] => California
    [1] => Half-Moon-Bay-Wood-Stoves
)

Array
(
    [debug_pass] => none
    [tmpl] => wood
    [baseurl] => http://www.wood-burning-stove-dealers.com/dir/
    [langs] => a:1:{s:2:"en";s:7:"English";}
    [tpl_list] => default
    [backup] => backup/
    [version] => 2.0.3
    [cron] => 1
    [admin_tmpl] => default
    [default_package] => directory
    [block_positions] => left,right,listing,top,bottom,user1,user2,verybottom,verytop,copyright,mainmenu,account
    [site] => Wood Burning Stove Dealers
    [suffix] => 
    [site_logo] => 
    [language_switch] => 0
    [lang] => en
    [charset] => UTF-8
    [date_format] => %b %e, %Y
    [bugs_email] => admin@localhost.com
    [admin_page] => admin
    [page_home] => index
    [caching] => 0
    [smarty_cache] => 0
    [compress_js] => 0
    [frontend] => 1
    [underconstruction] => 

	We are sorry. Our site is under construction.

    [thumb_w] => 80
    [thumb_h] => 80
    [imagic_path] => /usr/bin/
    [watermark] => 1
    [site_watermark] => 
    [accounts] => 1
    [accounts_autoapproval] => 1
    [currency] => USD
    [ckeditor_color] => #AAB
    [captcha] => 1
    [captcha_name] => kcaptcha
    [captcha_preview] => 
    [captcha_case_sensitive] => 1
    [captcha_num_chars] => 5
    [site_from_name] => Subrion CMS
    [site_email] => admin@localhost.com
    [mail_function] => php mail
    [smtp_server] => tls://smtp.example.org
    [smtp_user] => 
    [smtp_password] => 
    [sendmail_path] => /usr/bin/sendmail
    [mimetype] => html
    [intelliants_latest_news] => 0
    [admin_online_expiry_time] => 180
    [display_new_plugins] => 0
    [display_feedbacks] => 1
    [display_twitter] => 1
    [twitter_count] => 5
    [register_account] => 1
    [register_account_subject] => Thanks for registration at {%SITE_NAME%}
    [register_account_body] => 
Dear {%FULLNAME%},
Thanks for your registration at {%SITE_URL%}. Here is information you should use in order to login:
Your username: {%USERNAME%}

Your password: {%PASSWORD%}
Your activation key: {%KEY%}
To activate your account go to {%SITE_URL%}confirm/?user={%USERNAME%}&key={%KEY%}

You may change your password later by editing your personal attributes in your account area.
______________________________

Thank you,

{%SITE_NAME%} Administration Team

{%SITE_URL%}


    [register_account_admin_subject] => Account has been created {%SITE_NAME%}
    [register_account_admin_body] => 
Greetings {%FULLNAME%},
Administrator has just created an account for you at {%SITE_URL%}. Here is information you should use in order to login:
Your username: {%USERNAME%}

Your password: {%PASSWORD%}
______________________________

Thank you,

{%SITE_NAME%} Administration Team

{%SITE_URL%}


    [account_deleted] => 1
    [account_deleted_subject] => Account deleted at {%SITE_NAME%}
    [account_deleted_body] => 
Dear {%FULLNAME%},
Your account was removed from  {%SITE_URL%}.
______________________________
Thank you,

{%SITE_NAME%} Administration Team

{%SITE_URL%}
    [forgot_password_subject] => Password restoration request at {%SITE_NAME%}
    [forgot_password_body] => 
Dear {%FULLNAME%},
Please follow this link if you wish change the password at {%SITE_URL%}:

{%URL%}


Or use confirmation code on page: {%SITE_URL%}forgot/?code= 

Code: {%CODE%}

______________________________

Thank you,

{%SITE_NAME%} Administration Team

{%SITE_URL%}
    [password_change_subject] => Password change request at {%SITE_NAME%}
    [password_change_body] => 
Dear {%FULLNAME%},

You requested a password change in {%SITE_NAME%}. Now you should use the following credentials to log in as account:

username: {%USERNAME%}

password:  {%PASSWORD%}

______________________________

Thank you,

{%SITE_NAME%} Administration Team

{%SITE_URL%}
    [account_approved] => 1
    [account_approved_subject] => Account was approved at {%SITE_NAME%}
    [account_approved_body] => 
Dear {%FULLNAME%},
Your account was approved in {%SITE_NAME%}. Now you can log in.
______________________________
Thank you,

{%SITE_NAME%} Administration Team

{%SITE_URL%}
    [account_disapproved] => 1
    [account_disapproved_subject] => Account was disapproved at {%SITE_NAME%}
    [account_disapproved_body] => 
Dear {%FULLNAME%},
Your account was disapproved in {%SITE_NAME%}.
______________________________
Thank you,

{%SITE_NAME%} Administration Team

{%SITE_URL%}
    [listing_perpage] => 10
    [listing_length] => 50,50000
    [listing_gmap] => ABQIAAAA2zZE5F9J7nCzZtkTjwM-xBRo089xkC9c9RkJc1T4gdWrL3hFahSkRoxsXVtI4zOKjjoINkqE7STwUQ
    [listing_crossed_limit] => 15
    [display_num] => listings
    [listing_crossed] => 1
    [listing_sponsored_only] => 0
    [listing_order_type] => 0
    [listing_allow_flash] => 0
    [listing_auto_approval] => 0
    [directory_hide_empty_categories] => 0
    [listing_display_alexa] => 0
    [listing_display_thumbshots] => 0
    [reviews_comments_approval] => 0
    [num_latest_reviews] => 5
    [reviews_max_star] => 5
    [reviews_stars] => a:0:{}
    [listing_reviews_accounts] => 1
    [reviews_item] => a:0:{}
    [allow_listing_reviews_submission] => 1
    [reviews_approval] => 0
    [listing_notif_subject] => New Listing Submitted
    [listing_notif_body] => 
We have new listing "{%TITLE%}".
You can read it on {%URL%}.
    [listing_summary] => 700
    [extrasList] => kcaptcha,directory,reviews
    [ia_url] => http://www.wood-burning-stove-dealers.com/dir/
    [admin_url] => http://www.wood-burning-stove-dealers.com/dir/admin
    [listings_per_page] => 5
)

Array
(
    [0] => SET NAMES 'utf8'
    [1] => SELECT `name`,`code`,`type`,`extras`, `filename` FROM `sbr203_hooks`  WHERE `extras` IN('', 'kcaptcha','directory','reviews') AND `status`='active' AND `pages`='' ORDER BY `order`
    [2] => SELECT `id` FROM `sbr203_categs`  WHERE `title_alias` = 'listing' AND `level` = 1 LIMIT 1
    [3] => SELECT `key`, `value` 
			FROM `sbr203_language` 
			WHERE `code` = 'en' AND `category` != 'tooltip'  AND (`category` != 'admin')
    [4] => SELECT p.`id`, e.`type`, e.`url`, e.`items`, e.`title`, p.`name`, p.`unixperms`, p.`unique_url`, p.`extras`, p.`filename` , p.`meta_description` as `description`, p.`meta_keywords` as `keywords` FROM `sbr203_pages` p LEFT JOIN  `sbr203_extras` e ON(e.`name` = p.`extras`) WHERE (p.`name` = 'listing' OR p.`unique_url` = 'listing' OR p.`unique_url` LIKE 'listing/%') AND p.`status` = 'active' AND (e.`status` = 'active' OR e.`status` is NULL) ORDER BY p.`unique_url`
    [5] => SELECT `name`,`url`,`title` FROM `sbr203_extras`  WHERE `type` = 'package' AND `status` = 'active'
    [6] => SELECT `block_id`, `id` FROM `sbr203_blocks_pages`  WHERE `page_name`='view_listing'
    [7] => SELECT * FROM `sbr203_blocks`  WHERE `status`='active' AND `extras` IN ('', 'kcaptcha','directory','reviews') ORDER BY `order`
    [8] => SELECT * FROM `sbr203_actions`  WHERE `status` = 'blocks'
    [9] => SELECT `id`, `unique_url`, `custom_url`, `name` FROM `sbr203_pages`  WHERE `status` = 'active' AND `extras` IN ('', 'kcaptcha','directory','reviews')
    [10] => SELECT * FROM `sbr203_reviews` ORDER BY `last_updated` DESC LIMIT 5
    [11] => SELECT distinct ia.`action`
		FROM `sbr203_implemented_action` as ia
	
			-- join onto the object itself
			INNER JOIN `sbr203_pages` as obj on obj.`id` = 46
	
			-- Privileges that apply to the object (or every object in the table)
			-- and grant the given action
		LEFT OUTER JOIN `sbr203_privileges` as pr
			ON pr.`related_table` = 'pages'
				AND pr.`action` = ia.`action`
				AND ((pr.`type` = 'object' AND pr.`related_uid` = 46)
					OR pr.`type` = 'global'
					OR (pr.`role` = 'self' AND 0 = 46 AND 'pages' = 'accounts'))
					
		-- The action must apply to objects
		WHERE ia.`apply_object`
			AND ia.`table` = 'pages'
			AND ((ia.`status` = 0) OR (ia.`status` & obj.`status` <> 0))
			AND (

		   		-- Members of the 'root' group are always allowed to do everything
				(4 & 1 <> 0)
		      
				-- UNIX style read permissions in the bit field
				OR (ia.`action` = 'read' AND (
		      
					-- The other_read permission bit is on
					(obj.`unixperms` & 4 <> 0)
			         
					-- The owner_read permission bit is on, and the member is the owner
					OR ((obj.`unixperms` & 256 <> 0)
			            AND obj.`owner` = 0)
					-- The group_read permission bit is on, and the member is in the group
					OR ((obj.`unixperms` & 32 <> 0)
						AND (4 & obj.`group` <> 0))))
      
				-- UNIX style write permissions in the bit field
				OR (ia.`action` = 'write' AND (
				
					-- The other_write permission bit is on
					(obj.`unixperms` & 2 <> 0)
					
					-- The owner_write permission bit is on, AND the member is the owner
					OR ((obj.`unixperms` & 128 <> 0)
						AND obj.`owner` = 0)
					
					-- The group_write permission bit is on, and the member is in the group
					OR ((obj.`unixperms` & 16 <> 0)
						AND (4 & obj.`group` <> 0))))
					
				-- UNIX style delete permissions in the bit field
				OR (ia.`action` = 'delete' AND (
					
					-- The other_delete permission bit is on
					(obj.`unixperms` & 1 <> 0)
					
					-- The owner_delete permission bit is on, and the member is the owner
					OR ((obj.`unixperms` & 64 <> 0)
						AND obj.`owner` = 0)
					
					-- The group_delete permission bit is on, and the member is in the group
					OR ((obj.`unixperms` & 8 <> 0)
						AND (4 & obj.`group` <> 0))))
				
				-- user privileges
				OR (pr.`role` = 'user' AND pr.`who` = 0)
				
				-- owner privileges
				OR (pr.`role` = 'owner' AND obj.`owner` = 0)
				
				-- owner_group privileges
				OR (pr.`role` = 'owner_group' AND (obj.`group` & 4 <> 0))
				
				-- group privileges
				OR (pr.`role` = 'group' AND (pr.`who` & 4 <> 0)))

				-- self privileges
				OR pr.`role` = 'self';
    [12] => SELECT SQL_CALC_FOUND_ROWS t1.*, cat.`title` `category_title`, cat.`title_alias` `category_alias`, t3.`fullname` 'account', t3.`username` as `account_username` FROM `sbr203_listings` t1 LEFT JOIN `sbr203_categs` cat ON t1.`category_id` = cat.`id` LEFT JOIN `sbr203_accounts` t3 ON t1.`account_id` = t3.`id` WHERE t1.`title_alias` = 'Half-Moon-Bay-Wood-Stoves'  LIMIT 0,1 
    [13] => SELECT `id`, `parent_id`, `title`, `title_alias`, `visible`, `parents`, `description`,`available_fields` FROM `sbr203_categs`  WHERE `id`='7' LIMIT 1
    [14] => SELECT `title`, `title_alias`, `title_alias` 'category_alias', `num_all_listings` as 'num', `child` FROM `sbr203_categs`  WHERE `id` IN(7,1) AND `parent_id` > -1 AND  `status` = 'active' AND  `visible` = 1 ORDER BY `level`, `title`
    [15] => SELECT distinct obj.`id`
		FROM `sbr203_fields` as obj
		   
			-- Filter out actions that do not apply to this object type
			INNER JOIN `sbr203_implemented_action` as ia
			ON ia.`table` = 'fields' AND ia.`action` = 'write' AND ((ia.`status` = 0) 
				OR (ia.`status` & obj.`status` <> 0))

			-- Privileges that apply to the object (OR every object in the table)
			-- and grant the given action
			LEFT OUTER JOIN `sbr203_privileges` as pr
				ON pr.`related_table` = 'fields'
					AND pr.`action` = 'write'
					AND ((pr.`type` = 'object' AND pr.`related_uid` = obj.`id`)
						OR pr.`type` = 'global'
						OR (pr.`role` = 'self' AND 0 = obj.`id` AND 'fields' = 'accounts'))
		
			-- The action must apply to objects
			WHERE ia.`apply_object`
			AND (
				-- Members of the 'root' group are always allowed to do everything
				(4 & 1 <> 0)

				-- UNIX style read permissions in the bit field
				OR (ia.`action` = 'read' AND (

					-- The other_read permission bit is on
					(obj.`unixperms` & 4 <> 0)

					-- The owner_read permission bit is on, and the member is the owner
					OR ((obj.`unixperms` & 256 <> 0)
						AND obj.`owner` = 0)

					-- The group_read permission bit is on, and the member is in the group
					OR ((obj.`unixperms` & 32 <> 0)
						AND (4 & obj.`group` <> 0))))

				-- UNIX style write permissions in the bit field
				OR (ia.`action` = 'write' AND (

					-- The other_write permission bit is on
					(obj.`unixperms` & 2 <> 0)

					-- The owner_write permission bit is on, and the member is the owner
					OR ((obj.`unixperms` & 128 <> 0)
						AND obj.`owner` = 0)

					-- The group_write permission bit is on, and the member is in the group
					OR ((obj.`unixperms` & 16 <> 0)
						AND (4 & obj.`group` <> 0))))

				-- UNIX style delete permissions in the bit field
				OR (ia.`action` = 'delete' AND (

				-- The other_delete permission bit is on
				(obj.`unixperms` & 1 <> 0)
				 
				-- The owner_delete permission bit is on, and the member is the owner
				OR ((obj.`unixperms` & 64 <> 0)
					AND obj.`owner` = 0)

				-- The group_delete permission bit is on, and the member is in the group
				OR ((obj.`unixperms` & 8 <> 0)
					AND (4 & obj.`group` <> 0))))
				
				-- user privileges
				OR (pr.`role` = 'user' AND pr.`who` = 0)
				
				-- owner privileges
				OR (pr.`role` = 'owner' AND obj.`owner` = 0)
			  
				-- owner_group privileges
				OR (pr.`role` = 'owner_group' AND (obj.`group` & 4 <> 0))
			  
				-- group privileges
				OR (pr.`role` = 'group' AND (pr.`who` & 4 <> 0)))
			  
				-- self privileges
				OR pr.`role` = 'self';
		
    [16] => SELECT `f`.* 
						FROM `sbr203_fields_pages` `fp`
						LEFT JOIN `sbr203_fields` `f` ON `fp`.`field_id`=`f`.`id` 
					WHERE `fp`.`page_name`='view_listing' AND `f`.`status`='active' AND `f`.`item`='listings' AND `f`.`adminonly`<>'1' AND f.`id` IN(1,2,3,4,5,6,7,8,9,10,11,12,58,59,57,56,54,55,53,52,50,51,49,47,48,46,45,60,61,62,64)  GROUP BY `f`.`id`
					ORDER BY `f`.`order`
    [17] => SELECT distinct obj.`id`
		FROM `sbr203_fields` as obj
		   
			-- Filter out actions that do not apply to this object type
			INNER JOIN `sbr203_implemented_action` as ia
			ON ia.`table` = 'fields' AND ia.`action` = 'write' AND ((ia.`status` = 0) 
				OR (ia.`status` & obj.`status` <> 0))

			-- Privileges that apply to the object (OR every object in the table)
			-- and grant the given action
			LEFT OUTER JOIN `sbr203_privileges` as pr
				ON pr.`related_table` = 'fields'
					AND pr.`action` = 'write'
					AND ((pr.`type` = 'object' AND pr.`related_uid` = obj.`id`)
						OR pr.`type` = 'global'
						OR (pr.`role` = 'self' AND 0 = obj.`id` AND 'fields' = 'accounts'))
		
			-- The action must apply to objects
			WHERE ia.`apply_object`
			AND (
				-- Members of the 'root' group are always allowed to do everything
				(4 & 1 <> 0)

				-- UNIX style read permissions in the bit field
				OR (ia.`action` = 'read' AND (

					-- The other_read permission bit is on
					(obj.`unixperms` & 4 <> 0)

					-- The owner_read permission bit is on, and the member is the owner
					OR ((obj.`unixperms` & 256 <> 0)
						AND obj.`owner` = 0)

					-- The group_read permission bit is on, and the member is in the group
					OR ((obj.`unixperms` & 32 <> 0)
						AND (4 & obj.`group` <> 0))))

				-- UNIX style write permissions in the bit field
				OR (ia.`action` = 'write' AND (

					-- The other_write permission bit is on
					(obj.`unixperms` & 2 <> 0)

					-- The owner_write permission bit is on, and the member is the owner
					OR ((obj.`unixperms` & 128 <> 0)
						AND obj.`owner` = 0)

					-- The group_write permission bit is on, and the member is in the group
					OR ((obj.`unixperms` & 16 <> 0)
						AND (4 & obj.`group` <> 0))))

				-- UNIX style delete permissions in the bit field
				OR (ia.`action` = 'delete' AND (

				-- The other_delete permission bit is on
				(obj.`unixperms` & 1 <> 0)
				 
				-- The owner_delete permission bit is on, and the member is the owner
				OR ((obj.`unixperms` & 64 <> 0)
					AND obj.`owner` = 0)

				-- The group_delete permission bit is on, and the member is in the group
				OR ((obj.`unixperms` & 8 <> 0)
					AND (4 & obj.`group` <> 0))))
				
				-- user privileges
				OR (pr.`role` = 'user' AND pr.`who` = 0)
				
				-- owner privileges
				OR (pr.`role` = 'owner' AND obj.`owner` = 0)
			  
				-- owner_group privileges
				OR (pr.`role` = 'owner_group' AND (obj.`group` & 4 <> 0))
			  
				-- group privileges
				OR (pr.`role` = 'group' AND (pr.`who` & 4 <> 0)))
			  
				-- self privileges
				OR pr.`role` = 'self';
		
    [18] => SELECT `f`.* 
						FROM `sbr203_fields_pages` `fp`
						LEFT JOIN `sbr203_fields` `f` ON `fp`.`field_id`=`f`.`id` 
					WHERE `fp`.`page_name`='view_listing' AND `f`.`status`='active' AND `f`.`item`='listings' AND `f`.`adminonly`<>'1' AND f.`id` IN(1,2,3,4,5,6,7,8,9,10,11,12,58,59,57,56,54,55,53,52,50,51,49,47,48,46,45,60,61,62,64)  AND  `type` != 'image' GROUP BY `f`.`id`
					ORDER BY `f`.`order`
    [19] => SELECT `id`,`name`,`order`,`collapsed` FROM `sbr203_fields_groups`  WHERE `item`='listings' ORDER BY `order`
    [20] => SELECT 1 FROM `sbr203_listings_clicks` WHERE `listing_id`='6' AND `ip`='38.107.179.232' AND `date`= '2012-05-20' LIMIT 1 
    [21] => INSERT INTO `sbr203_listings_clicks` (`listing_id`, `ip`, `date`) VALUES('6', '38.107.179.232', '2012-05-20')
    [22] => UPDATE `sbr203_listings` SET `clicks`=`clicks`+1 WHERE `id`='6' LIMIT 1
    [23] => SELECT * FROM `sbr203_accounts`  WHERE `status`='active' AND `id` = '1'  LIMIT 1
    [24] => SELECT `title`, `title_alias`, `title_alias` 'category_alias', `num_all_listings` as 'num', `child` FROM `sbr203_categs`  WHERE `level` = 1 AND  `status` = 'active' AND  `visible` = 1 ORDER BY `level`, `title`
    [25] => SELECT COUNT(*) FROM `sbr203_messages` WHERE `account_id`='' AND `folder_id`='1' AND `read`='0'
    [26] => SELECT distinct obj.`id`
		FROM `sbr203_pages` as obj
		   
			-- Filter out actions that do not apply to this object type
			INNER JOIN `sbr203_implemented_action` as ia
			ON ia.`table` = 'pages' AND ia.`action` = 'read' AND ((ia.`status` = 0) 
				OR (ia.`status` & obj.`status` <> 0))

			-- Privileges that apply to the object (OR every object in the table)
			-- and grant the given action
			LEFT OUTER JOIN `sbr203_privileges` as pr
				ON pr.`related_table` = 'pages'
					AND pr.`action` = 'read'
					AND ((pr.`type` = 'object' AND pr.`related_uid` = obj.`id`)
						OR pr.`type` = 'global'
						OR (pr.`role` = 'self' AND 0 = obj.`id` AND 'pages' = 'accounts'))
		
			-- The action must apply to objects
			WHERE ia.`apply_object`
			AND (
				-- Members of the 'root' group are always allowed to do everything
				(4 & 1 <> 0)

				-- UNIX style read permissions in the bit field
				OR (ia.`action` = 'read' AND (

					-- The other_read permission bit is on
					(obj.`unixperms` & 4 <> 0)

					-- The owner_read permission bit is on, and the member is the owner
					OR ((obj.`unixperms` & 256 <> 0)
						AND obj.`owner` = 0)

					-- The group_read permission bit is on, and the member is in the group
					OR ((obj.`unixperms` & 32 <> 0)
						AND (4 & obj.`group` <> 0))))

				-- UNIX style write permissions in the bit field
				OR (ia.`action` = 'write' AND (

					-- The other_write permission bit is on
					(obj.`unixperms` & 2 <> 0)

					-- The owner_write permission bit is on, and the member is the owner
					OR ((obj.`unixperms` & 128 <> 0)
						AND obj.`owner` = 0)

					-- The group_write permission bit is on, and the member is in the group
					OR ((obj.`unixperms` & 16 <> 0)
						AND (4 & obj.`group` <> 0))))

				-- UNIX style delete permissions in the bit field
				OR (ia.`action` = 'delete' AND (

				-- The other_delete permission bit is on
				(obj.`unixperms` & 1 <> 0)
				 
				-- The owner_delete permission bit is on, and the member is the owner
				OR ((obj.`unixperms` & 64 <> 0)
					AND obj.`owner` = 0)

				-- The group_delete permission bit is on, and the member is in the group
				OR ((obj.`unixperms` & 8 <> 0)
					AND (4 & obj.`group` <> 0))))
				
				-- user privileges
				OR (pr.`role` = 'user' AND pr.`who` = 0)
				
				-- owner privileges
				OR (pr.`role` = 'owner' AND obj.`owner` = 0)
			  
				-- owner_group privileges
				OR (pr.`role` = 'owner_group' AND (obj.`group` & 4 <> 0))
			  
				-- group privileges
				OR (pr.`role` = 'group' AND (pr.`who` & 4 <> 0)))
			  
				-- self privileges
				OR pr.`role` = 'self';
		
    [27] => SELECT name, unique_url, nofollow, menus FROM `sbr203_pages`  WHERE `id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,53,52,51,50,49,48,47,46,44,45) AND `status`='active' AND `menus` != '' ORDER BY `order`
)

Array
(
    [DOCUMENT_ROOT] => /home/wood/public_html
    [GATEWAY_INTERFACE] => CGI/1.1
    [HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
    [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
    [HTTP_ACCEPT_ENCODING] => gzip
    [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
    [HTTP_CACHE_CONTROL] => no-cache
    [HTTP_CONNECTION] => close
    [HTTP_COOKIE] => PHPSESSID=dc56c6b49db337a2b6cb523f99e2e64b
    [HTTP_HOST] => www.wood-burning-stove-dealers.com
    [HTTP_PRAGMA] => no-cache
    [HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
    [HTTP_X_CC_ID] => ccc03-02
    [PATH] => /bin:/usr/bin
    [QUERY_STRING] => 
    [REDIRECT_STATUS] => 200
    [REDIRECT_UNIQUE_ID] => T7kMXNBKfg0AAFPYSK4AAAAJ
    [REDIRECT_URL] => /dir/listing/California/Half-Moon-Bay-Wood-Stoves.html
    [REMOTE_ADDR] => 38.107.179.232
    [REMOTE_PORT] => 34877
    [REQUEST_METHOD] => GET
    [REQUEST_URI] => /dir/listing/California/Half-Moon-Bay-Wood-Stoves.html
    [SCRIPT_FILENAME] => /home/wood/public_html/dir/index.php
    [SCRIPT_NAME] => /dir/index.php
    [SERVER_ADDR] => 208.74.126.13
    [SERVER_ADMIN] => webmaster@wood-burning-stove-dealers.com
    [SERVER_NAME] => www.wood-burning-stove-dealers.com
    [SERVER_PORT] => 80
    [SERVER_PROTOCOL] => HTTP/1.1
    [SERVER_SIGNATURE] => 
    [SERVER_SOFTWARE] => Apache
    [UNIQUE_ID] => T7kMXNBKfg0AAFPYSK4AAAAJ
    [PHP_SELF] => /dir/index.php
    [REQUEST_TIME] => 1337527388
    [argv] => Array
        (
        )

    [argc] => 0
)

Array
(
    [secret] => 6612301c7ec570834b7e5fda4c2169bd
    [user] => Array
        (
            [id] => 
            [group] => 4
        )

    [error] => Array
        (
            [0] => Notice:  Undefined index:  pictures_sections 
 on line 36 in file tmp/front_wood/%%13^133^133157A1%%listing_view.tpl.php
 
            [1] => Notice:  Undefined index:  review 
 on line 52 in file tmp/front_wood/%%13^133^133157A1%%listing_view.tpl.php
 
            [2] => Notice:  Undefined index:  retail_price 
 on line 9 in file tmp/front_wood/%%D0^D08^D084C3FA%%field-type-content.tpl.php
 
            [3] => Notice:  Undefined index:  display_alexa 
 on line 103 in file tmp/front_wood/%%13^133^133157A1%%listing_view.tpl.php
 
            [4] => Notice:  Undefined index:  pictures_sections 
 on line 174 in file tmp/front_wood/%%13^133^133157A1%%listing_view.tpl.php
 
            [5] => User Warning:  Smarty error: unable to read resource: "/home/wood/public_html/dir/templates/default//home/wood/public_html/dir/plugins/reviews/templates/front/index.tpl" 
 on line 1093 in file includes/classes/smarty/Smarty.class.php
 
        )

)

Array
(
    [PHPSESSID] => dc56c6b49db337a2b6cb523f99e2e64b
)