Issues in adoptcache.php - All Issues - Inspection of "Merge pull request #705 from nlubisch/feature/move..." - OpencachingDeutschland/oc-server3 - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — development ( f93eb8...ffa1a0 )

by Thomas

created 2017-11-26 19:47 UTC

htdocs/adoptcache.php (8 issues)

Labels

Deprecated Code 8

Severity

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

<?php
/***************************************************************************
 * for license information see LICENSE.md
 ***************************************************************************/

require __DIR__ . '/lib2/web.inc.php';

$tpl->name = 'adoptcache';
$tpl->menuitem = MNU_CACHES_ADOPT;

$login->verify();
if ($login->userid == 0) {
    $tpl->redirect_login();
}

$action = isset($_REQUEST['action']) ? $_REQUEST['action'] : 'listbyuser';
$cacheId = isset($_REQUEST['cacheid']) ? (int) $_REQUEST['cacheid'] : 0;
$tpl->assign('action', $action);
$tpl->assign('error', '');
if (isset($_REQUEST['cacheid'])) {
    $tpl->assign('cacheid', (int) $_REQUEST['cacheid']);
}

if ($action === 'listbycache') {
    listRequestsByCacheId($cacheId);
} elseif ($action === 'add') {
    $tpl->assign('action', 'listbycache');

    $tou = isset($_REQUEST['tou']) ? (int) $_REQUEST['tou'] : 0;
    $submit = isset($_REQUEST['submit']) ? (int) $_REQUEST['submit'] : 0;

    $username = isset($_REQUEST['username']) ? $_REQUEST['username'] : '';
    $tpl->assign('adoptusername', $username);

    if ($submit === 1) {
        $userId = (int) sql_value("SELECT `user_id` FROM `user` WHERE `username`='&1'", 0, $username);

        if ($userId === 0) {
            $tpl->assign('error', 'userunknown');
        } elseif ($tou !== 1) {
            $tpl->assign('error', 'tou');
        } else {
            addRequest($cacheId, $userId);
        }
    }

    listRequestsByCacheId($cacheId);
} elseif ($action === 'cancel') {
    $userId = isset($_REQUEST['userid']) ? (int) $_REQUEST['userid']: 0;
    cancelRequest($cacheId, $userId);
} elseif ($action === 'commit') {
    $submit = isset($_REQUEST['submit']) ? (int) $_REQUEST['submit'] : 0;
    $tou = isset($_REQUEST['tou']) ? (int) $_REQUEST['tou'] : 0;

    if ($submit === 1 && $tou === 1) {
        commitRequest($cacheId);
    } else {
        showAdoptScreen($cacheId, $submit);
    }
} else {
    $tpl->assign('action', 'listbyuser');
    listRequestsByUserId();
}

$tpl->error(ERROR_UNKNOWN);

/**
 * @param $cacheId
 * @param $touError
 */
function showAdoptScreen($cacheId, $touError)
{
    global $tpl, $login;

    $rs = sql(

        "SELECT `caches`.`name`,
                `user`.`username`,
                `cache_adoption`.`date_created`
         FROM `caches`
         INNER JOIN `user` ON `caches`.`user_id`=`user`.`user_id`
         INNER JOIN `cache_adoption` ON `caches`.`cache_id`=`cache_adoption`.`cache_id`
         WHERE `caches`.`cache_id`='&1'
         AND `cache_adoption`.`user_id`='&2'",
        $cacheId,
        $login->userid
    );
    $r = sql_fetch_assoc($rs);

    if ($r === false) {
        $tpl->error(ERROR_NO_ACCESS);
    }

    $tpl->assign('cache', $r);
    sql_free_result($rs);


    if ($touError != 0) {
        $tpl->assign('error', 'tou');
    }

    $tpl->display();
}

/**
 * @param $cacheId
 */
function listRequestsByCacheId($cacheId)
{
    global $tpl, $login;

    // cache exists?
    $cache = new cache($cacheId);
    if ($cache->exist() == false) {
        $tpl->error(ERROR_CACHE_NOT_EXISTS);
    }

    // is the current user the owner of the cache?
    if ($cache->getUserId() != $login->userid) {
        $tpl->error(ERROR_NO_ACCESS);
    }

    $rs = sql(

        "SELECT
             `caches`.`cache_id` AS `id`,
             `user`.`user_id` AS `userid`,
             `user`.`username` AS `username`,
             `cache_adoption`.`date_created`
         FROM `caches`
         INNER JOIN `cache_adoption`
             ON `caches`.`cache_id` = `cache_adoption`.`cache_id`
         INNER JOIN `user`
             ON `cache_adoption`.`user_id`=`user`.`user_id`
         WHERE `caches`.`cache_id`='&1'",
        $cacheId
    );
    $tpl->assign_rs('adoptions', $rs);
    sql_free_result($rs);


    $tpl->assign('cachename', $cache->getName());

    $tpl->display();
}

function listRequestsByUserId()
{
    global $tpl, $login;

    $tpl->menuitem = MNU_MYPROFILE_ADOPT;

    $rs = sql(

        "SELECT
             `caches`.`cache_id` AS `id`,
             `caches`.`name` AS `cachename`,
             `user`.`user_id` AS `ownerid`,
             `user`.`username` AS `ownername`,
             `cache_adoption`.`date_created`
         FROM `caches`
         INNER JOIN `cache_adoption`
             ON `caches`.`cache_id` = `cache_adoption`.`cache_id`
         INNER JOIN `user`
             ON `caches`.`user_id`=`user`.`user_id`
         WHERE `cache_adoption`.`user_id`='&1'",
        $login->userid
    );
    $tpl->assign_rs('adoptions', $rs);
    sql_free_result($rs);


    $tpl->display();
}

/**
 * @param $cacheId
 * @param $userId
 */
function addRequest($cacheId, $userId)
{
    global $tpl;

    // cache exists?
    $cache = new cache($cacheId);
    if ($cache->exist() == false) {
        $tpl->error(ERROR_CACHE_NOT_EXISTS);
    }

    $adopt_result = $cache->addAdoption($userId);
    if ($adopt_result === true) {
        $tpl->redirect('adoptcache.php?action=listbycache&cacheid=' . $cacheId);
    } else {
        $tpl->assign('error', $adopt_result);
        listRequestsByCacheId($cacheId);
    }
}

/**
 * @param $cacheId
 */
function commitRequest($cacheId)
{
    global $tpl, $login;

    // cache exists?
    $cache = new cache($cacheId);
    if ($cache->exist() == false) {
        $tpl->error(ERROR_CACHE_NOT_EXISTS);
    }

    if ($cache->commitAdoption($login->userid) == false) {
        $tpl->error(ERROR_UNKNOWN);
    }

    $tpl->redirect('viewcache.php?cacheid=' . $cacheId);
}

/**
 * @param $cacheId
 * @param $userId
 */
function cancelRequest($cacheId, $userId)
{
    global $tpl, $login;

    // cache exists?
    $cache = new cache($cacheId);
    if ($cache->exist() == false) {
        $tpl->error(ERROR_CACHE_NOT_EXISTS);
    }

    if ($cache->allowEdit() == false && $login->userid != $userId) {
        $tpl->error(ERROR_NO_ACCESS);
    }

    if ($cache->cancelAdoption($userId) == false) {
        $tpl->error(ERROR_UNKNOWN);
    }

    if ($userId == $login->userid) {
        $tpl->redirect('adoptcache.php');
    } else {
        $tpl->redirect('adoptcache.php?action=listbycache&cacheid=' . $cacheId);
    }
}


1		<?php
2		/***************************************************************************
3		* for license information see LICENSE.md
4		***************************************************************************/
5
6		require __DIR__ . '/lib2/web.inc.php';
7
8		$tpl->name = 'adoptcache';
9		$tpl->menuitem = MNU_CACHES_ADOPT;
10
11		$login->verify();
12		if ($login->userid == 0) {
13		$tpl->redirect_login();
14		}
15
16		$action = isset($_REQUEST['action']) ? $_REQUEST['action'] : 'listbyuser';
17		$cacheId = isset($_REQUEST['cacheid']) ? (int) $_REQUEST['cacheid'] : 0;
18		$tpl->assign('action', $action);
19		$tpl->assign('error', '');
20		if (isset($_REQUEST['cacheid'])) {
21		$tpl->assign('cacheid', (int) $_REQUEST['cacheid']);
22		}
23
24		if ($action === 'listbycache') {
25		listRequestsByCacheId($cacheId);
26		} elseif ($action === 'add') {
27		$tpl->assign('action', 'listbycache');
28
29		$tou = isset($_REQUEST['tou']) ? (int) $_REQUEST['tou'] : 0;
30		$submit = isset($_REQUEST['submit']) ? (int) $_REQUEST['submit'] : 0;
31
32		$username = isset($_REQUEST['username']) ? $_REQUEST['username'] : '';
33		$tpl->assign('adoptusername', $username);
34
35		if ($submit === 1) {
36		$userId = (int) sql_value("SELECT `user_id` FROM `user` WHERE `username`='&1'", 0, $username);
		0 ignored issues – show Deprecated Code introduced 2017-10-17 14:32 UTC by Report Bug Copy Issue Report Show Similar Issues like this The function `sql_value()` has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation This function has been deprecated. The supplier of the file has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the function will be removed from the class and what other function to use instead. Loading history...
37		if ($userId === 0) {
38		$tpl->assign('error', 'userunknown');
39		} elseif ($tou !== 1) {
40		$tpl->assign('error', 'tou');
41		} else {
42		addRequest($cacheId, $userId);
43		}
44		}
45
46		listRequestsByCacheId($cacheId);
47		} elseif ($action === 'cancel') {
48		$userId = isset($_REQUEST['userid']) ? (int) $_REQUEST['userid']: 0;
49		cancelRequest($cacheId, $userId);
50		} elseif ($action === 'commit') {
51		$submit = isset($_REQUEST['submit']) ? (int) $_REQUEST['submit'] : 0;
52		$tou = isset($_REQUEST['tou']) ? (int) $_REQUEST['tou'] : 0;
53
54		if ($submit === 1 && $tou === 1) {
55		commitRequest($cacheId);
56		} else {
57		showAdoptScreen($cacheId, $submit);
58		}
59		} else {
60		$tpl->assign('action', 'listbyuser');
61		listRequestsByUserId();
62		}
63
64		$tpl->error(ERROR_UNKNOWN);
65
66		/**
67		* @param $cacheId
68		* @param $touError
69		*/
70		function showAdoptScreen($cacheId, $touError)
71		{
72		global $tpl, $login;
73
74		$rs = sql(
		0 ignored issues – show Deprecated Code introduced 2017-10-17 14:32 UTC by Report Bug Copy Issue Report Show Similar Issues like this The function `sql()` has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation This function has been deprecated. The supplier of the file has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the function will be removed from the class and what other function to use instead. Loading history...
75		"SELECT `caches`.`name`,
76		`user`.`username`,
77		`cache_adoption`.`date_created`
78		FROM `caches`
79		INNER JOIN `user` ON `caches`.`user_id`=`user`.`user_id`
80		INNER JOIN `cache_adoption` ON `caches`.`cache_id`=`cache_adoption`.`cache_id`
81		WHERE `caches`.`cache_id`='&1'
82		AND `cache_adoption`.`user_id`='&2'",
83		$cacheId,
84		$login->userid
85		);
86		$r = sql_fetch_assoc($rs);
		0 ignored issues – show Deprecated Code introduced 2017-10-17 14:32 UTC by Report Bug Copy Issue Report Show Similar Issues like this The function `sql_fetch_assoc()` has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation This function has been deprecated. The supplier of the file has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the function will be removed from the class and what other function to use instead. Loading history...
87		if ($r === false) {
88		$tpl->error(ERROR_NO_ACCESS);
89		}
90
91		$tpl->assign('cache', $r);
92		sql_free_result($rs);
		0 ignored issues – show Deprecated Code introduced 2017-10-17 14:32 UTC by Report Bug Copy Issue Report Show Similar Issues like this The function `sql_free_result()` has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation This function has been deprecated. The supplier of the file has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the function will be removed from the class and what other function to use instead. Loading history...
93
94		if ($touError != 0) {
95		$tpl->assign('error', 'tou');
96		}
97
98		$tpl->display();
99		}
100
101		/**
102		* @param $cacheId
103		*/
104		function listRequestsByCacheId($cacheId)
105		{
106		global $tpl, $login;
107
108		// cache exists?
109		$cache = new cache($cacheId);
110		if ($cache->exist() == false) {
111		$tpl->error(ERROR_CACHE_NOT_EXISTS);
112		}
113
114		// is the current user the owner of the cache?
115		if ($cache->getUserId() != $login->userid) {
116		$tpl->error(ERROR_NO_ACCESS);
117		}
118
119		$rs = sql(
		0 ignored issues – show Deprecated Code introduced 2017-10-17 14:32 UTC by Report Bug Copy Issue Report Show Similar Issues like this The function `sql()` has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation This function has been deprecated. The supplier of the file has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the function will be removed from the class and what other function to use instead. Loading history...
120		"SELECT
121		`caches`.`cache_id` AS `id`,
122		`user`.`user_id` AS `userid`,
123		`user`.`username` AS `username`,
124		`cache_adoption`.`date_created`
125		FROM `caches`
126		INNER JOIN `cache_adoption`
127		ON `caches`.`cache_id` = `cache_adoption`.`cache_id`
128		INNER JOIN `user`
129		ON `cache_adoption`.`user_id`=`user`.`user_id`
130		WHERE `caches`.`cache_id`='&1'",
131		$cacheId
132		);
133		$tpl->assign_rs('adoptions', $rs);
134		sql_free_result($rs);
		0 ignored issues – show Deprecated Code introduced 2017-10-17 14:32 UTC by Report Bug Copy Issue Report Show Similar Issues like this The function `sql_free_result()` has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation This function has been deprecated. The supplier of the file has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the function will be removed from the class and what other function to use instead. Loading history...
135
136		$tpl->assign('cachename', $cache->getName());
137
138		$tpl->display();
139		}
140
141	View Code Duplication	function listRequestsByUserId()
142		{
143		global $tpl, $login;
144
145		$tpl->menuitem = MNU_MYPROFILE_ADOPT;
146
147		$rs = sql(
		0 ignored issues – show Deprecated Code introduced 2017-10-17 14:32 UTC by Report Bug Copy Issue Report Show Similar Issues like this The function `sql()` has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation This function has been deprecated. The supplier of the file has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the function will be removed from the class and what other function to use instead. Loading history...
148		"SELECT
149		`caches`.`cache_id` AS `id`,
150		`caches`.`name` AS `cachename`,
151		`user`.`user_id` AS `ownerid`,
152		`user`.`username` AS `ownername`,
153		`cache_adoption`.`date_created`
154		FROM `caches`
155		INNER JOIN `cache_adoption`
156		ON `caches`.`cache_id` = `cache_adoption`.`cache_id`
157		INNER JOIN `user`
158		ON `caches`.`user_id`=`user`.`user_id`
159		WHERE `cache_adoption`.`user_id`='&1'",
160		$login->userid
161		);
162		$tpl->assign_rs('adoptions', $rs);
163		sql_free_result($rs);
		0 ignored issues – show Deprecated Code introduced 2017-10-17 14:32 UTC by Report Bug Copy Issue Report Show Similar Issues like this The function `sql_free_result()` has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation This function has been deprecated. The supplier of the file has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the function will be removed from the class and what other function to use instead. Loading history...
164
165		$tpl->display();
166		}
167
168		/**
169		* @param $cacheId
170		* @param $userId
171		*/
172		function addRequest($cacheId, $userId)
173		{
174		global $tpl;
175
176		// cache exists?
177		$cache = new cache($cacheId);
178		if ($cache->exist() == false) {
179		$tpl->error(ERROR_CACHE_NOT_EXISTS);
180		}
181
182		$adopt_result = $cache->addAdoption($userId);
183		if ($adopt_result === true) {
184		$tpl->redirect('adoptcache.php?action=listbycache&cacheid=' . $cacheId);
185		} else {
186		$tpl->assign('error', $adopt_result);
187		listRequestsByCacheId($cacheId);
188		}
189		}
190
191		/**
192		* @param $cacheId
193		*/
194		function commitRequest($cacheId)
195		{
196		global $tpl, $login;
197
198		// cache exists?
199		$cache = new cache($cacheId);
200		if ($cache->exist() == false) {
201		$tpl->error(ERROR_CACHE_NOT_EXISTS);
202		}
203
204		if ($cache->commitAdoption($login->userid) == false) {
205		$tpl->error(ERROR_UNKNOWN);
206		}
207
208		$tpl->redirect('viewcache.php?cacheid=' . $cacheId);
209		}
210
211		/**
212		* @param $cacheId
213		* @param $userId
214		*/
215		function cancelRequest($cacheId, $userId)
216		{
217		global $tpl, $login;
218
219		// cache exists?
220		$cache = new cache($cacheId);
221		if ($cache->exist() == false) {
222		$tpl->error(ERROR_CACHE_NOT_EXISTS);
223		}
224
225		if ($cache->allowEdit() == false && $login->userid != $userId) {
226		$tpl->error(ERROR_NO_ACCESS);
227		}
228
229		if ($cache->cancelAdoption($userId) == false) {
230		$tpl->error(ERROR_UNKNOWN);
231		}
232
233		if ($userId == $login->userid) {
234		$tpl->redirect('adoptcache.php');
235		} else {
236		$tpl->redirect('adoptcache.php?action=listbycache&cacheid=' . $cacheId);
237		}
238		}
239

OpencachingDeutschland / oc-server3

Push — development ( f93eb8...ffa1a0 )

htdocs/adoptcache.php (8 issues)

Labels

Severity

Introduced By

Upgrade to new PHP Analysis Engine

Duplication Side-by-Side

Filter issues like