BOINC / boinc

html/ops/manage_special_users_action.php

Spacing +4 added lines, -4 removed lines

@@ -25,11 +25,11 @@ 
 
 $bitset = '';
 
-for ($i=0;$i<S_NFLAGS;$i++) {
+for ($i = 0; $i < S_NFLAGS; $i++) {
     if (post_int("role".$i, TRUE) == '1') {
-        $bitset = str_pad($bitset, $i+1, '1');
+        $bitset = str_pad($bitset, $i + 1, '1');
     } else {
-        $bitset = str_pad($bitset, $i+1, '0');
+        $bitset = str_pad($bitset, $i + 1, '0');
     }
 }
 if ($bitset == "0000000") $bitset = '';
@@ -50,5 +50,5 @@ 
 
 admin_page_tail();
 
-$cvs_version_tracker[]="\$Id$";  //Generated automatically - do not edit
+$cvs_version_tracker[] = "\$Id$"; //Generated automatically - do not edit
 ?>

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

@@ -26,7 +26,7 @@
 $bitset = '';
 
 for ($i=0;$i<S_NFLAGS;$i++) {
-    if (post_int("role".$i, TRUE) == '1') {
+    if (post_int("role".$i, true) == '1') {
         $bitset = str_pad($bitset, $i+1, '1');
     } else {
         $bitset = str_pad($bitset, $i+1, '0');

html/ops/create_forums.php

Spacing +3 added lines, -3 removed lines

@@ -41,10 +41,10 @@ 
     return $db->insert_id();
 }
 
-function create_forum($category, $orderID, $title, $description, $is_dev_blog=0) {
+function create_forum($category, $orderID, $title, $description, $is_dev_blog = 0) {
     $q = "(category, orderID, title, description, is_dev_blog) values ($category, $orderID, '$title', '$description', $is_dev_blog)";
     $db = BoincDB::get();
-    $result = $db->insert("forum",$q);
+    $result = $db->insert("forum", $q);
     if (!$result) {
         $forum = BoincForum::lookup("category=$category and title='$title'");
         if ($forum) return $forum->id;
@@ -72,5 +72,5 @@ 
 create_forum($catid, 4, "Preferences", "Using preferences");
 create_forum($catid, 6, "Web site", "Issues involving this web site");
 
-$cvs_version_tracker[]="\$Id$";  //Generated automatically - do not edit
+$cvs_version_tracker[] = "\$Id$"; //Generated automatically - do not edit
 ?>

html/ops/update_profile_pages.php

Indentation +1 added lines, -1 removed lines

@@ -200,7 +200,7 @@
         for ($row = 0; $row < $height; $row++) {
             echo "<tr>";
             for ($col = 0; $col < $width; $col++) {
-	            if ($count < $numIds) {
+                if ($count < $numIds) {
                     echo "<td class=\"bordered\" align=\"center\">
                         <a href=\"".secure_url_base()."view_profile.php?userid=".$userIds[$count]."\"><img src=\"".secure_url_base().IMAGE_URL.$userIds[$count]."_sm.jpg\"></a>
                     </td>";

Spacing +15 added lines, -15 removed lines

@@ -39,7 +39,7 @@ 
 
 // TODO: convert to new DB interface
 
-$alphabet = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','0','1','2','3','4','5','6','7','8','9');
+$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', '0', '1', '2', '3', '4', '5', '6', '7', '8', '9');
 
 
 // Builds a summary table of user profiles.
@@ -53,7 +53,7 @@ 
 function show_user_table($members, $offset, $numToDisplay, $cols) {
     start_table();
 
-    $rows = ceil($numToDisplay / $cols);
+    $rows = ceil($numToDisplay/$cols);
     $count = $offset;
     $numMembers = count($members);
 
@@ -151,7 +151,7 @@ 
     // Build an array of IDs of all users with pictures in their profiles.
     $userIds = array();
     $numIds = 0;
-    foreach($profiles as $profile) {
+    foreach ($profiles as $profile) {
         $user = BoincUser::lookup_id($profile->userid);
         if (!$user) continue; // maybe we should delete the profile if user is non-existent anymore?
         if ($user->name) {
@@ -171,7 +171,7 @@ 
 //        shuffle($userIds);
 //    }
 
-    $numPages = ceil(count($userIds)/($width * $height));
+    $numPages = ceil(count($userIds)/($width*$height));
 
     // Make sure that a page is generated even when no profiles with pictures
     // exist in order to avoid 404 errors from the profile_menu page.
@@ -185,7 +185,7 @@ 
     $count = 0;
 
     for ($page = 1; $page <= $numPages; $page++) {
-        $filename = PROFILE_PATH . "user_gallery_" . $page . ".html";
+        $filename = PROFILE_PATH."user_gallery_".$page.".html";
         open_output_buffer();
 
         page_head("Profile gallery: page $page of $numPages", null, false, "../");
@@ -244,7 +244,7 @@ 
     // of the userids who belong to those countries.
     // Format: array[country][index] = userid.
 
-    foreach($profiles as $profile) {
+    foreach ($profiles as $profile) {
         $user = BoincUser::lookup_id($profile->userid);
         if (!$user) continue; // maybe we should delete the profile if user is non-existent anymore?
         if ($user->country) {
@@ -264,7 +264,7 @@ 
     // TODO: Define a constant for the desired number of rows per page.
 
     foreach ($countries as $country) {
-        $baseFileName =  "profile_country_" . get_legal_filename($country);
+        $baseFileName = "profile_country_".get_legal_filename($country);
         build_profile_pages(
             $countryMembers[$country],
             "User Profiles from $country", 5, 2,
@@ -290,7 +290,7 @@ 
     $numIds = 0;
     $members = array();
 
-    foreach($profiles as $profile) {
+    foreach ($profiles as $profile) {
         $user = BoincUser::lookup_id($profile->userid);
         if (!$user) continue; // maybe we should delete the profile if user is non-existent anymore?
         if ($user->name) {
@@ -335,11 +335,11 @@ 
 function build_profile_pages(
     $members, $title, $rowsPerPage, $colsPerPage, $dir, $base_filename
 ) {
-    $numPerPage = $rowsPerPage * $colsPerPage;
-    $numPages = ceil(count($members) / $numPerPage);
+    $numPerPage = $rowsPerPage*$colsPerPage;
+    $numPages = ceil(count($members)/$numPerPage);
 
     for ($page = 1; $page <= $numPages; $page++) {
-        $filename = $dir . $base_filename . "_" . $page . ".html";
+        $filename = $dir.$base_filename."_".$page.".html";
         open_output_buffer();
 
         $pagetitle = $title.": Page $page of $numPages";
@@ -347,7 +347,7 @@ 
 
         echo "Last updated ", pretty_time_str(time()), "<p>\n";
 
-        $offset = (($page-1) * $rowsPerPage * $colsPerPage);
+        $offset = (($page - 1)*$rowsPerPage*$colsPerPage);
 
         show_user_table($members, $offset, $numPerPage, $colsPerPage);
 
@@ -364,11 +364,11 @@ 
     print_debug_msg("Beginning to build country summary page...");
     $countries = array_keys($countryMembers);
 
-    $filename = PROFILE_PATH . "profile_country.html";
+    $filename = PROFILE_PATH."profile_country.html";
     open_output_buffer();
 
     page_head("User Profiles by Country", null, null, "../");
-    echo "Last updated " . pretty_time_str(time()) . "<p>";
+    echo "Last updated ".pretty_time_str(time())."<p>";
 
     start_table();
     row_heading_array(array("Country", "Profiles"));
@@ -413,7 +413,7 @@ 
 
 $caching = true;
 
-if (@$argv[1]=="-d") $debug=true;
+if (@$argv[1] == "-d") $debug = true;
 
 build_country_pages();
 build_alpha_pages();

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

@@ -180,7 +180,7 @@
         $numPages = 1;
     }
 
-    print_debug_msg("Generating $numPages pages");
+    print_debug_msg("generating $numPages pages");
 
     $count = 0;
 

html/ops/analyze_coproc_log.php

Spacing +2 added lines, -2 removed lines

@@ -23,7 +23,7 @@ 
 // - daily total
 // - breakdown by desc (number, credit)
 
-ini_set ("memory_limit", "1G");
+ini_set("memory_limit", "1G");
 set_time_limit(0);
 
 $cli_only = true;
@@ -76,7 +76,7 @@ 
         add_to_array($days, $day, $granted);
     }
     $i++;
-    if ($i % 10000 == 0) echo "$i\n";
+    if ($i%10000 == 0) echo "$i\n";
 }
 
 uasort($hosts, "compare");

html/ops/make_emails_lowercase.php

Indentation +16 added lines, -16 removed lines

@@ -37,14 +37,14 @@ 
 
 // activate/deactivate script
 if (1) {
-  echo "
+    echo "
 This script needs to be activated before it can be run.
 Once you understand what the script does you can change the
 if (1) to if (0) at the top of the file to activate it.
 Be sure to deactivate the script after using it to make sure
 it is not accidentally run.
 ";
-  exit;
+    exit;
 }
 
 db_init();
@@ -63,33 +63,33 @@ 
 // loop over all users
 while ($user = _mysql_fetch_object($result)) {
 
-  $id=$user->id;
-  $email_addr=$user->email_addr;
-  $cpid=$user->cross_project_id;
+    $id=$user->id;
+    $email_addr=$user->email_addr;
+    $cpid=$user->cross_project_id;
 
-  $new_email=strtolower(trim($email_addr));
+    $new_email=strtolower(trim($email_addr));
   
-  if (strcmp($email_addr, $new_email))
+    if (strcmp($email_addr, $new_email))
     echo "Problematic email address [$id] $email_addr becomes $new_email<br/>";
   
-  if (!(strcmp($cpid,"0"))) {
+    if (!(strcmp($cpid,"0"))) {
     $newcpid=random_string();
     echo "Problematic CPID=0 for [$id] $email_addr gets CPID=$newcpid<br/>";
-  }
-  else
+    }
+    else
     $newcpid=$cpid;
   
-  if (strcmp($email_addr, $new_email) || strcmp($newcpid,$cpid)) {
+    if (strcmp($email_addr, $new_email) || strcmp($newcpid,$cpid)) {
     $update="update user set email_addr='$new_email', cross_project_id='$newcpid' where id='$id'";
     if ($confirm != "yes") {
-      echo "QUERY WOULD BE [$id] $query <br/>[click the link at the bottom to enable]<br/>";
-      $update_needed = TRUE;
+        echo "QUERY WOULD BE [$id] $query <br/>[click the link at the bottom to enable]<br/>";
+        $update_needed = TRUE;
     }
     else {
-      _mysql_query($update);
-      echo "Doing $update<br/>\n";
+        _mysql_query($update);
+        echo "Doing $update<br/>\n";
+    }
     }
-  }
 }
 if ($confirm != "yes" && $update_needed) {
     echo "You can enable the changes by <a href=\"make_emails_lowercase.php?confirm=yes\">click</a>";

Spacing +10 added lines, -10 removed lines

@@ -63,24 +63,24 @@ 
 // loop over all users
 while ($user = _mysql_fetch_object($result)) {
 
-  $id=$user->id;
-  $email_addr=$user->email_addr;
-  $cpid=$user->cross_project_id;
+  $id = $user->id;
+  $email_addr = $user->email_addr;
+  $cpid = $user->cross_project_id;
 
-  $new_email=strtolower(trim($email_addr));
+  $new_email = strtolower(trim($email_addr));
   
   if (strcmp($email_addr, $new_email))
     echo "Problematic email address [$id] $email_addr becomes $new_email<br/>";
   
-  if (!(strcmp($cpid,"0"))) {
-    $newcpid=random_string();
+  if (!(strcmp($cpid, "0"))) {
+    $newcpid = random_string();
     echo "Problematic CPID=0 for [$id] $email_addr gets CPID=$newcpid<br/>";
   }
   else
-    $newcpid=$cpid;
+    $newcpid = $cpid;
   
-  if (strcmp($email_addr, $new_email) || strcmp($newcpid,$cpid)) {
-    $update="update user set email_addr='$new_email', cross_project_id='$newcpid' where id='$id'";
+  if (strcmp($email_addr, $new_email) || strcmp($newcpid, $cpid)) {
+    $update = "update user set email_addr='$new_email', cross_project_id='$newcpid' where id='$id'";
     if ($confirm != "yes") {
       echo "QUERY WOULD BE [$id] $query <br/>[click the link at the bottom to enable]<br/>";
       $update_needed = TRUE;
@@ -99,5 +99,5 @@ 
 _mysql_free_result($result);
 
 admin_page_tail();
-$cvs_version_tracker[]="\$Id$";  //Generated automatically - do not edit
+$cvs_version_tracker[] = "\$Id$"; //Generated automatically - do not edit
 ?>

Braces +2 added lines, -4 removed lines

@@ -75,8 +75,7 @@ 
   if (!(strcmp($cpid,"0"))) {
     $newcpid=random_string();
     echo "Problematic CPID=0 for [$id] $email_addr gets CPID=$newcpid<br/>";
-  }
-  else
+  } else
     $newcpid=$cpid;
   
   if (strcmp($email_addr, $new_email) || strcmp($newcpid,$cpid)) {
@@ -84,8 +83,7 @@ 
     if ($confirm != "yes") {
       echo "QUERY WOULD BE [$id] $query <br/>[click the link at the bottom to enable]<br/>";
       $update_needed = TRUE;
-    }
-    else {
+    } else {
       _mysql_query($update);
       echo "Doing $update<br/>\n";
     }

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

@@ -83,11 +83,11 @@
     $update="update user set email_addr='$new_email', cross_project_id='$newcpid' where id='$id'";
     if ($confirm != "yes") {
       echo "QUERY WOULD BE [$id] $query <br/>[click the link at the bottom to enable]<br/>";
-      $update_needed = TRUE;
+      $update_needed = true;
     }
     else {
       _mysql_query($update);
-      echo "Doing $update<br/>\n";
+      echo "doing $update<br/>\n";
     }
   }
 }

html/ops/team_export.php

Spacing +1 added lines, -1 removed lines

@@ -100,7 +100,7 @@
     $f = fopen("temp.xml", "w");
     $teams = BoincTeam::enum(null);
     fwrite($f, "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<teams>\n");
-    foreach($teams as $team) {
+    foreach ($teams as $team) {
         handle_team($team, $f);
     }
     fwrite($f, "</teams>\n");

html/ops/badge_admin.php

Spacing +1 added lines, -1 removed lines

@@ -39,7 +39,7 @@
     $i = 0;
     foreach ($badges as $badge) {
         echo "<tr class=row$i valign=top><form action=badge_admin.php method=POST>";
-        $i = 1-$i;
+        $i = 1 - $i;
         echo "<td>$badge->id</td>\n";
         echo "<input type=hidden name=id value=$badge->id>";
         $nu = BoincBadgeUser::count("badge_id=$badge->id");

html/ops/bbcode_convert_signature.php

Spacing +4 added lines, -4 removed lines

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

Braces +4 added lines, -3 removed lines

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

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;