| Server IP : 157.90.209.209 / Your IP : 216.73.216.129 [ Web Server : Apache System : Linux hcomm124.dns-wk.info 4.18.0-553.64.1.el8_10.x86_64 #1 SMP Mon Jul 28 12:01:56 EDT 2025 x86_64 User : evidenciarevista ( 1049) PHP Version : 7.2.34 Disable Function : exec,passthru,shell_exec,system Domains : 216 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /scripts/ |
Upload File : |
#!/usr/local/cpanel/3rdparty/bin/perl
# cpanel - scripts/convert_whmxfer_to_sqlite Copyright 2022 cPanel, L.L.C.
# All rights reserved.
# copyright@cpanel.net http://cpanel.net
# This code is subject to the cPanel license. Unauthorized copying is prohibited
package scripts::convert_whmxfer_to_sqlite;
use strict;
use Whostmgr::Transfers::Session::Config ();
use Whostmgr::Transfers::SessionBase ();
use Cpanel::MysqlUtils::Connect ();
exit( __PACKAGE__->script() ) unless caller();
sub script {
my $sessionbase = Whostmgr::Transfers::SessionBase->new();
my $sqlite_dbh = $sessionbase->get_master_dbh();
my $mysql_dbh = Cpanel::MysqlUtils::Connect::get_dbi_handle();
my $has_db = $mysql_dbh->selectall_arrayref("SHOW DATABASES LIKE 'whmxfer';");
return if !$has_db->[0];
my $ref = $mysql_dbh->selectall_hashref( "select * from whmxfer.sessions;", 'sessionid' );
foreach my $sessionid ( sort keys %$ref ) {
next if !-d $Whostmgr::Transfers::Session::Config::SESSION_DIR . '/' . $sessionid;
my $row = $ref->{$sessionid};
my $cols = join( ',', map { $sqlite_dbh->quote($_) } keys %{$row} );
my $values = join( ',', map { $sqlite_dbh->quote($_) } values %{$row} );
$sqlite_dbh->do("INSERT INTO sessions ($cols) VALUES($values);");
}
$mysql_dbh->do("DROP DATABASE whmxfer;");
return 0;
}