#!/bin/bash
cat /tmp/new_wp.txt | while read LINE
  do
    if [ -f /var/www/html/$LINE/wp-config.php ]
     then
      echo $LINE
      hostdb=`grep DB_HOST  /var/www/html/$LINE/wp-config.php | awk '{print $2}' | awk -F"'" '{print $2}'`
      db=`grep DB_NAME  /var/www/html/$LINE/wp-config.php | awk '{print $2}' | awk -F"'" '{print $2}'`
      user=`grep DB_USER  /var/www/html/$LINE/wp-config.php | awk '{print $2}' | awk -F"'" '{print $2}'`
      pass=`grep DB_PASSWORD  /var/www/html/$LINE/wp-config.php | awk '{print $2}' | awk -F"'" '{print $2}'`

      ###add mwp user
      user_pass=`date +%s | sha256sum | base64 | head -c 16 ; echo`
      sql="INSERT INTO wp_users (user_login, user_pass, user_nicename, user_email, user_status) VALUES ('mwp', MD5('$user_pass'), '', 'mwp@devellar.com', '0');"
      echo $sql
      mysql -h $hostdb -u $user -p$pass -e "use $db;$sql;"
      sql="INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, (Select id FROM wp_users where user_login='mwp'), 'wp_capabilities', 'a:1:{s:13:\"administrator\";s:1:\"1\";}');"
      echo $sql
      mysql -h $hostdb -u $user -p$pass -e "use $db;$sql;"
      sql="INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, (Select id FROM wp_users where user_login='mwp'), 'wp_user_level', '10');"
      echo $sql
      mysql -h $hostdb -u $user -p$pass -e "use $db;$sql;"
      ###

      #add plugin mwp
      cp -R /tmp/mainwp-child /var/www/html/$LINE/wp-content/plugins/
      chown $LINE:$LNE /var/www/html/$LINE/wp-content/plugins/mainwp-child
      chown -R $LINE:$LINE /var/www/html/$LINE/wp-content/plugins/mainwp-child/*

      val_old=`mysql -N -h $hostdb -u $user -p$pass -e "use $db;SELECT option_value FROM wp_options WHERE option_name = 'active_plugins';"`
      val_new=`echo $val_old | php /tmp/serial.php`

      sql="update wp_options set option_value='$val_new' WHERE option_name = 'active_plugins';"
      #echo $sql
      mysql -h $hostdb -u $user -p$pass -e "use $db;$sql;"

      id_pass=`date +%s | sha256sum | base64 | head -c 8 ; echo`
      sql="update wp_options set option_value='$id_pass' WHERE option_name = 'mainwp_child_uniqueId';"

      echo "$LINE,http://$LINE,mwp,site-1,$id_pass,,,T,auto" >> /tmp/web_id.txt
      mysql -h $hostdb -u $user -p$pass -e "use $db;$sql;"
      sleep 1

#         echo $sql
#         mysql -h localhost -u $user -p$pass -e "use $db;$sql;"

    fi
 done;