<?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>Line In Web Design</title>
	
	<link>http://line-in.co.uk</link>
	<description>Let's build you an amazing Wordpress Site</description>
	<lastBuildDate>Mon, 06 Sep 2010 16:55:20 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.0.1</generator>
		<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/LineInWebDesign" /><feedburner:info uri="lineinwebdesign" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><item>
		<title>The Comment Link Suggest-O-Tron</title>
		<link>http://feedproxy.google.com/~r/LineInWebDesign/~3/q77wvcqwpB4/</link>
		<comments>http://line-in.co.uk/the-comment-link-suggest-o-tron/#comments</comments>
		<pubDate>Mon, 06 Sep 2010 16:00:55 +0000</pubDate>
		<dc:creator>Simon</dc:creator>
				<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://line-in.co.uk/?p=665</guid>
		<description><![CDATA[<p><img width="620" height="168" src="http://line-in.co.uk/wp-content/uploads/2010/09/comment_link_header-620x168.jpg" class="attachment-large wp-post-image" alt="comment_link_header" title="comment_link_header" /></p>If you run a blog and you&#8217;re anything like me, you have a huge ego that needs to be fed regularly and there is nothing more nourishing than a long list of comments and responses to something intelligent, useful or [...]]]></description>
			<content:encoded><![CDATA[<p><img width="620" height="168" src="http://line-in.co.uk/wp-content/uploads/2010/09/comment_link_header-620x168.jpg" class="attachment-large wp-post-image" alt="comment_link_header" title="comment_link_header" /></p><p>If you run a blog and you&#8217;re anything like me, you have a huge ego that needs to be fed regularly and there is nothing more nourishing than a long list of comments and responses to something intelligent, useful or insightful that you&#8217;ve published.</p>
<p>So how do you get your visitors to leave you a nice <del>meal</del> message?</p>
<p>With my nifty new plugin, the <a href="http://wordpress.org/extend/plugins/comment-link-suggest-o-tron/">Comment Link Suggest-O-Tron</a>!</p>
<p>The Suggest-O-Tron sits under your Edit Posts box and reminds, nay DEMANDS that you post a question or prompt to get people to start a discussion.</p>
<p><span id="more-665"></span></p>
<h3>Suggest-O-Tron Suggestions</h3>
<p>And, in case you can&#8217;t think of anything to write, it comes with a built in list of pre-written sentences scientifically proven* to increase the number of comments on your blog posts.</p>
<p style="text-align: center;">
<div id="attachment_669" class="wp-caption aligncenter" style="width: 470px"><a rel="attachment wp-att-669" href="http://line-in.co.uk/the-comment-link-suggest-o-tron/2-comment-link-screenshot/"><img class="size-medium wp-image-669 " title="Comment Link Suggest-O-Tron Suggestions!" src="http://line-in.co.uk/wp-content/uploads/2010/09/2-comment-link-screenshot-460x184.jpg" alt="" width="460" height="184" /></a><p class="wp-caption-text">Comment Link Suggest-O-Tron Suggestions!</p></div>
<p>Using my patented** Comment Tag Builder™, you decide which words or phrases appear as links and the Suggest-O-Tron takes care of the messy task of building links.</p>
<p>Cleverly, the links it builds lead directly to the Reply area, forcing folks to fill out the form before they have time to focus.</p>
<p>Devious, yes, but when you absolutely have to have those comments, sometimes drastic measures are necessary.</p>
<p>Finally, in a fit of fantasticness, it also works in RSS feeds. This is valuable stuff, because there are no comments lists or reply forms in feeds. With this plugin&#8217;s direct linkage, however, people reading in readers will not miss out on the opportunity to leave a response!</p>
<p>Quick Summary of All the Awesome Things:</p>
<ul class="tick-list">
<li>List of pre-written comment prompts</li>
<li>Ability to add and delete oft-used comment prompts to your list, saving you seconds on every post!</li>
<li>Automatically adds a link right back to your comments form</li>
<li>Works in RSS feeds, prompting people to click through back to your site</li>
<li>Ability to add basic formatting &#8211; bold and italicise it so it metaphorically grabs people by the scruff of the neck and throws them towards the Leave a Reply form</li>
<li>Knows whether you&#8217;re using the  tags or not and only shows if you&#8217;re not. It&#8217;s pretty smart like that.</li>
</ul>
<h3>Simon! Simon! I want it sooo bad! How do I get it?</h3>
<p>This sterling example of WordPress engineering is available for your downloading pleasure direct from its own page on the <a href="http://wordpress.org/extend/plugins/comment-link-suggest-o-tron/">WordPress repository</a>.</p>
<p>If you have bug reports or feature suggestions, I&#8217;ve created a page under my new Plugins menu item where you can <a href="http://line-in.co.uk/plugins/comment-link-suggest-o-tron">ask for help or suggest improvements</a>.</p>
<p>Here&#8217;s to many happy comment-filled posts!</p>
<p>*This might be a lie.<br />
**It might not be patented.</p>
<img src="http://line-in.co.uk/?ak_action=api_record_view&id=665&type=feed" alt="" />

<p>Related posts:<ol><li><a href='http://line-in.co.uk/getting-a-good-conversion-rate/' rel='bookmark' title='Permanent Link: Why You Should Be Tracking Your Conversions'>Why You Should Be Tracking Your Conversions</a></li>
<li><a href='http://line-in.co.uk/referral-competition/' rel='bookmark' title='Permanent Link: Competition &#8211; Win a Free Blog Consultation!'>Competition &#8211; Win a Free Blog Consultation!</a></li>
<li><a href='http://line-in.co.uk/optimize-wordpress-database/' rel='bookmark' title='Permanent Link: Optimize Your WordPress Database'>Optimize Your WordPress Database</a></li>
</ol></p><img src="http://feeds.feedburner.com/~r/LineInWebDesign/~4/q77wvcqwpB4" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://line-in.co.uk/the-comment-link-suggest-o-tron/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://line-in.co.uk/the-comment-link-suggest-o-tron/</feedburner:origLink></item>
		<item>
		<title>Create a Quick Grassy Hill in Illustrator with the Crystallize Tool</title>
		<link>http://feedproxy.google.com/~r/LineInWebDesign/~3/5AKWh7_FZqA/</link>
		<comments>http://line-in.co.uk/illustrator-crystallize-tool/#comments</comments>
		<pubDate>Mon, 30 Aug 2010 16:00:01 +0000</pubDate>
		<dc:creator>Simon</dc:creator>
				<category><![CDATA[Illustrator]]></category>
		<category><![CDATA[Tutorials]]></category>

		<guid isPermaLink="false">http://line-in.co.uk/?p=624</guid>
		<description><![CDATA[<p><img width="620" height="375" src="http://line-in.co.uk/wp-content/uploads/2010/08/Quick-Grassy-Hill-620x375.jpg" class="attachment-large wp-post-image" alt="Quick Grassy Hill in Illustrator" title="Quick Grassy Hill in Illustrator" /></p>A tutorial on creating a quick hill using one of Illustrator's Liquify tools.]]></description>
			<content:encoded><![CDATA[<p><img width="620" height="375" src="http://line-in.co.uk/wp-content/uploads/2010/08/Quick-Grassy-Hill-620x375.jpg" class="attachment-large wp-post-image" alt="Quick Grassy Hill in Illustrator" title="Quick Grassy Hill in Illustrator" /></p><p>Illustrator offers some very powerful tools for doing damage to your designs. In this tutorial, I want to show you how to quickly create a grassy hill using the Crystallize tool. </p>
<p>1) Start with a new document <code>(Cmd/Ctrl + N)</code>, and give it a name. In a fit of originality, I called mine  &#8216;Quick Grassy Hill&#8217;. Set the dimensions to 600px wide and 400px high.</p>
<p><a href="http://line-in.co.uk/illustrator-crystallize-tool/1_set_up_illustrator/" rel="attachment wp-att-626"><img src="http://line-in.co.uk/wp-content/uploads/2010/08/1_set_up_illustrator-620x309.jpg" alt="Set Up Illustrator" title="Set Up Illustrator" width="620" height="309" class="aligncenter size-large wp-image-626" /></a></p>
<p><span id="more-624"></span></p>
<p>2) Using the <code>Pen Tool (p)</code>, sketch out a rough hill shape.</p>
<p><a href="http://line-in.co.uk/illustrator-crystallize-tool/2_illustrator_pen_tool/" rel="attachment wp-att-627"><img src="http://line-in.co.uk/wp-content/uploads/2010/08/2_illustrator_pen_tool-620x333.jpg" alt="Illustrator Pen Tool" title="Illustrator Pen Tool" width="620" height="333" class="aligncenter size-large wp-image-627" /></a></p>
<p>3) Select the Stroke in the Tools palette, then set it to <code>none (/)</code>.</p>
<p><a href="http://line-in.co.uk/illustrator-crystallize-tool/3_illustrator_stroke/" rel="attachment wp-att-628"><img src="http://line-in.co.uk/wp-content/uploads/2010/08/3_illustrator_stroke-620x479.jpg" alt="Illustrator Stroke" title="Illustrator Stroke" width="620" height="479" class="aligncenter size-large wp-image-628" /></a></p>
<p>4) With the hill shape still selected, click on the Gradients panel, then click on the default gradient swatch.</p>
<p><a href="http://line-in.co.uk/illustrator-crystallize-tool/4_illustrator_gradients/" rel="attachment wp-att-629"><img src="http://line-in.co.uk/wp-content/uploads/2010/08/4_illustrator_gradients-620x363.jpg" alt="Illustrator Gradients" title="Illustrator Gradients" width="620" height="363" class="aligncenter size-large wp-image-629" /></a></p>
<p>6) Using the <code>Gradient Tool (G)</code>, click and drag in the direction of the arrow to set the gradient angle and length to something like this. This will give it some appearance of light and depth, but if you want to make the hill look even better, you could use the <code>Gradient Mesh Tool</code> to create some curves on the gradientto give it a real 3D feel.</p>
<p>If I did that, though, it wouldn&#8217;t be a Quick Grassy Hill (maybe I&#8217;ll come back to it in another tutorial).</p>
<p><a href="http://line-in.co.uk/illustrator-crystallize-tool/5_illustrator_gradient_tool/" rel="attachment wp-att-630"><img src="http://line-in.co.uk/wp-content/uploads/2010/08/5_illustrator_gradient_tool-620x407.jpg" alt="The Illustrator Gradient Tool" title="The Illustrator Gradient Tool" width="620" height="407" class="aligncenter size-large wp-image-630" /></a></p>
<p>5) With the hill still selected, go back to the gradient palette and set the colours of the gradient to R = 0, G = 120, B = 0 and R = 0, G = 69, B = 0.</p>
<p><a href="http://line-in.co.uk/illustrator-crystallize-tool/6_illustrator_gradient_settings/" rel="attachment wp-att-631"><img src="http://line-in.co.uk/wp-content/uploads/2010/08/6_illustrator_gradient_settings.jpg" alt="Illustrator Gradient Settings" title="Illustrator Gradient Settings" width="554" height="495" class="aligncenter size-full wp-image-631" /></a></p>
<p>7) Now to make us some grass! Select the <code>Crystallize tool</code>, which is kept under the <code>Liquify Tools</code>.</p>
<p><a href="http://line-in.co.uk/illustrator-crystallize-tool/7_illustrator_crystallize_tool/" rel="attachment wp-att-634"><img src="http://line-in.co.uk/wp-content/uploads/2010/08/7_illustrator_crystallize_tool-620x509.jpg" alt="Illustrator Crystallize Tool" title="Illustrator Crystallize Tool" width="620" height="509" class="aligncenter size-large wp-image-634" /></a></p>
<p>8) Double click the Crystallize Tool icon to open up the tool options dialog. Here are the settings I used, but you might want to experiment for different types of grass: </p>
<p><a href="http://line-in.co.uk/illustrator-crystallize-tool/11_illustrator_crystallize_settings/" rel="attachment wp-att-639"><img src="http://line-in.co.uk/wp-content/uploads/2010/08/11_illustrator_crystallize_settings.jpg" alt="Crystallize Settings Illustrator" title="Crystallize Settings Illustrator" width="496" height="475" class="aligncenter size-full wp-image-639" /></a></p>
<p>If you want finer blades of grass, set the complexity and detail higher and the size lower.</p>
<p>9) Zoom in to the bottom left hand corner of the hill, then simply click and drag to start making grass. Do short sections, stopping to see how it&#8217;s going and if it&#8217;s not looking good simply Undo <code>(Cmd/Ctrl + z)</code> and try again. </p>
<p><a href="http://line-in.co.uk/illustrator-crystallize-tool/8_illustrator_create_grass/" rel="attachment wp-att-635"><img src="http://line-in.co.uk/wp-content/uploads/2010/08/8_illustrator_create_grass-620x453.jpg" alt="Making grass with Illustrator" title="Making grass with Illustrator" width="620" height="453" class="aligncenter size-large wp-image-635" /></a></p>
<p><em>Tip: Keep the center of the cursor (the little plus) within the green to prevent the tool pushing the blades of grass into the hill.</em></p>
<p>10) Keep going around the top of the hill until you&#8217;ve covered it in grass. If you&#8217;ve crystallized the underneath of the corners of the hill, simply grab the <code>Pen Tool (p)</code> and click the tips of the spikes to delete them.</p>
<p><a href="http://line-in.co.uk/illustrator-crystallize-tool/9_illustrator_pen_delete/" rel="attachment wp-att-636"><img src="http://line-in.co.uk/wp-content/uploads/2010/08/9_illustrator_pen_delete-620x479.jpg" alt="Deleting with the Pen in Illustrator" title="Deleting with the Pen in Illustrator" width="620" height="479" class="aligncenter size-large wp-image-636" /></a></p>
<p>And there you have your grassy hill, ready to be dropped into your designs!</p>
<p><a href="http://line-in.co.uk/illustrator-crystallize-tool/10_illustrator_hill/" rel="attachment wp-att-637"><img src="http://line-in.co.uk/wp-content/uploads/2010/08/10_illustrator_hill-620x348.jpg" alt="Finished Hill in Illustrator" title="Finished Hill in Illustrator" width="620" height="348" class="aligncenter size-large wp-image-637" /></a></p>
<p>If you enjoyed this, you might also like my tutorial on creating a <a href='http://line-in.co.uk/3d-pipe-illustrator'>3d pipe</a> using Illustrator&#8217;s Revolve tool.</p>
<img src="http://line-in.co.uk/?ak_action=api_record_view&id=624&type=feed" alt="" />

<p>Related posts:<ol><li><a href='http://line-in.co.uk/3d-pipe-illustrator/' rel='bookmark' title='Permanent Link: Creating a 3D Pipe with Illustrator and Photoshop'>Creating a 3D Pipe with Illustrator and Photoshop</a></li>
<li><a href='http://line-in.co.uk/upgrade-wordpress-3/' rel='bookmark' title='Permanent Link: How To Upgrade To WordPress 3 Safely'>How To Upgrade To WordPress 3 Safely</a></li>
<li><a href='http://line-in.co.uk/optimize-wordpress-database/' rel='bookmark' title='Permanent Link: Optimize Your WordPress Database'>Optimize Your WordPress Database</a></li>
</ol></p><img src="http://feeds.feedburner.com/~r/LineInWebDesign/~4/5AKWh7_FZqA" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://line-in.co.uk/illustrator-crystallize-tool/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://line-in.co.uk/illustrator-crystallize-tool/</feedburner:origLink></item>
		<item>
		<title>Optimize Your WordPress Database</title>
		<link>http://feedproxy.google.com/~r/LineInWebDesign/~3/VVyvGBMPsos/</link>
		<comments>http://line-in.co.uk/optimize-wordpress-database/#comments</comments>
		<pubDate>Mon, 23 Aug 2010 16:00:55 +0000</pubDate>
		<dc:creator>Simon</dc:creator>
				<category><![CDATA[Wordpress]]></category>
		<category><![CDATA[Tutorials]]></category>

		<guid isPermaLink="false">http://line-in.co.uk/?p=586</guid>
		<description><![CDATA[<p><img width="620" height="319" src="http://line-in.co.uk/wp-content/uploads/2010/08/optimising-dbs-header-620x319.jpg" class="attachment-large wp-post-image" alt="Optimizing Your Wordpress Database" title="Optimizing Your Wordpress Database" /></p>WordPress is an amazing publishing platform. Part of its greatness is how user friendly it is, with Revisions being a particular case in point. I can&#8217;t count the number of times that I&#8217;ve had to load up a previous version [...]]]></description>
			<content:encoded><![CDATA[<p><img width="620" height="319" src="http://line-in.co.uk/wp-content/uploads/2010/08/optimising-dbs-header-620x319.jpg" class="attachment-large wp-post-image" alt="Optimizing Your Wordpress Database" title="Optimizing Your Wordpress Database" /></p><p>WordPress is an amazing publishing platform. Part of its greatness is how user friendly it is, with Revisions being a particular case in point. I can&#8217;t count the number of times that I&#8217;ve had to load up a previous version of a post to reclaim some literary nugget that I accidentally deleted in a fit of writer&#8217;s angst.</p>
<p>Unfortunately, in order to save me from myself, it has to use quite a lot of database space. Each revision means one more row in the Posts table, on top of the canonical version that you create every time you hit the Update or Draft versions. If you are like me and painfully obsessive about every single word, or you write epic 5,000 word posts, then that one post could have 20 or 30 revisions saved in addition to your working copy.</p>
<p>Multiply that by the number of posts on your blog, and it could quickly run up to the hundreds or thousands of rows.</p>
<p><span id="more-586"></span></p>
<p>Now, this isn&#8217;t a major problem because MySQL (the database that WordPress uses) is lightning quick and WordPress&#8217; tables are very well structured. However, during the loading of a page WP has to run some pretty complex queries on these tables &#8211; cross-referencing posts, post meta, options and authors &#8211; and the speed of these queries is dependent on the size of the tables.</p>
<p>Larger tables means a longer wait for the results. On smaller blogs we&#8217;re talking milliseconds but as your blog grows it might start turning into a noticeable amount of time. If you have thousands of posts, then it could take a second or more to process.</p>
<p>Add this to the PHP code WP has to process, transmission of files, JavaScript to process and so on and suddenly your blog can seem sluggish and unresponsive.</p>
<p>So, as part of your maintenance and tweaking efforts, it&#8217;s worth considering doing a little bit of database optimization now and again to see if you can&#8217;t speed things up a little on the server side and, if you&#8217;re above 500 posts and have never done it, I&#8217;m pretty certain you&#8217;ll notice a significant increase.</p>
<h3>Backing Up Your Database</h3>
<p>Before we do any work on the database, it&#8217;s absolutely essential that we take a backup of it just in case. Remember, every time someone skips this step, somewhere a fairy dies.</p>
<p>1) Log into your CPanel account, browse down to PHPMyAdmin and click the icon to open it up</p>
<p><a rel="attachment wp-att-533" href="http://line-in.co.uk/upgrade-wordpress-3/1-cpanel-phpmyadmin/"><img class="aligncenter size-large wp-image-533" title="CPanel PHPMyAdmin icon" src="http://line-in.co.uk/wp-content/uploads/2010/06/1-cpanel-phpmyadmin-620x596.jpg" alt="CPanel PHPMyAdmin icon" width="620" height="596" /></a></p>
<p>2) Once you&#8217;re in, select your blog&#8217;s database by clicking on the database name in the right hand panel (<em>note: you might have more databases listed &#8211; make sure you choose the right one!</em>)</p>
<p><a rel="attachment wp-att-532" href="http://line-in.co.uk/upgrade-wordpress-3/2-phpmyadmin-select-db/"><img class="aligncenter size-full wp-image-532" title="PHPMyAdmin Select Database" src="http://line-in.co.uk/wp-content/uploads/2010/06/2-phpmyadmin-select-db.jpg" alt="PHPMyAdmin Select Database" width="553" height="437" /></a></p>
<p>3) Click on &#8216;Export&#8217; along the top menu bar</p>
<p><a rel="attachment wp-att-531" href="http://line-in.co.uk/upgrade-wordpress-3/3-phpmyadmin-export-db/"><img class="aligncenter size-large wp-image-531" title="PHPMyAdmin Export Database" src="http://line-in.co.uk/wp-content/uploads/2010/06/3-phpmyadmin-export-db-620x242.jpg" alt="PHPMyAdmin Export Database" width="620" height="242" /></a></p>
<p>4) Make sure that all of the tables are highlighted here (click <code>Select All</code> if you&#8217;re not sure) :</p>
<p><a rel="attachment wp-att-530" href="http://line-in.co.uk/upgrade-wordpress-3/4-phpmyadmin-select-tables/"><img class="aligncenter size-large wp-image-530" title="PHPMyAdmin Select Tables" src="http://line-in.co.uk/wp-content/uploads/2010/06/4-phpmyadmin-select-tables-620x367.jpg" alt="PHPMyAdmin Select Tables" width="620" height="367" /></a></p>
<p>5) Check the box that says <code>Save As File</code> and then give it a name.</p>
<p><a rel="attachment wp-att-529" href="http://line-in.co.uk/upgrade-wordpress-3/5-phpmyadmin-save-as/"><img class="aligncenter size-large wp-image-529" title="PHPMyAdmin Export tables" src="http://line-in.co.uk/wp-content/uploads/2010/06/5-phpmyadmin-save-as-620x531.jpg" alt="PHPMyAdmin Export tables" width="620" height="531" /></a></p>
<p>6) Click <code>Go</code>, and the browser &#8216;Save as&#8230;&#8217; dialog will pop up. Save this file somewhere safe &#8211; I usually put it on the desktop while I&#8217;m working with it.</p>
<h3>Deleting Your Revisions</h3>
<p>Now that you have a copy of your DB saved somewhere safe in case of catastrophe, we can get on to the good stuff.</p>
<p>Step one is to delete all of your revisions from your <code>wp_posts</code> table. Note, I&#8217;m assuming that your table prefix is <code>wp_</code>. If it&#8217;s not, make sure you replace the <code>wp_</code> with your table prefix in the following code (if you have no clue what I&#8217;m talking about, you can probably safely ignore this).</p>
<p>1) Still in PHPMyAdmin, click on the &#8216;SQL&#8217; tab at the top.</p>
<p><a rel="attachment wp-att-593" href="http://line-in.co.uk/optimize-wordpress-database/1-select-sql/"><img class="aligncenter size-large wp-image-593" title="Select SQL tab" src="http://line-in.co.uk/wp-content/uploads/2010/08/1-select-sql-620x484.jpg" alt="Select SQL tab" width="620" height="484" /></a></p>
<p>Enter the following code in the text box:</p>
<pre class="brush: php;">&lt;br /&gt;
DELETE FROM `wp_posts` WHERE `post_type` = 'revision'&lt;br /&gt;
</pre>
<p><strong>WARNING: This will delete ALL of your post revisions and there is NO undo. Make super sure you want to do this (you have taken a backup right? I do worry).</strong></p>
<p>Click <code>Go</code></p>
<p>It may ask you if you&#8217;re sure. If you are sure, click <code>OK</code>.</p>
<h3>Optimizing The Tables</h3>
<p>Now that you&#8217;ve emptied the <code>wp_posts</code> table of all those excess rows, it&#8217;s time to let MySQL do its thing to optimize the table.</p>
<p>1) Click the big blue database name in the top left hand corner to go back to the list of your database tables.</p>
<p><a rel="attachment wp-att-596" href="http://line-in.co.uk/optimize-wordpress-database/2-list-dbs/"><img class="aligncenter size-large wp-image-596" title="List Databases" src="http://line-in.co.uk/wp-content/uploads/2010/08/2-list-dbs-620x309.jpg" alt="List Databases" width="620" height="309" /></a></p>
<p>On the right hand side of the list, there is a column called <code>Overhead</code>. This tells you roughly how much space in your DB you&#8217;ll save once you&#8217;ve optimized your tables. On some of my blogs, it was into the tens of megabytes. Not in this one, though. This one&#8217;s just for show.</p>
<p><a rel="attachment wp-att-597" href="http://line-in.co.uk/optimize-wordpress-database/3-overhead/"><img class="aligncenter size-large wp-image-597" title="Database Overheads" src="http://line-in.co.uk/wp-content/uploads/2010/08/3-overhead-620x262.jpg" alt="Database Overheads" width="620" height="262" /></a></p>
<p>2) Under the list, click on <code>Check All</code></p>
<p><a rel="attachment wp-att-598" href="http://line-in.co.uk/optimize-wordpress-database/4-check-all/"><img class="aligncenter size-large wp-image-598" title="PHPMyAdmin Check All" src="http://line-in.co.uk/wp-content/uploads/2010/08/4-check-all-620x309.jpg" alt="PHPMyAdmin Check All" width="620" height="309" /></a></p>
<p>3) Select <code>Optimize Table</code> from the <code>With Selected: </code> dropdown list.</p>
<p><a rel="attachment wp-att-599" href="http://line-in.co.uk/optimize-wordpress-database/5-optimize/"><img class="aligncenter size-large wp-image-599" title="Optimize Database Tables" src="http://line-in.co.uk/wp-content/uploads/2010/08/5-optimize-620x326.jpg" alt="Optimize Database Tables" width="620" height="326" /></a></p>
<p>MySQL will think about this for a second, then give you the results of the optimization. The standard WordPress tables will all be optimized. If you&#8217;ve installed some plugins that have created their own tables, these may not have been optimized so don&#8217;t worry if you see messages saying that it wasn&#8217;t possible.</p>
<p><a rel="attachment wp-att-600" href="http://line-in.co.uk/optimize-wordpress-database/6-optimize-results/"><img class="aligncenter size-large wp-image-600" title="PHPMyAdmin Results of Optimization" src="http://line-in.co.uk/wp-content/uploads/2010/08/6-optimize-results-620x397.jpg" alt="PHPMyAdmin Results of Optimization" width="620" height="397" /></a></p>
<p>And that&#8217;s it! Wanted more steps? Sorry to disappoint.</p>
<p>All that&#8217;s left is to go back and reload your website to see if you notice a bit of a speed increase (results may vary).</p>
<h3>For Kamikaze Bloggers</h3>
<p>If you find that you never use the Revisions functionality, then you can choose to turn it off entirely to stop WP bulking up your database unnecessarily (I would also recommend setting this option if your site has more than 750 posts and pages).</p>
<p>To do this, simply open up your wp_config.php file and add the following line to the top of the file.</p>
<pre class="brush: php;">&lt;br /&gt;
define('WP_POST_REVISIONS', false);&lt;br /&gt;
</pre>
<p>From now on, WordPress will stop keeping Post Revisions. That means no backups, sunshine. You delete the contents of a post by accident, you&#8217;re on your own.</p>
<h3>Bonus Easter Egg Fun!</h3>
<p>Since we&#8217;re talking about Revisions, check this fun little Easter egg out (if you&#8217;ve just followed the above instructions, you&#8217;ll need to wait until you&#8217;ve got some more revisions before this will work &#8211; simply leave a post open for a few minutes, then hit Update and you should have some to work with).</p>
<p>1) Select any post, then go down to the Revisions meta box and click on any of the links to open up the Revisions page.</p>
<p><a rel="attachment wp-att-601" href="http://line-in.co.uk/optimize-wordpress-database/7-click-revision/"><img class="aligncenter size-large wp-image-601" title="Wordpress Compare Revisions " src="http://line-in.co.uk/wp-content/uploads/2010/08/7-click-revision-620x242.jpg" alt="Wordpress Compare Revisions" width="620" height="242" /></a></p>
<p>2) Set the Old and New revisions to the same post.</p>
<p><a rel="attachment wp-att-602" href="http://line-in.co.uk/optimize-wordpress-database/8-compare-revisions/"><img class="aligncenter size-large wp-image-602" title="Wordpress Revisions Easter Egg" src="http://line-in.co.uk/wp-content/uploads/2010/08/8-compare-revisions-620x369.jpg" alt="Wordpress Revisions Easter Egg" width="620" height="369" /></a></p>
<p>Then click the <code>Compare Revisions</code> button&#8230;</p>
<img src="http://line-in.co.uk/?ak_action=api_record_view&id=586&type=feed" alt="" />

<p>Related posts:<ol><li><a href='http://line-in.co.uk/upgrade-wordpress-3/' rel='bookmark' title='Permanent Link: How To Upgrade To WordPress 3 Safely'>How To Upgrade To WordPress 3 Safely</a></li>
<li><a href='http://line-in.co.uk/wordpress-sites/' rel='bookmark' title='Permanent Link: Why WordPress Sites?'>Why WordPress Sites?</a></li>
<li><a href='http://line-in.co.uk/how-to-use-dreamweavers-site-specific-code-hinting/' rel='bookmark' title='Permanent Link: How To Use Dreamweaver CS5′s New Site-Specific Code Hinting'>How To Use Dreamweaver CS5′s New Site-Specific Code Hinting</a></li>
</ol></p><img src="http://feeds.feedburner.com/~r/LineInWebDesign/~4/VVyvGBMPsos" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://line-in.co.uk/optimize-wordpress-database/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://line-in.co.uk/optimize-wordpress-database/</feedburner:origLink></item>
		<item>
		<title>Why I Love My Clients</title>
		<link>http://feedproxy.google.com/~r/LineInWebDesign/~3/JWZ_bzW3CaI/</link>
		<comments>http://line-in.co.uk/why-i-love-my-clients/#comments</comments>
		<pubDate>Wed, 18 Aug 2010 16:00:47 +0000</pubDate>
		<dc:creator>Simon</dc:creator>
				<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://line-in.co.uk/?p=561</guid>
		<description><![CDATA[<p><img width="620" height="413" src="http://line-in.co.uk/wp-content/uploads/2010/08/IMG_0346-620x413.jpg" class="attachment-large wp-post-image" alt="Me &#039;working&#039; away at Altalaluna. Cafayate, Argentina." title="Me &#039;working&#039; away at Altalaluna. Cafayate, Argentina." /></p>You know the feeling. You open your email and there are 8 messages from your client, with the last one having a subject of &#8216;One other thing&#8230;&#8217;. It&#8217;s going to take an hour of your morning just to respond to [...]]]></description>
			<content:encoded><![CDATA[<p><img width="620" height="413" src="http://line-in.co.uk/wp-content/uploads/2010/08/IMG_0346-620x413.jpg" class="attachment-large wp-post-image" alt="Me &#039;working&#039; away at Altalaluna. Cafayate, Argentina." title="Me &#039;working&#039; away at Altalaluna. Cafayate, Argentina." /></p><p>You know the feeling. You open your email and there are 8 messages from your client, with the last one having a subject of &#8216;One other thing&#8230;&#8217;. It&#8217;s going to take an hour of your morning just to respond to them all. You open the first and it&#8217;s yet another change to the layout &#8211; the eighth one this week.</p>
<p>You ask yourself: Why do they have to be so unreasonable/difficult/demanding?</p>
<p><span id="more-561"></span></p>
<p>Looking at freelancing forums and blogs, it seems that this is a very common response. The ability to jump on a site and bash out your frustrations anonymously is altogether too tempting &#8211; especially when so many others are doing it.</p>
<p>I&#8217;m not saying it&#8217;s necessarily wrong &#8211; especially when some of the <a href="http://theoatmeal.com/comics/design_hell">creative outcomes of this frustration are so hilarious</a> &#8211; because it can get frustrating when things change constantly. But this is the nature of the work and, personally, I never want to be Ungrateful Moany Internet Guy.</p>
<p>As soon as I start to blame someone for something, I stop taking responsibility for my part in it. I stop being able to see that the situation was as much of my own creation as it was anything else and that there were many, many things that I could have done along the way to prevent this feeling I&#8217;m now having. As soon as I stop seeing that and focus solely on who else to blame, I&#8217;m no longer learning.</p>
<p>This isn&#8217;t to say that say clients can&#8217;t be unreasonable or awkward at times &#8211; they, like all of us, are human &#8211; but focusing on their shortcomings prevents me from seeing my own. And, goodness knows, I have plenty.</p>
<p>In the 9 months that I&#8217;ve been freelancing, I&#8217;ve dealt with my fair share of disasters &#8211; for example I&#8217;ve had my hourly rate go below minimum wage having stayed up all night trying to get the new features they just asked for in before the launch &#8211; but every single time I&#8217;ve been able to pinpoint where I went wrong with the process and improve it as a result.</p>
<p>If hourly rate drops below minimum wage, it&#8217;s because I didn&#8217;t charge enough. If I&#8217;m adding new features for free, it&#8217;s because I wasn&#8217;t clear about what was included and what wasn&#8217;t. If I&#8217;m sweating because they&#8217;re slow to pay, it&#8217;s because I didn&#8217;t ask for a deposit up front. None of these were the client&#8217;s fault &#8211; they, rightly, want what they were promised.</p>
<p>Since starting up, my proposals have changed massively. I now ask for a deposit up front and I host everything on my server until the fees are paid in full.</p>
<p>I also provide incredibly detailed lists of exactly what I will do and have a warning that anything not covered therein will be subject to an additional charge (in reality, I&#8217;ll usually let small additional requests slide in the interests of good relations). My fees now include administration and contingency time &#8211; I am awful at estimation and everything always takes longer than I think it will &#8211; and I am very conservative with my deadlines.</p>
<p>For the client&#8217;s part, they get what I hope to be an impeccable service. I deliver on time and on budget, communicate regularly and run a password-protected testing server with regular updates so that they can track the progress of the site from day 1. Not only do they feel more involved and can actually see the return on their investment grow over time, but we also get to nip niggles in the bud before they become major bugs.</p>
<p>With these safeguards in place, I can focus on doing the very best work that I can and respond positively to their requests without feeling like they&#8217;re taking advantage of me or that they don&#8217;t understand my &#8216;art&#8217;.</p>
<p>Perhaps I&#8217;ve been very lucky. Not only do I love the work I&#8217;m doing, but I&#8217;ve enjoyed working with every single one of my clients and, according to some of the lovely testimonials they&#8217;ve provided, it seems they&#8217;ve been happy with what I&#8217;ve done.</p>
<p>I don&#8217;t think that it&#8217;s coincidence that each one has come back for additional work and that I have never felt the need to jump online and join the mass whinging session.</p>
<p>I&#8217;m not saying that clients are perfect and we as designers or developers are always in the wrong, but when things head South it&#8217;s our reaction that will define us not only as professionals, but as individuals.</p>
<p>If we choose to see the situation as a curse or a challenge, we&#8217;re probably right.</p>
<img src="http://line-in.co.uk/?ak_action=api_record_view&id=561&type=feed" alt="" />

<p>Related posts:<ol><li><a href='http://line-in.co.uk/upgrade-wordpress-3/' rel='bookmark' title='Permanent Link: How To Upgrade To WordPress 3 Safely'>How To Upgrade To WordPress 3 Safely</a></li>
<li><a href='http://line-in.co.uk/the-comment-link-suggest-o-tron/' rel='bookmark' title='Permanent Link: The Comment Link Suggest-O-Tron'>The Comment Link Suggest-O-Tron</a></li>
<li><a href='http://line-in.co.uk/john-watson/' rel='bookmark' title='Permanent Link: Case Study: John H Watson MD'>Case Study: John H Watson MD</a></li>
</ol></p><img src="http://feeds.feedburner.com/~r/LineInWebDesign/~4/JWZ_bzW3CaI" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://line-in.co.uk/why-i-love-my-clients/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://line-in.co.uk/why-i-love-my-clients/</feedburner:origLink></item>
		<item>
		<title>Case Study: John H Watson MD</title>
		<link>http://feedproxy.google.com/~r/LineInWebDesign/~3/C7wKHfx6nwM/</link>
		<comments>http://line-in.co.uk/john-watson/#comments</comments>
		<pubDate>Mon, 09 Aug 2010 16:00:53 +0000</pubDate>
		<dc:creator>Simon</dc:creator>
				<category><![CDATA[Wordpress Case Studies]]></category>
		<category><![CDATA[Success]]></category>
		<category><![CDATA[Wordpress Sites]]></category>

		<guid isPermaLink="false">http://line-in.co.uk/?p=556</guid>
		<description><![CDATA[<p><img width="620" height="389" src="http://line-in.co.uk/wp-content/uploads/2010/05/JohnHWatson-620x389.jpg" class="attachment-large wp-post-image" alt="JohnHWatson" title="JohnHWatson" /></p>The client for this site contacted me again after I had finished his business website and asked if I could redesign his entertainment site. This site was a homage to Sherlock Holmes, but with a very creative twist &#8211; it [...]]]></description>
			<content:encoded><![CDATA[<p><img width="620" height="389" src="http://line-in.co.uk/wp-content/uploads/2010/05/JohnHWatson-620x389.jpg" class="attachment-large wp-post-image" alt="JohnHWatson" title="JohnHWatson" /></p><p>The client for this site contacted me again after I had finished his business website and asked if I could redesign his entertainment site. This site was a homage to Sherlock Holmes, but with a very creative twist &#8211; it was written as if the writer were Dr Watson living in the present day.</p>
<p>I love having the opportunity to do sites like these because they offer a lot of creative freedom. The brief was bashed out over a few late night dinners &#8211; my favourite kinds of meetings because they are always a bit of a creative free-for-all (and generally involve copious amounts of wine). Plenty of great ideas were thrown around and we both left very excited about the possibilites.</p>
<p><span id="more-556"></span></p>
<p>We eventually decided that the site should reflect the author&#8217;s circumstances and, of course, that meant basing it around the famous 221b Baker Street. The client supplied some great illustrations of the interior of the flat which gave me some fantastic ideas for little details that would appeal to the hardcore Holmes fan.</p>
<p>We finally narrowed it down to the design looking as if it were Watson&#8217;s journal on his desk and I set to work.</p>
<h3>Research</h3>
<p>The first thing I did was hit the library. Although the site features Watson writing in the present day, I still felt that it was important to keep to the Victorian aesthetic as that is the time period where the stories are set and would therefore more likely appeal to the target audience.</p>
<p>I found some interesting books on Victorian furnishings, with one picture standing out above all the others &#8211; an old, dark wood desk with a padded, green leather writing surface. This desk struck me as being most obviously Victorian.</p>
<h3>Design</h3>
<p>Using both Photoshop and Illustrator, I begun by recreating the desk based on the image. I located some wood textures and an amazing leather texture and then applied some filters and some shading to give it a more realistic look. The texture was originally brown, but I had to have it green so some adjustment layers were used to get the exact effect I was looking for.</p>
<p>One of the biggest problems I initially had was with the fact that there was no way of knowing how long the page would be. This meant that the majority of the page would have to use a repeating background. The problem with heavily textured backgrounds is that it becomes quite obvoious when it&#8217;s being repeated &#8211; especially if there are variations in brightness.</p>
<p>One solution is to have the repeating part so large (i.e. longer than the height of the average screen) so that it&#8217;s not obvious. However, this is totally impractical for the web as the file size for the image would be too much, taking the load time of the site to unacceptable levels.</p>
<p>It took a lot of experimentation to find the balance between repetition and file size, but I finally reached a compromise that I was happy with.</p>
<h3>The Details</h3>
<p>I couldn&#8217;t resist creating a magnifying glass for the search box &#8211; it was just too perfect an opportunity to pass up &#8211; some ideas just fit so naturally that it just had to be done.</p>
<p>The pipe was another obvious Holmes reference &#8211; I&#8217;ve written a tutorial on <a href='http://line-in.co.uk/3d-pipe-illustrator/'>how to design a pipe</a> that explains the exact steps used to create it.</p>
<p>The letters with the knife stuck through them was the most subtle element. Of course, in the novels the pile of correspondence is on the mantelpiece but, for this site, it has moved to Watson&#8217;s desk.</p>
<p>Hopefully the real fans will forgive the move and enjoy the reference.</p>
<h3>The Launch</h3>
<p>The client was very pleased with the final design. Ultimately, though, it is the users that decide whether or not it&#8217;s any good but, thankfully, this one seems to have passed the test.</p>
<p>Shortly after the launch, we noticed a 200% spike in visitors. Further investigation led us to a Sherlock Holmes discussion group where they had found this site and shared the link, along with some very nice messages, including this one:</p>
<blockquote><p>It is lovely isn’t it? Someone has obviously taken alot [sic] of time in putting the site together. And it has paid off really well I think.</p></blockquote>
<p>As a designer with the typical fragile ego, it&#8217;s very reassuring to have the approval of random strangers.</p>
<h3>The Lesson</h3>
<p>Ego stroking aside, it also shows how much of a draw a good design can be. The design led to nice things being said about the design which led to the spike in visitors.</p>
<p>However, it&#8217;s the <em>content</em> that keeps some of those visitors coming back. The design might draw people in, but if the content isn&#8217;t there to back it up then they&#8217;re not likely to return. Luckily, thanks to my client&#8217;s unique writing style and the clever twist, the content on the site was good enough to keep many of those initial visitors coming back.</p>
<p>Vist <a href='http://johnhwatsonmd.com'>John H Watson MD</a>.</p>
<img src="http://line-in.co.uk/?ak_action=api_record_view&id=556&type=feed" alt="" />

<p>Related posts:<ol><li><a href='http://line-in.co.uk/getting-visitors/' rel='bookmark' title='Permanent Link: How We Got Over 8,000 Visits In Less than Three Months'>How We Got Over 8,000 Visits In Less than Three Months</a></li>
<li><a href='http://line-in.co.uk/referral-competition/' rel='bookmark' title='Permanent Link: Competition &#8211; Win a Free Blog Consultation!'>Competition &#8211; Win a Free Blog Consultation!</a></li>
<li><a href='http://line-in.co.uk/3d-pipe-illustrator/' rel='bookmark' title='Permanent Link: Creating a 3D Pipe with Illustrator and Photoshop'>Creating a 3D Pipe with Illustrator and Photoshop</a></li>
</ol></p><img src="http://feeds.feedburner.com/~r/LineInWebDesign/~4/C7wKHfx6nwM" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://line-in.co.uk/john-watson/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		<feedburner:origLink>http://line-in.co.uk/john-watson/</feedburner:origLink></item>
		<item>
		<title>Creating a 3D Pipe with Illustrator and Photoshop</title>
		<link>http://feedproxy.google.com/~r/LineInWebDesign/~3/dio6Irm0j7E/</link>
		<comments>http://line-in.co.uk/3d-pipe-illustrator/#comments</comments>
		<pubDate>Mon, 26 Jul 2010 16:00:42 +0000</pubDate>
		<dc:creator>Simon</dc:creator>
				<category><![CDATA[Illustrator]]></category>
		<category><![CDATA[Photoshop]]></category>
		<category><![CDATA[Tutorials]]></category>
		<category><![CDATA[3D]]></category>

		<guid isPermaLink="false">http://line-in.co.uk/?p=455</guid>
		<description><![CDATA[<p><img width="620" height="400" src="http://line-in.co.uk/wp-content/uploads/2010/07/illustrator_pipe.jpg" class="attachment-large wp-post-image" alt="Illustrator 3D Objects" title="Illustrator 3D Objects" /></p>We&#8217;ll be building the shape in Illustrator using the 3D Revolve tool before going into Photoshop to texture it all up using clipping masks and blend modes and layer styles and all that modern doohickory. 1) Before I start trying [...]]]></description>
			<content:encoded><![CDATA[<p><img width="620" height="400" src="http://line-in.co.uk/wp-content/uploads/2010/07/illustrator_pipe.jpg" class="attachment-large wp-post-image" alt="Illustrator 3D Objects" title="Illustrator 3D Objects" /></p><p>We&#8217;ll be building the shape in Illustrator using the 3D Revolve tool before going into Photoshop to texture it all up using clipping masks and blend modes and layer styles and all that modern doohickory.</p>
<p><span id="more-455"></span></p>
<p>1) Before I start trying to create anything based on the material world, I always spend at least five minutes gathering some reference materials &#8211; especially for things that I don&#8217;t come in contact with every day. I&#8217;m not a pipe smoker, so I don&#8217;t have a real one lying around the house that I can use so I grabbed this photo from Stock Exchange instead. My memory is so rubbish that I don&#8217;t trust it to recall the important details of anything (anniversaries, birthdays, modern smoking pipe construction), so I always use a <a href="http://www.sxc.hu/photo/913743">reference</a>.</p>
<p>Instantly, I start to see little details that will help our design read better. The features that jump out at me from this image are the two different materials and the little lip at the smoking end.</p>
<p>2) In order to accurately recreate the pipe, we&#8217;re going to have to divide it into two parts. This is because we&#8217;re going to need to revolve the pipe around two different axis. Hopefully this screenshot will make the things a little clearer.</p>
<p><a rel="attachment wp-att-471" href="http://line-in.co.uk/3d-pipe-illustrator/pipeaxis/"><img class="aligncenter size-medium wp-image-471" title="Axis of the pipe" src="http://line-in.co.uk/wp-content/uploads/2010/07/pipeAxis-459x306.png" alt="Axis of the pipe" width="459" height="306" /></a></p>
<p>3) Got it? No? Me either. Not to worry, when in doubt, just start &#8211; trial and error are your friends.</p>
<p>Let&#8217;s grab our pen tool (p) and start roughing out the shape of the stem. You need to imagine that you&#8217;re cutting a slice out of the tube, then cutting that slice down the middle. To help you understand that nonsense sentence, an example: If I was going to make a sphere, I&#8217;d draw out a half moon and revolve it around the straight edge. Play with the revolve tool until you figure it out &#8211; don&#8217;t worry, it took me a while too.</p>
<p>Here is the shape of my stem &#8211; I used no stroke and a fill of <code>#919191</code>. I used this neutral grey because it will react better with the texture when we apply the blending mode in Photoshop. It doesn&#8217;t have to be perfect, as the 3D Revolve is an applied effect that can be edited or deleted later from the &#8216;appearances&#8217; panel.</p>
<p><a rel="attachment wp-att-460" href="http://line-in.co.uk/3d-pipe-illustrator/stemplan/"><img class="aligncenter size-full wp-image-460" title="Plan for the pipe stem" src="http://line-in.co.uk/wp-content/uploads/2010/07/stemPlan.png" alt="Plan for the pipe stem" width="450" height="704" /></a></p>
<p>4) Using the pen tool again, we start on the bowl, again using no stroke and a fill of <code>#919191</code>. I made something like this. Hopefully you can see the half-bowl shape. I&#8217;m going to be revolving it around the small edge, if that helps you understand it any better.</p>
<p><a rel="attachment wp-att-461" href="http://line-in.co.uk/3d-pipe-illustrator/bowlplan/"><img class="aligncenter size-medium wp-image-461" title="Plan for the bowl and stem" src="http://line-in.co.uk/wp-content/uploads/2010/07/bowlPlan-460x671.png" alt="Plan for the bowl and stem" width="460" height="671" /></a></p>
<p>5) Once you&#8217;ve created your shapes, select the stem and go to <code>Effect</code> -&gt; <code>3D</code> -&gt; <code>Revolve</code>. Here are the settings I used for the stem:</p>
<p><a rel="attachment wp-att-468" href="http://line-in.co.uk/3d-pipe-illustrator/stemrevolvesettings/"><img class="aligncenter size-full wp-image-468" title="Stem Revolve Settings" src="http://line-in.co.uk/wp-content/uploads/2010/07/stemRevolveSettings.png" alt="Stem Revolve Settings" width="449" height="630" /></a></p>
<p>6) And here are the settings for the bowl:</p>
<p><a href="http://line-in.co.uk/3d-pipe-illustrator/bowlrevolvesettings/" rel="attachment wp-att-467"><img src="http://line-in.co.uk/wp-content/uploads/2010/07/bowlRevolveSettings.png" alt="Bowl revolve settings" title="Bowl revolve settings" width="444" height="627" class="aligncenter size-full wp-image-467" /></a></p>
<p>7) You&#8217;ll probably have to move the stem around so that it looks like it&#8217;s coming out of the bowl and not totally detached. This really is just trial and error (unless you smart folks know of a better way &#8211; <a href='http://line-in.co.uk/3d-objects-illustrator/#respond'>leave a comment</a> if you do). You have to click and drag with your mouse, then let go of the button so that Illustrator can re-render the object. Repeat until it looks something like this:</p>
<p><a href="http://line-in.co.uk/3d-pipe-illustrator/greyscalerender/" rel="attachment wp-att-459"><img src="http://line-in.co.uk/wp-content/uploads/2010/07/greyscaleRender-460x275.png" alt="Greyscale Pipe Render" title="Greyscale Pipe Render" width="460" height="275" class="aligncenter size-medium wp-image-459" /></a></p>
<p>8) That&#8217;s looking pretty pipe-shaped! All right, go get a coffee before we move on to the Photoshop stage &#8211; you&#8217;ve earned it.</p>
<p>Got one? Great, now let&#8217;s make it look more real. <code>Shift + click</code> both paths to select them within Illustrator and then hit <code>Ctrl/Cmd + C</code>. Start up Photoshop and open a new document. The size of the clipboard image will already be set, but because it&#8217;s going in as a vector, you can have it as large as you want. My document size was 700px x 400px (increase the size/DPI if you&#8217;re planning to use it for print). Go to <code>Edit</code> -&gt; Paste (or hit <code>Ctrl/Cmd + V</code>) and Photoshop will ask you how you want to import it. Select <code>Smart Object</code> and then OK and it&#8217;ll come in with a bounding box around it.</p>
<p>I made mine a little smaller (remember to hold shift to constrain ratios) because I like to have a little breathing room around my images, and then I confirm the transformation.</p>
<p>9) Name this layer &#8216;Pipe Original&#8217;, then duplicate it, lock it and hide it (I like to use non-destructive editing techniques &#8211; including keeping originals intact &#8211; wherever possible. This is just in case we decide to go back and edit the original pipe in future. Rename the duplicate &#8216;Pipe&#8217;, then <code>right/ctrl + click</code> this layer and select &#8216;rasterize layer&#8217;.</p>
<p>10) Grab your favourite wood texture (I used the 4th one of these <a href='http://www.bittbox.com/freebies/free-hi-resolution-wood-textures'>free wooden textures</a>) and place it on a layer above the rasterized pipe. Call this &#8216;wood&#8217; and resize it so that the texture&#8217;s scale matches that of the pipe. I also rotated mine slightly so that the grain is parallel to the stem. <code>Alt + click</code> the line between the two layers to apply a clipping mask. Finally, change the &#8216;Wood&#8217; layer&#8217;s blending mode to <code>Multiply</code>.  Boom! 3D wood.</p>
<p><a href="http://line-in.co.uk/3d-pipe-illustrator/texturedwood/" rel="attachment wp-att-466"><img src="http://line-in.co.uk/wp-content/uploads/2010/07/texturedWood-460x368.png" alt="wood texture" title="Wood texture" width="460" height="368" class="aligncenter size-medium wp-image-466" /></a></p>
<p>11) Select the Wood layer and click on the layer mask icon. Make sure your foreground colour is set to black, then get a big, hard brush &#8211; make it big enough that the edge of it follows the curve of the wood nicely. <code>Ctrl/Cmd + click</code> the small image on the Pipe layer within the layers panel to select it, then line it up between roughly half way between the bowl and the tip of the stem and click once. Finally, paint away all the wood between the tip of the stem and edge you just made, like so:</p>
<p><a href="http://line-in.co.uk/3d-pipe-illustrator/deletededge/" rel="attachment wp-att-465"><img src="http://line-in.co.uk/wp-content/uploads/2010/07/deletedEdge-460x368.png" alt="Pipe with deleted edge" title="Pipe with deleted edge" width="460" height="368" class="aligncenter size-medium wp-image-465" /></a></p>
<p>12) <code>Ctrl/cmd+click</code> the Pipe layer icon, then <code>Ctrl/Cmd+click</code> the LAYER MASK image on the on the Wood layer, then press <code>Ctrl/Cmd+shift+i</code> to invert the selection. Create a new layer, then select the fill tool and click once within the selection &#8211; it doesn&#8217;t matter what color you use. Rename this layer &#8216;Plastic&#8217;.</p>
<p><a href="http://line-in.co.uk/3d-pipe-illustrator/layermask/" rel="attachment wp-att-464"><img src="http://line-in.co.uk/wp-content/uploads/2010/07/layerMask.png" alt="Photoshop Layer Mask" title="Photoshop Layer Mask" width="294" height="300" class="aligncenter size-full wp-image-464" /></a></p>
<p>13) Drop the &#8216;plastic&#8217; layer&#8217;s fill to 0, then double-click the layer to fire up the layer styles. Select gradient overlay and make something similar to this:</p>
<p><a href="http://line-in.co.uk/3d-pipe-illustrator/plasticlayerstyle/" rel="attachment wp-att-462"><img src="http://line-in.co.uk/wp-content/uploads/2010/07/plasticLayerStyle-460x586.png" alt="Plastic layer styles" title="Plastic layer styles" width="460" height="586" class="aligncenter size-medium wp-image-462" /></a></p>
<p>Make sure that you set the Blending Mode within the gradient style layer style, NOT on the layer itself, or else it won&#8217;t work right.</p>
<p><a href="http://line-in.co.uk/3d-pipe-illustrator/illustrator_pipe/" rel="attachment wp-att-470"><img src="http://line-in.co.uk/wp-content/uploads/2010/07/illustrator_pipe.jpg" alt="Illustrator 3D Objects" title="Illustrator 3D Objects" width="620" height="400" class="aligncenter size-full wp-image-470" /></a></p>
<p>And there you have it! A realistic, 3D pipe to use anywhere in your illustrations</p>
<img src="http://line-in.co.uk/?ak_action=api_record_view&id=455&type=feed" alt="" />

<p>Related posts:<ol><li><a href='http://line-in.co.uk/illustrator-crystallize-tool/' rel='bookmark' title='Permanent Link: Create a Quick Grassy Hill in Illustrator with the Crystallize Tool'>Create a Quick Grassy Hill in Illustrator with the Crystallize Tool</a></li>
<li><a href='http://line-in.co.uk/upgrade-wordpress-3/' rel='bookmark' title='Permanent Link: How To Upgrade To WordPress 3 Safely'>How To Upgrade To WordPress 3 Safely</a></li>
<li><a href='http://line-in.co.uk/john-watson/' rel='bookmark' title='Permanent Link: Case Study: John H Watson MD'>Case Study: John H Watson MD</a></li>
</ol></p><img src="http://feeds.feedburner.com/~r/LineInWebDesign/~4/dio6Irm0j7E" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://line-in.co.uk/3d-pipe-illustrator/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://line-in.co.uk/3d-pipe-illustrator/</feedburner:origLink></item>
		<item>
		<title>How To Use Dreamweaver CS5′s New Site-Specific Code Hinting</title>
		<link>http://feedproxy.google.com/~r/LineInWebDesign/~3/8w1Zm7Yc4b0/</link>
		<comments>http://line-in.co.uk/how-to-use-dreamweavers-site-specific-code-hinting/#comments</comments>
		<pubDate>Mon, 19 Jul 2010 16:00:12 +0000</pubDate>
		<dc:creator>Simon</dc:creator>
				<category><![CDATA[Products]]></category>
		<category><![CDATA[Wordpress]]></category>

		<guid isPermaLink="false">http://line-in.co.uk/?p=436</guid>
		<description><![CDATA[<p><img width="620" height="427" src="http://line-in.co.uk/wp-content/uploads/2010/07/Dreamweaver_splash_screen-620x427.jpg" class="attachment-large wp-post-image" alt="Dreamweaver_splash_screen" title="Dreamweaver_splash_screen" /></p>The new version of Adobe&#8217;s successful CS series of creative products has just recently launched and Dreamweaver has received an extensive upgrade full of exciting new features for WordPress developers. For a long while, I was content using Notepad++ to [...]]]></description>
			<content:encoded><![CDATA[<p><img width="620" height="427" src="http://line-in.co.uk/wp-content/uploads/2010/07/Dreamweaver_splash_screen-620x427.jpg" class="attachment-large wp-post-image" alt="Dreamweaver_splash_screen" title="Dreamweaver_splash_screen" /></p><p>The new version of Adobe&#8217;s successful CS series of creative products has just recently launched and Dreamweaver has received an extensive upgrade full of exciting new features for WordPress developers. For a long while, I was content using Notepad++ to do all of my development but, after switching to a Mac, I thought I&#8217;d give <a href="http://www.adobe.com/products/dreamweaver/">DreamWeaver</a> another go and this new version has been well worth it.</p>
<p><span id="more-436"></span></p>
<h3>About Site Specific Code Hinting</h3>
<p>This has to be my current favourite new feature. Often times, I&#8217;ll find myself developing away from the internet on a local server. The <a href="http://codex.wordpress.org/Main_Page">WordPress Codex</a> is a fantastic resource but, unfortunately, it&#8217;s all online. Site specific code hints have been a lifesaver. Not only do they save typing time, but they also remind you what arguments a function takes and tell you where in your site tree that function is located.</p>
<p>WordPress&#8217; code is well commented, so sometimes looking up the function in its original file can provide all of the information I need to continue developing (and it sometimes has a lot more information than the Codex). Of course, you could use the site-wide search that has been available in DreamWeaver for many years, but that doesn&#8217;t tell me whether or not a function actually exists or whether I&#8217;ve just made it up (it happens more than you&#8217;d think).</p>
<p>These code hints aren&#8217;t limited to WordPress, either. There are defaults available for Joomla and Drupal as well but, better than that, you can actually have it search recursively through your programs and create code hinting from your own functions!</p>
<h3>Using Code Hints</h3>
<p>Using Site Specific Code Hinting is easy. If you&#8217;re looking to use one of the default sets (currently Wordprss, Joomla and Drupal), you first need to set up a site and add a PHP server.</p>
<p>I do all of my development offline on a local testing server using <a href="http://www.mamp.info">MAMP</a> on the Mac. MAMP stands for Mac Apache MySQL PHP, and is basically an Apache web server in a box. It&#8217;s very easy to install, set up and use. Equivalents are available on other platforms &#8211; <a href="http://www.wampserver.com/en/">WAMP</a> is available for Windows and you can just install a regular LAMP stack (using apt-get on Ubuntu or Debian, or simply install <a href="http://www.apachefriends.org/en/xampp.html">XAMPP</a>) in Linux</p>
<p>Once that&#8217;s done, you&#8217;ll need to define your site.</p>
<ol>
<li>Go to Site -&gt; New Site&#8230;</li>
<li>Fill in your site&#8217;s name and the location of the files on your hard drive</li>
<li>In &#8216;Servers&#8217;, click the &#8216;+&#8217; sign to add a new server</li>
<li>Name it whatever you want, then change the Connect using: to &#8216;Local/Network&#8217;</li>
<li>The Server Folder is your web root &#8211; usually &#8216;htdocs&#8217; or &#8216;www&#8217; &#8211; and the installation of your local testing server should have told you where it is on your drive. Put that location in this box.</li>
<li>The Web URL is how you access your site through a browser. This usually defaults to &#8216;localhost&#8217; (e.g. http://localhost/)</li>
</ol>
<p>To use Site-Specific Code Hints for a WordPress site, simply go to the <code>Site</code> menu and click <code>Site-Specific Code Hints...</code>.</p>
<p style="text-align: center;"><a rel="attachment wp-att-441" href="http://line-in.co.uk/how-to-use-dreamweavers-site-specific-code-hinting/site-specific-code-hints-menu/"><img class="size-full wp-image-441 aligncenter" title="Accessing Site Specific Code Hints" src="http://line-in.co.uk/wp-content/uploads/2010/07/site-specific-code-hints-menu.jpg" alt="Accessing Site Specific Code Hints" width="370" height="354" /></a></p>
<p>Select <code>WordPress</code> from the <code>Structure: </code> drop-down list and hit OK. Now, open a file and start typing a WordPress function and you should get the hint from that function:</p>
<p style="text-align: center;"><a rel="attachment wp-att-446" href="http://line-in.co.uk/how-to-use-dreamweavers-site-specific-code-hinting/post_dw_site-specific-code-hinting/"><img class="aligncenter size-full wp-image-446" title="post_DW_site-specific-code-hinting" src="http://line-in.co.uk/wp-content/uploads/2010/07/post_DW_site-specific-code-hinting.jpg" alt="" width="587" height="59" /></a></p>
<h3>Defining Your Own Sites</h3>
<p>It gets better, though. If you&#8217;re developing your own site or PHP application, then you can set up your own structure and have it scan through and create code hints for <em>your</em> functions! Let&#8217;s take a look.</p>
<p>Here&#8217;s a very basic folder structure:</p>
<pre>index.php
- includes/functions.php
</pre>
<p>I&#8217;ve defined a nonsense function in the functions.php, and I want to be able to access the hinting while I&#8217;m coding away in index.php. Go to <code>Site</code> -&gt; <code>Site-Specific Code Hints...</code> and select <code>New from Blank</code> from the drop-down menu.</p>
<p><a rel="attachment wp-att-444" href="http://line-in.co.uk/how-to-use-dreamweavers-site-specific-code-hinting/site-specific-code-hinting-custom-1/"><img class="aligncenter  size-full wp-image-444" title="site-specific-code-hinting-custom-1" src="http://line-in.co.uk/wp-content/uploads/2010/07/site-specific-code-hinting-custom-1.jpg" alt="" width="573" height="416" /></a></p>
<p>Click the &#8216;+&#8217; sign next to <code>File(s): </code> and then click the  folder icon next to <code>File/folder: </code><a rel="attachment wp-att-442" href="http://line-in.co.uk/how-to-use-dreamweavers-site-specific-code-hinting/site-specific-code-hinting-select-folder/"><img class="aligncenter size-medium wp-image-442" title="site-specific-code-hinting-select-folder" src="http://line-in.co.uk/wp-content/uploads/2010/07/site-specific-code-hinting-select-folder-460x303.jpg" alt="" width="460" height="303" /></a></p>
<p>Choose the folders you want to include (in this case &#8216;includes&#8217;), and then click <code>Add</code>. If you have nested folders, then click on the folders in the window and make sure that you check &#8216;recursive&#8217;. It will then search through all of the subfolders.</p>
<p><a rel="attachment wp-att-445" href="http://line-in.co.uk/how-to-use-dreamweavers-site-specific-code-hinting/site-specific-code-hinting-all-done/"><img class="aligncenter size-medium wp-image-445" title="site-specific-code-hinting-all-done" src="http://line-in.co.uk/wp-content/uploads/2010/07/site-specific-code-hinting-all-done-460x338.jpg" alt="" width="460" height="338" /></a></p>
<p>Click <code>OK</code> and it&#8217;ll ask you if you want to save it as a custom structure. If it&#8217;s a structure you use a lot in different sites, then it&#8217;s probably worthwhile &#8211; otherwise, just hit cancel.</p>
<p>You should now have access to the defined function and if I go to index.php and start typing the name of the function, I get this:</p>
<p><a rel="attachment wp-att-443" href="http://line-in.co.uk/how-to-use-dreamweavers-site-specific-code-hinting/site-specific-code-hinting-new-hints/"><img class="aligncenter size-large wp-image-443" title="site-specific-code-hinting-new-hints" src="http://line-in.co.uk/wp-content/uploads/2010/07/site-specific-code-hinting-new-hints-620x58.jpg" alt="" width="620" height="58" /></a></p>
<p>Of course, there are a bunch of other great new features like Live Preview and the updated CSS panel, but the new code hinting feature is definitely the one I&#8217;m using the most. I hope you&#8217;ve found this useful &#8211; if you have, consider sharing it or subscribing to my <a href="http://feeds.feedburner.com/LineInWebDesign">RSS feed</a> or to my mailing list.</p>
<img src="http://line-in.co.uk/?ak_action=api_record_view&id=436&type=feed" alt="" />

<p>Related posts:<ol><li><a href='http://line-in.co.uk/upgrade-wordpress-3/' rel='bookmark' title='Permanent Link: How To Upgrade To WordPress 3 Safely'>How To Upgrade To WordPress 3 Safely</a></li>
<li><a href='http://line-in.co.uk/wordpress-sites/' rel='bookmark' title='Permanent Link: Why WordPress Sites?'>Why WordPress Sites?</a></li>
<li><a href='http://line-in.co.uk/optimize-wordpress-database/' rel='bookmark' title='Permanent Link: Optimize Your WordPress Database'>Optimize Your WordPress Database</a></li>
</ol></p><img src="http://feeds.feedburner.com/~r/LineInWebDesign/~4/8w1Zm7Yc4b0" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://line-in.co.uk/how-to-use-dreamweavers-site-specific-code-hinting/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://line-in.co.uk/how-to-use-dreamweavers-site-specific-code-hinting/</feedburner:origLink></item>
		<item>
		<title>How We Got Over 8,000 Visits In Less than Three Months</title>
		<link>http://feedproxy.google.com/~r/LineInWebDesign/~3/V0Q4jCa3AEo/</link>
		<comments>http://line-in.co.uk/getting-visitors/#comments</comments>
		<pubDate>Mon, 12 Jul 2010 16:00:22 +0000</pubDate>
		<dc:creator>Simon</dc:creator>
				<category><![CDATA[Wordpress Case Studies]]></category>
		<category><![CDATA[Success]]></category>
		<category><![CDATA[Wordpress]]></category>

		<guid isPermaLink="false">http://line-in.co.uk/?p=425</guid>
		<description><![CDATA[<p><img width="620" height="257" src="http://line-in.co.uk/wp-content/uploads/2010/06/NEV_analytics-620x257.jpg" class="attachment-large wp-post-image" alt="Our Analytics Results" title="Analytics" /></p>The launch of Never Ending Voyage was one of our most successful website launches to date, receiving over 8,000 visits and over 5,000 unique visitors in its first three months. Our site was launched on February 19th 2010 and the [...]]]></description>
			<content:encoded><![CDATA[<p><img width="620" height="257" src="http://line-in.co.uk/wp-content/uploads/2010/06/NEV_analytics-620x257.jpg" class="attachment-large wp-post-image" alt="Our Analytics Results" title="Analytics" /></p><p>The launch of Never Ending Voyage was one of our most successful website launches to date, receiving over 8,000 visits and over 5,000 unique visitors in its first three months. Our site was launched on February 19th 2010 and the image above is a picture of our Analytics account for those initial months (until May 18th 2010).</p>
<p>We launched with one post and a posting schedule of 3 a week (which we managed to keep to until we ran out of internet in Paraguay!) and we&#8217;ve been fortunate to have over <strong>470</strong> comments in the four and something months we&#8217;ve been live. We&#8217;ve also managed to earn some income through affiliate sales which has paid for the hosting costs for all of our sites for the year. Not bad for such a young site!</p>
<p><span id="more-425"></span></p>
<p>There are many possible reasons why it has been so successful, but I&#8217;d like to share what I think are some of the major contributing factors.</p>
<p><strong>1) Unique Design</strong></p>
<p>Design matters, it&#8217;s as simple as that. <em>Well-designed</em> does not have to mean lots of fancy graphics and crazy animations, but it does mean something that is easy to read and navigate and that stands out from the crowd.</p>
<p>We&#8217;ve had a lot of very nice things said about the design of the site. I&#8217;m sure it gives us an advantage over other travel sites that use free (or even premium) themes on their blogs in that it&#8217;s unique and recognisable.</p>
<p><strong>2) Quality Content</strong></p>
<p>My partner wrote a number of very in depth, high quality articles about selling all of our possessions and about saving money for travelling. She provided lots of details on how we did it and what worked and what didn&#8217;t and they proved to be very popular, getting shared around the web and ReTweeted on Twitter.</p>
<p>Of course, now the bar has been set we have to maintain that quality!</p>
<p><strong>3) Regular Posting Schedule</strong></p>
<p>We have been religious about updating the blog and I think that it does make a difference in keeping the site talking about &#8211; especially in the early days. Perhaps after a certain tipping point, the site will have enough momentum that regular updates are no longer as important, but in the beginning I think it&#8217;s important to show your commitment.</p>
<p><strong>4) Social Media</strong></p>
<p><a href='http://www.neverendingvoyage.com/about'>My partner</a> was incredibly active on <a href='http://twitter.com/NevEndingVoyage'>Twitter</a> from the outset, asking and answering questions and getting involved in the travel community. She has built up a following of nearly 600 people through her constant engagement and, as a result, Twitter remains one of our top 5 traffic sources.</p>
<p>Note that the important part here is <em>engagement</em>. You absolutely have to get involved and it has to be inolvement beyond the spammy &#8216;come and look at my site&#8217;. Chat to people, help them out, ask questions, make conversation &#8211; give freely of your time and effort and you&#8217;ll get it back in spades.</p>
<p>We also have a <a href='http://www.facebook.com/NeverEndingVoyage'>Facebook</a> page, a <a href='http://www.flickr.com/photos/neverendingvoyage/'>Flickr</a> account, a <a href='http://www.youtube.com/neverendingvoyage'>YouTube</a> account and a <a href='http://www.vimeo.com/nevendingvoyage'>Vimeo</a> account to make sure that we&#8217;re in as many relevant places as we can actively keep up with.</p>
<p><strong>5) Unique Story</strong></p>
<p>Although I don&#8217;t think you need to sell all of your stuff and travel indefinitely to have a successful blog, I do think that having a unique story has helped. Many people go travelling for 6 months or a year, but the longer the travel period the less people there are blogging about it.</p>
<p>It&#8217;s been a great start and our visitor numbers continue to grow and there have been many lessons learned from this launch which I&#8217;ll be applying to all future launches.</p>
<img src="http://line-in.co.uk/?ak_action=api_record_view&id=425&type=feed" alt="" />

<p>Related posts:<ol><li><a href='http://line-in.co.uk/getting-a-good-conversion-rate/' rel='bookmark' title='Permanent Link: Why You Should Be Tracking Your Conversions'>Why You Should Be Tracking Your Conversions</a></li>
<li><a href='http://line-in.co.uk/john-watson/' rel='bookmark' title='Permanent Link: Case Study: John H Watson MD'>Case Study: John H Watson MD</a></li>
<li><a href='http://line-in.co.uk/wordpress-sites/' rel='bookmark' title='Permanent Link: Why WordPress Sites?'>Why WordPress Sites?</a></li>
</ol></p><img src="http://feeds.feedburner.com/~r/LineInWebDesign/~4/V0Q4jCa3AEo" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://line-in.co.uk/getting-visitors/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://line-in.co.uk/getting-visitors/</feedburner:origLink></item>
		<item>
		<title>Why You Should Be Tracking Your Conversions</title>
		<link>http://feedproxy.google.com/~r/LineInWebDesign/~3/S78TRNUv6Vo/</link>
		<comments>http://line-in.co.uk/getting-a-good-conversion-rate/#comments</comments>
		<pubDate>Mon, 05 Jul 2010 16:00:26 +0000</pubDate>
		<dc:creator>Simon</dc:creator>
				<category><![CDATA[Analytics]]></category>
		<category><![CDATA[Conversion]]></category>
		<category><![CDATA[Traffic]]></category>

		<guid isPermaLink="false">http://simon/line-in-web-design/?p=333</guid>
		<description><![CDATA[<p><img width="620" height="306" src="http://line-in.co.uk/wp-content/uploads/2010/06/conversion-rates-620x306.png" class="attachment-large wp-post-image" alt="Conversion Rates Image" title="Conversion Rates Image" /></p>Ask me what the most important aspect of a website is and I&#8217;m likely to reply &#8216;Conversion Rate&#8217;. I believe it&#8217;s even more important than visitor numbers and I would rather have a high Conversion Rate than a high visitor [...]]]></description>
			<content:encoded><![CDATA[<p><img width="620" height="306" src="http://line-in.co.uk/wp-content/uploads/2010/06/conversion-rates-620x306.png" class="attachment-large wp-post-image" alt="Conversion Rates Image" title="Conversion Rates Image" /></p><p>Ask me what the most important aspect of a website is and I&#8217;m likely to reply &#8216;Conversion Rate&#8217;. I believe it&#8217;s even more important than visitor numbers and I would rather have a high Conversion Rate than a high visitor count (of course, having both would be best of all!)</p>
<p>Of course, you need to have a certain number of visitors to begin with, but even 100 visits is enough for you to start to see which aspects of your site are working.</p>
<p><span id="more-333"></span></p>
<h3>What Is a Conversion Rate</h3>
<p>Basically, it&#8217;s a number &#8211; usually expressed as a percentage &#8211; that tells you how many people are doing what you want them to do when they land on your site.</p>
<p>Everyone who has a website wants the people visiting it to do something on it &#8211; even if that&#8217;s just reading some content. Most actions that users take on your website can be measured (although there is one key thing that can never be measured by Analytics &#8211; we&#8217;ll come back to that later) and anything that can be measured can have a goal assigned to it.</p>
<p>Your Conversion Rate tells you how successful you are at achieving your goals. The most obvious goals are for eCommerce sites &#8211; making sales.</p>
<h3>An Example</h3>
<p>Bill and Steve both have online shops selling Flaming Death Skull t-shirts. The black shirts, adorned with a fetching bloody skull on fire motif, retail at $30 each. Bill is receiving about 200 visits a month and has a Conversion Rate of 1%. Steve is receiving about 50 visits a month, but has a Conversion Rate of 10%. Who&#8217;s doing better?</p>
<p>In terms of traffic, Bill. No question. But basic math shows us that, <em>financially</em>, Steve is doing much, much better, earning $150 a month against Bill&#8217;s $60 despite Bill have <strong>four</strong> times the traffic.</p>
<p>Although I&#8217;ve used a financial example here, the priciples can be applied to almost anything. Here are a few other things that could work as goals:</p>
<ul>
<li>Number of comments</li>
<li>Number of pages visited</li>
<li>Time spent on your site</li>
<li>Mailing list sign ups</li>
<li>Number of repeat visits</li>
<li>Brouchure requests</li>
<li>Number of visits from a particular keyword</li>
<li>Downloads</li>
<li>Uploads</li>
<li>Number of phone enquiries (a little harder to track, but still very possible &#8211; for example, by using a website specific phone number)</li>
</ul>
<h3>This Sounds Great &#8211; So How Do I Work It Out?</h3>
<p>Of course, in order to know if you&#8217;re reaching your goals you need a way to measure all of this stuff. Thankfully, the benevolent Google (All Hail!) has bestowed on us humble netizens an incredibly powerful (yet totally free) tool to help us &#8211; Google Analytics.</p>
<p>Installing Analytics is straightforward &#8211; you need a Google account and, once you&#8217;ve signed up, you just drop a small chunk of JavaScript at the foot of every page you want to track (that&#8217;s all of them) and then you sit back and let it collect the data. It&#8217;s very easy and there are plenty of tutorials out there, but if you need a hand setting it up, feel free to get in touch and we&#8217;ll work something.</p>
<p>Now you have your goal and your data, working out your Conversion Rate is simple mathematics. Analytics actually includes quite comprehensive support for goals that works out your Conversion Rate automatically within the program itself, but since that&#8217;s a fairly advanced topic we&#8217;ll start by working it out for ourselves.</p>
<p><em>Note: I&#8217;ll be writing more in-depth articles about using Google Analytics in future, so sign up to my <a href="http://feeds.feedburner.com/LineInWebDesign">RSS feed</a> or <a href="#signup">email mailing list</a> to make sure that you don&#8217;t miss them.</em></p>
<p>Let&#8217;s suppose that your goal is to get comments. You can work out your overall Conversion Rate by simply dividing the number of comments (spam comments don&#8217;t count!) by the number of visits and multiplying it by a hundred. If you had 4,000 visits in one week (hurrah!) and 200 comments, then your Conversion Rate for comments is ( 200 / 4000 ) * 100 = 5%. </p>
<p>That&#8217;s actually a really great rate &#8211; figure on 1% being an average rate. Of course, this varies wildly depending on what you&#8217;re doing, but as an extremely rough starting point it&#8217;s not too bad.</p>
<p>Note that we have barely even scratched the surface of what Analytics is capable of in the right hands. It can tell you where people are coming from, how long they&#8217;re staying, what they&#8217;re looking at and even what they&#8217;re clicking on. You can also have it work out all of your Conversion Rates automatically for up to 20 different goals. The trick, however, is not to focus on the numbers (or <em>metrics</em>) but on <em>what the data tells you</em> (it&#8217;s all too easy to get hung up on visitor numbers when, as we&#8217;ve seen, that&#8217;s not really what counts).</p>
<h3>OK, I Know My Conversion Rate &#8211; Now What</h3>
<p>If it&#8217;s a good rate then now is the time to start increasing traffic! Use the methods you&#8217;ve been using but increase their effectiveness. For example, if Twitter is getting you good traffic that converts, then increase your Twitter activity. If commenting on other blogs is helping, do that more. If certain keywords are bringing you traffic, schedule a few more posts around those words.</p>
<p>If it&#8217;s a poor Conversion Rate, then you need to fix it first! Throwing traffic at a bad (or non-existent) rate is a waste of your time and your bandwidth because no one is engaging with what you&#8217;re doing. There are potentially many reasons for this. </p>
<p>We&#8217;ll assume that you&#8217;ve taken care of the basics &#8211; you have a great looking site that functions well and is full of top quality content &#8211; but, even still, users aren&#8217;t engaging. Unfortunately, we rarely know through Analytics the most important reason why users aren&#8217;t getting involved but this doesn&#8217;t mean that we can&#8217;t do anything about it.</p>
<h3>That Important Reason</h3>
<p>So what is this mysterious thing that all of this data cannot tell us? </p>
<p>User Intention. </p>
<p>We rarely know <em>why</em> a user is visiting a website. You can guess and conjecture all that you want but the fact is that, until you ask them, you&#8217;ll never be totally sure. Even if you ask them, they may not tell you the full story (&#8216;I was on that porn site for research purposes! Honest!&#8217;). </p>
<p>There are ways to ask users why they visited your site, such as surveys, but even these won&#8217;t often give you the full picture because (apart from the innocent mistruths), the people that generally respond to surveys will be at the emotional extremes &#8211; incredibly happy or incredibly annoyed, for example &#8211; and may not be representitive of the majority. </p>
<p>So what can you do?</p>
<p>Test. Testing is the best way to find out what is engaging your users. Using your Conversion Rate as your baseline figure for measuring how successful your tests are, you can tweak and change to see what things will help you engage your users more.</p>
<p>For example, if you change the headline on your main sales page, does your Conversion Rate increase or decrease? How about if you change the main picture? What about floating it to the left or the right? Of course, the naysayers will say that they &#8216;know their users&#8217; and that their users aren&#8217;t dumb enough to be swayed to change by the simple placement of a picture. </p>
<p>The savvy, however, will never be arrogant enough to assume and will test to find out for sure (and then they will, very often, be surprised at the results).</p>
<p>Obviously, this is a very brief introduction into the deep and wide world of Analytics and conversion. I&#8217;ll be exploring various topics in more detail in future posts, so sign up to my <a href="http://feeds.feedburner.com/LineInWebDesign">RSS feed</a> or <a href="#signup">email mailing list</a> to make sure that you don&#8217;t miss them!</p>
<img src="http://line-in.co.uk/?ak_action=api_record_view&id=333&type=feed" alt="" />

<p>Related posts:<ol><li><a href='http://line-in.co.uk/getting-visitors/' rel='bookmark' title='Permanent Link: How We Got Over 8,000 Visits In Less than Three Months'>How We Got Over 8,000 Visits In Less than Three Months</a></li>
<li><a href='http://line-in.co.uk/referral-competition/' rel='bookmark' title='Permanent Link: Competition &#8211; Win a Free Blog Consultation!'>Competition &#8211; Win a Free Blog Consultation!</a></li>
<li><a href='http://line-in.co.uk/why-i-love-my-clients/' rel='bookmark' title='Permanent Link: Why I Love My Clients'>Why I Love My Clients</a></li>
</ol></p><img src="http://feeds.feedburner.com/~r/LineInWebDesign/~4/S78TRNUv6Vo" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://line-in.co.uk/getting-a-good-conversion-rate/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://line-in.co.uk/getting-a-good-conversion-rate/</feedburner:origLink></item>
		<item>
		<title>How To Upgrade To WordPress 3 Safely</title>
		<link>http://feedproxy.google.com/~r/LineInWebDesign/~3/AMVOBNwayOU/</link>
		<comments>http://line-in.co.uk/upgrade-wordpress-3/#comments</comments>
		<pubDate>Mon, 28 Jun 2010 16:00:05 +0000</pubDate>
		<dc:creator>Simon</dc:creator>
				<category><![CDATA[Tutorials]]></category>
		<category><![CDATA[Wordpress]]></category>

		<guid isPermaLink="false">http://line-in.co.uk/?p=518</guid>
		<description><![CDATA[<p><img width="620" height="372" src="http://line-in.co.uk/wp-content/uploads/2010/06/li_post_upgrade-header-620x372.jpg" class="attachment-large wp-post-image" alt="Header image for the Upgrade to Wordpress 3 post" title="Upgrade to Wordpress 3" /></p>The recent release of the world&#8217;s most popular blogging platform has seen some huge additions, including the ability to add custom Post Types and custom Taxonomies, and support for multiple blogs. Other improvements include support for custom stylesheets to style [...]]]></description>
			<content:encoded><![CDATA[<p><img width="620" height="372" src="http://line-in.co.uk/wp-content/uploads/2010/06/li_post_upgrade-header-620x372.jpg" class="attachment-large wp-post-image" alt="Header image for the Upgrade to Wordpress 3 post" title="Upgrade to Wordpress 3" /></p><p>The recent release of the world&#8217;s most popular blogging platform has seen some huge additions, including the ability to add custom Post Types and custom Taxonomies, and support for multiple blogs.</p>
<p>Other improvements include support for custom stylesheets to style the post and page editors. What this means is that what you see in the editor more closely resembles the final product.</p>
<p>To take advantage of these amazing new features, you&#8217;ll need to upgrade. Upgrading your current version of WordPress to the new version is pretty easy and all of the core functionality <em>should</em> just continue to work as normal and you shouldn&#8217;t lose anything.</p>
<p>However, there have been reports of bugs in some plugins and themes after the new version has been installed, so some care should be taken.</p>
<p><span id="more-518"></span></p>
<p>WordPress recommends that you have a complete backup of your site before you attempt to upgrade, just in case the worst happens. In this post, I&#8217;m going to walk you through the steps of backing up your WordPress install before upgrading.</p>
<h3>Prerequisites</h3>
<p>There are a few thing that you should have to hand before starting:</p>
<ol>
<li>Webhost control panel login details &#8211; note that I&#8217;m assuming that you&#8217;re using CPanel, but the steps should be similar on other providers like Plesk</li>
<li>Database name &#8211; this is the name you gave your database when you first setup WordPress. If you&#8217;re not sure you can use the CPanel file manager to browse to the root directory and open up the file named &#8216;wp-config.php&#8217; &#8211; the database name is in there.</li>
</ol>
<p>There are two main parts to a WordPress install, the files and the database. Both should be backed up prior to upgrading. The good news is that, if you&#8217;re host is using CPanel, both these jobs are relatively straightforward.</p>
<h3>Backing Up Your Database</h3>
<p><em>Note: There are plugins that handle database backups available as well, but I won&#8217;t be discussing them here.</em></p>
<p>1) Log into your CPanel account, browse down to PHPMyAdmin and click the icon to open it up</p>
<p><a rel="attachment wp-att-533" href="http://line-in.co.uk/upgrade-wordpress-3/1-cpanel-phpmyadmin/"><img class="aligncenter size-large wp-image-533" title="CPanel PHPMyAdmin icon" src="http://line-in.co.uk/wp-content/uploads/2010/06/1-cpanel-phpmyadmin-620x596.jpg" alt="CPanel PHPMyAdmin icon" width="620" height="596" /></a></p>
<p>2) Once you&#8217;re in, select your blog&#8217;s database by clicking on the database name in the right hand panel (<em>note: you might have more databases listed &#8211; make sure you choose the right one!</em>)</p>
<p><a rel="attachment wp-att-532" href="http://line-in.co.uk/upgrade-wordpress-3/2-phpmyadmin-select-db/"><img class="aligncenter size-full wp-image-532" title="PHPMyAdmin Select Database" src="http://line-in.co.uk/wp-content/uploads/2010/06/2-phpmyadmin-select-db.jpg" alt="PHPMyAdmin Select Database" width="553" height="437" /></a></p>
<p>3) Click on &#8216;Export&#8217; along the top menu bar</p>
<p><a rel="attachment wp-att-531" href="http://line-in.co.uk/upgrade-wordpress-3/3-phpmyadmin-export-db/"><img class="aligncenter size-large wp-image-531" title="PHPMyAdmin Export Database" src="http://line-in.co.uk/wp-content/uploads/2010/06/3-phpmyadmin-export-db-620x242.jpg" alt="PHPMyAdmin Export Database" width="620" height="242" /></a></p>
<p>4) Make sure that all of the tables are highlighted here (click <code>Select All</code> if you&#8217;re not sure) :</p>
<p><a rel="attachment wp-att-530" href="http://line-in.co.uk/upgrade-wordpress-3/4-phpmyadmin-select-tables/"><img class="aligncenter size-large wp-image-530" title="PHPMyAdmin Select Tables" src="http://line-in.co.uk/wp-content/uploads/2010/06/4-phpmyadmin-select-tables-620x367.jpg" alt="PHPMyAdmin Select Tables" width="620" height="367" /></a></p>
<p>5) Check the box that says <code>Save As File</code> and then give it a name.</p>
<p><a rel="attachment wp-att-529" href="http://line-in.co.uk/upgrade-wordpress-3/5-phpmyadmin-save-as/"><img class="aligncenter size-large wp-image-529" title="PHPMyAdmin Export tables" src="http://line-in.co.uk/wp-content/uploads/2010/06/5-phpmyadmin-save-as-620x531.jpg" alt="PHPMyAdmin Export tables" width="620" height="531" /></a></p>
<p>6) Click <code>Go</code>, and the browser &#8216;Save as&#8230;&#8217; dialog will pop up. Save this file somewhere safe &#8211; I usually put it on the desktop while I&#8217;m working with it.</p>
<p><strong>Backing Up Your Files</strong></p>
<p>If you&#8217;re using CPanel, the quickest way to get a copy of all of your files is to backup your home directory.</p>
<p>1) Log into your CPanel account and browse to <code>Backups</code>.</p>
<p><a rel="attachment wp-att-528" href="http://line-in.co.uk/upgrade-wordpress-3/6-cpanel-backups/"><img class="aligncenter size-large wp-image-528" title="CPanel Backups Icon" src="http://line-in.co.uk/wp-content/uploads/2010/06/6-cpanel-backups-620x596.jpg" alt="CPanel Backups Icon" width="620" height="596" /></a></p>
<p>2) Under <code>Download a Home Directory Backup</code> click <code>Home Directory</code>.</p>
<p><a rel="attachment wp-att-527" href="http://line-in.co.uk/upgrade-wordpress-3/7-cpanel-backup-home/"><img class="aligncenter size-large wp-image-527" title="CPanel Backups page" src="http://line-in.co.uk/wp-content/uploads/2010/06/7-cpanel-backup-home-620x551.jpg" alt="CPanel Backups page" width="620" height="551" /></a></p>
<p>3) The browser &#8216;Save as&#8230;&#8217; dialog will open. Again, save this file somewhere safe in case you need it. Note that it may be a very large file &#8211; perhaps hundreds of megabytes &#8211; depending on how many photos and things you&#8217;ve uploaded.</p>
<p><strong>Upgrading WordPress</strong></p>
<p>Now you have a backup of the database and files, you can get on with upgrading.</p>
<p>1) Log in to your WordPress Admin panel.</p>
<p>2) Go to <code>Upgrade</code></p>
<p><a rel="attachment wp-att-526" href="http://line-in.co.uk/upgrade-wordpress-3/8-upgrade-wordpress/"><img class="aligncenter size-large wp-image-526" title="Wordpress Upgrade Page" src="http://line-in.co.uk/wp-content/uploads/2010/06/8-upgrade-wordpress-620x362.jpg" alt="Wordpress Upgrade Page" width="620" height="362" /></a></p>
<p>3) click <code>Upgrade Automatically</code>. WordPress will download and install itself.</p>
<p>4) After installation, you might be asked to do a Database upgrade as well. Make sure that you do this.</p>
<p>5) Return to the <code>Upgrade</code> panel, and make sure that you upgrade all of your plugins.</p>
<p>6) You&#8217;re done! If everything&#8217;s gone smoothly, you should be running the latest version of WordPress. If something&#8217;s gone wrong, don&#8217;t panic. Go down to &#8216;Copying Your Upgraded Database&#8217; below and follow the steps.</p>
<h3>Disaster Recovery!</h3>
<p>If something goes horribly wrong, don&#8217;t panic! All you need to do is restore your database and files and you should be all set. Once again, CPanel makes this easy.</p>
<p><strong>Restore Your Files</strong></p>
<p>1) Log into CPanel and click on <code>Backups</code></p>
<p>2) Click on <code>Restore A Home Directory Backup</code></p>
<p><a rel="attachment wp-att-522" href="http://line-in.co.uk/upgrade-wordpress-3/12-cpanel-restore-backups/"><img class="aligncenter size-large wp-image-522" title="CPanel Restore Backups page" src="http://line-in.co.uk/wp-content/uploads/2010/06/12-cpanel-restore-backups-620x551.jpg" alt="CPanel Restore Backups page" width="620" height="551" /></a></p>
<p>3) Remember that entire home directory backup file you downloaded? The really huge one? Click <code>Browse</code> and go find it.</p>
<p>4) Click <code>Upload</code>, then go make yourself a cup of coffee &#8211; this might take a while</p>
<p><strong>Restore Your Database</strong></p>
<p>1) Log into CPanel and browse to PHPMyAdmin</p>
<p>2) Select your blog database</p>
<p><a rel="attachment wp-att-532" href="http://line-in.co.uk/upgrade-wordpress-3/2-phpmyadmin-select-db/"><img class="aligncenter size-full wp-image-532" title="PHPMyAdmin Select Database" src="http://line-in.co.uk/wp-content/uploads/2010/06/2-phpmyadmin-select-db.jpg" alt="PHPMyAdmin Select Database" width="553" height="437" /></a></p>
<p>3) Check the <code>Check All</code> button to select all of the tables</p>
<p><a rel="attachment wp-att-525" href="http://line-in.co.uk/upgrade-wordpress-3/9-select-tables/"><img class="aligncenter size-full wp-image-525" title="PHPMyAdmin Select All Tables" src="http://line-in.co.uk/wp-content/uploads/2010/06/9-select-tables.jpg" alt="PHPMyAdmin Select All Tables" width="604" height="558" /></a></p>
<p>4) Choose <code>Drop</code> from the drop-down menu labeled <code>With Selected: </code>. It&#8217;ll ask you if you&#8217;re sure you want to do that. You are (you DO have that backup, right? Triple check before you hit &#8216;Yes&#8217;)</p>
<p><a rel="attachment wp-att-524" href="http://line-in.co.uk/upgrade-wordpress-3/10-drop-tables/"><img class="aligncenter size-large wp-image-524" title="PHPMyAdmin Drop Tables" src="http://line-in.co.uk/wp-content/uploads/2010/06/10-drop-tables-620x335.jpg" alt="PHPMyAdmin Drop Tables" width="620" height="335" /></a></p>
<p>5) Click <code>Import</code> along the top row, then click <code>Browse...</code></p>
<p><a rel="attachment wp-att-523" href="http://line-in.co.uk/upgrade-wordpress-3/11-import-db/"><img class="aligncenter size-large wp-image-523" title="PHPMyAdmin Import Database page" src="http://line-in.co.uk/wp-content/uploads/2010/06/11-import-db-620x342.jpg" alt="PHPMyAdmin Import Database page" width="620" height="342" /></a></p>
<p>6) Find the database file you downloaded earlier (it should have the file extension &#8216;.sql&#8217;), select it and then hit OK</p>
<p>7) Click <code>Go</code> and wait until you get the confirmation screen &#8211; if everything executed successfully, you can now close that down &#8211; that&#8217;s your database restored.</p>
<p>And that&#8217;s it! With any luck, your blog should be back to how it was before the upgrade!</p>
<p>If you still don&#8217;t feel very confident and would like some help in updating your WordPress Site, then please <a href="http://line-in.co.uk/contact">get in touch</a>.</p>
<img src="http://line-in.co.uk/?ak_action=api_record_view&id=518&type=feed" alt="" />

<p>Related posts:<ol><li><a href='http://line-in.co.uk/optimize-wordpress-database/' rel='bookmark' title='Permanent Link: Optimize Your WordPress Database'>Optimize Your WordPress Database</a></li>
<li><a href='http://line-in.co.uk/how-to-use-dreamweavers-site-specific-code-hinting/' rel='bookmark' title='Permanent Link: How To Use Dreamweaver CS5′s New Site-Specific Code Hinting'>How To Use Dreamweaver CS5′s New Site-Specific Code Hinting</a></li>
<li><a href='http://line-in.co.uk/wordpress-sites/' rel='bookmark' title='Permanent Link: Why WordPress Sites?'>Why WordPress Sites?</a></li>
</ol></p><img src="http://feeds.feedburner.com/~r/LineInWebDesign/~4/AMVOBNwayOU" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://line-in.co.uk/upgrade-wordpress-3/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://line-in.co.uk/upgrade-wordpress-3/</feedburner:origLink></item>
	</channel>
</rss><!-- Performance optimized by W3 Total Cache. Learn more: http://www.w3-edge.com/wordpress-plugins/

Minified using disk
Page Caching using disk (enhanced)

Served from: line-in.co.uk @ 2010-09-08 03:45:22 -->
