admin_controller::edit_category() - Code Metrics - Inspection of "Add files via upload" - Sylver35/smiliescat - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Branch — 1.3.0 (40ec5c)

by Sylver

created 2020-08-27 19:12 UTC

admin_controller::edit_category() A

↳ Parent: admin_controller

Complexity

Conditions	5
Paths	5

Size

Total Lines	46
Code Lines	30

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	5
eloc	30
c	0
b	0
f	0
nc	5
nop	1
dl	0
loc	46
rs	9.1288

<?php
/**
*
* @package		Breizh Smilies Categories Extension
* @copyright	(c) 2020 Sylver35  https://breizhcode.com
* @license		http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

namespace sylver35\smiliescat\controller;

use sylver35\smiliescat\core\category;
use phpbb\config\config;
use phpbb\db\driver\driver_interface as db;
use phpbb\pagination;
use phpbb\request\request;
use phpbb\template\template;
use phpbb\user;
use phpbb\language\language;
use phpbb\log\log;

class admin_controller
{
	/* @var \sylver35\smiliescat\core\category */
	protected $category;

	/** @var \phpbb\config\config */
	protected $config;

	/** @var \phpbb\db\driver\driver_interface */
	protected $db;

	/** @var \phpbb\pagination */
	protected $pagination;

	/** @var \phpbb\request\request */
	protected $request;

	/** @var \phpbb\template\template */
	protected $template;

	/** @var \phpbb\user */
	protected $user;

	/** @var \phpbb\language\language */
	protected $language;

	/** @var \phpbb\log\log */
	protected $log;

	/** @var string phpBB root path */
	protected $root_path;

	/** @var string Custom form action */
	protected $u_action;

	/**
	 * The database tables
	 *
	 * @var string */
	protected $smilies_category_table;

	/**
	 * Constructor
	 */
	public function __construct(category $category, config $config, db $db, pagination $pagination, request $request, template $template, user $user, language $language, log $log, $root_path, $smilies_category_table)
	{
		$this->category = $category;
		$this->config = $config;
		$this->db = $db;
		$this->pagination = $pagination;
		$this->request = $request;
		$this->template = $template;
		$this->user = $user;
		$this->language = $language;
		$this->log = $log;
		$this->root_path = $root_path;
		$this->smilies_category_table = $smilies_category_table;
	}

	public function acp_smilies_category()
	{
		$this->language->add_lang('acp/posting');
		$action = (string) $this->request->variable('action', '');
		$start = (int) $this->request->variable('start', 0);
		$select = (int) $this->request->variable('select', -1);
		$id = (int) $this->request->variable('id', -1);
		$form_key = 'sylver35/smiliescat';
		add_form_key($form_key);

		if ($action)
		{
			switch ($action)
			{
				case 'edit':

					$this->category->adm_edit_smiley($id, $this->u_action, $start);

				break;

				case 'modify':

					if (!check_form_key($form_key))
					{
						trigger_error($this->language->lang('FORM_INVALID') . adm_back_link($this->u_action), E_USER_WARNING);
					}

					$cat_id = (int) $this->request->variable('cat_id', 0);
					$ex_cat = (int) $this->request->variable('ex_cat', 0);

					$sql = 'UPDATE ' . SMILIES_TABLE . " SET category = $cat_id WHERE smiley_id = $id";
					$this->db->sql_query($sql);

					// Decrement nb value if wanted
					if ($ex_cat !== 0)
					{
						$sql = 'UPDATE ' . $this->smilies_category_table . " SET cat_nb = cat_nb - 1 WHERE cat_id = $ex_cat";
						$this->db->sql_query($sql);
					}
					// Increment nb value if wanted
					if ($cat_id !== 0)
					{
						$sql = 'UPDATE ' . $this->smilies_category_table . " SET cat_nb = cat_nb + 1 WHERE cat_id = $cat_id";
						$this->db->sql_query($sql);
					}

					trigger_error($this->language->lang('SMILIES_EDITED', 1) . adm_back_link($this->u_action . '&amp;start=' . $start . '#acp_smilies_category'));

				break;
			}

			$this->template->assign_vars(array(
				'IN_ACTION'			=> true,
			));
		}
		else
		{
			$this->extract_list_smilies($select, $start);

			$this->template->assign_vars(array(
				'LIST_CATEGORY'		=> $this->category->select_categories($select, true),
				'U_BACK'			=> ($select) ? $this->u_action : '',
				'U_SELECT_CAT'		=> $this->u_action . '&amp;select=' . $select,
			));
		}

		$this->template->assign_vars(array(
			'CATEGORIE_SMILIES'		=> true,
		));
	}

	public function acp_categories_config()
	{
		$this->language->add_lang('acp/language');
		$mode = (string) $this->request->variable('mode', '');
		$action = (string) $this->request->variable('action', '');
		$id = (int) $this->request->variable('id', 0);
		$form_key = 'sylver35/smiliescat';
		add_form_key($form_key);

		if ($action)
		{
			if (in_array($action, array('config_cat', 'add_cat', 'edit_cat')) && !check_form_key($form_key))
			{
				trigger_error($this->language->lang('FORM_INVALID') . adm_back_link($this->u_action), E_USER_WARNING);
			}

			switch ($action)
			{
				case 'config_cat':

					$this->config->set('smilies_per_page_cat', (int) $this->request->variable('smilies_per_page_cat', 15));

					$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_SC_CONFIG', time());
					trigger_error($this->language->lang('CONFIG_UPDATED') . adm_back_link($this->u_action));

				break;

				case 'add':

					$this->category->adm_add_cat($this->u_action);

				break;

				case 'add_cat':

					$this->add_category();

				break;

				case 'edit':

					$this->category->adm_edit_cat($id, $this->u_action);

				break;

				case 'edit_cat':

					$this->edit_category($id);

				break;

				case 'move_up':
				case 'move_down':
					
					$this->move_cat($action, $id);

				break;

				case 'delete':

					if (confirm_box(true))
					{
						$this->delete_cat($id);
					}
					else
					{
						confirm_box(false, $this->language->lang('CONFIRM_OPERATION'), build_hidden_fields(array(
							'mode'		=> $mode,
							'id'		=> $id,
							'action'	=> 'delete',
						)));
					}

				break;
				
			}

			$this->template->assign_vars(array(
				'IN_ACTION'		=> true,
			));
		}
		else
		{
			$this->category->adm_list_cat($this->u_action);
		}

		$this->template->assign_vars(array(
			'CATEGORIE_CONFIG'		=> true,
			'SMILIES_PER_PAGE_CAT'	=> $this->config['smilies_per_page_cat'],
			'U_ACTION_CONFIG'		=> $this->u_action . '&amp;action=config_cat',
			'U_ADD'					=> $this->u_action . '&amp;action=add',
		));
	}

	private function move_cat($action, $id)
	{
		$id = (int) $id;
		// Get current order id and title...
		$sql = 'SELECT cat_order, cat_title
			FROM ' . $this->smilies_category_table . "
				WHERE cat_id = $id";
		$result = $this->db->sql_query($sql);
		$row = $this->db->sql_fetchrow($result);
		$current_order = (int) $row['cat_order'];
		$title = $row['cat_title'];
		$this->db->sql_freeresult($result);

		if ($current_order === 1 && $action === 'move_up')
		{
			return;
		}

		$max_order = (int) $this->category->get_max_order();

		if (($current_order === $max_order) && ($action === 'move_down'))
		{
			return;
		}

		// on move_down, switch position with next order_id...
		// on move_up, switch position with previous order_id...
		$switch_order_id = ($action === 'move_down') ? $current_order + 1 : $current_order - 1;

		$sql = 'UPDATE ' . $this->smilies_category_table . "
			SET cat_order = $current_order
			WHERE cat_order = $switch_order_id
				AND cat_id <> $id";
		$this->db->sql_query($sql);
		$move_executed = (bool) $this->db->sql_affectedrows();

		// Only update the other entry too if the previous entry got updated
		if ($move_executed)
		{
			$sql = 'UPDATE ' . $this->smilies_category_table . "
				SET cat_order = $switch_order_id
				WHERE cat_order = $current_order
					AND cat_id = $id";
			$this->db->sql_query($sql);
		}

		$this->category->reset_first_cat((int) $current_order, (int) $switch_order_id);
		$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_SC_' . strtoupper($action) . '_CAT', time(), array($title));

		if ($this->request->is_ajax())
		{
			trigger_error($this->language->lang('SC_MOVE_SUCCESS_AJAX') . adm_back_link($this->u_action));
			$json_response = new \phpbb\json_response;
			$json_response->send(array(
				'MESSAGE_TITLE'	=> $this->language->lang('INFORMATION'),
				'MESSAGE_TEXT'	=> $this->language->lang('SC_MOVE_SUCCESS_AJAX'),
				'REFRESH_DATA'	=> array('time' => 1),
			));
		}
		else
		{
			trigger_error($this->language->lang('SC_MOVE_SUCCESS') . adm_back_link($this->u_action));
		}
	}

	private function extract_list_smilies($select, $start)
	{
		$i = 0;
		$cat = -1;
		$lang = $this->user->lang_name;
		$smilies_count = (int) $this->category->smilies_count($select);

		if ($select === 0)
		{
			$sql = $this->db->sql_build_query('SELECT', array(
				'SELECT'	=> '*',
				'FROM'		=> array(SMILIES_TABLE => ''),
				'WHERE'		=> 'category = 0',
				'ORDER_BY'	=> 'smiley_order ASC',
			));
		}
		else
		{
			$sql = $this->db->sql_build_query('SELECT', array(
				'SELECT'	=> 's.*, c.*',
				'FROM'		=> array(SMILIES_TABLE => 's'),
				'LEFT_JOIN'	=> array(
					array(
						'FROM'	=> array($this->smilies_category_table => 'c'),
						'ON'	=> "cat_id = category AND cat_lang = '$lang'",
					),
				),
				'WHERE'		=> ($select == -1) ? "code <> ''" : "cat_id = $select AND code <> ''",
				'ORDER_BY'	=> 'cat_order ASC, smiley_order ASC',
			));
		}
		$result = $this->db->sql_query_limit($sql, (int) $this->config['smilies_per_page_cat'], $start);
		while ($row = $this->db->sql_fetchrow($result))
		{
			$row['category'] = isset($row['category']) ? $row['category'] : 0;
			$row['cat_name'] = ($row['category']) ? $row['cat_name'] : $this->language->lang('SC_CATEGORY_DEFAUT');

			$this->template->assign_block_vars('items', array(
				'SPACER_CAT'	=> ($cat !== (int) $row['category']) ? $this->language->lang('SC_CATEGORY_IN', $row['cat_name']) : '',
				'IMG_SRC'		=> $row['smiley_url'],
				'WIDTH'			=> $row['smiley_width'],
				'HEIGHT'		=> $row['smiley_height'],
				'CODE'			=> $row['code'],
				'EMOTION'		=> $row['emotion'],
				'CATEGORY'		=> $row['cat_name'],
				'U_EDIT'		=> $this->u_action . '&amp;action=edit&amp;id=' . $row['smiley_id'] . '&amp;start=' . $start,
			));
			$i++;

			// Keep this value in memory
			$cat = (int) $row['category'];
		}
		$this->db->sql_freeresult($result);

		$this->template->assign_vars(array(
			'NB_SMILIES'	=> $smilies_count,
			'U_SMILIES'		=> $this->root_path . $this->config['smilies_path'] . '/',
		));

		$this->pagination->generate_template_pagination($this->u_action . '&amp;select=' . $select, 'pagination', 'start', $smilies_count, (int) $this->config['smilies_per_page_cat'], $start);
	}

	private function delete_cat($id)
	{
		$id = (int) $id;
		$sql = 'SELECT cat_title, cat_order
			FROM ' . $this->smilies_category_table . "
				WHERE cat_id = $id";
		$result = $this->db->sql_query($sql);
		$row = $this->db->sql_fetchrow($result);
		$title = $row['cat_title'];
		$order = $row['cat_order'];
		$this->db->sql_freeresult($result);

		$sql_delete = 'DELETE FROM ' . $this->smilies_category_table . " WHERE cat_id = $id";
		$this->db->sql_query($sql_delete);

		// Decrement orders if needed
		$sql_decrement = 'SELECT cat_id, cat_order
			FROM ' . $this->smilies_category_table . "
				WHERE cat_order > $order";
		$result = $this->db->sql_query($sql_decrement);
		while ($row = $this->db->sql_fetchrow($result))
		{
			$new_order = $row['cat_order'] - 1;
			$sql_order = 'UPDATE ' . $this->smilies_category_table . '
				SET cat_order = ' . $new_order . '
					WHERE cat_id = ' . $row['cat_id'] . ' AND cat_order = ' . $row['cat_order'];
			$this->db->sql_query($sql_order);
		}
		$this->db->sql_freeresult($result);

		// Reset appropriate smilies category id
		$sql_update = 'UPDATE ' . SMILIES_TABLE . " SET category = 0 WHERE category = $id";
		$this->db->sql_query($sql_update);

		$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_SC_DELETE_CAT', time(), array($title));

		if ($this->request->is_ajax())
		{
			trigger_error($this->language->lang('SC_DELETE_SUCCESS_AJAX') . adm_back_link($this->u_action));
			$json_response = new \phpbb\json_response;
			$json_response->send(array(
				'MESSAGE_TITLE'	=> $this->language->lang('INFORMATION'),
				'MESSAGE_TEXT'	=> $this->language->lang('SC_DELETE_SUCCESS_AJAX'),
				'REFRESH_DATA'	=> array('time' => 2),
			));
		}
		else
		{
			trigger_error($this->language->lang('SC_DELETE_SUCCESS') . adm_back_link($this->u_action));
		}
	}

	private function add_category()
	{
		$title = $this->request->variable('name_' . $this->user->lang_name, '', true);
		$cat_order = (int) $this->request->variable('order', 0);
		$cat_id = (int) $this->category->get_max_id() + 1;
		$sql_in = array();
		$i = 0;

		$sql = 'SELECT lang_id, lang_iso
			FROM ' . LANG_TABLE . "
				ORDER BY lang_id ASC";
		$result = $this->db->sql_query($sql);
		while ($row = $this->db->sql_fetchrow($result))
		{
			$iso = $row['lang_iso'];
			$lang = (string) $this->request->variable("lang_$iso", '', true);
			$name = (string) $this->request->variable("name_$iso", '', true);
			if ($name === '')
			{
				trigger_error($this->language->lang('SC_CATEGORY_ERROR') . adm_back_link($this->u_action . '&amp;action=add'), E_USER_WARNING);
			}
			else
			{
				$sql_in[$i] = array(
					'cat_id'		=> $cat_id,
					'cat_order'		=> $cat_order,
					'cat_lang'		=> $lang,
					'cat_name'		=> $this->category->capitalize($name),
					'cat_title'		=> $this->category->capitalize($title),
				);
			}
			$i++;
		}

		for ($j = 0; $j < $i; $j++)
		{
			$this->db->sql_query('INSERT INTO ' . $this->smilies_category_table . $this->db->sql_build_array('INSERT', $sql_in[$j]));
		}

		if ($cat_order === 1)
		{
			$this->config->set('smilies_category_nb', $cat_id);
		}

		$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_SC_ADD_CAT', time(), array($title));
		trigger_error($this->language->lang('SC_CREATE_SUCCESS') . adm_back_link($this->u_action));
	}

	private function edit_category($id)
	{
		$id = (int) $id;
		$title = $this->category->capitalize($this->request->variable('name_' . $this->user->lang_name, '', true));

		$sql = 'SELECT lang_id, lang_iso
			FROM ' . LANG_TABLE . "
				ORDER BY lang_id ASC";
		$result = $this->db->sql_query($sql);
		while ($row = $this->db->sql_fetchrow($result))
		{
			$iso = $row['lang_iso'];
			$lang = (string) $this->request->variable("lang_$iso", '', true);
			$sort = (string) $this->request->variable("sort_$iso", '');
			$order = (int) $this->request->variable('order', 0);
			$name = $this->category->capitalize($this->request->variable("name_$iso", '', true));
			if ($name === '')
			{
				trigger_error($this->language->lang('SC_CATEGORY_ERROR') . adm_back_link($this->u_action . '&amp;action=edit&amp;id=' . $id), E_USER_WARNING);
			}
			else
			{
				if ($sort === 'edit')
				{
					$sql = 'UPDATE ' . $this->smilies_category_table . "
						SET cat_name = '" . $name . "', cat_title = '" . $title . "'
							WHERE cat_lang = '" . $this->db->sql_escape($lang) . "'
							AND cat_id = $id";
					$this->db->sql_query($sql);
				}
				else if ($sort === 'create')
				{
					$sql_in = array(
						'cat_id'		=> $id,
						'cat_order'		=> $order,
						'cat_lang'		=> $lang,
						'cat_name'		=> $name,
						'cat_title'		=> $title,
					);
					$this->db->sql_query('INSERT INTO ' . $this->smilies_category_table . $this->db->sql_build_array('INSERT', $sql_in));
				}
			}
		}

		$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_SC_EDIT_CAT', time(), array($title));
		trigger_error($this->language->lang('SC_EDIT_SUCCESS') . adm_back_link($this->u_action));
	}

	/**
	 * Set page url
	 *
	 * @param string $u_action Custom form action
	 * @return null
	 * @access public
	 */
	public function set_page_url($u_action)
	{
		$this->u_action = $u_action;
	}
}


1			<?php
2			/**
3			*
4			* @package Breizh Smilies Categories Extension
5			* @copyright (c) 2020 Sylver35 https://breizhcode.com
6			* @license http://opensource.org/licenses/gpl-license.php GNU Public License
7			*
8			*/
9
10			namespace sylver35\smiliescat\controller;
11
12			use sylver35\smiliescat\core\category;
13			use phpbb\config\config;
14			use phpbb\db\driver\driver_interface as db;
15			use phpbb\pagination;
16			use phpbb\request\request;
17			use phpbb\template\template;
18			use phpbb\user;
19			use phpbb\language\language;
20			use phpbb\log\log;
21
22			class admin_controller
23			{
24			/* @var \sylver35\smiliescat\core\category */
25			protected $category;
26
27			/** @var \phpbb\config\config */
28			protected $config;
29
30			/** @var \phpbb\db\driver\driver_interface */
31			protected $db;
32
33			/** @var \phpbb\pagination */
34			protected $pagination;
35
36			/** @var \phpbb\request\request */
37			protected $request;
38
39			/** @var \phpbb\template\template */
40			protected $template;
41
42			/** @var \phpbb\user */
43			protected $user;
44
45			/** @var \phpbb\language\language */
46			protected $language;
47
48			/** @var \phpbb\log\log */
49			protected $log;
50
51			/** @var string phpBB root path */
52			protected $root_path;
53
54			/** @var string Custom form action */
55			protected $u_action;
56
57			/**
58			* The database tables
59			*
60			* @var string */
61			protected $smilies_category_table;
62
63			/**
64			* Constructor
65			*/
66			public function __construct(category $category, config $config, db $db, pagination $pagination, request $request, template $template, user $user, language $language, log $log, $root_path, $smilies_category_table)
67			{
68			$this->category = $category;
69			$this->config = $config;
70			$this->db = $db;
71			$this->pagination = $pagination;
72			$this->request = $request;
73			$this->template = $template;
74			$this->user = $user;
75			$this->language = $language;
76			$this->log = $log;
77			$this->root_path = $root_path;
78			$this->smilies_category_table = $smilies_category_table;
79			}
80
81			public function acp_smilies_category()
82			{
83			$this->language->add_lang('acp/posting');
84			$action = (string) $this->request->variable('action', '');
85			$start = (int) $this->request->variable('start', 0);
86			$select = (int) $this->request->variable('select', -1);
87			$id = (int) $this->request->variable('id', -1);
88			$form_key = 'sylver35/smiliescat';
89			add_form_key($form_key);
90
91			if ($action)
92			{
93			switch ($action)
94			{
95			case 'edit':
96
97			$this->category->adm_edit_smiley($id, $this->u_action, $start);
98
99			break;
100
101			case 'modify':
102
103			if (!check_form_key($form_key))
104			{
105			trigger_error($this->language->lang('FORM_INVALID') . adm_back_link($this->u_action), E_USER_WARNING);
106			}
107
108			$cat_id = (int) $this->request->variable('cat_id', 0);
109			$ex_cat = (int) $this->request->variable('ex_cat', 0);
110
111			$sql = 'UPDATE ' . SMILIES_TABLE . " SET category = $cat_id WHERE smiley_id = $id";
112			$this->db->sql_query($sql);
113
114			// Decrement nb value if wanted
115			if ($ex_cat !== 0)
116			{
117			$sql = 'UPDATE ' . $this->smilies_category_table . " SET cat_nb = cat_nb - 1 WHERE cat_id = $ex_cat";
118			$this->db->sql_query($sql);
119			}
120			// Increment nb value if wanted
121			if ($cat_id !== 0)
122			{
123			$sql = 'UPDATE ' . $this->smilies_category_table . " SET cat_nb = cat_nb + 1 WHERE cat_id = $cat_id";
124			$this->db->sql_query($sql);
125			}
126
127			trigger_error($this->language->lang('SMILIES_EDITED', 1) . adm_back_link($this->u_action . '&start=' . $start . '#acp_smilies_category'));
128
129			break;
130			}
131
132			$this->template->assign_vars(array(
133			'IN_ACTION' => true,
134			));
135			}
136			else
137			{
138			$this->extract_list_smilies($select, $start);
139
140			$this->template->assign_vars(array(
141			'LIST_CATEGORY' => $this->category->select_categories($select, true),
142			'U_BACK' => ($select) ? $this->u_action : '',
143			'U_SELECT_CAT' => $this->u_action . '&select=' . $select,
144			));
145			}
146
147			$this->template->assign_vars(array(
148			'CATEGORIE_SMILIES' => true,
149			));
150			}
151
152			public function acp_categories_config()
153			{
154			$this->language->add_lang('acp/language');
155			$mode = (string) $this->request->variable('mode', '');
156			$action = (string) $this->request->variable('action', '');
157			$id = (int) $this->request->variable('id', 0);
158			$form_key = 'sylver35/smiliescat';
159			add_form_key($form_key);
160
161			if ($action)
162			{
163			if (in_array($action, array('config_cat', 'add_cat', 'edit_cat')) && !check_form_key($form_key))
164			{
165			trigger_error($this->language->lang('FORM_INVALID') . adm_back_link($this->u_action), E_USER_WARNING);
166			}
167
168			switch ($action)
169			{
170			case 'config_cat':
171
172			$this->config->set('smilies_per_page_cat', (int) $this->request->variable('smilies_per_page_cat', 15));
173
174			$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_SC_CONFIG', time());
175			trigger_error($this->language->lang('CONFIG_UPDATED') . adm_back_link($this->u_action));
176
177			break;
178
179			case 'add':
180
181			$this->category->adm_add_cat($this->u_action);
182
183			break;
184
185			case 'add_cat':
186
187			$this->add_category();
188
189			break;
190
191			case 'edit':
192
193			$this->category->adm_edit_cat($id, $this->u_action);
194
195			break;
196
197			case 'edit_cat':
198
199			$this->edit_category($id);
200
201			break;
202
203			case 'move_up':
204			case 'move_down':
205
206			$this->move_cat($action, $id);
207
208			break;
209
210			case 'delete':
211
212			if (confirm_box(true))
213			{
214			$this->delete_cat($id);
215			}
216			else
217			{
218			confirm_box(false, $this->language->lang('CONFIRM_OPERATION'), build_hidden_fields(array(
219			'mode' => $mode,
220			'id' => $id,
221			'action' => 'delete',
222			)));
223			}
224
225			break;
226
227			}
228
229			$this->template->assign_vars(array(
230			'IN_ACTION' => true,
231			));
232			}
233			else
234			{
235			$this->category->adm_list_cat($this->u_action);
236			}
237
238			$this->template->assign_vars(array(
239			'CATEGORIE_CONFIG' => true,
240			'SMILIES_PER_PAGE_CAT' => $this->config['smilies_per_page_cat'],
241			'U_ACTION_CONFIG' => $this->u_action . '&action=config_cat',
242			'U_ADD' => $this->u_action . '&action=add',
243			));
244			}
245
246			private function move_cat($action, $id)
247			{
248			$id = (int) $id;
249			// Get current order id and title...
250			$sql = 'SELECT cat_order, cat_title
251			FROM ' . $this->smilies_category_table . "
252			WHERE cat_id = $id";
253			$result = $this->db->sql_query($sql);
254			$row = $this->db->sql_fetchrow($result);
255			$current_order = (int) $row['cat_order'];
256			$title = $row['cat_title'];
257			$this->db->sql_freeresult($result);
258
259			if ($current_order === 1 && $action === 'move_up')
260			{
261			return;
262			}
263
264			$max_order = (int) $this->category->get_max_order();
265
266			if (($current_order === $max_order) && ($action === 'move_down'))
267			{
268			return;
269			}
270
271			// on move_down, switch position with next order_id...
272			// on move_up, switch position with previous order_id...
273			$switch_order_id = ($action === 'move_down') ? $current_order + 1 : $current_order - 1;
274
275			$sql = 'UPDATE ' . $this->smilies_category_table . "
276			SET cat_order = $current_order
277			WHERE cat_order = $switch_order_id
278			AND cat_id <> $id";
279			$this->db->sql_query($sql);
280			$move_executed = (bool) $this->db->sql_affectedrows();
281
282			// Only update the other entry too if the previous entry got updated
283			if ($move_executed)
284			{
285			$sql = 'UPDATE ' . $this->smilies_category_table . "
286			SET cat_order = $switch_order_id
287			WHERE cat_order = $current_order
288			AND cat_id = $id";
289			$this->db->sql_query($sql);
290			}
291
292			$this->category->reset_first_cat((int) $current_order, (int) $switch_order_id);
293			$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_SC_' . strtoupper($action) . '_CAT', time(), array($title));
294
295			if ($this->request->is_ajax())
296			{
297			trigger_error($this->language->lang('SC_MOVE_SUCCESS_AJAX') . adm_back_link($this->u_action));
298			$json_response = new \phpbb\json_response;
299			$json_response->send(array(
300			'MESSAGE_TITLE' => $this->language->lang('INFORMATION'),
301			'MESSAGE_TEXT' => $this->language->lang('SC_MOVE_SUCCESS_AJAX'),
302			'REFRESH_DATA' => array('time' => 1),
303			));
304			}
305			else
306			{
307			trigger_error($this->language->lang('SC_MOVE_SUCCESS') . adm_back_link($this->u_action));
308			}
309			}
310
311			private function extract_list_smilies($select, $start)
312			{
313			$i = 0;
314			$cat = -1;
315			$lang = $this->user->lang_name;
316			$smilies_count = (int) $this->category->smilies_count($select);
317
318			if ($select === 0)
319			{
320			$sql = $this->db->sql_build_query('SELECT', array(
321			'SELECT' => '*',
322			'FROM' => array(SMILIES_TABLE => ''),
323			'WHERE' => 'category = 0',
324			'ORDER_BY' => 'smiley_order ASC',
325			));
326			}
327			else
328			{
329			$sql = $this->db->sql_build_query('SELECT', array(
330			'SELECT' => 's., c.',
331			'FROM' => array(SMILIES_TABLE => 's'),
332			'LEFT_JOIN' => array(
333			array(
334			'FROM' => array($this->smilies_category_table => 'c'),
335			'ON' => "cat_id = category AND cat_lang = '$lang'",
336			),
337			),
338			'WHERE' => ($select == -1) ? "code <> ''" : "cat_id = $select AND code <> ''",
339			'ORDER_BY' => 'cat_order ASC, smiley_order ASC',
340			));
341			}
342			$result = $this->db->sql_query_limit($sql, (int) $this->config['smilies_per_page_cat'], $start);
343			while ($row = $this->db->sql_fetchrow($result))
344			{
345			$row['category'] = isset($row['category']) ? $row['category'] : 0;
346			$row['cat_name'] = ($row['category']) ? $row['cat_name'] : $this->language->lang('SC_CATEGORY_DEFAUT');
347
348			$this->template->assign_block_vars('items', array(
349			'SPACER_CAT' => ($cat !== (int) $row['category']) ? $this->language->lang('SC_CATEGORY_IN', $row['cat_name']) : '',
350			'IMG_SRC' => $row['smiley_url'],
351			'WIDTH' => $row['smiley_width'],
352			'HEIGHT' => $row['smiley_height'],
353			'CODE' => $row['code'],
354			'EMOTION' => $row['emotion'],
355			'CATEGORY' => $row['cat_name'],
356			'U_EDIT' => $this->u_action . '&action=edit&id=' . $row['smiley_id'] . '&start=' . $start,
357			));
358			$i++;
359
360			// Keep this value in memory
361			$cat = (int) $row['category'];
362			}
363			$this->db->sql_freeresult($result);
364
365			$this->template->assign_vars(array(
366			'NB_SMILIES' => $smilies_count,
367			'U_SMILIES' => $this->root_path . $this->config['smilies_path'] . '/',
368			));
369
370			$this->pagination->generate_template_pagination($this->u_action . '&select=' . $select, 'pagination', 'start', $smilies_count, (int) $this->config['smilies_per_page_cat'], $start);
371			}
372
373			private function delete_cat($id)
374			{
375			$id = (int) $id;
376			$sql = 'SELECT cat_title, cat_order
377			FROM ' . $this->smilies_category_table . "
378			WHERE cat_id = $id";
379			$result = $this->db->sql_query($sql);
380			$row = $this->db->sql_fetchrow($result);
381			$title = $row['cat_title'];
382			$order = $row['cat_order'];
383			$this->db->sql_freeresult($result);
384
385			$sql_delete = 'DELETE FROM ' . $this->smilies_category_table . " WHERE cat_id = $id";
386			$this->db->sql_query($sql_delete);
387
388			// Decrement orders if needed
389			$sql_decrement = 'SELECT cat_id, cat_order
390			FROM ' . $this->smilies_category_table . "
391			WHERE cat_order > $order";
392			$result = $this->db->sql_query($sql_decrement);
393			while ($row = $this->db->sql_fetchrow($result))
394			{
395			$new_order = $row['cat_order'] - 1;
396			$sql_order = 'UPDATE ' . $this->smilies_category_table . '
397			SET cat_order = ' . $new_order . '
398			WHERE cat_id = ' . $row['cat_id'] . ' AND cat_order = ' . $row['cat_order'];
399			$this->db->sql_query($sql_order);
400			}
401			$this->db->sql_freeresult($result);
402
403			// Reset appropriate smilies category id
404			$sql_update = 'UPDATE ' . SMILIES_TABLE . " SET category = 0 WHERE category = $id";
405			$this->db->sql_query($sql_update);
406
407			$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_SC_DELETE_CAT', time(), array($title));
408
409			if ($this->request->is_ajax())
410			{
411			trigger_error($this->language->lang('SC_DELETE_SUCCESS_AJAX') . adm_back_link($this->u_action));
412			$json_response = new \phpbb\json_response;
413			$json_response->send(array(
414			'MESSAGE_TITLE' => $this->language->lang('INFORMATION'),
415			'MESSAGE_TEXT' => $this->language->lang('SC_DELETE_SUCCESS_AJAX'),
416			'REFRESH_DATA' => array('time' => 2),
417			));
418			}
419			else
420			{
421			trigger_error($this->language->lang('SC_DELETE_SUCCESS') . adm_back_link($this->u_action));
422			}
423			}
424
425			private function add_category()
426			{
427			$title = $this->request->variable('name_' . $this->user->lang_name, '', true);
428			$cat_order = (int) $this->request->variable('order', 0);
429			$cat_id = (int) $this->category->get_max_id() + 1;
430			$sql_in = array();
431			$i = 0;
432
433			$sql = 'SELECT lang_id, lang_iso
434			FROM ' . LANG_TABLE . "
435			ORDER BY lang_id ASC";
436			$result = $this->db->sql_query($sql);
437			while ($row = $this->db->sql_fetchrow($result))
438			{
439			$iso = $row['lang_iso'];
440			$lang = (string) $this->request->variable("lang_$iso", '', true);
441			$name = (string) $this->request->variable("name_$iso", '', true);
442			if ($name === '')
443			{
444			trigger_error($this->language->lang('SC_CATEGORY_ERROR') . adm_back_link($this->u_action . '&action=add'), E_USER_WARNING);
445			}
446			else
447			{
448			$sql_in[$i] = array(
449			'cat_id' => $cat_id,
450			'cat_order' => $cat_order,
451			'cat_lang' => $lang,
452			'cat_name' => $this->category->capitalize($name),
453			'cat_title' => $this->category->capitalize($title),
454			);
455			}
456			$i++;
457			}
458
459			for ($j = 0; $j < $i; $j++)
460			{
461			$this->db->sql_query('INSERT INTO ' . $this->smilies_category_table . $this->db->sql_build_array('INSERT', $sql_in[$j]));
462			}
463
464			if ($cat_order === 1)
465			{
466			$this->config->set('smilies_category_nb', $cat_id);
467			}
468
469			$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_SC_ADD_CAT', time(), array($title));
470			trigger_error($this->language->lang('SC_CREATE_SUCCESS') . adm_back_link($this->u_action));
471			}
472
473			private function edit_category($id)
474			{
475			$id = (int) $id;
476			$title = $this->category->capitalize($this->request->variable('name_' . $this->user->lang_name, '', true));
477
478			$sql = 'SELECT lang_id, lang_iso
479			FROM ' . LANG_TABLE . "
480			ORDER BY lang_id ASC";
481			$result = $this->db->sql_query($sql);
482			while ($row = $this->db->sql_fetchrow($result))
483			{
484			$iso = $row['lang_iso'];
485			$lang = (string) $this->request->variable("lang_$iso", '', true);
486			$sort = (string) $this->request->variable("sort_$iso", '');
487			$order = (int) $this->request->variable('order', 0);
488			$name = $this->category->capitalize($this->request->variable("name_$iso", '', true));
489			if ($name === '')
490			{
491			trigger_error($this->language->lang('SC_CATEGORY_ERROR') . adm_back_link($this->u_action . '&action=edit&id=' . $id), E_USER_WARNING);
492			}
493			else
494			{
495			if ($sort === 'edit')
496			{
497			$sql = 'UPDATE ' . $this->smilies_category_table . "
498			SET cat_name = '" . $name . "', cat_title = '" . $title . "'
499			WHERE cat_lang = '" . $this->db->sql_escape($lang) . "'
500			AND cat_id = $id";
501			$this->db->sql_query($sql);
502			}
503			else if ($sort === 'create')
504			{
505			$sql_in = array(
506			'cat_id' => $id,
507			'cat_order' => $order,
508			'cat_lang' => $lang,
509			'cat_name' => $name,
510			'cat_title' => $title,
511			);
512			$this->db->sql_query('INSERT INTO ' . $this->smilies_category_table . $this->db->sql_build_array('INSERT', $sql_in));
513			}
514			}
515			}
516
517			$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_SC_EDIT_CAT', time(), array($title));
518			trigger_error($this->language->lang('SC_EDIT_SUCCESS') . adm_back_link($this->u_action));
519			}
520
521			/**
522			* Set page url
523			*
524			* @param string $u_action Custom form action
525			* @return null
526			* @access public
527			*/
528			public function set_page_url($u_action)
529			{
530			$this->u_action = $u_action;
531			}
532			}
533

Sylver35 / smiliescat

Branch — 1.3.0 (40ec5c)

admin_controller::edit_category() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like