Subversion Repositories eFlore/Applications.del

Rev

Rev 1656 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1656 Rev 1670
Line 367... Line 367...
367 
					'$val = sprintf("CONCAT(IFNULL(vdi.mots_cles_texte,\'\'),IFNULL(vdi.i_mots_cles_texte,\'\')) LIKE %s",
 367 
					'$val = sprintf("CONCAT(IFNULL(vdi.mots_cles_texte,\'\'),IFNULL(vdi.i_mots_cles_texte,\'\')) LIKE %s",
368 
					$db->proteger("%".$val."%"));'),
 368 
					$db->proteger("%".$val."%"));'),
369 
					$db);
 369 
					$db);
370 
				$req['where'][] = '(' . implode(' AND ', $tags) . ')';
 370 
				$req['where'][] = '(' . implode(' AND ', $tags) . ')';
371 
			} else {
 371 
			} else {
372 
				$req['where'][] = sprintf("CONCAT(IFNULL(vdi.mots_cles_texte,\'\'),IFNULL(vdi.i_mots_cles_texte,\'\')) REGEXP %s",
 372 
				$req['where'][] = sprintf("CONCAT(IFNULL(vdi.mots_cles_texte,''),IFNULL(vdi.i_mots_cles_texte,'')) REGEXP %s",
373 
					$db->proteger(implode('|', $p['masque.tag_cel']['OR'])));
 373 
					$db->proteger(implode('|', $p['masque.tag_cel']['OR'])));
374 
			}
 374 
			}
375 
		}
 375 
		}
Line 376... Line 376...
376 
 
 376 
 
Line 462... Line 462...
462 
			$req['where'][] = sprintf("vdi.id_image IN (%s)", $ids);
 462 
			$req['where'][] = sprintf("vdi.id_image IN (%s)", $ids);
463 
		}
 463 
		}
464 
	}
 464 
	}
Line 465... Line 465...
465 
 
 465 
 
466 
	static function getIdImages($p, $req, $db) {
 466 
	static function getIdImages($p, $req, $db) {
467 
		return $db->recupererTous(sprintf(
 467 
		$req = sprintf(
468 
			'SELECT SQL_CALC_FOUND_ROWS id_image' .
 468 
			'SELECT SQL_CALC_FOUND_ROWS id_image' .
469 
			//', dis.moyenne, dis.nb_points, dis.nb_votes' . // debug
 469 
			//', dis.moyenne, dis.nb_points, dis.nb_votes' . // debug
470 
			' FROM v_del_image vdi'.
 470 
			' FROM v_del_image vdi'.
471 
			' %s' . // LEFT JOIN if any
 471 
			' %s' . // LEFT JOIN if any
Line 479... Line 479...
479 
 
 479 
 
Line 480... Line 480...
480 
			$req['groupby'] ? ('GROUP BY ' . implode(', ', array_unique($req['groupby']))) : '',
 480 
			$req['groupby'] ? ('GROUP BY ' . implode(', ', array_unique($req['groupby']))) : '',
Line 481... Line 481...
481 
 
 481 
 
- 
 
 482 
			$req['orderby'],
482 
			$req['orderby'],
 483 
 
Line 483... Line 484...
483 
 
 484 
			$p['navigation.depart'], $p['navigation.limite'], __FILE__ . ':' . __LINE__);
484 
			$p['navigation.depart'], $p['navigation.limite'], __FILE__ . ':' . __LINE__));
 485 
		return $db->recupererTous($req);
485 
	}
 486 
	}