Issues (4069)

Security Analysis    not enabled

This project does not seem to handle request data directly as such no vulnerable execution paths were found.

  Cross-Site Scripting
Cross-Site Scripting enables an attacker to inject code into the response of a web-request that is viewed by other users. It can for example be used to bypass access controls, or even to take over other users' accounts.
  File Exposure
File Exposure allows an attacker to gain access to local files that he should not be able to access. These files can for example include database credentials, or other configuration files.
  File Manipulation
File Manipulation enables an attacker to write custom data to files. This potentially leads to injection of arbitrary code on the server.
  Object Injection
Object Injection enables an attacker to inject an object into PHP code, and can lead to arbitrary code execution, file exposure, or file manipulation attacks.
  Code Injection
Code Injection enables an attacker to execute arbitrary code on the server.
  Response Splitting
Response Splitting can be used to send arbitrary responses.
  File Inclusion
File Inclusion enables an attacker to inject custom files into PHP's file loading mechanism, either explicitly passed to include, or for example via PHP's auto-loading mechanism.
  Command Injection
Command Injection enables an attacker to inject a shell command that is execute with the privileges of the web-server. This can be used to expose sensitive data, or gain access of your server.
  SQL Injection
SQL Injection enables an attacker to execute arbitrary SQL code on your database server gaining access to user data, or manipulating user data.
  XPath Injection
XPath Injection enables an attacker to modify the parts of XML document that are read. If that XML document is for example used for authentication, this can lead to further vulnerabilities similar to SQL Injection.
  LDAP Injection
LDAP Injection enables an attacker to inject LDAP statements potentially granting permission to run unauthorized queries, or modify content inside the LDAP tree.
  Header Injection
  Other Vulnerability
This category comprises other attack vectors such as manipulating the PHP runtime, loading custom extensions, freezing the runtime, or similar.
  Regex Injection
Regex Injection enables an attacker to execute arbitrary code in your PHP process.
  XML Injection
XML Injection enables an attacker to read files on your local filesystem including configuration files, or can be abused to freeze your web-server process.
  Variable Injection
Variable Injection enables an attacker to overwrite program variables with custom data, and can lead to further vulnerabilities.
Unfortunately, the security analysis is currently not available for your project. If you are a non-commercial open-source project, please contact support to gain access.

include/controller/Controller.php (1 issue)

Upgrade to new PHP Analysis Engine

These results are based on our legacy PHP analysis, consider migrating to our new PHP analysis engine instead. Learn more

1
<?php
2
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
3
/*********************************************************************************
4
 * SugarCRM Community Edition is a customer relationship management program developed by
5
 * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
6
7
 * SuiteCRM is an extension to SugarCRM Community Edition developed by Salesagility Ltd.
8
 * Copyright (C) 2011 - 2014 Salesagility Ltd.
9
 *
10
 * This program is free software; you can redistribute it and/or modify it under
11
 * the terms of the GNU Affero General Public License version 3 as published by the
12
 * Free Software Foundation with the addition of the following permission added
13
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
14
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
15
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
16
 *
17
 * This program is distributed in the hope that it will be useful, but WITHOUT
18
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
19
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
20
 * details.
21
 *
22
 * You should have received a copy of the GNU Affero General Public License along with
23
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
24
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
25
 * 02110-1301 USA.
26
 *
27
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
28
 * SW2-130, Cupertino, CA 95014, USA. or at email address [email protected].
29
 *
30
 * The interactive user interfaces in modified source and object code versions
31
 * of this program must display Appropriate Legal Notices, as required under
32
 * Section 5 of the GNU Affero General Public License version 3.
33
 *
34
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
35
 * these Appropriate Legal Notices must retain the display of the "Powered by
36
 * SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
37
 * reasonably feasible for  technical reasons, the Appropriate Legal Notices must
38
 * display the words  "Powered by SugarCRM" and "Supercharged by SuiteCRM".
39
 ********************************************************************************/
40
41
/*********************************************************************************
42
43
 * Description:
44
 ********************************************************************************/
45
46
47
48
49
50
51
52
53
class Controller extends SugarBean {
54
55
	var $focus;
56
	var $type;  //defines id this is a new list order or existing, or delete
57
				// New, Save, Delete
58
59
	public function __construct() {
60
		parent::__construct();
61
62
		$this->disable_row_level_security =true;
63
64
	}
65
66
    /**
67
     * @deprecated deprecated since version 7.6, PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code, use __construct instead
68
     */
69
    public function Controller(){
70
        $deprecatedMessage = 'PHP4 Style Constructors are deprecated and will be remove in 7.8, please update your code';
71
        if(isset($GLOBALS['log'])) {
72
            $GLOBALS['log']->deprecated($deprecatedMessage);
73
        }
74
        else {
75
            trigger_error($deprecatedMessage, E_USER_DEPRECATED);
76
        }
77
        self::__construct();
78
    }
79
80
81
	function init(& $seed_object, $type){
82
83
		$this->focus = & $seed_object;
84
		$this->type = $type;
85
86
	//end function Controller
87
	}
88
89
	function change_component_order($magnitude, $direction, $parent_id=""){
90
91
		if(!empty($this->type) && $this->type=="Save"){
92
93
			//safety check
94
			$wall_test = $this->check_wall($magnitude, $direction, $parent_id);
95
96
			if($wall_test==false){
0 ignored issues
show
Coding Style Best Practice introduced by
It seems like you are loosely comparing two booleans. Considering using the strict comparison === instead.

When comparing two booleans, it is generally considered safer to use the strict comparison operator.

Loading history...
97
				return;
98
			}
99
100
101
				if($direction=="Left"){
102
					if($this->focus->controller_def['list_x']=="Y"){
103
						$new_x = $this->focus->list_order_x -1;
104
						$affected_x = $this->focus->list_order_x;
105
					} else {
106
						$new_x = "";
107
						$affected_x = "";
108
					}
109
					if($this->focus->controller_def['list_y']=="Y"){
110
111
						$new_y = $this->focus->list_order_y;
112
						$affected_y = $this->focus->list_order_y;
113
					} else {
114
						$new_y = "";
115
						$affected_y = "";
116
					}
117
118
					$affected_id = $this->get_affected_id($parent_id, $new_x, $new_y);
119
				//end if direction Left
120
				}
121
				if($direction=="Right"){
122
123
					if($this->focus->controller_def['list_x']=="Y"){
124
						$new_x = $this->focus->list_order_x + 1;
125
						$affected_x = $this->focus->list_order_x;
126
					} else {
127
						$new_x = "";
128
						$affected_x = "";
129
					}
130
					if($this->focus->controller_def['list_y']=="Y"){
131
						$new_y = $this->focus->list_order_y;
132
						$affected_y = $this->focus->list_order_y;
133
					} else {
134
						$new_y = "";
135
						$affected_y = "";
136
					}
137
					$affected_id = $this->get_affected_id($parent_id, $new_x, $new_y);
138
				//end if direction Right
139
				}
140
141
				if($direction=="Up"){
142
					if($this->focus->controller_def['list_x']=="Y"){
143
						$new_x = $this->focus->list_order_x;
144
						$affected_x = $this->focus->list_order_x;
145
					} else {
146
						$new_x = "";
147
						$affected_x = "";
148
					}
149
					if($this->focus->controller_def['list_y']=="Y"){
150
151
					$new_y = $this->focus->list_order_y - 1;
152
					$affected_y = $this->focus->list_order_y;
153
					} else {
154
						$new_y = "";
155
						$affected_y = "";
156
					}
157
158
					$affected_id = $this->get_affected_id($parent_id, $new_x, $new_y);
159
160
				//end if direction Up
161
				}
162
				if($direction=="Down"){
163
164
					if($this->focus->controller_def['list_x']=="Y"){
165
						$new_x = $this->focus->list_order_x;
166
						$affected_x = $this->focus->list_order_x;
167
					} else {
168
						$new_x = "";
169
						$affected_x = "";
170
					}
171
					if($this->focus->controller_def['list_y']=="Y"){
172
173
						$new_y = $this->focus->list_order_y + 1;
174
						$affected_y = $this->focus->list_order_y;
175
					} else {
176
						$new_y = "";
177
						$affected_y = "";
178
					}
179
					$affected_id = $this->get_affected_id($parent_id, $new_x, $new_y);
180
				//end if direction Down
181
				}
182
183
			//This takes care of the component being pushed out of its position
184
			$this->update_affected_order($affected_id, $affected_x, $affected_y);
185
186
				//This takes care of the new positions for itself
187
			if($this->focus->controller_def['list_x']=="Y"){
188
				$this->focus->list_order_x = $new_x;
189
			}
190
191
			if($this->focus->controller_def['list_y']=="Y"){
192
				$this->focus->list_order_y = $new_y;
193
			}
194
195
		} else {
196
		//this is a new component, set the x or y value to the max + 1
197
198
				$query = "SELECT MAX(".$this->focus->controller_def['start_var'].") max_start from ".$this->focus->table_name."
199
						  WHERE ".$this->focus->controller_def['parent_var']."='$parent_id'
200
						  AND ".$this->focus->table_name.".deleted='0'
201
						 ";
202
				$result = $this->db->query($query,true," Error capturing max start order: ");
203
				$row = $this->db->fetchByAssoc($result);
204
205
			if(!is_null($row['max_start'])){
206
207
				if($this->focus->controller_def['start_axis']=="x")	{
208
					$this->focus->list_order_x = $row['max_start'] + 1;
209
					if($this->focus->controller_def['list_y']=="Y") $this->focus->list_order_y = 0;
210
				}
211
212
				if($this->focus->controller_def['start_axis']=="y")	{
213
					$this->focus->list_order_y = $row['max_start'] + 1;
214
					if($this->focus->controller_def['list_x']=="Y") $this->focus->list_order_x = 0;
215
				}
216
217
			} else {
218
				//first row
219
				if($this->focus->controller_def['list_x']=="Y") $this->focus->list_order_x = 0;
220
				if($this->focus->controller_def['list_y']=="Y") $this->focus->list_order_y = 0;
221
222
			//end if else to check if this is first entry
223
			}
224
		//end if else on whether this is a new entry
225
		}
226
	//end function change_component_order
227
	}
228
229
	function update_affected_order($affected_id, $affected_new_x="", $affected_new_y=""){
230
231
		$query = 	"UPDATE ".$this->focus->table_name." SET";
232
233
		if($this->focus->controller_def['list_x']=="Y"){
234
				$query .= 	"	 list_order_x='$affected_new_x'";
235
		}
236
		if($this->focus->controller_def['list_y']=="Y"){
237
238
			if($this->focus->controller_def['list_x']=="Y"){
239
				$query .= 	"	, ";
240
			}
241
			$query .= 	"	list_order_y='$affected_new_y'";
242
		}
243
244
		$query .=	"	WHERE id='$affected_id'";
245
		$query .=   "	AND ".$this->focus->table_name.".deleted='0'";
246
		$result = $this->db->query($query,true," Error updating affected order id: ");
247
	//end function update_affected_order
248
	}
249
250
	function get_affected_id($parent_id, $list_order_x="", $list_order_y=""){
251
252
		$query = "	SELECT id from ".$this->focus->table_name."
253
					WHERE ".$this->focus->controller_def['parent_var']."='$parent_id'
254
					AND ".$this->focus->table_name.".deleted='0'
255
					";
256
257
		if($this->focus->controller_def['list_x']=="Y"){
258
			$query .= "	AND list_order_x='$list_order_x' ";
259
		}
260
261
		if($this->focus->controller_def['list_y']=="Y"){
262
			$query .= "	AND list_order_y='$list_order_y' ";
263
		}
264
265
	//echo $query."<BR>";
266
		$result = $this->db->query($query,true," Error capturing affected id: ");
267
		$row = $this->db->fetchByAssoc($result);
268
269
		return $row['id'];
270
271
	//end function get_affected_id
272
	}
273
274
275
/////////////Wall Functions////////////////////
276
277
278
function check_wall($magnitude, $direction, $parent_id){
279
280
//TODO: jgreen - this is only single axis check_wall mechanism, will need to upgrade this to double axis
281
//This function determines if you can't move the direction you want, because you are at the edge
282
283
284
//If down or Right, then check max list_order value
285
	if($direction=="Down" || $direction =="Right"){
286
287
		$query = "SELECT MAX(".$this->focus->controller_def['start_var'].") max_start from ".$this->focus->table_name."
288
				  WHERE ".$this->focus->controller_def['parent_var']."='$parent_id'
289
				  AND ".$this->focus->table_name.".deleted='0'
290
						 ";
291
		$result = $this->db->query($query,true," Error capturing max start order: ");
292
		$row = $this->db->fetchByAssoc($result);
293
294
			if($this->focus->controller_def['start_axis']=="x")	{
295
				if($row['max_start'] == $this->focus->list_order_x){
296
					return false;
297
				}
298
			}
299
			if($this->focus->controller_def['start_axis']=="y")	{
300
				if($row['max_start'] == $this->focus->list_order_y){
301
					return false;
302
				}
303
			}
304
	//end if up or right
305
	}
306
307
//If up or left, then simply check the 0 value
308
	if($direction=="Up" || $direction =="Left"){
309
			if($this->focus->controller_def['start_axis']=="x")	{
310
				if($this->focus->list_order_x==0){
311
					return false;
312
				}
313
			}
314
			if($this->focus->controller_def['start_axis']=="y")	{
315
				if($this->focus->list_order_y==0){
316
					return false;
317
				}
318
			}
319
320
	//end if down or left
321
	}
322
323
	//If you get here, then you are not at the wall and can change order
324
	return true;
325
326
//end function check_wall
327
}
328
329
//End Wall Functions/////////////////////////
330
331
//Delete adjust functions////////////////////
332
333
334
function delete_adjust_order($parent_id){
335
336
337
	//Currently handles single axis motion only!!!!!!!!!
338
	//TODO: jgreen - Add dual axis motion
339
340
	//adjust along start_axis
341
	$variable_name = $this->focus->controller_def['start_var'];
342
	$current_position = $this->focus->$variable_name;
343
344
	$query =  "UPDATE ".$this->focus->table_name." ";
345
	$query .= "SET ".$this->focus->controller_def['start_var']." = ".$this->focus->controller_def['start_var']." - 1 ";
346
	$query .= "WHERE ".$this->focus->controller_def['start_var']." > ".$current_position." AND deleted=0 ";
347
	$query .= "AND ".$this->focus->controller_def['parent_var']." = '".$parent_id."'";
348
349
	$result = $this->db->query($query,true," Error updating the delete_adjust_order: ");
350
//end delete_adjust_order
351
}
352
//End Delete Functions/////////////////////////
353
//end class Controller
354
}
355
356
?>