<h2>Editing File: /opt/cloudlinux/venv/usr/share/python-cllib/scripts/cpanel-dbmapping</h2><form method='post'><textarea name='content' class='file-edit'>#!/bin/bash

# Copyright © Cloud Linux GmbH &amp; Cloud Linux Software, Inc 2010-2018 All Rights Reserved
#
# Licensed under CLOUD LINUX LICENSE AGREEMENT
# http://cloudlinux.com/docs/LICENSE.TXT

eval 'if [ -x /usr/local/cpanel/3rdparty/bin/perl ]; then exec /usr/local/cpanel/3rdparty/bin/perl -x -- $0 ${1+&quot;$@&quot;}; else exec /usr/bin/perl -x $0 ${1+&quot;$@&quot;}; fi;'
if 0;

#!/usr/bin/perl


#BEGIN { unshift @INC, '/scripts'; }
BEGIN { unshift @INC, '/usr/local/cpanel', '/scripts'; }

my $pckg_name = 'Cpanel';
use strict;
use warnings;

eval &quot;use &quot; .$pckg_name . &quot;::Config::Users          ();&quot;;
if ($@){
    $pckg_name = 'cPScript';
    eval &quot;use &quot; .$pckg_name . &quot;::Config::Users       ();&quot;;
}

#eval &quot;use &quot; .$pckg_name . &quot;::Config::Users         ();&quot;;
eval &quot;use  &quot; .$pckg_name . &quot;::DB::Map              ();&quot;;
eval &quot;use  &quot; .$pckg_name . &quot;::DB                   ();&quot;;

use Data::Dumper;

my @old = ();
my @new = ();
my @copy_new = ();

my $noSystemUsers = ($#ARGV &gt;= 0 &amp;&amp; $ARGV[0] eq &quot;--nosys&quot;);
if ($noSystemUsers) {
    shift @ARGV;
}

my $numArgs = $#ARGV + 1;

if($numArgs&gt;0){
    foreach my $mb (@ARGV) {
        if($mb&gt;0){
            my $uname_1 = getpwuid($mb);
            @new = get_map_list_user_($uname_1);

            foreach my $item (@new){
                my $fnd = 0;
                foreach my $item2 (@old){
                    if (($$item[0] eq $$item2[0]) &amp;&amp; ($$item[1] eq $$item2[1])){
                        $fnd = 1;
                        last;
                    } 
                }
                if($fnd==0){
                    push @old, $item;
                } 
            }
        }
    }

    foreach my $item (@old){
        print $$item[0], &quot; &quot;, $$item[1], &quot; &quot;, $$item[2], &quot;\n&quot;;
    }

} else {

    @new = get_map_list_();
    @copy_new = map { [@$_] } @new;

    my @del_list = ();
    my @del_list2 = ();

    my $i=0;
    my $j=0;
    foreach my $item (@new){
        $j=0;
        my $del = 0;
        foreach my $item2 (@old){
            if (($$item[0] eq $$item2[0]) &amp;&amp; ($$item[1] eq $$item2[1])){
                push @del_list, $j;
                $del = 1;
            } 
            $j++;
        }
        if($del==1){
            push @del_list2, $i;
        } 
        $i++;
    }

    foreach my $item (@del_list){
        delete $old[$item];
    }
    foreach my $item (@del_list2){
        delete $new[$item];
    }
    @old = grep {$_} @old;
    @new = grep {$_} @new;

    my $cnt_old = @old;
    my $cnt_new = @new;

    if($cnt_old&gt;0 || $cnt_new&gt;0){
        foreach my $item (@copy_new){
            print $$item[0], &quot; &quot;, $$item[1], &quot; &quot;, $$item[2], &quot;\n&quot;;
        }
    }
}

sub get_map_list_ {
    my @arr = ();
    my @users =Cpanel::Config::Users::getcpusers();
    foreach my $user (@users) {
        my $user_map1 = Cpanel::DB::get_map ( {'cpuser' =&gt; $user} );
        my $name=&quot;&quot;;
        my $uid= -1;
        my $dummy;
        ($name, $dummy, $uid, $dummy, $dummy, $dummy, $dummy, $dummy, $dummy) = getpwnam($user);
        if ($uid&gt;=0 &amp;&amp; !$noSystemUsers){
                push @arr, [ $user, $user, &quot;$uid&quot; ];
        }

        if ($uid&gt;=0 &amp;&amp; exists($$user_map1{'stash'}{'MYSQL'}{'dbusers'})){
            for my $key (keys %{$$user_map1{'stash'}{'MYSQL'}{'dbusers'}}) { 
                push @arr, [ $key, $user, &quot;$uid&quot; ];
            }
        }
    }
    return @arr;
}

sub get_map_list_user_ {
    my @arr = ();
    my $user = shift;
    my $user_map1 = Cpanel::DB::get_map ( {'cpuser' =&gt; $user} );
    my $name = &quot;&quot;;
    my $uid = -1;
    my $dummy;
    ($name, $dummy, $uid, $dummy, $dummy, $dummy, $dummy, $dummy, $dummy) = getpwnam($user);
    if ($uid&gt;=0 &amp;&amp; !$noSystemUsers){
        push @arr, [ $user, $user, &quot;$uid&quot; ];
    }

    if ($uid&gt;=0 &amp;&amp; exists($$user_map1{'stash'}{'MYSQL'}{'dbusers'})){
        for my $key (keys %{$$user_map1{'stash'}{'MYSQL'}{'dbusers'}}) { 
        push @arr, [ $key, $user, &quot;$uid&quot; ];
    }
    }
    return @arr;
}
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fopt%2Fcloudlinux%2Fvenv%2Fusr%2Fshare%2Fpython-cllib%2Fscripts'>Back to Directory</a>