$rr = $db->query('SELECT id, date, title, short_story, SUBSTRING_INDEX(category,",",1) as category, alt_name, flag FROM '.PREFIX .'_post where approve="1" ORDER by RAND() LIMIT 0,3');
заменить на:
$rr = $db->query('SELECT id, date, title, short_story, SUBSTRING_INDEX(category,",",1) as category, alt_name, flag FROM '.PREFIX .'_post where approve="1" AND category='120' ORDER by RAND() LIMIT 0,3');
Случайная новость
в Запросы на создание модификаций
Опубликовано:
$rr = $db->query('SELECT id, date, title, short_story, SUBSTRING_INDEX(category,",",1) as category, alt_name, flag FROM '.PREFIX .'_post where approve="1" ORDER by RAND() LIMIT 0,3');заменить на:$rr = $db->query('SELECT id, date, title, short_story, SUBSTRING_INDEX(category,",",1) as category, alt_name, flag FROM '.PREFIX .'_post where approve="1" AND category='120' ORDER by RAND() LIMIT 0,3');где 120 - id нужной вам категории.