This program is to transfer files to your friend directly. Both behind NAT is ok.
Use STUN to do UDP hole punching.
And then use ice4j PseudoTcpSocket on top of UDP.
And then use SSL on top of PseudoTcpSocket.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001823s ]
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.100575s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001532s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001878s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001157s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003685s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001069s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003276s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014662s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001206s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 296211 [ RunTime:0.008371s ]