Блоги

Отладочная информация:

Array
(
    [0] => SELECT permission_type FROM om_rus_pages USE INDEX (PRIMARY) WHERE id = 237
    [1] => SELECT id, language FROM sites_languages
    [2] => SELECT pb.*, pb.id as block_id, m.name, m.title, m.id as mod_id, p.usr_group_id, number_of_fields, pt.main_module , IF(p.owner_id = 0, 1 , 0) as is_owner,
					IF(p.owner_id = 0,
						p.rights >> 8,
						IF(ug.user_id IS NOT NULL ,
							(p.rights & 0xF0) >> 4,
							p.rights & 0xF
						)
					) AS user_rights FROM  om_rus_pages as p LEFT JOIN core_users_groups ug ON (ug.group_id = p.usr_group_id AND ug.user_id = 0 ) , om_rus_pages_blocks as pb , om_rus_pages_templates as pt , modules as m  WHERE p.id = 237 
						  			 AND p.tpl_id = pt.id AND p.id = pb.page_id
									 AND m.id = pb.module_id AND IF( p.owner_id = 0,
						p.rights >> 8,
						IF(ug.user_id IS NOT NULL ,
							(p.rights & 0xF0) >> 4,
							p.rights & 0xF
						)
					) > 0 ORDER BY field_number, block_rank
    [3] => SELECT id, language FROM sites_languages
    [4] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='om' AND S.id = site_id AND M.id=module_id AND active
    [5] => SELECT  b.id,b.date AS _date,  DATE_FORMAT(b.date,'%d %m %Y | %H:%i') as date,  b.title,  b.announce,  LENGTH(b.content) as content_length,  b.comments_type,  b.author_id,  b.image,   b.preview,  u.username,  u.email, count(c.id) as cnt_comments  FROM om_rus_blogs b   JOIN core_users u   LEFT JOIN om_rus_comments_resource r ON (r.item_id=b.id AND r.type=3) LEFT JOIN om_rus_comments c ON c.resrc_id=r.id WHERE b.author_id=u.id AND b.active=1   GROUP BY b.id   ORDER BY _date DESC   LIMIT 0,3
    [6] => SELECT COUNT(*) AS cnt FROM om_rus_blogs WHERE active=1
    [7] => SELECT p.*, DATE_FORMAT(begin_date,'%d.%m.%Y') as begin_date, DATE_FORMAT(end_date,'%d.%m.%Y') as end_date, IF(p.owner_id = 0, 1 , 0) as is_owner,
					IF(p.owner_id = 0,
						p.rights >> 8,
						IF(ug.user_id IS NOT NULL ,
							(p.rights & 0xF0) >> 4,
							p.rights & 0xF
						)
					) AS user_rights FROM om_rus_polls p LEFT JOIN core_users_groups ug  ON (ug.group_id = p.usr_group_id AND ug.user_id = 0)  WHERE begin_date <= CURDATE() AND end_date >= CURDATE() AND active = 1  AND IF( p.owner_id = 0,
						p.rights >> 8,
						IF(ug.user_id IS NOT NULL ,
							(p.rights & 0xF0) >> 4,
							p.rights & 0xF
						)
					) > 0 ORDER BY RAND() LIMIT 0,1
    [8] => SELECT id,variant_text
					FROM om_rus_poll_other_results
					WHERE poll_id=11
					ORDER BY variant_text
    [9] => UPDATE om_rus_polls SET hits=IF(hits > 0, hits + 1, 1) WHERE id='0'
    [10] => UPDATE core_users SET onsite=0 WHERE last_visit  SELECT b.id, b.title, DATE_FORMAT(b.date,'%d %m %Y | %H:%i') as date, u.username, count(c.id) as cnt_comments FROM om_rus_blogs b  INNER JOIN core_users u on (b.author_id=u.id)  LEFT JOIN om_rus_comments_resource r ON (r.item_id=b.id AND r.type=3) LEFT JOIN om_rus_comments c ON c.resrc_id=r.id WHERE b.active = 1  GROUP BY b.id  ORDER BY cnt_comments DESC  LIMIT 0, 2
    [12] => SELECT b.id, b.title, DATE_FORMAT(b.date,'%d %m %Y | %H:%i') as date_txt, u.username FROM om_rus_blogs b  INNER JOIN core_users u ON b.author_id = u.id WHERE  b.active = 1 ORDER BY b.date DESC LIMIT 0, 2
    [13] => SELECT id FROM om_rus_blogs WHERE active=1
    [14] => SELECT b.id, b.title, DATE_FORMAT(b.date,'%d %m %Y | %H:%i') as date_txt, u.username, count(c.id) as cnt_comments FROM om_rus_blogs b
				INNER JOIN core_users u ON b.author_id = u.id LEFT JOIN om_rus_comments_resource r ON (r.item_id=b.id AND r.type=3) LEFT JOIN om_rus_comments c ON c.resrc_id=r.id WHERE b.id IN (11,13) GROUP BY b.id
    [15] => SELECT count(*) as cnt, u.username
					FROM om_rus_blogs b INNER JOIN core_users u ON b.author_id = u.id
					WHERE b.active = 1
					GROUP BY u.id DESC
					ORDER BY cnt DESC
					LIMIT 0, 2
    [16] => SELECT a.*, IF(a.owner_id = 0, 1 , 0) as is_owner,
					IF(a.owner_id = 0,
						a.rights >> 8,
						IF(ug.user_id IS NOT NULL ,
							(a.rights & 0xF0) >> 4,
							a.rights & 0xF
						)
					) AS user_rights FROM om_rus_articles a LEFT JOIN core_users_groups ug  ON (ug.group_id = a.usr_group_id AND ug.user_id = 0)  WHERE id = 124 AND active=1 AND IF( a.owner_id = 0,
						a.rights >> 8,
						IF(ug.user_id IS NOT NULL ,
							(a.rights & 0xF0) >> 4,
							a.rights & 0xF
						)
					) > 0
    [17] => SELECT id, title, commentable FROM om_rus_articles WHERE id=124 AND commentable>0
    [18] => SELECT * FROM om_rus_comments_resource WHERE type=4 AND item_id=124
    [19] => SELECT * FROM om_rus_comments_resource WHERE type=4 AND item_id=124
    [20] => UPDATE om_rus_articles SET hits=IF(hits > 0, hits + 1, 1) WHERE id='124'
    [21] => SELECT * FROM om_rus_pages USE INDEX (index_2) WHERE ((parent_id = 0  OR branch!="" ) AND active = 1) OR is_default = 1 ORDER BY level, page_rank DESC
    [22] => SELECT id, parent_id, title, address
											FROM om_rus_pages USE INDEX (index_3)
											WHERE parent_id IN (256,139,219,202,245,253,237,200,218,271,264,152,221,211,230,229,206,207,257,258,209,205,213,244,251,246,210,201,198,242,265,266,267,268,269,270,272) AND
												  active = 1
											ORDER BY page_rank desc
    [23] => SELECT id, parent_id, title, address
											FROM om_rus_pages USE INDEX (index_3)
											WHERE parent_id IN (256,139,219,202,245,253,237,200,218,271,264,152,221,211,230,229,206,207,257,258,209,205,213,244,251,246,210,201,198,242,265,266,267,268,269,270,272) AND
												  active = 1
											ORDER BY page_rank desc
    [24] => SELECT * FROM om_rus_pages_context_menu ORDER BY id
)

Array
(
)

Array
(
    [971] => $PAGE["modules"]["blogs"] = new Blogs('showlist', '/blogs/?', Array
(
    [1] => 3
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - blogs_list.html
    [1059] => $PAGE["modules"]["blogs"]->BlogsPrototype('showsearchform', '/blogs/?', Array
(
    [1] => 
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - blogs_searchform.html
    [959] => $PAGE["modules"]["poll"] = new Poll('showpoll', '/catalog/poll-result/?', Array
(
    [1] => 
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - poll_show.html
    [1133] => $PAGE["modules"]["siteusers"] = new Siteusers('usernav', '/siteusers/?', Array
(
    [1] => 
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - siteusers_usernav.html
    [962] => $PAGE["modules"]["siteusers"]->SiteusersPrototype('loginform', '/siteusers/?', Array
(
    [1] => 
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - siteusers_loginform.html
    [1057] => $PAGE["modules"]["blogs"]->BlogsPrototype('blogsannounce', '/blogs/?', Array
(
    [1] => 2
    [2] => 2
    [3] => 2
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - blogs_announce.html
    [964] => $PAGE["modules"]["article"] = new Article('showarticle', '/blogs/?', Array
(
    [1] => 124
    [2] => 
    [3] => 
    [4] => 
    [5] => 
    [tpl] => 
)
), tpl - article.html
    [-1] => $PAGE["modules"]["pages"] = new Pages('showmenu', '', Array
(
)
), tpl - pages_menu.html
    [-2] => $PAGE["modules"]["pages"]->PagesPrototype('showsubmenu', '', Array
(
)
), tpl - pages_sub_menu.html
    [-10] => $PAGE["modules"]["pages"]->PagesPrototype('showchilds', '', Array
(
)
)
    [-4] => $PAGE["modules"]["pages"]->PagesPrototype('showpath', '', Array
(
)
), tpl - pages_path.html
)

Array
(
    [session_cur_site_id] => 1
    [session_cur_lang_id] => 1
    [catalog_rates] => Array
        (
            [USD/USD] => 1
            [RUR/RUR] => 1
            [USD/RUR] => 30,0785
            [RUR/USD] => 0,033246338746945
            [EUR/EUR] => 1
            [EUR/RUR] => 44,0259
            [RUR/EUR] => 0,022713902498302
            [EUR/USD] => 1,4637
            [USD/EUR] => 0,68320010931202
        )

)