 | Live Chat box |  |
 Posted: 11/26/2006 10:33 PM |
 |
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
 |
|
|
|
Joined: Oct 29, 2006
Local time: 5:43 AM
Location: Klang, Malaysia
|
|
|
|
|
 |
I have a error msg as like below after i add the live chat box MOD.
| Code:
|
Could not check session for Ghosts
DEBUG MODE
SQL Error : 1146 Table 'wtfone_phpb1.phpbb_chatbox_session' doesn't exist
DELETE FROM phpbb_chatbox_session WHERE lastactive < '1164597943'
Line : 38
File : chatbox_front.php
|
 |
|
|
|
|
| Back to Top |
|
|
| Re: Live Chat box | |
| Posted: 11/26/2006 10:52 PM |
|
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 5:43 AM
Location: Klang, Malaysia
|
|
|
|
|
|
This is a installtion code~~
| Code:
|
##############################################################
## MOD Title: ChatBox
## MOD Author: Smartor < > (Hoang Ngoc Tu) http://smartor.is-root.com
## MOD Description: This will add a LIVE chatbox on your phpBB2
## Only registered users can chat. Admin can take
## control chatroom by some commands(/KICK username, /CLEAR). Smilies enabled.
## Only tested with phpBB 2.0.x/MySQL
## MOD Version: 1.1.9g
##
## Installation Level: easy
## Installation Time: 10 Minutes
## Files To Edit: 3
## index.php
## templates/subSilver/index_body.tpl
## language/lang_english/lang_main.php
##
## Included Files: 10
## chatbox_db_install.php (only required for DB install)
## chatbox_front.php
## chatbox_mod/chatbox.css
## chatbox_mod/chatbox.php
## chatbox_mod/chatbox_config.php
## chatbox_mod/chatbox_drop.php
## chatbox_mod/chatbox_function.php
## chatbox_mod/messenger_list.php
## chatbox_mod/messenger_send.php
## chatbox_mod/messenger_view.php
##############################################################
## This MOD is released under the GPL License.
## Intellectual Property is retained by the MOD Author(s) listed above
##############################################################
## Author Notes:
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################
#
#-----[ OPEN ]---------------------------------------------
#
index.php
#
#-----[ FIND ]---------------------------------------------
#
$template->assign_vars(array(
'TOTAL_POSTS' => sprintf($l_total_post_s, $total_posts),
'TOTAL_USERS' => sprintf($l_total_user_s, $total_users),
'NEWEST_USER' => sprintf($lang['Newest_user'], '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$newest_uid") . '">', $newest_user, '</a>'),
#
#-----[ BEFORE, ADD ]--------------------------------------
#
// ChatBox Mod
require_once($phpbb_root_path . 'chatbox_front.php');
#
#-----[ FIND ]---------------------------------------------
#
'L_MARK_FORUMS_READ' => $lang['Mark_all_forums'],
#
#-----[ AFTER, ADD ]--------------------------------------
#
// ChatBox Mod
'TOTAL_CHATTERS_ONLINE' => sprintf($lang['How_Many_Chatters'], $howmanychat),
'CHATTERS_LIST' => sprintf($lang['Who_Are_Chatting' ], $chatters),
'L_CLICK_TO_JOIN_CHAT' => $lang['Click_to_join_chat'],
'S_JOIN_CHAT' => append_sid("chatbox_mod/chatbox.$phpEx"),
'CHATBOX_NAME' => $userdata['user_id'] . '_ChatBox', // To make easier to test on my PC
'L_LOGIN_TO_JOIN_CHAT' => $lang['Login_to_join_chat'],
#
#-----[ OPEN ]---------------------------------------------
#
language/lang_english/lang_main.php
#
#-----[ FIND ]---------------------------------------------
#
//
// That's all Folks!
#
#-----[ BEFORE, ADD ]--------------------------------------
#
// ChatBox Mod
$lang['How_Many_Chatters'] = 'There are <B>%d</B> user(s) on chat now';
$lang['Who_Are_Chatting' ] = '<B>%s</B>';
$lang['Click_to_join_chat'] = 'Click to join chat';
$lang['ChatBox'] = 'ChatBox';
$lang['log_out_chat'] = 'You have successfully logged out from chat on ';
$lang['Send'] = 'Send';
$lang['Login_to_join_chat'] = 'Login to join chat';
#
#-----[ OPEN ]--------------------------------------------
#
templates/subSilver/index_body.tpl
#
#-----[ FIND ]--------------------------------------------
#
<td class="row1" align="center" valign="middle" rowspan="2"><img src="templates/subSilver/images/whosonline.gif" alt="{L_WHO_IS_ONLINE}" /></td>
#
#-----[ REPLACE WITH ]------------------------------------
#
<td class="row1" align="center" valign="middle" rowspan="3"><img src="templates/subSilver/images/whosonline.gif" alt="{L_WHO_IS_ONLINE}" /></td>
#
#-----[ FIND ]---------------------------------------------
#
<tr>
<td class="row1" align="left"><span class="gensmall">{TOTAL_USERS_ONLINE} [ {L_WHOSONLINE_ADMIN} ] [ {L_WHOSONLINE_MOD} ]<br />{RECORD_USERS}<br />{LOGGED_IN_USER_LIST}</span></td>
</tr>
#
#-----[ AFTER, ADD ]--------------------------------------
#
<tr>
<td class="row1" align="left"><span class="gensmall">{TOTAL_CHATTERS_ONLINE}
<!-- BEGIN switch_user_logged_out -->
[ {L_LOGIN_TO_JOIN_CHAT} ]
<!-- END switch_user_logged_out -->
<!-- BEGIN switch_user_logged_in -->
[ <a href="javascript:void(0);" onClick="window.open('{S_JOIN_CHAT}','{CHATBOX_NAME}','scrollbars=no,w idth=540,height=450')">{L_CLICK_TO_JOIN_CHAT}</a> ]
<!-- END switch_user_logged_in -->
<br />{CHATTERS_LIST}
</span>
</td>
</tr>
#
#-----[ COPY ]--------------------------------------------
#
copy chatbox_front.php to chatbox_front.php
copy chatbox_mod/*.* to chatbox_mod/
#
#-----[ SQL ]---------------------------------------------
# Run these folloing queries manually or run chatbox_db_install.php once
# Afterthat please remove your chatbox_db_install.php immediately
#
CREATE TABLE phpbb_chatbox (
id int(11) NOT NULL auto_increment,
name varchar(99) NOT NULL,
msg varchar(255) NOT NULL,
timestamp int(10) unsigned NOT NULL,
PRIMARY KEY (id));
CREATE TABLE phpbb_chatbox_session (
username varchar(99) NOT NULL,
lastactive int(10) DEFAULT '0' NOT NULL,
laststatus varchar(8) NOT NULL,
UNIQUE username (username));
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
|
|
|
|
|
|
| Back to Top |
|
|
| Re: Live Chat box | |
| Posted: 11/26/2006 11:48 PM |
|
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 5:43 AM
Location: Klang, Malaysia
|
|
|
|
|
|
| To Nightrider,i will offline from now..and i hope u can help me to fix the quote and livechatbox problem.Thanks so much..will online after few hours..coz im at the cyber cafe now. I was zip the livechatbox file and upload it into my (/public_html ) . So sorry..coz awayls need your help.. |
|
|
|
|
| Back to Top |
|
|
| Re: Live Chat box | |
| Posted: 11/27/2006 1:48 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:43 AM
Location: St Pete, FL
|
|
|
|
|
|
| Quote:
|
DEBUG MODE
SQL Error : 1146 Table 'wtfone_phpb1.phpbb_chatbox_session' doesn't exist
|
Those last two words should give you a good clue of what is wrong. You added a MOD that needed to update the database. So you altered the phpBB code but failed to finish the MOD install...
I ran the chatbox_db_install.php file for you in my browser. You really need to be using EM to install your MODs. If you really hose your board and don't use EM, I won't be able to help you fix it...
 |
|
|
|
|
| Back to Top |
|
|
| Re: Live Chat box | |
| Posted: 11/27/2006 9:42 PM |
|
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 5:43 AM
Location: Klang, Malaysia
|
|
|
|
|
|
| Nightrider wrote:
|
| Quote:
|
DEBUG MODE
SQL Error : 1146 Table 'wtfone_phpb1.phpbb_chatbox_session' doesn't exist
|
Those last two words should give you a good clue of what is wrong. You added a MOD that needed to update the database. So you altered the phpBB code but failed to finish the MOD install...
I ran the chatbox_db_install.php file for you in my browser. You really need to be using EM to install your MODs. If you really hose your board and don't use EM, I won't be able to help you fix it...
|
So mean i can't use the livechat box now? OK.. can i know how to using the Em to install MOD? Why my EM need password? and i dunno how to use EM to install MOD..  |
|
|
|
|
| Back to Top |
|
|
| Re: Live Chat box | |
| Posted: 11/28/2006 1:54 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:43 AM
Location: St Pete, FL
|
|
|
|
|
|
If you added the MOD code correctly, then the Live Chat should be working now...
|
|
|
|
|
| Back to Top |
|
|
| Re: Live Chat box | |
| Posted: 11/28/2006 10:51 PM |
|
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 5:43 AM
Location: Klang, Malaysia
|
|
|
|
|
|
| Nightrider wrote:
|
If you added the MOD code correctly, then the Live Chat should be working now...
|
Ok..i will try install the code now..but should i must try on my (test) forum.  |
|
|
|
|
| Back to Top |
|
|
| Re: Live Chat box | |
| Posted: 11/28/2006 11:55 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:43 AM
Location: St Pete, FL
|
|
|
|
|
|
You should install the MODs on your Test board first before installing them on your Live board. The Test board is to work out all the MOD install problems before you ever attempt to install the MOD on your Live board so that there is very little chance of disrupting your Live community...
|
|
|
|
|
| Back to Top |
|
|
| Re: Live Chat box | |
| Posted: 11/29/2006 12:02 AM |
|
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 5:43 AM
Location: Klang, Malaysia
|
|
|
|
|
|
| Nightrider wrote:
|
You should install the MODs on your Test board first before installing them on your Live board. The Test board is to work out all the MOD install problems before you ever attempt to install the MOD on your Live board so that there is very little chance of disrupting your Live community...
|
Roger,but i was install the mod just now.. got adding the new link on top ( Chat ) but when i click it..same error msg also. I don't get at last step .But i was delete all now.. i think i need ur help to install it for me.Can? i was copy the new version ( chatbox_v3_1_0(beta).zip) and i upload it on my /public_html
Can here me to install..i really headache when i want install this MOD. |
|
|
|
|
| Back to Top |
|
|
| Re: Live Chat box | |
| Posted: 11/29/2006 12:28 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:43 AM
Location: St Pete, FL
|
|
|
|
|
|
I don't see the chatbox_v3_1_0(beta) MOD in either your Live or Test board admin/mods folders...
 |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
