Gweled is a gem swapping game, originally written by Sebastien Delestaing. The aim of the game is to make an alignment of 3 or more gems, either vertically or horizontally, by swapping adjacent gems. The game ends when there are no possible moves left.
While the project is hosted here, the code is hosted over at Github.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001970s ]
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.094887s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002389s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002153s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002050s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003781s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002241s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004066s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014839s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002326s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 293529 [ RunTime:0.001213s ]