| Список форумов Правила Регистрация |
| Тема | Автор | Просмотров | Сообщений | Последнее |
|---|---|---|---|---|
| Родина! | ||||
 Сколько?
(←12)
|
ЛКН 06.07.2007 14:10 |
290 | 9 |
demo 10.07.2007 03:10 |
Опции просмотра |
МодераторыXloyamama |
|
тема тема закрыта |
горячая тема горячая тема закрыта |
прикрепленная тема прикрепленная тема закрыта |
объявления объявления закрыты |
Array
(
[0] => SELECT permission_type FROM outin_rus_pages USE INDEX (PRIMARY) WHERE id = 200
[1] => SELECT pb.*, pb.id as block_id, m.name, m.title, m.id as mod_id, p.usr_group_id, number_of_fields, 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 outin_rus_pages as p LEFT JOIN core_users_groups ug ON (ug.group_id = p.usr_group_id AND ug.user_id = 0 ) , outin_rus_pages_blocks as pb , outin_rus_pages_templates as pt , modules as m WHERE p.id = 200
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 block_rank
[2] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[3] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 644595572 BETWEEN first_long_ip AND last_long_ip ORDER BY name
[4] => SELECT b.id, IF(b.owner_id = 0, 1 , 0) as is_owner,
IF(b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) AS user_rights FROM outin_rus_banners b LEFT JOIN core_users_groups ug ON (ug.group_id = b.usr_group_id AND ug.user_id = 0) WHERE category_id = 47 AND ( ( max_showing = 0 AND ISNULL(show_from) AND ISNULL(show_to) ) OR showing < max_showing OR '2010-02-09' BETWEEN show_from AND show_to) AND active AND IF( b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) > 0
[5] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[6] => 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 outin_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
[7] => UPDATE outin_rus_polls SET hits=IF(hits > 0, hits + 1, 1) WHERE id=''
[8] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[9] => REPLACE INTO outin_rus_forum_online_user (sid, vtime, forum_id, topic_id, user_id, username) VALUES ('4261bb4e157626aacbaee5db4144d3df', NOW(), 3, 0, 0, '')
[10] => DELETE FROM outin_rus_forum_online_user WHERE vtime < DATE_SUB(NOW(), INTERVAL 15 MINUTE)
[11] => SELECT f.*, IF(f.owner_id = 0, 1 , 0) as is_owner,
IF(f.owner_id = 0,
f.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(f.rights & 0xF0) >> 4,
f.rights & 0xF
)
) AS user_rights FROM outin_rus_forums f LEFT JOIN core_users_groups ug ON (ug.group_id = f.usr_group_id AND ug.user_id = 0) WHERE f.id=3 AND active = 1 AND IF( f.owner_id = 0,
f.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(f.rights & 0xF0) >> 4,
f.rights & 0xF
)
) > 0
[12] => SELECT U.id, U.username FROM outin_rus_forum_moderator AS M, core_users AS U WHERE forum_id=3 AND user_id=U.id
[13] => SELECT count(*) as cnt FROM outin_rus_forum_posts fp
LEFT JOIN outin_rus_forum_post_state fs ON fp.id=fs.topic_id
LEFT JOIN outin_rus_forum_last_reply lr ON fp.id=lr.topic_id LEFT JOIN core_users_groups ug ON (ug.group_id = fp.usr_group_id AND ug.user_id = 0) WHERE fp.forum_id = 3 AND fp.topic_id = 0 AND fp.active = 1 AND fs.type=2 AND IF( fp.owner_id = 0,
fp.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(fp.rights & 0xF0) >> 4,
fp.rights & 0xF
)
) > 0
[14] => SELECT fp.*, fs.status, fs.type,
DATE_FORMAT(fp.post_date,'%d.%m.%Y %H:%i') as postdate,
DATE_FORMAT(fp.updated,'%d.%m.%Y %H:%i') as topic_updated,
lr.user_id as last_user_id, lr.username as last_username,
DATE_FORMAT(lr.post_date,'%d.%m.%Y %H:%i') as last_post_date,0 AS has_new, 0 as is_owner,
IF(fp.owner_id = 0,
fp.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(fp.rights & 0xF0) >> 4,
fp.rights & 0xF
)
) AS user_rights FROM outin_rus_forum_posts fp
LEFT JOIN outin_rus_forum_post_state fs ON fp.id=fs.topic_id
LEFT JOIN outin_rus_forum_last_reply lr ON fp.id=lr.topic_id LEFT JOIN core_users_groups ug ON (ug.group_id = fp.usr_group_id AND ug.user_id = 0) WHERE fp.forum_id = 3 AND fp.topic_id = 0 AND fp.active = 1 AND fs.type=2 AND IF( fp.owner_id = 0,
fp.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(fp.rights & 0xF0) >> 4,
fp.rights & 0xF
)
) > 0 ORDER BY fs.type DESC, updated DESC LIMIT 0,5
[15] => SELECT count(*) as cnt FROM outin_rus_forum_posts fp
LEFT JOIN outin_rus_forum_post_state fs ON fp.id=fs.topic_id
LEFT JOIN outin_rus_forum_last_reply lr ON fp.id=lr.topic_id LEFT JOIN core_users_groups ug ON (ug.group_id = fp.usr_group_id AND ug.user_id = 0) WHERE fp.forum_id = 3 AND fp.topic_id = 0 AND fp.active = 1 AND (fs.type IS NULL OR fs.type!=2) AND IF( fp.owner_id = 0,
fp.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(fp.rights & 0xF0) >> 4,
fp.rights & 0xF
)
) > 0
[16] => SELECT fp.*, fs.status, fs.type,
DATE_FORMAT(fp.post_date,'%d.%m.%Y %H:%i') as postdate,
DATE_FORMAT(fp.updated,'%d.%m.%Y %H:%i') as topic_updated,
lr.user_id as last_user_id, lr.username as last_username,
DATE_FORMAT(lr.post_date,'%d.%m.%Y %H:%i') as last_post_date,0 AS has_new, 0 as is_owner,
IF(fp.owner_id = 0,
fp.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(fp.rights & 0xF0) >> 4,
fp.rights & 0xF
)
) AS user_rights FROM outin_rus_forum_posts fp
LEFT JOIN outin_rus_forum_post_state fs ON fp.id=fs.topic_id
LEFT JOIN outin_rus_forum_last_reply lr ON fp.id=lr.topic_id LEFT JOIN core_users_groups ug ON (ug.group_id = fp.usr_group_id AND ug.user_id = 0) WHERE fp.forum_id = 3 AND fp.topic_id = 0 AND fp.active = 1 AND (fs.type IS NULL OR fs.type!=2) AND IF( fp.owner_id = 0,
fp.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(fp.rights & 0xF0) >> 4,
fp.rights & 0xF
)
) > 0 ORDER BY fs.type DESC, updated DESC LIMIT 0,5
[17] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[18] => SELECT DISTINCT city_id, name, region, zone FROM counter_cities WHERE 644595572 BETWEEN first_long_ip AND last_long_ip ORDER BY name
[19] => SELECT b.id, IF(b.owner_id = 0, 1 , 0) as is_owner,
IF(b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) AS user_rights FROM outin_rus_banners b LEFT JOIN core_users_groups ug ON (ug.group_id = b.usr_group_id AND ug.user_id = 0) WHERE category_id = 47 AND ( ( max_showing = 0 AND ISNULL(show_from) AND ISNULL(show_to) ) OR showing < max_showing OR '2010-02-09' BETWEEN show_from AND show_to) AND active AND IF( b.owner_id = 0,
b.rights >> 8,
IF(ug.user_id IS NOT NULL ,
(b.rights & 0xF0) >> 4,
b.rights & 0xF
)
) > 0
[20] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[21] => SELECT *
FROM outin_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 outin_rus_pages USE INDEX (index_3)
WHERE parent_id IN (218,243,139,219,202,245,198,221,208,215,210,152,211,212,214,206,207,220,209,205,213,201,237,244,251,246,253,230,229) AND
active = 1
ORDER BY id
[23] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
[24] => SELECT permission_type FROM outin_rus_pages USE INDEX (PRIMARY) WHERE id = 200
[25] => SELECT M.name FROM sites AS S, modules AS M, sites_modules AS SM WHERE alias='outin' AND S.id = site_id AND M.id=module_id AND active
)
Array ( )
Array
(
[835] => $PAGE["modules"]["banners"] = new Banners('showbanner', '/banners/?', Array
(
[1] => 47
[2] =>
[3] =>
[4] =>
[5] =>
)
)
[478] => $PAGE["modules"]["poll"] = new Poll('showpoll', '/catalog/siteusers/poll-result/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
)
)
[477] => $PAGE["modules"]["forum"] = new Forum('showtopics', '/forum/?', Array
(
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
)
)
[480] => $PAGE["modules"]["banners"]->Banners('showbanner', '/banners/?', Array
(
[1] => 47
[2] =>
[3] =>
[4] =>
[5] =>
)
)
[-1] => $PAGE["modules"]["pages"] = new Pages('showmenu', '', Array
(
)
)
[-3] => $PAGE["modules"]["pages"]->Pages('showheadtitle', '', Array
(
)
)
)
Array
(
[session_cur_site_id] => 1
[session_cur_lang_id] => 1
[catalog_rates] => Array
(
[USD/USD] => 1
[RUR/RUR] => 1
[USD/RUR] => 24.4389
[RUR/USD] => 0.040918371939817
[EUR/EUR] => 1
[EUR/RUR] => 36.0083
[RUR/EUR] => 0.027771374933002
[EUR/USD] => 1.4734
[USD/EUR] => 0.67870232116194
)
)