Subversion Repositories eFlore/Applications.del

Rev

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

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