Changeset 156

User picture

Author: Mighty Gorgon

(2009/12/17 14:01) About 2 years ago

Added the possibility to use TAGS instead of Wordgraph when viewing a forum

Affected files

Updated ip/trunk/includes/class_topics_tags.php Download diff

155156
95
	/*
95
	/*
96
	* Update tag entry
96
	* Update tag entry
97
	*/
97
	*/
 
98
	function update_tag_entry($tag_id)
98
	function update_tag_entry($tag_ids_array, $remove_zero_tags = false)
 
99
	{
99
	{
100
		global $db, $lang;
100
		global $db, $lang;
101
101



102
		$tag_count = 0;
102
		if (!is_array($tag_ids_array))



103
		$sql = "SELECT COUNT(tag_id) as tag_count FROM " . TOPICS_TAGS_MATCH_TABLE . " WHERE tag_id = " . $tag_id;



104
		$result = $db->sql_query($sql);



105
		if ($row = $db->sql_fetchrow($result))



106
		{
103
		{



107
			$tag_count = $row['tag_count'];
104
			$tag_ids_array = array($tag_ids_array);



108
			$db->sql_freeresult($result);



109
		}
105
		}



110
106



111
		$sql = "UPDATE " . TOPICS_TAGS_LIST_TABLE . " SET tag_count = " . $tag_count . " WHERE tag_id = " . $tag_id;
107
		for ($i = 0; $i < sizeof($tag_ids_array); $i++)



112
		$db->sql_query($sql);
108
		{



109
			$tag_count = 0;



110
			$sql = "SELECT COUNT(tag_id) as tag_count FROM " . TOPICS_TAGS_MATCH_TABLE . " WHERE tag_id = " . $tag_ids_array[$i];



111
			$result = $db->sql_query($sql);



112
			if ($row = $db->sql_fetchrow($result))



113
			{



114
				$tag_count = $row['tag_count'];



115
				$db->sql_freeresult($result);



116
			}



113
117



114
		$this->remove_zero_tags();
118
			$sql = "UPDATE " . TOPICS_TAGS_LIST_TABLE . " SET tag_count = " . $tag_count . " WHERE tag_id = " . $tag_ids_array[$i];



119
			$db->sql_query($sql);



120
		}



115
121



122
		if ($remove_zero_tags)



123
		{



124
			$this->remove_zero_tags();



125
		}



126



116
		return $tag_id;
127
		return $tag_id;



117
	}
128
	}



118
129


...
...
171
				$db->sql_query($sql);
182
				$db->sql_query($sql);



172
				if (!$tag_created)
183
				if (!$tag_created)



173
				{
184
				{



174
					$tag_id = $this->update_tag_entry($tag_id);
185
					$tag_id = $this->update_tag_entry($tag_id, false);



175
				}
186
				}



176
			}
187
			}



177
		}
188
		}



189
		$this->remove_zero_tags();



178
190



179
		return true;
191
		return true;



180
	}
192
	}


...
...
356
				$tag_id = $row['tag_id'];
368
				$tag_id = $row['tag_id'];



357
				$tags_ids_array = array($tag_id);
369
				$tags_ids_array = array($tag_id);



358
				$this->remove_tag_from_match($tags_ids_array, $topic_id);
370
				$this->remove_tag_from_match($tags_ids_array, $topic_id);



359
				$tag_id = $this->update_tag_entry($tag_id);
371
				$tag_id = $this->update_tag_entry($tag_id, false);



360
			}
372
			}



361
		}
373
		}



374
		$this->remove_zero_tags();



362
375



363
		return true;
376
		return true;



364
	}
377
	}


...
...
383
				$tag_id = $row['tag_id'];
396
				$tag_id = $row['tag_id'];



384
				$tags_ids_array = array($tag_id);
397
				$tags_ids_array = array($tag_id);



385
				$this->remove_tag_from_match($tags_ids_array, $topic_id);
398
				$this->remove_tag_from_match($tags_ids_array, $topic_id);



386
				$tag_id = $this->update_tag_entry($tag_id);
399
				$tag_id = $this->update_tag_entry($tag_id, false);



387
			}
400
			}



388
		}
401
		}



402
		$this->remove_zero_tags();



389
403



390
		return true;
404
		return true;



391
	}
405
	}





          

  Updated
ip/trunk/includes/forum_wordgraph.php  Download diff




      
      
155156
17
17



18
$words_array = array();
18
$words_array = array();



19
19



20
$sql = 'SELECT w.word_text, COUNT(*) AS word_count
20
if ($config['forum_tags_type'])



21
	FROM ' . SEARCH_WORD_TABLE . ' AS w, ' . SEARCH_MATCH_TABLE . ' AS m, ' . POSTS_TABLE . ' AS p, ' . TOPICS_TABLE . ' AS t
21
{



22
	WHERE m.word_id = w.word_id
22
	$sql = 'SELECT w.word_text, COUNT(*) AS word_count



23
	AND m.post_id = p.post_id
23
		FROM ' . SEARCH_WORD_TABLE . ' AS w, ' . SEARCH_MATCH_TABLE . ' AS m, ' . POSTS_TABLE . ' AS p, ' . TOPICS_TABLE . ' AS t



24
	AND p.topic_id = t.topic_id
24
		WHERE m.word_id = w.word_id



25
	AND t.forum_id = ' . $forum_id . '
25
		AND m.post_id = p.post_id



26
	GROUP BY m.word_id
26
		AND p.topic_id = t.topic_id



27
	ORDER BY word_count DESC LIMIT ' . intval($config['word_graph_max_words']);
27
		AND t.forum_id = ' . $forum_id . '



28
$result = $db->sql_query($sql, 0, 'forums_wg_', FORUMS_CACHE_FOLDER);
28
		GROUP BY m.word_id



29
		ORDER BY word_count DESC



30
		LIMIT ' . intval($config['word_graph_max_words']);



31
	$result = $db->sql_query($sql, 86400, 'forums_wg_' . str_pad($forum_id, 8, '0') . '_', FORUMS_CACHE_FOLDER);



32
}



33
else



34
{



35
	$sql = "SELECT l.tag_text as word_text, l.tag_count as word_count



36
					FROM " . TOPICS_TAGS_LIST_TABLE . " l, " . TOPICS_TAGS_MATCH_TABLE . " m



37
					WHERE m.forum_id = " . $forum_id . "



38
						AND l.tag_id = m.tag_id



39
					GROUP BY m.tag_id



40
					ORDER BY l.tag_count DESC



41
					LIMIT " . intval($config['word_graph_max_words']);



42
	$result = $db->sql_query($sql, 86400, 'forums_tags_' . str_pad($forum_id, 8, '0') . '_', FORUMS_CACHE_FOLDER);



43
}



29
44



30
while ($row = $db->sql_fetchrow($result))
45
while ($row = $db->sql_fetchrow($result))



31
{
46
{


...
...
62
{
77
{



63
	$ratio = intval(mt_rand(8, 14));
78
	$ratio = intval(mt_rand(8, 14));



64
	$template->assign_block_vars('forum_wordgraph.wordgraph_loop', array(
79
	$template->assign_block_vars('forum_wordgraph.wordgraph_loop', array(



65
		'WORD' => ($config['word_graph_word_counts']) ? $word . ' (' . $words_array[$word] . ')' : $word,
80
		'WORD' => htmlspecialchars($word) . (($config['word_graph_word_counts']) ? (' (' . $words_array[$word] . ')') : ''),



66
		'WORD_FONT_SIZE' => $ratio,
81
		'WORD_FONT_SIZE' => $ratio,



67
		'WORD_SEARCH_URL' => append_sid(CMS_PAGE_SEARCH . '?search_keywords=' . urlencode($word)),
82
		'WORD_SEARCH_URL' => $config['forum_tags_type'] ? append_sid(CMS_PAGE_SEARCH . '?search_keywords=' . htmlspecialchars(urlencode($word))) :  append_sid(CMS_PAGE_TAGS . '?mode=view&amp;tag_text=' . htmlspecialchars(urlencode($word))),



68
		)
83
		)



69
	);
84
	);



70
}
85
}





          

  Updated
ip/trunk/includes/functions_dbmtnc.php  Download diff




      
      
155156
598
	'display_tags_box' => '0',
598
	'display_tags_box' => '0',



599
	'allow_moderators_edit_tags' => '0',
599
	'allow_moderators_edit_tags' => '0',



600
	'enable_custom_bbcodes' => '0',
600
	'enable_custom_bbcodes' => '0',



601
	'forum_tags_type' => '0',



601
602



602
	// IP Version
603
	// IP Version



603
	'ip_version' => ICYPHOENIX_VERSION,
604
	'ip_version' => ICYPHOENIX_VERSION,





          

  Updated
ip/trunk/includes/mods_settings/mod_seo.php  Download diff




      
      
155156
102
			),
102
			),



103
		),
103
		),



104
104



105
	'display_tags_box' => array(



106
		'lang_key' => 'IP_display_tags_box',



107
		'explain' => 'IP_display_tags_box_explain',



108
		'type' => 'LIST_RADIO',



109
		'default' => 'No',



110
		'values' => $list_yes_no,



111
		),



112



113
	'allow_moderators_edit_tags' => array(



114
		'lang_key' => 'IP_allow_moderators_edit_tags',



115
		'explain' => 'IP_allow_moderators_edit_tags_explain',



116
		'type' => 'LIST_RADIO',



117
		'default' => 'No',



118
		'values' => $list_yes_no,



119
		),



120



105
	'word_graph_max_words' => array(
121
	'word_graph_max_words' => array(



106
		'lang_key' => 'IP_word_graph_max_words',
122
		'lang_key' => 'IP_word_graph_max_words',



107
		'explain' => 'IP_word_graph_max_words_explain',
123
		'explain' => 'IP_word_graph_max_words_explain',


...
...
125
		'values' => $list_yes_no,
141
		'values' => $list_yes_no,



126
		),
142
		),



127
143



144
	'forum_tags_type' => array(



145
		'lang_key' => 'IP_forum_tags_type',



146
		'explain' => 'IP_forum_tags_type_explain',



147
		'type' => 'LIST_RADIO',



148
		'default' => 'No',



149
		'values' => array(



150
			'IP_forum_tags_type_tags' => '0',



151
			'IP_forum_tags_type_wordgraph' => '1',



152
			),



153
		),



154



128
	'similar_topics' => array(
155
	'similar_topics' => array(



129
		'lang_key' => 'IP_similar_topics',
156
		'lang_key' => 'IP_similar_topics',



130
		'explain' => 'IP_similar_topics_explain',
157
		'explain' => 'IP_similar_topics_explain',





          

  Updated
ip/trunk/install/clean_tables_ip.php  Download diff




      
      
155156
135
}
135
}



136
136



137
// This array holds the table names which are created by Icy Phoenix, as well as their fieldnames
137
// This array holds the table names which are created by Icy Phoenix, as well as their fieldnames



138
$config_records = array('config_id', 'board_disable', 'sitename', 'site_desc', 'cookie_name', 'cookie_path', 'cookie_domain', 'cookie_secure', 'session_length',
'allow_html', 'allow_html_tags', 'allow_bbcode', 'allow_smilies', 'allow_sig', 'allow_namechange', 'allow_theme_create', 'allow_avatar_local',
'allow_avatar_remote', 'allow_avatar_upload', 'enable_confirm', 'override_user_style', 'posts_per_page', 'topics_per_page', 'hot_threshold', 'max_poll_options',
'max_sig_chars', 'max_inbox_privmsgs', 'max_sentbox_privmsgs', 'max_savebox_privmsgs', 'board_email_sig', 'board_email', 'smtp_delivery', 'smtp_host',
'smtp_username', 'smtp_password', 'sendmail_fix', 'require_activation', 'flood_interval', 'board_email_form', 'avatar_filesize', 'avatar_max_width',
'avatar_max_height', 'avatar_path', 'avatar_gallery_path', 'smilies_path', 'default_style', 'default_dateformat', 'board_timezone', 'prune_enable',
'privmsg_disable', 'gzip_compress', 'coppa_fax', 'coppa_mail', 'record_online_users', 'record_online_date', 'server_name', 'server_port', 'script_path',
'sig_line', 'birthday_required', 'birthday_greeting', 'max_user_age', 'min_user_age', 'birthday_check_day', 'bluecard_limit', 'bluecard_limit_2',
'max_user_bancard', 'report_forum', 'index_rating_return', 'min_rates_number', 'rating_max', 'allow_ext_rating', 'large_rating_return_limit',
'check_anon_ip_when_rating', 'allow_rerate', 'header_rating_return_limit', 'default_time_mode', 'default_dst_time_lag', 'search_flood_interval', 'rand_seed',
'allow_news', 'news_item_trim', 'news_title_trim', 'news_item_num', 'news_path', 'allow_rss', 'news_rss_desc', 'news_rss_language', 'news_rss_ttl',
'news_rss_cat', 'news_rss_image', 'news_rss_image_desc', 'news_rss_item_count', 'news_rss_show_abstract', 'news_base_url', 'news_index_file',
'dbmtnc_rebuild_end', 'dbmtnc_rebuild_pos', 'dbmtnc_rebuildcfg_maxmemory', 'dbmtnc_rebuildcfg_minposts', 'dbmtnc_rebuildcfg_php3only',
'dbmtnc_rebuildcfg_php3pps', 'dbmtnc_rebuildcfg_php4pps', 'dbmtnc_rebuildcfg_timelimit', 'dbmtnc_rebuildcfg_timeoverwrite', 'dbmtnc_disallow_postcounter',
'dbmtnc_disallow_rebuild', 'default_avatar_guests_url', 'default_avatar_users_url', 'enable_gravatars', 'gravatar_rating', 'gravatar_default_image',
'default_avatar_set', 'bin_forum', 'liw_enabled', 'liw_sig_enabled', 'liw_max_width', 'liw_attach_enabled', 'xs_news_version', 'board_disable_message',
'board_disable_mess_st', 'sitemap_announce_priority', 'sitemap_default_priority', 'sitemap_sort', 'sitemap_sticky_priority', 'sitemap_topic_limit',
'registration_status', 'registration_closed', 'prune_shouts', 'xs_shownav', 'allow_avatar_generator', 'avatar_generator_template_path',
'avatar_generator_version', 'max_login_attempts', 'login_reset_time', 'hidde_last_logon', 'online_time', 'gzip_level', 'gender_required', 'smilie_columns',
'smilie_rows', 'smilie_window_columns', 'allow_autologin', 'max_autologin_time', 'autolink_first', 'smilies_insert', 'sudoku_version', 'yahoo_search_savepath',
'yahoo_search_additional_urls', 'yahoo_search_compress', 'yahoo_search_compression_level', 'max_link_bookmarks', 'visit_counter', 'word_graph_max_words',
'word_graph_word_counts', 'search_min_chars', 'disable_registration_ip_check', 'extra_max', 'extra_display', 'upi2db_max_permanent_topics', 'upi2db_del_mark',
'upi2db_del_perm', 'upi2db_max_mark_posts', 'upi2db_unread_color', 'upi2db_edit_color', 'upi2db_mark_color', 'upi2db_auto_read', 'upi2db_edit_as_new',
'upi2db_last_edit_as_new', 'upi2db_on', 'upi2db_edit_topic_first', 'upi2db_no_group_min_regdays', 'upi2db_no_group_min_posts', 'upi2db_no_group_upi2db_on',
'upi2db_install_time', 'upi2db_delete_old_data', 'upi2db_max_new_posts', 'upi2db_version', 'use_captcha', 'version', 'board_startdate', 'default_lang',
'calendar_display_open', 'calendar_display_open_over', 'calendar_header_cells', 'calendar_header_cells_over', 'calendar_week_start', 'calendar_week_start_over',
'calendar_title_length', 'calendar_text_length', 'calendar_nb_row', 'calendar_nb_row_over', 'calendar_birthday', 'calendar_birthday_over', 'calendar_forum',
'calendar_forum_over', 'sub_forum', 'sub_forum_over', 'split_cat', 'split_cat_over', 'last_topic_title', 'last_topic_title_over', 'last_topic_title_length',
'sub_level_links', 'sub_level_links_over', 'display_viewonline', 'display_viewonline_over', 'max_posts', 'max_topics', 'max_users', 'xs_auto_compile',
'xs_auto_recompile', 'xs_use_cache', 'xs_php', 'xs_def_template', 'xs_check_switches', 'xs_warn_includes', 'xs_add_comments', 'xs_ftp_host', 'xs_ftp_login',
'xs_ftp_path', 'xs_downloads_count', 'xs_downloads_default', 'xs_template_time', 'xs_version', 'similar_stopwords', 'similar_ignore_forums_ids',
'similar_sort_type', 'similar_max_topics', 'similar_topics', 'bb_usage_stats_viewlevel', 'bb_usage_stats_viewoptions', 'bb_usage_stats_specialgrp',
'bb_usage_stats_prscale', 'bb_usage_stats_trscale', 'forum_wordgraph', 'shoutbox_floodinterval', 'display_shouts', 'stored_shouts', 'shoutbox_refreshtime',
'shout_allow_guest', 'upi2db_max_new_posts_admin', 'upi2db_max_new_posts_mod', 'smilie_window_rows', 'bots_color', 'show_calendar_box_index', 'url_rw',
'xmas_fx', 'switch_header_table', 'header_table_text', 'fast_n_furious', 'new_msgs_mumber', 'index_last_msgs', 'portal_last_msgs', 'online_last_msgs',
'index_shoutbox', 'portal_shoutbox', 'online_shoutbox', 'last_msgs_n', 'last_msgs_x', 'posts_precompiled', 'index_links', 'index_birthday', 'site_history',
'smilies_topic_title', 'html_email', 'config_cache', 'admin_protect', 'ftr_disable', 'disable_logins', 'last_logins_n', 'edit_notes', 'edit_notes_n',
'quote_iterations', 'page_gen', 'birthday_viewtopic', 'img_shoutbox', 'split_ga_ann_sticky', 'email_notification_html', 'select_theme', 'select_lang',
'show_icons', 'show_random_quote', 'visit_counter_switch', 'emails_only_to_admins', 'no_right_click', 'gd_version', 'show_img_no_gd', 'show_pic_size_on_thumb',
'thumbnail_posts', 'thumbnail_cache', 'thumbnail_quality', 'thumbnail_size', 'disable_html_guests', 'disable_email_error', 'switch_header_dropdown',
'switch_poster_info_topic', 'switch_bbcb_active_content', 'thumbnail_lightbox', 'enable_quick_quote', 'enable_xs_version_check', 'allow_all_bbcode',
'ip_version', 'enable_digests', 'digests_php_cron', 'digests_last_send_time', 'xmas_gfx', 'google_bot_detector', 'logs_path', 'url_rw_guests', 'lofi_bots',
'ajax_checks_register', 'inactive_users_memberlists', 'auth_view_pic_upload', 'enable_postimage_org', 'enable_new_messages_number', 'disable_thanks_topics',
'ajax_features', 'show_rss_forum_icon', 'disable_acronyms', 'disable_autolinks', 'disable_censor', 'global_disable_acronyms', 'global_disable_autolinks',
'global_disable_censor', 'disable_topic_view', 'disable_referrers', 'aprvmArchive', 'aprvmVersion', 'aprvmView', 'aprvmRows', 'aprvmIP', 'page_title_simple',
'digests_php_cron_lock', 'mg_log_actions', 'cash_disable', 'cash_display_after_posts', 'cash_post_message', 'cash_disable_spam_num', 'cash_disable_spam_time',
'cash_disable_spam_message', 'cash_installed', 'cash_version', 'cash_adminbig', 'cash_adminnavbar', 'points_name', 'active_users_color', 'active_users_legend',
'bots_legend', 'show_social_bookmarks', 'show_forums_online_users', 'cms_dock', 'smilie_single_row', 'main_admin_id', 'allow_mods_edit_admin_posts',
'force_large_caps_mods', 'enable_colorpicker', 'always_show_edit_by', 'show_new_reply_posting', 'show_chat_online', 'allow_zebra', 'allow_mods_view_self',
'enable_own_icons', 'show_thanks_profile', 'show_thanks_viewtopic', 'index_top_posters', 'global_disable_upi2db', 'last_user_id', 'write_errors_log',
'write_digests_log', 'no_bump', 'link_this_topic', 'cms_style', 'show_alpha_bar', 'db_log_actions', 'show_topic_description', 'bots_reg_auth',
'cron_global_switch', 'cron_lock', 'cron_queue_interval', 'cron_queue_last_run', 'cron_digests_interval', 'cron_digests_last_run', 'cron_files_interval',
'cron_files_last_run', 'cron_database_interval', 'cron_database_last_run', 'cron_cache_interval', 'cron_cache_last_run', 'cron_sql_interval',
'cron_sql_last_run', 'cron_users_interval', 'cron_users_last_run', 'cron_topics_interval', 'cron_topics_last_run', 'cron_sessions_interval',
'cron_sessions_last_run', 'cron_db_count', 'cron_db_show_begin_for', 'cron_db_show_not_optimized', 'rand_seed_last_update', 'gsearch_guests', 'ads_glt',
'ads_glb', 'ads_glh', 'ads_glf', 'ads_fix', 'ads_fit', 'ads_fib', 'ads_vfx', 'ads_vft', 'ads_vfb', 'ads_vtx', 'ads_vtt', 'ads_vtb', 'ads_nmt', 'ads_nmb',
'adsense_code', 'google_analytics', 'thumbnail_highslide', 'read_only_forum', 'forum_limit_edit_time_interval', 'ftr_topic_number', 'ftr_message',
'ftr_install_time', 'ftr_all_users', 'allow_html_only_for_admins', 'display_tags_box', 'allow_moderators_edit_tags', 'enable_custom_bbcodes'
138
$config_records = array('config_id', 'board_disable', 'sitename', 'site_desc', 'cookie_name', 'cookie_path', 'cookie_domain', 'cookie_secure', 'session_length', 'allow_html', 'allow_html_tags', 'allow_bbcode', 'allow_smilies', 'allow_sig', 'allow_namechange', 'allow_theme_create', 'allow_avatar_local', 'allow_avatar_remote', 'allow_avatar_upload', 'enable_confirm', 'override_user_style', 'posts_per_page', 'topics_per_page', 'hot_threshold', 'max_poll_options', 'max_sig_chars', 'max_inbox_privmsgs', 'max_sentbox_privmsgs', 'max_savebox_privmsgs', 'board_email_sig', 'board_email', 'smtp_delivery', 'smtp_host', 'smtp_username', 'smtp_password', 'sendmail_fix', 'require_activation', 'flood_interval', 'board_email_form', 'avatar_filesize', 'avatar_max_width', 'avatar_max_height', 'avatar_path', 'avatar_gallery_path', 'smilies_path', 'default_style', 'default_dateformat', 'board_timezone', 'prune_enable', 'privmsg_disable', 'gzip_compress', 'coppa_fax', 'coppa_mail', 'record_online_users', 'record_online_date', 'server_name', 'server_port', 'script_path', 'sig_line', 'birthday_required', 'birthday_greeting', 'max_user_age', 'min_user_age', 'birthday_check_day', 'bluecard_limit', 'bluecard_limit_2', 'max_user_bancard', 'report_forum', 'index_rating_return', 'min_rates_number', 'rating_max', 'allow_ext_rating', 'large_rating_return_limit', 'check_anon_ip_when_rating', 'allow_rerate', 'header_rating_return_limit', 'default_time_mode', 'default_dst_time_lag', 'search_flood_interval', 'rand_seed', 'allow_news', 'news_item_trim', 'news_title_trim', 'news_item_num', 'news_path', 'allow_rss', 'news_rss_desc', 'news_rss_language', 'news_rss_ttl', 'news_rss_cat', 'news_rss_image', 'news_rss_image_desc', 'news_rss_item_count', 'news_rss_show_abstract', 'news_base_url', 'news_index_file', 'dbmtnc_rebuild_end', 'dbmtnc_rebuild_pos', 'dbmtnc_rebuildcfg_maxmemory', 'dbmtnc_rebuildcfg_minposts', 'dbmtnc_rebuildcfg_php3only', 'dbmtnc_rebuildcfg_php3pps', 'dbmtnc_rebuildcfg_php4pps', 'dbmtnc_rebuildcfg_timelimit', 'dbmtnc_rebuildcfg_timeoverwrite', 'dbmtnc_disallow_postcounter', 'dbmtnc_disallow_rebuild', 'default_avatar_guests_url', 'default_avatar_users_url', 'enable_gravatars', 'gravatar_rating', 'gravatar_default_image', 'default_avatar_set', 'bin_forum', 'liw_enabled', 'liw_sig_enabled', 'liw_max_width', 'liw_attach_enabled', 'xs_news_version', 'board_disable_message', 'board_disable_mess_st', 'sitemap_announce_priority', 'sitemap_default_priority', 'sitemap_sort', 'sitemap_sticky_priority', 'sitemap_topic_limit', 'registration_status', 'registration_closed', 'prune_shouts', 'xs_shownav', 'allow_avatar_generator', 'avatar_generator_template_path', 'avatar_generator_version', 'max_login_attempts', 'login_reset_time', 'hidde_last_logon', 'online_time', 'gzip_level', 'gender_required', 'smilie_columns', 'smilie_rows', 'smilie_window_columns', 'allow_autologin', 'max_autologin_time', 'autolink_first', 'smilies_insert', 'sudoku_version', 'yahoo_search_savepath', 'yahoo_search_additional_urls', 'yahoo_search_compress', 'yahoo_search_compression_level', 'max_link_bookmarks', 'visit_counter', 'word_graph_max_words', 'word_graph_word_counts', 'search_min_chars', 'disable_registration_ip_check', 'extra_max', 'extra_display', 'upi2db_max_permanent_topics', 'upi2db_del_mark', 'upi2db_del_perm', 'upi2db_max_mark_posts', 'upi2db_unread_color', 'upi2db_edit_color', 'upi2db_mark_color', 'upi2db_auto_read', 'upi2db_edit_as_new', 'upi2db_last_edit_as_new', 'upi2db_on', 'upi2db_edit_topic_first', 'upi2db_no_group_min_regdays', 'upi2db_no_group_min_posts', 'upi2db_no_group_upi2db_on', 'upi2db_install_time', 'upi2db_delete_old_data', 'upi2db_max_new_posts', 'upi2db_version', 'use_captcha', 'version', 'board_startdate', 'default_lang', 'calendar_display_open', 'calendar_display_open_over', 'calendar_header_cells', 'calendar_header_cells_over', 'calendar_week_start', 'calendar_week_start_over', 'calendar_title_length', 'calendar_text_length', 'calendar_nb_row', 'calendar_nb_row_over', 'calendar_birthday', 'calendar_birthday_over', 'calendar_forum', 'calendar_forum_over', 'sub_forum', 'sub_forum_over', 'split_cat', 'split_cat_over', 'last_topic_title', 'last_topic_title_over', 'last_topic_title_length', 'sub_level_links', 'sub_level_links_over', 'display_viewonline', 'display_viewonline_over', 'max_posts', 'max_topics', 'max_users', 'xs_auto_compile', 'xs_auto_recompile', 'xs_use_cache', 'xs_php', 'xs_def_template', 'xs_check_switches', 'xs_warn_includes', 'xs_add_comments', 'xs_ftp_host', 'xs_ftp_login', 'xs_ftp_path', 'xs_downloads_count', 'xs_downloads_default', 'xs_template_time', 'xs_version', 'similar_stopwords', 'similar_ignore_forums_ids', 'similar_sort_type', 'similar_max_topics', 'similar_topics', 'bb_usage_stats_viewlevel', 'bb_usage_stats_viewoptions', 'bb_usage_stats_specialgrp', 'bb_usage_stats_prscale', 'bb_usage_stats_trscale', 'forum_wordgraph', 'shoutbox_floodinterval', 'display_shouts', 'stored_shouts', 'shoutbox_refreshtime', 'shout_allow_guest', 'upi2db_max_new_posts_admin', 'upi2db_max_new_posts_mod', 'smilie_window_rows', 'bots_color', 'show_calendar_box_index', 'url_rw', 'xmas_fx', 'switch_header_table', 'header_table_text', 'fast_n_furious', 'new_msgs_mumber', 'index_last_msgs', 'portal_last_msgs', 'online_last_msgs', 'index_shoutbox', 'portal_shoutbox', 'online_shoutbox', 'last_msgs_n', 'last_msgs_x', 'posts_precompiled', 'index_links', 'index_birthday', 'site_history', 'smilies_topic_title', 'html_email', 'config_cache', 'admin_protect', 'ftr_disable', 'disable_logins', 'last_logins_n', 'edit_notes', 'edit_notes_n', 'quote_iterations', 'page_gen', 'birthday_viewtopic', 'img_shoutbox', 'split_ga_ann_sticky', 'email_notification_html', 'select_theme', 'select_lang', 'show_icons', 'show_random_quote', 'visit_counter_switch', 'emails_only_to_admins', 'no_right_click', 'gd_version', 'show_img_no_gd', 'show_pic_size_on_thumb', 'thumbnail_posts', 'thumbnail_cache', 'thumbnail_quality', 'thumbnail_size', 'disable_html_guests', 'disable_email_error', 'switch_header_dropdown', 'switch_poster_info_topic', 'switch_bbcb_active_content', 'thumbnail_lightbox', 'enable_quick_quote', 'enable_xs_version_check', 'allow_all_bbcode', 'ip_version', 'enable_digests', 'digests_php_cron', 'digests_last_send_time', 'xmas_gfx', 'google_bot_detector', 'logs_path', 'url_rw_guests', 'lofi_bots', 'ajax_checks_register', 'inactive_users_memberlists', 'auth_view_pic_upload', 'enable_postimage_org', 'enable_new_messages_number', 'disable_thanks_topics', 'ajax_features', 'show_rss_forum_icon', 'disable_acronyms', 'disable_autolinks', 'disable_censor', 'global_disable_acronyms', 'global_disable_autolinks', 'global_disable_censor', 'disable_topic_view', 'disable_referrers', 'aprvmArchive', 'aprvmVersion', 'aprvmView', 'aprvmRows', 'aprvmIP', 'page_title_simple', 'digests_php_cron_lock', 'mg_log_actions', 'cash_disable', 'cash_display_after_posts', 'cash_post_message', 'cash_disable_spam_num', 'cash_disable_spam_time', 'cash_disable_spam_message', 'cash_installed', 'cash_version', 'cash_adminbig', 'cash_adminnavbar', 'points_name', 'active_users_color', 'active_users_legend', 'bots_legend', 'show_social_bookmarks', 'show_forums_online_users', 'cms_dock', 'smilie_single_row', 'main_admin_id', 'allow_mods_edit_admin_posts', 'force_large_caps_mods', 'enable_colorpicker', 'always_show_edit_by', 'show_new_reply_posting', 'show_chat_online', 'allow_zebra', 'allow_mods_view_self', 'enable_own_icons', 'show_thanks_profile', 'show_thanks_viewtopic', 'index_top_posters', 'global_disable_upi2db', 'last_user_id', 'write_errors_log', 'write_digests_log', 'no_bump', 'link_this_topic', 'cms_style', 'show_alpha_bar', 'db_log_actions', 'show_topic_description', 'bots_reg_auth', 'cron_global_switch', 'cron_lock', 'cron_queue_interval', 'cron_queue_last_run', 'cron_digests_interval', 'cron_digests_last_run', 'cron_files_interval', 'cron_files_last_run', 'cron_database_interval', 'cron_database_last_run', 'cron_cache_interval', 'cron_cache_last_run', 'cron_sql_interval', 'cron_sql_last_run', 'cron_users_interval', 'cron_users_last_run', 'cron_topics_interval', 'cron_topics_last_run', 'cron_sessions_interval', 'cron_sessions_last_run', 'cron_db_count', 'cron_db_show_begin_for', 'cron_db_show_not_optimized', 'rand_seed_last_update', 'gsearch_guests', 'ads_glt', 'ads_glb', 'ads_glh', 'ads_glf', 'ads_fix', 'ads_fit', 'ads_fib', 'ads_vfx', 'ads_vft', 'ads_vfb', 'ads_vtx', 'ads_vtt', 'ads_vtb', 'ads_nmt', 'ads_nmb', 'adsense_code', 'google_analytics', 'thumbnail_highslide', 'read_only_forum', 'forum_limit_edit_time_interval', 'ftr_topic_number', 'ftr_message', 'ftr_install_time', 'ftr_all_users', 'allow_html_only_for_admins', 'display_tags_box', 'allow_moderators_edit_tags', 'enable_custom_bbcodes', 'forum_tags_type'



139
139



140
);
140
);



141
141





          

  Updated
ip/trunk/install/schemas/db_update_054.sql  Download diff




      
      
155156
161
########################################
161
########################################



162
##              BUILD 058             ##
162
##              BUILD 058             ##



163
########################################
163
########################################



164
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('forum_tags_type', '0');



164
165



165
166



166
167





          

  Updated
ip/trunk/install/schemas/mysql_basic.sql  Download diff




      
      
155156
868
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('display_tags_box', '0');
868
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('display_tags_box', '0');



869
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('allow_moderators_edit_tags', '0');
869
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('allow_moderators_edit_tags', '0');



870
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('enable_custom_bbcodes', '0');
870
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('enable_custom_bbcodes', '0');



871
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('forum_tags_type', '0');



871
## CASH - BEGIN
872
## CASH - BEGIN



872
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('cash_disable', 0);
873
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('cash_disable', 0);



873
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('cash_display_after_posts', 1);
874
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('cash_display_after_posts', 1);





          

  Updated
ip/trunk/install/schemas/sql_update_ip.php  Download diff




      
      
155156
3727
3727



3728
		/* Updating from IP 1.3.4.57 */
3728
		/* Updating from IP 1.3.4.57 */



3729
		case '1.3.4.57':
3729
		case '1.3.4.57':



3730
		$sql[] = "INSERT INTO `" . $table_prefix . "config` (`config_name`, `config_value`) VALUES ('forum_tags_type', '0')";



3730
3731



3731
		/* Updating from IP 1.3.5.58 */
3732
		/* Updating from IP 1.3.5.58 */



3732
		case '1.3.5.58':
3733
		case '1.3.5.58':





          

  Updated
ip/trunk/language/lang_english/lang_extend_icy_phoenix.php  Download diff




      
      
155156
215
		'IP_no_bump_explain' => 'Enabling this option last posters won\'t be able to post within 24 hours from their last post unless someone else has posted a
reply (never applies to admins)',
215
		'IP_no_bump_explain' => 'Enabling this option last posters won\'t be able to post within 24 hours from their last post unless someone else has posted a
reply (never applies to admins)',



216
		'MODS_ALLOWED' => 'Moderators Can Posts',
216
		'MODS_ALLOWED' => 'Moderators Can Posts',



217
217



218
		'IP_display_tags_box' => 'Display Topics Tags',
218
		'IP_display_tags_box' => 'TAGS :: Display Topics Tags',



219
		'IP_display_tags_box_explain' => 'Enabling this option will enable Topics Tags (tags could be used for indexing purpose): tags could be inserted / edited
only by administrators (or moderators if you enable the switch below) to avoid spam',
219
		'IP_display_tags_box_explain' => 'Enabling this option will enable Topics Tags (tags could be used for indexing purpose): tags could be inserted / edited
only by administrators (or moderators if you enable the switch below) to avoid spam',



220
220



221
		'IP_allow_moderators_edit_tags' => 'Allow Moderators To Edit Tags',
221
		'IP_allow_moderators_edit_tags' => 'TAGS :: Allow Moderators To Edit Tags',



222
		'IP_allow_moderators_edit_tags_explain' => 'Enabling this option will allow Moderators to edit Topics Tags',
222
		'IP_allow_moderators_edit_tags_explain' => 'Enabling this option will allow Moderators to edit Topics Tags',



223
223



224
		'IP_show_topic_description' => 'Enable Topic Description',
224
		'IP_show_topic_description' => 'Enable Topic Description',


...
...
379
		'IP_sitemap_new_first' => 'New posts first',
379
		'IP_sitemap_new_first' => 'New posts first',



380
		'IP_sitemap_old_first' => 'Old posts first',
380
		'IP_sitemap_old_first' => 'Old posts first',



381
381



382
		'Word_graph' => 'TAGS',
382
//Tags



383



384
		'IP_word_graph_max_words' => 'TAGS :: Maximum Words',
383
		'IP_word_graph_max_words' => 'TAGS :: Maximum Words',



385
		'IP_word_graph_max_words_explain' => 'Select the maximum number of words to display. A higher number could affect server load. The recommended number is
250.',
384
		'IP_word_graph_max_words_explain' => 'Select the maximum number of words to display. A higher number could affect server load. The recommended number is
250.',



386
385


...
...
390
		'IP_forum_wordgraph' => 'TAGS :: Forum Tags (Global Switch)',
389
		'IP_forum_wordgraph' => 'TAGS :: Forum Tags (Global Switch)',



391
		'IP_forum_wordgraph_explain' => 'This feature will enable a forum based tags table at the bottom of each forum. You will need also to enable single forums
in Forums Management section.',
390
		'IP_forum_wordgraph_explain' => 'This feature will enable a forum based tags table at the bottom of each forum. You will need also to enable single forums
in Forums Management section.',



392
391



392
		'IP_forum_tags_type' => 'TAGS :: Forum Tags Type',



393
		'IP_forum_tags_type_explain' => 'You can choose whether to display Wordgraph (word taken from search tables) or Tags (tags specified in topics)',



394
		'IP_forum_tags_type_tags' => 'Tags',



395
		'IP_forum_tags_type_wordgraph' => 'Wordgraph',



396



393
		'Similar_topics' => 'Similar Topics',
397
		'Similar_topics' => 'Similar Topics',



394
		'Similar_topics_explain' => 'Configure search of similar topics.',
398
		'Similar_topics_explain' => 'Configure search of similar topics.',



395
399