!T_(buffered)

• Contact Us
• Links
• Home

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

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

Home  FAQs

Frequently Asked Questions (FAQs) ::Explanatory Notes - The Main Menu link "FAQs" is set to display "Table - Content Section". The list below is a list of the Categories inside the Section named "FAQs". Inside each Category are Content Items. ::

!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=32) ORDER BY client_id, menuid
2
DELETE FROM mos_session WHERE (time<1260219216 AND guest>=0) OR (time<1260216516 AND guest<0)
3
SELECT * FROM mos_session WHERE session_id='3ae28591a55da852ca76a5cc9522c473'
4
SELECT session_id FROM mos_session WHERE session_id=MD5('9976ed8e2b278b6024f410a82fbd2c57')
5
INSERT INTO mos_session ( `session_id`,`time`,`userid`,`username`,`gid`,`guest` ) VALUES ( '2b4b0bfffcd26e9a0ba79da4b83268d8','1260220116','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_sections WHERE id='3'
9

		SELECT a.*, COUNT( b.id ) AS numitems
		FROM mos_categories AS a
		LEFT JOIN mos_content AS b ON b.catid = a.id 
 AND b.state = '1'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-12-08 05:08:36' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-12-08 05:08:36' )
		WHERE a.section = '3' 
 AND a.published = '1'
		AND a.access <= 0
		GROUP BY a.id
		
 HAVING COUNT( b.id ) > 0
		ORDER BY a.ordering
10
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 = '32' OR mm.menuid = '0')
ORDER BY ordering
11
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:08:36') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-12-08 05:08:36')
 AND catid='3' 
 ORDER BY a.ordering
 
12
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
13
SELECT * FROM mos_banner WHERE showBanner=1 
LIMIT 1,1
14
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='4'
15
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
16
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'