isMobile() || $detect->isTablet() || $detect->version('iPad')) { ?> ReturnRs($sql); $row=mysql_fetch_row($rs); $category_id=$row[0]; if($row[0]!='') $_GET['catid']=$row[0]; } $subcategory_name=$_GET['id']; if($_GET['id']!='') { $flg=is_alpha($_GET['id']); if($flg>0) { $subcatname=strip_and_quote($_GET['id']); $sql="select fldSubcategoryId from TBL_Subcategory_Master where fldSubcategoryName='".$subcatname."' and fldCategoryId=".$_GET['catid']; $rs=$db->ReturnRs($sql); $row=mysql_fetch_row($rs); $subcategory_id=$row[0]; // print("sub_cat:".$subcategory_id); if($row[0]!='') $_GET['subcatid']=$row[0]; $_GET['id']=$row[0]; } } //New code that will //New code to show the titles with no image $selcount=$_POST['selCount']; if($selcount==5) $_POST['selCount']=''; $objectid=$_GET['id']; if($_GET['catid']!="") $catid=$_GET['catid']; else $catid=$_POST['catid']; if($_GET['subcatid']!="") $subcatid=$_GET['subcatid']; else $subcatid=$_POST['subcatid']; if($_GET['id']!="") $id1=$_GET['id']; else $id1=$_POST['hidid']; if($_GET['txtsrc']!="") $searchtext=$_GET['txtsrc']; else $searchtext=$_POST['hidsearchtext']; $searchtext=str_replace("","&",$searchtext); if($_POST['selCount']==5) $qry_no_image=" and fldProductThumbnailImage='' "; else $qry_no_image=""; $catalog=1; $sql_select="select fldSubcategoryName,fldSubcategoryDescription,fldSubcategoryTitleImage1,fldSubcategoryTitleImage2,fldMetakeyword,fldMetadescription,fldTitletag from TBL_Subcategory_Master where fldSubcategoryId=".$id1; $rs_select=$db->ReturnRs($sql_select); $row_select=mysql_fetch_object($rs_select); $id=$subcatid; if($subcatid=="") { $id=$id1; } //display navigation bar for category if($catid!="") { $strcategory="Select fldCategoryId,fldCategoryName from TBL_Category_Master where fldCategoryId=".$catid; $rscategory=mysql_query($strcategory); $row=mysql_fetch_row($rscategory); $category=$row[1]; $categoryid=$row[0]; $strsubcategory="Select fldSubcategoryId,fldSubcategoryName from TBL_Subcategory_Master where fldSubcategoryId=$id"; $rssubcategory=mysql_query($strsubcategory); $rowsubcat=mysql_fetch_row($rssubcategory); $subcat=$rowsubcat[1]; } if($row_select->fldMetakeyword!='') { $meta_content_arr=explode("\n",$row_select->fldMetakeyword); for($i=0;$ifldMetadescription); $meta_content=str_replace("\"","\\\"",$meta_content); $titletag=str_replace("\"","\\\"",$row_select->fldTitletag); if($titletag=='') $titletag=$subcat; $js_user_id=$_SESSION['learnout_username']; $js_session_id= session_id(); $js_item_id=stripslashes($objectid); $subcat_str=str_replace("and","&",$subcategory_name); $subcat_str1=str_replace("-"," ",$subcat_str); $subcat_str2=str_replace("_"," ",$subcat_str1); $js_subcat=$subcat_str2; $cat_str=str_replace("-"," ",$category_name); $cat_str1=str_replace("_"," ",$cat_str); $js_cat=$cat_str1; $category_id="C".$category_id; $js_cat_id=$category_id; $js_subcat_id=$subcategory_id; $keyw = str_replace('"',"'",stripslashes($meta_content)); $descp = str_replace('"',"'",stripslashes($meta_desc)); #==========================================================================================================# # Assigning Smarty Variables #===========================================================================================================# ?> isMobile() || $detect->isTablet() || $detect->version('iPad')) { ?> <?=stripslashes($titletag)?>

          

fldSubcategoryName?> Audio & Video

fldSubcategoryName); $linktoDownLoad=$serverpath."/Downloads/".add_and_hyphen($category_name)."/".add_and_hyphen($row_select->fldSubcategoryName); ?>

Featured Free fldSubcategoryName?> Titles

Browse Our fldSubcategoryName?> Free Audio & Video

Featured fldSubcategoryName?> Podcasts

Browse Our fldSubcategoryName?> Podcasts
ReturnRs($sqlA21); $rowA21=mysql_fetch_object($rsA21); $listA21=$rowA21->fldFormatId; $whereAV2="and TBL_Format_2_Master.fldFormatId='$listA21'"; } if(in_array("16",$arr_a)) { $chkAudioCD="checked"; $sqlA21="select fldFormatId from TBL_Format_2_Master where fldFormatTypeId=0 and fldFormatName='Audio CD'"; $rsA21=$db->ReturnRs($sqlA21); $rowA21=mysql_fetch_object($rsA21); $listA21=$rowA21->fldFormatId; $whereAV2="and TBL_Format_2_Master.fldFormatId='$listA21'"; } if(in_array("15",$arr_a)) { $chkVideoDownload="checked"; $sqlA21="select fldFormatId from TBL_Format_2_Master where fldFormatTypeId=0 and fldFormatName='Audio Cassette'"; $rsA21=$db->ReturnRs($sqlA21); $rowA21=mysql_fetch_object($rsA21); $listA21=$rowA21->fldFormatId; $whereAV2="and TBL_Format_2_Master.fldFormatId='$listA21'"; } if(in_array("18",$arr_a)) { $chkMP3CD="checked"; $sqlA21="select fldFormatId from TBL_Format_2_Master where fldFormatTypeId=0 and fldFormatName='MP3 CD'"; $rsA21=$db->ReturnRs($sqlA21); $rowA21=mysql_fetch_object($rsA21); $listA21=$rowA21->fldFormatId; $whereAV2="and TBL_Format_2_Master.fldFormatId='$listA21'"; } if(in_array("102",$arr_a)) { $chkOnlineAudio="checked"; $sqlA22="select fldFormatId from TBL_Format_2_Master where fldFormatTypeId=0 and fldFormatName='Online Audio'"; $rsA22=$db->ReturnRs($sqlA22); $rowA22=mysql_fetch_object($rsA22); $listA22=$rowA22->fldFormatId; $whereAV2="and TBL_Format_2_Master.fldFormatId='$listA22'"; } if(in_array("100",$arr_a)) { $chkPodcast="checked"; $sqlA21="select fldFormatId from TBL_Format_2_Master where fldFormatTypeId=0 and fldFormatName='Podcast'"; $rsA21=$db->ReturnRs($sqlA21); $rowA21=mysql_fetch_object($rsA21); $listA21=$rowA21->fldFormatId; $whereAV2="and TBL_Format_2_Master.fldFormatId='$listA21'"; } if(in_array("101",$arr_v)) { $chkOnlineVideo="checked"; $sqlV2="select fldFormatId from TBL_Format_2_Master where fldFormatTypeId=1 and fldFormatName='Online Video'"; $rsV2=$db->ReturnRs($sqlV2); $rowV2=mysql_fetch_object($rsV2); $listV2=$rowV2->fldFormatId; $whereAV2="and TBL_Format_2_Master.fldFormatId='$listV2'"; } if(in_array("20",$arr_v)) { $chkDownload="checked"; $sqlV2="select fldFormatId from TBL_Format_2_Master where fldFormatTypeId=1 and fldFormatName='Video Download'"; $rsV2=$db->ReturnRs($sqlV2); $rowV2=mysql_fetch_object($rsV2); $listV2=$rowV2->fldFormatId; $whereAV2="and TBL_Format_2_Master.fldFormatId='$listV2'"; } if(in_array("21",$arr_a)) { $$chkDVD="checked"; $sqlA21="select fldFormatId from TBL_Format_2_Master where fldFormatTypeId=0 and fldFormatName='DVD'"; $rsA21=$db->ReturnRs($sqlA21); $rowA21=mysql_fetch_object($rsA21); $listA21=$rowA21->fldFormatId; $whereAV2="and TBL_Format_2_Master.fldFormatId='$listA21'"; } if($listA21!="" && $listA22!="" && $listV2=="") $whereAV2="and (TBL_Format_2_Master.fldFormatId='$listA21' or TBL_Format_2_Master.fldFormatId='$listA22')"; if($listA21!="" && $listA22=="" && $listV2!="") $whereAV2="and (TBL_Format_2_Master.fldFormatId='$listV2' or TBL_Format_2_Master.fldFormatId='$listA21')"; if($listA21=="" && $listA22!="" && $listV2!="") $whereAV2="and (TBL_Format_2_Master.fldFormatId='$listV2' or TBL_Format_2_Master.fldFormatId='$listA22')"; if($listA21!="" && $listA22!="" && $listV2!="") $whereAV2="and (TBL_Format_2_Master.fldFormatId='$listV2' or TBL_Format_2_Master.fldFormatId='$listA21' or TBL_Format_2_Master.fldFormatId='$listA22')"; $sqlAV2=" select distinct TBL_Product_Format_2_Detail.fldProductId from TBL_Product_Format_2_Detail,TBL_Format_2_Master,TBL_Product_Master where $rs_subproid_list and TBL_Product_Master.fldProductId=TBL_Product_Format_2_Detail.fldProductId and TBL_Product_Format_2_Detail.fldFormatId=TBL_Format_2_Master.fldFormatId and TBL_Product_Master.fldPublishFlag=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 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 TBL_Product_Master.fldProductId in (".$list_pro_ids.") " ; if($_SERVER["REMOTE_ADDR"]=="115.241.197.6") print"
list_pro_ids :: $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 ) "; } } if($selType==1) { $descasc=" asc "; } if($selType==6) { $descasc=" desc "; } ?> 1) $searchtext_con.=") "; // echo "HERE".$searchtext_con; $select_pro_ids=" select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Subcategory_Master,TBL_Product_Category_Detail where TBL_Product_Master.fldProductId=TBL_Product_Category_Detail.fldProductId ".$qry_no_image." and TBL_Product_Category_Detail.fldCatSubCatId =TBL_Subcategory_Master.fldSubcategoryId ".$where_con." and TBL_Product_Category_Detail.fldCatSubCatFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Subcategory_Master.fldSubcategoryId=".$id1." ".$searchtext_con." order by fldProductTitle1 $descasc " ; // print "
select_pro_ids 1 :: ".$select_pro_ids; if($selType==20)//for featured search { if(count($titles)>1) $searchtext_con.=") "; if($_SERVER["REMOTE_ADDR"]=="115.241.197.6") print"
where_con :: $where_con"; $select_pro_ids=" select distinct TBL_Product_Master.fldRelevanceCount AS VIEWCOUNT, TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Product_Category_Detail where TBL_Product_Master.fldProductId=TBL_Product_Category_Detail.fldProductId ".$qry_no_image." and TBL_Product_Category_Detail.fldCatSubCatId=$id1 ".$where_con." and TBL_Product_Category_Detail.fldCatSubCatFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1". $searchtext_con." order by TBL_Product_Master.fldRelevanceCount DESC , fldProductTitle1 ASC " ; if($_SERVER["REMOTE_ADDR"]=="115.241.197.6") print" select_pro_ids :: $select_pro_ids"; } if($selType==23)//for random search { if(count($titles)>1) $searchtext_con.=") "; if($_SERVER["REMOTE_ADDR"]=="115.241.197.6") print"
where_con :: $where_con"; $select_pro_ids=" select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Product_Category_Detail where TBL_Product_Master.fldProductId=TBL_Product_Category_Detail.fldProductId ".$qry_no_image." and TBL_Product_Category_Detail.fldCatSubCatId=$id1 ".$where_con." and TBL_Product_Category_Detail.fldCatSubCatFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1". $searchtext_con." order by RAND() " ; if($_SERVER["REMOTE_ADDR"]=="115.241.197.6") print" select_pro_ids :: $select_pro_ids"; } if($selType==2)//for featured search { $select_pro_ids =" select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Subcategory_Master,TBL_Product_Category_Detail ".$table_list_for_format." where TBL_Product_Master.fldProductId=TBL_Product_Category_Detail.fldProductId ".$qry_no_image." and TBL_Product_Category_Detail.fldCatSubCatId =TBL_Subcategory_Master.fldSubcategoryId ".$where_con." and TBL_Product_Category_Detail.fldCatSubCatFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and fldProductTitle like '%".$searchtext."%' and fldCatSubCatId=".$id1." and TBL_Product_Category_Detail.fldFeaturedFlag=1 order by TBL_Product_Category_Detail.fldFeaturedFlag desc,fldProductTitle1 "; } //.......................make list of product ids............................................................... $id_list=""; $rs_id_list=$db->ReturnRs($select_pro_ids); while($row_id_list=mysql_fetch_array($rs_id_list)) { if($id_list!="") $id_list .=",".$row_id_list[0]; else $id_list .=$row_id_list[0]; } if($id_list=="") $id_list=0; //...................................................................................... if($selType==3)//for most rating { $select_max_pro=" select fldRatingPoints,fldProductId from TBL_Review_Rating where fldProductId in(".$id_list.") and fldApproveDeclineFlag=1 order by fldRatingPoints desc "; //echo $select_max_pro ; $max1=0; $list1=""; $rs_max_pro=$db->ReturnRs($select_max_pro); while($row_max_pro=mysql_fetch_array($rs_max_pro)) { if($list1=="") { $list1 .=$row_max_pro[1]; } else { $list1 .=",".$row_max_pro[1]; } } if($list1=="") $list1=0; $select_pro_ids="select TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,max(TBL_Review_Rating.fldRatingPoints) 'fldRatingPoints',fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Review_Rating where TBL_Product_Master.fldProductId = TBL_Review_Rating.fldProductId and fldApproveDeclineFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldProductId in(".$list1.") ".$qry_no_image." group by TBL_Product_Master.fldProductId order by fldRatingPoints desc "; } if($selType==4)//for most review { $select_pro_ids="select TBL_Review_Rating.fldProductId,fldProductTitle,TBL_Product_Master.fldShortDescription,fldProductThumbnailImage,fldProductImage,count(fldReviewText) total,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Review_Rating,TBL_Product_Master where TBL_Review_Rating.fldProductId in($id_list) and fldApproveDeclineFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Review_Rating.fldProductId=TBL_Product_Master.fldProductId $qry_no_image group by fldProductId order by total desc"; } if($selType==5) { $select_pro_ids=" select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldFirstName,fldLastName,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Author_Narrator_Master,TBL_Product_Author_Narrator where TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and TBL_Product_Master.fldProductId=TBL_Product_Author_Narrator.fldProductId and TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Author_Narrator.fldProductId in (".$id_list.") ".$qry_no_image." and TBL_Product_Author_Narrator.fldPrimaryFlag=1 and fldProductTitle like '%".$searchtext."%' order by fldLastName,fldFirstName " ; //echo $sql_author; } //Average Member Rating if($selType==7) { $select_pro_ids="select TBL_Product_Master.fldProductId,fldAvgRating as average,fldRatingCount as ratecount, TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master where TBL_Product_Master.fldProductId IN (".$id_list.") $sql_no_img and TBL_Product_Master.fldPublishFlag=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Master.fldLearnSectionFlag!=1 order by average desc ,ratecount desc,TBL_Product_Master.fldProductTitle1 asc"; //echo $select_pro_ids; } //End AVg. Rating if($selType==17)//for recently added { $select_pro_ids=" select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Subcategory_Master,TBL_Product_Category_Detail where TBL_Product_Master.fldProductId=TBL_Product_Category_Detail.fldProductId ".$qry_no_image." and TBL_Product_Category_Detail.fldCatSubCatId =TBL_Subcategory_Master.fldSubcategoryId ".$where_con." and TBL_Product_Category_Detail.fldCatSubCatFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Subcategory_Master.fldSubcategoryId=".$id1." order by TBL_Product_Master.fldProductId desc"; } if($selType==18)//for best sellers { $select_pro_ids=" select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldAvgRating as average,TBL_Product_Master.fldRatingCount as ratecount,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Subcategory_Master,TBL_Product_Category_Detail where TBL_Product_Master.fldProductId=TBL_Product_Category_Detail.fldProductId ".$qry_no_image." and TBL_Product_Category_Detail.fldCatSubCatId =TBL_Subcategory_Master.fldSubcategoryId ".$where_con." and TBL_Product_Category_Detail.fldCatSubCatFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Subcategory_Master.fldSubcategoryId=".$id1." order by fldPrevSaleCount desc, fldTotalSaleCount desc,fldRelevanceCount desc,average desc ,ratecount desc,fldProductTitle asc"; } $result=$db->ReturnRs($select_pro_ids); $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=$select_pro_ids." LIMIT ".$start.", ".$limit; //........................................................... $rs_pro_ids=$db->ReturnRs($select_pro_ids); $chkaudio=$_POST['chkAudioType']; ?>
fldSubcategoryDescription" ?>
<?=$row12['alt']?>

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); //.............create list of authors........................................ if($_POST['selType']!=5) { $select_author="select TBL_Author_Narrator_Master.fldFirstName,TBL_Author_Narrator_Master.fldLastName from TBL_Author_Narrator_Master,TBL_Product_Author_Narrator where TBL_Product_Author_Narrator.fldAuthorNarratorId =TBL_Author_Narrator_Master.fldAuthorNarratorId and TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and TBL_Product_Author_Narrator.fldPrimaryFlag=1 and fldProductId=".$row_pro_ids->fldProductId; $rs_author=$db->ReturnRs($select_author); $author_row_count=mysql_num_rows($rs_author); $author=""; $row_author=mysql_fetch_object($rs_author); if($row_author->fldLastName!=$default_author_flname) { if($row_author->fldLastName!="") $author=$row_author->fldFirstName." ".$row_author->fldLastName; else $author=$row_author->fldFirstName; } if(($row_author->fldLastName=="") && ($row_author->fldFirstName=="")) { $author=""; } } /*while($row_author=mysql_fetch_object($rs_author)) { if($author!="") $author .=":".$row_author->fldLastName.", ".$row_author->fldFirstName; else $author .=$row_author->fldLastName.", ".$row_author->fldFirstName; }*/ $select_format="select distinct fldFormatName,fldSale,fldPrice from TBL_Format_Master,TBL_Product_Format_Detail where TBL_Format_Master.fldFormatId=TBL_Product_Format_Detail.fldFormatId ".$formattype." and fldProductId=".$row_pro_ids->fldProductId." and fldPurchaseFlag=1 order by fldFormatTypeId,fldOrder"; //echo"
".$select_format; $rs_format=$db->ReturnRs($select_format); $format=""; $i=0; while($row_format=mysql_fetch_object($rs_format)) { // print("item price:".$row_format->fldPrice); $price_list=""; if($row_pro_ids->fldFreeFlag==1) $price_list=" (Free)"; else{ if($row_format->fldPrice>0 && $row_format->fldSale>=1) $price_list=" ($".sprintf("%.2f",$row_format->fldPrice).")"; } if($format!="") $format .=" | ".$row_format->fldFormatName.$price_list; else $format =$row_format->fldFormatName.$price_list; $i++; } //Subscribe Format $format.=get_subscribe_format_free($row_pro_ids->fldFreeFlag,$db,$row_pro_ids->fldProductId,$i); //End Subscribe Format if($_POST['selType']==5) { if($row_pro_ids->fldFirstName!=$default_author_flname) $author=$row_pro_ids->fldFirstName." ".$row_pro_ids->fldLastName; else $author=''; }?>
.
fldProductId,$catid,$subcatid); if($selcount!=5){ ?>
fldProductId); ?>
.
fldProductId,$catid,$subcatid); if($selcount!=5){ ?>
fldProductId); echo display_image_tpl($row_pro_ids->fldProductThumbnailImage,$serverpath.'/'.$pthumbnailimage.$row_pro_ids->fldProductThumbnailImage,0,0,"",$href,"",$row_pro_ids->fldProductTitle,"",$sample); ?>
Available on:
average!=0) { echo "
Average Rating: ".show_image_podcastpage($row_pro_ids->average); echo " (".sprintf("%01.1f", round($row_pro_ids->average,1))." Stars)"; } ?> fldAbridgedUnabridgedFlag==1 && $version_count>0) //echo "
Unabridged Edition"; // if($row_pro_ids->fldAbridgedUnabridgedFlag==0 && $version_count>0) //echo "
Abridged Edition"; if($row_pro_ids->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; ?>

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

Format

<?=stripslashes($titletag)?>
location.href='podcast_results.php?fname=$searchtxt';"; } ?>
LOL
 
fldSubcategoryName); $linktoDownLoad=$serverpath."/Downloads/".add_and_hyphen($category_name)."/".add_and_hyphen($row_select->fldSubcategoryName); ?>

Featured Free fldSubcategoryName?> Titles

Featured fldSubcategoryName?> Podcasts

1) $searchtext_con.=") "; // echo "HERE".$searchtext_con; $select_pro_ids=" select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Subcategory_Master,TBL_Product_Category_Detail where TBL_Product_Master.fldProductId=TBL_Product_Category_Detail.fldProductId ".$qry_no_image." and TBL_Product_Category_Detail.fldCatSubCatId =TBL_Subcategory_Master.fldSubcategoryId ".$where_con." and TBL_Product_Category_Detail.fldCatSubCatFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Subcategory_Master.fldSubcategoryId=".$id1." ".$searchtext_con." order by fldProductTitle1 $descasc " ; // print "
select_pro_ids 1 :: ".$select_pro_ids; if($selType==20)//for featured search { if(count($titles)>1) $searchtext_con.=") "; if($_SERVER["REMOTE_ADDR"]=="115.241.197.6") print"
where_con :: $where_con"; $select_pro_ids=" select distinct TBL_Product_Master.fldRelevanceCount AS VIEWCOUNT, TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Product_Category_Detail where TBL_Product_Master.fldProductId=TBL_Product_Category_Detail.fldProductId ".$qry_no_image." and TBL_Product_Category_Detail.fldCatSubCatId=$id1 ".$where_con." and TBL_Product_Category_Detail.fldCatSubCatFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1". $searchtext_con." order by TBL_Product_Master.fldRelevanceCount DESC , fldProductTitle1 ASC " ; if($_SERVER["REMOTE_ADDR"]=="115.241.197.6") print" select_pro_ids :: $select_pro_ids"; } if($selType==23)//for random search { if(count($titles)>1) $searchtext_con.=") "; if($_SERVER["REMOTE_ADDR"]=="115.241.197.6") print"
where_con :: $where_con"; $select_pro_ids=" select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Product_Category_Detail where TBL_Product_Master.fldProductId=TBL_Product_Category_Detail.fldProductId ".$qry_no_image." and TBL_Product_Category_Detail.fldCatSubCatId=$id1 ".$where_con." and TBL_Product_Category_Detail.fldCatSubCatFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1". $searchtext_con." order by RAND() " ; if($_SERVER["REMOTE_ADDR"]=="115.241.197.6") print" select_pro_ids :: $select_pro_ids"; } if($selType==2)//for featured search { $select_pro_ids =" select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Subcategory_Master,TBL_Product_Category_Detail ".$table_list_for_format." where TBL_Product_Master.fldProductId=TBL_Product_Category_Detail.fldProductId ".$qry_no_image." and TBL_Product_Category_Detail.fldCatSubCatId =TBL_Subcategory_Master.fldSubcategoryId ".$where_con." and TBL_Product_Category_Detail.fldCatSubCatFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and fldProductTitle like '%".$searchtext."%' and fldCatSubCatId=".$id1." and TBL_Product_Category_Detail.fldFeaturedFlag=1 order by TBL_Product_Category_Detail.fldFeaturedFlag desc,fldProductTitle1 "; } //.......................make list of product ids............................................................... $id_list=""; $rs_id_list=$db->ReturnRs($select_pro_ids); while($row_id_list=mysql_fetch_array($rs_id_list)) { if($id_list!="") $id_list .=",".$row_id_list[0]; else $id_list .=$row_id_list[0]; } if($id_list=="") $id_list=0; //...................................................................................... if($selType==3)//for most rating { $select_max_pro=" select fldRatingPoints,fldProductId from TBL_Review_Rating where fldProductId in(".$id_list.") and fldApproveDeclineFlag=1 order by fldRatingPoints desc "; //echo $select_max_pro ; $max1=0; $list1=""; $rs_max_pro=$db->ReturnRs($select_max_pro); while($row_max_pro=mysql_fetch_array($rs_max_pro)) { if($list1=="") { $list1 .=$row_max_pro[1]; } else { $list1 .=",".$row_max_pro[1]; } } if($list1=="") $list1=0; $select_pro_ids="select TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,max(TBL_Review_Rating.fldRatingPoints) 'fldRatingPoints',fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Review_Rating where TBL_Product_Master.fldProductId = TBL_Review_Rating.fldProductId and fldApproveDeclineFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldProductId in(".$list1.") ".$qry_no_image." group by TBL_Product_Master.fldProductId order by fldRatingPoints desc "; } if($selType==4)//for most review { $select_pro_ids="select TBL_Review_Rating.fldProductId,fldProductTitle,TBL_Product_Master.fldShortDescription,fldProductThumbnailImage,fldProductImage,count(fldReviewText) total,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Review_Rating,TBL_Product_Master where TBL_Review_Rating.fldProductId in($id_list) and fldApproveDeclineFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Review_Rating.fldProductId=TBL_Product_Master.fldProductId $qry_no_image group by fldProductId order by total desc"; } if($selType==5) { $select_pro_ids=" select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldFirstName,fldLastName,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Author_Narrator_Master,TBL_Product_Author_Narrator where TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and TBL_Product_Master.fldProductId=TBL_Product_Author_Narrator.fldProductId and TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Author_Narrator.fldProductId in (".$id_list.") ".$qry_no_image." and TBL_Product_Author_Narrator.fldPrimaryFlag=1 and fldProductTitle like '%".$searchtext."%' order by fldLastName,fldFirstName " ; //echo $sql_author; } //Average Member Rating if($selType==7) { $select_pro_ids="select TBL_Product_Master.fldProductId,fldAvgRating as average,fldRatingCount as ratecount, TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master where TBL_Product_Master.fldProductId IN (".$id_list.") $sql_no_img and TBL_Product_Master.fldPublishFlag=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Master.fldLearnSectionFlag!=1 order by average desc ,ratecount desc,TBL_Product_Master.fldProductTitle1 asc"; //echo $select_pro_ids; } //End AVg. Rating if($selType==17)//for recently added { $select_pro_ids=" select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Subcategory_Master,TBL_Product_Category_Detail where TBL_Product_Master.fldProductId=TBL_Product_Category_Detail.fldProductId ".$qry_no_image." and TBL_Product_Category_Detail.fldCatSubCatId =TBL_Subcategory_Master.fldSubcategoryId ".$where_con." and TBL_Product_Category_Detail.fldCatSubCatFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Subcategory_Master.fldSubcategoryId=".$id1." order by TBL_Product_Master.fldProductId desc"; } if($selType==18)//for best sellers { $select_pro_ids=" select distinct TBL_Product_Master.fldProductId,TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,TBL_Product_Master.fldProductImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,TBL_Product_Master.fldAvgRating as average,TBL_Product_Master.fldRatingCount as ratecount,TBL_Product_Master.fldFreeFlag from TBL_Product_Master,TBL_Subcategory_Master,TBL_Product_Category_Detail where TBL_Product_Master.fldProductId=TBL_Product_Category_Detail.fldProductId ".$qry_no_image." and TBL_Product_Category_Detail.fldCatSubCatId =TBL_Subcategory_Master.fldSubcategoryId ".$where_con." and TBL_Product_Category_Detail.fldCatSubCatFlag=1 and TBL_Product_Master.fldPublishflag=1 and TBL_Product_Master.fldLearnSectionFlag!=1 and TBL_Product_Master.fldQuickLearning!=1 and TBL_Product_Master.fldKidsSectionFlag!=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and TBL_Subcategory_Master.fldSubcategoryId=".$id1." order by fldPrevSaleCount desc, fldTotalSaleCount desc,fldRelevanceCount desc,average desc ,ratecount desc,fldProductTitle asc"; } $result=$db->ReturnRs($select_pro_ids); $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=$select_pro_ids." LIMIT ".$start.", ".$limit; //........................................................... $rs_pro_ids=$db->ReturnRs($select_pro_ids); $chkaudio=$_POST['chkAudioType']; ?>

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); //.............create list of authors........................................ if($_POST['selType']!=5) { $select_author="select TBL_Author_Narrator_Master.fldFirstName,TBL_Author_Narrator_Master.fldLastName from TBL_Author_Narrator_Master,TBL_Product_Author_Narrator where TBL_Product_Author_Narrator.fldAuthorNarratorId =TBL_Author_Narrator_Master.fldAuthorNarratorId and TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and TBL_Product_Author_Narrator.fldPrimaryFlag=1 and fldProductId=".$row_pro_ids->fldProductId; $rs_author=$db->ReturnRs($select_author); $author_row_count=mysql_num_rows($rs_author); $author=""; $row_author=mysql_fetch_object($rs_author); if($row_author->fldLastName!=$default_author_flname) { if($row_author->fldLastName!="") $author=$row_author->fldFirstName." ".$row_author->fldLastName; else $author=$row_author->fldFirstName; } if(($row_author->fldLastName=="") && ($row_author->fldFirstName=="")) { $author=""; } } $select_format="select distinct fldFormatName,fldSale,fldPrice from TBL_Format_Master,TBL_Product_Format_Detail where TBL_Format_Master.fldFormatId=TBL_Product_Format_Detail.fldFormatId ".$formattype." and fldProductId=".$row_pro_ids->fldProductId." and fldPurchaseFlag=1 order by fldFormatTypeId,fldOrder"; //echo"
".$select_format; $rs_format=$db->ReturnRs($select_format); $format=""; $i=0; while($row_format=mysql_fetch_object($rs_format)) { if($row_format->fldFormatName == "Audio Download") { $icon="icon-download"; } if($row_format->fldFormatName == "Audio Cassette") { $icon="icon-briefcase-2"; } if($row_format->fldFormatName == "Audio CD") { $icon="icon-cc-sa"; } if($row_format->fldFormatName == "MP3 CD") { $icon="icon-cc-sa"; } if($row_format->fldFormatName == "Podcast") { $icon="icon-broadcast"; } if($row_format->fldFormatName == "Online Audio") { $icon="icon-headphones"; } if($row_format->fldFormatName == "Online Video") { $icon="icon-film"; } if($row_format->fldFormatName == "Video Download") { $icon="icon-box-add"; } $price_list=""; if($row_pro_ids->fldFreeFlag==1) $price_list="  (Free)"; else{ if($row_format->fldPrice>0 && $row_format->fldSale>=1) $price_list="  ($".sprintf("%.2f",$row_format->fldPrice).")"; } if($format!="") $format .=""; else $format =""; $i++; } //Subscribe Format $format.=getresponsive_subscribe_format_free($row_pro_ids->fldFreeFlag,$db,$row_pro_ids->fldProductId,$i); //End Subscribe Format if($_POST['selType']==5) { if($row_pro_ids->fldFirstName!=$default_author_flname) $author=$row_pro_ids->fldFirstName." ".$row_pro_ids->fldLastName; else $author=''; } $href=generate_productlink($db,$row_pro_ids->fldProductId,$catid,$subcatid); $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; ?>

    Free Audio Book
  $book_desc
$exp[0]
.
 "; return $free_audio_content; } ?>