Home News Silent PC Guide Articles Search Featured computer repairs Super Warehouse Computer Repair Atlanta President Adam Klein eMusic Friends of BSPC SilentPCReview hardCOREware.net Widescreengamer The Poker Jerk Future Looks Tech Report Hard OCP Login Form Username Password Remember me Lost Password?   Thermalright HR-01 Heatpipe Cooler Review Maximum CPU looks at the Thermalright HR-01 Heatpipe Cooler, with optional 120mm fan bracket. They did not test it as a fanless cooler, unfortunately.Write Comment (0 Comments)   Thermaltake Silent Boost RX K8 Review Hardware Logic has reviewed the Thermaltake Silent Boost RX K8, a quiet CPU cooler that uses a custom designed 90mm fan that spins at about 2200 RPM. It looks like it performed pretty well, and should be pretty quiet at that speed.Write Comment (0 Comments)   Zalman CNPS9500 LED Heatsink Review Tech Neek has a review of what I think is the best CPU cooler in existance right now: The Zalman CNPS9500. They didn't really do a lot of tests on it - it was just compared to a couple stock coolers, and no sound measurements were taken - but take my word for it; this cooler RULES! It's pretty big though.Write Comment (0 Comments)   Quiet PC D.Vine D1 Quiet Media Center Review Bit-Tech has a review on D.Vine's D1 Quiet Media Center. This is a prebuilt HTPC system based on the Pentium M platform. So it should be very quiet. Unlike the Shuttle XPC, it uses a standard desktop DVD drive, so it's up to you to make sure it spins at a slow speed during DVD playback. Still, they seemed to like it, giving it a recommendation, even though that had some problems getting it to output to their TV. Write Comment (0 Comments)   Asus A8N32-SLI Deluxe A64-939 Motherboard Silent PC Review has posted their review of the Asus A8N32-SLI Deluxe A64-939 Motherboard, which features heatpipe cooling to eliminate those REALLY annoying fans you find on most motherboards. As you'd expect from them, they looked at it from a silent PC approach, and seemed to have mixed feelings for it: "If you're looking for a SLI 939 board that does everything, and passive cooling is a necessity, this board can certainly deliver. But, if you don't need the all the features and just want a board that is quiet and cool, you'll probably want to keep looking." Asus A8N32-SLI Deluxe A64-939 Motherboard Review Write Comment (0 Comments)   More... Build a Silent PC gets an upgrade! Latest News Thermalright HR-01 Heatpipe Cooler Review Thermaltake Silent Boost RX K8 Review Zalman CNPS9500 LED Heatsink Review Quiet PC D.Vine D1 Quiet Media Center Review Asus A8N32-SLI Deluxe A64-939 Motherboard
Copyright ©2010 BuildSilentPC.com | All Rights Reserved | All trademarks used are properties of their respective owners.

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 '%News%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'News/' ORDER BY rank ASC LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&Itemid=9&id=4&lang=en&task=blogcategory' AND `oldurl` = 'News/'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 9 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1328453083' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1328453083' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT *
 FROM jos_session
 WHERE session_id = '14c511b39b876280c3d3f05936d6a9c4'
9
SELECT session_id
 FROM jos_session
 WHERE session_id = '6db238ca9e6b89b997182c6b64e2e7ea'
10
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '6db238ca9e6b89b997182c6b64e2e7ea','1328453983','','0','1' )
11
SELECT *
 FROM jos_menu
 WHERE id = 9
12
SELECT COUNT(a.id)
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_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 <= '2012-02-05 08:59' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 08:59' )
 AND ( a.catid=4 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
13
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,
 CHAR_LENGTH( a.fulltext ) AS readmore, s.published AS sec_pub,  cc.published AS sec_pub, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_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 <= '2012-02-05 08:59' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 08:59' )
 AND ( a.catid=4 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  a.created DESC
LIMIT 9
14
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
15
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
16
SELECT count(*) FROM jos_akocomment WHERE contentid='15' AND published='1'
17
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=15&lang=en&page=0&pop=1&task=view'
18
SELECT sectionid from jos_content WHERE id = 15
19
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
20
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 15
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
21
SELECT title_alias,id FROM jos_content WHERE id=15
22
SELECT   a.title_alias AS title,a.id as id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=15
23
SELECT count(*) FROM jos_akocomment WHERE contentid='14' AND published='1'
24
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=14&lang=en&page=0&pop=1&task=view'
25
SELECT sectionid from jos_content WHERE id = 14
26
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 14
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
27
SELECT title_alias,id FROM jos_content WHERE id=14
28
SELECT   a.title_alias AS title,a.id as id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=14
29
SELECT count(*) FROM jos_akocomment WHERE contentid='13' AND published='1'
30
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=13&lang=en&page=0&pop=1&task=view'
31
SELECT sectionid from jos_content WHERE id = 13
32
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 13
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
33
SELECT title_alias,id FROM jos_content WHERE id=13
34
SELECT   a.title_alias AS title,a.id as id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=13
35
SELECT count(*) FROM jos_akocomment WHERE contentid='12' AND published='1'
36
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=12&lang=en&page=0&pop=1&task=view'
37
SELECT sectionid from jos_content WHERE id = 12
38
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 12
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
39
SELECT title_alias,id FROM jos_content WHERE id=12
40
SELECT   a.title_alias AS title,a.id as id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=12
41
SELECT count(*) FROM jos_akocomment WHERE contentid='11' AND published='1'
42
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=11&lang=en&page=0&pop=1&task=view'
43
SELECT sectionid from jos_content WHERE id = 11
44
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 11
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
45
SELECT title_alias,id FROM jos_content WHERE id=11
46
SELECT   a.title_alias AS title,a.id as id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=11
47
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'
48
SELECT m.* FROM jos_menu AS m
WHERE menutype='topmenu' AND published='1' AND access <= '0' AND parent='0'
ORDER BY ordering
49
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 = 9 )
 ORDER BY ordering
50
SELECT a.id, a.title, a.sectionid, a.catid
 FROM jos_content AS a
 LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-05 08:59' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 08:59' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 5