>
>
>
>
>
>
topic_of_month.php
<?php $base_url="../"; include "top.inc.php"; ?> <?php $month_array = array( '01' => 'Январь', '02' => 'Февраль', '03' => 'Март', '04' => 'Апрель', '05' => 'Май', '06' => 'Июнь', '07' => 'Июль', '08' => 'Август', '09' => 'Сентябрь', '10' => 'Октябрь', '11' => 'Ноябрь', '12' => 'Декабрь'); ?> <div align="center"> <form method="GET"> <select name="year"> <?php for ($year = 2006; $year <= date('Y'); $year++) { ?> <option value="<?php echo $year; ?>" <?php if ($_GET['year'] == $year ) echo 'selected'; ?>><?php echo $year; ?></option> <?php } ?> </select> <select name="month"> <?php foreach ($month_array as $num => $month) { ?> <option value="<?php echo $num; ?>" <?php if ($_GET['month'] == $num ) echo 'selected'; ?>><?php echo $month; ?></option> <?php } ?> </select> <input type="submit" name="submit" value="Вывести" /> </form> </div> <table width="90%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#cdcbc9"> <tr> <td height="30" align="center" valign="top" style="background:#84969f url(img/forum_top_fon.gif) top repeat-x" colspan="8"><strong id="white">Тема месяца</strong></td> </tr> <tr> <td height="30" align="center" valign="top"><strong>Дата</strong></td> <td height="30" align="center" valign="top"><strong>Тема</strong></td> <td height="30" align="center" valign="top"><strong>Форум</strong></td> <td height="30" align="center" valign="top"><strong>Пользователь</strong></td> <td height="30" align="center" valign="top"><strong><a href="?stype=1&year=<?php echo $_GET['year']; ?>&month=<?php echo $_GET['month']; ?>">Просмотров</a></strong></td> <td height="30" align="center" valign="top"><strong><a href="?stype=2&year=<?php echo $_GET['year']; ?>&month=<?php echo $_GET['month']; ?>">Участников</a></strong></td> <td height="30" align="center" valign="top"><strong><a href="?stype=3&year=<?php echo $_GET['year']; ?>&month=<?php echo $_GET['month']; ?>">Постов</a></strong></td> <td height="30" align="center" valign="top"><strong><a href="?stype=4&year=<?php echo $_GET['year']; ?>&month=<?php echo $_GET['month']; ?>">Рейтинг</a></strong></td> </tr> <?php $ofs = intval($_GET['ofs']); $pap = 25; $_GET['stype'] = intval( $_GET['stype'] ); switch ( $_GET['stype'] ) { case 1: $sql_order = "order by t1.views desc"; break; case 2: $sql_order = "order by unique_users desc"; break; case 3: $sql_order = "order by post_count desc"; break; case 4: $sql_order = "order by rating desc"; break; default: $sql_order = ''; break; } if ( $_GET['month'] == '' ) { $m = date("m"); $y = date("Y"); if ($m != 12) { $m1 = $m + 1; $y1 = $y; } else { $m = '01'; $y1 = $y + 1; } } else { $m = $_GET['month']; $y = $_GET['year']; if ($m != 12) { $m1 = $m + 1; $y1 = $y; } else { $m1 = '01'; $y1 = $y + 1; } } $date_begin = "{$y}-{$m}-01"; $date_end = "{$y1}-{$m1}-01"; $views = end( sqlval("select sum(views) from articl where id=id_parent and data between '{$date_begin}' and '{$date_end}'") ); $writers = end(sqlval("select count( DISTINCT `id_author`) from articl where data between '{$date_begin}' and '{$date_end}'")); $posts = end(sqlval("select count(*) from articl where data between '{$date_begin}' and '{$date_end}'")); $result = sql( "select sql_calc_found_rows t1.id, t1.tema, t1.data, t3.name uname, t4.id fid, t4.name fname, t1.views, count( t1.id ) post_count, count( distinct t2.`id_author` ) unique_users, t1.views / {$views} * 0.4 + count( t1.id ) / {$posts} * 0.8 + count( distinct t2.`id_author` ) / {$writers} * 1.2 rating from articl t1, articl t2, user t3, forum t4 where t1.id_forum <> 17 and t1.id_forum <> 20 and t1.id_forum <> 19 and t1.id_forum <> 11 and t1.id_forum <> 1 and t1.id_forum <> 32 and t1.id_forum <> 25 and t1.id_forum <> 18 and t1.`id` = t2.id_parent and t1.id = t1.id_parent and t1.data between '{$date_begin}' and '{$date_end}' and t1.id_author = t3.id and t1.id_forum = t4.id group by t1.id {$sql_order} limit $ofs, $pap" ); $num_rows = sqlval("SELECT FOUND_ROWS()"); while ( $row = sqlget( $result ) ) { ?> <tr> <td valign="top" bgcolor="#FFFFFF"> <?php echo $row['data']; ?> </td> <td valign="top" bgcolor="#FFFFFF"> <a href="forum_read.php?f=<?php echo $row['fid']; ?>&id=<?php echo $row['id']; ?>"><?php echo $row['tema']; ?></a> </td> <td valign="top" bgcolor="#FFFFFF"> <a href="forum_list.php?f=<?php echo $row['fid']; ?>"><?php echo $row['fname']; ?></a> </td> <td valign="top" bgcolor="#FFFFFF"> <a href="../user_info.php?login_user=<?php echo $row['uname']; ?>"><?php echo $row['uname']; ?></a> </td> <td valign="top" bgcolor="#FFFFFF"> <?php echo $row['views']; ?> </td> <td valign="top" bgcolor="#FFFFFF"> <?php echo $row['unique_users']; ?> </td> <td valign="top" bgcolor="#FFFFFF"> <?php echo $row['post_count']; ?> </td> <td valign="top" bgcolor="#FFFFFF"> <?php echo $row['rating']; ?> </td> <?php } ?> </table> <?php if ( $num_rows[0] > $pap ) { echo '<div align="center">Страницы:'; (empty( $_GET['page'] )) ? $page = 1 : $page = (int) $_GET['page']; list_all( $num_rows[0], "?year={$_GET['year']}&month={$_GET['month']}&stype={$_GET['stype']}", 8, $page, $pap, "ofs", 1 ); echo '</div>'; } ?> <?php require("../inc/bottom2.inc"); ?>
/forum/
..
2026-10-02
img
2013-04-27
jquery.arcticmodal-0.3
2014-09-26
_forum_read.php
2016-12-06
37 .
action.php
2017-02-01
2 .
ban.php
2016-12-06
2 .
basket_list.php
2016-12-06
3 .
basket_list_thems.php
2016-12-06
4 .
basket_read.php
2016-12-06
14 .
bbf.js
2016-12-06
4 .
close_ins.php
2016-12-06
730
close_tema.php
2016-12-06
1 .
del_ins.php
2016-12-06
6 .
del_ins_all.php
2016-12-06
3 .
del_tema.php
2016-12-06
2 .
dobavlenie.gif
2016-12-06
1 .
doska.php
2017-02-13
22 .
edit_articl.php
2021-09-02
3 .
edit_articl.php~
2019-03-20
3 .
edit_articl_back.php
2019-01-22
3 .
forum_image.php
2016-12-06
377
forum_list.php
2026-10-01
21 .
forum_list.php.bak.intl
2026-10-01
21 .
forum_list.php~
2022-08-25
21 .
forum_new_tema.php
2019-02-25
15 .
forum_news.php
2017-02-14
7 .
forum_read.php
2024-01-25
59 .
forum_read.php~
2022-08-25
59 .
forum_read.tpl
2016-12-06
30 .
forum_read_old.php
2016-12-06
37 .
forum_read_old2.php
2026-10-01
59 .
forum_read_old555551.php
2026-10-01
60 .
forum_read_test.php
2019-01-17
65 .
forum_respect.php
2017-08-18
4 .
forum_reyting.php
2016-12-06
949
forum_rss.php
2017-02-20
2 .
forum_rss_all.php
2019-03-12
2 .
forum_rss_theme.php
2017-02-20
2 .
forum_rss_utf.php
2019-03-12
2 .
forum_rss_utf_yandex.php
2019-03-12
2 .
forum_search.gif
2016-12-06
1 .
forum_search.php
2016-12-06
3 .
forum_sql.php
2017-02-10
42 .
forum_sql_new.php
2026-05-25
50 .
forum_sql_new.php~
2021-03-29
51 .
forum_sql_new_back.php
2019-03-12
47 .
forum_sql_old.php
2016-12-06
13 .
forum_widget_new.php
2017-02-21
2 .
img_forum.gif
2016-12-06
1 .
img_view.php
2016-12-06
398
index.php
2023-09-05
12 .
index.php~
2022-08-25
12 .
ins_oplata_for_user.php
2016-12-06
2 .
insert_pass.php
2016-12-06
1 .
kn_activ_temy.gif
2016-12-06
2 .
kn_doska.gif
2016-12-06
2 .
logout.php
2016-12-06
342
menu.inc.php
2020-02-19
4 .
moder_send.php
2017-09-05
2 .
neprochteni.gif
2016-12-06
1 .
net-tem.gif
2016-12-06
327
new.gif
2016-12-06
516
new_tema.inc.php
2024-03-14
29 .
new_tema.inc.php~
2021-01-14
29 .
new_tema.inc_back.php
2021-01-14
36 .
new_tema.php
2017-02-20
2 .
new_tema2.inc.php
2024-03-22
36 .
new_tema2.inc.php~
2024-03-20
35 .
new_vote.inc.php
2019-04-03
7 .
new_vote.inc_back.php
2019-01-23
6 .
new_vote.inc_test.php
2019-03-20
6 .
new_vote.php
2019-03-20
2 .
new_vote_test.php
2023-09-05
2 .
new_vote_test.php~
2019-03-20
2 .
newopros.gif
2016-12-06
2 .
newtopic.gif
2016-12-06
2 .
otpis.php
2017-02-20
549
package.xml
2016-12-06
1 .
package2.xml
2016-12-06
2 .
panelbar.inc.php
2016-12-06
2 .
peremest.php
2016-12-06
788
peremest_in_tema.php
2018-10-29
6 .
peremest_in_tema_ins.php
2019-01-23
2 .
peremest_ins.php
2016-12-06
763
pravila.gif
2016-12-06
1 .
pravila.php
2019-12-09
16 .
preview.php
2016-12-06
7 .
prochitano.gif
2016-12-06
1 .
repair_articl.php
2016-12-06
550
respect.php
2019-01-24
8 .
search.php
2019-06-07
13 .
statistic.php
2016-12-06
3 .
statistika_img.gif
2016-12-06
2 .
stopwords.php
2016-12-06
907
template.php
2017-01-31
23 .
top.inc.php
2024-01-24
2 .
top.inc.php~
2023-12-22
2 .
topic.php
2016-12-06
63 .
topic_of_month.php
2016-12-06
6 .
user_foto
1970-01-01
user_online.php
2017-09-04
668
view_post.php
2019-03-05
37 .
vote.php
2016-12-06
1 .
/forum
1
2
3
..
