Half-Court Shot jsApp
This jsApp will fetch your Dribbble shots from across the court (aka Internets) and display them in a fancy little widgeto. It was a collab effort between mediaHACK and KomodoMedia .
If you have any questions, suggestions or issues let me know on twitter.
Usage
If you want to just use this and instantly go, copy the code directly below and replace the jersey name "Rogie" with your own.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000965s ]
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.094589s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001424s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001933s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001412s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005330s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001392s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006482s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016168s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001202s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 227159 [ RunTime:0.032568s ]