4
Hi pmhoran
I never tested phpmychat for xoops2 but i don´t think it should be a problem. just try it.
I remember that the chat needs some tables:
CREATE TABLE `XOOPS_c_ban_users` (
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`ip` varchar(16) NOT NULL default '',
`rooms` varchar(100) NOT NULL default '',
`ban_until` int(11) NOT NULL default '0'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `XOOPS_c_messages`
--
CREATE TABLE `XOOPS_c_messages` (
`type` tinyint(1) NOT NULL default '0',
`room` varchar(30) NOT NULL default '',
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`m_time` int(11) NOT NULL default '0',
`address` varchar(30) NOT NULL default '',
`message` text NOT NULL
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `XOOPS_c_reg_users`
--
CREATE TABLE `XOOPS_c_reg_users` (
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`password` varchar(32) NOT NULL default '',
`firstname` varchar(64) NOT NULL default '',
`lastname` varchar(64) NOT NULL default '',
`country` varchar(64) NOT NULL default '',
`website` varchar(64) NOT NULL default '',
`email` varchar(64) NOT NULL default '',
`showemail` tinyint(1) NOT NULL default '0',
`perms` varchar(9) NOT NULL default '',
`rooms` varchar(128) NOT NULL default '',
`reg_time` int(11) NOT NULL default '0',
`ip` varchar(16) NOT NULL default '',
`gender` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `XOOPS_c_users`
--
CREATE TABLE `XOOPS_c_users` (
`room` varchar(30) NOT NULL default '',
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`u_time` int(11) NOT NULL default '0',
`status` char(1) NOT NULL default '',
`ip` varchar(16) NOT NULL default '',
UNIQUE KEY `room` (`room`,`username`)
) TYPE=MyISAM;
just replace te XOOPS_ with your own prefix.
about the other chat...i´ve contacted the dev ans suggested him to release a beta version.
greetings
birdseedmusic