PHP121 Instant Messenger Integration

The time now is Tue 16 Apr, 2024 23:29 • All times are UTC + 1 Hour [DST enabled]

PHP121 Instant Messenger Integration

Page 1 of 5
Goto page 1, 2, 3, 4, 5 Next

KasLimon

Joined: November 2006
Posts: 494
Location:

Madrid (Spain)

PHP121 Instant Messenger Integration

What does this mod does?
It allows you to integrate php121 Instant Messenger system to your Icy Phoenix.
Then, what PHP121 Instant Messenger is?

Quote:
PHP121 is a free web based instant messenger - written entirely in PHP. This means that it will work in any browser on any operating system including Windows and Linux, anywhere!

If traditional messaging programs like MSN Messenger or Yahoo! Messenger are blocked at your school or workplace, PHP121 will still work.

PHP121 is ideal for community websites where a quick and easy way to chat is needed among its members. By changing one setting in the configuration file, PHP121 can be easily integrated into other systems such as PHPNuke and phpBB. More integrations will be available in the future.
[More info: php121.com]

Demo board: here

Installation instructions:

Spoiler: [ Show ]

Download latest version of PHP121 instant messenger (here) and upload php121 folder to your Icy Phoenix root
Download the attached package and upload it to your Icy Phoenix root
Replace phpbb_ with your table prefix and run this SQL:
Code: [Download] [Hide] [Select]
Code: [Download] [Show]
ALTER TABLE `phpbb_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' ;
Run this SQLs:
Code: [Download] [Hide] [Select]
Code: [Download] [Show]
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 ;

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 ;
Apply this file changes:
Open includes/users_online_block.php
Find
Code: [Download] [Hide] [Select]
Code: [Download] [Show]
$sql = "SELECT u.username, u.user_id, u.user_allow_viewonline, u.user_level,

In-line, find
Code: [Download] [Hide] [Select]
Code: [Download] [Show]
u.user_level

In-line after, add
Code: [Download] [Hide] [Select]
Code: [Download] [Show]
, u.php121_user_chatting

Find
Code: [Download] [Hide] [Select]
Code: [Download] [Show]
            $user_online_link = colorize_username($row['user_id']);

Replace with
Code: [Download] [Hide] [Select]
Code: [Download] [Show]
            //***PHP121***
            $php121 = '';
            if ( ($row['php121_user_chatting'] != 0) && ($row['php121_user_chatting'] != NULL )&& (time()-$row['php121_user_chatting']) < 90 )
            {
                $php121 = " <a href="#" onClick="window.open('php121/php121sendim.php?to=$row[user_id]','$row[user_id]','left=20, top=20,width=600,height=500,toolbar=0,resizeable=0');"><img src="php121/php121online.gif" height="11" width="11" border=0 ALT="Send instant message"></a>";
            }
            //***END PHP121***
            $user_online_link = colorize_username($row['user_id']) . $php121;

Find
Code: [Download] [Hide] [Select]
Code: [Download] [Show]
                $user_online_link = '<em>' . colorize_username($row['user_id']) . '</em>';

Replace with
Code: [Download] [Hide] [Select]
Code: [Download] [Show]
                $user_online_link = '<em>' . $user_online_link . '</em>';

Open templates/mg_themes/overall_include.tpl
Find
Code: [Download] [Hide] [Select]
Code: [Download] [Show]


After, add
Code: [Download] [Hide] [Select]
Code: [Download] [Show]
<script type="text/javascript">

</script>
Add php121 CMS block where you want.

Greets!

php121 integration.zip
Description:		Download
Filename:	php121 integration.zip
Filesize:	8.23 KB
Downloaded:	322 Time(s)

____________
Gabriel Anca

Last edited by KasLimon on Tue 18 Mar, 2008 17:18; edited 2 times in total

#1 Tue 18 Mar, 2008 13:13

Sponsors	Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

moreteavicar Joined: August 2006 Posts: 608 Location: Classified	Re: PHP121 Instant Messenger Integration Nice integration KasLimon Only confusing thing is the icon for the chat room being on the right, away from all the other icons...
#2 Tue 18 Mar, 2008 15:17

Chaotic Joined: January 2008 Posts: 1369 Location: Georgia	Re: PHP121 Instant Messenger Integration Great job Kas! ____________ \| Icy Phoenix ColorizeIt! \| Bipolar Disorder - Not good for you and definitely not good for everyone else.
#3 Tue 18 Mar, 2008 15:19

buldo Joined: August 2006 Posts: 474 Location: Borgo San Michele	Re: PHP121 Instant Messenger Integration Nice work KasLimon! ____________ ~~~ Andrea ~~~ User #379756 on Linux Counter "If you can't apt-get something, it isn't useful or doesn't exist!!"
#4 Tue 18 Mar, 2008 15:25

JHOSMAN

Joined: March 2007
Posts: 205
Location:

Bogot

Re: PHP121 Instant Messenger Integration

Have an error of Syntaxis in this SQL

Code: [Download] [Hide]

ALTER TABLE `phpbb_users` ADD `php121_user_chatting` INT( 11 ) DEFAULT '0' NOT NULL , 

I reemplace ` for ' and never

Code: [Download] [Hide]

ALTER TABLE 'ip_users' ADD 'php121_user_chatting' INT( 11 ) DEFAULT '0' NOT NULL , 

Spoiler: [ Show ]

____________
? JHOSMAN - Webmaster

#5 Tue 18 Mar, 2008 15:44

novice programmer

Joined: June 2007
Posts: 1030
Location:

Re: PHP121 Instant Messenger Integration

JHOSMAN wrote: [View Post]
Have an error of Syntaxis in this SQL

Code: [Download] [Hide]
Code: [Download] [Show]
ALTER TABLE `phpbb_users` ADD `php121_user_chatting` INT( 11 ) DEFAULT '0' NOT NULL ,

I reemplace ` for ' and never

Code: [Download] [Hide]
Code: [Download] [Show]
ALTER TABLE 'ip_users' ADD 'php121_user_chatting' INT( 11 ) DEFAULT '0' NOT NULL ,

Spoiler: [ Show ]
Spoiler: [ Hide ]
Error

consulta SQL:

ALTER TABLE `phpbb_users` ADD `php121_user_chatting` INT( 11 ) DEFAULT '0' NOT NULL ,

MySQL ha dicho: Documentación
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Just before it, he said:

Replace phpbb_ with your table prefix and run this SQL:

#6 Tue 18 Mar, 2008 16:15

JHOSMAN

Joined: March 2007
Posts: 205
Location:

Bogot

Re: PHP121 Instant Messenger Integration

It is, the problem is in the post of KasLimon in ` is! => '

PD. my prefix is ip_

novice programmer wrote: [View Post]

Just before it, he said:

Replace phpbb_ with your table prefix and run this SQL:

Spoiler: [ Show ]

check:

Spoiler: [ Show ]

____________
? JHOSMAN - Webmaster

#7 Tue 18 Mar, 2008 16:17

Chaotic

Joined: January 2008
Posts: 1369
Location:

Georgia

Re: PHP121 Instant Messenger Integration

JHOSMAN, try this:

Spoiler: [ Show ]

Code: [Download] [Hide] [Select]

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 ;

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.

____________
| Icy Phoenix ColorizeIt! |
Bipolar Disorder - Not good for you and definitely not good for everyone else.

#8 Tue 18 Mar, 2008 16:34

KasLimon Joined: November 2006 Posts: 494 Location: Madrid (Spain)	Re: PHP121 Instant Messenger Integration moreteavicar, I'm afraid I don't know what icon you are talking about JHOSMAN, if what Chaotic says doesn't work, try this: Quote: ALTER TABLE `ip_users` ADD `php121_user_chatting` INT(11) DEFAULT '0' NOT NULL Thank you all ____________ Gabriel Anca
#9 Tue 18 Mar, 2008 16:39

Chaotic

Joined: January 2008
Posts: 1369
Location:

Georgia

Re: PHP121 Instant Messenger Integration

KasLimon wrote: [View Post]
moreteavicar, I'm afraid I don't know what icon you are talking about

JHOSMAN, if what Chaotic says doesn't work, try this:

Quote:
ALTER TABLE `ip_users` ADD `php121_user_chatting` INT(11) DEFAULT '0' NOT NULL

Thank you all

I think MORETEAVICAR is talking about this icon:

____________
| Icy Phoenix ColorizeIt! |
Bipolar Disorder - Not good for you and definitely not good for everyone else.

#10 Tue 18 Mar, 2008 16:42

JHOSMAN

Joined: March 2007
Posts: 205
Location:

Bogot

Re: PHP121 Instant Messenger Integration

KasLimon wrote: [View Post]
JHOSMAN, if what Chaotic says doesn't work, try this:

Quote:
ALTER TABLE `ip_users` ADD `php121_user_chatting` INT(11) DEFAULT '0' NOT NULL

This SQL it's Runing Thanks

The problem it's here:

Spoiler: [ Show ]

Edit the post of the Instalation

____________
? JHOSMAN - Webmaster

#11 Tue 18 Mar, 2008 16:43

JHOSMAN

Joined: March 2007
Posts: 205
Location:

Bogot

Re: PHP121 Instant Messenger Integration

New problem

Spoiler: [ Show ]

Edit: The SQL of Chaotic if runing

that a exepcion

Spoiler: [ Show ]

____________
? JHOSMAN - Webmaster

Edited by JHOSMAN, Tue 18 Mar, 2008 17:09: Error SQL

#12 Tue 18 Mar, 2008 16:53

KasLimon

Joined: November 2006
Posts: 494
Location:

Madrid (Spain)

Re: PHP121 Instant Messenger Integration

This is only for JHOSMAN. Please don't try to apply this if you are not JHOSMAN

I've made a mistake when posting installation instructions.

Try to run this queries:

Spoiler: [ Show ]

Code: [Download] [Hide] [Select]

ALTER TABLE `phpbb_users` 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' ;

Code: [Download] [Hide] [Select]

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 ;

____________
Gabriel Anca

#13 Tue 18 Mar, 2008 17:20

JHOSMAN

Joined: March 2007
Posts: 205
Location:

Bogot

Re: PHP121 Instant Messenger Integration

The first consult SQL it's nice that second print error

Spoiler: [ Show ]

____________
? JHOSMAN - Webmaster

#14 Tue 18 Mar, 2008 17:30

Chaotic

Joined: January 2008
Posts: 1369
Location:

Georgia

Re: PHP121 Instant Messenger Integration

JHOSMAN wrote: [View Post]
The first consult SQL it's nice that second print error

Spoiler: [ Show ]
Spoiler: [ Hide ]
Code: [Download] [Hide]
Code: [Download] [Show]
Error

consulta SQL:

REATE 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 ;

MySQL ha dicho: Documentación
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REATE TABLE `php121_control` (
`id` int(1) NOT NULL default '1',
`CL_LastMod' at line 1

You may have made a simple mistake JHOSMAN. See:

Code: [Download] [Hide] [Select]

REATE 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 ;

I think when you were copying and pasting, you left out the "C" in "CREATE". You entered "REATE TABLE". It may be best that you delete all the php121 SQL entries and run the SQL queries KasLimon just posted. After you get all the SQL work done, the mod will be a piece of cake to install.

Good luck!

____________
| Icy Phoenix ColorizeIt! |
Bipolar Disorder - Not good for you and definitely not good for everyone else.

#15 Tue 18 Mar, 2008 23:12

Page 1 of 5
Goto page 1, 2, 3, 4, 5 Next

Was this topic useful?

Link this topic
URL
BBCode
HTML

The time now is Tue 16 Apr, 2024 23:29 • All times are UTC + 1 Hour [DST enabled]

Permissions List

You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events