FM / ajaxchat

/var/softaculous/ajaxchat

Name	Size	Mode	Actions
images/	-	0755	rm
php53/	-	0755	rm
php56/	-	0755	rm
php71/	-	0755	rm
php81/	-	0755	rm
ajaxchat.sql	2347	0644	edit dl rm
ajaxchat.zip	619022	0644	edit dl rm
changelog.txt	3132	0644	edit dl rm
clone.php	3598	0644	edit dl rm
config.php	9973	0644	edit dl rm
edit.php	3666	0644	edit dl rm
edit.xml	433	0644	edit dl rm
fileindex.php	107	0644	edit dl rm
import.php	2592	0644	edit dl rm
info.xml	3775	0644	edit dl rm
install.js	924	0644	edit dl rm
install.php	3285	0644	edit dl rm
install.xml	495	0644	edit dl rm
md5	3627	0644	edit dl rm
users.php	1053	0644	edit dl rm

Edit: /var/softaculous/ajaxchat/ajaxchat.sql (2347B)

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `soft_chat088`
--

--
-- Table structure for table `ajax_chat_bans`
--

CREATE TABLE `ajax_chat_bans` (
  `userID` int(11) NOT NULL,
  `userName` varchar(64) COLLATE utf8_bin NOT NULL,
  `dateTime` datetime NOT NULL,
  `ip` varbinary(16) NOT NULL,
  PRIMARY KEY (`userID`),
  KEY `userName` (`userName`),
  KEY `dateTime` (`dateTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table `ajax_chat_invitations`
--

CREATE TABLE `ajax_chat_invitations` (
  `userID` int(11) NOT NULL,
  `channel` int(11) NOT NULL,
  `dateTime` datetime NOT NULL,
  PRIMARY KEY (`userID`,`channel`),
  KEY `dateTime` (`dateTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table `ajax_chat_messages`
--

CREATE TABLE `ajax_chat_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL,
  `userName` varchar(64) COLLATE utf8_bin NOT NULL,
  `userRole` int(1) NOT NULL,
  `channel` int(11) NOT NULL,
  `dateTime` datetime NOT NULL,
  `ip` varbinary(16) NOT NULL,
  `text` text COLLATE utf8_bin,
  PRIMARY KEY (`id`),
  KEY `message_condition` (`id`,`channel`,`dateTime`),
  KEY `dateTime` (`dateTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `ajax_chat_online`
--

CREATE TABLE `ajax_chat_online` (
  `userID` int(11) NOT NULL,
  `userName` varchar(64) COLLATE utf8_bin NOT NULL,
  `userRole` int(1) NOT NULL,
  `channel` int(11) NOT NULL,
  `dateTime` datetime NOT NULL,
  `ip` varbinary(16) NOT NULL,
  PRIMARY KEY (`userID`),
  KEY `userName` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `soft_chat088` -- -- -- Table structure for table `ajax_chat_bans` -- CREATE TABLE `ajax_chat_bans` ( `userID` int(11) NOT NULL, `userName` varchar(64) COLLATE utf8_bin NOT NULL, `dateTime` datetime NOT NULL, `ip` varbinary(16) NOT NULL, PRIMARY KEY (`userID`), KEY `userName` (`userName`), KEY `dateTime` (`dateTime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `ajax_chat_invitations` -- CREATE TABLE `ajax_chat_invitations` ( `userID` int(11) NOT NULL, `channel` int(11) NOT NULL, `dateTime` datetime NOT NULL, PRIMARY KEY (`userID`,`channel`), KEY `dateTime` (`dateTime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `ajax_chat_messages` -- CREATE TABLE `ajax_chat_messages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `userID` int(11) NOT NULL, `userName` varchar(64) COLLATE utf8_bin NOT NULL, `userRole` int(1) NOT NULL, `channel` int(11) NOT NULL, `dateTime` datetime NOT NULL, `ip` varbinary(16) NOT NULL, `text` text COLLATE utf8_bin, PRIMARY KEY (`id`), KEY `message_condition` (`id`,`channel`,`dateTime`), KEY `dateTime` (`dateTime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ajax_chat_online` -- CREATE TABLE `ajax_chat_online` ( `userID` int(11) NOT NULL, `userName` varchar(64) COLLATE utf8_bin NOT NULL, `userRole` int(1) NOT NULL, `channel` int(11) NOT NULL, `dateTime` datetime NOT NULL, `ip` varbinary(16) NOT NULL, PRIMARY KEY (`userID`), KEY `userName` (`userName`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;