private function login($username, $password)
{
$connection = parent::getConnection();
$sql = "Select * from user where username = '******' and password='******'";
$sql_result = mysqli_query($connection, $sql) or exit("Sql Error" . mysqli_error($connection));
while ($sql_row = mysqli_fetch_array($sql_result)) {
$albumSql = "Select a.* from album a,albumuser au where a.id=au.idalbum and au.iduser="******"Sql Error" . mysqli_error($connection));
$albums = array();
while ($sql_albumRow = mysqli_fetch_array($sql_albumResult)) {
$album = new Album($sql_albumRow['id'], $sql_albumRow['key'], $sql_albumRow['stickercount']);
$albums[$sql_albumRow['id']] = $album;
}
$user = new User($sql_row['id'], $sql_row['username'], $sql_row['firstname'], $sql_row['lastname'], $albums);
return $user;
}
return null;
}
private function getMatch($albumId)
{
$connection = parent::getConnection();
$sql = "SELECT d.iduser as uid, concat(u.firstname, ' ', u.lastname) as fullname, group_concat(m.stickernumber SEPARATOR ',') as idstickers\n \t FROM missing m \n \t\t\t\t\tLEFT OUTER JOIN duplicate d ON \n \t\t\t\t\t\t\t\tm.stickernumber = d.stickernumber \n \t\t\t\t\t\tand m.idalbum = d.idalbum \n \t\t\t\t\t\tand m.idalbum = " . mysqli_escape_string($connection, $albumId) . " \n \t\t\t\t\t\tand d.copy > 0\n \t\t\t\t\t\tand d.iduser in (SELECT id from user where active=1)\n \t LEFT OUTER JOIN user u ON u.id = d.iduser\n \t\t\t\t\tWHERE m.iduser = "******"\n \t\t\t\t and m.idalbum = " . mysqli_escape_string($connection, $albumId) . " \n \t\t\t\t\tGROUP by d.iduser";
$sql_result = mysqli_query($connection, $sql) or exit("Sql Error" . mysqli_error($connection));
$pair = array();
while ($sql_row = mysqli_fetch_array($sql_result)) {
$pair['uid'] = $sql_row["uid"];
$pair['fullname'] = $sql_row["fullname"];
$pair['stickers'] = explode(",", $sql_row["idstickers"]);
$result[] = $pair;
}
$returnArray = array();
$returnArray['type'] = "match";
$returnArray['data'] = $result;
return $returnArray;
}
function processInternal($urlRewrite)
{
$connection = parent::getConnection();
$allAlbums = $this->getAllAlbums($connection);
return array('render' => true, 'allAlbums' => $allAlbums);
}
