The last hour's chatterbox is graphed to clump around who was talking to whom. Sort of. This doesn't take into account message content so if you say someone's name, that doesn't hint that you are talking to them. You get points by speaking recently and within proximity to when someone else spoke.
Fullpage Chat with the graph
View the source
Incidentally, I'm bringing these links up in PMD because while the code is visible I'm not presenting complete packages so people can run this stuff on their own. In that sense its more just an introduction to another view to perlmonks.
Appended: I added the PL/R code so people could see that too. The full source code for everything is at http://grenekatz.org/downloads/chatterbox//sql/perlmonks.sql.
CREATE FUNCTION r_median(double precision) RETURNS double precision
CREATE AGGREGATE median (
BASETYPE = double precision,
SFUNC = plr_array_accum,
STYPE = double precision,
FINALFUNC = r_median
CREATE FUNCTION invisible_speakers() RETURNS SETOF text
FROM (SELECT userid
FROM chatter AS c,
( SELECT MAX( inserted ) AS s FROM other_users ) as s,
( SELECT MAX( inserted ) AS f FROM current_other_users ) AS
WHERE c.inserted BETWEEN s.s AND f.f
SELECT userid FROM current_other_users) AS i
JOIN users USING (userid);
LANGUAGE sql STABLE;
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||