Changeset 1436


Ignore:
Timestamp:
1/1/2010 1:31:29 AM (5 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:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/website/blackbox/upload.php

    r1416 r1436  
    4343         
    4444        //Query for the list of exceptions containing the given functions 
    45         $query = mysql_query(sprintf('SELECT DISTINCT(BlackBoxExceptions.ID) FROM BlackBoxStackFrames 
    46             INNER JOIN BlackBoxExceptions ON BlackBoxStackFrames.ExceptionID=BlackBoxExceptions.ID 
     45        $query = mysql_query(sprintf('SELECT DISTINCT(BlackBox_Exceptions.ID) FROM BlackBox_StackFrames 
     46            INNER JOIN BlackBox_Exceptions ON BlackBox_StackFrames.ExceptionID=BlackBox_Exceptions.ID 
    4747            WHERE (%s) AND ExceptionDepth=%d AND ExceptionType=\'%s\'', 
    4848            substr($stackFrames, 0, strlen($stackFrames) - 4), $exceptionDepth, 
     
    6161{ 
    6262    mysql_query('BEGIN TRANSACTION'); 
    63     mysql_query(sprintf('INSERT INTO BlackBoxReports SET IPAddress=%u', ip2long($_SERVER['REMOTE_ADDR']))); 
     63    mysql_query(sprintf('INSERT INTO BlackBox_Reports SET IPAddress=%u', ip2long($_SERVER['REMOTE_ADDR']))); 
    6464    if (mysql_affected_rows() != 1) 
    6565        throw new Exception('Could not insert crash report into Reports table: ' . mysql_error()); 
     
    6868    foreach ($stackTrace as $exceptionDepth => $exception) 
    6969    { 
    70         mysql_query(sprintf('INSERT INTO BlackBoxExceptions SET ReportID=%d, ExceptionType=\'%s\', ExceptionDepth=%d', 
     70        mysql_query(sprintf('INSERT INTO BlackBox_Exceptions SET ReportID=%d, ExceptionType=\'%s\', ExceptionDepth=%d', 
    7171            $reportId, mysql_real_escape_string($exception['exception']), $exceptionDepth)); 
    7272        if (mysql_affected_rows() != 1) 
     
    9494            } 
    9595             
    96             mysql_query(sprintf('INSERT INTO BlackBoxStackFrames SET 
     96            mysql_query(sprintf('INSERT INTO BlackBox_StackFrames SET 
    9797                ExceptionID=%d, StackFrameIndex=%d, Function=\'%s\', File=%s, Line=%s', 
    9898                $exceptionId, $stackIndex, mysql_real_escape_string($function), 
Note: See TracChangeset for help on using the changeset viewer.