Flashchat 4.7.0

[whoesa]

Hi,

Since many members here usses Flashchat, i thought i ask here.
I just recieved a mail from Tufat that there's a new version out(4.7.0). It says "An important security update has been made to FlashChat. Please download and install FlashChat 4.7.0 as soon as possible to avoid known security exploits."
Now, in the installation process i have an option to choose from but im not sure what to do. 

The FlashChat installer has detected that the following database tables already exist.
Based on the information that you inputted, these are likely to be FlashChat tables.

smf_fc_config
smf_fc_config_values
smf_fc_config_instances
smf_fc_config_chats

Would you like to upgrade your current FlashChat installation? This action will add fields that are missing from the the existing tables, and add any missing tables. Tables and fields are not removed during this process, and existing data is not removed. Thus, your current chat rooms, users, bots, and messages will be preserved.

If you are unsure whether these tables are related to FlashChat, then you are advised to check with your website administrator, or use a MySQL access tool like phpFlashMyadmin to backup the table contents before continuing.

Can i continue with the installation?

An other silly question, i checked my databasses with phpMyAdmin and i noticed 11 tables in there starting with x7chat2_ . Do these tables have anything to do with FlashChat? Just asking because when i uninstalled flashchat, these tables were still there.

[akulion]

hey how come i didnt get that email!!!

must be in the junk folder! thanks for lettin me know

my guess is it should be ok to go with upgrade since flash chat is a completely seperate software and configuration is done in php files and not in the tables

as for the additional tables....ask at tufat.com

that looks suspicious!

[Xarcell]

I think your asking in the wrong forum. Trying asking a the flashchat forum.

x7chat2_ does look suspcious. You could try deleteing the old tables before installing.

[Xarcell]

I made topic sticky for awhile. We don't want any secruity issues...

[G6Cad]

I got that mail yesterday, But i havent updated it yet

[akulion]

im gona upgrade as soon as i get something together to put up on GG (Goofy Goobers) lol

[G6Cad]

The tables created for FlashCat are these ones here

Code Select Expand

#--------------------------------------------------------------------------
# Table structure for table `bans`
#--------------------------------------------------------------------------

CREATE TABLE `bans` (
       `created` timestamp(14) NOT NULL,
       `userid` int(11) default NULL,
       `banneduserid` int(11) default NULL,
       `roomid` int(11) default NULL,
       `ip` varchar(16) default NULL,
       KEY `userid` (`userid`),
       KEY `created` (`created`)
     ) TYPE=MyISAM;

#--------------------------------------------------------------------------
# Table structure for table `connections`
#--------------------------------------------------------------------------

CREATE TABLE `connections` (
       `id` varchar(32) NOT NULL default '',
       `updated` timestamp(14) NOT NULL,
       `created` timestamp(14) NOT NULL,
       `userid` int(11) default NULL,
       `roomid` int(11) default NULL,
       `state` tinyint(4) NOT NULL default '1',
       `color` int(11) default NULL,
       `start` int(11) default NULL,
       `lang` char(2) default NULL,
       `ip` varchar(16) default NULL,
       `tzoffset` int(11) default '0',
       PRIMARY KEY  (`id`),
       KEY `userid` (`userid`),
       KEY `roomid` (`roomid`),
       KEY `updated` (`updated`)
     ) TYPE=MyISAM;

#--------------------------------------------------------------------------
# Table structure for table `ignors`
#--------------------------------------------------------------------------

CREATE TABLE `ignors` (
       `created` timestamp(14) NOT NULL,
       `userid` int(11) default NULL,
       `ignoreduserid` int(11) default NULL,
       KEY `userid` (`userid`),
       KEY `ignoreduserid` (`ignoreduserid`),
       KEY `created` (`created`)
     ) TYPE=MyISAM;

#--------------------------------------------------------------------------
# Table structure for table `messages`
#--------------------------------------------------------------------------

CREATE TABLE `messages` (
       `id` int(11) NOT NULL auto_increment,
       `created` timestamp(14) NOT NULL,
       `toconnid` varchar(32) default NULL,
       `touserid` int(11) default NULL,
       `toroomid` int(11) default NULL,
       `command` varchar(255) NOT NULL default '',
       `userid` int(11) default NULL,
       `roomid` int(11) default NULL,
       `txt` text,
       PRIMARY KEY  (`id`),
       KEY `touserid` (`touserid`),
       KEY `toroomid` (`toroomid`),
       KEY `toconnid` (`toconnid`),
       KEY `created` (`created`)
     ) TYPE=MyISAM AUTO_INCREMENT=14 ;

#--------------------------------------------------------------------------
# Table structure for table `rooms`
#--------------------------------------------------------------------------

CREATE TABLE `rooms` (
       `id` int(11) NOT NULL auto_increment,
       `updated` timestamp(14) NOT NULL,
       `created` timestamp(14) NOT NULL,
       `name` varchar(64) NOT NULL default '',
       `password` varchar(32) NOT NULL default '',
       `ispublic` char(1) default NULL,
       `ispermanent` int(11) default NULL,
       
       PRIMARY KEY  (`id`),
       KEY `name` (`name`),
       KEY `ispublic` (`ispublic`),
       KEY `ispermanent` (`ispermanent`),
       KEY `updated` (`updated`)
     ) TYPE=MyISAM AUTO_INCREMENT=5 ;

#--------------------------------------------------------------------------
# Table structure for table `users`
#--------------------------------------------------------------------------

CREATE TABLE `users` (
       `id` int(11) NOT NULL auto_increment,
       `login` varchar(32) NOT NULL default '',
       `password` varchar(32) NOT NULL default '',
       `roles` int(11) NOT NULL default '0',
       `profile` text,
       PRIMARY KEY  (`id`),
       KEY `login` (`login`)
     ) TYPE=MyISAM AUTO_INCREMENT=2 ;

[akulion]

that means x7chat2_ arent part of FC

Better hurry up and investigate WSA

good luck!

[whoesa]

Im done with the installation now and it's all working just fine.

Now i need to find out what these other tables doing there.
I have all these in there:

x7chat2_bandwidth
x7chat2_banned
x7chat2_events
x7chat2_filter
x7chat2_messages
x7chat2_muted
x7chat2_online
x7chat2_permissions
x7chat2_rooms
x7chat2_settings
x7chat2_users

You think it's save to just delete them?

[akulion]

best to ask at tufat.com

and also ask your host in case they know something