* @copyright Copyright (c) 2002-2015, Oliver Georgi * @license http://opensource.org/licenses/GPL-2.0 GNU GPL-2 * @link http://www.phpwcms.de * **/ // ---------------------------------------------------------------- // obligate check for phpwcms constants if (!defined('PHPWCMS_ROOT')) { die("You Cannot Access This Script Directly, Have a Nice Day."); } // ---------------------------------------------------------------- // recipe $content['recipe'] = array(); $content['recipe']['preparation'] = slweg($_POST['recipe_preparation']); $content['recipe']['calorificvalue'] = intval($_POST['recipe_calorificvalue']); $content['recipe']['calorificvalue_add'] = slweg($_POST['recipe_calorificvalue_add']); $content['recipe']['ingredients'] = clean_slweg($_POST['recipe_ingredients']); $content['recipe']['time'] = intval($_POST['recipe_time']); $content['recipe']['time_add'] = slweg($_POST['recipe_time_add']); $content['recipe']['category'] = clean_slweg($_POST['recipe_category']); $content['recipe']['severity'] = intval($_POST['recipe_severity']); $content['recipe']['template'] = clean_slweg($_POST['recipe_template']); if ($content['recipe']['severity'] < 1) { $content['recipe']['severity'] = 1; } elseif ($content['recipe']['severity'] > 5) { $content['recipe']['severity'] = 5; } $content['recipe']['category'] = convertStringToArray($content['recipe']['category']); $content['recipe']['category'] = implode(', ', $content['recipe']['category']); $content['recipe_search'] = optimizeForSearch($content['recipe']['preparation'], $content['recipe']['ingredients'], $content['recipe']['calorificvalue_add'], $content['recipe']['time_add'], $content['recipe']['category']);
function listRecipes($alt = NULL) { global $_getVar; $order_by = array(); /* $recipecat = trim($recipecat); if($recipecat == '') { return listRecipeCategories( array( 'LISTCAT'=> array() ) ); } */ $sql = "SELECT * FROM " . DB_PREPEND . "phpwcms_articlecontent "; $sql .= "INNER JOIN " . DB_PREPEND . "phpwcms_article ON "; $sql .= DB_PREPEND . "phpwcms_article.article_id = " . DB_PREPEND . "phpwcms_articlecontent.acontent_aid "; $sql .= "WHERE acontent_type=26 AND acontent_visible = 1 "; $sql .= "AND acontent_trash = 0 AND "; if (!empty($_getVar['recipecat'])) { $sql .= "acontent_text LIKE '%" . aporeplace($_getVar['recipecat']) . "%' AND "; } if (!empty($_getVar['recipecal']) && intval($_getVar['recipecal'])) { $_getVar['recipecal'] = intval($_getVar['recipecal']); switch ($_getVar['recipecal']) { //bis 400 kcal case 1: $sql .= "( SUBSTRING(acontent_alink, 3) / 4.1868) <= 400 AND "; $order_by[] = 'acontent_alink'; break; //400 bis 600 kcal //400 bis 600 kcal case 2: $sql .= "( SUBSTRING(acontent_alink, 3) / 4.1868) > 400 AND "; $sql .= "( SUBSTRING(acontent_alink, 3) / 4.1868) <= 600 AND "; $order_by[] = 'acontent_alink'; break; //über 600 kcal //über 600 kcal case 3: $sql .= "( SUBSTRING(acontent_alink, 3) / 4.1868) > 600 AND "; $order_by[] = 'acontent_alink'; break; } } if (!empty($_getVar['recipetime']) && intval($_getVar['recipetime'])) { $_getVar['recipetime'] = intval($_getVar['recipetime']); switch ($_getVar['recipetime']) { //bis 20 Min. case 1: $sql .= "( SUBSTRING(acontent_media, 3) * 1) <= 20 AND "; $order_by[] = 'acontent_media'; break; //20 bis 40 Min. //20 bis 40 Min. case 2: $sql .= "( SUBSTRING(acontent_media, 3) * 1) > 20 AND "; $sql .= "( SUBSTRING(acontent_media, 3) * 1) <= 40 AND "; $order_by[] = 'acontent_media'; break; //über 40 Min. //über 40 Min. case 3: $sql .= "( SUBSTRING(acontent_media, 3) * 1) > 40 AND "; $order_by[] = 'acontent_media'; break; } } if (!empty($_getVar['recipetext'])) { $text = optimizeForSearch(rawurldecode($_getVar['recipetext'])); $text = str_replace(array('UPDATE', 'INSERT', 'SELECT', 'FROM', 'DROP', 'CREATE', "'"), '', $text); $text = convertStringToArray($text, ' '); $t = array(); $sql .= '( '; foreach ($text as $value) { $t[] = '( CONCAT(acontent_newsletter, ' . DB_PREPEND . "phpwcms_article.article_title, acontent_title) LIKE '%" . aporeplace($value) . "%' )"; } $sql .= implode(' AND ', $t) . ' ) AND '; } $order_by[] = 'article_title'; $sql .= DB_PREPEND . "phpwcms_article.article_deleted=0 "; if (!PREVIEW_MODE) { $sql .= 'AND '; $sql .= DB_PREPEND . "phpwcms_article.article_begin < NOW() AND "; $sql .= DB_PREPEND . "phpwcms_article.article_end > NOW() "; } $sql .= 'ORDER BY ' . implode(', ', $order_by); $result = _dbQuery($sql); $result_listing = ''; if (is_array($result) && count($result)) { $articles = array(); foreach ($result as $value) { $value['article_image'] = unserialize($value['article_image']); $articles[$value['article_id']] = $value; } $result_listing = list_articles_summary($articles); } return $result_listing; }