category - Code Metrics - Inspection of "Add files via upload" - Sylver35/smiliescat - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — 1.3.0 ( 8f251a...b261a4 )

by Sylver

created 2020-08-30 09:32 UTC

category F

↳ Parent: Project

Complexity

Total Complexity

Size/Duplication

Total Lines	570
Duplicated Lines	0 %

Importance

Changes	21
Bugs	0	Features	0

Metric	Value
eloc	339
dl	0
loc	570
rs	3.36
c	21
b	0
f	0
wmc	63

18 Methods

Rating	Name	Size	Complexity
A	get_version()	16	2
A	__construct()	13	1
A	shoutbox_smilies()	44	4
A	set_order()	19	6
B	select_categories()	30	9
A	shoutbox_smilies_popup()	50	5
A	get_max_id()	10	1
A	move_cat()	38	3
A	capitalize()	3	1
A	smilies_count()	12	3
A	adm_edit_smiley()	30	1
A	adm_list_cat()	52	5
B	extract_list_categories()	50	11
A	get_first_order()	11	1
A	adm_add_cat()	23	2
A	get_max_order()	10	1
A	adm_edit_cat()	71	4
A	reset_first_cat()	6	3

How to fix Complexity

<?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\core;

use phpbb\cache\driver\driver_interface as cache;
use phpbb\db\driver\driver_interface as db;
use phpbb\config\config;
use phpbb\controller\helper;
use phpbb\user;
use phpbb\language\language;
use phpbb\template\template;
use phpbb\extension\manager;
use phpbb\log\log;

class category
{
	/** @var \phpbb\cache\driver\driver_interface */
	protected $cache;

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

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

	/* @var \phpbb\controller\helper */
	protected $helper;

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

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

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

	/** @var \phpbb\extension\manager "Extension Manager" */
	protected $ext_manager;

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

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

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

	/**
	 * Constructor
	 */
	public function __construct(cache $cache, db $db, config $config, helper $helper, user $user, language $language, template $template, manager $ext_manager, log $log, $smilies_category_table, $root_path)
	{
		$this->cache = $cache;
		$this->db = $db;
		$this->config = $config;
		$this->helper = $helper;
		$this->user = $user;
		$this->language = $language;
		$this->template = $template;
		$this->ext_manager = $ext_manager;
		$this->log = $log;
		$this->smilies_category_table = $smilies_category_table;
		$this->root_path = $root_path;
	}

	public function get_version()
	{
		if (($data = $this->cache->get('_smiliescat_version')) === false)
		{
			$md_manager = $this->ext_manager->create_extension_metadata_manager('sylver35/smiliescat');
			$meta = $md_manager->get_metadata();

			$data = array(
				'version'	=> $meta['version'],
				'homepage'	=> $meta['homepage'],
			);
			// cache for 7 days
			$this->cache->put('_smiliescat_version', $data, 604800);
		}

		return $data;
	}

	public function smilies_count($cat, $compact = false)
	{
		$sql = $this->db->sql_build_query('SELECT', array(
			'SELECT'	=> (!$compact) ? 'COUNT(DISTINCT smiley_id) AS smilies_count' : 'COUNT(DISTINCT smiley_url) AS smilies_count',
			'FROM'		=> array(SMILIES_TABLE => ''),
			'WHERE'		=> ($cat > -1) ? 'category = ' . (int) $cat : "code <> ''",
		));
		$result = $this->db->sql_query($sql);
		$nb = (int) $this->db->sql_fetchfield('smilies_count');
		$this->db->sql_freeresult($result);

		return $nb;
	}

	public function select_categories($cat, $modify = false, $empty = false)
	{
		$lang = $this->user->lang_name;
		$select = '<option disabled="disabled">' . $this->language->lang('SC_CATEGORY_SELECT') . '</option>';
		if ($modify)
		{
			$select .= '<option value="-1"' . (($cat == -1) ? ' selected="selected"' : '') . '>' . $this->language->lang('SC_CATEGORY_ANY') . '</option>';
		}

		$sql = 'SELECT *
			FROM ' . $this->smilies_category_table . "
				WHERE cat_lang = '$lang'
				ORDER BY cat_order ASC";
		$result = $this->db->sql_query($sql);
		while ($row = $this->db->sql_fetchrow($result))
		{
			if (!$row['cat_nb'] && $empty)
			{
				continue;
			}
			$row['cat_name'] = $row['cat_name'] ? $row['cat_name'] : $row['cat_title'];
			$selected = ($cat === (int) $row['cat_id']) ? ' selected="selected"' : '';
			$select .= '<option title="' . $row['cat_name'] . '" value="' . $row['cat_id'] . '"' . $selected . '> ' . $row['cat_name'] . '</option>';
		}
		$this->db->sql_freeresult($result);

		$selected_default = (!$cat) ? ' selected="selected"' : '';
		$select .= '<option title="' . $this->language->lang('SC_CATEGORY_DEFAUT') . '" value="0"' . $selected_default . '> ' . $this->language->lang('SC_CATEGORY_DEFAUT') . '</option>';

		return $select;
	}

	public function capitalize($var)
	{
		return $this->db->sql_escape(ucfirst(strtolower(trim($var))));
	}

	public function get_max_order()
	{
		// Get max order id...
		$sql = 'SELECT MAX(cat_order) AS maxi
			FROM ' . $this->smilies_category_table;
		$result = $this->db->sql_query($sql);
		$max = $this->db->sql_fetchfield('maxi', $result);
		$this->db->sql_freeresult($result);

		return (int) $max;
	}

	public function get_max_id()
	{
		// Get max id...
		$sql = 'SELECT MAX(cat_id) AS id_max
			FROM ' . $this->smilies_category_table;
		$result = $this->db->sql_query($sql);
		$id_max = (int) $this->db->sql_fetchfield('id_max', $result);
		$this->db->sql_freeresult($result);

		return $id_max;
	}

	public function get_first_order()
	{
		// Get first order id...
		$sql = 'SELECT cat_order, cat_id
			FROM ' . $this->smilies_category_table . '
			ORDER BY cat_order ASC';
		$result = $this->db->sql_query_limit($sql, 1);
		$mini = (int) $this->db->sql_fetchfield('cat_id');
		$this->db->sql_freeresult($result);

		return $mini;
	}

	public function extract_list_categories($cat)
	{
		$title = '';
		$cat_order = $i = 0;
		$lang = $this->user->lang_name;
		$sql = $this->db->sql_build_query('SELECT', array(
			'SELECT'	=> '*',
			'FROM'		=> array($this->smilies_category_table => ''),
			'WHERE'		=> "cat_lang = '$lang'",
			'ORDER_BY'	=> 'cat_order ASC',
		));
		$result = $this->db->sql_query($sql);
		while ($row = $this->db->sql_fetchrow($result))
		{
			// Choose only non-empty categories
			if ($row['cat_nb'])
			{
				$actual_cat = (int) $row['cat_id'] === $cat;
				$this->template->assign_block_vars('categories', array(
					'CLASS'			=> $actual_cat ? 'cat-active' : 'cat-inactive',
					'SEPARATE'		=> ($i > 0) ? ' - ' : '',
					'CAT_ID'		=> $row['cat_id'],
					'CAT_ORDER'		=> $row['cat_order'],
					'CAT_NAME'		=> $row['cat_name'] ? $row['cat_name'] : $row['cat_title'],
					'CAT_NB'		=> $row['cat_nb'],
				));
				$i++;

				// Keep these values in memory
				$title = $actual_cat ? $row['cat_name'] : $title;
				$cat_order = $row['cat_order'];
			}
		}
		$this->db->sql_freeresult($result);

		// Add the Unclassified category if not empty
		$nb = $this->smilies_count(0);
		if ($nb)
		{
			$this->template->assign_block_vars('categories', array(
				'CLASS'			=> ($cat === 0) ? 'cat-active' : 'cat-inactive',
				'SEPARATE'		=> ($i > 0) ? ' - ' : '',
				'CAT_ID'		=> 0,
				'CAT_ORDER'		=> $cat_order + 1,
				'CAT_NAME'		=> $this->language->lang('SC_CATEGORY_DEFAUT'),
				'CAT_NB'		=> $nb,
			));
		}

		return (!$cat) ? $this->language->lang('SC_CATEGORY_DEFAUT') : $title;
	}

	public function shoutbox_smilies($event)
	{
		$i = $cat_order = 0;
		$list_cat = [];
		$lang = $this->user->lang_name;

		$sql = 'SELECT * 
			FROM ' . $this->smilies_category_table . "
				WHERE cat_lang = '$lang'
				ORDER BY cat_order ASC";
		$result = $this->db->sql_query($sql);
		while ($row = $this->db->sql_fetchrow($result))
		{
			// Choose only non-empty categories
			if ($row['cat_nb'])
			{
				$list_cat[$i] = array(
					'cat_id'		=> (int) $row['cat_id'],
					'cat_order'		=> (int) $row['cat_order'],
					'cat_name'		=> (string) $row['cat_name'],
					'cat_nb'		=> (int) $row['cat_nb'],
				);
				$i++;
			}
			// Keep this value in memory
			$cat_order = (int) $row['cat_order'];
		}
		$this->db->sql_freeresult($result);

		// Add the Unclassified category if not empty
		$nb = $this->smilies_count(0, true);
		if ($nb)
		{
			$list_cat[$i] = array(
				'cat_id'		=> 0,
				'cat_order'		=> $cat_order + 1,
				'cat_name'		=> $this->language->lang('SC_CATEGORY_DEFAUT'),
				'cat_nb'		=> $nb,
			);
		}

		$event['content'] = array_merge($event['content'], array(
			'title_cat'		=> $this->language->lang('ACP_SC_SMILIES'),
			'categories'	=> $list_cat,
		));
	}

	public function shoutbox_smilies_popup($event)
	{
		$cat = (int) $event['cat'];
		if ($cat > -1)
		{
			$i = 0;
			$smilies = array();
			$lang = $this->user->lang_name;
			$cat_name = $this->language->lang('SC_CATEGORY_DEFAUT');

			if ($cat > 0)
			{
				$sql = 'SELECT cat_name
					FROM ' . $this->smilies_category_table . "
						WHERE cat_lang = '$lang'
						AND cat_id = $cat";
				$result = $this->db->sql_query_limit($sql, 1);
				$row = $this->db->sql_fetchrow($result);
				$cat_name = $row['cat_name'];
				$this->db->sql_freeresult($result);
			}

			$sql = $this->db->sql_build_query('SELECT', array(
				'SELECT'	=> 'smiley_url, MIN(smiley_id) AS smiley_id, MIN(code) AS code, MIN(smiley_order) AS min_smiley_order, MIN(smiley_width) AS smiley_width, MIN(smiley_height) AS smiley_height, MIN(emotion) AS emotion',
				'FROM'		=> array(SMILIES_TABLE => ''),
				'WHERE'		=> 'category = ' . $cat,
				'GROUP_BY'	=> 'smiley_url',
				'ORDER_BY'	=> 'min_smiley_order ASC',
			));
			$result = $this->db->sql_query($sql);
			while ($row = $this->db->sql_fetchrow($result))
			{
				$smilies[$i] = array(
					'nb'		=> (int) $i,
					'code'		=> (string) $row['code'],
					'emotion'	=> (string) $row['emotion'],
					'image'		=> (string) $row['smiley_url'],
					'width'		=> (int) $row['smiley_width'],
					'height'	=> (int) $row['smiley_height'],
				);
				$i++;
			}

			$event['content'] = array_merge($event['content'], array(
				'in_cat'		=> true,
				'cat'			=> $cat,
				'total'			=> $i,
				'smilies'		=> $smilies,
				'emptyRow'		=> (!$i) ? $this->language->lang('SC_SMILIES_EMPTY_CATEGORY') : '',
				'title'			=> $this->language->lang('SC_CATEGORY_IN', $cat_name),
			));
		}
	}

	public function set_order($action, $current_order)
	{
		$switch_order_id = 0;
		$max_order = $this->get_max_order();
		if ($current_order == 1 && $action == 'move_up')
		{
			return $switch_order_id;
		}

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

		// 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;

		return $switch_order_id;
	}

	public function adm_add_cat($u_action)
	{
		$max = $this->get_max_order();
		$sql = 'SELECT lang_local_name, lang_iso
			FROM ' . LANG_TABLE . '
				ORDER BY lang_id ASC';
		$result = $this->db->sql_query($sql);
		while ($row = $this->db->sql_fetchrow($result))
		{
			$this->template->assign_block_vars('categories', array(
				'CAT_LANG'		=> $row['lang_local_name'],
				'CAT_ISO'		=> $row['lang_iso'],
				'CAT_ORDER'		=> $max + 1,
			));
		}
		$this->db->sql_freeresult($result);

		$this->template->assign_vars(array(
			'IN_CAT_ACTION'		=> true,
			'IN_ADD_ACTION'		=> true,
			'CAT_ORDER'			=> $max + 1,
			'U_BACK'			=> $u_action,
			'U_ADD_CAT'			=> $u_action . '&amp;action=add_cat',
		));
	}

	public function adm_edit_cat($id, $u_action)
	{
		// Get total lang id...
		$sql = 'SELECT COUNT(lang_id) as total
			FROM ' . LANG_TABLE;
		$result = $this->db->sql_query($sql);
		$total = (int) $this->db->sql_fetchfield('total', $result);
		$this->db->sql_freeresult($result);

		$title = '';
		$i = $cat_order = 0;
		$list_id = [];
		$sql = $this->db->sql_build_query('SELECT', array(
			'SELECT'	=> 'l.*, c.*',
			'FROM'		=> array(LANG_TABLE => 'l'),
			'LEFT_JOIN'	=> array(
				array(
					'FROM'	=> array($this->smilies_category_table => 'c'),
					'ON'	=> 'c.cat_lang = l.lang_iso',
				),
			),
			'WHERE'		=> 'cat_id = ' . $id,
			'ORDER_BY'	=> 'lang_id ASC',
		));
		$result = $this->db->sql_query($sql);
		while ($row = $this->db->sql_fetchrow($result))
		{
			$this->template->assign_block_vars('category_lang', array(
				'CAT_LANG'			=> $row['lang_local_name'],
				'CAT_ISO'			=> $row['lang_iso'],
				'CAT_ORDER'			=> $row['cat_order'],
				'CAT_ID'			=> $row['cat_id'],
				'CAT_TRANSLATE'		=> $row['cat_name'],
				'CAT_SORT'			=> 'edit',
			));
			$i++;
			$list_id[$i] = $row['lang_id'];
			$cat_order = $row['cat_order'];
			$title = $row['cat_title'];
		}
		$this->db->sql_freeresult($result);

		// Add rows for empty langs in this category
		if ($i !== $total)
		{
			$sql = $this->db->sql_build_query('SELECT', array(
				'SELECT'	=> '*',
				'FROM'		=> array(LANG_TABLE => 'l'),
				'WHERE'		=> $this->db->sql_in_set('lang_id', $list_id, true, true),
			));
			$result = $this->db->sql_query($sql);
			while ($row = $this->db->sql_fetchrow($result))
			{
				$this->template->assign_block_vars('category_lang', array(
					'CAT_LANG'			=> $row['lang_local_name'],
					'CAT_ISO'			=> $row['lang_iso'],
					'CAT_ORDER'			=> $cat_order,
					'CAT_ID'			=> $id,
					'CAT_TRANSLATE'		=> '',
					'CAT_SORT'			=> 'create',
				));
			}
			$this->db->sql_freeresult($result);
		}

		$this->template->assign_vars(array(
			'IN_CAT_ACTION'	=> true,
			'CAT_ORDER'		=> $cat_order,
			'CAT_TITLE'		=> $title,
			'U_BACK'		=> $u_action,
			'U_EDIT_CAT'	=> $u_action . '&amp;action=edit_cat&amp;id=' . $id,
		));
	}

	public function adm_list_cat($u_action)
	{
		$i = $cat = 0;
		$max = $this->get_max_order();
		$sql = $this->db->sql_build_query('SELECT', array(
			'SELECT'	=> 'l.lang_iso, l.lang_local_name, c.*',
			'FROM'		=> array(LANG_TABLE => 'l'),
			'LEFT_JOIN'	=> array(
				array(
					'FROM'	=> array($this->smilies_category_table => 'c'),
					'ON'	=> 'cat_lang = lang_iso',
				),
			),
			'ORDER_BY'	=> 'cat_order ASC, cat_lang_id ASC',
		));
		$result = $this->db->sql_query($sql);
		while ($row = $this->db->sql_fetchrow($result))
		{
			if (!$row)
			{
				$this->template->assign_vars(array(
					'EMPTY_ROW'		=> true,
				));
			}
			else
			{
				$this->template->assign_block_vars('categories', array(
					'CAT_NR'			=> $i + 1,
					'LANG_EMPTY'		=> !$row['cat_id'] && !$row['cat_order'] && !$row['cat_name'],
					'SPACER_CAT'		=> $this->language->lang('SC_CATEGORY_IN', $row['cat_title']),
					'CAT_LANG'			=> $row['lang_local_name'],
					'CAT_ISO'			=> $row['lang_iso'],
					'CAT_ID'			=> $row['cat_id'],
					'CAT_ORDER'			=> $row['cat_order'],
					'CAT_TRANSLATE'		=> $row['cat_name'],
					'CAT_NB'			=> $row['cat_nb'],
					'ROW'				=> (int) $row['cat_id'] !== $cat,
					'ROW_MAX'			=> (int) $row['cat_order'] === $max,
					'U_EDIT'			=> $u_action . '&amp;action=edit&amp;id=' . $row['cat_id'],
					'U_DELETE'			=> $u_action . '&amp;action=delete&amp;id=' . $row['cat_id'],
				));
				$i++;
				// Keep this value in memory
				$cat = (int) $row['cat_id'];
			}
		}
		$this->db->sql_freeresult($result);

		$this->template->assign_vars(array(
			'IN_LIST_CAT'	=> true,
			'U_ACTION'		=> $u_action,
			'U_MOVE_CATS'	=> $this->helper->route('sylver35_smiliescat_ajax_list_cat'),
		));
	}

	public function adm_edit_smiley($id, $u_action, $start)
	{
		$lang = $this->user->lang_name;
		$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'	=> 'smiley_id = ' . (int) $id,
		));
		$result = $this->db->sql_query($sql);
		$row = $this->db->sql_fetchrow($result);

		$this->template->assign_vars(array(
			'WIDTH'				=> $row['smiley_width'],
			'HEIGHT'			=> $row['smiley_height'],
			'CODE'				=> $row['code'],
			'EMOTION'			=> $row['emotion'],
			'CATEGORY'			=> $row['cat_name'],
			'EX_CAT'			=> $row['cat_id'],
			'SELECT_CATEGORY'	=> $this->select_categories($row['cat_id'], false),
			'IMG_SRC'			=> $this->root_path . $this->config['smilies_path'] . '/' . $row['smiley_url'],
			'U_MODIFY'			=> $u_action . '&amp;action=modify&amp;id=' . $row['smiley_id'] . '&amp;start=' . $start,
			'U_BACK'			=> $u_action,
		));
		$this->db->sql_freeresult($result);
	}

	public function reset_first_cat($current_order, $switch_order_id)
	{
		$first = $this->get_first_order();
		if ($current_order === 1 || $switch_order_id === 1)
		{
			$this->config->set('smilies_category_nb', $first);
		}
	}

	public 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);

		$switch_order_id = $this->set_order($action, $current_order);
		if ($switch_order_id === 0)
		{
			return;
		}

		$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->reset_first_cat($current_order, $switch_order_id);
		$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_SC_' . strtoupper($action) . '_CAT', time(), array($title));
	}
}


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\core;
11
12			use phpbb\cache\driver\driver_interface as cache;
13			use phpbb\db\driver\driver_interface as db;
14			use phpbb\config\config;
15			use phpbb\controller\helper;
16			use phpbb\user;
17			use phpbb\language\language;
18			use phpbb\template\template;
19			use phpbb\extension\manager;
20			use phpbb\log\log;
21
22			class category
23			{
24			/** @var \phpbb\cache\driver\driver_interface */
25			protected $cache;
26
27			/** @var \phpbb\db\driver\driver_interface */
28			protected $db;
29
30			/** @var \phpbb\config\config */
31			protected $config;
32
33			/* @var \phpbb\controller\helper */
34			protected $helper;
35
36			/** @var \phpbb\user */
37			protected $user;
38
39			/** @var \phpbb\language\language */
40			protected $language;
41
42			/** @var \phpbb\template\template */
43			protected $template;
44
45			/** @var \phpbb\extension\manager "Extension Manager" */
46			protected $ext_manager;
47
48			/** @var \phpbb\log\log */
49			protected $log;
50
51			/**
52			* The database tables
53			*
54			* @var string */
55			protected $smilies_category_table;
56
57			/** @var string phpBB root path */
58			protected $root_path;
59
60			/**
61			* Constructor
62			*/
63			public function __construct(cache $cache, db $db, config $config, helper $helper, user $user, language $language, template $template, manager $ext_manager, log $log, $smilies_category_table, $root_path)
64			{
65			$this->cache = $cache;
66			$this->db = $db;
67			$this->config = $config;
68			$this->helper = $helper;
69			$this->user = $user;
70			$this->language = $language;
71			$this->template = $template;
72			$this->ext_manager = $ext_manager;
73			$this->log = $log;
74			$this->smilies_category_table = $smilies_category_table;
75			$this->root_path = $root_path;
76			}
77
78			public function get_version()
79			{
80			if (($data = $this->cache->get('_smiliescat_version')) === false)
81			{
82			$md_manager = $this->ext_manager->create_extension_metadata_manager('sylver35/smiliescat');
83			$meta = $md_manager->get_metadata();
84
85			$data = array(
86			'version' => $meta['version'],
87			'homepage' => $meta['homepage'],
88			);
89			// cache for 7 days
90			$this->cache->put('_smiliescat_version', $data, 604800);
91			}
92
93			return $data;
94			}
95
96			public function smilies_count($cat, $compact = false)
97			{
98			$sql = $this->db->sql_build_query('SELECT', array(
99			'SELECT' => (!$compact) ? 'COUNT(DISTINCT smiley_id) AS smilies_count' : 'COUNT(DISTINCT smiley_url) AS smilies_count',
100			'FROM' => array(SMILIES_TABLE => ''),
101			'WHERE' => ($cat > -1) ? 'category = ' . (int) $cat : "code <> ''",
102			));
103			$result = $this->db->sql_query($sql);
104			$nb = (int) $this->db->sql_fetchfield('smilies_count');
105			$this->db->sql_freeresult($result);
106
107			return $nb;
108			}
109
110			public function select_categories($cat, $modify = false, $empty = false)
111			{
112			$lang = $this->user->lang_name;
113			$select = '<option disabled="disabled">' . $this->language->lang('SC_CATEGORY_SELECT') . '</option>';
114			if ($modify)
115			{
116			$select .= '<option value="-1"' . (($cat == -1) ? ' selected="selected"' : '') . '>' . $this->language->lang('SC_CATEGORY_ANY') . '</option>';
117			}
118
119			$sql = 'SELECT *
120			FROM ' . $this->smilies_category_table . "
121			WHERE cat_lang = '$lang'
122			ORDER BY cat_order ASC";
123			$result = $this->db->sql_query($sql);
124			while ($row = $this->db->sql_fetchrow($result))
125			{
126			if (!$row['cat_nb'] && $empty)
127			{
128			continue;
129			}
130			$row['cat_name'] = $row['cat_name'] ? $row['cat_name'] : $row['cat_title'];
131			$selected = ($cat === (int) $row['cat_id']) ? ' selected="selected"' : '';
132			$select .= '<option title="' . $row['cat_name'] . '" value="' . $row['cat_id'] . '"' . $selected . '> ' . $row['cat_name'] . '</option>';
133			}
134			$this->db->sql_freeresult($result);
135
136			$selected_default = (!$cat) ? ' selected="selected"' : '';
137			$select .= '<option title="' . $this->language->lang('SC_CATEGORY_DEFAUT') . '" value="0"' . $selected_default . '> ' . $this->language->lang('SC_CATEGORY_DEFAUT') . '</option>';
138
139			return $select;
140			}
141
142			public function capitalize($var)
143			{
144			return $this->db->sql_escape(ucfirst(strtolower(trim($var))));
145			}
146
147			public function get_max_order()
148			{
149			// Get max order id...
150			$sql = 'SELECT MAX(cat_order) AS maxi
151			FROM ' . $this->smilies_category_table;
152			$result = $this->db->sql_query($sql);
153			$max = $this->db->sql_fetchfield('maxi', $result);
154			$this->db->sql_freeresult($result);
155
156			return (int) $max;
157			}
158
159			public function get_max_id()
160			{
161			// Get max id...
162			$sql = 'SELECT MAX(cat_id) AS id_max
163			FROM ' . $this->smilies_category_table;
164			$result = $this->db->sql_query($sql);
165			$id_max = (int) $this->db->sql_fetchfield('id_max', $result);
166			$this->db->sql_freeresult($result);
167
168			return $id_max;
169			}
170
171			public function get_first_order()
172			{
173			// Get first order id...
174			$sql = 'SELECT cat_order, cat_id
175			FROM ' . $this->smilies_category_table . '
176			ORDER BY cat_order ASC';
177			$result = $this->db->sql_query_limit($sql, 1);
178			$mini = (int) $this->db->sql_fetchfield('cat_id');
179			$this->db->sql_freeresult($result);
180
181			return $mini;
182			}
183
184			public function extract_list_categories($cat)
185			{
186			$title = '';
187			$cat_order = $i = 0;
188			$lang = $this->user->lang_name;
189			$sql = $this->db->sql_build_query('SELECT', array(
190			'SELECT' => '*',
191			'FROM' => array($this->smilies_category_table => ''),
192			'WHERE' => "cat_lang = '$lang'",
193			'ORDER_BY' => 'cat_order ASC',
194			));
195			$result = $this->db->sql_query($sql);
196			while ($row = $this->db->sql_fetchrow($result))
197			{
198			// Choose only non-empty categories
199			if ($row['cat_nb'])
200			{
201			$actual_cat = (int) $row['cat_id'] === $cat;
202			$this->template->assign_block_vars('categories', array(
203			'CLASS' => $actual_cat ? 'cat-active' : 'cat-inactive',
204			'SEPARATE' => ($i > 0) ? ' - ' : '',
205			'CAT_ID' => $row['cat_id'],
206			'CAT_ORDER' => $row['cat_order'],
207			'CAT_NAME' => $row['cat_name'] ? $row['cat_name'] : $row['cat_title'],
208			'CAT_NB' => $row['cat_nb'],
209			));
210			$i++;
211
212			// Keep these values in memory
213			$title = $actual_cat ? $row['cat_name'] : $title;
214			$cat_order = $row['cat_order'];
215			}
216			}
217			$this->db->sql_freeresult($result);
218
219			// Add the Unclassified category if not empty
220			$nb = $this->smilies_count(0);
221			if ($nb)
222			{
223			$this->template->assign_block_vars('categories', array(
224			'CLASS' => ($cat === 0) ? 'cat-active' : 'cat-inactive',
225			'SEPARATE' => ($i > 0) ? ' - ' : '',
226			'CAT_ID' => 0,
227			'CAT_ORDER' => $cat_order + 1,
228			'CAT_NAME' => $this->language->lang('SC_CATEGORY_DEFAUT'),
229			'CAT_NB' => $nb,
230			));
231			}
232
233			return (!$cat) ? $this->language->lang('SC_CATEGORY_DEFAUT') : $title;
234			}
235
236			public function shoutbox_smilies($event)
237			{
238			$i = $cat_order = 0;
239			$list_cat = [];
240			$lang = $this->user->lang_name;
241
242			$sql = 'SELECT *
243			FROM ' . $this->smilies_category_table . "
244			WHERE cat_lang = '$lang'
245			ORDER BY cat_order ASC";
246			$result = $this->db->sql_query($sql);
247			while ($row = $this->db->sql_fetchrow($result))
248			{
249			// Choose only non-empty categories
250			if ($row['cat_nb'])
251			{
252			$list_cat[$i] = array(
253			'cat_id' => (int) $row['cat_id'],
254			'cat_order' => (int) $row['cat_order'],
255			'cat_name' => (string) $row['cat_name'],
256			'cat_nb' => (int) $row['cat_nb'],
257			);
258			$i++;
259			}
260			// Keep this value in memory
261			$cat_order = (int) $row['cat_order'];
262			}
263			$this->db->sql_freeresult($result);
264
265			// Add the Unclassified category if not empty
266			$nb = $this->smilies_count(0, true);
267			if ($nb)
268			{
269			$list_cat[$i] = array(
270			'cat_id' => 0,
271			'cat_order' => $cat_order + 1,
272			'cat_name' => $this->language->lang('SC_CATEGORY_DEFAUT'),
273			'cat_nb' => $nb,
274			);
275			}
276
277			$event['content'] = array_merge($event['content'], array(
278			'title_cat' => $this->language->lang('ACP_SC_SMILIES'),
279			'categories' => $list_cat,
280			));
281			}
282
283			public function shoutbox_smilies_popup($event)
284			{
285			$cat = (int) $event['cat'];
286			if ($cat > -1)
287			{
288			$i = 0;
289			$smilies = array();
290			$lang = $this->user->lang_name;
291			$cat_name = $this->language->lang('SC_CATEGORY_DEFAUT');
292
293			if ($cat > 0)
294			{
295			$sql = 'SELECT cat_name
296			FROM ' . $this->smilies_category_table . "
297			WHERE cat_lang = '$lang'
298			AND cat_id = $cat";
299			$result = $this->db->sql_query_limit($sql, 1);
300			$row = $this->db->sql_fetchrow($result);
301			$cat_name = $row['cat_name'];
302			$this->db->sql_freeresult($result);
303			}
304
305			$sql = $this->db->sql_build_query('SELECT', array(
306			'SELECT' => 'smiley_url, MIN(smiley_id) AS smiley_id, MIN(code) AS code, MIN(smiley_order) AS min_smiley_order, MIN(smiley_width) AS smiley_width, MIN(smiley_height) AS smiley_height, MIN(emotion) AS emotion',
307			'FROM' => array(SMILIES_TABLE => ''),
308			'WHERE' => 'category = ' . $cat,
309			'GROUP_BY' => 'smiley_url',
310			'ORDER_BY' => 'min_smiley_order ASC',
311			));
312			$result = $this->db->sql_query($sql);
313			while ($row = $this->db->sql_fetchrow($result))
314			{
315			$smilies[$i] = array(
316			'nb' => (int) $i,
317			'code' => (string) $row['code'],
318			'emotion' => (string) $row['emotion'],
319			'image' => (string) $row['smiley_url'],
320			'width' => (int) $row['smiley_width'],
321			'height' => (int) $row['smiley_height'],
322			);
323			$i++;
324			}
325
326			$event['content'] = array_merge($event['content'], array(
327			'in_cat' => true,
328			'cat' => $cat,
329			'total' => $i,
330			'smilies' => $smilies,
331			'emptyRow' => (!$i) ? $this->language->lang('SC_SMILIES_EMPTY_CATEGORY') : '',
332			'title' => $this->language->lang('SC_CATEGORY_IN', $cat_name),
333			));
334			}
335			}
336
337			public function set_order($action, $current_order)
338			{
339			$switch_order_id = 0;
340			$max_order = $this->get_max_order();
341			if ($current_order == 1 && $action == 'move_up')
342			{
343			return $switch_order_id;
344			}
345
346			if (($current_order == $max_order) && ($action == 'move_down'))
347			{
348			return $switch_order_id;
349			}
350
351			// on move_down, switch position with next order_id...
352			// on move_up, switch position with previous order_id...
353			$switch_order_id = ($action === 'move_down') ? $current_order + 1 : $current_order - 1;
354
355			return $switch_order_id;
356			}
357
358			public function adm_add_cat($u_action)
359			{
360			$max = $this->get_max_order();
361			$sql = 'SELECT lang_local_name, lang_iso
362			FROM ' . LANG_TABLE . '
363			ORDER BY lang_id ASC';
364			$result = $this->db->sql_query($sql);
365			while ($row = $this->db->sql_fetchrow($result))
366			{
367			$this->template->assign_block_vars('categories', array(
368			'CAT_LANG' => $row['lang_local_name'],
369			'CAT_ISO' => $row['lang_iso'],
370			'CAT_ORDER' => $max + 1,
371			));
372			}
373			$this->db->sql_freeresult($result);
374
375			$this->template->assign_vars(array(
376			'IN_CAT_ACTION' => true,
377			'IN_ADD_ACTION' => true,
378			'CAT_ORDER' => $max + 1,
379			'U_BACK' => $u_action,
380			'U_ADD_CAT' => $u_action . '&action=add_cat',
381			));
382			}
383
384			public function adm_edit_cat($id, $u_action)
385			{
386			// Get total lang id...
387			$sql = 'SELECT COUNT(lang_id) as total
388			FROM ' . LANG_TABLE;
389			$result = $this->db->sql_query($sql);
390			$total = (int) $this->db->sql_fetchfield('total', $result);
391			$this->db->sql_freeresult($result);
392
393			$title = '';
394			$i = $cat_order = 0;
395			$list_id = [];
396			$sql = $this->db->sql_build_query('SELECT', array(
397			'SELECT' => 'l., c.',
398			'FROM' => array(LANG_TABLE => 'l'),
399			'LEFT_JOIN' => array(
400			array(
401			'FROM' => array($this->smilies_category_table => 'c'),
402			'ON' => 'c.cat_lang = l.lang_iso',
403			),
404			),
405			'WHERE' => 'cat_id = ' . $id,
406			'ORDER_BY' => 'lang_id ASC',
407			));
408			$result = $this->db->sql_query($sql);
409			while ($row = $this->db->sql_fetchrow($result))
410			{
411			$this->template->assign_block_vars('category_lang', array(
412			'CAT_LANG' => $row['lang_local_name'],
413			'CAT_ISO' => $row['lang_iso'],
414			'CAT_ORDER' => $row['cat_order'],
415			'CAT_ID' => $row['cat_id'],
416			'CAT_TRANSLATE' => $row['cat_name'],
417			'CAT_SORT' => 'edit',
418			));
419			$i++;
420			$list_id[$i] = $row['lang_id'];
421			$cat_order = $row['cat_order'];
422			$title = $row['cat_title'];
423			}
424			$this->db->sql_freeresult($result);
425
426			// Add rows for empty langs in this category
427			if ($i !== $total)
428			{
429			$sql = $this->db->sql_build_query('SELECT', array(
430			'SELECT' => '*',
431			'FROM' => array(LANG_TABLE => 'l'),
432			'WHERE' => $this->db->sql_in_set('lang_id', $list_id, true, true),
433			));
434			$result = $this->db->sql_query($sql);
435			while ($row = $this->db->sql_fetchrow($result))
436			{
437			$this->template->assign_block_vars('category_lang', array(
438			'CAT_LANG' => $row['lang_local_name'],
439			'CAT_ISO' => $row['lang_iso'],
440			'CAT_ORDER' => $cat_order,
441			'CAT_ID' => $id,
442			'CAT_TRANSLATE' => '',
443			'CAT_SORT' => 'create',
444			));
445			}
446			$this->db->sql_freeresult($result);
447			}
448
449			$this->template->assign_vars(array(
450			'IN_CAT_ACTION' => true,
451			'CAT_ORDER' => $cat_order,
452			'CAT_TITLE' => $title,
453			'U_BACK' => $u_action,
454			'U_EDIT_CAT' => $u_action . '&action=edit_cat&id=' . $id,
455			));
456			}
457
458			public function adm_list_cat($u_action)
459			{
460			$i = $cat = 0;
461			$max = $this->get_max_order();
462			$sql = $this->db->sql_build_query('SELECT', array(
463			'SELECT' => 'l.lang_iso, l.lang_local_name, c.*',
464			'FROM' => array(LANG_TABLE => 'l'),
465			'LEFT_JOIN' => array(
466			array(
467			'FROM' => array($this->smilies_category_table => 'c'),
468			'ON' => 'cat_lang = lang_iso',
469			),
470			),
471			'ORDER_BY' => 'cat_order ASC, cat_lang_id ASC',
472			));
473			$result = $this->db->sql_query($sql);
474			while ($row = $this->db->sql_fetchrow($result))
475			{
476			if (!$row)
477			{
478			$this->template->assign_vars(array(
479			'EMPTY_ROW' => true,
480			));
481			}
482			else
483			{
484			$this->template->assign_block_vars('categories', array(
485			'CAT_NR' => $i + 1,
486			'LANG_EMPTY' => !$row['cat_id'] && !$row['cat_order'] && !$row['cat_name'],
487			'SPACER_CAT' => $this->language->lang('SC_CATEGORY_IN', $row['cat_title']),
488			'CAT_LANG' => $row['lang_local_name'],
489			'CAT_ISO' => $row['lang_iso'],
490			'CAT_ID' => $row['cat_id'],
491			'CAT_ORDER' => $row['cat_order'],
492			'CAT_TRANSLATE' => $row['cat_name'],
493			'CAT_NB' => $row['cat_nb'],
494			'ROW' => (int) $row['cat_id'] !== $cat,
495			'ROW_MAX' => (int) $row['cat_order'] === $max,
496			'U_EDIT' => $u_action . '&action=edit&id=' . $row['cat_id'],
497			'U_DELETE' => $u_action . '&action=delete&id=' . $row['cat_id'],
498			));
499			$i++;
500			// Keep this value in memory
501			$cat = (int) $row['cat_id'];
502			}
503			}
504			$this->db->sql_freeresult($result);
505
506			$this->template->assign_vars(array(
507			'IN_LIST_CAT' => true,
508			'U_ACTION' => $u_action,
509			'U_MOVE_CATS' => $this->helper->route('sylver35_smiliescat_ajax_list_cat'),
510			));
511			}
512
513			public function adm_edit_smiley($id, $u_action, $start)
514			{
515			$lang = $this->user->lang_name;
516			$sql = $this->db->sql_build_query('SELECT', array(
517			'SELECT' => 's., c.',
518			'FROM' => array(SMILIES_TABLE => 's'),
519			'LEFT_JOIN' => array(
520			array(
521			'FROM' => array($this->smilies_category_table => 'c'),
522			'ON' => "cat_id = category AND cat_lang = '$lang'",
523			),
524			),
525			'WHERE' => 'smiley_id = ' . (int) $id,
526			));
527			$result = $this->db->sql_query($sql);
528			$row = $this->db->sql_fetchrow($result);
529
530			$this->template->assign_vars(array(
531			'WIDTH' => $row['smiley_width'],
532			'HEIGHT' => $row['smiley_height'],
533			'CODE' => $row['code'],
534			'EMOTION' => $row['emotion'],
535			'CATEGORY' => $row['cat_name'],
536			'EX_CAT' => $row['cat_id'],
537			'SELECT_CATEGORY' => $this->select_categories($row['cat_id'], false),
538			'IMG_SRC' => $this->root_path . $this->config['smilies_path'] . '/' . $row['smiley_url'],
539			'U_MODIFY' => $u_action . '&action=modify&id=' . $row['smiley_id'] . '&start=' . $start,
540			'U_BACK' => $u_action,
541			));
542			$this->db->sql_freeresult($result);
543			}
544
545			public function reset_first_cat($current_order, $switch_order_id)
546			{
547			$first = $this->get_first_order();
548			if ($current_order === 1 \|\| $switch_order_id === 1)
549			{
550			$this->config->set('smilies_category_nb', $first);
551			}
552			}
553
554			public function move_cat($action, $id)
555			{
556			$id = (int) $id;
557			// Get current order id and title...
558			$sql = 'SELECT cat_order, cat_title
559			FROM ' . $this->smilies_category_table . '
560			WHERE cat_id = ' . $id;
561			$result = $this->db->sql_query($sql);
562			$row = $this->db->sql_fetchrow($result);
563			$current_order = (int) $row['cat_order'];
564			$title = $row['cat_title'];
565			$this->db->sql_freeresult($result);
566
567			$switch_order_id = $this->set_order($action, $current_order);
568			if ($switch_order_id === 0)
569			{
570			return;
571			}
572
573			$sql = 'UPDATE ' . $this->smilies_category_table . "
574			SET cat_order = $current_order
575			WHERE cat_order = $switch_order_id
576			AND cat_id <> $id";
577			$this->db->sql_query($sql);
578			$move_executed = (bool) $this->db->sql_affectedrows();
579
580			// Only update the other entry too if the previous entry got updated
581			if ($move_executed)
582			{
583			$sql = 'UPDATE ' . $this->smilies_category_table . "
584			SET cat_order = $switch_order_id
585			WHERE cat_order = $current_order
586			AND cat_id = $id";
587			$this->db->sql_query($sql);
588			}
589
590			$this->reset_first_cat($current_order, $switch_order_id);
591			$this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_SC_' . strtoupper($action) . '_CAT', time(), array($title));
592			}
593			}
594

Sylver35 / smiliescat

Push — 1.3.0 ( 8f251a...b261a4 )

category F

Complexity

Size/Duplication

Importance

18 Methods

How to fix Complexity

Complex Class

Duplication Side-by-Side

Filter issues like