South Texas Council BSA National   Home Links Contact Us Advancement Training Units Camps Login Form Username Password Remember me Lost Password? Home District Training Committee DeLeon District Training Committee will meet Tuesday, July 29, 2008 at 7 pm in the Community Room at the Victoria Mall.   Junior Leader Training DeLeon District will present Junior Leader Training this fall.  The course will be all day Saturday and for each troop attending, there will need to be one adult leader.   Stay tuned to this web site for additional information.   OA Summer Lodge Meeting Summer Lodge Meeting is scheduled for August 8-10 at Camp K.  Registration begins Friday evening at 6:30 with the Pre-Ordeal Ceremony scheduled for 9:30 PM.   Guide to Safe Scouting Guide to Safe Scouting, a required course, will be offerred at Camp K in the Training Center on September 6, 2008.  For additional info, please go to the council web site under news and events.   Outdoor Leader Training Outdoor Leader Training is scheduled for the weekend of Sept. 13th.  BALOO will be all day Saturday. and Outdoor Leader Skills for Boys Scouts and Webelo Leaders will be Sat. and Sun.  For additional info including registration form please go to the council web site and click on News and Events.    New Leader Essentials/Cub Scout Specifics Mark your calendars for July 19, 2008.  DeLeon District will be conducting New Leader Essentials and Cub Scout Leader Specific Training. The classes will be conducted in the Community Room at the Victoria Mall.  Registration  Read more...   New Philmont Requirement Philmont has a new training requirements effective in 2008.  These are Wilderness First Aid Basics and When Care Is Delayed.  These courses will be offered by the Crossroads Chapter American Red Cross.  For additional information please call  the Red Cross at 573-2674 or contact Katrin McDonough via the training link on this web site. Read more...   Training Cubmasters, Scoutmasters and Scouters, If you need training please contact me via the link on the webpage so that we can set this up.   2007 Scouting for Food Scouting for Food 2007 was a great success!  Thanks to Lydia Huber for coordinating our efforts. Read more for the totals by Unit. Read more...   More... Nuts for Knots! << Start < Prev 1 2 Next > End >> Results 1 - 10 of 11

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 = 1 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM mos_session
 WHERE (
 ( time < '1216793841' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1216882941' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM mos_menu
 WHERE id = 1
6
SELECT COUNT(a.id)
 FROM mos_content AS a
 INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN mos_categories AS cc ON cc.id = a.catid
 INNER JOIN mos_sections AS s ON s.id = a.sectionid
 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.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 s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
7
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
 FROM mos_content AS a
 INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN mos_categories AS cc ON cc.id = a.catid
 INNER JOIN mos_sections AS s ON s.id = a.sectionid
 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.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 s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  f.ordering
LIMIT 10
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 = 1 )
 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