PHP121 Instant Messenger Integration

Forum » Icy Phoenix Support » Older Versions Archive » Old Customizations

PHP121 Instant Messenger Integration

Reply to topic

Goto page Previous 1, 2, 3, 4, 5 Next

Chaotic

Quote

Posts: 1369 Location: Georgia

Sat 29 Mar, 2008 01:42

Subject: Re: PHP121 Instant Messenger Integration

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

Code: [Download] [Hide]
Code: [Download] [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: [Download] [Hide]
Code: [Download] [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!

Profile PM Website AIM MSN

xmenfile

Quote

Posts: 482 Location: Right in front of my computer

Thu 10 Apr, 2008 10:36

Subject: Re: PHP121 Instant Messenger Integration

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

Profile PM

xmenfile

Quote

Posts: 482 Location: Right in front of my computer

Sat 24 May, 2008 17:27

Subject: Re: PHP121 Instant Messenger Integration

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

Code: [Download] [Hide]
Code: [Download] [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: [Download] [Hide]
Code: [Download] [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.

Profile PM

postanime

Quote

Posts: 15

Sun 01 Jun, 2008 04:29

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.

^^

Profile PM

xmenfile

Quote

Posts: 482 Location: Right in front of my computer

Sun 01 Jun, 2008 08:16

Subject: Re: PHP121 Instant Messenger Integration

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

Profile PM

Chaotic

Quote

Posts: 1369 Location: Georgia

Mon 02 Jun, 2008 00:49

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 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.

Profile PM Website AIM MSN

postanime

Quote

Posts: 15

Wed 11 Jun, 2008 01:08

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

Profile PM

postanime

Quote

Posts: 15

Wed 11 Jun, 2008 20:37

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: [Download] [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: [Download] [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 :D

Profile PM

xmenfile

Quote

Posts: 482 Location: Right in front of my computer

Thu 12 Jun, 2008 00:44

Subject: Re: PHP121 Instant Messenger Integration

awesome Postanime. I'll try it :mricy: :mricy:

Profile PM

KasLimon

Quote

Posts: 494 Location: Madrid (Spain)

Sat 14 Jun, 2008 09:59

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! :mri:

Profile PM Website MSN

Chaotic

Quote

Posts: 1369 Location: Georgia

Sat 14 Jun, 2008 10:05

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.

Profile PM Website AIM MSN

KasLimon

Quote

Posts: 494 Location: Madrid (Spain)

Sun 15 Jun, 2008 11:14

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!

Profile PM Website MSN

Mighty Gorgon

Quote

Posts: 7192 Location: Borgo San Michele

Thu 26 Jun, 2008 16:06

Subject: Re: PHP121 Instant Messenger Integration

Thanks Kas for having asked. :wink:

And of course thanks for sharing... :wink:

Profile PM Website

argenta

Quote

Posts: 25

Fri 27 Jun, 2008 12:02

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: [Download] [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>

Profile PM

KasLimon

Quote

Posts: 494 Location: Madrid (Spain)

Sun 13 Jul, 2008 16:08

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! :mri:

Profile PM Website MSN

Reply to topic

Goto page Previous 1, 2, 3, 4, 5 Next

Page 4 of 5

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

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.2539s (PHP: 12% SQL: 88%)
SQL queries: 13 - Debug Off - GZIP Enabled

Icy Phoenix

Icy Phoenix - Powering Communities

PHP121 Instant Messenger Integration