<?php
# partners1
case
'partners1'
:
$design
=
new
design (
'Admins Area'
,
'Admins Area'
, 2 );
$design
->header();
$tpl
=
new
tpl (
'archiv/partners1'
, 1);
# loeschen
if
(
$menu
->getA(2) ==
'd'
) {
$pos
= db_result(db_query(
"SELECT pos FROM prefix_partners1 WHERE id = "
.
$menu
->getE(2)), 0);
db_query(
"DELETE FROM prefix_partners1 WHERE id = "
.
$menu
->getE(2));
db_query(
"UPDATE prefix_partners1 SET pos = pos -1 WHERE pos > "
.
$pos
);
}
# aendern / eintragen
if
( isset(
$_POST
[
'sub'
]) ) {
$_POST
[
'name'
] = escape(
$_POST
[
'name'
],
'string'
);
$_POST
[
'banner'
] = escape(
$_POST
[
'banner'
],
'string'
);
$_POST
[
'link'
] = get_homepage(escape(
$_POST
[
'link'
],
'string'
));
if
(
empty
(
$_POST
[
'pkey'
]) ) {
$_POST
[
'pos'
] = db_result(db_query(
"SELECT COUNT(*) FROM prefix_partners1"
),0);
db_query(
"INSERT INTO prefix_partners1 (name,banner,link,pos) VALUES ('"
.
$_POST
['name
']."'
,
'".$_POST['
banner
']."'
,
'".$_POST['
link
']."'
,
'".$_POST['
pos
']."'
)");
}
else
{
db_query(
"UPDATE prefix_partners1 SET name = '"
.
$_POST
['name
']."'
,banner =
'".$_POST['
banner
']."'
,link =
'".$_POST['
link
']."'
WHERE id =
'".$_POST['
pkey
']."'
");
}
}
# verschieben
if
(
$menu
->getA(2) ==
'o'
OR
$menu
->getA(2) ==
'u'
) {
$pos
=
$menu
->get(3);
$id
=
$menu
->getE(2);
$nps
= (
$menu
->getA(2) ==
'u'
?
$pos
+ 1 :
$pos
- 1 );
$anz
= db_result(db_query(
"SELECT COUNT(*) FROM prefix_partners1"
),0);
if
(
$nps
< 0) {
db_query(
"UPDATE prefix_partners1 SET pos = "
.
$anz
.
" WHERE id = "
.
$id
);
db_query(
"UPDATE prefix_partners1 SET pos = pos -1"
);
}
if
(
$nps
>=
$anz
) {
db_query(
"UPDATE prefix_partners1 SET pos = -1 WHERE id = "
.
$id
);
db_query(
"UPDATE prefix_partners1 SET pos = pos +1"
);
}
if
(
$nps
<
$anz
AND
$nps
>= 0 ) {
db_query(
"UPDATE prefix_partners1 SET pos = "
.
$pos
.
" WHERE pos = "
.
$nps
);
db_query(
"UPDATE prefix_partners1 SET pos = "
.
$nps
.
" WHERE id = "
.
$id
);
}
}
# aendern vorbereiten.
if
(
$menu
->getA(2) ==
'e'
) {
$erg
= db_query(
"SELECT id,name,banner,link FROM prefix_partners1 WHERE id = '"
.
$menu
->getE(2).
"'"
);
$_ilch
= db_fetch_assoc(
$erg
);
$_ilch
[
'pkey'
] =
$menu
->getE(2);
}
else
{
$_ilch
=
array
(
'pkey'
=>
''
,
'id'
=>
''
,
'banner'
=>
''
,
'name'
=>
''
,
'link'
=>
''
);
}
$tpl
->set_ar_out(
$_ilch
,0);
$page
= (
$menu
->getA(2) ==
'p'
?
$menu
->getE(2) : 1 );
$limit
= 20;
$class
=
'Cnorm'
;
$MPL
= db_make_sites (
$page
,
''
,
$limit
,
'?archiv-partners1'
,
'partners1'
);
$anfang
= (
$page
- 1) *
$limit
;
$abf
=
"SELECT id,name,link, pos FROM prefix_partners1 ORDER BY pos ASC LIMIT "
.
$anfang
.
","
.
$limit
;
$erg
= db_query(
$abf
);
while
(
$row
= db_fetch_assoc(
$erg
) ) {
$class
= (
$class
==
'Cmite'
?
'Cnorm'
:
'Cmite'
);
$row
[
'class'
] =
$class
;
$tpl
->set_ar (
$row
);
$tpl
->out(1);
}
$tpl
->set (
'MPL'
,
$MPL
);
$tpl
->out(2);
$design
->footer();
break
;
# partners2
case
'partners2'
:
$design
=
new
design (
'Admins Area'
,
'Admins Area'
, 2 );
$design
->header();
$tpl
=
new
tpl (
'archiv/partners2'
, 1);
# loeschen
if
(
$menu
->getA(2) ==
'd'
) {
$pos
= db_result(db_query(
"SELECT pos FROM prefix_partners2 WHERE id = "
.
$menu
->getE(2)), 0);
db_query(
"DELETE FROM prefix_partners2 WHERE id = "
.
$menu
->getE(2));
db_query(
"UPDATE prefix_partners2 SET pos = pos -1 WHERE pos > "
.
$pos
);
}
# aendern / eintragen
if
( isset(
$_POST
[
'sub'
]) ) {
$_POST
[
'name'
] = escape(
$_POST
[
'name'
],
'string'
);
$_POST
[
'banner'
] = escape(
$_POST
[
'banner'
],
'string'
);
$_POST
[
'link'
] = get_homepage(escape(
$_POST
[
'link'
],
'string'
));
if
(
empty
(
$_POST
[
'pkey'
]) ) {
$_POST
[
'pos'
] = db_result(db_query(
"SELECT COUNT(*) FROM prefix_partners2"
),0);
db_query(
"INSERT INTO prefix_partners2 (name,banner,link,pos) VALUES ('"
.
$_POST
['name
']."'
,
'".$_POST['
banner
']."'
,
'".$_POST['
link
']."'
,
'".$_POST['
pos
']."'
)");
}
else
{
db_query(
"UPDATE prefix_partners2 SET name = '"
.
$_POST
['name
']."'
,banner =
'".$_POST['
banner
']."'
,link =
'".$_POST['
link
']."'
WHERE id =
'".$_POST['
pkey
']."'
");
}
}
# verschieben
if
(
$menu
->getA(2) ==
'o'
OR
$menu
->getA(2) ==
'u'
) {
$pos
=
$menu
->get(3);
$id
=
$menu
->getE(2);
$nps
= (
$menu
->getA(2) ==
'u'
?
$pos
+ 1 :
$pos
- 1 );
$anz
= db_result(db_query(
"SELECT COUNT(*) FROM prefix_partners2"
),0);
if
(
$nps
< 0) {
db_query(
"UPDATE prefix_partners2 SET pos = "
.
$anz
.
" WHERE id = "
.
$id
);
db_query(
"UPDATE prefix_partners2 SET pos = pos -1"
);
}
if
(
$nps
>=
$anz
) {
db_query(
"UPDATE prefix_partners2 SET pos = -1 WHERE id = "
.
$id
);
db_query(
"UPDATE prefix_partners2 SET pos = pos +1"
);
}
if
(
$nps
<
$anz
AND
$nps
>= 0 ) {
db_query(
"UPDATE prefix_partners2 SET pos = "
.
$pos
.
" WHERE pos = "
.
$nps
);
db_query(
"UPDATE prefix_partners2 SET pos = "
.
$nps
.
" WHERE id = "
.
$id
);
}
}
# aendern vorbereiten.
if
(
$menu
->getA(2) ==
'e'
) {
$erg
= db_query(
"SELECT id,name,banner,link FROM prefix_partners2 WHERE id = '"
.
$menu
->getE(2).
"'"
);
$_ilch
= db_fetch_assoc(
$erg
);
$_ilch
[
'pkey'
] =
$menu
->getE(2);
}
else
{
$_ilch
=
array
(
'pkey'
=>
''
,
'id'
=>
''
,
'banner'
=>
''
,
'name'
=>
''
,
'link'
=>
''
);
}
$tpl
->set_ar_out(
$_ilch
,0);
$page
= (
$menu
->getA(2) ==
'p'
?
$menu
->getE(2) : 1 );
$limit
= 20;
$class
=
'Cnorm'
;
$MPL
= db_make_sites (
$page
,
''
,
$limit
,
'?archiv-partners2'
,
'partners2'
);
$anfang
= (
$page
- 1) *
$limit
;
$abf
=
"SELECT id,name,link, pos FROM prefix_partners2 ORDER BY pos ASC LIMIT "
.
$anfang
.
","
.
$limit
;
$erg
= db_query(
$abf
);
while
(
$row
= db_fetch_assoc(
$erg
) ) {
$class
= (
$class
==
'Cmite'
?
'Cnorm'
:
'Cmite'
);
$row
[
'class'
] =
$class
;
$tpl
->set_ar (
$row
);
$tpl
->out(1);
}
$tpl
->set (
'MPL'
,
$MPL
);
$tpl
->out(2);
$design
->footer();
break
;
# partners3
case
'partners3'
:
$design
=
new
design (
'Admins Area'
,
'Admins Area'
, 2 );
$design
->header();
$tpl
=
new
tpl (
'archiv/partners3'
, 1);
# loeschen
if
(
$menu
->getA(2) ==
'd'
) {
$pos
= db_result(db_query(
"SELECT pos FROM prefix_partners3 WHERE id = "
.
$menu
->getE(2)), 0);
db_query(
"DELETE FROM prefix_partners3 WHERE id = "
.
$menu
->getE(2));
db_query(
"UPDATE prefix_partners3 SET pos = pos -1 WHERE pos > "
.
$pos
);
}
# aendern / eintragen
if
( isset(
$_POST
[
'sub'
]) ) {
$_POST
[
'name'
] = escape(
$_POST
[
'name'
],
'string'
);
$_POST
[
'banner'
] = escape(
$_POST
[
'banner'
],
'string'
);
$_POST
[
'link'
] = get_homepage(escape(
$_POST
[
'link'
],
'string'
));
if
(
empty
(
$_POST
[
'pkey'
]) ) {
$_POST
[
'pos'
] = db_result(db_query(
"SELECT COUNT(*) FROM prefix_partners3"
),0);
db_query(
"INSERT INTO prefix_partners3 (name,banner,link,pos) VALUES ('"
.
$_POST
['name
']."'
,
'".$_POST['
banner
']."'
,
'".$_POST['
link
']."'
,
'".$_POST['
pos
']."'
)");
}
else
{
db_query(
"UPDATE prefix_partners3 SET name = '"
.
$_POST
['name
']."'
,banner =
'".$_POST['
banner
']."'
,link =
'".$_POST['
link
']."'
WHERE id =
'".$_POST['
pkey
']."'
");
}
}
# verschieben
if
(
$menu
->getA(2) ==
'o'
OR
$menu
->getA(2) ==
'u'
) {
$pos
=
$menu
->get(3);
$id
=
$menu
->getE(2);
$nps
= (
$menu
->getA(2) ==
'u'
?
$pos
+ 1 :
$pos
- 1 );
$anz
= db_result(db_query(
"SELECT COUNT(*) FROM prefix_partners3"
),0);
if
(
$nps
< 0) {
db_query(
"UPDATE prefix_partners3 SET pos = "
.
$anz
.
" WHERE id = "
.
$id
);
db_query(
"UPDATE prefix_partners3 SET pos = pos -1"
);
}
if
(
$nps
>=
$anz
) {
db_query(
"UPDATE prefix_partners3 SET pos = -1 WHERE id = "
.
$id
);
db_query(
"UPDATE prefix_partners3 SET pos = pos +1"
);
}
if
(
$nps
<
$anz
AND
$nps
>= 0 ) {
db_query(
"UPDATE prefix_partners3 SET pos = "
.
$pos
.
" WHERE pos = "
.
$nps
);
db_query(
"UPDATE prefix_partners3 SET pos = "
.
$nps
.
" WHERE id = "
.
$id
);
}
}
# aendern vorbereiten.
if
(
$menu
->getA(2) ==
'e'
) {
$erg
= db_query(
"SELECT id,name,banner,link FROM prefix_partners3 WHERE id = '"
.
$menu
->getE(2).
"'"
);
$_ilch
= db_fetch_assoc(
$erg
);
$_ilch
[
'pkey'
] =
$menu
->getE(2);
}
else
{
$_ilch
=
array
(
'pkey'
=>
''
,
'id'
=>
''
,
'banner'
=>
''
,
'name'
=>
''
,
'link'
=>
''
);
}
$tpl
->set_ar_out(
$_ilch
,0);
$page
= (
$menu
->getA(2) ==
'p'
?
$menu
->getE(2) : 1 );
$limit
= 20;
$class
=
'Cnorm'
;
$MPL
= db_make_sites (
$page
,
''
,
$limit
,
'?archiv-partners3'
,
'partners3'
);
$anfang
= (
$page
- 1) *
$limit
;
$abf
=
"SELECT id,name,link, pos FROM prefix_partners3 ORDER BY pos ASC LIMIT "
.
$anfang
.
","
.
$limit
;
$erg
= db_query(
$abf
);
while
(
$row
= db_fetch_assoc(
$erg
) ) {
$class
= (
$class
==
'Cmite'
?
'Cnorm'
:
'Cmite'
);
$row
[
'class'
] =
$class
;
$tpl
->set_ar (
$row
);
$tpl
->out(1);
}
$tpl
->set (
'MPL'
,
$MPL
);
$tpl
->out(2);
$design
->footer();
break
;
}
?>