isMobile() || $detect->isTablet() || $detect->version('iPad')) { ?> 0) { $names=split(",",$flag); $aname=strip_and_quote($_GET['pubid']); $sql="select fldPublisherRetailerId from TBL_Publisher_Retailer_Master where fldName='".$aname."'"; $rs=$db->ReturnRs($sql); $row=mysql_fetch_row($rs); if($row[0]!='') $_GET['pubid']=$row[0]; } } $publisherid=$_GET['pubid']; if($publisherid=="") $publisherid=$_POST['id']; $subcatid=$_GET['subcatid']; if($subcatid=="") $subcatid=$_POST['subcatid']; $catid=$_GET['catid']; if($catid=="") $catid=$_POST['catid']; $sql="select * from TBL_Publisher_Retailer_Master where fldPublisherRetailerId=".$publisherid; $rs=$db->ReturnRs($sql); $row_topic=mysql_fetch_object($rs); $pubflag=$row_topic->fldType; $pubname=$row_topic->fldName; $puburl=$row_topic->fldCompanyURL; $dlink=$row_topic->fldCompanyUrlText; $title_dlink=""; if(strlen($dlink) > 23) { $title_dlink=$dlink; $dlink=substr($dlink,0,20)."..."; } $aimage=$row_topic->fldlogo; $reviews_offered=$row_topic->fldReviewsOffered; $summary_offered=$row_topic->fldSummaryOffered; $catalog_flag=$row_topic->fldProductCatalogAvailability; $info_link=$row_topic->flgInfoLink; $newsletter=$row_topic->fldNewsletter; $newsletter_link=$row_topic->fldNewsletterInfoLink; $totalproduct=$row_topic->fldTotalProducts; $unabridge=$row_topic->fldUnabridged; $total_unabridge=$row_topic->fldTotalUnabridged; $unabridge_link=$row_topic->fldUnabridgedLink; $advsearchflag=$row_topic->fldAdvsearchFlag; $advsearchtext=$row_topic->fldAdvancedSearchText; $advsearch=$row_topic->fldAdvancedSearchText; $adv_link=$row_topic->fldAdvancedSearchLink; $category=$row_topic->fldCategory; $category_link=$row_topic->fldCategoryLink; $author_link=$row_topic->fldAuthorsLink; $narrator_link=$row_topic->fldNarratorsLink; $audio_sample=$row_topic->fldAudioSamples; $audio_link=$row_topic->fldAudioLink; $video_sample=$row_topic->fldVideoSamples; $video_link=$row_topic->fldVideoLink; $catlist=$row_topic->fldCatlist; $sale_section=$row_topic->fldSaleSection; $sale_link=$row_topic->fldSaleLink; $shortdesc=(stripslashes($row_topic->fldSummaries)); $longdesc=(stripslashes($row_topic->fldLongDescription)); if($row_topic->fldKeywords!='') { $meta_content_arr=explode("\n",$row_topic->fldKeywords); for($i=0;$ifldMetaDesc); $title=$row_topic->fldTitleTag; if($title=="") $title=$pubname; $pub_href=$serverpath.'/Resources/Publishers-and-Retailers/'.add_and_hyphen($pubname).'/'.$publisherid; //contact details $contact_details=""; $txtaddr1=$row_topic->fldAddress1; $txtaddr2=$row_topic->fldAddress2; $txtcity=$row_topic->fldCity; $txtcountryid=$row_topic->fldCountryId; $txtstateid=$row_topic->fldStateId; $txtstate=$row_topic->fldState; $txtzip=$row_topic->fldZipCode; $txtpno=$row_topic->fldPhone; $txtmno=$row_topic->fldTollFreeNo; $txtfno=$row_topic->fldFax; $txtemail=$row_topic->fldEmail; //$contact_details1="Contact Information:

"; $contact_details1.="
"; $contact_details1.="".$pubname."
"; if($txtaddr1!="") $contact_details.="".$txtaddr1."
"; if($txtaddr2!="") $contact_details.="".$txtaddr2."
"; if($txtcountryid!="" && $txtcountryid!=226 && $txtcountryid!=0) { $sql_country="select fldCountryName from TBL_Country_Master where fldCountryId=".$txtcountryid; $rs_country=$db->ReturnRs($sql_country); $row_country=mysql_fetch_object($rs_country); $country=$row_country->fldCountryName; $country=str_to_standard($country); } if($txtstateid!="" && $txtstateid!=0) { $sql_fetch_state="select fldStateName from TBL_State_Master where fldStateId=".$txtstateid; $rs_fetch_state=$db->ReturnRs($sql_fetch_state); $row_fetch_state=mysql_fetch_object($rs_fetch_state); $state=$row_fetch_state-> fldStateName ; } else $state=$txtstate; if($txtcity!="") $contact_details.="".$txtcity.", "; if($state!="") $contact_details.="".$state." "; if($country!="") $contact_details.="".$country.", "; if($txtzip!="") $contact_details.="".$txtzip."
"; if($txtpno!="") $contact_details.="Phone: ".$txtpno."
"; if($txtmno!="") $contact_details.="Toll Free: ".$txtmno."
"; if($txtfno!="") $contact_details.="Fax: ".$txtfno."
"; if($txtemail!="") $contact_details.="E-Mail: ".$txtemail."
"; $contact_details2="
"; if($contact_details!="") $c_info=$contact_details1.$contact_details.$contact_details2; //Rental details in right box $sql="select fldRentalLink,fldPeriod from TBL_PublisherRetailer_AvailableFormat_Master PRAM,TBL_Format_Master FM where FM.fldFormatId=PRAM.fldFormatId and fldRetailerPublisherId=".$publisherid." and fldRental=1 limit 0,1 "; $rs=$db->ReturnRs($sql); $cnt=mysql_num_rows($rs); if($cnt>0) { $row=mysql_fetch_object($rs); $days=" Day"; if($row->fldPeriod>1) $days=" Days"; $href=$row->fldRentalLink; if($href=='') $onclick=''; else { if(substr($href,0,7)!="http://") $href="http://".$href; $onclick=" Onclick=\"javascript:ext_popup('$href')\""; } if($row->fldPeriod!='') $period=" (".stripslashes($row->fldPeriod).")"; else $period=""; $rental="Yes".$period." (?) "; } if($pubflag==0) $atype="Publisher"; else if($pubflag==1) $atype="Retailer"; else $atype="Publisher & Retailer"; if(substr($puburl,0,7)!="http://" && $puburl!="") $puburl="http://".$puburl; if($puburl!='') { $publisher_url=" "; $publisher_url1=" ".$dlink.""; } else $publisher_url="".$dlink.""; //Formats Details Audio $format_details=get_format_details($db,$publisherid); if($unabridge_link=='') { $onclick=''; $unabridge_info=get_percentage($unabridge).stripslashes(get_total_no($total_unabridge)); } else { if(substr($unabridge_link,0,7)!="http://") $unabridge_link="http://".$unabridge_link; $onclick=" Onclick=\"javascript:ext_popup('$unabridge_link')\""; $unabridge_info="".get_percentage($unabridge).stripslashes(get_total_no($total_unabridge)).""; } if($unabridge!=0 && $unabridge!='') $format_details.="
  • Unabridged: ".$unabridge_info."
  • "; $format_details.=""; if($format_details=="") $format_details=""; //Web site Features if(substr($sale_link,0,7)!="http://" && $sale_link!='') $sale_link="http://".$sale_link; $onclick_sale=" Onclick=\"javascript:ext_popup('$sale_link')\""; if($sale_link!="") $sale_section=" ".$sale_section." "; if(substr($audio_link,0,7)!="http://" && $audio_link!='') $audio_link="http://".$audio_link; $onclick_audio=" Onclick=\"javascript:ext_popup('$audio_link')\""; if($audio_link!="") $audio_sample=" Some (Quicktime) "; if(substr($video_link,0,7)!="http://" && $video_link!='') $video_link="http://".$video_link; $onclick_video=" Onclick=\"javascript:ext_popup('$video_link')\""; if($video_link!="") $video_sample=" ".$video_sample." "; if(substr($info_link,0,7)!="http://" && $info_link!='') $info_link="http://".$info_link; $onclick_catalog=" Onclick=\"javascript:ext_popup('$info_link')\""; if($info_link!="") $catalog_info="Yes "; else { if($catalog_flag==1) $catalog_info="Yes"; else $catalog_info="No"; } if(substr($newsletter_link,0,7)!="http://" && $newsletter_link!='') $newsletter_link="http://".$newsletter_link; $onclick_news=" Onclick=\"javascript:ext_popup('$newsletter_link')\""; if($newsletter_link!="") $news_info="Yes "; else $news_info="Yes "; if(substr($adv_link,0,7)!="http://" && $adv_link!='') $adv_link="http://".$adv_link; $onclick_adv=" Onclick=\"javascript:ext_popup('$adv_link')\""; if($adv_link!="") { //echo $advsearchflag; if($advsearchflag==1) $advsearchtext1="Yes "; } if($advsearchtext!='') $advsearchtext1.=" (?)"; $advsearchtext=$advsearchtext1; $author_link1=$author_link; if(substr($author_link1,0,7)!="http://" && $author_link1!='') $author_link1="http://".$author_link1; $onclick_author=" Onclick=\"javascript:ext_popup('$author_link1')\""; if($author_link!="") $author_link="Featured Authors Page "; $narrator_link1=$narrator_link; if(substr($narrator_link1,0,7)!="http://" && $narrator_link1!='') $narrator_link1="http://".$narrator_link1; $onclick_narrator=" Onclick=\"javascript:ext_popup('$narrator_link1')\""; if($narrator_link!="") $narrator_link="Featured Narrators Page "; if(substr($category_link,0,7)!="http://" && $category_link!='') $category_link="http://".$category_link; $onclick_category=" Onclick=\"javascript:ext_popup('$category_link')\""; if($category_link!="") $category1="".$category.""; else $category1=$category; $website_feature=""; //web site end //search criteria if($catid!="") { $subcatslist=get_catsubcatlist($db,$catid); $sql_subcat="select distinct fldProductId from TBL_Product_Category_Detail where fldCatSubCatId in(".$subcatslist.") and fldcatSubCatId<>0 and fldCatSubCatFlag=1"; $rs_subcat=$db->ReturnRs($sql_subcat); while($row_sub=mysql_fetch_array($rs_subcat)) { $subid_list.=$row_sub['fldProductId'].","; } $subidlist=substr($subid_list,0,-1); //$sql="select distinct fldProductId from TBL_Product_Category_Detail where fldCatSubCatId in(".$subcatslist.",".$catid.") and fldcatSubCatId<>0"; $sql="select distinct fldProductId from TBL_Product_Category_Detail where fldCatSubCatId in(".$catid.") and fldCatSubCatFlag=0 and fldcatSubCatId<>0"; //echo $sql; $rs_all_product=$db->ReturnRs($sql); while($row_rs2=mysql_fetch_array($rs_all_product)) { $cidlist.=$row_rs2['fldProductId'].","; } $cidlist=substr($cidlist,0,-1); if($subidlist!="" && $cidlist!="") $id_list=$subidlist.",".$cidlist; if($subidlist!="" && $cidlist=="") $id_list=$subidlist; if($subidlist=="" && $cidlist!="") $id_list=$cidlist; if($id_list=="") $id_list=0; /*while($row_rs2=mysql_fetch_array($rs_all_product)) { $id_list1[$i++]=$row_rs2[0]; } if($i>0) $strlist=implode(",",$id_list1); else $strlist=$id_list1[0]; $id_list=$strlist; if($id_list=="") $id_list=0; */ } if($subcatid!="") { $sql="select distinct fldProductId from TBL_Product_Category_Detail where fldCatSubCatId in(".$subcatid.") and fldcatSubCatId<>0 and fldCatSubCatFlag=1"; $rs=$db->ReturnRs($sql);$i=0; while($row=mysql_fetch_array($rs)) { if($id_list!='') $id_list.=",".$row[0]; else $id_list=$row[0];$i++; } if($id_list=="") $id_list=0; } if($_POST['hidFormatFlag']==1) { // print_r($_POST); $chkOnlineAudio=""; $chkOnlineVideo=""; $chkAudioDownload=""; $chkVideoDownload=""; $list_a_v=explode(":",$_POST['hidFormatList']); $list_a=$list_a_v[0]; if($list_a==17) $chkAudioDownload="checked"; $list_v=$list_a_v[1]; $arr_a=explode(",",$list_a); $arr_v=explode(",",$list_v); if(in_array("102",$arr_a) || in_array("103",$arr_v)|| in_array("101",$arr_a)) { $listA21=$listA22=$listV2=$whereAV2=""; if(in_array("102",$arr_a)) { $chkOnlineAudio="checked"; $sqlA22="select fldFormatId from TBL_Format_Master where fldFormatTypeId=0 and fldFormatName='Audio CD'"; $rsA22=$db->ReturnRs($sqlA22); $rowA22=mysql_fetch_object($rsA22); $listA22=$rowA22->fldFormatId; $whereAV2="and TBL_Format_Master.fldFormatId='$listA22'"; } if(in_array("103",$arr_v)) { $chkVideoDownload="checked"; $sqlVD2="select fldFormatId from TBL_Format_Master where fldFormatTypeId=0 and fldFormatName='Audio Cassette'"; //print "
    sqlVD2 :: $sqlVD2 "; $rsVD2=$db->ReturnRs($sqlVD2); $rowVD2=mysql_fetch_object($rsVD2); $listVD2=$rowVD2->fldFormatId; $whereAV2="and TBL_Format_Master.fldFormatId='$listVD2'"; } if(in_array("101",$arr_a)) { $chkOnlineVideo="checked"; $sqlV2="select fldFormatId from TBL_Format_Master where fldFormatTypeId=0 and fldFormatName='MP3 CD'"; $rsV2=$db->ReturnRs($sqlV2); $rowV2=mysql_fetch_object($rsV2); $listV2=$rowV2->fldFormatId; $whereAV2="and TBL_Format_Master.fldFormatId='$listV2'"; } // 10/23/2008 listA21 listA22 listV2 listVD2 $sel_format_list="-1"; if(!empty($listA21)) $sel_format_list.=",".$listA21; if(!empty($listA22)) $sel_format_list.=",".$listA22; if(!empty($listV2)) $sel_format_list.=",".$listV2; if(!empty($listVD2)) $sel_format_list.=",".$listVD2; if($sel_format_list!="-1") $whereAV2="and (TBL_Format_Master.fldFormatId IN($sel_format_list))"; //print " whereAV2 :: $whereAV2"; //$sqlAV2="select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage from TBL_Product_Master,TBL_Product_Format_Detail,TBL_Format_Master where TBL_Product_Master.fldProductId=TBL_Product_Format_Detail.fldProductId and TBL_Product_Format_Detail.fldFormatId=TBL_Format_Master.fldFormatId and TBL_Product_Master.fldFreeFlag!=1 and fldLearnSectionFlag IN('0','2') and TBL_Product_Master.fldKidsSectionFlag!=1 $whereAV2"; $sqlAV2="select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage from TBL_Product_Master,TBL_Product_Format_Detail,TBL_Format_Master where TBL_Product_Master.fldProductId=TBL_Product_Format_Detail.fldProductId and TBL_Product_Format_Detail.fldFormatId=TBL_Format_Master.fldFormatId and fldLearnSectionFlag IN('0','2') and TBL_Product_Master.fldKidsSectionFlag!=1 $whereAV2"; $rsAV2=$db->ReturnRs($sqlAV2); $list_pro_ids_AV2=""; while($rowAV2=mysql_fetch_object($rsAV2)) { if($list_pro_ids_AV2!="") $list_pro_ids_AV2 .=",".$rowAV2->fldProductId; else $list_pro_ids_AV2 =$rowAV2->fldProductId; } }//end of second if // covered format 2 if( ($list_a!="") || ($list_v!="") ) { $list_pro_ids = fnaudiovideo($db,$list_a,$list_v); if($list_pro_ids_AV2!="") { $list_pro_ids.=$list_pro_ids_AV2; } if($list_pro_ids=="") $list_pro_ids=0; $where_con =" and PM.fldProductId in (".$list_pro_ids.") "; } else { //$avlist=makelist($db); //$list_a_v=explode(":",$avlist); // $list_a=$list_a_v[0]; // $list_v=$list_a_v[1]; if( ($list_a!="") || ($list_v!="") ) { $list_pro_ids = fnaudiovideo($db,$list_a,$list_v); if($list_pro_ids=="") $list_pro_ids=0; $where_con =" and PM.fldProductId in (".$list_pro_ids.") "; } $where_con .=" and ( fldAbridgedUnabridgedFlag =1 or fldAbridgedUnabridgedFlag =0 ) "; } } else { // $chkOnlineAudio="checked"; // $chkOnlineVideo="checked"; // $chkAudioDownload="checked"; // $chkVideoDownload="checked"; } /* if($_POST['hidFormatList']!="") { $list_a_v=explode(":",$_POST['hidFormatList']); $list_a=$list_a_v[0]; $list_v=$list_a_v[1]; if( ($list_a!="") || ($list_v!="") ) { $list_pro_ids = fnaudiovideo($db,$list_a,$list_v); if($list_pro_ids=="") $list_pro_ids=0; $where_con =" and PM.fldProductId in (".$list_pro_ids.") "; } if(($_POST['chkAbridged']!="") && ($_POST['chkUnabridged']=="")) { $where_con .=" and fldAbridgedUnabridgedFlag =0 "; } if(($_POST['chkAbridged']=="") && ($_POST['chkUnabridged']!="")) { $where_con.=" and fldAbridgedUnabridgedFlag =1 "; } if(($_POST['chkAbridged']!="") && ($_POST['chkUnabridged']!="")) { $where_con .=" and ( fldAbridgedUnabridgedFlag =1 or fldAbridgedUnabridgedFlag =0 ) "; } } else { $avlist=makelist($db); $list_a_v=explode(":",$avlist); $list_a=$list_a_v[0]; $list_v=$list_a_v[1]; if( ($list_a!="") || ($list_v!="") ) { $list_pro_ids = fnaudiovideo($db,$list_a,$list_v); if($list_pro_ids=="") $list_pro_ids=0; $where_con =" and PM.fldProductId in (".$list_pro_ids.") "; } $where_con .=" and ( fldAbridgedUnabridgedFlag =1 or fldAbridgedUnabridgedFlag =0 ) "; }*/ //ascending combos if($_POST['subcat_prodlist']!='') $where_con .=" and PM.fldProductId in (".$_POST['subcat_prodlist'].") "; $selType=$_POST['selType']; //$selType=$_POST['selType']; if($selType==""){ $selType=4; //deffualt id avarage member rating $_POST['selType']=$selType; } // echo $selType; switch($selType) { case 1: $sql_final_query="select distinct PM.fldProductId,fldProductTitle,fldShortDescription,fldProductThumbnailImage,fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Product_Publisher PP,TBL_Publisher_Retailer_Master PRM where PP.fldPrimaryFlag=1 and PRM.fldPublisherRetailerId=PP.fldPublisherRetailerId and PM.fldPublishFlag=1 and PM.fldProductId=PP.fldProductId and PP.fldPublisherRetailerId='".$publisherid."' ".$where_con." order by fldProductTitle1"; //echo "Here".$sql_final_query; if($subcatid!='' || $catid!='') //list out all the titles in the subcats { $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldShortDescription,PM.fldProductThumbnailImage,PM.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Publisher_Retailer_Master,TBL_Product_Publisher where TBL_Publisher_Retailer_Master.fldPublisherRetailerId=TBL_Product_Publisher.fldPublisherRetailerId and TBL_Product_Publisher.fldPrimaryFlag=1 and PM.fldPublishFlag=1 and PM.fldProductId=TBL_Product_Publisher.fldProductId and TBL_Product_Publisher.fldProductId in (".$id_list.") and TBL_Publisher_Retailer_Master.fldPublisherRetailerId='".$publisherid."' ".$where_con." order by fldProductTitle1" ; } break; case 2: $sql_final_query="select distinct PM.fldProductId,fldProductTitle,fldShortDescription,fldProductThumbnailImage,fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Product_Publisher PP,TBL_Publisher_Retailer_Master PRM where PP.fldPrimaryFlag=1 and PRM.fldPublisherRetailerId=PP.fldPublisherRetailerId and PM.fldPublishFlag=1 and PM.fldProductId=PP.fldProductId and PP.fldPublisherRetailerId='".$publisherid."' ".$where_con." order by fldProductTitle1 desc"; if($subcatid!='' || $catid!='') //list out all the titles in the subcats //made primary flag=1 { $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldShortDescription,PM.fldProductThumbnailImage,PM.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Publisher_Retailer_Master,TBL_Product_Publisher where TBL_Publisher_Retailer_Master.fldPublisherRetailerId=TBL_Product_Publisher.fldPublisherRetailerId and TBL_Product_Publisher.fldPrimaryFlag=1 and PM.fldProductId=TBL_Product_Publisher.fldProductId and PM.fldPublishFlag=1 and TBL_Publisher_Retailer_Master.fldPublisherRetailerId='".$publisherid."' and TBL_Product_Publisher.fldProductId in (".$id_list.") ".$where_con." order by fldProductTitle1 desc" ; } break; case 3: //Authur Name $publisher_products=get_publisher_products_id($db,$publisherid); if($publisher_products!='') $where_pub="and PM.fldProductId in(".$publisher_products.")"; $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldProductThumbnailImage,PM.fldProductImage,fldShortDescription,fldLastName,fldFirstName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Author_Narrator_Master,TBL_Product_Author_Narrator,TBL_Product_Master PM where TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and PM.fldPublishFlag=1 and TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and TBL_Product_Author_Narrator.fldProductId=PM.fldProductId ".$where_con." ".$where_pub." and fldPrimaryFlag=1 order by fldLastName,fldFirstName";//Added No Image ; if($subcatid!='' || $catid!='') //list out all the titles in the subcats { $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldProductThumbnailImage,PM.fldProductImage,fldShortDescription,fldLastName,fldFirstName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Author_Narrator_Master,TBL_Product_Author_Narrator,TBL_Product_Master PM where TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and PM.fldPublishFlag=1 and TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and PM.fldProductId in (".$id_list.") and TBL_Product_Author_Narrator.fldProductId=PM.fldProductId ".$where_con." ".$where_pub." and fldPrimaryFlag=1 order by fldLastName,fldFirstName";//Added No Image } break; case 4: //Avg. Member ratings avg(fldRatingPoints) as average //$sql_final_query="select distinct PM.fldProductId,avg(fldRatingPoints) as average,fldProductTitle,fldShortDescription,fldProductThumbnailImage,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM left join TBL_Review_Rating TRR on PM.fldProductId=TRR.fldProductId,TBL_Product_Publisher PP,TBL_Publisher_Retailer_Master PRM where PP.fldPrimaryFlag=1 and PRM.fldPublisherRetailerId=PP.fldPublisherRetailerId and PM.fldProductId=PP.fldProductId and PM.fldPublishFlag=1 and PP.fldPublisherRetailerId='".$publisherid."' ".$where_con." group by PM.fldProductId order by average desc , PM.fldProductTitle1 asc"; //Most Popular $sql_final_query="select distinct PM.fldProductId,fldProductTitle,fldShortDescription,fldProductThumbnailImage,fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Product_Publisher PP,TBL_Publisher_Retailer_Master PRM where PP.fldPrimaryFlag=1 and PRM.fldPublisherRetailerId=PP.fldPublisherRetailerId and PM.fldPublishFlag=1 and PM.fldProductId=PP.fldProductId and PP.fldPublisherRetailerId='".$publisherid."' ".$where_con." order by fldRelevanceCount DESC, fldProductTitle1 asc"; if($subcatid!='' || $catid!='') //list out all the titles in the subcats //made primary flag=1 { $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldShortDescription,PM.fldProductThumbnailImage,PM.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Publisher_Retailer_Master,TBL_Product_Publisher where TBL_Publisher_Retailer_Master.fldPublisherRetailerId=TBL_Product_Publisher.fldPublisherRetailerId and TBL_Product_Publisher.fldPrimaryFlag=1 and PM.fldProductId=TBL_Product_Publisher.fldProductId and PM.fldPublishFlag=1 and TBL_Publisher_Retailer_Master.fldPublisherRetailerId='".$publisherid."' and TBL_Product_Publisher.fldProductId in (".$id_list.") ".$where_con." order by fldRelevanceCount DESC,fldProductTitle1 desc" ; } break; case 5: //featured $sql_final_query="select distinct PM.fldProductId,fldProductTitle,fldShortDescription,fldProductThumbnailImage,fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Product_Publisher PP,TBL_Publisher_Retailer_Master PRM where PP.fldPrimaryFlag=1 and PRM.fldPublisherRetailerId=PP.fldPublisherRetailerId and PP.fldFeaturedProductFlag=1 and PM.fldProductId=PP.fldProductId and PM.fldPublishFlag=1 and PP.fldPublisherRetailerId='".$publisherid."' ".$where_con." order by fldProductTitle1"; if($subcatid!='' || $catid!='') //list out all the titles in the subcats //made primary flag=1 { $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldShortDescription,PM.fldProductThumbnailImage,PM.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Publisher_Retailer_Master,TBL_Product_Publisher where TBL_Publisher_Retailer_Master.fldPublisherRetailerId=TBL_Product_Publisher.fldPublisherRetailerId and TBL_Product_Publisher.fldPrimaryFlag=1 and PM.fldPublishFlag=1 and PM.fldProductId=TBL_Product_Publisher.fldProductId and TBL_Product_Publisher.fldProductId in (".$id_list.") and TBL_Product_Publisher.fldFeaturedProductFlag=1 and TBL_Publisher_Retailer_Master.fldPublisherRetailerId='".$publisherid."' ".$where_con." order by PM.fldProductTitle"; } break; case 17: //buy seller $publisher_products=get_publisher_products_id($db,$publisherid); if($publisher_products!='') $where_pub="and PM.fldProductId in(".$publisher_products.")"; $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldProductThumbnailImage,PM.fldProductImage,fldShortDescription,fldLastName,fldFirstName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Author_Narrator_Master,TBL_Product_Author_Narrator,TBL_Product_Master PM where TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and PM.fldPublishFlag=1 and TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and TBL_Product_Author_Narrator.fldProductId=PM.fldProductId ".$where_con." ".$where_pub." and fldPrimaryFlag=1 order by fldTotalSaleCount desc";//Added No Image ; if($subcatid!='' || $catid!='') //list out all the titles in the subcats { $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldProductThumbnailImage,PM.fldProductImage,fldShortDescription,fldLastName,fldFirstName,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Author_Narrator_Master,TBL_Product_Author_Narrator,TBL_Product_Master PM where TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and PM.fldPublishFlag=1 and TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and PM.fldProductId in (".$id_list.") and TBL_Product_Author_Narrator.fldProductId=PM.fldProductId ".$where_con." ".$where_pub." and fldPrimaryFlag=1 order by fldLastName,fldFirstName";//Added No Image } break; default: //default $sql_final_query="select distinct PM.fldProductId,fldProductTitle,fldShortDescription,fldProductThumbnailImage,fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Product_Publisher PP,TBL_Publisher_Retailer_Master PRM where PP.fldPrimaryFlag=1 and PRM.fldPublisherRetailerId=PP.fldPublisherRetailerId and PM.fldPublishFlag=1 and PM.fldProductId=PP.fldProductId and PP.fldPublisherRetailerId='".$publisherid."' ".$where_con." order by fldProductTitle1"; if($subcatid!='' || $catid!='') //list out all the titles in the subcats //made primary flag=1 { $sql_final_query="select distinct PM.fldProductId,PM.fldProductTitle,PM.fldShortDescription,PM.fldProductThumbnailImage,PM.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master PM,TBL_Publisher_Retailer_Master,TBL_Product_Publisher where TBL_Publisher_Retailer_Master.fldPublisherRetailerId=TBL_Product_Publisher.fldPublisherRetailerId and TBL_Product_Publisher.fldPrimaryFlag=1 and PM.fldPublishFlag=1 and PM.fldProductId=TBL_Product_Publisher.fldProductId and TBL_Product_Publisher.fldProductId in (".$id_list.") and TBL_Publisher_Retailer_Master.fldPublisherRetailerId='".$publisherid."' ".$where_con." order by PM.fldProductTitle1" ; //echo $sql_final_query; } break; } //echo $sql_final_query; $result=$db->ReturnRs($sql_final_query); $count = mysql_num_rows($result); $p = new Pager; if($_POST['selCount']==1) { $limit = 10; } else if($_POST['selCount']==2) { $limit = 25; } else if($_POST['selCount']==3) { $limit = 50; } else if($_POST['selCount']==4 || $_POST['selCount']==6) { $limit = $count; } else { $limit = 10; } $start = $p->findStart($limit,$pageno); if($count!= 0 ) $pages = $p->findPages($count, $limit); $pagelist = $p->pageList($pageno, $pages,1); $pagelist_top = $p->pageList($pageno, $pages,0); $j=1+($pageno-1)*$limit; $start_count=$j; //***************************************************************/ $select_pro_ids=$sql_final_query." LIMIT ".$start.", ".$limit; $rs_pro_ids=$db->ReturnRs($select_pro_ids); //........................................................... ?> isMobile() || $detect->isTablet() || $detect->version('iPad')) { ?> <? echo $title;?>

              

    <?=$pubname?>
    Website:
    Total Number of Titles:
    0) { ?> 0) { ?> ReturnRs($select_pro_ids); $count_link = mysql_num_rows($result_link); if($count_link>0) { ?>

    "; ?>Go to Downloads


    ') || $c_info!="" || ($website_feature!="" && $website_feature!='
      ')) { ?> ' || $c_info!='') { ?> ') { ?>

      Contact Information

      0){?> "; ?>Go to Downloads

      Sort by
      Titles Per Page
      - ($start_count+$limit-1)) echo $start_count+$limit-1 ; else echo $count ; ?> of Titles
      0 then only show edition $select_version="select fldProductId from TBL_Product_Other_Version where fldProductId=".$row_pro_ids->fldProductId; $rs_version=$db->ReturnRs($select_version); $version_count=mysql_num_rows($rs_version); if($subcatid!='') if($subcat_prodlist!="") $subcat_prodlist.=",".$row_pro_ids->fldProductId; else $subcat_prodlist=$row_pro_ids->fldProductId; if($selType==3) { if($row_pro_ids->fldFirstName!=$default_author_flname) $author=$row_pro_ids->fldFirstName." ".$row_pro_ids->fldLastName; else $author=''; } else $author=get_author($db,$row_pro_ids->fldProductId); if($lolhost!=1) $href=generate_productlink($db,$row_pro_ids->fldProductId); else $href=generate_productlink($db,$row_pro_ids->fldProductId,"","","",5); $format=get_available_formats($db,$row_pro_ids->fldProductId) ?>
      .
      fldProductId; //$href=generate_href($db,$row_pro_ids->fldProductId); if($lolhost!=1) $href=generate_productlink($db,$row_pro_ids->fldProductId); else $href=generate_productlink($db,$row_pro_ids->fldProductId,"","","",5); if($_POST['selCount']!=6) {?>
      fldProductId); display_image($row_pro_ids->fldProductThumbnailImage,$serverpath.'/'.$pthumbnailimage.$row_pro_ids->fldProductThumbnailImage,0,0,"",$href,"",$row_pro_ids->fldProductTitle,"",$sample); ?>
      by
      Available on:
      fldShortDescription!='') { ?>

      fldHTMLFlags; if($HTMLFlag!='') $HTMLFlags=split(",",$HTMLFlag); else $HTMLFlags[0]=0; if($HTMLFlags[0]==0) echo nl2br($row_pro_ids->fldShortDescription); else echo $row_pro_ids->fldShortDescription; ?>

      - ($start_count+$limit-1)) echo $start_count+$limit-1 ; else echo $count ; ?> of Titles

      Featured In

      Format

      • >   Audio Download   Audio Download
      • >   Audio CD   Audio CD
      • >   Audio Cassette   Audio Cassette
      • >   MP3 CD   MP3 CD
      <? echo $title;?>
      location.href='podcast_results.php?fname=$searchtxt';"; } ?>
      LOL
       

      <?=$pubname?>


      0) { ?> 0) { ?> ReturnRs($select_pro_ids); $count_link = mysql_num_rows($result_link); if($count_link>0) { if($catid!="") $aaa=$pub_href; else if($subcatid!="") $aaa=$pub_href; else $aaa=add_and_hyphen($pubname); ?>

      Description

      Browse Titles

      0 then only show edition $select_version="select fldProductId from TBL_Product_Other_Version where fldProductId=".$row_pro_ids->fldProductId; $rs_version=$db->ReturnRs($select_version); $version_count=mysql_num_rows($rs_version); if($subcatid!='') if($subcat_prodlist!="") { $subcat_prodlist.=",".$row_pro_ids->fldProductId; }else{ $subcat_prodlist=$row_pro_ids->fldProductId; } if($selType==3) { if($row_pro_ids->fldFirstName!=$default_author_flname) $author=$row_pro_ids->fldFirstName." ".$row_pro_ids->fldLastName; else $author=''; } else { $author=get_author($db,$row_pro_ids->fldProductId); } if($lolhost!=1) { $href=generate_productlink($db,$row_pro_ids->fldProductId); } else{ $href=generate_productlink($db,$row_pro_ids->fldProductId,"","","",5); } $format=getresponsive_available_formats($db,$row_pro_ids->fldProductId); $sample=displayresponsivepagi_sample($db,$row_pro_ids->fldProductId); ?>
      fldProductTitle ?>
      by
      fldAbridgedUnabridgedFlag==1 && $version_count>0){?>
      Unabridged Edition
      fldAbridgedUnabridgedFlag==0 && $version_count>0){?>
      Abridged Edition
      fldShortDescription!='') { ?>

      fldHTMLFlags; if($HTMLFlag!='') $HTMLFlags=split(",",$HTMLFlag); else $HTMLFlags[0]=0; if($HTMLFlags[0]==0) echo nl2br($row_pro_ids->fldShortDescription); else echo $row_pro_ids->fldShortDescription; ?>