I want to make quick modification for plugin:
http://forums.alliedmods.net/showthread.php?t=149779
So the main thing that i want to change it's to work for phpbb3 forum not for IPB.
I think that the part which must be only changed is:
#define DB_CALL "INSERT INTO `%s` ( s_mid, s_date, s_message, s_ip ) VALUES ( '%d', '%d', '(%s) %s:%s', '%s' )"
So i want to insert the same informations to table like that:
CREATE TABLE IF NOT EXISTS `phpbb_chat` (
`message_id` int(11) unsigned NOT NULL auto_increment,
`chat_id` int(11) unsigned NOT NULL default '0',
`user_id` int(11) unsigned NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`user_colour` varchar(6) NOT NULL default '',
`message` text character set utf8 collate utf8_bin NOT NULL,
`bbcode_bitfield` varchar(255) NOT NULL default '',
`bbcode_uid` varchar(
NOT NULL default '',
`bbcode_options` tinyint(1) unsigned NOT NULL default '7',
`time` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=87511 ;
Can somebody help me with this?