isc_change_owner.sh

#!/bin/bash
#http://www.howtoforge.com/forums/showthread.php?t=57770
#
# Usage ./script.sh client new_owner

MY="mysql --skip-column-names --batch "
CLIENT_USERNAME=$1
RESELLER_USERNAME=$2

DB="dbispconfig"

k=$( $MY -e "SELECT Rsu.userid AS R_userid, Rsg.groupid AS R_groupid, Rsg.client_id AS R_client_id, Csu.userid AS C_userid, Csg.groupid AS C_groupid, Csg.client_id AS C_client_id
FROM sys_user AS Rsu
        JOIN sys_group AS Rsg ON Rsu.default_group = Rsg.groupid
        JOIN sys_user AS Csu ON Csu.username = '$CLIENT_USERNAME'
        JOIN sys_group AS Csg ON Csu.default_group = Csg.groupid
WHERE Rsu.username = '$RESELLER_USERNAME';" $DB )

R_client_id=$( echo $k | awk '{print $3}' )
R_userid=$( echo $k | awk '{print $1}' )
R_groupid=$( echo $k | awk '{print $2}' )
C_client_id=$( echo $k | awk '{print $6}' )
C_groupid=$( echo $k | awk '{print $5}' )
#C_userid=$( echo $k | awk '{print $4}' )

echo update client
$MY -e "UPDATE \`client\`
SET \`parent_client_id\` = '$R_client_id',
        \`sys_userid\` = '$R_userid',
        \`sys_groupid\` = '$R_groupid'
WHERE client_id = '$C_client_id';" $DB

echo update sys_user
$MY -e "UPDATE \`sys_user\`
        SET \`groups\` = CONCAT(\`groups\`,',','$C_groupid')
WHERE \`userid\` = '$R_userid';" $DB