This is a small perl script that allows you to display Caller ID information on Squeezeboxes (and other devices from Slimdevices.com) It also includes...
LDAP lookup of the phone number
RSS feed of the CID log
Bonjour discovery of Growl clients
Growl Notifications
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001110s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.070878s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001017s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001128s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000941s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003057s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000804s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003700s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.025162s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001761s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 267105 [ RunTime:0.016773s ]