Пример #1
0
 * @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']);
Пример #2
0
 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;
 }