function getRecords($con, $where, $orderby, $limit, $offset, $pagesize, &$rowcount)
{
$sql_where = getWhere($where);
$sql_orderby = getOrderBy($orderby, $count);
$sql_limit = getLimit($limit, 0);
$sql_page = getLimit($pagesize, $offset);
if ($limit) {
if ($pagesize) {
$sql = "SELECT * FROM phones " . $sql_where . $sql_orderby . $sql_limit;
$sql = "select * from ( " . $sql . " ) a " . $sql_page;
$records = fetchRows($con, $sql);
if (!$records) {
return false;
}
$rc_sql = "SELECT 1 FROM phones " . $sql_where . $sql_limit;
$rc_sql = "select count(*) AS rowcount from ( " . $rc_sql . " ) rc";
$rowcount = fetchRowCount($con, $rc_sql);
if (!$rowcount) {
return false;
}
return $records;
}
$sql = "SELECT * FROM phones " . $sql_where . $sql_orderby . $sql_limit;
$records = fetchRows($con, $sql);
$rowcount = count($records);
return $records;
}
if ($pagesize) {
$sql = "SELECT * FROM phones " . $sql_where . $sql_orderby . $sql_page;
$records = fetchRows($con, $sql);
if (!$records) {
return false;
}
$rc_sql = "SELECT 1 FROM phones " . $sql_where;
$rc_sql = "select count(*) AS rowcount from ( " . $rc_sql . " ) rc";
$rowcount = fetchRowCount($con, $rc_sql);
if (!$rowcount) {
return false;
}
return $records;
}
$sql = "SELECT * FROM phones " . $sql_where . $sql_orderby;
$records = fetchRows($con, $sql);
if (!$records) {
return false;
}
$rowcount = count($records);
return $records;
}
function shareListUser($conn, $userID, $user, $listID)
{
$message = "Failed";
$sql = "SELECT `ID` FROM `UserInfo` WHERE `email`=? OR `username`=?";
$rows_ID = fetchRows($conn, $sql, 'ss', $user, $user);
if (count($rows_ID) == 1) {
$uid = intval($rows_ID[0]['ID']);
$sql = "INSERT INTO `UserList`(`UserID`, `ListID`) VALUES (?,?)";
if (modifyRows($conn, $sql, 'ii', $uid, $listID)) {
$message = "OK";
} else {
$message = "List is already assigned or something went wrong.";
}
} else {
if ($num_result == 0) {
$message = "User not found";
} else {
$message = "There was a mismatch";
}
}
return $message;
}
function GetAuthLevelEoC($name)
{
$query = 'SELECT
account.`status`
FROM
account
WHERE
account.`name` = "' . $name . '"';
$result = mysql_query($query);
$status = fetchRows($result)[0]['status'];
return $status;
}
