|
#!/bin/bashhost_ip=$1zabbix_server_ip="10.1.1.1"mysql -C -N -h localhost -u geekwolf -pgeekwolf "--execute=select total,dota,war3vs,war3rpg,first_login from online_table;">/tmp/.data
Total=`cat /tmp/.data |awk '{print $1}'`
Dota=`cat /tmp/.data |awk '{print $2}'`
War3vs=`cat /tmp/.data |awk '{print $3}'`
War3rpg=`cat /tmp/.data |awk '{print $4}'`
First_Login=`cat /tmp/.data |awk '{print $5}'`
echo "$host_ip online_count[Total] $Total" >/tmp/count.logecho "$host_ip online_count[Dota] $Dota" >>/tmp/count.logecho "$host_ip online_count[War3vs] $War3vs" >>/tmp/count.logecho "$host_ip online_count[War3rpg] $War3rpg" >>/tmp/count.logecho "$host_ip online_count[First_login] $First_Login" >>/tmp/count.log
zabbix_sender -z $zabbix_server_ip -i /tmp/count.log &>/dev/null
|
|
|