赵岩的博客

#!/bin/sh
 
CURRENT_DIR=$(dirname "$0")
MYSQL_USERNAME="xxxxxx"
MYSQL_PASSWORD="xxxxxxxx"
MYSQL_DATABASE="xxxxxxx"
MYSQL_CMD="/usr/bin/mysql"
 
#百度链接提交地址，在百度站长里可以找到
BAIDU_COMMIT_URL="http://data.zz.baidu.com/urls?site=zhaoyanblog.com&token=xxxxxxx"
 
#找出今天所有发布的文章，post类型代码文章，publish状态表示发布状态的，排除草稿。
today=`date "+%Y-%m-%d 00:00:00"`
ids=`$MYSQL_CMD -N  -u $MYSQL_USERNAME -p$MYSQL_PASSWORD $MYSQL_DATABASE -e "select ID from wp_posts where post_type='post' and post_status='publish' and post_date>'${today}';"`
 
if [ ! -n "$ids" ]; then
  exit;
fi
 
#把文章地址输出到一个临时文件里
cd $CURRENT_DIR
rm -rf urls.txt
 
for id in $ids; do
 
echo "http://zhaoyanblog.com/archives/$id.html" >> urls.txt;
 
done
 
#提交给百度
curl -H 'Content-Type:text/plain' --data-binary @urls.txt "$BAIDU_COMMIT_URL"