The aim of HaptiNav project is to provide haptic feedback in order to assist a mobile user in pedestrian navigation. This projects consists of an Android application, an Arduino sketch and an Amarino plugin. In this project we use an android mobile device (Galaxy S2), an Arduino BT Board and four vibrators fixed upon a belt.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.009327s ]
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.109090s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.004001s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002091s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002927s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003817s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001797s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003275s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.020077s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002894s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 100008 [ RunTime:0.001597s ]