vb.org Archive
Page 3 of 8 12 3 45 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)
-   -   Flashchat - who is online with showing the chatters avatars (https://vborg.vbsupport.ru/showthread.php?t=71288)

The Keeper 11-05-2004 02:07 PM
Works now, but the avatar function isn't quite right. People with avatars are showing up as the noavatar thing

karlogaga 11-05-2004 02:09 PM
mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ...../forum/index.php on line 514

(das ist die line 514 in meinem index.php)

$count = mysql_fetch_array(mysql_query($query_chatonline));

The Keeper 11-05-2004 02:11 PM
Just realised it only works if the avatars are in teh database, whereas I use a file based system. Hang on and I'll think of a way round that.

karlogaga 11-05-2004 02:12 PM
Oh, sorry for talking german!

I installed it and get the following error message:

mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ...../forum/index.php on line 514

where line 514 is this one:

$count = mysql_fetch_array(mysql_query($query_chatonline));

quasan 11-05-2004 02:18 PM
@karlogaga: is the flashchat dbtable in the same database as the forum? your error sounds to me, that the query cannot find the "connections" table of your flashchat table. or do you use a prefix on the flashchat table?

I forgot to implement this in the php because i do not use a prefix.

If you use one. please change the
Quote:
$query_chatonline ="SELECT COUNT(*) FROM connections WHERE userid IS NOT NULL";
to
Quote:
$query_chatonline ="SELECT COUNT(*) FROM PREFIX_connections WHERE userid IS NOT NULL";
and insert the prefix of your flashchat db table in there...

I will put it in the next version

karlogaga 11-05-2004 02:25 PM
thanks, i just found it myself, and i put the prefix before "connections".

I also did it for "users", is that correct?



Quote:
Originally Posted by quasan
@karlogaga: is the flashchat dbtable in the same database as the forum? your error sounds to me, that the query cannot find the "connections" table of your flashchat table. or do you use a prefix on the flashchat table?

I forgot to implement this in the php because i do not use a prefix.

If you use one. please change the


to


and insert the prefix of your flashchat db table in there...

I will put it in the next version

karlogaga 11-05-2004 02:29 PM
..like this:

//Get the username for each chatter
$show_username= $DB_site->query("select username from vb3_user where userid=".intval($val));

where vb3_ is the prefix...

quasan 11-05-2004 02:30 PM
Quote:
"SELECT COUNT(*) FROM flashchatprefix_connections WHERE userid IS NOT NULL";
prefix_connections of your flashchat dbprefix

here again:
Quote:
"SELECT userid FROM flashchatprefix_connections WHERE userid IS NOT NULL";

if you have also a prefix for your vbulletin board:

Quote:
$DB_site->query("select username from user where userid=".intval($val));
from VBPREFIX_user ...

quasan 11-05-2004 02:31 PM
Quote:
..like this:

//Get the username for each chatter
$show_username= $DB_site->query("select username from vb3_user where userid=".intval($val));


where vb3_ is the prefix...
yep exactly :)

@keeper: thx I will have a look at it later. now i have to go shopping:/

The Keeper 11-05-2004 03:06 PM
Ok I looked at my code, and this appears to work fine now for both flat files and database:

Code:
// ### HACK FOR WHO'S CHATTING

$query_chatonline ="SELECT COUNT(*) FROM connections WHERE userid IS NOT NULL";
$count = mysql_fetch_array(mysql_query($query_chatonline));
$count_chatter = $count[0];





// ###################### Start getavatarurl #######################
function fetch_avatar_url($userid)
{
        global $DB_site, $session, $vboptions;

        if ($avatarinfo = $DB_site->query_first("
                SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline
                FROM " . TABLE_PREFIX . "user AS user
                LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON avatar.avatarid = user.avatarid
                LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON customavatar.userid = user.userid
                WHERE user.userid = $userid"))
        {
                if (!empty($avatarinfo['avatarpath']))
                {
                        return $avatarinfo['avatarpath'];
                }
                else if ($avatarinfo['hascustom'])
                {
                        if ($vboptions['usefileavatar'])
                        {
                                return "$vboptions[avatarurl]/avatar{$userid}_{$avatarinfo[avatarrevision]}.gif";
                        }
                        else
                        {
                                return "image.php?u=$userid&dateline=$avatarinfo[dateline]";
                        }
                }
                else
                {
                        return '';
                }
        }
}



//if anyone is chatting.....
if($count_chatter >0)
{
 
        //get the uids of the chatters
        $query_userid = "SELECT userid FROM connections WHERE userid IS NOT NULL";
        $show_userid = mysql_query($query_userid);
        $row_show_userid = mysql_fetch_assoc($show_userid);
       
        //build an array of the userids
        do {       
        $userids[] = $row_show_userid['userid'];       
        } while ($row_show_userid = mysql_fetch_assoc($show_userid));
       

// Get the usernames and build the outputVar for the template
foreach($userids as $val)
{

        //Get the username for each chatter
        $show_username= $DB_site->query("select username from user where userid=".intval($val));
        $row_show_username = mysql_fetch_assoc($show_username);


        //pass the userid to the avatar_resize.php
        $chatavatar = fetch_avatar_url($val);


        // store the htmloutput for each user in $temp
        $temp = "<td><tr>";
        $temp.= "<img src=\"$chatavatar\">";
        $temp.= "<div align=\"center\">";
        $temp.= "<a href=\"member.php?u=".$val."\">".$row_show_username['username']."</a>";
        $temp.= "</div>";
        $temp.= "</tr><td>";
       

        // concatenate the temp stuff to > $chatusers
        $chatusers = $chatusers.$temp;
       
}; // End foreach



}; // End $count_chatter >0


// surround the $chatusers with some table tags and assign it to a template var
$chatter['usernames'] = "<table><tr>".$chatusers."</tr></table>";

// assign the number of people to a templatevar, so that we can have some conditions on the forumhome-template
$chatter['count'] = $count_chatter;


All times are GMT. The time now is 09:26 AM.
Page 3 of 8 12 3 45 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.01266 seconds
  • Memory Usage 1,758KB
  • 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
  • (1)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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