<?php
defined (
'main'
)
or
die
(
'no direct access'
);
defined (
'admin'
)
or
die
(
'only admin access'
);
$design
=
new
design (
'Admins Area'
,
'Admins Area'
, 2 );
$design
->header();
$tpl
=
new
tpl (
'radio/djs.htm'
, 1);
if
(
$menu
->getA(1) ==
'd'
)
{
$id
= escape(
$menu
->getE(1),
'integer'
);
$test
= db_query(
"SELECT `userid` FROM `prefix_radio_djs` WHERE `userid` = '$id'"
);
if
(!
$test
)
{
$mid1
= db_result(db_query(
"SELECT `id` FROM `prefix_modules` WHERE `url` = 'sendeplan'"
));
$mid2
= db_result(db_query(
"SELECT `id` FROM `prefix_modules` WHERE `url` = 'wunschgruss'"
));
db_query(
"DELETE FROM `prefix_radio_djs` WHERE `userid` = '$id'"
);
db_query(
"DELETE FROM `prefix_modulerights` WHERE `uid` = '$id' AND (`mid` = '$mid1' OR `mid` = '$mid2')"
);
wd(
'admin.php?djs'
,
'Erfolgreich ausgetragen.'
);
}
else
{
wd(
'admin.php?djs'
,
'Dieser DJ ist nicht eingetragen!'
);
}
}
elseif
(isset(
$_POST
[
'save'
]))
{
$name
= escape(
$_POST
[
'name'
],
'string'
);
$id
= @db_result(db_query(
"SELECT `id` FROM `prefix_user` WHERE `name` = '$name'"
));
if
(!
$id
)
{
wd(
'admin.php?djs'
,
'Diesen User gibt es nicht.'
);
}
else
{
$test
= db_query(
"SELECT `userid` FROM `prefix_radio_djs` WHERE `userid` = '$id'"
);
if
(db_num_rows(
$test
) == 0)
{
$mid1
= db_result(db_query(
"SELECT `id` FROM `prefix_modules` WHERE `url` = 'sendeplan'"
));
$mid2
= db_result(db_query(
"SELECT `id` FROM `prefix_modules` WHERE `url` = 'wunschgruss'"
));
db_query(
"INSERT INTO `prefix_radio_djs` (`userid`) VALUES ('$id')"
);
db_query(
"INSERT INTO `prefix_modulerights` (`uid`,`mid`) VALUES ('$id','$mid1'),('$id','$mid2')"
);
wd(
'admin.php?djs'
,
'Neuer DJ wurde hinzugefügt.'
);
}
else
{
wd(
'admin.php?djs'
,
'Dieser User ist bereits als DJ eingetragen.'
);
}
}
}
else
{
$tpl
->out(0);
$limit
= 10;
$page
= (
$menu
->getA(1) ==
'p'
?
$menu
->getE(1) : 1 );
$MPL
= db_make_sites (
$page
,
''
,
$limit
,
"?djs"
,
'radio_djs'
);
$anfang
= (
$page
- 1) *
$limit
;
$q
= db_query(
"SELECT `a`.`name`,`a`.`id` FROM `prefix_radio_djs` b LEFT JOIN `prefix_user` a ON `b`.`userid` = `a`.`id` LIMIT $anfang,$limit"
);
while
(
$row
= db_fetch_assoc(
$q
))
{
$tpl
->set(
'DJID'
,
$row
[
'id'
]);
$tpl
->set(
'DJ'
,
$row
[
'name'
]);
$tpl
->out(1);
}
$tpl
->set(
'MPL'
,
$MPL
);
$tpl
->out(2);
}
require_once
(
'include/includes/class/scRadioModul.php'
);
echo
getCopyright(false);
$design
->footer();
?>