百度网盘文件自动分类sql 并带有对应标识图标

效果：http://wjsou.com/

文件自动分类sql

update file set type='1' where category='-1'; -- 其它云文件
update file set type='3' where category='1'; -- 视频
update file set type='5'  where type='2'; -- 音频
update file set type='7' where category='3'; -- 图片
update file set type='9' where category='4'; -- 文档
update file set type='11' where category='5'; -- 软件
update file set type='1' where category='6'; -- 云
update file set type='16' where category='7'; -- 种子


update file set type='3' where filename like '%.mp4'; -- 视频
update file set type='3' where filename like '%.avi'; -- 视频
update file set type='3' where filename like '%.rmvb'; -- 视频
update file set type='3' where filename like '%.flv'; -- 视频
update file set type='3' where filename like '%.mkv'; -- 视频
update file set type='3' where filename like '%.flv'; -- 视频
update file set type='5' where filename like '%.mp3'; -- 音频
update file set type='7' where filename like '%.jpg'; -- 图片
update file set type='9' where filename like '%.txt'; -- 文档
update file set type='9' where filename like '%.pdf'; -- 文档
update file set type='9' where filename like '%.mobi'; -- 文档
update file set type='9' where filename like '%.doc'; -- 文档
update file set type='9' where filename like '%.docx'; -- 文档
update file set type='9' where filename like '%.wps'; -- 文档
update file set type='9' where filename like '%.ppt'; -- 文档
update file set type='9' where filename like '%.xls'; -- 文档
update file set type='9' where filename like '%.xlsx'; -- 文档
update file set type='9' where filename like '%.epub'; -- 文档
update file set type='9' where filename like '%.rtf'; -- 文档
update file set type='11' where filename like '%.exe'; -- 软件
update file set type='16' where filename like '%.torrent'; -- 种子


update file set type='13' where filename like '%.dmg'; -- 压缩包
update file set type='13' where filename like '%.GHO'; -- 压缩包
update file set type='13' where filename like '%.iso'; -- 压缩包
update file set type='13' where filename like '%.zip'; -- 压缩包
update file set type='13' where filename like '%.rar'; -- 压缩包
update file set type='13' where filename like '%.7z'; -- 压缩包
update file set type='14' where size='1024'; -- 文件夹
update file set type='0' where size='专辑'; -- 专辑
update file set type='12' where category is null; -- 手动添加的
update file set type='4' where size like '%个'; -- 多个文件






select category,count(*) from file group by category; -- 分类统计
select * from file where category is null limit 1000;
select * from file where type='6' limit 1000;
select type,count(*) from file group by type; -- 分类统计


select * from file where Id>7527035 and type='6' limit 1000;
select type,count(*) from file where Id>7527035 group by type;  -- 分类统计

php自动执行

正在整理分类文件';	
echo "
".mysql_query("update file set type='1' where category='-1'"); // 其它云文件
echo "
".mysql_query("update file set type='3' where category='1'"); // 视频
echo "
".mysql_query("update file set type='5'  where type='2'"); // 音频
echo "
".mysql_query("update file set type='7' where category='3'"); // 图片
echo "
".mysql_query("update file set type='9' where category='4'"); // 文档
echo "
".mysql_query("update file set type='11' where category='5'"); // 软件
echo "
".mysql_query("update file set type='1' where category='6'"); // 云
echo "
".mysql_query("update file set type='16' where category='7'"); // 种子
echo "
".mysql_query("update file set type='3' where filename like '%.mp4'"); // 视频
echo "
".mysql_query("update file set type='3' where filename like '%.avi'"); // 视频
echo "
".mysql_query("update file set type='3' where filename like '%.rmvb'"); // 视频
echo "
".mysql_query("update file set type='3' where filename like '%.flv'"); // 视频
echo "
".mysql_query("update file set type='3' where filename like '%.mkv'"); // 视频
echo "
".mysql_query("update file set type='3' where filename like '%.flv'"); // 视频
echo "
".mysql_query("update file set type='5' where filename like '%.mp3'"); // 音频
echo "
".mysql_query("update file set type='7' where filename like '%.jpg'"); // 图片
echo "
".mysql_query("update file set type='9' where filename like '%.txt'"); // 文档
echo "
".mysql_query("update file set type='9' where filename like '%.pdf'"); // 文档
echo "
".mysql_query("update file set type='9' where filename like '%.mobi'"); // 文档
echo "
".mysql_query("update file set type='9' where filename like '%.doc'"); // 文档
echo "
".mysql_query("update file set type='9' where filename like '%.docx'"); // 文档
echo "
".mysql_query("update file set type='9' where filename like '%.wps'"); // 文档
echo "
".mysql_query("update file set type='9' where filename like '%.ppt'"); // 文档
echo "
".mysql_query("update file set type='9' where filename like '%.xls'"); // 文档
echo "
".mysql_query("update file set type='9' where filename like '%.xlsx'"); // 文档
echo "
".mysql_query("update file set type='9' where filename like '%.epub'"); // 文档
echo "
".mysql_query("update file set type='9' where filename like '%.rtf'"); // 文档
echo "
".mysql_query("update file set type='11' where filename like '%.exe'"); // 软件
echo "
".mysql_query("update file set type='16' where filename like '%.torrent'"); // 种子
echo "
".mysql_query("update file set type='13' where filename like '%.dmg'"); // 压缩包
echo "
".mysql_query("update file set type='13' where filename like '%.GHO'"); // 压缩包
echo "
".mysql_query("update file set type='13' where filename like '%.iso'"); // 压缩包
echo "
".mysql_query("update file set type='13' where filename like '%.zip'"); // 压缩包
echo "
".mysql_query("update file set type='13' where filename like '%.rar'"); // 压缩包
echo "
".mysql_query("update file set type='13' where filename like '%.7z'"); // 压缩包
echo "
".mysql_query("update file set type='14' where size='1024'"); // 文件夹
echo "
".mysql_query("update file set type='0' where size='专辑'"); // 专辑
echo "
".mysql_query("update file set type='12' where category is null"); // 手动添加的
echo "
".mysql_query("update file set type='4' where size like '%个'"); // 多个文件echo  '
整理完成。当前时间：'.date('Y-m-d H:i:s');/* 注释内容
0 .x6     专辑
1 .icon   云
2 .icon01 Excel
3 .icon10 视频
4 .icon12 多个文件
5 .icon20 音频
6 .icon22 x
7 .icon30 图片
8 .icon32 x
9 .icon40 文档
10.icon42 x
11.icon50 软件
12.icon52 其它
13.icon60 压缩包
14.icon61 文件夹
15.icon62 x
16.icon70 种子
17.icon72 x$typeArray=array("x6","icon","icon01","icon10","icon12","icon20","icon22","icon30","icon32","icon40","icon42","icon50","icon52","icon60","icon61","icon62","icon70","icon72");  //-1 全部 1视频 2音乐 3图片 4程序 5其它 6种子update file set type='1' where category='-1'; -- 其它云文件
update file set type='3' where category='1'; -- 视频
update file set type='5'  where type='2'; -- 音频
update file set type='7' where category='3'; -- 图片
update file set type='9' where category='4'; -- 文档
update file set type='11' where category='5'; -- 软件
update file set type='1' where category='6'; -- 云
update file set type='16' where category='7'; -- 种子update file set type='3' where filename like '%.mp4'; -- 视频
update file set type='3' where filename like '%.avi'; -- 视频
update file set type='3' where filename like '%.rmvb'; -- 视频
update file set type='3' where filename like '%.flv'; -- 视频
update file set type='3' where filename like '%.mkv'; -- 视频
update file set type='3' where filename like '%.flv'; -- 视频
update file set type='5' where filename like '%.mp3'; -- 音频
update file set type='7' where filename like '%.jpg'; -- 图片
update file set type='9' where filename like '%.txt'; -- 文档
update file set type='9' where filename like '%.pdf'; -- 文档
update file set type='9' where filename like '%.mobi'; -- 文档
update file set type='9' where filename like '%.doc'; -- 文档
update file set type='9' where filename like '%.docx'; -- 文档
update file set type='9' where filename like '%.wps'; -- 文档
update file set type='9' where filename like '%.ppt'; -- 文档
update file set type='9' where filename like '%.xls'; -- 文档
update file set type='9' where filename like '%.xlsx'; -- 文档
update file set type='9' where filename like '%.epub'; -- 文档
update file set type='9' where filename like '%.rtf'; -- 文档
update file set type='11' where filename like '%.exe'; -- 软件
update file set type='16' where filename like '%.torrent'; -- 种子update file set type='13' where filename like '%.dmg'; -- 压缩包
update file set type='13' where filename like '%.GHO'; -- 压缩包
update file set type='13' where filename like '%.iso'; -- 压缩包
update file set type='13' where filename like '%.zip'; -- 压缩包
update file set type='13' where filename like '%.rar'; -- 压缩包
update file set type='13' where filename like '%.7z'; -- 压缩包
update file set type='14' where size='1024'; -- 文件夹
update file set type='0' where size='专辑'; -- 专辑
update file set type='12' where category is null; -- 手动添加的
update file set type='4' where size like '%个'; -- 多个文件select category,count(*) from file group by category; -- 分类统计
select * from file where category is null limit 1000;
select * from file where type='6' limit 1000;
select type,count(*) from file group by type; -- 分类统计select * from file where Id>7527035 and type='6' limit 1000;
select type,count(*) from file where Id>7527035 group by type;  -- 分类统计
*/
?>				

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！