Home Board of Directors Continuing Education Online Forms Advanced Search How to Become a CCA CCA Credential Forms Find an official CCA Contact Us Links Exams/Announcements Articles / News Presentations                   Online Forms Course Approval Request This form is used for meeting sponsor that would like to apply for CCA credits for a continuing education meeting. Reporting Missing CEU's This form is used by the individual CCA member to self report any courses or self study that is missing from the on-line printout of their continuing education record. Blank Sign in Form This form can be used by a meeting sponsor that has lost the CE sign-in sheet or for anyone that has a pending CE meeting accreditation approval that has not been received prior to the meeting. Last Updated 01/06/2010

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='38' LIMIT 1
3
DELETE FROM mos_session
WHERE (time < 1283766380)
4
SELECT * FROM mos_session WHERE session_id='10cfe79fb5107d3818e4e4210921a474'
5
SELECT session_id FROM mos_session WHERE session_id=MD5('4450c49f4acae3aa9e5cbf0b9f8d128e')
6
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'fd757fe789d1a0eec411a7aa93aae4d3','1283767280','','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='38'
10
SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups
 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_content_rating AS v ON a.id = v.content_id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.id='26' AND (a.state = '1' OR a.state = '-1')
	AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-06 05:01:20')
	AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-06 05:01:20')
 AND a.access <= 0
11
UPDATE mos_content SET hits=(hits+1) WHERE id='26'
12
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
13
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
14
SELECT * FROM mos_mambots WHERE id='16'
15
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
16
SELECT * FROM mos_components WHERE id='17'
17
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 = '38' OR mm.menuid = '0')
ORDER BY ordering
18
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
19
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=25'
20
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=25'
21
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=27'
22
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=27'
23
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=26'
24
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=26'
25
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=30'
26
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=30'
27
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=31'
28
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=31'
29
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=32'
30
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=32'
31
SELECT m.* FROM mos_menu AS m
WHERE menutype='othermenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering