Приветствую, переношу с 9.6 на 9.5 функцию пагинации в личных сообщениях, осталось адаптировать два запроса, мучаюсь, по разному уже пробовал , не получается, прошу вашей помощи.
Вот собственно и запросы:
if( $_GET['folder'] == "outbox" ) {
$lang['pm_from'] = $lang['pm_to'];
$sql = "SELECT SQL_CALC_FOUND_ROWS id, subj, name as user_from, date, pm_read FROM " . USERPREFIX . "_pm LEFT JOIN " . USERPREFIX . "_users ON " . USERPREFIX . "_pm.user=" . USERPREFIX . "_users.user_id WHERE user_from = '{$member_id['name']}' AND folder = 'outbox' ORDER BY date DESC LIMIT " . $cstart . "," . $pm_per_page;
$user_query = "do=pm&folder=outbox";
} else {
$sql = "SELECT SQL_CALC_FOUND_ROWS id, subj, user_from, date, pm_read, reply FROM " . USERPREFIX . "_pm where user = '{$member_id['user_id']}' AND folder = 'inbox' ORDER BY pm_read ASC, date DESC LIMIT " . $cstart . "," . $pm_per_page;
$user_query = "do=pm";
}
if( $_GET[folder] == "outbox" ) {
$lang[pm_from] = $lang[pm_to];
$sql = "SELECT id, text, subj, foto, name as user_from, date, pm_read FROM ".USERPREFIX."_pm LEFT JOIN ".USERPREFIX."_users ON " . USERPREFIX . "_pm.user=" . USERPREFIX . "_users.user_id WHERE user_from = {$member_id[
ame]} AND folder = outbox order by date desc";
$user_query = "do=pm&folder=outbox";
} else {
$sql = "SELECT foto, text, id, subj, user_from, date, pm_read, reply, us.lastdate as lastdate FROM " . USERPREFIX . "_pm, " . USERPREFIX . "_users us where user_from = us.name AND user = {$member_id[user_id]} order by date desc";
$user_query = "do=pm";
}
Заранее спасибо за вашу помощь!
Источник:
dle-faq.pro, DLE