#! /bin/bash

CODE_FILELIST_FILE="filelist.txt"
find   -name "*.*htm*" | xargs grep -l -e 'dtl.php?mvid=[0-9]\{1,6\}' > ${CODE_FILELIST_FILE}
while read line_str; do
    if [ -f ${line_str} ]; then
        echo "File:" ${line_str}
 grep -h -o -e 'dtl.php?mvid=[0-9]\{1,6\}' ${line_str}  | awk -F'=' '{print $2}' | sort | uniq > 1.txt
 cat 1.txt | awk  '{printf "select  count(movieid) , max(isaudited), %s,max(movieName)   from mvdetail where movieid = %s ; \n",$1,$1} ' >2.txt
 /home/work/mysql/bin/mysql -uroot -p111111 movie  -N -s <2.txt | awk '{if($1==0 || $2==0) printf "%s\t%s\n ",$3,$4}'
 echo " "
 rm -f 1.txt
 rm -f 2.txt
 rm -f 3.txt
 
    else
        echo "Error!"
    fi
done < ${CODE_FILELIST_FILE}

rm -f  ${CODE_FILELIST_FILE}

发表于 @ 2009年03月19日　11:20:00 | 评论( loading... ) | 编辑| 举报| 收藏

旧一篇:将数据从MSSQL Server导到mysql的一种方法 | 新一篇:Apache乱码问题