!T_(buffered)

• Contact Us
• Links
• Home

!T_(buffered) Home Getting Started FAQs The Mambo License Blog News Feeds Wrapper Links Advanced Search ????????

Other Menu
!T_(buffered) Mambo Foundation Mambo Forums Mambo Docs Site The Source Administrator

Login Form
!T_(buffered) T_(Имя) T_(Пароль) T_(Запомнить) T_(Вспомнить пароль) T_(Нет регистрации?) T_(Создать)

Syndicate
!T_(buffered)

Latest News
!T_(buffered)

Popular
!T_(buffered)

T_(Нечего отображать)

!T_(buffered)

!T_(buffered)

Polls
!T_(buffered) The most influential person in technology in the last 25 years is... Steve Jobs Bill Gates Linus Torvalds Tim Berners-Lee Scott Adams

Who's Online
!T_(buffered) T_(На сайте 1 гость)

!T_(buffered)

Mambo is Free Software released under the GNU/GPL License.

1
SELECT * FROM mos_menu ORDER BY name
2
SELECT template, client_id, menuid FROM mos_templates_menu WHERE (client_id=0 or client_id=1) AND (menuid=0 OR menuid=1) ORDER BY client_id, menuid
3
DELETE FROM mos_session WHERE (time<1257595629 AND guest>=0) OR (time<1257592929 AND guest<0)
4
SELECT * FROM mos_session WHERE session_id='db001605ccc3a52d8850d7a7d6ec521f'
5
SELECT session_id FROM mos_session WHERE session_id=MD5('b6283a354a70c8b51dc35e59f95c91e7')
6
INSERT INTO mos_session ( `session_id`,`time`,`userid`,`username`,`gid`,`guest` ) VALUES ( 'd38df843e7a8276860360bfd84975540','1257596529','0','','0','1' ) 
7
SELECT folder, element, published, params, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0
ORDER BY ordering
8
SELECT group_id FROM mos_core_acl_aro_groups WHERE name='Registered'
9
SELECT group_id FROM mos_core_acl_aro_groups WHERE name='Author'
10
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM mos_content AS a
 INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 LEFT JOIN mos_sections AS s ON s.id = a.sectionid
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.state = '1'
 AND a.access <= '0'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-11-07 20:22:09'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-11-07 20:22:09' )
 AND a.access <= 0
 ORDER BY f.ordering
11
SELECT id, title, module, position, content, showtitle, params, published, m.access, m.groups
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '1' OR mm.menuid = '0')
ORDER BY ordering
12
SELECT p.id, p.title
FROM mos_polls AS p, mos_poll_menu AS pm
WHERE (pm.menuid='1' OR pm.menuid='0') AND p.id=pm.pollid
AND p.published=1
13
SELECT id, text FROM mos_poll_data
WHERE pollid='15' AND text <> ''
ORDER BY id
14
SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype='')
15
SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'
16
SELECT group_id FROM mos_core_acl_aro_groups WHERE name='Registered'
17
SELECT group_id FROM mos_core_acl_aro_groups WHERE name='Author'
18
SELECT a.id, a.title, a.sectionid, a.catid
 FROM mos_content AS a
 LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
 WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-11-07 20:22:10' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-11-07 20:22:10' )
 AND a.access <= '0'
 ORDER BY a.created DESC LIMIT 5
19
SELECT a.id, a.title, a.sectionid, a.catid, a.hits
 FROM mos_content AS a
 LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
 WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-11-07 20:22:10' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-11-07 20:22:10' )
 AND a.access <= '0'
 ORDER BY a.hits DESC LIMIT 5
20
SELECT a.id
 FROM mos_content AS a
 INNER JOIN mos_categories AS b ON b.id = a.catid
 WHERE a.state = 1
 AND a.access <= '0' AND b.access <= '0'
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-11-07 20:22:10') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-11-07 20:22:10')
 AND catid='3' 
 ORDER BY a.ordering
 
21
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
22
SELECT * FROM mos_banner WHERE showBanner=1 
LIMIT 2,1
23
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='5'
24
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
25
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'