#!/bin/bash

DB_USER='******';
DB_PASS='******';

echo 'USE portal' > query.sql
mysql -u$DB_USER -p$DB_PASS < select.sql | grep -v user_login | sed 's/\t/#########/g' | while read str
do
    user_login=`echo $str | awk -F"#########" '{print $1}'`
    user_email=`echo $str | awk -F"#########" '{print $2}'`
    registered=`echo $str | awk -F"#########" '{print $3}'`
    meta=`echo $str | awk -F"#########" '{print $4}'`
    pass=`echo $meta | awk -F';' '{print $6}' | awk -F'"' '{print $2}'`
    lname=`echo $meta | awk -F';' '{print $2}' | awk -F'"' '{print $2}'`
    echo "INSERT INTO wp_users (user_login, user_pass, user_nicename, user_email, user_registered, display_name) VALUES ('$user_login', '$pass', '$user_login', '$user_email', '$registered', '$lname');" >> query.sql
done
echo 'UPDATE wp_signups SET active = 1' >> query.sql
mysql -u$DB_USER -p$DB_PASS < query.sql