GitHub Access Token became invalid

It seems like the GitHub access token used for retrieving details about this repository from GitHub became invalid. This might prevent certain types of inspections from being run (in particular, everything related to pull requests).
Please ask an admin of your repository to re-new the access token on this website.
Completed
Push — master ( b79b58...ea0e22 )
by Marco
04:53
created
function.php 4 patches
Doc Comments   +14 added lines patch added patch discarded remove patch
@@ -226,6 +226,9 @@  discard block
 block discarded – undo
226 226
 }
227 227
 
228 228
 
229
+/**
230
+ * @param integer $id
231
+ */
229 232
 function askMilter($myconn,$id,$obj,$typedesc,$miltId,$value,$user,$adm)  {
230 233
 	$milts = readMiltName($myconn,$user);
231 234
 	$size = count($milts);
@@ -256,6 +259,11 @@  discard block
 block discarded – undo
256 259
 }
257 260
 
258 261
 
262
+/**
263
+ * @param integer $id
264
+ * @param string $what
265
+ * @param boolean $lock
266
+ */
259 267
 function ask($myconn,$id,$what,$alltables,$typedesc,$value,$lock,$user,$adm) {
260 268
 
261 269
 	$whynot=NULL;
@@ -514,6 +522,9 @@  discard block
 block discarded – undo
514 522
 }
515 523
 
516 524
 
525
+/**
526
+ * @param string $reason
527
+ */
517 528
 function searchAndList ($myconn,$loguser,$tables,$typedesc,$value,$unit,&$quantity,$reason) {
518 529
 
519 530
 /* Search and list value */
@@ -580,6 +591,9 @@  discard block
 block discarded – undo
580 591
 	return array_map('long2ip', range( ip2long($range[0]), ip2long($range[1]) ) );
581 592
 }
582 593
 
594
+/**
595
+ * @param string $netA
596
+ */
583 597
 function isIn($netA, $netB) {
584 598
 /* TRUE if an IP of $netA is contained in netB */
585 599
 	list($addressA,$maskA) = explode('/', $netA);
Please login to merge, or discard this patch.
Indentation   +149 added lines, -149 removed lines patch added patch discarded remove patch
@@ -4,18 +4,18 @@  discard block
 block discarded – undo
4 4
 
5 5
 function username() {
6 6
 	if (isset ($_SERVER['REMOTE_USER'])) $user = $_SERVER['REMOTE_USER'];
7
-        	else if (isset ($_SERVER['USER'])) $user = $_SERVER['USER'];
8
-                	else $user='unknown';
7
+			else if (isset ($_SERVER['USER'])) $user = $_SERVER['USER'];
8
+					else $user='unknown';
9 9
 	return $user;
10 10
 }
11 11
 
12 12
 
13 13
 function myConnect($host, $user, $pass, $db, $port, $tablelist, $typedesc, $loguser) {
14
-        $db = ( $tablelist["$typedesc"]['milter'] ) ? $tablelist["$typedesc"]['name'] : $db;
14
+		$db = ( $tablelist["$typedesc"]['milter'] ) ? $tablelist["$typedesc"]['name'] : $db;
15 15
 	$mysqli = new mysqli($host, $user, $pass, $db, $port);
16
-        if ($mysqli->connect_error) {
17
-           	syslog (LOG_EMERG, $loguser.': Connect Error to DB <'.$db.'> (' . $mysqli->connect_errno . ') '
18
-                    		. $mysqli->connect_error);
16
+		if ($mysqli->connect_error) {
17
+		   	syslog (LOG_EMERG, $loguser.': Connect Error to DB <'.$db.'> (' . $mysqli->connect_errno . ') '
18
+							. $mysqli->connect_error);
19 19
 		return FALSE;
20 20
 	}
21 21
 	syslog(LOG_INFO, $loguser.': Successfully MySQL connected at DB <'.$db.'> to ' . $mysqli->host_info) ;
@@ -56,7 +56,7 @@  discard block
 block discarded – undo
56 56
 			}
57 57
 		}
58 58
 		list($sub['net'],$sub['mask'])=explode('/',$value);
59
-                $query= sprintf("INSERT INTO `$table` (
59
+				$query= sprintf("INSERT INTO `$table` (
60 60
                         `$type` ,
61 61
 			`netmask`,
62 62
                         `date` ,
@@ -69,10 +69,10 @@  discard block
 block discarded – undo
69 69
                         INET_ATON( '%s' ) , INET_ATON( '%s' ) ,
70 70
                         CURRENT_TIMESTAMP , TIMESTAMPADD(%s,%d,CURRENT_TIMESTAMP), '1', '%s', '%s'
71 71
                 )" ,$sub['net'],$sub['mask'],$expUnit,$expQ,$user,$myreason);
72
-                break;
72
+				break;
73 73
 
74 74
 	  default:
75
-                $query= sprintf("INSERT INTO `$table` (
75
+				$query= sprintf("INSERT INTO `$table` (
76 76
                         `$type` ,
77 77
                         `date` ,
78 78
                         `exp` ,
@@ -87,8 +87,8 @@  discard block
 block discarded – undo
87 87
 	}
88 88
 
89 89
 	if ($myconn->query($query) === TRUE) {
90
-	    syslog(LOG_INFO, "$user: $type <$value> successfully listed on <$table> for $expQ $expUnit.");
91
-	    $result=TRUE;
90
+		syslog(LOG_INFO, "$user: $type <$value> successfully listed on <$table> for $expQ $expUnit.");
91
+		$result=TRUE;
92 92
 	}
93 93
 	else syslog(LOG_ERR, "$user: Error: ".$myconn->error);
94 94
 	return $result;
@@ -98,9 +98,9 @@  discard block
 block discarded – undo
98 98
 
99 99
 	$result=FALSE;
100 100
 
101
-        switch ($type) {
101
+		switch ($type) {
102 102
 	  case 'ip':
103
-                $query= sprintf("UPDATE `$table` SET
103
+				$query= sprintf("UPDATE `$table` SET
104 104
 			`active` = '1',
105 105
 			`user` = '%s',
106 106
 			`exp` = TIMESTAMPADD(%s,%d,CURRENT_TIMESTAMP),
@@ -108,9 +108,9 @@  discard block
 block discarded – undo
108 108
 			`reason` = '%s'
109 109
 			WHERE `$table`.`$type` = INET_ATON('%s') LIMIT 1" ,$user,$expUnit,$expQ,$myreason,$value);
110 110
 		break;
111
-          case 'network':
111
+		  case 'network':
112 112
 		list($sub['net'],$sub['mask'])=explode('/',$value);
113
-                $query= sprintf("UPDATE `$table` SET
113
+				$query= sprintf("UPDATE `$table` SET
114 114
                         `active` = '1',
115 115
                         `user` = '%s',
116 116
                         `exp` = TIMESTAMPADD(%s,%d,CURRENT_TIMESTAMP),
@@ -119,7 +119,7 @@  discard block
 block discarded – undo
119 119
                         WHERE (`$table`.`$type` = INET_ATON('%s') AND `$table`.`netmask` = INET_ATON('%s')) LIMIT 1" ,$user,$expUnit,$expQ,$myreason,$sub['net'],$sub['mask']);
120 120
 		break;
121 121
 	  default:
122
-                $query= sprintf("UPDATE `$table` SET
122
+				$query= sprintf("UPDATE `$table` SET
123 123
                         `active` = '1',
124 124
                         `user` = '%s',
125 125
                         `exp` = TIMESTAMPADD(%s,%d,CURRENT_TIMESTAMP),
@@ -128,18 +128,18 @@  discard block
 block discarded – undo
128 128
 			WHERE `$table`.`$type` = '%s' LIMIT 1" ,$user,$expUnit,$expQ,$myreason,$value);
129 129
 	}
130 130
 
131
-        if ($myconn->query($query) === TRUE) {
132
-            syslog(LOG_INFO, "$user: relist $type <$value> on <$table> for $expQ $expUnit.");
131
+		if ($myconn->query($query) === TRUE) {
132
+			syslog(LOG_INFO, "$user: relist $type <$value> on <$table> for $expQ $expUnit.");
133 133
 		$result=TRUE;
134
-        }
135
-        else syslog (LOG_ERR, "$user: Error: ". $myconn->error);
134
+		}
135
+		else syslog (LOG_ERR, "$user: Error: ". $myconn->error);
136 136
 	return $result;
137 137
 }
138 138
 
139 139
 function remove ($myconn,$user,$value,$type,$table) {
140 140
 
141
-        switch ($type) {
142
-          case 'ip':
141
+		switch ($type) {
142
+		  case 'ip':
143 143
 		$query = sprintf("DELETE FROM `$table` WHERE
144 144
                         `$table`.`$type` = INET_ATON('%s') LIMIT 1", $value);
145 145
 		break;
@@ -155,18 +155,18 @@  discard block
 block discarded – undo
155 155
 	}
156 156
 
157 157
 
158
-        if ($return=$myconn->query($query) === TRUE) 
159
-            syslog(LOG_INFO, "$user: permanently DELETED $type <$value> from <$table>.");
160
-        else syslog(LOG_ERR, "$user: Error: ". $myconn->error);
158
+		if ($return=$myconn->query($query) === TRUE) 
159
+			syslog(LOG_INFO, "$user: permanently DELETED $type <$value> from <$table>.");
160
+		else syslog(LOG_ERR, "$user: Error: ". $myconn->error);
161 161
 
162
-        return $return;
162
+		return $return;
163 163
 }
164 164
 
165 165
 
166 166
 function changestatus ($myconn,$user,$value,$status,$type,$table) {
167 167
 
168 168
 	switch ($type) {
169
-          case 'ip':
169
+		  case 'ip':
170 170
 		$query= sprintf("UPDATE `$table` SET `active` = '$status', `user` = '%s' WHERE `$table`.`$type` = INET_ATON('%s') LIMIT 1" ,$user, $value);
171 171
 		break;
172 172
 	  case 'network':
@@ -177,16 +177,16 @@  discard block
 block discarded – undo
177 177
 		$query= sprintf("UPDATE `$table` SET `active` = '$status', `user` = '%s' WHERE `$table`.`$type` = '%s' LIMIT 1" ,$user, $value);
178 178
 	}
179 179
 
180
-        if ($return=$myconn->query($query) === TRUE) {
181
-            syslog(LOG_INFO, "$user: change status of $type <$value>. The status is now <$status>");
182
-        }
183
-        else syslog(LOG_ERR, "$user: Error: ". $myconn->error);
180
+		if ($return=$myconn->query($query) === TRUE) {
181
+			syslog(LOG_INFO, "$user: change status of $type <$value>. The status is now <$status>");
182
+		}
183
+		else syslog(LOG_ERR, "$user: Error: ". $myconn->error);
184 184
 	return $return;	
185 185
 }
186 186
 
187 187
 
188 188
 function expire ($myconn,$user,$tables,$expireTime) {
189
-        $return=TRUE;
189
+		$return=TRUE;
190 190
 	$log=array();
191 191
 	$desc = array_keys($tables);
192 192
 	foreach ($desc as $tdesc) { 
@@ -196,11 +196,11 @@  discard block
 block discarded – undo
196 196
 		/* END OF QUERY */
197 197
 		$log[0] = 'expired for';
198 198
 		$log[1] = 'disabled for';
199
-        	if ($myconn->multi_query($query)) {
199
+			if ($myconn->multi_query($query)) {
200 200
 			$j = 0;
201 201
 			do {
202
-		    		$numdel = $myconn->affected_rows;
203
-	            		syslog(LOG_INFO, "Expire job - <$user> Permanently DELETED $numdel records ".$log[$j]." $expireTime YEARS from <".$tables["$tdesc"]['name'].'>.');
202
+					$numdel = $myconn->affected_rows;
203
+						syslog(LOG_INFO, "Expire job - <$user> Permanently DELETED $numdel records ".$log[$j]." $expireTime YEARS from <".$tables["$tdesc"]['name'].'>.');
204 204
 				$j++;
205 205
 
206 206
 			} while ($myconn->next_result());
@@ -212,7 +212,7 @@  discard block
 block discarded – undo
212 212
 	}
213 213
 	if ( !($return) ) syslog(LOG_EMERG, 'End of Expire job with error. See above logs. SQL Connection terminated');
214 214
 	else  syslog(LOG_INFO, 'Successfully End of Expire job. SQL Connection successfully terminated.');
215
-        return $return;
215
+		return $return;
216 216
 }
217 217
 
218 218
 
@@ -285,7 +285,7 @@  discard block
 block discarded – undo
285 285
 		if ( $entry->num_rows ) {
286 286
 			if ( $entry->num_rows == 1 ) {
287 287
 				$riga = $entry->fetch_array(MYSQLI_ASSOC);
288
-                        	if (isListed($riga)) {
288
+							if (isListed($riga)) {
289 289
 					$warn = "<$value> is already present in <$listdep> list!";
290 290
 					$entry->free();
291 291
 					return FALSE;
@@ -302,7 +302,7 @@  discard block
 block discarded – undo
302 302
 function searchentry ($myconn,$value,$tablelist) {
303 303
 /* Make a MYSQL query and return result */
304 304
 
305
-        $type = $tablelist['field'];
305
+		$type = $tablelist['field'];
306 306
 	
307 307
 	if ( $tablelist['milter'] ) {
308 308
 		$table = milterTable($type);
@@ -326,7 +326,7 @@  discard block
 block discarded – undo
326 326
 				case 'ip':
327 327
 					$query = sprintf('SELECT * FROM (
328 328
 							SELECT *, GROUP_CONCAT(milt.name) as miltnames FROM `%s` LEFT JOIN milt ON (%s.idmilt=milt.id)' .
329
-                                                		'WHERE `ip` =  INET_ATON(\'%s\')
329
+														'WHERE `ip` =  INET_ATON(\'%s\')
330 330
 							 ) AS val WHERE val.ip IS NOT null', $table, $table, $value);
331 331
 					break;
332 332
 				default:
@@ -337,33 +337,33 @@  discard block
 block discarded – undo
337 337
 	}
338 338
 
339 339
 	else {
340
-	        $table = $tablelist['name'];
341
-	        if ($value == 'ALL') $query = 'select * from '.$table;
342
-	        else {
343
-	                switch ($type) {
344
-	                  case 'ip':
345
-	                        $query= "select * from $table where $type =  INET_ATON('$value')";
346
-	                        break;
347
-	                  case 'network':
348
-	                        list($sub['net'],$sub['mask'])=explode('/',$value);
349
-	                        $query= sprintf('select * from `%s`
340
+			$table = $tablelist['name'];
341
+			if ($value == 'ALL') $query = 'select * from '.$table;
342
+			else {
343
+					switch ($type) {
344
+					  case 'ip':
345
+							$query= "select * from $table where $type =  INET_ATON('$value')";
346
+							break;
347
+					  case 'network':
348
+							list($sub['net'],$sub['mask'])=explode('/',$value);
349
+							$query= sprintf('select * from `%s`
350 350
 						WHERE (
351 351
 							inet_aton(\'%s\') >= network AND
352 352
 							( inet_aton(\'%s\') | ( inet_aton(\'%s\') ^ (power(2,32)-1) ) )
353 353
 								<= network | ( netmask ^ (power(2,32)-1) )
354 354
 						)', $table, $sub['net'], $sub['net'], $sub['mask']);
355 355
 ;
356
-	                        break;
357
-	                  default:
358
-	                        $query= "select * from $table where $type = '$value'";
359
-	                }
360
-	        }
356
+							break;
357
+					  default:
358
+							$query= "select * from $table where $type = '$value'";
359
+					}
360
+			}
361 361
 	}
362 362
 
363 363
 	$result = $myconn->query($query);
364 364
 	if($result === false)
365 365
 		syslog(LOG_EMERG, "ALERT: Query <$query> failed: ".$myconn->error);
366
-        return $result;
366
+		return $result;
367 367
 }
368 368
 
369 369
 function countListed ($myconn,$table) {
@@ -378,14 +378,14 @@  discard block
 block discarded – undo
378 378
 
379 379
 
380 380
 function isFull($myconn,$typedesc,$alltables) {
381
-        if (isset($alltables["$typedesc"]['limit'])) {
381
+		if (isset($alltables["$typedesc"]['limit'])) {
382 382
 		if ( $alltables["$typedesc"]['milter'] )
383 383
 			$tab = 'net';
384 384
 		else
385 385
 			$tab = $alltables["$typedesc"]['name'];
386
-                if ( countListed($myconn,$tab) >= $alltables["$typedesc"]['limit'] ) 
387
-                        return TRUE;
388
-        }
386
+				if ( countListed($myconn,$tab) >= $alltables["$typedesc"]['limit'] ) 
387
+						return TRUE;
388
+		}
389 389
 	return FALSE;
390 390
 }
391 391
 
@@ -405,14 +405,14 @@  discard block
 block discarded – undo
405 405
 	if ($result) {
406 406
 		printf("<pre>Your request for $type &lt;$value&gt; returned %d items.\n</pre>", $result->num_rows);
407 407
 
408
-        /* Check for limit in number of listed items */
408
+		/* Check for limit in number of listed items */
409 409
 	$full = isFull($myconn,$typedesc,$tables);
410 410
 	if ($full) print '<p>'.htmlspecialchars("$typedesc has reached maximum value of ".$tables["$typedesc"]['limit'].' listed items.').'</p>';
411 411
 
412 412
 		if ($result->num_rows) {
413 413
 			print $tabhtm;
414 414
 			$i=0;
415
-        		while ($riga = $result->fetch_array(MYSQLI_ASSOC)) {
415
+				while ($riga = $result->fetch_array(MYSQLI_ASSOC)) {
416 416
 				if (isListed($riga)) {
417 417
 					if ($tables["$typedesc"]['bl']) $listed='Listed';
418 418
 					else $listed='WhiteListed';
@@ -438,7 +438,7 @@  discard block
 block discarded – undo
438 438
 					 printf ("<tr id=id$i><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td>%s</td></tr>\n",
439 439
 					$element, $riga['date'], $riga['datemod'], $riga['exp'], $riga['active'], $riga['nlist'], $riga['user'],htmlspecialchars($riga['reason']),ask($myconn,$i,$listed,$tables,$typedesc,$element,$full,$user,$adm));
440 440
 				$i++;
441
-        		}
441
+				}
442 442
 			print '</tbody></table>';
443 443
 		}
444 444
 		else {
@@ -458,15 +458,15 @@  discard block
 block discarded – undo
458 458
         
459 459
 function sendEmailWarn($tplf,$from,$to,$sbj,$emailListed,$intervalToExpire,$detail) {
460 460
 	$now = time();
461
-        setlocale (LC_TIME, 'it_IT');
462
-        $date = date("r",$now);
461
+		setlocale (LC_TIME, 'it_IT');
462
+		$date = date("r",$now);
463 463
 	$messageID = md5(uniqid($now,1)) . '@' . $_SERVER["HOSTNAME"];
464 464
 	$mua = 'PHP/' . phpversion();
465 465
 
466 466
 	/* Parsing headers */
467 467
 	if (!file_exists($tplf['header'])) {
468
-    		syslog(LOG_ERR, 'Sending email... template file <'.$tplf['header'].'> not found!');
469
-    		exit;
468
+			syslog(LOG_ERR, 'Sending email... template file <'.$tplf['header'].'> not found!');
469
+			exit;
470 470
 	}
471 471
 
472 472
 	$head_tmpl = file_get_contents($tplf['header']);
@@ -475,35 +475,35 @@  discard block
 block discarded – undo
475 475
 	$headers = str_replace($arr_tpl_vars, $arr_tpl_data, $head_tmpl);
476 476
 	$headers = preg_replace( '/\r|\n/', "\r\n", $headers );
477 477
 
478
-        /* Parsing body */
478
+		/* Parsing body */
479 479
 
480
-        if (!file_exists($tplf['body'])) {
481
-                syslog(LOG_ERR, 'Sending email... template file <'.$tplf['body'].'> not found!');
482
-                exit;
483
-        }
480
+		if (!file_exists($tplf['body'])) {
481
+				syslog(LOG_ERR, 'Sending email... template file <'.$tplf['body'].'> not found!');
482
+				exit;
483
+		}
484 484
 
485
-        $body_tmpl = file_get_contents($tplf['body']);
486
-        $arr_tpl_vars = array('{emailListed}','{expInterval}','{reason}');
487
-        $arr_tpl_data = array($emailListed,$intervalToExpire,$detail);
488
-        $body = str_replace($arr_tpl_vars, $arr_tpl_data, $body_tmpl);
489
-        $body = preg_replace( "/\r|\n/", "\r\n", $body );
485
+		$body_tmpl = file_get_contents($tplf['body']);
486
+		$arr_tpl_vars = array('{emailListed}','{expInterval}','{reason}');
487
+		$arr_tpl_data = array($emailListed,$intervalToExpire,$detail);
488
+		$body = str_replace($arr_tpl_vars, $arr_tpl_data, $body_tmpl);
489
+		$body = preg_replace( "/\r|\n/", "\r\n", $body );
490 490
 	$body = wordwrap ( $body, 75 , "\r\n" );	
491 491
 
492 492
 	/* Send the mail! */
493
-        if ( strlen(ini_get("safe_mode"))< 1) {
494
-                $old_mailfrom = ini_get("sendmail_from");
495
-                ini_set("sendmail_from", $from);
496
-                $params = sprintf("-oi -f %s", '<>');
497
-                if (!(mail($to,$sbj, $body,$headers,$params))) $flag=FALSE;
498
-                else $flag=TRUE;
499
-                if (isset($old_mailfrom))
500
-                        ini_set("sendmail_from", $old_mailfrom);
501
-        }
502
-        else {
503
-                if (!(mail($to,$sbj, $body,$headers))) $flag=FALSE;
504
-                else $flag=TRUE;
505
-        }
506
-        return $flag;
493
+		if ( strlen(ini_get("safe_mode"))< 1) {
494
+				$old_mailfrom = ini_get("sendmail_from");
495
+				ini_set("sendmail_from", $from);
496
+				$params = sprintf("-oi -f %s", '<>');
497
+				if (!(mail($to,$sbj, $body,$headers,$params))) $flag=FALSE;
498
+				else $flag=TRUE;
499
+				if (isset($old_mailfrom))
500
+						ini_set("sendmail_from", $old_mailfrom);
501
+		}
502
+		else {
503
+				if (!(mail($to,$sbj, $body,$headers))) $flag=FALSE;
504
+				else $flag=TRUE;
505
+		}
506
+		return $flag;
507 507
 }
508 508
 
509 509
 function emailToNotify($notify_file,$dom) {
@@ -517,59 +517,59 @@  discard block
 block discarded – undo
517 517
 function searchAndList ($myconn,$loguser,$tables,$typedesc,$value,$unit,&$quantity,$reason) {
518 518
 
519 519
 /* Search and list value */
520
-        $type = $tables["$typedesc"]['field'];
521
-        $table = $tables["$typedesc"]['name'];
522
-        $result = searchentry ($myconn,$value,$tables["$typedesc"]);
523
-
524
-        /* Manage abnormal conditions */
525
-        /* Value already present in db more than once. This is absurd. Panic! */
526
-        if ($result->num_rows > 1) {
527
-                syslog(LOG_EMERG,"$loguser: PANIC! Select for $type '$value' returned ". $result->num_rows ." items instead of one. Abnormal. Contact a sysadmin or a developer.");
528
-                $result->free();
529
-                return FALSE;
530
-        }
520
+		$type = $tables["$typedesc"]['field'];
521
+		$table = $tables["$typedesc"]['name'];
522
+		$result = searchentry ($myconn,$value,$tables["$typedesc"]);
523
+
524
+		/* Manage abnormal conditions */
525
+		/* Value already present in db more than once. This is absurd. Panic! */
526
+		if ($result->num_rows > 1) {
527
+				syslog(LOG_EMERG,"$loguser: PANIC! Select for $type '$value' returned ". $result->num_rows ." items instead of one. Abnormal. Contact a sysadmin or a developer.");
528
+				$result->free();
529
+				return FALSE;
530
+		}
531 531
 
532
-        /* Value already present in db or not present: to list anyway */
533
-        if ($result->num_rows >= 0) {
534
-                /* First, check for limit in number of listed items */
535
-                if (isFull($myconn,$typedesc,$tables)) {
536
-                        syslog(LOG_EMERG,"$loguser: $typedesc has reached maximum value of ".$tables["$typedesc"]['limit'].' listed items. Abnormal exit.');
537
-                        $result->free();
538
-                        return FALSE;
539
-                }
540
-                /* Second, check if the (re)list would be consistent now */
541
-                if (! consistentListing($myconn,$tables,$typedesc,$value,$whynot) ) {
542
-                        syslog(LOG_ERR, $loguser.': '.$whynot);
543
-                        $result->free();
544
-                        return FALSE;
545
-                }
546
-        }
547
-        /* End of abnormal conditions */
532
+		/* Value already present in db or not present: to list anyway */
533
+		if ($result->num_rows >= 0) {
534
+				/* First, check for limit in number of listed items */
535
+				if (isFull($myconn,$typedesc,$tables)) {
536
+						syslog(LOG_EMERG,"$loguser: $typedesc has reached maximum value of ".$tables["$typedesc"]['limit'].' listed items. Abnormal exit.');
537
+						$result->free();
538
+						return FALSE;
539
+				}
540
+				/* Second, check if the (re)list would be consistent now */
541
+				if (! consistentListing($myconn,$tables,$typedesc,$value,$whynot) ) {
542
+						syslog(LOG_ERR, $loguser.': '.$whynot);
543
+						$result->free();
544
+						return FALSE;
545
+				}
546
+		}
547
+		/* End of abnormal conditions */
548 548
 
549 549
 
550
-        /* Finally, here I can list the value! */
550
+		/* Finally, here I can list the value! */
551 551
 	$thisentry = $result->fetch_array(MYSQLI_ASSOC);
552
-        switch ($result->num_rows) {
553
-                /* Relist value if already present */
554
-                case 1:
555
-                        /* Entry already listed */
556
-                        if ( isListed($thisentry) ) {
557
-                                syslog(LOG_INFO, $loguser.': '.$value.' already listed. Nothing to do.');
558
-                                $result->free();
559
-                                return FALSE;
560
-                        }
561
-
562
-                        /* Entry delisted */
563
-                        $result->free();
552
+		switch ($result->num_rows) {
553
+				/* Relist value if already present */
554
+				case 1:
555
+						/* Entry already listed */
556
+						if ( isListed($thisentry) ) {
557
+								syslog(LOG_INFO, $loguser.': '.$value.' already listed. Nothing to do.');
558
+								$result->free();
559
+								return FALSE;
560
+						}
561
+
562
+						/* Entry delisted */
563
+						$result->free();
564 564
 			$quantity *= $thisentry['nlist'];
565
-                        return relist ($myconn,$loguser,$value,$type,$table,$unit,$quantity,$reason);
565
+						return relist ($myconn,$loguser,$value,$type,$table,$unit,$quantity,$reason);
566 566
 
567 567
 
568
-                /* First time list value */
569
-                case 0:
570
-                        $result->free();
571
-                        return addtolist ($myconn,$loguser,$value,$type,$table,$unit,$quantity,$reason);
572
-        }
568
+				/* First time list value */
569
+				case 0:
570
+						$result->free();
571
+						return addtolist ($myconn,$loguser,$value,$type,$table,$unit,$quantity,$reason);
572
+		}
573 573
 }
574 574
 
575 575
 
@@ -602,7 +602,7 @@  discard block
 block discarded – undo
602 602
 		return FALSE;
603 603
 	}
604 604
 	$result = searchentry ($myconn,'ALL',$tabletype);
605
-        if ($result->num_rows) {
605
+		if ($result->num_rows) {
606 606
 		while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
607 607
 			$thisNet = long2ip($row['network']).'/'.long2ip($row['netmask']);
608 608
 			if ( isIn($thisNet, $net) ) {
@@ -622,7 +622,7 @@  discard block
 block discarded – undo
622 622
 /* For miltermap */
623 623
 function checkMilterConf($table) {
624 624
 	if (isset($table['milter'])) {
625
-        	if ($table['milter'] ===  TRUE) {
625
+			if ($table['milter'] ===  TRUE) {
626 626
 			switch ( $table['field'] ) {
627 627
 				case 'network':
628 628
 				case 'ip':
@@ -645,15 +645,15 @@  discard block
 block discarded – undo
645 645
 
646 646
 function milterTable($t) {
647 647
 	/* Return the milter object table for type t  or FALSE on error */
648
-        switch ($t) {
649
-                case 'network':
650
-                        return 'net';
651
-                case 'ip':
652
-                        return 'ips';
653
-                default:
648
+		switch ($t) {
649
+				case 'network':
650
+						return 'net';
651
+				case 'ip':
652
+						return 'ips';
653
+				default:
654 654
 			syslog(LOG_EMERG, "ALERT: type <$t> not allowed in configuration. ");
655
-                        return FALSE;
656
-        }
655
+						return FALSE;
656
+		}
657 657
 }
658 658
 
659 659
 
@@ -661,9 +661,9 @@  discard block
 block discarded – undo
661 661
 	$milters=array();
662 662
 	$query = 'SELECT `name` FROM `config`';
663 663
 
664
-        $result = $myconn->query($query);
665
-        if($result === false) {
666
-                syslog(LOG_EMERG, "$loguser: ALERT: Query <$query> failed: ".$myconn->error);
664
+		$result = $myconn->query($query);
665
+		if($result === false) {
666
+				syslog(LOG_EMERG, "$loguser: ALERT: Query <$query> failed: ".$myconn->error);
667 667
 		return FALSE;
668 668
 	}
669 669
 	if ($result->num_rows) {
Please login to merge, or discard this patch.
Spacing   +149 added lines, -149 removed lines patch added patch discarded remove patch
@@ -5,36 +5,36 @@  discard block
 block discarded – undo
5 5
 function username() {
6 6
 	if (isset ($_SERVER['REMOTE_USER'])) $user = $_SERVER['REMOTE_USER'];
7 7
         	else if (isset ($_SERVER['USER'])) $user = $_SERVER['USER'];
8
-                	else $user='unknown';
8
+                	else $user = 'unknown';
9 9
 	return $user;
10 10
 }
11 11
 
12 12
 
13 13
 function myConnect($host, $user, $pass, $db, $port, $tablelist, $typedesc, $loguser) {
14
-        $db = ( $tablelist["$typedesc"]['milter'] ) ? $tablelist["$typedesc"]['name'] : $db;
14
+        $db = ($tablelist["$typedesc"]['milter']) ? $tablelist["$typedesc"]['name'] : $db;
15 15
 	$mysqli = new mysqli($host, $user, $pass, $db, $port);
16 16
         if ($mysqli->connect_error) {
17
-           	syslog (LOG_EMERG, $loguser.': Connect Error to DB <'.$db.'> (' . $mysqli->connect_errno . ') '
17
+           	syslog(LOG_EMERG, $loguser.': Connect Error to DB <'.$db.'> ('.$mysqli->connect_errno.') '
18 18
                     		. $mysqli->connect_error);
19 19
 		return FALSE;
20 20
 	}
21
-	syslog(LOG_INFO, $loguser.': Successfully MySQL connected at DB <'.$db.'> to ' . $mysqli->host_info) ;
21
+	syslog(LOG_INFO, $loguser.': Successfully MySQL connected at DB <'.$db.'> to '.$mysqli->host_info);
22 22
 	return $mysqli;
23 23
 }
24 24
 
25
-function addtolist ($myconn,$user,$value,$tabledesc,$expUnit,$expQ,$myreason,&$err) {
25
+function addtolist($myconn, $user, $value, $tabledesc, $expUnit, $expQ, $myreason, &$err) {
26 26
 // See MySQL manual for $expQ and $expUnit at
27 27
 // https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_timestampadd
28 28
 
29
-	$result=FALSE;
30
-	$sub=array();
29
+	$result = FALSE;
30
+	$sub = array();
31 31
 	$type = $tabledesc['field'];
32 32
 	$milt = $tabledesc['milter'];
33 33
 	$table = ($milt) ? milterTable($type) : $tabledesc['name'];
34 34
 
35 35
 	switch ($type) {
36 36
 	  case 'ip':
37
-		$query= sprintf("INSERT INTO `$table` (
37
+		$query = sprintf("INSERT INTO `$table` (
38 38
 			`$type` ,
39 39
 			`date` ,
40 40
 			`exp` ,
@@ -45,18 +45,18 @@  discard block
 block discarded – undo
45 45
 		VALUES (
46 46
 			INET_ATON( '%s' ) ,
47 47
 			CURRENT_TIMESTAMP , TIMESTAMPADD(%s,%d,CURRENT_TIMESTAMP), '1', '%s', '%s'
48
-		)" ,$value,$expUnit,$expQ,$user,$myreason);
48
+		)", $value, $expUnit, $expQ, $user, $myreason);
49 49
 		break;
50 50
 
51 51
 	  case 'network':
52 52
 		if (!$milt) {
53
-			if ( netOverlap($myconn, $tabledesc, $value, $overlappedNet, $user) ) {
53
+			if (netOverlap($myconn, $tabledesc, $value, $overlappedNet, $user)) {
54 54
 				$err = "<$value> overlaps the existing network <$overlappedNet>";
55 55
 				return FALSE;
56 56
 			}
57 57
 		}
58
-		list($sub['net'],$sub['mask'])=explode('/',$value);
59
-                $query= sprintf("INSERT INTO `$table` (
58
+		list($sub['net'], $sub['mask']) = explode('/', $value);
59
+                $query = sprintf("INSERT INTO `$table` (
60 60
                         `$type` ,
61 61
 			`netmask`,
62 62
                         `date` ,
@@ -68,11 +68,11 @@  discard block
 block discarded – undo
68 68
                 VALUES (
69 69
                         INET_ATON( '%s' ) , INET_ATON( '%s' ) ,
70 70
                         CURRENT_TIMESTAMP , TIMESTAMPADD(%s,%d,CURRENT_TIMESTAMP), '1', '%s', '%s'
71
-                )" ,$sub['net'],$sub['mask'],$expUnit,$expQ,$user,$myreason);
71
+                )", $sub['net'], $sub['mask'], $expUnit, $expQ, $user, $myreason);
72 72
                 break;
73 73
 
74 74
 	  default:
75
-                $query= sprintf("INSERT INTO `$table` (
75
+                $query = sprintf("INSERT INTO `$table` (
76 76
                         `$type` ,
77 77
                         `date` ,
78 78
                         `exp` ,
@@ -83,60 +83,60 @@  discard block
 block discarded – undo
83 83
                 VALUES (
84 84
                         '%s' ,
85 85
                         CURRENT_TIMESTAMP , TIMESTAMPADD(%s,%d,CURRENT_TIMESTAMP), '1', '%s', '%s'
86
-                )" ,$value,$expUnit,$expQ,$user,$myreason);
86
+                )", $value, $expUnit, $expQ, $user, $myreason);
87 87
 	}
88 88
 
89 89
 	if ($myconn->query($query) === TRUE) {
90 90
 	    syslog(LOG_INFO, "$user: $type <$value> successfully listed on <$table> for $expQ $expUnit.");
91
-	    $result=TRUE;
91
+	    $result = TRUE;
92 92
 	}
93 93
 	else syslog(LOG_ERR, "$user: Error: ".$myconn->error);
94 94
 	return $result;
95 95
 }
96 96
 
97
-function relist ($myconn,$user,$value,$type,$table,$expUnit,$expQ,$myreason) {
97
+function relist($myconn, $user, $value, $type, $table, $expUnit, $expQ, $myreason) {
98 98
 
99
-	$result=FALSE;
99
+	$result = FALSE;
100 100
 
101 101
         switch ($type) {
102 102
 	  case 'ip':
103
-                $query= sprintf("UPDATE `$table` SET
103
+                $query = sprintf("UPDATE `$table` SET
104 104
 			`active` = '1',
105 105
 			`user` = '%s',
106 106
 			`exp` = TIMESTAMPADD(%s,%d,CURRENT_TIMESTAMP),
107 107
 			`nlist` = `nlist` + 1,
108 108
 			`reason` = '%s'
109
-			WHERE `$table`.`$type` = INET_ATON('%s') LIMIT 1" ,$user,$expUnit,$expQ,$myreason,$value);
109
+			WHERE `$table`.`$type` = INET_ATON('%s') LIMIT 1", $user, $expUnit, $expQ, $myreason, $value);
110 110
 		break;
111 111
           case 'network':
112
-		list($sub['net'],$sub['mask'])=explode('/',$value);
113
-                $query= sprintf("UPDATE `$table` SET
112
+		list($sub['net'], $sub['mask']) = explode('/', $value);
113
+                $query = sprintf("UPDATE `$table` SET
114 114
                         `active` = '1',
115 115
                         `user` = '%s',
116 116
                         `exp` = TIMESTAMPADD(%s,%d,CURRENT_TIMESTAMP),
117 117
                         `nlist` = `nlist` + 1,
118 118
                         `reason` = '%s'
119
-                        WHERE (`$table`.`$type` = INET_ATON('%s') AND `$table`.`netmask` = INET_ATON('%s')) LIMIT 1" ,$user,$expUnit,$expQ,$myreason,$sub['net'],$sub['mask']);
119
+                        WHERE (`$table`.`$type` = INET_ATON('%s') AND `$table`.`netmask` = INET_ATON('%s')) LIMIT 1", $user, $expUnit, $expQ, $myreason, $sub['net'], $sub['mask']);
120 120
 		break;
121 121
 	  default:
122
-                $query= sprintf("UPDATE `$table` SET
122
+                $query = sprintf("UPDATE `$table` SET
123 123
                         `active` = '1',
124 124
                         `user` = '%s',
125 125
                         `exp` = TIMESTAMPADD(%s,%d,CURRENT_TIMESTAMP),
126 126
                         `nlist` = `nlist` + 1,
127 127
                         `reason` = '%s'
128
-			WHERE `$table`.`$type` = '%s' LIMIT 1" ,$user,$expUnit,$expQ,$myreason,$value);
128
+			WHERE `$table`.`$type` = '%s' LIMIT 1", $user, $expUnit, $expQ, $myreason, $value);
129 129
 	}
130 130
 
131 131
         if ($myconn->query($query) === TRUE) {
132 132
             syslog(LOG_INFO, "$user: relist $type <$value> on <$table> for $expQ $expUnit.");
133
-		$result=TRUE;
133
+		$result = TRUE;
134 134
         }
135
-        else syslog (LOG_ERR, "$user: Error: ". $myconn->error);
135
+        else syslog(LOG_ERR, "$user: Error: ".$myconn->error);
136 136
 	return $result;
137 137
 }
138 138
 
139
-function remove ($myconn,$user,$value,$type,$table) {
139
+function remove($myconn, $user, $value, $type, $table) {
140 140
 
141 141
         switch ($type) {
142 142
           case 'ip':
@@ -144,10 +144,10 @@  discard block
 block discarded – undo
144 144
                         `$table`.`$type` = INET_ATON('%s') LIMIT 1", $value);
145 145
 		break;
146 146
 	  case 'network':
147
-		list($sub['net'],$sub['mask'])=explode('/',$value);
147
+		list($sub['net'], $sub['mask']) = explode('/', $value);
148 148
 		$query = sprintf("DELETE FROM `$table` WHERE
149 149
 			`$table`.`$type` = INET_ATON('%s') AND `$table`.`netmask` = INET_ATON('%s') LIMIT 1",
150
-			$sub['net'],$sub['mask']);
150
+			$sub['net'], $sub['mask']);
151 151
 		break;
152 152
 	  default:
153 153
 		$query = sprintf("DELETE FROM `$table` WHERE
@@ -155,39 +155,39 @@  discard block
 block discarded – undo
155 155
 	}
156 156
 
157 157
 
158
-        if ($return=$myconn->query($query) === TRUE) 
158
+        if ($return = $myconn->query($query) === TRUE) 
159 159
             syslog(LOG_INFO, "$user: permanently DELETED $type <$value> from <$table>.");
160
-        else syslog(LOG_ERR, "$user: Error: ". $myconn->error);
160
+        else syslog(LOG_ERR, "$user: Error: ".$myconn->error);
161 161
 
162 162
         return $return;
163 163
 }
164 164
 
165 165
 
166
-function changestatus ($myconn,$user,$value,$status,$type,$table) {
166
+function changestatus($myconn, $user, $value, $status, $type, $table) {
167 167
 
168 168
 	switch ($type) {
169 169
           case 'ip':
170
-		$query= sprintf("UPDATE `$table` SET `active` = '$status', `user` = '%s' WHERE `$table`.`$type` = INET_ATON('%s') LIMIT 1" ,$user, $value);
170
+		$query = sprintf("UPDATE `$table` SET `active` = '$status', `user` = '%s' WHERE `$table`.`$type` = INET_ATON('%s') LIMIT 1", $user, $value);
171 171
 		break;
172 172
 	  case 'network':
173
-		list($sub['net'],$sub['mask'])=explode('/',$value);
174
-		$query= sprintf("UPDATE `$table` SET `active` = '$status', `user` = '%s' WHERE (`$table`.`$type` = INET_ATON('%s') AND `$table`.`netmask` = INET_ATON('%s')) LIMIT 1" ,$user, $sub['net'],$sub['mask']);
173
+		list($sub['net'], $sub['mask']) = explode('/', $value);
174
+		$query = sprintf("UPDATE `$table` SET `active` = '$status', `user` = '%s' WHERE (`$table`.`$type` = INET_ATON('%s') AND `$table`.`netmask` = INET_ATON('%s')) LIMIT 1", $user, $sub['net'], $sub['mask']);
175 175
 		break;
176 176
 	  default:
177
-		$query= sprintf("UPDATE `$table` SET `active` = '$status', `user` = '%s' WHERE `$table`.`$type` = '%s' LIMIT 1" ,$user, $value);
177
+		$query = sprintf("UPDATE `$table` SET `active` = '$status', `user` = '%s' WHERE `$table`.`$type` = '%s' LIMIT 1", $user, $value);
178 178
 	}
179 179
 
180
-        if ($return=$myconn->query($query) === TRUE) {
180
+        if ($return = $myconn->query($query) === TRUE) {
181 181
             syslog(LOG_INFO, "$user: change status of $type <$value>. The status is now <$status>");
182 182
         }
183
-        else syslog(LOG_ERR, "$user: Error: ". $myconn->error);
183
+        else syslog(LOG_ERR, "$user: Error: ".$myconn->error);
184 184
 	return $return;	
185 185
 }
186 186
 
187 187
 
188
-function expire ($myconn,$user,$tables,$expireTime) {
189
-        $return=TRUE;
190
-	$log=array();
188
+function expire($myconn, $user, $tables, $expireTime) {
189
+        $return = TRUE;
190
+	$log = array();
191 191
 	$desc = array_keys($tables);
192 192
 	foreach ($desc as $tdesc) { 
193 193
 		/* QUERY */
@@ -206,11 +206,11 @@  discard block
 block discarded – undo
206 206
 			} while ($myconn->next_result());
207 207
 		}
208 208
 		else {
209
-			syslog(LOG_ERR, "Expire job - Error: ". $myconn->error);
209
+			syslog(LOG_ERR, "Expire job - Error: ".$myconn->error);
210 210
 			$return = FALSE;
211 211
 		}
212 212
 	}
213
-	if ( !($return) ) syslog(LOG_EMERG, 'End of Expire job with error. See above logs. SQL Connection terminated');
213
+	if (!($return)) syslog(LOG_EMERG, 'End of Expire job with error. See above logs. SQL Connection terminated');
214 214
 	else  syslog(LOG_INFO, 'Successfully End of Expire job. SQL Connection successfully terminated.');
215 215
         return $return;
216 216
 }
@@ -218,18 +218,18 @@  discard block
 block discarded – undo
218 218
 
219 219
 function isListed($row) {
220 220
 
221
-	$exp=new DateTime($row['exp']);
222
-	$now=new DateTime('NOW');
223
-	if (($exp > $now) and ($row['active'])) return true;
221
+	$exp = new DateTime($row['exp']);
222
+	$now = new DateTime('NOW');
223
+	if (($exp>$now) and ($row['active'])) return true;
224 224
 	else return false;
225 225
 
226 226
 }
227 227
 
228 228
 
229
-function askMilter($myconn,$id,$obj,$typedesc,$miltId,$value,$user,$adm)  {
230
-	$milts = readMiltName($myconn,$user);
229
+function askMilter($myconn, $id, $obj, $typedesc, $miltId, $value, $user, $adm) {
230
+	$milts = readMiltName($myconn, $user);
231 231
 	$size = count($milts);
232
-	if (in_array($user,array_keys($adm))) {
232
+	if (in_array($user, array_keys($adm))) {
233 233
 		$button = <<<END
234 234
 		<form style="margin:0; display:inline;" name="Milter$id" enctype="text/plain" method="post" target="_self" action="changeMilter.php" onSubmit="xmlhttpPost('changeMilter.php', 'Milter$id', 'id$id', '<img src=\'/include/pleasewait.gif\'>'); return false;" />
235 235
 		<input name="object" type="hidden" value="$obj" /><input name="oldvalues" type="hidden" value="$value" />
@@ -239,12 +239,12 @@  discard block
 block discarded – undo
239 239
 		<div class="noscroll">
240 240
 		<select class="input_text" name="newvalues[]" multiple size="$size">
241 241
 END;
242
-		$activeMilts = explode(',',$value);
243
-		foreach ( $milts as $milter ) {
244
-			if ( in_array($milter, $activeMilts) )
245
-				$selected= 'selected';
242
+		$activeMilts = explode(',', $value);
243
+		foreach ($milts as $milter) {
244
+			if (in_array($milter, $activeMilts))
245
+				$selected = 'selected';
246 246
 			else
247
-				$selected= NULL;
247
+				$selected = NULL;
248 248
 			$button .= sprintf('<option value="%s" %s>%s</option>', $milter, $selected, $milter);
249 249
 		}	
250 250
 		$button .= '</select></div><input class="button" name="Change" type="submit" value="Change" /></form>';
@@ -256,14 +256,14 @@  discard block
 block discarded – undo
256 256
 }
257 257
 
258 258
 
259
-function ask($myconn,$id,$what,$alltables,$typedesc,$value,$lock,$user,$adm) {
259
+function ask($myconn, $id, $what, $alltables, $typedesc, $value, $lock, $user, $adm) {
260 260
 
261
-	$whynot=NULL;
261
+	$whynot = NULL;
262 262
 	switch ($what) {
263 263
 		case 'Ok':
264 264
 			if ($lock) return NULL;
265
-			if (in_array($user,array_keys($adm)))
266
-				if ( consistentListing($myconn,$alltables,$typedesc,$value,$whynot) ) return require('relistButton.php');
265
+			if (in_array($user, array_keys($adm)))
266
+				if (consistentListing($myconn, $alltables, $typedesc, $value, $whynot)) return require('relistButton.php');
267 267
 			return htmlspecialchars($whynot);
268 268
 		case 'Listed':
269 269
 		case 'WhiteListed':
@@ -272,18 +272,18 @@  discard block
 block discarded – undo
272 272
 }
273 273
 
274 274
 
275
-function consistentListing($myconn,$alltables,$typed,$value,&$warn) {
275
+function consistentListing($myconn, $alltables, $typed, $value, &$warn) {
276 276
 /* Check if there are no pending mislisting */
277 277
 	$warn = NULL;
278
-	if (! isset($alltables["$typed"]['depend']) ) return TRUE;
278
+	if (!isset($alltables["$typed"]['depend'])) return TRUE;
279 279
 	foreach ($alltables["$typed"]['depend'] as $listdep) {
280
-		if ($alltables["$typed"]['field'] != $alltables["$listdep"]['field'] ) {
280
+		if ($alltables["$typed"]['field'] != $alltables["$listdep"]['field']) {
281 281
 			$warn = "Config ERROR: <$typed> and <$listdep> are of different types! I can't check consistency!";
282 282
 			return FALSE;
283 283
 		}
284
-		$entry = searchentry($myconn,$value,$alltables["$listdep"]);
285
-		if ( $entry->num_rows ) {
286
-			if ( $entry->num_rows == 1 ) {
284
+		$entry = searchentry($myconn, $value, $alltables["$listdep"]);
285
+		if ($entry->num_rows) {
286
+			if ($entry->num_rows == 1) {
287 287
 				$riga = $entry->fetch_array(MYSQLI_ASSOC);
288 288
                         	if (isListed($riga)) {
289 289
 					$warn = "<$value> is already present in <$listdep> list!";
@@ -291,7 +291,7 @@  discard block
 block discarded – undo
291 291
 					return FALSE;
292 292
 				}
293 293
 			}
294
-			if ( $entry->num_rows > 1 ) {$warn = "<$value> seems to be present more than once in <$listdep>. Contact a sysadmin NOW!";}
294
+			if ($entry->num_rows>1) {$warn = "<$value> seems to be present more than once in <$listdep>. Contact a sysadmin NOW!"; }
295 295
 		}
296 296
 		$entry->free();
297 297
 	}
@@ -299,20 +299,20 @@  discard block
 block discarded – undo
299 299
 	return TRUE;
300 300
 }
301 301
 
302
-function searchentry ($myconn,$value,$tablelist) {
302
+function searchentry($myconn, $value, $tablelist) {
303 303
 /* Make a MYSQL query and return result */
304 304
 
305 305
         $type = $tablelist['field'];
306 306
 	
307
-	if ( $tablelist['milter'] ) {
307
+	if ($tablelist['milter']) {
308 308
 		$table = milterTable($type);
309 309
 		if ($value == 'ALL')
310 310
 			$query = sprintf('SELECT *, GROUP_CONCAT(milt.name) as miltnames FROM `%s` LEFT JOIN milt ON (%s.idmilt=milt.id) GROUP by idmilt',
311
-				$table,$table);
311
+				$table, $table);
312 312
 		else {
313 313
 			switch ($type) {
314 314
 				case 'network':
315
-					list($sub['net'],$sub['mask'])=explode('/',$value);
315
+					list($sub['net'], $sub['mask']) = explode('/', $value);
316 316
 					$query = sprintf('SELECT * FROM (
317 317
 							SELECT *, GROUP_CONCAT(milt.name) as miltnames FROM `%s` LEFT JOIN milt ON (%s.idmilt=milt.id)
318 318
 				 				WHERE (
@@ -330,7 +330,7 @@  discard block
 block discarded – undo
330 330
 							 ) AS val WHERE val.ip IS NOT null', $table, $table, $value);
331 331
 					break;
332 332
 				default:
333
-					syslog(LOG_EMERG, 'ALERT: The type <'.$type.'> is not allowed for milter lists.' );
333
+					syslog(LOG_EMERG, 'ALERT: The type <'.$type.'> is not allowed for milter lists.');
334 334
 					return FALSE;
335 335
 			}
336 336
 		}
@@ -342,11 +342,11 @@  discard block
 block discarded – undo
342 342
 	        else {
343 343
 	                switch ($type) {
344 344
 	                  case 'ip':
345
-	                        $query= "select * from $table where $type =  INET_ATON('$value')";
345
+	                        $query = "select * from $table where $type =  INET_ATON('$value')";
346 346
 	                        break;
347 347
 	                  case 'network':
348
-	                        list($sub['net'],$sub['mask'])=explode('/',$value);
349
-	                        $query= sprintf('select * from `%s`
348
+	                        list($sub['net'], $sub['mask']) = explode('/', $value);
349
+	                        $query = sprintf('select * from `%s`
350 350
 						WHERE (
351 351
 							inet_aton(\'%s\') >= network AND
352 352
 							( inet_aton(\'%s\') | ( inet_aton(\'%s\') ^ (power(2,32)-1) ) )
@@ -355,18 +355,18 @@  discard block
 block discarded – undo
355 355
 ;
356 356
 	                        break;
357 357
 	                  default:
358
-	                        $query= "select * from $table where $type = '$value'";
358
+	                        $query = "select * from $table where $type = '$value'";
359 359
 	                }
360 360
 	        }
361 361
 	}
362 362
 
363 363
 	$result = $myconn->query($query);
364
-	if($result === false)
364
+	if ($result === false)
365 365
 		syslog(LOG_EMERG, "ALERT: Query <$query> failed: ".$myconn->error);
366 366
         return $result;
367 367
 }
368 368
 
369
-function countListed ($myconn,$table) {
369
+function countListed($myconn, $table) {
370 370
 /* Return number of current listed items into a rbl table */
371 371
 	$query = "SELECT COUNT(*) as `count` FROM `$table` WHERE (`active`=1 AND TIMESTAMPDIFF(MICROSECOND,NOW(),`exp`)>0) GROUP BY `active` ORDER BY `count` DESC LIMIT 1";
372 372
 	$row = $myconn->query($query);
@@ -377,48 +377,48 @@  discard block
 block discarded – undo
377 377
 }
378 378
 
379 379
 
380
-function isFull($myconn,$typedesc,$alltables) {
380
+function isFull($myconn, $typedesc, $alltables) {
381 381
         if (isset($alltables["$typedesc"]['limit'])) {
382
-		if ( $alltables["$typedesc"]['milter'] )
382
+		if ($alltables["$typedesc"]['milter'])
383 383
 			$tab = 'net';
384 384
 		else
385 385
 			$tab = $alltables["$typedesc"]['name'];
386
-                if ( countListed($myconn,$tab) >= $alltables["$typedesc"]['limit'] ) 
386
+                if (countListed($myconn, $tab)>=$alltables["$typedesc"]['limit']) 
387 387
                         return TRUE;
388 388
         }
389 389
 	return FALSE;
390 390
 }
391 391
 
392
-function rlookup ($myconn,$user,$adm,$value,$typedesc,$tables) {
392
+function rlookup($myconn, $user, $adm, $value, $typedesc, $tables) {
393 393
 
394 394
 	$type = $tables["$typedesc"]['field'];
395
-	$whynot=NULL;
395
+	$whynot = NULL;
396 396
 
397 397
 	$tabhtm = <<<END
398 398
 	<table><thead><tr><th>$type</th><th title="The date this object has been listed for the first time">DateAdd</th><th>DateMod</th><th>Exp</th><th>Status</th><th title="Number of times this object has been listed">#List</th>
399 399
 END;
400
-	if ( $tables["$typedesc"]['milter'] )
400
+	if ($tables["$typedesc"]['milter'])
401 401
 		$tabhtm .= '<th title="Milter active for this object">Milters</th>';
402 402
 	$tabhtm .= '<th>Authored by</th><th width="250">Reason</th><th>Action</th></tr></thead><tfoot><tr></tr></tfoot><tbody>'."\n";
403 403
 
404
-	$result = searchentry ($myconn,$value,$tables["$typedesc"]);
404
+	$result = searchentry($myconn, $value, $tables["$typedesc"]);
405 405
 	if ($result) {
406 406
 		printf("<pre>Your request for $type &lt;$value&gt; returned %d items.\n</pre>", $result->num_rows);
407 407
 
408 408
         /* Check for limit in number of listed items */
409
-	$full = isFull($myconn,$typedesc,$tables);
409
+	$full = isFull($myconn, $typedesc, $tables);
410 410
 	if ($full) print '<p>'.htmlspecialchars("$typedesc has reached maximum value of ".$tables["$typedesc"]['limit'].' listed items.').'</p>';
411 411
 
412 412
 		if ($result->num_rows) {
413 413
 			print $tabhtm;
414
-			$i=0;
414
+			$i = 0;
415 415
         		while ($riga = $result->fetch_array(MYSQLI_ASSOC)) {
416 416
 				if (isListed($riga)) {
417
-					if ($tables["$typedesc"]['bl']) $listed='Listed';
418
-					else $listed='WhiteListed';
417
+					if ($tables["$typedesc"]['bl']) $listed = 'Listed';
418
+					else $listed = 'WhiteListed';
419 419
 				}	
420 420
 				else
421
-					$listed='Ok';
421
+					$listed = 'Ok';
422 422
 
423 423
 				switch ($type) {
424 424
 				  case 'ip':
@@ -431,20 +431,20 @@  discard block
 block discarded – undo
431 431
 					$element = $riga["$type"];
432 432
 				}
433 433
 
434
-				if ( $tables["$typedesc"]['milter'] AND checkMilterConf($tables["$typedesc"]) )
435
-					printf ("<tr id=id$i><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td nowrap id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td>%s</td></tr>\n",
436
-					$element, $riga['date'], $riga['datemod'], $riga['exp'], $riga['active'], $riga['nlist'], askMilter($myconn,$i,$element,$typedesc,$riga['idmilt'],$riga['miltnames'],$user,$adm), $riga['user'],htmlspecialchars($riga['reason']),ask($myconn,$i,$listed,$tables,$typedesc,$element,$full,$user,$adm));
434
+				if ($tables["$typedesc"]['milter'] AND checkMilterConf($tables["$typedesc"]))
435
+					printf("<tr id=id$i><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td nowrap id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td>%s</td></tr>\n",
436
+					$element, $riga['date'], $riga['datemod'], $riga['exp'], $riga['active'], $riga['nlist'], askMilter($myconn, $i, $element, $typedesc, $riga['idmilt'], $riga['miltnames'], $user, $adm), $riga['user'], htmlspecialchars($riga['reason']), ask($myconn, $i, $listed, $tables, $typedesc, $element, $full, $user, $adm));
437 437
 				else
438
-					 printf ("<tr id=id$i><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td>%s</td></tr>\n",
439
-					$element, $riga['date'], $riga['datemod'], $riga['exp'], $riga['active'], $riga['nlist'], $riga['user'],htmlspecialchars($riga['reason']),ask($myconn,$i,$listed,$tables,$typedesc,$element,$full,$user,$adm));
438
+					 printf("<tr id=id$i><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td>%s</td></tr>\n",
439
+					$element, $riga['date'], $riga['datemod'], $riga['exp'], $riga['active'], $riga['nlist'], $riga['user'], htmlspecialchars($riga['reason']), ask($myconn, $i, $listed, $tables, $typedesc, $element, $full, $user, $adm));
440 440
 				$i++;
441 441
         		}
442 442
 			print '</tbody></table>';
443 443
 		}
444 444
 		else {
445 445
 			print "<pre>$type &lt;$value&gt; is not listed!\n</pre>";
446
-			if ( in_array($user,array_keys($adm)) AND ($value != 'ALL') )
447
-				if ( (!$full) AND (consistentListing($myconn,$tables,$typedesc,$value,$whynot)) ) require_once('listForm.php');
446
+			if (in_array($user, array_keys($adm)) AND ($value != 'ALL'))
447
+				if ((!$full) AND (consistentListing($myconn, $tables, $typedesc, $value, $whynot))) require_once('listForm.php');
448 448
 									else print '<p>'.htmlspecialchars($whynot).'</p>';
449 449
 				
450 450
 		}
@@ -456,12 +456,12 @@  discard block
 block discarded – undo
456 456
 
457 457
 
458 458
         
459
-function sendEmailWarn($tplf,$from,$to,$sbj,$emailListed,$intervalToExpire,$detail) {
459
+function sendEmailWarn($tplf, $from, $to, $sbj, $emailListed, $intervalToExpire, $detail) {
460 460
 	$now = time();
461
-        setlocale (LC_TIME, 'it_IT');
462
-        $date = date("r",$now);
463
-	$messageID = md5(uniqid($now,1)) . '@' . $_SERVER["HOSTNAME"];
464
-	$mua = 'PHP/' . phpversion();
461
+        setlocale(LC_TIME, 'it_IT');
462
+        $date = date("r", $now);
463
+	$messageID = md5(uniqid($now, 1)).'@'.$_SERVER["HOSTNAME"];
464
+	$mua = 'PHP/'.phpversion();
465 465
 
466 466
 	/* Parsing headers */
467 467
 	if (!file_exists($tplf['header'])) {
@@ -470,10 +470,10 @@  discard block
 block discarded – undo
470 470
 	}
471 471
 
472 472
 	$head_tmpl = file_get_contents($tplf['header']);
473
-	$arr_tpl_vars = array('{from}','{to}','{date}','{messageID}','{mua}');
474
-	$arr_tpl_data = array($from,$to,$date,$messageID,$mua);
473
+	$arr_tpl_vars = array('{from}', '{to}', '{date}', '{messageID}', '{mua}');
474
+	$arr_tpl_data = array($from, $to, $date, $messageID, $mua);
475 475
 	$headers = str_replace($arr_tpl_vars, $arr_tpl_data, $head_tmpl);
476
-	$headers = preg_replace( '/\r|\n/', "\r\n", $headers );
476
+	$headers = preg_replace('/\r|\n/', "\r\n", $headers);
477 477
 
478 478
         /* Parsing body */
479 479
 
@@ -483,62 +483,62 @@  discard block
 block discarded – undo
483 483
         }
484 484
 
485 485
         $body_tmpl = file_get_contents($tplf['body']);
486
-        $arr_tpl_vars = array('{emailListed}','{expInterval}','{reason}');
487
-        $arr_tpl_data = array($emailListed,$intervalToExpire,$detail);
486
+        $arr_tpl_vars = array('{emailListed}', '{expInterval}', '{reason}');
487
+        $arr_tpl_data = array($emailListed, $intervalToExpire, $detail);
488 488
         $body = str_replace($arr_tpl_vars, $arr_tpl_data, $body_tmpl);
489
-        $body = preg_replace( "/\r|\n/", "\r\n", $body );
490
-	$body = wordwrap ( $body, 75 , "\r\n" );	
489
+        $body = preg_replace("/\r|\n/", "\r\n", $body);
490
+	$body = wordwrap($body, 75, "\r\n");	
491 491
 
492 492
 	/* Send the mail! */
493
-        if ( strlen(ini_get("safe_mode"))< 1) {
493
+        if (strlen(ini_get("safe_mode"))<1) {
494 494
                 $old_mailfrom = ini_get("sendmail_from");
495 495
                 ini_set("sendmail_from", $from);
496 496
                 $params = sprintf("-oi -f %s", '<>');
497
-                if (!(mail($to,$sbj, $body,$headers,$params))) $flag=FALSE;
498
-                else $flag=TRUE;
497
+                if (!(mail($to, $sbj, $body, $headers, $params))) $flag = FALSE;
498
+                else $flag = TRUE;
499 499
                 if (isset($old_mailfrom))
500 500
                         ini_set("sendmail_from", $old_mailfrom);
501 501
         }
502 502
         else {
503
-                if (!(mail($to,$sbj, $body,$headers))) $flag=FALSE;
504
-                else $flag=TRUE;
503
+                if (!(mail($to, $sbj, $body, $headers))) $flag = FALSE;
504
+                else $flag = TRUE;
505 505
         }
506 506
         return $flag;
507 507
 }
508 508
 
509
-function emailToNotify($notify_file,$dom) {
509
+function emailToNotify($notify_file, $dom) {
510 510
 	$ini_array = parse_ini_file($notify_file);
511
-	if (in_array($dom,array_keys($ini_array)))
511
+	if (in_array($dom, array_keys($ini_array)))
512 512
 		return $ini_array["$dom"];
513 513
 	else return FALSE;
514 514
 }
515 515
 
516 516
 
517
-function searchAndList ($myconn,$loguser,$tables,$typedesc,$value,$unit,&$quantity,$reason) {
517
+function searchAndList($myconn, $loguser, $tables, $typedesc, $value, $unit, &$quantity, $reason) {
518 518
 
519 519
 /* Search and list value */
520 520
         $type = $tables["$typedesc"]['field'];
521 521
         $table = $tables["$typedesc"]['name'];
522
-        $result = searchentry ($myconn,$value,$tables["$typedesc"]);
522
+        $result = searchentry($myconn, $value, $tables["$typedesc"]);
523 523
 
524 524
         /* Manage abnormal conditions */
525 525
         /* Value already present in db more than once. This is absurd. Panic! */
526
-        if ($result->num_rows > 1) {
527
-                syslog(LOG_EMERG,"$loguser: PANIC! Select for $type '$value' returned ". $result->num_rows ." items instead of one. Abnormal. Contact a sysadmin or a developer.");
526
+        if ($result->num_rows>1) {
527
+                syslog(LOG_EMERG, "$loguser: PANIC! Select for $type '$value' returned ".$result->num_rows." items instead of one. Abnormal. Contact a sysadmin or a developer.");
528 528
                 $result->free();
529 529
                 return FALSE;
530 530
         }
531 531
 
532 532
         /* Value already present in db or not present: to list anyway */
533
-        if ($result->num_rows >= 0) {
533
+        if ($result->num_rows>=0) {
534 534
                 /* First, check for limit in number of listed items */
535
-                if (isFull($myconn,$typedesc,$tables)) {
536
-                        syslog(LOG_EMERG,"$loguser: $typedesc has reached maximum value of ".$tables["$typedesc"]['limit'].' listed items. Abnormal exit.');
535
+                if (isFull($myconn, $typedesc, $tables)) {
536
+                        syslog(LOG_EMERG, "$loguser: $typedesc has reached maximum value of ".$tables["$typedesc"]['limit'].' listed items. Abnormal exit.');
537 537
                         $result->free();
538 538
                         return FALSE;
539 539
                 }
540 540
                 /* Second, check if the (re)list would be consistent now */
541
-                if (! consistentListing($myconn,$tables,$typedesc,$value,$whynot) ) {
541
+                if (!consistentListing($myconn, $tables, $typedesc, $value, $whynot)) {
542 542
                         syslog(LOG_ERR, $loguser.': '.$whynot);
543 543
                         $result->free();
544 544
                         return FALSE;
@@ -553,7 +553,7 @@  discard block
 block discarded – undo
553 553
                 /* Relist value if already present */
554 554
                 case 1:
555 555
                         /* Entry already listed */
556
-                        if ( isListed($thisentry) ) {
556
+                        if (isListed($thisentry)) {
557 557
                                 syslog(LOG_INFO, $loguser.': '.$value.' already listed. Nothing to do.');
558 558
                                 $result->free();
559 559
                                 return FALSE;
@@ -562,34 +562,34 @@  discard block
 block discarded – undo
562 562
                         /* Entry delisted */
563 563
                         $result->free();
564 564
 			$quantity *= $thisentry['nlist'];
565
-                        return relist ($myconn,$loguser,$value,$type,$table,$unit,$quantity,$reason);
565
+                        return relist($myconn, $loguser, $value, $type, $table, $unit, $quantity, $reason);
566 566
 
567 567
 
568 568
                 /* First time list value */
569 569
                 case 0:
570 570
                         $result->free();
571
-                        return addtolist ($myconn,$loguser,$value,$type,$table,$unit,$quantity,$reason);
571
+                        return addtolist($myconn, $loguser, $value, $type, $table, $unit, $quantity, $reason);
572 572
         }
573 573
 }
574 574
 
575 575
 
576 576
 /*************** Functions to check if two net overlap each other ********************/
577 577
 
578
-function ipRange ($range) {
578
+function ipRange($range) {
579 579
 /* List IP in range */
580
-	return array_map('long2ip', range( ip2long($range[0]), ip2long($range[1]) ) );
580
+	return array_map('long2ip', range(ip2long($range[0]), ip2long($range[1])));
581 581
 }
582 582
 
583 583
 function isIn($netA, $netB) {
584 584
 /* TRUE if an IP of $netA is contained in netB */
585
-	list($addressA,$maskA) = explode('/', $netA);
586
-	list($addressB,$maskB) = explode('/', $netB);
585
+	list($addressA, $maskA) = explode('/', $netA);
586
+	list($addressB, $maskB) = explode('/', $netB);
587 587
 	require_once 'vendor/autoload.php';
588 588
 	$net = new \dautkom\ipv4\IPv4();
589 589
 	$range = $net->address($addressA)->mask($maskA)->getRange();
590 590
 	$ips = ipRange($range);
591
-	foreach ( $ips as $ip )
592
-		if ( $net->address($addressB)->mask($maskB)->has($ip) )
591
+	foreach ($ips as $ip)
592
+		if ($net->address($addressB)->mask($maskB)->has($ip))
593 593
 			return TRUE;
594 594
 	return FALSE;
595 595
 }
@@ -601,11 +601,11 @@  discard block
 block discarded – undo
601 601
 		syslog(LOG_ERR, $loguser.': '.$tabletype['name'].' is not a network list.');
602 602
 		return FALSE;
603 603
 	}
604
-	$result = searchentry ($myconn,'ALL',$tabletype);
604
+	$result = searchentry($myconn, 'ALL', $tabletype);
605 605
         if ($result->num_rows) {
606 606
 		while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
607 607
 			$thisNet = long2ip($row['network']).'/'.long2ip($row['netmask']);
608
-			if ( isIn($thisNet, $net) ) {
608
+			if (isIn($thisNet, $net)) {
609 609
 				$result->free();
610 610
 				syslog(LOG_INFO, "$loguser: the net <$net> overlaps the existing network <$thisNet>.");
611 611
 				return TRUE;
@@ -622,8 +622,8 @@  discard block
 block discarded – undo
622 622
 /* For miltermap */
623 623
 function checkMilterConf($table) {
624 624
 	if (isset($table['milter'])) {
625
-        	if ($table['milter'] ===  TRUE) {
626
-			switch ( $table['field'] ) {
625
+        	if ($table['milter'] === TRUE) {
626
+			switch ($table['field']) {
627 627
 				case 'network':
628 628
 				case 'ip':
629 629
 					return TRUE;
@@ -657,12 +657,12 @@  discard block
 block discarded – undo
657 657
 }
658 658
 
659 659
 
660
-function readMiltName($myconn,$loguser) {
661
-	$milters=array();
660
+function readMiltName($myconn, $loguser) {
661
+	$milters = array();
662 662
 	$query = 'SELECT `name` FROM `config`';
663 663
 
664 664
         $result = $myconn->query($query);
665
-        if($result === false) {
665
+        if ($result === false) {
666 666
                 syslog(LOG_EMERG, "$loguser: ALERT: Query <$query> failed: ".$myconn->error);
667 667
 		return FALSE;
668 668
 	}
@@ -674,27 +674,27 @@  discard block
 block discarded – undo
674 674
 	return $milters;
675 675
 }
676 676
 
677
-function changeMilter ($myconn,$loguser,$miltVal,$table,$miltID) {
677
+function changeMilter($myconn, $loguser, $miltVal, $table, $miltID) {
678 678
 	$query = array();
679
-	foreach ( $miltVal as $value => $action ) {
680
-		switch ( $action ) {
679
+	foreach ($miltVal as $value => $action) {
680
+		switch ($action) {
681 681
 			case 'keep':
682 682
 				break;
683 683
 			case 'add':
684
-				$query[] = sprintf( "INSERT INTO `milt` (
684
+				$query[] = sprintf("INSERT INTO `milt` (
685 685
                 		        	`id` ,
686 686
                         			`name` 
687 687
                 			)
688 688
                 			VALUES (
689 689
                         			%d ,
690 690
 						'%s'
691
-					)",$miltID,$value);
691
+					)",$miltID, $value);
692 692
 				break;
693 693
 			case 'del':
694 694
 				$query[] = "DELETE FROM  `milt` WHERE (`id` = '$miltID' AND `name` = '$value')";
695 695
 		}
696 696
 	}
697
-	if ( count($query) ) /* This "if" is redundant, because if I call this I already checked there is a change */
697
+	if (count($query)) /* This "if" is redundant, because if I call this I already checked there is a change */
698 698
 		/* I update datemod because the user couldn't change */
699 699
 		$query[] = sprintf('UPDATE `%s` SET
700 700
 						`user`=\'%s\',
@@ -706,18 +706,18 @@  discard block
 block discarded – undo
706 706
 	$myconn->autocommit(FALSE);
707 707
 	$myconn->begin_transaction(MYSQLI_TRANS_START_READ_ONLY);
708 708
 	$ok = TRUE;
709
-	foreach ( $query as $q ) {
709
+	foreach ($query as $q) {
710 710
 		if ($myconn->query($q) !== TRUE) {
711 711
 			$ok = FALSE;
712 712
 			syslog(LOG_ERR, "$loguser: Error: ".$myconn->error);
713 713
 		}
714 714
 	}
715
-	if ( $ok ) {
716
-		if ( $myconn->commit() )
715
+	if ($ok) {
716
+		if ($myconn->commit())
717 717
 			syslog(LOG_INFO, "$loguser: Milter setting changed successfully.");
718 718
 		else {
719 719
 			syslog(LOG_ERR, "$loguser: Milter setting NOT changed for an unpredictable COMMIT error.");
720
-			if ( $myconn->rollback() )
720
+			if ($myconn->rollback())
721 721
 				syslog(LOG_INFO, "$loguser: rollback succeeded.");
722 722
 			else
723 723
 				syslog(LOG_ERR, "$loguser: rollback failed. Your db could be compromized. Check it!");
Please login to merge, or discard this patch.
Braces   +128 added lines, -84 removed lines patch added patch discarded remove patch
@@ -3,9 +3,13 @@  discard block
 block discarded – undo
3 3
 ini_set('error_log', 'syslog');
4 4
 
5 5
 function username() {
6
-	if (isset ($_SERVER['REMOTE_USER'])) $user = $_SERVER['REMOTE_USER'];
7
-        	else if (isset ($_SERVER['USER'])) $user = $_SERVER['USER'];
8
-                	else $user='unknown';
6
+	if (isset ($_SERVER['REMOTE_USER'])) {
7
+		$user = $_SERVER['REMOTE_USER'];
8
+	} else if (isset ($_SERVER['USER'])) {
9
+        		$user = $_SERVER['USER'];
10
+        	} else {
11
+                		$user='unknown';
12
+                	}
9 13
 	return $user;
10 14
 }
11 15
 
@@ -89,8 +93,9 @@  discard block
 block discarded – undo
89 93
 	if ($myconn->query($query) === TRUE) {
90 94
 	    syslog(LOG_INFO, "$user: $type <$value> successfully listed on <$table> for $expQ $expUnit.");
91 95
 	    $result=TRUE;
96
+	} else {
97
+		syslog(LOG_ERR, "$user: Error: ".$myconn->error);
92 98
 	}
93
-	else syslog(LOG_ERR, "$user: Error: ".$myconn->error);
94 99
 	return $result;
95 100
 }
96 101
 
@@ -131,8 +136,9 @@  discard block
 block discarded – undo
131 136
         if ($myconn->query($query) === TRUE) {
132 137
             syslog(LOG_INFO, "$user: relist $type <$value> on <$table> for $expQ $expUnit.");
133 138
 		$result=TRUE;
139
+        } else {
140
+        	syslog (LOG_ERR, "$user: Error: ". $myconn->error);
134 141
         }
135
-        else syslog (LOG_ERR, "$user: Error: ". $myconn->error);
136 142
 	return $result;
137 143
 }
138 144
 
@@ -155,9 +161,11 @@  discard block
 block discarded – undo
155 161
 	}
156 162
 
157 163
 
158
-        if ($return=$myconn->query($query) === TRUE) 
159
-            syslog(LOG_INFO, "$user: permanently DELETED $type <$value> from <$table>.");
160
-        else syslog(LOG_ERR, "$user: Error: ". $myconn->error);
164
+        if ($return=$myconn->query($query) === TRUE) {
165
+                    syslog(LOG_INFO, "$user: permanently DELETED $type <$value> from <$table>.");
166
+        } else {
167
+        	syslog(LOG_ERR, "$user: Error: ". $myconn->error);
168
+        }
161 169
 
162 170
         return $return;
163 171
 }
@@ -179,8 +187,9 @@  discard block
 block discarded – undo
179 187
 
180 188
         if ($return=$myconn->query($query) === TRUE) {
181 189
             syslog(LOG_INFO, "$user: change status of $type <$value>. The status is now <$status>");
190
+        } else {
191
+        	syslog(LOG_ERR, "$user: Error: ". $myconn->error);
182 192
         }
183
-        else syslog(LOG_ERR, "$user: Error: ". $myconn->error);
184 193
 	return $return;	
185 194
 }
186 195
 
@@ -204,14 +213,16 @@  discard block
 block discarded – undo
204 213
 				$j++;
205 214
 
206 215
 			} while ($myconn->next_result());
207
-		}
208
-		else {
216
+		} else {
209 217
 			syslog(LOG_ERR, "Expire job - Error: ". $myconn->error);
210 218
 			$return = FALSE;
211 219
 		}
212 220
 	}
213
-	if ( !($return) ) syslog(LOG_EMERG, 'End of Expire job with error. See above logs. SQL Connection terminated');
214
-	else  syslog(LOG_INFO, 'Successfully End of Expire job. SQL Connection successfully terminated.');
221
+	if ( !($return) ) {
222
+		syslog(LOG_EMERG, 'End of Expire job with error. See above logs. SQL Connection terminated');
223
+	} else {
224
+		syslog(LOG_INFO, 'Successfully End of Expire job. SQL Connection successfully terminated.');
225
+	}
215 226
         return $return;
216 227
 }
217 228
 
@@ -220,8 +231,11 @@  discard block
 block discarded – undo
220 231
 
221 232
 	$exp=new DateTime($row['exp']);
222 233
 	$now=new DateTime('NOW');
223
-	if (($exp > $now) and ($row['active'])) return true;
224
-	else return false;
234
+	if (($exp > $now) and ($row['active'])) {
235
+		return true;
236
+	} else {
237
+		return false;
238
+	}
225 239
 
226 240
 }
227 241
 
@@ -241,10 +255,11 @@  discard block
 block discarded – undo
241 255
 END;
242 256
 		$activeMilts = explode(',',$value);
243 257
 		foreach ( $milts as $milter ) {
244
-			if ( in_array($milter, $activeMilts) )
245
-				$selected= 'selected';
246
-			else
247
-				$selected= NULL;
258
+			if ( in_array($milter, $activeMilts) ) {
259
+							$selected= 'selected';
260
+			} else {
261
+							$selected= NULL;
262
+			}
248 263
 			$button .= sprintf('<option value="%s" %s>%s</option>', $milter, $selected, $milter);
249 264
 		}	
250 265
 		$button .= '</select></div><input class="button" name="Change" type="submit" value="Change" /></form>';
@@ -261,9 +276,12 @@  discard block
 block discarded – undo
261 276
 	$whynot=NULL;
262 277
 	switch ($what) {
263 278
 		case 'Ok':
264
-			if ($lock) return NULL;
265
-			if (in_array($user,array_keys($adm)))
266
-				if ( consistentListing($myconn,$alltables,$typedesc,$value,$whynot) ) return require('relistButton.php');
279
+			if ($lock) {
280
+				return NULL;
281
+			}
282
+			if (in_array($user,array_keys($adm))) {
283
+							if ( consistentListing($myconn,$alltables,$typedesc,$value,$whynot) ) return require('relistButton.php');
284
+			}
267 285
 			return htmlspecialchars($whynot);
268 286
 		case 'Listed':
269 287
 		case 'WhiteListed':
@@ -275,7 +293,9 @@  discard block
 block discarded – undo
275 293
 function consistentListing($myconn,$alltables,$typed,$value,&$warn) {
276 294
 /* Check if there are no pending mislisting */
277 295
 	$warn = NULL;
278
-	if (! isset($alltables["$typed"]['depend']) ) return TRUE;
296
+	if (! isset($alltables["$typed"]['depend']) ) {
297
+		return TRUE;
298
+	}
279 299
 	foreach ($alltables["$typed"]['depend'] as $listdep) {
280 300
 		if ($alltables["$typed"]['field'] != $alltables["$listdep"]['field'] ) {
281 301
 			$warn = "Config ERROR: <$typed> and <$listdep> are of different types! I can't check consistency!";
@@ -306,10 +326,10 @@  discard block
 block discarded – undo
306 326
 	
307 327
 	if ( $tablelist['milter'] ) {
308 328
 		$table = milterTable($type);
309
-		if ($value == 'ALL')
310
-			$query = sprintf('SELECT *, GROUP_CONCAT(milt.name) as miltnames FROM `%s` LEFT JOIN milt ON (%s.idmilt=milt.id) GROUP by idmilt',
329
+		if ($value == 'ALL') {
330
+					$query = sprintf('SELECT *, GROUP_CONCAT(milt.name) as miltnames FROM `%s` LEFT JOIN milt ON (%s.idmilt=milt.id) GROUP by idmilt',
311 331
 				$table,$table);
312
-		else {
332
+		} else {
313 333
 			switch ($type) {
314 334
 				case 'network':
315 335
 					list($sub['net'],$sub['mask'])=explode('/',$value);
@@ -334,12 +354,11 @@  discard block
 block discarded – undo
334 354
 					return FALSE;
335 355
 			}
336 356
 		}
337
-	}
338
-
339
-	else {
357
+	} else {
340 358
 	        $table = $tablelist['name'];
341
-	        if ($value == 'ALL') $query = 'select * from '.$table;
342
-	        else {
359
+	        if ($value == 'ALL') {
360
+	        	$query = 'select * from '.$table;
361
+	        } else {
343 362
 	                switch ($type) {
344 363
 	                  case 'ip':
345 364
 	                        $query= "select * from $table where $type =  INET_ATON('$value')";
@@ -361,8 +380,9 @@  discard block
 block discarded – undo
361 380
 	}
362 381
 
363 382
 	$result = $myconn->query($query);
364
-	if($result === false)
365
-		syslog(LOG_EMERG, "ALERT: Query <$query> failed: ".$myconn->error);
383
+	if($result === false) {
384
+			syslog(LOG_EMERG, "ALERT: Query <$query> failed: ".$myconn->error);
385
+	}
366 386
         return $result;
367 387
 }
368 388
 
@@ -379,12 +399,14 @@  discard block
 block discarded – undo
379 399
 
380 400
 function isFull($myconn,$typedesc,$alltables) {
381 401
         if (isset($alltables["$typedesc"]['limit'])) {
382
-		if ( $alltables["$typedesc"]['milter'] )
383
-			$tab = 'net';
384
-		else
385
-			$tab = $alltables["$typedesc"]['name'];
386
-                if ( countListed($myconn,$tab) >= $alltables["$typedesc"]['limit'] ) 
387
-                        return TRUE;
402
+		if ( $alltables["$typedesc"]['milter'] ) {
403
+					$tab = 'net';
404
+		} else {
405
+					$tab = $alltables["$typedesc"]['name'];
406
+		}
407
+                if ( countListed($myconn,$tab) >= $alltables["$typedesc"]['limit'] ) {
408
+                                        return TRUE;
409
+                }
388 410
         }
389 411
 	return FALSE;
390 412
 }
@@ -397,8 +419,9 @@  discard block
 block discarded – undo
397 419
 	$tabhtm = <<<END
398 420
 	<table><thead><tr><th>$type</th><th title="The date this object has been listed for the first time">DateAdd</th><th>DateMod</th><th>Exp</th><th>Status</th><th title="Number of times this object has been listed">#List</th>
399 421
 END;
400
-	if ( $tables["$typedesc"]['milter'] )
401
-		$tabhtm .= '<th title="Milter active for this object">Milters</th>';
422
+	if ( $tables["$typedesc"]['milter'] ) {
423
+			$tabhtm .= '<th title="Milter active for this object">Milters</th>';
424
+	}
402 425
 	$tabhtm .= '<th>Authored by</th><th width="250">Reason</th><th>Action</th></tr></thead><tfoot><tr></tr></tfoot><tbody>'."\n";
403 426
 
404 427
 	$result = searchentry ($myconn,$value,$tables["$typedesc"]);
@@ -407,18 +430,23 @@  discard block
 block discarded – undo
407 430
 
408 431
         /* Check for limit in number of listed items */
409 432
 	$full = isFull($myconn,$typedesc,$tables);
410
-	if ($full) print '<p>'.htmlspecialchars("$typedesc has reached maximum value of ".$tables["$typedesc"]['limit'].' listed items.').'</p>';
433
+	if ($full) {
434
+		print '<p>'.htmlspecialchars("$typedesc has reached maximum value of ".$tables["$typedesc"]['limit'].' listed items.').'</p>';
435
+	}
411 436
 
412 437
 		if ($result->num_rows) {
413 438
 			print $tabhtm;
414 439
 			$i=0;
415 440
         		while ($riga = $result->fetch_array(MYSQLI_ASSOC)) {
416 441
 				if (isListed($riga)) {
417
-					if ($tables["$typedesc"]['bl']) $listed='Listed';
418
-					else $listed='WhiteListed';
419
-				}	
420
-				else
421
-					$listed='Ok';
442
+					if ($tables["$typedesc"]['bl']) {
443
+						$listed='Listed';
444
+					} else {
445
+						$listed='WhiteListed';
446
+					}
447
+				} else {
448
+									$listed='Ok';
449
+				}
422 450
 
423 451
 				switch ($type) {
424 452
 				  case 'ip':
@@ -431,27 +459,30 @@  discard block
 block discarded – undo
431 459
 					$element = $riga["$type"];
432 460
 				}
433 461
 
434
-				if ( $tables["$typedesc"]['milter'] AND checkMilterConf($tables["$typedesc"]) )
435
-					printf ("<tr id=id$i><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td nowrap id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td>%s</td></tr>\n",
462
+				if ( $tables["$typedesc"]['milter'] AND checkMilterConf($tables["$typedesc"]) ) {
463
+									printf ("<tr id=id$i><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td nowrap id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td>%s</td></tr>\n",
436 464
 					$element, $riga['date'], $riga['datemod'], $riga['exp'], $riga['active'], $riga['nlist'], askMilter($myconn,$i,$element,$typedesc,$riga['idmilt'],$riga['miltnames'],$user,$adm), $riga['user'],htmlspecialchars($riga['reason']),ask($myconn,$i,$listed,$tables,$typedesc,$element,$full,$user,$adm));
437
-				else
438
-					 printf ("<tr id=id$i><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td>%s</td></tr>\n",
465
+				} else {
466
+									 printf ("<tr id=id$i><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td id='status$listed'>%s</td><td>%s</td></tr>\n",
439 467
 					$element, $riga['date'], $riga['datemod'], $riga['exp'], $riga['active'], $riga['nlist'], $riga['user'],htmlspecialchars($riga['reason']),ask($myconn,$i,$listed,$tables,$typedesc,$element,$full,$user,$adm));
468
+				}
440 469
 				$i++;
441 470
         		}
442 471
 			print '</tbody></table>';
443
-		}
444
-		else {
472
+		} else {
445 473
 			print "<pre>$type &lt;$value&gt; is not listed!\n</pre>";
446
-			if ( in_array($user,array_keys($adm)) AND ($value != 'ALL') )
447
-				if ( (!$full) AND (consistentListing($myconn,$tables,$typedesc,$value,$whynot)) ) require_once('listForm.php');
448
-									else print '<p>'.htmlspecialchars($whynot).'</p>';
474
+			if ( in_array($user,array_keys($adm)) AND ($value != 'ALL') ) {
475
+							if ( (!$full) AND (consistentListing($myconn,$tables,$typedesc,$value,$whynot)) ) require_once('listForm.php');
476
+			} else {
477
+										print '<p>'.htmlspecialchars($whynot).'</p>';
478
+									}
449 479
 				
450 480
 		}
451 481
 		$result->free();
482
+	} else {
483
+		print '<pre>Query error or something wrong in DB schema'."\n</pre>";
484
+	}
452 485
 	}
453
-	else print '<pre>Query error or something wrong in DB schema'."\n</pre>";
454
-}
455 486
 
456 487
 
457 488
 
@@ -494,24 +525,32 @@  discard block
 block discarded – undo
494 525
                 $old_mailfrom = ini_get("sendmail_from");
495 526
                 ini_set("sendmail_from", $from);
496 527
                 $params = sprintf("-oi -f %s", '<>');
497
-                if (!(mail($to,$sbj, $body,$headers,$params))) $flag=FALSE;
498
-                else $flag=TRUE;
499
-                if (isset($old_mailfrom))
500
-                        ini_set("sendmail_from", $old_mailfrom);
501
-        }
502
-        else {
503
-                if (!(mail($to,$sbj, $body,$headers))) $flag=FALSE;
504
-                else $flag=TRUE;
528
+                if (!(mail($to,$sbj, $body,$headers,$params))) {
529
+                	$flag=FALSE;
530
+                } else {
531
+                	$flag=TRUE;
532
+                }
533
+                if (isset($old_mailfrom)) {
534
+                                        ini_set("sendmail_from", $old_mailfrom);
535
+                }
536
+        } else {
537
+                if (!(mail($to,$sbj, $body,$headers))) {
538
+                	$flag=FALSE;
539
+                } else {
540
+                	$flag=TRUE;
541
+                }
505 542
         }
506 543
         return $flag;
507 544
 }
508 545
 
509 546
 function emailToNotify($notify_file,$dom) {
510 547
 	$ini_array = parse_ini_file($notify_file);
511
-	if (in_array($dom,array_keys($ini_array)))
512
-		return $ini_array["$dom"];
513
-	else return FALSE;
514
-}
548
+	if (in_array($dom,array_keys($ini_array))) {
549
+			return $ini_array["$dom"];
550
+	} else {
551
+		return FALSE;
552
+	}
553
+	}
515 554
 
516 555
 
517 556
 function searchAndList ($myconn,$loguser,$tables,$typedesc,$value,$unit,&$quantity,$reason) {
@@ -588,9 +627,10 @@  discard block
 block discarded – undo
588 627
 	$net = new \dautkom\ipv4\IPv4();
589 628
 	$range = $net->address($addressA)->mask($maskA)->getRange();
590 629
 	$ips = ipRange($range);
591
-	foreach ( $ips as $ip )
592
-		if ( $net->address($addressB)->mask($maskB)->has($ip) )
630
+	foreach ( $ips as $ip ) {
631
+			if ( $net->address($addressB)->mask($maskB)->has($ip) )
593 632
 			return TRUE;
633
+	}
594 634
 	return FALSE;
595 635
 }
596 636
 
@@ -667,8 +707,9 @@  discard block
 block discarded – undo
667 707
 		return FALSE;
668 708
 	}
669 709
 	if ($result->num_rows) {
670
-		while ($milt = $result->fetch_array(MYSQLI_ASSOC))
671
-			$milters[] = $milt['name'];
710
+		while ($milt = $result->fetch_array(MYSQLI_ASSOC)) {
711
+					$milters[] = $milt['name'];
712
+		}
672 713
 	}
673 714
 	$result->free();
674 715
 	return $milters;
@@ -694,12 +735,14 @@  discard block
 block discarded – undo
694 735
 				$query[] = "DELETE FROM  `milt` WHERE (`id` = '$miltID' AND `name` = '$value')";
695 736
 		}
696 737
 	}
697
-	if ( count($query) ) /* This "if" is redundant, because if I call this I already checked there is a change */
738
+	if ( count($query) ) {
739
+		/* This "if" is redundant, because if I call this I already checked there is a change */
698 740
 		/* I update datemod because the user couldn't change */
699 741
 		$query[] = sprintf('UPDATE `%s` SET
700 742
 						`user`=\'%s\',
701 743
 						`datemod`= CURRENT_TIMESTAMP
702 744
 					 WHERE `idmilt`=%d', $table, $loguser, $miltID);
745
+	}
703 746
 
704 747
 
705 748
 	/* Start a safe transaction: it commits only if all queries happen */
@@ -713,19 +756,20 @@  discard block
 block discarded – undo
713 756
 		}
714 757
 	}
715 758
 	if ( $ok ) {
716
-		if ( $myconn->commit() )
717
-			syslog(LOG_INFO, "$loguser: Milter setting changed successfully.");
718
-		else {
759
+		if ( $myconn->commit() ) {
760
+					syslog(LOG_INFO, "$loguser: Milter setting changed successfully.");
761
+		} else {
719 762
 			syslog(LOG_ERR, "$loguser: Milter setting NOT changed for an unpredictable COMMIT error.");
720
-			if ( $myconn->rollback() )
721
-				syslog(LOG_INFO, "$loguser: rollback succeeded.");
722
-			else
723
-				syslog(LOG_ERR, "$loguser: rollback failed. Your db could be compromized. Check it!");
763
+			if ( $myconn->rollback() ) {
764
+							syslog(LOG_INFO, "$loguser: rollback succeeded.");
765
+			} else {
766
+							syslog(LOG_ERR, "$loguser: rollback failed. Your db could be compromized. Check it!");
767
+			}
724 768
 			$ok = FALSE;
725 769
 		}
770
+	} else {
771
+			syslog(LOG_ERR, "$loguser: Error: Milter setting NOT changed. See at above errors.");
726 772
 	}
727
-	else
728
-		syslog(LOG_ERR, "$loguser: Error: Milter setting NOT changed. See at above errors.");
729 773
 	return $ok;
730 774
 		
731 775
 }
Please login to merge, or discard this patch.
changeMilter.php 3 patches
Indentation   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -44,8 +44,8 @@  discard block
 block discarded – undo
44 44
 	}
45 45
 	if (! empty($old) ) {
46 46
 		foreach ($old as $item) {
47
-        		if (! in_array($item, $new) ) {
48
-                		$values["$item"] = 'del';
47
+				if (! in_array($item, $new) ) {
48
+						$values["$item"] = 'del';
49 49
 				$logs[] = "<$item>: ". $values["$item"];
50 50
 			}
51 51
 		}
@@ -63,7 +63,7 @@  discard block
 block discarded – undo
63 63
 	
64 64
 	/* Store new values */
65 65
 	if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
66
-        	exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
66
+			exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
67 67
 
68 68
 	if (changeMilter ($mysqli,$user,$values,$col,$_POST['miltId']))
69 69
 		print 'OK milter setting changed.';
Please login to merge, or discard this patch.
Spacing   +18 added lines, -18 removed lines patch added patch discarded remove patch
@@ -1,10 +1,10 @@  discard block
 block discarded – undo
1 1
 <?php
2 2
 require_once('config.php');
3 3
 require_once('function.php');
4
-$typedesc=$_POST['type'];
4
+$typedesc = $_POST['type'];
5 5
 $type = $tables["$typedesc"]['field'];
6 6
 $col = milterTable($type);
7
-if ( $col === FALSE )
7
+if ($col === FALSE)
8 8
 	exit ("<p>Error in you config at field <b>$type</b>.</p>");
9 9
 ?>
10 10
 <td colspan="10" style="text-align: center">
@@ -18,54 +18,54 @@  discard block
 block discarded – undo
18 18
 	$new = $_POST['newvalues'];
19 19
 else
20 20
 	$new = array();
21
-if (! empty($_POST['oldvalues']))
21
+if (!empty($_POST['oldvalues']))
22 22
 	$old = explode(',', $_POST['oldvalues']);
23 23
 else
24
-	$old=array();
25
-$values=array();
26
-$logs=array();
24
+	$old = array();
25
+$values = array();
26
+$logs = array();
27 27
 
28 28
 print '<pre>';
29 29
 /* Check need to disable all milters, removing unnecessary setting */
30
-if ( in_array('DISABLE ALL', $new) )
30
+if (in_array('DISABLE ALL', $new))
31 31
 	$new = array('DISABLE ALL');
32 32
 
33 33
 /* Compare the values determining what to do */
34 34
 if (count(array_diff(array_merge($new, $old), array_intersect($new, $old))) !== 0) {
35 35
 	/* New and old are different (we assume we don't have duplicate values) */
36
-	if (! empty($new) ) {
36
+	if (!empty($new)) {
37 37
 		foreach ($new as $item) {
38
-			if ( in_array($item, $old) )
38
+			if (in_array($item, $old))
39 39
 				$values["$item"] = 'keep';
40 40
 			else
41 41
 				$values["$item"] = 'add';
42
-			$logs[] = "<$item>: ". $values["$item"];
42
+			$logs[] = "<$item>: ".$values["$item"];
43 43
 		}
44 44
 	}
45
-	if (! empty($old) ) {
45
+	if (!empty($old)) {
46 46
 		foreach ($old as $item) {
47
-        		if (! in_array($item, $new) ) {
47
+        		if (!in_array($item, $new)) {
48 48
                 		$values["$item"] = 'del';
49
-				$logs[] = "<$item>: ". $values["$item"];
49
+				$logs[] = "<$item>: ".$values["$item"];
50 50
 			}
51 51
 		}
52 52
 	}
53 53
 }
54 54
 
55 55
 /* Logging */
56
-if ( empty($values) ) 
56
+if (empty($values)) 
57 57
 	print 'No values to change.';
58 58
 else {
59
-	$msg = sprintf('%s: Changing Milter setting on list <%s> for %s <%s>.',$user,$typedesc,$type, $_POST['object']);
59
+	$msg = sprintf('%s: Changing Milter setting on list <%s> for %s <%s>.', $user, $typedesc, $type, $_POST['object']);
60 60
 	syslog(LOG_INFO, $msg);
61 61
 	foreach ($logs as $log)
62 62
 		syslog(LOG_INFO, "$user: milter $log");
63 63
 	
64 64
 	/* Store new values */
65
-	if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
66
-        	exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
65
+	if (($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE)
66
+        	exit ($user.': Connect Error ('.$mysqli->connect_errno.') '.$mysqli->connect_error);
67 67
 
68
-	if (changeMilter ($mysqli,$user,$values,$col,$_POST['miltId']))
68
+	if (changeMilter($mysqli, $user, $values, $col, $_POST['miltId']))
69 69
 		print 'OK milter setting changed.';
70 70
 	else
71 71
 		print 'ERROR updating milter setting; check your syslog. No changes made.';
Please login to merge, or discard this patch.
Braces   +28 added lines, -20 removed lines patch added patch discarded remove patch
@@ -4,8 +4,9 @@  discard block
 block discarded – undo
4 4
 $typedesc=$_POST['type'];
5 5
 $type = $tables["$typedesc"]['field'];
6 6
 $col = milterTable($type);
7
-if ( $col === FALSE )
7
+if ( $col === FALSE ) {
8 8
 	exit ("<p>Error in you config at field <b>$type</b>.</p>");
9
+}
9 10
 ?>
10 11
 <td colspan="10" style="text-align: center">
11 12
 
@@ -14,31 +15,35 @@  discard block
 block discarded – undo
14 15
 $user = $_POST['user'];
15 16
 
16 17
 /* Compare old values with new ones */
17
-if (isset($_POST['newvalues']))
18
+if (isset($_POST['newvalues'])) {
18 19
 	$new = $_POST['newvalues'];
19
-else
20
+} else {
20 21
 	$new = array();
21
-if (! empty($_POST['oldvalues']))
22
+}
23
+if (! empty($_POST['oldvalues'])) {
22 24
 	$old = explode(',', $_POST['oldvalues']);
23
-else
25
+} else {
24 26
 	$old=array();
27
+}
25 28
 $values=array();
26 29
 $logs=array();
27 30
 
28 31
 print '<pre>';
29 32
 /* Check need to disable all milters, removing unnecessary setting */
30
-if ( in_array('DISABLE ALL', $new) )
33
+if ( in_array('DISABLE ALL', $new) ) {
31 34
 	$new = array('DISABLE ALL');
35
+}
32 36
 
33 37
 /* Compare the values determining what to do */
34 38
 if (count(array_diff(array_merge($new, $old), array_intersect($new, $old))) !== 0) {
35 39
 	/* New and old are different (we assume we don't have duplicate values) */
36 40
 	if (! empty($new) ) {
37 41
 		foreach ($new as $item) {
38
-			if ( in_array($item, $old) )
39
-				$values["$item"] = 'keep';
40
-			else
41
-				$values["$item"] = 'add';
42
+			if ( in_array($item, $old) ) {
43
+							$values["$item"] = 'keep';
44
+			} else {
45
+							$values["$item"] = 'add';
46
+			}
42 47
 			$logs[] = "<$item>: ". $values["$item"];
43 48
 		}
44 49
 	}
@@ -53,22 +58,25 @@  discard block
 block discarded – undo
53 58
 }
54 59
 
55 60
 /* Logging */
56
-if ( empty($values) ) 
61
+if ( empty($values) ) {
57 62
 	print 'No values to change.';
58
-else {
63
+} else {
59 64
 	$msg = sprintf('%s: Changing Milter setting on list <%s> for %s <%s>.',$user,$typedesc,$type, $_POST['object']);
60 65
 	syslog(LOG_INFO, $msg);
61
-	foreach ($logs as $log)
62
-		syslog(LOG_INFO, "$user: milter $log");
66
+	foreach ($logs as $log) {
67
+			syslog(LOG_INFO, "$user: milter $log");
68
+	}
63 69
 	
64 70
 	/* Store new values */
65
-	if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
66
-        	exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
71
+	if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE ) {
72
+	        	exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
73
+	}
67 74
 
68
-	if (changeMilter ($mysqli,$user,$values,$col,$_POST['miltId']))
69
-		print 'OK milter setting changed.';
70
-	else
71
-		print 'ERROR updating milter setting; check your syslog. No changes made.';
75
+	if (changeMilter ($mysqli,$user,$values,$col,$_POST['miltId'])) {
76
+			print 'OK milter setting changed.';
77
+	} else {
78
+			print 'ERROR updating milter setting; check your syslog. No changes made.';
79
+	}
72 80
 
73 81
 	$mysqli->close();
74 82
 }
Please login to merge, or discard this patch.
listForm.php 2 patches
Spacing   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -1,18 +1,18 @@
 block discarded – undo
1 1
 <?php
2
-if (in_array($user,array_keys(array_filter($adm)))) $extopt = '<option value="MONTH">MONTHS</option><option value="YEAR">YEARS</option>';
2
+if (in_array($user, array_keys(array_filter($adm)))) $extopt = '<option value="MONTH">MONTHS</option><option value="YEAR">YEARS</option>';
3 3
 else $extopt = NULL;
4 4
 
5
-if ( $tables["$typedesc"]['milter'] ) {
6
-	if ( checkMilterConf($tables["$typedesc"]) ) 
5
+if ($tables["$typedesc"]['milter']) {
6
+	if (checkMilterConf($tables["$typedesc"])) 
7 7
 		print '<p>This is a milter table. Please, first add your item as usual. Then you will be able to customize the milter settings.</p>';
8 8
 	else {
9 9
 		$err = "Error in config about <$typedesc>. Check at your config.php.";
10
-		syslog (LOG_EMERG, $err);
11
-		printf ('<p>%s</p>', htmlspecialchars($err) );
10
+		syslog(LOG_EMERG, $err);
11
+		printf('<p>%s</p>', htmlspecialchars($err));
12 12
 	}	
13 13
 }	
14 14
 ?>
15 15
 <form style="margin:0; text-align: left;" name='ListButton<?php echo $type ?>' enctype="text/plain" method="post" target="_self" action="list.php"  onSubmit="xmlhttpPost('list.php', 'ListButton<?php echo $type ?>', 'Risultato', '<img src=\'/include/pleasewait.gif\'>'); return false;" />
16 16
 
17 17
 		List <?php  echo $typedesc.' &lt;'.$value.'&gt;'; ?> for <input name="type" type="hidden" value="<?php echo $typedesc; ?>" /><input name="value" type="hidden" class="input_text" value="<?php echo $value; ?>" />
18
-		<select name="quantity" class="input_text" size="1"><option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="20">20</option></select><select class="input_text" name="unit" size="1"><option value="DAY">DAYS</option><option value="WEEK">WEEKS</option><?php echo $extopt;?></select>  Reason:<input maxlength="128" name="reason" size="30" type="text" class="input_text" /><input name="List" class="button" id="bwarn" type="submit" value="List"/></form>
18
+		<select name="quantity" class="input_text" size="1"><option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="20">20</option></select><select class="input_text" name="unit" size="1"><option value="DAY">DAYS</option><option value="WEEK">WEEKS</option><?php echo $extopt; ?></select>  Reason:<input maxlength="128" name="reason" size="30" type="text" class="input_text" /><input name="List" class="button" id="bwarn" type="submit" value="List"/></form>
Please login to merge, or discard this patch.
Braces   +8 added lines, -5 removed lines patch added patch discarded remove patch
@@ -1,11 +1,14 @@
 block discarded – undo
1 1
 <?php
2
-if (in_array($user,array_keys(array_filter($adm)))) $extopt = '<option value="MONTH">MONTHS</option><option value="YEAR">YEARS</option>';
3
-else $extopt = NULL;
2
+if (in_array($user,array_keys(array_filter($adm)))) {
3
+	$extopt = '<option value="MONTH">MONTHS</option><option value="YEAR">YEARS</option>';
4
+} else {
5
+	$extopt = NULL;
6
+}
4 7
 
5 8
 if ( $tables["$typedesc"]['milter'] ) {
6
-	if ( checkMilterConf($tables["$typedesc"]) ) 
7
-		print '<p>This is a milter table. Please, first add your item as usual. Then you will be able to customize the milter settings.</p>';
8
-	else {
9
+	if ( checkMilterConf($tables["$typedesc"]) ) {
10
+			print '<p>This is a milter table. Please, first add your item as usual. Then you will be able to customize the milter settings.</p>';
11
+	} else {
9 12
 		$err = "Error in config about <$typedesc>. Check at your config.php.";
10 13
 		syslog (LOG_EMERG, $err);
11 14
 		printf ('<p>%s</p>', htmlspecialchars($err) );
Please login to merge, or discard this patch.
relist.php 3 patches
Indentation   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -11,11 +11,11 @@
 block discarded – undo
11 11
 openlog($tag, LOG_PID, $fac);
12 12
 if (empty($_POST['reason'])) die ("Specify a reason, please!</td>");
13 13
 if (preg_match( '/[^\x20-\x7f]/', $_POST['reason']))
14
-        exit('ERROR: &lt;'.htmlentities($_POST['reason'],ENT_COMPAT | ENT_HTML401, 'ISO-8859-1').'&gt; contains NON ASCII chars.</td>');
14
+		exit('ERROR: &lt;'.htmlentities($_POST['reason'],ENT_COMPAT | ENT_HTML401, 'ISO-8859-1').'&gt; contains NON ASCII chars.</td>');
15 15
 $user = username();
16 16
 
17 17
 if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
18
-                exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
18
+				exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
19 19
 
20 20
 if (isFull($mysqli,$typedesc,$tables)) die("ERROR in relist: ".htmlspecialchars("$typedesc has reached maximum value of ".$tables["$typedesc"]['limit'].' listed items.') );
21 21
 if (relist ($mysqli,username(),$_POST['value'],$type,$table,$_POST['unit'],$_POST['quantity'],$_POST['reason']))
Please login to merge, or discard this patch.
Spacing   +7 added lines, -7 removed lines patch added patch discarded remove patch
@@ -1,7 +1,7 @@  discard block
 block discarded – undo
1 1
 <?php
2 2
 require_once('config.php');
3 3
 require_once('function.php');
4
-$typedesc=$_POST['type'];
4
+$typedesc = $_POST['type'];
5 5
 $type = $tables["$typedesc"]['field'];
6 6
 $table = ($tables["$typedesc"]['milter']) ? milterTable($type) : $tables["$typedesc"]['name'];
7 7
 $cl = ($tables["$typedesc"]['milter']) ? 10 : 9;
@@ -10,15 +10,15 @@  discard block
 block discarded – undo
10 10
 <?php
11 11
 openlog($tag, LOG_PID, $fac);
12 12
 if (empty($_POST['reason'])) die ("Specify a reason, please!</td>");
13
-if (preg_match( '/[^\x20-\x7f]/', $_POST['reason']))
14
-        exit('ERROR: &lt;'.htmlentities($_POST['reason'],ENT_COMPAT | ENT_HTML401, 'ISO-8859-1').'&gt; contains NON ASCII chars.</td>');
13
+if (preg_match('/[^\x20-\x7f]/', $_POST['reason']))
14
+        exit('ERROR: &lt;'.htmlentities($_POST['reason'], ENT_COMPAT | ENT_HTML401, 'ISO-8859-1').'&gt; contains NON ASCII chars.</td>');
15 15
 $user = username();
16 16
 
17
-if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
18
-                exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
17
+if (($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE)
18
+                exit ($user.': Connect Error ('.$mysqli->connect_errno.') '.$mysqli->connect_error);
19 19
 
20
-if (isFull($mysqli,$typedesc,$tables)) die("ERROR in relist: ".htmlspecialchars("$typedesc has reached maximum value of ".$tables["$typedesc"]['limit'].' listed items.') );
21
-if (relist ($mysqli,username(),$_POST['value'],$type,$table,$_POST['unit'],$_POST['quantity'],$_POST['reason']))
20
+if (isFull($mysqli, $typedesc, $tables)) die("ERROR in relist: ".htmlspecialchars("$typedesc has reached maximum value of ".$tables["$typedesc"]['limit'].' listed items.'));
21
+if (relist($mysqli, username(), $_POST['value'], $type, $table, $_POST['unit'], $_POST['quantity'], $_POST['reason']))
22 22
  print 'OK '.$_POST["type"].' &lt;'.$_POST['value'].'&gt; relisted for '.$_POST['quantity'].$_POST['unit'];
23 23
 else
24 24
  print 'ERROR in relist; check log';
Please login to merge, or discard this patch.
Braces   +13 added lines, -6 removed lines patch added patch discarded remove patch
@@ -9,19 +9,26 @@
 block discarded – undo
9 9
 <td colspan="<?php echo $cl; ?>" style="text-align: center">
10 10
 <?php
11 11
 openlog($tag, LOG_PID, $fac);
12
-if (empty($_POST['reason'])) die ("Specify a reason, please!</td>");
13
-if (preg_match( '/[^\x20-\x7f]/', $_POST['reason']))
12
+if (empty($_POST['reason'])) {
13
+	die ("Specify a reason, please!</td>");
14
+}
15
+if (preg_match( '/[^\x20-\x7f]/', $_POST['reason'])) {
14 16
         exit('ERROR: &lt;'.htmlentities($_POST['reason'],ENT_COMPAT | ENT_HTML401, 'ISO-8859-1').'&gt; contains NON ASCII chars.</td>');
17
+}
15 18
 $user = username();
16 19
 
17
-if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
20
+if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE ) {
18 21
                 exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
22
+}
19 23
 
20
-if (isFull($mysqli,$typedesc,$tables)) die("ERROR in relist: ".htmlspecialchars("$typedesc has reached maximum value of ".$tables["$typedesc"]['limit'].' listed items.') );
21
-if (relist ($mysqli,username(),$_POST['value'],$type,$table,$_POST['unit'],$_POST['quantity'],$_POST['reason']))
24
+if (isFull($mysqli,$typedesc,$tables)) {
25
+	die("ERROR in relist: ".htmlspecialchars("$typedesc has reached maximum value of ".$tables["$typedesc"]['limit'].' listed items.') );
26
+}
27
+if (relist ($mysqli,username(),$_POST['value'],$type,$table,$_POST['unit'],$_POST['quantity'],$_POST['reason'])) {
22 28
  print 'OK '.$_POST["type"].' &lt;'.$_POST['value'].'&gt; relisted for '.$_POST['quantity'].$_POST['unit'];
23
-else
29
+} else {
24 30
  print 'ERROR in relist; check log';
31
+}
25 32
 $mysqli->close();
26 33
 closelog();
27 34
 print '</td>';
Please login to merge, or discard this patch.
result.php 3 patches
Indentation   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -10,7 +10,7 @@  discard block
 block discarded – undo
10 10
 		exit ('<pre>&lt;'.$_POST['Value'].'&gt; is NOT a valid email address.</pre>');
11 11
 
12 12
 if ( ($tables["$_"]['field']=='domain') AND ($_POST['Value']!='ALL') )
13
-        if (!(filter_var(gethostbyname($_POST['Value']), FILTER_VALIDATE_IP)))
13
+		if (!(filter_var(gethostbyname($_POST['Value']), FILTER_VALIDATE_IP)))
14 14
 		exit ('<pre>&lt;'.$_POST['Value'].'&gt; is NOT a valid domain.</pre>');
15 15
 
16 16
 if ( ($tables["$_"]['field']=='ip')  AND ($_POST['Value']!='ALL') )
@@ -27,8 +27,8 @@  discard block
 block discarded – undo
27 27
 }
28 28
 
29 29
 if ( ($tables["$_"]['field']=='username') AND ($_POST['Value']!='ALL') ) {
30
-        if ( preg_match( '/[^\x20-\x7f]/', $_POST['Value']) )
31
-                exit('<pre>&lt;'.$_POST['Value'].'&gt; contains NON ASCII chars.</pre>');
30
+		if ( preg_match( '/[^\x20-\x7f]/', $_POST['Value']) )
31
+				exit('<pre>&lt;'.$_POST['Value'].'&gt; contains NON ASCII chars.</pre>');
32 32
 	if ( preg_match( '/[$~=#*+%,{}()\/\\<>;:\"`\[\]&?\s]/', $_POST['Value']) )
33 33
 		exit('<pre>&lt;'.$_POST['Value'].'&gt; contains invalid ASCII chars.</pre>');
34 34
 	switch ( $_POST['Value'] ) {
Please login to merge, or discard this patch.
Spacing   +13 added lines, -13 removed lines patch added patch discarded remove patch
@@ -5,20 +5,20 @@  discard block
 block discarded – undo
5 5
 $net = new \dautkom\ipv4\IPv4();
6 6
 
7 7
 $_ = $_POST['genere'];
8
-if ( ($tables["$_"]['field']=='email') AND ($_POST['Value']!='ALL') )
8
+if (($tables["$_"]['field'] == 'email') AND ($_POST['Value'] != 'ALL'))
9 9
 	if (!(filter_var($_POST['Value'], FILTER_VALIDATE_EMAIL)))
10 10
 		exit ('<pre>&lt;'.$_POST['Value'].'&gt; is NOT a valid email address.</pre>');
11 11
 
12
-if ( ($tables["$_"]['field']=='domain') AND ($_POST['Value']!='ALL') )
12
+if (($tables["$_"]['field'] == 'domain') AND ($_POST['Value'] != 'ALL'))
13 13
         if (!(filter_var(gethostbyname($_POST['Value']), FILTER_VALIDATE_IP)))
14 14
 		exit ('<pre>&lt;'.$_POST['Value'].'&gt; is NOT a valid domain.</pre>');
15 15
 
16
-if ( ($tables["$_"]['field']=='ip')  AND ($_POST['Value']!='ALL') )
16
+if (($tables["$_"]['field'] == 'ip') AND ($_POST['Value'] != 'ALL'))
17 17
 	if (!(filter_var($_POST['Value'], FILTER_VALIDATE_IP, FILTER_FLAG_IPV4)))
18 18
 		exit ('<pre>&lt;'.$_POST['Value'].'&gt; is NOT a valid IP address.</pre>');
19 19
 	
20
-if ( ($tables["$_"]['field']=='network') AND ($_POST['Value']!='ALL') ) {
21
-	$value = explode('/',$_POST['Value']);
20
+if (($tables["$_"]['field'] == 'network') AND ($_POST['Value'] != 'ALL')) {
21
+	$value = explode('/', $_POST['Value']);
22 22
 	if (count($value) != 2)
23 23
 		exit ('<pre>&lt;'.$_POST['Value'].'&gt; is NOT a valid Network/Netmask pair.</pre>');
24 24
 	if (!$net->address($value[0])->mask($value[1])->isValid(1))
@@ -26,16 +26,16 @@  discard block
 block discarded – undo
26 26
 	$_POST['Value'] = $value[0].'/'.$net->mask($value[1])->convertTo('dec');
27 27
 }
28 28
 
29
-if ( ($tables["$_"]['field']=='username') AND ($_POST['Value']!='ALL') ) {
30
-        if ( preg_match( '/[^\x20-\x7f]/', $_POST['Value']) )
29
+if (($tables["$_"]['field'] == 'username') AND ($_POST['Value'] != 'ALL')) {
30
+        if (preg_match('/[^\x20-\x7f]/', $_POST['Value']))
31 31
                 exit('<pre>&lt;'.$_POST['Value'].'&gt; contains NON ASCII chars.</pre>');
32
-	if ( preg_match( '/[$~=#*+%,{}()\/\\<>;:\"`\[\]&?\s]/', $_POST['Value']) )
32
+	if (preg_match('/[$~=#*+%,{}()\/\\<>;:\"`\[\]&?\s]/', $_POST['Value']))
33 33
 		exit('<pre>&lt;'.$_POST['Value'].'&gt; contains invalid ASCII chars.</pre>');
34
-	switch ( $_POST['Value'] ) {
34
+	switch ($_POST['Value']) {
35 35
 		case 'anonymous':
36 36
 		case 'anybody':
37 37
 		case 'anyone':
38
-		case ( preg_match( '/^anyone@/',$_POST['Value']) == TRUE ):
38
+		case (preg_match('/^anyone@/', $_POST['Value']) == TRUE):
39 39
 			exit('<pre>&lt;'.$_POST['Value'].'&gt; is not allowed.</pre>');
40 40
 	}
41 41
 }	
@@ -51,10 +51,10 @@  discard block
 block discarded – undo
51 51
 openlog($tag, LOG_PID, $fac);
52 52
 $user = username();
53 53
 
54
-if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $_, $user)) === FALSE )
55
-	exit ('Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
54
+if (($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $_, $user)) === FALSE)
55
+	exit ('Connect Error ('.$mysqli->connect_errno.') '.$mysqli->connect_error);
56 56
 	
57
-rlookup($mysqli,username(),$admins,$_POST['Value'],$_POST['genere'],$tables);
57
+rlookup($mysqli, username(), $admins, $_POST['Value'], $_POST['genere'], $tables);
58 58
 $mysqli->close();
59 59
 closelog();
60 60
 ?>
Please login to merge, or discard this patch.
Braces   +28 added lines, -16 removed lines patch added patch discarded remove patch
@@ -5,32 +5,39 @@  discard block
 block discarded – undo
5 5
 $net = new \dautkom\ipv4\IPv4();
6 6
 
7 7
 $_ = $_POST['genere'];
8
-if ( ($tables["$_"]['field']=='email') AND ($_POST['Value']!='ALL') )
8
+if ( ($tables["$_"]['field']=='email') AND ($_POST['Value']!='ALL') ) {
9 9
 	if (!(filter_var($_POST['Value'], FILTER_VALIDATE_EMAIL)))
10 10
 		exit ('<pre>&lt;'.$_POST['Value'].'&gt; is NOT a valid email address.</pre>');
11
+}
11 12
 
12
-if ( ($tables["$_"]['field']=='domain') AND ($_POST['Value']!='ALL') )
13
+if ( ($tables["$_"]['field']=='domain') AND ($_POST['Value']!='ALL') ) {
13 14
         if (!(filter_var(gethostbyname($_POST['Value']), FILTER_VALIDATE_IP)))
14 15
 		exit ('<pre>&lt;'.$_POST['Value'].'&gt; is NOT a valid domain.</pre>');
16
+}
15 17
 
16
-if ( ($tables["$_"]['field']=='ip')  AND ($_POST['Value']!='ALL') )
18
+if ( ($tables["$_"]['field']=='ip')  AND ($_POST['Value']!='ALL') ) {
17 19
 	if (!(filter_var($_POST['Value'], FILTER_VALIDATE_IP, FILTER_FLAG_IPV4)))
18 20
 		exit ('<pre>&lt;'.$_POST['Value'].'&gt; is NOT a valid IP address.</pre>');
21
+}
19 22
 	
20 23
 if ( ($tables["$_"]['field']=='network') AND ($_POST['Value']!='ALL') ) {
21 24
 	$value = explode('/',$_POST['Value']);
22
-	if (count($value) != 2)
23
-		exit ('<pre>&lt;'.$_POST['Value'].'&gt; is NOT a valid Network/Netmask pair.</pre>');
24
-	if (!$net->address($value[0])->mask($value[1])->isValid(1))
25
-		exit ('<pre>&lt;'.$_POST['Value'].'&gt; is NOT a valid Network/Netmask.</pre>');
25
+	if (count($value) != 2) {
26
+			exit ('<pre>&lt;'.$_POST['Value'].'&gt; is NOT a valid Network/Netmask pair.</pre>');
27
+	}
28
+	if (!$net->address($value[0])->mask($value[1])->isValid(1)) {
29
+			exit ('<pre>&lt;'.$_POST['Value'].'&gt; is NOT a valid Network/Netmask.</pre>');
30
+	}
26 31
 	$_POST['Value'] = $value[0].'/'.$net->mask($value[1])->convertTo('dec');
27 32
 }
28 33
 
29 34
 if ( ($tables["$_"]['field']=='username') AND ($_POST['Value']!='ALL') ) {
30
-        if ( preg_match( '/[^\x20-\x7f]/', $_POST['Value']) )
31
-                exit('<pre>&lt;'.$_POST['Value'].'&gt; contains NON ASCII chars.</pre>');
32
-	if ( preg_match( '/[$~=#*+%,{}()\/\\<>;:\"`\[\]&?\s]/', $_POST['Value']) )
33
-		exit('<pre>&lt;'.$_POST['Value'].'&gt; contains invalid ASCII chars.</pre>');
35
+        if ( preg_match( '/[^\x20-\x7f]/', $_POST['Value']) ) {
36
+                        exit('<pre>&lt;'.$_POST['Value'].'&gt; contains NON ASCII chars.</pre>');
37
+        }
38
+	if ( preg_match( '/[$~=#*+%,{}()\/\\<>;:\"`\[\]&?\s]/', $_POST['Value']) ) {
39
+			exit('<pre>&lt;'.$_POST['Value'].'&gt; contains invalid ASCII chars.</pre>');
40
+	}
34 41
 	switch ( $_POST['Value'] ) {
35 42
 		case 'anonymous':
36 43
 		case 'anybody':
@@ -41,18 +48,23 @@  discard block
 block discarded – undo
41 48
 }	
42 49
 
43 50
 if (empty($_GET)) {
44
-	if ($tables["$_"]['milter']) print "<p><i>$_</i> is a miltermap of ".$tables["$_"]['field'].'.</p>';
45
-	else {
46
-		if ($tables["$_"]['bl']) print "<p><i>$_</i> is a blocklist of ".$tables["$_"]['field'].'.</p>';
47
-		else                     print "<p><i>$_</i> is a whitelist of ".$tables["$_"]['field'].'.</p>';
51
+	if ($tables["$_"]['milter']) {
52
+		print "<p><i>$_</i> is a miltermap of ".$tables["$_"]['field'].'.</p>';
53
+	} else {
54
+		if ($tables["$_"]['bl']) {
55
+			print "<p><i>$_</i> is a blocklist of ".$tables["$_"]['field'].'.</p>';
56
+		} else {
57
+			print "<p><i>$_</i> is a whitelist of ".$tables["$_"]['field'].'.</p>';
58
+		}
48 59
 	}
49 60
 }
50 61
 
51 62
 openlog($tag, LOG_PID, $fac);
52 63
 $user = username();
53 64
 
54
-if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $_, $user)) === FALSE )
65
+if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $_, $user)) === FALSE ) {
55 66
 	exit ('Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
67
+}
56 68
 	
57 69
 rlookup($mysqli,username(),$admins,$_POST['Value'],$_POST['genere'],$tables);
58 70
 $mysqli->close();
Please login to merge, or discard this patch.
list.php 3 patches
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -13,7 +13,7 @@
 block discarded – undo
13 13
 $err = NULL;
14 14
 
15 15
 if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
16
-                exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
16
+				exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
17 17
 
18 18
 if (addtolist ($mysqli,$user,$_POST['value'],$tables["$typedesc"],$_POST['unit'],$_POST['quantity'],$_POST['reason'],$err))
19 19
  print 'OK '.$_POST["type"].' &lt;'.$_POST['value'].'&gt; first time listed for '.$_POST['quantity'].$_POST['unit'].'.';
Please login to merge, or discard this patch.
Spacing   +7 added lines, -7 removed lines patch added patch discarded remove patch
@@ -1,25 +1,25 @@
 block discarded – undo
1 1
 <?php
2 2
 require_once('config.php');
3 3
 require_once('function.php');
4
-$typedesc=$_POST['type'];
4
+$typedesc = $_POST['type'];
5 5
 $type = $tables["$typedesc"]['field'];
6 6
 $table = ($tables["$typedesc"]['milter']) ? milterTable($type) : $tables["$typedesc"]['name'];
7 7
 
8 8
 openlog($tag, LOG_PID, $fac);
9 9
 if (empty($_POST['reason'])) die ("<p>Please, specify a reason!</p>");
10
-if (preg_match( '/[^\x20-\x7f]/', $_POST['reason']))
11
-	exit('<p>ERROR: &lt;'.htmlentities($_POST['reason'],ENT_COMPAT | ENT_HTML401, 'ISO-8859-1').'&gt; contains NON ASCII chars.</p>');
10
+if (preg_match('/[^\x20-\x7f]/', $_POST['reason']))
11
+	exit('<p>ERROR: &lt;'.htmlentities($_POST['reason'], ENT_COMPAT | ENT_HTML401, 'ISO-8859-1').'&gt; contains NON ASCII chars.</p>');
12 12
 $user = username();
13 13
 $err = NULL;
14 14
 
15
-if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
16
-                exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
15
+if (($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE)
16
+                exit ($user.': Connect Error ('.$mysqli->connect_errno.') '.$mysqli->connect_error);
17 17
 
18
-if (addtolist ($mysqli,$user,$_POST['value'],$tables["$typedesc"],$_POST['unit'],$_POST['quantity'],$_POST['reason'],$err))
18
+if (addtolist($mysqli, $user, $_POST['value'], $tables["$typedesc"], $_POST['unit'], $_POST['quantity'], $_POST['reason'], $err))
19 19
  print 'OK '.$_POST["type"].' &lt;'.$_POST['value'].'&gt; first time listed for '.$_POST['quantity'].$_POST['unit'].'.';
20 20
 else
21 21
  print 'List operation ERROR; check log.';
22
-if (!is_null($err) ) print htmlentities(' Error: ' . $err);
22
+if (!is_null($err)) print htmlentities(' Error: '.$err);
23 23
 $mysqli->close();
24 24
 closelog();
25 25
 ?>
Please login to merge, or discard this patch.
Braces   +13 added lines, -6 removed lines patch added patch discarded remove patch
@@ -6,20 +6,27 @@
 block discarded – undo
6 6
 $table = ($tables["$typedesc"]['milter']) ? milterTable($type) : $tables["$typedesc"]['name'];
7 7
 
8 8
 openlog($tag, LOG_PID, $fac);
9
-if (empty($_POST['reason'])) die ("<p>Please, specify a reason!</p>");
10
-if (preg_match( '/[^\x20-\x7f]/', $_POST['reason']))
9
+if (empty($_POST['reason'])) {
10
+	die ("<p>Please, specify a reason!</p>");
11
+}
12
+if (preg_match( '/[^\x20-\x7f]/', $_POST['reason'])) {
11 13
 	exit('<p>ERROR: &lt;'.htmlentities($_POST['reason'],ENT_COMPAT | ENT_HTML401, 'ISO-8859-1').'&gt; contains NON ASCII chars.</p>');
14
+}
12 15
 $user = username();
13 16
 $err = NULL;
14 17
 
15
-if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
18
+if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE ) {
16 19
                 exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
20
+}
17 21
 
18
-if (addtolist ($mysqli,$user,$_POST['value'],$tables["$typedesc"],$_POST['unit'],$_POST['quantity'],$_POST['reason'],$err))
22
+if (addtolist ($mysqli,$user,$_POST['value'],$tables["$typedesc"],$_POST['unit'],$_POST['quantity'],$_POST['reason'],$err)) {
19 23
  print 'OK '.$_POST["type"].' &lt;'.$_POST['value'].'&gt; first time listed for '.$_POST['quantity'].$_POST['unit'].'.';
20
-else
24
+} else {
21 25
  print 'List operation ERROR; check log.';
22
-if (!is_null($err) ) print htmlentities(' Error: ' . $err);
26
+}
27
+if (!is_null($err) ) {
28
+	print htmlentities(' Error: ' . $err);
29
+}
23 30
 $mysqli->close();
24 31
 closelog();
25 32
 ?>
Please login to merge, or discard this patch.
remove.php 3 patches
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -10,7 +10,7 @@
 block discarded – undo
10 10
 $user = username();
11 11
 
12 12
 if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
13
-                exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
13
+				exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
14 14
 if (remove ($mysqli,$user,$_POST['value'],$type,$table))
15 15
  print 'OK '.$typedesc.' &lt;'.$_POST['value'].'&gt; permanently REMOVED!';
16 16
 else
Please login to merge, or discard this patch.
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -1,17 +1,17 @@
 block discarded – undo
1 1
 <?php
2 2
 require_once('config.php');
3 3
 require_once('function.php');
4
-$typedesc=$_POST['type'];
5
-$type =  $tables["$typedesc"]['field'];
4
+$typedesc = $_POST['type'];
5
+$type = $tables["$typedesc"]['field'];
6 6
 $table = ($tables["$typedesc"]['milter']) ? milterTable($type) : $tables["$typedesc"]['name'];
7 7
 $cl = ($tables["$typedesc"]['milter']) ? 10 : 9;
8 8
 printf('<td colspan="%d" style="text-align: center">', $cl);
9 9
 openlog($tag, LOG_PID, $fac);
10 10
 $user = username();
11 11
 
12
-if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
13
-                exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
14
-if (remove ($mysqli,$user,$_POST['value'],$type,$table))
12
+if (($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE)
13
+                exit ($user.': Connect Error ('.$mysqli->connect_errno.') '.$mysqli->connect_error);
14
+if (remove($mysqli, $user, $_POST['value'], $type, $table))
15 15
  print 'OK '.$typedesc.' &lt;'.$_POST['value'].'&gt; permanently REMOVED!';
16 16
 else
17 17
  print 'Delete operation ERROR on '.$typedesc.' &lt;'.$_POST['value'].'&gt;; check log.';
Please login to merge, or discard this patch.
Braces   +5 added lines, -3 removed lines patch added patch discarded remove patch
@@ -9,12 +9,14 @@
 block discarded – undo
9 9
 openlog($tag, LOG_PID, $fac);
10 10
 $user = username();
11 11
 
12
-if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
12
+if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE ) {
13 13
                 exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
14
-if (remove ($mysqli,$user,$_POST['value'],$type,$table))
14
+}
15
+if (remove ($mysqli,$user,$_POST['value'],$type,$table)) {
15 16
  print 'OK '.$typedesc.' &lt;'.$_POST['value'].'&gt; permanently REMOVED!';
16
-else
17
+} else {
17 18
  print 'Delete operation ERROR on '.$typedesc.' &lt;'.$_POST['value'].'&gt;; check log.';
19
+}
18 20
 print '</td>';
19 21
 $mysqli->close();
20 22
 closelog();
Please login to merge, or discard this patch.
relistForm.php 2 patches
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -1,10 +1,10 @@
 block discarded – undo
1 1
 <?php
2 2
 $adm = unserialize($_POST["adm"]);
3
-if (in_array($_POST["user"],array_keys(array_filter($adm)))) $extopt = '<option value="MONTH">MONTHS</option><option value="YEAR">YEARS</option>';
3
+if (in_array($_POST["user"], array_keys(array_filter($adm)))) $extopt = '<option value="MONTH">MONTHS</option><option value="YEAR">YEARS</option>';
4 4
 else $extopt = NULL;
5 5
 
6 6
 require_once('config.php');
7
-$typedesc=$_POST['type'];
7
+$typedesc = $_POST['type'];
8 8
 $cl = ($tables["$typedesc"]['milter']) ? 10 : 9;
9 9
 ?>
10 10
 
Please login to merge, or discard this patch.
Braces   +5 added lines, -2 removed lines patch added patch discarded remove patch
@@ -1,7 +1,10 @@
 block discarded – undo
1 1
 <?php
2 2
 $adm = unserialize($_POST["adm"]);
3
-if (in_array($_POST["user"],array_keys(array_filter($adm)))) $extopt = '<option value="MONTH">MONTHS</option><option value="YEAR">YEARS</option>';
4
-else $extopt = NULL;
3
+if (in_array($_POST["user"],array_keys(array_filter($adm)))) {
4
+	$extopt = '<option value="MONTH">MONTHS</option><option value="YEAR">YEARS</option>';
5
+} else {
6
+	$extopt = NULL;
7
+}
5 8
 
6 9
 require_once('config.php');
7 10
 $typedesc=$_POST['type'];
Please login to merge, or discard this patch.
delist.php 3 patches
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -12,7 +12,7 @@
 block discarded – undo
12 12
 $user = username();
13 13
 
14 14
 if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
15
-                exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
15
+				exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
16 16
 
17 17
 if (changestatus($mysqli,username(),$_POST['value'],'0',$type,$table))
18 18
  print 'OK '.$_POST["type"].' &lt;'.$_POST['value'].'&gt; delisted.';
Please login to merge, or discard this patch.
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -1,7 +1,7 @@  discard block
 block discarded – undo
1 1
 <?php
2 2
 require_once('config.php');
3 3
 require_once('function.php');
4
-$typedesc=$_POST['type'];
4
+$typedesc = $_POST['type'];
5 5
 $type = $tables["$typedesc"]['field'];
6 6
 $table = ($tables["$typedesc"]['milter']) ? milterTable($type) : $tables["$typedesc"]['name'];
7 7
 $cl = ($tables["$typedesc"]['milter']) ? 10 : 9;
@@ -11,10 +11,10 @@  discard block
 block discarded – undo
11 11
 openlog($tag, LOG_PID, $fac);
12 12
 $user = username();
13 13
 
14
-if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
15
-                exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
14
+if (($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE)
15
+                exit ($user.': Connect Error ('.$mysqli->connect_errno.') '.$mysqli->connect_error);
16 16
 
17
-if (changestatus($mysqli,username(),$_POST['value'],'0',$type,$table))
17
+if (changestatus($mysqli, username(), $_POST['value'], '0', $type, $table))
18 18
  print 'OK '.$_POST["type"].' &lt;'.$_POST['value'].'&gt; delisted.';
19 19
 else
20 20
  print 'ERROR in delist &lt;'.$_POST['value'].'&gt;; check log';
Please login to merge, or discard this patch.
Braces   +5 added lines, -3 removed lines patch added patch discarded remove patch
@@ -11,13 +11,15 @@
 block discarded – undo
11 11
 openlog($tag, LOG_PID, $fac);
12 12
 $user = username();
13 13
 
14
-if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE )
14
+if ( ($mysqli = myConnect($dbhost, $userdb, $pwd, $db, $dbport, $tables, $typedesc, $user)) === FALSE ) {
15 15
                 exit ($user.': Connect Error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
16
+}
16 17
 
17
-if (changestatus($mysqli,username(),$_POST['value'],'0',$type,$table))
18
+if (changestatus($mysqli,username(),$_POST['value'],'0',$type,$table)) {
18 19
  print 'OK '.$_POST["type"].' &lt;'.$_POST['value'].'&gt; delisted.';
19
-else
20
+} else {
20 21
  print 'ERROR in delist &lt;'.$_POST['value'].'&gt;; check log';
22
+}
21 23
 print '</td>';
22 24
 $mysqli->close();
23 25
 closelog();
Please login to merge, or discard this patch.