https://www.icyphoenix.com/viewtopic.php?f=35&t=1762 ----------------------------------- darkone Fri 27 Apr, 2007 15:18 FlashChat - Ok Got All It Working Need Some Code Help Pls ----------------------------------- Hey Everyone Got FlashChat working great in ICY portal now I wanted to do a bit more but I am unsure how to do it and maybe the ICY programming gods can help me :) As you notice with this screenshot: [img]http://www.icyphoenix.com/files/images/1134/flashchat_fix_1_1177680484_809331.jpg[/img] First question: How do I make the users in this list have the same color or color designation that they would have if shown in the forum who is online. For instance i'm the admin and I show up in red. Not sure if I would have to add code to the block/index_body.php or the info_embedded.php in FC. Here is the info_embedded.php file: [code linenumbers=false] ? AND roomid=?"); $rs = $stmt->process(SPY_USERID, $room); } else { $stmt = new Statement("SELECT COUNT(*) AS numb FROM {$GLOBALS['fc_config']['db']['pref']}connections,{$GLOBALS['fc_config']['db']['pref']}rooms WHERE userid IS NOT NULL AND userid <> ? AND ispublic IS NOT NULL AND {$GLOBALS['fc_config']['db']['pref']}connections.roomid = {$GLOBALS['fc_config']['db']['pref']}rooms.id"); $rs = $stmt->process(SPY_USERID); } $rec = $rs->next(); return $rec?$rec['numb']:0; } /** Retrieves a list of the users (by login ID) who are in $room. Leave the $room parameter empty to return a list of all users in all rooms. */ function usersinroom( $room = "" ) { $list = array(); if($room) { $stmt = new Statement("SELECT userid, state, color, lang, roomid FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL AND userid <> ? AND roomid=?"); $rs = $stmt->process(SPY_USERID, $room); } else { $stmt = new Statement("SELECT userid, state, color, lang, roomid FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL AND userid <> ?"); $rs = $stmt->process(SPY_USERID); } while($rec = $rs->next()) { $usr = ChatServer::getUser($rec['userid']); if($usr == null && $GLOBALS['fc_config']['enableBots']) $usr = $GLOBALS['fc_config']['bot']->getUser($rec['userid']); $list[] = array_merge($usr, $rec); } return $list; } /** Retrieves a list of all available rooms, as an array. */ function roomlist() { $list = array(); // populate $list with the names of all available rooms $stmt = new Statement("SELECT * FROM {$GLOBALS['fc_config']['db']['pref']}rooms WHERE ispublic IS NOT NULL order by ispermanent"); $rs = $stmt->process(); while($rec = $rs->next()) $list[] = $rec; //result will be an array of arrays like ('id' => , 'updated' = , 'created' => , 'name' => , 'ispublic' => , 'ispermanent' => ) return $list; } $rooms = roomlist(); $roomnumb = sizeof($rooms); $usernumb = numusers(); ?> Who's in the chat?

user in all room.

  • () "; foreach( $users as $user ) { echo "
  • ".$user['login'] . "
    • "; } echo "
"; } ?> [/code] Second question: In my main bar near the top of the screen in ICY you have the 'HOME, FORUM, PROFILE, REGISTER' menu selections on the screen. I have inserted a 'Live Chat' option in the 'Overall_Header_sq.tpl' file and want to next to the 'Live Chat' I want it too look like this 'Live Chat (0)' with (0) be linked to the amount of users in chat in total. From looking at the info_embedded.php code I see this piece right here which gets the value and puts it into a variable. How do I use this and insert it into my code in the overall_header_sq.tpl? [code linenumbers=false] function numusers( $room = "" ) { if($room) { $stmt = new Statement("SELECT COUNT(*) AS numb FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL AND userid <> ? AND roomid=?"); $rs = $stmt->process(SPY_USERID, $room); } else { $stmt = new Statement("SELECT COUNT(*) AS numb FROM {$GLOBALS['fc_config']['db']['pref']}connections,{$GLOBALS['fc_config']['db']['pref']}rooms WHERE userid IS NOT NULL AND userid <> ? AND ispublic IS NOT NULL AND {$GLOBALS['fc_config']['db']['pref']}connections.roomid = {$GLOBALS['fc_config']['db']['pref']}rooms.id"); $rs = $stmt->process(SPY_USERID); } $rec = $rs->next(); return $rec?$rec['numb']:0; } [/code] If anyone can help me that would be great I think this would pretty much finish off all the questions people would have about integrating FlashChat into ICY and it would look and act perfectly. So can any programmers help me out with this one. I can provide more info on files etc.. if you need it. Thanks -D1- ----------------------------------- Mighty Gorgon Tue 01 May, 2007 19:11 Re: FlashChat - Ok Got All It Working Need Some Code Help Pl ----------------------------------- Good you got it working. For what you need, I currently don't have the time, but me or someone else I think will try to help you when the final release is out... and now we are really near the release. :wink: