<?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:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>CodeCrunch</title>
	
	<link>http://www.codecrunch.com</link>
	<description>Webmaster Tutorials, News and Design Blog</description>
	<lastBuildDate>Wed, 08 Dec 2010 00:10:48 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.2.1</generator>
		<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/WebmasterTutorialsCodecrunch" /><feedburner:info uri="webmastertutorialscodecrunch" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><feedburner:emailServiceId>WebmasterTutorialsCodecrunch</feedburner:emailServiceId><feedburner:feedburnerHostname>http://feedburner.google.com</feedburner:feedburnerHostname><item>
		<title>Outsourcing my server – Can Site 5 deliver?</title>
		<link>http://feedproxy.google.com/~r/WebmasterTutorialsCodecrunch/~3/YT-Bd53SUR4/</link>
		<comments>http://www.codecrunch.com/2010/10/outsourcing-server-site-5-deliver/#comments</comments>
		<pubDate>Thu, 28 Oct 2010 19:19:35 +0000</pubDate>
		<dc:creator>Cory Crampton</dc:creator>
				<category><![CDATA[Off the Path]]></category>
		<category><![CDATA[Tech Reviews]]></category>

		<guid isPermaLink="false">http://www.codecrunch.com/?p=558</guid>
		<description><![CDATA[After years of managing my own server environment, I found that I was getting too busy serving my own clients needs, and I wanted to outsource my hosting management. I chose <a href="http://www.codecrunch.com/go/Site5/" target="_blank">Site 5 hosting</a> after working on a client site that was hosted with them, and they are definitely up to par.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>I have been hosting on the <a title="VPS Hosting" href="http://www.codecrunch.com/go/Site5VPS/" target="_blank">VPS2 plan</a> with <a title="Site 5 Hosting" href="http://www.codecrunch.com/go/Site5/" target="_blank">Site 5</a> for just under a month. For the past several years I have bounced around from dedicated hosting companies, running my own server because I like the infinite control I have over the application environment I can build. The last few years have been good to me, I was able to open my own webmaster consulting type firm, and take on several clients from various parts of the world. Providing this service to others had started to take away from my server management time, which any good server admin will tell you, is vital to the success of any web based service.</p>
<p>As much as I love spending time in the command line, I figured the amount of time I do that for clients was enough for me to get my fill. I started looking for a host that brought a little more to the table than just &#8216;being a host&#8217;.</p>
<blockquote><p><strong>I needed a hosting company that could understand my lingo (which is really theirs too), and at the same time would provide me any information I needed to get my job done.</strong></p></blockquote>
<p>In my perspective, <a title="Site 5 Designer Hosting" href="http://www.codecrunch.com/go/Site5/" target="_blank">Site 5 hosting</a> has created a niche market for designers and programmers that every other host should be keeping their eye on. Yes, they provide hosting like every other web host available, but there are a few fundamental differences that Site 5 brings to the table :</p>
<ol>
<li><strong>They take of the small stuff that others expect you to do on your own</strong>. This can be a real time saver for newbies and veterans alike. Example? They will change your DNS settings for you, free of charge. This may sound trivial, but take the boom of Google Apps users on the web today, and the time it takes for new webmasters to understand how DNS works. By the time a new webmaster figures out that these settings can be made themselves in their control panels (Cpanel, Plesk, Webmin etc..), Site 5 can have the changes made for you, freeing up valuable time to take care of more pressing issues.</li>
<li><strong>Their tech support is the real deal</strong>. They have structured their support much like any other support service, breaking down their tasks into what I like to call &#8216;Server Tiers.&#8217; Level one techs have their own set of support requests they can handle, level two &#8211; their own, and so on. Site 5 does not employ hundreds of offshore techs, so you are bound to run into some of the same ones over and over again. This is nice for a couple of reasons, but the most important me is that these technicians really do know their capabilities, and are not afraid to pass off requests that are not their specialty. This is a time saver, and it also shows that they really are out to retain me as a client.</li>
<li><strong>They understand that my clients are their clients too.</strong> In the reseller world, this is vital because many times you do not have the time to respond to your clients with an appropriate answer to their questions. My business model is not reselling hosting, I provide webmaster services for those that have no clue how a website works &#8211; whether by choice or inability to understand. This is my bottom line, not hosting, and when I do decide to host a client or two, I need to know that someone cares about their sites, as much as I do. With Site5, so far, the grass is definitely greener.</li>
</ol>
<div style="overflow: auto; text-align: center; margin-bottom: 20px;"><a href="http://www.site5.com/in.php?id=92633-45"><img src="http://www.site5.com/creative/2008/4/468x60-2.gif" border="0" alt="468x60-2" /></a></div>
<p>In the last month, I have submitted 14 support tickets, for various different needs. All but one of these tickets were replied to almost immediately. The only reason the one ticket was not replied to instantly was because it was an upgrade request that had to be routed to the proper system administrator to perform the upgrade. In 3 months I will revisit this post, and keep you informed of how everything is working out, so you can make an informed decision of your own about Site 5 web hosting. Until then &#8211; keep on keeping on!</p>
<div class="shr-publisher-558"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic --><img src="http://feeds.feedburner.com/~r/WebmasterTutorialsCodecrunch/~4/YT-Bd53SUR4" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.codecrunch.com/2010/10/outsourcing-server-site-5-deliver/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.codecrunch.com/2010/10/outsourcing-server-site-5-deliver/</feedburner:origLink></item>
		<item>
		<title>Blocking Countries To Your Website With iptables</title>
		<link>http://feedproxy.google.com/~r/WebmasterTutorialsCodecrunch/~3/sQJNgPFFRgE/</link>
		<comments>http://www.codecrunch.com/2010/08/blocking-countries-website-iptables/#comments</comments>
		<pubDate>Tue, 17 Aug 2010 21:57:57 +0000</pubDate>
		<dc:creator>Cory Crampton</dc:creator>
				<category><![CDATA[Code]]></category>
		<category><![CDATA[block countries]]></category>
		<category><![CDATA[firewall]]></category>
		<category><![CDATA[iptables]]></category>
		<category><![CDATA[unix]]></category>

		<guid isPermaLink="false">http://www.codecrunch.com/?p=506</guid>
		<description><![CDATA[If you manage your own server, you know the pains of a Denial of Service attack, or the annoying trappings of continual spam from the same countries. This little free bash script will allow you to block an entire country from your server using iptables.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>Here is a nice bash script that I ran across some time ago, that allows you to import ip ranges into your iptables. To better understand what is happening here, the full script is below, and follows with a break down of what the iptables script is actually doing. (The provider of the country ip ranges is Blogama &#8211; be sure and give them a visit.) For your convenience here is a list of the <a rel="noindex,nofollow" href="http://www.codecrunch.com/wp-content/uploads/2010/08/countrycodes.txt">Country Codes</a> to use in this script.</p>

<div class="wp_syntax"><div class="code"><pre class="text" style="font-family:monospace;">#!/bin/bash
###PUT HERE COMA SEPARATED LIST OF COUNTRY CODE###
COUNTRIES=&quot;AK,AR&quot;
WORKDIR=&quot;/root&quot;
#######################################
cd $WORKDIR
wget -c --output-document=iptables-blocklist.txt http://blogama.org/country_query.php?country=$COUNTRIES
if [ -f iptables-blocklist.txt ]; then
  iptables -F
  BLOCKDB=&quot;iptables-blocklist.txt&quot;
  IPS=$(grep -Ev &quot;^#&quot; $BLOCKDB)
  for i in $IPS
  do
    iptables -A INPUT -s $i -j DROP
    iptables -A OUTPUT -d $i -j DROP
  done
fi
rm $WORKDIR/iptables-blocklist.txt</pre></div></div>

<h2>1st Step of the Bash Script</h2>
<p>In this step, you are invoking the bash shell. The &#8216;COUNTRIES&#8217; variable is a list of country codes that you wish to add to your iptables to block. The full list of countries is available <a rel="noindex,nofollow" href="http://www.codecrunch.com/wp-content/uploads/2010/08/countrycodes.txt">here</a>. Obviously /root is your working directory that the script will do all of it&#8217;s work in. You can change this to your common working directory if you have one that you regularly use.</p>

<div class="wp_syntax"><div class="code"><pre class="text" style="font-family:monospace;">#!/bin/bash
###PUT HERE COMA SEPARATED LIST OF COUNTRY CODE###
COUNTRIES=&quot;AK,AR&quot;
WORKDIR=&quot;/root&quot;
#######################################</pre></div></div>

<h2>2nd Step</h2>
<p>Here we are simply changing the current working directory to match the directory variable that we listed above. The next step fetches (via wget) an external url, which is actually a script that will generate a formatted list of the ip ranges for the countries you requested.</p>

<div class="wp_syntax"><div class="code"><pre class="text" style="font-family:monospace;">cd $WORKDIR
wget -c --output-document=iptables-blocklist.txt http://blogama.org/country_query.php?country=$COUNTRIES</pre></div></div>

<h2>3rd Step &#8211; Meat and Potatoes of the iptables flush</h2>
<p>These two lines below check to see if a file already exists from a prior run of the bash script itself. If the file does exist, then it flushes your iptables.</p>

<div class="wp_syntax"><div class="code"><pre class="text" style="font-family:monospace;">if [ -f iptables-blocklist.txt ]; then
  iptables -F</pre></div></div>

<h2>4th Step &#8211; Finishing the iptables insert</h2>
<p>The last step of this iptable bash script opens the file we created with the ip ranges in it, and for each occurence of a new ip range, it creates a rule in your iptables to drop traffic from those ip ranges. When the script is done, it removes the created text file.</p>

<div class="wp_syntax"><div class="code"><pre class="text" style="font-family:monospace;">  BLOCKDB=&quot;iptables-blocklist.txt&quot;
  IPS=$(grep -Ev &quot;^#&quot; $BLOCKDB)
  for i in $IPS
  do
    iptables -A INPUT -s $i -j DROP
    iptables -A OUTPUT -d $i -j DROP
  done
fi
rm $WORKDIR/iptables-blocklist.txt</pre></div></div>

<p>To run the script on your server, simply type <em>bash scriptnamehere.sh</em>, replacing scriptnamehere.sh with whatever it is you choose to call and save the script as. The original file for this script can viewed at <a rel="nofollow" href="http://www.howtoforge.com/blocking-ip-addresses-of-any-country-with-iptables">HowToForge</a>.</p>
<div class="shr-publisher-506"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic --><img src="http://feeds.feedburner.com/~r/WebmasterTutorialsCodecrunch/~4/sQJNgPFFRgE" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.codecrunch.com/2010/08/blocking-countries-website-iptables/feed/</wfw:commentRss>
		<slash:comments>5</slash:comments>
		<feedburner:origLink>http://www.codecrunch.com/2010/08/blocking-countries-website-iptables/</feedburner:origLink></item>
		<item>
		<title>CoffeeCup HTML Editor Review</title>
		<link>http://feedproxy.google.com/~r/WebmasterTutorialsCodecrunch/~3/bUsw7hl9uNQ/</link>
		<comments>http://www.codecrunch.com/2010/08/coffeecup-html-editor-review/#comments</comments>
		<pubDate>Fri, 13 Aug 2010 23:15:52 +0000</pubDate>
		<dc:creator>Cory Crampton</dc:creator>
				<category><![CDATA[Tech Reviews]]></category>
		<category><![CDATA[free stock photography]]></category>
		<category><![CDATA[html editor]]></category>
		<category><![CDATA[javascript editor]]></category>
		<category><![CDATA[php editor]]></category>
		<category><![CDATA[text editor]]></category>
		<category><![CDATA[wysiwyg editor]]></category>

		<guid isPermaLink="false">http://www.codecrunch.com/?p=439</guid>
		<description><![CDATA[There are not many companies left like <a href="http://www.codecrunch.com/go/CoffeeCup/">CoffeeCup Software</a>. Where else can you buy an HTML Editor for $49 - 10 years ago, and still have access to every single update since? That's exactly how the fine folks at CoffeeCup operate. Here's an in depth review of <a href="http://www.codecrunch.com/go/CoffeeCup/">CoffeeCup HTML Editor 2010</a>, the same HTML Editor I have been using since 1999. (And also some links to some of their other top notch software such as FireStarter - their easy to use Flash tool.)]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><h2>An HTML Editor That Harnesses Simplicity</h2>
<p>The market of HTML editors seems to be flooded with text editors and WYSIWYG (what you see is what you get) editors that aim to provide an intuitive interface, yet fail miserably. I have been building websites since around 1997 and have used my share of them. First I used Microsoft Front Page 1997, followed shortly by Homesite (owned by Allaire back then), and Arachnophilia. I just couldn&#8217;t find a comfortable fit for me. Then I stumbled upon Coffee Cup Software. I figured for a free 30 day trial, and price tag of $49 (compared to the hefty price tag of the aforementioned) I had nothing to lose. Boy was I genuinely surprised at what I got for that price.</p>
<h2>Underneath the Hood</h2>
<p>When I first opened the <a href="http://www.codecrunch.com/go/CoffeeCup/">CoffeeCup Editor</a>, I was greeted by a warm little ditty from a song by Tom T Hall called &#8220;I Love&#8221;. Specifically it plays the portion where he is singing -&#8221; I love..coffee in a cup&#8221;. I knew right away that this editor was not your every day run of the mill, and I knew I found my fit, even if my volume level was all the way up and it scared the wits out of me. At first glance &#8211; this is what you will see in the 2010 Edition of their HTML Editor :<div id="attachment_459" class="wp-caption aligncenter" style="width: 610px"><a href="http://www.codecrunch.com/wp-content/uploads/2010/08/coffee_cup_1.png"><img src="http://www.codecrunch.com/wp-content/uploads/2010/08/coffee_cup_1.png" alt="HTML Editor by CoffeeCup Software" title="HTML Editor by CoffeeCup Software" width="600" height="358" class="size-full wp-image-459" /></a><p class="wp-caption-text">HTML Editor Load Page</p></div></p>
<h2>Looks Pretty &#8211; How&#8217;s the HTML Editing?</h2>
<p>This HTML editor has quite a few extra handy tools that most don&#8217;t and we&#8217;ll talk about that in a moment. The actual HTML editor portion of the software supports both WYSIWYG and standard text/html editing mode. I always use the text editing mode, but I have played around with the WYSIWYG editing portion on occasion just because it&#8217;s actually fun when you code everything by hand all the time.<strong> HTML5? Yes. CSS3? Check.</strong></p>
<p>The editor fully supports syntax highlighting of all the major scripting languages that most websites use these days : PHP, CSS, XHTML, Perl, and much more. I find it to be accurate in it&#8217;s highlighting, and it offers the ability to change the way your code is shown via the Document Display Properties option that comes with it. The built in code cleaner function gives you minute control over how you want your code cleaned up, which is really handy for people like me that make a lot of inline coding annotations. Look at the before and after picture below to get an idea of just how well the <a href="http://www.codecrunch.com/go/CoffeeCup/">HTML editor</a> cleans and beautifies your code :</p>
<div id="attachment_466" class="wp-caption aligncenter" style="width: 610px"><a href="http://www.codecrunch.com/wp-content/uploads/2010/08/code_before.png"><img src="http://www.codecrunch.com/wp-content/uploads/2010/08/code_before.png" alt="HTML Editor Code Before Cleaning" title="HTML Editor Code Before Cleaning" width="600" height="230" class="size-full wp-image-466" /></a><p class="wp-caption-text">HTML Editor Code Before Cleaning</p></div>
<div id="attachment_465" class="wp-caption aligncenter" style="width: 610px"><a href="http://www.codecrunch.com/wp-content/uploads/2010/08/code_after.png"><img src="http://www.codecrunch.com/wp-content/uploads/2010/08/code_after.png" alt="HTML Editor Code After Cleaning" title="HTML Editor Code After Cleaning" width="600" height="230" class="size-full wp-image-465" /></a><p class="wp-caption-text">HTML Editor Code After Cleaning</p></div>
<p>It may not look like much has happened, but what the code cleaner does is align your code, clean out any open tags, nest your syntax properly, and word wraps your code according to your input. It also has the ability to clean up comments, properly close comments, and much more.</p>
<h2>What else can it do? Can it make me breakfast?</h2>
<p>Short of whipping you up some eggs, the software comes with hundreds of code snippets, and pre-made templates for you to freely use in your projects. What I find to be one of the most valuable tools that comes as part of the editor is the website color scheme chooser. This handy little tool allows you to pick a color, and will match colors that fit well with it, as well as let you compare color schemes without having to do it on a live site :</p>
<div id="attachment_474" class="wp-caption aligncenter" style="width: 410px"><a href="http://www.codecrunch.com/wp-content/uploads/2010/08/coffee_cup_color.png"><img src="http://www.codecrunch.com/wp-content/uploads/2010/08/coffee_cup_color.png" alt="HTML Editor Website Color Schemer - Included!" title="HTML Editor Website Color Schemer - Included!" width="400" height="375" class="size-full wp-image-474" /></a><p class="wp-caption-text">HTML Editor Website Color Schemer</p></div>
<h2>What&#8217;s The Catch?</h2>
<p>You would think for all the features that this HTML editor gives you, a price tag of $49 would indicate that something is just not right. There has to be a catch..right? The bottom line is &#8211; CoffeeCup Software has such a large, loyal user base &#8211; that they don&#8217;t need to inflate their price to make the software look reasonable. Thousands of users continually rave about how well and how functional this little piece of heaven is. I&#8217;m just jumping in with them and telling you &#8211; if you don&#8217;t have it &#8211; <a href="http://www.codecrunch.com/go/CoffeeCup/">get the 2010 CoffeCup HTML Editor Trial Edition</a>, it will be the best $49 you ever spent, and you will never need another HTML Editor again.</p>
<h2>Other Software by CoffeeCup</h2>
<p><a href="http://www.codecrunch.com/go/FireStarter/" target="_blank" class="broken_link">FireStarter</a> &#8211; A great little flash animation maker for the non Flash types out there.<br />
<a href="http://www.codecrunch.com/go/PasswordWizard/" target="_blank">PassWordWizard</a> &#8211; Tool used to make custom password protected areas of your website. Good for WordPress, Joolma!, you name it.</p>
<p><img src="http://www.lduhtrp.net/image-3853827-5438736" width="1" height="1" border="0"/><img src="http://www.awltovhc.com/image-3853827-5438738" width="1" height="1" border="0"/> <img src="http://www.awltovhc.com/image-3853827-5438748" width="1" height="1" border="0"/></p>
<div class="shr-publisher-439"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic --><img src="http://feeds.feedburner.com/~r/WebmasterTutorialsCodecrunch/~4/bUsw7hl9uNQ" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.codecrunch.com/2010/08/coffeecup-html-editor-review/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.codecrunch.com/2010/08/coffeecup-html-editor-review/</feedburner:origLink></item>
		<item>
		<title>Free Stock Photographs and Free Stock Photo Sites</title>
		<link>http://feedproxy.google.com/~r/WebmasterTutorialsCodecrunch/~3/fojh45Uoisc/</link>
		<comments>http://www.codecrunch.com/2010/08/free-weekly-photographs-free-stock-photo-sites/#comments</comments>
		<pubDate>Thu, 12 Aug 2010 23:23:43 +0000</pubDate>
		<dc:creator>Cory Crampton</dc:creator>
				<category><![CDATA[Freebies]]></category>
		<category><![CDATA[free photo]]></category>
		<category><![CDATA[free stock photography]]></category>
		<category><![CDATA[freebies]]></category>
		<category><![CDATA[royalty free images]]></category>

		<guid isPermaLink="false">http://www.codecrunch.com/wpress/?p=275</guid>
		<description><![CDATA[Here's a couple of links to some hot royalty free stock photo sites that allow you to either download images for free, or offer free samples of their work. I use <a href='http://www.codecrunch.com/go/istock/' target='_blank'>iStockPhoto</a> exclusively for my designs, but there are a few good free sites out there.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>As a full time webmaster and designer, I use royalty free photography on a daily basis. As noted, <a href="http://www.codecrunch.com/go/istock/">iStockPhoto</a> is my royalty free image source of choice, but there are some good sources of free photography and vector images available to you. I have collected what I consider to be the top 10 free stock photography sites for <em>use in a commercial setting</em>, many with no attribution requirements. If you know of any other completely free photography resources, feel free to comment.</p>
<h2>Top Ten Royalty Free Stock Photography Resources</h2>
<div id="attachment_412" class="wp-caption alignright" style="width: 234px"><a href="http://www.codecrunch.com/wp-content/uploads/2010/08/punk_lady.jpg"><img src="http://www.codecrunch.com/wp-content/uploads/2010/08/punk_lady-224x300.jpg" alt="Punk Lady - Courtesy of Photoree.com" title="Punk Lady - Courtesy of Photoree.com" width="224" height="300" class="size-medium wp-image-412" /></a><p class="wp-caption-text">Punk Lady - Courtesy of Photoree.com</p></div>
<p><a rel="nofollow" href="http://photoree.com" style="font-size:150%;">Photoree</a> &#8211; I love this site and so will you. You can search stock photography by license which is a real time and effort saver. Many of the images are of the same quality and workmanship you would find on sites that charge a pretty penny. Yes &#8211; the image to the right was found on Photoree!</p>
<p><a rel="nofollow" href="http://freerangestock.com" style="font-size:150%;">FreeRangeStock</a> &#8211; This is not a large photography site, but I love the fact that they share ad revenue with their photographers. Many of their images are clean, hi resolution, and great for side projects such as scrap-booking.</p>
<p><a rel="nofollow" href="http://stockvault.net" style="font-size:150%;">StockVault</a> &#8211; These guys have some very clear images, and offer other resources in a similar, smooth layout &#8211; such as images specifically for web designers and niche fields.</p>
<p><a rel="nofollow" href="http://freepixels.com" style="font-size:150%;">FreePixels</a> &#8211; Another free stock photography website with superb quality, commercial grade images. As of this post they have just over 4,000 images, which while not a lot &#8211; you are completely free to use them in your commercial projects.</p>
<div id="attachment_418" class="wp-caption alignleft" style="width: 310px"><a href="http://www.codecrunch.com/wp-content/uploads/2010/08/fruit.jpg"><img src="http://www.codecrunch.com/wp-content/uploads/2010/08/fruit-300x199.jpg" alt="Fresh Fruit! - Courtesy of Freepixels.com" title="Fresh Fruit! - Courtesy of Freepixels.com" width="300" height="199" class="size-medium wp-image-418" /></a><p class="wp-caption-text">Fresh Fruit! - Courtesy of Freepixels.com</p></div>
<p><a rel="nofollow" href="http://imageafter.com" style="font-size:150%;">ImageAfter</a> &#8211; While ImageAfter does not have the highest quality free stock photography, they do have a cool tool. Their color picker tool allows you to pick  HTML hexadecimals <em>(N.B. codes)</em> and find images that match your color choice.</p>
<p><a rel="nofollow" href="http://rgbstock.com" style="font-size:150%;">RGB Stock</a> &#8211; I enjoy this stock photo site due to it&#8217;s clutter free layout, and the great implementation of category structure. Their images of buildings stand out more than other sites, but that may just be an opinion. They do require that you register to download full size photos, but it takes less than 1 minute, and it is a simple email validation process. The building below is from RGBStock!</p>
<div id="attachment_425" class="wp-caption alignright" style="width: 235px"><a href="http://www.codecrunch.com/wp-content/uploads/2010/08/building.jpg"><img src="http://www.codecrunch.com/wp-content/uploads/2010/08/building-225x300.jpg" alt="Austrain Architecture at it&#039;s finest! Courtesy of RGBStock.com" title="Austrain Architecture at it&#039;s finest! Courtesy of RGBStock.com" width="225" height="300" class="size-medium wp-image-425" /></a><p class="wp-caption-text">Austrain Architecture at it's finest! Courtesy of RGBStock.com</p></div>
<p><a rel="nofollow" href="http://photl.com/" style="font-size:150%;">photl</a> &#8211; Photl allows you to download a set limit each day, currently up to 35 Mb. They have a unique cropping tool that allows you download parts of images. I found this to be handy when I found an image of a coffee cup, but I didn&#8217;t want the beans that were with it. This image cropping tool can be a real time saver.</p>
<p><a rel="nofollow" href="http://woophy.com" style="font-size:150%;">Woophy</a> &#8211; If you need regional photography &#8211; this place has it nailed. Being from Oregon, I clicked on their map in the general area I am from and found some amazing photography. I added this one to my bookmarks right away. <em>N.B. &#8211; This site is for non-commercial use only but it&#8217;s map overlay was too cool for me to leave them out.</em></p>
<p><a rel="nofollow" href="http://allourstock.com/" style="font-size:150%;">AllOurStock</a> &#8211; This is a smaller and newer site, but there are some photography gems to be found. All the images on AllOurStock are public domain, so you can use freely as you need.</p>
<p><a rel="nofollow" href="http://www.geekphilosopher.com/GeekPhilosopher.com/photos/photos.aspx" style="font-size:150%;">GeekPhilosopher</a> &#8211; Yet another smaller site, but the images are free. There are many abstracts that can be used in your web projects.</p>
<p>I also wanted to note that a quick way to get up to <a href="/go/istock/">52 high quality stock photos each year</a>, is to visit iStock Photo on a weekly basis. They give away one free photograph each week, and you can download it in the highest resolution they offer which makes this a win-win for you!</p>
<div class="shr-publisher-275"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic --><img src="http://feeds.feedburner.com/~r/WebmasterTutorialsCodecrunch/~4/fojh45Uoisc" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.codecrunch.com/2010/08/free-weekly-photographs-free-stock-photo-sites/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.codecrunch.com/2010/08/free-weekly-photographs-free-stock-photo-sites/</feedburner:origLink></item>
		<item>
		<title>Bye Bye Archives</title>
		<link>http://feedproxy.google.com/~r/WebmasterTutorialsCodecrunch/~3/3wNQxcsHlvo/</link>
		<comments>http://www.codecrunch.com/2010/08/bye-bye-archive/#comments</comments>
		<pubDate>Tue, 10 Aug 2010 16:09:34 +0000</pubDate>
		<dc:creator>Cory Crampton</dc:creator>
				<category><![CDATA[Site News]]></category>

		<guid isPermaLink="false">http://www.codecrunch.com/wpress/?p=51</guid>
		<description><![CDATA[It's an age old dilemma. Keep archives older than a few years or scrap them? I've decided in the best interest of fresh content , new tutorials, and our reinvented vigor - to simply get rid of most of the old CodeCrunch tutorials.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>Many methods used in these older articles and tutorials were out-dated, and are not in the spirit of where I want this site to be headed. So, for some time, you may get some 404 errors &#8211; but be assured that new and fresh content will be taking the place of the deleted archives. I have some great plans lined up for some tutorials and Open Source code for your to use in your projects.</p>
<p>I also took a real hard look at why I would want to keep the older articles, and honestly, the main reason for me was financial purposes. (Ad revenue) That&#8217;s when I knew it had to be deleted, I just couldn&#8217;t possibly sit on old content and expect that to carry the new site theme in the right direction. I did keep some older, relevant Photoshop tutorials, as I want to revisit them sometime in the near future as I feel some of the techniques can be carried a lot farther, and having the old posts to refer to will be handy.</p>
<p>Also, if you would like to contribute to CodeCrunch, please read our <a href="/submit-your-articles-and-tutorials/">general outline of articles and content that we accept</a>.</p>
<div class="shr-publisher-51"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic --><img src="http://feeds.feedburner.com/~r/WebmasterTutorialsCodecrunch/~4/3wNQxcsHlvo" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.codecrunch.com/2010/08/bye-bye-archive/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.codecrunch.com/2010/08/bye-bye-archive/</feedburner:origLink></item>
		<item>
		<title>WordPress and Thesis – Can’t we all just get along?</title>
		<link>http://feedproxy.google.com/~r/WebmasterTutorialsCodecrunch/~3/zr0CBJUxJpI/</link>
		<comments>http://www.codecrunch.com/2010/08/wordpress-thesis-opensource-debate/#comments</comments>
		<pubDate>Mon, 09 Aug 2010 16:49:19 +0000</pubDate>
		<dc:creator>Cory Crampton</dc:creator>
				<category><![CDATA[Open Source]]></category>
		<category><![CDATA[chris pearson]]></category>
		<category><![CDATA[gpl]]></category>
		<category><![CDATA[matt mullenweg]]></category>
		<category><![CDATA[open source]]></category>
		<category><![CDATA[thesis]]></category>
		<category><![CDATA[wordpress]]></category>

		<guid isPermaLink="false">http://www.codecrunch.com/wpress/?p=70</guid>
		<description><![CDATA[For those that are unaware, recent events have pitted the creator of Wordpress against a Worpress Theme creator - DIY Themes, more specifically the framework known as Thesis. Chris Pearson, the creator of Thesis, refused to recognize the GPL in full. Here's my take on this debate.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>Firstly, let me state that I have no vested interest in either party. Yes &#8211; it seems that a partial GPL has been adopted. Yes, I just dumped Joomla and years of content down the tubes because I wanted to start fresh, and went with WordPress as the new framework for the site. But let me just put aside WordPress and Thesis, to look at a much simpler issue at hand &#8211; the GPL, what it means to us, and why I feel Chris Pearson is going to change minds.</p>
<p><em>Synopsis &#8211; Chris:</em> Chris Pearson is the owner and founder of DIY Themes, a service that offers an extended framework and themes for the basic WordPress software. He believes that his code, which is separate and independent of WordPress, should not have to follow the GPL guidelines that were set into motion with the creation of WordPress.<em>N.B. &#8211; Thesis has adopted a partial GPL , and this article outlines the overall outcome.</em></p>
<p><em>Synopsis &#8211; Matt:</em> As the founder of WordPress, Matt Mullenweg and the other developers of Worpdress released their software under the GPL, which in short states that any software released as a derivative or conditionally built to function with their software as the core, needs to be released under the GPL.</p>
<h2>My Take on the Argument</h2>
<p>Let me start by pointing out that Matt and Chris both appeared in an impromptu discussion about this issue on Mixergy. I have listened to the whole conversation, and I have certainly thought about what both of them had to say. However, as a developer myself, long before either of them &#8211; I must say clearly that Matt understands the spirit of the GPL as it was intended. Let me tell you why :</p>
<p>Chris Pearson had to start somewhere with his software. If WordPress did not exist, and was not GPL in the first place, he never would have created Thesis. In undertaking the Thesis project, the rules of the GPL were already set into motion. This simply means that at some point during developmental planning, Chris had to take a look at the GPL and decide to adopt it or not. Since he concedes that he does not believe that the GPL is fair, one can reasonably assume that he should have not proceeded, because he did not agreed to it&#8217;s terms, which were clearly set out before he started his project.</p>
<p>To be fair in my analysis, Matt probably could have better explained the overall flow of the GPL to Chris better. I understand Chris to be very intelligent, and a highly likable guy, and I think with a better understanding of what it is that Matt and the Open Source GPL community at large were asking of him, then he would have be willing to meet in the middle much sooner. I find myself thinking of the numerous times that I have purchased Open Source GPL software simply because I wanted the freedom to do what I wanted with the software. In the context that Chris is delivering his message, he is simply stating that he feels he &#8220;<em>Should be able to do what he wants&#8230;</em>&#8221; <strong>I simply couldn&#8217;t agree more, and that&#8217;s what Chris needs to hear</strong>.</p>
<p>No statement is more profound or matching of the overall message of the GPL. <strong>Give us software in the spirit that the software was given to you</strong>. There is no argument that can refute the basis of this statement, simply because the flow of the software creation process is always dictated by the person that created the original software. Chris wants creative control over his software, and is afraid that if he releases it GPL, others will take the Thesis framework, and undercut his sales. History will prove that is indeed true, coders are always taking pieces of others code, porting it, tweaking it and calling it their own. The one thing that Chris needs to understand, is that with people like you and I behind his solid framework, he need not worry about good coders, and ethically sound supporters stealing his work. We&#8217;re (meaning supporters) always going to want the real deal, in this case &#8211; Thesis with WordPress. <strong>Not Thesis X2, Not Thesis Nuke, Not Thesis Post Nuke. (Oh yes I did&#8230;&#8230;)</strong></p>
<p>Let me ask you something. Is there a spin off of WordPress that I am unaware of that just blows away the framework with some newer MVC methods or outside frame that distinguishes itself enough to be a completely different project? If so, is it GPL? Do you think that making a framework on top of anothers work constitutes a derivative work?</p>
<p>I think Chris did an outstanding job of sticking to his beliefs, but I feel that Matt &#8211; overall, embodies the spirit of the GPL. What&#8217;s this spirit I keep referring to? It&#8217;s called integrity, and the belief that no matter how good you think you are &#8211; you can always be better with the help of others. At least that&#8217;s how I see it.</p>
<h2>Why I think Chris Will Change Minds</h2>
<p>I&#8217;m not saying that I feel any ill feelings towards Chris, but it really seems to me that Generation Y thinks they own the internet sometimes. Because they are much younger, and really do fuel new technologies, I feel this sometimes empowers them to make their own rules when they can&#8217;t fit into existing ones. Chris is business savvy, a smooth talker, and you can tell he firmly believes he is right with regards towards this issue by simply listening to him. I think his actions from here forward will drive the way that software is created, and I think with him behind the GPL , rather than against it &#8211; it could possibly spark a newer movement in the right direction, especially from within his generation.</p>
<p>Any thoughts?</p>
<h2>Thesis Adopts a Partial GPL</h2>
<p>I&#8217;m really overwhelmed with a sense of relief that Chris decided to partially GPL his code. This is definitely a step in the right direction. In doing so &#8211; Chris can get back to work on Thesis, Matt can move on with his projects, and we can all learn from the experience. I hope that Thesis continues to thrive, and that Matt continues to be in the forefront for Open Source and GPL licensed software.</p>
<div class="shr-publisher-70"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic --><img src="http://feeds.feedburner.com/~r/WebmasterTutorialsCodecrunch/~4/zr0CBJUxJpI" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.codecrunch.com/2010/08/wordpress-thesis-opensource-debate/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://www.codecrunch.com/2010/08/wordpress-thesis-opensource-debate/</feedburner:origLink></item>
		<item>
		<title>ASCAP vs The Internet Round 3</title>
		<link>http://feedproxy.google.com/~r/WebmasterTutorialsCodecrunch/~3/CJW_bbff6Gc/</link>
		<comments>http://www.codecrunch.com/2010/08/ascap-vs-the-internet-round-3/#comments</comments>
		<pubDate>Mon, 09 Aug 2010 08:30:26 +0000</pubDate>
		<dc:creator>Cory Crampton</dc:creator>
				<category><![CDATA[Off the Path]]></category>
		<category><![CDATA[ascap]]></category>
		<category><![CDATA[creative commons]]></category>
		<category><![CDATA[licensing]]></category>
		<category><![CDATA[music]]></category>
		<category><![CDATA[open source]]></category>

		<guid isPermaLink="false">http://www.codecrunch.com/wpress/?p=153</guid>
		<description><![CDATA[ASCAP (The American Society of Composers, Authors and Publishers) is back at it again, this time targeting the Creative Commons licensing schemes. Another example of one medium trying to impose their will on another.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>Apparently last week ASCAP sent letters out to all of their &#8216;members&#8217;, with a call for fundraising to combat &#8216;opponents&#8217; such as the Creative Commons. It&#8217;s not the first time that ASCAP has tried to bully smaller, yet perfectly viable licensing schemes out of the picture.</p>
<p>As a guitar player of 20 years, and having written numerous songs, I understand the need for a streamlined process whereby music is protected for the author. What&#8217;s not really transparent from ASCAP is their reasoning, but let me go out on limb and say it always has to do with the almighty dollar. As noted on the Creative Commons website, musicians such as NIN have purposely selected their own licensing scheme as a means of controlling their own destiny for their music.</p>
<p>I&#8217;ve been doing alot of reading on this topic, mostly posts in response to articles written about a musicians rights, and their ability to interpret a license. Let me just say this &#8211; I may be an exception, but I certainly don&#8217;t think a larger more corporate approach to license interpretation is where the answer is. Certainly we can all benefit from collectively bargaining as a group, but the group has to agree on everything &#8211; and with ASCAP that just will not happen, it will always be biased. What is their main interest in shutting down the Creative Commons? I&#8217;d be interested in hearing your opinions.</p>
<p>The president of ASCAP continually barks out stuff like this , as if to speak for all musicians, but I can assure you that I don&#8217;t agree with this sentiment at all:</p>
<blockquote><p>I am well aware of those &#8220;copyleft&#8221; mouthpieces who take a highly critical view of ASCAP&#8217;s efforts to protect our members&#8217; rights&#8230; What I find most fascinating is that those who purport to support a climate of free culture work so hard to silence opposing points of view. They will not silence me&#8230;.Paul Williams ASCAP President</p></blockquote>
<p>I find it rather funny that ASCAP continues to wage war on the very &#8220;mouthpieces&#8221; that allows it to stay in business &#8211; the people that buy the music. You see, Mr. Williams wants a paycheck for being a musician, which I fully understand and support. However, what Mr. Williams is saying is that all music should be this way, and that the Creative Commons is taking away musicians rights, and that&#8217;s just not the case. The bottom line is that musicians are choosing for themselves what they want, giving less control and credibility to third party companies in our digital age. Nobody wants Paul Williams silenced, we just want him to be a leader in this digital age, to stop ranting, and start getting some meaningful relationships built vice tearing down walls.</p>
<p>You can read the full article and keep up on the news <a rel="nofollow" href="http://creativecommons.org/weblog/entry/22643?utm_source=ccorg&amp;utm_medium=postbanner">here</a>.</p>
<div class="shr-publisher-153"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic --><img src="http://feeds.feedburner.com/~r/WebmasterTutorialsCodecrunch/~4/CJW_bbff6Gc" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.codecrunch.com/2010/08/ascap-vs-the-internet-round-3/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.codecrunch.com/2010/08/ascap-vs-the-internet-round-3/</feedburner:origLink></item>
		<item>
		<title>Forums Closed &amp; Site Maintenance</title>
		<link>http://feedproxy.google.com/~r/WebmasterTutorialsCodecrunch/~3/ETusqfaNZdo/</link>
		<comments>http://www.codecrunch.com/2010/07/forums-closed-and-site-maintenance/#comments</comments>
		<pubDate>Wed, 28 Jul 2010 00:05:28 +0000</pubDate>
		<dc:creator>Cory Crampton</dc:creator>
				<category><![CDATA[Site News]]></category>

		<guid isPermaLink="false">http://www.codecrunch.com/wpress/?p=46</guid>
		<description><![CDATA[Due to the sheer amount of continual spam on the old forums, I've just decided to shut them down all together. They really were not getting used, and combing through all the IP's just really wasn't worth the effort.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>This is actually good news in a way, as I made myself find time to clean up the site, and convert from a Joomla install to a WordPress installation. The change was made because I simply don&#8217;t need anything more than WordPress right now to write articles and share my content. Looking forward to another great year!</p>
<p>I also would like to extend an open hand to the same, continual users who find it &#8216;fun&#8217; to post comment spam and continually probe the server for vulnerabilities. It&#8217;s actually users like you who the community would benefit from the most as many of you have the right intentions, but are approaching sites like ours in the wrong spirit.</p>
<p>So, in short &#8211; I call on you (you know who you are) to join in my efforts to make things a little more fluid. If you want to be part of a community that embraces your abilities, then please &#8211; join me in helping others. However, if you continue to walk the path less traveled, that of a script kiddie, then you will not be welcome at all. Consider this our one and only invitation to cease and desist.</p>
<div class="shr-publisher-46"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic --><img src="http://feeds.feedburner.com/~r/WebmasterTutorialsCodecrunch/~4/ETusqfaNZdo" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.codecrunch.com/2010/07/forums-closed-and-site-maintenance/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.codecrunch.com/2010/07/forums-closed-and-site-maintenance/</feedburner:origLink></item>
		<item>
		<title>Photoshop Magic Marker Effect</title>
		<link>http://feedproxy.google.com/~r/WebmasterTutorialsCodecrunch/~3/JHlP64DwK7I/</link>
		<comments>http://www.codecrunch.com/2010/05/photoshop-magic-marker-effect/#comments</comments>
		<pubDate>Fri, 07 May 2010 22:30:45 +0000</pubDate>
		<dc:creator>Cory Crampton</dc:creator>
				<category><![CDATA[Tutorials]]></category>
		<category><![CDATA[magic marker effect]]></category>
		<category><![CDATA[photoshop marker]]></category>

		<guid isPermaLink="false">http://www.codecrunch.com/wpress/?p=259</guid>
		<description><![CDATA[Sometimes you'll want to make your text look like it was written with a marker on real paper (or some other surface), and the fonts that look like handwriting are not accurate enough for you. Fortunately, Photoshop has a few tools that will help give your text a nice, somewhat distressed inky effect for a realistic 'marker' effect.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>You can get some <a href="http://www.free-fonts.com/handwriting_fonts.html" target="_blank">handwriting fonts here</a> that you can use to follow along with and create your own samples. Just remember that you&#8217;ll want to choose one that isn&#8217;t too choppy or blocky for a better end result.</p>
<p>I&#8217;ve included a jpeg as an attachement on the last page of this tutorial. If you simply can&#8217;t wait to see what the output will be &#8211; it should look something like the photograph included with this tutorial.</p>
<ol>
<li>Start with a <a href="http://www.free-fonts.com/handwriting_fonts.html" target="_blank">good handwriting-style font</a>; the less computer-generated it looks, the better. Type your test, apply whatever distortions, et cetera, you&#8217;d like, and rasterize your layer. We&#8217;ll be using black text for this example, but you can alter the color later. </li>
<li>Choose Filter -&gt; Blur -&gt; Gaussian Blur&#8230; Be careful! Even for a large image you won&#8217;t want to blur your text by more than a pixel or two. The goal is to create a slight halo of fuzz around solid, readable text, not to actually make your text seem blurry. </li>
<li>Duplicate your layer of text. </li>
<li>Choose Filter -&gt; Stylize -&gt; Wind&#8230; The default settings should suffice. </li>
<li>Merge your two layers of text together. </li>
<li>Choose Filter -&gt; Distort -&gt; Ripple&#8230; The exact amount of distortion you choose to apply here will depend on how large your image is and where on the Canvas your text is located, but you will want to keep it subtle; the goal is to apply a bit of randomness and shakiness to your &#8216;handwriting&#8217;, not to actually see ripples.</li>
</ol>
<p>You may be done here, if you are simply looking to replicate the marker look on a clean background. If you&#8217;re trying to make the marker texture appear as if you actually wrote or drew on the underlying layer, continue with the steps on the next page of this tutorial.</p>
<p>If you&#8217;re trying to make the marker texture appear as if you actually wrote or drew on the underlying layer, continue with the steps below :</p>
<ul>
<li>Change the text layer&#8217;s blending mode to Soft Light. </li>
<li>Duplicate it two to four times, each time leaving the blending mode on Soft Light.</li>
</ul>
<p>These individual layers may be adjusted for color and opacity as you see fit, to create the effect that suits your particular image and your personal taste. Below is a sample output of what this effect can do. Your mileage may very as you are probably using a different font :</p>
<p align="center"><img src="http://www.codecrunch.com/content_images/ps_marker_tutorial.jpg" align="baseline" border="0" height="110" width="250" /></p>
<div class="shr-publisher-259"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic --><img src="http://feeds.feedburner.com/~r/WebmasterTutorialsCodecrunch/~4/JHlP64DwK7I" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.codecrunch.com/2010/05/photoshop-magic-marker-effect/feed/</wfw:commentRss>
		<slash:comments>5</slash:comments>
		<feedburner:origLink>http://www.codecrunch.com/2010/05/photoshop-magic-marker-effect/</feedburner:origLink></item>
		<item>
		<title>MYSQL Fulltext – Changing the word Length</title>
		<link>http://feedproxy.google.com/~r/WebmasterTutorialsCodecrunch/~3/KwkX2T67GdY/</link>
		<comments>http://www.codecrunch.com/2010/04/mysql-fulltext-changing-the-word-length/#comments</comments>
		<pubDate>Tue, 13 Apr 2010 19:53:47 +0000</pubDate>
		<dc:creator>Cory Crampton</dc:creator>
				<category><![CDATA[Code]]></category>
		<category><![CDATA[Uncategorized]]></category>
		<category><![CDATA[database]]></category>
		<category><![CDATA[fulltext]]></category>
		<category><![CDATA[mysql]]></category>

		<guid isPermaLink="false">http://www.codecrunch.com/wpress/?p=236</guid>
		<description><![CDATA[The MySQL fulltext search feature allows you to index your database and make the text fully searchable. If you want to index character counts less than 4, you will need to adjust your MySQL configuration.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>This is more a simple share than a tutorial. Back in 2004 I was working on a site that had a relatively small database (MYSQL), with about 50K records.</p>
<p>The DB was indexed so that full text searching could be used, but I found that whenever a user would search for common words under a certain length (in this case under 4 letters), no results would be returned. An example of a query that I tested was &#8220;ASP&#8221;, which of course returned zero results.</p>
<p>This is simply because by default, MYSQL fulltext is setup to allow only indexing of 4 letters. I&#8217;ve never had to change my maximum word length, but according to the MYSQL documentation &#8211; the length varies by version. Anyone have more insight on this?</p>
<p>To change your minimum word length, you must simply edit the ft_min_word_length by adding it to an options file like this :</p>
<p><code>[mysqld]<br /> ft_min_word_len=3</code></p>
<p>Once you have done this &#8211; you must rebuild your indexes, or like me, not read the documentation and wonder why it isn&#8217;t working for 2 hours. In addition to changing the word length, you may have to over ride the installed default stopword list. You can find more information on how to do this at the <a title="Mysql Fulltext" target="_blank" href="http://dev.mysql.com/doc/refman/5.1/en/fulltext-fine-tuning.html">MYSQL Fulltext doc page</a>.</p>
<p>I haven&#8217;t had a need to use fulltext searching since that project in 2004, but I thought I would save someone out there a couple of hours of hair pulling. You will also notice on the MYSQL documentation pages, information on search thresholds. I didn&#8217;t find the need to tweak these parameters, but for fun times sake &#8211; I will have to do so in the near future and share my results. Most people find that the default stoplist and thresholds meet their needs, but I can imagine a few scenarios where you would want the fulltext features of MYSQL to work quite different.</p>
<p>For example &#8211; an acronym database. What a project to tackle &#8211; getting the search threshold and stop list to NOT return every result for AAA, and also to NOT return zero sets.</p>
<p>Interesting.</p>
<div class="shr-publisher-236"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic --><img src="http://feeds.feedburner.com/~r/WebmasterTutorialsCodecrunch/~4/KwkX2T67GdY" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.codecrunch.com/2010/04/mysql-fulltext-changing-the-word-length/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://www.codecrunch.com/2010/04/mysql-fulltext-changing-the-word-length/</feedburner:origLink></item>
	</channel>
</rss>

