'; $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $message.=trim($_POST['txtsuggestion']); $headers .= "From: Online-Suggestion\r\n"; $subject="http://www.learnoutloud.com".$pageurl; $cmsg="Message sent successfully"; $hidsvalue=0; mail('suggestions@learnoutloud.com',$subject, $message,$headers); } //code for suggestion mail ends here //-------------------------code review added by jaymin on september 22------------------------ if(trim($_POST['txtrate'])!="") { $localIP = GetHostByName($REMOTE_ADDR); $date=gmdate("Y-m-d"); $user_id=$_SESSION['learnout_userid']; $product_id="LOL123".$_GET['id']; $rating= $_POST['txtrate']; if($_POST['txtrated']==0) { $sql_insert_update="insert into TBL_Review_Rating (fldLOLUserId,fldRatingPoints,fldProductId,fldIPAddress,fldReviewDate,fldApproveDeclineFlag) values('".$_SESSION['learnout_userid']."','" .$_POST['txtrate']."','" .$_GET['id']."','" .$localIP."',now(),1)"; } else { $sql_insert_update="update TBL_Review_Rating set fldRatingPoints='".$_POST['txtrate']."',fldReviewDate=now(),fldIPAddress='".$localIP."' where fldLOLUserId= '".$_SESSION['learnout_userid']."' and fldProductId='".$_GET['id']."' "; } $db->ExecuteSql($sql_insert_update); update_average($db,$_GET['id']); echo""; }//end if //-------------------------code review added by jaymin on september 22------------------------ if($_GET['catid']!='') { $catname=strip_and_quote($_GET['catid']); $sql="select fldCategoryId from TBL_Category_Master where fldCategoryName='".$catname."'"; $rs=$db->ReturnRs($sql); $row=mysql_fetch_row($rs); $subcategory_id=$row[0]; //$category_id=$row[0]; if($row[0]!='') $_GET['catid']=$row[0]; }//if if($_GET['subcatid']!='') { $flg=is_alpha($_GET['subcatid']); if($flg>0) { $subcatname=strip_and_quote($_GET['subcatid']); $sql="select fldSubcategoryId from TBL_Subcategory_Master where fldSubcategoryName='".$subcatname."'"; $rs=$db->ReturnRs($sql); $row=mysql_fetch_row($rs); $category_id=$row[0]; if($row[0]!='') $_GET['subcatid']=$row[0]; } }//if $level=2; if($level=="") { echo "Access Denied
"; echo "Click Here"; exit(); }//if $objectid=$_GET['id']; $catid=$_GET['catid']; $subcatid=$_GET['subcatid']; //.............fetch data from TBL_Product_Master...................... $sql_product_publisher1="select TBL_Publisher_Retailer_Master.fldPublisherRetailerId from TBL_Publisher_Retailer_Master,TBL_Product_Publisher where TBL_Publisher_Retailer_Master.fldPublisherRetailerId=TBL_Product_Publisher.fldPublisherRetailerId and fldPrimaryFlag=1 and fldProductId=".$objectid; $rs_product_publisher1=$db->ReturnRs($sql_product_publisher1); $row_product_publisher1=mysql_fetch_object($rs_product_publisher1); $publisher_id1=$row_product_publisher1->fldPublisherRetailerId; $fields=" fldProductId, fldProductTitle , fldProductSubTitle, fldOriginalContent, fldAbridgedUnabridgedFlag, fldTotalRunningTime, fldProductImage , fldProductThumbnailImage , fldMoreAuthor, fldMoreNarrator, fldReadByAuthor, fldYearOfPublication , fldOriginalYearOfPublication , fldShortDescription , fldLongDescription, fldembvideo, fldFeaturedProductDescription, fldListeningSample , fldViewingSample, fldGuideBook , fldGuideText , fldLevel , fldUniversity , fldTransscriptBook , fldNoOfLecture , fldLectureTime, fldPublishFlag, fldGenaratedProductId, fldPublishFlag, fldProductForumId, fldFreeCourse, fldFreeDocumentries, fldOrder, fldHTMLFlags,fldListeningSample2,fldViewingSample2,fldlListeningFormatId,fldListenimg2_FormatId,fldViewingFormatId,fldViewing2FormatId ,fldListeningRetailerId,fldListening1RetailerId,fldViewingRetailerId,fldViewing1RetailerId,fldSubscription,fldXmlFeedLink,fldDoesNotPlay,fldForumUrl,fldPodcastLink,fldFreeFlag,fldListeningSample2,fldFreeForMemberFlag,fldPublishDate,fldPodcastXMLfeedFlag,fldLearnDirectFlag,fldAvgRating,fldReviewTitle,fldReview,fldFreeAudioBooks"; $select_product="select $fields from TBL_Product_Master where fldProductId=".$objectid; $rs_product=$db->ReturnRs($select_product); $row_product=mysql_fetch_object($rs_product); $row_product->fldLongDescription= html_entity_decode( $row_product->fldLongDescription); $row_product->fldShortDescription= html_entity_decode( $row_product->fldShortDescription); $free_flg=$row_product->fldFreeFlag; if($row_product->fldXmlFeedLink!='') $pod = 1; if($row_product->fldPublishFlag==2) { header("Location:http://www.learnoutloud.com/Home"); exit; }//if /****** RELEVANCE ADDED ********/ function show_download_rating($rating,$pid) { global $serverpath,$s_imagepath; $ratearray=explode(".",round($rating,1)); $rate1=$ratearray[0]; $rate2=$ratearray[1]; if(!empty($rate1) && $rate1>0) { for($i=0; $i<$rate1;$i++) { $k=$i+1; $strRate.= ""; } } $half_star=0; if($rate2!="" && $rate2>0) { $half_star=1; $lastrate=$rate1+1; if($rate2<=9) $strRate.= ""; else $strRate.= ""; } if($lastrate <5) { if($half_star>0) $leftStars=5-$lastrate; else { $leftStars=5-$rate1; $lastrate=$rate1; } for($h=1; $h<=$leftStars; $h++) { $currentRate=$lastrate+$h; $strRate.= ""; } } print $strRate; } function fnDisplayRating($avarage_rating,$pid) { ?>
failed:: query::".mysql_error()); $rs=$db->ReturnRs($sql); if(mysql_num_rows($rs) >0) { $sql_counter= "Update TBL_Product_Relevance set fldViewCount=fldViewCount+1 where fldProductId=".$productId." and fldDate='".$today."'"; } else { $sql_counter= "Insert into TBL_Product_Relevance set fldProductId=".$productId." , fldViewCount=1 ,fldDate='".$today."'"; } $rs=$db->ReturnRs($sql_counter); $sql_counter= "Update TBL_Product_Master set fldAllViewCount=fldAllViewCount+1 where fldProductId=".$productId.""; $rs=$db->ReturnRs($sql_counter); }//function //$productId="57"; $productId=$objectid; fnAddProductRelevance($productId); /****** RELEVANCE ADDED ********/ //................FETCH AUTHOR FROM TBL_Product_Author for Display (modified by richa)........................... $sql_select_product_author1=" select TBL_Product_Author_Narrator.fldAuthorNarratorId ,fldFirstName,fldLastName,fldMoreAuthor,fldAuthorLinkFlag from TBL_Author_Narrator_Master,TBL_Product_Author_Narrator,TBL_Product_Master where TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and TBL_Product_Author_Narrator.fldProductId=TBL_Product_Master.fldProductId and TBL_Product_Author_Narrator.fldProductId=".$objectid." order by fldProductAuthorNarratorId limit 0,4"; $rs_select_product_author1=$db->ReturnRs($sql_select_product_author1); $author_name1=""; while($row_select_product_author1=mysql_fetch_object($rs_select_product_author1)) { if($row_select_product_author1->fldFirstName!=$default_author_flname) { if(($cookies!=0) || ($cookies==0 && $sessionurl=="")) { if($row_select_product_author1->fldAuthorLinkFlag==1) { $aname=trim($row_select_product_author1->fldFirstName." ".$row_select_product_author1->fldLastName); if($lolhost!=1) $author_href=$serverpath.'/Resources/Authors-and-Narrators/'.add_and_hyphen($aname).'/'.$row_select_product_author1->fldAuthorNarratorId; else $author_href=$teachouthomepage.'/Resources/Authors-and-Narrators/'.add_and_hyphen($aname).'/'.$row_select_product_author1->fldAuthorNarratorId; $auth_href=""; } else { $aname=trim($row_select_product_author1->fldFirstName." ".$row_select_product_author1->fldLastName); $aname=add_and_hyphen($aname); if($lolhost!=1) $auth_href="fldAuthorNarratorId\">"; else $auth_href="fldAuthorNarratorId\">"; } } else { if($lolhost!=1) $auth_href=""; else $auth_href=""; } //if else if($author_name1!='') if($row_select_product_author1->fldLastName!="") $author_name1 .=", ".$auth_href.trim($row_select_product_author1->fldFirstName)." ".trim($row_select_product_author1->fldLastName).""; else $author_name1 .=", ".$auth_href.trim($row_select_product_author1->fldFirstName).""; else if($row_select_product_author1->fldLastName!="") $author_name1 =$auth_href.trim($row_select_product_author1->fldFirstName)." ".trim($row_select_product_author1->fldLastName).""; else $author_name1=$auth_href.trim($row_select_product_author1->fldFirstName).""; if($row_select_product_author1->fldMoreAuthor==1) $more_author=', and more'; }//if }//while //................FETCH AUTHOR FROM TBL_Product_Author........................... $sql_select_product_author=" select TBL_Product_Author_Narrator.fldAuthorNarratorId ,fldFirstName,fldLastName,fldAuthorLinkFlag from TBL_Author_Narrator_Master,TBL_Product_Author_Narrator where TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and TBL_Product_Author_Narrator.fldPrimaryFlag=1 and TBL_Product_Author_Narrator.fldAuthorNarratorFlag=0 and TBL_Product_Author_Narrator.fldProductId=".$objectid; $rs_select_product_author=$db->ReturnRs($sql_select_product_author); $row_select_product_author=mysql_fetch_object($rs_select_product_author); $author_id=$row_select_product_author->fldAuthorNarratorId; if($row_select_product_author->fldLastName!="") $author_name=$row_select_product_author->fldFirstName." ".$row_select_product_author->fldLastName; else $author_name=$row_select_product_author->fldFirstName; if (strcasecmp(strtoupper(trim($author_name)), "ZNA ZNA")==0) $author_name=""; $author_name_title=$author_name; if($author_name!='') { $ahref=""; if(($cookies!=0) || ($cookies==0 && $sessionurl=="")) { if($row_select_product_author->fldAuthorLinkFlag==1) { $aname=trim($row_select_product_author->fldFirstName." ".$row_select_product_author->fldLastName); if($lolhost!=1) $ahref=$serverpath.'/Resources/Authors-and-Narrators/'.add_and_hyphen($aname).'/'.$row_select_product_author->fldAuthorNarratorId; else $ahref=$teachouthomepage.'/Resources/Authors-and-Narrators/'.add_and_hyphen($aname).'/'.$row_select_product_author->fldAuthorNarratorId; $ahref_this=$ahref; $ahref=""; $author_name=$ahref.$author_name.""; } else { $aname=trim($row_select_product_author->fldFirstName." ".$row_select_product_author->fldLastName); if($lolhost!=1) $ahref_this=$serverpath."/Results/Author/".add_and_hyphen($aname).'/'.$row_select_product_author->fldAuthorNarratorId; else $ahref_this=$teachouthomepage."/Results/Author/".add_and_hyphen($aname).'/'.$row_select_product_author->fldAuthorNarratorId; $author_name="".$aname.""; } } else { $aname=trim($row_select_product_author->fldFirstName." ".$row_select_product_author->fldLastName); if($lolhost!=1) $ahref_this=$serverpath."/results.php?stype=a&sid=".$row_select_product_author->fldAuthorNarratorId."&nav=B&$sessionurl"; else $ahref_this=$teachouthomepage."/results.php?stype=a&sid=".$row_select_product_author->fldAuthorNarratorId."&nav=B&$sessionurl"; $author_name="".$aname.""; }//if else }//if //..fetch narrator from TBL_Product_Narrator Table modified by richa on 8 jan 2004.............................................................. $sql_select_product_narrator1=" select TBL_Product_Author_Narrator.fldAuthorNarratorId ,fldFirstName,fldLastName,fldMoreNarrator,fldAuthorLinkFlag from TBL_Author_Narrator_Master,TBL_Product_Author_Narrator,TBL_Product_Master where TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and TBL_Product_Author_Narrator.fldProductId=TBL_Product_Master.fldProductId and TBL_Product_Author_Narrator.fldAuthorNarratorFlag=1 and TBL_Product_Author_Narrator.fldProductId=".$objectid." order by fldProductAuthorNarratorId limit 0,4"; $rs_select_product_narrator1=$db->ReturnRs($sql_select_product_narrator1); $narrator_name1=''; while($row_select_product_narrator1=mysql_fetch_object($rs_select_product_narrator1)) { if($row_select_product_narrator1->fldFirstName!=$default_author_flname) { if(($cookies!=0) || ($cookies==0 && $sessionurl=="")) { if($row_select_product_narrator1->fldAuthorLinkFlag==1) { $nname=trim($row_select_product_narrator1->fldFirstName." ".$row_select_product_narrator1->fldLastName); if($lolhost!=1) $narrator_href=$serverpath.'/Resources/Authors-and-Narrators/'.add_and_hyphen($nname).'/'.$row_select_product_narrator1->fldAuthorNarratorId; else $narrator_href=$teachouthomepage.'/Resources/Authors-and-Narrators/'.add_and_hyphen($nname).'/'.$row_select_product_narrator1->fldAuthorNarratorId; $narrtor_href=""; } else { $nname=trim($row_select_product_narrator1->fldFirstName." ".$row_select_product_narrator1->fldLastName); $nname=add_and_hyphen($nname); if($lolhost!=1) $narrtor_href="fldAuthorNarratorId\">"; else $narrtor_href="fldAuthorNarratorId\">"; } } else { if($lolhost!=1) $narrtor_href=""; else $narrtor_href=""; }//if else if($narrator_name1!="") if($row_select_product_narrator1->fldLastName!="") $narrator_name1 .=", ".$narrtor_href.trim($row_select_product_narrator1->fldFirstName)." ".trim($row_select_product_narrator1->fldLastName).""; else $narrator_name1 .=", ".$narrtor_href.trim($row_select_product_narrator1->fldFirstName).""; else if($row_select_product_narrator1->fldLastName!="") $narrator_name1 =$narrtor_href.trim($row_select_product_narrator1->fldFirstName)." ".trim($row_select_product_narrator1->fldLastName).""; else $narrator_name1 =$narrtor_href.trim($row_select_product_narrator1->fldFirstName).""; if($row_select_product_narrator1->fldMoreNarrator==1) $more_narrator=', and more'; }//if }//while //..fetch narrator from TBL_Product_Narrator Table.............................................................. $sql_select_product_narrator=" select TBL_Product_Author_Narrator.fldAuthorNarratorId ,fldFirstName,fldLastName,fldAuthorLinkFlag from TBL_Author_Narrator_Master,TBL_Product_Author_Narrator where TBL_Author_Narrator_Master.fldAuthorNarratorId=TBL_Product_Author_Narrator.fldAuthorNarratorId and TBL_Product_Author_Narrator.fldPrimaryFlag=1 and TBL_Product_Author_Narrator.fldAuthorNarratorFlag=1 and TBL_Product_Author_Narrator.fldProductId=".$objectid; $rs_select_product_narrator=$db->ReturnRs($sql_select_product_narrator); $row_select_product_narrator=mysql_fetch_object($rs_select_product_narrator); $narrator_id=$row_select_product_narrator->fldAuthorNarratorId; if($row_select_product_narrator->fldLastName!="") $narrator_name=$row_select_product_narrator->fldFirstName." ".$row_select_product_narrator->fldLastName; else $narrator_name=$row_select_product_narrator->fldFirstName; if (strcasecmp(trim($narrator_name), "not applicable")==0) $narrator_name=""; if($narrator_name!='') { $ahref=""; if(($cookies!=0) || ($cookies==0 && $sessionurl=="")) { if($row_select_product_author->fldAuthorLinkFlag==1) { $nname=trim($row_select_product_narrator->fldFirstName." ".$row_select_product_narrator->fldLastName); if($lolhost!=1) $nhref=$serverpath.'/Resources/Authors-and-Narrators/'.add_and_hyphen($nname).'/'.$row_select_product_narrator->fldAuthorNarratorId; else $nhref=$teachouthomepage.'/Resources/Authors-and-Narrators/'.add_and_hyphen($nname).'/'.$row_select_product_narrator->fldAuthorNarratorId; $nhref_this=$nhref; $nhref=""; $narrator_name=$nhref.add_and_hyphen($nname).""; } else { $narrator_name="".$narrator_name.""; $nname=trim($row_select_product_narrator->fldFirstName." ".$row_select_product_narrator->fldLastName); if($lolhost!=1) $nhref_this=$serverpath."/Results/Narrator/".add_and_hyphen($nname).'/'.$row_select_product_narrator->fldAuthorNarratorId; else $nhref_this=$teachouthomepage."/Results/Narrator/".add_and_hyphen($nname).'/'.$row_select_product_narrator->fldAuthorNarratorId; }//ifelse }//if else { if($lolhost!=1) $nhref_this=$serverpath."/results.php?stype=a&sid=".$row_select_product_narrator->fldAuthorNarratorId."&nav=B&$sessionurl"; else $nhref_this=$teachouthomepage."/results.php?stype=a&sid=".$row_select_product_narrator->fldAuthorNarratorId."&nav=B&$sessionurl"; }//if else }//if //................fetch primary publisher from TBL_Product_Publisher table............. $sql_product_publisher="select TBL_Publisher_Retailer_Master.fldPublisherRetailerId,fldPublisherProductVersionId,fldName,fldListeningSyntaxShell,fldWebSiteReview, fldPublisherLinkFlag from TBL_Publisher_Retailer_Master,TBL_Product_Publisher where TBL_Publisher_Retailer_Master.fldPublisherRetailerId=TBL_Product_Publisher.fldPublisherRetailerId and fldPrimaryFlag=1 and fldProductId=".$objectid; $rs_product_publisher=$db->ReturnRs($sql_product_publisher); $row_product_publisher=mysql_fetch_object($rs_product_publisher); $publisher_name=$row_product_publisher->fldName; $publisher_id=$row_product_publisher->fldPublisherRetailerId; if($cookies==0 && $sessionurl!='') { if($lolhost!=1) $publisher_href=""; else $publisher_href=""; } else { if($row_product_publisher->fldPublisherLinkFlag==1) { if($lolhost!=1) $publisher_href=$serverpath.'/Resources/Publishers-and-Retailers/'.add_and_hyphen($publisher_name).'/'.$publisher_id; else $publisher_href=$teachouthomepage.'/Resources/Publishers-and-Retailers/'.add_and_hyphen($publisher_name).'/'.$publisher_id; $publisher_href=""; } else { if($lolhost!=1) $publisher_href=""; else $publisher_href=""; } }//if else //......................................................Secondary Publishers //................fetch primary publisher from TBL_Product_Publisher table............. $sql_product_publisher_secondary="select TBL_Publisher_Retailer_Master.fldPublisherRetailerId,fldName,fldPublisherProductVersionId,fldProductSyntaxShell from TBL_Publisher_Retailer_Master,TBL_Product_Publisher where TBL_Publisher_Retailer_Master.fldPublisherRetailerId=TBL_Product_Publisher.fldPublisherRetailerId and fldPrimaryFlag=0 and fldProductId=".$objectid; $rs_product_publisher_secondary=$db->ReturnRs($sql_product_publisher_secondary); $secondary_pubs=mysql_num_rows($rs_product_publisher_secondary); if($secondary_pubs!=0) { $secondary_pubs_name=""; while($row_product_publisher_secondary=mysql_fetch_row($rs_product_publisher_secondary)) { if($row_product_publisher_secondary[2]!='') { $prodid=$row_product_publisher_secondary[2]; $cnt=0; $cnt=is_alpha($prodid); if($cnt>0)//get product id of this otherver { $select_p="select fldProductId from TBL_Product_Master where fldGenaratedProductId='".$prodid."'"; //print "
select_p::".$select_p; $rs_product_p=$db->ReturnRs($select_p); $row_product_p=mysql_fetch_object($rs_product_p); $cnt1=mysql_num_rows($rs_product_p); if($cnt) $prodid=$row_product_p->fldProductId; else $prodid=0; }//if if(!empty($prodid)) { $select_cat_subcatid1="select fldCatSubCatId from TBL_Product_Category_Detail where fldCatSubCatFlag=0 and fldProductId=".$prodid; $rs_product_catsubcat1=$db->ReturnRs($select_cat_subcatid1); $row_product_catsubcat1=mysql_fetch_object($rs_product_catsubcat1); $cnt=mysql_num_rows($rs_product_catsubcat1); if($cnt>0) { if($row_product_catsubcat1->fldCatSubCatId!="" && $row_product_catsubcat1->fldCatSubCatId!=0) $prodcatid=$row_product_catsubcat1->fldCatSubCatId; else { $select_subcatid="select fldCatSubCatId from TBL_Product_Category_Detail where fldCatSubCatFlag=1 and fldProductId=".$prodid; $rs_product_subcat1=$db->ReturnRs($select_subcatid); $row_product_subcat1=mysql_fetch_object($rs_product_subcat1); $prodsubcatid=$row_product_subcat1->fldCatSubCatId; $select_subcat_cat="select fldCategoryId from TBL_Subcategory_Master where fldSubcategoryId=".$prodsubcatid; $rs_product_subcat_cat1=$db->ReturnRs($select_subcat_cat); $row_product_subcat_cat1=mysql_fetch_object($rs_product_subcat_cat1); $prodcatid=$row_product_subcat_cat1->fldCategoryId; } }//if $publisher_link=generate_productlink($db,$prodid,$prodcatid,$prodsubcatid); } //"productpage.php?cat=1&catid=".$prodcatid."&level=2&subcatid=".$prodsubcatid."&id=".$prodid."&nav=B"; }//if if($publisher_link!="") $pubnames="
".$row_product_publisher_secondary[1].""; else $pubnames=$row_product_publisher_secondary[1]; if($secondary_pubs_name!="") $secondary_pubs_name.=" - ".$pubnames; else $secondary_pubs_name=$pubnames; }//while }//if //............................Customer Rating $sql_cust_rate="select TBL_Product_Customer_Rating.fldProductId,fldRetailerId,fldRating,fldName,fldCompanyURL from TBL_Product_Customer_Rating,TBL_Product_Master,TBL_Publisher_Retailer_Master where TBL_Product_Customer_Rating.fldProductId=TBL_Product_Master.fldProductId and fldPublisherRetailerId=fldRetailerId and TBL_Product_Customer_Rating.fldProductId=".$objectid; $rs_cust_rate=$db->ReturnRs($sql_cust_rate); $rs_cust_rate_cnt=mysql_num_rows($rs_cust_rate); //................................................. //select count Video format $sqlVideoFormatId="select TBL_Format_Master.fldFormatId from TBL_Product_Format_Detail,TBL_Format_Master where fldFormatTypeId=1 and TBL_Product_Format_Detail.fldFormatId=TBL_Format_Master.fldFormatId and TBL_Product_Format_Detail.fldPRoductId=".$objectid; $rs_sqlVideoFormatId=$db->ReturnRs($sqlVideoFormatId); $vcount=mysql_num_rows($rs_sqlVideoFormatId); //Audio format count $sqlAudioFormatId="select TBL_Format_Master.fldFormatId from TBL_Product_Format_Detail,TBL_Format_Master where fldFormatTypeId=0 and TBL_Product_Format_Detail.fldFormatId=TBL_Format_Master.fldFormatId and TBL_Product_Format_Detail.fldPRoductId=".$objectid; $rs_sqlAudioFormatId=$db->ReturnRs($sqlAudioFormatId); $acount=mysql_num_rows($rs_sqlAudioFormatId); //Purchase rental $sql_format1="select fldFormatIcon,fldName,fldProductSyntaxShell,fldRetailerPurchaseRentalProductId,fldGenaratedId,fldNoOfVolumes,fldISBN,TBL_Format_Master.fldFormatId,fldUnit,TBL_Publisher_Retailer_Master.fldPublisherRetailerId,fldBadgeImage from TBL_Product_Format_Detail,TBL_Publisher_Retailer_Master,TBL_Format_Master where TBL_Product_Format_Detail.fldRetailerID =fldPublisherRetailerId and fldRentalFlag=1 and TBL_Format_Master.fldFormatId=TBL_Product_Format_Detail.fldFormatId and TBL_Product_Format_Detail.fldRetailerID=fldPublisherRetailerId and fldProductId=".$objectid." order by fldFormatTypeId,fldOrder"; $rs_format1_rental=$db->ReturnRs($sql_format1); $rcount=mysql_num_rows($rs_format1_rental); $rs_product_format_r=$db->ReturnRs($sql_format1); while($row_format_r=mysql_fetch_object($rs_product_format_r)) { if($format_p!="") $format_p.=", ".$row_format_r->fldFormatName; else $format_p=$row_format_r->fldFormatName; }//while $sql_format="select fldFormatIcon,fldName,fldProductSyntaxShell,fldRetailerPurchaseRentalProductId,fldGenaratedId,fldNoOfVolumes,fldFormatName,fldISBN,TBL_Format_Master.fldFormatId,fldUnit,TBL_Publisher_Retailer_Master.fldPublisherRetailerId,fldPrice,fldSale,fldBadgeImage,fldDiscount,fldListPrice,fldCredit from TBL_Product_Format_Detail,TBL_Publisher_Retailer_Master,TBL_Format_Master where TBL_Product_Format_Detail.fldRetailerID =fldPublisherRetailerId and fldPurchaseFlag=1 and TBL_Format_Master.fldFormatId=TBL_Product_Format_Detail.fldFormatId and TBL_Product_Format_Detail.fldRetailerID=fldPublisherRetailerId and fldSale>=1 and fldProductId=".$objectid." order by fldFormatTypeId,fldOrder"; //echo $sql_format; $rs_format1_purchase=mysql_query($sql_format); /* 10-07-2009 we have changed the order of formats. Audiodownload(AD) not placed on top. We need discount and List price calculations CD to be done before Audiodownloads to display with AD. So I am adding this query repeatition */ $sql_format2forCD="select fldFormatIcon,fldName,fldProductSyntaxShell,fldRetailerPurchaseRentalProductId,fldGenaratedId,fldNoOfVolumes,fldFormatName,fldISBN,TBL_Format_Master.fldFormatId,fldUnit,TBL_Publisher_Retailer_Master.fldPublisherRetailerId,fldPrice,fldSale,fldBadgeImage,fldDiscount,fldListPrice,fldCredit from TBL_Product_Format_Detail,TBL_Publisher_Retailer_Master,TBL_Format_Master where TBL_Product_Format_Detail.fldRetailerID =fldPublisherRetailerId and fldPurchaseFlag=1 and TBL_Format_Master.fldFormatId=TBL_Product_Format_Detail.fldFormatId and TBL_Product_Format_Detail.fldRetailerID=fldPublisherRetailerId and fldProductId=".$objectid." and TBL_Product_Format_Detail.fldFormatId=16 order by fldFormatTypeId,fldOrder"; //echo $sql_format; $rs_format2forCD=$db->ReturnRs($sql_format2forCD); $sql_product_format="select fldFormatIcon,fldName,fldProductSyntaxShell,fldRetailerPurchaseRentalProductId,fldGenaratedId,fldNoOfVolumes,fldFormatName,fldISBN,TBL_Format_Master.fldFormatId,fldUnit,TBL_Publisher_Retailer_Master.fldPublisherRetailerId,fldPrice,fldSale,fldDiscount,fldListPrice,fldBadgeImage from TBL_Product_Format_Detail,TBL_Publisher_Retailer_Master,TBL_Format_Master where TBL_Product_Format_Detail.fldRetailerID =fldPublisherRetailerId and fldPurchaseFlag=1 and TBL_Format_Master.fldFormatId=TBL_Product_Format_Detail.fldFormatId and TBL_Product_Format_Detail.fldRetailerID=fldPublisherRetailerId and fldProductId=".$objectid." order by fldFormatTypeId,fldOrder"; $rs_product_format_p=$db->ReturnRs($sql_product_format); while($row_format_p=mysql_fetch_object($rs_product_format_p)) { if($format_p!="") $format_p.=", ".$row_format_p->fldFormatName; else $format_p=$row_format_p->fldFormatName; }//while //echo $format_p; $pcount=mysql_num_rows($rs_format1_purchase); $arr_format2=array('Podcast','Audio Cassette 2','Audio CD 2','CD-ROM 2','DVD 2','MP3 CD 2','Podcast 2','Podcast 3','Podcast 4','Video Cassette (VHS) 2','Digital Download 2'); //Subscribe Formats $sql_format="select fldFormatIcon,fldName,fldProductSyntaxShell,fldRetailerPurchaseRentalProductId,fldGenaratedId,fldNoOfVolumes,fldFormatName,fldISBN,TBL_Format_2_Master.fldFormatId,fldUnit,TBL_Publisher_Retailer_Master.fldPublisherRetailerId,fldBadgeImage from TBL_Product_Format_2_Detail,TBL_Publisher_Retailer_Master,TBL_Format_2_Master where TBL_Product_Format_2_Detail.fldRetailerID =fldPublisherRetailerId and fldSubscribeFlag=1 and TBL_Format_2_Master.fldFormatId=TBL_Product_Format_2_Detail.fldFormatId and TBL_Product_Format_2_Detail.fldRetailerID=fldPublisherRetailerId and fldProductId=".$objectid." order by fldFormatTypeId,fldOrder"; $rs_format2_purchase=$db->ReturnRs($sql_format); $rs_format2_s=$db->ReturnRs($sql_format); $scount=mysql_num_rows($rs_format2_purchase); while($row_format2_s=mysql_fetch_object($rs_format2_s)) { if(!in_array($row_format2_s->fldFormatName,$arr_format2)) { if($format_p!="") $format_p.=", ".$row_format2_s->fldFormatName; else $format_p=$row_format2_s->fldFormatName; } }//while //format 2 purchase $sql_format="select fldFormatIcon,fldName,fldProductSyntaxShell,fldRetailerPurchaseRentalProductId,fldGenaratedId,fldNoOfVolumes,fldFormatName,fldISBN,TBL_Format_2_Master.fldFormatId,fldUnit,TBL_Publisher_Retailer_Master.fldPublisherRetailerId,fldBadgeImage from TBL_Product_Format_2_Detail,TBL_Publisher_Retailer_Master,TBL_Format_2_Master where TBL_Product_Format_2_Detail.fldRetailerID =fldPublisherRetailerId and fldPurchaseFlag=1 and TBL_Format_2_Master.fldFormatId=TBL_Product_Format_2_Detail.fldFormatId and TBL_Product_Format_2_Detail.fldRetailerID=fldPublisherRetailerId and fldProductId=".$objectid." order by fldFormatTypeId,fldOrder"; $rs_format2_buy=$db->ReturnRs($sql_format); $rs_format2_p=$db->ReturnRs($sql_format); $bcount=mysql_num_rows($rs_format2_buy); while($row_format2_p=mysql_fetch_object($rs_format2_p)) { if(!in_array($row_format2_p->fldFormatName,$arr_format2)) { if($format_p!="") $format_p.=", ".$row_format2_p->fldFormatName; else $format_p=$row_format2_p->fldFormatName; } }//while //format 2 rental $sql_format="select fldFormatIcon,fldName,fldProductSyntaxShell,fldRetailerPurchaseRentalProductId,fldGenaratedId,fldNoOfVolumes,fldFormatName,fldISBN,TBL_Format_2_Master.fldFormatId,fldUnit,TBL_Publisher_Retailer_Master.fldPublisherRetailerId,fldBadgeImage from TBL_Product_Format_2_Detail,TBL_Publisher_Retailer_Master,TBL_Format_2_Master where TBL_Product_Format_2_Detail.fldRetailerID =fldPublisherRetailerId and fldRentalFlag=1 and TBL_Format_2_Master.fldFormatId=TBL_Product_Format_2_Detail.fldFormatId and TBL_Product_Format_2_Detail.fldRetailerID=fldPublisherRetailerId and fldProductId=".$objectid." order by fldFormatTypeId,fldOrder"; $rs_format2_rental=$db->ReturnRs($sql_format); $rs_format2_r=$db->ReturnRs($sql_format); $ren_count=mysql_num_rows($rs_format2_rental); while($row_format2_r=mysql_fetch_object($rs_format2_r)) { if(!in_array($row_format2_r->fldFormatName,$arr_format2)) { if($format_p!="") $format_p.=", ".$row_format2_r->fldFormatName; else $format_p=$row_format2_r->fldFormatName; } }//while /*---------On Monday, May 07, 2012-------------------------*/ $url = $_SERVER["REQUEST_URI"]; $ur = explode('/',$url); if($ur[1] == "testing") $site = $ur[2]; else $site = $ur[1]; $shwVar = ""; if($site == "Catalog" && $row_product->fldFreeFlag==1) { $shwVar = "Free "; } if($site == "Free-Audio-Video") { $shwVar = "Free "; } /*--------------------------------------------------------------*/ if($format_p!="" && $cat!=3 && $cat!=4) $p_formats=" on ".$shwVar.$format_p; else if($format_p!="" && $cat==3) $p_formats=" Audio Book on ".$format_p; if($format_p!="" && $cat==4) $p_formats=" Audiobook on ".$format_p; $select_review="select fldReviewText,fldReviewDate,fldUserName,fldCountryId,fldStateId,fldState,fldRatingPoints,fldFirstName,fldLastName,fldCity,TBL_Review_Rating.fldLOLUserId as ruid,fldReviewFlag,fldReviewTitle from TBL_Review_Rating,TBL_User_Master where TBL_Review_Rating.fldLOLUserId=TBL_User_Master.fldUserId and fldApproveDeclineFlag=1 and fldReviewText!='NULL' and TBL_Review_Rating.fldProductId=".$objectid." AND fldRatingPoints>0 order by fldReviewDate desc"; $select_review; $rs_review=$db->ReturnRs($select_review); $rating_count=mysql_num_rows($rs_review); if(!empty($_SESSION['learnout_userid'])) { $select_review_user="select fldReviewText,fldReviewDate,fldUserName,fldCountryId,fldStateId,fldState,fldRatingPoints,fldFirstName,fldLastName,fldCity,TBL_Review_Rating.fldLOLUserId as ruid,fldReviewFlag,fldReviewTitle from TBL_Review_Rating,TBL_User_Master where TBL_Review_Rating.fldLOLUserId=TBL_User_Master.fldUserId and fldApproveDeclineFlag=1 and fldReviewText<>'NULL' and fldProductId=".$objectid." and TBL_Review_Rating.fldLOLUserId='".$_SESSION['learnout_userid']."' AND fldRatingPoints>0 order by fldReviewDate desc"; $rs_review_user=$db->ReturnRs($select_review_user); $rating_count_user=mysql_num_rows($rs_review_user); } //...................................................................... $sql_rating="select count(fldReviewRatingId) from TBL_Review_Rating where fldApproveDeclineFlag=1 and fldProductId=".$objectid." AND fldRatingPoints>0 "; $rs_rating=$db->ReturnRs($sql_rating); $row_rating=mysql_fetch_row($rs_rating); $rating=$row_rating[0]; //...................................................................... $sql_review_count="select count(fldReviewRatingId),avg(fldRatingPoints) as avarage from TBL_Review_Rating where fldApproveDeclineFlag=1 and fldProductId=".$objectid." AND fldRatingPoints>0 " ; $rs_review_count=$db->ReturnRs($sql_review_count); $row_review_count=mysql_fetch_row($rs_review_count); $num_review_count=mysql_num_rows($rs_review_count); $review_count=$row_review_count[0]; if($num_review_count==0) $avarage_rating = 0; else $avarage_rating=$row_review_count[1]; //Listening Syntax shell of publisher if($row_product->fldListeningSample!="" && $row_product->fldlListeningFormatId!='') { $listen=generate_shell_link($db,$row_product->fldListeningSample,"fldListeningSyntaxShell,fldListeningFormatSampleId",$objectid,$row_product->fldlListeningFormatId,$row_product->fldListeningRetailerId); } if($row_product->fldListeningSample2!="" && $row_product->fldListenimg2_FormatId!='') { $listen2=generate_shell_link($db,$row_product->fldListeningSample2,"fldListeningSyntaxShell1,fldListeningSampleId1",$objectid,$row_product->fldListenimg2_FormatId,$row_product->fldListening1RetailerId); } if($row_product->fldViewingSample!="" && $row_product->fldViewingFormatId) { $view=generate_shell_link($db,$row_product->fldViewingSample,"fldViewingSyntaxShell,fldViewingFormatSampleId",$objectid,$row_product->fldViewingFormatId,$row_product->fldViewingRetailerId); } if($row_product->fldViewingSample2!="" && $row_product->fldViewing2FormatId) { $view2=generate_shell_link($db,$row_product->fldViewingSample2,"fldViewingSyntaxShell1,fldViewingSampleId1",$objectid,$row_product->fldViewing2FormatId,$row_product->fldViewing1RetailerId); } global $maxlength,$navigation; $maxlength=6; $cat=$_GET['cat']; $uri = $_SERVER["REQUEST_URI"]; $free = explode('/',$uri); if($free[1]=='Free-Audio-Downloads') $cat = 6; if($free[1]=='Quick-Learning') $cat = 8; if($cat=="") $cat=1; if($lolhost==1) $homepageurl=$teachouthomepage; $navigation="Home "; switch($cat) { case 1: $navigation.=" Catalog "; $maxlength+=8; if($cookies) $toplevel="Catalog"; else $toplevel="category.php"; $sublevel="subcategory.php"; $podcastpage=0; $productpageimage=""; $class="greylight"; $bottom_image=""; $description_image=""; $list_image="Learn About"; $background="background=\"$serverpath/images/heading_learnabouttext.gif\" align=\"center\" height=\"19\""; $custmsg1="People Who Liked"; if($cat==1){ $custmsg2="Also Liked These Free Titles:"; }else{ $custmsg2="Also Liked:"; } break; case 0: $navigation.=" Podcast Directory "; $maxlength+=18; if($cookies) $toplevel="Podcast-Directory"; else $toplevel="category_podcast.php"; $sublevel="subcategory_podcast.php"; $podcastpage=1; $productpageimage=""; $bottom_image="\"Catalog\""; $description_image=""; $list_image="Podcast Directory"; $background="background=\"$serverpath/images/heading_podcastdirtext.gif\" align=\"center\" height=\"19\""; $custmsg1="People Who Liked"; $custmsg2="Also Liked These Podcasts:"; break; case 2: $navigation.=" Free Audio & Video "; $maxlength+=14; if($cookies) $toplevel="Free-Audio-Video"; else $toplevel="free.php"; $sublevel="subcategory_free.php"; $podcastpage=2; $productpageimage=""; $bottom_image="\"Catalog\""; $description_image=""; $list_image="Free Directory"; $background="background=\"$serverpath/images/hdr_freedir_new.gif\" align=\"center\" height=\"21\""; $custmsg1="People Who Liked"; $custmsg2="Also Liked These Free Titles:"; break; case 3: $navigation.=" Sale Section "; $maxlength+=14; if($cookies) $toplevel="Sale-Section"; else $toplevel="category_sale.php"; $sublevel="subcategory_sale.php"; $cattitleimage="oursalesection.gif"; $alttext="Sale-Section"; $left_category_image="   OUR SALE SECTION"; $productpageimage=""; $podcastpage=3; $bottom_image="\"Catalog\""; $description_image=""; $list_image="Our Sale Section"; $background="background=\"$serverpath/images/heading_salesectiontext.gif\" align=\"center\" height=\"21\""; $custmsg1="Customers Who Bought"; $custmsg2="Also Bought:"; break; case 4: $navigation.=" Downloads "; $maxlength+=14; if($cookies) $toplevel="Downloads"; else $toplevel="downloads_category.php"; $sublevel="downloads_subcategory.php"; $cattitleimage="oursalesection.gif"; $alttext="Downloads"; $left_category_image="   OUR SALE SECTION"; $productpageimage=""; $podcastpage=4; $bottom_image="\"Catalog\""; $description_image=""; $list_image="Audio Downloads"; $background="background=\"$serverpath/images/heading_downloadstext.gif\" align=\"center\" height=\"20\""; $custmsg1="People Who Liked"; $custmsg2="Also Liked:"; break; case 5: $navigation.=" Browse "; $maxlength+=8; if($cookies) $toplevel="Browse"; else $toplevel="category_browse.php"; $sublevel="subcategory_browse.php"; $podcastpage=5; $productpageimage=""; $class="greylight"; $bottom_image="\"Return"; $description_image=""; $list_image="Teach Out Loud"; $background="background=\"$serverpath/images/heading_downloadstext.gif\" align=\"center\" height=\"20\""; $custmsg1="Customers Who Bought"; $custmsg2="Also Bought:"; break; case 6: $navigation.=" Free-Audio-Downloads "; $maxlength+=14; if($cookies) $toplevel="Free-Audio-Downloads"; else $toplevel="free_downloads_category.php"; $sublevel="free_downloads_subcategory.php"; $cattitleimage="oursalesection.gif"; $alttext="Free-Audio-Downloads"; $left_category_image="   OUR SALE SECTION"; $productpageimage=""; $podcastpage=4; $bottom_image="\"Catalog\""; $description_image=""; $list_image="Audio Downloads"; $background="background=\"$serverpath/images/heading_downloadstext.gif\" align=\"center\" height=\"20\""; $custmsg1="People Who Liked"; $custmsg2="Also Liked:"; break; case 7: $navigation.=" Audio Books "; $maxlength+=14; if($cookies) $toplevel="Audio-Books"; else $toplevel="category_audio_books.php"; $sublevel="subcategory_audio_books.php"; $cattitleimage="oursalesection.gif"; $alttext="Audio Books"; $left_category_image="   Audio Books"; $productpageimage=""; $podcastpage=10; $bottom_image="\"Catalog\""; $description_image=""; $list_image="Audio Books"; $background="background=\"$serverpath/images/heading_salesectiontext.gif\" align=\"center\" height=\"21\""; //changes on 19-03-2017 //$custmsg1="Customers Who Bought"; //$custmsg2="Also Bought:"; $custmsg1="People Who Liked"; $custmsg2="Also Liked These Free Titles:"; break; case 8: $navigation.=" Quick Learning "; $maxlength+=14; if($cookies) $toplevel="Quick-Learning"; else $toplevel="category_audio_books.php"; $sublevel="subcategory_audio_books.php"; $cattitleimage="oursalesection.gif"; $alttext="Quick-Learning"; $left_category_image="   Quick Learning"; $productpageimage=""; $podcastpage=11; $bottom_image="\"Catalog\""; $description_image=""; $list_image="Quick Learning"; $background="background=\"$serverpath/images/heading_salesectiontext.gif\" align=\"center\" height=\"21\""; $custmsg1="Customers Who Bought"; $custmsg2="Also Bought:"; break; }//switch if($_GET['catid']!="") { //display navigation bar for category $strcategory="Select fldCategoryId,fldCategoryName from TBL_Category_Master where fldCategoryID=".$_GET['catid']; $rscategory=$db->ReturnRs($strcategory); $row=mysql_fetch_row($rscategory); $maxlength+=strlen($row[1])+3; if($maxlength>40) $catname=striptitle($row[1],20); else $catname=$row[1]; /*Added By Megha on 10-Jan-2012 as per new design requirement. and just comment $catname = $row[1]; to revert it.*/ $catname = $row[1]; $categoryid=$row[0]; if($cookies) { if($lolhost!=1) $cat_href="$serverpath/$toplevel/$category_name"; else $cat_href="$teachouthomepage/$toplevel/$category_name"; } else $cat_href=$serverpath."/$toplevel?cat=$cat&catid=$categoryid&level=0&id=$categoryid&$sessionurl"; $navigation .=" ".$catname." "; }//if if($_GET['subcatid']!='') { $strsubcategory="Select fldSubcategoryId,fldSubcategoryName from TBL_Subcategory_Master where fldSubcategoryID=".$_GET['subcatid'] ; $rssubcategory=$db->ReturnRs($strsubcategory); $rowsubcat=mysql_fetch_row($rssubcategory); $maxlength+=strlen($rowsubcat[0])+3; if($maxlength>60) $scname=striptitle($rowsubcat[1],20); else $scname=$rowsubcat[1]; $subcatid=$rowsubcat[0]; if($cookies) { if($lolhost!=1) $subcat_href="$serverpath/$toplevel/$category_name/$subcategory_name"; else $subcat_href="$teachouthomepage/$toplevel/$category_name/$subcategory_name"; } else { $subcat_href=$serverpath."/$sublevel?cat=$cat&catid=$categoryid&level=1&id=$subcatid&$sessionurl"; } $navigation.=" ".$scname.""; }//if //get product $selectproduct="select fldProductTitle from TBL_Product_Master where fldProductId=".$_GET['id']; $rsproduct1=$db->ReturnRs($selectproduct); $rowproduct1=mysql_fetch_row($rsproduct1); $temptitle=$rowproduct1[0]; $pmaxlength=strlen($rowproduct1[0]); $total=$pmaxlength+$maxlength; if($total>55) { if($maxlength>10 && $maxlength<20) $str=striptitle($temptitle,60); else if($maxlength>20 && $maxlength<30) $str=striptitle($temptitle,50); else if($maxlength>=30 && $maxlength<=40) { if($pmaxlength>38) $str=striptitle($temptitle,28); else $str=striptitle($temptitle,38); } else if($maxlength>40 && $maxlength<50) { if($pmaxlength>13) $str=striptitle($temptitle,13); else $str=$temptitle; } else if($maxlength>50 && $maxlength<60) $str=striptitle($temptitle,20); else if($maxlength>60 && $maxlength<70) $str=striptitle($temptitle,10); else if($maxlength>70 && $maxlength<80) $str=striptitle($temptitle,5); else $str=$temptitle; } else $str=$temptitle; //*Added By Megha on 10-Jan-2012 as per new design requirement. and just comment $str = $rowproduct1[0]; to revert it.*/ $str = $rowproduct1[0]; //if else if($_SESSION['learnout_userid']!='') { $sql_user="select TBL_User_Master.fldVbUserId,fldProductId,fldRatingPoints from TBL_User_Master,TBL_Review_Rating where TBL_User_Master.fldUserId=TBL_Review_Rating.fldLOLUserId and TBL_Review_Rating.fldLOLUserId='".$_SESSION['learnout_userid']."' and fldProductId=".$objectid." AND fldRatingPoints>0"; $rs_user=$db->ReturnRs($sql_user); if(mysql_num_rows($rs_user)==0) { $str_login="$serverpath/addrating_popup.php?id=$objectid&nav=B&$sessionurl"; $str_login1=$str_login; } else { $edit_flag=1; $row=mysql_fetch_array($rs_user); $user_rating=$row['fldRatingPoints']; $str_login_edit="$serverpath/editrating_popup.php?id=$objectid&nav=B&$sessionurl"; if($rating_count_user>0) { $str_login="javascript:fnShowRating(0);"; $str_login1="javascript:fnShowRating(1);"; } else { $str_login=$str_login_edit; $str_login1=$str_login_edit; } } } else { $currurl = $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"]; if($cookies==0 && $sessionurl=="") $str_login="javascript:window.location.href='$s_serverpath/welcome.php?from=4&currurl=$currurl&$sessionurl_temp';"; else $str_login="javascript:window.location.href='$s_serverpath/welcome.php?from=4&currurl=$currurl&$sessionurl';"; $str_login1=$str_login; }//if else $meta_content=($row_product->fldProductTitle); if($author_name!='' && $author_name!="ZNA ZNA") $meta_content.=",".($author_name); if($publisher_name!='') $meta_content.=",".($publisher_name); $cat_subcat_name=get_all_cat_subcat_mame($db,$objectid); $meta_content.=",".$cat_subcat_name; $meta_content.=",".get_all_keyword_cat_subcat($db,$objectid,$catid,$subcatid); $meta_desc=$row_product->fldShortDescription; $meta_desc=strip_tags($meta_desc); $meta_desc=str_replace("\"","\\\"",$meta_desc); $p_formats=str_replace("Digital Download","MP3 Digital Download",$p_formats); if($cat==3 || $cat==4) { $p_formats=str_replace("MP3 Digital Download","MP3 Download",$p_formats); $p_formats=str_replace("Audio CD","CD",$p_formats); $p_formats=str_replace("Audio Cassette","Cassette",$p_formats); } ?> fldFreeAudioBooks == 1) { $printvalue = " on Free Audio Book Download"; }else{ $printvalue = $p_formats; } //mobile condition require_once 'Mobile_Detect.php'; $detect = new Mobile_Detect; if (!$detect->isMobile() || $detect->isTablet() || $detect->version('iPad')) { ?> <? echo $row_product->fldProductTitle; if($row_product->fldFreeCourse==1){echo " Course";}if($row_product->fldFreeDocumentries==1){ if($row_product->fldPublishDate != 0000){?> (<? if(substr($row_product->fldPublishDate,5,2)!="" && substr($row_product->fldPublishDate,5,2)!="00"){echo date("F Y",mktime(0, 0, 0, substr($row_product->fldPublishDate,5,2) , 1, substr($row_product->fldPublishDate,0,4))); }else{ echo substr($row_product->fldPublishDate,0,4);}?>)<?}?><? echo " Documentary"; }if($author_name_title!='' && $author_name_title!="ZNA ZNA"){echo " by ".$author_name_title;} echo $printvalue; if($site=='Podcast-Directory') echo " - Free Podcast Download";?> ReturnRs($strcategory); $row=mysql_fetch_row($rscategory); $catname=remove_sp_chars($row[1]); } if($_GET['subcatid']!='') { $strsubcategory="Select fldSubcategoryId,fldSubcategoryName from TBL_Subcategory_Master where fldSubcategoryID=".$_GET['subcatid'] ; $rssubcategory=$db->ReturnRs($strsubcategory); $rowsubcat=mysql_fetch_row($rssubcategory); $scname=remove_sp_chars($rowsubcat[1]); } ?> "> "> 0"; $rs_sqlprd=$db->ReturnRs($sqlprd); $result=mysql_fetch_row($rs_sqlprd); $item_price=$result[1]; $js_cat=$subcategory_name; $cat_str=str_replace("and","&",$subcategory_name); $cat_str1=str_replace("-"," ",$cat_str); $cat_str2=str_replace("_"," ",$cat_str1); $js_cat=$cat_str2; $js_cat_id=$category_id; $js_subcat_id=$subcategory_id; $js_item_id=stripslashes($objectid); $js_item_name=stripslashes($row_product->fldProductTitle); $js_author_name=$aname; $js_product_image='images/new_product/'.stripslashes($row_product->fldProductImage); $js_product_link=$expath[1]."/".$expath[2]."/".$expath[3]."/".$expath[4]."/".$expath[5]."/".$expath[6]; if(substr($js_product_link, strlen($js_product_link)-1, strlen($js_product_link))=="/") $js_product_link=substr($js_product_link,0, strlen($js_product_link)-1); $js_item_price=sprintf("%02.2f",$item_price); ?> fldPodcastLink!='') { ?> /"> /"> fldLearnDirectFlag==1) { ?> /">

 
ReturnRs($sql_format_names); while($row_fname=mysql_fetch_array($rs_format1)) { $flist.=$row_fname['fldFormatName'].", "; } $flist=substr($flist,0,-2); $flistarr=explode(",",$flist); $cntflist=count($flistarr); $first_string=substr($flist,0,strrpos($flist,",")); $last_string=substr($flist,strrpos($flist,",")); if($cntflist==2) $last_string=str_replace(","," & ",$last_string); else $last_string=str_replace(",",", & ",$last_string); $final_string=$first_string.$last_string; $final_string=str_replace("Audio CD","CD",$final_string); $final_string=str_replace("Audio Cassette","Tape",$final_string); $final_string=str_replace("Digital Download","MP3",$final_string); $final_string=str_replace("Video Cassette (VHS)","VHS",$final_string); $final_string_title=$row_product->fldProductTitle." on ".$final_string; ?>
0 || ($vcount>0 && $pcount>0) || $scount>0 || ($bcount>0 && $row_product->fldFreeFlag!=1)) { include('rentalpurchase.php'); } ?>
fldProductImage,$serverpath.'/'.$pimage.$row_product->fldProductImage,"",95,"","","",$row_product->fldProductTitle.$by.$author_name_title); $iwidth=0; if(file_exists("/images/new_product/".$row_product->fldProductImage)) { if($row_product->fldProductImage!="") { $img=getimagesize($serverpath."/images/new_product/".str_replace(" ","%20",$row_product->fldProductImage)); $iwidth=$img[0]; } } ?> fldProductImage;?>">

fldProductTitle?>

fldProductSubTitle !=""){?>

fldProductSubTitle?>

by '.$author_name.''; } ?>
fldXmlFeedLink!='') { if($row_product->fldDoesNotPlay != '1') { $pv_vedio=get_xml_content("$row_product->fldXmlFeedLink"); }else{ $pv_vedio= ""; } if($pv_vedio=="") { if($row_product->fldDoesNotPlay!= '1') { $other_format=get_xml_content_other("$row_product->fldXmlFeedLink"); }else{ $other_format= ""; } $pfile=str_replace('&','ampersand_in_url',$row_product->fldXmlFeedLink); function getBrowser() { $u_agent = $_SERVER['HTTP_USER_AGENT']; $bname = 'Unknown'; $platform = 'Unknown'; $version= ""; //First get the platform? if (preg_match('/linux/i', $u_agent)) { $platform = 'linux'; } elseif (preg_match('/macintosh|mac os x/i', $u_agent)) { $platform = 'mac'; } elseif (preg_match('/windows|win32/i', $u_agent)) { $platform = 'windows'; } // Next get the name of the useragent yes seperately and for good reason if(preg_match('/MSIE/i',$u_agent) && !preg_match('/Opera/i',$u_agent)) { $bname = 'Internet Explorer'; $ub = "MSIE"; } elseif(preg_match('/Firefox/i',$u_agent)) { $bname = 'Mozilla Firefox'; $ub = "Firefox"; } elseif(preg_match('/Chrome/i',$u_agent)) { $bname = 'Google Chrome'; $ub = "Chrome"; } elseif(preg_match('/Safari/i',$u_agent)) { $bname = 'Apple Safari'; $ub = "Safari"; } elseif(preg_match('/Opera/i',$u_agent)) { $bname = 'Opera'; $ub = "Opera"; } elseif(preg_match('/Netscape/i',$u_agent)) { $bname = 'Netscape'; $ub = "Netscape"; } // finally get the correct version number $known = array('Version', $ub, 'other'); $pattern = '#(?' . join('|', $known) . ')[/ ]+(?[0-9.|a-zA-Z.]*)#'; if (!preg_match_all($pattern, $u_agent, $matches)) { // we have no matching number just continue } // see how many we have $i = count($matches['browser']); if ($i != 1) { //we will have two since we are not using 'other' argument yet //see if version is before or after the name if (strripos($u_agent,"Version") < strripos($u_agent,$ub)){ $version= $matches['version'][0]; } else { $version= $matches['version'][1]; } } else { $version= $matches['version'][0]; } // check if we have a number if ($version==null || $version=="") {$version="?";} return array( 'userAgent' => $u_agent, 'name' => $bname, 'version' => $version, 'platform' => $platform, 'pattern' => $pattern ); } // now try it $ua=getBrowser(); $yourbrowser= "Your browser: " . $ua['name'] . " " . $ua['version'] . " on " .$ua['platform'] . " reports:
" . $ua['userAgent']; if($ua['name'] != "Google Chrome") { if(!empty($other_format) && $row_product->fldDoesNotPlay!=1 ) { echo""; }else{ if($row_product->fldPodcastXMLfeedFlag!=1 && $row_product->fldDoesNotPlay!=1) { require_once 'Mobile_Detect.php'; $detect = new Mobile_Detect; if ($detect->isMobile() || $detect->isTablet() || $detect->version('iPad') ) { echo "fldProductId\">"; }else{ echo "fldProductId\">"; } } } }else{ if(!empty($other_format) && $row_product->fldDoesNotPlay!=1 ) { echo""; }else { if($row_product->fldPodcastXMLfeedFlag!=1 && $row_product->fldDoesNotPlay!=1) { require_once 'Mobile_Detect.php'; $detect = new Mobile_Detect; if ($detect->isMobile() || $detect->isTablet() || $detect->version('iPad') ) { echo "fldProductId\" >"; }else{ echo "fldProductId\" >"; } } } } } else { echo"fldProductId\">"; } ?> fldlListeningFormatId); } $rid=$row_product->fldListeningSample; $url=$listen_link[0]; $hrefl="javascript:winpopup_feature('$url','height=125,width=300,top=140,left=440,status=no')"; $ptitle=str_replace("'","",trim($row_product->fldProductTitle)); $ptitle=str_replace('"','',$ptitle); $ptitle=str_replace('#','hashproblem',$ptitle); require_once 'Mobile_Detect.php'; $detect = new Mobile_Detect; if ($detect->isMobile() || $detect->isTablet() || $detect->version('iPad') ) { $hrefl="http://www.learnoutloud.com/podcaststream/listen.php?url=$url&all=$row_product->fldProductId&title=$ptitle&productid=$row_product->fldProductId"; }else{ $hrefl="http://www.learnoutloud.com/podcaststream/listen.php?url=$url&all=$row_product->fldProductId&title=$ptitle&productid=$row_product->fldProductId"; } if(($listen_link1[0]!='' || $listen_link[0]!='') && ($image!='' || $image2!='')) {?>
isMobile() || $detect->isTablet() || $detect->version('iPad') ) {?>
fldListenimg2_FormatId); } $rid=$row_product->fldListeningSample2; $url1=$listen_link1[0]; $hrefl="javascript:winpopup_feature('$url1','height=125,width=300,top=140,left=440,status=no')"; if($row_product->fldListeningSample2==399) { $ptitle=str_replace("'","",trim($row_product->fldProductTitle)); $ptitle=str_replace('"','',$ptitle); $ptitle=str_replace('#','hashproblem',$ptitle); $hrefl="javascript:podcast_popup('$url',0,'$ptitle')"; } if($listen_link1[0]!='' && $image2!='') { ?>  <?=$format_name2?>
fldViewingFormatId); } $rid=$row_product->fldViewingSample; $url2=str_replace("&","",$view_link[0]); $hrefl="javascript:external_popup('$url2','$formatidv1','$rid','$catid','$subcatid','$objectid','$cat','$uid','1','$level')"; if(($view_link[0]!='' || $view_link1[0]!='') && ($imagev!='' || $imagev2!='')) { ?>
View Sample 140) echo "
";?><?=$format_name3?> fldViewing2FormatId); } $rid=$row_product->fldViewingSample2; $url3=str_replace("&","",$view_link1[0]); $hrefl="javascript:external_popup('$url3','$formatidv2','$rid','$catid','$subcatid','$objectid','$cat','$uid','1','$level')"; if($view_link1[0]!='') { ?>   <?=$format_name4?>
fldembvideo!='') echo '

Video

'.$row_product->fldembvideo.'



'; ?>
fldReview)); $reviewtitle=trim(stripslashes(htmlentities($row_product->fldReviewTitle))); $review=str_replace("'","''",$review); $rate = $row_product->fldAvgRating; if($row_product->fldReview!="") { ?>

LearnOutLoud.com Review

".nl2br($row_product->fldReview).""; ?>


fldReview=="") { ?>

Description

fldLongDescription!="") { ?> fldHTMLFlags; if($HTMLFlag!='') $HTMLFlags=split(",",$HTMLFlag); else $HTMLFlags[1]=0; if($HTMLFlags[1]==0) echo "".nl2br($row_product->fldLongDescription).""; else echo "". $row_product->fldLongDescription.""; ?>


Reviews & Ratings
User Reviews         Rate this title  

fldRatingPoints; $reviewuserid=$row_review->ruid; $reviewflag=$row_review->fldReviewFlag; $reviewtitle=$row_review->fldReviewTitle; $username=$row_review->fldFirstName." ".$row_review->fldLastName; if(trim($username)=='' || $reviewflag!=1) $username=$row_review->fldUserName; $city=$row_review->fldCity; if($row_review->fldStateId!="") { $sql_fetch_state="select fldStateName from TBL_State_Master where fldStateId=".$row_review->fldStateId; $rs_fetch_state=$db->ReturnRs($sql_fetch_state); $row_fetch_state=mysql_fetch_object($rs_fetch_state); $state=$row_fetch_state-> fldStateName ; } else $state=$row_review->fldState; $sql_country="select fldCountryName from TBL_Country_Master where fldCountryId=".$row_review->fldCountryId; $rs_country=$db->ReturnRs($sql_country); $row_country=mysql_fetch_object($rs_country); $country=$row_country->fldCountryName; if($country!='') { $country=str_to_standard($country); } if($state!='') { $state=str_to_standard($state); } if($city!='') { $city=str_to_standard($city); } ?>
fldRatingPoints!="") echo show_image1($row_review->fldRatingPoints); ?>
Reviewer
fldReviewDate,0,10); $YMD=split("-",$d); echo" ";display_month($YMD[1]); echo " ".$YMD[2].", ".$YMD[0]; ?>
fldReviewText) ?>

Edit Review
fldXmlFeedLink!='') {?>

Podcast Episodes

fldDoesNotPlay!=1) { $other_format=get_xml_content_other("$row_product->fldXmlFeedLink"); }else{ $other_format=""; } $pfile=str_replace('&','ampersand_in_url',$row_product->fldXmlFeedLink); $link=str_replace('&','ampersand_in_url',$row_product->fldXmlFeedLink); if(!empty($other_format)) { if($row_product->fldPodcastXMLfeedFlag!=1 && $row_product->fldDoesNotPlay!=1 ) { echo "
fldProductId\" onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('Imagelistenpodcast','','http://www.learnoutloud.com/images/listentothesepodcastsorange2.gif',1);\"> "; } } else { if($row_product->fldPodcastXMLfeedFlag!=1 && $row_product->fldDoesNotPlay!=1) { require_once 'Mobile_Detect.php'; $detect = new Mobile_Detect; if ($detect->isTablet() || $detect->version('iPad') ) { echo "
fldProductId\" onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('Imagelistenpodcast','','http://www.learnoutloud.com/images/listentothesepodcastsorange2.gif',1);\"> "; }else{ echo "
fldProductId\" onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('Imagelistenpodcast','','http://www.learnoutloud.com/images/listentothesepodcastsorange2.gif',1);\"> "; } } } } else { echo"
fldProductId\" onMouseOut=\"MM_swapImgRestore()\" onMouseOver=\"MM_swapImage('Imagewatchpodcast','','http://www.learnoutloud.com/images/watchthisvidcasttext_orange.gif',1);\"> "; } print "
"; if($podcastpage==1) { echo '
If this Podcast isn\'t working, please let us know by emailing us and we will try to fix it ASAP:
'; } echo "
Podcast Feed URL:
"; if (browser_detection( 'browser' )== 'mozilla') { echo "
"; echo ""; echo"
fldXmlFeedLink\" readonly>fldXmlFeedLink');\">
"; } else { echo "
"; echo ""; echo"
fldXmlFeedLink\" readonly>fldXmlFeedLink');\">
"; } if($row_product->fldPodcastLink!='') echo "
 Podcast Website:
fldPodcastLink');\" class=text13blue>".$row_product->fldPodcastLink."

"; if($row_product->fldDoesNotPlay!=1) { show_xml_content_product($row_product->fldXmlFeedLink,$row_product->fldProductId); } } ?>

More Details

    fldPublishDate,0,4)!="0000" && substr($row_product->fldPublishDate,0,4)!="") { ?>
  • Published: fldPublishDate,5,2)!="" && substr($row_product->fldPublishDate,5,2)!="00") echo date("F Y",mktime(0, 0, 0, substr($row_product->fldPublishDate,5,2) , 1, substr($row_product->fldPublishDate,0,4))); else echo substr($row_product->fldPublishDate,0,4); ?>
  • fldOriginalYearOfPublication!=0 && $row_product->fldOriginalYearOfPublication!="") {?>
  • Original Year Of Publication: fldOriginalYearOfPublication; ?>
  • fldNoOfLecture!=0 && $row_product->fldNoOfLecture!="") { ?>
  • Number Of Lectures: fldNoOfLecture; ?>
  • fldLectureTime!=0 && $row_product->fldLectureTime!="") { ?>
  • Lecture Time: fldLectureTime; ?>
  • fldUniversity!="") { ?>
  • University: fldUniversity; ?>
  • LearnOutLoud.com Product ID: fldGenaratedProductId; ?>
ReturnRs($sql_format); $ISBNcount=mysql_num_rows($rs_format1_purchase_format); if($ISBNcount>0) { ?>
Available On
Volumes
ISBN-10
ISBN-13
fldFormatName; if($srow_format->fldFormatName=='Audio Cassette') $formatName = 'Cassette'; if($srow_format->fldFormatName=='Digital Download' || $srow_format->fldFormatName=='Audio Download' ) $formatName = 'Download'; echo str_replace("(VHS)","",$formatName); ?>
fldNoOfVolumes!='' && $srow_format->fldNoOfVolumes!=0) echo $srow_format->fldNoOfVolumes.display_unit($srow_format->fldNoOfVolumes,$srow_format->fldUnit,1); ?>
fldISBN ;?>
fldISBN13 ;?>
"; } ?>

ReturnRs($sql_format_names); while($row_fname=mysql_fetch_array($rs_format1)) { $flist.=$row_fname['fldFormatName'].", "; } $flist=substr($flist,0,-2); $flistarr=explode(",",$flist); $cntflist=count($flistarr); $first_string=substr($flist,0,strrpos($flist,",")); $last_string=substr($flist,strrpos($flist,",")); if($cntflist==2) $last_string=str_replace(","," & ",$last_string); else $last_string=str_replace(",",", & ",$last_string); $final_string=$first_string.$last_string; $final_string=str_replace("Audio CD","CD",$final_string); $final_string=str_replace("Audio Cassette","Tape",$final_string); $final_string=str_replace("Digital Download","MP3",$final_string); $final_string=str_replace("Video Cassette (VHS)","VHS",$final_string); if($final_string=="") echo striptitle($row_product->fldProductTitle,40); else echo striptitle($final_string_title,40); ?>

fldProductImage,$serverpath.'/'.$pimage.$row_product->fldProductImage,"",95,"","","",$row_product->fldProductTitle); $iwidth=0; if(file_exists("/images/new_product/".$row_product->fldProductImage)) { if($row_product->fldProductImage!="") { $img=getimagesize($serverpath."/images/new_product/".str_replace(" ","%20",$row_product->fldProductImage)); $iwidth=$img[0]; } } ?> fldProductImage;?>"> fldProductSubTitle!="") { ?>

fldProductTitle?>

fldProductSubTitle?>

by

0 || ($vcount>0 && $pcount>0) || $scount>0 || ($bcount>0 && $row_product->fldFreeFlag!=1)) { include('rentalpurchase.php'); } ?>
fldLongDescription!="") { ?>

Description


fldHTMLFlags; if($HTMLFlag!='') $HTMLFlags=split(",",$HTMLFlag); else $HTMLFlags[1]=0; if($HTMLFlags[1]==0) echo "".nl2br($row_product->fldLongDescription).""; else echo "". $row_product->fldLongDescription.""; ?>

<? echo $row_product->fldProductTitle; if($row_product->fldFreeCourse==1){echo " Course";}if($row_product->fldFreeDocumentries==1) { if($row_product->fldPublishDate != 0000){?> (<? if(substr($row_product->fldPublishDate,5,2)!="" && substr($row_product->fldPublishDate,5,2)!="00") { echo date("F Y",mktime(0, 0, 0, substr($row_product->fldPublishDate,5,2) , 1, substr($row_product->fldPublishDate,0,4))); }else{ echo substr($row_product->fldPublishDate,0,4); } ?>) <?}?> <? echo " Documentary"; }if($author_name_title!='' && $author_name_title!="ZNA ZNA") {echo " by ".$author_name_title;} echo $printvalue; if($site=='Podcast-Directory') echo " - Free Podcast Download";?> ReturnRs($strcategory); $row=mysql_fetch_row($rscategory); $catname=remove_sp_chars($row[1]); } if($_GET['subcatid']!='') { $strsubcategory="Select fldSubcategoryId,fldSubcategoryName from TBL_Subcategory_Master where fldSubcategoryID=".$_GET['subcatid'] ; $rssubcategory=$db->ReturnRs($strsubcategory); $rowsubcat=mysql_fetch_row($rssubcategory); $scname=remove_sp_chars($rowsubcat[1]); } ?> "> "> 0"; $rs_sqlprd=$db->ReturnRs($sqlprd); $result=mysql_fetch_row($rs_sqlprd); $item_price=$result[1]; $js_cat=$subcategory_name; $cat_str=str_replace("and","&",$subcategory_name); $cat_str1=str_replace("-"," ",$cat_str); $cat_str2=str_replace("_"," ",$cat_str1); $js_cat=$cat_str2; $js_cat_id=$category_id; $js_subcat_id=$subcategory_id; $js_item_id=stripslashes($objectid); $js_item_name=stripslashes($row_product->fldProductTitle); $js_author_name=$aname; $js_product_image='images/new_product/'.stripslashes($row_product->fldProductImage); $js_product_link=$expath[1]."/".$expath[2]."/".$expath[3]."/".$expath[4]."/".$expath[5]."/".$expath[6]; if(substr($js_product_link, strlen($js_product_link)-1, strlen($js_product_link))=="/") $js_product_link=substr($js_product_link,0, strlen($js_product_link)-1); $js_item_price=sprintf("%02.2f",$item_price); ?> fldPodcastLink!='') { ?> /"> /"> fldLearnDirectFlag==1) { ?> /">
location.href='podcast_results.php?fname=$searchtxt';"; } ?>
LOL
 
ReturnRs($sql_format_names); while($row_fname=mysql_fetch_array($rs_format1)) { $flist.=$row_fname['fldFormatName'].", "; } $flist=substr($flist,0,-2); $flistarr=explode(",",$flist); $cntflist=count($flistarr); $first_string=substr($flist,0,strrpos($flist,",")); $last_string=substr($flist,strrpos($flist,",")); if($cntflist==2) $last_string=str_replace(","," & ",$last_string); else $last_string=str_replace(",",", & ",$last_string); $final_string=$first_string.$last_string; $final_string=str_replace("Audio CD","CD",$final_string); $final_string=str_replace("Audio Cassette","Tape",$final_string); $final_string=str_replace("Digital Download","MP3",$final_string); $final_string=str_replace("Video Cassette (VHS)","VHS",$final_string); $final_string_title=$row_product->fldProductTitle." on ".$final_string; ?>

fldProductTitle?>

fldProductSubTitle !=""){?> fldProductSubTitle?>
<?=htmlentities($row_product->fldProductTitle.$by.$author_name_title)?> fldProductImage)) { if($row_product->fldProductImage!="") { $img=getimagesize($serverpath."/images/new_product/".str_replace(" ","%20",$row_product->fldProductImage)); $iwidth=$img[0]; } } ?> fldProductImage;?>">
By  '.$author_name.'
'; } ?> fldXmlFeedLink!='') { if($row_product->fldDoesNotPlay!=1) { $pv_vedio=get_xml_content("$row_product->fldXmlFeedLink"); }else{ $pv_vedio=""; } if($pv_vedio=="") { if($row_product->fldDoesNotPlay!=1) { $other_format=get_xml_content_other("$row_product->fldXmlFeedLink"); }else{ $other_format=""; } $pfile=str_replace('&','ampersand_in_url',$row_product->fldXmlFeedLink); function getBrowser() { $u_agent = $_SERVER['HTTP_USER_AGENT']; $bname = 'Unknown'; $platform = 'Unknown'; $version= ""; //First get the platform? if (preg_match('/linux/i', $u_agent)) { $platform = 'linux'; } elseif (preg_match('/macintosh|mac os x/i', $u_agent)) { $platform = 'mac'; } elseif (preg_match('/windows|win32/i', $u_agent)) { $platform = 'windows'; } // Next get the name of the useragent yes seperately and for good reason if(preg_match('/MSIE/i',$u_agent) && !preg_match('/Opera/i',$u_agent)) { $bname = 'Internet Explorer'; $ub = "MSIE"; } elseif(preg_match('/Firefox/i',$u_agent)) { $bname = 'Mozilla Firefox'; $ub = "Firefox"; } elseif(preg_match('/Chrome/i',$u_agent)) { $bname = 'Google Chrome'; $ub = "Chrome"; } elseif(preg_match('/Safari/i',$u_agent)) { $bname = 'Apple Safari'; $ub = "Safari"; } elseif(preg_match('/Opera/i',$u_agent)) { $bname = 'Opera'; $ub = "Opera"; } elseif(preg_match('/Netscape/i',$u_agent)) { $bname = 'Netscape'; $ub = "Netscape"; } // finally get the correct version number $known = array('Version', $ub, 'other'); $pattern = '#(?' . join('|', $known) . ')[/ ]+(?[0-9.|a-zA-Z.]*)#'; if (!preg_match_all($pattern, $u_agent, $matches)) { // we have no matching number just continue } // see how many we have $i = count($matches['browser']); if ($i != 1) { //we will have two since we are not using 'other' argument yet //see if version is before or after the name if (strripos($u_agent,"Version") < strripos($u_agent,$ub)){ $version= $matches['version'][0]; } else { $version= $matches['version'][1]; } } else { $version= $matches['version'][0]; } // check if we have a number if ($version==null || $version=="") {$version="?";} return array( 'userAgent' => $u_agent, 'name' => $bname, 'version' => $version, 'platform' => $platform, 'pattern' => $pattern ); } // now try it $ua=getBrowser(); $yourbrowser= "Your browser: " . $ua['name'] . " " . $ua['version'] . " on " .$ua['platform'] . " reports:
" . $ua['userAgent']; if($ua['name'] != "Google Chrome") { if(!empty($other_format) && $row_product->fldDoesNotPlay!=1 ) { echo""; }else{ if($row_product->fldPodcastXMLfeedFlag!=1 && $row_product->fldDoesNotPlay!=1) { require_once 'Mobile_Detect.php'; $detect = new Mobile_Detect; if ($detect->isMobile() || $detect->isTablet() || $detect->version('iPad') ) { //echo ""; echo ""; }else{ echo ""; } } } }else{ if(!empty($other_format) && $row_product->fldDoesNotPlay!=1 ) { echo""; }else { if($row_product->fldPodcastXMLfeedFlag!=1 && $row_product->fldDoesNotPlay!=1) { require_once 'Mobile_Detect.php'; $detect = new Mobile_Detect; if ($detect->isMobile() || $detect->isTablet() || $detect->version('iPad') ) { echo ""; //echo ""; }else{ echo ""; } } } } } else { echo""; } ?> fldlListeningFormatId); } $rid=$row_product->fldListeningSample; $url=$listen_link[0]; $hrefl="javascript:winpopup_feature('$url','height=125,width=300,top=140,left=440,status=no')"; $ptitle=str_replace("'","",trim($row_product->fldProductTitle)); $ptitle=str_replace('"','',$ptitle); $ptitle=str_replace('#','hashproblem',$ptitle); require_once 'Mobile_Detect.php'; $detect = new Mobile_Detect; if ($detect->isMobile() || $detect->isTablet() || $detect->version('iPad') ) { $hrefl="http://www.learnoutloud.com/podcaststream/listen_mobile.php?url=$url&all=$row_product->fldProductId&title=$ptitle&productid=$row_product->fldProductId"; }else{ $hrefl="http://www.learnoutloud.com/podcaststream/listen.php?url=$url&all=$row_product->fldProductId&title=$ptitle&productid=$row_product->fldProductId"; } if(($listen_link1[0]!='' || $listen_link[0]!='') && ($image!='' || $image2!='')) {?>
isMobile() || $detect->isTablet() || $detect->version('iPad') ) {?> fldListenimg2_FormatId); } $rid=$row_product->fldListeningSample2; $url1=$listen_link1[0]; $hrefl="javascript:winpopup_feature('$url1','height=125,width=300,top=140,left=440,status=no')"; if($row_product->fldListeningSample2==399) { $ptitle=str_replace("'","",trim($row_product->fldProductTitle)); $ptitle=str_replace('"','',$ptitle); $ptitle=str_replace('#','hashproblem',$ptitle); $hrefl="javascript:podcast_popup('$url',0,'$ptitle')"; } if($listen_link1[0]!='' && $image2!='') { ?>  <?=$format_name2?> fldViewingFormatId); } $rid=$row_product->fldViewingSample; $url2=str_replace("&","",$view_link[0]); $hrefl="javascript:external_popup('$url2','$formatidv1','$rid','$catid','$subcatid','$objectid','$cat','$uid','1','$level')"; if(($view_link[0]!='' || $view_link1[0]!='') && ($imagev!='' || $imagev2!='')) { ?>
View Sample 140) echo "
";?><?=$format_name3?> fldViewing2FormatId); } $rid=$row_product->fldViewingSample2; $url3=str_replace("&","",$view_link1[0]); $hrefl="javascript:external_popup('$url3','$formatidv2','$rid','$catid','$subcatid','$objectid','$cat','$uid','1','$level')"; if($view_link1[0]!='') { ?>   <?=$format_name4?>
fldembvideo!='') { ?>

Video

fldembvideo;?>
0 || ($vcount>0 && $pcount>0) || $scount>0 || ($bcount>0 && $row_product->fldFreeFlag!=1)) { include('rentalpurchase_responsive.php'); } ?>
fldReview)); $reviewtitle=trim(stripslashes(htmlentities($row_product->fldReviewTitle))); $review=str_replace("'","''",$review); $rate = $row_product->fldAvgRating; if($row_product->fldReview!="") { ?>

LearnOutLoud.com Review

".nl2br($row_product->fldReview).""; ?>

fldReview == "") { ?> fldLongDescription!="") { ?>

Description

fldHTMLFlags;?>
fldLongDescription); else echo $row_product->fldLongDescription; ?>

fldXmlFeedLink!='') {?>

Podcast Episodes

"; } if($row_product->fldPodcastLink!='') { echo""; }?> fldDoesNotPlay!=1) { show_xml_content_product_responsive($row_product->fldXmlFeedLink,$row_product->fldProductId); } ?>
ReturnRs($select_subcat); //...................................................................... $select_cat="select fldCatSubCatId,fldCategoryName from TBL_Product_Category_Detail,TBL_Category_Master where TBL_Product_Category_Detail.fldCatSubCatId=TBL_Category_Master.fldCategoryId and fldCatSubCatFlag=0 and fldProductId =".$objectid; $rs_cat=$db->ReturnRs($select_cat); ?>

Podcasts in These Categories

Free Stuff in These Categories

Learn More About

fldCategoryId&".$sessionurl; $url="subcategory.php?level=2&id=$row_subcat->fldCatSubCatId&".$sessionurl; break; case 0: $caturl="category_podcast.php?level=1&catid=$row_subcat->fldCategoryId&".$sessionurl; $url="subcategory_podcast.php?level=2&id=$row_subcat->fldCatSubCatId&".$sessionurl; break; case 2: $caturl="category_free.php?level=1&catid=$row_subcat->fldCategoryId&".$sessionurl; $url="subcategory_free.php?level=2&id=$row_subcat->fldCatSubCatId&".$sessionurl; break; case 3: $caturl="category_sale.php?level=1&catid=$row_subcat->fldCategoryId&".$sessionurl; $url="subcategory_sale.php?level=2&id=$row_subcat->fldCatSubCatId&".$sessionurl; break; case 4: $caturl="downloads_category.php?level=1&catid=$row_subcat->fldCategoryId&".$sessionurl; $url="downloads_subcategory.php?level=2&id=$row_subcat->fldCatSubCatId&".$sessionurl; break; case 5: $caturl="category_browse.php?level=1&catid=$row_subcat->fldCategoryId&".$sessionurl; $url="subcategory_browse.php?level=2&id=$row_subcat->fldCatSubCatId&".$sessionurl; break; case 7: $caturl="category_audio_books.php?level=1&catid=$row_subcat->fldCategoryId&".$sessionurl; $url="subcategory_audio_books.php?level=2&id=$row_subcat->fldCatSubCatId&".$sessionurl; break; } } else { switch($cat) { case 1: $url=$serverpath.'/Catalog/'.add_and_hyphen($row_subcat->fldCategoryName).'/'.add_and_hyphen($row_subcat->fldSubcategoryName); $caturl=$serverpath.'/Catalog/'.add_and_hyphen($row_subcat->fldCategoryName); break; case 0: $url=$serverpath.'/Podcast-Directory/'.add_and_hyphen($row_subcat->fldCategoryName).'/'.add_and_hyphen($row_subcat->fldSubcategoryName); $caturl=$serverpath.'/Podcast-Directory/'.add_and_hyphen($row_subcat->fldCategoryName); break; case 2: $url=$serverpath.'/Free-Audio-Video/'.add_and_hyphen($row_subcat->fldCategoryName).'/'.add_and_hyphen($row_subcat->fldSubcategoryName); $caturl=$serverpath.'/Free-Audio-Video/'.add_and_hyphen($row_subcat->fldCategoryName); break; case 3: $url=$serverpath.'/Sale-Section/'.add_and_hyphen($row_subcat->fldCategoryName).'/'.add_and_hyphen($row_subcat->fldSubcategoryName); $caturl=$serverpath.'/Sale-Section/'.add_and_hyphen($row_subcat->fldCategoryName); break; case 4: $url=$serverpath.'/Downloads/'.add_and_hyphen($row_subcat->fldCategoryName).'/'.add_and_hyphen($row_subcat->fldSubcategoryName); $caturl=$serverpath.'/Downloads/'.add_and_hyphen($row_subcat->fldCategoryName); break; case 5: $url=$teachouthomepage.'/Browse/'.add_and_hyphen($row_subcat->fldCategoryName).'/'.add_and_hyphen($row_subcat->fldSubcategoryName); $caturl=$teachouthomepage.'/Browse/'.add_and_hyphen($row_subcat->fldCategoryName); break; case 7: $url=$serverpath.'/Audio-Books/'.add_and_hyphen($row_subcat->fldCategoryName).'/'.add_and_hyphen($row_subcat->fldSubcategoryName); $caturl=$serverpath.'/Audio-Books/'.add_and_hyphen($row_subcat->fldCategoryName); break; } } ?> fldCatSubCatId&".$sessionurl; break; case 0: $url="category_podcast.php?level=1&catid=$row_cat->fldCatSubCatId&".$sessionurl; break; case 2: $url="category_free.php?level=1&catid=$row_cat->fldCatSubCatId&".$sessionurl; break; case 3: $url="category_sale.php?level=1&catid=$row_cat->fldCatSubCatId&".$sessionurl; break; case 4: $url="downloads_category.php?level=1&catid=$row_cat->fldCatSubCatId&".$sessionurl; break; case 5: $url="category_browse.php?level=1&catid=$row_cat->fldCatSubCatId&".$sessionurl; break; case 7: $caturl="category_audio_books.php?level=1&catid=$row_cat->fldCatSubCatId&".$sessionurl; break; } } else { switch($cat) { case 1: $url=$serverpath.'/Catalog/'.add_and_hyphen($row_cat->fldCategoryName); break; case 0: $url=$serverpath.'/Podcast-Directory/'.add_and_hyphen($row_cat->fldCategoryName); break; case 2: $url=$serverpath.'/Free-Audio-Video/'.add_and_hyphen($row_cat->fldCategoryName); break; case 3: $url=$serverpath.'/Sale-Section/'.add_and_hyphen($row_cat->fldCategoryName); break; case 4: $url=$serverpath.'/Downloads/'.add_and_hyphen($row_cat->fldCategoryName); break; case 5: $url=$teachouthomepage.'/Browse/'.add_and_hyphen($row_cat->fldCategoryName); break; case 7: $url=$serverpath.'/Audio-Books/'.add_and_hyphen($row_cat->fldCategoryName); break; } } ?>

Find More Titles by

This Author :
This Narrator :
This Publisher:

ReturnRs($sql_format_names); while($row_fname=mysql_fetch_array($rs_format1)) { $flist.=$row_fname['fldFormatName'].", "; } $flist=substr($flist,0,-2); $flistarr=explode(",",$flist); $cntflist=count($flistarr); $first_string=substr($flist,0,strrpos($flist,",")); $last_string=substr($flist,strrpos($flist,",")); if($cntflist==2) $last_string=str_replace(","," & ",$last_string); else $last_string=str_replace(",",", & ",$last_string); $final_string=$first_string.$last_string; $final_string=str_replace("Audio CD","CD",$final_string); $final_string=str_replace("Audio Cassette","Tape",$final_string); $final_string=str_replace("Digital Download","MP3",$final_string); $final_string=str_replace("Video Cassette (VHS)","VHS",$final_string); if($final_string=="") echo striptitle($row_product->fldProductTitle,40); else echo striptitle($final_string_title,40); ?>

fldProductImage,$serverpath.'/'.$pimage.$row_product->fldProductImage,"",95,"","","",$row_product->fldProductTitle); $iwidth=0; if(file_exists("/images/new_product/".$row_product->fldProductImage)) { if($row_product->fldProductImage!="") { $img=getimagesize($serverpath."/images/new_product/".str_replace(" ","%20",$row_product->fldProductImage)); $iwidth=$img[0]; } } ?> fldProductImage;?>"> fldProductSubTitle!="") { ?>

fldProductTitle?>

fldProductSubTitle?>

by

0 || ($vcount>0 && $pcount>0) || $scount>0 || ($bcount>0 && $row_product->fldFreeFlag!=1)) { include('rentalpurchase.php'); } ?>
fldLongDescription!="") { ?>

Description


fldHTMLFlags; if($HTMLFlag!='') $HTMLFlags=split(",",$HTMLFlag); else $HTMLFlags[1]=0; if($HTMLFlags[1]==0) echo "".nl2br($row_product->fldLongDescription).""; else echo "". $row_product->fldLongDescription.""; ?>

fldProductTitle); $title=str_replace("'","",$title); $title=str_replace("&","",$title); $title=str_replace("/","",$title); $title=str_replace("\\","",$title); $title=str_replace("?","",$title); $title=str_replace("/","",$title); $title=str_replace("<","",$title); $title=str_replace(">","",$title); $title=str_replace("|","",$title); $title=str_replace("*","",$title); $title=str_replace("#","",$title); $title=str_replace(".","",$title); $title=str_replace(")","",$title); $title=str_replace("(","",$title); $title=str_replace("%","",$title); $title=str_replace("^","",$title); $title=str_replace("+","",$title); $title=str_replace("-","",$title); $title=str_replace("{","",$title); $title=str_replace("}","",$title); $title=str_replace("?","",$title); $username=str_replace("'","",$_SESSION['learnout_username']); $username=str_replace("\"","",$username); function generate_forumlink($db,$forumid) { global $serverpath; global $db; $sql="select title from forum where forumid=".$forumid; $rs=$db->ReturnRs($sql); $row=mysql_fetch_row($rs); if($row[0]!='') { $forum=add_and_hyphen_to_forum($row[0]); return $serverpath."/forums/forum-".$forum.'-'.$forumid;; } else return "#"; } function add_and_hyphen_to_forum($name) { $name=trim($name); $name=str_replace("?","",$name); $name=str_replace("\\","",$name); $name=str_replace("/","",$name); $name=str_replace("%","",$name); $name=str_replace("<","",$name); $name=str_replace(">","",$name); $name=str_replace(".","",$name); $name=str_replace("^","",$name); $name=str_replace("`","",$name); $name=str_replace("!","",$name); $name=str_replace("~","",$name); $cat=str_replace("&","and",$name); $cat=str_replace(" ","-",$cat); $cat=str_replace(",","_",$cat); $cat=str_replace("/","+",$cat); return $cat; } function browser_detection( $which_test ) { // initialize the variables $browser = ''; $dom_browser = ''; // set to lower case to avoid errors $navigator_user_agent = strtolower( $_SERVER['HTTP_USER_AGENT'] ); // run through the main browser possibilities, assign them to the main $browser variable if (stristr($navigator_user_agent, "opera")) { $browser = 'opera'; $dom_browser = true; } elseif (stristr($navigator_user_agent, "msie 4")) { $browser = 'msie4'; $dom_browser = false; } elseif (stristr($navigator_user_agent, "msie")) { $browser = 'msie'; $dom_browser = true; } elseif ((stristr($navigator_user_agent, "konqueror")) || (stristr($navigator_user_agent, "safari"))) { $browser = 'safari'; $dom_browser = true; } elseif (stristr($navigator_user_agent, "gecko")) { $browser = 'mozilla'; $dom_browser = true; } elseif (stristr($navigator_user_agent, "mozilla/4")) { $browser = 'ns4'; $dom_browser = false; } else { $dom_browser = false; $browser = false; } if ( $which_test == 'browser' ) { return $browser; } elseif ( $which_test == 'dom' ) { return $dom_browser; } } ?>    0 and fldProductId=".$latestid." order by fldCatSubcatId limit 0,1 "; $rs=$db->ReturnRs($sql); $cnt=mysql_num_rows($rs); $catsubcat=1; if($cnt==0) { $sql="select fldCatSubcatId from TBL_Product_Category_Detail where fldCatSubcatFlag=0 and fldCatSubcatId<>0 and fldProductId=".$latestid." order by fldCatSubcatId limit 0,1 "; $rs=$db->ReturnRs($sql); $catsubcat=0; } $row=mysql_fetch_row($rs); $catsubcatid=$row[0]; $sql_select="select distinct fldProductId from TBL_Order_Detail"; $order_plist=return_id_list($db,$sql_select); if($catsubcatid!=0) { $sql="select fldProductId from TBL_Product_Category_Detail where fldCatSubcatFlag=$catsubcat and fldCatSubcatId=$catsubcatid and fldProductId in(".$order_plist.") $condition"; $rs=$db->ReturnRs($sql); $rowcount=mysql_num_rows($rs); $i=0; if($rowcount>0) { while($row=mysql_fetch_row($rs)) $productid[$i++]=$row[0]; } $pcount=count($productid); if($pcount>=12) { $indexid=array_rand($productid,12); foreach ($indexid as $key=>$val) { $arrcollIds[]=$productid[$val]; } $indexid=$arrcollIds; $new_indexid=$indexid; if(count($new_indexid)>=1) $impld_indexid=implode(",",$new_indexid); else $impld_indexid=$new_indexid; $id=$indexid[0]; }else { $indexid=array_rand($productid,$pcount); $new_indexid=$productid; if(count($new_indexid)>=1) $impld_indexid=implode(",",$new_indexid); else $impld_indexid=$new_indexid; $id=$indexid[0]; } if(count($indexid)>0) { $latesttitle="select fldProductTitle from TBL_Product_Master where fldProductId=".$latestid; $rst=$db->ReturnRs($latesttitle); $row_latesttitle=mysql_fetch_row($rst); $title=$row_latesttitle[0]; ?>
 "
=1 and TBL_Product_Master.fldProductId IN($impld_indexid) and fldPurchaseFlag=1 and fldPublishFlag=1 and TBL_Format_Master.fldFormatId=TBL_Product_Format_Detail.fldFormatId "; $sql.=" and TBL_Product_Format_Detail.fldFormatId=17" ; $sql.=" and TBL_Product_Format_Detail.fldPrice>0 and TBL_Product_Format_Detail.fldProductId<>$latestid order by RAND() limit 0,6 "; $rs=$db->ReturnRs($sql); $cnt1=mysql_num_rows($rs); $ncntr=0; while($row=mysql_fetch_object($rs)) { $ncntr++; $authorf=trim($row->fldFirstName.' '.$row->fldLastName); if($row->fldFirstName=="ZNA") $authorf=''; else $authorf="by ".$authorf; if($row->fldFormatName!='') $formatf="Format: ".$row->fldFormatName; if($row->fldPrice!='') $price="
Price: $ ".sprintf("%02.2f",$row->fldPrice).""; else if($row->fldPrice=='') $price="
Price: $ 0.00"; $href=generate_productlink($db,$row->fldProductId,"","","",6); $item_list=$row->fldProductId.':'.$row->fldFormatId.':0:1'; if($flag==1) $cart_wishlist=""; else $cart_wishlist="fldProductId','0','$userid','$row->fldFormatId','0','$_GET[s]');\" onMouseOut='MM_swapImgRestore()' onMouseOver=\"MM_swapImage('Image123','','$serverpath/images/but_addtocart_f2.gif',1)\">"; show_suggested_titles2($row->fldProductTitle,$authorf,$formatf,$price,$cart_wishlist,$row->fldProductThumbnailImage,$title,1,$cnt2,$href,$custmsg1,$custmsg2,$ncntr); }//while ?>