plugins\tags\tags.tools.php

<?php
/* ====================
[BEGIN_COT_EXT]
Hooks=tools
[END_COT_EXT]
==================== */
(defined('COT_CODE') && defined('COT_ADMIN')) or die('Wrong URL.');
 
list($usr['auth_read'], $usr['auth_write'], $usr['isadmin']) = cot_auth('plug', 'tags');
cot_block($usr['isadmin']);
 
require_once cot_incfile('tags', 'plug');
 
$tt = new XTemplate(cot_tplfile('tags.tools', 'plug', true));
 
$adminhelp = $L['adm_help_tags'];
$adminsubtitle = $L['tags_All'];
 
$cfg['maxrowsperpage'] = 30;
 
$action = cot_import('action', 'P', 'TXT');
$tag = str_replace('_', ' ', cot_import('tag', 'R', 'TXT'));
list($pg, $d, $durl) = cot_import_pagenav('d', $cfg['maxrowsperpage']);
 
$sorttype = cot_import('sorttype', 'R', 'ALP');
$sorttype = empty($sorttype) ? 'tag' : $sorttype;
$sort_type = array(
	'tag' => $L['Code'],
	'tag_cnt' => $L['Count'],
	'length' => 'Длина'
);
if ($sorttype == 'tag')
{
	$admin_tags_join_sorttype = "t.tag";
}
elseif ($sorttype == 'length')
{
	$admin_tags_join_sorttype = "length(t.tag)";
}
else
{
	$admin_tags_join_sorttype = $sorttype;
}
 
$sortway = cot_import('sortway', 'R', 'ALP');
$sortway = empty($sortway) ? 'asc' : $sortway;
$sort_way = array(
	'asc' => $L['Ascending'],
	'desc' => $L['Descending']
);
 
$filter = cot_import('filter', 'R', 'TXT');
$filter = empty($filter) ? 'all' : $filter;
$filter_type = array(
	'all' => $L['All'],
);
foreach(range(chr(0xC0),chr(0xDF)) as $i)
{
	$i = iconv('CP1251', 'UTF-8', $i);
	$filter_type[$i] = $i;
}
if ($filter == 'all')
{
	$admin_tags_join_where = "";
}
else
{
	$admin_tags_join_where = "AND t.tag LIKE '".$filter."%'";
}
 
$admin_tags_join_fields = '';
$admin_tags_join_tables = '';
 
/* === Hook  === */
foreach (cot_getextplugins('admin.tags.first') as $pl)
{
	include $pl;
}
/* ===== */
 
if ($action == $L['Delete'])
{
	cot_check_xp();
	foreach (cot_getextplugins('admin.tags.delete') as $pl)
	{
		include $pl;
	}
	/* ===== */
	$db->delete($db_tags, "tag='".htmlspecialchars($tag)."'");
	$sql = $db->delete($db_tag_references, "tag='".htmlspecialchars($tag)."'");
	$adminwarnings = ($sql) ? cot_message('adm_tag_already_del') : $L['Error'];
}
elseif ($action == $L['Edit'])
{
	cot_check_xp();
	$old_tag = str_replace('_', ' ', cot_import('old_tag', 'R', 'TXT'));
 
	foreach (cot_getextplugins('admin.tags.edit') as $pl)
	{
		include $pl;
	}
	/* ===== */
	$db->update($db_tags, array("tag" => htmlspecialchars($tag)), "tag='".$db->prep($old_tag)."'");
	$db->update($db_tag_references, array("tag" => htmlspecialchars($tag)), "tag='".$db->prep($old_tag)."'");
	$adminwarnings = ($sql) ? cot_message('adm_tag_already_edit') : $L['Error'];
}
elseif (!empty($tag))
{
	$admin_tags_join_where = "AND t.tag LIKE '".$tag."'";
}
 
$is_adminwarnings = isset($adminwarnings);
 
if (cot_module_active('page'))
{
	require_once cot_incfile('page', 'module');
	$admin_tags_join_fields = ", p.*, u.user_name";
	$admin_tags_join_tables = " LEFT JOIN $db_pages AS p
		ON t.tag_area = 'pages' AND t.tag_item = p.page_id LEFT JOIN $db_users AS u ON u.user_id=p.page_ownerid";
}
if (cot_module_active('forums'))
{
	require_once cot_incfile('forums', 'module');
	$admin_tags_join_fields = ", f.*";
	$admin_tags_join_tables = " LEFT JOIN $db_forum_posts AS f
		ON t.tag_area = 'forums' AND t.tag_item = f.fp_id";
}
 
$totalitems = $db->query("SELECT distinct(tag) FROM $db_tag_references AS t WHERE 1 ".$admin_tags_join_where)->rowCount();//$totalitems = $db->countRows($db_tags);
$pagenav = cot_pagenav('admin', 'm=other&p=tags&sorttype='.$sorttype.'&sortway='.$sortway.'&filter='.$filter, $d, $totalitems, $cfg['maxrowsperpage'], 'd', '', $cfg['jquery'] && $cfg['turnajax']);
 
$sql = $db->query("SELECT t.*,COUNT(*) AS tag_cnt, GROUP_CONCAT(t.tag_area,':',t.tag_item SEPARATOR ',') AS tag_grp $admin_tags_join_fields
	FROM $db_tag_references AS t $admin_tags_join_tables
	WHERE 1 $admin_tags_join_where
	GROUP BY t.tag
	ORDER BY $admin_tags_join_sorttype $sortway LIMIT $d, ".$cfg['maxrowsperpage']);
 
$ii = 0;
/* === Hook - Part1 : Set === */
$extp = cot_getextplugins('admin.tags.loop');
/* ===== */
foreach ($sql->fetchAll() as $row)
{
		if (isset($cot_extrafields[$db_tag_references]))
		{
			foreach ($cot_extrafields[$db_tag_references] as $exfld)
			{
				$tag = mb_strtoupper($exfld['field_name']);
				$tt->assign(array(
					'ADMIN_TAGS_' . $tag . '_TITLE' => isset($L['tags_' . $exfld['field_name'] . '_title']) ? $L['tags_' . $exfld['field_name'] . '_title'] : $exfld['field_description'],
					'ADMIN_TAGS_' . $tag => cot_build_extrafields_data('tags', $exfld, $row['tag_'.$exfld['field_name']]),
					'ADMIN_TAGS_' . $tag . '_VALUE' => $row['tag_'.$exfld['field_name']],
				));
			}
		}
		if (!empty($row['tag_grp']))
		{
			$item_mas = array();
			$items = explode(',', $row['tag_grp']);
			foreach ($items as $val)
			{
				$item = explode(':', $val);
				$item_mas[$item[0]][] = $item[1];
			}
			foreach ($item_mas as $k=>$v)
			{
				if ($k == 'pages')
				{
					foreach ($v as $kk=>$vv)
					{
						$row_item = cot_generate_pagetags($vv, 'ADMIN_TAGS_ITEM_', 200);
						if ($row_item['ADMIN_TAGS_ITEM_TITLE'] == 'Удалено') { }//$db->delete($db_tag_references, "tag_item=$vv"); //echo $vv.'-убить<br />';
						else
						{
							$tt->assign($row_item);
							//$tt->assign(cot_generate_usertags($row_item['page_ownerid'], 'ADMIN_TAGS_PAGE_OWNER_'), htmlspecialchars($row['user_name']));
							$tt->parse('MAIN.ADMIN_TAGS_ROW.ADMIN_TAGS_ROW_ITEMS');
						}
					}
				}
				elseif ($k == 'forum')
				{
 
				}
			}
		}
		$tt->assign(array(
			'ADMIN_TAGS_FORM_ACTION' => cot_url('admin', 'm=other&p=tags&d='.$durl),
			'ADMIN_TAGS_DEL_URL' => cot_url('admin', 'm=other&p=tags&a=delete&tag='.str_replace(' ', '_', $row['tag']).'&'.cot_xg()),
			'ADMIN_TAGS_CODE' => $row['tag'],
			'ADMIN_TAGS_TAG' => cot_inputbox('text', 'tag', htmlspecialchars_decode($row['tag']), array('size' => '30', 'maxlength' => '255')),//['.$row['tag'].']
			'ADMIN_TAGS_AREA' => $row['tag_area'],
			'ADMIN_TAGS_COUNT' => $row['tag_cnt'],
			'ADMIN_TAGS_ITEMS' => str_replace(array('pages:', ','),array('', ', '),$row['tag_grp']),
			'ADMIN_TAGS_ODDEVEN' => cot_build_oddeven($ii)
		));
		/* === Hook - Part2 : Include === */
		foreach ($extp as $pl)
		{
			include $pl;
		}
		/* ===== */
		$tt->parse('MAIN.ADMIN_TAGS_ROW');
		$ii++;
}
 
$tt->assign(array(
	'ADMIN_TAGS_CONFIG_URL' => cot_url('admin', 'm=config&n=edit&o=plug&p=tags'),
	'ADMIN_TAGS_ADMINWARNINGS' => $adminwarnings,
	'ADMIN_TAGS_FORM_ACTION' => cot_url('admin', 'm=other&p=tags'),
	'ADMIN_TAGS_ORDER' => cot_selectbox($sorttype, 'sorttype', array_keys($sort_type), array_values($sort_type), false),
	'ADMIN_TAGS_WAY' => cot_selectbox($sortway, 'sortway', array_keys($sort_way), array_values($sort_way), false),
	'ADMIN_TAGS_FILTER' => cot_selectbox($filter, 'filter', array_keys($filter_type), array_values($filter_type), false),
	'ADMIN_TAGS_PAGINATION_PREV' => $pagenav['prev'],
	'ADMIN_TAGS_PAGNAV' => $pagenav['main'],
	'ADMIN_TAGS_PAGINATION_NEXT' => $pagenav['next'],
	'ADMIN_TAGS_TOTALITEMS' => $totalitems,
	'ADMIN_TAGS_COUNTER_ROW' => $ii
));
 
/* === Hook  === */
foreach (cot_getextplugins('admin.tags.tags') as $pl)
{
	include $pl;
}
/* ===== */
 
cot_display_messages($tt);
 
$tt->parse('MAIN');
$adminmain = $tt->text('MAIN');
 
 

This documentation pages was generated by PHPDoctor with «HTML_BS» doclet styles.