BOINC / boinc

html/ops/dbinfo.php

Indentation +118 added lines, -118 removed lines

@@ -15,10 +15,10 @@ 
     function __construct($n, $d, $i, $t, $r, $s) {
         $this->name = $n;
         $this->data_size = $d;
-		$this->index_size = $i;
-		$this->total_size = $t;
-		$this->rows = $r;
-		$this->size_per_row = $s;
+        $this->index_size = $i;
+        $this->total_size = $t;
+        $this->rows = $r;
+        $this->size_per_row = $s;
     }
     function __destruct() {
     }
@@ -42,40 +42,40 @@ 
 
 // returns formatted data size
 function size_format($size){
-	$retval = 0;
+    $retval = 0;
 
-	$KB = 1024;
+    $KB = 1024;
     $MB = 1024*1024;
     $GB = 1024*1024*1024;
-	$TB = 1024*1024*1024*1024;
+    $TB = 1024*1024*1024*1024;
 	
     if ($size < $KB) {
-	    $retval = $size;
+        $retval = $size;
     } elseif (($size > $KB) && ($size < $MB)) {
-		$retval = sprintf("%.0fK", ($size / $KB));    
+        $retval = sprintf("%.0fK", ($size / $KB));    
     } elseif ( ($size >= $MB) && ($size < $GB)) {
-		$retval = sprintf("%.2fMB", ($size / $MB));
+        $retval = sprintf("%.2fMB", ($size / $MB));
     } elseif ( ($size >= $GB) && ($size < $TB)) {
-		$retval = sprintf("%.2fGB", ($size / $GB));
-	} elseif ( $size >= $TB ) {
-		$retval = sprintf("%.2fTB", ($size / $TB));
-	}
-	return $retval;
+        $retval = sprintf("%.2fGB", ($size / $GB));
+    } elseif ( $size >= $TB ) {
+        $retval = sprintf("%.2fTB", ($size / $TB));
+    }
+    return $retval;
 }
 
 
 // returns the DB data structure as DB_REC
 function get_db_info($db_name) 
 {
-	// Carl grabbed this from the mysql.com boards http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html  
+    // Carl grabbed this from the mysql.com boards http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html  
     $result = _mysql_query("SHOW TABLE STATUS FROM $db_name");
 
     // SQL output
     // mysql> show table status from [table_name];
     // | Name | Engine | Version | Row_format | Rows    
-	// | Avg_row_length | Data_length | Max_data_length  
-	// | Index_length | Data_free  | Auto_increment | Create_time         
-	// | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+    // | Avg_row_length | Data_length | Max_data_length  
+    // | Index_length | Data_free  | Auto_increment | Create_time         
+    // | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
     //
 
     $gdata  = 0;
@@ -83,24 +83,24 @@ 
     $gtotal = 0;
     $grows  = 0;
 
-	$i = 0;
-	$db_rec = array();
-	while($myarr = _mysql_fetch_assoc($result)) {
+    $i = 0;
+    $db_rec = array();
+    while($myarr = _mysql_fetch_assoc($result)) {
 
-		// sum grand totals
-		$total  =  $myarr["Data_length"] + $myarr["Index_length"];
-		$gindex += $myarr["Index_length"];
+        // sum grand totals
+        $total  =  $myarr["Data_length"] + $myarr["Index_length"];
+        $gindex += $myarr["Index_length"];
         $gdata  += $myarr["Data_length"];
-		$grows  += $myarr["Rows"]; 
-		$gtotal += $total;
+        $grows  += $myarr["Rows"]; 
+        $gtotal += $total;
  
-	    $db_rec[$i] = new DB_REC ($myarr["Name"], $myarr["Data_length"], $myarr["Index_length"], $total, $myarr["Rows"], $myarr["Avg_row_length"] );	
-		$i++;
-	}
+        $db_rec[$i] = new DB_REC ($myarr["Name"], $myarr["Data_length"], $myarr["Index_length"], $total, $myarr["Rows"], $myarr["Avg_row_length"] );	
+        $i++;
+    }
 
     $db_rec[$i] = new DB_REC ("Total", $gdata, $gindex, $gtotal, $grows, "" );	
 
-	return $db_rec;
+    return $db_rec;
 }
 
 
@@ -108,41 +108,41 @@ 
 function show_db_info($db_name, $db_rec) 
 { 
 
-	echo "<table cols=6>";
-	echo "<tr>";
-	echo "<th colspan=6> Database $db_name </th>";
-	echo "</tr>";
-
-	echo "<tr>";
-	echo "<th>Table</th>";
-	echo "<th>Data Size</th>";
-	echo "<th>Index Size</th>";
-	echo "<th>Total Size</th>";
-	echo "<th>Total Rows</th>";
-	echo "<th>Avg. Size per Row</th>";
-	echo "</tr>";
-
-	for ($i = 0; $i < sizeof($db_rec)-1; $i++){ 
-		echo "<tr>";
-		echo "<td align=left valign=top class=fieldname>" . $db_rec[$i]->name . "</td>";
-		echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->data_size)  . "</td>";
-		echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->index_size) . "</td>";
-		echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->total_size) . "</td>";
+    echo "<table cols=6>";
+    echo "<tr>";
+    echo "<th colspan=6> Database $db_name </th>";
+    echo "</tr>";
+
+    echo "<tr>";
+    echo "<th>Table</th>";
+    echo "<th>Data Size</th>";
+    echo "<th>Index Size</th>";
+    echo "<th>Total Size</th>";
+    echo "<th>Total Rows</th>";
+    echo "<th>Avg. Size per Row</th>";
+    echo "</tr>";
+
+    for ($i = 0; $i < sizeof($db_rec)-1; $i++){ 
+        echo "<tr>";
+        echo "<td align=left valign=top class=fieldname>" . $db_rec[$i]->name . "</td>";
+        echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->data_size)  . "</td>";
+        echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->index_size) . "</td>";
+        echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->total_size) . "</td>";
         echo "<td align=left valign=top class=fieldname>" . number_format($db_rec[$i]->rows)     . "</td>";
         echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->size_per_row) . "</td>";
-		echo "</tr>";
-	}
+        echo "</tr>";
+    }
 
-	// Last record is just a summary
-	$i = sizeof($db_rec)-1;
-	echo "<tr>";
+    // Last record is just a summary
+    $i = sizeof($db_rec)-1;
+    echo "<tr>";
     echo "<th align=left>" . $db_rec[$i]->name . "</th>";
     echo "<th align=left>" . size_format($db_rec[$i]->data_size)  . "</th>";
     echo "<th align=left>" . size_format($db_rec[$i]->index_size) . "</th>";
     echo "<th align=left>" . size_format($db_rec[$i]->total_size) . "</th>";
     echo "<th align=left>" . number_format($db_rec[$i]->rows)     . "</th>";
     echo "<th align=left></th>";
-	echo "</tr>";
+    echo "</tr>";
 
     echo "</table>";
 }
@@ -152,80 +152,80 @@ 
 // NB: same as show_db_info but with sortable cloumns
 function sort_db_info($db_name, $db_rec) 
 { 
-	// sort 
-	$file_list = array();
+    // sort 
+    $file_list = array();
     $file_sort = array();
 
-	$sort =  get_str("sort", true);
-	$r = get_str("r", true);
-
-	// check if its empty
-	if(empty($sort)) $sort = "name";
-	// check for allowed keys 
-	if ((strcmp($sort, "name")!=0) && 
-		(strcmp($sort, "data_size")!=0) && 
-		(strcmp($sort, "index_size")!=0) && 
-		(strcmp($sort, "total_size")!=0)  && 
-		(strcmp($sort, "rows")!=0) && 
-		(strcmp($sort, "size_per_row")!=0)) 
-		$sort = "name";
-	if(empty($r)) $r=0;
-
-	for ($i = 0; $i < sizeof($db_rec)-1; $i++){
-		$file_details["name"]         = $db_rec[$i]->name;
-		$file_details["data_size"]    = $db_rec[$i]->data_size;
-		$file_details["index_size"]   = $db_rec[$i]->index_size;
-		$file_details["total_size"]   = $db_rec[$i]->total_size;
-	    $file_details["rows"]         = $db_rec[$i]->rows;
-		$file_details["size_per_row"] = $db_rec[$i]->size_per_row;
-
-		$file_list[$i] = $file_details;
-		$key = strtolower($file_details[$sort]);
-		$file_sort[$i] = $key;
-	}
+    $sort =  get_str("sort", true);
+    $r = get_str("r", true);
+
+    // check if its empty
+    if(empty($sort)) $sort = "name";
+    // check for allowed keys 
+    if ((strcmp($sort, "name")!=0) && 
+        (strcmp($sort, "data_size")!=0) && 
+        (strcmp($sort, "index_size")!=0) && 
+        (strcmp($sort, "total_size")!=0)  && 
+        (strcmp($sort, "rows")!=0) && 
+        (strcmp($sort, "size_per_row")!=0)) 
+        $sort = "name";
+    if(empty($r)) $r=0;
+
+    for ($i = 0; $i < sizeof($db_rec)-1; $i++){
+        $file_details["name"]         = $db_rec[$i]->name;
+        $file_details["data_size"]    = $db_rec[$i]->data_size;
+        $file_details["index_size"]   = $db_rec[$i]->index_size;
+        $file_details["total_size"]   = $db_rec[$i]->total_size;
+        $file_details["rows"]         = $db_rec[$i]->rows;
+        $file_details["size_per_row"] = $db_rec[$i]->size_per_row;
+
+        $file_list[$i] = $file_details;
+        $key = strtolower($file_details[$sort]);
+        $file_sort[$i] = $key;
+    }
 	
-	if($r)arsort($file_sort);
+    if($r)arsort($file_sort);
     else  asort($file_sort);
-	// -- end sort 
-
-	echo "<table cols=6>";
-	echo "<tr>";
-	echo "<th colspan=6> Database $db_name </th>";
-	echo "</tr>";
-
-	echo "<tr>";
-	echo "<th><a href='dbinfo.php?sort=name&r=" . (!$r) . "'>Table </a></th>";
-	echo "<th><a href='dbinfo.php?sort=data_size&r=" . (!$r) . "'>Data Size</a></th>";
-	echo "<th><a href='dbinfo.php?sort=index_size&r=" . (!$r) . "'>Index Size</a></th>";
-	echo "<th><a href='dbinfo.php?sort=total_size&r=" . (!$r) . "'>Total Size</a></th>";
-	echo "<th><a href='dbinfo.php?sort=rows&r=" . (!$r) . "'>Total Rows</a></th>";
-	echo "<th><a href='dbinfo.php?sort=size_per_row&r=" . (!$r) . "'>Avg. Size per Row</a></th>";
-	echo "</tr>";
-
-	$i = 0;
-	while ( list($key, $value) = each($file_sort) ) {
-		$value = $file_list[$key];
-		echo "<tr>"; 
-		echo "<td align=left valign=top class=fieldname>" . $value["name"] . "</td>";
-		echo "<td align=left valign=top class=fieldname>" . size_format($value["data_size"])  . "</td>";
-		echo "<td align=left valign=top class=fieldname>" . size_format($value["index_size"]) . "</td>";
-		echo "<td align=left valign=top class=fieldname>" . size_format($value["total_size"]) . "</td>";
+    // -- end sort 
+
+    echo "<table cols=6>";
+    echo "<tr>";
+    echo "<th colspan=6> Database $db_name </th>";
+    echo "</tr>";
+
+    echo "<tr>";
+    echo "<th><a href='dbinfo.php?sort=name&r=" . (!$r) . "'>Table </a></th>";
+    echo "<th><a href='dbinfo.php?sort=data_size&r=" . (!$r) . "'>Data Size</a></th>";
+    echo "<th><a href='dbinfo.php?sort=index_size&r=" . (!$r) . "'>Index Size</a></th>";
+    echo "<th><a href='dbinfo.php?sort=total_size&r=" . (!$r) . "'>Total Size</a></th>";
+    echo "<th><a href='dbinfo.php?sort=rows&r=" . (!$r) . "'>Total Rows</a></th>";
+    echo "<th><a href='dbinfo.php?sort=size_per_row&r=" . (!$r) . "'>Avg. Size per Row</a></th>";
+    echo "</tr>";
+
+    $i = 0;
+    while ( list($key, $value) = each($file_sort) ) {
+        $value = $file_list[$key];
+        echo "<tr>"; 
+        echo "<td align=left valign=top class=fieldname>" . $value["name"] . "</td>";
+        echo "<td align=left valign=top class=fieldname>" . size_format($value["data_size"])  . "</td>";
+        echo "<td align=left valign=top class=fieldname>" . size_format($value["index_size"]) . "</td>";
+        echo "<td align=left valign=top class=fieldname>" . size_format($value["total_size"]) . "</td>";
         echo "<td align=left valign=top class=fieldname>" . number_format($value["rows"])     . "</td>";
         echo "<td align=left valign=top class=fieldname>" . size_format($value["size_per_row"]) . "</td>";
-		echo "</tr>";
-		$i++;
-	}
+        echo "</tr>";
+        $i++;
+    }
 
-	// Last record is just a summary
-	$i = sizeof($db_rec)-1;
-	echo "<tr>";
+    // Last record is just a summary
+    $i = sizeof($db_rec)-1;
+    echo "<tr>";
     echo "<th align=left>" . $db_rec[$i]->name . "</th>";
     echo "<th align=left>" . size_format($db_rec[$i]->data_size)  . "</th>";
     echo "<th align=left>" . size_format($db_rec[$i]->index_size) . "</th>";
     echo "<th align=left>" . size_format($db_rec[$i]->total_size) . "</th>";
     echo "<th align=left>" . number_format($db_rec[$i]->rows)     . "</th>";
     echo "<th align=left></th>";
-	echo "</tr>";
+    echo "</tr>";
 
     echo "</table>";
 }

Spacing +57 added lines, -57 removed lines

@@ -41,7 +41,7 @@ 
 
 
 // returns formatted data size
-function size_format($size){
+function size_format($size) {
 	$retval = 0;
 
 	$KB = 1024;
@@ -52,13 +52,13 @@ 
     if ($size < $KB) {
 	    $retval = $size;
     } elseif (($size > $KB) && ($size < $MB)) {
-		$retval = sprintf("%.0fK", ($size / $KB));    
-    } elseif ( ($size >= $MB) && ($size < $GB)) {
-		$retval = sprintf("%.2fMB", ($size / $MB));
-    } elseif ( ($size >= $GB) && ($size < $TB)) {
-		$retval = sprintf("%.2fGB", ($size / $GB));
-	} elseif ( $size >= $TB ) {
-		$retval = sprintf("%.2fTB", ($size / $TB));
+		$retval = sprintf("%.0fK", ($size/$KB));    
+    } elseif (($size >= $MB) && ($size < $GB)) {
+		$retval = sprintf("%.2fMB", ($size/$MB));
+    } elseif (($size >= $GB) && ($size < $TB)) {
+		$retval = sprintf("%.2fGB", ($size/$GB));
+	} elseif ($size >= $TB) {
+		$retval = sprintf("%.2fTB", ($size/$TB));
 	}
 	return $retval;
 }
@@ -85,20 +85,20 @@ 
 
 	$i = 0;
 	$db_rec = array();
-	while($myarr = _mysql_fetch_assoc($result)) {
+	while ($myarr = _mysql_fetch_assoc($result)) {
 
 		// sum grand totals
-		$total  =  $myarr["Data_length"] + $myarr["Index_length"];
+		$total = $myarr["Data_length"] + $myarr["Index_length"];
 		$gindex += $myarr["Index_length"];
-        $gdata  += $myarr["Data_length"];
+        $gdata += $myarr["Data_length"];
 		$grows  += $myarr["Rows"]; 
 		$gtotal += $total;
  
-	    $db_rec[$i] = new DB_REC ($myarr["Name"], $myarr["Data_length"], $myarr["Index_length"], $total, $myarr["Rows"], $myarr["Avg_row_length"] );	
+	    $db_rec[$i] = new DB_REC($myarr["Name"], $myarr["Data_length"], $myarr["Index_length"], $total, $myarr["Rows"], $myarr["Avg_row_length"]);	
 		$i++;
 	}
 
-    $db_rec[$i] = new DB_REC ("Total", $gdata, $gindex, $gtotal, $grows, "" );	
+    $db_rec[$i] = new DB_REC("Total", $gdata, $gindex, $gtotal, $grows, "");	
 
 	return $db_rec;
 }
@@ -122,25 +122,25 @@ 
 	echo "<th>Avg. Size per Row</th>";
 	echo "</tr>";
 
-	for ($i = 0; $i < sizeof($db_rec)-1; $i++){ 
+	for ($i = 0; $i < sizeof($db_rec) - 1; $i++) { 
 		echo "<tr>";
-		echo "<td align=left valign=top class=fieldname>" . $db_rec[$i]->name . "</td>";
-		echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->data_size)  . "</td>";
-		echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->index_size) . "</td>";
-		echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->total_size) . "</td>";
-        echo "<td align=left valign=top class=fieldname>" . number_format($db_rec[$i]->rows)     . "</td>";
-        echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->size_per_row) . "</td>";
+		echo "<td align=left valign=top class=fieldname>".$db_rec[$i]->name."</td>";
+		echo "<td align=left valign=top class=fieldname>".size_format($db_rec[$i]->data_size)."</td>";
+		echo "<td align=left valign=top class=fieldname>".size_format($db_rec[$i]->index_size)."</td>";
+		echo "<td align=left valign=top class=fieldname>".size_format($db_rec[$i]->total_size)."</td>";
+        echo "<td align=left valign=top class=fieldname>".number_format($db_rec[$i]->rows)."</td>";
+        echo "<td align=left valign=top class=fieldname>".size_format($db_rec[$i]->size_per_row)."</td>";
 		echo "</tr>";
 	}
 
 	// Last record is just a summary
-	$i = sizeof($db_rec)-1;
+	$i = sizeof($db_rec) - 1;
 	echo "<tr>";
-    echo "<th align=left>" . $db_rec[$i]->name . "</th>";
-    echo "<th align=left>" . size_format($db_rec[$i]->data_size)  . "</th>";
-    echo "<th align=left>" . size_format($db_rec[$i]->index_size) . "</th>";
-    echo "<th align=left>" . size_format($db_rec[$i]->total_size) . "</th>";
-    echo "<th align=left>" . number_format($db_rec[$i]->rows)     . "</th>";
+    echo "<th align=left>".$db_rec[$i]->name."</th>";
+    echo "<th align=left>".size_format($db_rec[$i]->data_size)."</th>";
+    echo "<th align=left>".size_format($db_rec[$i]->index_size)."</th>";
+    echo "<th align=left>".size_format($db_rec[$i]->total_size)."</th>";
+    echo "<th align=left>".number_format($db_rec[$i]->rows)."</th>";
     echo "<th align=left></th>";
 	echo "</tr>";
 
@@ -156,27 +156,27 @@ 
 	$file_list = array();
     $file_sort = array();
 
-	$sort =  get_str("sort", true);
+	$sort = get_str("sort", true);
 	$r = get_str("r", true);
 
 	// check if its empty
-	if(empty($sort)) $sort = "name";
+	if (empty($sort)) $sort = "name";
 	// check for allowed keys 
-	if ((strcmp($sort, "name")!=0) && 
-		(strcmp($sort, "data_size")!=0) && 
-		(strcmp($sort, "index_size")!=0) && 
-		(strcmp($sort, "total_size")!=0)  && 
-		(strcmp($sort, "rows")!=0) && 
-		(strcmp($sort, "size_per_row")!=0)) 
+	if ((strcmp($sort, "name") != 0) && 
+		(strcmp($sort, "data_size") != 0) && 
+		(strcmp($sort, "index_size") != 0) && 
+		(strcmp($sort, "total_size") != 0) && 
+		(strcmp($sort, "rows") != 0) && 
+		(strcmp($sort, "size_per_row") != 0)) 
 		$sort = "name";
-	if(empty($r)) $r=0;
+	if (empty($r)) $r = 0;
 
-	for ($i = 0; $i < sizeof($db_rec)-1; $i++){
+	for ($i = 0; $i < sizeof($db_rec) - 1; $i++) {
 		$file_details["name"]         = $db_rec[$i]->name;
 		$file_details["data_size"]    = $db_rec[$i]->data_size;
 		$file_details["index_size"]   = $db_rec[$i]->index_size;
 		$file_details["total_size"]   = $db_rec[$i]->total_size;
-	    $file_details["rows"]         = $db_rec[$i]->rows;
+	    $file_details["rows"] = $db_rec[$i]->rows;
 		$file_details["size_per_row"] = $db_rec[$i]->size_per_row;
 
 		$file_list[$i] = $file_details;
@@ -184,7 +184,7 @@ 
 		$file_sort[$i] = $key;
 	}
 	
-	if($r)arsort($file_sort);
+	if ($r)arsort($file_sort);
     else  asort($file_sort);
 	// -- end sort 
 
@@ -194,36 +194,36 @@ 
 	echo "</tr>";
 
 	echo "<tr>";
-	echo "<th><a href='dbinfo.php?sort=name&r=" . (!$r) . "'>Table </a></th>";
-	echo "<th><a href='dbinfo.php?sort=data_size&r=" . (!$r) . "'>Data Size</a></th>";
-	echo "<th><a href='dbinfo.php?sort=index_size&r=" . (!$r) . "'>Index Size</a></th>";
-	echo "<th><a href='dbinfo.php?sort=total_size&r=" . (!$r) . "'>Total Size</a></th>";
-	echo "<th><a href='dbinfo.php?sort=rows&r=" . (!$r) . "'>Total Rows</a></th>";
-	echo "<th><a href='dbinfo.php?sort=size_per_row&r=" . (!$r) . "'>Avg. Size per Row</a></th>";
+	echo "<th><a href='dbinfo.php?sort=name&r=".(!$r)."'>Table </a></th>";
+	echo "<th><a href='dbinfo.php?sort=data_size&r=".(!$r)."'>Data Size</a></th>";
+	echo "<th><a href='dbinfo.php?sort=index_size&r=".(!$r)."'>Index Size</a></th>";
+	echo "<th><a href='dbinfo.php?sort=total_size&r=".(!$r)."'>Total Size</a></th>";
+	echo "<th><a href='dbinfo.php?sort=rows&r=".(!$r)."'>Total Rows</a></th>";
+	echo "<th><a href='dbinfo.php?sort=size_per_row&r=".(!$r)."'>Avg. Size per Row</a></th>";
 	echo "</tr>";
 
 	$i = 0;
-	while ( list($key, $value) = each($file_sort) ) {
+	while (list($key, $value) = each($file_sort)) {
 		$value = $file_list[$key];
 		echo "<tr>"; 
-		echo "<td align=left valign=top class=fieldname>" . $value["name"] . "</td>";
-		echo "<td align=left valign=top class=fieldname>" . size_format($value["data_size"])  . "</td>";
-		echo "<td align=left valign=top class=fieldname>" . size_format($value["index_size"]) . "</td>";
-		echo "<td align=left valign=top class=fieldname>" . size_format($value["total_size"]) . "</td>";
-        echo "<td align=left valign=top class=fieldname>" . number_format($value["rows"])     . "</td>";
-        echo "<td align=left valign=top class=fieldname>" . size_format($value["size_per_row"]) . "</td>";
+		echo "<td align=left valign=top class=fieldname>".$value["name"]."</td>";
+		echo "<td align=left valign=top class=fieldname>".size_format($value["data_size"])."</td>";
+		echo "<td align=left valign=top class=fieldname>".size_format($value["index_size"])."</td>";
+		echo "<td align=left valign=top class=fieldname>".size_format($value["total_size"])."</td>";
+        echo "<td align=left valign=top class=fieldname>".number_format($value["rows"])."</td>";
+        echo "<td align=left valign=top class=fieldname>".size_format($value["size_per_row"])."</td>";
 		echo "</tr>";
 		$i++;
 	}
 
 	// Last record is just a summary
-	$i = sizeof($db_rec)-1;
+	$i = sizeof($db_rec) - 1;
 	echo "<tr>";
-    echo "<th align=left>" . $db_rec[$i]->name . "</th>";
-    echo "<th align=left>" . size_format($db_rec[$i]->data_size)  . "</th>";
-    echo "<th align=left>" . size_format($db_rec[$i]->index_size) . "</th>";
-    echo "<th align=left>" . size_format($db_rec[$i]->total_size) . "</th>";
-    echo "<th align=left>" . number_format($db_rec[$i]->rows)     . "</th>";
+    echo "<th align=left>".$db_rec[$i]->name."</th>";
+    echo "<th align=left>".size_format($db_rec[$i]->data_size)."</th>";
+    echo "<th align=left>".size_format($db_rec[$i]->index_size)."</th>";
+    echo "<th align=left>".size_format($db_rec[$i]->total_size)."</th>";
+    echo "<th align=left>".number_format($db_rec[$i]->rows)."</th>";
     echo "<th align=left></th>";
 	echo "</tr>";
 

Braces +6 added lines, -9 removed lines

@@ -41,7 +41,7 @@ 
 
 
 // returns formatted data size
-function size_format($size){
+function size_format($size) {
 	$retval = 0;
 
 	$KB = 1024;
@@ -65,8 +65,7 @@ 
 
 
 // returns the DB data structure as DB_REC
-function get_db_info($db_name) 
-{
+function get_db_info($db_name) {
 	// Carl grabbed this from the mysql.com boards http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html  
     $result = _mysql_query("SHOW TABLE STATUS FROM $db_name");
 
@@ -105,8 +104,7 @@ 
 
 
 // shows the plain db structure
-function show_db_info($db_name, $db_rec) 
-{ 
+function show_db_info($db_name, $db_rec) {
 
 	echo "<table cols=6>";
 	echo "<tr>";
@@ -122,7 +120,7 @@ 
 	echo "<th>Avg. Size per Row</th>";
 	echo "</tr>";
 
-	for ($i = 0; $i < sizeof($db_rec)-1; $i++){ 
+	for ($i = 0; $i < sizeof($db_rec)-1; $i++) {
 		echo "<tr>";
 		echo "<td align=left valign=top class=fieldname>" . $db_rec[$i]->name . "</td>";
 		echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->data_size)  . "</td>";
@@ -150,8 +148,7 @@ 
 
 
 // NB: same as show_db_info but with sortable cloumns
-function sort_db_info($db_name, $db_rec) 
-{ 
+function sort_db_info($db_name, $db_rec) {
 	// sort 
 	$file_list = array();
     $file_sort = array();
@@ -171,7 +168,7 @@ 
 		$sort = "name";
 	if(empty($r)) $r=0;
 
-	for ($i = 0; $i < sizeof($db_rec)-1; $i++){
+	for ($i = 0; $i < sizeof($db_rec)-1; $i++) {
 		$file_details["name"]         = $db_rec[$i]->name;
 		$file_details["data_size"]    = $db_rec[$i]->data_size;
 		$file_details["index_size"]   = $db_rec[$i]->index_size;

html/ops/bossa_example_make_files.php

Spacing +5 added lines, -5 removed lines

@@ -32,7 +32,7 @@ 
     $mid = 200;
     $lo = $mid - $range;
     $hi = $mid + $range;
-    return imagecolorallocate($im, rand($lo,$hi), rand($lo,$hi), rand($lo,$hi));
+    return imagecolorallocate($im, rand($lo, $hi), rand($lo, $hi), rand($lo, $hi));
 }
 
 function add_ellipse($im, $case) {
@@ -46,14 +46,14 @@ 
     $cy = rand(-100, 400);
     $w = rand(50, 100);
     $h = rand(50, 100);
-    imagefilledrectangle($im, $cx, $cy, $cx+$w, $cy+$h, rand_color($im, 50));
+    imagefilledrectangle($im, $cx, $cy, $cx + $w, $cy + $h, rand_color($im, 50));
 }
 
 
 function make_image($case) {
     $im = imagecreatetruecolor(600, 400);
     imagefill($im, 0, 0, imagecolorallocate($im, 255, 255, 255));
-    for ($i=0; $i<400; $i++) {
+    for ($i = 0; $i < 400; $i++) {
         add_rect($im);
     }
     $im2 = imagecreatetruecolor(600, 400);
@@ -85,7 +85,7 @@ 
 $nfiles = 0;
 $dir = null;
 $ellipse_frac = 0.5;
-for ($i=1; $i<$argc; $i++) {
+for ($i = 1; $i < $argc; $i++) {
     if ($argv[$i] == '--nfiles') $nfiles = $argv[++$i];
     elseif ($argv[$i] == '--dir') $dir = $argv[++$i];
     elseif ($argv[$i] == '--ellipse_frac') $ellipse_frac = $argv[++$i];
@@ -99,7 +99,7 @@ 
     exit("$dir is not a directory\n");
 }
 
-for ($i=0; $i<$nfiles; $i++) {
+for ($i = 0; $i < $nfiles; $i++) {
     $path = "$dir/$i.png";
     $anspath = "$dir/$i.ans";
     $case = make_test_case($ellipse_frac);

html/ops/db_schemaversion.php

Indentation +1 added lines, -1 removed lines

@@ -28,7 +28,7 @@
 $updates = array();
 foreach ($db_updates as $db_update) {
     if ($db_update[0] > $db_revision) {
-		$db_revision = $db_update[0];
+        $db_revision = $db_update[0];
     }
 }
 

Spacing +1 added lines, -1 removed lines

@@ -21,7 +21,7 @@
 
 $db_revision = 0;
 if (file_exists("../../db_revision")) {
-    $db_revision = (int) file_get_contents("../../db_revision");
+    $db_revision = (int)file_get_contents("../../db_revision");
 }
 require_once("db_update.php");
 

html/ops/bbcode_convert_response2.php

Spacing +4 added lines, -4 removed lines

@@ -42,15 +42,15 @@
     $start_id = 0; //Set this to something else if you like
     $profiles = _mysql_query("select * from profile where userid>$start_id order by userid");
     echo _mysql_error();
-    $i=0;
-    while ($profile = _mysql_fetch_object($profiles)){
+    $i = 0;
+    while ($profile = _mysql_fetch_object($profiles)) {
         $i++; 
         if ($i%100 == 0) {                      //For every 100 profiles
-            echo $profile->userid.". "; flush();   // print out where we are
+            echo $profile->userid.". "; flush(); // print out where we are
             //usleep(200000);
         }
         
-        if ($profile->userid > $start_id){
+        if ($profile->userid > $start_id) {
             fix_profile($profile);
         }
     }

Braces +4 added lines, -3 removed lines

@@ -43,14 +43,15 @@
     $profiles = _mysql_query("select * from profile where userid>$start_id order by userid");
     echo _mysql_error();
     $i=0;
-    while ($profile = _mysql_fetch_object($profiles)){
+    while ($profile = _mysql_fetch_object($profiles)) {
         $i++; 
-        if ($i%100 == 0) {                      //For every 100 profiles
+        if ($i%100 == 0) {
+//For every 100 profiles
             echo $profile->userid.". "; flush();   // print out where we are
             //usleep(200000);
         }
         
-        if ($profile->userid > $start_id){
+        if ($profile->userid > $start_id) {
             fix_profile($profile);
         }
     }

html/ops/pass_percentage_by_platform.php

Spacing +1 added lines, -1 removed lines

@@ -197,5 +197,5 @@
 
 admin_page_tail();
 
-$cvs_version_tracker[]="\$Id$";  //Generated automatically - do not edit
+$cvs_version_tracker[] = "\$Id$"; //Generated automatically - do not edit
 ?>

html/ops/manage_user.php

Spacing +24 added lines, -24 removed lines

@@ -39,8 +39,8 @@ 
 
 // Delete a user if they have no credit, results, or posts
 //
-function possibly_delete_user($user){
-    if ($user->total_credit > 0.0){
+function possibly_delete_user($user) {
+    if ($user->total_credit > 0.0) {
         admin_error_page("Cannot delete user: User has credit.");
     }  
 
@@ -56,7 +56,7 @@ 
         admin_error_page("Cannot delete user: User has forum posts.");
     }
 
-    if ($user->teamid){
+    if ($user->teamid) {
         user_quit_team($user);
     }
     delete_user($user);
@@ -67,8 +67,8 @@ 
 function handle_special_user($user) {
     global $special_user_bitfield;
     $Nbf = sizeof($special_user_bitfield);
-    $bits="";
-    for ($i=0; $i<$Nbf; $i++) {
+    $bits = "";
+    for ($i = 0; $i < $Nbf; $i++) {
         $key = "special_user_$i";
         if (array_key_exists($key, $_POST) && $_POST[$key]) {
             $bits .= "1";
@@ -94,35 +94,35 @@ 
         );
     } else {
         if (is_numeric($dt)) {
-            $t = $dt>0 ? time()+$dt : 0;
+            $t = $dt > 0 ? time() + $dt : 0;
             $q = "UPDATE forum_preferences SET banished_until=$t WHERE userid=$user->id";
             _mysql_query($q);
 
             // put a timestamp in wiki to trigger re-validation of credentials
 
-            if (function_exists('touch_wiki_user')){
+            if (function_exists('touch_wiki_user')) {
                 touch_wiki_user($user);  
             }
 
             // Send suspension e-mail to user and administrators
 
-            if ($dt>0) {
-                $subject = PROJECT." posting privileges suspended for ". $user->name;
+            if ($dt > 0) {
+                $subject = PROJECT." posting privileges suspended for ".$user->name;
                 $body = "
-Forum posting privileges for the " .PROJECT. " user \"".$user->name."\"
-have been suspended for " .time_diff($dt). " by ".$g_logged_in_user->name.". 
+Forum posting privileges for the " .PROJECT." user \"".$user->name."\"
+have been suspended for " .time_diff($dt)." by ".$g_logged_in_user->name.". 
 The reason given was:
 
 $reason
 
-The suspension will end at " .time_str($t)."\n";
+The suspension will end at ".time_str($t)."\n";
             } else {
-                $subject = PROJECT." user ". $user->name. " unsuspended";
+                $subject = PROJECT." user ".$user->name." unsuspended";
                 $body = "
-Forum posting privileges for the " .PROJECT. " user \"".$user->name."\"
+Forum posting privileges for the " .PROJECT." user \"".$user->name."\"
 have been restored by ".$g_logged_in_user->name."\n";
                 if ($reason) {
-                    $body.="The reason given was:\n\n   $reason\n";
+                    $body .= "The reason given was:\n\n   $reason\n";
                 }
             }
 
@@ -186,13 +186,13 @@ 
     row1("Special User Status");
 
     echo "<tr>\n";
-    for ($i=0; $i<$Nbf; $i++) {
+    for ($i = 0; $i < $Nbf; $i++) {
         $bit = substr($user->prefs->special_user, $i, 1);
         echo "<tr><td><input type='checkbox'' name='special_user_".$i."' value='1'";
         if ($bit == 1) {
             echo " checked='checked'";
         }
-        echo ">". $special_user_bitfield[$i] ."</td></tr>\n";
+        echo ">".$special_user_bitfield[$i]."</td></tr>\n";
     }
     echo "</tr>";
 
@@ -217,10 +217,10 @@ 
     if ($user->prefs->banished_until) {
         $dt = $user->prefs->banished_until - time();
         if ($dt > 0) {
-            $x = " Suspended until " . time_str($user->prefs->banished_until)
-                ."<br/> (Expires in " . time_diff($dt) .")" ;
+            $x = " Suspended until ".time_str($user->prefs->banished_until)
+                ."<br/> (Expires in ".time_diff($dt).")";
         } else {
-            $x = " last suspended " . time_str($user->prefs->banished_until);
+            $x = " last suspended ".time_str($user->prefs->banished_until);
         }
         row1($x);
     } else {
@@ -238,11 +238,11 @@ 
     ";
     echo "
         <input type='radio' name='suspend_for' value='172800'> 48 hours  <br/>
-        <input type='radio' name='suspend_for' value='",86400*7,"'> 1 week  <br/>
-        <input type='radio' name='suspend_for' value='",86400*14,"'> 2 weeks  <br/>
+        <input type='radio' name='suspend_for' value='",86400*7, "'> 1 week  <br/>
+        <input type='radio' name='suspend_for' value='",86400*14, "'> 2 weeks  <br/>
     ";
 
-    if ($dt>0) {
+    if ($dt > 0) {
         echo "
             <input type='radio' name='suspend_for' value='-1'>  <b>unsuspend</b>   <br/>";
     }
@@ -306,6 +306,6 @@ 
 
 show_manage_user_form($user);
 
-$cvs_version_tracker[]=        //Generated automatically - do not edit
+$cvs_version_tracker[] = //Generated automatically - do not edit
     "\$Id$"; 
 ?>

Braces +4 added lines, -4 removed lines

@@ -39,8 +39,8 @@ 
 
 // Delete a user if they have no credit, results, or posts
 //
-function possibly_delete_user($user){
-    if ($user->total_credit > 0.0){
+function possibly_delete_user($user) {
+    if ($user->total_credit > 0.0) {
         admin_error_page("Cannot delete user: User has credit.");
     }  
 
@@ -56,7 +56,7 @@ 
         admin_error_page("Cannot delete user: User has forum posts.");
     }
 
-    if ($user->teamid){
+    if ($user->teamid) {
         user_quit_team($user);
     }
     delete_user($user);
@@ -100,7 +100,7 @@ 
 
             // put a timestamp in wiki to trigger re-validation of credentials
 
-            if (function_exists('touch_wiki_user')){
+            if (function_exists('touch_wiki_user')) {
                 touch_wiki_user($user);  
             }
 

Upper-Lower-Casing +1 added lines, -1 removed lines

@@ -141,7 +141,7 @@
     global $special_user_bitfield;
     $Nbf = sizeof($special_user_bitfield);
 
-    admin_page_head("Management $user->name");
+    admin_page_head("management $user->name");
 
     if (!defined("POST_REPORT_EMAILS")) {
         echo "<p><font color='RED'>

html/ops/db_update.php

Spacing +5 added lines, -5 removed lines

@@ -274,7 +274,7 @@ 
     do_query("alter table host add max_results_day integer not null");
 }
 
-function update_4_20_2005(){
+function update_4_20_2005() {
     do_query("ALTER TABLE `thread` ADD `sticky` TINYINT UNSIGNED DEFAULT '0' NOT NULL");
     do_query("ALTER TABLE `forum` ADD `post_min_total_credit` INT NOT NULL AFTER `posts`");
     do_query("ALTER TABLE `forum` ADD `post_min_expavg_credit` INT NOT NULL AFTER `posts`");
@@ -284,7 +284,7 @@ 
     do_query("ALTER TABLE `forum_preferences` ADD `last_post` INT( 14 ) UNSIGNED NOT NULL AFTER `posts`");
 }
 
-function update_4_30_2005(){
+function update_4_30_2005() {
     do_query("ALTER TABLE `forum_preferences` ADD `ignore_sticky_posts` TINYINT( 1 ) UNSIGNED NOT NULL");
 }    
 
@@ -311,7 +311,7 @@ 
     do_query("update user set country='Macedonia' where country='Macedonia, The Former Yugoslav Republic of'");
 }
 
-function update_11_24_2005(){
+function update_11_24_2005() {
     do_query("ALTER TABLE `forum_preferences` ADD `minimum_wrap_postcount` INT DEFAULT '100' NOT NULL AFTER `high_rating_threshold` ,
 ADD `display_wrap_postcount` INT DEFAULT '75' NOT NULL AFTER `minimum_wrap_postcount`");
 }
@@ -616,7 +616,7 @@ 
     ");
 }
 
-function update_10_05_2008(){
+function update_10_05_2008() {
     do_query("alter table forum_preferences add highlight_special tinyint default '1' not null");
 }
 
@@ -1045,7 +1045,7 @@ 
 // This used to be the Subversion version#,
 // but with Git we just use sequential integers
 //
-$db_updates = array (
+$db_updates = array(
     array(18490, "update_6_16_2009"),
     array(19001, "update_9_3_2009"),
     array(20807, "update_3_5_2010"),

Braces +4 added lines, -4 removed lines

@@ -274,7 +274,7 @@ 
     do_query("alter table host add max_results_day integer not null");
 }
 
-function update_4_20_2005(){
+function update_4_20_2005() {
     do_query("ALTER TABLE `thread` ADD `sticky` TINYINT UNSIGNED DEFAULT '0' NOT NULL");
     do_query("ALTER TABLE `forum` ADD `post_min_total_credit` INT NOT NULL AFTER `posts`");
     do_query("ALTER TABLE `forum` ADD `post_min_expavg_credit` INT NOT NULL AFTER `posts`");
@@ -284,7 +284,7 @@ 
     do_query("ALTER TABLE `forum_preferences` ADD `last_post` INT( 14 ) UNSIGNED NOT NULL AFTER `posts`");
 }
 
-function update_4_30_2005(){
+function update_4_30_2005() {
     do_query("ALTER TABLE `forum_preferences` ADD `ignore_sticky_posts` TINYINT( 1 ) UNSIGNED NOT NULL");
 }    
 
@@ -311,7 +311,7 @@ 
     do_query("update user set country='Macedonia' where country='Macedonia, The Former Yugoslav Republic of'");
 }
 
-function update_11_24_2005(){
+function update_11_24_2005() {
     do_query("ALTER TABLE `forum_preferences` ADD `minimum_wrap_postcount` INT DEFAULT '100' NOT NULL AFTER `high_rating_threshold` ,
 ADD `display_wrap_postcount` INT DEFAULT '75' NOT NULL AFTER `minimum_wrap_postcount`");
 }
@@ -616,7 +616,7 @@ 
     ");
 }
 
-function update_10_05_2008(){
+function update_10_05_2008() {
     do_query("alter table forum_preferences add highlight_special tinyint default '1' not null");
 }
 

html/ops/test_job_file.php

Spacing +3 added lines, -3 removed lines

@@ -58,7 +58,7 @@ 
     $post = array();
     $post["request"] = $xml;
     if ($req->type == "upload") {
-        $i=0;
+        $i = 0;
         foreach ($files as $f) {
             if ($f['path'] != "") {
                 $post["file_$i"] = '@'.$f['path'];
@@ -70,9 +70,9 @@ 
     curl_setopt($ch, CURLOPT_POSTFIELDS, $post);
     $reply = curl_exec($ch);
     if ($reply) {
-        print $reply . "\n";
+        print $reply."\n";
     } else {
-        print curl_error($ch) . "\n";
+        print curl_error($ch)."\n";
     }
     curl_close($ch);
 }

html/ops/clear_host.php

Spacing +1 added lines, -1 removed lines

@@ -29,5 +29,5 @@
 echo "Host RPC time cleared for host ID: $hostid\n";
 
 admin_page_tail();
-$cvs_version_tracker[]="\$Id$";  //Generated automatically - do not edit
+$cvs_version_tracker[] = "\$Id$"; //Generated automatically - do not edit
 ?>