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