<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>molotov.bliss</title>
	
	<link>http://www.molotovbliss.com/blog</link>
	<description>Mb | Magento | Android | Demo Scene | Drum'n'Bass | PHP | Design</description>
	<lastBuildDate>Wed, 09 Dec 2009 08:31:41 +0000</lastBuildDate>
	<generator>http://wordpress.org/?v=2.9</generator>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
			<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/Molotovbliss" /><feedburner:info uri="molotovbliss" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com" /><geo:lat>32.92704</geo:lat><geo:long>-97.250609</geo:long><item>
		<title>Magento Commerce Error Reporting Tip</title>
		<link>http://feedproxy.google.com/~r/Molotovbliss/~3/VDxQUal_xJo/</link>
		<comments>http://www.molotovbliss.com/blog/general/magento-commerce-404-whoops-our-bad-error-reporting/#comments</comments>
		<pubDate>Wed, 09 Dec 2009 08:29:51 +0000</pubDate>
		<dc:creator>B00MER</dc:creator>
				<category><![CDATA[General]]></category>
		<category><![CDATA[Magento Commerce]]></category>
		<category><![CDATA[Magento]]></category>
		<category><![CDATA[tips]]></category>
		<category><![CDATA[tricks]]></category>

		<guid isPermaLink="false">http://www.molotovbliss.com/blog/?p=761</guid>
		<description><![CDATA[Whoops, our bad&#8230;
The page you requested was not found, and we have a fine guess why.
If you typed the URL directly, please make sure the spelling is correct.
If you clicked on a link to get here, the link is outdated.
What can you do?
Well, you can start by looking in /var/report/ and view the file that [...]]]></description>
			<content:encoded><![CDATA[<blockquote><p><em>Whoops, our bad&#8230;<br />
The page you requested was not found, and we have a fine guess why.<br />
If you typed the URL directly, please make sure the spelling is correct.<br />
If you clicked on a link to get here, the link is outdated.</p>
<p><strong>What can you do?</strong></em></p></blockquote>
<p>Well, you can start by looking in /var/report/ and view the file that corresponds with the error ID on the web address. <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' title="Magento Commerce Error Reporting Tip" /> </p>
<p>This is just a merely nice page to display to end users as not to display any nasty php errors to them.  However looking at these reports can lead useful if your needing to find out more details on whats causing the issues.</p>
<p>Didn&#8217;t realize this until tonight, I must be slow&#8230; <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_confused.gif' alt=':?' class='wp-smiley' title="Magento Commerce Error Reporting Tip" /> but thought I would share. <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_wink.gif' alt=':wink:' class='wp-smiley' title="Magento Commerce Error Reporting Tip" /> </p>

<p><strong>Possibly Related Posts:</strong></p>
<ul>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/eclipse-zend-studio-zendserver-android-sdk-how-to-install/">Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/magento-paypal-standard-ipn-double-totals-bug-1-3-2-3-fix/">Magento: Paypal Standard IPN Double Totals Bug 1.3.2.3 + fix</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/iphone-magento-theme-compatible-with-android/">iPhone Magento theme compatible with Android</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/706/">Magento Tutorial Video: Display Product Images in Blocks and Pages</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/magento-phoning-home-to-big-brothervarien/">Magento: Phoning home to Big Brother/Varien?</a></li>
</ul><br />
<img src="http://feeds.feedburner.com/~r/Molotovbliss/~4/VDxQUal_xJo" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.molotovbliss.com/blog/general/magento-commerce-404-whoops-our-bad-error-reporting/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://www.molotovbliss.com/blog/general/magento-commerce-404-whoops-our-bad-error-reporting/</feedburner:origLink></item>
		<item>
		<title>Android SDK 2.01 Emu WebKit User Agent</title>
		<link>http://feedproxy.google.com/~r/Molotovbliss/~3/7B_jUYzei7c/</link>
		<comments>http://www.molotovbliss.com/blog/android-os-g1-sdk/android-sdk-2-01-emu-webkit-user-agent/#comments</comments>
		<pubDate>Tue, 08 Dec 2009 00:06:06 +0000</pubDate>
		<dc:creator>B00MER</dc:creator>
				<category><![CDATA[Android]]></category>
		<category><![CDATA[Web Development]]></category>
		<category><![CDATA[AndroidOS]]></category>
		<category><![CDATA[g1]]></category>
		<category><![CDATA[tips]]></category>

		<guid isPermaLink="false">http://www.molotovbliss.com/blog/?p=752</guid>
		<description><![CDATA[
I got curious what the Android 2.01 SDK User Agent was returning after toying around with the iPhone theme for Magento.  It appears Apple has standardized the UserAgent and &#8220;Mobile Safari&#8221; as a condition should enable future detection of Webkit on any device without conditioning more. Here&#8217;s the full user agent being returned

?View Code HTML1
Mozilla/5.0 (Linux; U; Android [...]]]></description>
			<content:encoded><![CDATA[<p><a href="http://www.molotovbliss.com/blog/wp-content/uploads/2009/12/user-agent-2.01-android-emu.jpg"><img class="alignnone size-medium wp-image-753" title="user-agent-2.01-android-emu" src="http://www.molotovbliss.com/blog/wp-content/uploads/2009/12/user-agent-2.01-android-emu-300x211.jpg" alt="user agent 2.01 android emu 300x211 Android SDK 2.01 Emu WebKit User Agent" width="300" height="211" /></a></p>
<p>I got curious what the Android 2.01 SDK User Agent was returning after toying around with the <a href="http://www.molotovbliss.com/blog/magento-commerce/iphone-magento-theme-compatible-with-android/">iPhone theme for Magento</a>.  It appears Apple has standardized the UserAgent and &#8220;Mobile Safari&#8221; as a condition should enable future detection of Webkit on any device without conditioning more. Here&#8217;s the full user agent being returned</p>

<div class="wp_codebox_msgheader"><span class="right"><sup><a href="http://www.ericbess.com/ericblog/2008/03/03/wp-codebox/#examples" target="_blank" title="WP-CodeBox HowTo?"><span style="color: #99cc00">?</span></a></sup></span><span class="left"><a href="javascript:;" onclick="javascript:showCodeTxt('p752code2'); return false;">View Code</a> HTML</span><div class="codebox_clear"></div></div><div class="wp_codebox"><table width="100%" ><tr id="p7522"><td class="line_numbers"><pre>1
</pre></td><td class="code" id="p752code2"><pre class="html" style="font-family:monospace;">Mozilla/5.0 (Linux; U; Android 2.0.1; en-us;sdk Build/ES54) AppleWebKit/530.17+ (KHTML, like Gecko) Version/4.0 Mobile Safari/530.17</pre></td></tr></table></div>


<p><strong>Possibly Related Posts:</strong></p>
<ul>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/eclipse-zend-studio-zendserver-android-sdk-how-to-install/">Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/iphone-magento-theme-compatible-with-android/">iPhone Magento theme compatible with Android</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/magento-phoning-home-to-big-brothervarien/">Magento: Phoning home to Big Brother/Varien?</a></li>
<li><a href="http://www.molotovbliss.com/blog/web-dev/selecting-30-days-or-older-entries-using-mysql-datetime-field/">Selecting 30 days or older entries using MySQL DateTime field</a></li>
<li><a href="http://www.molotovbliss.com/blog/general/x-cart-creators-release-gears-based-ecwid-e-commerce-widgets-in-beta/">X-Cart creators release Gears based Ecwid E-Commerce Widgets in Beta</a></li>
</ul><br />
<img src="http://feeds.feedburner.com/~r/Molotovbliss/~4/7B_jUYzei7c" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.molotovbliss.com/blog/android-os-g1-sdk/android-sdk-2-01-emu-webkit-user-agent/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.molotovbliss.com/blog/android-os-g1-sdk/android-sdk-2-01-emu-webkit-user-agent/</feedburner:origLink></item>
		<item>
		<title>Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE</title>
		<link>http://feedproxy.google.com/~r/Molotovbliss/~3/UwSxwj-rJNY/</link>
		<comments>http://www.molotovbliss.com/blog/magento-commerce/eclipse-zend-studio-zendserver-android-sdk-how-to-install/#comments</comments>
		<pubDate>Sun, 06 Dec 2009 11:08:48 +0000</pubDate>
		<dc:creator>B00MER</dc:creator>
				<category><![CDATA[Android]]></category>
		<category><![CDATA[Magento Commerce]]></category>
		<category><![CDATA[MySQL]]></category>
		<category><![CDATA[Web Development]]></category>
		<category><![CDATA[Eclipse]]></category>
		<category><![CDATA[Magento]]></category>
		<category><![CDATA[programming]]></category>
		<category><![CDATA[SDK]]></category>
		<category><![CDATA[tips]]></category>

		<guid isPermaLink="false">http://www.molotovbliss.com/blog/?p=733</guid>
		<description><![CDATA[
Recently installed the Zend Studio for Eclipse and took it upon myself to get Android Development setup as well.  I also found Magento works best with ZendServer, although it does require a few work arounds to get Magento to work with ZendServer.
However with that being said I&#8217;m pretty much happy to have one IDE that I [...]]]></description>
			<content:encoded><![CDATA[<p><a href="http://www.molotovbliss.com/blog/wp-content/uploads/2009/12/zend-android.jpg"><img class="alignnone size-full wp-image-739" title="zend-android" src="http://www.molotovbliss.com/blog/wp-content/uploads/2009/12/zend-android.jpg" alt="zend android Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE" width="444" height="156" /></a></p>
<p>Recently installed the Zend Studio for Eclipse and took it upon myself to get Android Development setup as well.  I also found Magento works best with ZendServer, although it does require a few <a href="http://www.magentocommerce.com/boards/viewthread/4337/P15/#t141895">work arounds to get Magento to work with ZendServer</a>.</p>
<p>However with that being said I&#8217;m pretty much happy to have one IDE that I can do both Web Development, and Android Development in one IDE!</p>
<p>Now if only I can setup C# development, and Eclipse not be such a resource/memory hog.</p>
<p>ZendServer Community Edition<br /> <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_arrow.gif' alt=':arrow:' class='wp-smiley' title="Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE" /> <a href="http://www.zend.com/en/products/server-ce/index">http://www.zend.com/en/products/server-ce/index</a></p>
<p>Zend Studio for Eclipse<br /> <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_arrow.gif' alt=':arrow:' class='wp-smiley' title="Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE" /> <a href="http://www.zend.com/community/pdt">http://www.zend.com/community/pdt</a></p>
<p>Installing Android SDK<br /> <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_arrow.gif' alt=':arrow:' class='wp-smiley' title="Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE" /> <a href="http://developer.android.com/sdk/installing.html">http://developer.android.com/sdk/installing.html</a></p>
<p>Setting up Android SDK in Eclipse<br /> <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_arrow.gif' alt=':arrow:' class='wp-smiley' title="Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE" /> <a href="http://developer.android.com/sdk/eclipse-adt.html">http://developer.android.com/sdk/eclipse-adt.html</a></p>
<p>If anyone desires I can write up a more detailed step by step guide, however at this point I think its pretty easy to figure out, with the links I provided.  <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_mrgreen.gif' alt=':mrgreen:' class='wp-smiley' title="Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE" /> </p>

<p><strong>Possibly Related Posts:</strong></p>
<ul>
<li><a href="http://www.molotovbliss.com/blog/general/magento-commerce-404-whoops-our-bad-error-reporting/">Magento Commerce Error Reporting Tip</a></li>
<li><a href="http://www.molotovbliss.com/blog/android-os-g1-sdk/android-sdk-2-01-emu-webkit-user-agent/">Android SDK 2.01 Emu WebKit User Agent</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/magento-paypal-standard-ipn-double-totals-bug-1-3-2-3-fix/">Magento: Paypal Standard IPN Double Totals Bug 1.3.2.3 + fix</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/iphone-magento-theme-compatible-with-android/">iPhone Magento theme compatible with Android</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/706/">Magento Tutorial Video: Display Product Images in Blocks and Pages</a></li>
</ul><br />
<img src="http://feeds.feedburner.com/~r/Molotovbliss/~4/UwSxwj-rJNY" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.molotovbliss.com/blog/magento-commerce/eclipse-zend-studio-zendserver-android-sdk-how-to-install/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.molotovbliss.com/blog/magento-commerce/eclipse-zend-studio-zendserver-android-sdk-how-to-install/</feedburner:origLink></item>
		<item>
		<title>Farbrausch: debris</title>
		<link>http://feedproxy.google.com/~r/Molotovbliss/~3/FcjNUWWkwXs/</link>
		<comments>http://www.molotovbliss.com/blog/demo-scene-demos-videos/farbrausch-debris/#comments</comments>
		<pubDate>Sun, 06 Dec 2009 03:57:51 +0000</pubDate>
		<dc:creator>admin</dc:creator>
				<category><![CDATA[Demo Scene]]></category>
		<category><![CDATA[demo]]></category>
		<category><![CDATA[Demoscene]]></category>
		<category><![CDATA[programming]]></category>

		<guid isPermaLink="false">http://www.molotovbliss.com/blog/?p=727</guid>
		<description><![CDATA[
177 kilobytes of awesomeness! I&#8217;d highly recommend the link in full HD than my embed to enjoy, or better yet if you&#8217;ve got a good graphics card like an late model NVIDIA or ATI then download the tiny executable.
  YouTube &#8211; Farbrausch &#8211; fr-041: debris. [HD].
The secret behind all this is procedural content generation. [...]]]></description>
			<content:encoded><![CDATA[<p><object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="480" height="295" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0"><param name="allowFullScreen" value="true" /><param name="allowscriptaccess" value="always" /><param name="src" value="http://www.youtube.com/v/wqu_IpkOYBg&amp;hl=en_US&amp;fs=1&amp;color1=0x3a3a3a&amp;color2=0x999999" /><param name="allowfullscreen" value="true" /><embed type="application/x-shockwave-flash" width="480" height="295" src="http://www.youtube.com/v/wqu_IpkOYBg&amp;hl=en_US&amp;fs=1&amp;color1=0x3a3a3a&amp;color2=0x999999" allowscriptaccess="always" allowfullscreen="true"></embed></object></p>
<p style="text-align: left;">177 kilobytes of awesomeness! I&#8217;d highly recommend the link in full HD than my embed to enjoy, or better yet if you&#8217;ve got a good graphics card like an late model NVIDIA or ATI then <a href="http://www.theprodukkt.com/debris" target="_blank">download the tiny executable</a>.</p>
<p> <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_arrow.gif' alt=':arrow:' class='wp-smiley' title="Farbrausch: debris" /> <a href="http://www.youtube.com/watch?v=wqu_IpkOYBg&amp;fmt=22">YouTube &#8211; Farbrausch &#8211; fr-041: debris. [HD]</a>.</p>
<blockquote><p>The secret behind all this is procedural content generation. in a nutshell, instead of storing a movie as-is we&#8217;re storing a certain number of mathematical formulas for image and audio manipulation as well as the &#8220;recipe&#8221; how to apply those small bits of code in a way that what you see comes out. And while it&#8217;s running your computer&#8217;s graphics card cares for the actual displaying ot the world, just like in modern 3D games. Formulas+recipe are of course way smaller than the end result, and with a few additional sprinkles of magic compression fairy dust we get down to under 200 kilobytes, which is way less than one single high quality image of this show would take.</p></blockquote>

<p><strong>Possibly Related Posts:</strong></p>
<ul>
<li><a href="http://www.molotovbliss.com/blog/demo-scene-demos-videos/best-4k-demo-ever-texas-by-keyboarders/">Best 4k Demo EVER! Texas by Keyboarders</a></li>
<li><a href="http://www.molotovbliss.com/blog/demo-scene-demos-videos/everything-is-under-control-break-point-09-invite-demo/">Everything is Under Control &#8211; Break Point 09 invite demo</a></li>
<li><a href="http://www.molotovbliss.com/blog/demo-scene-demos-videos/favorited-demos-on-youtube/">Favorite Demos on YouTube in a playlist</a></li>
<li><a href="http://www.molotovbliss.com/blog/demo-scene-demos-videos/old-kosmic-kfmf-demos-flight-dream/">Old Kosmic (KFMF) Demos</a></li>
<li><a href="http://www.molotovbliss.com/blog/demo-scene-demos-videos/youtube-asd-lifeforce-assembly-2007-hd/">ASD LifeForce Assembly 2007</a></li>
</ul><br />
<img src="http://feeds.feedburner.com/~r/Molotovbliss/~4/FcjNUWWkwXs" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.molotovbliss.com/blog/demo-scene-demos-videos/farbrausch-debris/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.molotovbliss.com/blog/demo-scene-demos-videos/farbrausch-debris/</feedburner:origLink></item>
		<item>
		<title>Magento: Paypal Standard IPN Double Totals Bug 1.3.2.3 + fix</title>
		<link>http://feedproxy.google.com/~r/Molotovbliss/~3/OAHtUK_nTKI/</link>
		<comments>http://www.molotovbliss.com/blog/magento-commerce/magento-paypal-standard-ipn-double-totals-bug-1-3-2-3-fix/#comments</comments>
		<pubDate>Fri, 04 Dec 2009 20:59:03 +0000</pubDate>
		<dc:creator>B00MER</dc:creator>
				<category><![CDATA[Magento Commerce]]></category>
		<category><![CDATA[bug]]></category>
		<category><![CDATA[commerce]]></category>
		<category><![CDATA[Magento]]></category>

		<guid isPermaLink="false">http://www.molotovbliss.com/blog/?p=719</guid>
		<description><![CDATA[  This fix didn&#8217;t work for me after further testing on 1.3.2.4 another recommended fix has however worked.   

Does the above look familiar for Paypal Standard Orders, Note the Grand Total and Total Paid&#8230;
Running into this issue myself I thought I would post it up to let everyone else know the issue [...]]]></description>
			<content:encoded><![CDATA[<p> <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_exclaim.gif' alt=':!:' class='wp-smiley' title="Magento: Paypal Standard IPN Double Totals Bug 1.3.2.3 + fix" /> <span style="color: #ff0000;"><strong>This fix didn&#8217;t work for me after further testing on 1.3.2.4 <a href="http://www.magentocommerce.com/boards/viewthread/47584/#t153588">another recommended fix</a> has however worked.  <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_exclaim.gif' alt=':!:' class='wp-smiley' title="Magento: Paypal Standard IPN Double Totals Bug 1.3.2.3 + fix" /> </strong></span></p>
<p><a href="http://www.molotovbliss.com/blog/wp-content/uploads/2009/12/Untitled-1.gif"><img class="alignnone size-full wp-image-721" title="Untitled-1" src="http://www.molotovbliss.com/blog/wp-content/uploads/2009/12/Untitled-1.gif" alt="Untitled 1 Magento: Paypal Standard IPN Double Totals Bug 1.3.2.3 + fix" width="452" height="146" /></a></p>
<p>Does the above look familiar for Paypal Standard Orders, Note the Grand Total and Total Paid&#8230;</p>
<p>Running into this issue myself I thought I would post it up to let everyone else know the issue with the Standard Paypal IPN and Magento version 1.3.2.3.  It appears double Order totals are showing up under &#8220;Total Paid&#8221; and can cause a lot of customer confusion.</p>
<p>Here is the quick temporary fix:</p>
<p> <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_exclaim.gif' alt=':!:' class='wp-smiley' title="Magento: Paypal Standard IPN Double Totals Bug 1.3.2.3 + fix" /> NOTE: This modifies the base code of Magento and recommended you save a backup of the original file, as it may cause issues upgrading later on.</p>
<p>app/code/core/Mage/Paypal/Model/Standard.php as follows: <br style="padding: 0px; margin: 0px;" /><br style="padding: 0px; margin: 0px;" />- $invoice-&gt;register()-&gt;capture();<br style="padding: 0px; margin: 0px;" />+ $invoice-&gt;register()-&gt;pay(); <br style="padding: 0px; margin: 0px;" /><br style="padding: 0px; margin: 0px;" />The above modification fixed IPN problems but now the Total Paid amount is wrong. <br style="padding: 0px; margin: 0px;" /><br style="padding: 0px; margin: 0px;" />Also the above modification introduced another bug: paid orders are shown as COMPLETE instead of PROCESSING. This can be fixed by changing app/code/core/Mage/Paypal/Model/Standard.php as follows: <br style="padding: 0px; margin: 0px;" /><br style="padding: 0px; margin: 0px;" />- Mage_Sales_Model_Order::STATE_COMPLETE, true,<br style="padding: 0px; margin: 0px;" />+ Mage_Sales_Model_Order::STATE_PROCESSING, $newOrderStatus, <br style="padding: 0px; margin: 0px;" /><br style="padding: 0px; margin: 0px;" />This change will fix the status problem so that paid orers now appear as PROCESSING.</p>
<p>This fix was not mine and I would like to thank those whom are responsible for finding the bug and providing a fix! Kudos to them.  <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_biggrin.gif' alt=':D' class='wp-smiley' title="Magento: Paypal Standard IPN Double Totals Bug 1.3.2.3 + fix" /> </p>
<p> <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_arrow.gif' alt=':arrow:' class='wp-smiley' title="Magento: Paypal Standard IPN Double Totals Bug 1.3.2.3 + fix" /> <a href="http://www.magentocommerce.com/bug-tracking/issue?issue=6993">Magento &#8211; Issue List  &#8211; eCommerce Software for Growth</a>.</p>

<p><strong>Possibly Related Posts:</strong></p>
<ul>
<li><a href="http://www.molotovbliss.com/blog/general/magento-commerce-404-whoops-our-bad-error-reporting/">Magento Commerce Error Reporting Tip</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/eclipse-zend-studio-zendserver-android-sdk-how-to-install/">Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/iphone-magento-theme-compatible-with-android/">iPhone Magento theme compatible with Android</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/706/">Magento Tutorial Video: Display Product Images in Blocks and Pages</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/magento-phoning-home-to-big-brothervarien/">Magento: Phoning home to Big Brother/Varien?</a></li>
</ul><br />
<img src="http://feeds.feedburner.com/~r/Molotovbliss/~4/OAHtUK_nTKI" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.molotovbliss.com/blog/magento-commerce/magento-paypal-standard-ipn-double-totals-bug-1-3-2-3-fix/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.molotovbliss.com/blog/magento-commerce/magento-paypal-standard-ipn-double-totals-bug-1-3-2-3-fix/</feedburner:origLink></item>
		<item>
		<title>iPhone Magento theme compatible with Android</title>
		<link>http://feedproxy.google.com/~r/Molotovbliss/~3/brOct91J06Y/</link>
		<comments>http://www.molotovbliss.com/blog/magento-commerce/iphone-magento-theme-compatible-with-android/#comments</comments>
		<pubDate>Thu, 03 Dec 2009 08:52:12 +0000</pubDate>
		<dc:creator>B00MER</dc:creator>
				<category><![CDATA[Android]]></category>
		<category><![CDATA[Magento Commerce]]></category>
		<category><![CDATA[Magento]]></category>
		<category><![CDATA[tips]]></category>
		<category><![CDATA[tricks]]></category>

		<guid isPermaLink="false">http://www.molotovbliss.com/blog/?p=710</guid>
		<description><![CDATA[After installing the iPhone Theme for Magento via Magento Connect do the following:
Simply configure the exceptions under &#8220;System&#8221;-&#62;&#8221;Configuration&#8221;-&#62;&#8221;Design&#8221;
Expand &#8220;Themes&#8221; see the screenshot and use the values &#8220;Mobile Safari&#124;iPhone&#124;iPod&#8221; for Matched expression, and &#8220;iphone&#8221; for value.  Since both iPhone and Android use WebKit they will both return the user agent as &#8220;Mobile Safari&#8221;.  Be [...]]]></description>
			<content:encoded><![CDATA[<p>After installing the <a href="http://www.magentocommerce.com/extension/303/iphone-theme" target="_blank">iPhone Theme for Magento</a> via Magento Connect do the following:</p>
<p>Simply configure the exceptions under &#8220;System&#8221;-&gt;&#8221;Configuration&#8221;-&gt;&#8221;Design&#8221;</p>
<p>Expand &#8220;Themes&#8221; see the screenshot and use the values &#8220;Mobile Safari|iPhone|iPod&#8221; for Matched expression, and &#8220;iphone&#8221; for value.  Since both iPhone and Android use WebKit they will both return the user agent as &#8220;Mobile Safari&#8221;.  Be sure and realize it IS case sensitive for all values.</p>
<p>However after some further testing with some iPhones won&#8217;t return &#8220;Mobile Safari&#8221; so the condition for iPhone or iPod needs to be added as well.</p>
<p>Cheers! <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_wink.gif' alt=';)' class='wp-smiley' title="iPhone Magento theme compatible with Android" /> </p>
<p><a href="http://www.molotovbliss.com/blog/wp-content/uploads/2009/12/android-iphone1.gif"><img class="alignnone size-full wp-image-716" title="android-iphone" src="http://www.molotovbliss.com/blog/wp-content/uploads/2009/12/android-iphone1.gif" alt="android iphone1 iPhone Magento theme compatible with Android" width="474" height="556" /></a></p>
<p> <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_idea.gif' alt=':idea:' class='wp-smiley' title="iPhone Magento theme compatible with Android" /> Update: <a href="http://www.infinitezest.com/articles/which-web-browser-is-used-in-android.aspx" target="_blank">More details about Which Browser is used in Android</a></p>

<p><strong>Possibly Related Posts:</strong></p>
<ul>
<li><a href="http://www.molotovbliss.com/blog/general/magento-commerce-404-whoops-our-bad-error-reporting/">Magento Commerce Error Reporting Tip</a></li>
<li><a href="http://www.molotovbliss.com/blog/android-os-g1-sdk/android-sdk-2-01-emu-webkit-user-agent/">Android SDK 2.01 Emu WebKit User Agent</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/eclipse-zend-studio-zendserver-android-sdk-how-to-install/">Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/magento-paypal-standard-ipn-double-totals-bug-1-3-2-3-fix/">Magento: Paypal Standard IPN Double Totals Bug 1.3.2.3 + fix</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/706/">Magento Tutorial Video: Display Product Images in Blocks and Pages</a></li>
</ul><br />
<img src="http://feeds.feedburner.com/~r/Molotovbliss/~4/brOct91J06Y" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.molotovbliss.com/blog/magento-commerce/iphone-magento-theme-compatible-with-android/feed/</wfw:commentRss>
		<slash:comments>6</slash:comments>
		<feedburner:origLink>http://www.molotovbliss.com/blog/magento-commerce/iphone-magento-theme-compatible-with-android/</feedburner:origLink></item>
		<item>
		<title>Magento Tutorial Video: Display Product Images in Blocks and Pages</title>
		<link>http://feedproxy.google.com/~r/Molotovbliss/~3/5zAdEmCfnk8/</link>
		<comments>http://www.molotovbliss.com/blog/magento-commerce/706/#comments</comments>
		<pubDate>Fri, 13 Nov 2009 16:59:39 +0000</pubDate>
		<dc:creator>B00MER</dc:creator>
				<category><![CDATA[Magento Commerce]]></category>
		<category><![CDATA[Magento]]></category>
		<category><![CDATA[tips]]></category>
		<category><![CDATA[tricks]]></category>

		<guid isPermaLink="false">http://www.molotovbliss.com/blog/?p=706</guid>
		<description><![CDATA[
Thanks to Yireo for creating a video based off my posting: Magento: Display a product image within Static Pages and Blocks.  Being a visual person myself, this should really help people understand how to do such with ease.  Kudos to Yireo!

Possibly Related Posts:

Magento Commerce Error Reporting Tip
Eclipse + ZendStudio + ZendServer + Android [...]]]></description>
			<content:encoded><![CDATA[<p><object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="425" height="350" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0"><param name="src" value="http://www.youtube.com/v/uKAO1rrN6kw" /><embed type="application/x-shockwave-flash" width="425" height="350" src="http://www.youtube.com/v/uKAO1rrN6kw"></embed></object></p>
<p>Thanks to <a href="https://www.yireo.com/tutorials/magento-programming/183-video-dynamic-product-image-to-static-page">Yireo</a> for creating a video based off my posting: <a href="/magento-commerce/magento-display-a-product-image-within-static-pages-and-blocks/">Magento: Display a product image within Static Pages and Blocks</a>.  Being a visual person myself, this should really help people understand how to do such with ease.  Kudos to Yireo!</p>

<p><strong>Possibly Related Posts:</strong></p>
<ul>
<li><a href="http://www.molotovbliss.com/blog/general/magento-commerce-404-whoops-our-bad-error-reporting/">Magento Commerce Error Reporting Tip</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/eclipse-zend-studio-zendserver-android-sdk-how-to-install/">Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/magento-paypal-standard-ipn-double-totals-bug-1-3-2-3-fix/">Magento: Paypal Standard IPN Double Totals Bug 1.3.2.3 + fix</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/iphone-magento-theme-compatible-with-android/">iPhone Magento theme compatible with Android</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/magento-phoning-home-to-big-brothervarien/">Magento: Phoning home to Big Brother/Varien?</a></li>
</ul><br />
<img src="http://feeds.feedburner.com/~r/Molotovbliss/~4/5zAdEmCfnk8" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.molotovbliss.com/blog/magento-commerce/706/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.molotovbliss.com/blog/magento-commerce/706/</feedburner:origLink></item>
		<item>
		<title>Magento: Phoning home to Big Brother/Varien?</title>
		<link>http://feedproxy.google.com/~r/Molotovbliss/~3/5Bhqi9_HRig/</link>
		<comments>http://www.molotovbliss.com/blog/magento-commerce/magento-phoning-home-to-big-brothervarien/#comments</comments>
		<pubDate>Tue, 20 Oct 2009 07:23:19 +0000</pubDate>
		<dc:creator>B00MER</dc:creator>
				<category><![CDATA[Magento Commerce]]></category>
		<category><![CDATA[Web Development]]></category>
		<category><![CDATA[Magento]]></category>
		<category><![CDATA[security]]></category>

		<guid isPermaLink="false">http://www.molotovbliss.com/blog/?p=695</guid>
		<description><![CDATA[It appears some have claimed there Magento installation has been making calls back to IP&#8217;s owned by Varien/Magento, The thread is initially a year old, and more recent discussions have claimed they haven&#8217;t found anything of such nature.  I know X-Cart used to use a javascript blank 1&#215;1 gif image to track installations of X-Cart [...]]]></description>
			<content:encoded><![CDATA[<p>It appears some have claimed there Magento installation has been making calls back to IP&#8217;s owned by Varien/Magento, The thread is initially a year old, and more recent discussions have claimed they haven&#8217;t found anything of such nature.  I know X-Cart used to use a javascript blank 1&#215;1 gif image to track installations of X-Cart but it was only on the backend/admin side, and not the front end.  Has anyone else run into similar instances?  Also this may not pertain to 3rd party modules installed as that may a whole other can of worms you could be opening up your store up to, most modules are free, but nothing is really free in this world.  <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_eek.gif' alt='8O' class='wp-smiley' title="Magento: Phoning home to Big Brother/Varien?" />  Here is the original thread: <a href="http://www.magentocommerce.com/boards/viewthread/20037/P0/">Magento Phone Home?</a></p>

<p><strong>Possibly Related Posts:</strong></p>
<ul>
<li><a href="http://www.molotovbliss.com/blog/general/magento-commerce-404-whoops-our-bad-error-reporting/">Magento Commerce Error Reporting Tip</a></li>
<li><a href="http://www.molotovbliss.com/blog/android-os-g1-sdk/android-sdk-2-01-emu-webkit-user-agent/">Android SDK 2.01 Emu WebKit User Agent</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/eclipse-zend-studio-zendserver-android-sdk-how-to-install/">Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/magento-paypal-standard-ipn-double-totals-bug-1-3-2-3-fix/">Magento: Paypal Standard IPN Double Totals Bug 1.3.2.3 + fix</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/iphone-magento-theme-compatible-with-android/">iPhone Magento theme compatible with Android</a></li>
</ul><br />
<img src="http://feeds.feedburner.com/~r/Molotovbliss/~4/5Bhqi9_HRig" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.molotovbliss.com/blog/magento-commerce/magento-phoning-home-to-big-brothervarien/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://www.molotovbliss.com/blog/magento-commerce/magento-phoning-home-to-big-brothervarien/</feedburner:origLink></item>
		<item>
		<title>Magento: Display a product image within Static Pages and Blocks</title>
		<link>http://feedproxy.google.com/~r/Molotovbliss/~3/-u0WaBkggI4/</link>
		<comments>http://www.molotovbliss.com/blog/magento-commerce/magento-display-a-product-image-within-static-pages-and-blocks/#comments</comments>
		<pubDate>Thu, 15 Oct 2009 09:50:25 +0000</pubDate>
		<dc:creator>B00MER</dc:creator>
				<category><![CDATA[Magento Commerce]]></category>
		<category><![CDATA[Magento]]></category>
		<category><![CDATA[Web Development]]></category>

		<guid isPermaLink="false">http://www.molotovbliss.com/blog/?p=688</guid>
		<description><![CDATA[In this particular instance I needed to add product thumbnails for reference on a front page.
First create a new .phtml file with the following under catalog/product/view/your_new_page.phtml

?View Code PHP1
2
3
4
5
&#60;?php
$productId = $this-&#62;getProduct_id&#40;&#41;; 
$_product = Mage::getModel&#40;'catalog/product'&#41;-&#62;load&#40;$productId&#41;; //load the product
?&#62;
&#60;img src=&#34;&#60;? echo Mage::helper('catalog/image')-&#62;init($_product, 'thumbnail')-&#62;resize(75, 75); ?&#62;&#34; alt=&#34;&#60;?php echo $this-&#62;htmlEscape($_product['name']); ?&#62;&#34; border=&#34;0&#34; width=&#34;75&#34; /&#62;

Now simply add the following to your [...]]]></description>
			<content:encoded><![CDATA[<p>In this particular instance I needed to add product thumbnails for reference on a front page.</p>
<p>First create a new .phtml file with the following under catalog/product/view/your_new_page.phtml</p>

<div class="wp_codebox_msgheader"><span class="right"><sup><a href="http://www.ericbess.com/ericblog/2008/03/03/wp-codebox/#examples" target="_blank" title="WP-CodeBox HowTo?"><span style="color: #99cc00">?</span></a></sup></span><span class="left"><a href="javascript:;" onclick="javascript:showCodeTxt('p688code5'); return false;">View Code</a> PHP</span><div class="codebox_clear"></div></div><div class="wp_codebox"><table width="100%" ><tr id="p6885"><td class="line_numbers"><pre>1
2
3
4
5
</pre></td><td class="code" id="p688code5"><pre class="php" style="font-family:monospace;"><span style="color: #000000; font-weight: bold;">&lt;?php</span>
<span style="color: #000088;">$productId</span> <span style="color: #339933;">=</span> <span style="color: #000088;">$this</span><span style="color: #339933;">-&gt;</span><span style="color: #004000;">getProduct_id</span><span style="color: #009900;">&#40;</span><span style="color: #009900;">&#41;</span><span style="color: #339933;">;</span> 
<span style="color: #000088;">$_product</span> <span style="color: #339933;">=</span> Mage<span style="color: #339933;">::</span><span style="color: #004000;">getModel</span><span style="color: #009900;">&#40;</span><span style="color: #0000ff;">'catalog/product'</span><span style="color: #009900;">&#41;</span><span style="color: #339933;">-&gt;</span><span style="color: #004000;">load</span><span style="color: #009900;">&#40;</span><span style="color: #000088;">$productId</span><span style="color: #009900;">&#41;</span><span style="color: #339933;">;</span> <span style="color: #666666; font-style: italic;">//load the product</span>
<span style="color: #000000; font-weight: bold;">?&gt;</span>
<span style="color: #339933;">&lt;</span>img src<span style="color: #339933;">=</span><span style="color: #0000ff;">&quot;&lt;? echo Mage::helper('catalog/image')-&gt;init(<span style="color: #006699; font-weight: bold;">$_product</span>, 'thumbnail')-&gt;resize(75, 75); ?&gt;&quot;</span> alt<span style="color: #339933;">=</span><span style="color: #0000ff;">&quot;&lt;?php echo <span style="color: #006699; font-weight: bold;">$this-&gt;htmlEscape</span>(<span style="color: #006699; font-weight: bold;">$_product</span>['name']); ?&gt;&quot;</span> border<span style="color: #339933;">=</span><span style="color: #0000ff;">&quot;0&quot;</span> width<span style="color: #339933;">=</span><span style="color: #0000ff;">&quot;75&quot;</span> <span style="color: #339933;">/&gt;</span></pre></td></tr></table></div>

<p>Now simply add the following to your CMS Page or Block and adjust the product ID to the product Image you wish to view:</p>

<div class="wp_codebox_msgheader"><span class="right"><sup><a href="http://www.ericbess.com/ericblog/2008/03/03/wp-codebox/#examples" target="_blank" title="WP-CodeBox HowTo?"><span style="color: #99cc00">?</span></a></sup></span><span class="left"><a href="javascript:;" onclick="javascript:showCodeTxt('p688code6'); return false;">View Code</a> PHP</span><div class="codebox_clear"></div></div><div class="wp_codebox"><table width="100%" ><tr id="p6886"><td class="line_numbers"><pre>1
</pre></td><td class="code" id="p688code6"><pre class="php" style="font-family:monospace;"><span style="color: #009900;">&#123;</span><span style="color: #009900;">&#123;</span>block type<span style="color: #339933;">=</span><span style="color: #0000ff;">&quot;catalog/product_new&quot;</span> product_id<span style="color: #339933;">=</span><span style="color: #0000ff;">&quot;1&quot;</span> template<span style="color: #339933;">=</span><span style="color: #0000ff;">&quot;catalog/product/view/your_new_page.phtml&quot;</span><span style="color: #009900;">&#125;</span><span style="color: #009900;">&#125;</span></pre></td></tr></table></div>


<p><strong>Possibly Related Posts:</strong></p>
<ul>
<li><a href="http://www.molotovbliss.com/blog/general/magento-commerce-404-whoops-our-bad-error-reporting/">Magento Commerce Error Reporting Tip</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/eclipse-zend-studio-zendserver-android-sdk-how-to-install/">Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/magento-paypal-standard-ipn-double-totals-bug-1-3-2-3-fix/">Magento: Paypal Standard IPN Double Totals Bug 1.3.2.3 + fix</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/iphone-magento-theme-compatible-with-android/">iPhone Magento theme compatible with Android</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/706/">Magento Tutorial Video: Display Product Images in Blocks and Pages</a></li>
</ul><br />
<img src="http://feeds.feedburner.com/~r/Molotovbliss/~4/-u0WaBkggI4" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.molotovbliss.com/blog/magento-commerce/magento-display-a-product-image-within-static-pages-and-blocks/feed/</wfw:commentRss>
		<slash:comments>3</slash:comments>
		<feedburner:origLink>http://www.molotovbliss.com/blog/magento-commerce/magento-display-a-product-image-within-static-pages-and-blocks/</feedburner:origLink></item>
		<item>
		<title>Selecting 30 days or older entries using MySQL DateTime field</title>
		<link>http://feedproxy.google.com/~r/Molotovbliss/~3/_3KHcDJfX4Q/</link>
		<comments>http://www.molotovbliss.com/blog/web-dev/selecting-30-days-or-older-entries-using-mysql-datetime-field/#comments</comments>
		<pubDate>Thu, 08 Oct 2009 20:12:26 +0000</pubDate>
		<dc:creator>B00MER</dc:creator>
				<category><![CDATA[MySQL]]></category>
		<category><![CDATA[Web Development]]></category>
		<category><![CDATA[tips]]></category>
		<category><![CDATA[tricks]]></category>

		<guid isPermaLink="false">http://www.molotovbliss.com/blog/?p=685</guid>
		<description><![CDATA[I&#8217;ve been doing quite a bit of Date and Time manipulations lately, and have grown to enjoy MySQL&#8217;s DateTime fields just as much as UNIX timestamps.  Particularly its built-in functions for selecting any range of fields based on a time frame.
Needing to remove all entries from a table that are older than 30 days, [...]]]></description>
			<content:encoded><![CDATA[<p>I&#8217;ve been doing quite a bit of Date and Time manipulations lately, and have grown to enjoy <a href="http://www.w3schools.com/sql/sql_datatypes.asp">MySQL&#8217;s DateTime fields</a> just as much as UNIX timestamps.  Particularly its built-in functions for selecting any range of fields based on a time frame.</p>
<p>Needing to remove all entries from a table that are older than 30 days, at first I thought I would need to iterate over the very large table (90+k) rows of data and convert each <a href="http://www.w3schools.com/sql/sql_datatypes.asp">MySQL DateTime field</a> to a UNIX time stamp to do the calculations myself with PHP.  However after a bit of research I&#8217;ve learned of a few things with MySQL DateTime that make this a lot easier.</p>

<div class="wp_codebox_msgheader"><span class="right"><sup><a href="http://www.ericbess.com/ericblog/2008/03/03/wp-codebox/#examples" target="_blank" title="WP-CodeBox HowTo?"><span style="color: #99cc00">?</span></a></sup></span><span class="left"><a href="javascript:;" onclick="javascript:showCodeTxt('p685code9'); return false;">View Code</a> SQL</span><div class="codebox_clear"></div></div><div class="wp_codebox"><table width="100%" ><tr id="p6859"><td class="line_numbers"><pre>1
</pre></td><td class="code" id="p685code9"><pre class="sql" style="font-family:monospace;"><span style="color: #993333; font-weight: bold;">SELECT</span> <span style="color: #993333; font-weight: bold;">fields</span> <span style="color: #993333; font-weight: bold;">FROM</span> <span style="color: #993333; font-weight: bold;">table</span> <span style="color: #993333; font-weight: bold;">WHERE</span> DATE_SUB<span style="color: #66cc66;">&#40;</span>CURDATE<span style="color: #66cc66;">&#40;</span><span style="color: #66cc66;">&#41;</span><span style="color: #66cc66;">,</span>INTERVAL <span style="color: #cc66cc;">30</span> DAY<span style="color: #66cc66;">&#41;</span> <span style="color: #66cc66;">&gt;=</span> timestamp;</pre></td></tr></table></div>

<p>The &#8220;timestamp&#8221; field is the MySQL DateTime field.  Using the <a href="http://www.w3schools.com/sql/func_date_sub.asp" target="_self">DATE_SUB</a>, <a href="http://www.w3schools.com/sql/func_curdate.asp">CURDATE</a> and INTERVAL one can easily grab all records that are 30 days old without the headache of converting to UNIX timestamps in PHP and doing the grunt work yourself.</p>
<p> <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_idea.gif' alt=':idea:' class='wp-smiley' title="Selecting 30 days or older entries using MySQL DateTime field" /> Also as a side note, if you wish to convert a MySQL DateTime field to a UNIX timestamp you can easily do this by:</p>

<div class="wp_codebox_msgheader"><span class="right"><sup><a href="http://www.ericbess.com/ericblog/2008/03/03/wp-codebox/#examples" target="_blank" title="WP-CodeBox HowTo?"><span style="color: #99cc00">?</span></a></sup></span><span class="left"><a href="javascript:;" onclick="javascript:showCodeTxt('p685code10'); return false;">View Code</a> PHP</span><div class="codebox_clear"></div></div><div class="wp_codebox"><table width="100%" ><tr id="p68510"><td class="line_numbers"><pre>1
</pre></td><td class="code" id="p685code10"><pre class="php" style="font-family:monospace;"><span style="color: #000088;">$mysql_timestamp</span> <span style="color: #339933;">=</span> <a href="http://www.php.net/gmdate"><span style="color: #990000;">gmdate</span></a><span style="color: #009900;">&#40;</span><span style="color: #0000ff;">&quot;Y-m-d H:i:s&quot;</span><span style="color: #339933;">,</span><span style="color: #000088;">$mysql_timestamp_value</span><span style="color: #009900;">&#41;</span><span style="color: #339933;">;</span></pre></td></tr></table></div>

<p>If anyone has any better more efficient means to accomplish this please feel free to leave a comment. <img src='http://www.molotovbliss.com/blog/wp-includes/images/smilies/icon_biggrin.gif' alt=':D' class='wp-smiley' title="Selecting 30 days or older entries using MySQL DateTime field" /> </p>

<p><strong>Possibly Related Posts:</strong></p>
<ul>
<li><a href="http://www.molotovbliss.com/blog/android-os-g1-sdk/android-sdk-2-01-emu-webkit-user-agent/">Android SDK 2.01 Emu WebKit User Agent</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/eclipse-zend-studio-zendserver-android-sdk-how-to-install/">Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE</a></li>
<li><a href="http://www.molotovbliss.com/blog/magento-commerce/magento-phoning-home-to-big-brothervarien/">Magento: Phoning home to Big Brother/Varien?</a></li>
<li><a href="http://www.molotovbliss.com/blog/general/x-cart-creators-release-gears-based-ecwid-e-commerce-widgets-in-beta/">X-Cart creators release Gears based Ecwid E-Commerce Widgets in Beta</a></li>
<li><a href="http://www.molotovbliss.com/blog/general/combine-h-264-mp4-files-and-add-audio-via-mp4box-and-ffmpeg/">Combine H.264 MP4 Files and Add Audio via MP4Box and FFMPEG</a></li>
</ul><br />
<img src="http://feeds.feedburner.com/~r/Molotovbliss/~4/_3KHcDJfX4Q" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.molotovbliss.com/blog/web-dev/selecting-30-days-or-older-entries-using-mysql-datetime-field/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.molotovbliss.com/blog/web-dev/selecting-30-days-or-older-entries-using-mysql-datetime-field/</feedburner:origLink></item>
	</channel>
</rss>
