Website Inter-data Your slogan here   Home News News General  ( 24 items )   Copyright 2000 - 2005 Miro International Pty Ltd. All rights reserved. Mambo is Free Software released under the GNU/GPL License.

1
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='2' LIMIT 1
3
DELETE FROM mos_session
WHERE (time < 1534470479)
4
SELECT * FROM mos_session WHERE session_id='856c3720adc21adcc3fc40b9d1266aa5'
5
SELECT session_id FROM mos_session WHERE session_id=MD5('3f90cd61b08f138d85a64b08dc98d79d')
6
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'e7488a724d47e7a41715de44fedb4753','1534471379','','0','1' )
7
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
8
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
9
SELECT access FROM mos_menu WHERE id='2'
10
SELECT * FROM mos_menu WHERE id='2'
11
SELECT * FROM mos_sections WHERE id='1'
12
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 <= '2018-08-17 10:02:59' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-08-17 10:02:59' )
		WHERE a.section = '1' 
 AND a.published = '1'
		GROUP BY a.id
		
 HAVING COUNT( b.id ) > 0
		ORDER BY a.ordering
13
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
14
SELECT * FROM mos_components WHERE id='17'
15
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '2' OR mm.menuid = '0')
ORDER BY ordering
16
SELECT *
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
17
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering