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); }