#! /bin/bash

HOME="/home/$USER"
TMP_DIR="$HOME/tmp_upgrade"
PATH_TARGET="$HOME/public_html"
CONFIG_INC="$PATH_TARGET/conf/config.inc.php"
DOMAIN_INC="$PATH_TARGET/custom/domain/domain.inc.php"
CONSTANTS_INC="$PATH_TARGET/conf/constants.inc.php"
EDIR_ROOT="$PATH_TARGET"
LOG="$TMP_DIR/fix_sitemgr.log"
EDIR_VERSION=$(grep -E "VERSION" $CONSTANTS_INC | awk '{ print $2}' | \
tr -d "[\) \" \; v a-zA-Z \\]" | sed 's/^[. $]//' | sed '/^$/d' | sed 's/\r//g' | head -1)

[ ! -d $TMP_DIR ] && mkdir $TMP_DIR

DB_USER=$(grep -E "define\(\"_DIRECTORYDB_USER\"\," $CONFIG_INC | cut -f4 -d '"')
DB_PASS=$(grep -E "define\(\"_DIRECTORYDB_PASS\"\," $CONFIG_INC | cut -f4 -d '"')
DB_MAIN=$(grep -E "define\(\"_DIRECTORYDB_NAME\"\," $CONFIG_INC | cut -f4 -d '"')

NEW_PASS_SITEMGR=$(/usr/local/bin/v11tools-gerar_senha)
NEW_HASH="$DB_USER""$NEW_PASS_SITEMGR"
#NEW_HASH_SITEMGR=$(echo -e "$DB_USER""$NEW_PASS_SITEMGR" | md5sum | awk '{print $1}')
#echo -e "\n$NEW_HASH_SITEMGR\n"
CHANGE_LOGIN="use $DB_MAIN; update SMAccount set username='arcalogin@arcasolutions.com' where username='arcalogin';"
CHANGE_PASS="use $DB_MAIN; update SMAccount set password=MD5('$NEW_PASS_SITEMGR'), complementary_info=MD5('$NEW_HASH') where username='arcalogin@arcasolutions.com';"
#complementary_info, gerar um hash concatenando 
#complementary_info = ".db_formatString(md5($this->username.$this->password))." WHERE id = $this->id";

echo -e "[+] Gerando nova senha..."
sleep 1

mysql -u"$DB_USER" -p"$DB_PASS" -e "$CHANGE_LOGIN"
mysql -u"$DB_USER" -p"$DB_PASS" -e "$CHANGE_PASS"

echo -e "Concluido.\n
Sitemgr:
Login\t: arcalogin@arcasolutions.com\nSenha\t: $NEW_PASS_SITEMGR
\nAtualize no Rattic.\n" > $LOG

cat $LOG

## FIM
