Icy Phoenix

Old Customizations - PHP121 Instant Messenger Integration

xmenfile [ Wed 19 Mar, 2008 05:22 ]
Post subject: Re: PHP121 Instant Messenger Integration

Oh, no. Mine comes out 400 error

KasLimon [ Wed 19 Mar, 2008 11:05 ]
Post subject: Re: PHP121 Instant Messenger Integration

JHOSMAN, I agree with Chaotic

xmenfile, do you mean 404 (not found)?
Please check if this file exists:
your_ip_root/php121/php121im.php

xmenfile [ Wed 19 Mar, 2008 13:50 ]
Post subject: Re: PHP121 Instant Messenger Integration

sorry, that's what i meant. I could not find that file, not even in package.

nene94 [ Wed 19 Mar, 2008 15:36 ]
Post subject: Re: PHP121 Instant Messenger Integration

Fatal error: Call to undefined function encode_ip_hexdec() in /homepages/33/d224740309/htdocs/iesmg/ip/includes/sessions.php on line 218

KasLimon [ Wed 19 Mar, 2008 16:13 ]
Post subject: Re: PHP121 Instant Messenger Integration

xmenfile, You should download the ZIP package from here: http://www.php121.com/download.php
Please follow the installation instructions

nene94, this error is related to IP Country Flag Mod, not to php121 Instant Messenger.

Greets!

nene94 [ Wed 19 Mar, 2008 16:30 ]
Post subject: Re: PHP121 Instant Messenger Integration

KasLimon wrote: [View Post]
xmenfile, You should download the ZIP package from here: http://www.php121.com/download.php
Please follow the installation instructions

nene94, this error is related to IP Country Flag Mod, not to php121 Instant Messenger.

Greets!

Ok but you have any other demo board?

Thanks!

KasLimon [ Wed 19 Mar, 2008 16:45 ]
Post subject: Re: PHP121 Instant Messenger Integration

Ok I'm sorry, I had messed up my demo board. I'll repair it ASAP.
I thought you were speaking about your board

KasLimon [ Wed 19 Mar, 2008 16:49 ]
Post subject: Re: PHP121 Instant Messenger Integration

It should be fixed now

JHOSMAN [ Wed 19 Mar, 2008 18:09 ]
Post subject: Re: PHP121 Instant Messenger Integration

The consults SQL is inished, the problem is

in the add block in "Edit the page" the Archive of Block "php121" no found in the list

Chaotic [ Wed 19 Mar, 2008 18:33 ]
Post subject: Re: PHP121 Instant Messenger Integration

JHOSMAN,

When adding the block, search for "php121" in the Block File. Here are some screenshots of where to find it:

Spoiler: [ Show ]

Also, make sure you have uploaded the "blocks" and "templates" folders that came with the modification in the first post.

nene94 [ Wed 19 Mar, 2008 18:38 ]
Post subject: Re: PHP121 Instant Messenger Integration

KasLimon wrote: [View Post]
It should be fixed now

Thanks!

JHOSMAN [ Wed 19 Mar, 2008 19:37 ]
Post subject: Re: PHP121 Instant Messenger Integration

I reupload the files modified and never

Chek the files

http://www.mediafire.com/?9gy2guone49

xmenfile [ Thu 20 Mar, 2008 08:01 ]
Post subject: Re: PHP121 Instant Messenger Integration

hello, i got an error message. can anyone help? Thank you,

Spoiler: [ Show ]

KasLimon [ Thu 20 Mar, 2008 11:38 ]
Post subject: Re: PHP121 Instant Messenger Integration

JHOSMAN, look at the end of the list.
At first your block will appear at the end of the list.

xmenfile, this is a php121 problem. What have you changed since you installed this addon?

Greets!

xmenfile [ Thu 20 Mar, 2008 14:55 ]
Post subject: Re: PHP121 Instant Messenger Integration

I installed and edit files just like the 1st post instruction said. down load php121 and upload it to root, down load attached package and upload to root and edit 2 files.

KasLimon [ Thu 20 Mar, 2008 15:46 ]
Post subject: Re: PHP121 Instant Messenger Integration

xmenfile, this is very strange...
Have you runned all the mysql queries?

xmenfile [ Thu 20 Mar, 2008 17:21 ]
Post subject: Re: PHP121 Instant Messenger Integration

KasLimon wrote: [View Post]
xmenfile, this is very strange...
Have you runned all the mysql queries?

Yes, i did and i did couple times to make sure.

KasLimon [ Thu 20 Mar, 2008 18:02 ]
Post subject: Re: PHP121 Instant Messenger Integration

If the error is not related to integration you'll have to ask for help in php121.com...

Chaotic [ Thu 20 Mar, 2008 21:15 ]
Post subject: Re: PHP121 Instant Messenger Integration

xmenfile wrote: [View Post]
hello, i got an error message. can anyone help? Thank you,

Spoiler: [ Show ]
Spoiler: [ Hide ]

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/usavngu8/public_html/php121/php121im.php on line 625
Instant Messenger
(0)
TruongVoKy
Online
Online

Set Your Away Message
Appear Offline

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/usavngu8/public_html/php121/php121im.php on line 1399
Online Buddies (0)
Online Buddies (0)

Offline Buddies (0)
Offline Buddies (0)

Online Users (1)
Online Users (1)

Send Instant Message

Powered by PHP121 v3.1.2
(phpBB Integration)

I had those problems at first too. I went back and removed all the SQL from php121 and started from scratch. If you are having these errors when copying and pasting the entire SQL code, try adding each SQL block seperately. My IM worked perfectly after doing that.

KasLimon [ Thu 20 Mar, 2008 22:59 ]
Post subject: Re: PHP121 Instant Messenger Integration

I think the problem is you ran some sql more than once, and that returns an error because some queries ask for a single result and it's returning more than one.
Please delete all tables you've created and execute all SQL queries only once.

Greets!

JHOSMAN [ Fri 21 Mar, 2008 18:24 ]
Post subject: Re: PHP121 Instant Messenger Integration

KasLimon wrote: [View Post]
JHOSMAN, look at the end of the list.
At first your block will appear at the end of the list.

Chek the end of my list

KasLimon [ Sat 22 Mar, 2008 11:08 ]
Post subject: Re: PHP121 Instant Messenger Integration

JHOSMAN, please check if this files are present in your forum:
/blocks/blocks_imp_php121.cfg
/blocks/blocks_imp_php121.php

If they are not, please re-upload all the pack attached to my first message.

Greets!

JHOSMAN [ Sat 22 Mar, 2008 17:03 ]
Post subject: Re: PHP121 Instant Messenger Integration

This have the problem

I later upload the content the DOwnload of php121

Thanks

Other problem

In the block in the portal print this mesage

Code: [Hide]

No input file specified.

xmenfile [ Sat 22 Mar, 2008 20:19 ]
Post subject: Re: PHP121 Instant Messenger Integration

I can't get it work on my and i have a question. do i have to edit anything in the config file?

KasLimon [ Sun 23 Mar, 2008 17:00 ]
Post subject: Re: PHP121 Instant Messenger Integration

JHOSMAN, please show me a shot of your php121 block configuration

xmenfile, Config file included in my first message takes the configuration from config.php and constants.php, it should not have any problem...
Have you deleted all new tables and ran sql again?

Greets!

xmenfile [ Sun 23 Mar, 2008 17:27 ]
Post subject: Re: PHP121 Instant Messenger Integration

KasLimon wrote: [View Post]
JHOSMAN, please show me a shot of your php121 block configuration

xmenfile, Config file included in my first message takes the configuration from config.php and constants.php, it should not have any problem...
Have you deleted all new tables and ran sql again?

Greets!

KasLimon, i did so many times. Let me keep playing wiith it.

JHOSMAN [ Sun 23 Mar, 2008 17:43 ]
Post subject: Re: PHP121 Instant Messenger Integration

KasLimon wrote: [View Post]
JHOSMAN, please show me a shot of your php121 block configuration

Greets!

The show

KasLimon [ Sun 23 Mar, 2008 18:06 ]
Post subject: Re: PHP121 Instant Messenger Integration

Please try to clean cache.

JHOSMAN wrote: [View Post]
In the block in the portal print this mesage

Code: [Hide]
Code: [Show]
No input file specified.

When exactly? When adding the block or when viewing the portal?

Greets!

JHOSMAN [ Sun 23 Mar, 2008 18:43 ]
Post subject: Re: PHP121 Instant Messenger Integration

At time of view the portal

JHOSMAN [ Fri 28 Mar, 2008 16:41 ]
Post subject: Re: PHP121 Instant Messenger Integration

I have two problems SQL

Code: [Hide]

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/kokforos/public_html/foro/php121/php121im.php on line 625 

Code: [Hide]

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/kokforos/public_html/foro/php121/php121im.php on line 1399 

Chaotic [ Sat 29 Mar, 2008 01:42 ]
Post subject: Re: PHP121 Instant Messenger Integration

JHOSMAN wrote: [View Post]
I have two problems SQL

Code: [Hide]
Code: [Show]
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/kokforos/public_html/foro/php121/php121im.php on line 625

Code: [Hide]
Code: [Show]
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/kokforos/public_html/foro/php121/php121im.php on line 1399

I'm 99.9% sure that not all the SQL entries were made. Go back and enter them again and I bet it'll work.

Good luck JHOSMAN!

xmenfile [ Thu 10 Apr, 2008 10:36 ]
Post subject: Re: PHP121 Instant Messenger Integration

Joshman, do you have any luck? i tried over and over MySQL, but same result.

xmenfile [ Sat 24 May, 2008 17:27 ]
Post subject: Re: PHP121 Instant Messenger Integration

Chaotic wrote: [View Post]
JHOSMAN wrote: [View Post]
I have two problems SQL

Code: [Hide]
Code: [Show]
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/kokforos/public_html/foro/php121/php121im.php on line 625

Code: [Hide]
Code: [Show]
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/kokforos/public_html/foro/php121/php121im.php on line 1399

I'm 99.9% sure that not all the SQL entries were made. Go back and enter them again and I bet it'll work.

Good luck JHOSMAN!

no, it's not sql, 'cause i have it work perfectly on other host and when i moved to different host, then getting this error.

postanime [ Sun 01 Jun, 2008 04:29 ]
Post subject: Re: PHP121 Instant Messenger Integration

This may sound weird or even stupid :P, but, is this software free or it has to be buyed?. Because i cant seem to find it free anywhere.

^^

xmenfile [ Sun 01 Jun, 2008 08:16 ]
Post subject: Re: PHP121 Instant Messenger Integration

it used to be free, but now they are charging it.

Chaotic [ Mon 02 Jun, 2008 00:49 ]
Post subject: Re: PHP121 Instant Messenger Integration

postanime wrote: [View Post]
This may sound weird or even stupid :P, but, is this software free or it has to be buyed?. Because i cant seem to find it free anywhere.

^^

I don't see the free link anywhere either. I donated $15 a few years back for this product and it seems to give me access to all future upgrades/versions.

Not seeing the free product probably means they are about to release a new version. When they release a new version, the previous version is released for free.

postanime [ Wed 11 Jun, 2008 01:08 ]
Post subject: Re: PHP121 Instant Messenger Integration

Ok i manage to get php121 (I made the spanish translation :D), so now i have installed and follow every intruction in this topic, but i get almost the same errors like the two users before me, the sql problems.

I tried and tried editing some file to see if i wasnt missing something but i could not find it. So i was wondering, is there anything more to do besides what you say in this post? Because for a fresh installation of php121, the folder contains several files that seem like SQL Queries that i dont see in here.

Another question, someone have succesfully installed this application?.

Thank you for your time

PD: The SQL Querie you mention, i run them twice so i think thats not the problem

postanime [ Wed 11 Jun, 2008 20:37 ]
Post subject: Re: PHP121 Instant Messenger Integration

Hi again, i managed to keep this thing running and i know why are there so many sql errors. Its because in the first Querie in this topic, there are missing some tables. I put you the corrected querie below.

Code: [Hide] [Select]

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_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');

Remember that IP_ it the prefix of your icyphoenix table, be sure to change it if yours is different.

The other querie its i think the same, but i leave it to you just in case.

Code: [Hide] [Select]

-- Table structure for table `imbuddylist`

-- 

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;

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

-- 

-- Table structure for table `imbuddylist_config`

-- 

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

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

-- 

-- Table structure for table `imbuddylist_groups`

-- 

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;

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

-- 

-- Table structure for table `imbuddylist_profilecomments`

-- 

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;

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

-- 

-- Table structure for table `imbuddylist_profilecomments_text`

-- 

CREATE TABLE `imbuddylist_profilecomments_text` (

  `comment_id` int(20) NOT NULL auto_increment,

  `comment_text` text,

  PRIMARY KEY  (`comment_id`)

) TYPE=MyISAM;

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

-- 

-- Table structure for table `imbuddylist_staffbuddies`

-- 

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;

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

-- 

-- Table structure for table `imbuddylist_staffgroups`

-- 

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;

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

-- 

-- Table structure for table `php121_offlinemessages`

-- 

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 ;

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

-- 

-- Table structure for table `php121_offlinemessages_text`

-- 

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 ;

Bye

xmenfile [ Thu 12 Jun, 2008 00:44 ]
Post subject: Re: PHP121 Instant Messenger Integration

awesome Postanime. I'll try it

KasLimon [ Sat 14 Jun, 2008 09:59 ]
Post subject: Re: PHP121 Instant Messenger Integration

php121 doesn't seem to be free now...
I'll send them an email asking if I can keep this topic open, and if I can not, unfortunately I'll close it...

Thank you for your corrections postanime!

Greets!

Chaotic [ Sat 14 Jun, 2008 10:05 ]
Post subject: Re: PHP121 Instant Messenger Integration

Where are you downloading from on that page?

The first two downloads are for supporters only (Need username & password to download). The third download is a manual for those downloads. The fourth and fifth links are the README and CHANGES files.

KasLimon [ Sun 15 Jun, 2008 11:14 ]
Post subject: Re: PHP121 Instant Messenger Integration

I received a reply very quickly. I can keep this topic open, so I'll update first post with some information and postanime queries.

Greets!

Mighty Gorgon [ Thu 26 Jun, 2008 16:06 ]
Post subject: Re: PHP121 Instant Messenger Integration

Thanks Kas for having asked.

And of course thanks for sharing...

argenta [ Fri 27 Jun, 2008 12:02 ]
Post subject: Re: PHP121 Instant Messenger Integration

Kas, thank you for your great job!
Your contribution is very much appreciated

Can you tell me where may I apply the following codechange for ca_aphrodite theme?

Code: [Hide] [Select]

Open templates/mg_themes/overall_include.tpl

Find

<!-- END switch_new_download -->

After, add

<script type="text/javascript">

<!--

var newwindow;

function poptastic(url)

{

    newwindow=window.open(url,'name','height=500,width=240,left=20,top=20,toolbar=no, menubar=no,directories=no,location=no,scrollbars=yes,status=no,resizable=yes,fullscreen=no');

    if (window.focus) {newwindow.focus()}

}

-->

</script>

KasLimon [ Sun 13 Jul, 2008 16:08 ]
Post subject: Re: PHP121 Instant Messenger Integration

Hi, I'm very sorry for the long time since my last visit, but I was in England for the end of the classes. After the trip I had to update my web completely, and I'm still updating my web.

argenta, this change should be done in overall_header.tpl in ca_aphrodite, I think. Just give it a try.

Greets!

Mighty Gorgon [ Wed 23 Jul, 2008 15:39 ]
Post subject: Re: PHP121 Instant Messenger Integration

No problem Kas... take your time... you will find us here when you are ready to work again!

KasLimon wrote: [View Post]
Hi, I'm very sorry for the long time since my last visit, but I was in England for the end of the classes. After the trip I had to update my web completely, and I'm still updating my web.

MaxTortora [ Thu 09 Oct, 2008 19:14 ]
Post subject: Re: PHP121 Instant Messenger Integration

Are you sure that

Code: [Hide] [Select]

           //***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;

is correct?

Because whithout this part of code I have php121 in my site but without the possibility of watch users on-line and off-line...

When I insert this part of code, index.php become white.

Somebody can help me?

Chaotic [ Thu 09 Oct, 2008 20:56 ]
Post subject: Re: PHP121 Instant Messenger Integration

MaxTortora wrote: [View Post]
Are you sure that

//***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;

is correct?

Because whithout this part of code I have php121 in my site but without the possibility of watch users on-line and off-line...

When I insert this part of code, index.php become white.

Somebody can help me?

Please wrap code using the code wrapping BBCode.

Thanks

-- I've used and still use this modification on my website with the installation instructions in the first post. It works like a charm. Be sure you've edited all necessary files and uploaded each file correctly.

MaxTortora [ Thu 09 Oct, 2008 23:52 ]
Post subject: Re: PHP121 Instant Messenger Integration

Thank you very much for your answer, Chaotic.

I have forgotten to say that when I runned the first SQL, the answer was

#1060 - Duplicate column name 'php121_user_chatting'

What does it mean?
Do you think that this message cause my problems?

Thank you very much!

Chaotic [ Thu 09 Oct, 2008 23:54 ]
Post subject: Re: PHP121 Instant Messenger Integration

Very well could be the problem. You may want to remove that second repeating line and see if it works.