This pySportsLive python scripts will help the users to see the On Screen Display of the current match scores.
This script uses the PyOSD for the On Screen Display and xml.sax for xml parsing.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001664s ]
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.146975s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001710s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.003120s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001780s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.006014s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001482s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005762s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.025092s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002041s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 39159 [ RunTime:0.001542s ]