<?php require_once('file:///Macintosh HD/Users/emily/Sites/padmor/Connections/paddysite.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_rsPosters = 1;
$pageNum_rsPosters = 0;
if (isset($_GET['pageNum_rsPosters'])) {
  $pageNum_rsPosters = $_GET['pageNum_rsPosters'];
}
$startRow_rsPosters = $pageNum_rsPosters * $maxRows_rsPosters;

$colname_rsPosters = "-1";
if (isset($_GET['id_ill'])) {
  $colname_rsPosters = (get_magic_quotes_gpc()) ? $_GET['id_ill'] : addslashes($_GET['id_ill']);
}
$colname3_rsPosters = "-1";
if (isset($_GET['id_shop'])) {
  $colname3_rsPosters = (get_magic_quotes_gpc()) ? $_GET['id_shop'] : addslashes($_GET['id_shop']);
}
$colname2_rsPosters = "-1";
if (isset($_GET['id_art'])) {
  $colname2_rsPosters = (get_magic_quotes_gpc()) ? $_GET['id_art'] : addslashes($_GET['id_art']);
}
mysql_select_db($database_paddysite, $paddysite);
$query_rsPosters = sprintf("SELECT * FROM pmo_shop WHERE idill_shop = %s OR idfa_shop = %s OR id_shop = %s ORDER BY date_shop DESC", GetSQLValueString($colname_rsPosters, "int"),GetSQLValueString($colname2_rsPosters, "int"),GetSQLValueString($colname3_rsPosters, "int"));
$query_limit_rsPosters = sprintf("%s LIMIT %d, %d", $query_rsPosters, $startRow_rsPosters, $maxRows_rsPosters);
$rsPosters = mysql_query($query_limit_rsPosters, $paddysite) or die(mysql_error());
$row_rsPosters = mysql_fetch_assoc($rsPosters);

if (isset($_GET['totalRows_rsPosters'])) {
  $totalRows_rsPosters = $_GET['totalRows_rsPosters'];
} else {
  $all_rsPosters = mysql_query($query_rsPosters);
  $totalRows_rsPosters = mysql_num_rows($all_rsPosters);
}
$totalPages_rsPosters = ceil($totalRows_rsPosters/$maxRows_rsPosters)-1;

$maxRows_rsdetail = 1;
$pageNum_rsdetail = 0;
if (isset($_GET['pageNum_rsdetail'])) {
  $pageNum_rsdetail = $_GET['pageNum_rsdetail'];
}
$startRow_rsdetail = $pageNum_rsdetail * $maxRows_rsdetail;

mysql_select_db($database_paddysite, $paddysite);
$query_rsdetail = "SELECT * FROM pmo_fineart WHERE kind_art= 'FINISHED' OR kind_art='INPROGRESS'";
$query_limit_rsdetail = sprintf("%s LIMIT %d, %d", $query_rsdetail, $startRow_rsdetail, $maxRows_rsdetail);
$rsdetail = mysql_query($query_limit_rsdetail, $paddysite) or die(mysql_error());
$row_rsdetail = mysql_fetch_assoc($rsdetail);

if (isset($_GET['totalRows_rsdetail'])) {
  $totalRows_rsdetail = $_GET['totalRows_rsdetail'];
} else {
  $all_rsdetail = mysql_query($query_rsdetail);
  $totalRows_rsdetail = mysql_num_rows($all_rsdetail);
}
$totalPages_rsdetail = ceil($totalRows_rsdetail/$maxRows_rsdetail)-1;

$queryString_rsdetail = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_rsdetail") == false && 
        stristr($param, "totalRows_rsdetail") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_rsdetail = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_rsdetail = sprintf("&totalRows_rsdetail=%d%s", $totalRows_rsdetail, $queryString_rsdetail);

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
?><!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><title>Padraic O'Reilly Illustration</title>
<META name="description" content="Work of editorial illustrator and artist Padraic O'Reilly" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="keywords" content="big papi poster, red sox poster, padraic o'reilly, padraic oreilly, padraic o'reilly art, padraic o'reilly playwright, padraic o'reilly illustration, padraic o'reilly posters, padraic o'reilly advocate, padraic o'reilly man gone down, padraic o'reilly book cover, padraic, o'reilly art, o'reilly illustration, padraic o'reilly red sox, padraic o'reilly boston, padraic boston, padraic o'reilly harvard" /><title>Padraic O'Reilly Illustration</title>
<style type="text/css">
<!--
body,td,th {
	font-family: Times New Roman, Times, serif;
	font-size: 12px;
	color: #999999;
}
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	background-color: #F0F0F0;
}
-->
</style>
<link href="file:///Macintosh HD/Users/emily/Sites/padmor/padraicoreilly/files/illustration/pad.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
a:link {
	color: #690000;
}
a:visited {
	color: #690000;
}
a:hover {
	color: #690000;
}
a:active {
	color: #690000;
}
-->
</style>
<script type="text/JavaScript">
<!--


function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<link href="file:///Macintosh HD/Users/emily/Sites/padmor/pages/pages.css" rel="stylesheet" type="text/css" />
<link href="files/illustration/pad.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style7 {font-size: 18px}
-->
</style>
</head>

<body onload="MM_preloadImages('../../images/illustrations/sketches/<?php echo $row_rsSketches['idcli_ske']; ?>/<?php echo $row_rsSketches['image_ske']; ?>')">
<table border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td></td>
  </tr>
  <tr>
    <td height="500" align="center" valign="middle" nowrap="nowrap"><p class="newtext style7">padraic o'reilly</p>
    <p><a href="files/index.php?page=detail.php?kind=EDITORIAL">enter</a> </p></td>
  </tr>
  <tr>
    <td height="30" align="center" valign="middle">&nbsp;</td>
  </tr>
</table>
</body>
</html>
<?php
mysql_free_result($rsPosters);

mysql_free_result($rsdetail);
?>