This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment