{d-m-Y} {H:i}"; function sed_get_otherpages($pid, $cat, $limit) { global $t, $L, $db_pages, $db_users, $sys, $usr, $cfg, $sed_cat, $plu_empty; $pcomments = ($cfg['showcommentsonpage']) ? "" : "&comments=1"; $sql = sed_sql_query("(SELECT p.page_id, p.page_alias, p.page_cat, p.page_title, p.page_desc, p.page_date, p.page_ownerid, p.page_count, p.page_comcount, p.page_thumb, u.user_id, u.user_name, u.user_maingrp, u.user_avatar FROM $db_pages AS p LEFT JOIN $db_users AS u ON u.user_id = p.page_ownerid WHERE p.page_id < ".(int)$pid." AND p.page_state = 0 AND p.page_cat = '".$cat."' ORDER BY p.page_date DESC LIMIT $limit) UNION (SELECT p.page_id, p.page_alias, p.page_cat, p.page_title, p.page_desc, p.page_date, p.page_ownerid, p.page_count, p.page_comcount, p.page_thumb, u.user_id, u.user_name, u.user_maingrp, u.user_avatar FROM $db_pages AS p LEFT JOIN $db_users AS u ON u.user_id = p.page_ownerid WHERE p.page_id > ".(int)$pid." AND p.page_state = 0 AND p.page_cat = '".$cat."' ORDER BY p.page_date DESC LIMIT $limit)"); if (sed_sql_numrows($sql) > 0) { while ($row = sed_sql_fetchassoc($sql)) { if (sed_auth('page', $row['page_cat'], 'R')) { $sys['catcode'] = $row['page_cat']; //new in v175 $row['page_pageurl'] = (empty($row['page_alias'])) ? sed_url("page", "id=".$row['page_id']) : sed_url("page", "al=".$row['page_alias']); $row['page_pageurlcom'] = (empty($row['page_alias'])) ? sed_url("page", "id=".$row['page_id'].$pcomments) : sed_url("page", "al=".$row['page_alias'].$pcomments); $t-> assign(array( "OTHER_PAGES_ROW_URL" => $row['page_pageurl'], "OTHER_PAGES_ROW_ID" => $row['page_id'], "OTHER_PAGES_ROW_CAT" => $row['page_cat'], "OTHER_PAGES_ROW_CATURL" => sed_url('list', 'c='.$row['page_cat']), "OTHER_PAGES_ROW_DESC" => $row['page_desc'], "OTHER_PAGES_ROW_CATTITLE" => $sed_cat[$row['page_cat']]['title'], "OTHER_PAGES_ROW_CATPATH" => sed_build_catpath($row['page_cat'], "%2\$s"), "OTHER_PAGES_ROW_SHORTTITLE" => sed_cutstring($row['page_title'], 50), "OTHER_PAGES_ROW_TITLE" => $row['page_title'], "OTHER_PAGES_ROW_DATE" => sed_build_date($cfg['formatyearmonthday'], $row['page_date'], $cfg['plu_mask_pages_date']), "OTHER_PAGES_ROW_AUTHOR" => sed_cc($row['user_name']), "OTHER_PAGES_ROW_USERURL" => sed_url("users", "m=details&id=".$row['page_ownerid']), "OTHER_PAGES_ROW_USER" => sed_build_user($row['page_ownerid'], sed_cc($row['user_name']), $row['user_maingrp']), "OTHER_PAGES_ROW_COUNT" => $row['page_count'], "OTHER_PAGES_ROW_COMMENTS_URL" => $row['page_pageurlcom'], "OTHER_PAGES_ROW_COMMENTS_COUNT" => $row['page_comcount'], "OTHER_PAGES_ROW_AVATAR" => sed_build_userimage($row['user_avatar']) )); // ------- thumb if (!empty($row['page_thumb'])) { $page_thumbs_array = rtrim($row['page_thumb']); if ($page_thumbs_array[mb_strlen($page_thumbs_array) - 1] == ';') { $page_thumbs_array = mb_substr($page_thumbs_array, 0, -1); } $page_thumbs_array = explode(";", $page_thumbs_array); if (count($page_thumbs_array) > 0) { $t->assign("OTHER_PAGES_ROW_THUMB", $page_thumbs_array[0]); $t->parse("MAIN.OTHER_PAGES.OTHER_PAGES_ROW.OTHER_PAGES_ROW_THUMB"); } else { $t->assign("OTHER_PAGES_ROW_THUMB", sed_cc($row['page_thumb'])); } } // ------- $t->parse("MAIN.OTHER_PAGES.OTHER_PAGES_ROW"); } } $t->parse("MAIN.OTHER_PAGES"); } } sed_get_otherpages($pag['page_id'], $pag['page_cat'], $maxotherpages); ?>