Skip to content

Instantly share code, notes, and snippets.

@davidimoore

davidimoore/spaghetti

Created April 30, 2015 12:16
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save davidimoore/dc2d8f57e51e719ea52b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save davidimoore/dc2d8f57e51e719ea52b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
spaghetti
<?php
$pn = $_GET['page'];
$page_arr = fetchPageByName($pn);
//echo $page_arr["page_id"];
$meta_title=strip_tags($page_arr['varchar1']);$meta_title_defined="yes";
$meta_description=strip_tags($page_arr['text2']);$meta_description_defined="yes";
$meta_keywords=strip_tags($page_arr['text1']);$meta_keywords_defined="yes";
require_once($_SERVER['DOCUMENT_ROOT'] . '/inc/header.php');
//echo $par['options1'];
//echo $altColor;
?>
<body id="textLink">
<div id="header">
<div class="wrapper">
<?php require_once($_SERVER['DOCUMENT_ROOT'] . '/inc/header-nav.php'); ?>
<div id="infoBox" style="background-color:#<?=$altColor?>">
<?php
if(isset($_GET['parent2']))
{
$urlBase = substr(strtolower($_SERVER['REQUEST_URI']), 0, strrpos($_SERVER['REQUEST_URI'], '/'));
$ppid = $page_arr['parent_page_id'];
$sql = "SELECT * FROM page WHERE (template_id=3 OR template_id=26) AND parent_page_id=$ppid ORDER BY sort_id";
$result = mysql_query($sql);
if(mysql_num_rows($result) <= 1 && $page_arr['image2']->img1 != '')
{
$img = $page_arr['image2']->img3;
?>
<div id="contentPanel" style="background-color:#<?= $par['options1']?>" class="hasImage">
<h1><?= spanfirstletter($page_arr['varchar2']); ?></h1>
<hr class="yh" />
<p><?= brr($page_arr['text3']); ?></p>
</div>
<?
$img = $page_arr['image2']->img1;
echo "<img src='$img' class='mImg' />";
echo "<ul id='navPanel' style='background-color:#".$altColor."'>";
$sql = "SELECT * FROM page WHERE page_id=" . $page_arr['parent_page_id'];
$result = mysql_query($sql);
$parr = mysql_fetch_array($result);
$replace = '/' . makeUrl($page_arr['page_name']) .'.html';
$urlBase = str_replace($replace, '', strtolower($_SERVER['REQUEST_URI']));
$urlBase = substr($_SERVER['REQUEST_URI'], 0, strrpos($_SERVER['REQUEST_URI'], '/'));
$url = $urlBase;
if(isset($_GET['parent2']))$url .= '.html';
echo "<li class='sectHead'><a href='$url'>". spanfirstletter($parr['page_name']) . "</a></li>";
$sql = "SELECT * FROM page WHERE parent_page_id=" . $page_arr['parent_page_id'] . " ORDER BY sort_id";
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
if($num_rows > 10){$fr = 13 - ($num_rows - 11); $lr = 16 - ($num_rows - 11); echo "<style type='text/css'>#navPanel li{font-size:". $fr. "px; line-height: ".$lr."px;}</style>"; }
while($arr = mysql_fetch_array($result))
{
$url = $urlBase . '/' . makeUrl($arr['page_name']) . '.html';
if($arr['page_id'] == $page_arr['page_id']) echo "<li class='selectedB'>" . $arr['page_name'] . "</li>"; else echo "<li><a href='$url'>" . $arr['page_name'] . "</a></li>";
}
echo "</ul>";
}
else
{ //echo '2';
?>
<div id="contentPanel" style="background-color:#<?= $par['options1']?>" class="hasImage">
<h1><?= spanfirstletter($page_arr['varchar2']); ?></h1>
<hr class="yh" />
<p><?= brr($page_arr['text3']); ?></p>
</div>
<?
if( !empty($page_arr['image2']) )
{
$img = $page_arr['image2']->img1;
echo "<img src='$img' class='mImage' />";
}
echo '<ul id="navPanel" style="background-color:#'.$altColor.( !empty($page_arr['image2']) ? ';width:318px !important;"' : '' ).'">';
$replace = '/' . makeUrl($page_arr['page_name']) .'.html';
$replace = str_replace(' ', '%20', $replace);
$replace = str_replace(',', '%2C', $replace);
// $urlBase = str_replace($replace, '', strtolower($_SERVER['REQUEST_URI']));
$parent = ucwords(str_replace('-', ' ', $_GET['parent']));
// $urlBase = str_replace('.html', '', $urlBase);
$urlBase = substr($_SERVER['REQUEST_URI'], 0, strrpos($_SERVER['REQUEST_URI'], '/'));
$sect = "<a href='$urlBase.html'>".spanfirstletter($parent)."</a>";
echo '<li class="sectHead">'.$sect.'</li>';
if($page_arr['template_id'] == 26){ $urlBase = substr(strtolower($_SERVER['REQUEST_URI']), 0, strrpos($_SERVER['REQUEST_URI'], '/')); }
$num_rows = mysql_num_rows($result);
if($num_rows > 10){$fr = 13 - ($num_rows - 11); $lr = 16 - ($num_rows - 11); echo "<style type='text/css'>#navPanel li{font-size: $fr\px; line-height: $lr\px;}</style>"; }
while($arr = mysql_fetch_array($result))
{
$url = $urlBase . '/'. makeUrl($arr['page_name']) . '.html';
if($arr['page_name'] == $page_arr['page_name'])echo "<li class='selectedB'><a href='$url'>" . $arr['page_name'] . "</a></li>"; else echo "<li><a href='$url'>" . $arr['page_name'] . "</a></li>";
}
echo '</ul>';
}
}
else
{ //echo '3';
$img = $page_arr['image2']->img3;
$sql = "SELECT * FROM page WHERE template_id=3 AND parent_page_id=$pid ORDER BY sort_id";
$result = mysql_query($sql);
if(mysql_num_rows($result) < 1 && $page_arr['image2']->img1 != '')
{
?>
<div id="contentPanel" style="background-color:#<?= $par['options1']?>" class="hasImage">
<h1><? if (strtoupper($page_arr['varchar2'])=='UCC') {
echo spanfirstletter('U').spanfirstletter('C').spanfirstletter('C');
}else{
echo spanfirstletter($page_arr['varchar2']);
}
?></h1>
<hr class="yh" />
<p><?= brr($page_arr['text3']) ?></p>
</div>
<? if($page_arr['template_id'] == 8)
{
$img = $page_arr['image1']->img1;
}
else
{
$img = $page_arr['image2']->img1;
}
echo "<img src='$img' class='mImg' />";
echo "<ul id='navPanel' style='background-color:#".$altColor."'>";
$sql = "SELECT * FROM page WHERE page_id=" . $page_arr['parent_page_id'];
$result = mysql_query($sql);
$parr = mysql_fetch_array($result);
$replace = '/' . makeUrl($page_arr['page_name']) .'.html';
$replace = str_replace(' ', '%20', $replace);
$urlBase = str_replace($replace, '', strtolower($_SERVER['REQUEST_URI']));
$url = $urlBase;
echo "<li class='sectHead'><a href='$url'>". spanfirstletter($parr['page_name']) . "</a></li>";
$sql = "SELECT * FROM page WHERE parent_page_id=" . $page_arr['parent_page_id'] . " ORDER BY sort_id";
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
if($num_rows > 10){$fr = 13 - ($num_rows - 11); $lr = 16 - ($num_rows - 11); echo "<style type='text/css'>#navPanel li{font-size:". $fr. "px; line-height: ".$lr."px;}</style>"; }
while($arr = mysql_fetch_array($result))
{
$url = $urlBase . '/' . makeUrl($arr['page_name']) . '.html';
if($arr['page_id'] == $page_arr['page_id']) echo "<li class='selectedB'>" . $arr['page_name'] . "</li>"; else echo "<li><a href='$url'>" . $arr['page_name'] . "</a></li>";
}
echo "</ul>";
}
else
{ //echo '4';
?>
<div id="contentPanel" style="background-color:#<?= $par['options1']?>" class="hasImage">
<h1><?= spanfirstletter($page_arr['varchar2']); ?></h1>
<hr class="yh" />
<p><?= brr($page_arr['text3']) ?></p>
</div>
<? if($page_arr['template_id'] == 8)
{
$img = $page_arr['image1']->img1;
echo "<img src='$img' class='mImage' />";
}
else
{
$img = $page_arr['image2']->img1;
echo "<img src='$img' class='mImage' />";
}
if( !empty($page_arr['image2']) )
{
$img = $page_arr['image2']->img1;
echo "<img src='$img' class='mImage' />";
}
echo '<ul id="navPanel" style="background-color:#'.$altColor.( !empty($page_arr['image2']) ? ';width:320px !important;"' : '' ).'">';
// $urlBase = str_replace('.html', '/', strtolower($_SERVER['REQUEST_URI']));
// echo '<li class="selected">'.spanfirstletter($page_arr['varchar2']).'</li>';
$sql = "SELECT * FROM page WHERE page_id=" . $page_arr['parent_page_id'];
$result = mysql_query($sql);
$parr = mysql_fetch_array($result);
$replace = '/' . makeUrl($page_arr['page_name']) .'.html';
$urlBase = str_replace($replace, '', strtolower($_SERVER['REQUEST_URI']));
$url = $urlBase;
echo "<li class='sectHead'><a href='$url'>". spanfirstletter($parr['page_name']) . "</a></li>";
$sql = "SELECT * FROM page WHERE parent_page_id=" . $page_arr['parent_page_id'] . " ORDER BY sort_id";
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
if($num_rows > 10){$fr = 13 - ($num_rows - 11); $lr = 16 - ($num_rows - 11); echo "<style type='text/css'>#navPanel li{font-size:". $fr. "px; line-height: ".$lr."px;}</style>"; }
while($arr = mysql_fetch_array($result))
{
$url = $urlBase . '/' . makeUrl($arr['page_name']) . '.html';
if($arr['page_id'] == $page_arr['page_id']) echo "<li class='selectedB'>" . $arr['page_name'] . "</li>"; else echo "<li><a href='$url'>" . $arr['page_name'] . "</a></li>";
// $url = $urlBase ."/". makeUrl($arr['page_name']) . '.html';
// echo "<li><a href='$url'>" . $arr['page_name'] . "</a></li>";
}
echo '</ul>';
}
}
?>
</div>
<?php print breadcrumbs(); ?>
</div>
</div>
<div id="container">
<div class="wrapperA">
<?php
if($page_arr['template_id'] == 8)
{
require_once($_SERVER['DOCUMENT_ROOT'] . '/inc/body-sidecol.php');
}
?>
<?
$pid = $page_arr['page_id'];
$sql = "SELECT * FROM page WHERE template_id=17 AND checklist1 LIKE '%$pid%' ORDER BY sort_id";
$result = mysql_query($sql);
$i = 0;
$scripts = '';
$new_id = -1;
$num_rows = mysql_num_rows($result);
//if(mysql_num_rows($result) < 3) echo '<ul id="gallery" class="gHorz wtf">'; else echo '<ul id="gallery" class="gHorz">';
if ($num_rows>0){
echo '<ul id="gallery" class="gHorz what-we-believe">';
while($arr = mysql_fetch_array($result))
{
/*if($i == 3 && mysql_num_rows($result) >= 4)
{
echo '</ul><ul id="gallery" class="gHorz nf">';
}*/
if($arr['image2'] > 0) $img = new img($arr['image2']); else $img = new img($arr['image1']);
$img = $img->img1;
$url = makeUrl($arr['page_name']) . '.html';
$sql = "SELECT * FROM page WHERE parent_page_id=" . $arr['page_id'] . " AND template_id=33 ORDER BY sort_id";
$resultB = mysql_query($sql);
$arrB = mysql_fetch_array($resultB);
$img = new img($arrB['image1']);
$img2 = $img->img2;
$img = $img->img1;
$id = makeurl($arr['page_name']);
if(strlen($id) > 20)
{
$id = substr($id, 0, 20);
}
$id = $arr['page_id'] . '-' . $id;
$title = $arrB['text1'];
if($title == '')$title = $arrB['page_name'];
$date = strpos($arr['date1'], '00-00') == false ? $arr['date1'] : '';
//if($arr['boolean1'] == 1) $date = '';
echo "<li rel='gallery' id='g$id'><a href='$img2' title='$title'><img src='$img' /></a><h3>" . $arr['page_name'] . "</h3><span>". $date ."</span>";
if($new_id != $id)
{
$new_id = $id;
$scripts .= "<script type='text/javascript'>$(document).ready(function(){
$('li[id=\"g$id\"] a').lightBox();
});</script>";
}
$resultB = mysql_query("SELECT * FROM page WHERE template_id=33 AND parent_page_id=" . $arr['page_id']. " ORDER BY sort_id");
$html = '';
$arrB = mysql_fetch_array($resultB);
while($arrB = mysql_fetch_array($resultB))
{
$img = new img($arrB['image1']);
$img = $img->img2;
$title = $arrB['text1'];
if($title == '')$title = $arrB['page_name'];
$html .= "<a class='galleryImage' rel='gallery$i' href='$img' title='$title' /><img src='$img' /></a>";
}
echo $html;
echo "</li>";
$i++;
//if($i % 4 == 0) echo '<li class="hr">&nbsp;</li>';
}
?>
</ul>
<?php
}
if(!empty($page_arr['image1'])&& $page_arr["template_id"]!=8)
{
$img = $page_arr['image1']->img1;
echo "<img src='$img' class='fr' />";
}
?>
<?= $page_arr['text4'] ?>
</div>
</div>
<?php require_once($_SERVER['DOCUMENT_ROOT'] . '/inc/footer.php'); echo $scripts; ?>
<!--! end of #container -->
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment