<?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();
echo
'
<script language=
"JavaScript"
type=
"text/javascript"
>
<!--
function
skilldel ( SKILLID ) {
var
frage = confirm (
"Willst du diesen Eintrag wirklich entfernen?"
);
if
( frage == true ) {
document.location.href=
"?skills-del-"
+SKILLID;
}
}
function
skillname ( SKILLID ) {
var
frage = window.prompt(
"Bitte geben Sie den neuen Namen ein"
,
""
);
if
(frage != null) {
document.location.href=
"?skills-name-"
+SKILLID+
"-"
+frage;
}
}
function
skillnew () {
var
newname = window.prompt(
"Bitte geben Sie den Namen des Skill ein"
,
""
);
document.location.href=
"?skills-newskill-"
+newname;
}
function
catnew () {
var
newname = window.prompt(
"Bitte geben Sie den Namen der Kategorie an"
,
""
);
document.location.href=
"?skills-newcat-"
+newname;
}
-->
</script>';
echo
'
<table cellpadding=
"0"
cellspacing=
"0"
border=
"0"
>
<tr>
<td><img src=
"include/images/icons/admin/skills.png"
/></td>
<td width=
"30"
></td><td valign=
"bottom"
><h1>Skills</h1></td>
</tr>
</table>
<table width=
"520"
cellpadding=
"3"
cellspacing=
"1"
border=
"0"
class
=
"border"
>
<tr
class
=
"Cdark"
>
<td width=
"50"
align=
"center"
>Pos</td>
<td width=
"470"
colspan=
"5"
>Skillname<span style=
"float:right"
><a href=
"javascript:catnew()"
><b>Neue Kategorie</b></a> | <a href=
"javascript:skillnew()"
><b>Neuer Skill</b></a></span></td>
</tr>
<tr
class
=
"Cmite"
>
<td colspan=
"6"
height=
"5"
></td>
</tr>';
if
(
$menu
->get(1) ==
'del'
) {
db_query(
'DELETE FROM `prefix_skill` WHERE id = "'
.
$menu
->get(2) .
'" LIMIT 1'
);
}
if
(
$menu
->get(1) ==
'name'
) {
$name
= escape(
$_SERVER
[
"REQUEST_URI"
],
'string'
);
$name
=
str_replace
(
'/admin.php?skills-name-'
.
$menu
->get(2).
'-'
,
''
,
$name
);
$name
= urldecode(
$name
);
db_query(
'UPDATE `prefix_skill` SET name = "'
.
$name
.
'" WHERE id = "'
.
$menu
->get(2) .
'"'
);
}
if
(
$menu
->get(1) ==
'newskill'
and
$menu
->get(2) !=
'null'
and
$menu
->get(2) !=
''
) {
$name
= escape(
$_SERVER
[
"REQUEST_URI"
],
'string'
);
$name
=
str_replace
(
'/admin.php?skills-newskill-'
,
''
,
$name
);
$name
= urldecode(
$name
);
$maxpos
= db_result(db_query(
'SELECT pos FROM `prefix_skill` ORDER BY pos DESC LIMIT 1'
),0) + 1;
db_query(
'INSERT INTO prefix_skill (`pos` , `name`) VALUES ("'
.
$maxpos
.
'", "'
.
$name
.
'")'
);
}
if
(
$menu
->get(1) ==
'newcat'
and
$menu
->get(2) !=
'null'
and
$menu
->get(2) !=
''
) {
$name
= escape(
$_SERVER
[
"REQUEST_URI"
],
'string'
);
$name
=
str_replace
(
'/admin.php?skills-newcat-'
,
''
,
$name
);
$name
= urldecode(
$name
);
$maxpos
= db_result(db_query(
'SELECT pos FROM `prefix_skill` ORDER BY pos DESC LIMIT 1'
),0) + 1;
db_query(
'INSERT INTO prefix_skill (`pos` , `name`, `cat`) VALUES ("'
.
$maxpos
.
'", "'
.
$name
.
'", 1)'
);
}
if
(
$menu
->getA(1) ==
'o'
OR
$menu
->getA(1) ==
'u'
) {
$pos
=
$menu
->get(2);
$id
=
$menu
->getE(1);
$nps
= (
$menu
->getA(1) ==
'u'
?
$pos
+ 1 :
$pos
- 1);
$anz
= db_result(db_query(
"SELECT COUNT(*) FROM prefix_skill"
), 0);
if
(
$nps
<=
$anz
AND
$nps
>= 1) {
db_query(
"UPDATE prefix_skill SET pos = "
.
$pos
.
" WHERE pos = "
.
$nps
);
db_query(
"UPDATE prefix_skill SET pos = "
.
$nps
.
" WHERE id = "
.
$id
);
}
}
$erg
= db_query(
'SELECT * FROM `prefix_skill` ORDER BY pos, name DESC'
);
$class
=
''
;
while
(
$row
= db_fetch_object(
$erg
)) {
if
(
$row
->cat == 1) {
$class
=
'Cnorm'
;
echo
'<tr class="Cdark">'
;
}
else
{
if
(
$class
==
'Cmite'
) {
$class
=
'Cnorm'
; }
else
{
$class
=
'Cmite'
; }
echo
'<tr class="'
.
$class
.
'">'
;
}
echo
'<td width="50" align="center">'
.
$row
->pos . '</td>
<td width=
"440"
>
' . $row->name . '
</td>
<td width=
"10"
align=
"center"
>
<a href=
"javascript:skillname(' . $row->id . ')"
><img src=
"include/images/icons/edit.gif"
alt=
"umbenennen"
title=
"umbenennen"
></a></td>
<td width=
"10"
align=
"center"
>
<a href=
"javascript:skilldel(' . $row->id . ')"
><img src=
"include/images/icons/del.gif"
alt=
"löschen"
title=
"löschen"
></a></td>
<td width=
"10"
align=
"center"
>
<a href=
"?skills-o' . $row->id . '-' . $row->pos . '"
><img src=
"include/images/icons/pfeilo.gif"
border=
"0"
title=
"oben"
alt=
"oben"
></a></td>
<td width=
"10"
align=
"center"
>
<a href=
"?skills-u' . $row->id . '-' . $row->pos . '"
><img src=
"include/images/icons/pfeilu.gif"
border=
"0"
title=
"unten"
alt=
"unten"
></a></td>
</tr>';
}
echo
'</table>'
;
$design
->footer();
?>