"
.""
."| "._TEAMTBPOS." | "
.""._TEAMTBNNAM.", "._TEAMTBVNAM." | "
.""._TEAMTBSTELG." | "
.""._TEAMEMAIL." | "
.""._TEAMTBMODUS." | "
.""._TEAMTBOPS." | "
."
";
if (sql_num_rows($result) > 0) {
while ($row = sql_fetch_array($result)) {
$q = "SELECT tid, pos FROM ".$prefix."_team WHERE pos<'".$row['pos']."'";
$showHoch = sql_num_rows(sql_query($q))>0 ? true : false;
$q = "SELECT tid, pos FROM ".$prefix."_team WHERE pos>'".$row['pos']."'";
$showRunter = sql_num_rows(sql_query($q))>0 ? true : false;
$emphasis = $row['stellung'];
$emphalng = strlen($emphasis);
if ($emphalng >= 50) {
$emphasis = substr($emphasis, 0, 46);
$emphasis .= " ...";
} else {
$emphasis = $row['stellung'];
}
echo ""
.""
."".($showHoch ? ""
."![\""._TEAMIMGUP."\"](\"images/vkp/vkp-up.gif\") " : "![\""._TEAMIMGNOUP."\"](\"images/vkp/vkp-nup.gif\") ")." | "
."".$row['pos']." | "
."".($showRunter ? ""
."![\""._TEAMIMGDOWN."\"](\"images/vkp/vkp-dn.gif\") "
."" : "![\""._TEAMIMGNODOWN."\"](\"images/vkp/vkp-ndn.gif\") ")." | "
."".$row['nname'].", ".$row['vname']." | "
."".$emphasis." | "
."".$row['email']." | "
."".($row['anzeigen']==0 ? ""._TEAMMODDEACT."" : ""._TEAMMODACT."")." | "
.""
.""._TEAMOPCNG.""
.""._TEAMOPDEL.""
.""
.($row['anzeigen']==1 ? ""._TEAMOPDEACT."" : ""._TEAMOPACT."").""
." | "
."
";
unset($emphasis, $emphalng);
}
}
// echo "";
echo "";
CloseTable();
echo "
";
$permsdir = decoct(fileperms($vkp19));
$perms=substr($permsdir,-3);
if ($perms!="777" || $vkp19 == "") {
OpenTable();
echo ""._ERRORGLOBAL.":
";
echo ""._TEAMVERZEICHNIS." "".$vkp19."" "._TEAMCHMOD777."!
";
CloseTable();
echo "
";
$errorstop = 1;
} else {
$errorstop = 0;
}
$number_of_uploads = $vkp39;
if ($errorstop != 1) {
OpenTable2();
echo "";
CloseTable2();
echo "
";
}
include("footer.php");
}
/* ################################################################### */
function writeDetail() {
global $prefix, $tid;
global $inputURL1, $inputURL2, $inputNname, $inputVname, $inputBirth, $inputStellung, $inputEmail, $inputBildKlein, $inputBildGross, $inputBildKlein_name, $inputBildGross_name, $inputBeschrKurz, $inputBeschrLang, $inputAnzeigen;
global $mxTeamNickObli, $mxTeamBirthObli, $mxTeamInterObli, $mxTeamEmailObli, $mxTeamShortDescObli, $mxTeamLongDescObli;
$errors = array();
if (empty($inputNname)) array_push($errors, ""._ERROR1."");
if (empty($inputVname) && $mxTeamNickObli == "YES") array_push($errors, ""._ERROR2."");
if (empty($inputStellung) && $mxTeamInterObli == "YES") array_push($errors, ""._ERROR3."");
if (empty($inputBeschrKurz) && $mxTeamShortDescObli == "YES") array_push($errors, ""._ERROR4."");
if (empty($inputBeschrLang) && $mxTeamLongDescObli == "YES") array_push($errors, ""._ERROR5."");
if (empty($inputBildKlein)) array_push($errors, ""._ERROR6."");
if (empty($inputBildGross)) array_push($errors, ""._ERROR7."");
if (empty($inputEmail) && $mxTeamEmailObli == "YES") array_push($errors, ""._ERROR8."");
if (empty($inputBirth) && $mxTeamBirthObli == "YES") array_push($errors, ""._ERROR9."");
if (count($errors)==0) {
$nname = mxAddSlashesForSQL($inputNname);
$vname = mxAddSlashesForSQL($inputVname);
$birthday = mxAddSlashesForSQL($inputBirth);
$bildklein = ($inputBildKlein);
$bildgross = ($inputBildGross);
$stellung = mxAddSlashesForSQL($inputStellung);
$email = ($inputEmail);
$beschrKurz = mxAddSlashesForSQL($inputBeschrKurz);
$beschrLang = mxAddSlashesForSQL($inputBeschrLang);
$anzeigen = ($inputAnzeigen=="Ja" ? 1 : 0);
$url1 = ($inputURL1);
$url2 = ($inputURL2);
$query_set = $prefix."_team SET nname='".$nname."', vname='".$vname."', bild_klein='".$bildklein."', bild_gross='".$bildgross."', stellung='".$stellung."', email='".$email."', beschr_kurz='".$beschrKurz."', beschr_lang='".$beschrLang."', anzeigen='".$anzeigen."', url1='".$url1."', url2='".$url2."', bday='".$birthday."'";
if ($tid == "neu") {
$posr=sql_fetch_row(sql_query("SELECT MAX(pos) FROM ".$prefix."_team"));
$pos=$posr[0]+1;
$query="INSERT INTO ".$query_set.", pos='".$pos."'";
} else {
$query="UPDATE ".$query_set." WHERE tid='".$tid."'";
}
sql_query($query);
if ($tid == "neu") {
// $tidr=sql_fetch_row(sql_query("SELECT tid FROM ".$prefix."_team WHERE pos='".$posnew."'"));
$tidr=sql_fetch_row(sql_query("SELECT tid FROM ".$prefix."_team WHERE pos='".$pos."'"));
$tid=$tid[0];
}
}
return $errors;
}
/* ################################################################### */
function teamAdminConfig() {
include("header.php");
include("modules/Team/teamset.php");
GraphicAdmin();
Title(_TEAMTITLEMAIN);
teamAdminMenu();
Title(_TEAMSETTINX);
OpenTable();
echo "
\n";
CloseTable();
echo "
";
OpenTable2();
$filename = "modules/Team/teamset.php";
if (is_writable($filename)) {
$writecheck = ""._TEAMLANG39."";
} else {
$writecheck = ""._TEAMLANG40."";
}
if (file_exists($filename)) {
echo ""._TEAMLANG41." "".$filename."" "._TEAMLANG42." ".$writecheck.".\n";
} else {
echo ""._TEAMLANG41." "".$filename."" "._TEAMLANG43." ".$writecheck.".\n";
}
echo "
".$vkp0."\n";
CloseTable2();
include("footer.php");
}
/* ################################################################### */
function teamAdminConfigSave($xset19, $xset24, $xset25, $xset26, $xset27, $xset28, $xset37, $xset38, $xset39, $xset40, $xsetmxTeamCol, $xsetmxTeamDetail, $xsetmxTeamNickObli, $xsetmxTeamBirthObli, $xsetmxTeamInterObli, $xsetmxTeamEmailObli, $xsetmxTeamShortDescObli, $xsetmxTeamLongDescObli) {
intval($vkp24);
intval($vkp25);
intval($vkp26);
intval($vkp27);
intval($vkp28);
intval($vkp37);
intval($vkp39);
intval($mxTeamCol);
$rtradmin = "";
$file = @fopen("modules/Team/teamset.php", "w");
$rtradmin = "RtR\";\n\n";
$rtradmin .= "// *** Admin-Gallery ***\n";
$rtradmin .= "\$vkp24 = \"".$xset24."\";\n";
$rtradmin .= "\$vkp25 = \"".$xset25."\";\n";
$rtradmin .= "\$vkp26 = \"".$xset26."\";\n";
$rtradmin .= "\$vkp27 = \"".$xset27."\";\n";
$rtradmin .= "\$vkp28 = \"".$xset28."\";\n";
$rtradmin .= "\$mxTeamCol = \"".$xsetmxTeamCol."\";\n";
$rtradmin .= "\$vkp19 = \"".$xset19."\";\n";
$rtradmin .= "\$vkp37 = \"".$xset37."\";\n";
$rtradmin .= "\$vkp38 = \"".$xset38."\";\n";
$rtradmin .= "\$vkp39 = \"".$xset39."\";\n";
$rtradmin .= "\$vkp40 = \"".$xset40."\";\n";
$rtradmin .= "\$mxTeamDetail = \"".$xsetmxTeamDetail."\";\n";
$rtradmin .= "\$mxTeamNickObli = \"".$xsetmxTeamNickObli."\";\n";
$rtradmin .= "\$mxTeamBirthObli = \"".$xsetmxTeamBirthObli."\";\n";
$rtradmin .= "\$mxTeamInterObli = \"".$xsetmxTeamInterObli."\";\n";
$rtradmin .= "\$mxTeamEmailObli = \"".$xsetmxTeamEmailObli."\";\n";
$rtradmin .= "\$mxTeamShortDescObli = \"".$xsetmxTeamShortDescObli."\";\n";
$rtradmin .= "\$mxTeamLongDescObli = \"".$xsetmxTeamLongDescObli."\";\n\n";
$rtradmin .= "?>\n";
@fwrite($file, $rtradmin);
@fclose($file);
Header("Location: admin.php?op=teamAdminConfig");
}
/* ################################################################### */
function showDetail($tid="neu") {
global $nukeurl, $prefix, $modus, $errors;
global $inputURL1, $inputURL2, $inputNname, $inputVname, $inputBirth, $inputStellung, $inputEmail, $inputBeschrKurz, $inputBeschrLang, $inputAnzeigen, $inputBildKlein_name, $inputBildGross_name;
if ($modus == "change") {
$errwd = writeDetail();
// $errors = array_merge($errwd, $errup);
$errors = array_merge($errwd);
if (count($errors)==0) {
showUebersicht();
return;
}
}
if (count($errors) >= 1) {
$errormsg = ""._ERRORGLOBAL.":\n";
foreach ($errors as $error) {
$errormsg .= "- ".$error."
\n";
}
$errormsg .= "
\n";
} else {
$errormsg = "";
}
include("header.php");
GraphicAdmin();
Title(_TEAMTITLEMAIN);
teamAdminMenu();
include("modules/Team/teamset.php");
OpenTable();
if ($tid == "neu" && count($errors) == 0) {
$nname = "";
$vname = "";
$birthday = "";
$stellung = "";
$email = "";
$bildKlein = "";
$bildGross = "";
$beschrKurz = "";
$beschrLang = "";
$pos = "";
$anzeigenJa = " checked";
$anzeigenNein = "";
$url1 = "";
$url2 = "";
} elseif ($tid == "neu" && count($errors) >= 1) {
$nname = mxEntityQuotes($inputNname);
$vname = mxEntityQuotes($inputVname);
$birthday = mxEntityQuotes($inputBirth);
$stellung = mxEntityQuotes($inputStellung);
$email = mxEntityQuotes($inputEmail);
$beschrKurz = mxEntityQuotes($inputBeschrKurz);
$beschrLang = mxEntityQuotes($inputBeschrLang);
$pos = "";
$anzeigenJa = ($inputAnzeigen=="Ja" ? " checked" : "");
$anzeigenNein = ($inputAnzeigen=="Nein" ? " checked" : "");
$bildKlein = ($inputBildKlein_name);
$bildGross = ($inputBildGross_name);
$url1 = ($inputURL1);
$url2 = ($inputURL2);
} else {
$result = sql_query("SELECT * FROM ".$prefix."_team WHERE tid='".$tid."'");
$row = sql_fetch_array($result);
$pos = $row['pos'];
if ($modus=="change") {
$nname = mxEntityQuotes($inputNname);
$vname = mxEntityQuotes($inputVname);
$birthday = mxEntityQuotes($inputBirth);
$stellung = mxEntityQuotes($inputStellung);
$email = mxEntityQuotes($inputEmail);
$beschrKurz = mxEntityQuotes($inputBeschrKurz);
$beschrLang = mxEntityQuotes($inputBeschrLang);
$anzeigenJa = ($inputAnzeigen=="Ja" ? " checked" : "");
$anzeigenNein = ($inputAnzeigen=="Nein" ? " checked" : "");
$bildKlein = ($inputBildKlein_name);
$bildGross = ($inputBildGross_name);
$url1 = ($inputURL1);
$url2 = ($inputURL2);
} else {
$nname = mxEntityQuotes($row['nname']);
$vname = mxEntityQuotes($row['vname']);
$birthday = mxEntityQuotes($row['bday']);
$stellung = mxEntityQuotes($row['stellung']);
$email = mxEntityQuotes($row['email']);
$beschrKurz = mxEntityQuotes($row['beschr_kurz']);
$beschrLang = mxEntityQuotes($row['beschr_lang']);
$anzeigenJa = ($row['anzeigen']==1 ? " checked" : "");
$anzeigenNein = ($row['anzeigen']==0 ? " checked" : "");
$bildKlein = ($row['bild_klein']);
$bildGross = ($row['bild_gross']);
$url1 = ($row['url1']);
$url2 = ($row['url2']);
}
}
if (($bildKlein == "") || (empty($bildKlein))) {
$bildKlein = $vkp40;
} else {
$bildKlein = $bildKlein;
}
if (($bildGross == "") || (empty($bildGross))) {
$bildGross = $vkp40;
} else {
$bildGross = $bildGross;
}
echo ""._TEAMDETTITLE."
\n";
if (!empty($errormsg)) {
echo "".$errormsg."
\n";
}
echo "\n"
."\n";
if ($tid!="neu") {
echo "\n";
}
echo "
\n";
CloseTable();
include("footer.php");
}
/* ################################################################### */
function getImagePath() {
include("modules/Team/teamset.php");
$imgpath = $vkp19;
return $imgpath;
}
/* ################################################################### */
function delAbfrage() {
global $prefix, $tid;
include("header.php");
include("modules/Team/teamset.php");
GraphicAdmin();
Title(_TEAMTITLEMAIN);
teamAdminMenu();
OpenTable();
$result = sql_query("SELECT * FROM ".$prefix."_team WHERE tid='".$tid."'");
$row = sql_fetch_array($result);
echo ""._TEAMDELTITLE.""
.""._TEAMDELMSG1."
"
." - "._TEAMTBNNAM.": ".$row['nname']."
"
." - "._TEAMTBVNAM.": ".$row['vname']."
"
._TEAMDELMSG2."
"
."";
if ($row['anzeigen']==1) {
echo ""
.""._TEAMNOTE.": "._TEAMDELHINTMSG
." "._TEAMOPDEACT."."
."";
}
CloseTable();
include("footer.php");
}
/* ################################################################### */
function delJa() {
global $prefix, $tid;
sql_query("DELETE FROM ".$prefix."_team WHERE tid='".$tid."'");
showUebersicht();
}
/* ################################################################### */
function changeModus() {
global $prefix, $tid;
$q="SELECT anzeigen FROM ".$prefix."_team WHERE tid='".$tid."'";
$r=sql_fetch_row(sql_query($q));
$q="UPDATE ".$prefix."_team SET anzeigen='".($r[0]==0?1:0)."' WHERE tid='".$tid."'";
sql_query($q);
showUebersicht();
}
/* ################################################################### */
function uploadAdminImage() {
global $img_name, $img_type, $img_size, $img, $submitted;
include("header.php");
include("modules/Team/teamset.php");
GraphicAdmin();
Title(_TEAMTITLEMAIN);
teamAdminMenu();
$vkp37 = intval($vkp37);
$vkp39 = intval($vkp39);
$abpath = $vkp19;
$sizelim = $vkp38;
$size = $vkp37;
$number_of_uploads = $vkp39;
if ($_REQUEST['submitted']) {
/* Sicherheitscheck */
$bildcheck1 = "image/pjpeg";
$bildcheck2 = "image/jpeg";
$bildcheck3 = "image/jpg";
$bildcheck4 = "image/gif";
$bildcheck5 = "image/png";
$bildcheck6 = "image/tiff";
$bildcheck7 = "image/bmp";
$bildcheck8 = "image/vnd.wap.wbmp";
$bildcheck9 = "image/ief";
$bildcheck10 = "image/x-x-portable-anymap";
$bildcheck11 = "image/x-portable-bitmap";
$bildcheck12 = "image/x-portable-graymap";
$bildcheck13 = "image/x-portable-pixmap";
$bildcheck14 = "image/x-rgb";
$bildcheck15 = "image/x-xbitmap";
$bildcheck16 = "image/x-xpixmap";
$bildcheck17 = "image/x-xwindowdump";
$bildcheck18 = "image/x-cmu-raster";
$log = "";
for ($i=0; $i<$number_of_uploads; $i++) {
if ($img_name[$i] == "") {
$log .= ""._TEAMLANG44.": "._TEAMEMPTYUPLOAD."
";
}
if ($img_name[$i] != "") {
if (file_exists($abpath."/".$img_name[$i])) {
$log .= ""._TEAMNOTE.": "._TEAMDATEI." "".$img_name[$i]."" "._TEAMFEXISTS."
![\""._TEAMTHISFILE.":](\"".$abpath."/".$img_name[$i]."\")
";
} else {
if (($sizelim == "yes") && ($img_size[$i] > $size)) {
$log .= ""._TEAMNOTE.": "._TEAMDATEI." "".$img_name[$i]."" "._TEAMFTOOBIG."
";
} else {
if (($img_type[$i] == $bildcheck1) or ($img_type[$i] == $bildcheck2) or ($img_type[$i] == $bildcheck3) or ($img_type[$i] == $bildcheck4) or ($img_type[$i] == $bildcheck5) or ($img_type[$i] == $bildcheck6) or ($img_type[$i] == $bildcheck7) or ($img_type[$i] == $bildcheck8) or ($img_type[$i] == $bildcheck9) or ($img_type[$i] == $bildcheck10) or ($img_type[$i] == $bildcheck11) or ($img_type[$i] == $bildcheck12) or ($img_type[$i] == $bildcheck13) or ($img_type[$i] == $bildcheck14) or ($img_type[$i] == $bildcheck15) or ($img_type[$i] == $bildcheck16) or ($img_type[$i] == $bildcheck17)) {
@copy($img[$i], $abpath."/".$img_name[$i]) or $log .= ""._TEAMNOTE.": "._TEAMDATEI." "".$img_name[$i]."" "._TEAMCANTCOPY."
";
if (file_exists($abpath."/".$img_name[$i])) {
$log .= ""._TEAMDATEI." "".$img_name[$i]."" "._TEAMSUCCESSUP."
";
}
} else {
$log .= ""._TEAMNOTE.": "._TEAMDATEI." "".$img_name[$i]."" "._TEAMISNTIMG."
";
}
}
}
}
}
Title("\n"._TEAMUPLOADMSG."\n");
if (!empty($log)) {
OpenTable();
echo $log;
CloseTable();
echo "
";
}
include("footer.php");
exit;
}
}
/* ################################################################### */
function displayAdminImage () {
global $prefix, $do_pic_del, $pic_del_name;
include("header.php");
include("modules/Team/teamset.php");
GraphicAdmin();
Title(_TEAMTITLEMAIN);
teamAdminMenu();
if ((is_numeric($do_pic_del)) && ($do_pic_del == 1)) {
$pic_complete = $vkp19."/".$pic_del_name;
if (file_exists($pic_complete)) {
$qklein = "UPDATE ".$prefix."_team SET bild_klein='".$vkp40."' WHERE tid='".$pic_del_name."'";
sql_query($qklein);
$qgross = "UPDATE ".$prefix."_team SET bild_gross='".$vkp40."' WHERE tid='".$pic_del_name."'";
sql_query($qgross);
@unlink($pic_complete);
OpenTableAl();
echo ""._TEAMDELPICINFO1." "".$pic_del_name."" "._TEAMDELPICINFO2."
"._TEAMDELPICINFO3."";
CloseTableAl();
echo "
";
unset($pic_complete, $qklein, $qgross);
}
}
unset($do_pic_del, $pic_del_name);
Title("\n"._TEAMPICVIEW."\n");
OpenTable();
$direktori = $vkp19;
$handle=opendir($direktori);
while ($file = readdir($handle)) {
$filelist[] = $file;
}
asort($filelist);
while (list ($key, $file) = each ($filelist)) {
ereg(".gif |.jpg",$file);
if ($file == "." || $file == "..") {
$a=1;
} else {
$extension = end(explode(".", $file));
if ($extension == "gif" || $extension == "jpg" || $extension == "jpeg" || $extension == "png") {
echo ""._TEAMFILE.":
".$file."![\"".$file."\"](\"".$direktori."/".$file."\")
";
$info = getimagesize($direktori."/".$file);
$width = $info[0];
$height = $info[1];
$mime = $info['mime'];
if ($file != $vkp40) {
echo "
";
}
echo "
"._TEAMPICINFO." -->> [ "._TEAMPICWIDTH.": ".$width." "._TEAMPICPIXEL." | "._TEAMPICHEIGTH.": ".$height." "._TEAMPICPIXEL." | "._TEAMPICMIME.": ".$mime." ]
";
if ($file == $vkp40) {
echo "
- "._TEAMPLACEHOLDER." -
";
}
echo"
\n";
}
}
}
CloseTable();
include("footer.php");
exit;
}
/* ################################################################### */
function changePos($modus) {
global $prefix, $tid;
$tid = (intval($tid));
$q = "SELECT pos FROM ".$prefix."_team WHERE tid='".$tid."'";
$row = sql_fetch_array(sql_query($q));
$pos_alt = $row['pos'];
$tid_alt = $tid;
switch ($modus) {
case "hoch":
$q = "SELECT tid, pos FROM ".$prefix."_team WHERE pos<'".$pos_alt."' ORDER BY pos DESC LIMIT 1";
break;
case "runter":
$q = "SELECT tid, pos FROM ".$prefix."_team WHERE pos>'".$pos_alt."' ORDER BY pos ASC LIMIT 1";
break;
default:
return;
break;
}
$r = sql_query($q);
if (sql_num_rows($r)==1) {
$row = sql_fetch_array($r);
$pos_neu = $row['pos'];
$tid_neu = $row['tid'];
// !!!Nummern tauschen - ACHTUNG! UNIQUE NUMBERS!!!
$q_alt_tmp="UPDATE ".$prefix."_team SET pos='-1' WHERE tid='".$tid_alt."'";
$q_neu="UPDATE ".$prefix."_team SET pos='".$pos_alt."' WHERE tid='".$tid_neu."'";
$q_alt="UPDATE ".$prefix."_team SET pos='".$pos_neu."' WHERE tid='".$tid_alt."'";
sql_query($q_alt_tmp);
sql_query($q_neu);
sql_query($q_alt);
} else {
}
showUebersicht();
}
/* ################################################################### */
function teamAdminMenu() {
global $aidname;
OpenTable();
echo "";
CloseTable();
echo "
";
}
/* ################################################################### */
switch($op) {
case "team":
showUebersicht();
break;
case "teamDel":
delAbfrage();
break;
case "teamDelJa":
delJa();
break;
case "teamAdminImage":
uploadAdminImage();
break;
case "teamAdminDisplay":
displayAdminImage();
break;
case "teamDetail":
showDetail($tid);
break;
case "teamAdd":
showDetail();
break;
case "teamChgMod":
changeModus();
break;
case "teamPos":
changePos($modus);
break;
case "teamAdminConfig":
teamAdminConfig();
break;
case "teamAdminConfigSave":
teamAdminConfigSave($xset19, $xset24, $xset25, $xset26, $xset27, $xset28, $xset37, $xset38, $xset39, $xset40, $xsetmxTeamCol, $xsetmxTeamDetail, $xsetmxTeamNickObli, $xsetmxTeamBirthObli, $xsetmxTeamInterObli, $xsetmxTeamEmailObli, $xsetmxTeamShortDescObli, $xsetmxTeamLongDescObli);
break;
default:
showUebersicht();
break;
}
?>