|
Page 4 of 5
|
 Chaotic 
Joined: January 2008
Posts: 1369
Location:  Georgia
|
 Re: PHP121 Instant Messenger Integration
I have two problems SQL
- 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
- 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!
____________ | Icy Phoenix ColorizeIt! |
Bipolar Disorder - Not good for you and definitely not good for everyone else.
|
#46 Sat 29 Mar, 2008 01:42 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
| |
xmenfile
Joined: September 2007
Posts: 482
Location: Right in front of my computer
|
Re: PHP121 Instant Messenger Integration
Joshman, do you have any luck? i tried over and over MySQL, but same result.
|
#47 Thu 10 Apr, 2008 10:36 |
|
xmenfile
Joined: September 2007
Posts: 482
Location: Right in front of my computer
|
Re: PHP121 Instant Messenger Integration
I have two problems SQL
- 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
- 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.
|
#48 Sat 24 May, 2008 17:27 |
|
postanime
Joined: September 2007
Posts: 15
|
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.
^^
|
#49 Sun 01 Jun, 2008 04:29 |
|
xmenfile
Joined: September 2007
Posts: 482
Location: Right in front of my computer
|
Re: PHP121 Instant Messenger Integration
it used to be free, but now they are charging it.
|
#50 Sun 01 Jun, 2008 08:16 |
|
Chaotic
Joined: January 2008
Posts: 1369
Location: Georgia
|
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.
^^
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.
____________ | Icy Phoenix ColorizeIt! |
Bipolar Disorder - Not good for you and definitely not good for everyone else.
|
#51 Mon 02 Jun, 2008 00:49 |
|
postanime
Joined: September 2007
Posts: 15
|
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
|
#52 Wed 11 Jun, 2008 01:08 |
|
postanime
Joined: September 2007
Posts: 15
|
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.
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.
-- 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 
|
#53 Wed 11 Jun, 2008 20:37 |
|
xmenfile
Joined: September 2007
Posts: 482
Location: Right in front of my computer
|
Re: PHP121 Instant Messenger Integration
awesome Postanime. I'll try it 
|
#54 Thu 12 Jun, 2008 00:44 |
|
KasLimon
Joined: November 2006
Posts: 494
Location:  Madrid (Spain)
|
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!
____________
Gabriel Anca
|
#55 Sat 14 Jun, 2008 09:59 |
|
Chaotic
Joined: January 2008
Posts: 1369
Location: Georgia
|
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.
____________ | Icy Phoenix ColorizeIt! |
Bipolar Disorder - Not good for you and definitely not good for everyone else.
|
#56 Sat 14 Jun, 2008 10:05 |
|
KasLimon
Joined: November 2006
Posts: 494
Location: Madrid (Spain)
|
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!
____________
Gabriel Anca
|
#57 Sun 15 Jun, 2008 11:14 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7192
Location:  Borgo San Michele
|
Re: PHP121 Instant Messenger Integration
Thanks Kas for having asked. 
And of course thanks for sharing...
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#58 Thu 26 Jun, 2008 16:06 |
|
argenta
Joined: October 2007
Posts: 25
|
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?
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>
|
#59 Fri 27 Jun, 2008 12:02 |
|
KasLimon
Joined: November 2006
Posts: 494
Location: Madrid (Spain)
|
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!
____________
Gabriel Anca
|
#60 Sun 13 Jul, 2008 16:08 |
|
|
|
Page 4 of 5
|
 Was this topic useful?
 Was this topic useful?
| Link this topic |
|---|
| URL |
|
| BBCode |
|
| HTML |
|
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
|
|
|
|
