#!/bin/sh
#Function:scan server web ct
#Writer:liutiansi
#Mail:liutiansi@gmail.com
#Date:2007-11-09 23:57
mysql_bin="/usr/local/mysql/bin/mysql"
mysql_host="localhost"
mysql_user="systemuserscanct"
mysql_passwd="123456"
scan_web=""
checkpy="/home/liuts/tyAdmin/bin/check_ty_web.py"
server=`$mysql_bin -h $mysql_host -u$mysql_user -p$mysql_passwd -e "select SERVER,CONDITIONTYPE from sysadmin.ty_server_scanport where SERVERTYPE='ct' and CONDITIONTYPE!=''" | awk 'NR>1 {print NR,$0}'|awk '{print $2","$3}'`
for vlist in $server
do
        getdatetime=`date '+%Y-%m-%d %H:%M:%S'`
        getserver=`echo "$vlist"|awk -F ',' '{print $1}'`
        getwebtype=`echo "$vlist"|awk -F ',' '{print $2}'`
 echo $vlist
        result=`$checkpy $getserver $getwebtype 2>&1`
	
	echo $result
        result_up=`$mysql_bin -h $mysql_host -u$mysql_user -p$mysql_passwd -e "update sysadmin.ty_server_scanport set WEBCONDITION='$result',UPDATETIME='$getdatetime' where SERVER='$getserver';" 2>&1`
done;
