ben1

<?php

 $querystr = "

    SELECT wposts.*

    FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta

    WHERE wposts.ID = wpostmeta.post_id

    AND (wpostmeta.meta_key = 'rating_value'

    OR wpostmeta.meta_key = 'rating')

    AND wposts.post_status = 'publish'

    AND wposts.post_type = 'post'

    ORDER BY wposts.post_date DESC

 ";

 $pageposts = $wpdb->get_results($querystr, OBJECT);

  ?>

    <?php if ($pageposts): ?>

    <?php foreach ($pageposts as $post): ?>

    <?php setup_postdata($post); ?>

    <?php static $ctr = 0;

if ($ctr == "8") { break; }

else { ?>

    <?php if ($ctr > "4" ) { ?>

    <?php $width = 43;

          $height = 43;



          $classtext = 'thumbnail-small';

          $titletext = get_the_title();



          $thumbnail = get_thumbnail($width,$height,$classtext,$titletext,$titletext,false,'image_value');

          $thumb = $thumbnail["thumb"]; ?>



    <?php $rating = get_post_meta($post->ID, 'rating_value', $single = true);

          $rating2 = get_post_meta($post->ID, 'rating', $single = true);

          $rating3 = get_post_meta($post->ID, 'gamerating', $single = true);

          $rating4 = get_post_meta($post->ID, 'musicrating', $single = true);

          $age = get_post_meta($post->ID, 'age', $single = true);

          $type = get_post_meta($post->ID, 'type', $single = true); ?>



    <div class="post-inside-small">



        <?php if($thumb <> '') { ?>

            <a href="<?php the_permalink() ?>" title="<?php printf(esc_attr__('Click to read our verdict on %s','eGamer'), get_the_title()) ?>">

                <?php print_thumbnail($thumb, $thumbnail["use_timthumb"], $titletext, $width, $height, $classtext); ?>

            </a>

        <?php } ?>



        <a href="<?php the_permalink() ?>" title="<?php printf(esc_attr__('Click to read our verdict on %s','eGamer'), get_the_title()) ?>" style="float: left;">

        <?php truncate_title(26) ?>

        </a>



<!-- This is the code for the star rating -->

        <img src="<?php bloginfo('template_directory'); ?>/images/star-<?php if($rating2 <> '') { ?><?php echo get_post_meta($post->ID, "rating", true); ?><?php }

        elseif($rating3 <> '') { ?>game<?php echo get_post_meta($post->ID, "gamerating", true); ?><?php }

        elseif($rating4 <> '') { ?>music<?php echo get_post_meta($post->ID, "musicrating", true); ?><?php }

        else { ?><?php echo esc_attr($rating); ?><?php }; ?>.gif" alt="rating" style="float: right;" />



<!-- puts the rest onto the bottom line -->

        <span class="post-info-small">



<?php if((get_post_meta($post->ID, "release", true)) <> '') { ?>

        <?php echo ucfirst(get_post_meta($post->ID, "type", true));?>

        <?php esc_html_e(' released on','eGamer'); ?>

        <?php echo get_post_meta($post->ID, "release", true); ?>

        <?php esc_html_e(' | Rated','eGamer'); ?>

        <?php echo strtoupper(get_post_meta($post->ID, "age", true)); ?>

<?php } else { ?>

        <?php echo ucfirst(get_post_meta($post->ID, "type", true));?>

        <?php esc_html_e(' review posted','eGamer') ?>

        <?php the_time('j M Y') ?>

        <?php esc_html_e(' | Rated','eGamer'); ?>

        <?php echo strtoupper(get_post_meta($post->ID, "age", true)); ?>



<?php } ?>

        </span> </div>

    <div style="clear: both;"></div>

    <?php $ctr++; } ?>

    <?php } ?>

    <?php endforeach; ?>

    <?php endif; ?>