vb.org Archive
Page 5 of 36 « First 34 5 6715 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vBChat v2.3 (https://vborg.vbsupport.ru/showthread.php?t=71049)

SVTOA 11-09-2004 11:17 PM
Well... did as instructed, now get this error instead:

Invalid SQL: alter table chat_store
add s_forroom int(15) not null default '0';
mysql error: Table 'sfx-1co_vbthree.chat_store' doesn't exist

Deimos 11-09-2004 11:17 PM
Quote:
Originally Posted by wattieuk
I get this error now:
Database error in vBulletin 3.0.3:

Invalid SQL: alter table chat_store
add s_forroom int(15) not null default '0';
mysql error: Table 'user_pneodb.chat_store' doesn't exist
I think the install file is wrong, when installing it sets the name as "Vbchat_Store", but later on during the modifying part, it looks for "chat_store"

Mijae 11-09-2004 11:20 PM
Quote:
Originally Posted by Deimos
I think the install file is wrong, when installing it sets the name as "Vbchat_Store", but later on during the modifying part, it looks for "chat_store"
Yep, here too:

Code:
Database error in vBulletin 3.0.3:

Invalid SQL: alter table chat_store
add s_forroom int(15) not null default '0';
mysql error: Table 'invoid_vb3.chat_store' doesn't exist

mysql error number: 1146

Date: Tuesday 09th of November 2004 08:18:37 PM
Script: xxx/forum/admincp/install_vbchat.php
Referer: xxx/forum/admincp/install_vbchat.php
Username: Mijae
IP Address: xxx

wattieuk 11-09-2004 11:20 PM
Tried it again and I now get this:
Invalid SQL: alter table vbchat_datastore
add d_smiliedisplay tinyint(2) not null default '1',
add d_smilieamount int(15) not null default '10',
add d_allowbantag tinyint(2) not null default '1',
add d_chatrooms text not null default '',
add d_maxrooms int(15) not null default '5';
mysql error: Duplicate column name 'd_smiliedisplay'

mysql error number: 1060

Zero Tolerance 11-09-2004 11:21 PM
For those that got the error:
Code:
alter table chat_store
add s_forroom int(15) not null default '0';
mysql error: Table 'XXXX.chat_store' doesn't exist
Run this query:
Code:
alter table TABLE_PREFIXvbchat_store
add s_forroom int(15) not null default '0';
(Change TABLE_PREFIX to your settings)

Then continue with the installation steps.

Remind me to test the install next time i release a new version =P

- Zero Tolerance

Mijae 11-09-2004 11:26 PM
Quote:
Originally Posted by Zero Tolerance
For those that got the error:
Code:
alter table chat_store
add s_forroom int(15) not null default '0';
mysql error: Table 'XXXX.chat_store' doesn't exist
Run this query:
Code:
alter table TABLE_PREFIXvbchat_store
add s_forroom int(15) not null default '0';
(Change TABLE_PREFIX to your settings)

Then continue with the installation steps.

Remind me to test the install next time i release a new version =P

- Zero Tolerance
There is another error in the instructions:

Code:
        while ($loggedin = $DB_site->fetch_array($forumusers))
        {
                $userid = $loggedin['userid'];
                if (!$userid)
                {        // Guest
                        $numberguest++;
                        $inforum["$loggedin[inforum]"]++;
                }
                else if (empty($userinfos["$userid"]) OR ($userinfos["$userid"]['lastactivity'] < $loggedin['lastactivity']))
                {
                        $userinfos["$userid"] = $loggedin;
                }

                if(preg_match("/vBChat.php/",$loggedin['location']) && $loggedin['userid']){
                $vbchat_users[$loggedin['userid']] = $loggedin;
                }

        }
I dont have that in index.php :P

wattieuk 11-09-2004 11:27 PM
Ran query as suggested and still get:
Invalid SQL: alter table vbchat_datastore
add d_smiliedisplay tinyint(2) not null default '1',
add d_smilieamount int(15) not null default '10',
add d_allowbantag tinyint(2) not null default '1',
add d_chatrooms text not null default '',
add d_maxrooms int(15) not null default '5';
mysql error: Duplicate column name 'd_smiliedisplay'

Zero Tolerance 11-09-2004 11:29 PM
Quote:
Originally Posted by Mijae
There is another error in the instructions:

Code:
        while ($loggedin = $DB_site->fetch_array($forumusers))
        {
                $userid = $loggedin['userid'];
                if (!$userid)
                {        // Guest
                        $numberguest++;
                        $inforum["$loggedin[inforum]"]++;
                }
                else if (empty($userinfos["$userid"]) OR ($userinfos["$userid"]['lastactivity'] < $loggedin['lastactivity']))
                {
                        $userinfos["$userid"] = $loggedin;
                }

                if(preg_match("/vBChat.php/",$loggedin['location']) && $loggedin['userid']){
                $vbchat_users[$loggedin['userid']] = $loggedin;
                }

        }
I dont have that in index.php :P
Your supposed to add that, just ignore the lines you dont have and continue, while i go smash my head against a wall.

- Zero Tolerance

SVTOA 11-09-2004 11:30 PM
I ran the query now get this:

Invalid SQL: alter table vbchat_datastore
add d_smiliedisplay tinyint(2) not null default '1',
add d_smilieamount int(15) not null default '10',
add d_allowbantag tinyint(2) not null default '1',
add d_chatrooms text not null default '',
add d_maxrooms int(15) not null default '5';
mysql error: Duplicate column name 'd_smiliedisplay'

Zero Tolerance 11-09-2004 11:32 PM
Quote:
Originally Posted by wattieuk
Ran query as suggested and still get:
Invalid SQL: alter table vbchat_datastore
add d_smiliedisplay tinyint(2) not null default '1',
add d_smilieamount int(15) not null default '10',
add d_allowbantag tinyint(2) not null default '1',
add d_chatrooms text not null default '',
add d_maxrooms int(15) not null default '5';
mysql error: Duplicate column name 'd_smiliedisplay'
You were supposed to run the query and continue with steps, not the install file, thats done now.

- Zero Tolerance

wattieuk 11-09-2004 11:33 PM
Bugger! What do i do now then? Do i just delete the install files and then make the code modifications?

SVTOA 11-09-2004 11:35 PM
"Once finished you will be prompted to delete 2 specific file's, you must do this"

You never get to that point because of the SQL errors...

Zero Tolerance 11-09-2004 11:35 PM
Quote:
Originally Posted by wattieuk
Bugger! What do i do now then? Do i just delete the install files and then make the code modifications?
Yep :)

- Zero Tolerance

Zero Tolerance 11-09-2004 11:35 PM
Quote:
Originally Posted by SVTOA
"Once finished you will be prompted to delete 2 specific file's, you must do this"

You never get to that point because of the SQL errors...
Well just delete vbchat.xml and install_vbchat.php

- Zero Tolerance

Deimos 11-09-2004 11:36 PM
Hey Zero, did you read my post about the missing smilies?
I didn't realise you could set your own status, so ignore that "problem" :P
hehe

wattieuk 11-09-2004 11:36 PM
Thanks ZT - the two files I delete are installvbchat and vbchat.xml - is that right?

SVTOA 11-09-2004 11:36 PM
Quote:
Originally Posted by wattieuk
Bugger! What do i do now then? Do i just delete the install files and then make the code modifications?

I guess we delete the install file and the vbchat.xml and continue...

SVTOA 11-09-2004 11:37 PM
ZeroT, you are working overtime here and I really appreciate it, will check back after the code mods...

Zero Tolerance 11-09-2004 11:37 PM
wattieuk @ Yes they are.

Deimos @ Missing smilies? vBChat loads the smilies in the datastore, which is the same function used when posting threads.

- Zero Tolerance

Deimos 11-09-2004 11:40 PM
Yea it's odd, it randomly shows one smiley, but the rest are red x's
Hrm, the smileys are all working on posts etc, but not showing up in the chat.
Is it because I have two groups of smilies? Standard set and a secondary set perhaps?

Zero Tolerance 11-09-2004 11:41 PM
Quote:
Originally Posted by Deimos
Yea it's odd, it randomly shows one smiley, but the rest are red x's
Hrm, the smileys are all working on posts etc, but not showing up in the chat.
Is it because I have two groups of smilies? Standard set and a secondary set perhaps?
Give me an example url of one of the smilies that have a red-x please :)

- Zero Tolerance

Deimos 11-09-2004 11:43 PM
I wish I could!
I can get the URL's for the ones that WORK, but the others just have my forum addess.
This is the forum chat URL

http://www.uoforums.com/forums/vBChat.php?

If I right click on a faulty one and choose "Show picture", it just refreshes ALL the red x's

Zero Tolerance 11-09-2004 11:47 PM
Quote:
Originally Posted by Deimos
I wish I could!
I can get the URL's for the ones that WORK, but the others just have my forum addess.
This is the forum chat URL

http://www.uoforums.com/forums/vBChat.php?

If I right click on a faulty one and choose "Show picture", it just refreshes ALL the red x's
Ok, we'll talk in your vbchat :)

- Zero Tolerance

SVTOA 11-09-2004 11:48 PM
ZT, I'm afraid I'm going to screw up my index.php file- I am not sure where to stop as far as what to replace-

My file does not look like the instructions do-

Zero Tolerance 11-09-2004 11:51 PM
Yeah re-download the zip and reopen the install, it had some code which wasn't supposed to be found. I updated it about 5 mins ago

- Zero Tolerance

SVTOA 11-09-2004 11:53 PM
ok, will do.

wattieuk 11-09-2004 11:55 PM
Quote:
Originally Posted by Zero Tolerance
Change these 4 templates:
chat_row
chat_row_me
chat_row_special_recieved
chat_row_special_sent

Change the html table structure to how you desire :)
It doesn't make any sense to me! Any idea how I can make the chat appear straight after the username?

Zero Tolerance 11-09-2004 11:57 PM
Quote:
Originally Posted by wattieuk
It doesn't make any sense to me! Any idea how I can make the chat appear straight after the username?
Change the html structure, make it just 1 <td> instead of 2 <td>'s

- Zero Tolerance

SVTOA 11-09-2004 11:57 PM
This is how it looks in my index.php file:



Code:
        while ($loggedin = $DB_site->fetch_array($forumusers))
        {
                $userid = $loggedin['userid'];
                if (!$userid)
                {        // Guest
                        $numberguest++;
                        $inforum["$loggedin[inforum]"]++;
                }
                else if (empty($userinfos["$userid"]['lastactivity']) OR ($userinfos["$userid"]['lastactivity'] < $loggedin['lastactivity']))
                {
                        $userinfos["$userid"] = $loggedin;
                        $numberregistered++;
                        if ($userid != $bbuserinfo['userid'])
                        {
                                $inforum["$loggedin[inforum]"]++;
                        }
                        $loggedin['musername'] = fetch_musername($loggedin);

                        if (fetch_online_status($loggedin))
                        {
                                $numbervisible++;
                                eval('$activeusers .= ", ' . fetch_template('forumhome_loggedinuser') . '";');
                        }
                }
        }

So where do I put this?

Code:
        // Get the users in vBChat
        $vbchat_users = array();

        while ($loggedin = $DB_site->fetch_array($forumusers))
        {
                $userid = $loggedin['userid'];
                if (!$userid)
                {        // Guest
                        $numberguest++;
                        $inforum["$loggedin[inforum]"]++;
                }
                else if (empty($userinfos["$userid"]) OR ($userinfos["$userid"]['lastactivity'] < $loggedin['lastactivity']))
                {
                        $userinfos["$userid"] = $loggedin;
                }
        }

        // Configure Peeps In vBChat
        $invBChat = "";

        if(is_array($vbchat_users)){
                foreach($vbchat_users as $invbc){
                        if($invBChat == ""){
                        $extra = "";
                        } else {
                        $extra = ", ";
                        }

                // Get Username Style
                $invbc['musername'] = fetch_musername($invbc);

                $invBChat .= "{$extra}<a href='member.php?{$session['sessionurl']}&u={$invbc['userid']}'>{$invbc['musername']}</a>";
                }
        }

        if($invBChat == ""){
        $invBChat = "<i>No one is currently inside vBChat</i>";
        }

Zero Tolerance 11-10-2004 12:17 AM
Change
Code:
while ($loggedin = $DB_site->fetch_array($forumusers))
        {
                $userid = $loggedin['userid'];
                if (!$userid)
                {        // Guest
                        $numberguest++;
                        $inforum["$loggedin[inforum]"]++;
                }
                else if (empty($userinfos["$userid"]['lastactivity']) OR ($userinfos["$userid"]['lastactivity'] < $loggedin['lastactivity']))
                {
                        $userinfos["$userid"] = $loggedin;
                        $numberregistered++;
                        if ($userid != $bbuserinfo['userid'])
                        {
                                $inforum["$loggedin[inforum]"]++;
                        }
                        $loggedin['musername'] = fetch_musername($loggedin);

                        if (fetch_online_status($loggedin))
                        {
                                $numbervisible++;
                                eval('$activeusers .= ", ' . fetch_template('forumhome_loggedinuser') . '";');
                        }
                }
        }
TO:
Code:
        // Get the users in vBChat
        $vbchat_users = array();
        while ($loggedin = $DB_site->fetch_array($forumusers))
        {
                $userid = $loggedin['userid'];
                if (!$userid)
                {        // Guest
                        $numberguest++;
                        $inforum["$loggedin[inforum]"]++;
                }
                else if (empty($userinfos["$userid"]['lastactivity']) OR ($userinfos["$userid"]['lastactivity'] < $loggedin['lastactivity']))
                {
                        $userinfos["$userid"] = $loggedin;
                        $numberregistered++;
                        if ($userid != $bbuserinfo['userid'])
                        {
                                $inforum["$loggedin[inforum]"]++;
                        }
                        $loggedin['musername'] = fetch_musername($loggedin);

                        if (fetch_online_status($loggedin))
                        {
                                $numbervisible++;
                                eval('$activeusers .= ", ' . fetch_template('forumhome_loggedinuser') . '";');
                        }
                }
        }
        // Configure Peeps In vBChat
        $invBChat = "";

        if(is_array($vbchat_users)){
                foreach($vbchat_users as $invbc){
                        if($invBChat == ""){
                        $extra = "";
                        } else {
                        $extra = ", ";
                        }

                // Get Username Style
                $invbc['musername'] = fetch_musername($invbc);

                $invBChat .= "{$extra}<a href='member.php?{$session['sessionurl']}&u={$invbc['userid']}'>{$invbc['musername']}</a>";
                }
        }

        if($invBChat == ""){
        $invBChat = "<i>No one is currently inside vBChat</i>";
        }
- Zero Tolerance

Mijae 11-10-2004 12:36 AM
One of my users is chatting without a username, so he probably found a bug :P

I'll try to make him talk...

SVTOA 11-10-2004 12:40 AM
ugh... Now it seems that the forumhome "who's online" is fubared. It will only show yourself (your username) as online, but when you click the "who's online" then you see everyone... Any ideas?

SVTOA 11-10-2004 12:42 AM
Yup, something isn't right. If I revert to the old index (I backed it up) then the who's online works correctly...

SVTOA 11-10-2004 01:25 AM
Well ZT, the chat itself works great, all features wrok fine. But It would be nice to get that "who's in VB CHat" to work correctly on the forumhome...
Any ideas? I have been comparing code between the edit and the original, I can't locate the problem.

SVTOA 11-10-2004 01:55 AM
I found some slight differences and altered the code and now at least I can make WHO'S online work again but the "who's in Chat" dispays nobody when there are several. (I guess I'm talking to myself here now!)

bendigo-tech 11-10-2004 02:57 AM
Excellent work. I have the previous version installed and will install this version once a few bugs have been sorted out.

Thanks ZT :D

Blam Forumz 11-10-2004 03:53 AM
Upgraded, except only 1 smilie shwos up each time

Delw 11-10-2004 04:08 AM
I found a missing ; in the directions, it will give you a parse error when trying to login to admin panel.

thought you might want to know, its highlight in red, its at the bottom of the code file

Code:
:: Open File - ROOT FORUM DIRECTORY/admincp/index.php
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
FIND:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
        // *************************************************

        $printhr = false;
        if (can_administer('canadminsettings'))
        {
                $printhr = true;
                construct_nav_option($vbphrase['vbulletin_options'], 'options.php?null=0', '<br />');
                if ($debug == 1)
                {
                        construct_nav_option($vbphrase['admin_help_manager'], 'help.php?do=manage&script=NOSCRIPT');
                }
                construct_nav_group($vbphrase['vbulletin_options'], '<hr />');
        }
        if ($printhr == true)
        {
                construct_nav_spacer();
        }

        // *************************************************
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
UNDERNEATH ADD:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
        $printhr = true ;
        construct_nav_option ( 'vBChat Options', 'admin_vbchat.php', '<br />' ) ;
        construct_nav_option ( 'vBChat Room Control', 'admin_vbchat.php?do=room', '<br />' ) ;
        construct_nav_option ( 'vBChat Prune Options', 'admin_vbchat.php?do=prune', '<br />' ) ;
        construct_nav_group ( 'vBChat Control', '<hr />' ) ;  (would be this one here)
        $printhr = false;

Delw

Delw 11-10-2004 04:57 AM
BTW nice job on the chat board,
it took about 20 mins to install and that included finding out about the problem above.

Other than that I found no problems with it.

I do notice the page refreshs alot(every 1-2 seconds) is there a way to slow it down? I am just curius about bandwidth and if the refresh rate will add to it.

Delw

SVTOA 11-10-2004 10:07 AM
Has anyone who did the most recent upgrade been able to get your "who is currently in chat" to work on your forumhome?


All times are GMT. The time now is 08:06 AM.
Page 5 of 36 « First 34 5 6715 Last »
Show 40 post(s) from this thread on one page

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.03250 seconds
  • Memory Usage 1,872KB
  • 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
  • (12)bbcode_code_printable
  • (12)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