Passed
Push — master ( df2595...b8f383 )
by Patrick
01:54
created
library/Trapdirector/TrapsController.php 3 patches
Indentation   +115 added lines, -115 removed lines patch added patch discarded remove patch
@@ -32,8 +32,8 @@  discard block
 block discarded – undo
32 32
 	protected $trapClass;		//< Trap class for bin/trap_class.php
33 33
 		
34 34
 	/** Get instance of TrapModuleConfig class
35
-	*	@return TrapModuleConfig
36
-	*/
35
+	 *	@return TrapModuleConfig
36
+	 */
37 37
 	public function getModuleConfig() 
38 38
 	{
39 39
 		if ($this->moduleConfig == Null) 
@@ -58,12 +58,12 @@  discard block
 block discarded – undo
58 58
 	
59 59
 	public function getTrapHostListTable()
60 60
 	{
61
-	    if ($this->trapTableHostList == Null) 
61
+		if ($this->trapTableHostList == Null) 
62 62
 		{
63
-	        $this->trapTableHostList = new TrapTableHostList();
64
-	        $this->trapTableHostList->setConfig($this->getModuleConfig());
65
-	    }
66
-	    return $this->trapTableHostList;
63
+			$this->trapTableHostList = new TrapTableHostList();
64
+			$this->trapTableHostList->setConfig($this->getModuleConfig());
65
+		}
66
+		return $this->trapTableHostList;
67 67
 	}
68 68
 	
69 69
 	public function getHandlerListTable() 
@@ -77,11 +77,11 @@  discard block
 block discarded – undo
77 77
 	}	
78 78
 	
79 79
 	/**	Get Database connexion
80
-	*	@param $DBname string DB name in resource.ini_ge
81
-	*	@param $test bool if set to true, returns error code and not database
82
-	*	@param $test_version bool if set to flase, does not test database version of trapDB
83
-	*	@return array<integer,mixed>|mixed : if test=false, returns DB connexion, else array(error_num,message) or null on error.
84
-	*/
80
+	 *	@param $DBname string DB name in resource.ini_ge
81
+	 *	@param $test bool if set to true, returns error code and not database
82
+	 *	@param $test_version bool if set to flase, does not test database version of trapDB
83
+	 *	@return array<integer,mixed>|mixed : if test=false, returns DB connexion, else array(error_num,message) or null on error.
84
+	 */
85 85
 	public function getDbByName($DBname,$test=false,$test_version=true)
86 86
 	{
87 87
 		try 
@@ -166,20 +166,20 @@  discard block
 block discarded – undo
166 166
 
167 167
 		if ( ! $dbresource )
168 168
 		{
169
-		    if ($test) return array(1,'No database in config.ini');
170
-		    $this->redirectNow('trapdirector/settings?idodberror=1');
171
-		    return null;
169
+			if ($test) return array(1,'No database in config.ini');
170
+			$this->redirectNow('trapdirector/settings?idodberror=1');
171
+			return null;
172 172
 		}
173 173
 		
174 174
 		try
175 175
 		{
176
-		    $dbconn = IcingaDbConnection::fromResourceName($dbresource);
176
+			$dbconn = IcingaDbConnection::fromResourceName($dbresource);
177 177
 		}
178 178
 		catch (Exception $e)
179 179
 		{
180
-		    if ($test) return array(2,"Database $dbresource does not exists in IcingaWeb2");
181
-		    $this->redirectNow('trapdirector/settings?idodberror=2');
182
-		    return null;
180
+			if ($test) return array(2,"Database $dbresource does not exists in IcingaWeb2");
181
+			$this->redirectNow('trapdirector/settings?idodberror=2');
182
+			return null;
183 183
 		}
184 184
 		
185 185
 		if ($test == false) 
@@ -190,13 +190,13 @@  discard block
 block discarded – undo
190 190
 		
191 191
 		try
192 192
 		{
193
-		    $query = $dbconn->select()
194
-		    ->from('icinga_dbversion',array('version'));
195
-		    $version=$dbconn->fetchRow($query);
196
-		    if ( ($version == null) || ! property_exists($version,'version') )
197
-		    {
198
-		        return array(4,"$dbresource does not look like an IDO database");
199
-		    }
193
+			$query = $dbconn->select()
194
+			->from('icinga_dbversion',array('version'));
195
+			$version=$dbconn->fetchRow($query);
196
+			if ( ($version == null) || ! property_exists($version,'version') )
197
+			{
198
+				return array(4,"$dbresource does not look like an IDO database");
199
+			}
200 200
 		}
201 201
 		catch (Exception $e)
202 202
 		{
@@ -206,15 +206,15 @@  discard block
 block discarded – undo
206 206
 		return array(0,'');
207 207
 	}
208 208
 	
209
-    protected function applyPaginationLimits(Paginatable $paginatable, $limit = 25, $offset = null)
210
-    {
211
-        $limit = $this->params->get('limit', $limit);
212
-        $page = $this->params->get('page', $offset);
209
+	protected function applyPaginationLimits(Paginatable $paginatable, $limit = 25, $offset = null)
210
+	{
211
+		$limit = $this->params->get('limit', $limit);
212
+		$page = $this->params->get('page', $offset);
213 213
 
214
-        $paginatable->limit($limit, $page > 0 ? ($page - 1) * $limit : 0);
214
+		$paginatable->limit($limit, $page > 0 ? ($page - 1) * $limit : 0);
215 215
 
216
-        return $paginatable;
217
-    }	
216
+		return $paginatable;
217
+	}	
218 218
 	
219 219
 	public function displayExitError($source,$message)
220 220
 	{	// TODO : check better ways to transmit data (with POST ?)
@@ -223,33 +223,33 @@  discard block
 block discarded – undo
223 223
 	
224 224
 	protected function checkReadPermission()
225 225
 	{
226
-        if (! $this->Auth()->hasPermission('trapdirector/view')) {
227
-            $this->displayExitError('Permissions','No permission fo view content');
228
-        }		
226
+		if (! $this->Auth()->hasPermission('trapdirector/view')) {
227
+			$this->displayExitError('Permissions','No permission fo view content');
228
+		}		
229 229
 	}
230 230
 
231 231
 	protected function checkConfigPermission()
232 232
 	{
233
-        if (! $this->Auth()->hasPermission('trapdirector/config')) {
234
-            $this->displayExitError('Permissions','No permission fo configure');
235
-        }		
233
+		if (! $this->Auth()->hasPermission('trapdirector/config')) {
234
+			$this->displayExitError('Permissions','No permission fo configure');
235
+		}		
236 236
 	}
237 237
 	
238
-    /**
239
-     * Check if user has write permission
240
-     * @param number $check optional : if set to 1, return true (user has permission) or false instead of displaying error page
241
-     * @return boolean : user has permission
242
-     */
238
+	/**
239
+	 * Check if user has write permission
240
+	 * @param number $check optional : if set to 1, return true (user has permission) or false instead of displaying error page
241
+	 * @return boolean : user has permission
242
+	 */
243 243
 	protected function checkModuleConfigPermission($check=0)
244 244
 	{
245
-        if (! $this->Auth()->hasPermission('trapdirector/module_config')) {
246
-            if ($check == 0)
247
-            {
248
-                $this->displayExitError('Permissions','No permission fo configure module');
249
-            }
250
-            return false;
251
-        }
252
-        return true;
245
+		if (! $this->Auth()->hasPermission('trapdirector/module_config')) {
246
+			if ($check == 0)
247
+			{
248
+				$this->displayExitError('Permissions','No permission fo configure module');
249
+			}
250
+			return false;
251
+		}
252
+		return true;
253 253
 	}
254 254
 
255 255
 	/*************************  Trap class get **********************/
@@ -269,8 +269,8 @@  discard block
 block discarded – undo
269 269
 	/************************** MIB related **************************/
270 270
 	
271 271
 	/** Get MIBLoader class
272
-	*	@return MIBLoader class
273
-	*/
272
+	 *	@return MIBLoader class
273
+	 */
274 274
 	protected function getMIB()
275 275
 	{
276 276
 		if ($this->MIBData == null)
@@ -288,9 +288,9 @@  discard block
 block discarded – undo
288 288
 	/**************************  Database queries *******************/
289 289
 	
290 290
 	/** Get host(s) by IP (v4 or v6) or by name in IDO database
291
-	*	does not catch exceptions
292
-	*	@return array of objects ( name, id (object_id), display_name)
293
-	*/
291
+	 *	does not catch exceptions
292
+	 *	@return array of objects ( name, id (object_id), display_name)
293
+	 */
294 294
 	protected function getHostByIP($ip) 
295 295
 	{
296 296
 		// select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id
@@ -309,9 +309,9 @@  discard block
 block discarded – undo
309 309
 	}
310 310
 
311 311
 	/** Get host(s) by name in IDO database
312
-	*	does not catch exceptions
313
-	*	@return array of objects ( name, id (object_id), display_name)
314
-	*/
312
+	 *	does not catch exceptions
313
+	 *	@return array of objects ( name, id (object_id), display_name)
314
+	 */
315 315
 	protected function getHostByName($name) 
316 316
 	{
317 317
 		// select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id
@@ -330,9 +330,9 @@  discard block
 block discarded – undo
330 330
 	}	
331 331
 	
332 332
 	/** Get host groups by  name in IDO database
333
-	*	does not catch exceptions
334
-	*	@return array of objects ( name, id (object_id), display_name)
335
-	*/
333
+	 *	does not catch exceptions
334
+	 *	@return array of objects ( name, id (object_id), display_name)
335
+	 */
336 336
 	protected function getHostGroupByName($ip) 
337 337
 	{
338 338
 		// select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id
@@ -352,9 +352,9 @@  discard block
 block discarded – undo
352 352
 
353 353
 	
354 354
 	/** Get host IP (v4 and v6) by name in IDO database
355
-	*	does not catch exceptions
356
-	*	@return array ( name, display_name, ip4, ip6)
357
-	*/
355
+	 *	does not catch exceptions
356
+	 *	@return array ( name, display_name, ip4, ip6)
357
+	 */
358 358
 	protected function getHostInfoByID($id) 
359 359
 	{
360 360
 		if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id');  }
@@ -373,9 +373,9 @@  discard block
 block discarded – undo
373 373
 
374 374
 	
375 375
 	/** Get host by objectid  in IDO database
376
-	*	does not catch exceptions
377
-	*	@return array of objects ( id, name, display_name, ip, ip6,  )
378
-	*/
376
+	 *	does not catch exceptions
377
+	 *	@return array of objects ( id, name, display_name, ip, ip6,  )
378
+	 */
379 379
 	protected function getHostByObjectID($id) // TODO : duplicate of getHostInfoByID above
380 380
 	{
381 381
 		if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id');  }
@@ -393,10 +393,10 @@  discard block
 block discarded – undo
393 393
 	}	
394 394
 	
395 395
 	/** Get services from object ( host_object_id) in IDO database
396
-	*	does not catch exceptions
397
-	*	@param $id	int object_id
398
-	*	@return array display_name (of service), service_object_id
399
-	*/
396
+	 *	does not catch exceptions
397
+	 *	@param $id	int object_id
398
+	 *	@return array display_name (of service), service_object_id
399
+	 */
400 400
 	protected function getServicesByHostid($id) 
401 401
 	{
402 402
 		// select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id
@@ -416,11 +416,11 @@  discard block
 block discarded – undo
416 416
 	}	
417 417
 	
418 418
 	/** Get services from hostgroup object id ( hostgroup_object_id) in IDO database
419
-	* 	gets all hosts in hostgroup and return common services
420
-	*	does not catch exceptions
421
-	*	@param $id	int object_id
422
-	*	@return array display_name (of service), service_object_id
423
-	*/
419
+	 * 	gets all hosts in hostgroup and return common services
420
+	 *	does not catch exceptions
421
+	 *	@param $id	int object_id
422
+	 *	@return array display_name (of service), service_object_id
423
+	 */
424 424
 	protected function getServicesByHostGroupid($id) 
425 425
 	{		
426 426
 		if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id');  }
@@ -459,7 +459,7 @@  discard block
 block discarded – undo
459 459
 		//print_r($common_services);
460 460
 		foreach (array_keys($common_services) as $key)
461 461
 		{
462
-		    if ($common_services[$key]['num'] == $num_hosts)
462
+			if ($common_services[$key]['num'] == $num_hosts)
463 463
 			{
464 464
 				array_push($result,array($key,$common_services[$key]['name']));
465 465
 			}
@@ -469,11 +469,11 @@  discard block
 block discarded – undo
469 469
 	}	
470 470
 
471 471
 	/** Get services object id by host name / service name in IDO database
472
-	*	does not catch exceptions
473
-	*	@param $hostname string host name
474
-	*	@param $name string service name
475
-	*	@return array  service id
476
-	*/
472
+	 *	does not catch exceptions
473
+	 *	@param $hostname string host name
474
+	 *	@param $name string service name
475
+	 *	@return array  service id
476
+	 */
477 477
 	protected function getServiceIDByName($hostname,$name) 
478 478
 	{
479 479
 		$db = $this->getIdoDb()->getConnection();
@@ -496,10 +496,10 @@  discard block
 block discarded – undo
496 496
 	}
497 497
 	
498 498
 	/** Get object name from object_id  in IDO database
499
-	*	does not catch exceptions
500
-	*	@param int $id object_id (default to null, used first if not null)
501
-	*	@return array name1 (host) name2 (service)
502
-	*/
499
+	 *	does not catch exceptions
500
+	 *	@param int $id object_id (default to null, used first if not null)
501
+	 *	@return array name1 (host) name2 (service)
502
+	 */
503 503
 	protected function getObjectNameByid($id) 
504 504
 	{
505 505
 		// select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id
@@ -515,9 +515,9 @@  discard block
 block discarded – undo
515 515
 	}		
516 516
 
517 517
 	/** Add handler rule in traps DB
518
-	*	@param array $params : array(<db item>=><value>)
519
-	*	@return int inserted id
520
-	*/
518
+	 *	@param array $params : array(<db item>=><value>)
519
+	 *	@return int inserted id
520
+	 */
521 521
 	protected function addHandlerRule($params)
522 522
 	{
523 523
 		// TODO Check for rule consistency
@@ -539,9 +539,9 @@  discard block
 block discarded – undo
539 539
 	}	
540 540
 
541 541
 	/** Update handler rule in traps DB
542
-	*	@param array(<db item>=><value>)
543
-	*	@return array affected rows
544
-	*/
542
+	 *	@param array(<db item>=><value>)
543
+	 *	@return array affected rows
544
+	 */
545 545
 	protected function updateHandlerRule($params,$ruleID)
546 546
 	{
547 547
 		// TODO Check for rule consistency
@@ -559,8 +559,8 @@  discard block
 block discarded – undo
559 559
 	}	
560 560
 	
561 561
 	/** Delete rule by id
562
-	*	@param int $ruleID rule id
563
-	*/
562
+	 *	@param int $ruleID rule id
563
+	 */
564 564
 	protected function deleteRule($ruleID)
565 565
 	{
566 566
 		if (!preg_match('/^[0-9]+$/',$ruleID)) { throw new Exception('Invalid id');  }
@@ -574,9 +574,9 @@  discard block
 block discarded – undo
574 574
 	}
575 575
 
576 576
 	/** Delete trap by ip & oid
577
-	*	@param $ip string source IP (v4 or v6)
578
-	*	@param $oid string oid
579
-	*/
577
+	 *	@param $ip string source IP (v4 or v6)
578
+	 *	@param $oid string oid
579
+	 */
580 580
 	protected function deleteTrap($ip,$oid)
581 581
 	{
582 582
 		
@@ -602,9 +602,9 @@  discard block
 block discarded – undo
602 602
    
603 603
 
604 604
 	/** count trap by ip & oid
605
-	*	@param $ip string source IP (v4 or v6)
606
-	*	@param $oid string oid
607
-	*/
605
+	 *	@param $ip string source IP (v4 or v6)
606
+	 *	@param $oid string oid
607
+	 */
608 608
 	protected function countTrap($ip,$oid)
609 609
 	{
610 610
 		
@@ -630,8 +630,8 @@  discard block
 block discarded – undo
630 630
 	}		
631 631
 	
632 632
 	/** get configuration value
633
-	*	@param string $element : configuration name in db
634
-	*/
633
+	 *	@param string $element : configuration name in db
634
+	 */
635 635
 	protected function getDBConfigValue($element)
636 636
 	{
637 637
 	
@@ -662,9 +662,9 @@  discard block
 block discarded – undo
662 662
 	}
663 663
 
664 664
 	/** add configuration value
665
-	*	@param string $element : name of config element
666
-	*   @param string $value : value
667
-	*/
665
+	 *	@param string $element : name of config element
666
+	 *   @param string $value : value
667
+	 */
668 668
 		
669 669
 	protected function addDBConfigValue($element,$value)
670 670
 	{
@@ -682,9 +682,9 @@  discard block
 block discarded – undo
682 682
 	}
683 683
 
684 684
 	/** set configuration value
685
-	*	@param string $element : name of config element
686
-	*   @param string $value : value
687
-	*/
685
+	 *	@param string $element : name of config element
686
+	 *   @param string $value : value
687
+	 */
688 688
 	protected function setDBConfigValue($element,$value)
689 689
 	{
690 690
 	
@@ -698,13 +698,13 @@  discard block
 block discarded – undo
698 698
 	}
699 699
 	
700 700
 	/** Check if director is installed
701
-	*	@return bool true/false
702
-	*/
701
+	 *	@return bool true/false
702
+	 */
703 703
 	protected function isDirectorInstalled()
704 704
 	{
705
-	    $output=array();
706
-	    exec('icingacli module list',$output);
707
-	    foreach ($output as $line)
705
+		$output=array();
706
+		exec('icingacli module list',$output);
707
+		foreach ($output as $line)
708 708
 		{
709 709
 			if (preg_match('/^director .*enabled/',$line))
710 710
 			{
Please login to merge, or discard this patch.
Spacing   +112 added lines, -112 removed lines patch added patch discarded remove patch
@@ -22,14 +22,14 @@  discard block
 block discarded – undo
22 22
 
23 23
 class TrapsController extends Controller
24 24
 {
25
-	protected $moduleConfig;  	//< TrapModuleConfig instance
26
-	protected $trapTableList; 	//< TrapTableList (by date)
27
-	protected $trapTableHostList; 	//< TrapTableList (by hosts)
28
-	protected $handlerTableList; 	//< HandlerTableList instance
29
-	protected $trapDB;			//< Trap database
30
-	protected $icingaDB;		//< Icinga IDO database;
31
-	protected $MIBData; 		//< MIBLoader class
32
-	protected $trapClass;		//< Trap class for bin/trap_class.php
25
+	protected $moduleConfig; //< TrapModuleConfig instance
26
+	protected $trapTableList; //< TrapTableList (by date)
27
+	protected $trapTableHostList; //< TrapTableList (by hosts)
28
+	protected $handlerTableList; //< HandlerTableList instance
29
+	protected $trapDB; //< Trap database
30
+	protected $icingaDB; //< Icinga IDO database;
31
+	protected $MIBData; //< MIBLoader class
32
+	protected $trapClass; //< Trap class for bin/trap_class.php
33 33
 		
34 34
 	/** Get instance of TrapModuleConfig class
35 35
 	*	@return TrapModuleConfig
@@ -43,14 +43,14 @@  discard block
 block discarded – undo
43 43
 			{
44 44
 				$this->redirectNow('trapdirector/settings?message=No database prefix');
45 45
 			}
46
-			$this->moduleConfig = new TrapModuleConfig($db_prefix);
46
+			$this->moduleConfig=new TrapModuleConfig($db_prefix);
47 47
 		}
48 48
 		return $this->moduleConfig;
49 49
 	}
50 50
 	
51 51
 	public function getTrapListTable() {
52 52
 		if ($this->trapTableList == Null) {
53
-			$this->trapTableList = new TrapTableList();
53
+			$this->trapTableList=new TrapTableList();
54 54
 			$this->trapTableList->setConfig($this->getModuleConfig());
55 55
 		}
56 56
 		return $this->trapTableList;
@@ -60,7 +60,7 @@  discard block
 block discarded – undo
60 60
 	{
61 61
 	    if ($this->trapTableHostList == Null) 
62 62
 		{
63
-	        $this->trapTableHostList = new TrapTableHostList();
63
+	        $this->trapTableHostList=new TrapTableHostList();
64 64
 	        $this->trapTableHostList->setConfig($this->getModuleConfig());
65 65
 	    }
66 66
 	    return $this->trapTableHostList;
@@ -70,7 +70,7 @@  discard block
 block discarded – undo
70 70
 	{
71 71
 		if ($this->handlerTableList == Null) 
72 72
 		{
73
-			$this->handlerTableList = new HandlerTableList();
73
+			$this->handlerTableList=new HandlerTableList();
74 74
 			$this->handlerTableList->setConfig($this->getModuleConfig());
75 75
 		}
76 76
 		return $this->handlerTableList;
@@ -82,15 +82,15 @@  discard block
 block discarded – undo
82 82
 	*	@param $test_version bool if set to flase, does not test database version of trapDB
83 83
 	*	@return array<integer,mixed>|mixed : if test=false, returns DB connexion, else array(error_num,message) or null on error.
84 84
 	*/
85
-	public function getDbByName($DBname,$test=false,$test_version=true)
85
+	public function getDbByName($DBname, $test=false, $test_version=true)
86 86
 	{
87 87
 		try 
88 88
 		{
89
-			$dbconn = IcingaDbConnection::fromResourceName($DBname);
89
+			$dbconn=IcingaDbConnection::fromResourceName($DBname);
90 90
 		} 
91 91
 		catch (Exception $e)
92 92
 		{
93
-			if ($test) return array(2,$DBname);
93
+			if ($test) return array(2, $DBname);
94 94
 			$this->redirectNow('trapdirector/settings?dberror=2');
95 95
 			return null;
96 96
 		}
@@ -101,37 +101,37 @@  discard block
 block discarded – undo
101 101
 			}
102 102
 			catch (Exception $e) 
103 103
 			{
104
-				if ($test) return array(3,$DBname,$e->getMessage());
104
+				if ($test) return array(3, $DBname, $e->getMessage());
105 105
 				$this->redirectNow('trapdirector/settings?dberror=3');
106 106
 				return null;
107 107
 			}
108 108
 			try
109 109
 			{
110
-				$query = $db->select()
111
-					->from($this->getModuleConfig()->getDbConfigTableName(),'value')
110
+				$query=$db->select()
111
+					->from($this->getModuleConfig()->getDbConfigTableName(), 'value')
112 112
 					->where('name=\'db_version\'');
113 113
 				$version=$db->fetchRow($query);
114
-				if ( ($version == null) || ! property_exists($version,'value') )
114
+				if (($version == null) || !property_exists($version, 'value'))
115 115
 				{
116
-					if ($test) return array(4,$DBname);
116
+					if ($test) return array(4, $DBname);
117 117
 					$this->redirectNow('trapdirector/settings?dberror=4');
118 118
 					return null;
119 119
 				}
120 120
 				if ($version->value < $this->getModuleConfig()->getDbMinVersion()) 
121 121
 				{
122
-					if ($test) return array(5,$version->value,$this->getModuleConfig()->getDbMinVersion());
122
+					if ($test) return array(5, $version->value, $this->getModuleConfig()->getDbMinVersion());
123 123
 					$this->redirectNow('trapdirector/settings?dberror=5');
124 124
 					return null;
125 125
 				}
126 126
 			}
127 127
 			catch (Exception $e) 
128 128
 			{
129
-				if ($test) return array(3,$DBname,$e->getMessage());
129
+				if ($test) return array(3, $DBname, $e->getMessage());
130 130
 				$this->redirectNow('trapdirector/settings?dberror=4');
131 131
 				return null;
132 132
 			}
133 133
 		}
134
-		if ($test) return array(0,'');
134
+		if ($test) return array(0, '');
135 135
 		return $dbconn;
136 136
 	}
137 137
 
@@ -142,17 +142,17 @@  discard block
 block discarded – undo
142 142
 	 */
143 143
 	public function getDb($test=false)
144 144
 	{
145
-		if ($this->trapDB != null && $test = false) return $this->trapDB;
145
+		if ($this->trapDB != null && $test=false) return $this->trapDB;
146 146
 		
147 147
 		$dbresource=$this->Config()->get('config', 'database');
148 148
 		
149
-		if ( ! $dbresource )
149
+		if (!$dbresource)
150 150
 		{	
151
-			if ($test) return array(1,'');
151
+			if ($test) return array(1, '');
152 152
 			$this->redirectNow('trapdirector/settings?dberror=1');
153 153
 			return null;
154 154
 		}
155
-		$retDB=$this->getDbByName($dbresource,$test,true);
155
+		$retDB=$this->getDbByName($dbresource, $test, true);
156 156
 		if ($test == true) return $retDB;
157 157
 		$this->trapDB=$retDB;
158 158
 		return $this->trapDB;
@@ -160,78 +160,78 @@  discard block
 block discarded – undo
160 160
 	
161 161
 	public function getIdoDb($test=false)
162 162
 	{
163
-		if ($this->icingaDB != null && $test = false) return $this->icingaDB;
163
+		if ($this->icingaDB != null && $test=false) return $this->icingaDB;
164 164
 		// TODO : get ido database directly from icingaweb2 config -> (or not if using only API)
165
-		$dbresource=$this->Config()->get('config', 'IDOdatabase');;
165
+		$dbresource=$this->Config()->get('config', 'IDOdatabase'); ;
166 166
 
167
-		if ( ! $dbresource )
167
+		if (!$dbresource)
168 168
 		{
169
-		    if ($test) return array(1,'No database in config.ini');
169
+		    if ($test) return array(1, 'No database in config.ini');
170 170
 		    $this->redirectNow('trapdirector/settings?idodberror=1');
171 171
 		    return null;
172 172
 		}
173 173
 		
174 174
 		try
175 175
 		{
176
-		    $dbconn = IcingaDbConnection::fromResourceName($dbresource);
176
+		    $dbconn=IcingaDbConnection::fromResourceName($dbresource);
177 177
 		}
178 178
 		catch (Exception $e)
179 179
 		{
180
-		    if ($test) return array(2,"Database $dbresource does not exists in IcingaWeb2");
180
+		    if ($test) return array(2, "Database $dbresource does not exists in IcingaWeb2");
181 181
 		    $this->redirectNow('trapdirector/settings?idodberror=2');
182 182
 		    return null;
183 183
 		}
184 184
 		
185 185
 		if ($test == false) 
186 186
 		{ 
187
-			$this->icingaDB = $dbconn; 
187
+			$this->icingaDB=$dbconn; 
188 188
 			return $this->icingaDB;
189 189
 		}
190 190
 		
191 191
 		try
192 192
 		{
193
-		    $query = $dbconn->select()
194
-		    ->from('icinga_dbversion',array('version'));
193
+		    $query=$dbconn->select()
194
+		    ->from('icinga_dbversion', array('version'));
195 195
 		    $version=$dbconn->fetchRow($query);
196
-		    if ( ($version == null) || ! property_exists($version,'version') )
196
+		    if (($version == null) || !property_exists($version, 'version'))
197 197
 		    {
198
-		        return array(4,"$dbresource does not look like an IDO database");
198
+		        return array(4, "$dbresource does not look like an IDO database");
199 199
 		    }
200 200
 		}
201 201
 		catch (Exception $e)
202 202
 		{
203
-			return array(3,"Error connecting to $dbresource : " . $e->getMessage());
203
+			return array(3, "Error connecting to $dbresource : ".$e->getMessage());
204 204
 		}
205 205
 		
206
-		return array(0,'');
206
+		return array(0, '');
207 207
 	}
208 208
 	
209
-    protected function applyPaginationLimits(Paginatable $paginatable, $limit = 25, $offset = null)
209
+    protected function applyPaginationLimits(Paginatable $paginatable, $limit=25, $offset=null)
210 210
     {
211
-        $limit = $this->params->get('limit', $limit);
212
-        $page = $this->params->get('page', $offset);
211
+        $limit=$this->params->get('limit', $limit);
212
+        $page=$this->params->get('page', $offset);
213 213
 
214 214
         $paginatable->limit($limit, $page > 0 ? ($page - 1) * $limit : 0);
215 215
 
216 216
         return $paginatable;
217 217
     }	
218 218
 	
219
-	public function displayExitError($source,$message)
219
+	public function displayExitError($source, $message)
220 220
 	{	// TODO : check better ways to transmit data (with POST ?)
221 221
 		$this->redirectNow('trapdirector/error?source='.$source.'&message='.$message);
222 222
 	}
223 223
 	
224 224
 	protected function checkReadPermission()
225 225
 	{
226
-        if (! $this->Auth()->hasPermission('trapdirector/view')) {
227
-            $this->displayExitError('Permissions','No permission fo view content');
226
+        if (!$this->Auth()->hasPermission('trapdirector/view')) {
227
+            $this->displayExitError('Permissions', 'No permission fo view content');
228 228
         }		
229 229
 	}
230 230
 
231 231
 	protected function checkConfigPermission()
232 232
 	{
233
-        if (! $this->Auth()->hasPermission('trapdirector/config')) {
234
-            $this->displayExitError('Permissions','No permission fo configure');
233
+        if (!$this->Auth()->hasPermission('trapdirector/config')) {
234
+            $this->displayExitError('Permissions', 'No permission fo configure');
235 235
         }		
236 236
 	}
237 237
 	
@@ -242,10 +242,10 @@  discard block
 block discarded – undo
242 242
      */
243 243
 	protected function checkModuleConfigPermission($check=0)
244 244
 	{
245
-        if (! $this->Auth()->hasPermission('trapdirector/module_config')) {
245
+        if (!$this->Auth()->hasPermission('trapdirector/module_config')) {
246 246
             if ($check == 0)
247 247
             {
248
-                $this->displayExitError('Permissions','No permission fo configure module');
248
+                $this->displayExitError('Permissions', 'No permission fo configure module');
249 249
             }
250 250
             return false;
251 251
         }
@@ -257,10 +257,10 @@  discard block
 block discarded – undo
257 257
 	{ // TODO : try/catch here ? or within caller
258 258
 		if ($this->trapClass == null)
259 259
 		{
260
-			require_once($this->Module()->getBaseDir() .'/bin/trap_class.php');
260
+			require_once($this->Module()->getBaseDir().'/bin/trap_class.php');
261 261
 			$icingaweb2_etc=$this->Config()->get('config', 'icingaweb2_etc');
262 262
 			//$debug_level=4;
263
-			$this->trapClass = new Trap($icingaweb2_etc);
263
+			$this->trapClass=new Trap($icingaweb2_etc);
264 264
 			//$Trap->setLogging($debug_level,'syslog');
265 265
 		}
266 266
 		return $this->trapClass;
@@ -294,12 +294,12 @@  discard block
 block discarded – undo
294 294
 	protected function getHostByIP($ip) 
295 295
 	{
296 296
 		// select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id
297
-		$db = $this->getIdoDb()->getConnection();
297
+		$db=$this->getIdoDb()->getConnection();
298 298
 		// TODO : check for SQL injections
299 299
 		$query=$db->select()
300 300
 				->from(
301 301
 					array('a' => 'icinga_objects'),
302
-					array('name' => 'a.name1','id' => 'object_id'))
302
+					array('name' => 'a.name1', 'id' => 'object_id'))
303 303
 				->join(
304 304
 					array('b' => 'icinga_hosts'),
305 305
 					'b.host_object_id=a.object_id',
@@ -315,12 +315,12 @@  discard block
 block discarded – undo
315 315
 	protected function getHostByName($name) 
316 316
 	{
317 317
 		// select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id
318
-		$db = $this->getIdoDb()->getConnection();
318
+		$db=$this->getIdoDb()->getConnection();
319 319
 		// TODO : check for SQL injections
320 320
 		$query=$db->select()
321 321
 				->from(
322 322
 					array('a' => 'icinga_objects'),
323
-					array('name' => 'a.name1','id' => 'object_id'))
323
+					array('name' => 'a.name1', 'id' => 'object_id'))
324 324
 				->join(
325 325
 					array('b' => 'icinga_hosts'),
326 326
 					'b.host_object_id=a.object_id',
@@ -336,12 +336,12 @@  discard block
 block discarded – undo
336 336
 	protected function getHostGroupByName($ip) 
337 337
 	{
338 338
 		// select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id
339
-		$db = $this->getIdoDb()->getConnection();
339
+		$db=$this->getIdoDb()->getConnection();
340 340
 		// TODO : check for SQL injections
341 341
 		$query=$db->select()
342 342
 				->from(
343 343
 					array('a' => 'icinga_objects'),
344
-					array('name' => 'a.name1','id' => 'object_id'))
344
+					array('name' => 'a.name1', 'id' => 'object_id'))
345 345
 				->join(
346 346
 					array('b' => 'icinga_hostgroups'),
347 347
 					'b.hostgroup_object_id=a.object_id',
@@ -357,8 +357,8 @@  discard block
 block discarded – undo
357 357
 	*/
358 358
 	protected function getHostInfoByID($id) 
359 359
 	{
360
-		if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id');  }
361
-		$db = $this->getIdoDb()->getConnection();
360
+		if (!preg_match('/^[0-9]+$/', $id)) { throw new Exception('Invalid id'); }
361
+		$db=$this->getIdoDb()->getConnection();
362 362
 		$query=$db->select()
363 363
 				->from(
364 364
 					array('a' => 'icinga_objects'),
@@ -378,17 +378,17 @@  discard block
 block discarded – undo
378 378
 	*/
379 379
 	protected function getHostByObjectID($id) // TODO : duplicate of getHostInfoByID above
380 380
 	{
381
-		if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id');  }
382
-		$db = $this->getIdoDb()->getConnection();
381
+		if (!preg_match('/^[0-9]+$/', $id)) { throw new Exception('Invalid id'); }
382
+		$db=$this->getIdoDb()->getConnection();
383 383
 		$query=$db->select()
384 384
 				->from(
385 385
 					array('a' => 'icinga_objects'),
386
-					array('name' => 'a.name1','id' => 'a.object_id'))
386
+					array('name' => 'a.name1', 'id' => 'a.object_id'))
387 387
 				->join(
388 388
 					array('b' => 'icinga_hosts'),
389 389
 					'b.host_object_id=a.object_id',
390
-					array('display_name' => 'b.display_name' , 'ip' => 'b.address', 'ip6' => 'b.address6'))
391
-				->where('a.object_id = ?',$id);
390
+					array('display_name' => 'b.display_name', 'ip' => 'b.address', 'ip6' => 'b.address6'))
391
+				->where('a.object_id = ?', $id);
392 392
 		return $db->fetchRow($query);
393 393
 	}	
394 394
 	
@@ -400,16 +400,16 @@  discard block
 block discarded – undo
400 400
 	protected function getServicesByHostid($id) 
401 401
 	{
402 402
 		// select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id
403
-		if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id');  }
404
-		$db = $this->getIdoDb()->getConnection();
403
+		if (!preg_match('/^[0-9]+$/', $id)) { throw new Exception('Invalid id'); }
404
+		$db=$this->getIdoDb()->getConnection();
405 405
 		$query=$db->select()
406 406
 				->from(
407 407
 					array('s' => 'icinga_services'),
408
-					array('name' => 's.display_name','id' => 's.service_object_id'))
408
+					array('name' => 's.display_name', 'id' => 's.service_object_id'))
409 409
 				->join(
410 410
 					array('a' => 'icinga_objects'),
411 411
 					's.service_object_id=a.object_id',
412
-					array('is_active'=>'a.is_active','name2'=>'a.name2'))
412
+					array('is_active'=>'a.is_active', 'name2'=>'a.name2'))
413 413
 				->where('s.host_object_id='.$id.' AND a.is_active = 1');
414 414
 
415 415
 		return $db->fetchAll($query);
@@ -423,8 +423,8 @@  discard block
 block discarded – undo
423 423
 	*/
424 424
 	protected function getServicesByHostGroupid($id) 
425 425
 	{		
426
-		if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id');  }
427
-		$db = $this->getIdoDb()->getConnection();
426
+		if (!preg_match('/^[0-9]+$/', $id)) { throw new Exception('Invalid id'); }
427
+		$db=$this->getIdoDb()->getConnection();
428 428
 		$query=$db->select()
429 429
 				->from(
430 430
 					array('s' => 'icinga_hostgroup_members'),
@@ -441,11 +441,11 @@  discard block
 block discarded – undo
441 441
 		foreach ($hosts as $key => $host)
442 442
 		{ // For each host, get all services and add in common_services if not found or add counter
443 443
 			$host_services=$this->getServicesByHostid($host->host_object_id);
444
-			foreach($host_services as $service)
444
+			foreach ($host_services as $service)
445 445
 			{
446 446
 				if (isset($common_services[$service->name2]['num']))
447 447
 				{
448
-					$common_services[$service->name2]['num'] +=1;
448
+					$common_services[$service->name2]['num']+=1;
449 449
 				}
450 450
 				else
451 451
 				{
@@ -461,7 +461,7 @@  discard block
 block discarded – undo
461 461
 		{
462 462
 		    if ($common_services[$key]['num'] == $num_hosts)
463 463
 			{
464
-				array_push($result,array($key,$common_services[$key]['name']));
464
+				array_push($result, array($key, $common_services[$key]['name']));
465 465
 			}
466 466
 		}
467 467
 		
@@ -474,9 +474,9 @@  discard block
 block discarded – undo
474 474
 	*	@param $name string service name
475 475
 	*	@return array  service id
476 476
 	*/
477
-	protected function getServiceIDByName($hostname,$name) 
477
+	protected function getServiceIDByName($hostname, $name) 
478 478
 	{
479
-		$db = $this->getIdoDb()->getConnection();
479
+		$db=$this->getIdoDb()->getConnection();
480 480
 		if ($name == null)
481 481
 		{
482 482
 			return array();
@@ -485,7 +485,7 @@  discard block
 block discarded – undo
485 485
 		$query=$db->select()
486 486
 				->from(
487 487
 					array('s' => 'icinga_services'),
488
-					array('name' => 's.display_name','id' => 's.service_object_id'))
488
+					array('name' => 's.display_name', 'id' => 's.service_object_id'))
489 489
 				->join(
490 490
 					array('a' => 'icinga_objects'),
491 491
 					's.service_object_id=a.object_id',
@@ -503,12 +503,12 @@  discard block
 block discarded – undo
503 503
 	protected function getObjectNameByid($id) 
504 504
 	{
505 505
 		// select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id
506
-		if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id');  }
507
-		$db = $this->getIdoDb()->getConnection();
506
+		if (!preg_match('/^[0-9]+$/', $id)) { throw new Exception('Invalid id'); }
507
+		$db=$this->getIdoDb()->getConnection();
508 508
 		$query=$db->select()
509 509
 				->from(
510 510
 					array('a' => 'icinga_objects'),
511
-					array('name1' => 'a.name1','name2' => 'a.name2'))
511
+					array('name1' => 'a.name1', 'name2' => 'a.name2'))
512 512
 				->where('a.object_id='.$id.' AND a.is_active = 1');
513 513
 
514 514
 		return $db->fetchRow($query);
@@ -521,17 +521,17 @@  discard block
 block discarded – undo
521 521
 	protected function addHandlerRule($params)
522 522
 	{
523 523
 		// TODO Check for rule consistency
524
-		$db = $this->getDb()->getConnection();
524
+		$db=$this->getDb()->getConnection();
525 525
 		// Add last modified date = creation date and username
526
-		$params['created'] = new Zend_Db_Expr('NOW()');
527
-		$params['modified'] = new 	Zend_Db_Expr('NOW()');
528
-		$params['modifier'] = $this->Auth()->getUser()->getUsername();
526
+		$params['created']=new Zend_Db_Expr('NOW()');
527
+		$params['modified']=new 	Zend_Db_Expr('NOW()');
528
+		$params['modifier']=$this->Auth()->getUser()->getUsername();
529 529
 		
530 530
 		$query=$db->insert(
531 531
 			$this->getModuleConfig()->getTrapRuleName(),
532 532
 			$params
533 533
 		);
534
-		if($query==false)
534
+		if ($query == false)
535 535
 		{
536 536
 		  return null;
537 537
 		}
@@ -542,13 +542,13 @@  discard block
 block discarded – undo
542 542
 	*	@param array(<db item>=><value>)
543 543
 	*	@return array affected rows
544 544
 	*/
545
-	protected function updateHandlerRule($params,$ruleID)
545
+	protected function updateHandlerRule($params, $ruleID)
546 546
 	{
547 547
 		// TODO Check for rule consistency
548
-		$db = $this->getDb()->getConnection();
548
+		$db=$this->getDb()->getConnection();
549 549
 		// Add last modified date = creation date and username
550
-		$params['modified'] = new 	Zend_Db_Expr('NOW()');
551
-		$params['modifier'] = $this->Auth()->getUser()->getUsername();
550
+		$params['modified']=new 	Zend_Db_Expr('NOW()');
551
+		$params['modifier']=$this->Auth()->getUser()->getUsername();
552 552
 		
553 553
 		$numRows=$db->update(
554 554
 			$this->getModuleConfig()->getTrapRuleName(),
@@ -563,8 +563,8 @@  discard block
 block discarded – undo
563 563
 	*/
564 564
 	protected function deleteRule($ruleID)
565 565
 	{
566
-		if (!preg_match('/^[0-9]+$/',$ruleID)) { throw new Exception('Invalid id');  }
567
-		$db = $this->getDb()->getConnection();
566
+		if (!preg_match('/^[0-9]+$/', $ruleID)) { throw new Exception('Invalid id'); }
567
+		$db=$this->getDb()->getConnection();
568 568
 		
569 569
 		$query=$db->delete(
570 570
 			$this->getModuleConfig()->getTrapRuleName(),
@@ -577,10 +577,10 @@  discard block
 block discarded – undo
577 577
 	*	@param $ip string source IP (v4 or v6)
578 578
 	*	@param $oid string oid
579 579
 	*/
580
-	protected function deleteTrap($ip,$oid)
580
+	protected function deleteTrap($ip, $oid)
581 581
 	{
582 582
 		
583
-		$db = $this->getDb()->getConnection();
583
+		$db=$this->getDb()->getConnection();
584 584
 		$condition=null;
585 585
 		if ($ip != null)
586 586
 		{
@@ -588,10 +588,10 @@  discard block
 block discarded – undo
588 588
 		}
589 589
 		if ($oid != null)
590 590
 		{
591
-			$condition=($condition===null)?'':$condition.' AND ';
591
+			$condition=($condition === null) ? '' : $condition.' AND ';
592 592
 			$condition.="trap_oid='$oid'";
593 593
 		}
594
-		if($condition === null) return null;
594
+		if ($condition === null) return null;
595 595
 		$query=$db->delete(
596 596
 			$this->getModuleConfig()->getTrapTableName(),
597 597
 			$condition
@@ -605,10 +605,10 @@  discard block
 block discarded – undo
605 605
 	*	@param $ip string source IP (v4 or v6)
606 606
 	*	@param $oid string oid
607 607
 	*/
608
-	protected function countTrap($ip,$oid)
608
+	protected function countTrap($ip, $oid)
609 609
 	{
610 610
 		
611
-		$db = $this->getDb()->getConnection();
611
+		$db=$this->getDb()->getConnection();
612 612
 		$condition=null;
613 613
 		if ($ip != null)
614 614
 		{
@@ -616,10 +616,10 @@  discard block
 block discarded – undo
616 616
 		}
617 617
 		if ($oid != null)
618 618
 		{
619
-			$condition=($condition===null)?'':$condition.' AND ';
619
+			$condition=($condition === null) ? '' : $condition.' AND ';
620 620
 			$condition.="trap_oid='$oid'";
621 621
 		}
622
-		if($condition ==null) return 0;
622
+		if ($condition == null) return 0;
623 623
 		$query=$db->select()
624 624
 			->from(
625 625
 				$this->getModuleConfig()->getTrapTableName(),
@@ -635,27 +635,27 @@  discard block
 block discarded – undo
635 635
 	protected function getDBConfigValue($element)
636 636
 	{
637 637
 	
638
-		$db = $this->getDb()->getConnection();
638
+		$db=$this->getDb()->getConnection();
639 639
 		
640 640
 		$query=$db->select()
641 641
 			->from(
642 642
 				$this->getModuleConfig()->getDbConfigTableName(),
643 643
 				array('value'=>'value'))
644
-			->where('name=?',$element);
644
+			->where('name=?', $element);
645 645
 		$return_row=$db->fetchRow($query);
646
-		if ($return_row==null)  // value does not exists
646
+		if ($return_row == null)  // value does not exists
647 647
 		{
648 648
 			$default=$this->getModuleConfig()->getDBConfigDefaults();
649
-			if ( ! isset($default[$element])) return null; // no default and not value
649
+			if (!isset($default[$element])) return null; // no default and not value
650 650
 			
651
-			$this->addDBConfigValue($element,$default[$element]);
651
+			$this->addDBConfigValue($element, $default[$element]);
652 652
 			return $default[$element];
653 653
 		}
654 654
 		if ($return_row->value == null) // value id empty
655 655
 		{
656 656
 			$default=$this->getModuleConfig()->getDBConfigDefaults();
657
-			if ( ! isset($default[$element])) return null; // no default and not value
658
-			$this->setDBConfigValue($element,$default[$element]);
657
+			if (!isset($default[$element])) return null; // no default and not value
658
+			$this->setDBConfigValue($element, $default[$element]);
659 659
 			return $default[$element];			
660 660
 		}
661 661
 		return $return_row->value;		
@@ -666,10 +666,10 @@  discard block
 block discarded – undo
666 666
 	*   @param string $value : value
667 667
 	*/
668 668
 		
669
-	protected function addDBConfigValue($element,$value)
669
+	protected function addDBConfigValue($element, $value)
670 670
 	{
671 671
 	
672
-		$db = $this->getDb()->getConnection();
672
+		$db=$this->getDb()->getConnection();
673 673
 		
674 674
 		$query=$db->insert(
675 675
 				$this->getModuleConfig()->getDbConfigTableName(),
@@ -685,10 +685,10 @@  discard block
 block discarded – undo
685 685
 	*	@param string $element : name of config element
686 686
 	*   @param string $value : value
687 687
 	*/
688
-	protected function setDBConfigValue($element,$value)
688
+	protected function setDBConfigValue($element, $value)
689 689
 	{
690 690
 	
691
-		$db = $this->getDb()->getConnection();
691
+		$db=$this->getDb()->getConnection();
692 692
 		$query=$db->update(
693 693
 				$this->getModuleConfig()->getDbConfigTableName(),
694 694
 				array('value'=>$value),
@@ -703,10 +703,10 @@  discard block
 block discarded – undo
703 703
 	protected function isDirectorInstalled()
704 704
 	{
705 705
 	    $output=array();
706
-	    exec('icingacli module list',$output);
706
+	    exec('icingacli module list', $output);
707 707
 	    foreach ($output as $line)
708 708
 		{
709
-			if (preg_match('/^director .*enabled/',$line))
709
+			if (preg_match('/^director .*enabled/', $line))
710 710
 			{
711 711
 				return true;
712 712
 			}
Please login to merge, or discard this patch.
Braces   +62 added lines, -30 removed lines patch added patch discarded remove patch
@@ -87,10 +87,11 @@  discard block
 block discarded – undo
87 87
 		try 
88 88
 		{
89 89
 			$dbconn = IcingaDbConnection::fromResourceName($DBname);
90
-		} 
91
-		catch (Exception $e)
90
+		} catch (Exception $e)
92 91
 		{
93
-			if ($test) return array(2,$DBname);
92
+			if ($test) {
93
+				return array(2,$DBname);
94
+			}
94 95
 			$this->redirectNow('trapdirector/settings?dberror=2');
95 96
 			return null;
96 97
 		}
@@ -98,10 +99,11 @@  discard block
 block discarded – undo
98 99
 			try 
99 100
 			{
100 101
 				$db=$dbconn->getConnection();
101
-			}
102
-			catch (Exception $e) 
102
+			} catch (Exception $e) 
103 103
 			{
104
-				if ($test) return array(3,$DBname,$e->getMessage());
104
+				if ($test) {
105
+					return array(3,$DBname,$e->getMessage());
106
+				}
105 107
 				$this->redirectNow('trapdirector/settings?dberror=3');
106 108
 				return null;
107 109
 			}
@@ -113,25 +115,32 @@  discard block
 block discarded – undo
113 115
 				$version=$db->fetchRow($query);
114 116
 				if ( ($version == null) || ! property_exists($version,'value') )
115 117
 				{
116
-					if ($test) return array(4,$DBname);
118
+					if ($test) {
119
+						return array(4,$DBname);
120
+					}
117 121
 					$this->redirectNow('trapdirector/settings?dberror=4');
118 122
 					return null;
119 123
 				}
120 124
 				if ($version->value < $this->getModuleConfig()->getDbMinVersion()) 
121 125
 				{
122
-					if ($test) return array(5,$version->value,$this->getModuleConfig()->getDbMinVersion());
126
+					if ($test) {
127
+						return array(5,$version->value,$this->getModuleConfig()->getDbMinVersion());
128
+					}
123 129
 					$this->redirectNow('trapdirector/settings?dberror=5');
124 130
 					return null;
125 131
 				}
126
-			}
127
-			catch (Exception $e) 
132
+			} catch (Exception $e) 
128 133
 			{
129
-				if ($test) return array(3,$DBname,$e->getMessage());
134
+				if ($test) {
135
+					return array(3,$DBname,$e->getMessage());
136
+				}
130 137
 				$this->redirectNow('trapdirector/settings?dberror=4');
131 138
 				return null;
132 139
 			}
133 140
 		}
134
-		if ($test) return array(0,'');
141
+		if ($test) {
142
+			return array(0,'');
143
+		}
135 144
 		return $dbconn;
136 145
 	}
137 146
 
@@ -142,31 +151,41 @@  discard block
 block discarded – undo
142 151
 	 */
143 152
 	public function getDb($test=false)
144 153
 	{
145
-		if ($this->trapDB != null && $test = false) return $this->trapDB;
154
+		if ($this->trapDB != null && $test = false) {
155
+			return $this->trapDB;
156
+		}
146 157
 		
147 158
 		$dbresource=$this->Config()->get('config', 'database');
148 159
 		
149 160
 		if ( ! $dbresource )
150 161
 		{	
151
-			if ($test) return array(1,'');
162
+			if ($test) {
163
+				return array(1,'');
164
+			}
152 165
 			$this->redirectNow('trapdirector/settings?dberror=1');
153 166
 			return null;
154 167
 		}
155 168
 		$retDB=$this->getDbByName($dbresource,$test,true);
156
-		if ($test == true) return $retDB;
169
+		if ($test == true) {
170
+			return $retDB;
171
+		}
157 172
 		$this->trapDB=$retDB;
158 173
 		return $this->trapDB;
159 174
 	}
160 175
 	
161 176
 	public function getIdoDb($test=false)
162 177
 	{
163
-		if ($this->icingaDB != null && $test = false) return $this->icingaDB;
178
+		if ($this->icingaDB != null && $test = false) {
179
+			return $this->icingaDB;
180
+		}
164 181
 		// TODO : get ido database directly from icingaweb2 config -> (or not if using only API)
165 182
 		$dbresource=$this->Config()->get('config', 'IDOdatabase');;
166 183
 
167 184
 		if ( ! $dbresource )
168 185
 		{
169
-		    if ($test) return array(1,'No database in config.ini');
186
+		    if ($test) {
187
+		    	return array(1,'No database in config.ini');
188
+		    }
170 189
 		    $this->redirectNow('trapdirector/settings?idodberror=1');
171 190
 		    return null;
172 191
 		}
@@ -174,10 +193,11 @@  discard block
 block discarded – undo
174 193
 		try
175 194
 		{
176 195
 		    $dbconn = IcingaDbConnection::fromResourceName($dbresource);
177
-		}
178
-		catch (Exception $e)
196
+		} catch (Exception $e)
179 197
 		{
180
-		    if ($test) return array(2,"Database $dbresource does not exists in IcingaWeb2");
198
+		    if ($test) {
199
+		    	return array(2,"Database $dbresource does not exists in IcingaWeb2");
200
+		    }
181 201
 		    $this->redirectNow('trapdirector/settings?idodberror=2');
182 202
 		    return null;
183 203
 		}
@@ -197,8 +217,7 @@  discard block
 block discarded – undo
197 217
 		    {
198 218
 		        return array(4,"$dbresource does not look like an IDO database");
199 219
 		    }
200
-		}
201
-		catch (Exception $e)
220
+		} catch (Exception $e)
202 221
 		{
203 222
 			return array(3,"Error connecting to $dbresource : " . $e->getMessage());
204 223
 		}
@@ -446,8 +465,7 @@  discard block
 block discarded – undo
446 465
 				if (isset($common_services[$service->name2]['num']))
447 466
 				{
448 467
 					$common_services[$service->name2]['num'] +=1;
449
-				}
450
-				else
468
+				} else
451 469
 				{
452 470
 					$common_services[$service->name2]['num']=1;
453 471
 					$common_services[$service->name2]['name']=$service->name;
@@ -591,7 +609,9 @@  discard block
 block discarded – undo
591 609
 			$condition=($condition===null)?'':$condition.' AND ';
592 610
 			$condition.="trap_oid='$oid'";
593 611
 		}
594
-		if($condition === null) return null;
612
+		if($condition === null) {
613
+			return null;
614
+		}
595 615
 		$query=$db->delete(
596 616
 			$this->getModuleConfig()->getTrapTableName(),
597 617
 			$condition
@@ -619,7 +639,9 @@  discard block
 block discarded – undo
619 639
 			$condition=($condition===null)?'':$condition.' AND ';
620 640
 			$condition.="trap_oid='$oid'";
621 641
 		}
622
-		if($condition ==null) return 0;
642
+		if($condition ==null) {
643
+			return 0;
644
+		}
623 645
 		$query=$db->select()
624 646
 			->from(
625 647
 				$this->getModuleConfig()->getTrapTableName(),
@@ -643,18 +665,28 @@  discard block
 block discarded – undo
643 665
 				array('value'=>'value'))
644 666
 			->where('name=?',$element);
645 667
 		$return_row=$db->fetchRow($query);
646
-		if ($return_row==null)  // value does not exists
668
+		if ($return_row==null) {
669
+			// value does not exists
647 670
 		{
648 671
 			$default=$this->getModuleConfig()->getDBConfigDefaults();
649
-			if ( ! isset($default[$element])) return null; // no default and not value
672
+		}
673
+			if ( ! isset($default[$element])) {
674
+				return null;
675
+			}
676
+			// no default and not value
650 677
 			
651 678
 			$this->addDBConfigValue($element,$default[$element]);
652 679
 			return $default[$element];
653 680
 		}
654
-		if ($return_row->value == null) // value id empty
681
+		if ($return_row->value == null) {
682
+			// value id empty
655 683
 		{
656 684
 			$default=$this->getModuleConfig()->getDBConfigDefaults();
657
-			if ( ! isset($default[$element])) return null; // no default and not value
685
+		}
686
+			if ( ! isset($default[$element])) {
687
+				return null;
688
+			}
689
+			// no default and not value
658 690
 			$this->setDBConfigValue($element,$default[$element]);
659 691
 			return $default[$element];			
660 692
 		}
Please login to merge, or discard this patch.
library/Trapdirector/Config/MIBLoader.php 3 patches
Indentation   +46 added lines, -46 removed lines patch added patch discarded remove patch
@@ -31,10 +31,10 @@  discard block
 block discarded – undo
31 31
 				
32 32
 	}
33 33
 
34
-    /**
35
-     * Get all mibs in db which have at least one trap
36
-     * @return array
37
-     */	
34
+	/**
35
+	 * Get all mibs in db which have at least one trap
36
+	 * @return array
37
+	 */	
38 38
 	
39 39
 	public function getMIBList()
40 40
 	{
@@ -58,9 +58,9 @@  discard block
 block discarded – undo
58 58
 	
59 59
 	
60 60
 	/** Get trap list from a mib 
61
-	*	@param $mib string mib name
62
-	*	@return array : traps
63
-	*/
61
+	 *	@param $mib string mib name
62
+	 *	@return array : traps
63
+	 */
64 64
 	public function getTrapList($mib)
65 65
 	{
66 66
 		$traps=array();
@@ -68,7 +68,7 @@  discard block
 block discarded – undo
68 68
 		$query=$dbconn->select()
69 69
 				->from(
70 70
 					$this->config->getMIBCacheTableName(),
71
-				    array('name' => 'name', 'oid' => 'oid', 'description' => 'description'))
71
+					array('name' => 'name', 'oid' => 'oid', 'description' => 'description'))
72 72
 				->where("mib = '".$mib."' AND type='21'") ;
73 73
 		$names=$dbconn->fetchAll($query);
74 74
 		foreach ($names as $val)
@@ -79,9 +79,9 @@  discard block
 block discarded – undo
79 79
 	}
80 80
 	
81 81
 	/** Get objects a trap can have
82
-	*	@param int $trap oid of trap
83
-	*	@return array|null : null if trap not found, or array ( <oid> => name/mib/type )
84
-	*/
82
+	 *	@param int $trap oid of trap
83
+	 *	@return array|null : null if trap not found, or array ( <oid> => name/mib/type )
84
+	 */
85 85
 	public function getObjectList($trap)
86 86
 	{
87 87
 		$objects=array();
@@ -97,15 +97,15 @@  discard block
 block discarded – undo
97 97
 		if ( ($id == null) || ! property_exists($id,'id') ) return null;
98 98
 		
99 99
 		$query=$dbconn->select()
100
-		        ->from(
101
-		            array('c' => $this->config->getMIBCacheTableName()),
102
-		            array('name' => 'c.name','mib' => 'c.mib','oid' => 'c.oid','type_enum'=>'c.type_enum',
103
-		                'type' => 'c.syntax', 'text_conv' => 'c.textual_convention', 'disp' => 'display_hint',
104
-		                'description' => 'c.description'))
105
-		        ->join(
106
-		            array('o' => $this->config->getMIBCacheTableTrapObjName()),
107
-		            'o.trap_id='.$id->id )
108
-		        ->where("o.object_id = c.id");
100
+				->from(
101
+					array('c' => $this->config->getMIBCacheTableName()),
102
+					array('name' => 'c.name','mib' => 'c.mib','oid' => 'c.oid','type_enum'=>'c.type_enum',
103
+						'type' => 'c.syntax', 'text_conv' => 'c.textual_convention', 'disp' => 'display_hint',
104
+						'description' => 'c.description'))
105
+				->join(
106
+					array('o' => $this->config->getMIBCacheTableTrapObjName()),
107
+					'o.trap_id='.$id->id )
108
+				->where("o.object_id = c.id");
109 109
 		$listObjects=$dbconn->fetchAll($query);
110 110
 		if ( count($listObjects)==0 ) return null;
111 111
 		
@@ -123,12 +123,12 @@  discard block
 block discarded – undo
123 123
 	}
124 124
 
125 125
 	/** translate oid in MIB::Name 
126
-	*	@param string oid
127
-	*	@return array|null :  return array with index (oid -> oid, mib -> mib name, name -> oid name, type -> oid type)
128
-	*/
126
+	 *	@param string oid
127
+	 *	@return array|null :  return array with index (oid -> oid, mib -> mib name, name -> oid name, type -> oid type)
128
+	 */
129 129
 	public function translateOID($oid)
130 130
 	{
131
-	    if (!preg_match('/^\./',$oid)) $oid = '.' . $oid; // Add a leading '.'
131
+		if (!preg_match('/^\./',$oid)) $oid = '.' . $oid; // Add a leading '.'
132 132
 		$retArray=array('oid' => $oid, 'mib' => null, 'name'=>null,'type'=>null);
133 133
 		$dbconn = $this->db->getConnection();
134 134
 
@@ -136,7 +136,7 @@  discard block
 block discarded – undo
136 136
 				->from(
137 137
 					array('o' => $this->config->getMIBCacheTableName()),
138 138
 					array('mib'=>'o.mib','name' => 'o.name','type'=>'o.syntax',
139
-					    'type_enum'=>'o.type_enum', 'description'=>'o.description'))
139
+						'type_enum'=>'o.type_enum', 'description'=>'o.description'))
140 140
 				->where('o.oid=\''.$oid.'\'');
141 141
 		$object=$dbconn->fetchRow($query);
142 142
 		if ($object != null) 
@@ -152,7 +152,7 @@  discard block
 block discarded – undo
152 152
 		// Try to get oid name from snmptranslate
153 153
 		$matches=array();
154 154
 		$translate=exec($this->snmptranslate . ' -m ALL -M +'.$this->snmptranslate_dirs.
155
-		    ' '.$oid);
155
+			' '.$oid);
156 156
 		$ret_code=preg_match('/(.*)::(.*)/',$translate,$matches);
157 157
 		if ($ret_code===0 || $ret_code===false) {
158 158
 			return null;
@@ -164,8 +164,8 @@  discard block
 block discarded – undo
164 164
 			" | grep SYNTAX | sed 's/SYNTAX[[:blank:]]*//'");
165 165
 		if (preg_match('/(.*)\{(.*)\}/',$translate,$matches))
166 166
 		{
167
-		    $retArray['type']=$matches[1];
168
-		    $retArray['type_enum']=$matches[2];
167
+			$retArray['type']=$matches[1];
168
+			$retArray['type_enum']=$matches[2];
169 169
 		}
170 170
 		else
171 171
 		{
@@ -229,25 +229,25 @@  discard block
 block discarded – undo
229 229
 	 */
230 230
 	public function getTrapDetails($oid=null,$id=null)
231 231
 	{	    
232
-	    // Get trap id in DB
233
-	    if ($oid===null)
234
-	    {
235
-	        $where="c.id = '$id'";
236
-	    }
237
-	    else
238
-	    {
239
-	        $where="c.oid = '$oid'";
240
-	    }
241
-	    $query=$this->db->getConnection()->select()
242
-           ->from(
243
-            array('c' => $this->config->getMIBCacheTableName()),
244
-            array('name' => 'c.name','mib' => 'c.mib','oid' => 'c.oid','type_enum'=>'c.type_enum',
245
-                'type' => 'c.syntax', 'text_conv' => 'c.textual_convention', 'disp' => 'display_hint',
246
-                'description' => 'c.description'))
247
-            ->where($where);
248
-        $trap=$this->db->getConnection()->fetchRow($query);
232
+		// Get trap id in DB
233
+		if ($oid===null)
234
+		{
235
+			$where="c.id = '$id'";
236
+		}
237
+		else
238
+		{
239
+			$where="c.oid = '$oid'";
240
+		}
241
+		$query=$this->db->getConnection()->select()
242
+		   ->from(
243
+			array('c' => $this->config->getMIBCacheTableName()),
244
+			array('name' => 'c.name','mib' => 'c.mib','oid' => 'c.oid','type_enum'=>'c.type_enum',
245
+				'type' => 'c.syntax', 'text_conv' => 'c.textual_convention', 'disp' => 'display_hint',
246
+				'description' => 'c.description'))
247
+			->where($where);
248
+		$trap=$this->db->getConnection()->fetchRow($query);
249 249
         
250
-        return $trap;
250
+		return $trap;
251 251
 	}
252 252
 	
253 253
 }
Please login to merge, or discard this patch.
Spacing   +28 added lines, -28 removed lines patch added patch discarded remove patch
@@ -21,7 +21,7 @@  discard block
 block discarded – undo
21 21
 	 * @param string $db current database
22 22
 	 * @param TrapModuleConfig $config TrapModuleConfig class instance
23 23
 	 */
24
-	public function __construct($snmptranslate,$snmptranslate_dirs,$db,$config)
24
+	public function __construct($snmptranslate, $snmptranslate_dirs, $db, $config)
25 25
 	{
26 26
 		$this->snmptranslate=$snmptranslate;
27 27
 		$this->snmptranslate_dirs=$snmptranslate_dirs;
@@ -38,19 +38,19 @@  discard block
 block discarded – undo
38 38
 	
39 39
 	public function getMIBList()
40 40
 	{
41
-		$dbconn = $this->db->getConnection();
41
+		$dbconn=$this->db->getConnection();
42 42
 		$query=$dbconn->select()
43 43
 				->distinct()
44 44
 				->from(
45 45
 					$this->config->getMIBCacheTableName(),
46 46
 					array('mib' => 'mib'))
47 47
 				->where("type = '21'")
48
-				->order('mib ASC');				;
48
+				->order('mib ASC'); ;
49 49
 		$names=$dbconn->fetchAll($query);
50 50
 		$mib=array();
51
-		foreach($names as $val)
51
+		foreach ($names as $val)
52 52
 		{
53
-			array_push($mib,$val->mib);
53
+			array_push($mib, $val->mib);
54 54
 		}
55 55
 		return $mib;
56 56
 		
@@ -64,12 +64,12 @@  discard block
 block discarded – undo
64 64
 	public function getTrapList($mib)
65 65
 	{
66 66
 		$traps=array();
67
-		$dbconn = $this->db->getConnection();
67
+		$dbconn=$this->db->getConnection();
68 68
 		$query=$dbconn->select()
69 69
 				->from(
70 70
 					$this->config->getMIBCacheTableName(),
71 71
 				    array('name' => 'name', 'oid' => 'oid', 'description' => 'description'))
72
-				->where("mib = '".$mib."' AND type='21'") ;
72
+				->where("mib = '".$mib."' AND type='21'");
73 73
 		$names=$dbconn->fetchAll($query);
74 74
 		foreach ($names as $val)
75 75
 		{
@@ -87,19 +87,19 @@  discard block
 block discarded – undo
87 87
 		$objects=array();
88 88
 		
89 89
 		// Get trap id in DB
90
-		$dbconn = $this->db->getConnection();
90
+		$dbconn=$this->db->getConnection();
91 91
 		$query=$dbconn->select()
92 92
 				->from(
93 93
 					$this->config->getMIBCacheTableName(),
94 94
 					array('id' => 'id'))
95
-				->where("oid = '".$trap."'") ;
95
+				->where("oid = '".$trap."'");
96 96
 		$id=$dbconn->fetchRow($query);
97
-		if ( ($id == null) || ! property_exists($id,'id') ) return null;
97
+		if (($id == null) || !property_exists($id, 'id')) return null;
98 98
 		
99 99
 		$query=$dbconn->select()
100 100
 		        ->from(
101 101
 		            array('c' => $this->config->getMIBCacheTableName()),
102
-		            array('name' => 'c.name','mib' => 'c.mib','oid' => 'c.oid','type_enum'=>'c.type_enum',
102
+		            array('name' => 'c.name', 'mib' => 'c.mib', 'oid' => 'c.oid', 'type_enum'=>'c.type_enum',
103 103
 		                'type' => 'c.syntax', 'text_conv' => 'c.textual_convention', 'disp' => 'display_hint',
104 104
 		                'description' => 'c.description'))
105 105
 		        ->join(
@@ -107,7 +107,7 @@  discard block
 block discarded – undo
107 107
 		            'o.trap_id='.$id->id )
108 108
 		        ->where("o.object_id = c.id");
109 109
 		$listObjects=$dbconn->fetchAll($query);
110
-		if ( count($listObjects)==0 ) return null;
110
+		if (count($listObjects) == 0) return null;
111 111
 		
112 112
 		foreach ($listObjects as $val)
113 113
 		{
@@ -128,14 +128,14 @@  discard block
 block discarded – undo
128 128
 	*/
129 129
 	public function translateOID($oid)
130 130
 	{
131
-	    if (!preg_match('/^\./',$oid)) $oid = '.' . $oid; // Add a leading '.'
132
-		$retArray=array('oid' => $oid, 'mib' => null, 'name'=>null,'type'=>null);
133
-		$dbconn = $this->db->getConnection();
131
+	    if (!preg_match('/^\./', $oid)) $oid='.'.$oid; // Add a leading '.'
132
+		$retArray=array('oid' => $oid, 'mib' => null, 'name'=>null, 'type'=>null);
133
+		$dbconn=$this->db->getConnection();
134 134
 
135 135
 		$query=$dbconn->select()
136 136
 				->from(
137 137
 					array('o' => $this->config->getMIBCacheTableName()),
138
-					array('mib'=>'o.mib','name' => 'o.name','type'=>'o.syntax',
138
+					array('mib'=>'o.mib', 'name' => 'o.name', 'type'=>'o.syntax',
139 139
 					    'type_enum'=>'o.type_enum', 'description'=>'o.description'))
140 140
 				->where('o.oid=\''.$oid.'\'');
141 141
 		$object=$dbconn->fetchRow($query);
@@ -151,18 +151,18 @@  discard block
 block discarded – undo
151 151
 		
152 152
 		// Try to get oid name from snmptranslate
153 153
 		$matches=array();
154
-		$translate=exec($this->snmptranslate . ' -m ALL -M +'.$this->snmptranslate_dirs.
154
+		$translate=exec($this->snmptranslate.' -m ALL -M +'.$this->snmptranslate_dirs.
155 155
 		    ' '.$oid);
156
-		$ret_code=preg_match('/(.*)::(.*)/',$translate,$matches);
157
-		if ($ret_code===0 || $ret_code===false) {
156
+		$ret_code=preg_match('/(.*)::(.*)/', $translate, $matches);
157
+		if ($ret_code === 0 || $ret_code === false) {
158 158
 			return null;
159 159
 		} 
160 160
 		$retArray['mib']=$matches[1];
161 161
 		$retArray['name']=$matches[2];
162 162
 		
163
-		$translate=exec($this->snmptranslate . ' -m ALL -M +'.$this->snmptranslate_dirs.' -Td -On ' . $matches[0] .
163
+		$translate=exec($this->snmptranslate.' -m ALL -M +'.$this->snmptranslate_dirs.' -Td -On '.$matches[0].
164 164
 			" | grep SYNTAX | sed 's/SYNTAX[[:blank:]]*//'");
165
-		if (preg_match('/(.*)\{(.*)\}/',$translate,$matches))
165
+		if (preg_match('/(.*)\{(.*)\}/', $translate, $matches))
166 166
 		{
167 167
 		    $retArray['type']=$matches[1];
168 168
 		    $retArray['type_enum']=$matches[2];
@@ -197,9 +197,9 @@  discard block
 block discarded – undo
197 197
 	 * @param string $type filter by type (21=trap)
198 198
 	 * @return number number of entries in db.
199 199
 	 */
200
-	public function countObjects($mib=null,$type=null)
200
+	public function countObjects($mib=null, $type=null)
201 201
 	{
202
-		$dbconn = $this->db->getConnection();
202
+		$dbconn=$this->db->getConnection();
203 203
 		$query=$dbconn->select()
204 204
 				->from(
205 205
 					$this->config->getMIBCacheTableName(),
@@ -207,11 +207,11 @@  discard block
 block discarded – undo
207 207
 		$where=null;
208 208
 		if ($mib !== null)
209 209
 		{
210
-			$where ="mib = '$mib' ";
210
+			$where="mib = '$mib' ";
211 211
 		}
212 212
 		if ($type !== null)
213 213
 		{
214
-			$where=($where != null)?' AND ':'';
214
+			$where=($where != null) ? ' AND ' : '';
215 215
 			$where.="type='$type'";
216 216
 		}
217 217
 		if ($where !== null)
@@ -227,10 +227,10 @@  discard block
 block discarded – undo
227 227
 	 * @param integer $id
228 228
 	 * @return array trap details
229 229
 	 */
230
-	public function getTrapDetails($oid=null,$id=null)
230
+	public function getTrapDetails($oid=null, $id=null)
231 231
 	{	    
232 232
 	    // Get trap id in DB
233
-	    if ($oid===null)
233
+	    if ($oid === null)
234 234
 	    {
235 235
 	        $where="c.id = '$id'";
236 236
 	    }
@@ -241,7 +241,7 @@  discard block
 block discarded – undo
241 241
 	    $query=$this->db->getConnection()->select()
242 242
            ->from(
243 243
             array('c' => $this->config->getMIBCacheTableName()),
244
-            array('name' => 'c.name','mib' => 'c.mib','oid' => 'c.oid','type_enum'=>'c.type_enum',
244
+            array('name' => 'c.name', 'mib' => 'c.mib', 'oid' => 'c.oid', 'type_enum'=>'c.type_enum',
245 245
                 'type' => 'c.syntax', 'text_conv' => 'c.textual_convention', 'disp' => 'display_hint',
246 246
                 'description' => 'c.description'))
247 247
             ->where($where);
Please login to merge, or discard this patch.
Braces   +12 added lines, -7 removed lines patch added patch discarded remove patch
@@ -94,7 +94,9 @@  discard block
 block discarded – undo
94 94
 					array('id' => 'id'))
95 95
 				->where("oid = '".$trap."'") ;
96 96
 		$id=$dbconn->fetchRow($query);
97
-		if ( ($id == null) || ! property_exists($id,'id') ) return null;
97
+		if ( ($id == null) || ! property_exists($id,'id') ) {
98
+			return null;
99
+		}
98 100
 		
99 101
 		$query=$dbconn->select()
100 102
 		        ->from(
@@ -107,7 +109,9 @@  discard block
 block discarded – undo
107 109
 		            'o.trap_id='.$id->id )
108 110
 		        ->where("o.object_id = c.id");
109 111
 		$listObjects=$dbconn->fetchAll($query);
110
-		if ( count($listObjects)==0 ) return null;
112
+		if ( count($listObjects)==0 ) {
113
+			return null;
114
+		}
111 115
 		
112 116
 		foreach ($listObjects as $val)
113 117
 		{
@@ -128,7 +132,10 @@  discard block
 block discarded – undo
128 132
 	*/
129 133
 	public function translateOID($oid)
130 134
 	{
131
-	    if (!preg_match('/^\./',$oid)) $oid = '.' . $oid; // Add a leading '.'
135
+	    if (!preg_match('/^\./',$oid)) {
136
+	    	$oid = '.' . $oid;
137
+	    }
138
+	    // Add a leading '.'
132 139
 		$retArray=array('oid' => $oid, 'mib' => null, 'name'=>null,'type'=>null);
133 140
 		$dbconn = $this->db->getConnection();
134 141
 
@@ -166,8 +173,7 @@  discard block
 block discarded – undo
166 173
 		{
167 174
 		    $retArray['type']=$matches[1];
168 175
 		    $retArray['type_enum']=$matches[2];
169
-		}
170
-		else
176
+		} else
171 177
 		{
172 178
 			$retArray['type']=$translate;
173 179
 			$retArray['type_enum']='';			
@@ -233,8 +239,7 @@  discard block
 block discarded – undo
233 239
 	    if ($oid===null)
234 240
 	    {
235 241
 	        $where="c.id = '$id'";
236
-	    }
237
-	    else
242
+	    } else
238 243
 	    {
239 244
 	        $where="c.oid = '$oid'";
240 245
 	    }
Please login to merge, or discard this patch.
library/Trapdirector/TrapsProcess/Logging.php 3 patches
Indentation   +102 added lines, -102 removed lines patch added patch discarded remove patch
@@ -9,113 +9,113 @@
 block discarded – undo
9 9
 class Logging
10 10
 {
11 11
 
12
-    //**** Options from config database
13
-    // Default values
14
-    public $debugLevel=2;  // 0=No output 1=critical 2=warning 3=trace 4=ALL
15
-    public $outputMode='syslog'; // alert type : file, syslog, display
16
-    public $outputFile="/tmp/trapdebug.txt";
17
-    protected $logLevels=array("","Error","Warning","Info","Debug");
18
-    protected $outputList=array('file', 'syslog', 'display');
12
+	//**** Options from config database
13
+	// Default values
14
+	public $debugLevel=2;  // 0=No output 1=critical 2=warning 3=trace 4=ALL
15
+	public $outputMode='syslog'; // alert type : file, syslog, display
16
+	public $outputFile="/tmp/trapdebug.txt";
17
+	protected $logLevels=array("","Error","Warning","Info","Debug");
18
+	protected $outputList=array('file', 'syslog', 'display');
19 19
     
20
-    /** Send log. Throws exception on critical error
21
-     *	@param	string $message Message to log
22
-     *	@param	int $level 1=critical 2=warning 3=trace 4=debug
23
-     *	@param  string $destination file/syslog/display
24
-     *	@return void
25
-     *  @throws Exception
26
-     **/
27
-    public function log( $message, $level, $destination ='')
28
-    {
29
-        if ($this->debugLevel >= $level)
30
-        {
31
-            $message = '['.  date("Y/m/d H:i:s") . '] ' .
32
-                '[TrapDirector] ['.$this->logLevels[$level].']: ' .$message . "\n";
20
+	/** Send log. Throws exception on critical error
21
+	 *	@param	string $message Message to log
22
+	 *	@param	int $level 1=critical 2=warning 3=trace 4=debug
23
+	 *	@param  string $destination file/syslog/display
24
+	 *	@return void
25
+	 *  @throws Exception
26
+	 **/
27
+	public function log( $message, $level, $destination ='')
28
+	{
29
+		if ($this->debugLevel >= $level)
30
+		{
31
+			$message = '['.  date("Y/m/d H:i:s") . '] ' .
32
+				'[TrapDirector] ['.$this->logLevels[$level].']: ' .$message . "\n";
33 33
             
34
-            $output = ( $destination != '' ) ? $destination : $this->outputMode;
35
-            switch ($output)
36
-            {
37
-                case 'file':
38
-                    file_put_contents ($this->outputFile, $message , FILE_APPEND);
39
-                    break;
40
-                case 'syslog':
41
-                    switch($level)
42
-                    {
43
-                        case 1 : $prio = LOG_ERR;break;
44
-                        case 2 : $prio = LOG_WARNING;break;
45
-                        case 3 : $prio = LOG_INFO;break;
46
-                        case 4 : $prio = LOG_DEBUG;break;
47
-                        default: $prio = LOG_ERR;
48
-                    }
49
-                    syslog($prio,$message);
50
-                    break;
51
-                case 'display':
52
-                    echo $message;
53
-                    break;
54
-                default : // nothing we can do at this point
55
-                    throw new Exception($message);
56
-            }
57
-        }
58
-        if ($level == 1)
59
-        {
60
-            throw new Exception($message);
61
-        }
62
-    }
34
+			$output = ( $destination != '' ) ? $destination : $this->outputMode;
35
+			switch ($output)
36
+			{
37
+				case 'file':
38
+					file_put_contents ($this->outputFile, $message , FILE_APPEND);
39
+					break;
40
+				case 'syslog':
41
+					switch($level)
42
+					{
43
+						case 1 : $prio = LOG_ERR;break;
44
+						case 2 : $prio = LOG_WARNING;break;
45
+						case 3 : $prio = LOG_INFO;break;
46
+						case 4 : $prio = LOG_DEBUG;break;
47
+						default: $prio = LOG_ERR;
48
+					}
49
+					syslog($prio,$message);
50
+					break;
51
+				case 'display':
52
+					echo $message;
53
+					break;
54
+				default : // nothing we can do at this point
55
+					throw new Exception($message);
56
+			}
57
+		}
58
+		if ($level == 1)
59
+		{
60
+			throw new Exception($message);
61
+		}
62
+	}
63 63
     
64 64
         
65
-    public function setLogging($debugLvl,$outputType,$outputFile=null)
66
-    {
67
-        $this->setLevel($debugLvl);
68
-        switch ($outputType)
69
-        {
70
-            case 'file':
71
-                if ($outputFile == null) throw new Exception("File logging without file !");
72
-                $this->setFile($outputFile);
73
-                $this->setDestination('file');
74
-                break;
75
-            default:
76
-                $this->setDestination($outputType);
77
-        }
78
-    }
65
+	public function setLogging($debugLvl,$outputType,$outputFile=null)
66
+	{
67
+		$this->setLevel($debugLvl);
68
+		switch ($outputType)
69
+		{
70
+			case 'file':
71
+				if ($outputFile == null) throw new Exception("File logging without file !");
72
+				$this->setFile($outputFile);
73
+				$this->setDestination('file');
74
+				break;
75
+			default:
76
+				$this->setDestination($outputType);
77
+		}
78
+	}
79 79
     
80
-    /**
81
-     * Set logging level
82
-     * @param integer $level
83
-     * @throws Exception
84
-     */
85
-    public function setLevel($level)
86
-    {
87
-        if (!is_integer($level) || $level < 0 || $level > 10)
88
-        {
89
-            throw new Exception('Invalid log level');
90
-        }
91
-        $this->debugLevel=$level;
92
-    }
80
+	/**
81
+	 * Set logging level
82
+	 * @param integer $level
83
+	 * @throws Exception
84
+	 */
85
+	public function setLevel($level)
86
+	{
87
+		if (!is_integer($level) || $level < 0 || $level > 10)
88
+		{
89
+			throw new Exception('Invalid log level');
90
+		}
91
+		$this->debugLevel=$level;
92
+	}
93 93
 
94
-    /**
95
-     * Set logging destination
96
-     * @param string $destination
97
-     * @throws Exception
98
-     */
99
-    public function setDestination($destination)
100
-    {
101
-        if (!is_string($destination) || ! in_array($destination, $this->outputList))
102
-        {
103
-            throw new Exception('Invalid log destination');
104
-        }
105
-        $this->outputMode=$destination;
106
-    }
107
-    /**
108
-     * Set file destination
109
-     * @param string $file
110
-     * @throws Exception
111
-     */
112
-    public function setFile($file)
113
-    {
114
-        if (!is_string($file))
115
-        {
116
-            throw new Exception('Invalid log file');
117
-        }
118
-        $this->outputFile=$file;
119
-    }
94
+	/**
95
+	 * Set logging destination
96
+	 * @param string $destination
97
+	 * @throws Exception
98
+	 */
99
+	public function setDestination($destination)
100
+	{
101
+		if (!is_string($destination) || ! in_array($destination, $this->outputList))
102
+		{
103
+			throw new Exception('Invalid log destination');
104
+		}
105
+		$this->outputMode=$destination;
106
+	}
107
+	/**
108
+	 * Set file destination
109
+	 * @param string $file
110
+	 * @throws Exception
111
+	 */
112
+	public function setFile($file)
113
+	{
114
+		if (!is_string($file))
115
+		{
116
+			throw new Exception('Invalid log file');
117
+		}
118
+		$this->outputFile=$file;
119
+	}
120 120
     
121 121
 }
122 122
\ No newline at end of file
Please login to merge, or discard this patch.
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch
@@ -4,17 +4,17 @@  discard block
 block discarded – undo
4 4
 
5 5
 use Exception;
6 6
 
7
-define("ERROR", 1);define("WARN", 2);define("INFO", 3);define("DEBUG", 4);
7
+define("ERROR", 1); define("WARN", 2); define("INFO", 3); define("DEBUG", 4);
8 8
 
9 9
 class Logging
10 10
 {
11 11
 
12 12
     //**** Options from config database
13 13
     // Default values
14
-    public $debugLevel=2;  // 0=No output 1=critical 2=warning 3=trace 4=ALL
14
+    public $debugLevel=2; // 0=No output 1=critical 2=warning 3=trace 4=ALL
15 15
     public $outputMode='syslog'; // alert type : file, syslog, display
16 16
     public $outputFile="/tmp/trapdebug.txt";
17
-    protected $logLevels=array("","Error","Warning","Info","Debug");
17
+    protected $logLevels=array("", "Error", "Warning", "Info", "Debug");
18 18
     protected $outputList=array('file', 'syslog', 'display');
19 19
     
20 20
     /** Send log. Throws exception on critical error
@@ -24,29 +24,29 @@  discard block
 block discarded – undo
24 24
      *	@return void
25 25
      *  @throws Exception
26 26
      **/
27
-    public function log( $message, $level, $destination ='')
27
+    public function log($message, $level, $destination='')
28 28
     {
29 29
         if ($this->debugLevel >= $level)
30 30
         {
31
-            $message = '['.  date("Y/m/d H:i:s") . '] ' .
32
-                '[TrapDirector] ['.$this->logLevels[$level].']: ' .$message . "\n";
31
+            $message='['.date("Y/m/d H:i:s").'] '.
32
+                '[TrapDirector] ['.$this->logLevels[$level].']: '.$message."\n";
33 33
             
34
-            $output = ( $destination != '' ) ? $destination : $this->outputMode;
34
+            $output=($destination != '') ? $destination : $this->outputMode;
35 35
             switch ($output)
36 36
             {
37 37
                 case 'file':
38
-                    file_put_contents ($this->outputFile, $message , FILE_APPEND);
38
+                    file_put_contents($this->outputFile, $message, FILE_APPEND);
39 39
                     break;
40 40
                 case 'syslog':
41
-                    switch($level)
41
+                    switch ($level)
42 42
                     {
43
-                        case 1 : $prio = LOG_ERR;break;
44
-                        case 2 : $prio = LOG_WARNING;break;
45
-                        case 3 : $prio = LOG_INFO;break;
46
-                        case 4 : $prio = LOG_DEBUG;break;
47
-                        default: $prio = LOG_ERR;
43
+                        case 1 : $prio=LOG_ERR; break;
44
+                        case 2 : $prio=LOG_WARNING; break;
45
+                        case 3 : $prio=LOG_INFO; break;
46
+                        case 4 : $prio=LOG_DEBUG; break;
47
+                        default: $prio=LOG_ERR;
48 48
                     }
49
-                    syslog($prio,$message);
49
+                    syslog($prio, $message);
50 50
                     break;
51 51
                 case 'display':
52 52
                     echo $message;
@@ -62,7 +62,7 @@  discard block
 block discarded – undo
62 62
     }
63 63
     
64 64
         
65
-    public function setLogging($debugLvl,$outputType,$outputFile=null)
65
+    public function setLogging($debugLvl, $outputType, $outputFile=null)
66 66
     {
67 67
         $this->setLevel($debugLvl);
68 68
         switch ($outputType)
@@ -98,7 +98,7 @@  discard block
 block discarded – undo
98 98
      */
99 99
     public function setDestination($destination)
100 100
     {
101
-        if (!is_string($destination) || ! in_array($destination, $this->outputList))
101
+        if (!is_string($destination) || !in_array($destination, $this->outputList))
102 102
         {
103 103
             throw new Exception('Invalid log destination');
104 104
         }
Please login to merge, or discard this patch.
Braces   +3 added lines, -1 removed lines patch added patch discarded remove patch
@@ -68,7 +68,9 @@
 block discarded – undo
68 68
         switch ($outputType)
69 69
         {
70 70
             case 'file':
71
-                if ($outputFile == null) throw new Exception("File logging without file !");
71
+                if ($outputFile == null) {
72
+                	throw new Exception("File logging without file !");
73
+                }
72 74
                 $this->setFile($outputFile);
73 75
                 $this->setDestination('file');
74 76
                 break;
Please login to merge, or discard this patch.
library/Trapdirector/TrapsProcess/Database.php 2 patches
Indentation   +110 added lines, -110 removed lines patch added patch discarded remove patch
@@ -11,128 +11,128 @@
 block discarded – undo
11 11
 class Database
12 12
 {
13 13
 
14
-    // Databases
15
-    protected $trapDB=null; //< trap database
16
-    protected $idoDB=null; //< ido database
17
-    public $trapDBType; //< Type of database for traps (mysql, pgsql)
18
-    public $idoDBType; //< Type of database for ido (mysql, pgsql)
14
+	// Databases
15
+	protected $trapDB=null; //< trap database
16
+	protected $idoDB=null; //< ido database
17
+	public $trapDBType; //< Type of database for traps (mysql, pgsql)
18
+	public $idoDBType; //< Type of database for ido (mysql, pgsql)
19 19
     
20
-    protected $trapDSN; //< trap database connection params
21
-    protected $trapUsername; //< trap database connection params
22
-    protected $trapPass; //< trap database connection params
20
+	protected $trapDSN; //< trap database connection params
21
+	protected $trapUsername; //< trap database connection params
22
+	protected $trapPass; //< trap database connection params
23 23
     
24
-    protected $idoSet; //< bool true is ido database set
25
-    protected $idoDSN; //< trap database connection params
26
-    protected $idoUsername; //< trap database connection params
27
-    protected $idoPass; //< trap database connection params
24
+	protected $idoSet; //< bool true is ido database set
25
+	protected $idoDSN; //< trap database connection params
26
+	protected $idoUsername; //< trap database connection params
27
+	protected $idoPass; //< trap database connection params
28 28
     
29
-    // Logging function
29
+	// Logging function
30 30
     
31
-    protected $logging; //< logging class
31
+	protected $logging; //< logging class
32 32
     
33
-    /**
34
-     * @param Logging $logClass : where to log
35
-     * @param array $dbParam : array of named params  type,host,dbname,username,[port],[password]
36
-     */
37
-    function __construct($logClass,$dbParam)
38
-    {
39
-        $this->logging=$logClass;
33
+	/**
34
+	 * @param Logging $logClass : where to log
35
+	 * @param array $dbParam : array of named params  type,host,dbname,username,[port],[password]
36
+	 */
37
+	function __construct($logClass,$dbParam)
38
+	{
39
+		$this->logging=$logClass;
40 40
         
41
-        $this->trapDSN=$this->setupDSN($dbParam);
42
-        $this->trapUsername = $dbParam['username'];
43
-        $this->trapPass = (array_key_exists('password', $dbParam)) ? $dbParam['password']:'';
44
-        $this->trapDBType=$dbParam['db'];
45
-        $this->logging->log('DSN : '.$this->trapDSN. ';user '.$this->trapUsername,INFO);
46
-        $this->db_connect_trap();
41
+		$this->trapDSN=$this->setupDSN($dbParam);
42
+		$this->trapUsername = $dbParam['username'];
43
+		$this->trapPass = (array_key_exists('password', $dbParam)) ? $dbParam['password']:'';
44
+		$this->trapDBType=$dbParam['db'];
45
+		$this->logging->log('DSN : '.$this->trapDSN. ';user '.$this->trapUsername,INFO);
46
+		$this->db_connect_trap();
47 47
         
48
-    }
48
+	}
49 49
     
50
-    /**
51
-     * Setup and connect to IDO database
52
-     * @param array $dbParam : array of named params
53
-     */
54
-    public function setupIDO($dbParam)
55
-    {
56
-        $this->idoDSN=$this->setupDSN($dbParam);
57
-        $this->idoUsername = $dbParam['username'];
58
-        $this->idoPass = (array_key_exists('password', $dbParam)) ? $dbParam['password']:'';
59
-        $this->logging->log('DSN : '.$this->idoDSN. ';user '.$this->idoUsername,INFO);
60
-        $this->idoDBType=$dbParam['db'];
61
-        $this->db_connect_ido();
62
-    }
50
+	/**
51
+	 * Setup and connect to IDO database
52
+	 * @param array $dbParam : array of named params
53
+	 */
54
+	public function setupIDO($dbParam)
55
+	{
56
+		$this->idoDSN=$this->setupDSN($dbParam);
57
+		$this->idoUsername = $dbParam['username'];
58
+		$this->idoPass = (array_key_exists('password', $dbParam)) ? $dbParam['password']:'';
59
+		$this->logging->log('DSN : '.$this->idoDSN. ';user '.$this->idoUsername,INFO);
60
+		$this->idoDBType=$dbParam['db'];
61
+		$this->db_connect_ido();
62
+	}
63 63
     
64
-    /**
65
-     * Connect to IDO database
66
-     * @return \PDO
67
-     */
68
-    public function db_connect_ido()
69
-    {
70
-        if ($this->idoDB != null) {
71
-            // Check if connection is still alive
72
-            try {
73
-                $this->idoDB->query('select 1')->fetchColumn();
74
-                return $this->idoDB;
75
-            } catch (Exception $e) {
76
-                // select 1 failed, try to reconnect.
77
-                $this->logging->log('Database IDO connection lost, reconnecting',WARN);
78
-            }
79
-        }
80
-        try {
81
-            $this->idoDB = new PDO($this->idoDSN,$this->idoUsername,$this->idoPass);
82
-        } catch (PDOException $e) {
83
-            $this->logging->log('Connection failed to IDO : ' . $e->getMessage(),ERROR,'');
84
-        }
85
-        return $this->idoDB;
86
-    }
64
+	/**
65
+	 * Connect to IDO database
66
+	 * @return \PDO
67
+	 */
68
+	public function db_connect_ido()
69
+	{
70
+		if ($this->idoDB != null) {
71
+			// Check if connection is still alive
72
+			try {
73
+				$this->idoDB->query('select 1')->fetchColumn();
74
+				return $this->idoDB;
75
+			} catch (Exception $e) {
76
+				// select 1 failed, try to reconnect.
77
+				$this->logging->log('Database IDO connection lost, reconnecting',WARN);
78
+			}
79
+		}
80
+		try {
81
+			$this->idoDB = new PDO($this->idoDSN,$this->idoUsername,$this->idoPass);
82
+		} catch (PDOException $e) {
83
+			$this->logging->log('Connection failed to IDO : ' . $e->getMessage(),ERROR,'');
84
+		}
85
+		return $this->idoDB;
86
+	}
87 87
     
88
-    /**
89
-     * Connect to Trap database
90
-     * @return \PDO
91
-     */
92
-    public function db_connect_trap()
93
-    {
88
+	/**
89
+	 * Connect to Trap database
90
+	 * @return \PDO
91
+	 */
92
+	public function db_connect_trap()
93
+	{
94 94
         
95
-        if ($this->trapDB != null) {
96
-            // Check if connection is still alive
97
-            try {
98
-                $this->trapDB->query('select 1')->fetchColumn();
99
-                return $this->trapDB;
100
-            } catch (Exception $e) {
101
-                // select 1 failed, try to reconnect.
102
-                $this->logging->log('Database connection lost, reconnecting',WARN);
103
-            }           
104
-        }       
105
-        try {
106
-            $this->trapDB = new PDO($this->trapDSN,$this->trapUsername,$this->trapPass);
107
-        } catch (PDOException $e) {
108
-            $this->logging->log('Connection failed : ' . $e->getMessage(),ERROR,'');
109
-        }
110
-        return $this->trapDB;
111
-    }
95
+		if ($this->trapDB != null) {
96
+			// Check if connection is still alive
97
+			try {
98
+				$this->trapDB->query('select 1')->fetchColumn();
99
+				return $this->trapDB;
100
+			} catch (Exception $e) {
101
+				// select 1 failed, try to reconnect.
102
+				$this->logging->log('Database connection lost, reconnecting',WARN);
103
+			}           
104
+		}       
105
+		try {
106
+			$this->trapDB = new PDO($this->trapDSN,$this->trapUsername,$this->trapPass);
107
+		} catch (PDOException $e) {
108
+			$this->logging->log('Connection failed : ' . $e->getMessage(),ERROR,'');
109
+		}
110
+		return $this->trapDB;
111
+	}
112 112
     
113
-    /**
114
-     * Setup dsn and check parameters
115
-     * @param array $configElmt
116
-     * @return string
117
-     */
118
-    protected function setupDSN($configElmt)  
119
-    {
120
-        if (!array_key_exists('db',$configElmt) ||
121
-            !array_key_exists('host',$configElmt) ||
122
-            !array_key_exists('dbname',$configElmt) ||
123
-            !array_key_exists('username',$configElmt))
124
-        {
125
-            $this->logging->log('Missing DB params',ERROR);
126
-            return ''; 
127
-        }
113
+	/**
114
+	 * Setup dsn and check parameters
115
+	 * @param array $configElmt
116
+	 * @return string
117
+	 */
118
+	protected function setupDSN($configElmt)  
119
+	{
120
+		if (!array_key_exists('db',$configElmt) ||
121
+			!array_key_exists('host',$configElmt) ||
122
+			!array_key_exists('dbname',$configElmt) ||
123
+			!array_key_exists('username',$configElmt))
124
+		{
125
+			$this->logging->log('Missing DB params',ERROR);
126
+			return ''; 
127
+		}
128 128
         
129
-        //	$dsn = 'mysql:dbname=traps;host=127.0.0.1';
130
-        $dsn= $configElmt['db'].':dbname='.$configElmt['dbname'].';host='.$configElmt['host'];
129
+		//	$dsn = 'mysql:dbname=traps;host=127.0.0.1';
130
+		$dsn= $configElmt['db'].':dbname='.$configElmt['dbname'].';host='.$configElmt['host'];
131 131
         
132
-        if (array_key_exists('port', $configElmt))
133
-        {
134
-            $dsn .= ';port='.$configElmt['port'];
135
-        }
136
-        return $dsn;
137
-    }
132
+		if (array_key_exists('port', $configElmt))
133
+		{
134
+			$dsn .= ';port='.$configElmt['port'];
135
+		}
136
+		return $dsn;
137
+	}
138 138
 }
139 139
\ No newline at end of file
Please login to merge, or discard this patch.
Spacing   +20 added lines, -20 removed lines patch added patch discarded remove patch
@@ -34,15 +34,15 @@  discard block
 block discarded – undo
34 34
      * @param Logging $logClass : where to log
35 35
      * @param array $dbParam : array of named params  type,host,dbname,username,[port],[password]
36 36
      */
37
-    function __construct($logClass,$dbParam)
37
+    function __construct($logClass, $dbParam)
38 38
     {
39 39
         $this->logging=$logClass;
40 40
         
41 41
         $this->trapDSN=$this->setupDSN($dbParam);
42
-        $this->trapUsername = $dbParam['username'];
43
-        $this->trapPass = (array_key_exists('password', $dbParam)) ? $dbParam['password']:'';
42
+        $this->trapUsername=$dbParam['username'];
43
+        $this->trapPass=(array_key_exists('password', $dbParam)) ? $dbParam['password'] : '';
44 44
         $this->trapDBType=$dbParam['db'];
45
-        $this->logging->log('DSN : '.$this->trapDSN. ';user '.$this->trapUsername,INFO);
45
+        $this->logging->log('DSN : '.$this->trapDSN.';user '.$this->trapUsername, INFO);
46 46
         $this->db_connect_trap();
47 47
         
48 48
     }
@@ -54,9 +54,9 @@  discard block
 block discarded – undo
54 54
     public function setupIDO($dbParam)
55 55
     {
56 56
         $this->idoDSN=$this->setupDSN($dbParam);
57
-        $this->idoUsername = $dbParam['username'];
58
-        $this->idoPass = (array_key_exists('password', $dbParam)) ? $dbParam['password']:'';
59
-        $this->logging->log('DSN : '.$this->idoDSN. ';user '.$this->idoUsername,INFO);
57
+        $this->idoUsername=$dbParam['username'];
58
+        $this->idoPass=(array_key_exists('password', $dbParam)) ? $dbParam['password'] : '';
59
+        $this->logging->log('DSN : '.$this->idoDSN.';user '.$this->idoUsername, INFO);
60 60
         $this->idoDBType=$dbParam['db'];
61 61
         $this->db_connect_ido();
62 62
     }
@@ -74,13 +74,13 @@  discard block
 block discarded – undo
74 74
                 return $this->idoDB;
75 75
             } catch (Exception $e) {
76 76
                 // select 1 failed, try to reconnect.
77
-                $this->logging->log('Database IDO connection lost, reconnecting',WARN);
77
+                $this->logging->log('Database IDO connection lost, reconnecting', WARN);
78 78
             }
79 79
         }
80 80
         try {
81
-            $this->idoDB = new PDO($this->idoDSN,$this->idoUsername,$this->idoPass);
81
+            $this->idoDB=new PDO($this->idoDSN, $this->idoUsername, $this->idoPass);
82 82
         } catch (PDOException $e) {
83
-            $this->logging->log('Connection failed to IDO : ' . $e->getMessage(),ERROR,'');
83
+            $this->logging->log('Connection failed to IDO : '.$e->getMessage(), ERROR, '');
84 84
         }
85 85
         return $this->idoDB;
86 86
     }
@@ -99,13 +99,13 @@  discard block
 block discarded – undo
99 99
                 return $this->trapDB;
100 100
             } catch (Exception $e) {
101 101
                 // select 1 failed, try to reconnect.
102
-                $this->logging->log('Database connection lost, reconnecting',WARN);
102
+                $this->logging->log('Database connection lost, reconnecting', WARN);
103 103
             }           
104 104
         }       
105 105
         try {
106
-            $this->trapDB = new PDO($this->trapDSN,$this->trapUsername,$this->trapPass);
106
+            $this->trapDB=new PDO($this->trapDSN, $this->trapUsername, $this->trapPass);
107 107
         } catch (PDOException $e) {
108
-            $this->logging->log('Connection failed : ' . $e->getMessage(),ERROR,'');
108
+            $this->logging->log('Connection failed : '.$e->getMessage(), ERROR, '');
109 109
         }
110 110
         return $this->trapDB;
111 111
     }
@@ -117,21 +117,21 @@  discard block
 block discarded – undo
117 117
      */
118 118
     protected function setupDSN($configElmt)  
119 119
     {
120
-        if (!array_key_exists('db',$configElmt) ||
121
-            !array_key_exists('host',$configElmt) ||
122
-            !array_key_exists('dbname',$configElmt) ||
123
-            !array_key_exists('username',$configElmt))
120
+        if (!array_key_exists('db', $configElmt) ||
121
+            !array_key_exists('host', $configElmt) ||
122
+            !array_key_exists('dbname', $configElmt) ||
123
+            !array_key_exists('username', $configElmt))
124 124
         {
125
-            $this->logging->log('Missing DB params',ERROR);
125
+            $this->logging->log('Missing DB params', ERROR);
126 126
             return ''; 
127 127
         }
128 128
         
129 129
         //	$dsn = 'mysql:dbname=traps;host=127.0.0.1';
130
-        $dsn= $configElmt['db'].':dbname='.$configElmt['dbname'].';host='.$configElmt['host'];
130
+        $dsn=$configElmt['db'].':dbname='.$configElmt['dbname'].';host='.$configElmt['host'];
131 131
         
132 132
         if (array_key_exists('port', $configElmt))
133 133
         {
134
-            $dsn .= ';port='.$configElmt['port'];
134
+            $dsn.=';port='.$configElmt['port'];
135 135
         }
136 136
         return $dsn;
137 137
     }
Please login to merge, or discard this patch.