Ticket #19102: front-page.php

<?php
/**
 * The template for the front page of u.osu.edu
 *
 * @package WordPress
 * @subpackage U
 */
wp_enqueue_style('front-page-css', get_bloginfo('template_directory') . '/css/front-page.css');
wp_enqueue_script('front-page', get_bloginfo('template_directory') . '/js/front-page.js', array('jquery'));
get_header(); ?>

<div id="primary">
  <div id="content" role="main">
    <div class="content-section">
    <?php
      global $wpdb;
      $sql = 'SELECT * FROM wp_blogs WHERE NOT blog_id = "1" AND public = "1" AND archived = "0" AND mature = "0" AND spam = "0" AND deleted = "0" ORDER BY rand() LIMIT 4';
      $blogs = $wpdb->get_results($sql);
    
      echo '<h2>Sites from around Ohio State</h2>';
      echo '<div class="content-section-main"><ul id="slider">';
      foreach ($blogs as $blog) {
        $blog_name = get_blog_option($blog->blog_id, 'blogname');
        $blog_description = get_blog_option($blog->blog_id, 'blogdescription');
        $site_url = 'http://' . $blog->domain . $blog->path;
        echo '<li class="content">';
        echo '<a href="' . $site_url . '"><img class= "site-thumbnail" src="' . get_bloginfo('template_directory') . '/images/screenshots/shot.png"/></a>';
        echo '<div class="site-details">';
        echo '<h4 class="site-title"><a href="' . $site_url . '">' . $blog_name . '</a></h4>';
        echo '<div class="site-description">' . $blog_description . '</div>';
        echo '</div>';
        echo '</li>';
        break;
      }
      echo '</ul></div>';
    ?>
    </div>

    <div class="content-section">
      <h2>Join u.osu.edu</h2>
      <div class="content-section-main">
        <div class="left">Set your site up to start customizing, blogging, etc.</div>
        <a id="setup-new-site" href="<?php echo get_bloginfo('url'); ?>/register">
        <button class="big_button" type="button">Get Started!</button>
      </a>
      </div>
    </div>
  </div><!-- #content -->
</div><!-- #primary -->

<?php get_footer(); ?>