|
Page 1 of 5
|
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:
- 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:
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:
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$sql = "SELECT u.username, u.user_id, u.user_allow_viewonline, u.user_level,
In-line, find
In-line after, add
Find $user_online_link = colorize_username($row['user_id']);
Replace with //***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 $user_online_link = '<em>' . colorize_username($row['user_id']) . '</em>';
Replace with $user_online_link = '<em>' . $user_online_link . '</em>';
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>
- Add php121 CMS block where you want.
Greets!
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
- ALTER TABLE `phpbb_users` ADD `php121_user_chatting` INT( 11 ) DEFAULT '0' NOT NULL ,
I reemplace ` for ' and never
- ALTER TABLE 'ip_users' ADD 'php121_user_chatting' INT( 11 ) DEFAULT '0' NOT NULL ,
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
____________ ? JHOSMAN - Webmaster
|
#5 Tue 18 Mar, 2008 15:44 |
|
novice programmer
Joined: June 2007
Posts: 1030
Location:
|
Re: PHP121 Instant Messenger Integration
Have an error of Syntaxis in this SQL
- ALTER TABLE `phpbb_users` ADD `php121_user_chatting` INT( 11 ) DEFAULT '0' NOT NULL ,
I reemplace ` for ' and never
- ALTER TABLE 'ip_users' ADD 'php121_user_chatting' INT( 11 ) DEFAULT '0' NOT NULL ,
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_
Just before it, he said:
Replace phpbb_ with your table prefix and run this SQL:
Error
consulta SQL:
ALTER TABLE `ip_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
check:
Error
consulta SQL:
ALTER TABLE 'ip_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 ''ip_users' ADD 'php121_user_chatting' INT( 11 ) DEFAULT '0' NOT NULL ,' at line 1
____________ ? 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:
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
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
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:
ALTER TABLE `ip_users` ADD `php121_user_chatting` INT( 11 ) DEFAULT '0' NOT NULL ,
ALTER TABLE `ip_users` ADD `php121_user_chatting` INT(11) DEFAULT '0' NOT NULL
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
Error
consulta SQL:
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';
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 'ADD `php121_smilies` TINYINT( 1 ) DEFAULT '1' NOT NULL ,
ADD `php121_level` TIN' at line 1
Edit: The SQL of Chaotic if runing that a exepcion
Error
consulta SQL:
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';
MySQL ha dicho: Documentación
#1060 - Duplicate column name 'php121_user_chatting'
____________ ? 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: 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' ;
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
- 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
____________ ? JHOSMAN - Webmaster
|
#14 Tue 18 Mar, 2008 17:30 |
|
Chaotic
Joined: January 2008
Posts: 1369
Location: Georgia
|
Re: PHP121 Instant Messenger Integration
The first consult SQL it's nice that second print error
- 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:
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
|
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
|
|
|
|