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)

Shakefire.com 06-18-2007 05:09 PM

I am getting this error:

Quote:

Originally Posted by error
Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO vb3_plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Cache des templates chatbox', 'cache_templates', '$globaltemplates = array_merge($globaltemplates, array(\'mgc_chatbox\', \'mgc_chatbox_bit\', \'mgc_chatbox_editor\', \'mgc_chatbox_ucp\', \'editor_jsoptions_font\', \'editor_jsoptions_size\'));', 'mgc_chatbox');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Monday, June 18th 2007 @ 01:51:29 PM
Script : http://www.shakefire.com/boards/admincp/plugin.php
Referrer : http://www.shakefire.com/boards/admi...?do=productadd
IP Address : 151.213.225.123
Username : SFpeter
Classname : vb_database

any help?

GoNz00 06-18-2007 05:56 PM

if i use the /me command it throws all the text below to the right hand side ?

and as it wont allow me to search for /me does anyone have an answer please?

SuprSurfr 06-18-2007 06:41 PM

It was working fine for about 3 days.

Now I loging and it is totally missing from the Forums.
I went into usergroups and found that the permissions were all set to no.
I gave my groups the persmissions to see the chat I get this error:

Database error in vBulletin 3.6.7:

Code:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Administrators',
        `description` = '',
        `usertitle` = 'Administrator',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '180',
        `passwordhistory` = '360',
        `mgccustomusergroupperms` = '1',
        `nbmsgshowchatbox` = '100',
        `vbgmepermissions` = '31',
        `forumpermissions` = '1048575',
        `genericpermissions` = '1073741759',
        `attachlimit` = '0',
        `pmquota` = '50',
        `pmpermissions` = '7',
        `pmsendmax` = '5',
        `calendarpermissions` = '63',
        `wolpermissions` = '31',
        `adminpermissions` = '3',
        `genericoptions` = '63',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '100',
        `profilepicmaxsize` = '65535',
        `avatarmaxwidth` = '80',
        `avatarmaxheight` = '80',
        `avatarmaxsize` = '20000',
        `signaturepermissions` = '237567',
        `sigpicmaxwidth` = '500',
        `sigpicmaxheight` = '100',
        `sigpicmaxsize` = '20000',
        `sigmaxrawchars` = '0',
        `sigmaxchars` = '0',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '0'
WHERE usergroupid=6;

MySQL Error  : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054


VBDev 06-18-2007 07:39 PM

Quote:

Originally Posted by Shakefire.com (Post 1271097)
I am getting this error:


any help?

I haven't tested the chatbox on vb3.5.4, and I think that it might not be compatible with that version has there are changes in the plugin management syste.

Quote:

Originally Posted by GoNz00 (Post 1271123)
if i use the /me command it throws all the text below to the right hand side ?

and as it wont allow me to search for /me does anyone have an answer please?

Could you make a screenshot plz ?

Quote:

Originally Posted by SuprSurfr (Post 1271156)
It was working fine for about 3 days.

Now I loging and it is totally missing from the Forums.
I went into usergroups and found that the permissions were all set to no.
I gave my groups the persmissions to see the chat I get this error:

Database error in vBulletin 3.6.7:

Code:

Invalid SQL:
UPDATE usergroup SET
 
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Administrators',
    `description` = '',
    `usertitle` = 'Administrator',
    `opentag` = '',
    `closetag` = '',
    `passwordexpires` = '180',
    `passwordhistory` = '360',
    `mgccustomusergroupperms` = '1',
    `nbmsgshowchatbox` = '100',
    `vbgmepermissions` = '31',
    `forumpermissions` = '1048575',
    `genericpermissions` = '1073741759',
    `attachlimit` = '0',
    `pmquota` = '50',
    `pmpermissions` = '7',
    `pmsendmax` = '5',
    `calendarpermissions` = '63',
    `wolpermissions` = '31',
    `adminpermissions` = '3',
    `genericoptions` = '63',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '65535',
    `avatarmaxwidth` = '80',
    `avatarmaxheight` = '80',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '237567',
    `sigpicmaxwidth` = '500',
    `sigpicmaxheight` = '100',
    `sigpicmaxsize` = '20000',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '0'
WHERE usergroupid=6;
 
MySQL Error  : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054


Have you installed the product_mgc_bitfield ?

GoNz00 06-18-2007 10:08 PM

it wont do it now, i have no idea what went wrong, i disabled the option to stop anyone causing it, and now i re-enabled it, theres no issues ?

obmob 06-19-2007 02:40 AM

Quote:

Originally Posted by VBDev (Post 1270223)
What do you mean exactly ? You can see the team icon channel ? And when you click on it you can chat but chats are not shown ??

You mean the problem of the smiley being far from the username ?

Do you have particular css options in your alt1 and alt2 classes ?

Oh, no, smilie is ok, the problem is that the first line where the date and username are, is not aligned with the chat's messages.

Checked alt classes, but they don't have padding or margin asigned. :eek:

VBDev 06-19-2007 04:24 AM

Quote:

Originally Posted by GoNz00 (Post 1271319)
it wont do it now, i have no idea what went wrong, i disabled the option to stop anyone causing it, and now i re-enabled it, theres no issues ?

No noone has been experienced that expect obmob with the first line problem.

Quote:

Originally Posted by obmob (Post 1271420)
Oh, no, smilie is ok, the problem is that the first line where the date and username are, is not aligned with the chat's messages.

Checked alt classes, but they don't have padding or margin asigned. :eek:

Only the first line??? who that's strange, I don't see what could cause this problem. Especially if this is for one line. I think it might come from your skin but don't know what could be messing with the chatbox :/

Lifesupporters 06-19-2007 07:46 AM

Quote:

Originally Posted by Lifesupporters
I'm using the chatroom in it's own window /forums/mgc_chatbox.php?do=view_chatbox#top to help keep the forums from looking wayyyy too cluttered and scroll heavy. Is there a way to broadcast who's online from this other page?

Quote:

Originally Posted by VBDev (Post 1269584)
You mean the whole who's online of the forum ? If so, my answer for that one would be no coz this would add to much code and it's not a necessary option in my opinion.


I think I explained it rather poorly, sorry. What I meant is that it would be great if you could see who's in chat even if the chat is only configured to display on a separate page.

Currently, the only way the chat will show who is in chat is if the physical chat module is within the forum index. If you use the chat in it's own page, you can no longer see who's in chat nor can you see chat statistics.

I'm obviously not very articulate lately so I hope this make sense.

BTW I'd like to add that I'm also very impressed with how responsive you are within your thread, great work all around!

GoNz00 06-19-2007 09:45 AM

can u fix the /announce in 1.3 ?

im not impressed having to type the word nonce :)

Announce not annonce

makes me sound like a kiddie fiddler typing it :O

VBDev 06-19-2007 12:01 PM

Quote:

Originally Posted by Lifesupporters (Post 1271582)
I think I explained it rather poorly, sorry. What I meant is that it would be great if you could see who's in chat even if the chat is only configured to display on a separate page.

Currently, the only way the chat will show who is in chat is if the physical chat module is within the forum index. If you use the chat in it's own page, you can no longer see who's in chat nor can you see chat statistics.

I'm obviously not very articulate lately so I hope this make sense.

BTW I'd like to add that I'm also very impressed with how responsive you are within your thread, great work all around!

I still don't understand the first part lol

Actually, there are no whosonline for the chatbox so I don't understand what you still don't see ? Maybe you only speak of the statistics ?

What you'd like is an option to show the stats in the self page mode ?

Thanks for the compliment :)

Quote:

Originally Posted by GoNz00 (Post 1271647)
can u fix the /announce in 1.3 ?

im not impressed having to type the word nonce :)

Announce not annonce

makes me sound like a kiddie fiddler typing it :O

As I previously told, this is not a wrong spelling, this is just the fact that this hack was originally developped for the french community. And in french an announce is "annonce".

For some commands I have used english which is in some way easier to type for certain commands, but for this one it was not easier.

Maybe I'll implement both commands so that you don't feel like a kiddie fiddler ...

GoNz00 06-19-2007 12:42 PM

lol thanks, its easier than trying to explain it over and over to the members :)

SuprSurfr 06-19-2007 03:29 PM

Quote:

Originally Posted by VBDev (Post 1271211)
I haven't tested the chatbox on vb3.5.4, and I think that it might not be compatible with that version has there are changes in the plugin management syste.



Could you make a screenshot plz ?



Have you installed the product_mgc_bitfield ?



That was it!

Thanks

Allan 06-19-2007 06:24 PM

Great hack, the best Chatbox on the vBulletin world ;)

RedGTiVR6 06-19-2007 08:07 PM

a quick read didn't answer this question, so if it's posted somewhere in here, please direct me:

We would like to have multiple chats in different forums. Is this possible with this mod?

VBDev 06-19-2007 11:14 PM

You mean different chatboxes but not showing sames chats ?

No that's not possible but that could be an interesting idea.

RedGTiVR6 06-19-2007 11:37 PM

yes - like on the main forum page, it would show a general chat, then in our support forum it would show a different chat.

deltagsm 06-20-2007 12:55 AM

how to fix this?

MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054

burntire 06-20-2007 01:05 AM

Quote:

Originally Posted by deltagsm (Post 1272148)
how to fix this?

MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054

Did you install both products?

VBDev 06-20-2007 04:42 AM

Quote:

Originally Posted by deltagsm (Post 1272148)
how to fix this?

MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054

Quote:

Originally Posted by burntire (Post 1272156)
Did you install both products?

As burntire stated, I think you forgot to install the two products.

pnkllr 06-20-2007 10:51 AM

Hi i was looking around the forum trying to find out how to stick the chat box on the vbadvanced CMPS Portal, anyone know to do this?

Thanks in advance :)

VBDev 06-20-2007 01:44 PM

As stated some previous posts, I'll look that for the next version :)

obmob 06-20-2007 04:52 PM

Quote:

Originally Posted by VBDev (Post 1271474)
Only the first line??? who that's strange, I don't see what could cause this problem. Especially if this is for one line. I think it might come from your skin but don't know what could be messing with the chatbox :/

Hmm... yeah, it's odd, it happens when i add a smilie. Will have to test this a little more...

Also, when i click to add a smilie, i'm sent to the top of the webpage, then i must go down and search for the chatbox, is that normal? :eek:

Thanks!

EDIT: oh, i think you have a #top id somewhere... i have one too, i'll change it and see what happens.

burntire 06-20-2007 06:39 PM

Is there anyway to exclude the navbar for showing when the full page chat is open?

burntire 06-20-2007 06:59 PM

Quote:

Originally Posted by burntire (Post 1272645)
Is there anyway to exclude the navbar for showing when the full page chat is open?


I figured it out.

I don't know if there is an easier way but it works.

I used this in the navbar template

Code:

<if condition="THIS_SCRIPT != 'mgc_chatbox'">

VBDev 06-20-2007 10:35 PM

Quote:

Originally Posted by obmob (Post 1272582)
Hmm... yeah, it's odd, it happens when i add a smilie. Will have to test this a little more...

Also, when i click to add a smilie, i'm sent to the top of the webpage, then i must go down and search for the chatbox, is that normal? :eek:

Thanks!

EDIT: oh, i think you have a #top id somewhere... i have one too, i'll change it and see what happens.

Yes this is an issue I have to correct in the next version :)

For your problem I really don't know what could do that, have tested with smiles and no problem.

Quote:

Originally Posted by burntire (Post 1272657)
I figured it out.

I don't know if there is an easier way but it works.

I used this in the navbar template

Code:

<if condition="THIS_SCRIPT != 'mgc_chatbox'">

Nope I think it's the better way as I use the GENERIC_SHELL vbulletin template for the building of that page (so can't remove any $navbar in my templates).

obmob 06-20-2007 10:38 PM

Quote:

Originally Posted by VBDev (Post 1272777)
Yes this is an issue I have to correct in the next version :)

For your problem I really don't know what could do that, have tested with smiles and no problem.

Oh, thanks... in the meantime i'll keep testing my css classes and see which one might be the problem.

Thanks

ABeautifulBrown 06-22-2007 03:10 AM

awesome mod. love it.

grandfso 06-23-2007 04:17 AM

Hi! Great mod! Already installed it! But tell me, how do I edit shouts?

daemon_ 06-23-2007 01:39 PM

does it work with vbadvanced?

santimariani 06-23-2007 02:09 PM

Hm... I've tried installing the mod, but it is not working properly. The chatbox is disected and I can't use it. I've attached an image of what I am getting. Any ideas?

VBDev 06-24-2007 04:25 PM

I think you have put the modification in the navbar to a wrong place.

Have you installed on your board a hack which helps you managing the link in your navbar ?

Chadi 06-24-2007 04:55 PM

Nice chat system. Just some feature requests if I may :)

Built in mp3 player (right side column). I will gladly donate $25 for this particular mp3 addon, along with anyone else willing to donate for your time.

The MP3 player features would include

* stream mp3 from my local server
* stream online radio stations
* sort by artist, song title or genre
* mini search box to search song list
* volume / start / stop / pause
* shuffle playlist
* search / sort function (category, artist, song, genre, sermons)
* expand (shows all functions plus about 10 songs in list w/ scrollbar) / Collapse (minimal view, just buttons)

ABeautifulBrown 06-25-2007 03:33 AM

can it be put on every page?

VBDev 06-25-2007 04:45 AM

Quote:

Originally Posted by chadi (Post 1275523)
Nice chat system. Just some feature requests if I may :)

Built in mp3 player (right side column). I will gladly donate $25 for this particular mp3 addon, along with anyone else willing to donate for your time.

The MP3 player features would include

* stream mp3 from my local server
* stream online radio stations
* sort by artist, song title or genre
* mini search box to search song list
* volume / start / stop / pause
* shuffle playlist
* search / sort function (category, artist, song, genre, sermons)
* expand (shows all functions plus about 10 songs in list w/ scrollbar) / Collapse (minimal view, just buttons)

I really do not have time for such functionnality and I don't think it is an interesting feature for a chatbox as It doesn't add anything to the chat experience ;)

Quote:

Originally Posted by ABeautifulBrown (Post 1275844)
can it be put on every page?

Not actually, it's planned for the enxt version. I am going to start it this week :)

ABeautifulBrown 06-25-2007 10:54 AM

cool beans

srt10etr 06-25-2007 07:43 PM

I keep getting this Error when i try to edit the usergroups settings....

Quote:

Database error in vBulletin 3.6.3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Moderators',
`description` = '',
`usertitle` = 'Moderator',
`opentag` = '<font color=\"#FF0099\">',
`closetag` = '</font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`mgccustomusergroupperms` = '255',
`nbmsgshowchatbox` = '100',
`itraderpermissions` = '0',
`forumpermissions` = '782847',
`genericpermissions` = '535764719',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '15',
`adminpermissions` = '0',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '2000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4'
WHERE usergroupid=7;

MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054
Date : Monday, June 25th 2007 @ 03:42:20 PM
Script : http://www.excessivemotorsport.net/v....php?do=update
Referrer : http://www.excessivemotorsport.net/v...&usergroupid=7
IP Address : 68.33.119.107
Username : DOA 5/15/07
Classname : vb_database

da420 06-25-2007 08:40 PM

You didn't import both plug ins per instructions.

Yukino_AE 06-25-2007 09:24 PM

erm. i'm having trouble with this. it's just not showing up. i even tried the little Display the Chatbox on some styles alteration with no success. help please? @_@

santimariani 06-25-2007 10:23 PM

Quote:

Originally Posted by VBDev (Post 1275496)
I think you have put the modification in the navbar to a wrong place.

Have you installed on your board a hack which helps you managing the link in your navbar ?

I have not installed such a mod. Do I need to? Thanks for the help!

srt10etr 06-25-2007 10:26 PM

Thanks Its Working... Nice Mod...


All times are GMT. The time now is 05:32 AM.

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.02426 seconds
  • Memory Usage 1,861KB
  • 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_code_printable
  • (24)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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