AutoBB REV 2.3 [Joomla 1.0.x!] - страница 11 - AutoBB

if (!isset ($_GET['task'])){
$mainframe->setPageTitle ('Авторынок, продажа автомобилей, мотоциклов...');
}

switch ( strtolower ( $task) ) {

	case "show" :
		$query = "UPDATE #__autobb_messages set views=views+1, lastViewIP='$ip' WHERE id=$id and lastViewIP<>'$ip' OR (id=$id and lastViewIP IS NULL)";
		$database->setQuery ( $query);
		$database->query ();
		echo getErrorText ( mosGetParam ( $_REQUEST, 'error', 0 ) );
		$options = array ( 'cacheDir' => $mosConfig_cachepath.'/', 'caching' => $mosConfig_caching, 'defaultGroup' => "com_autobb_show_$id", 'lifeTime' => $autobbConfig->cachetime_show );
		$cache = new JCache_Lite_Function ( $options );
		$meta = $cache->call ('showMessage', $id, $img );
		$mainframe->setPageTitle ( $meta->title ); 
		if ( $meta->keywords ) $mainframe->prependMetaTag ( "keywords", $meta->keywords ); 
		if ( $meta->description ) $mainframe->prependMetaTag ( "description", $meta->description ); 
		$mainframe->appendPathWay ( $meta->pathway ); 
		$comments = $mosConfig_absolute_path . '/components/com_jcomments/jcomments.php';
		if ( $autobbConfig->allow_jcomments && file_exists ( $comments ) ) {
			include_once ( $comments ); 
			echo JComments::showComments ($id, 'com_autobb', sprintf ( _AUTOBB_JCOMMENTS_RSSTITLE, $meta->pathway ) );
		}
		break;

	case "print" : 
		$options = array ( 'cacheDir' );
		$cache = new JCache_Lite_Function ( $options );
		$meta = $cache->call ('showMessage', $id, $img );
		$mainframe->setPageTitle ( $meta->title ); 
		break;

	case "photo" : 
		header ( "Content-type: image/jpeg" ); 
		header ( "Cache-control: max-age=".$autobbConfig->cachetime_photo );
		header ( "Expires: ".date ("r", time () + $autobbConfig->cachetime_photo ) );
		$options = array ( 'cacheDir' => $mosConfig_cachepath.'/', 'caching' => 1, 'defaultGroup' => 'com_autobb_photo', 'lifeTime' => $autobbConfig->cachetime_photo );
		if ( $size == 'custom' ) $filename = "pic_custom_".$msize."_".$id.".jpg"; 
		else $filename = "pic_".$size."_".$id.".jpg";
		$cache = new JCache_Lite_Function ( $options );
		$ic = $autobbConfig->category;
		$cache->call ( 'loadPhoto', $id, $size, $msize, $toFileName='', $ic ); 
		break;

	case "select_region" : 
		$mainframe->setPageTitle ( _AUTOBB_SELECTREGIONFORM_PAGETITLE_REGION );
		$cache =& mosCache::getCache ( 'com_autobb' ); 
		$cache->call ( 'selectRegion', intval ( mosGetParam ($_REQUEST, 'allow_any', 0 ) ) ); 
		break;
	case "select_city" : 
		$mainframe->setPageTitle ( _AUTOBB_SELECTREGIONFORM_PAGETITLE_CITY );
		$cache =& mosCache::getCache ( 'com_autobb' ); 
		$region = intval ( mosGetParam ( $_REQUEST, 'region' ) ); 
		$cache->call ( 'selectCity', $region, intval ( mosGetParam ($_REQUEST, 'allow_any', 0 ) ) ); 
		break;
	case "list" : 
	case "listex" : //Для совестимости с модулем городов от Surik
	case "rss" : 
		listMessages ( $category_id ); 
		break;
	case "add" :
		newMessage ( $category_id );
		break;
	case "edit" :
		editMessage ( $id );
		break;
	case "apply" : 
	case "save" : 
		saveMessage ( $id ); 
		break;
	case "publish" :
		publishMessage ( $id );
		break;
	case "unpublish" :
		unPublish ( $id );
		break;
	case "setpublish" :
		publishAds ( $id );
		break;
	case "searchpage" :  
		searchPage ( $category_id ); 
		break;
	case "search" :  
		extendedSearch ( $category_id ); 
		break;
	case "delete" : deleteMessage ( $id ); break;
	case "seomap" : 
		$limit      = intval ( mosGetParam ( $_REQUEST, 'limit', $mosConfig_list_limit ) );
		$limitstart = intval ( mosGetParam ( $_REQUEST, 'limitstart', 0 ) );
		$options = array ( 'cacheDir' => $mosConfig_cachepath.'/', 'caching' => 1, 'defaultGroup' => 'com_autobb_seomap', 'lifeTime' => $autobbConfig->cachetime_seomap );
		$cache = new JCache_Lite_Function ( $options );
		$cache->call ( 'seoMap', $category_id, $limitstart, $limit ); 
		break; 
	case "wwwmail" : 
		mailForm ( $id );
		break;
	case "simage" : 
		loadSecuredImage ( $id );
		break;
	case "sendmail" : 
		sendWWWMail ( $id );
		break;
	default : 
	   
		$meta = listMessages ( $category_id ); 
		if ($my->id) {
		$mainframe->setPageTitle ('Авторынок, продажа автомобилей, мотоциклов...');
		if ( $meta->pathway ) $mainframe->appendPathWay ( $meta->pathway ); 
		}
		break;
}

if (!isset ($_GET['task'])){
$mainframe->setPageTitle ('Авторынок, продажа автомобилей, мотоциклов...');
}

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'sefpatch'
 ORDER BY ordering
4
SELECT file, title FROM jos_sefexts WHERE title != ''
5
SELECT name, link, id FROM jos_menu WHERE published > 0 AND link LIKE 'index.php?option=com_%'
6
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_autobb'
7
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 202 )
 ORDER BY menuid DESC
LIMIT 1
8
DELETE FROM jos_session
 WHERE (
 ( time < '1252230219' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1252230219' )
 AND guest = 1
 AND userid = 0
 )
9
SELECT session_id
 FROM jos_session
 WHERE session_id = 'ebfd5750857a04d05206a3b1ce42a8a8'
10
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'ebfd5750857a04d05206a3b1ce42a8a8','1252231119','','0','1' )
11
SELECT
				k.id,
				k.name
			FROM
				jos_kusoma k
			WHERE
				k.published = 1
12
SELECT *
 FROM jos_kusoma
 WHERE id = '1'
13
SELECT id FROM jos_mambots WHERE element = 'joomsef_metabot' AND folder = 'system'
14
SELECT *
 FROM jos_mambots
 WHERE id = '20'
15
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 202 )
 ORDER BY menuid DESC
LIMIT 1
16
SELECT params
 FROM jos_mambots
 WHERE element = 'yoo_effects'
 AND folder = 'system'
17
SELECT *
 FROM jos_menu
 WHERE id = 202
18
SELECT *
 FROM jos_menu
 WHERE id = '202'
19
SELECT count(a.id)
 FROM jos_autobb_messages AS a
 LEFT JOIN jos_autobb_photos AS p
 ON a.id=p.msgid
 LEFT JOIN jos_autobb_vendors AS v
 ON a.vendor=v.id
 LEFT JOIN jos_autobb_models AS m
 ON a.model=m.id
 LEFT JOIN jos_autobb_colors AS c
 ON a.color=c.id
 LEFT JOIN jos_autobb_currency AS cur
 ON a.currency=cur.id
 WHERE a.expirationDate>=NOW() AND a.published=1 AND a.modifyDate>=DATE_SUB( now(), INTERVAL 1 MONTH)
 GROUP BY a.id
20
SELECT a.*, a.mileage*(1 + a.mileage_unit*0.609) as metric_mileage, a.mileage*(1 - (1 - a.mileage_unit)*0.3785) as english_mileage,
 p.id as photo_id, count(p.id) as photo_count, v.itemid as vendor_itemid, v.title as vendortitle, m.itemid as model_itemid, m.title as modeltitle, c.title as colortitle,
 cur.sign as currency_sign, a.price*cur.rate as price_in_rur, DATE_FORMAT(a.modifyDate, '%a, %d %b %Y %T GMT') as rfcDate, ct.title as city_title, r.title as region_title
 FROM jos_autobb_messages AS a
 LEFT JOIN jos_autobb_photos AS p
 ON a.id=p.msgid
 LEFT JOIN jos_autobb_vendors AS v
 ON a.vendor=v.id
 LEFT JOIN jos_autobb_models AS m
 ON a.model=m.id
 LEFT JOIN jos_autobb_colors AS c
 ON a.color=c.id
 LEFT JOIN jos_autobb_currency AS cur
 ON a.currency=cur.id
 LEFT JOIN jos_autobb_cities AS ct
 ON a.city=ct.id
 LEFT JOIN jos_autobb_regions AS r
 ON ct.region=r.id
 WHERE a.expirationDate>=NOW() AND a.published=1 AND a.modifyDate>=DATE_SUB( now(), INTERVAL 1 MONTH)
 GROUP BY a.id
 ORDER BY a.sticked DESC, a.ordering ASC, a.modifyDate DESC
 LIMIT 0, 30
21
SELECT *
 FROM jos_sefexts
 WHERE file = 'com_autobb.xml'
22
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&d=30&ex=0&m=0&task=&v=0' AND Itemid = '202'
23
SELECT min(id) id, min(title) title FROM jos_autobb_photos where msgid=83
24
SELECT min(id) id, min(title) title FROM jos_autobb_photos where msgid=82
25
SELECT min(id) id, min(title) title FROM jos_autobb_photos where msgid=81
26
SELECT min(id) id, min(title) title FROM jos_autobb_photos where msgid=80
27
SELECT min(id) id, min(title) title FROM jos_autobb_photos where msgid=79
28
SELECT min(id) id, min(title) title FROM jos_autobb_photos where msgid=77
29
SELECT min(id) id, min(title) title FROM jos_autobb_photos where msgid=60
30
SELECT min(id) id, min(title) title FROM jos_autobb_photos where msgid=59
31
SELECT min(id) id, min(title) title FROM jos_autobb_photos where msgid=56
32
SELECT min(id) id, min(title) title FROM jos_autobb_photos where msgid=49
33
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 202 )
 ORDER BY ordering
34
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=0&d=0&ex=0&m=0&task=&v=0' AND Itemid = '202'
35
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=0&d=1&ex=0&m=0&task=&v=0' AND Itemid = '202'
36
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=0&d=2&ex=0&m=0&task=&v=0' AND Itemid = '202'
37
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=0&d=3&ex=0&m=0&task=&v=0' AND Itemid = '202'
38
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=0&d=7&ex=0&m=0&task=&v=0' AND Itemid = '202'
39
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=0&d=14&ex=0&m=0&task=&v=0' AND Itemid = '202'
40
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=0&d=21&ex=0&m=0&task=&v=0' AND Itemid = '202'
41
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=0&d=30&ex=0&m=0&task=&v=0' AND Itemid = '202'
42
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=0&d=60&ex=0&m=0&task=&v=0' AND Itemid = '202'
43
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=0&d=0&ex=-1&m=0&task=&v=0' AND Itemid = '202'
44
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=86&task=unpublish' AND Itemid = '202'
45
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=86&task=setpublish' AND Itemid = '202'
46
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=86&task=delete' AND Itemid = '202'
47
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=1336&d=0&ex=0&m=0&task=&v=0' AND Itemid = '202'
48
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=83&task=unpublish' AND Itemid = '202'
49
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=83&task=setpublish' AND Itemid = '202'
50
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=83&task=delete' AND Itemid = '202'
51
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=82&task=show' AND Itemid = '202'
52
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=82&task=unpublish' AND Itemid = '202'
53
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=82&task=setpublish' AND Itemid = '202'
54
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=82&task=delete' AND Itemid = '202'
55
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=1327&d=0&ex=0&m=0&task=&v=0' AND Itemid = '202'
56
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=81&task=unpublish' AND Itemid = '202'
57
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=81&task=setpublish' AND Itemid = '202'
58
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=81&task=delete' AND Itemid = '202'
59
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=80&task=unpublish' AND Itemid = '202'
60
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=80&task=setpublish' AND Itemid = '202'
61
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=80&task=delete' AND Itemid = '202'
62
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=79&task=unpublish' AND Itemid = '202'
63
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=79&task=setpublish' AND Itemid = '202'
64
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=79&task=delete' AND Itemid = '202'
65
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=78&task=unpublish' AND Itemid = '202'
66
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=78&task=setpublish' AND Itemid = '202'
67
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=78&task=delete' AND Itemid = '202'
68
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=77&task=show' AND Itemid = '202'
69
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=77&task=unpublish' AND Itemid = '202'
70
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=77&task=setpublish' AND Itemid = '202'
71
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=77&task=delete' AND Itemid = '202'
72
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=76&task=unpublish' AND Itemid = '202'
73
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=76&task=setpublish' AND Itemid = '202'
74
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=76&task=delete' AND Itemid = '202'
75
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=62&task=unpublish' AND Itemid = '202'
76
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=62&task=setpublish' AND Itemid = '202'
77
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=62&task=delete' AND Itemid = '202'
78
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=61&task=unpublish' AND Itemid = '202'
79
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=61&task=setpublish' AND Itemid = '202'
80
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=61&task=delete' AND Itemid = '202'
81
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=60&task=unpublish' AND Itemid = '202'
82
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=60&task=setpublish' AND Itemid = '202'
83
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=60&task=delete' AND Itemid = '202'
84
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=1334&d=0&ex=0&m=0&task=&v=0' AND Itemid = '202'
85
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=59&task=show' AND Itemid = '202'
86
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=59&task=unpublish' AND Itemid = '202'
87
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=59&task=setpublish' AND Itemid = '202'
88
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=59&task=delete' AND Itemid = '202'
89
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=58&task=unpublish' AND Itemid = '202'
90
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=58&task=setpublish' AND Itemid = '202'
91
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=58&task=delete' AND Itemid = '202'
92
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=57&task=unpublish' AND Itemid = '202'
93
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=57&task=setpublish' AND Itemid = '202'
94
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=57&task=delete' AND Itemid = '202'
95
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=1320&d=0&ex=0&m=0&task=&v=0' AND Itemid = '202'
96
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=56&task=unpublish' AND Itemid = '202'
97
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=56&task=setpublish' AND Itemid = '202'
98
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=56&task=delete' AND Itemid = '202'
99
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=50&task=unpublish' AND Itemid = '202'
100
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=50&task=setpublish' AND Itemid = '202'
101
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=50&task=delete' AND Itemid = '202'
102
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=49&task=unpublish' AND Itemid = '202'
103
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=49&task=setpublish' AND Itemid = '202'
104
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=49&task=delete' AND Itemid = '202'
105
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=1327&d=0&ex=0&m=0&task=&v=0' AND Itemid = '202'
106
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=48&task=unpublish' AND Itemid = '202'
107
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=48&task=setpublish' AND Itemid = '202'
108
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=48&task=delete' AND Itemid = '202'
109
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=47&task=unpublish' AND Itemid = '202'
110
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=47&task=setpublish' AND Itemid = '202'
111
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=47&task=delete' AND Itemid = '202'
112
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=46&task=unpublish' AND Itemid = '202'
113
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=46&task=setpublish' AND Itemid = '202'
114
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&id=46&task=delete' AND Itemid = '202'
115
SELECT m.id,m.name,m.link,m.parent,m.browserNav,m.type, count(p.parent) as child_count
FROM jos_menu AS m
LEFT JOIN jos_menu AS p ON p.parent = m.id
WHERE m.menutype='mainmenu' AND m.published='1'
GROUP BY m.id ORDER BY m.parent, m.ordering
116
SELECT *
 FROM jos_sefexts
 WHERE file = 'com_content.xml'
117
SELECT *
 FROM jos_sefexts
 WHERE file = 'com_frontpage.xml'
118
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_frontpage' AND Itemid = '1'
119
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_frontpage' AND Itemid = '1'
120
SELECT newurl, Itemid FROM jos_redirection WHERE oldurl = ''
121
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
122
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
123
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
124
SELECT params
 FROM jos_menu
 WHERE id = 203
125
SELECT params
 FROM jos_menu
 WHERE id = 128
126
SELECT params
 FROM jos_menu
 WHERE id = 235
127
SELECT params
 FROM jos_menu
 WHERE id = 236
128
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
129
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Покупка Продажа Авто'
 AND published = 1
 ORDER BY parent, ordering
130
SELECT params
 FROM jos_menu
 WHERE id = 227
131
SELECT params
 FROM jos_menu
 WHERE id = 228
132
SELECT params
 FROM jos_menu
 WHERE id = 229
133
SELECT params
 FROM jos_menu
 WHERE id = 256
134
SELECT params
 FROM jos_menu
 WHERE id = 262
135
SELECT params
 FROM jos_menu
 WHERE id = 258
136
SELECT params
 FROM jos_menu
 WHERE id = 230
137
SELECT c.id as value,c.title,m.id as Itemid,m.name FROM jos_categories as c
 LEFT JOIN jos_menu as m
 ON m.params LIKE CONCAT('%category_id=',c.id,'%')
 WHERE m.type='components' AND m.link='index.php?option=com_autobb' AND c.section='com_autobb' and m.published=1
138
SELECT id as value, title FROM jos_autobb_vendors WHERE category='601' ORDER BY title
139
SELECT id as value, title FROM jos_autobb_models WHERE vendor='0' ORDER BY title
140
SELECT a.city, c.title, count(a.id) as msg_count 
 FROM jos_autobb_messages a 
 LEFT JOIN jos_autobb_cities as c ON c.id=a.city 
 WHERE a.expirationDate>=NOW() AND a.published='1'
 GROUP BY a.city
 ORDER BY 3 desc
141
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=1340&d=0&ex=0&m=0&task=&v=0' AND Itemid = '202'
142
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=1336&d=0&ex=0&m=0&task=&v=0' AND Itemid = '202'
143
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=1320&d=0&ex=0&m=0&task=&v=0' AND Itemid = '202'
144
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=1327&d=0&ex=0&m=0&task=&v=0' AND Itemid = '202'
145
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=1328&d=0&ex=0&m=0&task=&v=0' AND Itemid = '202'
146
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_autobb&ct=1334&d=0&ex=0&m=0&task=&v=0' AND Itemid = '202'
147
SELECT *
 FROM jos_sefexts
 WHERE file = 'com_registration.xml'
148
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_registration&task=lostPassword'
149
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
150
SELECT * FROM jos_comment_setting 
  WHERE  id=1 
  ORDER BY set_component ASC,set_sectionid DESC LIMIT 1
151
SELECT params
 FROM jos_mambots
 WHERE element LIKE 'joscomment%'
 AND folder = 'content'
 AND published = 1
152
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
153
SELECT params
 FROM jos_mambots
 WHERE element = 'hsimage'
 AND folder = 'content'