@@ -27,7 +27,7 @@ discard block |
||
| 27 | 27 | |
| 28 | 28 | function init_conn($user, $passwd, $host, $name) { |
| 29 | 29 | $x = explode(":", $host); |
| 30 | - if (sizeof($x)>1) { |
|
| 30 | + if (sizeof($x) > 1) { |
|
| 31 | 31 | $host = $x[0]; |
| 32 | 32 | $port = $x[1]; |
| 33 | 33 | } else { |
@@ -131,10 +131,10 @@ discard block |
||
| 131 | 131 | $where_clause = "where $where_clause"; |
| 132 | 132 | } |
| 133 | 133 | $query = "select $fields from DBNAME.$table $where_clause $order_clause"; |
| 134 | - return $this->enum_general($classname,$query); |
|
| 134 | + return $this->enum_general($classname, $query); |
|
| 135 | 135 | } |
| 136 | 136 | |
| 137 | - function enum($table, $classname, $where_clause=null, $order_clause=null) { |
|
| 137 | + function enum($table, $classname, $where_clause = null, $order_clause = null) { |
|
| 138 | 138 | return self::enum_fields( |
| 139 | 139 | $table, $classname, '*', $where_clause, $order_clause |
| 140 | 140 | ); |
@@ -179,15 +179,15 @@ discard block |
||
| 179 | 179 | if ($x) return (double)$x->$field; |
| 180 | 180 | return false; |
| 181 | 181 | } |
| 182 | - function count($table, $clause="TRUE") { |
|
| 182 | + function count($table, $clause = "TRUE") { |
|
| 183 | 183 | $query = "select count(*) as total from DBNAME.$table where $clause"; |
| 184 | 184 | return $this->get_int($query, 'total'); |
| 185 | 185 | } |
| 186 | - function sum($table, $field, $clause="") { |
|
| 186 | + function sum($table, $field, $clause = "") { |
|
| 187 | 187 | $query = "select sum($field) as total from DBNAME.$table $clause"; |
| 188 | 188 | return $this->get_double($query, 'total'); |
| 189 | 189 | } |
| 190 | - function max($table, $field, $clause="") { |
|
| 190 | + function max($table, $field, $clause = "") { |
|
| 191 | 191 | $query = "select max($field) as total from DBNAME.$table $clause"; |
| 192 | 192 | return $this->get_double($query, 'total'); |
| 193 | 193 | } |
@@ -33,7 +33,8 @@ |
||
| 33 | 33 | } else { |
| 34 | 34 | $port = null; |
| 35 | 35 | } |
| 36 | - if (1) { // don't use persistent connections for now |
|
| 36 | + if (1) { |
|
| 37 | +// don't use persistent connections for now |
|
| 37 | 38 | $this->db_conn = @new mysqli( |
| 38 | 39 | $host, $user, $passwd, $name, $port |
| 39 | 40 | ); |
@@ -49,7 +49,7 @@ discard block |
||
| 49 | 49 | self::$instance = null; |
| 50 | 50 | $config = get_config(); |
| 51 | 51 | if ($dbnum) { |
| 52 | - $r = $dbnum==1?'':strval($dbnum); |
|
| 52 | + $r = $dbnum == 1 ? '' : strval($dbnum); |
|
| 53 | 53 | $host = parse_config($config, sprintf('<replica%s_db_host>', $r)); |
| 54 | 54 | $name = parse_config($config, sprintf('<replica%s_db_name>', $r)); |
| 55 | 55 | $user = parse_config($config, sprintf('<replica%s_db_user>', $r)); |
@@ -189,11 +189,11 @@ discard block |
||
| 189 | 189 | $db = BoincDb::get(); |
| 190 | 190 | return $db->update($this, 'user', $clause); |
| 191 | 191 | } |
| 192 | - static function enum($where_clause, $order_clause=null) { |
|
| 192 | + static function enum($where_clause, $order_clause = null) { |
|
| 193 | 193 | $db = BoincDb::get(); |
| 194 | 194 | return $db->enum('user', 'BoincUser', $where_clause, $order_clause); |
| 195 | 195 | } |
| 196 | - static function enum_fields($fields, $where_clause, $order_clause=null) { |
|
| 196 | + static function enum_fields($fields, $where_clause, $order_clause = null) { |
|
| 197 | 197 | $db = BoincDb::get(); |
| 198 | 198 | return $db->enum_fields( |
| 199 | 199 | 'user', 'BoincUser', $fields, $where_clause, $order_clause |
@@ -243,7 +243,7 @@ discard block |
||
| 243 | 243 | $db = BoincDb::get(); |
| 244 | 244 | return $db->update($this, 'team', $clause); |
| 245 | 245 | } |
| 246 | - static function enum($where_clause, $order_clause=null) { |
|
| 246 | + static function enum($where_clause, $order_clause = null) { |
|
| 247 | 247 | $db = BoincDb::get(); |
| 248 | 248 | return $db->enum('team', 'BoincTeam', $where_clause, $order_clause); |
| 249 | 249 | } |
@@ -268,7 +268,7 @@ discard block |
||
| 268 | 268 | $db = BoincDb::get(); |
| 269 | 269 | return $db->max('team', $field); |
| 270 | 270 | } |
| 271 | - static function enum_fields($fields, $where_clause, $order_clause=null) { |
|
| 271 | + static function enum_fields($fields, $where_clause, $order_clause = null) { |
|
| 272 | 272 | $db = BoincDb::get(); |
| 273 | 273 | return $db->enum_fields( |
| 274 | 274 | 'team', 'BoincTeam', $fields, $where_clause, $order_clause |
@@ -306,11 +306,11 @@ discard block |
||
| 306 | 306 | $db = BoincDb::get(); |
| 307 | 307 | return $db->delete($this, 'host'); |
| 308 | 308 | } |
| 309 | - static function enum($where_clause, $order_clause=null) { |
|
| 309 | + static function enum($where_clause, $order_clause = null) { |
|
| 310 | 310 | $db = BoincDb::get(); |
| 311 | 311 | return $db->enum('host', 'BoincHost', $where_clause, $order_clause); |
| 312 | 312 | } |
| 313 | - static function enum_fields($fields, $where_clause, $order_clause=null) { |
|
| 313 | + static function enum_fields($fields, $where_clause, $order_clause = null) { |
|
| 314 | 314 | $db = BoincDb::get(); |
| 315 | 315 | return $db->enum_fields( |
| 316 | 316 | 'host', 'BoincHost', $fields, $where_clause, $order_clause |
@@ -432,7 +432,7 @@ discard block |
||
| 432 | 432 | $db = BoincDb::get(); |
| 433 | 433 | return $db->update($this, 'app', $clause); |
| 434 | 434 | } |
| 435 | - static function sum($field, $clause=null) { |
|
| 435 | + static function sum($field, $clause = null) { |
|
| 436 | 436 | $db = BoincDb::get(); |
| 437 | 437 | return $db->sum('app', $field, $clause); |
| 438 | 438 | } |
@@ -490,11 +490,11 @@ discard block |
||
| 490 | 490 | $db = BoincDb::get(); |
| 491 | 491 | return $db->insert('profile', $clause); |
| 492 | 492 | } |
| 493 | - static function enum($where_clause=null, $order_clause=null) { |
|
| 493 | + static function enum($where_clause = null, $order_clause = null) { |
|
| 494 | 494 | $db = BoincDb::get(); |
| 495 | 495 | return $db->enum('profile', 'BoincProfile', $where_clause, $order_clause); |
| 496 | 496 | } |
| 497 | - static function enum_fields($fields, $where_clause=null, $order_clause=null) { |
|
| 497 | + static function enum_fields($fields, $where_clause = null, $order_clause = null) { |
|
| 498 | 498 | $db = BoincDb::get(); |
| 499 | 499 | return $db->enum_fields('profile', 'BoincProfile', $fields, $where_clause, $order_clause); |
| 500 | 500 | } |
@@ -889,12 +889,12 @@ discard block |
||
| 889 | 889 | return $db->enum('consent', 'BoincConsent', $where_clause); |
| 890 | 890 | } |
| 891 | 891 | |
| 892 | - static function insert ($clause) { |
|
| 892 | + static function insert($clause) { |
|
| 893 | 893 | $db = BoincDb::get(); |
| 894 | 894 | return $db->insert('consent', $clause); |
| 895 | 895 | } |
| 896 | 896 | |
| 897 | - static function update ($clause) { |
|
| 897 | + static function update($clause) { |
|
| 898 | 898 | $db = BoincDb::get(); |
| 899 | 899 | return $db->update_aux('consent', $clause); |
| 900 | 900 | } |
@@ -919,17 +919,17 @@ discard block |
||
| 919 | 919 | return $db->lookup('consent_type', 'BoincConsentType', $clause); |
| 920 | 920 | } |
| 921 | 921 | |
| 922 | - static function enum($where_clause, $order_clause=null) { |
|
| 922 | + static function enum($where_clause, $order_clause = null) { |
|
| 923 | 923 | $db = BoincDb::get(); |
| 924 | 924 | return $db->enum('consent_type', 'BoincConsentType', $where_clause, $order_clause); |
| 925 | 925 | } |
| 926 | 926 | |
| 927 | - static function insert ($clause) { |
|
| 927 | + static function insert($clause) { |
|
| 928 | 928 | $db = BoincDb::get(); |
| 929 | 929 | return $db->insert('consent_type', $clause); |
| 930 | 930 | } |
| 931 | 931 | |
| 932 | - static function update ($clause) { |
|
| 932 | + static function update($clause) { |
|
| 933 | 933 | $db = BoincDb::get(); |
| 934 | 934 | return $db->update_aux('consent_type', $clause); |
| 935 | 935 | } |
@@ -955,7 +955,7 @@ discard block |
||
| 955 | 955 | return $db->lookup('latest_consent', 'BoincLatestConsent', $clause); |
| 956 | 956 | } |
| 957 | 957 | |
| 958 | - static function enum($where_clause, $order_clause=null) { |
|
| 958 | + static function enum($where_clause, $order_clause = null) { |
|
| 959 | 959 | $db = BoincDb::get(); |
| 960 | 960 | return $db->enum('latest_consent', 'BoincLatestConsent', $where_clause, $order_clause); |
| 961 | 961 | } |
@@ -966,7 +966,7 @@ discard block |
||
| 966 | 966 | // apply this to any user-supplied strings used in queries |
| 967 | 967 | // |
| 968 | 968 | function boinc_real_escape_string($x) { |
| 969 | - if (version_compare(phpversion(),"4.3.0")>=0) { |
|
| 969 | + if (version_compare(phpversion(), "4.3.0") >= 0) { |
|
| 970 | 970 | return BoincDb::escape_string($x); |
| 971 | 971 | } else { |
| 972 | 972 | $x = str_replace("'", "\'", $x); |