@@ -24,17 +24,17 @@ |
||
24 | 24 | set_time_limit(0); |
25 | 25 | |
26 | 26 | function cache_check_diskspace2(){ |
27 | - $too_old = 86400; |
|
28 | - while (1) { |
|
29 | - $f = disk_free_space("../cache"); |
|
30 | - $u = disk_usage("../cache"); |
|
31 | - echo "free: $f used: $u\n"; |
|
32 | - if ($f > MIN_FREE_SPACE && $u < MAX_CACHE_USAGE) { |
|
33 | - break; |
|
34 | - } |
|
35 | - clean_cache($too_old, "../cache"); |
|
36 | - $too_old/=2; |
|
37 | - } |
|
27 | + $too_old = 86400; |
|
28 | + while (1) { |
|
29 | + $f = disk_free_space("../cache"); |
|
30 | + $u = disk_usage("../cache"); |
|
31 | + echo "free: $f used: $u\n"; |
|
32 | + if ($f > MIN_FREE_SPACE && $u < MAX_CACHE_USAGE) { |
|
33 | + break; |
|
34 | + } |
|
35 | + clean_cache($too_old, "../cache"); |
|
36 | + $too_old/=2; |
|
37 | + } |
|
38 | 38 | } |
39 | 39 | |
40 | 40 | cache_check_diskspace2(); |
@@ -200,7 +200,7 @@ |
||
200 | 200 | for ($row = 0; $row < $height; $row++) { |
201 | 201 | echo "<tr>"; |
202 | 202 | for ($col = 0; $col < $width; $col++) { |
203 | - if ($count < $numIds) { |
|
203 | + if ($count < $numIds) { |
|
204 | 204 | echo "<td class=\"bordered\" align=\"center\"> |
205 | 205 | <a href=\"".secure_url_base()."view_profile.php?userid=".$userIds[$count]."\"><img src=\"".secure_url_base().IMAGE_URL.$userIds[$count]."_sm.jpg\"></a> |
206 | 206 | </td>"; |
@@ -37,14 +37,14 @@ discard block |
||
37 | 37 | |
38 | 38 | // activate/deactivate script |
39 | 39 | if (1) { |
40 | - echo " |
|
40 | + echo " |
|
41 | 41 | This script needs to be activated before it can be run. |
42 | 42 | Once you understand what the script does you can change the |
43 | 43 | if (1) to if (0) at the top of the file to activate it. |
44 | 44 | Be sure to deactivate the script after using it to make sure |
45 | 45 | it is not accidentally run. |
46 | 46 | "; |
47 | - exit; |
|
47 | + exit; |
|
48 | 48 | } |
49 | 49 | |
50 | 50 | db_init(); |
@@ -63,33 +63,33 @@ discard block |
||
63 | 63 | // loop over all users |
64 | 64 | while ($user = _mysql_fetch_object($result)) { |
65 | 65 | |
66 | - $id=$user->id; |
|
67 | - $email_addr=$user->email_addr; |
|
68 | - $cpid=$user->cross_project_id; |
|
66 | + $id=$user->id; |
|
67 | + $email_addr=$user->email_addr; |
|
68 | + $cpid=$user->cross_project_id; |
|
69 | 69 | |
70 | - $new_email=strtolower(trim($email_addr)); |
|
70 | + $new_email=strtolower(trim($email_addr)); |
|
71 | 71 | |
72 | - if (strcmp($email_addr, $new_email)) |
|
72 | + if (strcmp($email_addr, $new_email)) |
|
73 | 73 | echo "Problematic email address [$id] $email_addr becomes $new_email<br/>"; |
74 | 74 | |
75 | - if (!(strcmp($cpid,"0"))) { |
|
75 | + if (!(strcmp($cpid,"0"))) { |
|
76 | 76 | $newcpid=random_string(); |
77 | 77 | echo "Problematic CPID=0 for [$id] $email_addr gets CPID=$newcpid<br/>"; |
78 | - } |
|
79 | - else |
|
78 | + } |
|
79 | + else |
|
80 | 80 | $newcpid=$cpid; |
81 | 81 | |
82 | - if (strcmp($email_addr, $new_email) || strcmp($newcpid,$cpid)) { |
|
82 | + if (strcmp($email_addr, $new_email) || strcmp($newcpid,$cpid)) { |
|
83 | 83 | $update="update user set email_addr='$new_email', cross_project_id='$newcpid' where id='$id'"; |
84 | 84 | if ($confirm != "yes") { |
85 | - echo "QUERY WOULD BE [$id] $query <br/>[click the link at the bottom to enable]<br/>"; |
|
86 | - $update_needed = TRUE; |
|
85 | + echo "QUERY WOULD BE [$id] $query <br/>[click the link at the bottom to enable]<br/>"; |
|
86 | + $update_needed = TRUE; |
|
87 | 87 | } |
88 | 88 | else { |
89 | - _mysql_query($update); |
|
90 | - echo "Doing $update<br/>\n"; |
|
89 | + _mysql_query($update); |
|
90 | + echo "Doing $update<br/>\n"; |
|
91 | + } |
|
91 | 92 | } |
92 | - } |
|
93 | 93 | } |
94 | 94 | if ($confirm != "yes" && $update_needed) { |
95 | 95 | echo "You can enable the changes by <a href=\"make_emails_lowercase.php?confirm=yes\">click</a>"; |
@@ -15,10 +15,10 @@ discard block |
||
15 | 15 | function __construct($n, $d, $i, $t, $r, $s) { |
16 | 16 | $this->name = $n; |
17 | 17 | $this->data_size = $d; |
18 | - $this->index_size = $i; |
|
19 | - $this->total_size = $t; |
|
20 | - $this->rows = $r; |
|
21 | - $this->size_per_row = $s; |
|
18 | + $this->index_size = $i; |
|
19 | + $this->total_size = $t; |
|
20 | + $this->rows = $r; |
|
21 | + $this->size_per_row = $s; |
|
22 | 22 | } |
23 | 23 | function __destruct() { |
24 | 24 | } |
@@ -42,40 +42,40 @@ discard block |
||
42 | 42 | |
43 | 43 | // returns formatted data size |
44 | 44 | function size_format($size){ |
45 | - $retval = 0; |
|
45 | + $retval = 0; |
|
46 | 46 | |
47 | - $KB = 1024; |
|
47 | + $KB = 1024; |
|
48 | 48 | $MB = 1024*1024; |
49 | 49 | $GB = 1024*1024*1024; |
50 | - $TB = 1024*1024*1024*1024; |
|
50 | + $TB = 1024*1024*1024*1024; |
|
51 | 51 | |
52 | 52 | if ($size < $KB) { |
53 | - $retval = $size; |
|
53 | + $retval = $size; |
|
54 | 54 | } elseif (($size > $KB) && ($size < $MB)) { |
55 | - $retval = sprintf("%.0fK", ($size / $KB)); |
|
55 | + $retval = sprintf("%.0fK", ($size / $KB)); |
|
56 | 56 | } elseif ( ($size >= $MB) && ($size < $GB)) { |
57 | - $retval = sprintf("%.2fMB", ($size / $MB)); |
|
57 | + $retval = sprintf("%.2fMB", ($size / $MB)); |
|
58 | 58 | } elseif ( ($size >= $GB) && ($size < $TB)) { |
59 | - $retval = sprintf("%.2fGB", ($size / $GB)); |
|
60 | - } elseif ( $size >= $TB ) { |
|
61 | - $retval = sprintf("%.2fTB", ($size / $TB)); |
|
62 | - } |
|
63 | - return $retval; |
|
59 | + $retval = sprintf("%.2fGB", ($size / $GB)); |
|
60 | + } elseif ( $size >= $TB ) { |
|
61 | + $retval = sprintf("%.2fTB", ($size / $TB)); |
|
62 | + } |
|
63 | + return $retval; |
|
64 | 64 | } |
65 | 65 | |
66 | 66 | |
67 | 67 | // returns the DB data structure as DB_REC |
68 | 68 | function get_db_info($db_name) |
69 | 69 | { |
70 | - // Carl grabbed this from the mysql.com boards http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html |
|
70 | + // Carl grabbed this from the mysql.com boards http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html |
|
71 | 71 | $result = _mysql_query("SHOW TABLE STATUS FROM $db_name"); |
72 | 72 | |
73 | 73 | // SQL output |
74 | 74 | // mysql> show table status from [table_name]; |
75 | 75 | // | Name | Engine | Version | Row_format | Rows |
76 | - // | Avg_row_length | Data_length | Max_data_length |
|
77 | - // | Index_length | Data_free | Auto_increment | Create_time |
|
78 | - // | Update_time | Check_time | Collation | Checksum | Create_options | Comment | |
|
76 | + // | Avg_row_length | Data_length | Max_data_length |
|
77 | + // | Index_length | Data_free | Auto_increment | Create_time |
|
78 | + // | Update_time | Check_time | Collation | Checksum | Create_options | Comment | |
|
79 | 79 | // |
80 | 80 | |
81 | 81 | $gdata = 0; |
@@ -83,24 +83,24 @@ discard block |
||
83 | 83 | $gtotal = 0; |
84 | 84 | $grows = 0; |
85 | 85 | |
86 | - $i = 0; |
|
87 | - $db_rec = array(); |
|
88 | - while($myarr = _mysql_fetch_assoc($result)) { |
|
86 | + $i = 0; |
|
87 | + $db_rec = array(); |
|
88 | + while($myarr = _mysql_fetch_assoc($result)) { |
|
89 | 89 | |
90 | - // sum grand totals |
|
91 | - $total = $myarr["Data_length"] + $myarr["Index_length"]; |
|
92 | - $gindex += $myarr["Index_length"]; |
|
90 | + // sum grand totals |
|
91 | + $total = $myarr["Data_length"] + $myarr["Index_length"]; |
|
92 | + $gindex += $myarr["Index_length"]; |
|
93 | 93 | $gdata += $myarr["Data_length"]; |
94 | - $grows += $myarr["Rows"]; |
|
95 | - $gtotal += $total; |
|
94 | + $grows += $myarr["Rows"]; |
|
95 | + $gtotal += $total; |
|
96 | 96 | |
97 | - $db_rec[$i] = new DB_REC ($myarr["Name"], $myarr["Data_length"], $myarr["Index_length"], $total, $myarr["Rows"], $myarr["Avg_row_length"] ); |
|
98 | - $i++; |
|
99 | - } |
|
97 | + $db_rec[$i] = new DB_REC ($myarr["Name"], $myarr["Data_length"], $myarr["Index_length"], $total, $myarr["Rows"], $myarr["Avg_row_length"] ); |
|
98 | + $i++; |
|
99 | + } |
|
100 | 100 | |
101 | 101 | $db_rec[$i] = new DB_REC ("Total", $gdata, $gindex, $gtotal, $grows, "" ); |
102 | 102 | |
103 | - return $db_rec; |
|
103 | + return $db_rec; |
|
104 | 104 | } |
105 | 105 | |
106 | 106 | |
@@ -108,41 +108,41 @@ discard block |
||
108 | 108 | function show_db_info($db_name, $db_rec) |
109 | 109 | { |
110 | 110 | |
111 | - echo "<table cols=6>"; |
|
112 | - echo "<tr>"; |
|
113 | - echo "<th colspan=6> Database $db_name </th>"; |
|
114 | - echo "</tr>"; |
|
115 | - |
|
116 | - echo "<tr>"; |
|
117 | - echo "<th>Table</th>"; |
|
118 | - echo "<th>Data Size</th>"; |
|
119 | - echo "<th>Index Size</th>"; |
|
120 | - echo "<th>Total Size</th>"; |
|
121 | - echo "<th>Total Rows</th>"; |
|
122 | - echo "<th>Avg. Size per Row</th>"; |
|
123 | - echo "</tr>"; |
|
124 | - |
|
125 | - for ($i = 0; $i < sizeof($db_rec)-1; $i++){ |
|
126 | - echo "<tr>"; |
|
127 | - echo "<td align=left valign=top class=fieldname>" . $db_rec[$i]->name . "</td>"; |
|
128 | - echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->data_size) . "</td>"; |
|
129 | - echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->index_size) . "</td>"; |
|
130 | - echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->total_size) . "</td>"; |
|
111 | + echo "<table cols=6>"; |
|
112 | + echo "<tr>"; |
|
113 | + echo "<th colspan=6> Database $db_name </th>"; |
|
114 | + echo "</tr>"; |
|
115 | + |
|
116 | + echo "<tr>"; |
|
117 | + echo "<th>Table</th>"; |
|
118 | + echo "<th>Data Size</th>"; |
|
119 | + echo "<th>Index Size</th>"; |
|
120 | + echo "<th>Total Size</th>"; |
|
121 | + echo "<th>Total Rows</th>"; |
|
122 | + echo "<th>Avg. Size per Row</th>"; |
|
123 | + echo "</tr>"; |
|
124 | + |
|
125 | + for ($i = 0; $i < sizeof($db_rec)-1; $i++){ |
|
126 | + echo "<tr>"; |
|
127 | + echo "<td align=left valign=top class=fieldname>" . $db_rec[$i]->name . "</td>"; |
|
128 | + echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->data_size) . "</td>"; |
|
129 | + echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->index_size) . "</td>"; |
|
130 | + echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->total_size) . "</td>"; |
|
131 | 131 | echo "<td align=left valign=top class=fieldname>" . number_format($db_rec[$i]->rows) . "</td>"; |
132 | 132 | echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->size_per_row) . "</td>"; |
133 | - echo "</tr>"; |
|
134 | - } |
|
133 | + echo "</tr>"; |
|
134 | + } |
|
135 | 135 | |
136 | - // Last record is just a summary |
|
137 | - $i = sizeof($db_rec)-1; |
|
138 | - echo "<tr>"; |
|
136 | + // Last record is just a summary |
|
137 | + $i = sizeof($db_rec)-1; |
|
138 | + echo "<tr>"; |
|
139 | 139 | echo "<th align=left>" . $db_rec[$i]->name . "</th>"; |
140 | 140 | echo "<th align=left>" . size_format($db_rec[$i]->data_size) . "</th>"; |
141 | 141 | echo "<th align=left>" . size_format($db_rec[$i]->index_size) . "</th>"; |
142 | 142 | echo "<th align=left>" . size_format($db_rec[$i]->total_size) . "</th>"; |
143 | 143 | echo "<th align=left>" . number_format($db_rec[$i]->rows) . "</th>"; |
144 | 144 | echo "<th align=left></th>"; |
145 | - echo "</tr>"; |
|
145 | + echo "</tr>"; |
|
146 | 146 | |
147 | 147 | echo "</table>"; |
148 | 148 | } |
@@ -152,80 +152,80 @@ discard block |
||
152 | 152 | // NB: same as show_db_info but with sortable cloumns |
153 | 153 | function sort_db_info($db_name, $db_rec) |
154 | 154 | { |
155 | - // sort |
|
156 | - $file_list = array(); |
|
155 | + // sort |
|
156 | + $file_list = array(); |
|
157 | 157 | $file_sort = array(); |
158 | 158 | |
159 | - $sort = get_str("sort", true); |
|
160 | - $r = get_str("r", true); |
|
161 | - |
|
162 | - // check if its empty |
|
163 | - if(empty($sort)) $sort = "name"; |
|
164 | - // check for allowed keys |
|
165 | - if ((strcmp($sort, "name")!=0) && |
|
166 | - (strcmp($sort, "data_size")!=0) && |
|
167 | - (strcmp($sort, "index_size")!=0) && |
|
168 | - (strcmp($sort, "total_size")!=0) && |
|
169 | - (strcmp($sort, "rows")!=0) && |
|
170 | - (strcmp($sort, "size_per_row")!=0)) |
|
171 | - $sort = "name"; |
|
172 | - if(empty($r)) $r=0; |
|
173 | - |
|
174 | - for ($i = 0; $i < sizeof($db_rec)-1; $i++){ |
|
175 | - $file_details["name"] = $db_rec[$i]->name; |
|
176 | - $file_details["data_size"] = $db_rec[$i]->data_size; |
|
177 | - $file_details["index_size"] = $db_rec[$i]->index_size; |
|
178 | - $file_details["total_size"] = $db_rec[$i]->total_size; |
|
179 | - $file_details["rows"] = $db_rec[$i]->rows; |
|
180 | - $file_details["size_per_row"] = $db_rec[$i]->size_per_row; |
|
181 | - |
|
182 | - $file_list[$i] = $file_details; |
|
183 | - $key = strtolower($file_details[$sort]); |
|
184 | - $file_sort[$i] = $key; |
|
185 | - } |
|
159 | + $sort = get_str("sort", true); |
|
160 | + $r = get_str("r", true); |
|
161 | + |
|
162 | + // check if its empty |
|
163 | + if(empty($sort)) $sort = "name"; |
|
164 | + // check for allowed keys |
|
165 | + if ((strcmp($sort, "name")!=0) && |
|
166 | + (strcmp($sort, "data_size")!=0) && |
|
167 | + (strcmp($sort, "index_size")!=0) && |
|
168 | + (strcmp($sort, "total_size")!=0) && |
|
169 | + (strcmp($sort, "rows")!=0) && |
|
170 | + (strcmp($sort, "size_per_row")!=0)) |
|
171 | + $sort = "name"; |
|
172 | + if(empty($r)) $r=0; |
|
173 | + |
|
174 | + for ($i = 0; $i < sizeof($db_rec)-1; $i++){ |
|
175 | + $file_details["name"] = $db_rec[$i]->name; |
|
176 | + $file_details["data_size"] = $db_rec[$i]->data_size; |
|
177 | + $file_details["index_size"] = $db_rec[$i]->index_size; |
|
178 | + $file_details["total_size"] = $db_rec[$i]->total_size; |
|
179 | + $file_details["rows"] = $db_rec[$i]->rows; |
|
180 | + $file_details["size_per_row"] = $db_rec[$i]->size_per_row; |
|
181 | + |
|
182 | + $file_list[$i] = $file_details; |
|
183 | + $key = strtolower($file_details[$sort]); |
|
184 | + $file_sort[$i] = $key; |
|
185 | + } |
|
186 | 186 | |
187 | - if($r)arsort($file_sort); |
|
187 | + if($r)arsort($file_sort); |
|
188 | 188 | else asort($file_sort); |
189 | - // -- end sort |
|
190 | - |
|
191 | - echo "<table cols=6>"; |
|
192 | - echo "<tr>"; |
|
193 | - echo "<th colspan=6> Database $db_name </th>"; |
|
194 | - echo "</tr>"; |
|
195 | - |
|
196 | - echo "<tr>"; |
|
197 | - echo "<th><a href='dbinfo.php?sort=name&r=" . (!$r) . "'>Table </a></th>"; |
|
198 | - echo "<th><a href='dbinfo.php?sort=data_size&r=" . (!$r) . "'>Data Size</a></th>"; |
|
199 | - echo "<th><a href='dbinfo.php?sort=index_size&r=" . (!$r) . "'>Index Size</a></th>"; |
|
200 | - echo "<th><a href='dbinfo.php?sort=total_size&r=" . (!$r) . "'>Total Size</a></th>"; |
|
201 | - echo "<th><a href='dbinfo.php?sort=rows&r=" . (!$r) . "'>Total Rows</a></th>"; |
|
202 | - echo "<th><a href='dbinfo.php?sort=size_per_row&r=" . (!$r) . "'>Avg. Size per Row</a></th>"; |
|
203 | - echo "</tr>"; |
|
204 | - |
|
205 | - $i = 0; |
|
206 | - while ( list($key, $value) = each($file_sort) ) { |
|
207 | - $value = $file_list[$key]; |
|
208 | - echo "<tr>"; |
|
209 | - echo "<td align=left valign=top class=fieldname>" . $value["name"] . "</td>"; |
|
210 | - echo "<td align=left valign=top class=fieldname>" . size_format($value["data_size"]) . "</td>"; |
|
211 | - echo "<td align=left valign=top class=fieldname>" . size_format($value["index_size"]) . "</td>"; |
|
212 | - echo "<td align=left valign=top class=fieldname>" . size_format($value["total_size"]) . "</td>"; |
|
189 | + // -- end sort |
|
190 | + |
|
191 | + echo "<table cols=6>"; |
|
192 | + echo "<tr>"; |
|
193 | + echo "<th colspan=6> Database $db_name </th>"; |
|
194 | + echo "</tr>"; |
|
195 | + |
|
196 | + echo "<tr>"; |
|
197 | + echo "<th><a href='dbinfo.php?sort=name&r=" . (!$r) . "'>Table </a></th>"; |
|
198 | + echo "<th><a href='dbinfo.php?sort=data_size&r=" . (!$r) . "'>Data Size</a></th>"; |
|
199 | + echo "<th><a href='dbinfo.php?sort=index_size&r=" . (!$r) . "'>Index Size</a></th>"; |
|
200 | + echo "<th><a href='dbinfo.php?sort=total_size&r=" . (!$r) . "'>Total Size</a></th>"; |
|
201 | + echo "<th><a href='dbinfo.php?sort=rows&r=" . (!$r) . "'>Total Rows</a></th>"; |
|
202 | + echo "<th><a href='dbinfo.php?sort=size_per_row&r=" . (!$r) . "'>Avg. Size per Row</a></th>"; |
|
203 | + echo "</tr>"; |
|
204 | + |
|
205 | + $i = 0; |
|
206 | + while ( list($key, $value) = each($file_sort) ) { |
|
207 | + $value = $file_list[$key]; |
|
208 | + echo "<tr>"; |
|
209 | + echo "<td align=left valign=top class=fieldname>" . $value["name"] . "</td>"; |
|
210 | + echo "<td align=left valign=top class=fieldname>" . size_format($value["data_size"]) . "</td>"; |
|
211 | + echo "<td align=left valign=top class=fieldname>" . size_format($value["index_size"]) . "</td>"; |
|
212 | + echo "<td align=left valign=top class=fieldname>" . size_format($value["total_size"]) . "</td>"; |
|
213 | 213 | echo "<td align=left valign=top class=fieldname>" . number_format($value["rows"]) . "</td>"; |
214 | 214 | echo "<td align=left valign=top class=fieldname>" . size_format($value["size_per_row"]) . "</td>"; |
215 | - echo "</tr>"; |
|
216 | - $i++; |
|
217 | - } |
|
215 | + echo "</tr>"; |
|
216 | + $i++; |
|
217 | + } |
|
218 | 218 | |
219 | - // Last record is just a summary |
|
220 | - $i = sizeof($db_rec)-1; |
|
221 | - echo "<tr>"; |
|
219 | + // Last record is just a summary |
|
220 | + $i = sizeof($db_rec)-1; |
|
221 | + echo "<tr>"; |
|
222 | 222 | echo "<th align=left>" . $db_rec[$i]->name . "</th>"; |
223 | 223 | echo "<th align=left>" . size_format($db_rec[$i]->data_size) . "</th>"; |
224 | 224 | echo "<th align=left>" . size_format($db_rec[$i]->index_size) . "</th>"; |
225 | 225 | echo "<th align=left>" . size_format($db_rec[$i]->total_size) . "</th>"; |
226 | 226 | echo "<th align=left>" . number_format($db_rec[$i]->rows) . "</th>"; |
227 | 227 | echo "<th align=left></th>"; |
228 | - echo "</tr>"; |
|
228 | + echo "</tr>"; |
|
229 | 229 | |
230 | 230 | echo "</table>"; |
231 | 231 | } |
@@ -28,7 +28,7 @@ |
||
28 | 28 | $updates = array(); |
29 | 29 | foreach ($db_updates as $db_update) { |
30 | 30 | if ($db_update[0] > $db_revision) { |
31 | - $db_revision = $db_update[0]; |
|
31 | + $db_revision = $db_update[0]; |
|
32 | 32 | } |
33 | 33 | } |
34 | 34 |
@@ -68,93 +68,93 @@ |
||
68 | 68 | } |
69 | 69 | |
70 | 70 | function analyze_nvidia() { |
71 | - $hosts_total = 0; // number of hosts 6.2 or better |
|
72 | - $hosts_gpu = 0; // number with an nvidia gpu |
|
73 | - $rac_total =0; |
|
74 | - $rac_gpu = 0; |
|
75 | - $linux_total = 0; |
|
76 | - $linux_gpus = 0; |
|
77 | - $windows_total = 0; |
|
78 | - $windows_gpus = 0; |
|
79 | - $model = array(); // name -> count |
|
80 | - $ram = array(); // size -> count |
|
81 | - $driver = array(); // vers -> count |
|
82 | - $ngpus = array(); // ngpus -> count |
|
71 | + $hosts_total = 0; // number of hosts 6.2 or better |
|
72 | + $hosts_gpu = 0; // number with an nvidia gpu |
|
73 | + $rac_total =0; |
|
74 | + $rac_gpu = 0; |
|
75 | + $linux_total = 0; |
|
76 | + $linux_gpus = 0; |
|
77 | + $windows_total = 0; |
|
78 | + $windows_gpus = 0; |
|
79 | + $model = array(); // name -> count |
|
80 | + $ram = array(); // size -> count |
|
81 | + $driver = array(); // vers -> count |
|
82 | + $ngpus = array(); // ngpus -> count |
|
83 | 83 | |
84 | - $hosts = BoincHost::enum("expavg_credit > 10 and serialnum<>''"); |
|
85 | - foreach($hosts as $host) { |
|
86 | - $boinc_vers = parse_vers($host->serialnum); |
|
87 | - if (!$boinc_vers) continue; |
|
88 | - if ($boinc_vers->major < 6) continue; |
|
89 | - $is_linux = false; |
|
90 | - if (strstr($host->os_name, "Linux")) { |
|
91 | - $linux_total++; |
|
92 | - $is_linux = true; |
|
93 | - } else if (strstr($host->os_name, "Windows")) { |
|
94 | - $windows_total++; |
|
95 | - } else { |
|
96 | - continue; |
|
97 | - } |
|
98 | - $hosts_total++; |
|
99 | - $rac_total += $host->expavg_credit; |
|
100 | - $gpu = parse_cuda($host->serialnum); |
|
101 | - if (!$gpu) { |
|
102 | - continue; |
|
103 | - } |
|
104 | - $hosts_gpu++; |
|
105 | - $rac_gpu += $host->expavg_credit; |
|
106 | - if ($is_linux) { |
|
107 | - $linux_gpus++; |
|
108 | - } else { |
|
109 | - $windows_gpus++; |
|
110 | - } |
|
111 | - inc($model, $gpu->model); |
|
112 | - inc($ram, $gpu->ram); |
|
113 | - inc($driver, $gpu->driver); |
|
114 | - inc($ngpus, $gpu->ngpus); |
|
115 | - } |
|
84 | + $hosts = BoincHost::enum("expavg_credit > 10 and serialnum<>''"); |
|
85 | + foreach($hosts as $host) { |
|
86 | + $boinc_vers = parse_vers($host->serialnum); |
|
87 | + if (!$boinc_vers) continue; |
|
88 | + if ($boinc_vers->major < 6) continue; |
|
89 | + $is_linux = false; |
|
90 | + if (strstr($host->os_name, "Linux")) { |
|
91 | + $linux_total++; |
|
92 | + $is_linux = true; |
|
93 | + } else if (strstr($host->os_name, "Windows")) { |
|
94 | + $windows_total++; |
|
95 | + } else { |
|
96 | + continue; |
|
97 | + } |
|
98 | + $hosts_total++; |
|
99 | + $rac_total += $host->expavg_credit; |
|
100 | + $gpu = parse_cuda($host->serialnum); |
|
101 | + if (!$gpu) { |
|
102 | + continue; |
|
103 | + } |
|
104 | + $hosts_gpu++; |
|
105 | + $rac_gpu += $host->expavg_credit; |
|
106 | + if ($is_linux) { |
|
107 | + $linux_gpus++; |
|
108 | + } else { |
|
109 | + $windows_gpus++; |
|
110 | + } |
|
111 | + inc($model, $gpu->model); |
|
112 | + inc($ram, $gpu->ram); |
|
113 | + inc($driver, $gpu->driver); |
|
114 | + inc($ngpus, $gpu->ngpus); |
|
115 | + } |
|
116 | 116 | |
117 | - $pct = 100*($hosts_gpu/$hosts_total); |
|
118 | - echo "ntotal: $hosts_total ngpus: $hosts_gpu ($pct %)\n"; |
|
119 | - $pct = 100*($windows_gpus/$windows_total); |
|
120 | - echo "Windows: total $windows_total gpus $windows_gpus ($pct %)\n"; |
|
121 | - $pct = 100*($linux_gpus/$linux_total); |
|
122 | - echo "Linux: total $linux_total gpus $linux_gpus ($pct %)\n"; |
|
117 | + $pct = 100*($hosts_gpu/$hosts_total); |
|
118 | + echo "ntotal: $hosts_total ngpus: $hosts_gpu ($pct %)\n"; |
|
119 | + $pct = 100*($windows_gpus/$windows_total); |
|
120 | + echo "Windows: total $windows_total gpus $windows_gpus ($pct %)\n"; |
|
121 | + $pct = 100*($linux_gpus/$linux_total); |
|
122 | + echo "Linux: total $linux_total gpus $linux_gpus ($pct %)\n"; |
|
123 | 123 | |
124 | - $rac_non_gpu = $rac_total - $rac_gpu; |
|
125 | - $hosts_non_gpu = $hosts_total - $hosts_gpu; |
|
126 | - $a = $rac_gpu/$hosts_gpu; |
|
127 | - $b = $rac_non_gpu/$hosts_non_gpu; |
|
128 | - echo "Avg RAC: GPU: $a non-GPU: $b\n"; |
|
124 | + $rac_non_gpu = $rac_total - $rac_gpu; |
|
125 | + $hosts_non_gpu = $hosts_total - $hosts_gpu; |
|
126 | + $a = $rac_gpu/$hosts_gpu; |
|
127 | + $b = $rac_non_gpu/$hosts_non_gpu; |
|
128 | + echo "Avg RAC: GPU: $a non-GPU: $b\n"; |
|
129 | 129 | |
130 | - arsort($model); |
|
131 | - foreach($model as $m=>$c) { |
|
132 | - echo "$m $c\n"; |
|
133 | - } |
|
134 | - print_r($ram); |
|
135 | - print_r($driver); |
|
136 | - print_r($ngpus); |
|
130 | + arsort($model); |
|
131 | + foreach($model as $m=>$c) { |
|
132 | + echo "$m $c\n"; |
|
133 | + } |
|
134 | + print_r($ram); |
|
135 | + print_r($driver); |
|
136 | + print_r($ngpus); |
|
137 | 137 | } |
138 | 138 | |
139 | 139 | function analyze_all() { |
140 | - $total = 0; |
|
141 | - $nnv = 0; |
|
142 | - $nati = 0; |
|
143 | - $nboth = 0; |
|
144 | - $hosts = BoincHost::enum("expavg_credit > 10 and serialnum<>''"); |
|
145 | - foreach($hosts as $host) { |
|
146 | - $boinc_vers = parse_vers($host->serialnum); |
|
147 | - if (!$boinc_vers) continue; |
|
148 | - if ($boinc_vers->major < 6) continue; |
|
149 | - if ($boinc_vers->major == 6 && $boinc_vers->minor < 10) continue; |
|
150 | - $total++; |
|
151 | - $has_nv = strstr($host->serialnum, 'CUDA'); |
|
152 | - $has_ati = strstr($host->serialnum, 'ATI'); |
|
153 | - if ($has_nv) $nnv++; |
|
154 | - if ($has_ati) $nati++; |
|
155 | - if ($has_nv && $has_ati) $nboth++; |
|
156 | - } |
|
157 | - echo "total: $total NVIDIA: $nnv ATI: $nati both: $nboth\n"; |
|
140 | + $total = 0; |
|
141 | + $nnv = 0; |
|
142 | + $nati = 0; |
|
143 | + $nboth = 0; |
|
144 | + $hosts = BoincHost::enum("expavg_credit > 10 and serialnum<>''"); |
|
145 | + foreach($hosts as $host) { |
|
146 | + $boinc_vers = parse_vers($host->serialnum); |
|
147 | + if (!$boinc_vers) continue; |
|
148 | + if ($boinc_vers->major < 6) continue; |
|
149 | + if ($boinc_vers->major == 6 && $boinc_vers->minor < 10) continue; |
|
150 | + $total++; |
|
151 | + $has_nv = strstr($host->serialnum, 'CUDA'); |
|
152 | + $has_ati = strstr($host->serialnum, 'ATI'); |
|
153 | + if ($has_nv) $nnv++; |
|
154 | + if ($has_ati) $nati++; |
|
155 | + if ($has_nv && $has_ati) $nboth++; |
|
156 | + } |
|
157 | + echo "total: $total NVIDIA: $nnv ATI: $nati both: $nboth\n"; |
|
158 | 158 | } |
159 | 159 | |
160 | 160 | analyze_all(); |
@@ -25,14 +25,14 @@ |
||
25 | 25 | |
26 | 26 | // activate/deactivate script |
27 | 27 | if (1) { |
28 | - echo " |
|
28 | + echo " |
|
29 | 29 | This script needs to be activated before it can be run. |
30 | 30 | Once you understand what the script does you can change the |
31 | 31 | if (1) to if (0) at the top of the file to activate it. |
32 | 32 | Be sure to deactivate the script after using it to make sure |
33 | 33 | it is not accidentally run. |
34 | 34 | "; |
35 | - exit; |
|
35 | + exit; |
|
36 | 36 | } |
37 | 37 | |
38 | 38 | db_init(); |
@@ -41,9 +41,9 @@ |
||
41 | 41 | } |
42 | 42 | |
43 | 43 | function find_oldest() { |
44 | - $result=_mysql_query("select name,create_time from result where server_state=2 order by create_time limit 1"); |
|
45 | - $x = _mysql_fetch_object($result); |
|
46 | - return $x->create_time; |
|
44 | + $result=_mysql_query("select name,create_time from result where server_state=2 order by create_time limit 1"); |
|
45 | + $x = _mysql_fetch_object($result); |
|
46 | + return $x->create_time; |
|
47 | 47 | } |
48 | 48 | |
49 | 49 | function daemon_status($host, $pidname) { |
@@ -42,7 +42,7 @@ discard block |
||
42 | 42 | |
43 | 43 | db_init(); |
44 | 44 | |
45 | - wap_begin(); |
|
45 | + wap_begin(); |
|
46 | 46 | |
47 | 47 | // keep a 'running tab' in wapstr in case exceeds 1K WAP limit |
48 | 48 | |
@@ -56,15 +56,15 @@ discard block |
||
56 | 56 | //$wapstr .= "#Activ: " . getSingleQuery("select count(distinct hostid) from cpdnexpt.trickle " |
57 | 57 | // . "where trickledate>=" . sprintf("%d", mktime() - (3600*24*7))) . "<br/>"; |
58 | 58 | |
59 | - // finally get last 5 trickles for everyone |
|
60 | - //$wapstr .= show_trickles("a", 0, 5, 1); |
|
59 | + // finally get last 5 trickles for everyone |
|
60 | + //$wapstr .= show_trickles("a", 0, 5, 1); |
|
61 | 61 | |
62 | - // limit wap output to 1KB |
|
63 | - if (strlen($wapstr)>1024) |
|
64 | - echo substr($wapstr,0,1024); |
|
65 | - else |
|
66 | - echo $wapstr; |
|
62 | + // limit wap output to 1KB |
|
63 | + if (strlen($wapstr)>1024) |
|
64 | + echo substr($wapstr,0,1024); |
|
65 | + else |
|
66 | + echo $wapstr; |
|
67 | 67 | |
68 | - wap_end(); |
|
68 | + wap_end(); |
|
69 | 69 | |
70 | 70 | ?> |