Verzeichnisstruktur phpBB-3.2.0


Veröffentlicht
06.01.2017

So funktioniert es

Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück

Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis.
Auf den Verzeichnisnamen klicken, dies zeigt nur das Verzeichnis mit Inhalt an
      (Beispiel Datei-Icons)

Auf das Icon klicken um den Quellcode anzuzeigen

acp_reasons.php

Zuletzt modifiziert: 09.10.2024, 12:52 - Dateigröße: 12.01 KiB


 001  <?php
 002  /**
 003  *
 004  * This file is part of the phpBB Forum Software package.
 005  *
 006  * @copyright (c) phpBB Limited <https://www.phpbb.com>
 007  * @license GNU General Public License, version 2 (GPL-2.0)
 008  *
 009  * For full copyright and license information, please see
 010  * the docs/CREDITS.txt file.
 011  *
 012  */
 013   
 014  /**
 015  * @ignore
 016  */
 017  if (!defined('IN_PHPBB'))
 018  {
 019      exit;
 020  }
 021   
 022  class acp_reasons
 023  {
 024      var $u_action;
 025   
 026      function main($id, $mode)
 027      {
 028          global $db, $user, $template;
 029          global $request, $phpbb_log;
 030   
 031          $user->add_lang(array('mcp', 'acp/posting'));
 032   
 033          // Set up general vars
 034          $action = $request->variable('action', '');
 035          $submit = (isset($_POST['submit'])) ? true : false;
 036          $reason_id = $request->variable('id', 0);
 037   
 038          $this->tpl_name = 'acp_reasons';
 039          $this->page_title = 'ACP_REASONS';
 040   
 041          $form_name = 'acp_reason';
 042          add_form_key('acp_reason');
 043   
 044          $error = array();
 045   
 046          switch ($action)
 047          {
 048              case 'add':
 049              case 'edit':
 050   
 051                  $reason_row = array(
 052                      'reason_title'            => $request->variable('reason_title', '', true),
 053                      'reason_description'    => $request->variable('reason_description', '', true),
 054                  );
 055   
 056                  if ($submit)
 057                  {
 058                      if (!check_form_key($form_name))
 059                      {
 060                          $error[] = $user->lang['FORM_INVALID'];
 061                      }
 062                      // Reason specified?
 063                      if (!$reason_row['reason_title'] || !$reason_row['reason_description'])
 064                      {
 065                          $error[] = $user->lang['NO_REASON_INFO'];
 066                      }
 067   
 068                      $check_double = ($action == 'add') ? true : false;
 069   
 070                      if ($action == 'edit')
 071                      {
 072                          $sql = 'SELECT reason_title
 073                              FROM ' . REPORTS_REASONS_TABLE . "
 074                              WHERE reason_id = $reason_id";
 075                          $result = $db->sql_query($sql);
 076                          $row = $db->sql_fetchrow($result);
 077                          $db->sql_freeresult($result);
 078   
 079                          if (strtolower($row['reason_title']) == 'other' || strtolower($reason_row['reason_title']) == 'other')
 080                          {
 081                              $reason_row['reason_title'] = 'other';
 082                          }
 083   
 084                          if ($row['reason_title'] != $reason_row['reason_title'])
 085                          {
 086                              $check_double = true;
 087                          }
 088                      }
 089   
 090                      // Check for same reason if adding it...
 091                      if ($check_double)
 092                      {
 093                          $sql = 'SELECT reason_id
 094                              FROM ' . REPORTS_REASONS_TABLE . "
 095                              WHERE reason_title = '" . $db->sql_escape($reason_row['reason_title']) . "'";
 096                          $result = $db->sql_query($sql);
 097                          $row = $db->sql_fetchrow($result);
 098                          $db->sql_freeresult($result);
 099   
 100                          if ($row || ($action == 'add' && strtolower($reason_row['reason_title']) == 'other'))
 101                          {
 102                              $error[] = $user->lang['REASON_ALREADY_EXIST'];
 103                          }
 104                      }
 105   
 106                      if (!sizeof($error))
 107                      {
 108                          // New reason?
 109                          if ($action == 'add')
 110                          {
 111                              // Get new order...
 112                              $sql = 'SELECT MAX(reason_order) as max_reason_order
 113                                  FROM ' . REPORTS_REASONS_TABLE;
 114                              $result = $db->sql_query($sql);
 115                              $max_order = (int) $db->sql_fetchfield('max_reason_order');
 116                              $db->sql_freeresult($result);
 117   
 118                              $sql_ary = array(
 119                                  'reason_title'            => (string) $reason_row['reason_title'],
 120                                  'reason_description'    => (string) $reason_row['reason_description'],
 121                                  'reason_order'            => $max_order + 1
 122                              );
 123   
 124                              $db->sql_query('INSERT INTO ' . REPORTS_REASONS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));
 125   
 126                              $log = 'ADDED';
 127                          }
 128                          else if ($reason_id)
 129                          {
 130                              $sql_ary = array(
 131                                  'reason_title'            => (string) $reason_row['reason_title'],
 132                                  'reason_description'    => (string) $reason_row['reason_description'],
 133                              );
 134   
 135                              $db->sql_query('UPDATE ' . REPORTS_REASONS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
 136                                  WHERE reason_id = ' . $reason_id);
 137   
 138                              $log = 'UPDATED';
 139                          }
 140   
 141                          $phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_REASON_' . $log, false, array($reason_row['reason_title']));
 142                          trigger_error($user->lang['REASON_' . $log] . adm_back_link($this->u_action));
 143                      }
 144                  }
 145                  else if ($reason_id)
 146                  {
 147                      $sql = 'SELECT *
 148                          FROM ' . REPORTS_REASONS_TABLE . '
 149                          WHERE reason_id = ' . $reason_id;
 150                      $result = $db->sql_query($sql);
 151                      $reason_row = $db->sql_fetchrow($result);
 152                      $db->sql_freeresult($result);
 153   
 154                      if (!$reason_row)
 155                      {
 156                          trigger_error($user->lang['NO_REASON'] . adm_back_link($this->u_action), E_USER_WARNING);
 157                      }
 158                  }
 159   
 160                  $l_title = ($action == 'edit') ? 'EDIT' : 'ADD';
 161   
 162                  $translated = false;
 163   
 164                  // If the reason is defined within the language file, we will use the localized version, else just use the database entry...
 165                  if (isset($user->lang['report_reasons']['TITLE'][strtoupper($reason_row['reason_title'])]) && isset($user->lang['report_reasons']['DESCRIPTION'][strtoupper($reason_row['reason_title'])]))
 166                  {
 167                      $translated = true;
 168                  }
 169   
 170                  $template->assign_vars(array(
 171                      'L_TITLE'        => $user->lang['REASON_' . $l_title],
 172                      'U_ACTION'        => $this->u_action . "&amp;id=$reason_id&amp;action=$action",
 173                      'U_BACK'        => $this->u_action,
 174                      'ERROR_MSG'        => (sizeof($error)) ? implode('<br />', $error) : '',
 175   
 176                      'REASON_TITLE'            => $reason_row['reason_title'],
 177                      'REASON_DESCRIPTION'    => $reason_row['reason_description'],
 178   
 179                      'TRANSLATED_TITLE'        => ($translated) ? $user->lang['report_reasons']['TITLE'][strtoupper($reason_row['reason_title'])] : '',
 180                      'TRANSLATED_DESCRIPTION'=> ($translated) ? $user->lang['report_reasons']['DESCRIPTION'][strtoupper($reason_row['reason_title'])] : '',
 181   
 182                      'S_AVAILABLE_TITLES'    => implode($user->lang['COMMA_SEPARATOR'], array_map('htmlspecialchars', array_keys($user->lang['report_reasons']['TITLE']))),
 183                      'S_EDIT_REASON'            => true,
 184                      'S_TRANSLATED'            => $translated,
 185                      'S_ERROR'                => (sizeof($error)) ? true : false,
 186                      )
 187                  );
 188   
 189                  return;
 190              break;
 191   
 192              case 'delete':
 193   
 194                  $sql = 'SELECT *
 195                      FROM ' . REPORTS_REASONS_TABLE . '
 196                      WHERE reason_id = ' . $reason_id;
 197                  $result = $db->sql_query($sql);
 198                  $reason_row = $db->sql_fetchrow($result);
 199                  $db->sql_freeresult($result);
 200   
 201                  if (!$reason_row)
 202                  {
 203                      trigger_error($user->lang['NO_REASON'] . adm_back_link($this->u_action), E_USER_WARNING);
 204                  }
 205   
 206                  if (strtolower($reason_row['reason_title']) == 'other')
 207                  {
 208                      trigger_error($user->lang['NO_REMOVE_DEFAULT_REASON'] . adm_back_link($this->u_action), E_USER_WARNING);
 209                  }
 210   
 211                  // Let the deletion be confirmed...
 212                  if (confirm_box(true))
 213                  {
 214                      $sql = 'SELECT reason_id
 215                          FROM ' . REPORTS_REASONS_TABLE . "
 216                          WHERE LOWER(reason_title) = 'other'";
 217                      $result = $db->sql_query($sql);
 218                      $other_reason_id = (int) $db->sql_fetchfield('reason_id');
 219                      $db->sql_freeresult($result);
 220   
 221                      switch ($db->get_sql_layer())
 222                      {
 223                          // The ugly one!
 224                          case 'mysqli':
 225                          case 'mysql4':
 226                          case 'mysql':
 227                              // Change the reports using this reason to 'other'
 228                              $sql = 'UPDATE ' . REPORTS_TABLE . '
 229                                  SET reason_id = ' . $other_reason_id . ", report_text = CONCAT('" . $db->sql_escape($reason_row['reason_description']) . "\n\n', report_text)
 230                                  WHERE reason_id = $reason_id";
 231                          break;
 232   
 233                          // Standard? What's that?
 234                          case 'mssql_odbc':
 235                          case 'mssqlnative':
 236                              // Change the reports using this reason to 'other'
 237                              $sql = "DECLARE @ptrval binary(16)
 238   
 239                                      SELECT @ptrval = TEXTPTR(report_text)
 240                                          FROM " . REPORTS_TABLE . "
 241                                      WHERE reason_id = " . $reason_id . "
 242   
 243                                      UPDATETEXT " . REPORTS_TABLE . ".report_text @ptrval 0 0 '" . $db->sql_escape($reason_row['reason_description']) . "\n\n'
 244   
 245                                      UPDATE " . REPORTS_TABLE . '
 246                                          SET reason_id = ' . $other_reason_id . "
 247                                      WHERE reason_id = $reason_id";
 248                          break;
 249   
 250                          // Teh standard
 251                          case 'postgres':
 252                          case 'oracle':
 253                          case 'sqlite3':
 254                              // Change the reports using this reason to 'other'
 255                              $sql = 'UPDATE ' . REPORTS_TABLE . '
 256                                  SET reason_id = ' . $other_reason_id . ", report_text = '" . $db->sql_escape($reason_row['reason_description']) . "\n\n' || report_text
 257                                  WHERE reason_id = $reason_id";
 258                          break;
 259                      }
 260                      $db->sql_query($sql);
 261   
 262                      $db->sql_query('DELETE FROM ' . REPORTS_REASONS_TABLE . ' WHERE reason_id = ' . $reason_id);
 263   
 264                      $phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_REASON_REMOVED', false, array($reason_row['reason_title']));
 265                      trigger_error($user->lang['REASON_REMOVED'] . adm_back_link($this->u_action));
 266                  }
 267                  else
 268                  {
 269                      confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(
 270                          'i'            => $id,
 271                          'mode'        => $mode,
 272                          'action'    => $action,
 273                          'id'        => $reason_id))
 274                      );
 275                  }
 276   
 277              break;
 278   
 279              case 'move_up':
 280              case 'move_down':
 281   
 282                  if (!check_link_hash($request->variable('hash', ''), 'acp_reasons'))
 283                  {
 284                      trigger_error($user->lang['FORM_INVALID'] . adm_back_link($this->u_action), E_USER_WARNING);
 285                  }
 286   
 287                  $sql = 'SELECT reason_order
 288                      FROM ' . REPORTS_REASONS_TABLE . "
 289                      WHERE reason_id = $reason_id";
 290                  $result = $db->sql_query($sql);
 291                  $order = $db->sql_fetchfield('reason_order');
 292                  $db->sql_freeresult($result);
 293   
 294                  if ($order === false || ($order == 0 && $action == 'move_up'))
 295                  {
 296                      break;
 297                  }
 298                  $order = (int) $order;
 299                  $order_total = $order * 2 + (($action == 'move_up') ? -1 : 1);
 300   
 301                  $sql = 'UPDATE ' . REPORTS_REASONS_TABLE . '
 302                      SET reason_order = ' . $order_total . ' - reason_order
 303                      WHERE reason_order IN (' . $order . ', ' . (($action == 'move_up') ? $order - 1 : $order + 1) . ')';
 304                  $db->sql_query($sql);
 305   
 306                  if ($request->is_ajax())
 307                  {
 308                      $json_response = new \phpbb\json_response;
 309                      $json_response->send(array(
 310                          'success'    => (bool) $db->sql_affectedrows(),
 311                      ));
 312                  }
 313              break;
 314          }
 315   
 316          // By default, check that order is valid and fix it if necessary
 317          $sql = 'SELECT reason_id, reason_order
 318              FROM ' . REPORTS_REASONS_TABLE . '
 319              ORDER BY reason_order';
 320          $result = $db->sql_query($sql);
 321   
 322          if ($row = $db->sql_fetchrow($result))
 323          {
 324              $order = 0;
 325              do
 326              {
 327                  ++$order;
 328   
 329                  if ($row['reason_order'] != $order)
 330                  {
 331                      $sql = 'UPDATE ' . REPORTS_REASONS_TABLE . "
 332                          SET reason_order = $order
 333                          WHERE reason_id = {$row['reason_id']}";
 334                      $db->sql_query($sql);
 335                  }
 336              }
 337              while ($row = $db->sql_fetchrow($result));
 338          }
 339          $db->sql_freeresult($result);
 340   
 341          $template->assign_vars(array(
 342              'U_ACTION'            => $this->u_action,
 343              )
 344          );
 345   
 346          // Reason count
 347          $sql = 'SELECT reason_id, COUNT(reason_id) AS reason_count
 348              FROM ' . REPORTS_TABLE . '
 349              GROUP BY reason_id';
 350          $result = $db->sql_query($sql);
 351   
 352          $reason_count = array();
 353          while ($row = $db->sql_fetchrow($result))
 354          {
 355              $reason_count[$row['reason_id']] = $row['reason_count'];
 356          }
 357          $db->sql_freeresult($result);
 358   
 359          $sql = 'SELECT *
 360              FROM ' . REPORTS_REASONS_TABLE . '
 361              ORDER BY reason_order ASC';
 362          $result = $db->sql_query($sql);
 363   
 364          while ($row = $db->sql_fetchrow($result))
 365          {
 366              $translated = false;
 367              $other_reason = ($row['reason_title'] == 'other') ? true : false;
 368   
 369              // If the reason is defined within the language file, we will use the localized version, else just use the database entry...
 370              if (isset($user->lang['report_reasons']['TITLE'][strtoupper($row['reason_title'])]) && isset($user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])]))
 371              {
 372                  $row['reason_description'] = $user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])];
 373                  $row['reason_title'] = $user->lang['report_reasons']['TITLE'][strtoupper($row['reason_title'])];
 374   
 375                  $translated = true;
 376              }
 377   
 378              $template->assign_block_vars('reasons', array(
 379                  'REASON_TITLE'            => $row['reason_title'],
 380                  'REASON_DESCRIPTION'    => $row['reason_description'],
 381                  'REASON_COUNT'            => (isset($reason_count[$row['reason_id']])) ? $reason_count[$row['reason_id']] : 0,
 382   
 383                  'S_TRANSLATED'        => $translated,
 384                  'S_OTHER_REASON'    => $other_reason,
 385   
 386                  'U_EDIT'        => $this->u_action . '&amp;action=edit&amp;id=' . $row['reason_id'],
 387                  'U_DELETE'        => (!$other_reason) ? $this->u_action . '&amp;action=delete&amp;id=' . $row['reason_id'] : '',
 388                  'U_MOVE_UP'        => $this->u_action . '&amp;action=move_up&amp;id=' . $row['reason_id'] . '&amp;hash=' . generate_link_hash('acp_reasons'),
 389                  'U_MOVE_DOWN'    => $this->u_action . '&amp;action=move_down&amp;id=' . $row['reason_id'] . '&amp;hash=' . generate_link_hash('acp_reasons'))
 390              );
 391          }
 392          $db->sql_freeresult($result);
 393      }
 394  }
 395   

Powered by TreeView® & SyntaxHighlight® PHP-Tools © St. Frank

Verzeichnisstruktur phpBB-3.2.0

Zuletzt modifiziert: 09.10.2024, 12:52 - Dateigröße: 12.01 KiB

acp_reasons.php


 001  <?php
 002  /**
 003  *
 004  * This file is part of the phpBB Forum Software package.
 005  *
 006  * @copyright (c) phpBB Limited <https://www.phpbb.com>
 007  * @license GNU General Public License, version 2 (GPL-2.0)
 008  *
 009  * For full copyright and license information, please see
 010  * the docs/CREDITS.txt file.
 011  *
 012  */
 013   
 014  /**
 015  * @ignore
 016  */
 017  if (!defined('IN_PHPBB'))
 018  {
 019      exit;
 020  }
 021   
 022  class acp_reasons
 023  {
 024      var $u_action;
 025   
 026      function main($id, $mode)
 027      {
 028          global $db, $user, $template;
 029          global $request, $phpbb_log;
 030   
 031          $user->add_lang(array('mcp', 'acp/posting'));
 032   
 033          // Set up general vars
 034          $action = $request->variable('action', '');
 035          $submit = (isset($_POST['submit'])) ? true : false;
 036          $reason_id = $request->variable('id', 0);
 037   
 038          $this->tpl_name = 'acp_reasons';
 039          $this->page_title = 'ACP_REASONS';
 040   
 041          $form_name = 'acp_reason';
 042          add_form_key('acp_reason');
 043   
 044          $error = array();
 045   
 046          switch ($action)
 047          {
 048              case 'add':
 049              case 'edit':
 050   
 051                  $reason_row = array(
 052                      'reason_title'            => $request->variable('reason_title', '', true),
 053                      'reason_description'    => $request->variable('reason_description', '', true),
 054                  );
 055   
 056                  if ($submit)
 057                  {
 058                      if (!check_form_key($form_name))
 059                      {
 060                          $error[] = $user->lang['FORM_INVALID'];
 061                      }
 062                      // Reason specified?
 063                      if (!$reason_row['reason_title'] || !$reason_row['reason_description'])
 064                      {
 065                          $error[] = $user->lang['NO_REASON_INFO'];
 066                      }
 067   
 068                      $check_double = ($action == 'add') ? true : false;
 069   
 070                      if ($action == 'edit')
 071                      {
 072                          $sql = 'SELECT reason_title
 073                              FROM ' . REPORTS_REASONS_TABLE . "
 074                              WHERE reason_id = $reason_id";
 075                          $result = $db->sql_query($sql);
 076                          $row = $db->sql_fetchrow($result);
 077                          $db->sql_freeresult($result);
 078   
 079                          if (strtolower($row['reason_title']) == 'other' || strtolower($reason_row['reason_title']) == 'other')
 080                          {
 081                              $reason_row['reason_title'] = 'other';
 082                          }
 083   
 084                          if ($row['reason_title'] != $reason_row['reason_title'])
 085                          {
 086                              $check_double = true;
 087                          }
 088                      }
 089   
 090                      // Check for same reason if adding it...
 091                      if ($check_double)
 092                      {
 093                          $sql = 'SELECT reason_id
 094                              FROM ' . REPORTS_REASONS_TABLE . "
 095                              WHERE reason_title = '" . $db->sql_escape($reason_row['reason_title']) . "'";
 096                          $result = $db->sql_query($sql);
 097                          $row = $db->sql_fetchrow($result);
 098                          $db->sql_freeresult($result);
 099   
 100                          if ($row || ($action == 'add' && strtolower($reason_row['reason_title']) == 'other'))
 101                          {
 102                              $error[] = $user->lang['REASON_ALREADY_EXIST'];
 103                          }
 104                      }
 105   
 106                      if (!sizeof($error))
 107                      {
 108                          // New reason?
 109                          if ($action == 'add')
 110                          {
 111                              // Get new order...
 112                              $sql = 'SELECT MAX(reason_order) as max_reason_order
 113                                  FROM ' . REPORTS_REASONS_TABLE;
 114                              $result = $db->sql_query($sql);
 115                              $max_order = (int) $db->sql_fetchfield('max_reason_order');
 116                              $db->sql_freeresult($result);
 117   
 118                              $sql_ary = array(
 119                                  'reason_title'            => (string) $reason_row['reason_title'],
 120                                  'reason_description'    => (string) $reason_row['reason_description'],
 121                                  'reason_order'            => $max_order + 1
 122                              );
 123   
 124                              $db->sql_query('INSERT INTO ' . REPORTS_REASONS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));
 125   
 126                              $log = 'ADDED';
 127                          }
 128                          else if ($reason_id)
 129                          {
 130                              $sql_ary = array(
 131                                  'reason_title'            => (string) $reason_row['reason_title'],
 132                                  'reason_description'    => (string) $reason_row['reason_description'],
 133                              );
 134   
 135                              $db->sql_query('UPDATE ' . REPORTS_REASONS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
 136                                  WHERE reason_id = ' . $reason_id);
 137   
 138                              $log = 'UPDATED';
 139                          }
 140   
 141                          $phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_REASON_' . $log, false, array($reason_row['reason_title']));
 142                          trigger_error($user->lang['REASON_' . $log] . adm_back_link($this->u_action));
 143                      }
 144                  }
 145                  else if ($reason_id)
 146                  {
 147                      $sql = 'SELECT *
 148                          FROM ' . REPORTS_REASONS_TABLE . '
 149                          WHERE reason_id = ' . $reason_id;
 150                      $result = $db->sql_query($sql);
 151                      $reason_row = $db->sql_fetchrow($result);
 152                      $db->sql_freeresult($result);
 153   
 154                      if (!$reason_row)
 155                      {
 156                          trigger_error($user->lang['NO_REASON'] . adm_back_link($this->u_action), E_USER_WARNING);
 157                      }
 158                  }
 159   
 160                  $l_title = ($action == 'edit') ? 'EDIT' : 'ADD';
 161   
 162                  $translated = false;
 163   
 164                  // If the reason is defined within the language file, we will use the localized version, else just use the database entry...
 165                  if (isset($user->lang['report_reasons']['TITLE'][strtoupper($reason_row['reason_title'])]) && isset($user->lang['report_reasons']['DESCRIPTION'][strtoupper($reason_row['reason_title'])]))
 166                  {
 167                      $translated = true;
 168                  }
 169   
 170                  $template->assign_vars(array(
 171                      'L_TITLE'        => $user->lang['REASON_' . $l_title],
 172                      'U_ACTION'        => $this->u_action . "&amp;id=$reason_id&amp;action=$action",
 173                      'U_BACK'        => $this->u_action,
 174                      'ERROR_MSG'        => (sizeof($error)) ? implode('<br />', $error) : '',
 175   
 176                      'REASON_TITLE'            => $reason_row['reason_title'],
 177                      'REASON_DESCRIPTION'    => $reason_row['reason_description'],
 178   
 179                      'TRANSLATED_TITLE'        => ($translated) ? $user->lang['report_reasons']['TITLE'][strtoupper($reason_row['reason_title'])] : '',
 180                      'TRANSLATED_DESCRIPTION'=> ($translated) ? $user->lang['report_reasons']['DESCRIPTION'][strtoupper($reason_row['reason_title'])] : '',
 181   
 182                      'S_AVAILABLE_TITLES'    => implode($user->lang['COMMA_SEPARATOR'], array_map('htmlspecialchars', array_keys($user->lang['report_reasons']['TITLE']))),
 183                      'S_EDIT_REASON'            => true,
 184                      'S_TRANSLATED'            => $translated,
 185                      'S_ERROR'                => (sizeof($error)) ? true : false,
 186                      )
 187                  );
 188   
 189                  return;
 190              break;
 191   
 192              case 'delete':
 193   
 194                  $sql = 'SELECT *
 195                      FROM ' . REPORTS_REASONS_TABLE . '
 196                      WHERE reason_id = ' . $reason_id;
 197                  $result = $db->sql_query($sql);
 198                  $reason_row = $db->sql_fetchrow($result);
 199                  $db->sql_freeresult($result);
 200   
 201                  if (!$reason_row)
 202                  {
 203                      trigger_error($user->lang['NO_REASON'] . adm_back_link($this->u_action), E_USER_WARNING);
 204                  }
 205   
 206                  if (strtolower($reason_row['reason_title']) == 'other')
 207                  {
 208                      trigger_error($user->lang['NO_REMOVE_DEFAULT_REASON'] . adm_back_link($this->u_action), E_USER_WARNING);
 209                  }
 210   
 211                  // Let the deletion be confirmed...
 212                  if (confirm_box(true))
 213                  {
 214                      $sql = 'SELECT reason_id
 215                          FROM ' . REPORTS_REASONS_TABLE . "
 216                          WHERE LOWER(reason_title) = 'other'";
 217                      $result = $db->sql_query($sql);
 218                      $other_reason_id = (int) $db->sql_fetchfield('reason_id');
 219                      $db->sql_freeresult($result);
 220   
 221                      switch ($db->get_sql_layer())
 222                      {
 223                          // The ugly one!
 224                          case 'mysqli':
 225                          case 'mysql4':
 226                          case 'mysql':
 227                              // Change the reports using this reason to 'other'
 228                              $sql = 'UPDATE ' . REPORTS_TABLE . '
 229                                  SET reason_id = ' . $other_reason_id . ", report_text = CONCAT('" . $db->sql_escape($reason_row['reason_description']) . "\n\n', report_text)
 230                                  WHERE reason_id = $reason_id";
 231                          break;
 232   
 233                          // Standard? What's that?
 234                          case 'mssql_odbc':
 235                          case 'mssqlnative':
 236                              // Change the reports using this reason to 'other'
 237                              $sql = "DECLARE @ptrval binary(16)
 238   
 239                                      SELECT @ptrval = TEXTPTR(report_text)
 240                                          FROM " . REPORTS_TABLE . "
 241                                      WHERE reason_id = " . $reason_id . "
 242   
 243                                      UPDATETEXT " . REPORTS_TABLE . ".report_text @ptrval 0 0 '" . $db->sql_escape($reason_row['reason_description']) . "\n\n'
 244   
 245                                      UPDATE " . REPORTS_TABLE . '
 246                                          SET reason_id = ' . $other_reason_id . "
 247                                      WHERE reason_id = $reason_id";
 248                          break;
 249   
 250                          // Teh standard
 251                          case 'postgres':
 252                          case 'oracle':
 253                          case 'sqlite3':
 254                              // Change the reports using this reason to 'other'
 255                              $sql = 'UPDATE ' . REPORTS_TABLE . '
 256                                  SET reason_id = ' . $other_reason_id . ", report_text = '" . $db->sql_escape($reason_row['reason_description']) . "\n\n' || report_text
 257                                  WHERE reason_id = $reason_id";
 258                          break;
 259                      }
 260                      $db->sql_query($sql);
 261   
 262                      $db->sql_query('DELETE FROM ' . REPORTS_REASONS_TABLE . ' WHERE reason_id = ' . $reason_id);
 263   
 264                      $phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_REASON_REMOVED', false, array($reason_row['reason_title']));
 265                      trigger_error($user->lang['REASON_REMOVED'] . adm_back_link($this->u_action));
 266                  }
 267                  else
 268                  {
 269                      confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(
 270                          'i'            => $id,
 271                          'mode'        => $mode,
 272                          'action'    => $action,
 273                          'id'        => $reason_id))
 274                      );
 275                  }
 276   
 277              break;
 278   
 279              case 'move_up':
 280              case 'move_down':
 281   
 282                  if (!check_link_hash($request->variable('hash', ''), 'acp_reasons'))
 283                  {
 284                      trigger_error($user->lang['FORM_INVALID'] . adm_back_link($this->u_action), E_USER_WARNING);
 285                  }
 286   
 287                  $sql = 'SELECT reason_order
 288                      FROM ' . REPORTS_REASONS_TABLE . "
 289                      WHERE reason_id = $reason_id";
 290                  $result = $db->sql_query($sql);
 291                  $order = $db->sql_fetchfield('reason_order');
 292                  $db->sql_freeresult($result);
 293   
 294                  if ($order === false || ($order == 0 && $action == 'move_up'))
 295                  {
 296                      break;
 297                  }
 298                  $order = (int) $order;
 299                  $order_total = $order * 2 + (($action == 'move_up') ? -1 : 1);
 300   
 301                  $sql = 'UPDATE ' . REPORTS_REASONS_TABLE . '
 302                      SET reason_order = ' . $order_total . ' - reason_order
 303                      WHERE reason_order IN (' . $order . ', ' . (($action == 'move_up') ? $order - 1 : $order + 1) . ')';
 304                  $db->sql_query($sql);
 305   
 306                  if ($request->is_ajax())
 307                  {
 308                      $json_response = new \phpbb\json_response;
 309                      $json_response->send(array(
 310                          'success'    => (bool) $db->sql_affectedrows(),
 311                      ));
 312                  }
 313              break;
 314          }
 315   
 316          // By default, check that order is valid and fix it if necessary
 317          $sql = 'SELECT reason_id, reason_order
 318              FROM ' . REPORTS_REASONS_TABLE . '
 319              ORDER BY reason_order';
 320          $result = $db->sql_query($sql);
 321   
 322          if ($row = $db->sql_fetchrow($result))
 323          {
 324              $order = 0;
 325              do
 326              {
 327                  ++$order;
 328   
 329                  if ($row['reason_order'] != $order)
 330                  {
 331                      $sql = 'UPDATE ' . REPORTS_REASONS_TABLE . "
 332                          SET reason_order = $order
 333                          WHERE reason_id = {$row['reason_id']}";
 334                      $db->sql_query($sql);
 335                  }
 336              }
 337              while ($row = $db->sql_fetchrow($result));
 338          }
 339          $db->sql_freeresult($result);
 340   
 341          $template->assign_vars(array(
 342              'U_ACTION'            => $this->u_action,
 343              )
 344          );
 345   
 346          // Reason count
 347          $sql = 'SELECT reason_id, COUNT(reason_id) AS reason_count
 348              FROM ' . REPORTS_TABLE . '
 349              GROUP BY reason_id';
 350          $result = $db->sql_query($sql);
 351   
 352          $reason_count = array();
 353          while ($row = $db->sql_fetchrow($result))
 354          {
 355              $reason_count[$row['reason_id']] = $row['reason_count'];
 356          }
 357          $db->sql_freeresult($result);
 358   
 359          $sql = 'SELECT *
 360              FROM ' . REPORTS_REASONS_TABLE . '
 361              ORDER BY reason_order ASC';
 362          $result = $db->sql_query($sql);
 363   
 364          while ($row = $db->sql_fetchrow($result))
 365          {
 366              $translated = false;
 367              $other_reason = ($row['reason_title'] == 'other') ? true : false;
 368   
 369              // If the reason is defined within the language file, we will use the localized version, else just use the database entry...
 370              if (isset($user->lang['report_reasons']['TITLE'][strtoupper($row['reason_title'])]) && isset($user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])]))
 371              {
 372                  $row['reason_description'] = $user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])];
 373                  $row['reason_title'] = $user->lang['report_reasons']['TITLE'][strtoupper($row['reason_title'])];
 374   
 375                  $translated = true;
 376              }
 377   
 378              $template->assign_block_vars('reasons', array(
 379                  'REASON_TITLE'            => $row['reason_title'],
 380                  'REASON_DESCRIPTION'    => $row['reason_description'],
 381                  'REASON_COUNT'            => (isset($reason_count[$row['reason_id']])) ? $reason_count[$row['reason_id']] : 0,
 382   
 383                  'S_TRANSLATED'        => $translated,
 384                  'S_OTHER_REASON'    => $other_reason,
 385   
 386                  'U_EDIT'        => $this->u_action . '&amp;action=edit&amp;id=' . $row['reason_id'],
 387                  'U_DELETE'        => (!$other_reason) ? $this->u_action . '&amp;action=delete&amp;id=' . $row['reason_id'] : '',
 388                  'U_MOVE_UP'        => $this->u_action . '&amp;action=move_up&amp;id=' . $row['reason_id'] . '&amp;hash=' . generate_link_hash('acp_reasons'),
 389                  'U_MOVE_DOWN'    => $this->u_action . '&amp;action=move_down&amp;id=' . $row['reason_id'] . '&amp;hash=' . generate_link_hash('acp_reasons'))
 390              );
 391          }
 392          $db->sql_freeresult($result);
 393      }
 394  }
 395   

Powered by TreeView® & SyntaxHighlight® PHP-Tools © St. Frank