Template Blocks

<?php
/**
 * TEMPLATE BLOCKS
 * Copyright (C) 2008 Makis Tracend
 * 
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * http://www.gnu.org/licenses/gpl-2.0.txt
 * 
 * Class: MODx
 * 
*************************************************************************
	MODx Content Management System and PHP Application Framework 
	Managed and maintained by Raymond Irving, Ryan Thrash and the
	MODx community
*************************************************************************
* Known Limitations: 
* - This class only works on MODx setup with MySQL 
* - Only one MODx installation per website is supported 
* - You need to insert the database information to connect to MODx manually
*/
 
 
/* Variables (PLEASE CHANGE AS SUITED) */
$_TEMPLATE_VARS['modx_root'] = '/'; 
$_TEMPLATE_VARS['database_server'] = '';
$_TEMPLATE_VARS['database_name'] = '';
$_TEMPLATE_VARS['database_user'] = '';
$_TEMPLATE_VARS['database_password'] = '';
$_TEMPLATE_VARS['table_prefix'] = '';
 
 
class MODx{
  # Define class varriables
  private $dbhost;
  private $dbuser;
  private $dbpass;
  private $dbname;
  private $prefix;
  private $connection;
  private $settings;
 
  # Call constructor
  function __construct() {
    global $_TEMPLATE_VARS;
 
    $this->dbhost = $_TEMPLATE_VARS['database_server'];
    $this->dbname = $_TEMPLATE_VARS['database_name'];
    $this->dbuser = $_TEMPLATE_VARS['database_user'];
    $this->dbpass = $_TEMPLATE_VARS['database_password'];
    $this->prefix = $_TEMPLATE_VARS['table_prefix'];
 
	$this->openConnection();
  }
 
  function openConnection(){
 
    $this->connection = @mysql_connect($this->dbhost, $this->dbuser, $this->dbpass) or die('Could not connect: ' . mysql_error());
	//Select the database connection for use
	mysql_select_db($this->dbname, $this->connection) or die('could not select database'); 
  }
 
  function getSettings(){
 
	//Run the query and store the results
	$data=mysql_query('SELECT * FROM ' . $this->prefix . 'system_settings')or die('query failed'. mysql_error());
 
	$numrows=mysql_num_rows($data);
 
	if( $numrows>0 ){
	  //Place all of the data into an array
	  for( $i=0; $i<$numrows; $i++ ){
	    $row = mysql_fetch_assoc($data);
	    $returndata[$row['setting_name']]=$row['setting_value'];
	  }
	  //Return the results
      $this->settings = $returndata;
    }
  }
 
  function findPage(){
    global $_TEMPLATE_VARS;
 
	// first parse the URL
	if ( $this->settings['friendly_urls'] ) {
	  // we have user friendly URLs
	  $urlparts = explode('/', $_SERVER['REQUEST_URI']);
	  $file = array_pop( $urlparts );
	  // for the case we are viewing a container of pages we need to go one level in
      if( $file=='' ){ $file = array_pop( $urlparts ); }
 
	  if ( $this->settings['use_alias_path'] ) {
	    $parent_alias = array_pop( $urlparts );
		if( $parent_alias ){
		  // now find the parent's id
	      $parent_data=mysql_query("SELECT id FROM " . $this->prefix . "site_content WHERE alias='" . $parent_alias . "'")or die('query failed'. mysql_error());
	      if( mysql_num_rows($parent_data) ){ $parent_array=mysql_fetch_assoc($parent_data); }
		  $parent_id = $parent_array['id'];
		}
	  }
	  $file_parts = array( $this->settings['friendly_url_prefix'], $this->settings['friendly_url_suffix'] );
	  if ( $this->settings['friendly_alias_urls'] ) {
		$page_alias = ( $file != '' ) ? str_replace( $file_parts, '', $file ) : 'index';
	  } else {
		$page_id = ( $file != '' ) ? str_replace( $file_parts, '', $file ) : '1';
	  }
	} else {
	  // we simple have an id variable in the URL let's parse that...
      import_request_variables("gp", "page_");
	  // a precaution so that the query doesn't return an error
	  if( !$page_id ){ $page_id = '1'; }
	}
 
	// compile the query 
	$query = "SELECT * FROM " . $this->prefix . "site_content WHERE ";
	if($page_alias){ $query .= "alias='" . $page_alias . "'"; }
	if($page_id){ $query .= "id=" . $page_id; }
	if($parent_id){ $query .= " AND parent=" . $parent_id; }
 
	$data=mysql_query( $query )or die('query failed'. mysql_error());
 
	if( mysql_num_rows($data) ){
	  // We only need one record so we won't loop through the $numrows
	  $returndata=mysql_fetch_assoc($data);
	  //Return the results
	  return $returndata;
	}
  }	
}
 
$modx = new MODx();
$modx->getSettings();
$modx_page = $modx->findPage();
 
$_TEMPLATE_VARS['page-title'] = ( $modx_page['longtitle'] ) ? $modx_page['longtitle'] : $modx_page['pagetitle'];
$page['title'] = $_TEMPLATE_VARS['page-title'];
 
unset($modx);
unset($modx_page);
 
?>

<?php
 
$links = array( 'Home' => '/',
                'Features' => '/features.html',
                'Demo' => '/demo.html',
                'Download' => '/download.html',
                'Support' => '/support/',
                'About' => '/about.html'
               );
 
echo '  <ul id="toplinks">';
 
foreach( $links as $key => $value ){
  $selected = ($_SERVER['REQUEST_URI'] == $value) ? ' class="selected"' : '';
  echo '<li><a href="' . $value . '"' . $selected . '><span>' . $key . '</span></a></li>';
}
 
echo '  </ul>';
 
?>

<?php
 
$items = $db->select( '*', $config['Sections'], false, 'id');
if( is_array($items) ){
  $children = array();
  foreach( $items as $k => $v ){
    preg_match('/(.*)\((.*)\)/', $v['position'], $matches);
 
    if($matches[2] == 'x') {
      array_push($children[$matches[1]], $v['id']);
    } else {
      $children[$matches[1]][$matches[2]] = $v['id'];
    }
  }
  $output = createOrder( $items, $children );
}
echo '<div id="topbar">';
echo $output;
echo '</div>';
 
function createOrder( $items, $order, $parent=0, $path='' ){
 
  ksort($order[$parent]); 
 
  $listings .= '<ul>';
 
  $middle = '</span></a>';
  $close = '</li>';
  foreach( $order[$parent] as $k => $v ){
    foreach( $items as $l => $w ){
      // now we can create the listings
      if( $w['id'] == $v ){
        $open = '<li><a href="/'. $path . $w['slug'] .'.html"><span>';
        // check for children in this branch
        if (array_key_exists($w['id'], $order)) {
		  $new_path = $path . $w['slug'] . '/';
	      $children = createOrder( $items, $order, $w['id'], $new_path );
	    } else {
	      $children = '';
	    }
	  $listings .= $open . $w['title'] . $middle .  $children . $close;
      }
    }
  }
  $listings .= '</ul>';
 
  return $listings;
}
 
?>