Flashchat - who is online with showing the chatters avatars

this is a beta release of a "who is online" mod for Flashchat

Version 0.2

What's new:

• now working with prefixes for the database tables
• now working with gif-avatars too
• resize option (yes / no)
• better image quality because of gdlib2

Features:

• generate dynamically resized avatar-pics for the chatting users
  and displays them on the forumhome with the username and a link to their profile

issues/bugs/ todo:

• if too many users are chatting, the tablerow grows and grows instead of breaking into a new tablerow (fixing it later)
• doesn't show avatars when they aren't stored in the db(thekeeper)

note: you need the gdlib2

installation and upgrade information inside the .zip

[karlogaga]

@qasan

ich habs installiert und bekomme das:

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

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

[karlogaga]

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]

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]

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]

@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

$query_chatonline ="SELECT COUNT(*) FROM connections WHERE userid IS NOT NULL";

to

$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]

thanks, i just found it myself, and i put the prefix before "connections".

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

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]

..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]

"SELECT COUNT(*) FROM flashchatprefix_connections WHERE userid IS NOT NULL";

prefix_connections of your flashchat dbprefix

here again:

"SELECT userid FROM flashchatprefix_connections WHERE userid IS NOT NULL";

if you have also a prefix for your vbulletin board:

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

from VBPREFIX_user ...

[quasan]

..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]

Ok I looked at my code, and this appears to work fine now for both flat files and database:

// ### 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;