- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
PREPARE `@pr_statement` FROM "
SELECT `torrents_full`.`torrent_id`,`torrents_full`.`torrent_tracker`,
`torrents_full`.`torrent_href`,`torrents_full`.`torrent_name`,`torrents_full`.`torrent_author`,`torrents_full`.`torrent_files`,
`torrents_full`.`torrent_img`,`torrents_full`.`torrent_size`,`torrents_full`.`torrent_info`,`torrents_full`.`torrent_date`,
`torrents_full`.`user_name`,`torrents_full`.`user_class`,`torrents_full`.`user_href`,? AS `count` FROM
(SELECT `torrents`.`torrent_id`,`torrents`.`torrent_tracker`,
`torrents`.`torrent_href`,`torrents`.`torrent_name`,`torrents`.`torrent_author`,`torrents`.`torrent_files`,
`torrents`.`torrent_img`,`torrents`.`torrent_size`,`torrents`.`torrent_info`,`torrents`.`torrent_date`,
`users`.`user_name`,`users`.`user_class`,`users`.`user_href`
FROM `torrents` LEFT JOIN `users` ON `users`.`user_id` = `torrents`.`torrent_author`
WHERE `torrents`.`torrent_tracker` IN (?,1,2,3,4,5,6,7) AND (MATCH(`torrents`.`torrent_name`) AGAINST(?)
OR `torrents`.`torrent_name` LIKE ?)) as `torrents_full`
WHERE `torrents_full`.`torrent_name` LIKE ? ORDER BY `torrents_full`.`torrent_date` LIMIT 50";
SET @torr_tracker = `torr_tracker`;
SET @torr_fullsearch = `torr_fullsearch`;
SET @torr_search = `torr_search`;
EXECUTE `@pr_statement` USING @torr_count,@torr_tracker,@torr_fullsearch,@torr_search,@torr_search;
DEALLOCATE PREPARE `@pr_statement`;
guest 28.10.2009 21:51 # −2
Sadie 29.10.2009 07:46 # 0
ну ладно... подскажу... говнокод где-то тут
AND (MATCH(`torrents`.`torrent_name`) AGAINST(?)
OR `torrents`.`torrent_name` LIKE ?)) as `torrents_full`
WHERE `torrents_full`.`torrent_name` LIKE ? ORDER BY
Sadie 29.10.2009 07:47 # 0