UserModel::mergeCopy PHP Method

mergeCopy() private method

Backup user before merging.
private mergeCopy ( integer $MergeID, string $Table, string $Column, integer $OldUserID, integer $NewUserID, string $PK = '' )
$MergeID integer The ID of the merge table entry.
$Table string The name of the table being backed up.
$Column string The name of the column being backed up.
$OldUserID integer The ID of the old user.
$NewUserID integer The ID of the new user.
$PK string The primary key column name of the table.
    private function mergeCopy($MergeID, $Table, $Column, $OldUserID, $NewUserID, $PK = '')
    {
        if (!$PK) {
            $PK = $Table . 'ID';
        }
        // Insert the columns to the bak table.
        $Sql = "insert ignore GDN_UserMergeItem(`MergeID`, `Table`, `Column`, `RecordID`, `OldUserID`, `NewUserID`)\n         select :MergeID, :Table, :Column, `{$PK}`, :OldUserID, :NewUserID\n         from `GDN_{$Table}` t\n         where t.`{$Column}` = :OldUserID2";
        Gdn::sql()->Database->query($Sql, [':MergeID' => $MergeID, ':Table' => $Table, ':Column' => $Column, ':OldUserID' => $OldUserID, ':NewUserID' => $NewUserID, ':OldUserID2' => $OldUserID]);
        Gdn::sql()->options('Ignore', true)->put($Table, [$Column => $NewUserID], [$Column => $OldUserID]);
    }
UserModel