It consists of a database that allows you to admin your film collection, storing about them many data, like its director, actors, productor, year ... and even an image about it, like, for example, the poster or dvd cover.
文 件 列 表
phpfilm init.php view_film.php view_director.php codes.txt admin INSTALL Changelog TODO lang index.php fixperm.sh index_detailed.php config.php style.css view_actor.php ABOUT img language.php COPYING tables.sql common.php
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001303s ]
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.102584s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001312s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001917s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001330s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003861s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001273s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003448s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016371s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001530s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 232279 [ RunTime:0.004139s ]
