function main($id, $mode)
{
global $db, $user, $auth, $template, $cache;
global $config, $SID, $phpbb_root_path, $phpbb_admin_path, $phpEx;
$user->add_lang('acp/k_cloud');
$this->tpl_name = 'acp_k_cloud';
$this->page_title = 'ACP_CLOUD';
$form_key = 'acp_k_cloud';
add_form_key($form_key);
$s_hidden_fields = '';
$tag_id = '';
$mode = request_var('mode', '');
$tag_id = request_var('tag_id', '');
$action = request_var('config', '');
//$cloud_group = request_var('cloud_group', '');
$action = isset($_POST['add_tag']) ? 'add' : (isset($_POST['save']) ? 'save' : (isset($_POST['config']) ? 'config' : $action));
switch ($action) {
case 'config':
$template->assign_vars(array('MESSAGE' => $user->lang['SWITCHING']));
meta_refresh(1, "{$phpbb_root_path}adm/index.{$phpEx}{$SID}&i=k_vars&mode=config&switch=k_cloud_vars.html");
break;
case 'add':
$mode = '';
meta_refresh(0, "{$phpbb_root_path}adm/index.{$phpEx}{$SID}&i=k_cloud&mode=add");
break;
default:
}
$submit = isset($_POST['submit']) ? true : false;
if (!$action && $mode == 'browse') {
}
get_cloud_data();
if ($submit && !check_form_key($form_key)) {
$submit = false;
$mode = '';
trigger_error($user->lang['FORM_INVALID'] . basename(dirname(__FILE__)) . '/' . basename(__FILE__) . ', line ' . __LINE__);
}
$template->assign_vars(array('U_BACK' => "{$phpbb_root_path}adm/index.{$phpEx}{$SID}&i=k_cloud", 'U_ADD' => "{$phpbb_root_path}adm/index.{$phpEx}{$SID}&i=k_cloud&mode=add", 'U_EDIT' => "{$phpbb_root_path}adm/index.{$phpEx}{$SID}&i=k_cloud&mode=edit" . '&tag_id=' . $tag_id, 'U_DELETE' => "{$phpbb_root_path}adm/index.{$phpEx}{$SID}&i=k_cloud&mode=delete" . '&tag_id=' . $tag_id, 'U_BROWSE' => "{$phpbb_root_path}adm/index.{$phpEx}{$SID}&i=k_cloud&mode=browse", 'U_SWATCH1' => append_sid("{$phpbb_admin_path}swatch2.{$phpEx}", 'form=acp_k_cloud&name=colour'), 'U_SWATCH2' => append_sid("{$phpbb_admin_path}swatch2.{$phpEx}", 'form=acp_k_cloud&name=colour2'), 'U_SWATCH3' => append_sid("{$phpbb_admin_path}swatch2.{$phpEx}", 'form=acp_k_cloud&name=hcolour'), 'S_OPTION' => 'browse'));
switch ($mode) {
case 'edit':
if ($submit) {
$tag_id = request_var('tag_id', '');
$is_active = request_var('is_active', '');
$tag = request_var('tag', '');
$link = request_var('link', '');
$rel = request_var('rel', '');
$font_size = request_var('font_size', '');
$colour = request_var('colour', '');
$colour2 = request_var('colour2', '');
$hcolour = request_var('hcolour', '');
$text = utf8_normalize_nfc(request_var('text', '', true));
$colour = str_replace("#", "", $colour);
$colour2 = str_replace("#", "", $colour2);
$hcolour = str_replace("#", "", $hcolour);
$sql_ary = array('tag_id' => $tag_id, 'is_active' => $is_active, 'tag' => $tag, 'link' => $link, 'rel' => $rel, 'font_size' => $font_size, 'colour' => $colour, 'colour2' => $colour2, 'hcolour' => $hcolour, 'text' => $text);
$sql = 'UPDATE ' . K_CLOUD_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . " WHERE tag_id = {$tag_id}";
if (!($result = $db->sql_query($sql))) {
trigger_error($user->lang['ERROR_PORTAL_CLOUD'] . basename(dirname(__FILE__)) . '/' . basename(__FILE__) . ', line ' . __LINE__);
}
$cache->destroy('sql', K_CLOUD_TABLE);
$template->assign_vars(array('MESSAGE' => $user->lang['DATA_IS_BEING_SAVED'] . '</font><br />', 'S_OPTION' => 'save'));
meta_refresh(1, "{$phpbb_root_path}adm/index.{$phpEx}{$SID}&i=k_cloud&mode=browse");
break;
}
get_tag_item($tag_id);
$template->assign_var('S_OPTION', 'edit');
break;
case 'delete':
if (!$tag_id) {
trigger_error($user->lang['MUST_SELECT_VALID_CLOUD_DATA'] . adm_back_link($this->u_action), E_USER_WARNING);
}
if (confirm_box(true)) {
/*
$sql = 'SELECT tag_id
FROM ' . K_CLOUD_TABLE . '
WHERE tag_id = ' . $tag_id;
$result = $db->sql_query($sql);
*/
//$tag_id = (int) $db->sql_fetchfield('tag_id');
//$db->sql_freeresult($result);
//$colour2 .= ' Tag ';
$sql = 'DELETE FROM ' . K_CLOUD_TABLE . '
WHERE tag_id = ' . $tag_id;
$db->sql_query($sql);
$template->assign_vars(array('MESSAGE' => $user->lang['DELETING'] . $tag_id . '</font><br />', 'S_OPTION' => 'delete'));
$cache->destroy('sql', K_CLOUD_TABLE);
meta_refresh(1, "{$phpbb_root_path}adm/index.{$phpEx}{$SID}&i=k_cloud&mode=browse");
break;
} else {
confirm_box(false, $user->lang['CONFIRM_OPERATION_CLOUD'], build_hidden_fields(array('i' => $id, 'mode' => $mode, 'action' => 'delete')));
}
$template->assign_vars(array('MESSAGE' => $user->lang['ACTION_CANCELLED']));
meta_refresh(1, "{$phpbb_root_path}adm/index.{$phpEx}{$SID}&i=k_cloud&mode=browse");
break;
case 'add':
if ($submit) {
//$tag_id =request_var('tag_id', '');
$is_active = request_var('is_active', '');
$tag = request_var('tag', '');
$link = request_var('link', '');
$rel = request_var('rel', '');
$font_size = request_var('font_size', '');
$colour = request_var('colour', '');
$colour2 = request_var('colour2', '');
$hcolour = request_var('hcolour', '');
$text = utf8_normalize_nfc(request_var('text', '', true));
if (strstr($link, $user->lang['NONE'])) {
$link = '';
}
$colour = str_replace("#", "", $colour);
$colour2 = str_replace("#", "", $colour2);
$hcolour = str_replace("#", "", $hcolour);
$sql_array = array('is_active' => $is_active, 'tag' => $tag, 'link' => $link, 'rel' => $rel, 'font_size' => $font_size, 'colour' => $colour, 'colour2' => $colour2, 'hcolour' => $hcolour, 'text' => $text);
$db->sql_query('INSERT INTO ' . K_CLOUD_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_array));
$cache->destroy('sql', K_CLOUD_TABLE);
meta_refresh(1, "{$phpbb_root_path}adm/index.{$phpEx}{$SID}&i=k_cloud&mode=browse");
$template->assign_vars(array('L_MENU_REPORT' => $user->lang['TAG_CREATED']));
break;
} else {
get_tag_item(0);
$template->assign_var('S_OPTION', 'add');
$mode = 'add';
break;
}
case 'config':
//get_cloud_data();
break;
case 'default':
//get_cloud_data();
}
$template->assign_vars(array('U_ACTION' => $this->u_action, 'S_HIDDEN_FIELDS' => $s_hidden_fields));
//$template->assign_vars(array('U_ACTION' => $u_action));
}
if (!empty($tags)) {
foreach ($tags as $t) {
$array[] = get_tag($t);
}
echo implode(', ', $array);
} else {
echo "";
}
?>
</td>
<td><?php
$tags_items = unserialize($v->tag_item);
$array = array();
if (!empty($tags_items)) {
foreach ($tags_items as $t) {
$array[] = get_tag_item($t);
}
echo implode(', ', $array);
} else {
echo "";
}
?>
</td>
<td><?php
echo $v->learning_objective;
?>
</td>
<td class="materialstd-link" style="">
<?php
if (isset($v->tasks) and !empty($v->tasks)) {
?>
<!--#####################################################################
#
# File : EDIT TAG
# Project : Game Magazine Project
# Author : Béo Sagittarius
# Created : 07/01/2015
#
##################################################################### -->
<?php
include '../includes/backend/mysqli_connect.php';
include '../includes/functions.php';
$title_page = 'Edit Game';
if ($tid = validate_id($_GET['tid'])) {
$result = get_tag_item($tid);
if (mysqli_num_rows($result) == 1) {
$tag = mysqli_fetch_array($result, MYSQLI_ASSOC);
} else {
redirect_to('admin/list_tag.php');
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$errors = array();
// validate tag
if (empty($_POST['tag'])) {
$errors[] = "tag";
} else {
$tag = mysqli_real_escape_string($dbc, strip_tags($_POST['tag']));
}
if (empty($errors)) {
$result = edit_tag($tid, $tag);
if (mysqli_affected_rows($dbc) == 1) {
echo "<script type='text/javascript'>\n alert('{$lang['AD_EDIT_GAME_SUCCESS']}');\n window.location = 'list_tag.php';\n </script>\n ";
