Tutor Management Education Management Contact Us Home Login Form Username Password Remember me Forgotten your password?   Home Contact Us Contact Us Director Position PO Box 1412 Atlanta GA United States 30024 770-614-0200 Download information as a VCard Send an Email to this Contact: Enter your name: E-mail address: Message subject: Enter your message: Email a copy of this message to your own address [ Back ]   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='3' LIMIT 1
3
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='3' LIMIT 1
4
DELETE FROM mos_session
WHERE (time < 1283724299)
5
SELECT * FROM mos_session WHERE session_id='c630b326a7eb4901f4bf9a63001ff009'
6
SELECT session_id FROM mos_session WHERE session_id=MD5('d04b104c1c3d9e1609c98a7a016647f6')
7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`oid` ) VALUES ( '7e1ac025aafbc64da0566a2650c6bd2f','1283733299','','0','1','0' )
8
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='0'
9
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='0'
10
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='1'
11
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='1'
12
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='2'
13
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='2'
14
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
15
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
16
SELECT access FROM mos_menu WHERE id='3'
17
SELECT *, COUNT(a.id) AS numlinks
 FROM mos_categories AS cc
 LEFT JOIN mos_contact_details AS a ON a.catid = cc.id
 WHERE a.published='1'
 AND cc.section='com_contact_details'
 AND cc.published='1'
 AND a.access <= '0'
 AND cc.access <= '0'
 GROUP BY cc.id
 ORDER BY cc.ordering
18
SELECT a.id AS value, CONCAT_WS( ' - ', a.name, a.con_position ) AS text
 FROM mos_contact_details AS a
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 WHERE a.published = '1'
 AND cc.published = '1'
 AND a.access <=0
 AND cc.access <=0
 ORDER BY a.default_con DESC, a.ordering ASC
19
SELECT *
 FROM mos_contact_details
 WHERE published = '1'
 AND id = 1
 AND access <=0
20
SELECT * FROM mos_menu WHERE id='3'
21
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
22
SELECT * FROM mos_components WHERE id='17'
23
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 = '3' OR mm.menuid = '0')
ORDER BY ordering
24
SELECT m.* FROM mos_menu AS m
left join mos_graccess_groupmenu as gra on gra.menuid=m.id or gra.menuid=0
left join mos_graccess_usergroup as usr on gra.groupid=usr.groupid 
WHERE menutype='topmenu' AND published='1' AND access <= '0' 
AND (usr.userid=0 or usr.userid=0 )
ORDER BY parent,ordering
25
SELECT name FROM mos_users WHERE id = 0
26
SELECT *
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
27
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering