!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

Latest News
!T_(buffered)

Popular
!T_(buffered)

Home  Getting Started

Getting Started :: Explanatory Note -- This set of content items is being used to demonstrate one way to order content logically and display it on the page. You see here an example of a "flat" hierarchy of content. There is only one level of content items, so we created a Section named "Getting Started" and then we created within that Section a Category with the same name ("Getting Started"). We loaded the content items into the category and then created a Main Menu item named "Getting Started". When we created that Menu Item we chose the "Table - Content Category" format option, which gives us the table layout containing the content items, below. On the Content Items in this Category we have used the Content Items Parameters tab to enable the Item Rating option. Note the Content Item Getting the Most Out of Your Mambo Site demonstrates how to create multi-page content. ::   T_(Эта Категория пуста)

!T_(buffered)

!T_(buffered)

!T_(buffered)

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

1
SELECT template, client_id, menuid FROM mos_templates_menu WHERE (client_id=0 or client_id=1) AND (menuid=0 OR menuid=27) ORDER BY client_id, menuid
2
DELETE FROM mos_session WHERE (time<1260219275 AND guest>=0) OR (time<1260216575 AND guest<0)
3
SELECT * FROM mos_session WHERE session_id='63179769d7ea996ccf21788de8e4446e'
4
SELECT session_id FROM mos_session WHERE session_id=MD5('6b863f463662769cae052bd9c211f569')
5
INSERT INTO mos_session ( `session_id`,`time`,`userid`,`username`,`gid`,`guest` ) VALUES ( '40fe22966fb876eefec043b1cd04b028','1260220175','0','','0','1' ) 
6
SELECT folder, element, published, params, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0
ORDER BY ordering
7
SELECT * FROM mos_menu ORDER BY name
8
SELECT * FROM mos_categories WHERE id='16'
9
SELECT c.*, COUNT( b.id ) AS numitems
 FROM mos_categories AS c
 LEFT JOIN mos_content AS b ON b.catid = c.id 
 AND b.state='1'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-12-08 05:09:35' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-12-08 05:09:35' )
 AND b.access <= '0'
 WHERE c.section = '4'
 AND c.published='1'
 AND c.access <= '0'
 GROUP BY c.id
 HAVING COUNT( b.id ) > 0
 ORDER BY c.ordering
10
SELECT COUNT(a.id) as numitems
 FROM mos_content AS a
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.catid='16' 
 AND a.state='1'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-12-08 05:09:35' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-12-08 05:09:35' )
 AND a.access<='0'
 AND '0'<='0'
 ORDER BY a.created DESC
11
SELECT a.id, a.title, a.hits, a.created_by, a.created_by_alias, a.created AS created, a.access, u.name AS author, a.state, g.name AS groups
 FROM mos_content AS a
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.catid='16' 
 AND a.state='1'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-12-08 05:09:35' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-12-08 05:09:35' )
 AND a.access<='0'
 AND '0'<='0'
 ORDER BY a.created DESC
 LIMIT 0, 50
12
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 = '27' OR mm.menuid = '0')
ORDER BY ordering
13
SELECT group_id FROM mos_core_acl_aro_groups WHERE name='Registered'
14
SELECT group_id FROM mos_core_acl_aro_groups WHERE name='Author'
15
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-12-08 05:09:35' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-12-08 05:09:35' )
 AND a.access <= '0'
 ORDER BY a.created DESC LIMIT 5
16
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-12-08 05:09:36' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-12-08 05:09:36' )
 AND a.access <= '0'
 ORDER BY a.hits DESC LIMIT 5
17
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-12-08 05:09:36') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-12-08 05:09:36')
 AND catid='3' 
 ORDER BY a.ordering
 
18
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
19
SELECT * FROM mos_banner WHERE showBanner=1 
LIMIT 2,1
20
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='5'
21
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
22
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'