$_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 = ""; break; case "C": //echo "not a unit account"; $res = "not a unit account"; break; } }else if($_SESSION['ctype'] == "US" || $_SESSION['ctype'] == "UK" || $_SESSION['ctype'] == "BOTH" || $_SESSION['ctype'] == "TRIAL" || $_SESSION['ctype'] == "RG" ){ //$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 = ""; //$img_res = ""; //$img_res = ""; } /* END OF MODULE */ ?>