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 : /proc/1700/cwd/html/app/model/

Upload File :

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

Current File : /proc/1700/cwd/html/app/model/PageRepository.php

<?php

namespace Promoteus;

use App\frontModule\Presenters\BasePresenter;
use Tracy\Debugger;

/**
 * Table "page"
 */
class PageRepository extends Repository
{
    public function insert($values)
    {
        parent::insert($values);
    }

    public function update($pageId, $values)
    {
        if(parent::update($pageId, $values)){
            return true;
        }else{
            return false;
        }

    }


    /**
     * @param int $page_id
     * @param $ls
     * @return mixed
     * @throws RepositoryException
     */
    public function getPageById(int $page_id, $ls)
    {
        $res = $this->getTable()->select("id, title_$ls title, url_$ls url, content_$ls content, active_$ls active" )->where(['id' => $page_id])->fetchAll();
        if ($res) {
            return array_shift($res);
        }
        throw new RepositoryException('Page not found!');
    }

    function getAllLangUrl($pageId)
    {
        $activeLangs = [1, 2, 3, 4];
        $allLangUrl = [];

        foreach ($activeLangs as &$langId) {
            //$langSuffix = $this->langRep->getLangSuffix($langId);TODO ma byt tak, ale zatim to co je dolu:
            $langSuffix = $this->db->table('languages')->select('suffix')->where(['id_lang' => $langId])->fetch()->suffix;
            $res = $this->getTable()->select("url_$langSuffix url")->where(['id' => $pageId])->fetch();

            $allLangUrl[$langId] = $res['url'];
        }

        return $allLangUrl;
    }

    /**
     * @param string $page_url
     * @param $ls
     * @return array|\Nette\Database\Table\IRow[]|\Nette\Database\Table\Selection
     * @throws RepositoryException
     */
    public function getPage(string $page_url, $ls)
    {
        $res = $this->getTable()->select("id, title_$ls title, url_$ls url, content_$ls content, active_for_logout_$ls active_for_logout")->where(['url_' . $ls => $page_url, "active_$ls" => true])->fetchAll();
        if ($res) {
            return array_shift($res);
        }
        throw new RepositoryException('Page not found!');
    }

    function getPageText($page, $subpage = null, $langSuffix = null, $pos = "top")
    {
        $langSuffix = $langSuffix ?: BasePresenter::getLanguageData();
        $category = $subpage ?: $page;

        if (empty($category)) {
            return [];
        }

        /*$result = $this->getTable()->select("active_$langSuffix active, title_$langSuffix title, description_$langSuffix description, content_$langSuffix content")
            ->joinWhere('category', "category.page_id_$pos = page.id")
            ->where(["category.url_$langSuffix" => $category])
            ->fetchAll();*/
        $pageText = $this->db->query("SELECT page.id id, page.active_$langSuffix active, title_$langSuffix title, description_$langSuffix description, content_$langSuffix content FROM page "
            . "JOIN category ON category.page_id_$pos = page.id "
            . "WHERE category.url_$langSuffix = ?", $category)->fetch();

        if (!$pageText && $pos != "bot") {
            $pageText = $this->getTable()->select("id, active_$langSuffix active, title_$langSuffix title, description_$langSuffix description, content_$langSuffix content")
                ->where(["url_$langSuffix" => $category])->fetchAssoc('id');
            $pageText = $pageText ? end($pageText) : null;

            if ($pageText && $pageText['title'] == "") {
                $category_text = $this->db->table('category')->select("id, name_$langSuffix name")
                    ->where(["url_$langSuffix" => $category])->fetchAssoc('id');
                $pageText['title'] = $category_text ? $category_text['name'] : null;
            }
        }

        if (!$pageText['active']) {
            return [];
        }

        $pageText['title'] = $pageText['title'] ?? null;
        $pageText['content'] = $pageText['content'] ?? null;
        $pageText['description'] = $pageText['description'] ?? null;
        /* Když najdu značku MORE, zobrazím jen první půlku */
        if ($pageText && strpos($pageText['content'], '*** MORE ***') !== false && $page != 'kariera') {
            $content = explode("*** MORE ***", $pageText['content']);
            $pageText['content'] = $content[0];
            $pageText['afterMore'] = $content[1];
        }

        $pageText['description'] = html_entity_decode(strip_tags($pageText['description']));
        return $pageText;
    }

    /**
     * @param string $search_string
     * @param string $ls
     * @return array
     */
    public function getPageSearch(string $search_string, string $ls){
        $search_string = str_replace("  ", " ", $search_string);
        $search_string = str_replace(" ", "+", $search_string);
        $search_array = explode("+", $search_string);

        $query = "SELECT DISTINCT p.title_$ls title, p.description_$ls description, p.url_$ls url, c.url_$ls cat_top, c2.url_$ls cat_bot, c3.url_$ls parent_top, c4.url_$ls parent_bot
			  FROM page p
              LEFT JOIN category c ON p.id = c.page_id_top
              LEFT JOIN category c2 ON p.id = c2.page_id_bot
              LEFT JOIN category c3 ON c.parent_id = c3.id
              LEFT JOIN category c4 ON c2.parent_id = c4.id
              WHERE (";
        foreach ($search_array as $littlestring){
            $encoded_ls = htmlentities($littlestring);
            $query .= "(title_$ls LIKE '%$littlestring%' OR content_$ls LIKE '%$encoded_ls%') AND ";
        }
        $query .= "1) AND p.active_$ls = 1 AND p.id NOT IN (20,22,23,24,25,68,70,72,78,79) GROUP BY url"; // z dotazu vypustit thankyou page

        $result = $this->db->query($query);

        $resultExtrudes = array(
            "cze" => array(
                1 => "uspesna-registrace"
            ),
            "eng" => array(
                1 => "successful-registration"
            ),
            "ger" => array(
                1 => "erfolgreiche-registration"
            ),
            "svk" => array(
                1 => "uspesna-registracia"
            )
        );
        $extrudesCount = count($resultExtrudes[$ls]);
        $pages = array();
        if($result){
            foreach($result->fetchAll() as $a){



                $status = 1;

                foreach ($resultExtrudes[$ls] as $row){
                    if ($a["url"] == $row){
                        $status = 0;
                    }
                }

                if($status == 1){
                    $pages[] = $a;
                }

            }
        }

        return $pages;
    }

}

Anon7 - 2022
AnonSec Team