https://www.icyphoenix.com/viewtopic.php?f=35&t=2071&p=16611#p16611 ----------------------------------- Labiri Tue 19 Jun, 2007 13:46 Re: Chatters In ViewOnline Block ----------------------------------- Sorry, I have this php code to see who is in chat (using Flash Chat) How can I insert it into Icy? [code linenumbers=false]query("SELECT * FROM ".$flashchatprefix."rooms WHERE ispublic IS NOT NULL"); $files = $DB->get_num_rows($result); // How many chatters are currently yacking in the rooms $result = $DB->query("SELECT userid, state, color, lang, roomid FROM ".$flashchatprefix."connections WHERE userid IS NOT NULL"); $cats = $DB->get_num_rows($result); $content .="
"; $content .= "  $chatrooms: $files
  $amtchatters: $cats
"; $content .="
"; // Lets print out a list of the rooms for all to see $content .= "
".$curchat."
"; $a = 1; $result = $DB->query("SELECT id, name FROM ".$flashchatprefix."rooms WHERE ispublic IS NOT NULL"); while(list( $id, $name) = mysql_fetch_row($result)) { $title2 = ereg_replace("_", " ", $name); $content .= "  $a- $title2
"; $a++; } unset($result); unset($cats); unset($files); // yeaaaaa its the php end thingy it means i have finished ?>[/code] ...and I didn't understand how to write the .tpl...... :shock: Edit: sorry for writing in italian, I traslated. I visit both forums and I have italian language on both, so I got confused :)