$result = $db->sql_query($sql); $tags_data = $db->sql_fetchrow($result); $db->sql_freeresult($result); $tags = implode("\n", get_tags_from_text($tags_data['meeting_tags'])); $marshrut_return = $tags_data['marshrut_return']; $no_tags = !$tags_data['meeting_tags'] ? 1 : 0; // Set template file $template->set_filenames(array('body' => 'aljax_quick_edit_marshrut.html')); $_RESULT['success'] = true; if (isset($_REQUEST['submit'])) { /** Serve saving edited post */ // Prepare text to saving into DB $content = request_var('content', '', true); $tag_ary = get_tags_from_text($content); $meeting_tags = ''; if (sizeof($tag_ary)) { for ($k = 0; $k < sizeof($tag_ary); $k++) { $meeting_tags .= '[tag_delim]' . $tag_ary[$k]; } $meeting_tags .= '[tag_delim]'; } $sql_array = array('meeting_tags' => $meeting_tags, 'marshrut_return' => $return); $sql = 'UPDATE ' . MEETING_DATA_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_array) . " WHERE meeting_id = {$meeting_id}"; $db->sql_query($sql); $marshrutrow = get_marshrut_meeting($meeting_id); if (sizeof($marshrutrow) && sizeof($tag_ary)) { $marshrut_id = $marshrutrow['marshrut_id']; $sql_array_marshrut = array('marshrut_tags' => $meeting_tags, 'marshrut_return' => $return); $sql = 'UPDATE ' . MARSHRUT_DATA_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_array_marshrut) . " WHERE marshrut_id = {$marshrut_id}";
function tags_meeting_handle_data_end_clear(&$args, $marshrut_return, &$color) { global $user, $phpbb_root_path, $phpEx, $meeting_tags; $meeting_tags = ''; $tags = array(); $count_tags = 0; foreach (get_tags_from_text($args) as $tag) { $tags[] = $tag; $count_tags = $count_tags + 1; } if ($marshrut_return == 1) { if ($color) { $tags[$count_tags] = '<font color="#FF0000">' . $tags[0] . '</font>'; } else { $tags[$count_tags] = $tags[0]; } } if (sizeof($tags)) { $meeting_tags .= implode(' - ', $tags); } //trigger_error($meeting_tags); return $meeting_tags; }
public function tags_meeting_edit_sql(&$tags, $no_tags, $tag_text) { global $meeting_id, $id, $cache, $db; // If there were not tags before we edited we simply need to add the new tags if ($no_tags == 1) { tags_meeting_add_sql($tags); return; } $all_tags = get_meeting_tags(); $tag_ary = get_tags_from_text_2($tags); $old_tags = get_tags_from_text($tag_text); //$tags = request_var('tags', '', true); $new_tags = ''; foreach ($old_tags as $tag) { if (!in_array($tag, $tag_ary)) { if ($all_tags[$tag]['tag_count'] == 1) { $db->sql_query('DELETE FROM ' . MEETING_TAGS_TABLE . ' WHERE tag_id = ' . $all_tags[$tag]['tag_id']); $cache->destroy('sql', MEETING_TAGS_TABLE); } else { $db->sql_query('UPDATE ' . MEETING_TAGS_TABLE . ' SET tag_count = tag_count - 1 WHERE tag_id = ' . $all_tags[$tag]['tag_id']); } } } foreach ($tag_ary as $tag) { if (!in_array($tag, $old_tags)) { $new_tags .= $tag . "\n"; } } $cache->destroy('_meeting_tags'); tags_meeting_add_sql($args, $new_tags); //$args['blog_tags'] = '[tag_delim]' . implode('[tag_delim]', $tag_ary) . '[tag_delim]'; }
switch (self::$plugins[$which]['plugin_version']) { case '0.7.0': case '0.7.1': default: if (!defined('BLOGS_TAGS_TABLE')) { define('BLOGS_TAGS_TABLE', $table_prefix . 'blogs_tags'); } if (!function_exists('get_tags_from_text')) { include $blog_plugins_path . 'tags/functions.' . $phpEx; } $db->sql_query('DELETE FROM ' . BLOGS_TAGS_TABLE); $all_tags = get_blog_tags(); $sql = 'SELECT blog_id, blog_tags FROM ' . BLOGS_TABLE; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) { $tag_ary = get_tags_from_text($row['blog_tags']); if (!sizeof($tag_ary)) { continue; } $db->sql_query('UPDATE ' . BLOGS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', array('blog_tags' => '[tag_delim]' . implode('[tag_delim]', $tag_ary) . '[tag_delim]')) . ' WHERE blog_id = ' . $row['blog_id']); foreach ($tag_ary as $tag) { if (isset($all_tags[$tag])) { $db->sql_query('UPDATE ' . BLOGS_TAGS_TABLE . ' SET tag_count = tag_count + 1 WHERE tag_id = ' . $all_tags[$tag]['tag_id']); } else { $sql_ary = array('tag_name' => $tag, 'tag_count' => 1); $db->sql_query('INSERT INTO ' . BLOGS_TAGS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary)); $all_tags[$tag] = array('tag_id' => $db->sql_nextid()); } } } $cache->destroy('_blog_tags');
function tags_function_handle_basic_posting_data(&$args) { global $blog_id, $template, $user; if ($args['page'] != 'blog') { return; } $args['panels']['tags-panel'] = $user->lang['TAGS']; $tags = ''; if ($args['mode'] == 'edit' && isset(blog_data::$blog[$blog_id]['blog_tags'])) { $tags = implode("\n", get_tags_from_text(blog_data::$blog[$blog_id]['blog_tags'])); } $template->assign_vars(array('TAGS' => request_var('tags', $tags, true))); $args['panel_data'] = blog_plugins::parse_template('blog/plugins/tags/tags_panel.html'); }
$meeting_guest_single = intval($meeting_guest_single); $meeting_guest_names = intval($meeting_guest_names); $meeting_guest_phone = intval($meeting_guest_phone); $meeting_marshrut = intval($meeting_marshrut); $meeting_phone = str_replace("\\'", "''", trim($meeting_phone)); $meeting_auth_avatar = $user->data['user_avatar'] ? $user->data['user_avatar'] : ''; $user_avatar_type = $user->data['user_avatar_type'] ? $user->data['user_avatar_type'] : 0; $meeting_flag = intval($meeting_flag); $meeting_plain_road_1 = (int) $meeting_plain_road_1; $meeting_plain_road_2 = (int) $meeting_plain_road_2; $meeting_plain_road_3 = (int) $meeting_plain_road_3; $meeting_plain_km = (int) $meeting_plain_km; $meeting_el_link = htmlspecialchars(trim($meeting_el_link)); // TAGS ------------ $meeting_tags = $tags = request_var('tags', '', true); $tag_ary = get_tags_from_text($meeting_tags); $no_tags = request_var('no_tags', 0); $tag_text = request_var('tag_text', '', true); $meeting_tags = ''; if (sizeof($tag_ary)) { for ($k = 0; $k < sizeof($tag_ary); $k++) { $meeting_tags .= '[tag_delim]' . $tag_ary[$k]; } $meeting_tags .= '[tag_delim]'; } // END TAGS ------------ $total_attrib = count($meeting_attrib); $meeting_attributes = ''; for ($i = 0; $i < $total_attrib; $i++) { $meeting_attributes .= $meeting_attrib[$i]; if ($i < $total_attrib - 1) {