#####################################################
/*
* File Name: pigot_imageviewer.php
* File Created: 26-03-2008
* @Created by Rudolph
* @Project FamilyRelatives.com
* Description: used to show image and tracking image views for pigots
* @copyright Synapse Communications Private Limited.
*
*/
#####################################################
$pageName = "search";
include_once("../includes/inc_header.php");
include_once('../includes/session.php');
require_once(SITE_ROOT_PATH.'/search/data_search_counts.php');
include_once('cdn.php');
/*Code to get the next and previous starts*/
// present ID
//$id = $_REQUEST['id'];
if($_REQUEST['te']!='')
$where_str = " WHERE ( fld_title LIKE '%$_REQUEST[te]%'
OR fld_body LIKE '%$_REQUEST[te]%' )
";
if($_REQUEST['co'] != '' && $where_str!='')
$where_str .= " AND fld_county = '$_REQUEST[co]'";
elseif($_REQUEST['co'] != '')
$where_str .= " WHERE fld_county = '$_REQUEST[co]'";
if($_REQUEST['id'])
$id_str = " AND fld_id < $_REQUEST[id]";
if($_REQUEST['id'])
$id2_str = " AND fld_id > $_REQUEST[id]";
$prev_str = "SELECT fld_id, fld_filename FROM tbl_pigots $where_str $id_str ORDER BY fld_title DESC LIMIT 1";
$res = $db2->query($prev_str);
// CHECK FOR ERRORS.
if ((new PEAR)->isError($res)) {
die($res->getMessage());
}
$rowp = $res->fetchrow();
$prev_id = $rowp['fld_id'];
$next_str = "SELECT fld_id, fld_filename FROM tbl_pigots $where_str $id2_str ORDER BY fld_title ASC LIMIT 1";
$res = $db2->query($next_str);
// CHECK FOR ERRORS.
if ((new PEAR)->isError($res)) {
die($res->getMessage());
}
$rown = $res->fetchrow();
$next_id = $rown['fld_id'];
/////////////////////////////
$next_str23 = "SELECT fld_id, fld_filename, fld_body FROM tbl_pigots WHERE fld_id = '".$_REQUEST[id]."'";
$res23 = $db2->query($next_str23);
// CHECK FOR ERRORS.
if ((new PEAR)->isError($res23)) {
die($res23->getMessage());
}
$rown23 = $res23->fetchrow();
// function for the case senstive position
function strpos_case_insensitive ($prohledavany_retezec, $hledany_retezec, $hledat_od_pozice=0)
{
$prohledavany_retezec = substr($prohledavany_retezec, $hledat_od_pozice, strlen($prohledavany_retezec) ); // o��zne �et�zec
$temp = stristr($prohledavany_retezec, $hledany_retezec); // do tempu se ulo�� zbytek �et�zce od m�sta, kde byl nalezen hledan� �et�zec
$pozice = strlen($prohledavany_retezec) - strlen($temp); // pak u� jen sta�� ode��st od celkov� d�lky �et�zce d�lku �et�zce od m�sta, kde byl nalezen hledan� �et�zec
If ($pozice == strlen ($prohledavany_retezec) ) // pokud bude pozice odkazovat na konec �et�zce znamen� to, �e hledan� �et�zec nebyl nalezen
$pozice = FALSE;
else
$pozice += $hledat_od_pozice; // mus�m p�i��st to, co jsem od��znul
return $pozice;
}
$pos = strpos_case_insensitive ($rown23["fld_body"], "John");
//strlen($_REQUEST["te"]);
/////////////////////////////
/*Code to get the next and previous starts*/
/*
NEW MODULE FOR TRACKING IMAGES AND SEARCH VIEWS FOR UNIT SUBSCRIBING
*/
if ($_SESSION['ctype'] == "UNIT"){
require_once('../includes/classes/class.tracking.unit.php');
$_unitTracking = new _familyUnitTracking($db,$pa_ge);
if($_SERVER['QUERY_STRING'])
switch($_unitTracking->_trackImageView($_SESSION[cid],$_SERVER['QUERY_STRING'],$db)) {
case "A":
$loc = "../post_nounits.php";
echo "";
exit;
break;
case "B":
//$loc = "../$type/$imageId.djvu";
if(strpos($imageId,".djvu"))
$loc = CDN_SITE_URL."$type/$imageId";
else
$loc = CDN_SITE_URL."$type/$imageId.djvu";
$loc .= "?".$token;
$img_res = "