Тема: Вывод тем форума (WAP/WEB мастеру/Поиск скриптов) Zews (22 Mar 2016 в 23:01) ... Королева (22 Mar 2016 в 23:03) поднятие темы раз в сутки! [i]Добавлено:[/i] на фото замок Zews (22 Mar 2016 в 23:06) Королева, http://dcms-social.ru/obmen/Lichnye_fajly/12115.jpg RuSInet (22 Mar 2016 в 23:13) Обычный вывод тем только стиль добавили Мр. Форум (23 Mar 2016 в 01:12) [red]Тему переместил Админ форума SimptomFD из раздела Помощь мастерам в раздел Поиск скриптов[/red] Dreamer (23 Mar 2016 в 08:43) <? echo \"<div class=\'st_1\'></div>\"; echo \"<div class=\'st_2\'>\"; $k_post=mysql_result(mysql_query(\"SELECT COUNT(*) FROM `forum_t`\"), 0); if ($k_post > 0) { $q=mysql_query(\"SELECT * FROM `forum_t` WHERE `close`=\'0\' ORDER BY `time_create` DESC LIMIT 7\"); while ($them = mysql_fetch_assoc($q)) { $forum=mysql_fetch_assoc(mysql_query(\"SELECT id FROM `forum_f` WHERE `id` = \'$them[id_forum]\' LIMIT 1\")); $razdel=mysql_fetch_assoc(mysql_query(\"SELECT id FROM `forum_r` WHERE `id` = \'$them[id_razdel]\' LIMIT 1\")); $ank=mysql_fetch_assoc(mysql_query(\"SELECT * FROM `user` WHERE `id` = $them[id_user] LIMIT 1\")); $post=mysql_fetch_assoc(mysql_query(\"SELECT * FROM `forum_p` WHERE `id_them` = \'$them[id]\' AND `id_razdel` = \'$razdel[id]\' AND `id_forum` = \'$forum[id]\' ORDER BY `time` DESC LIMIT 1\")); if ($post) { $ank2=mysql_fetch_assoc(mysql_query(\"SELECT * FROM `user` WHERE `id` = $post[id_user] LIMIT 1\")); if ($ank2[\'id\']!=0)$ann = \" » \".user::nick($ank2[\'id\'], 1, 0, 0).\"\"; else $ann = \" » \"; } else{ $ann = null; } echo \'<img src=\"/style/themes/\' . $set[\'set_them\'] . \'/forum/14/them_\' . $them[\'up\'] . $them[\'close\'] . \'.png\" alt=\"\" /> \'; echo \'<a href=\"/forum/\' . $forum[\'id\'] . \'/\' . $razdel[\'id\'] . \'/\' . $them[\'id\'] . \'/\">\' . text($them[\'name\']) . \'</a> <a href=\"/forum/\' . $forum[\'id\'] . \'/\' . $razdel[\'id\'] . \'/\' . $them[\'id\'] . \'/?page=\' . $pageEnd . \'\">(\' . mysql_result(mysql_query(\"SELECT COUNT(*) FROM `forum_p` WHERE `id_forum` = \'$forum[id]\' AND `id_razdel` = \'$razdel[id]\' AND `id_them` = \'$them[id]\'\"),0) . \')</a>\' . $ann .\'<br />\'; } } echo \"</div>\"; ?> Источник: http://www.dcms-social.ru/forum/20/46/61396/