Portale Cremona: Alberghi, Aziende, Hotel, eventi, Foto, Nei dintorni, Hotel | by italy.cremona.it

SET NAMES 'utf8'

SET NAMES 'utf8'

SELECT `name`,`value` 
FROM Ecy330_config  
WHERE `type` NOT 
    AND'divider')

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT `name`, `url` 
FROM Ecy330_plugins  
WHERE `url` != ''AND `status` = 'active'

SELECT `name`, `title` 
FROM Ecy330_plugins  
WHERE `status` = 'active'

SELECT `name`,`code`,`type`,`file`,`plugin` 
FROM Ecy330_hooks  
WHERE `status` = 'active'AND (`page_type` = '' || `page_type` = 'front')AND `plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `order`

SELECT `code`,`lang` 
FROM Ecy330_language  
WHERE 1 
GROUP BY `code`

SELECT DISTINCT `blocks`.* 
FROM `Ecy330_blocks` `blocks` 
    LEFT JOIN `Ecy330_block_show` `block_show`
        ON `blocks`.`id` = `block_show`.`block_id` 
WHERE `blocks`.`status` = 'active'AND `blocks`.`name` != 'account'AND (`blocks`.`sticky` = '1'OR `block_show`.`page` = 'view_listing'OR REPLACE(`block_show`.`page`, 'index_browse|', '') = '0' )AND `blocks`.`plugin` 
    AND'', 'spider','crawl','recaptcha','webthumbnail','gelio_green') 
ORDER BY `blocks`.`position`, `blocks`.`order`

SELECT `value` 
FROM Ecy330_language  
WHERE `key` = 'block_title_blc7'AND `code` = 'it' 
LIMIT 0, 1

SELECT `value` 
FROM Ecy330_language  
WHERE `key` = 'block_content_blc7'AND `code` = 'it' 
LIMIT 0, 1

SELECT `bp`.*, `p`.*, `c`.`title`, `c`.`path` 
FROM `Ecy330_block_pages` `bp` 
    LEFT JOIN `Ecy330_pages` `p`
        ON `bp`.`page_name` = `p`.`name` 
    LEFT JOIN `Ecy330_categories` `c`
        ON `c`.`id` = REPLACE(`bp`.`page_name`, 'index_browse|', '') 
WHERE `bp`.`block_name` = 'inventory' 
ORDER BY `bp`.`id`

SELECT DISTINCT `actions`.`name`, `actions`.* 
FROM `Ecy330_actions` `actions` 
    LEFT JOIN `Ecy330_action_show` `action_show`
        ON `actions`.`name` = `action_show`.`action_name` 
WHERE `action_show`.`page` = 'view_listing'AND `actions`.`name` != 'report' 
ORDER BY `actions`.`order`

SELECT t1.*, t1.`title` `title`, `t3`.`path` `path` , 
    IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval` 
FROM `Ecy330_listings` t1 
    LEFT JOIN `Ecy330_categories` t3
        ON t1.`category_id` = t3.`id` 
WHERE t1.`status` = 'active'AND `t1`.`featured` = '1'AND t3.`status` = 'active'AND t3.`hidden` = '0' 
GROUP BY t1.`id` 
ORDER BY RAND() 
LIMIT 0, 5

SELECT t1.*, t1.`title` `title`, `t3`.`path` `path` , 
    IF((`t1`.`date` + INTERVAL 7 DAY < NOW()), '0', '1') `interval` 
FROM `Ecy330_listings` t1 
    LEFT JOIN `Ecy330_categories` t3
        ON t1.`category_id` = t3.`id` 
WHERE t1.`status` = 'active'AND `t1`.`partner` = '1'AND t3.`status` = 'active'AND t3.`hidden` = '0' 
GROUP BY t1.`id` 
ORDER BY RAND() 
LIMIT 0, 3

SELECT * 
FROM `Ecy330_listing_fields` `listing_fields` 
    LEFT JOIN `Ecy330_field_categories` `field_categories`
        ON `field_categories`.`field_id` = `listing_fields`.`id` 
WHERE `type`='image'AND `instead_thumbnail`=1AND (`field_categories`.`category_id` = '' ) 
GROUP BY `listing_fields`.`id` 
ORDER BY `order` ASC 
LIMIT 1

SELECT `name`, `value` 
FROM Ecy330_listing_visual_options  
WHERE `show` = 1

SELECT t1.*, t2.`path`, t2.`title` `category_title`, t2.`path` `category_path`, (SELECT `username` `account_username` 
FROM `Ecy330_accounts` `accounts` 
WHERE `t1`.`account_id` = `accounts`.`id`) `account_username` 
FROM `Ecy330_listings` t1 
        INNER JOIN `Ecy330_categories` t2
        ON t1.`category_id` = t2.`id` 
WHERE t1.`id` = '33'AND `t2`.`status` = 'active'AND `t1`.`status`='active'

SELECT `url`, `title` 
FROM Ecy330_deep_links  
WHERE `listing_id` = '33'

SELECT `id` 
FROM Ecy330_categories  
WHERE `path` = 'lombardia/cremona' 
LIMIT 0, 1

SELECT 1 
FROM Ecy330_listing_categories 
WHERE `listing_id` = '33'AND `category_id` = '158'

SELECT `categories`.* 
FROM `Ecy330_listing_categories` `listing_categories` 
    LEFT JOIN `Ecy330_categories` `categories`
        ON `listing_categories`.`category_id` = `categories`.`id` 
WHERE `listing_categories`.`listing_id` = '33'

SELECT * 
FROM Ecy330_categories  
WHERE `id` = '158' 
LIMIT 0, 1

SELECT `parent_id` 
FROM Ecy330_flat_structure  
WHERE `category_id` = '158'AND `parent_id` <> '158'

SELECT * 
FROM `Ecy330_listing_fields` `listing_fields` 
    LEFT JOIN `Ecy330_field_categories` `field_categories`
        ON `field_categories`.`field_id` = `listing_fields`.`id` 
WHERE FIND_IN_SET('view', `pages`) > 0AND `adminonly` = '0'AND `name` NOT IN ('url', 'title')AND `instead_thumbnail` = '0'AND (`field_categories`.`category_id` = '158' OR ( `listing_fields`.`recursive` = '1'AND `field_categories`.`category_id` IN ('0','87'))) 
GROUP BY `listing_fields`.`id` 
ORDER BY `order_v` ASC 

SELECT `name` 
FROM Ecy330_field_groups  
WHERE FIND_IN_SET('view', `pages`) 
ORDER BY `order`

SELECT `parent_id`,`title`,`page_title`,`path`, `no_follow` 
FROM Ecy330_categories  
WHERE `id` = '158' 
LIMIT 0, 1

SELECT `parent_id`,`title`,`page_title`,`path`, `no_follow` 
FROM Ecy330_categories  
WHERE `id` = '87' 
LIMIT 0, 1

SELECT `parent_id`,`title`,`page_title`,`path`, `no_follow` 
FROM Ecy330_categories  
WHERE `id` = '0' 
LIMIT 0, 1

global $listing, $eSyndiCat, $esynSmarty;

if ('webthumbnail' == $eSyndiCat->mConfig['thumbshots_name'] && !empty($listing['domain']))
{
	// thumbnail file path
	$path = IA_TMP . 'webthumbnails' ;

	// create thumbnails directory in case it does not exist
	if (!file_exists($path) || !is_dir($path))
	{
		@mkdir($path);
	}

	// thumbnail filename
	$thumbname = $listing['domain'] . '.' . $eSyndiCat->mConfig['webthumbnail_format'];

	// create thumbnail if no thumbnail created
	if (!file_exists($path . IA_DS . $thumbname))
	{
		// define webthumbnail class
		$eSyndiCat->loadPluginClass("Webthumbnail", "webthumbnail", "esyn", false);
		$esynWebthumbnail = new esynWebthumbnail('http://'.$listing['domain']);

		$esynWebthumbnail
			->setWidth($eSyndiCat->mConfig['webthumbnail_width'])
			->setHeight($eSyndiCat->mConfig['webthumbnail_height'])
			->captureToFile($path . IA_DS . $thumbname);
	}
}

{if $config.ckeditor_code_highlighting}
	{ia_add_media files='js:js/utils/syntaxhighlighter/js/core-min, css:js/utils/syntaxhighlighter/css/shCore-min, css:js/utils/syntaxhighlighter/css/shCoreDefault-min, css:js/utils/syntaxhighlighter/css/shThemeDefault-min'}

<script type="text/javascript">
<!--
SyntaxHighlighter.autoloader(
	['applescript', 'js/utils/syntaxhighlighter/js/shBrushAppleScript-min.js'],
	['actionscript3 as3', 'js/utils/syntaxhighlighter/js/shBrushAS3-min.js'],
	['bash shell', 'js/utils/syntaxhighlighter/js/shBrushBash-min.js'],
	['coldfusion cf', 'js/utils/syntaxhighlighter/js/shBrushColdFusion-min.js'],
	['c# c-sharp csharp', 'js/utils/syntaxhighlighter/js/shBrushCSharp-min.js'],
	['cpp c', 'js/utils/syntaxhighlighter/js/shBrushCpp-min.js'],
	['css', 'js/utils/syntaxhighlighter/js/shBrushCss-min.js'],
	['java', 'js/utils/syntaxhighlighter/js/shBrushJava-min.js'],
	['js jscript javascript', 'js/utils/syntaxhighlighter/js/shBrushJScript-min.js'],
	['objective-c objc cocoa', 'js/utils/syntaxhighlighter/js/shBrushObjC-min.js'],
	['perl pl', 'js/utils/syntaxhighlighter/js/shBrushPerl-min.js'],
	['php', 'js/utils/syntaxhighlighter/js/shBrushPhp-min.js'],
	['text plain', 'js/utils/syntaxhighlighter/js/shBrushPlain-min.js'],
	['py python', 'js/utils/syntaxhighlighter/js/shBrushPython-min.js'],
	['rails ror ruby', 'js/utils/syntaxhighlighter/js/shBrushRuby-min.js'],
	['sql', 'js/utils/syntaxhighlighter/js/shBrushSql-min.js'],
	['vb vbnet', 'js/utils/syntaxhighlighter/js/shBrushVb-min.js'],
	['xml xhtml xslt html', 'js/utils/syntaxhighlighter/js/shBrushXml-min.js']
);
SyntaxHighlighter.defaults['auto-links'] = true;
SyntaxHighlighter.defaults['toolbar'] = false;
SyntaxHighlighter.all();
-->
</script>
{/if}