BUG_REPORT_FORM_R0: process_bug_report.php

<?php
        
        function getFileName($attIndex) {
                $reportIdRow = mysql_fetch_array(mysql_query("SELECT max(id) AS result FROM reports;"));
                $reportId = $reportIdRow['result'];
        
                $path_info = pathinfo($_FILES['sophie2attachment']['name']);
                $fileExtension = $path_info['extension'];
                
                return "ReportNo$reportId-Attachment$attIndex.$fileExtension";
        }

        $con = mysql_connect("localhost","root","");
        if (!$con) {
                die('Could not connect: ' . mysql_error());
        }
        mysql_select_db("bug_reports", $con);

        $email = addSlashes($_POST['sophie2email']);
        $userExpl = addSlashes($_POST['sophie2userExplanation']);
        $stackTrace = addSlashes($_POST['sophie2stacktrace']);
        $log = addSlashes($_POST['sophie2log']);
        $sysProps = addSlashes($_POST['sophie2systemProperties']);
        
        $sql = "INSERT INTO reports (eMail, userExplanation, stackTrace, log, systemProperties) 
                VALUES ('$email','$userExpl','$stackTrace', '$log', '$sysProps')";
        mysql_query($sql);
        
        if (mysql_error()) {
                echo "2: The report could not be submitted.";
        } else {
                
                $target_path = "uploads/" . getFileName(1);
                
                if ($_FILES['sophie2attachment']['tmp_name']) {
                
                        if ($_FILES['sophie2attachment']['error'] > 0 || $_FILES['sophie2attachment']['size'] > 11 * 1024 * 1024) {
                                echo "1: The report was submitted but there was a problem with the attached file.";
                        } else {
                        
                                // TODO: try-catch instead?
                                $src = fopen($_FILES['sophie2attachment']['tmp_name'], 'rb');                   
                                if (!$src) {
                                        echo "1: The report was submitted but there was a problem with the attached file.";
                                } else {
                                        $dst = fopen("$target_path", 'wb');
                                        if (!dst) {
                                                echo "1: The report was submitted bit there was a problem with the attached file.";
                                        } else {
                                                $chunkSize = 1024;
                                                while (!feof($src)) {
                                                        fwrite($dst, base64_decode(fread($src, $chunkSize)));
                                                }
                                                fclose($dst);
                                        }
                                        fclose($src);
                                }
                        }
                }
        }
        
        echo "0: Success";
?>