https://www.icyphoenix.com/viewtopic.php?f=28&t=3889&p=26399#p26399
-----------------------------------
Chaotic
Tue 18 Mar, 2008 16:34

Re: PHP121 Instant Messenger Integration
-----------------------------------
[b]JHOSMAN[/b], try this:

[spoiler][code linenumbers=false]CREATE TABLE `php121_blocks` (
  `b_id` int(10) NOT NULL auto_increment,
  `b_user` int(10) NOT NULL default '0',
  `b_block` int(10) NOT NULL default '0',
  PRIMARY KEY  (`b_id`)
) TYPE=MyISAM ;

CREATE TABLE `php121_config` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`config_name`)
) TYPE=MyISAM;

INSERT INTO `php121_config` VALUES ('server_timezone', '0');
INSERT INTO `php121_config` VALUES ('default_language', 'English');
INSERT INTO `php121_config` VALUES ('auto_email_transcript', '0');
INSERT INTO `php121_config` VALUES ('user_can_create_account', '1');
INSERT INTO `php121_config` VALUES ('user_can_delete_account', '1');


CREATE TABLE `php121_requests` (
  `r_id` int(11) NOT NULL auto_increment,
  `roomid` int(11) default NULL,
  `r_to` int(11) NOT NULL default '0',
  `r_from` int(11) NOT NULL default '0',
  `r_time` int(11) NOT NULL default '0',
  `r_result` tinyint(1) NOT NULL default '0',
  `r_update_time` int(11) NOT NULL default '0',
  `r_type` int(1) NOT NULL default '0',
  PRIMARY KEY  (`r_id`)
) TYPE=MyISAM ;

ALTER TABLE `ip_users` ADD `php121_user_chatting` INT( 11 ) DEFAULT '0' NOT NULL ,
ADD `php121_smilies` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `php121_level` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `php121_showrequest` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `php121_beep_newmsg` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `php121_focus_newmsg` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `php121_auto_email_transcript` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `php121_banned` TINYINT( 1 ) DEFAULT '0' NOT NULL ,
ADD `php121_timezone` TINYINT( 3 ) DEFAULT '0' NOT NULL ,
ADD `php121_timestamp` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `php121_language` VARCHAR( 30 ) DEFAULT 'English' NOT NULL ,
ADD `php121_cl_update_key` int(11) NOT NULL default '0',
ADD `imbl_appear_offline` int(1) NOT NULL default '0',
ADD `imbl_away_message` varchar(255) NOT NULL default '',
ADD `imbl_usertheme` varchar(64) NOT NULL default '',
ADD `imbl_profileshowsbuddies` int(1) NOT NULL default '1',
ADD `imbl_general_info` text NOT NULL,
ADD `imbl_profile_timestamp` varchar(255) NOT NULL default '',
ADD `imbl_profiletheme` varchar(64) NOT NULL default '',
ADD `imbl_profile_gender` varchar(35) NOT NULL default '',
ADD `imbl_profile_age` int(2) NOT NULL default '0',
ADD `imbl_profile_location` varchar(35) NOT NULL default '',
ADD `imbl_profile_status` varchar(35) NOT NULL default '',
ADD `imbl_profile_orientation` varchar(35) NOT NULL default '',
ADD `imbl_profile_occupation` varchar(35) NOT NULL default '',
ADD `imbl_profile_avataruploaded` int(1) NOT NULL default '0',
ADD `imbl_profile_avatarhide` int(1) NOT NULL default '0',
ADD `php121_tabs_timestamp` int(11) NOT NULL default '0',
ADD `php121_tabs_update` int(1) NOT NULL default '0';


CREATE TABLE `php121_control` (
  `id` int(1) NOT NULL default '1',
  `CL_LastModified` int(11) NOT NULL default '0',
  `CL_UpdateKey` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;


INSERT INTO `php121_control` VALUES (1, 1, 1);

INSERT INTO `php121_control` VALUES (2, 1, 1);

CREATE TABLE `php121_messages` (
  `msgid` int(11) NOT NULL auto_increment,
  `roomid` int(11) NOT NULL default '0',
  `username` varchar(25) NOT NULL default '',
  `timestamp` int(11) NOT NULL default '0',
  `servernotice` int(1) NOT NULL default '0',
  `message` longtext NOT NULL,
  PRIMARY KEY  (`msgid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


CREATE TABLE `php121_rooms` (
  `roomid` int(11) NOT NULL default '0',
  `uname` varchar(25) NOT NULL default '',
  `joined` int(11) NOT NULL default '0',
  `lastping` int(11) NOT NULL default '0',
  `timedout` int(1) NOT NULL default '0',
  PRIMARY KEY  (`roomid`,`uname`)
) TYPE=MyISAM;


CREATE TABLE `php121_smilies` (
  `id` smallint(5) NOT NULL auto_increment,
  `code` varchar(50) NOT NULL default '',
  `filename` varchar(100) NOT NULL default '',
  `description` varchar(75) NOT NULL default '',
  `pack` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=44 ;

INSERT INTO `php121_smilies` VALUES (1, ':D', 'icon_biggrin.gif', 'Very Happy', 'phpbb');
INSERT INTO `php121_smilies` VALUES (2, ':)', 'icon_smile.gif', 'Smile', 'phpbb');
INSERT INTO `php121_smilies` VALUES (3, ':smile:', 'icon_smile.gif', 'Smile', 'phpbb');
INSERT INTO `php121_smilies` VALUES (4, ':(', 'icon_sad.gif', 'Sad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (5, ':-(', 'icon_sad.gif', 'Sad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (6, ':sad:', 'icon_sad.gif', 'Sad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (7, ':o', 'icon_surprised.gif', 'Surprised', 'phpbb');
INSERT INTO `php121_smilies` VALUES (8, ':-o', 'icon_surprised.gif', 'Surprised', 'phpbb');
INSERT INTO `php121_smilies` VALUES (9, ':eek:', 'icon_surprised.gif', 'Surprised', 'phpbb');
INSERT INTO `php121_smilies` VALUES (10, '8O', 'icon_eek.gif', 'Shocked', 'phpbb');
INSERT INTO `php121_smilies` VALUES (11, '8-O', 'icon_eek.gif', 'Shocked', 'phpbb');
INSERT INTO `php121_smilies` VALUES (12, ':shock:', 'icon_eek.gif', 'Shocked', 'phpbb');
INSERT INTO `php121_smilies` VALUES (13, ':?', 'icon_confused.gif', 'Confused', 'phpbb');
INSERT INTO `php121_smilies` VALUES (14, ':-?', 'icon_confused.gif', 'Confused', 'phpbb');
INSERT INTO `php121_smilies` VALUES (15, ':???:', 'icon_confused.gif', 'Confused', 'phpbb');
INSERT INTO `php121_smilies` VALUES (16, '8)', 'icon_cool.gif', 'Cool', 'phpbb');
INSERT INTO `php121_smilies` VALUES (17, '8-)', 'icon_cool.gif', 'Cool', 'phpbb');
INSERT INTO `php121_smilies` VALUES (18, ':cool:', 'icon_cool.gif', 'Cool', 'phpbb');
INSERT INTO `php121_smilies` VALUES (19, ':lol:', 'icon_lol.gif', 'Laughing', 'phpbb');
INSERT INTO `php121_smilies` VALUES (20, ':x', 'icon_mad.gif', 'Mad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (21, ':-x', 'icon_mad.gif', 'Mad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (22, ':mad:', 'icon_mad.gif', 'Mad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (23, ':P', 'icon_razz.gif', 'Razz', 'phpbb');
INSERT INTO `php121_smilies` VALUES (24, ':-P', 'icon_razz.gif', 'Razz', 'phpbb');
INSERT INTO `php121_smilies` VALUES (25, ':razz:', 'icon_razz.gif', 'Razz', 'phpbb');
INSERT INTO `php121_smilies` VALUES (26, ':oops:', 'icon_redface.gif', 'Embarassed', 'phpbb');
INSERT INTO `php121_smilies` VALUES (27, ':cry:', 'icon_cry.gif', 'Crying or Very sad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (28, ':evil:', 'icon_evil.gif', 'Evil or Very Mad', 'phpbb');
INSERT INTO `php121_smilies` VALUES (29, ':twisted:', 'icon_twisted.gif', 'Twisted Evil', 'phpbb');
INSERT INTO `php121_smilies` VALUES (30, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes', 'phpbb');
INSERT INTO `php121_smilies` VALUES (31, ':wink:', 'icon_wink.gif', 'Wink', 'phpbb');
INSERT INTO `php121_smilies` VALUES (32, ';)', 'icon_wink.gif', 'Wink', 'phpbb');
INSERT INTO `php121_smilies` VALUES (33, ':!:', 'icon_exclaim.gif', 'Exclamation', 'phpbb');
INSERT INTO `php121_smilies` VALUES (34, ':?:', 'icon_question.gif', 'Question', 'phpbb');
INSERT INTO `php121_smilies` VALUES (35, ':idea:', 'icon_idea.gif', 'Idea', 'phpbb');
INSERT INTO `php121_smilies` VALUES (36, ':arrow:', 'icon_arrow.gif', 'Arrow', 'phpbb');
INSERT INTO `php121_smilies` VALUES (37, ':|', 'icon_neutral.gif', 'Neutral', 'phpbb');
INSERT INTO `php121_smilies` VALUES (38, ':-|', 'icon_neutral.gif', 'Neutral', 'phpbb');
INSERT INTO `php121_smilies` VALUES (39, ':neutral:', 'icon_neutral.gif', 'Neutral', 'phpbb');
INSERT INTO `php121_smilies` VALUES (40, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green', 'phpbb');
INSERT INTO `php121_smilies` VALUES (41, ':^_^:', 'aiwebs_004.gif', 'Smile (Japanese)', 'phpbb');
INSERT INTO `php121_smilies` VALUES (42, ':wave:', 'wavey.gif', '', 'phpbb');
INSERT INTO `php121_smilies` VALUES (43, ':samurai:', 'samurai.gif', '', 'phpbb');


CREATE TABLE `imbuddylist` (
  `id` int(20) NOT NULL auto_increment,
  `userid` int(32) NOT NULL default '0',
  `buddyid` int(32) NOT NULL default '0',
  `buddygroup` int(32) NOT NULL default '0',
  `buddycomment` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `imbuddylist_config` (
  `config_name` varchar(255) NOT NULL default '',
  `defaulttheme` varchar(255) NOT NULL default '',
  `group_allonline_opened` int(1) NOT NULL default '1',
  `group_onlinebuddies_opened` int(1) NOT NULL default '1',
  `group_offlinebuddies_opened` int(1) NOT NULL default '0',
  `profile_enabled` int(1) NOT NULL default '1',
  `buddylist_enabled` int(1) NOT NULL default '1',
  `awaymsg_enabled` int(1) NOT NULL default '1',
  `showonline_enabled` int(1) NOT NULL default '1',
  `usersearch_enabled` int(1) NOT NULL default '1',
  `profilecomments_enabled` int(1) NOT NULL default '1',
  `profileavatars_enabled` int(1) NOT NULL default '1',
  `buddycomments_enabled` int(1) NOT NULL default '1',
  `offlinemessages_enabled` int(1) NOT NULL default '1',
  `debugmode_enabled` int(1) NOT NULL default '0',
  `adminscontrolusersettings` int(1) NOT NULL default '0',
  `chatlogsaving_enabled` int(1) NOT NULL default '1',
  `staffsupportsystem_enabled` int(1) NOT NULL default '1',
  `usersautoacceptchatrequests` int(1) NOT NULL default '0',
  PRIMARY KEY  (`config_name`)
) TYPE=MyISAM;
INSERT INTO `imbuddylist_config` VALUES ('imbuddylist', '', 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0);

CREATE TABLE `imbuddylist_groups` (
  `id` int(20) NOT NULL auto_increment,
  `userid` int(32) NOT NULL default '0',
  `group` varchar(21) NOT NULL default '',
  `opened` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `imbuddylist_profilecomments` (
  `comment_id` int(20) NOT NULL auto_increment,
  `profile_id` int(20) NOT NULL default '0',
  `poster_id` int(20) NOT NULL default '0',
  `timestamp` int(11) NOT NULL default '0',
  PRIMARY KEY  (`comment_id`),
  KEY `profile_id` (`profile_id`),
  KEY `poster_id` (`poster_id`),
  KEY `timestamp` (`timestamp`)
) TYPE=MyISAM;

CREATE TABLE `imbuddylist_profilecomments_text` (
  `comment_id` int(20) NOT NULL auto_increment,
  `comment_text` text,
  PRIMARY KEY  (`comment_id`)
) TYPE=MyISAM;

CREATE TABLE `imbuddylist_staffbuddies` (
  `id` int(20) NOT NULL auto_increment,
  `userid` varchar(45) NOT NULL default '1',
  `buddyid` varchar(45) NOT NULL default '',
  `buddygroup` varchar(45) NOT NULL default '',
  `displayname` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `imbuddylist_staffgroups` (
  `id` int(20) NOT NULL auto_increment,
  `userid` varchar(45) NOT NULL default '1',
  `group` varchar(45) NOT NULL default '',
  `opened` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `php121_offlinemessages` (
  `offlineim_id` INT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  `receiver_id` INT(20) NOT NULL ,
  `sender_id` INT(20) NOT NULL ,
  `timestamp` INT(11) NOT NULL ,
  `subject` varchar(50) NOT NULL default '',
  `unread` int(1) NOT NULL default '1',
  INDEX ( `receiver_id` ) 
) TYPE = MYISAM ;

CREATE TABLE `php121_offlinemessages_text` (
`offlineim_id` INT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`offlineim_text` TEXT NULL 
) TYPE = MYISAM ;

CREATE TABLE `php121_chatlogs` (
  `id` int(99) NOT NULL auto_increment,
  `room_id` int(99) NOT NULL default '0',
  `timestamp` int(11) NOT NULL default '0',
  `usernames` text NOT NULL,
  `textlog` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;[/code][/spoiler]

I had a problem with functions not working a few days ago, so I removed all the php121 SQL actions and started over from scratch.  I also ran each SQL block manually, block by block to be sure all SQL code was executed correctly.

Try that.


