<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page 
  check lines 78, 105, 124, 143
  */
  require_once "/hsphere/local/home/terreryb/terrerybovich.com/cmsAdmin/lib/viewer_functions.php";

  list($common_informationRecords, $common_informationMetaData) = getRecords(array(
    'tableName'   => 'common_information',

    'limit'       => '1',
  ));
  $common_informationRecord = @$common_informationRecords[0]; // get first record


 // load records from 'blog_chapter_details'
  list($blog_chapter_detailsRecords, $blog_chapter_detailsMetaData) = getRecords(array(
    'tableName'   => 'blog_chapter_details',
    
  ));
  
   list($blog_chaptersRecords, $blog_chaptersMetaData) = getRecords(array(
    'tableName'   => 'blog_chapters',
  ));
  
  
 // load records
  list($google_font_namesRecords, $google_font_namesMetaData) = getRecords(array(
    'tableName'   => 'google_font_names',
  ));
    
    list($navigation_menu_link_textRecords, $navigation_menu_link_textMetaData) = getRecords(array(
    'tableName'   => 'navigation_menu_link_text',
    'loadUploads' => true,
    'allowSearch' => false,
  ));
  
  
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>T e r r e &nbsp; R y b o v i c h &nbsp; W e l c o m e s &nbsp; Y o u</title>
<meta http-equiv="Content-Style-Type" content="text/css" />
<link rel="stylesheet" type="text/css" href="css/terre2.css.php" />
<link rel="stylesheet" type="text/css" href="css/fonts.css.php" />
<link rel="stylesheet" type="text/css" href="http://fonts.googleapis.com/css?family=<?php 
    $output = ''; 
    foreach ($google_font_namesRecords as $record) { $record['name'] = preg_replace("/[, ]/", "+", $record['name']);
      $output .= $record['name'] . "|"; 
    } 
    $output = rtrim($output,"|"); // remove trailing pipe 
    print $output; 
?>">
<link rel="shortcut icon" type="image/ico" href="/favicon.ico" />
<script type="text/javascript" src="Scripts/css3-multi-column.js"></script>
<meta name="description" content="<?php echo $common_informationRecord['site_description'] ?>">
<meta name="keywords" content="<?php echo $common_informationRecord['keywords'] ?>">
<link rel="shortcut icon"  href="http://www.terrerybovich.com/favicon.ico" >
</head>

<body>
<div align="center">
<br />
<table  align="center" width="80%" cellpadding="15">
  <tr>
    <td align="center" valign="top"><table  border="0" align="center" cellpadding="0" cellspacing="0" >
        <tr>
          <td align="right" valign="middle"><a href="index.php"><span class="masthead_font">Terre&nbsp;Rybovich</span></a></td>
          <td><img src="images/clear.gif" alt="" width="25" height="25" /></td>
          <?php foreach ($navigation_menu_link_textRecords as $record): ?>
          <td align="center" valign="middle"><a  href="<?php echo htmlencode($record['linked_page']) ?>" class="navigation"><?php echo htmlencode($record['title']) ?></a></td>
          <td><img src="images/clear.gif" alt="" width="25" height="25" /></td>
          <?php endforeach ?>
      </table>
      <div align="center" style="width:60%"> <br />
        <br />
        <br />
        <span class="page_title_font"><b><?php echo strtoupper($common_informationRecord['blog_heading']) ?></b></span><br/>
        <span class=" text_font"><?php echo strtoupper($common_informationRecord['blog_header_text']) ?></span> <br />
      </div></td>
  </tr>
</table>

<?php if ($common_informationRecord['blog_post_order'] == "Visitors Choice" ):?>
<span class="heading_font">Have It Your Way</span><br />
<form method="POST" action="<?php echo $_SERVER['PHP_SELF'] ?>">
  <input type="hidden" name="blog_chapter" value="<?php echo @$_REQUEST['blog_chapter']; ?>">
  <select name="order">
   <option value="b">earliest post at the top</option>
    <option value="a">most recent post at the top</option>
  </select>
  <input type="submit" name="submit" value="Click/Tap To Choose Display Order">
</form>
<?php $orderBy = "date";
if (@$FORM['order'] == 'b') { $orderBy = "date"; }
if (@$FORM['order'] == 'a') { $orderBy = "date DESC"; }

?>
<?php $record_limit = $common_informationRecord['record_limit'] ?>
<?php if (@!$record_limit ) { $record_limit1 = ""; } ?>
<?php if (@$record_limit >=1 ) { $record_limit1 = $common_informationRecord['record_limit']; } ?>
<br>

<?php // load records from 'blog'
  list($blogRecords, $blogMetaData) = getRecords(array(
    'tableName'   => 'blog',
    'loadUploads' => true,
    'allowSearch' => true,
	'orderBy' => $orderBy, 
	'limit' => $record_limit1,
	
  ));
  
  ?>
<?php endif ?>
<?php if ($common_informationRecord['blog_post_order'] == "Latest First" ):?>
<br />
<span class="heading_font">Latest Posts At the Top</span><br />
<?php $record_limit = $common_informationRecord['record_limit'] ?>
<?php if (@!$record_limit ) { $record_limit1 = ""; } ?>
<?php if (@$record_limit >=1 ) { $record_limit1 = $common_informationRecord['record_limit']; } ?>

<?php // load records from 'blog'
  list($blogRecords, $blogMetaData) = getRecords(array(
    'tableName'   => 'blog',
    'loadUploads' => true,
    'allowSearch' => false,
	'orderBy' => "date DESC", 
	'limit' => $record_limit1,
	
  ));
  
  ?>
<?php endif ?>
<?php if ($common_informationRecord['blog_post_order'] == "Earliest First" ):?>
<br />
<span class="heading_font">Earliest Posts At the Top</span><br />
<?php $record_limit = $common_informationRecord['record_limit'] ?>
<?php if (@!$record_limit ) { $record_limit1 = ""; } ?>
<?php if (@$record_limit >=1 ) { $record_limit1 = $common_informationRecord['record_limit']; } ?>

<?php // load records from 'blog'
  list($blogRecords, $blogMetaData) = getRecords(array(
    'tableName'   => 'blog',
    'loadUploads' => true,
    'allowSearch' => false,
	'orderBy' => "date", 
	'limit' => $record_limit1,

  ));
  
  ?>
<?php endif ?>
<table width="50%" border="0" align="center" cellpadding="10">
  <tr>
    <td width="75%" align="left" valign="top"><table width="100%" border="0" align="left" cellpadding="2">
        <?php foreach ($blogRecords as $record): ?>
        <tr>
          <td align="left" ><hr />
            <span class="text_font_bold"><?php echo date("D, M jS, Y ", strtotime($record['date'])) ?><br />
            <?php echo strtoupper($record['title']) ?></span><br />
            <div class=" pad" style="float:left">
              <div style="float:none">
                <?php foreach ($record['image'] as $upload): ?>
                <a target="_blank" href="<?php echo $upload['urlPath'] ?>"> <img src="<?php echo $upload['thumbUrlPath2'] ?>" width="<?php echo $upload['thumbWidth2'] ?>" height="<?php echo $upload['thumbHeight2'] ?>" alt="" /></a>
                <?php endforeach ?>
              </div>
            </div>
            <span class="text_font"><?php echo $record['content'] ?></span></td>
        </tr>
        <?php endforeach ?>
      </table></td>
    <td width="25%" align="left" valign="top"><p><span class="page_title_font"><br />
        Or Select<br />
        An Archive</span><br />
        <?php
// get list of unique months and years with articles
$query = "SELECT DATE_FORMAT(date, '%M %Y') as dateAndYear, YEAR(date) as year, MONTH(date) as month FROM cms_blog GROUP BY dateAndYear ORDER BY date";
$result = mysql_query($query) or die("MySQL Error: ". htmlspecialchars(mysql_error()) . "\n");
while ($record = mysql_fetch_assoc($result)):
?>
        <a href="blog2.php?date_year=<?php echo $record['year'] ?>&date_month=<?php echo $record['month'] ?>&orderBy=<?php echo $orderBy ?>"><?php echo $record['dateAndYear']; ?> </a><br/>
        <?php endwhile ?>
    </td>
  </tr>
</table>
<br />
<br />
<table width="644" border="0" align="center" cellpadding="3">
  <tr>
    <td><div align="left" class="small_text_font">&copy; <?php echo date("Y") ?> Terre Rybovich - All Rights Reserved</div></td>
    <td><div align="center">&nbsp;</div></td>
    <td><div align="center">&nbsp;</div></td>
    <td><div align="right" >
        <?php if ($common_informationRecord['disclaimer']): ?>
        <a class="small_text_font" href="disclaimer2.php">Read This First</a>
        <?php endif ?>
      </div></td>
  </tr>
</table>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span class="tiny_text_font">
<?php showExecuteSeconds() ?>
seconds </span>
</body>
</html>
