<?php
defined (
'main'
)
or
die
(
'no direct access'
);
if
(!
empty
(
$_REQUEST
[
'f'
])
and
substr
(
$_REQUEST
[
'f'
], 0, 23) !=
'include/downs/downloads'
) {
die
(
'dont try to hack'
);
}
function
archiv_links_admin_showcats (
$id
,
$stufe
) {
$q
=
"SELECT * FROM prefix_linkcats WHERE cat = "
.
$id
.
" ORDER BY pos"
;
$erg
= db_query(
$q
);
if
(db_num_rows(
$erg
) > 0) {
while
(
$row
= db_fetch_object(
$erg
)) {
echo
'<tr class="Cmite"><td>'
.
$stufe
.
'- <a href="admin.php?archiv-links-S'
.
$row
->id .
'">'
.
$row
->name .
'</a></td>'
;
echo
'<td align="center"><a href="?archiv-links-E'
.
$row
->id .
'#edit"><img src="include/images/icons/edit.gif" border="0"></a></td>'
;
echo
'<td align="center"><a href="javascript:Kdel('
.
$row
->id .
')"><img src="include/images/icons/del.gif" border="0"></a></td>'
;
echo
'<td align="center"><a href="admin.php?archiv-links-S'
.
$row
->id .
'-O'
.
$row
->id .
'-'
.
$row
->pos .
'-'
.
$row
->cat .
'"><img src="include/images/icons/pfeilo.gif" border="0"></a></td>'
;
echo
'<td align="center"><a href="admin.php?archiv-links-S'
.
$row
->id .
'-U'
.
$row
->id .
'-'
.
$row
->pos .
'-'
.
$row
->cat .
'"><img src="include/images/icons/pfeilu.gif" border="0"></a></td></tr>'
;
archiv_links_admin_showcats(
$row
->id,
$stufe
.
' '
);
}
}
}
function
archiv_links_admin_selectcats (
$id
,
$stufe
, &
$output
,
$sel
= 0) {
$q
=
"SELECT * FROM prefix_linkcats WHERE cat = "
.
$id
.
" ORDER BY pos"
;
$erg
= db_query(
$q
);
if
(db_num_rows(
$erg
) > 0) {
while
(
$row
= db_fetch_object(
$erg
)) {
$output
.=
'<option value="'
.
$row
->id .
'"'
. (
$sel
==
$row
->id?
' selected="selected"'
:
''
) .
'>'
.
$stufe
.
' '
.
$row
->name .
'</option>'
;
archiv_links_admin_selectcats(
$row
->id,
$stufe
.
'»'
,
$output
,
$sel
);
}
}
}
$um
=
$menu
->get(1);
$design
=
new
design (
$title
,
$hmenu
);
$design
->header();
$tpl
=
new
tpl (
'archiv/links_eintragen'
);
if
(!
empty
(
$_POST
[
'sub'
])) {
$_POST
[
'cat'
] = escape(
$_POST
[
'cat'
],
'integer'
);
$_POST
[
'name'
] = escape(
$_POST
[
'name'
],
'string'
);
$_POST
[
'banner'
] = escape(
$_POST
[
'banner'
],
'string'
);
$_POST
[
'desc'
] = escape(
$_POST
[
'desc'
],
'string'
);
$_POST
[
'link'
] = get_homepage(escape(
$_POST
[
'link'
],
'string'
));
if
(
empty
(
$_POST
[
'pkey'
])) {
$pos
= db_result(db_query(
"SELECT COUNT(*) FROM prefix_links WHERE cat = "
.
$_POST
[
'cat'
]), 0);
db_query(
"INSERT INTO prefix_links (cat,name,banner,`desc`,link,pos) VALUES ('"
.
$_POST
['cat
'] . "'
,
'" . $_POST['
name
'] . "'
,
'" . $_POST['
banner
'] . "'
,
'" . $_POST['
desc
'] . "'
,
'" . $_POST['
link
'] . "'
,
'" . $pos . "'
)");
}
else
{
$alt_row
= db_fetch_assoc(db_query(
"SELECT cat,pos FROM prefix_links WHERE id = "
.
$_POST
[
'pkey'
]));
if
(
$alt_row
[
'cat'
] !=
$_POST
[
'cat'
]) {
$pos
= db_result(db_query(
"SELECT COUNT(*) FROM prefix_links WHERE cat = "
.
$_POST
[
'cat'
]), 0);
}
else
{
$pos
=
$alt_row
[
'pos'
];
}
db_query(
"UPDATE prefix_links SET cat = '"
.
$_POST
['cat
'] . "'
,name =
'" . $_POST['
name
'] . "'
,pos = " .
$pos
.
", banner = '"
.
$_POST
['banner
'] . "'
,`desc` =
'" . $_POST['
desc
'] . "'
,link =
'" . $_POST['
link
'] . "'
WHERE id =
'" . $_POST['
pkey
'] . "'
");
if
(
$alt_row
[
'cat'
] !=
$_POST
[
'cat'
]) {
db_query(
"UPDATE prefix_links SET pos = pos - 1 WHERE pos > "
.
$alt_row
[
'pos'
] .
" AND cat = "
.
$alt_row
[
'cat'
]);
}
}
$azk
=
$_POST
[
'cat'
];
}
if
(
$menu
->getA(2) ==
'e'
) {
$erg
= db_query(
"SELECT id,cat,`desc`,name,banner,link FROM prefix_links WHERE id = '"
.
$menu
->getE(2) .
"'"
);
$_ilch
= db_fetch_assoc(
$erg
);
$_ilch
[
'pkey'
] =
$menu
->getE(2);
$azk
=
$_ilch
[
'cat'
];
}
else
{
if
(isset (
$azk
)) {
$c
=
$azk
;
}
elseif
(
$menu
->getA(2) ==
'S'
OR
$menu
->getA(2) ==
'E'
) {
$c
=
$menu
->getE(2);
}
else
{
$c
= 0;
}
$_ilch
=
array
(
'pkey'
=>
''
,
'id'
=>
''
,
'banner'
=>
''
,
'name'
=>
''
,
'desc'
=>
''
,
'link'
=>
''
,
'cat'
=>
$c
);
unset(
$c
);
}
archiv_links_admin_selectcats(
'0'
,
''
,
$_ilch
[
'cat'
],
$_ilch
[
'cat'
]);
$_ilch
[
'cat'
] =
'<option value="0">Keine</option>'
.
$_ilch
[
'cat'
];
if
(!isset(
$azk
)) {
$azk
= 0;
if
(
$menu
->getA(2) ==
'S'
OR
$menu
->getA(2) ==
'E'
) {
$azk
=
$menu
->getE(2);
}
}
$tpl
->out(0);
$class
= 0;
$abf
=
"SELECT id,name,link,cat,pos FROM prefix_links WHERE cat = "
.
$azk
.
" ORDER BY pos"
;
$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
->out(2);
if
(
$menu
->getA(2) ==
'E'
) {
$erg
= db_query(
"SELECT id,cat as Ccat, name as Cname,pos as Cpos,`desc` as Cdesc FROM prefix_linkcats WHERE id = '"
.
$menu
->getE(2) .
"'"
);
$_Cilch
= db_fetch_assoc(
$erg
);
$_Cilch
[
'Cpkey'
] =
$menu
->getE(2);
}
else
{
$_Cilch
=
array
(
'Ccat'
=>
''
,
'Cpkey'
=>
''
,
'Cpos'
=>
''
,
'Cname'
=>
''
,
'Cdesc'
=>
''
);
}
archiv_links_admin_selectcats(
'0'
,
''
,
$_Cilch
[
'Ccat'
],
$_Cilch
[
'Ccat'
]);
$_Cilch
[
'Ccat'
] =
'<option value="0">Keine</option>'
.
$_Cilch
[
'Ccat'
];
archiv_links_admin_showcats (0 ,
''
);
$tpl
->set_ar(
$_ilch
);
$tpl
->set_ar(
$_Cilch
);
$tpl
->out(3);
$design
->footer();
break
;
?>