South Texas Council BSA National   Top Module Empty Home Links Contact Us Advancement Training Units Camps Home Units Units PDF  | Print | Deleon District Units   Unit Charter       Pack104 Vickers School   Pack114 Deleon School   Pack 364 Our Lady Victory School         Troop 363 Holy Family Church   Troop 364 Our Lady Victory School   Troop 368  Victoria Kiwanis Club

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM mos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM mos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 42 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM mos_session
 WHERE (
 ( time < '1216793849' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1216882949' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM mos_menu
 WHERE id = 42
6
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
 s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
 s.id AS sec_id, cc.id as cat_id
 FROM mos_content AS a
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope = 'content'
 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.id = 34 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-07-24 02:17' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-07-24 02:17' )
 AND a.access <= 0
7
UPDATE mos_content
 SET hits = ( hits + 1 )
 WHERE id = '34'
8
SELECT folder, element, published, params
 FROM mos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
9
SELECT a.*
 FROM mos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
10
SELECT id, title, module, position, content, showtitle, params
 FROM mos_modules AS m
 INNER JOIN mos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 42 )
 ORDER BY ordering
11
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
12
SELECT id
 FROM mos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
13
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
14
SELECT id, name, link, parent, type, menutype, access
 FROM mos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering