Changeset 2689 for trunk/website/scripts/blackbox/upload.php

Timestamp:

05/25/12 01:35:32 (13 months ago)

Author:

lowjoel

Message:

Use the lowercase table names, following our schema.

File:

• trunk/website/scripts/blackbox/upload.php (modified) (3 diffs)

trunk/website/scripts/blackbox/upload.php

@@ -56 +56 @@
         
         //Query for the list of exceptions containing the given functions
-        $statement = $pdo->prepare(sprintf('SELECT DISTINCT(BlackBox_Exceptions.ID) FROM BlackBox_StackFrames
-            INNER JOIN BlackBox_Exceptions ON BlackBox_StackFrames.ExceptionID=BlackBox_Exceptions.ID
+        $statement = $pdo->prepare(sprintf('SELECT DISTINCT(blackbox_exceptions.ID) FROM blackbox_stackframes
+            INNER JOIN blackbox_exceptions ON blackbox_stackframes.ExceptionID=blackbox_exceptions.ID
             WHERE (%s) AND ExceptionDepth=? AND ExceptionType=?',
             substr($stackFrames, 0, strlen($stackFrames) - 4)));
@@ -78 +78 @@
     $pdo->beginTransaction();
 
-    $statement = $pdo->prepare('INSERT INTO BlackBox_Reports SET IPAddress=?');
+    $statement = $pdo->prepare('INSERT INTO blackbox_reports SET IPAddress=?');
     $statement->bindParam(1, sprintf('%u', ip2long($_SERVER['REMOTE_ADDR'])));
     try
@@ -90 +90 @@
 
     $reportId = $pdo->lastInsertId();
-    $exceptionInsert = $pdo->prepare('INSERT INTO BlackBox_Exceptions
+    $exceptionInsert = $pdo->prepare('INSERT INTO blackbox_exceptions
         SET ReportID=?, ExceptionType=?, ExceptionDepth=?');
     $exceptionInsert->bindParam(1, $reportId);
-    $stackFrameInsert = $pdo->prepare('INSERT INTO BlackBox_StackFrames SET
+    $stackFrameInsert = $pdo->prepare('INSERT INTO blackbox_stackframes SET
         ExceptionID=?, StackFrameIndex=?, Function=?, File=?, Line=?');
     foreach ($stackTrace as $exceptionDepth => $exception)