文件自动分类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自动执行
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<?php
set_time_limit(0);
//载入配置文件
require_once 'db.php';
echo '<br>正在整理分类文件';
echo "<br>".mysql_query("update file set type='1' where category='-1'"); // 其它云文件
echo "<br>".mysql_query("update file set type='3' where category='1'"); // 视频
echo "<br>".mysql_query("update file set type='5' where type='2'"); // 音频
echo "<br>".mysql_query("update file set type='7' where category='3'"); // 图片
echo "<br>".mysql_query("update file set type='9' where category='4'"); // 文档
echo "<br>".mysql_query("update file set type='11' where category='5'"); // 软件
echo "<br>".mysql_query("update file set type='1' where category='6'"); // 云
echo "<br>".mysql_query("update file set type='16' where category='7'"); // 种子
echo "<br>".mysql_query("update file set type='3' where filename like '%.mp4'"); // 视频
echo "<br>".mysql_query("update file set type='3' where filename like '%.avi'"); // 视频
echo "<br>".mysql_query("update file set type='3' where filename like '%.rmvb'"); // 视频
echo "<br>".mysql_query("update file set type='3' where filename like '%.flv'"); // 视频
echo "<br>".mysql_query("update file set type='3' where filename like '%.mkv'"); // 视频
echo "<br>".mysql_query("update file set type='3' where filename like '%.flv'"); // 视频
echo "<br>".mysql_query("update file set type='5' where filename like '%.mp3'"); // 音频
echo "<br>".mysql_query("update file set type='7' where filename like '%.jpg'"); // 图片
echo "<br>".mysql_query("update file set type='9' where filename like '%.txt'"); // 文档
echo "<br>".mysql_query("update file set type='9' where filename like '%.pdf'"); // 文档
echo "<br>".mysql_query("update file set type='9' where filename like '%.mobi'"); // 文档
echo "<br>".mysql_query("update file set type='9' where filename like '%.doc'"); // 文档
echo "<br>".mysql_query("update file set type='9' where filename like '%.docx'"); // 文档
echo "<br>".mysql_query("update file set type='9' where filename like '%.wps'"); // 文档
echo "<br>".mysql_query("update file set type='9' where filename like '%.ppt'"); // 文档
echo "<br>".mysql_query("update file set type='9' where filename like '%.xls'"); // 文档
echo "<br>".mysql_query("update file set type='9' where filename like '%.xlsx'"); // 文档
echo "<br>".mysql_query("update file set type='9' where filename like '%.epub'"); // 文档
echo "<br>".mysql_query("update file set type='9' where filename like '%.rtf'"); // 文档
echo "<br>".mysql_query("update file set type='11' where filename like '%.exe'"); // 软件
echo "<br>".mysql_query("update file set type='16' where filename like '%.torrent'"); // 种子
echo "<br>".mysql_query("update file set type='13' where filename like '%.dmg'"); // 压缩包
echo "<br>".mysql_query("update file set type='13' where filename like '%.GHO'"); // 压缩包
echo "<br>".mysql_query("update file set type='13' where filename like '%.iso'"); // 压缩包
echo "<br>".mysql_query("update file set type='13' where filename like '%.zip'"); // 压缩包
echo "<br>".mysql_query("update file set type='13' where filename like '%.rar'"); // 压缩包
echo "<br>".mysql_query("update file set type='13' where filename like '%.7z'"); // 压缩包
echo "<br>".mysql_query("update file set type='14' where size='1024'"); // 文件夹
echo "<br>".mysql_query("update file set type='0' where size='专辑'"); // 专辑
echo "<br>".mysql_query("update file set type='12' where category is null"); // 手动添加的
echo "<br>".mysql_query("update file set type='4' where size like '%个'"); // 多个文件
echo '<br>整理完成。当前时间:'.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; -- 分类统计
*/
?>
</body>
</html>