- is what creates the indent
while ($myrow = @mysql_fetch_array($commentlist)) {
$comments = stripslashes($myrow["comment"]);
$comments = str_replace("\n\n",'
Comment posted by ".$myrow["poster"]."
".$myrow["comment"]."
\n";
if ($parent_id){
$indent=$indent+100;
}else{
$indent =$indent;
}
// thread($postId,$isBlog,$isRecipe,$acctId); // run through
// the function again, this is what creates the
// threading effect
}
// echo "
',$comments); $postedate = date('F j, Y g:i a', strtotime($myrow["whattime"])); $posterId = $myrow["userId"]; $getusername = @mysql_query("SELECT username FROM user WHERE userId=$posterId"); while ($gmyrow = @mysql_fetch_array($getusername)) { $postername = $gmyrow['username']; } if ($userId == $submitted || $userId=='468' || $userId == $posterId){ $deletelink = ''; }else{ $deletelink=''; } $truncate=0; if ($userId != $submitted){ $truncate = 1; } //echo $truncate; $mystuff .= '
'.$deletelink.'
'.$comments.'
Comment posted by '.$postername.'
'.$postedate.'
myProfile | myRecipes | myBlog
'; } if (!$myimg){ $myimg = ''; } //$showallarts .=$myimg.''.$photobyname.'\'s Recipe'; //$showallarts .='
Page url: https://recipebox.cdkitchen.com/'.$submitted.'/myrecipes.html
'; $aboutrecipe1 .=$myimg.'
view my recipes';
//
$myrecipes ='Page url: https://recipebox.cdkitchen.com/'.$submitted.'/myrecipes.html
'; // $hitsquery = "SELECT count(idx) as hitcount FROM user_visits where box_visited=".mysql_real_escape_string($submitted).""; $hitsquery = "SELECT hitcount FROM user_hitcount where userId=".mysql_real_escape_string($submitted).""; $hitresult = @mysql_query($hitsquery); while($hitrow = @mysql_fetch_array($hitresult)) { $sitehits = $hitrow[hitcount]; $sitehits = number_format($sitehits, 0, "", ","); //$showallarts .=''.$photobyname.'\'s webpage has been visited '.$sitehits.' times'; // $aboutrecipe .=''.$photobyname.'\'s visits: '.$sitehits.''; } $hitsquery = "SELECT count(idx) as hitcount FROM user_visits where box_visited=".mysql_real_escape_string($submitted)." and section='myrecipes' and postid=$ridx"; $hitresult = @mysql_query($hitsquery); while($hitrow = @mysql_fetch_array($hitresult)) { $sitehits = $hitrow[hitcount]; $sitehits = number_format($sitehits, 0, "", ","); //$showallarts .=''.$photobyname.'\'s webpage has been visited '.$sitehits.' times'; $aboutrecipe ='this recipe viewed '.$sitehits.' times'; } //include("/home/chilidog/public_html/recipebox/mininav.html"); if ($loggedIn==true){ $rec_breadcrumb='
'; } if ($loggedIn == true && $userId == $submitted){ $MyPage =1; $showallarts .='
'; $showallarts .=' recipe box edit/delete recipe add/edit photo
'; } //$showallarts .='
'; if ($userId == $submitted){ $showpublic = ''; }else{ $showpublic='and public=\'T\''; } $q = @mysql_query("SELECT userId,datesub,title,recbody,catId,rbox_user,approved,cdk,cdkadded,photo,fin,public,SUBSTRING(recbody,1,100) as metabrief,description,prep_time,cook_time,total_time,yield,source,source_name,rtype,mid,user_notes,default_image FROM user_recipes where userId = $submitted and idx=$ridx and approved=1 $showpublic limit 1"); $numrowsb=@mysql_num_rows($q); if ($numrowsb == 0){ header ("Location: https://recipebox.cdkitchen.com/"); exit; } $thumb_img_src = 'https://cdn.cdkitchen.com/images/cdksingle.jpg?recipe='.$ridx; while ($q2 = @mysql_fetch_array($q)) { $resultb = @mysql_query("SELECT categoryName,categoryId FROM category where categoryOwner=$submitted and categoryId={$q2['catId']}"); while ($q3 = @mysql_fetch_array($resultb)) { $categoryName = $q3['categoryName']; $categoryId = $q3['categoryId']; } $recbody = $q2['recbody']; $rtype = $q2['rtype']; $public = $q2['public']; $default_image = $q2['default_image']; $mid = $q2['mid']; $rec_description = stripslashes($q2['description']); $user_notes = stripslashes($q2['user_notes']); $cook_time = stripslashes($q2['cook_time']); $prep_time = stripslashes($q2['prep_time']); $total_time = stripslashes($q2['total_time']); $recipe_source = stripslashes($q2['source']); $recipe_source_orig = $recipe_source; $recipe_source_name = stripslashes($q2['source_name']); $recipe_source_name_orig = stripslashes($q2['source_name']); $yield = stripslashes($q2['yield']); $metabrief = $q2['metabrief']; $recbody = str_replace("‰Ûª", '\'', $recbody); $recbody = str_replace("Õ","'",$recbody); $recbody = str_replace("Ò","\"",$recbody); $recbody = str_replace("Ó","\"",$recbody); $recbody = str_replace("Ð",":",$recbody); $recbody = str_replace("Ž","é",$recbody); $recbody = str_replace("Ô","'",$recbody); $recbody = str_replace("¥","
', $recbody); //$recbody = str_replace("<", '<', $recbody); //$recbody = str_replace(">", '>', $recbody); $recbody = str_replace("\n", '
', $recbody); $recbody = str_replace("@", '-at-', $recbody); $recbody = str_replace(".com", '-dot-com', $recbody); $recbody = stripslashes($recbody); $shortbody = implode(' ', array_slice(explode(' ', $recbody), 0, 20)); $pagetitle = $q2['title']; $cdkadded = $q2['cdkadded']; $photodir = substr($submitted, -1); if ($q2['photo'] == 1){ foreach (glob("/home/chilidog/public_html/recipebox/recphoto/".$photodir."/".$ridx."_large.*") as $filename) { $showpic = str_replace('/home/chilidog/public_html/recipebox/recphoto/'.$photodir.'/','',$filename); list($width) = getimagesize($filename); $width=$width*1.5; $thumb_img_src = 'https://recipebox.cdkitchen.com/recphoto/'.$photodir.'/'.$showpic; $photoshow = '
'; } }else{ if ($rtype !=3){ $width=653*1.5; if ($default_image==0){ $photoshow = '
'; }else{ $photodir = substr($submitted, -1); $photoshow = '
'; $thumb_img_src = 'https://recipebox.cdkitchen.com/recphoto/'.$photodir.'/'.$ridx.'_default.png'; } } } $rtoolswords = '
'.$photobyname.'\'s
recipe box
recipe box
'; $rtoolsold = '
RECIPE TOOLS:
'.$aboutrecipe.'
print
save'; $shortbody = strip_tags($shortbody); $shortbody = preg_replace('/\s+/', ' ', $shortbody); $encodetitle = urlencode($pagetitle.' by '.$photobyname.' on CDKitchen.com | '.$shortbody); $encodelink = urlencode($canon); $encodemedia = urlencode($thumb_img_src); $social .='
share this recipe:
'; if ($public == 'F'){ $social=''; } // $showallarts .= '
'.$catrecipenav.''.$social.'
'; $showallarts .= '
'.$catrecipenav.''.$social.'
';
$howlongrec = strlen($recbody);
if ($rec_description){
$rec_description = ''.$rec_description.'
';
}
if ($recipe_source){
if ($recipe_source_name){
$recipe_source = 'Recipe Source: '.$recipe_source_name.''; }else{ $recipe_source = 'Recipe Source: '.$recipe_source.'
'; } } if ($yield){ $yield = 'Yield/Servings:
'; } $cookprep = ' Prep Time: '.$prep_time; $cookprep .= ' Cook Time: '.$cook_time; $cookprep .= ' Total Time: '.$total_time.'
'; $body_cutoff = $howlongrec/2; if ($rtype==2 && $MyPage !=1){ $recbody = substr( $recbody, 0, strrpos( substr( $recbody, 0, $body_cutoff), ' ' ) ); $recbody .='...
see full recipe at: '.$recipe_source_name_orig.'
'; ; } if ($rtype==3){ include "/home/chilidog/public_html/recipebox/include_cdk_recipe.php"; } $h1tag = stripslashes($pagetitle); if ($userId == $submitted){ if ($public=='F'){$visibility = 'Private';}else{$visibility='Public';} $visibility ='Visibility: '.$visibility.'
'; } $showallarts .= $rec_description.''.$photoshow.'Category: '.$categoryName.'
'.$visibility.$yield.$cookprep.''.$recbody.'
'.$recipe_source; // $showallarts .= '
'.$catrecipenav.''.$social.'
';
if ($userId == $submitted){
$showallarts .='My Notes (only you see these): '.$user_notes.''; } } //$showallarts .='
';
//$showallarts .= '';
if ($MyPage !=1){
function curPageURL() {
$pageURL = 'http';
if ($_SERVER["HTTPS"] == "on") {$pageURL .= "s";}
$pageURL .= "://";
if ($_SERVER["SERVER_PORT"] != "80") {
$pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"];
} else {
$pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];
}
return $pageURL;
}
$getthispage = curPageURL();
$getthistitle = stripslashes($pagetitle);
$getthistitle = htmlentities($getthistitle);
$getthistitle = str_replace(" ","+",$getthistitle);
//$showallarts .='Bookmark this recipe in your recipEbox'; //$showallarts .= '
'; } if(1!=1 && !eregi("Googlebot",$_SERVER['HTTP_USER_AGENT'])&&!eregi("yahoo",$_SERVER['HTTP_USER_AGENT']) ){ $showallarts .='
'; } //$showallarts .=''; $showallarts .='
»Printer-Friendly VersionNote: This recipe is part of a user\'s personal recipEbox. It is not part of the CDKitchen collection.
'; //comments $showallarts .='recipe comments
'; $showallarts .=thread($postId,$isBlog,$isRecipe,$submitted,$userId); if ($loggedIn == false){ $showallarts .='add a comment:
';
$showallarts .='
You must log in to comment on this page
'; }else{ $post = $submitted.','.$isBlog.','.$isRecipe.','.$postId.','.$userId; $showallarts .='add a comment:
'; } $showallarts.='
';
//end comment section
/*related recipes*/
function rbox_related_recipes($ridx,$pagetitle) {
$cservememcache = @new Memcache;
@include "/home/chilidog/public_html/mcacheconn.php";
if (!@$cservememcache->connect("$datacip", $datacport)) { @$cservememcache->connect("$datacip", $datacport); }
$cservesetname = 'rbox_related_member_recipe_viewrecipehtmlx-'.$ridx;
$cserve = @$cservememcache->get($cservesetname);
if (!$cserve) {
$aq3next = 'SELECT user_recipes.idx,user_recipes.title as nexttitle,user_recipes.idx as nextlink,user_recipes.userId as userId,rbox_user as relateduser,user_recipes.description,user_recipes.photo,SUBSTRING(user_recipes.recbody,1,200) as nodescript, MATCH (user_recipes.title) AGAINST (\''.addslashes($pagetitle).'\') AS score from user_recipes where idx != '.$ridx.' and user_recipes.public="T" and user_recipes.approved=1 and user_recipes.misc != "VW" and MATCH (user_recipes.title) AGAINST (\''.addslashes($pagetitle).'\') group by user_recipes.title having score > 7 order by score desc,user_recipes.datesub desc limit 5';
//echo "";
$ar3next = @mysql_query($aq3next);
$next_num_rows = @mysql_num_rows($ar3next);
if ($next_num_rows < 2){
}else{
$morerecipes =''; } $showallarts.='
related member recipes
'; //$morerecipes.='- ';
while($arow3next = mysql_fetch_array($ar3next))
{
$nexttitle = ucwords(strtolower(stripslashes($arow3next['nexttitle'])));
$ridxb = $arow3next['idx'];
$nextlink = $arow3next['nextlink'];
$relatedid = $arow3next['userId'];
$hasphoto = $arow3next['photo'];
$nodescript = stripslashes($arow3next['nodescript']);
$rec_description = stripslashes($arow3next['description']);
$relateduser = $arow3next['relateduser'];
if ($hasphoto==1){
$photodir = substr($relatedid, -1);
foreach (glob("/home/chilidog/public_html/recipebox/recphoto/".$photodir2."/".$ridxb."*") as $filename2) {
$showpic2 = str_replace('/home/chilidog/public_html/recipebox/recphoto/'.$photodir2.'/','',$filename2);
$bigpic2 = str_replace('_thumb','_large',$showpic2);
$rbox_recipe_image = '
- '.$nexttitle.'
by '.$relateduser.' ';
}
$morerecipes.=' - '.$nexttitle.'
'.$nexttitle.' ';
//$nextrecipe .= '';
}
$nextrecipe2='';
$nextprev = '
';
}
if (strlen($description) > 3){
$rbox_recipe_blurb = $description;
}else{
$rbox_recipe_blurb = $nodescript;
}
$morerecipes .=''; //$morerecipes .='
view more member recipes
'; } $cserve = $morerecipes; @$cservememcache->set($cservesetname, $cserve, false, 604800); //save it for 60 seconds, uncompressed } //return the array return $cserve; } $morerecipes =rbox_related_recipes($ridx,$pagetitle); $showallarts .=$morerecipes; function rbox_cdk_related_recipes($pagetitle) { $cservememcache = @new Memcache; @include "/home/chilidog/public_html/mcacheconn.php"; if (!@$cservememcache->connect("$datacip", $datacport)) { @$cservememcache->connect("$datacip", $datacport); } $cservesetname = 'rbox_related_cdk_recipe_recipehtmlx-'.$pagetitle; $cserve = @$cservememcache->get($cservesetname); if (!$cserve) { $nextprev=''; $aq3next = 'SELECT cdklinks.title as nexttitle,cdklinks.link2 as nextlink,cdkrecipeseo__recipes1.newimgdir as minilogodir,cdklinks.mid as logomid,cdklinks.is_img as is_img2,MATCH (new_search.s_all) AGAINST (\''.addslashes($pagetitle).'\') AS score from cdklinks,cdkrecipeseo__recipes1,new_search where cdklinks.DB=3 and cdklinks.link2=new_search.link2 and (cdkrecipeseo__recipes1.smalllogo=1 or cdklinks.is_img=1) and cdklinks.mid=cdkrecipeseo__recipes1.mid and MATCH (s_all) AGAINST (\''.addslashes($pagetitle).'\') and cdkrecipeseo__recipes1.noindex3=0 and cdklinks.showmod <=NOW() group by cdklinks.title having score > 7 order by cdklinks.is_img desc,score desc,cdklinks.idx asc limit 10'; //echo $aq3next; $ar3next = mysql_query($aq3next); $next_num_rows = mysql_num_rows($ar3next); if ($next_num_rows < 4){ }else{ $morerecipes ='
related CDKitchen recipes
'; while($arow3next = mysql_fetch_array($ar3next)) { $nexttitle = stripslashes($arow3next['nexttitle']); $logomid = $arow3next['logomid']; $nextlink = $arow3next['nextlink']; $is_img2 = $arow3next['is_img2']; $minilogodir = $arow3next['minilogodir']; if ($is_img2==1){ $qimg2 = "SELECT imgurl as imgurl2 FROM cdkimages where mid=".$logomid." order by prio desc,uploaddate desc limit 1"; $rimg2 = mysql_query($qimg2); while($rowimg2 = mysql_fetch_array($rimg2)) { $nextlinkimg = $rowimg2['imgurl2']; } }else{ $nextlinkimg = 'https://www.cdkitchen.com/recipes/images/sharing/'.$minilogodir.'/'.$logomid.'-small.png'; } //$nextrecipe .= ''.$morerecipes.'
- '.$nextrecipe.''.$nextrecipe2.'
'; $cserve = $nextprev; @$cservememcache->set($cservesetname, $cserve, false, 604800); //save it for 60 seconds, uncompressed } //return the array return $cserve; } } $nextprev =rbox_cdk_related_recipes($pagetitle); $showallarts.=$nextprev; $extraheaders .=''; //$extra_headers_js .= ' '; //$extra_headers_js .=''; //$extra_headers_js .=''; $extraheaders .= ' '; $whatpage = 'userrecipes'; $newpage_title = stripslashes($pagetitle); $metabrief = stripslashes($metabrief); $metabrief = str_replace('"','',$metabrief); $metabrief = preg_replace("'\s+'", ' ', $metabrief); $meta_description = 'Recipe for '.stripslashes($pagetitle).': '.$metabrief; $ugc='yes'; if ($howlongrec > 2000){ $shortpage=0; } $shortpage=0; include($alltemplate); ?>