• Home
• Contest News
• NMMLP
• Contact Us

Main Menu

Home

How to Enter

Contest Rules

Entry Forms

Scripts & Storyboards

Counter Marketing

About Tobacco

After the contest

2006 Winners

Sponsors

Contact Us

Login

Please login to access all features on this site and receive contest updates.

Username Password Remember me

Lost Password?

Privacy policy

Entry forms We hope to be able to run the contest again in Fall 2008, if funding is available.  Please bookmark this page and visit us again soon. In the meantime, you can browse info from last year's contest. ---------------------------------------------------------------------------------------------------- All scripts and storyboards must be accompanied by a contest entry form.   > Download an entry form here  Or, contact us and we'll mail you an entry form. If you're under 18, a parent or legal guardian must sign the entry form.  Mail the entry form and your script/storyboard to:  Talk Back to Big Tobacco! c/o New Mexico Media Literacy Project 6400 Wyoming Blvd. NE Albuquerque NM 87109 Deadline: All entries must be postmarked by December 14, 2007.  Questions? Post a comment below or contact us at: This e-mail address is being protected from spam bots, you need JavaScript enabled to view it 505-858-8897 Comments (1) ... written by Ian Naranjo , November 30, 2007 Tabacco is an very bad product that destroys people. So remember try to stay away from tabacco before that evil desteroys you. Write comment Comment Name   Add Comment Jom Comment 0.095 Serialize: Jom Comment 0.095 Building Jom COmment: Jom Comment 0.098 Fetch Cache: 27 queries executed   < Prev   Next >

Rate these ads! Watch, listen to &    discuss real ads Site tools Search Tell a friend Downloads Your photo here

© 2008 Talk Back to Big Tobacco! Script & Storyboard Contest

Joomla! is Free Software released under the GNU/GPL License.

Designed by Red Evolution

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT `id`,`link` FROM jos_menu  WHERE ((`name` LIKE '%entry forms.html%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'entry-forms.html' LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&task=view&id=23&Itemid=38'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 38 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1210686180' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1210686180' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT `params` FROM `jos_mambots` WHERE `element`='azrul.system'
9
SELECT value FROM jos_jomcomment_config WHERE name='all'
10
SELECT id FROM jos_sections
11
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
12
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
13
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
14
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
15
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
16
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
17
SELECT *
 FROM jos_menu
 WHERE id = 38
18
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 jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = 'content'
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.id = 23 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-05-13 06:58' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-05-13 06:58' )
 AND a.access <= 0
19
SELECT a.id
 FROM jos_content AS a
 WHERE a.catid = 14
 AND a.state = 1
 AND a.access <= 0 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-05-13 06:58' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-05-13 06:58' )
 ORDER BY a.ordering
20
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '23'
21
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
22
SELECT a.*, b.created_by FROM jos_jomcomment as a, jos_content as b 
						            WHERE a.`contentid`='23' 
						                AND ( a.`option`='com_content' OR a.`option`='com_myblog') 
						                AND a.`published`='1' 
						                AND b.`id`=a.`contentid`  ORDER BY date DESC, id DESC
23
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_jomcomment&jc_task=rss&contentid=23&opt=com_content'
24
SELECT * FROM jos_jomcomment_tb WHERE contentid='23' AND published=1 AND `option`='com_content'  ORDER BY id DESC
25
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_jomcomment&task=trackback&id=23&opt=com_content'
26
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_jomcomment&task=trackback&id=23&opt=com_content'
27
SELECT count(*) FROM jos_jomcomment_tb WHERE contentid='23' AND published=1 AND `option`='com_content'  ORDER BY id DESC
28
SELECT * FROM jos_jomcomment_mailq WHERE status='0' LIMIT 0 , 10
29
select media from jos_media where id = 23
30
SELECT params
 FROM jos_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'
31
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=21&Itemid=38'
32
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=36&Itemid=38'
33
SELECT a.*
 FROM jos_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'
34
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_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 = 38 )
 ORDER BY ordering
35
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
36
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
37
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=section&id=1&Itemid=2'
38
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_contact&Itemid=3'
39
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
40
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_frontpage&Itemid=1'
41
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
42
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=22'
43
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=22&Itemid=37'
44
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=21'
45
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=21&Itemid=36'
46
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=23'
47
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=23&Itemid=38'
48
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=section&id=10&Itemid=29'
49
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=section&id=7&Itemid=51'
50
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=section&id=11&Itemid=64'
51
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=47&Itemid=75'
52
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=72'
53
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=72&Itemid=128'
54
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=46'
55
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=46&Itemid=74'
56
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_contact&Itemid=3'
57
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_registration&task=lostPassword'
58
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=23&Itemid=38'
59
SELECT *
 FROM jos_banner
 WHERE showBanner=1
60
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 3
61
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_banners&task=click&bid=3'
62
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Rate these ads!'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
63
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=blogcategory&id=30&Itemid=77'
64
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Site tools'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
65
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_search&Itemid=82'
66
SELECT name FROM jos_menu WHERE link = 'index.php?option=com_recommend'
67
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_docman&Itemid=110'
68
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=64'
69
SELECT oldurl

	FROM jos_redirection

	WHERE newurl = 'index.php?option=com_content&task=view&id=64&Itemid=126'