Просмотр файла admin/admin_forum_prune.php

Размер файла: 4.47Kb
  1. <?php
  2. /***************************************************************************
  3. * mides.ru
  4. * -------------------
  5. ***************************************************************************/
  6. define('IN_PHPBB', true);
  7.  
  8. if ( !empty($setmodules) )
  9. {
  10. $filename = basename(__FILE__);
  11.  
  12. return;
  13. }
  14.  
  15. $phpbb_root_path = "./../";
  16. require($phpbb_root_path . 'extension.inc');
  17. require('./pagestart.' . $phpEx);
  18. require($phpbb_root_path . 'includes/prune.'.$phpEx);
  19. require($phpbb_root_path . 'includes/functions_admin.'.$phpEx);
  20.  
  21. if( isset($HTTP_GET_VARS[POST_FORUM_URL]) || isset($HTTP_POST_VARS[POST_FORUM_URL]) )
  22. {
  23. $forum_id = ( isset($HTTP_POST_VARS[POST_FORUM_URL]) ) ? $HTTP_POST_VARS[POST_FORUM_URL] : $HTTP_GET_VARS[POST_FORUM_URL];
  24.  
  25. if( $forum_id == -1 )
  26. {
  27. $forum_sql = '';
  28. }
  29. else
  30. {
  31. $forum_id = intval($forum_id);
  32. $forum_sql = "AND forum_id = $forum_id";
  33. }
  34. }
  35. else
  36. {
  37. $forum_id = '';
  38. $forum_sql = '';
  39. }
  40.  
  41. $sql = "SELECT f.*
  42. FROM " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c
  43. WHERE c.cat_id = f.cat_id
  44. $forum_sql
  45. ORDER BY c.cat_order ASC, f.forum_order ASC";
  46. if( !($result = $db->sql_query($sql)) )
  47. {
  48. message_die(GENERAL_ERROR, 'Could not obtain list of forums for pruning', '', __LINE__, __FILE__, $sql);
  49. }
  50.  
  51. $forum_rows = array();
  52. while( $row = $db->sql_fetchrow($result) )
  53. {
  54. $forum_rows[] = $row;
  55. }
  56.  
  57. if( isset($HTTP_POST_VARS['doprune']) )
  58. {
  59. $prunedays = ( isset($HTTP_POST_VARS['prunedays']) ) ? intval($HTTP_POST_VARS['prunedays']) : 0;
  60.  
  61. $prunedate = time() - ( $prunedays * 86400 );
  62.  
  63. $template->set_filenames(array(
  64. 'body' => 'admin/forum_prune_result_body.tpl')
  65. );
  66.  
  67. for($i = 0; $i < count($forum_rows); $i++)
  68. {
  69. $p_result = prune($forum_rows[$i]['forum_id'], $prunedate);
  70. sync('forum', $forum_rows[$i]['forum_id']);
  71. $row_color = '';
  72. $row_class = ( !($i % 2) ) ? 'row_easy' : 'row_hard';
  73. $template->assign_block_vars('prune_results', array(
  74. 'ROW_COLOR' => '#' . $row_color,
  75. 'ROW_CLASS' => $row_class,
  76. 'FORUM_NAME' => $forum_rows[$i]['forum_name'],
  77. 'FORUM_TOPICS' => $p_result['topics'],
  78. 'FORUM_POSTS' => $p_result['posts'])
  79. );
  80. }
  81.  
  82. $template->assign_vars(array(
  83. "admin_forums" => append_sid("admin_forums.$phpEx"),
  84. "admin_forumauth" => append_sid("admin_forumauth.$phpEx"),
  85. 'L_FORUM_PRUNE' => $lang['Forum_Prune'],
  86. 'L_FORUM' => $lang['Forum'],
  87. 'L_TOPICS_PRUNED' => $lang['Topics_pruned'],
  88. 'L_POSTS_PRUNED' => $lang['Posts_pruned'],
  89. 'L_PRUNE_RESULT' => $lang['Prune_success'])
  90.  
  91. );
  92. }
  93. else
  94. {
  95.  
  96. if( empty($HTTP_POST_VARS[POST_FORUM_URL]) )
  97. {
  98. $template->set_filenames(array(
  99. 'body' => 'admin/forum_prune_select_body.tpl')
  100. );
  101.  
  102. $select_list = '<select name="' . POST_FORUM_URL . '">';
  103. $select_list .= '<option value="-1">' . $lang['All_Forums'] . '</option>';
  104.  
  105. for($i = 0; $i < count($forum_rows); $i++)
  106. {
  107. $select_list .= '<option value="' . $forum_rows[$i]['forum_id'] . '">' . $forum_rows[$i]['forum_name'] . '</option>';
  108. }
  109. $select_list .= '</select>';
  110.  
  111. $template->assign_vars(array(
  112. "admin_forums" => append_sid("admin_forums.$phpEx"),
  113. "admin_forumauth" => append_sid("admin_forumauth.$phpEx"),
  114.  
  115. 'L_FORUM_PRUNE' => $lang['Forum_Prune'],
  116. 'L_SELECT_FORUM' => $lang['Select_a_Forum'],
  117. 'L_LOOK_UP' => $lang['Look_up_Forum'],
  118.  
  119. 'S_FORUMPRUNE_ACTION' => append_sid("admin_forum_prune.$phpEx"),
  120. 'S_FORUMS_SELECT' => $select_list)
  121. );
  122. }
  123. else
  124. {
  125. $forum_id = intval($HTTP_POST_VARS[POST_FORUM_URL]);
  126.  
  127. $template->set_filenames(array(
  128. 'body' => 'admin/forum_prune_body.tpl')
  129. );
  130.  
  131. $forum_name = ( $forum_id == -1 ) ? $lang['All_Forums'] : $forum_rows[0]['forum_name'];
  132.  
  133. $prune_data = $lang['Prune_topics_not_posted'] . " ";
  134. $prune_data .= '<input class="post" type="text" name="prunedays" size="4"> ' . $lang['Days'];
  135.  
  136. $hidden_input = '<input type="hidden" name="' . POST_FORUM_URL . '" value="' . $forum_id . '" />';
  137.  
  138. $template->assign_vars(array(
  139. "admin_forumauth" => append_sid("admin_forumauth.$phpEx"),
  140. "admin_forums" => append_sid("admin_forums.$phpEx"),
  141.  
  142. 'FORUM_NAME' => $forum_name,
  143.  
  144. 'L_FORUM' => $lang['Forum'],
  145. 'L_FORUM_PRUNE' => $lang['Forum_Prune'],
  146. 'L_FORUM_PRUNE_EXPLAIN' => $lang['Forum_Prune_explain'],
  147. 'L_DO_PRUNE' => $lang['Do_Prune'],
  148.  
  149. 'S_FORUMPRUNE_ACTION' => append_sid("admin_forum_prune.$phpEx"),
  150. 'S_PRUNE_DATA' => $prune_data,
  151. 'S_HIDDEN_VARS' => $hidden_input)
  152. );
  153. }
  154. }
  155.  
  156. $template->pparse('body');
  157.  
  158. include('./page_footer_admin.'.$phpEx);
  159.  
  160. ?>