BUY Klaricid ONLINE WITHOUT PRESCRIPTION
Dec
After Engadget BUY Klaricid ONLINE WITHOUT PRESCRIPTION, redesigned their website a few weeks ago, I noticed how their sidebar contained some unique methods of displaying posts. Buy Klaricid ONLINE WITHOUT prescription, A nice featured posts section, a fancy calendar and an awesome most commented, buy no prescription Klaricid online, Where to buy Klaricid, digg and twitter section. Using the amount of comments to determine the width and having each post a different color to produce a rainbow, purchase Klaricid, Order Klaricid from United States pharmacy, I thought was an awesome idea. So I had a go at making the most commented section for CreativityDen, rx free Klaricid. Order Klaricid no prescription, It turned out pretty well, so I decided to share it with you, buy cheap Klaricid no rx. All credit goes to Code and Theory, BUY Klaricid ONLINE WITHOUT PRESCRIPTION. Klaricid over the counter,
Colorful comment section
The colorful comment section developed and designed for wordpress blogs.
[caption id="attachment_2046" align="aligncenter" width="550" caption="Colourful comments"]
[/caption]Querying and displaying the most commented posts
The code is fairly simple, where can i buy cheapest Klaricid online. Order Klaricid from mexican pharmacy, Firstly, it queries the database, comprar en línea Klaricid, comprar Klaricid baratos, Where can i find Klaricid online, finding the x most commented posts between two given dates. It then loops through the posts calculating the width and color of each post, Klaricid gel, ointment, cream, pill, spray, continuous-release, extended-release. BUY Klaricid ONLINE WITHOUT PRESCRIPTION, I have tried to make the code as readable as possible, but if you have any problems do not hesitate to leave a comment. Buy Klaricid without a prescription, I am currently learning php myself so anyone who can improve this code, please share your improved version :)
My Version
My attempt is referred to as 'spaghetti code' - don't use it, online buy Klaricid without a prescription. Klaricid from canadian pharmacy, Instead use Dylan's improved version below mine. I shall leave my version up so you can see the mistakes I made and how Dylan cleaned my mess up, Klaricid for sale. Buying Klaricid online over the counter, :)
[php htmlscript="true"]
<h2>Most commented</h2>
<ul id="most_commented">
<?php
#Fetch the five most commented posts between the 1st of January 2009 to the 31st of December 2009
$result = $wpdb->get_results("SELECT comment_count,ID, canada, mexico, india, Purchase Klaricid ONLINE WITHOUT prescription, post_title, post_date FROM $wpdb->posts WHERE post_date BETWEEN '2009-01-01' AND '2009-12-31' ORDER BY comment_count DESC LIMIT 0, japan, craiglist, ebay, overseas, paypal, Fast shipping Klaricid, 5");
#Declare counter variable
$i = 1;
#Loop through each post
foreach ($result as $topfive)
{
$postid = $topfive->ID;
$title = $topfive->post_title;
$commentcount = $topfive->comment_count;
#My hacky way of finding the number of comments on the most commented post
if ($i == 1) {$mostcomments = $commentcount;}
if ($commentcount != 0)
{
#Display our results
echo '<li style="width:';
#Determine the width for each post, the width of my sidebar was 260px, ordering Klaricid online, Kjøpe Klaricid på nett, köpa Klaricid online, you will need to change this value to the width of sidebar (don't forget padding etc).
echo round((260/$mostcomments)*$commentcount,1).'px; ';
#Change the color for each post - hex values - change these values to have different colors
echo 'background-color:#';
if ($i == 1) echo 'c32a2a';
elseif ($i == 2) echo 'c37d2a';
elseif ($i == 3) echo 'bac32a';
elseif ($i == 4) echo '8fc32a';
elseif ($i == 5) echo '4ec32a';
echo ' ;"> ';
#Display the post title with a link to the post
echo '<a href=" ';
echo get_permalink($postid);
echo ' "> ';
echo $title;
echo '</a>';
#Display the comment number
echo '<div class="comment_no">';
echo $commentcount;
echo '</div></li>';
}
$i++;
}
?>
</ul>
[/php]
Dylan's much improved version
[php htmlscript="true"]
<h2>Most commented</h2>
<ul id="most_commented">
<?php
# Fetch the five most commented posts in the last 12 months
$result = $wpdb->get_results("SELECT comment_count,ID,post_title, post_date FROM $wpdb->posts WHERE post_date BETWEEN NOW() AND DATE_SUB(NOW(), INTERVAL 12 MONTH) ORDER BY comment_count DESC LIMIT 5");
# Initialize $mostcomments
$mostcomments = FALSE;
# Initialize the colors, BUY Klaricid ONLINE WITHOUT PRESCRIPTION. Change these values to have different colours
$colors = array(
'#c32a2a', online buying Klaricid hcl, Buy Klaricid from mexico, '#c37d2a',
'#bac32a', buy cheap Klaricid, Purchase Klaricid online, '#8fc32a',
'#4ec32a');
#Loop through each post
foreach ($result as $i=>$topfive)
{
$postid = $topfive->ID;
$title = $topfive->post_title;
$commentcount = $topfive->comment_count;
# store the most comments in the first iteration, Klaricid trusted pharmacy reviews, Where can i buy Klaricid online, as a non-zero value evaluates to TRUE
$mostcomments = ($mostcomments) . $mostcomments : $commentcount;
if ($commentcount != 0)
{
#Determine the width for each post, order Klaricid online c.o.d, Canada, mexico, india, the width of my sidebar was 260px, you will need to change this value to the width of sidebar (don't forget padding etc), purchase Klaricid ONLINE WITHOUT prescription. Order Klaricid online overnight delivery no prescription, $width = round((260/$mostcomments)*$commentcount,1).'px; ';
# use $i to correlate to an element in $colors rather than 5 if() statements
$background_color = $colors[$i];
# Get the permalink for this post
$permalink = get_permalink($postid);
# Use heredocs to output, australia, uk, us, usa, Fast shipping Klaricid, to save on 1001 echo statements
# Closing COUNT; is intentionally indented weird (see docs for why)
echo <<<COUNT
<li style = "width:$width;background-color:$background_color;">
<a href = "$permalink">$title</a>
<div class = "comment_no">$commentcount</div>
</li>
COUNT;
}
}
?>
</ul>
[/php]
I decided to insert this code into my sidebar, however you can put it anywhere on your blog, buy Klaricid from canada. Real brand Klaricid online,
Add a little CSS
[css]
#most_commented a {
color: #000;
font-size: 14px;
}
#most_commented a:hover {
color: #fff;
}
#most_commented li {
position: relative;
min-height: 40px;
opacity: 0.9;
margin: 0 0 -15px 0 !important;
padding: 15px 10px 15px 10px !important;
}
#most_commented li .comment_no {
position: absolute;
top: 12px;
right: -11px;
padding: 5px;
color: #efefef;
background-color: #101010;
-moz-border-radius: 5px;
-webkit-border-radius: 5px;
}
[/css]
Done. Easy as pie
Stay tuned, buy cheap Klaricid no rx. I plan on implementing this for most viewed posts and most tweeted/dugg posts :).
Similar posts: BUY Ansaid ONLINE WITHOUT PRESCRIPTION. BUY Ilosone ONLINE WITHOUT PRESCRIPTION. Order Diges Tea online c.o.d. Order Keflex online c.o.d.
Trackbacks from: BUY Klaricid ONLINE WITHOUT PRESCRIPTION. BUY Klaricid ONLINE WITHOUT PRESCRIPTION. Comprar en línea Klaricid, comprar Klaricid baratos. Order Klaricid online overnight delivery no prescription. Rx free Klaricid.
Discussion
Thanks for sharing this interesting script.
amazing code for famous bloggers.
Nifty! Thanks for taking the time to share Liam. I’m interested to see this for most viewed posts as well.
Thanks for the comments guys
@John No problem, stay tuned for most viewed
Thanks for sharing this amazing stuff
Here’s some cleaned up code. The original had what developers call, “spaghetti code” – output mixed with logic. I’ve removed that and, in my opinion, simplified the steps needed.
I also changed the query a bit to show results from the last 12 months, not a statically stated date range. This will allow you to not need to updated the query every year. I also fixed the LIMIT clause. You don’t need to specify the 0, as the result set always starts at the beginning. You’d only use something like LIMIT 10,5 if you wanted 5 rows starting at the 10th row.
I’ve never commented here before, so I’ll wrap my code in code tags to see if it does anything.
<h2>Most commented</h2> <ul id="most_commented"> <?php # Fetch the five most commented posts in the last 12 months $result = $wpdb->get_results("SELECT comment_count,ID,post_title, post_date FROM $wpdb->posts WHERE post_date BETWEEN NOW() AND DATE_SUB(NOW(), INTERVAL 12 MONTH) ORDER BY comment_count DESC LIMIT 5"); # Initialize $mostcomments $mostcomments = FALSE; # Initialize the colors. Change these values to have different colours $colors = array( '#c32a2a', '#c37d2a', '#bac32a', '#8fc32a', '#4ec32a'); #Loop through each post foreach ($result as $i=>$topfive) { $postid = $topfive->ID; $title = $topfive->post_title; $commentcount = $topfive->comment_count; # store the most comments in the first iteration, as a non-zero value evaluates to TRUE $mostcomments = ($mostcomments) ? $mostcomments : $commentcount; if ($commentcount != 0) { #Determine the width for each post, the width of my sidebar was 260px, you will need to change this value to the width of sidebar (don't forget padding etc). $width = round((260/$mostcomments)*$commentcount,1).'px; '; # use $i to correlate to an element in $colors rather than 5 if() statements $background_color = $colors[$i]; # Get the permalink for this post $permalink = get_permalink($postid); # Use heredocs to output, to save on 1001 echo statements # Closing COUNT; is intentionally indented weird (see docs for why) echo <<<COUNT <li style = "width:$width;background-color:$background_color;"> <a href = "$permalink">$title</a> <div class = "comment_no">$commentcount</div> </li> COUNT; } } ?> </ul>Also, the reply field is horrible. I absolutely can’t read the labels beside the fields, and can barely make out the name field. Black on black? Come on. I’m using FF3.5 on OS X.
Thanks for the awesome reply Dylan, I shall edit the post with your improved code.
I shall definitely be reading up on the improvements you made, looks a bit advanced for me atm :S
Sorry about the reply field being horrible. I had just added an “about author” section which had some conflicting id names with the comment form. I have fixed this as well as brightened up the label names
Thanks again for taking the time to improve my spaghetti code
EDIT: Just added your improved code to CreativityDen and it didn’t seem to like the query, returned nothing. I’m not entirely sure, but I don’t think the MYSQL Functions are working (guessing). I’m looking into it.
Just fire me off an email if you have any questions.
Damn that is funky… haha thanks for the tut!
no problem Blogger Den
Looks really good, thank you!
Thanks for sharing this. I’m interested in doing something along this line on my site.
this is really cool and funky
… thanks for the share
Great tutorial, thanks for sharing!
Thanks for the comments people!
WOw i love this idea, mind if I steal errrr… use it in some other way? I was thinking of doing this for my hot posts this month.
is there an solution for articles per category?
Hello,
I am trying to use Dylan’s code for placing the “most commended” section on my blog’s sidebar. I copied the code and then I selected to add an HTML/JavaScript gadget. Unfortunately, it is not working and I am pretty sure that I am doing something wrong… could you please help me by pointing out what I should change in the code?
Thank you!
interesting, thanks for the sharing!
i like this post http://bit.ly/cQ32cZ
Leave a comment