Changeset 1436

Timestamp:

1/1/2010 1:31:29 AM (3 years ago)

Author:

lowjoel

Message:

Rename all the BlackBox? tables to have an underscore separating the BlackBox? noun and the table name. This follows the convention of the rest of the tables

File:

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

trunk/website/blackbox/upload.php

@@ -43 +43 @@
         
         //Query for the list of exceptions containing the given functions
-        $query = mysql_query(sprintf('SELECT DISTINCT(BlackBoxExceptions.ID) FROM BlackBoxStackFrames
-            INNER JOIN BlackBoxExceptions ON BlackBoxStackFrames.ExceptionID=BlackBoxExceptions.ID
+        $query = mysql_query(sprintf('SELECT DISTINCT(BlackBox_Exceptions.ID) FROM BlackBox_StackFrames
+            INNER JOIN BlackBox_Exceptions ON BlackBox_StackFrames.ExceptionID=BlackBox_Exceptions.ID
             WHERE (%s) AND ExceptionDepth=%d AND ExceptionType=\'%s\'',
             substr($stackFrames, 0, strlen($stackFrames) - 4), $exceptionDepth,
@@ -61 +61 @@
 {
     mysql_query('BEGIN TRANSACTION');
-    mysql_query(sprintf('INSERT INTO BlackBoxReports SET IPAddress=%u', ip2long($_SERVER['REMOTE_ADDR'])));
+    mysql_query(sprintf('INSERT INTO BlackBox_Reports SET IPAddress=%u', ip2long($_SERVER['REMOTE_ADDR'])));
     if (mysql_affected_rows() != 1)
         throw new Exception('Could not insert crash report into Reports table: ' . mysql_error());
@@ -68 +68 @@
     foreach ($stackTrace as $exceptionDepth => $exception)
     {
-        mysql_query(sprintf('INSERT INTO BlackBoxExceptions SET ReportID=%d, ExceptionType=\'%s\', ExceptionDepth=%d',
+        mysql_query(sprintf('INSERT INTO BlackBox_Exceptions SET ReportID=%d, ExceptionType=\'%s\', ExceptionDepth=%d',
             $reportId, mysql_real_escape_string($exception['exception']), $exceptionDepth));
         if (mysql_affected_rows() != 1)
@@ -94 +94 @@
             }
             
-            mysql_query(sprintf('INSERT INTO BlackBoxStackFrames SET
+            mysql_query(sprintf('INSERT INTO BlackBox_StackFrames SET
                 ExceptionID=%d, StackFrameIndex=%d, Function=\'%s\', File=%s, Line=%s',
                 $exceptionId, $stackIndex, mysql_real_escape_string($function),