A collection of libraries and applications in .NET for FourSquare.
Currently in alpha, at version 0.1
All of the methods and objects from the FourSquareAPI are currently implemented.
Error checking has yet to be implemented.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.011019s ]
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.138343s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001052s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001238s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001016s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003512s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001017s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003841s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016078s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001138s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 284381 [ RunTime:0.015257s ]
