vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Chat Modifications - MGC Chatbox (with AJAX) (https://vborg.vbsupport.ru/showthread.php?t=148472)

VBDev 07-25-2007 06:34 AM

Cool :) I am relieved for now !

I'll put the corrected 1.4 version tonight then !

maidos 07-25-2007 07:22 AM

how about the pm channel ? when a user want to send a pm to i see the blinking on the pm channel and when i try to respond on that pm chanenl the msg will display on the main channel and not on the on pm channel...

maidos 07-25-2007 07:37 AM

i got this error

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT id,u.username,u.usergroupid,date,chat,u.userid AS userid

FROM mgc_chatbox AS mgc_cb
LEFT JOIN user AS u ON(mgc_cb.userid = u.userid)

WHERE chat NOT REGEXP '^(/[tT][eE][aA][mM])' AND touserid='0'
ORDER BY date DESC
LIMIT 16;

MySQL Error : Unknown column 'touserid' in 'where clause'
Error Number : 1054
Date : Wednesday, July 25th 2007 @ 12:10:28 AM
Script : http://www./forums/mgc_chatbox.php
Referrer : http://www./forums/index.php
IP Address : 24.80.183.xxx
Username : taka
Classname : vB_Database

VBDev 07-25-2007 07:39 AM

There are no blinking on the PM channel.

As I already told you for the PM channel, you can't just send the message without entering again the pm command as you might pm anyone you want.

To answer a private shout, even in the pm channel, you have to enter the command again before your text, this is why I have added the pen to easier command entering.

VBDev 07-25-2007 07:41 AM

Quote:

Originally Posted by maidos (Post 1300932)
i got this error

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT id,u.username,u.usergroupid,date,chat,u.userid AS userid

FROM mgc_chatbox AS mgc_cb
LEFT JOIN user AS u ON(mgc_cb.userid = u.userid)

WHERE chat NOT REGEXP '^(/[tT][eE][aA][mM])' AND touserid='0'
ORDER BY date DESC
LIMIT 16;

MySQL Error : Unknown column 'touserid' in 'where clause'
Error Number : 1054
Date : Wednesday, July 25th 2007 @ 12:10:28 AM
Script : http://www./forums/mgc_chatbox.php
Referrer : http://www./forums/index.php
IP Address : 24.80.183.xxx
Username : taka
Classname : vB_Database

Which version do you have installed now ?

Could you try plz to sum up all your problems before entering a post ? Coz this makes too many messages and I think it could easier things if you just wait before facing all problems and reporting them.

Tulsa 07-25-2007 07:42 AM

Pottsy - thanks for that! :)

that language issue really wreaked havoc with the ajax.

maidos 07-25-2007 07:43 AM

i received these msg once i tried to pm a user
using 3.6.7

alright sorry...
btw then heres a feature request, if possible can u make it possible to have the user in a list on a pm channel and select a user u wish to chat with and engage a live chat with that person privately without using a pm command

sickboy6ths 07-25-2007 08:11 AM

@VBDev; Thanks for your insight. I have resolved it by setting the correct charset in the Language Manager of vBulletin, this field was empty, it's now filled with utf-8, and the error is gone.

Another question:
I have the shoutbox on all pages and when I go to my who's online page, I can see that everyone is inside the "MGC Chatbox" instead of the page they are really on, what they are doing etc etc (default who's online functionality)... This has always been a problem at every chat/shoutbox I came passed.
EWT Chatbox has resolved this by messing with the session management etc, I don't know the details though. Is it possible to have an option in the future that can enable such functionality?

VBDev 07-25-2007 08:23 AM

Quote:

Originally Posted by maidos (Post 1300938)
i received these msg once i tried to pm a user
using 3.6.7

alright sorry...
btw then heres a feature request, if possible can u make it possible to have the user in a list on a pm channel and select a user u wish to chat with and engage a live chat with that person privately without using a pm command

Could you ckeck in your database if you have the touserid field in the mgc_chatbox field ?

I was speaking of chatbox version, the product and files are the one from the 1.4 that's right ?

For that feature, my anwser will be no sorry, this would complicate the chatbox too much and it would become a chat which is what I don't want !

Quote:

Originally Posted by sickboy6ths (Post 1300957)
@VBDev; Thanks for your insight. I have resolved it by setting the correct charset in the Language Manager of vBulletin, this field was empty, it's now filled with utf-8, and the error is gone.

Another question:
I have the shoutbox on all pages and when I go to my who's online page, I can see that everyone is inside the "MGC Chatbox" instead of the page they are really on, what they are doing etc etc (default who's online functionality)... This has always been a problem at every chat/shoutbox I came passed.
EWT Chatbox has resolved this by messing with the session management etc, I don't know the details though. Is it possible to have an option in the future that can enable such functionality?

ok :)

As a matter of fact, chatbox ajax calls makes the session table to be updated this is the reason why user are shown as being in chatbox.

I unfortunately don't know a lot about vbulletin session so I can't promise you anything on that part :)

wizardan 07-25-2007 09:14 AM

Quote:

Originally Posted by VBDev (Post 1300831)
What problem do you have in full page view ?

None now! I messed up with my file uploads and missed one.
Full page view working fine again.

So the only issue I have left is that Quick Reply situation.
I've read through all the posts this morning, and saw that there seems to be a temporary solution via a new language.

Can someone walk me through the steps?
Otherwise, I'll wait for your fix tonight VBDev.


All times are GMT. The time now is 11:01 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04720 seconds
  • Memory Usage 1,747KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete