LINE 59: SELECT mid, title, custom_title, active, view, blocks, version FROM cms_modules WHERE LOWER(title)='news'
modules/News/article.php
LINE 26: SELECT s.*, c.title as cattitle, t.topicimage, t.topictext FROM cms_stories s
LEFT JOIN cms_stories_cat c ON c.catid=s.catid
LEFT JOIN cms_topics t ON t.topicid=s.topic WHERE s.sid=286
LINE 31: UPDATE cms_stories SET counter=counter+1 WHERE sid=286
LINE 86: SELECT topicid, topicimage, topictext from cms_topics WHERE topicid IN (35)
LINE 156: SELECT name, url FROM cms_related WHERE tid=35
LINE 163: SELECT sid, title FROM cms_stories WHERE topic=35 ORDER BY counter DESC LIMIT 0,1
includes/functions/display.php
LINE 114: SELECT bid, bposition, bkey, title, content, url, blockfile, view, refresh, time FROM cms_blocks WHERE active='1' AND (bposition='l' OR bposition='r') ORDER BY weight ASC
LINE 318: SELECT * FROM cms_banner WHERE type='0' AND active='1' ORDER BY RAND() LIMIT 0,1
LINE 327: UPDATE cms_banner SET impmade=963884+1 WHERE bid='2'
blocks/block-Last_5_Articles.php
LINE 29: SELECT sid, title, comments, counter FROM cms_stories ORDER BY sid DESC LIMIT 0,5
blocks/block-Advertising.php
LINE 21: SELECT COUNT(*) FROM cms_banner WHERE type='1' AND active='1'
blocks/block-Total_Hits.php
LINE 21: SELECT SUM(count) FROM cms_counter WHERE type='os'
includes/counter.php
LINE 76: UPDATE cms_counter SET count=count+1 WHERE (var='Firefox' AND type='browser') OR (var='Other' AND type='os')
LINE 77: UPDATE cms_stats_hour SET hits=hits+1 WHERE (year='2008') AND (month='05') AND (date='10') AND (hour='20')
includes/nbbcode.php
LINE 252: SELECT * FROM cms_bbsmilies
modules/coppermine/include/load.inc
LINE 81: SELECT prefix, dirname FROM cms_cpg_installs ORDER BY cpg_id
includes/coppermine/init.inc
LINE 54: SELECT * FROM cms_cpg_config
LINE 74: SELECT * FROM cms_cpg_usergroups WHERE group_id = 3
blocks/block-CPG-scroll-Last_pictures_thumb.php
LINE 39: SELECT pid, filepath, filename, p.aid, p.title FROM cms_cpg_pictures AS p INNER JOIN cms_cpg_albums AS a ON (p.aid = a.aid AND visibility IN (0,3)) WHERE approved='YES' GROUP BY pid ORDER BY pid DESC LIMIT 10
blocks/block-CPG-Top_rate_pictures.php
LINE 34: SELECT pid, filepath, filename, p.aid, pic_rating, p.votes, p.title FROM cms_cpg_pictures AS p INNER JOIN cms_cpg_albums AS a ON (p.aid = a.aid AND visibility IN (0,3)) WHERE approved='YES' AND p.votes >= '1' GROUP BY pid ORDER BY ROUND((pic_rating+1)/2000) DESC, p.votes DESC LIMIT 5
blocks/block-CPG-scroll-Random_pictures.php
LINE 37: SELECT COUNT(*) FROM cms_cpg_pictures as p INNER JOIN cms_cpg_albums AS a ON (p.aid = a.aid AND visibility IN (0,3)) WHERE approved='YES' GROUP BY pid
LINE 56: SELECT pid, filepath, filename, p.aid, p.title FROM cms_cpg_pictures AS p INNER JOIN cms_cpg_albums AS a ON (p.aid = a.aid AND visibility IN (0,3)) WHERE approved='YES' GROUP BY pid ORDER BY RAND() DESC LIMIT 4
includes/cmsinit.inc
CMS Notice line 179: sendmail_from:webmaster@candycanechildren.com