#!/bin/bash

DB_USER='01088992482db'
DB_PASS='pwnew11400'
DB_NAME='01088992482db'

DATE=`date '+%Y%m%d%H%M%S'`
#echo $DATE

HH=${DATE:8:2}
HH2=`expr $RANDOM % 3`
MM=${DATE:10:2} 
MM2=`expr $RANDOM % 59`
SS=${DATE:12:2} 
SS2=`expr $RANDOM % 59`

HH=$(( HH + HH2 ))
MM=$(( MM + MM2 ))
#SS=$(( SS + SS2 ))

DD=${DATE:0:8}$HH$MM$SS
#echo $DD

SUBJ[0]='구미포장이사 문의드립니다.'
SUBJ[1]='구미포장이사 궁금합니다.'
SUBJ[2]='구미포장이사 답변부탁드립니다.'
SUBJ[3]='구미포장이사 문의'
SUBJ_IDX=`expr $RANDOM % 4`
SS=${SUBJ[SUBJ_IDX]}
echo $SS

SEQ=`/home/mysql/bin/mysql --user=$DB_USER --password=$DB_PASS --database=$DB_NAME --execute="SELECT MIN(gid)-1 AS seq FROM rb_bbs_index;"`
SEQ=${SEQ:4:11}
echo $SEQ

/home/mysql/bin/mysql --user=$DB_USER --password=$DB_PASS --database=$DB_NAME --execute="INSERT INTO rb_bbs_data (site, gid, bbs, bbsid, depth, parentmbr, display, hidden, notice, name, nic, mbruid, id, pw, category, subject, content, html, tag, hit, down, comment, oneline, trackback, score1, score2, singo, point1, point2, point3, point4, d_regis, d_modify, d_comment, d_trackback, upload, ip, agent, sns, adddata, email, tel) VALUES (1, $SEQ, 6, 'qna', 0, 0, 1, 1, 0, '비공개', '비공개', 0, '', 'ad0234829205b9033196ba818f7a872b', '', '$SS', '구미포장이사', 'HTML', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, $DD, '', '', '', '', '180.70.123.220', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36', '', '', 'email', 'tel');"

/home/mysql/bin/mysql --user=$DB_USER --password=$DB_PASS --database=$DB_NAME --execute="INSERT INTO rb_bbs_index (site, notice, bbs, gid) VALUES (1, 0, 6, $SEQ);"