$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) {
