#!bin/bash

echo "start"

serverPath=/server
task_log_path=${serverPath}/timed_task.log

#zone_id=$(awk '{print $1}' ${serverPath}/config.txt)
zone_id=$(awk 'NR==1{split($0,a,"=");print a[2]}' ${serverPath}/config.txt)
echo $zone_id

cur_time=$(date "+%Y-%m-%d %H:%M:%S")
echo "当前执行开服：${zone_id}区开始时间为:${cur_time}" >> $task_log_path

#1:execute install
sh ${serverPath}/srv_install.sh $zone_id
cur_time=$(date "+%Y-%m-%d %H:%M:%S")
echo "${cur_time}=>srv_install.sh ${zone_id}" >> $task_log_path

#4:update 
db_user="root"
db_password="wch123.com"
db_name="sdk"
table_name="game_server"

declare -A zone_id_name
zone_id_name[2]=花开满城
zone_id_name[3]=春暖花开
zone_id_name[4]=云卷云舒
zone_id_name[5]=静夜思归
zone_id_name[6]=海阔天空
zone_id_name[7]=星河灿烂
zone_id_name[8]=鸟语花香
zone_id_name[9]=山明水秀
zone_id_name[10]=岁月静好
zone_id_name[11]=月明如水

mongodb_name=$((350001 + zone_id))
port=$((8191 + zone_id))

update_sql="insert into game_server(id,name,status,ip,port,tag,tips,white_list,open_time) values(${zone_id},'${zone_id_name[$zone_id]}', 1,'43.248.185.27',${port},'default','','',0);"
mysql -u $db_user -p$db_password $db_name -e "$update_sql"

cur_time=$(date "+%Y-%m-%d %H:%M:%S")
echo "${cur_time}=>update sql:${update_sql}" >> $task_log_path

#5:add 1
((zone_id++))
cur_time=$(date "+%Y-%m-%d %H:%M:%S")
echo "${cur_time}=>zone_id++ ${zone_id}" >> $task_log_path

#6:save id
sed -i "1c\zone_start_id=${zone_id}" ${serverPath}/config.txt
cur_time=$(date "+%Y-%m-%d %H:%M:%S")
echo "${cur_time}=>zone_id++ ${zone_id}" >> $task_log_path

cur_time=$(date "+%Y-%m-%d %H:%M:%S")
echo "当前执行开服：${zone_id}区结束时间为:${cur_time}" >> $task_log_path

echo $zone_id