Author: KasLimon
(2010/01/16 11:43) About 2 years ago
Features added: * Private Chat Notification
34
$action = (!empty($_POST['act'])) ? htmlspecialchars($_POST['act']) : htmlspecialchars($_GET['act']);
35
}
36
37
$private_chat = false;
if (!defined('AJAX_CHAT_ROOM'))
38
{
39
$chat_room = request_var('chat_room', '');
40
$chat_room = preg_replace('/[^0-9|]+/', '', trim($chat_room));
41
$chat_room_users = array();
42
$chat_room_users = explode('|', $chat_room);
43
44
$chat_room_users_count = sizeof($chat_room_users);
$chat_room_sql = " s.shout_room = '" . $chat_room . "' ";
45
if(($userdata['user_level'] != ADMIN) && !empty($chat_room) && !in_array($userdata['user_id'], $chat_room_users))
46
47
message_die(GENERAL_ERROR, $lang['Not_Auth_View']);
48
49
define('AJAX_CHAT_ROOM', true);
50
51
$private_chat = true;
52
53
if($action)
54
...
64
$error = AJAX_SHOUTBOX_NO_ERROR;
67
65
$error_msg = '';
68
66
69
70
// Delete alert for poster if present
71
if ($private_chat && !empty($userdata['user_private_chat_alert']))
72
73
$sql = "UPDATE " . USERS_TABLE . " SET user_private_chat_alert = '0' WHERE user_id = " . $userdata['user_id'];
74
$db->sql_query($sql);
75
76
// Code for getting data
77
if($action == 'read')
78
79
233
243
234
244
235
245
246
// Alert other users that somebody is willing to chat with them
247
if ($private_chat)
248
249
// It omits users that have been active for the last 5 minutes (300 seconds)
250
$sql = "SELECT session_user_id
251
FROM " . AJAX_SHOUTBOX_SESSIONS_TABLE . "
252
WHERE " . $db->sql_in_set('session_user_id', $chat_room_users) . "
253
AND session_time < " . (time() - 300) . "
254
ORDER BY session_user_id ASC";
255
$result = $db->sql_query($sql);
256
$row = $db->sql_fetchrowset($result);
257
$db->sql_freeresult($result);
258
259
$alert_users_array = array();
260
foreach ($chat_room_users as $chat_room_user)
261
262
if (($chat_room_user != $userdata['user_id']) && !in_array($chat_room_user, $row))
263
264
$alert_users_array[] = $chat_room_user;
265
266
267
268
$sql = "UPDATE " . USERS_TABLE . " SET user_private_chat_alert = '" . $chat_room . "' WHERE " . $db->sql_in_set('user_id', $alert_users_array);
269
270
271
236
// Some weird conversion of the data inputed
272
237
if($userdata['session_logged_in'])
273
238
274
3324
3325
// Mighty Gorgon - Advanced Switches - BEGIN
3326
3327
$new_pm_switch = false;
3328
$new_private_chat_switch = false;
3329
// LOGGED IN CHECK - BEGIN
3330
if (!$userdata['session_logged_in'])
3331
3332
3363
$l_privmsgs_text = $lang['Login_check_pm'];
3366
3364
$l_privmsgs_text_unread = '';
3367
3365
$s_privmsg_new = 0;
3368
3369
3370
$icon_private_chat = $images['private_chat'];
3371
$u_private_chat = '#';
3372
else
3373
3374
3437
3443
3438
if ($userdata['user_new_privmsg'] && !$config['privmsg_disable'])
3444
3439
3445
3446
$new_pm_switch = true;
3440
$l_message_new = ($userdata['user_new_privmsg'] == 1) ? $lang['New_pm'] : $lang['New_pms'];
3447
3441
$l_privmsgs_text = sprintf($l_message_new, $userdata['user_new_privmsg']);
3448
3442
3449
3462
$icon_pm = $images['pm_no_new_msg'];
3469
3463
3470
3464
3471
3472
3473
if (!empty($userdata['user_private_chat_alert']))
3474
3475
$new_private_chat_switch = true;
3476
$icon_private_chat = $images['private_chat_alert'];
3477
$u_private_chat = append_sid('ajax_shoutbox.' . PHP_EXT . '?chat_room=' . $userdata['user_private_chat_alert']);
3478
3479
3465
if ($userdata['user_unread_privmsg'])
3480
3466
3481
3467
$l_message_unread = ($userdata['user_unread_privmsg'] == 1) ? $lang['Unread_pm'] : $lang['Unread_pms'];
3482
3901
'PRIVATE_MESSAGE_INFO_UNREAD' => $l_privmsgs_text_unread,
3916
3902
'PRIVATE_MESSAGE_NEW_FLAG' => $s_privmsg_new,
3917
3903
'PRIVMSG_IMG' => $icon_pm,
3918
3919
'NEW_PM_SWITCH' => $new_pm_switch,
3904
3920
3921
'PRIVATE_CHAT_IMG' => $icon_private_chat,
3922
'U_PRIVATE_CHAT' => $u_private_chat,
3923
'NEW_PRIVATE_CHAT_SWITCH' => $new_private_chat_switch,
3924
3905
'L_USERNAME' => $lang['Username'],
3925
3906
'L_PASSWORD' => $lang['Password'],
3926
3907
'L_LOGIN_LOGOUT' => $l_login_logout,
3927
285
$table_prefix . 'upi2db_last_posts' => array('post_id', 'topic_id', 'forum_id', 'poster_id', 'post_time', 'post_edit_time', 'topic_type', 'post_edit_by'),
286
$table_prefix . 'upi2db_unread_posts' => array('post_id', 'topic_id', 'forum_id', 'user_id', 'status', 'topic_type', 'last_update'),
287
$table_prefix . 'user_group' => array('group_id', 'user_id', 'user_pending'),
288
$table_prefix . 'users' => array('user_id', 'user_active', 'username', 'username_clean', 'user_password', 'user_session_time', 'user_session_page', 'user_http_agents', 'user_lastvisit', 'user_regdate', 'user_level', 'user_cms_level', 'user_posts', 'user_timezone', 'user_style', 'user_lang', 'user_dateformat', 'user_new_privmsg', 'user_unread_privmsg', 'user_last_privmsg', 'user_emailtime', 'user_viewemail', 'user_profile_view_popup', 'user_attachsig', 'user_setbm', 'user_allowhtml', 'user_allowbbcode', 'user_allowsmile', 'user_allowavatar', 'user_allow_pm', 'user_allow_pm_in', 'user_allow_mass_email', 'user_allow_viewonline', 'user_notify', 'user_notify_pm', 'user_popup_pm', 'user_rank', 'user_rank2', 'user_rank3', 'user_rank4', 'user_rank5', 'user_avatar', 'user_avatar_type', 'user_email', 'user_icq', 'user_website', 'user_from', 'user_sig', 'user_aim', 'user_yim', 'user_msnm', 'user_occ', 'user_interests', 'user_actkey', 'user_newpasswd', 'ct_search_time', 'ct_search_count', 'ct_last_mail', 'ct_last_post', 'ct_post_counter', 'ct_last_pw_reset', 'ct_enable_ip_warn', 'ct_last_used_ip', 'ct_login_count', 'ct_login_vconfirm', 'ct_last_pw_change', 'ct_global_msg_read', 'ct_miserable_user', 'ct_last_ip', 'user_birthday', 'user_birthday_y', 'user_birthday_m', 'user_birthday_d', 'user_next_birthday_greeting', 'user_sub_forum', 'user_split_cat', 'user_last_topic_title', 'user_sub_level_links', 'user_display_viewonline', 'user_color_group', 'user_color', 'user_gender', 'user_lastlogon', 'user_totaltime', 'user_totallogon', 'user_totalpages', 'user_calendar_display_open', 'user_calendar_header_cells', 'user_calendar_week_start', 'user_calendar_nb_row', 'user_calendar_birthday', 'user_calendar_forum', 'user_warnings', 'user_time_mode', 'user_dst_time_lag', 'user_pc_timeOffsets', 'user_skype', 'user_registered_ip', 'user_registered_hostname', 'user_profile_view', 'user_last_profile_view', 'user_topics_per_page', 'user_hot_threshold', 'user_posts_per_page', 'user_allowswearywords', 'user_showavatars', 'user_showsignatures', 'user_login_tries', 'user_last_login_try', 'user_sudoku_playing', 'user_from_flag', 'user_phone', 'user_selfdes', 'user_upi2db_which_system', 'user_upi2db_disable', 'user_upi2db_datasync', 'user_upi2db_new_word', 'user_upi2db_edit_word', 'user_upi2db_unread_color', 'user_personal_pics_count', 'user_allow_new_download_email', 'user_allow_fav_download_email', 'user_allow_new_download_popup', 'user_allow_fav_download_popup', 'user_dl_update_time', 'user_new_download', 'user_traffic', 'user_download_counter', 'user_dl_note_type', 'user_dl_sort_fix', 'user_dl_sort_opt', 'user_dl_sort_dir'),
$table_prefix . 'users' => array('user_id', 'user_active', 'username', 'username_clean', 'user_password', 'user_session_time', 'user_session_page', 'user_http_agents', 'user_lastvisit', 'user_regdate', 'user_level', 'user_cms_level', 'user_posts', 'user_timezone', 'user_style', 'user_lang', 'user_dateformat', 'user_new_privmsg', 'user_unread_privmsg', 'user_last_privmsg', 'user_private_chat_alert', 'user_emailtime', 'user_viewemail', 'user_profile_view_popup', 'user_attachsig', 'user_setbm', 'user_allowhtml', 'user_allowbbcode', 'user_allowsmile', 'user_allowavatar', 'user_allow_pm', 'user_allow_pm_in', 'user_allow_mass_email', 'user_allow_viewonline', 'user_notify', 'user_notify_pm', 'user_popup_pm', 'user_rank', 'user_rank2', 'user_rank3', 'user_rank4', 'user_rank5', 'user_avatar', 'user_avatar_type', 'user_email', 'user_icq', 'user_website', 'user_from', 'user_sig', 'user_aim', 'user_yim', 'user_msnm', 'user_occ', 'user_interests', 'user_actkey', 'user_newpasswd', 'ct_search_time', 'ct_search_count', 'ct_last_mail', 'ct_last_post', 'ct_post_counter', 'ct_last_pw_reset', 'ct_enable_ip_warn', 'ct_last_used_ip', 'ct_login_count', 'ct_login_vconfirm', 'ct_last_pw_change', 'ct_global_msg_read', 'ct_miserable_user', 'ct_last_ip', 'user_birthday', 'user_birthday_y', 'user_birthday_m', 'user_birthday_d', 'user_next_birthday_greeting', 'user_sub_forum', 'user_split_cat', 'user_last_topic_title', 'user_sub_level_links', 'user_display_viewonline', 'user_color_group', 'user_color', 'user_gender', 'user_lastlogon', 'user_totaltime', 'user_totallogon', 'user_totalpages', 'user_calendar_display_open', 'user_calendar_header_cells', 'user_calendar_week_start', 'user_calendar_nb_row', 'user_calendar_birthday', 'user_calendar_forum', 'user_warnings', 'user_time_mode', 'user_dst_time_lag', 'user_pc_timeOffsets', 'user_skype', 'user_registered_ip', 'user_registered_hostname', 'user_profile_view', 'user_last_profile_view', 'user_topics_per_page', 'user_hot_threshold', 'user_posts_per_page', 'user_allowswearywords', 'user_showavatars', 'user_showsignatures', 'user_login_tries', 'user_last_login_try', 'user_sudoku_playing', 'user_from_flag', 'user_phone', 'user_selfdes', 'user_upi2db_which_system', 'user_upi2db_disable', 'user_upi2db_datasync', 'user_upi2db_new_word', 'user_upi2db_edit_word', 'user_upi2db_unread_color', 'user_personal_pics_count', 'user_allow_new_download_email', 'user_allow_fav_download_email', 'user_allow_new_download_popup', 'user_allow_fav_download_popup', 'user_dl_update_time', 'user_new_download', 'user_traffic', 'user_download_counter', 'user_dl_note_type', 'user_dl_sort_fix', 'user_dl_sort_opt', 'user_dl_sort_dir'),
289
$table_prefix . 'vote_desc' => array('vote_id', 'topic_id', 'vote_text', 'vote_start', 'vote_length'),
290
$table_prefix . 'vote_results' => array('vote_id', 'vote_option_id', 'vote_option_text', 'vote_result'),
291
$table_prefix . 'vote_voters' => array('vote_id', 'vote_user_id', 'vote_user_ip', 'vote_cast'),
162
## BUILD 058 ##
163
########################################
164
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('forum_tags_type', '0');
165
ALTER TABLE `phpbb_users` ADD `user_private_chat_alert` VARCHAR(255) NOT NULL AFTER `user_last_privmsg`;
166
167
168
2029
`user_new_privmsg` smallint(5) unsigned NOT NULL DEFAULT '0',
2030
`user_unread_privmsg` smallint(5) unsigned NOT NULL DEFAULT '0',
2031
`user_last_privmsg` int(11) NOT NULL DEFAULT '0',
2032
`user_private_chat_alert` varchar(255) NOT NULL DEFAULT '0',
`user_emailtime` int(11) DEFAULT NULL,
2033
`user_viewemail` tinyint(1) DEFAULT NULL,
2034
`user_profile_view_popup` tinyint(1) DEFAULT '0',
2035
3728
/* Updating from IP 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')";
3731
$sql[] = "ALTER TABLE `" . $table_prefix . "users` ADD `user_private_chat_alert` VARCHAR(255) NOT NULL AFTER `user_last_privmsg`";
3732
/* Updating from IP 1.3.5.58 */
3733
case '1.3.5.58':
3734
$lang['BBC_IP_CREDITS_STATIC'] = '
<a href="http://www.icyphoenix.com" title="Icy Phoenix"><img src="http://www.icyphoenix.com/images/logo_ip.png" alt="Icy Phoenix" title="Icy Phoenix" /></a><br />
<span style="color: #ff5500;"><b>Mighty Gorgon</b></span><br />
<span style="color: #dd2222;"><b>Mighty Gorgon</b></span> <i>(Luca Libralato)</i><br />
<i>(Luca Libralato)</i><br />
<br />
<b><i>Developer</i></b><br />
Interests: Heroes Of Might And Magic III, 69, #FF5522<br />
Location: Homer\'s Head<br />
<span style="color: #ff5500;"><b>hpl</b></span><br />
<b><i>Junior Developer</i></b><br />
<span style="color: #dd2222;"><b>Bicet</b></span><br />
<b><i>phpBB XS Developer</i></b><br />
<span style="color: #dd2222;"><b>hpl</b></span><br />
<b><i>Some Special Contributions</i></b><br />
<b><i>Valued Contributors</i></b><br />
<span style="color: #228822;"><b>Andrea75</b></span><br />
55
<span style="color: #dd2222;"><b>Artie</b></span><br />
56
63
<span style="color: #880088;"><b>ganesh</b></span><br />
<span style="color: #228822;"><b>JANU1535</b></span><br />
<span style="color: #880088;"><b>jz</b></span><br />
<span style="color: #228822;"><b>KasLimon</b></span><br />
<span style="color: #aaff00;"><b>KugeLSichA</b></span><br />
<span style="color: #0000bb;"><b>Limun</b></span><br />
<span style="color: #880088;"><b>Lopalong</b></span><br />
<span style="color: #228822;"><b>ThE KuKa</b></span><br />
<span style="color: #ff7700;"><b>TheSteffen</b></span><br />
<span style="color: #0000bb;"><b>Tom</b></span><br />
<span style="color: #aaff00;"><b>TuningBEB2008</b></span><br />
<span style="color: #228822;"><b>z3d0</b></span><br />
<span style="color: #228822;"><b>Zuker</b></span><br />
Interests: Icy Phoenix<br />
Location: <a href="http://www.icyphoenix.com/">http://www.icyphoenix.com</a>
80
';
81
82
$lang['BBC_IP_CREDITS'] = '<div class="center-block"><marquee behavior="scroll" direction="up" scrolldelay="120">' . $lang['BBC_IP_CREDITS_STATIC'] . '</marquee></div>';
2263
'AJAX_SHOUTBOX' => 'Chat',
2264
'AJAX_SHOUTBOX_PVT' => 'Private Chat',
2265
'AJAX_SHOUTBOX_PVT_LINK' => 'Direct chat with this user',
2266
'AJAX_SHOUTBOX_PVT_ALERT' => 'You have a chat request',
2267
)
2268
);
2269
$images['pm_new_msg'] = 'pm-new';
$images['pm_no_new_msg'] = 'pm';
// Private chat notification
$images['private_chat_alert'] = $images['pm_new_msg'];
$images['private_chat'] = $images['pm_no_new_msg'];
// Small icons
$images['forum_tiny'] = $current_template_buttons . 'icon_post.gif' . $img_fade;
$images['icon_minipost'] = $current_template_buttons . 'icon_post.gif';
29
30
<tr>
31
<td colspan="3" id="content">
32
<!-- IF S_LOGGED_IN --><div class="popup{PRIVMSG_IMG}"><a href="{FULL_SITE_PATH}{U_PRIVATEMSGS}">{PRIVATE_MESSAGE_INFO}</a></div><!-- ENDIF -->
<!-- IF S_LOGGED_IN -->
33
<!-- IF NEW_PM_SWITCH --><div class="popup{PRIVMSG_IMG}"><a href="{FULL_SITE_PATH}{U_PRIVATEMSGS}">{PRIVATE_MESSAGE_INFO}</a></div><!-- ENDIF -->
<!-- IF NEW_PRIVATE_CHAT_SWITCH --><div class="popup{PRIVATE_CHAT_IMG}"><a href="#" class="gensmall" onclick="window.open('{U_PRIVATE_CHAT}', '_chat', 'width=720,height=600,resizable=yes'); return false;">{L_AJAX_SHOUTBOX_PVT_ALERT}</a></div><!-- ENDIF -->
<!-- ENDIF -->
<!-- BEGIN switch_admin_disable_board -->
<table width="100%" align="center" cellspacing="0" cellpadding="10" border="0">
<tr><td align="center" class="forumline-no"><div class="genmed"><div class="topic_ann">{L_BOARD_DISABLE}</div></div></td></tr>
if (!defined('AJAX_CHAT_ROOM'))if (!defined('AJAX_CHAT_ROOM')){{$chat_room = request_var('chat_room', '');$chat_room = request_var('chat_room', '');$chat_room = preg_replace('/[^0-9|]+/', '', trim($chat_room));$chat_room = preg_replace('/[^0-9|]+/', '', trim($chat_room));$chat_room_users = explode('|', $chat_room);$chat_room_users = explode('|', $chat_room);{{define('AJAX_CHAT_ROOM', true);define('AJAX_CHAT_ROOM', true);{{{{WHERE " . $db->sql_in_set('session_user_id', $chat_room_users) . "{{$sql = "UPDATE " . USERS_TABLE . " SET user_private_chat_alert = '" . $chat_room . "' WHERE " . $db->sql_in_set('user_id', $alert_users_array);{{{{{{{{{$u_private_chat = append_sid('ajax_shoutbox.' . PHP_EXT . '?chat_room=' . $userdata['user_private_chat_alert']);{{$table_prefix . 'upi2db_last_posts' => array('post_id', 'topic_id', 'forum_id', 'poster_id', 'post_time', 'post_edit_time', 'topic_type', 'post_edit_by'),$table_prefix . 'upi2db_last_posts' => array('post_id', 'topic_id', 'forum_id', 'poster_id', 'post_time', 'post_edit_time', 'topic_type', 'post_edit_by'),$table_prefix . 'upi2db_unread_posts' => array('post_id', 'topic_id', 'forum_id', 'user_id', 'status', 'topic_type', 'last_update'),$table_prefix . 'upi2db_unread_posts' => array('post_id', 'topic_id', 'forum_id', 'user_id', 'status', 'topic_type', 'last_update'),$table_prefix . 'user_group' => array('group_id', 'user_id', 'user_pending'),$table_prefix . 'user_group' => array('group_id', 'user_id', 'user_pending'),$table_prefix . 'users' => array('user_id', 'user_active', 'username', 'username_clean', 'user_password', 'user_session_time', 'user_session_page', 'user_http_agents', 'user_lastvisit', 'user_regdate', 'user_level', 'user_cms_level', 'user_posts', 'user_timezone', 'user_style', 'user_lang', 'user_dateformat', 'user_new_privmsg', 'user_unread_privmsg', 'user_last_privmsg', 'user_emailtime', 'user_viewemail', 'user_profile_view_popup', 'user_attachsig', 'user_setbm', 'user_allowhtml', 'user_allowbbcode', 'user_allowsmile', 'user_allowavatar', 'user_allow_pm', 'user_allow_pm_in', 'user_allow_mass_email', 'user_allow_viewonline', 'user_notify', 'user_notify_pm', 'user_popup_pm', 'user_rank', 'user_rank2', 'user_rank3', 'user_rank4', 'user_rank5', 'user_avatar', 'user_avatar_type', 'user_email', 'user_icq', 'user_website', 'user_from', 'user_sig', 'user_aim', 'user_yim', 'user_msnm', 'user_occ', 'user_interests', 'user_actkey', 'user_newpasswd', 'ct_search_time', 'ct_search_count', 'ct_last_mail', 'ct_last_post', 'ct_post_counter', 'ct_last_pw_reset', 'ct_enable_ip_warn', 'ct_last_used_ip', 'ct_login_count', 'ct_login_vconfirm', 'ct_last_pw_change', 'ct_global_msg_read', 'ct_miserable_user', 'ct_last_ip', 'user_birthday', 'user_birthday_y', 'user_birthday_m', 'user_birthday_d', 'user_next_birthday_greeting', 'user_sub_forum', 'user_split_cat', 'user_last_topic_title', 'user_sub_level_links', 'user_display_viewonline', 'user_color_group', 'user_color', 'user_gender', 'user_lastlogon', 'user_totaltime', 'user_totallogon', 'user_totalpages', 'user_calendar_display_open', 'user_calendar_header_cells', 'user_calendar_week_start', 'user_calendar_nb_row', 'user_calendar_birthday', 'user_calendar_forum', 'user_warnings', 'user_time_mode', 'user_dst_time_lag', 'user_pc_timeOffsets', 'user_skype', 'user_registered_ip', 'user_registered_hostname', 'user_profile_view', 'user_last_profile_view', 'user_topics_per_page', 'user_hot_threshold', 'user_posts_per_page', 'user_allowswearywords', 'user_showavatars', 'user_showsignatures', 'user_login_tries', 'user_last_login_try', 'user_sudoku_playing', 'user_from_flag', 'user_phone', 'user_selfdes', 'user_upi2db_which_system', 'user_upi2db_disable', 'user_upi2db_datasync', 'user_upi2db_new_word', 'user_upi2db_edit_word', 'user_upi2db_unread_color', 'user_personal_pics_count', 'user_allow_new_download_email', 'user_allow_fav_download_email', 'user_allow_new_download_popup', 'user_allow_fav_download_popup', 'user_dl_update_time', 'user_new_download', 'user_traffic', 'user_download_counter', 'user_dl_note_type', 'user_dl_sort_fix', 'user_dl_sort_opt', 'user_dl_sort_dir'),$table_prefix . 'users' => array('user_id', 'user_active', 'username', 'username_clean', 'user_password', 'user_session_time', 'user_session_page', 'user_http_agents', 'user_lastvisit', 'user_regdate', 'user_level', 'user_cms_level', 'user_posts', 'user_timezone', 'user_style', 'user_lang', 'user_dateformat', 'user_new_privmsg', 'user_unread_privmsg', 'user_last_privmsg', 'user_private_chat_alert', 'user_emailtime', 'user_viewemail', 'user_profile_view_popup', 'user_attachsig', 'user_setbm', 'user_allowhtml', 'user_allowbbcode', 'user_allowsmile', 'user_allowavatar', 'user_allow_pm', 'user_allow_pm_in', 'user_allow_mass_email', 'user_allow_viewonline', 'user_notify', 'user_notify_pm', 'user_popup_pm', 'user_rank', 'user_rank2', 'user_rank3', 'user_rank4', 'user_rank5', 'user_avatar', 'user_avatar_type', 'user_email', 'user_icq', 'user_website', 'user_from', 'user_sig', 'user_aim', 'user_yim', 'user_msnm', 'user_occ', 'user_interests', 'user_actkey', 'user_newpasswd', 'ct_search_time', 'ct_search_count', 'ct_last_mail', 'ct_last_post', 'ct_post_counter', 'ct_last_pw_reset', 'ct_enable_ip_warn', 'ct_last_used_ip', 'ct_login_count', 'ct_login_vconfirm', 'ct_last_pw_change', 'ct_global_msg_read', 'ct_miserable_user', 'ct_last_ip', 'user_birthday', 'user_birthday_y', 'user_birthday_m', 'user_birthday_d', 'user_next_birthday_greeting', 'user_sub_forum', 'user_split_cat', 'user_last_topic_title', 'user_sub_level_links', 'user_display_viewonline', 'user_color_group', 'user_color', 'user_gender', 'user_lastlogon', 'user_totaltime', 'user_totallogon', 'user_totalpages', 'user_calendar_display_open', 'user_calendar_header_cells', 'user_calendar_week_start', 'user_calendar_nb_row', 'user_calendar_birthday', 'user_calendar_forum', 'user_warnings', 'user_time_mode', 'user_dst_time_lag', 'user_pc_timeOffsets', 'user_skype', 'user_registered_ip', 'user_registered_hostname', 'user_profile_view', 'user_last_profile_view', 'user_topics_per_page', 'user_hot_threshold', 'user_posts_per_page', 'user_allowswearywords', 'user_showavatars', 'user_showsignatures', 'user_login_tries', 'user_last_login_try', 'user_sudoku_playing', 'user_from_flag', 'user_phone', 'user_selfdes', 'user_upi2db_which_system', 'user_upi2db_disable', 'user_upi2db_datasync', 'user_upi2db_new_word', 'user_upi2db_edit_word', 'user_upi2db_unread_color', 'user_personal_pics_count', 'user_allow_new_download_email', 'user_allow_fav_download_email', 'user_allow_new_download_popup', 'user_allow_fav_download_popup', 'user_dl_update_time', 'user_new_download', 'user_traffic', 'user_download_counter', 'user_dl_note_type', 'user_dl_sort_fix', 'user_dl_sort_opt', 'user_dl_sort_dir'),$table_prefix . 'vote_desc' => array('vote_id', 'topic_id', 'vote_text', 'vote_start', 'vote_length'),$table_prefix . 'vote_desc' => array('vote_id', 'topic_id', 'vote_text', 'vote_start', 'vote_length'),$table_prefix . 'vote_results' => array('vote_id', 'vote_option_id', 'vote_option_text', 'vote_result'),$table_prefix . 'vote_results' => array('vote_id', 'vote_option_id', 'vote_option_text', 'vote_result'),$table_prefix . 'vote_voters' => array('vote_id', 'vote_user_id', 'vote_user_ip', 'vote_cast'),$table_prefix . 'vote_voters' => array('vote_id', 'vote_user_id', 'vote_user_ip', 'vote_cast'),INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('forum_tags_type', '0');INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('forum_tags_type', '0');$sql[] = "INSERT INTO `" . $table_prefix . "config` (`config_name`, `config_value`) VALUES ('forum_tags_type', '0')";$sql[] = "INSERT INTO `" . $table_prefix . "config` (`config_name`, `config_value`) VALUES ('forum_tags_type', '0')";<span style="color: #ff5500;"><b>Mighty Gorgon</b></span><br /><span style="color: #dd2222;"><b>Mighty Gorgon</b></span> <i>(Luca Libralato)</i><br /><i>(Luca Libralato)</i><br />Interests: Heroes Of Might And Magic III, 69, #FF5522<br />Location: Homer\'s Head<br /><span style="color: #dd2222;"><b>hpl</b></span><br /><b><i>Some Special Contributions</i></b><br /><br /><br /><span style="color: #228822;"><b>KasLimon</b></span><br />Interests: Icy Phoenix<br />Location: <a href="http://www.icyphoenix.com/">http://www.icyphoenix.com</a><!-- IF S_LOGGED_IN --><div class="popup{PRIVMSG_IMG}"><a href="{FULL_SITE_PATH}{U_PRIVATEMSGS}">{PRIVATE_MESSAGE_INFO}</a></div><!-- ENDIF --><!-- IF NEW_PM_SWITCH --><div class="popup{PRIVMSG_IMG}"><a href="{FULL_SITE_PATH}{U_PRIVATEMSGS}">{PRIVATE_MESSAGE_INFO}</a></div><!-- ENDIF --><!-- IF NEW_PRIVATE_CHAT_SWITCH --><div class="popup{PRIVATE_CHAT_IMG}"><a href="#" class="gensmall" onclick="window.open('{U_PRIVATE_CHAT}', '_chat', 'width=720,height=600,resizable=yes'); return false;">{L_AJAX_SHOUTBOX_PVT_ALERT}</a></div><!-- ENDIF --><!-- ENDIF --><tr><td align="center" class="forumline-no"><div class="genmed"><div class="topic_ann">{L_BOARD_DISABLE}</div></div></td></tr><tr><td align="center" class="forumline-no"><div class="genmed"><div class="topic_ann">{L_BOARD_DISABLE}</div></div></td></tr>