????JFIF??x?x????'
| Server IP : 79.136.114.73 / Your IP : 216.73.217.114 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/www.inspection-online.se/scripts/ |
Upload File : |
<?php
$username = $_POST['username'];
$password = $_POST['password'];
$password_md5 = md5($password);
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("supervision");
$sql = "select * from tblUsers where username = '".$username."' and password = '".$password_md5."' and active = 1";
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0) {
// User found, we are logged in
$userdata = mysql_fetch_assoc($result);
$xml ='<?xml version="1.0" encoding="UTF-8"?>
';
$xml .= ' <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
';
$xml .= ' <plist version="1.0">
';
$xml .= ' <dict>
';
$xml .= ' <key>LoginInfo</key>
';
$xml .= ' <dict>
';
$xml .= ' <key>UserID</key>
';
$xml .= ' <string>'.$userdata['userId'].'</string>
';
$xml .= ' <key>CompanyID</key>
';
$xml .= ' <string>'.$userdata['companyId'].'</string>
';
$xml .= ' <key>LoggedIn</key>
';
$xml .= ' <string>true</string>
';
$xml .= ' <key>ReloadSplashScreen</key>
';
$xml .= ' <string>false</string>
';
$xml .= ' <key>SplashScreen</key>
';
$xml .= ' <string></string>
';
$xml .= ' <key>SymbolSets</key>
';
$xml .= ' <dict>
';
$sql = "SELECT * FROM tblSymbolSets where companyid = ".$userdata['companyId'];
$result1 = mysql_query($sql);
$SymbolSetX = 0;
while ($row1 = mysql_fetch_assoc($result1)){
$symbolSetId = $row1['symbolSetId'];
$SymbolSetX++;
$xml .= ' <key>SymbolSet'.$SymbolSetX.'</key>
';
$xml .= ' <dict>
';
$xml .= ' <key>IdentifyData</key>
';
$xml .= ' <dict>
';
$xml .= ' <key>Name</key>
';
$xml .= ' <string>'.$row1['name'];
$xml .= '</string>
';
$xml .= ' <key>SymbolSetId</key>
';
$xml .= ' <integer>'.$row1['symbolSetId'];
$xml .= '</integer>
';
$xml .= ' <key>Status1</key>
';
$xml .= ' <dict>
';
$xml .= ' <key>Image</key>
';
$xml .= ' <string>'.$row1['status1'];
$xml .= '</string>
';
$xml .= ' <key>ImageURL</key>
';
$xml .= ' <string>'.$row1['status1url'];
$xml .= '</string>
';
$xml .= ' </dict>
';
$xml .= ' <key>Status2</key>
';
$xml .= ' <dict>
';
$xml .= ' <key>Image</key>
';
$xml .= ' <string>'.$row1['status2'];
$xml .= '</string>
';
$xml .= ' <key>ImageURL</key>
';
$xml .= ' <string>'.$row1['status2url'];
$xml .= '</string>
';
$xml .= ' </dict>
';
$xml .= ' <key>Status3</key>
';
$xml .= ' <dict>
';
$xml .= ' <key>Image</key>
';
$xml .= ' <string>'.$row1['status3'];
$xml .= '</string>
';
$xml .= ' <key>ImageURL</key>
';
$xml .= ' <string>'.$row1['status3url'];
$xml .= '</string>
';
$xml .= ' </dict>
';
$xml .= ' <key>Status4</key>
';
$xml .= ' <dict>
';
$xml .= ' <key>Image</key>
';
$xml .= ' <string>'.$row1['status4'];
$xml .= '</string>
';
$xml .= ' <key>ImageURL</key>
';
$xml .= ' <string>'.$row1['status4url'];
$xml .= '</string>
';
$xml .= ' </dict>
';
$xml .= ' </dict>
';
$xml .= ' </dict>
';
}
$xml .= ' </dict>
';
$xml .= ' </dict>
';
$xml .= ' </dict>
';
$xml .= '</plist>';
$sql = "update tblUsers set loggedIn = '1', lastLogin = '".date("Y-m-d H:i:s")."' where username = '".$username."' and password = '".$password_md5."'";
mysql_query($sql);
}else{
// User not found, not logged in
$xml ='<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>LoginInfo</key>
<dict>
<key>UserID</key>
<string></string>
<key>CompanyID</key>
<string></string>
<key>LoggedIn</key>
<string>false</string>
<key>ReloadSplashScreen</key>
<string>false</string>
<key>SplashScreen</key>
<string></string>
</dict>
</dict>
</plist>';
}
if($_GET['test'] == "true"){
echo(iconv($source_encoding,"UTF-8",$xml));
}else{
$source_encoding = "ISO-8859-1";
header("Content-type: application/octet-stream");
header('Content-Disposition: attachment; filename="Login.plist"');
echo(iconv($source_encoding,"UTF-8",$xml));
}
?>