(5 фев 2013, 23:06) (0/0)
[0]
PlayME,
Код который я написал выше,будит выводить темы всем и авторизованным и неавторизованным.
(5 фев 2013, 22:48) (0/0)
[0]
Вот
[code]<?$req = mysql_query(\"SELECT * FROM `forum` WHERE `type` = \'t\' AND `close`!=\'1\' ORDER BY `time` DESC LIMIT 10\"
;
while ($arr = mysql_fetch_array($req)) {
$q3 = mysql_query(\"select `id`, `refid`, `text` from `forum` where type=\'r\' and id=\'\" . $arr[\'refid\'] . \"\'\";
$razd = mysql_fetch_array($q3);
$q4 = mysql_query(\"select `id`, `refid`, `text` from `forum` where type=\'f\' and id=\'\" . $razd[\'refid\'] . \"\'\";
$frm = mysql_fetch_array($q4);
$nikuser = mysql_query(\"SELECT `from`, `time` FROM `forum` WHERE `type` = \'m\' AND `close` != \'1\' AND `refid` = \'\" . $arr[\'id\'] . \"\'ORDER BY time DESC\";
$colmes1 = mysql_num_rows($nikuser);
$cpg = ceil($colmes1 / $kmess);
$nam = mysql_fetch_array($nikuser);
echo is_integer($i / 2) ? \'<div class=\"list1\">\' : \'<div class=\"list2\">\';
echo \'<img src=\"../images/\' . ($arr[\'edit\'] == 1 ? \'tz\' : \'np\') . \'.gif\" alt=\"\"/>\';
if ($arr[\'realid\'] == 1)
echo \' <img src=\"../images/rate.gif\" alt=\"\"/>\';
echo \' <a href=\"/forum/index.php?id=\' . $arr[\'id\'] . ($cpg > 1 && $_SESSION[\'uppost\'] ? \'&clip&page=\' . $cpg : \'\') . \'\">\' . $arr[\'text\'] . \'</a> [\' . $colmes1 . \']\';
if ($cpg > 1)
echo \' <a href=\"/forum/index.php?id=\' . $arr[\'id\'] . ($_SESSION[\'uppost\'] ? \'\' : \'&clip&page=\' . $cpg) . \'\">>></a>\';
echo \'<br/><div class=\"sub\"><a href=\"/forum/index.php?id=\' . $razd[\'id\'] . \'\">\' . $frm[\'text\'] . \' / \' . $razd[\'text\'] . \'</a><br />\';
echo $arr[\'from\'];
if (!empty ($nam[\'from\'])) {
echo \' / \' . $nam[\'from\'];
}
echo \' <font color=\"#777777\">\' . date(\"d.m.y / H:i\", $nam[\'time\']) . \'</font>\';
echo \'</div></div>\';
$i++;
}?>[/code]
[code]<?$req = mysql_query(\"SELECT * FROM `forum` WHERE `type` = \'t\' AND `close`!=\'1\' ORDER BY `time` DESC LIMIT 10\"
;while ($arr = mysql_fetch_array($req)) {
$q3 = mysql_query(\"select `id`, `refid`, `text` from `forum` where type=\'r\' and id=\'\" . $arr[\'refid\'] . \"\'\"
;$razd = mysql_fetch_array($q3);
$q4 = mysql_query(\"select `id`, `refid`, `text` from `forum` where type=\'f\' and id=\'\" . $razd[\'refid\'] . \"\'\"
;$frm = mysql_fetch_array($q4);
$nikuser = mysql_query(\"SELECT `from`, `time` FROM `forum` WHERE `type` = \'m\' AND `close` != \'1\' AND `refid` = \'\" . $arr[\'id\'] . \"\'ORDER BY time DESC\"
;$colmes1 = mysql_num_rows($nikuser);
$cpg = ceil($colmes1 / $kmess);
$nam = mysql_fetch_array($nikuser);
echo is_integer($i / 2) ? \'<div class=\"list1\">\' : \'<div class=\"list2\">\';
echo \'<img src=\"../images/\' . ($arr[\'edit\'] == 1 ? \'tz\' : \'np\') . \'.gif\" alt=\"\"/>\';
if ($arr[\'realid\'] == 1)
echo \' <img src=\"../images/rate.gif\" alt=\"\"/>\';
echo \' <a href=\"/forum/index.php?id=\' . $arr[\'id\'] . ($cpg > 1 && $_SESSION[\'uppost\'] ? \'&clip&page=\' . $cpg : \'\') . \'\">\' . $arr[\'text\'] . \'</a> [\' . $colmes1 . \']\';
if ($cpg > 1)
echo \' <a href=\"/forum/index.php?id=\' . $arr[\'id\'] . ($_SESSION[\'uppost\'] ? \'\' : \'&clip&page=\' . $cpg) . \'\">>></a>\';
echo \'<br/><div class=\"sub\"><a href=\"/forum/index.php?id=\' . $razd[\'id\'] . \'\">\' . $frm[\'text\'] . \' / \' . $razd[\'text\'] . \'</a><br />\';
echo $arr[\'from\'];
if (!empty ($nam[\'from\'])) {
echo \' / \' . $nam[\'from\'];
}
echo \' <font color=\"#777777\">\' . date(\"d.m.y / H:i\", $nam[\'time\']) . \'</font>\';
echo \'</div></div>\';
$i++;
}?>[/code]
(5 фев 2013, 22:20) (0/0)
[0]
Открою сикрет,который недавно нарыл))В форуме есть файл непрочитанного,в нём есть вывод 10 последних тем для неавторизованных,берёте этот код,ставите на главную и меняете 10 на то число,которое нужно 
- 1 из 1
