@@ -42,15 +42,15 @@ |
||
42 | 42 | $start_id = 0; //Set this to something else if you like |
43 | 43 | $forum_preferencess = _mysql_query("select * from forum_preferences where userid>$start_id order by userid"); |
44 | 44 | echo _mysql_error(); |
45 | - $i=0; |
|
46 | - while ($forum_preferences = _mysql_fetch_object($forum_preferencess)){ |
|
45 | + $i = 0; |
|
46 | + while ($forum_preferences = _mysql_fetch_object($forum_preferencess)) { |
|
47 | 47 | $i++; |
48 | 48 | if ($i%100 == 0) { //For every 100 forum_preferencess |
49 | - echo $forum_preferences->userid.". "; flush(); // print out where we are |
|
49 | + echo $forum_preferences->userid.". "; flush(); // print out where we are |
|
50 | 50 | //usleep(200000); |
51 | 51 | } |
52 | 52 | |
53 | - if ($forum_preferences->userid > $start_id){ |
|
53 | + if ($forum_preferences->userid > $start_id) { |
|
54 | 54 | fix_forum_preferences($forum_preferences); |
55 | 55 | } |
56 | 56 | } |
@@ -43,14 +43,15 @@ |
||
43 | 43 | $forum_preferencess = _mysql_query("select * from forum_preferences where userid>$start_id order by userid"); |
44 | 44 | echo _mysql_error(); |
45 | 45 | $i=0; |
46 | - while ($forum_preferences = _mysql_fetch_object($forum_preferencess)){ |
|
46 | + while ($forum_preferences = _mysql_fetch_object($forum_preferencess)) { |
|
47 | 47 | $i++; |
48 | - if ($i%100 == 0) { //For every 100 forum_preferencess |
|
48 | + if ($i%100 == 0) { |
|
49 | +//For every 100 forum_preferencess |
|
49 | 50 | echo $forum_preferences->userid.". "; flush(); // print out where we are |
50 | 51 | //usleep(200000); |
51 | 52 | } |
52 | 53 | |
53 | - if ($forum_preferences->userid > $start_id){ |
|
54 | + if ($forum_preferences->userid > $start_id) { |
|
54 | 55 | fix_forum_preferences($forum_preferences); |
55 | 56 | } |
56 | 57 | } |
@@ -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 | } |
@@ -41,7 +41,7 @@ discard block |
||
41 | 41 | |
42 | 42 | |
43 | 43 | // returns formatted data size |
44 | -function size_format($size){ |
|
44 | +function size_format($size) { |
|
45 | 45 | $retval = 0; |
46 | 46 | |
47 | 47 | $KB = 1024; |
@@ -52,13 +52,13 @@ discard block |
||
52 | 52 | if ($size < $KB) { |
53 | 53 | $retval = $size; |
54 | 54 | } elseif (($size > $KB) && ($size < $MB)) { |
55 | - $retval = sprintf("%.0fK", ($size / $KB)); |
|
56 | - } elseif ( ($size >= $MB) && ($size < $GB)) { |
|
57 | - $retval = sprintf("%.2fMB", ($size / $MB)); |
|
58 | - } elseif ( ($size >= $GB) && ($size < $TB)) { |
|
59 | - $retval = sprintf("%.2fGB", ($size / $GB)); |
|
60 | - } elseif ( $size >= $TB ) { |
|
61 | - $retval = sprintf("%.2fTB", ($size / $TB)); |
|
55 | + $retval = sprintf("%.0fK", ($size/$KB)); |
|
56 | + } elseif (($size >= $MB) && ($size < $GB)) { |
|
57 | + $retval = sprintf("%.2fMB", ($size/$MB)); |
|
58 | + } elseif (($size >= $GB) && ($size < $TB)) { |
|
59 | + $retval = sprintf("%.2fGB", ($size/$GB)); |
|
60 | + } elseif ($size >= $TB) { |
|
61 | + $retval = sprintf("%.2fTB", ($size/$TB)); |
|
62 | 62 | } |
63 | 63 | return $retval; |
64 | 64 | } |
@@ -85,20 +85,20 @@ discard block |
||
85 | 85 | |
86 | 86 | $i = 0; |
87 | 87 | $db_rec = array(); |
88 | - while($myarr = _mysql_fetch_assoc($result)) { |
|
88 | + while ($myarr = _mysql_fetch_assoc($result)) { |
|
89 | 89 | |
90 | 90 | // sum grand totals |
91 | - $total = $myarr["Data_length"] + $myarr["Index_length"]; |
|
91 | + $total = $myarr["Data_length"] + $myarr["Index_length"]; |
|
92 | 92 | $gindex += $myarr["Index_length"]; |
93 | - $gdata += $myarr["Data_length"]; |
|
93 | + $gdata += $myarr["Data_length"]; |
|
94 | 94 | $grows += $myarr["Rows"]; |
95 | 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"] ); |
|
97 | + $db_rec[$i] = new DB_REC($myarr["Name"], $myarr["Data_length"], $myarr["Index_length"], $total, $myarr["Rows"], $myarr["Avg_row_length"]); |
|
98 | 98 | $i++; |
99 | 99 | } |
100 | 100 | |
101 | - $db_rec[$i] = new DB_REC ("Total", $gdata, $gindex, $gtotal, $grows, "" ); |
|
101 | + $db_rec[$i] = new DB_REC("Total", $gdata, $gindex, $gtotal, $grows, ""); |
|
102 | 102 | |
103 | 103 | return $db_rec; |
104 | 104 | } |
@@ -122,25 +122,25 @@ discard block |
||
122 | 122 | echo "<th>Avg. Size per Row</th>"; |
123 | 123 | echo "</tr>"; |
124 | 124 | |
125 | - for ($i = 0; $i < sizeof($db_rec)-1; $i++){ |
|
125 | + for ($i = 0; $i < sizeof($db_rec) - 1; $i++) { |
|
126 | 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 | - echo "<td align=left valign=top class=fieldname>" . number_format($db_rec[$i]->rows) . "</td>"; |
|
132 | - echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->size_per_row) . "</td>"; |
|
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 | + echo "<td align=left valign=top class=fieldname>".number_format($db_rec[$i]->rows)."</td>"; |
|
132 | + echo "<td align=left valign=top class=fieldname>".size_format($db_rec[$i]->size_per_row)."</td>"; |
|
133 | 133 | echo "</tr>"; |
134 | 134 | } |
135 | 135 | |
136 | 136 | // Last record is just a summary |
137 | - $i = sizeof($db_rec)-1; |
|
137 | + $i = sizeof($db_rec) - 1; |
|
138 | 138 | echo "<tr>"; |
139 | - echo "<th align=left>" . $db_rec[$i]->name . "</th>"; |
|
140 | - echo "<th align=left>" . size_format($db_rec[$i]->data_size) . "</th>"; |
|
141 | - echo "<th align=left>" . size_format($db_rec[$i]->index_size) . "</th>"; |
|
142 | - echo "<th align=left>" . size_format($db_rec[$i]->total_size) . "</th>"; |
|
143 | - echo "<th align=left>" . number_format($db_rec[$i]->rows) . "</th>"; |
|
139 | + echo "<th align=left>".$db_rec[$i]->name."</th>"; |
|
140 | + echo "<th align=left>".size_format($db_rec[$i]->data_size)."</th>"; |
|
141 | + echo "<th align=left>".size_format($db_rec[$i]->index_size)."</th>"; |
|
142 | + echo "<th align=left>".size_format($db_rec[$i]->total_size)."</th>"; |
|
143 | + echo "<th align=left>".number_format($db_rec[$i]->rows)."</th>"; |
|
144 | 144 | echo "<th align=left></th>"; |
145 | 145 | echo "</tr>"; |
146 | 146 | |
@@ -156,27 +156,27 @@ discard block |
||
156 | 156 | $file_list = array(); |
157 | 157 | $file_sort = array(); |
158 | 158 | |
159 | - $sort = get_str("sort", true); |
|
159 | + $sort = get_str("sort", true); |
|
160 | 160 | $r = get_str("r", true); |
161 | 161 | |
162 | 162 | // check if its empty |
163 | - if(empty($sort)) $sort = "name"; |
|
163 | + if (empty($sort)) $sort = "name"; |
|
164 | 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)) |
|
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 | 171 | $sort = "name"; |
172 | - if(empty($r)) $r=0; |
|
172 | + if (empty($r)) $r = 0; |
|
173 | 173 | |
174 | - for ($i = 0; $i < sizeof($db_rec)-1; $i++){ |
|
174 | + for ($i = 0; $i < sizeof($db_rec) - 1; $i++) { |
|
175 | 175 | $file_details["name"] = $db_rec[$i]->name; |
176 | 176 | $file_details["data_size"] = $db_rec[$i]->data_size; |
177 | 177 | $file_details["index_size"] = $db_rec[$i]->index_size; |
178 | 178 | $file_details["total_size"] = $db_rec[$i]->total_size; |
179 | - $file_details["rows"] = $db_rec[$i]->rows; |
|
179 | + $file_details["rows"] = $db_rec[$i]->rows; |
|
180 | 180 | $file_details["size_per_row"] = $db_rec[$i]->size_per_row; |
181 | 181 | |
182 | 182 | $file_list[$i] = $file_details; |
@@ -184,7 +184,7 @@ discard block |
||
184 | 184 | $file_sort[$i] = $key; |
185 | 185 | } |
186 | 186 | |
187 | - if($r)arsort($file_sort); |
|
187 | + if ($r)arsort($file_sort); |
|
188 | 188 | else asort($file_sort); |
189 | 189 | // -- end sort |
190 | 190 | |
@@ -194,36 +194,36 @@ discard block |
||
194 | 194 | echo "</tr>"; |
195 | 195 | |
196 | 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>"; |
|
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 | 203 | echo "</tr>"; |
204 | 204 | |
205 | 205 | $i = 0; |
206 | - while ( list($key, $value) = each($file_sort) ) { |
|
206 | + while (list($key, $value) = each($file_sort)) { |
|
207 | 207 | $value = $file_list[$key]; |
208 | 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 | - echo "<td align=left valign=top class=fieldname>" . number_format($value["rows"]) . "</td>"; |
|
214 | - echo "<td align=left valign=top class=fieldname>" . size_format($value["size_per_row"]) . "</td>"; |
|
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 | + echo "<td align=left valign=top class=fieldname>".number_format($value["rows"])."</td>"; |
|
214 | + echo "<td align=left valign=top class=fieldname>".size_format($value["size_per_row"])."</td>"; |
|
215 | 215 | echo "</tr>"; |
216 | 216 | $i++; |
217 | 217 | } |
218 | 218 | |
219 | 219 | // Last record is just a summary |
220 | - $i = sizeof($db_rec)-1; |
|
220 | + $i = sizeof($db_rec) - 1; |
|
221 | 221 | echo "<tr>"; |
222 | - echo "<th align=left>" . $db_rec[$i]->name . "</th>"; |
|
223 | - echo "<th align=left>" . size_format($db_rec[$i]->data_size) . "</th>"; |
|
224 | - echo "<th align=left>" . size_format($db_rec[$i]->index_size) . "</th>"; |
|
225 | - echo "<th align=left>" . size_format($db_rec[$i]->total_size) . "</th>"; |
|
226 | - echo "<th align=left>" . number_format($db_rec[$i]->rows) . "</th>"; |
|
222 | + echo "<th align=left>".$db_rec[$i]->name."</th>"; |
|
223 | + echo "<th align=left>".size_format($db_rec[$i]->data_size)."</th>"; |
|
224 | + echo "<th align=left>".size_format($db_rec[$i]->index_size)."</th>"; |
|
225 | + echo "<th align=left>".size_format($db_rec[$i]->total_size)."</th>"; |
|
226 | + echo "<th align=left>".number_format($db_rec[$i]->rows)."</th>"; |
|
227 | 227 | echo "<th align=left></th>"; |
228 | 228 | echo "</tr>"; |
229 | 229 |
@@ -41,7 +41,7 @@ discard block |
||
41 | 41 | |
42 | 42 | |
43 | 43 | // returns formatted data size |
44 | -function size_format($size){ |
|
44 | +function size_format($size) { |
|
45 | 45 | $retval = 0; |
46 | 46 | |
47 | 47 | $KB = 1024; |
@@ -65,8 +65,7 @@ discard block |
||
65 | 65 | |
66 | 66 | |
67 | 67 | // returns the DB data structure as DB_REC |
68 | -function get_db_info($db_name) |
|
69 | -{ |
|
68 | +function get_db_info($db_name) { |
|
70 | 69 | // Carl grabbed this from the mysql.com boards http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html |
71 | 70 | $result = _mysql_query("SHOW TABLE STATUS FROM $db_name"); |
72 | 71 | |
@@ -105,8 +104,7 @@ discard block |
||
105 | 104 | |
106 | 105 | |
107 | 106 | // shows the plain db structure |
108 | -function show_db_info($db_name, $db_rec) |
|
109 | -{ |
|
107 | +function show_db_info($db_name, $db_rec) { |
|
110 | 108 | |
111 | 109 | echo "<table cols=6>"; |
112 | 110 | echo "<tr>"; |
@@ -122,7 +120,7 @@ discard block |
||
122 | 120 | echo "<th>Avg. Size per Row</th>"; |
123 | 121 | echo "</tr>"; |
124 | 122 | |
125 | - for ($i = 0; $i < sizeof($db_rec)-1; $i++){ |
|
123 | + for ($i = 0; $i < sizeof($db_rec)-1; $i++) { |
|
126 | 124 | echo "<tr>"; |
127 | 125 | echo "<td align=left valign=top class=fieldname>" . $db_rec[$i]->name . "</td>"; |
128 | 126 | echo "<td align=left valign=top class=fieldname>" . size_format($db_rec[$i]->data_size) . "</td>"; |
@@ -150,8 +148,7 @@ discard block |
||
150 | 148 | |
151 | 149 | |
152 | 150 | // NB: same as show_db_info but with sortable cloumns |
153 | -function sort_db_info($db_name, $db_rec) |
|
154 | -{ |
|
151 | +function sort_db_info($db_name, $db_rec) { |
|
155 | 152 | // sort |
156 | 153 | $file_list = array(); |
157 | 154 | $file_sort = array(); |
@@ -171,7 +168,7 @@ discard block |
||
171 | 168 | $sort = "name"; |
172 | 169 | if(empty($r)) $r=0; |
173 | 170 | |
174 | - for ($i = 0; $i < sizeof($db_rec)-1; $i++){ |
|
171 | + for ($i = 0; $i < sizeof($db_rec)-1; $i++) { |
|
175 | 172 | $file_details["name"] = $db_rec[$i]->name; |
176 | 173 | $file_details["data_size"] = $db_rec[$i]->data_size; |
177 | 174 | $file_details["index_size"] = $db_rec[$i]->index_size; |
@@ -32,7 +32,7 @@ discard block |
||
32 | 32 | $mid = 200; |
33 | 33 | $lo = $mid - $range; |
34 | 34 | $hi = $mid + $range; |
35 | - return imagecolorallocate($im, rand($lo,$hi), rand($lo,$hi), rand($lo,$hi)); |
|
35 | + return imagecolorallocate($im, rand($lo, $hi), rand($lo, $hi), rand($lo, $hi)); |
|
36 | 36 | } |
37 | 37 | |
38 | 38 | function add_ellipse($im, $case) { |
@@ -46,14 +46,14 @@ discard block |
||
46 | 46 | $cy = rand(-100, 400); |
47 | 47 | $w = rand(50, 100); |
48 | 48 | $h = rand(50, 100); |
49 | - imagefilledrectangle($im, $cx, $cy, $cx+$w, $cy+$h, rand_color($im, 50)); |
|
49 | + imagefilledrectangle($im, $cx, $cy, $cx + $w, $cy + $h, rand_color($im, 50)); |
|
50 | 50 | } |
51 | 51 | |
52 | 52 | |
53 | 53 | function make_image($case) { |
54 | 54 | $im = imagecreatetruecolor(600, 400); |
55 | 55 | imagefill($im, 0, 0, imagecolorallocate($im, 255, 255, 255)); |
56 | - for ($i=0; $i<400; $i++) { |
|
56 | + for ($i = 0; $i < 400; $i++) { |
|
57 | 57 | add_rect($im); |
58 | 58 | } |
59 | 59 | $im2 = imagecreatetruecolor(600, 400); |
@@ -85,7 +85,7 @@ discard block |
||
85 | 85 | $nfiles = 0; |
86 | 86 | $dir = null; |
87 | 87 | $ellipse_frac = 0.5; |
88 | -for ($i=1; $i<$argc; $i++) { |
|
88 | +for ($i = 1; $i < $argc; $i++) { |
|
89 | 89 | if ($argv[$i] == '--nfiles') $nfiles = $argv[++$i]; |
90 | 90 | elseif ($argv[$i] == '--dir') $dir = $argv[++$i]; |
91 | 91 | elseif ($argv[$i] == '--ellipse_frac') $ellipse_frac = $argv[++$i]; |
@@ -99,7 +99,7 @@ discard block |
||
99 | 99 | exit("$dir is not a directory\n"); |
100 | 100 | } |
101 | 101 | |
102 | -for ($i=0; $i<$nfiles; $i++) { |
|
102 | +for ($i = 0; $i < $nfiles; $i++) { |
|
103 | 103 | $path = "$dir/$i.png"; |
104 | 104 | $anspath = "$dir/$i.ans"; |
105 | 105 | $case = make_test_case($ellipse_frac); |
@@ -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 |
@@ -21,7 +21,7 @@ |
||
21 | 21 | |
22 | 22 | $db_revision = 0; |
23 | 23 | if (file_exists("../../db_revision")) { |
24 | - $db_revision = (int) file_get_contents("../../db_revision"); |
|
24 | + $db_revision = (int)file_get_contents("../../db_revision"); |
|
25 | 25 | } |
26 | 26 | require_once("db_update.php"); |
27 | 27 |
@@ -42,15 +42,15 @@ |
||
42 | 42 | $start_id = 0; //Set this to something else if you like |
43 | 43 | $profiles = _mysql_query("select * from profile where userid>$start_id order by userid"); |
44 | 44 | echo _mysql_error(); |
45 | - $i=0; |
|
46 | - while ($profile = _mysql_fetch_object($profiles)){ |
|
45 | + $i = 0; |
|
46 | + while ($profile = _mysql_fetch_object($profiles)) { |
|
47 | 47 | $i++; |
48 | 48 | if ($i%100 == 0) { //For every 100 profiles |
49 | - echo $profile->userid.". "; flush(); // print out where we are |
|
49 | + echo $profile->userid.". "; flush(); // print out where we are |
|
50 | 50 | //usleep(200000); |
51 | 51 | } |
52 | 52 | |
53 | - if ($profile->userid > $start_id){ |
|
53 | + if ($profile->userid > $start_id) { |
|
54 | 54 | fix_profile($profile); |
55 | 55 | } |
56 | 56 | } |
@@ -43,14 +43,15 @@ |
||
43 | 43 | $profiles = _mysql_query("select * from profile where userid>$start_id order by userid"); |
44 | 44 | echo _mysql_error(); |
45 | 45 | $i=0; |
46 | - while ($profile = _mysql_fetch_object($profiles)){ |
|
46 | + while ($profile = _mysql_fetch_object($profiles)) { |
|
47 | 47 | $i++; |
48 | - if ($i%100 == 0) { //For every 100 profiles |
|
48 | + if ($i%100 == 0) { |
|
49 | +//For every 100 profiles |
|
49 | 50 | echo $profile->userid.". "; flush(); // print out where we are |
50 | 51 | //usleep(200000); |
51 | 52 | } |
52 | 53 | |
53 | - if ($profile->userid > $start_id){ |
|
54 | + if ($profile->userid > $start_id) { |
|
54 | 55 | fix_profile($profile); |
55 | 56 | } |
56 | 57 | } |
@@ -197,5 +197,5 @@ |
||
197 | 197 | |
198 | 198 | admin_page_tail(); |
199 | 199 | |
200 | -$cvs_version_tracker[]="\$Id$"; //Generated automatically - do not edit |
|
200 | +$cvs_version_tracker[] = "\$Id$"; //Generated automatically - do not edit |
|
201 | 201 | ?> |
@@ -39,8 +39,8 @@ discard block |
||
39 | 39 | |
40 | 40 | // Delete a user if they have no credit, results, or posts |
41 | 41 | // |
42 | -function possibly_delete_user($user){ |
|
43 | - if ($user->total_credit > 0.0){ |
|
42 | +function possibly_delete_user($user) { |
|
43 | + if ($user->total_credit > 0.0) { |
|
44 | 44 | admin_error_page("Cannot delete user: User has credit."); |
45 | 45 | } |
46 | 46 | |
@@ -56,7 +56,7 @@ discard block |
||
56 | 56 | admin_error_page("Cannot delete user: User has forum posts."); |
57 | 57 | } |
58 | 58 | |
59 | - if ($user->teamid){ |
|
59 | + if ($user->teamid) { |
|
60 | 60 | user_quit_team($user); |
61 | 61 | } |
62 | 62 | delete_user($user); |
@@ -67,8 +67,8 @@ discard block |
||
67 | 67 | function handle_special_user($user) { |
68 | 68 | global $special_user_bitfield; |
69 | 69 | $Nbf = sizeof($special_user_bitfield); |
70 | - $bits=""; |
|
71 | - for ($i=0; $i<$Nbf; $i++) { |
|
70 | + $bits = ""; |
|
71 | + for ($i = 0; $i < $Nbf; $i++) { |
|
72 | 72 | $key = "special_user_$i"; |
73 | 73 | if (array_key_exists($key, $_POST) && $_POST[$key]) { |
74 | 74 | $bits .= "1"; |
@@ -94,35 +94,35 @@ discard block |
||
94 | 94 | ); |
95 | 95 | } else { |
96 | 96 | if (is_numeric($dt)) { |
97 | - $t = $dt>0 ? time()+$dt : 0; |
|
97 | + $t = $dt > 0 ? time() + $dt : 0; |
|
98 | 98 | $q = "UPDATE forum_preferences SET banished_until=$t WHERE userid=$user->id"; |
99 | 99 | _mysql_query($q); |
100 | 100 | |
101 | 101 | // put a timestamp in wiki to trigger re-validation of credentials |
102 | 102 | |
103 | - if (function_exists('touch_wiki_user')){ |
|
103 | + if (function_exists('touch_wiki_user')) { |
|
104 | 104 | touch_wiki_user($user); |
105 | 105 | } |
106 | 106 | |
107 | 107 | // Send suspension e-mail to user and administrators |
108 | 108 | |
109 | - if ($dt>0) { |
|
110 | - $subject = PROJECT." posting privileges suspended for ". $user->name; |
|
109 | + if ($dt > 0) { |
|
110 | + $subject = PROJECT." posting privileges suspended for ".$user->name; |
|
111 | 111 | $body = " |
112 | -Forum posting privileges for the " .PROJECT. " user \"".$user->name."\" |
|
113 | -have been suspended for " .time_diff($dt). " by ".$g_logged_in_user->name.". |
|
112 | +Forum posting privileges for the " .PROJECT." user \"".$user->name."\" |
|
113 | +have been suspended for " .time_diff($dt)." by ".$g_logged_in_user->name.". |
|
114 | 114 | The reason given was: |
115 | 115 | |
116 | 116 | $reason |
117 | 117 | |
118 | -The suspension will end at " .time_str($t)."\n"; |
|
118 | +The suspension will end at ".time_str($t)."\n"; |
|
119 | 119 | } else { |
120 | - $subject = PROJECT." user ". $user->name. " unsuspended"; |
|
120 | + $subject = PROJECT." user ".$user->name." unsuspended"; |
|
121 | 121 | $body = " |
122 | -Forum posting privileges for the " .PROJECT. " user \"".$user->name."\" |
|
122 | +Forum posting privileges for the " .PROJECT." user \"".$user->name."\" |
|
123 | 123 | have been restored by ".$g_logged_in_user->name."\n"; |
124 | 124 | if ($reason) { |
125 | - $body.="The reason given was:\n\n $reason\n"; |
|
125 | + $body .= "The reason given was:\n\n $reason\n"; |
|
126 | 126 | } |
127 | 127 | } |
128 | 128 | |
@@ -186,13 +186,13 @@ discard block |
||
186 | 186 | row1("Special User Status"); |
187 | 187 | |
188 | 188 | echo "<tr>\n"; |
189 | - for ($i=0; $i<$Nbf; $i++) { |
|
189 | + for ($i = 0; $i < $Nbf; $i++) { |
|
190 | 190 | $bit = substr($user->prefs->special_user, $i, 1); |
191 | 191 | echo "<tr><td><input type='checkbox'' name='special_user_".$i."' value='1'"; |
192 | 192 | if ($bit == 1) { |
193 | 193 | echo " checked='checked'"; |
194 | 194 | } |
195 | - echo ">". $special_user_bitfield[$i] ."</td></tr>\n"; |
|
195 | + echo ">".$special_user_bitfield[$i]."</td></tr>\n"; |
|
196 | 196 | } |
197 | 197 | echo "</tr>"; |
198 | 198 | |
@@ -217,10 +217,10 @@ discard block |
||
217 | 217 | if ($user->prefs->banished_until) { |
218 | 218 | $dt = $user->prefs->banished_until - time(); |
219 | 219 | if ($dt > 0) { |
220 | - $x = " Suspended until " . time_str($user->prefs->banished_until) |
|
221 | - ."<br/> (Expires in " . time_diff($dt) .")" ; |
|
220 | + $x = " Suspended until ".time_str($user->prefs->banished_until) |
|
221 | + ."<br/> (Expires in ".time_diff($dt).")"; |
|
222 | 222 | } else { |
223 | - $x = " last suspended " . time_str($user->prefs->banished_until); |
|
223 | + $x = " last suspended ".time_str($user->prefs->banished_until); |
|
224 | 224 | } |
225 | 225 | row1($x); |
226 | 226 | } else { |
@@ -238,11 +238,11 @@ discard block |
||
238 | 238 | "; |
239 | 239 | echo " |
240 | 240 | <input type='radio' name='suspend_for' value='172800'> 48 hours <br/> |
241 | - <input type='radio' name='suspend_for' value='",86400*7,"'> 1 week <br/> |
|
242 | - <input type='radio' name='suspend_for' value='",86400*14,"'> 2 weeks <br/> |
|
241 | + <input type='radio' name='suspend_for' value='",86400*7, "'> 1 week <br/> |
|
242 | + <input type='radio' name='suspend_for' value='",86400*14, "'> 2 weeks <br/> |
|
243 | 243 | "; |
244 | 244 | |
245 | - if ($dt>0) { |
|
245 | + if ($dt > 0) { |
|
246 | 246 | echo " |
247 | 247 | <input type='radio' name='suspend_for' value='-1'> <b>unsuspend</b> <br/>"; |
248 | 248 | } |
@@ -306,6 +306,6 @@ discard block |
||
306 | 306 | |
307 | 307 | show_manage_user_form($user); |
308 | 308 | |
309 | -$cvs_version_tracker[]= //Generated automatically - do not edit |
|
309 | +$cvs_version_tracker[] = //Generated automatically - do not edit |
|
310 | 310 | "\$Id$"; |
311 | 311 | ?> |
@@ -39,8 +39,8 @@ discard block |
||
39 | 39 | |
40 | 40 | // Delete a user if they have no credit, results, or posts |
41 | 41 | // |
42 | -function possibly_delete_user($user){ |
|
43 | - if ($user->total_credit > 0.0){ |
|
42 | +function possibly_delete_user($user) { |
|
43 | + if ($user->total_credit > 0.0) { |
|
44 | 44 | admin_error_page("Cannot delete user: User has credit."); |
45 | 45 | } |
46 | 46 | |
@@ -56,7 +56,7 @@ discard block |
||
56 | 56 | admin_error_page("Cannot delete user: User has forum posts."); |
57 | 57 | } |
58 | 58 | |
59 | - if ($user->teamid){ |
|
59 | + if ($user->teamid) { |
|
60 | 60 | user_quit_team($user); |
61 | 61 | } |
62 | 62 | delete_user($user); |
@@ -100,7 +100,7 @@ discard block |
||
100 | 100 | |
101 | 101 | // put a timestamp in wiki to trigger re-validation of credentials |
102 | 102 | |
103 | - if (function_exists('touch_wiki_user')){ |
|
103 | + if (function_exists('touch_wiki_user')) { |
|
104 | 104 | touch_wiki_user($user); |
105 | 105 | } |
106 | 106 |
@@ -141,7 +141,7 @@ |
||
141 | 141 | global $special_user_bitfield; |
142 | 142 | $Nbf = sizeof($special_user_bitfield); |
143 | 143 | |
144 | - admin_page_head("Management $user->name"); |
|
144 | + admin_page_head("management $user->name"); |
|
145 | 145 | |
146 | 146 | if (!defined("POST_REPORT_EMAILS")) { |
147 | 147 | echo "<p><font color='RED'> |
@@ -274,7 +274,7 @@ discard block |
||
274 | 274 | do_query("alter table host add max_results_day integer not null"); |
275 | 275 | } |
276 | 276 | |
277 | -function update_4_20_2005(){ |
|
277 | +function update_4_20_2005() { |
|
278 | 278 | do_query("ALTER TABLE `thread` ADD `sticky` TINYINT UNSIGNED DEFAULT '0' NOT NULL"); |
279 | 279 | do_query("ALTER TABLE `forum` ADD `post_min_total_credit` INT NOT NULL AFTER `posts`"); |
280 | 280 | do_query("ALTER TABLE `forum` ADD `post_min_expavg_credit` INT NOT NULL AFTER `posts`"); |
@@ -284,7 +284,7 @@ discard block |
||
284 | 284 | do_query("ALTER TABLE `forum_preferences` ADD `last_post` INT( 14 ) UNSIGNED NOT NULL AFTER `posts`"); |
285 | 285 | } |
286 | 286 | |
287 | -function update_4_30_2005(){ |
|
287 | +function update_4_30_2005() { |
|
288 | 288 | do_query("ALTER TABLE `forum_preferences` ADD `ignore_sticky_posts` TINYINT( 1 ) UNSIGNED NOT NULL"); |
289 | 289 | } |
290 | 290 | |
@@ -311,7 +311,7 @@ discard block |
||
311 | 311 | do_query("update user set country='Macedonia' where country='Macedonia, The Former Yugoslav Republic of'"); |
312 | 312 | } |
313 | 313 | |
314 | -function update_11_24_2005(){ |
|
314 | +function update_11_24_2005() { |
|
315 | 315 | do_query("ALTER TABLE `forum_preferences` ADD `minimum_wrap_postcount` INT DEFAULT '100' NOT NULL AFTER `high_rating_threshold` , |
316 | 316 | ADD `display_wrap_postcount` INT DEFAULT '75' NOT NULL AFTER `minimum_wrap_postcount`"); |
317 | 317 | } |
@@ -616,7 +616,7 @@ discard block |
||
616 | 616 | "); |
617 | 617 | } |
618 | 618 | |
619 | -function update_10_05_2008(){ |
|
619 | +function update_10_05_2008() { |
|
620 | 620 | do_query("alter table forum_preferences add highlight_special tinyint default '1' not null"); |
621 | 621 | } |
622 | 622 | |
@@ -1045,7 +1045,7 @@ discard block |
||
1045 | 1045 | // This used to be the Subversion version#, |
1046 | 1046 | // but with Git we just use sequential integers |
1047 | 1047 | // |
1048 | -$db_updates = array ( |
|
1048 | +$db_updates = array( |
|
1049 | 1049 | array(18490, "update_6_16_2009"), |
1050 | 1050 | array(19001, "update_9_3_2009"), |
1051 | 1051 | array(20807, "update_3_5_2010"), |
@@ -274,7 +274,7 @@ discard block |
||
274 | 274 | do_query("alter table host add max_results_day integer not null"); |
275 | 275 | } |
276 | 276 | |
277 | -function update_4_20_2005(){ |
|
277 | +function update_4_20_2005() { |
|
278 | 278 | do_query("ALTER TABLE `thread` ADD `sticky` TINYINT UNSIGNED DEFAULT '0' NOT NULL"); |
279 | 279 | do_query("ALTER TABLE `forum` ADD `post_min_total_credit` INT NOT NULL AFTER `posts`"); |
280 | 280 | do_query("ALTER TABLE `forum` ADD `post_min_expavg_credit` INT NOT NULL AFTER `posts`"); |
@@ -284,7 +284,7 @@ discard block |
||
284 | 284 | do_query("ALTER TABLE `forum_preferences` ADD `last_post` INT( 14 ) UNSIGNED NOT NULL AFTER `posts`"); |
285 | 285 | } |
286 | 286 | |
287 | -function update_4_30_2005(){ |
|
287 | +function update_4_30_2005() { |
|
288 | 288 | do_query("ALTER TABLE `forum_preferences` ADD `ignore_sticky_posts` TINYINT( 1 ) UNSIGNED NOT NULL"); |
289 | 289 | } |
290 | 290 | |
@@ -311,7 +311,7 @@ discard block |
||
311 | 311 | do_query("update user set country='Macedonia' where country='Macedonia, The Former Yugoslav Republic of'"); |
312 | 312 | } |
313 | 313 | |
314 | -function update_11_24_2005(){ |
|
314 | +function update_11_24_2005() { |
|
315 | 315 | do_query("ALTER TABLE `forum_preferences` ADD `minimum_wrap_postcount` INT DEFAULT '100' NOT NULL AFTER `high_rating_threshold` , |
316 | 316 | ADD `display_wrap_postcount` INT DEFAULT '75' NOT NULL AFTER `minimum_wrap_postcount`"); |
317 | 317 | } |
@@ -616,7 +616,7 @@ discard block |
||
616 | 616 | "); |
617 | 617 | } |
618 | 618 | |
619 | -function update_10_05_2008(){ |
|
619 | +function update_10_05_2008() { |
|
620 | 620 | do_query("alter table forum_preferences add highlight_special tinyint default '1' not null"); |
621 | 621 | } |
622 | 622 |
@@ -58,7 +58,7 @@ discard block |
||
58 | 58 | $post = array(); |
59 | 59 | $post["request"] = $xml; |
60 | 60 | if ($req->type == "upload") { |
61 | - $i=0; |
|
61 | + $i = 0; |
|
62 | 62 | foreach ($files as $f) { |
63 | 63 | if ($f['path'] != "") { |
64 | 64 | $post["file_$i"] = '@'.$f['path']; |
@@ -70,9 +70,9 @@ discard block |
||
70 | 70 | curl_setopt($ch, CURLOPT_POSTFIELDS, $post); |
71 | 71 | $reply = curl_exec($ch); |
72 | 72 | if ($reply) { |
73 | - print $reply . "\n"; |
|
73 | + print $reply."\n"; |
|
74 | 74 | } else { |
75 | - print curl_error($ch) . "\n"; |
|
75 | + print curl_error($ch)."\n"; |
|
76 | 76 | } |
77 | 77 | curl_close($ch); |
78 | 78 | } |