function __construct()
{
db_connect();
$selected_group = (int) @$_REQUEST['selected_group'];
$add_new = @$_REQUEST['selected_group'] == 'new';
if (isset($_GET['delete'])) {
$id = (int) $_GET['delete'];
$query = "DELETE FROM `groups` WHERE id={$id}";
if (!($result = mysql_query($query))) {
die(mysql_error());
}
unlink("../costumes/groups/{$id}.jpg");
header('Location: grupy');
}
if (count($_POST)) {
$group = mysql_escape_string($_POST['group']);
$sort = (int) $_POST['sort'];
if ($add_new == true) {
$query = "INSERT INTO `groups` (`id`, `group`, `sort`) VALUES (0, '{$group}', {$sort})";
if (!($result = mysql_query($query))) {
die(mysql_error());
}
$selected_group = mysql_insert_id();
} else {
$query = "UPDATE `groups` SET `group`='{$group}', `sort`={$sort} WHERE `id`={$selected_group}";
if (!($result = mysql_query($query))) {
die(mysql_error());
}
}
if (@$_FILES['cover']['tmp_name']) {
Obrazek::zmniejsziwytnij($_FILES['cover']['tmp_name'], "../costumes/groups/{$selected_group}.jpg", 120, 180);
}
header('Location: grupy#group-' . $selected_group);
}
if ($selected_group == 0 && $add_new == false) {
$this->groups = array();
$query = "SELECT * FROM `groups` ORDER BY sort ASC";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
$this->groups[] = $row;
}
} else {
$this->template = "grupa";
if ($add_new) {
$this->group = array('id' => 'new', 'group' => '', 'sort' => '');
} else {
$query = "SELECT * FROM `groups` WHERE id={$selected_group}";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$this->group = $row;
}
$this->show();
exit;
}
}
function __construct()
{
db_connect();
// wyrbane zdjecie
$selected_photo = (int) @$_REQUEST['selected_photo'];
//czy jest to opcja dodawania
$add_new = @$_REQUEST['selected_photo'] == 'new';
// kasowanie elementu
if (isset($_GET['delete'])) {
$id = (int) $_GET['delete'];
//wyrzucamy wpis z bazy
$query = "DELETE FROM `photos` WHERE id={$id}";
if (!($result = mysql_query($query))) {
die(mysql_error());
}
//kasujemy pliki
unlink("../costumes/large/{$id}.jpg");
unlink("../costumes/thumb/{$id}.jpg");
//przekierowujemy z powrotem na liste
header('Location: kostiumy');
}
// jeżeli został wysłany formularz to edytujemy/zmieniamy
if (count($_POST)) {
// pobieramy wysłane wartosci
$id_group = (int) $_POST['id_group'];
$name = mysql_escape_string($_POST['name']);
$stars = (int) $_POST['stars'];
// jezeli dodajemy
if ($add_new == true) {
$query = "INSERT INTO photos (id, id_group, name, stars) VALUES (0, {$id_group}, '{$name}', {$stars})";
if (!($result = mysql_query($query))) {
die(mysql_error());
}
$selected_photo = mysql_insert_id();
} else {
$query = "UPDATE photos SET id_group={$id_group}, name='{$name}', stars={$stars} WHERE id={$selected_photo}";
if (!($result = mysql_query($query))) {
die(mysql_error());
}
}
// jezeli został wrzucony plik
if (@$_FILES['photo']['tmp_name']) {
// to robimy miniaturkę i prevke
Obrazek::zmniejsz($_FILES['photo']['tmp_name'], "../costumes/large/{$selected_photo}.jpg", 800, 600);
Obrazek::zmniejsziwytnij($_FILES['photo']['tmp_name'], "../costumes/thumb/{$selected_photo}.jpg", 120, 180);
}
// przekierowywujemy na liste kostiumów w odpowienie miejsce
// wpis po # odnosi automatcyznie do elementu o takim id na stronie
header('Location: kostiumy#costume-' . $selected_photo);
}
// jezeli nie ma wybranego zdjecia to wyrzucamy listę
if ($selected_photo == 0 && $add_new == false) {
$selected_group = 1;
$this->photos = array();
$query = "SELECT * FROM `photos` ORDER BY id_group ASC, stars DESC";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
$this->photos[] = $row;
}
} else {
$this->template = "kostium";
// jezeli nowy to zwracamy tablicę z pustymi wartosciami
if ($add_new) {
$this->photo = array('id' => 'new', 'name' => '', 'id_group' => 0, 'stars' => '');
} else {
$query = "SELECT * FROM `photos` WHERE id={$selected_photo}";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$this->photo = $row;
}
// pobieramy grupy żeby wyświetlić selectboxa z wyborem
$this->groups = array();
$query = "SELECT * FROM `groups` ORDER BY sort ASC";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
$this->groups[] = $row;
}
// wypisujemy ( tak jak w indexie tylko że bez headera i footera )
$this->show();
// i kończymy dalsze wykonywanie
exit;
}
}
