Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 3932332 bytes) in /var/www/web109/html/include/admin/archiv.php on line 88
hier mal die archiv.php
<?php
# Copyright by: Manuel
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
defined ('admin') or die ( 'only admin access' );
function get_upload_linked ( $v ) {
$l = '';
$i = 1;
$erg = db_query("SELECT id, name FROM prefix_downloads WHERE url = '".$v."'");
if ( @db_num_rows($erg) > 0 ) {
while ( $r=db_fetch_assoc($erg) ) {
$l .= '[<a href="javascript:showDDetails('.$r['id'].')" title="'.$r['name'].'">'.$i.'</a>], ';
$i++;
}
}
return ( $l);
}
function uploadMoveFile_getdirlist ($f='include/downs/downloads',$list='<option value="/">/</option>') {
$o = opendir($f);
while($v = readdir($o)) {
if ( $v == '.' OR $v == '..' OR !is_dir($f .'/'. $v) ) { continue; }
$dirn = str_replace('include/downs/downloads/','', $f .'/'. $v );
$list .= '<option value="'.$dirn.'">'.$dirn.'</option>';
$list = uploadMoveFile_getdirlist ($f .'/'. $v , $list);
}
return ( $list );
}
function upload_getdirlist ($f='include/downs/downloads',$list='') {
$o = opendir($f);
while($v = readdir($o)) {
if ( $v == '.' OR $v == '..' OR !is_dir($f .'/'. $v) ) { continue; }
$dirn = str_replace('include/downs/downloads/','', $f .'/'. $v );
$list .= '<tr><td class="Cnorm"><a href="?archiv-downloads-upload=0&f='.$f.'/'.$v.'">'.$dirn.'</a></td></tr>';
$list = upload_getdirlist ($f .'/'. $v , $list);
}
return ( $list );
}
function get_downloads_ar ($ar=NULL,$f=NULL) {
if ( is_null ( $ar ) ) {
$ar = array();
}
if ( is_null ($f) ) {
$f = 'include/downs/downloads';
}
$o = opendir($f);
while ($v = readdir($o) ) {
if ( $v != '.' AND $v != '..' ) {
if ( is_dir ($f.'/'.$v ) ) {
$ar = get_downloads_ar ($ar, $f.'/'.$v );
} else {
$ar[$f.'/'.$v] = $v;
}
}
}
closedir($o);
return ($ar);
}
function archiv_downs_admin_showcats ( $id , $stufe ) {
$q = "SELECT id,name,pos,cat FROM prefix_downcats 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-downloads-S'.$row->id.'">'.$row->name.'</a></td>';
echo '<td align="center"><a href="admin.php?archiv-downloads-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-downloads-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-downloads-S'.$row->id.'-U'.$row->id.'-'.$row->pos.'-'.$row->cat.'"><img src="include/images/icons/pfeilu.gif" border="0"></a></td></tr>';
archiv_downs_admin_showcats($row->id, $stufe.' ' );
}
}
}
function archiv_downs_admin_selectcats ( $id, $stufe, &$output, $sel = 0) {
$q = "SELECT id,name,pos,cat FROM prefix_downcats 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_downs_admin_selectcats($row->id, $stufe.'»', $output, $sel );
}
}
}
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);
switch ($um) {
case 'downloads' :
if ( $menu->get(2) == 'upload' ) {
$msg = '';
# file rechte pruefen
if ( !is_writeable ( 'include/downs/downloads' ) ) {
$msg = '<b>Bevor du hier eine Datei hochladen/verwalten kannst muss der Ordner include/downs/<b>downloads</b>/ erstellt werden und er muss Schreibrechte ( chmod 777 ) erhalten !!! Wenn das geschehen ist einfach nochmal hier auf aktualisieren klicken</b>';
}
# file hochladen
if ( isset ($_FILES['file']['name']) ) {
if ( move_uploaded_file ( $_FILES['file']['tmp_name'], $_REQUEST['f'].'/'.$_FILES['file']['name']) ) {
@chmod($_REQUEST['f'].'/'.$_FILES['file']['name'], 0777);
$msg = 'Datei ('.$_FILES['file']['name'].' ) <font color="#00FF00">erfolgreich hochgeladen</font><br />';
} else {
$msg = 'Datei ( '.$_FILES['file']['name'].' ) <font color="#FF0000">nicht erfolgreich hochgeladen</font><br />';
}
}
# datei loeschen
if ( isset ($_REQUEST['d']) ) {
unlink ( $_REQUEST['f'].'/'.$_REQUEST['d'] );
}
# datei verschieben
if ( isset ($_REQUEST['r']) ) {
if ( @rename ( $_REQUEST['f'].'/'.$_REQUEST['v'], $_REQUEST['f'].'/'.$_REQUEST['r'] ) ) {
db_query("UPDATE prefix_downloads SET url = '".$_REQUEST['f'].'/'.$_REQUEST['r']."' WHERE url = '".$_REQUEST['f'].'/'.$_REQUEST['v']."'");
db_query("UPDATE prefix_downloads SET surl = '".$_REQUEST['f'].'/'.$_REQUEST['r']."' WHERE surl = '".$_REQUEST['f'].'/'.$_REQUEST['v']."'");
db_query("UPDATE prefix_downloads SET ssurl = '".$_REQUEST['f'].'/'.$_REQUEST['r']."' WHERE ssurl = '".$_REQUEST['f'].'/'.$_REQUEST['v']."'");
$msg = '<font color="#00FF00">Erfolgreich umbenannt...</font><br />';
} else {
$msg = '<font color="#FF0000">Konnte Datei nicht umbennen</font></br />';
}
}
if ( isset ($_REQUEST['n']) ) {
$neudir = 'include/downs/downloads/'.str_replace('.','',$_REQUEST['n']);
if ( $_REQUEST['n'] == '/' ) {
$neudir = 'include/downs/downloads';
}
if ( is_dir ( $neudir ) AND is_writeable ( $neudir ) ) {
if ( @rename ( $_REQUEST['f'].'/'.$_REQUEST['v'], $neudir.'/'.$_REQUEST['v'] ) ) {
db_query("UPDATE prefix_downloads SET url = '".$neudir.'/'.$_REQUEST['v']."' WHERE url = '".$_REQUEST['f'].'/'.$_REQUEST['v']."'");
db_query("UPDATE prefix_downloads SET surl = '".$neudir.'/'.$_REQUEST['v']."' WHERE surl = '".$_REQUEST['f'].'/'.$_REQUEST['v']."'");
db_query("UPDATE prefix_downloads SET ssurl = '".$neudir.'/'.$_REQUEST['v']."' WHERE ssurl = '".$_REQUEST['f'].'/'.$_REQUEST['v']."'");
$msg = '<font color="#00FF00">Erfolgreich verschoben...</font><br />';
$_REQUEST['f'] = $neudir;
} else {
$msg = '<font color="#FF0000">Konnte Datei nicht verschieben</font></br />';
}
} else {
$msg = '<font color="#FF0000">Der angegebene Ordner ist nicht vorhanden...</font><br />';
}
}
# files anzeigen von ordner X... wenn x nicht definiert nimm downs/downloads...
# sonst halt downs/downloads/x/x1/x2...
$f = 'include/downs/downloads';
if (isset ($_REQUEST['f']) AND !empty($_REQUEST['f'])) {
$f = $_REQUEST['f'];
if ( strpos ( $f, '.' ) !== FALSE ) {
$f = dirname ( $f );
}
}
# positions liste definieren... (wo bin ich ;-))
$str_fl = '';
if ( $f != 'include/downs/downloads' ) {
$ar_f = explode('/',str_replace('include/downs/downloads/','',$f));
$str_nfl = '';
foreach ( $ar_f as $v ) {
$str_fl .= '<b> » </b><a href="?archiv-downloads-upload=0&f=include/downs/downloads/'.$str_nfl.$v.'">'.$v.'</a>';
$str_nfl .= $v.'/';
}
}
# template oeffnen
$tpl = new tpl ( 'archiv/upload', 1);
$tpl->set_ar_out(array('posi'=>$str_fl,'msg'=>$msg),0);
if ( is_dir ( $f ) ) {
# dir oeffnen und arrays fuellen einmal
# arrays mit ordner einmal mit files
$ar_files = array();
$ar_dirs = array();
$o = opendir ( $f );
while ( $v = readdir ( $o ) ) {
if ( $v == '.' OR $v == '..' ) { continue; }
$is_dir = is_dir ($f.'/'.$v);
if ( $is_dir AND is_writeable ($f.'/'.$v) ) {
$ar_dirs[] = $v;
} elseif ( !$is_dir ) {
$ar_files[] = $v;
}
}
$class = 'Cmite';
# arrays durchlaufen und mit entsprechenden aktionen bzw. links versehen.
# zuerstmal das dirs array dann das files...
foreach($ar_dirs as $v) {
$class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' );
echo '<tr class="'.$class.'"><td colspan="5"><a href="?archiv-downloads-upload=0&f='.$f.'/'.$v.'">'.$v.'/</a></td></tr>';
}
foreach($ar_files as $v) {
$class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' );
echo '<tr class="'.$class.'">';
echo '<td>'.$v.'</td>';
echo '<td><a href="javascript:deleteFile(\''.$f.'\',\''.$v.'\')"><img src="include/images/icons/del.gif" title="löschen" border="0" /></a></td>';
echo '<td><a href="javascript:moveFile(\''.$f.'\',\''.$v.'\')"><img src="include/images/icons/pfeila.gif" title="verschieben" border="0" /></a></td>';
echo '<td><a href="javascript:renFile(\''.$f.'\',\''.$v.'\')"><img src="include/images/icons/edit.gif" title="umbennen" border="0" /></a></td>';
echo '<td>'.get_upload_linked ( $f.'/'.$v ).'<a href="javascript:waehleThisFile(\''.$f.'/'.$v.'\')">wählen</a></td>';
echo '</tr>';
}
} else {
echo '<tr><td colspan="5" class="Cmite">Verzeichnis nicht gefunden... <a href="?archiv-downloads-upload">Übersicht</a></td></tr>';
}
$tpl->set('f',$f);
$tpl->out(1);
# ordner liste
echo upload_getdirlist ();
$tpl->out(2);
}
###################
# upload move file
if ( $menu->get(2) == 'uploadMoveFile' ) {
$tpl = new tpl ( 'archiv/upload_move_file', 1 );
$tpl->set('v',$_REQUEST['v']);
$tpl->set('f',$_REQUEST['f']);
$tpl->set('dirlist',uploadMoveFile_getdirlist());
$tpl->out(0);
}
if ( $menu->get(2) == 'upload' OR $menu->get(2) == 'uploadMoveFile' ) { exit (); }
$design = new design ( 'Admins Area', 'Admins Area', 2 );
$design->header();
$tpl = new tpl ( 'archiv/downloads', 1);
# kategorie und download eintraege loeschen
if ( $menu->getA(2) == 'D' ) {
$azk = db_result(db_query("SELECT cat FROM prefix_downcats WHERE id = '".$menu->getE(2)."'"),0);
$pos = db_result(db_query("SELECT pos FROM prefix_downcats WHERE id = '".$menu->getE(2)."'"),0);
db_query("DELETE FROM prefix_downcats WHERE id = '".$menu->getE(2)."'");
db_query("UPDATE prefix_downcats SET pos = pos - 1 WHERE pos > ".$pos." AND cat = ".$azk);
}
if ($menu->getA(2) == 'd' AND 1 == db_result(db_query("SELECT COUNT(*) FROM prefix_downloads WHERE id = ".intval($menu->getE(2))),0)) {
$r = db_fetch_assoc(db_query("SELECT cat, pos, url, surl, ssurl FROM prefix_downloads WHERE id = ".$menu->getE(2)));
$azk = $r['cat'];
$pos = $r['pos'];
unset ($r['cat']);
unset ($r['pos']);
# wenn url nur noch in diesem download vorhanden dann loeschen
foreach ($r as $k => $v) {
$qc = "SELECT COUNT(*) FROM prefix_downloads WHERE ".$k." = '".$v."'";
if (db_result(db_query($qc),0) == 1 AND @file_exists($v)) {
@unlink($v);
}
}
db_query("DELETE FROM prefix_downloads WHERE id = '".$menu->getE(2)."'");
db_query("UPDATE prefix_downloads SET pos = pos - 1 WHERE pos > ".$pos." AND cat = ".$azk);
}
# download eintraege speichern oder aendern.
if ( !empty($_POST['sub']) ) {
$_POST['url'] = $_POST['newurl'];
$_POST['cat'] = escape($_POST['cat'], 'integer');
$_POST['creater'] = escape($_POST['creater'], 'string');
$_POST['version'] = escape($_POST['version'], 'string');
$_POST['url'] = escape($_POST['url'], 'string');
$_POST['surl'] = escape($_POST['surl'], 'string');
$_POST['ssurl'] = escape($_POST['ssurl'], 'string');
$_POST['name'] = escape($_POST['name'], 'string');
$_POST['desc'] = escape($_POST['desc'], 'string');
$_POST['descl'] = escape($_POST['descl'], 'string');
if ( empty ($_POST['pkey']) ) {
$pos = db_result(db_query("SELECT COUNT(*) FROM prefix_downloads WHERE cat = ".$_POST['cat']),0);
db_query("INSERT INTO prefix_downloads (`time`,`cat`,`creater`,`version`,`url`,surl,`ssurl`,`name`,`desc`,`descl`,pos) VALUES (NOW(),'".$_POST['cat']."','".$_POST['creater']."','".$_POST['version']."','".$_POST['url']."','".$_POST['surl']."','".$_POST['ssurl']."','".$_POST['name']."','".$_POST['desc']."','".$_POST['descl']."','".$pos."')");
} else {
$alt_row = db_fetch_assoc(db_query("SELECT cat,pos FROM prefix_downloads WHERE id = ".$_POST['pkey']));
if ( $alt_row['cat'] <> $_POST['cat'] ) {
$pos = db_result(db_query("SELECT COUNT(*) FROM prefix_downloads WHERE cat = ".$_POST['cat']),0);
} else {
$pos = $alt_row['pos'];
}
if ($_POST['refdate'] == 'on') {
$datum = '`time` = NOW(), ';
} else { $datum = ''; }
db_query("UPDATE prefix_downloads SET ".$datum."pos = ".$pos.", `cat` = '".$_POST['cat']."',`creater` = '".$_POST['creater']."',version = '".$_POST['version']."',url = '".$_POST['url']."',surl = '".$_POST['surl']."',ssurl = '".$_POST['ssurl']."',`name` = '".$_POST['name']."',`desc` = '".$_POST['desc']."',descl = '".$_POST['descl']."' WHERE id = '".$_POST['pkey']."'");
if ( $alt_row['cat'] <> $_POST['cat'] ) {
db_query("UPDATE prefix_downloads SET pos = pos - 1 WHERE pos > ".$alt_row['pos']." AND cat = ".$alt_row['cat']);
}
}
$azk = $_POST['cat'];
}
# kategorie eintrage speichern oder aendern.
if ( isset ( $_POST['Csub']) ) {
if ( empty($_POST['Ccat']) ) {
$_POST['Ccat'] = 0;
}
if ( empty ($_POST['Cpkey']) ) {
$pos = db_result(db_query("SELECT COUNT(*) FROM prefix_downcats WHERE cat = ".$_POST['Ccat']),0);
db_query("INSERT INTO prefix_downcats (`cat`,`name`,`desc`,pos,recht) VALUES (".$_POST['Ccat'].",'".$_POST['Cname']."','".$_POST['Cdesc']."','".$pos."','".$_POST['Crecht']."')");
} else {
$alt_row = db_fetch_assoc(db_query("SELECT cat,pos FROM prefix_downcats WHERE id = ".$_POST['Cpkey']));
$bool = true;
$tc = $_POST['Ccat'];
while ($tc > 0) {
if ($tc == $_POST['Cpkey']) { $bool = false; }
$tc = @db_result(db_query("SELECT cat FROM prefix_downcats WHERE id = $tc"));
}
if ($bool) {
if ( $alt_row['cat'] <> $_POST['Ccat'] ) {
$pos = db_result(db_query("SELECT COUNT(*) FROM prefix_downcats WHERE cat = ".$_POST['Ccat']),0);
} else {
$pos = $alt_row['pos'];
}
db_query("UPDATE prefix_downcats SET `cat` = '".$_POST['Ccat']."',`name` = '".$_POST['Cname']."',pos = '".$pos."',`desc` = '".$_POST['Cdesc']."', recht = '".$_POST['Crecht']."' WHERE `id` = '".$_POST['Cpkey']."'");
if ( $alt_row['cat'] <> $_POST['Ccat'] ) {
db_query("UPDATE prefix_downcats SET pos = pos - 1 WHERE pos > ".$alt_row['pos']." AND cat = ".$alt_row['cat']);
}
}
}
$azk = $_POST['Ccat'];
}
# downloadeintrage verschieben.
if ( $menu->getA(3) == 'u' OR $menu->getA(3) == 'o' ){
$pos = $menu->get(4);
$id = $menu->getE(3);
$nps = ( $menu->getA(3) == 'u' ? $pos + 1 : $pos - 1 );
$anz = db_result(db_query("SELECT COUNT(*) FROM prefix_downloads WHERE cat = ".$menu->getE(2)),0);
if ($nps < 0) {
db_query("UPDATE prefix_downloads SET pos = ".$anz." WHERE id = ".$id);
db_query("UPDATE prefix_downloads SET pos = pos -1 WHERE cat = ".$menu->getE(2));
}
if ($nps >= $anz) {
db_query("UPDATE prefix_downloads SET pos = -1 WHERE id = ".$id);
db_query("UPDATE prefix_downloads SET pos = pos +1 WHERE cat = ".$menu->getE(2));
}
if ( $nps < $anz AND $nps >= 0 ) {
db_query("UPDATE prefix_downloads SET pos = ".$pos." WHERE pos = ".$nps." AND cat = ".$menu->getE(2));
db_query("UPDATE prefix_downloads SET pos = ".$nps." WHERE id = ".$id);
}
}
# download kategorien verschieben
if ( $menu->getA(3) == 'U' OR $menu->getA(3) == 'O' ){
$pos = $menu->get(4);
$id = $menu->getE(3);
$cat = db_result(db_query("SELECT cat FROM prefix_downcats WHERE id = ".$id),0);
$nps = ( $menu->getA(3) == 'U' ? $pos + 1 : $pos - 1 );
$anz = db_result(db_query("SELECT COUNT(*) FROM prefix_downcats WHERE cat = ".$cat),0);
if ($nps < 0) {
db_query("UPDATE prefix_downcats SET pos = ".$anz." WHERE id = ".$id);
db_query("UPDATE prefix_downcats SET pos = pos -1 WHERE cat = ".$cat);
}
if ($nps >= $anz) {
db_query("UPDATE prefix_downcats SET pos = -1 WHERE id = ".$id);
db_query("UPDATE prefix_downcats SET pos = pos +1 WHERE cat = ".$cat);
}
if ( $nps < $anz AND $nps >= 0 ) {
db_query("UPDATE prefix_downcats SET pos = ".$pos." WHERE pos = ".$nps." AND cat = ".$cat);
db_query("UPDATE prefix_downcats SET pos = ".$nps." WHERE id = ".$id);
}
}
# downs
if ( $menu->getA(2) == 'e' ) {
$erg = db_query("SELECT id,`cat`,creater,surl,ssurl,pos,version,url,`name`,`desc`,descl FROM prefix_downloads WHERE id = '".$menu->getE(2)."'");
$_ilch = db_fetch_assoc($erg);
$_ilch['pkey'] = $menu->getE(2);
$azk = $_ilch['cat'];
$_ilch['datum'] = '<input type="checkbox" name="refdate" /><font color="white">Datum aktualisieren</font>';
} 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 (
'cat' => $c,
'creater' => '',
'surl' => '',
'ssurl' => '',
'pkey' => '',
'pos' => '',
'version' => '',
'name' => '',
'url' => '',
'desc' => '',
'descl' => '',
'datum' => ''
);
unset($c);
}
# wenn der link von archiv upload kommt ist dllink gesetzt
$dllink = '';
if ( isset($_REQUEST['dllink']) ) {
$dllink = $_REQUEST['dllink'];
} else {
$dllink = $_ilch['url'];
}
$_ilch['newurl'] = $_ilch['url'];
$_ilch['url'] = arlistee ( $dllink, get_downloads_ar() );
$_ilch['url'] = '<option value="neu">andere:</option>'.$_ilch['url'];
archiv_downs_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);
if ( $menu->get(2) == 'Sa' ) { $azk = -1; }
}
}
# wenn userupload on und writeable dann koennen user
# dateien hochladen, also wird als kategorie link noch ein "freischalt" link hinzugefueght.
$frei = '';
if ( $allgAr['archiv_down_userupload'] == 1 AND is_writeable ( 'include/downs/downloads/user_upload' ) ) {
$frei = '<tr class="Cmite"><td colspan="5"><a href="?archiv-downloads-Sa">User-Uploads freischalten</a></td></tr>';
}
$tpl->out(0); $class = 0;
$abf = "SELECT id,`cat`,`version`,`name`,pos FROM prefix_downloads 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);
}
# downs
$tpl->set_out('frei',$frei,2);
# cat
if ( $menu->getA(2) == 'E' ) {
$erg = db_query("SELECT id,cat as Ccat, recht as Crecht, name as Cname,pos as Cpos,`desc` as Cdesc FROM prefix_downcats WHERE id = '".$menu->getE(2)."'");
$_Cilch = db_fetch_assoc($erg);
$_Cilch['Cpkey'] = $menu->getE(2);
} else {
$_Cilch = array (
'Ccat' => '',
'Cpkey' => '',
'Cpos' => '',
'Cname' => '',
'Crecht' => '',
'Cdesc' => ''
);
}
$_Cilch['Crecht'] = dblistee($_Cilch['Crecht'],"SELECT id,name FROM prefix_grundrechte ORDER BY id DESC");
archiv_downs_admin_selectcats('0','',$_Cilch['Ccat'],$_Cilch['Ccat']);
$_Cilch['Ccat'] = '<option value="0">Keine</option>'.$_Cilch['Ccat'];
archiv_downs_admin_showcats ( 0 , '' );
$tpl->set_ar($_ilch);
$tpl->set_ar($_Cilch);
$tpl->out(3);
$design->footer();
break;
# # # # # # # # # # # # # # # # # # #
# Links
case 'links' :
$design = new design ( 'Admins Area', 'Admins Area', 2 );
$design->header();
$tpl = new tpl ( 'archiv/links', 1);
# kategorie und link eintraege loeschen
if ( $menu->getA(2) == 'D' ) {
$azk = db_result(db_query("SELECT cat FROM prefix_linkcats WHERE id = '".$menu->getE(2)."'"),0);
$pos = db_result(db_query("SELECT pos FROM prefix_linkcats WHERE id = '".$menu->getE(2)."'"),0);
db_query("DELETE FROM prefix_linkcats WHERE id = '".$menu->getE(2)."'");
db_query("UPDATE prefix_linkcats SET pos = pos - 1 WHERE pos > ".$pos." AND cat = ".$azk);
}
if ( $menu->getA(2) == 'd' ) {
$azk = db_result(db_query("SELECT cat FROM prefix_links WHERE id = '".$menu->getE(2)."'"),0);
$pos = db_result(db_query("SELECT pos FROM prefix_links WHERE id = '".$menu->getE(2)."'"),0);
db_query("DELETE FROM prefix_links WHERE id = ".$menu->getE(2));
db_query("UPDATE prefix_links SET pos = pos - 1 WHERE pos > ".$pos." AND cat = ".$azk);
}
# link eintraege speichern oder aendern.
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'];
}
# kategorie eintrage speichern oder aendern.
if ( isset ( $_POST['Csub']) ) {
if ( empty($_POST['Ccat']) ) {
$_POST['Ccat'] = 0;
}
if ( empty ($_POST['Cpkey']) ) {
$pos = db_result(db_query("SELECT COUNT(*) FROM prefix_linkcats WHERE cat = ".$_POST['Ccat']),0);
db_query("INSERT INTO prefix_linkcats (`cat`,`name`,`desc`,pos) VALUES (".$_POST['Ccat'].",'".$_POST['Cname']."','".$_POST['Cdesc']."','".$pos."')");
} else {
$alt_row = db_fetch_assoc(db_query("SELECT cat,pos FROM prefix_linkcats WHERE id = ".$_POST['Cpkey']));
$tc = $_POST['Ccat'];
$bool = true;
while ($tc > 0) {
if ($tc == $_POST['Cpkey']) { $bool = false; }
$tc = @db_result(db_query("SELECT cat FROM prefix_linkcats WHERE id = $tc"));
}
if ($bool) {
if ( $alt_row['cat'] <> $_POST['Ccat'] ) {
$pos = db_result(db_query("SELECT COUNT(*) FROM prefix_linkcats WHERE cat = ".$_POST['Ccat']),0);
} else {
$pos = $alt_row['pos'];
}
db_query("UPDATE prefix_linkcats SET `cat` = '".$_POST['Ccat']."',`name` = '".$_POST['Cname']."',pos = '".$pos."',`desc` = '".$_POST['Cdesc']."' WHERE `id` = '".$_POST['Cpkey']."'");
if ( $alt_row['cat'] <> $_POST['Ccat'] ) {
db_query("UPDATE prefix_linkcats SET pos = pos - 1 WHERE pos > ".$alt_row['pos']." AND cat = ".$alt_row['cat']);
}
}
}
$azk = $_POST['Ccat'];
}
# verschieben
if ( $menu->getA(3) == 'u' OR $menu->getA(3) == 'o' ){
$pos = $menu->get(4);
$id = $menu->getE(3);
$nps = ( $menu->getA(3) == 'u' ? $pos + 1 : $pos - 1 );
$anz = db_result(db_query("SELECT COUNT(*) FROM prefix_links WHERE cat = ".$menu->getE(2)),0);
if ($nps < 0) {
db_query("UPDATE prefix_links SET pos = ".$anz." WHERE id = ".$id);
db_query("UPDATE prefix_links SET pos = pos -1 WHERE cat = ".$menu->getE(2));
}
if ($nps >= $anz) {
db_query("UPDATE prefix_links SET pos = -1 WHERE id = ".$id);
db_query("UPDATE prefix_links SET pos = pos +1 WHERE cat = ".$menu->getE(2));
}
if ( $nps < $anz AND $nps >= 0 ) {
db_query("UPDATE prefix_links SET pos = ".$pos." WHERE pos = ".$nps." AND cat = ".$menu->getE(2));
db_query("UPDATE prefix_links SET pos = ".$nps." WHERE id = ".$id);
}
}
# link kategorien verschieben
if ( $menu->getA(3) == 'U' OR $menu->getA(3) == 'O' ){
$pos = $menu->get(4);
$id = $menu->getE(3);
$cat = db_result(db_query("SELECT cat FROM prefix_linkcats WHERE id = ".$id),0);
$nps = ( $menu->getA(3) == 'U' ? $pos + 1 : $pos - 1 );
$anz = db_result(db_query("SELECT COUNT(*) FROM prefix_linkcats WHERE cat = ".$cat),0);
if ($nps < 0) {
db_query("UPDATE prefix_linkcats SET pos = ".$anz." WHERE id = ".$id);
db_query("UPDATE prefix_linkcats SET pos = pos -1 WHERE cat = ".$cat);
}
if ($nps >= $anz) {
db_query("UPDATE prefix_linkcats SET pos = -1 WHERE id = ".$id);
db_query("UPDATE prefix_linkcats SET pos = pos +1 WHERE cat = ".$cat);
}
if ( $nps < $anz AND $nps >= 0 ) {
db_query("UPDATE prefix_linkcats SET pos = ".$pos." WHERE pos = ".$nps." AND cat = ".$cat);
db_query("UPDATE prefix_linkcats SET pos = ".$nps." WHERE id = ".$id);
}
}
# links
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);
}
# links
$tpl->out(2);
# cat
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;
# # # # # # # # # # # # # # # # # # #
# Partners
case 'partners' :
$design = new design ( 'Admins Area', 'Admins Area', 2 );
$design->header();
$tpl = new tpl ( 'archiv/partners', 1);
# loeschen
if ( $menu->getA(2) == 'd' ) {
$pos = db_result(db_query("SELECT pos FROM prefix_partners WHERE id = ".$menu->getE(2)), 0);
db_query("DELETE FROM prefix_partners WHERE id = ".$menu->getE(2));
db_query("UPDATE prefix_partners 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_partners"),0);
db_query("INSERT INTO prefix_partners (name,banner,link,pos) VALUES ('".$_POST['name']."','".$_POST['banner']."','".$_POST['link']."','".$_POST['pos']."')");
} else {
db_query("UPDATE prefix_partners 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_partners"),0);
if ($nps < 0) {
db_query("UPDATE prefix_partners SET pos = ".$anz." WHERE id = ".$id);
db_query("UPDATE prefix_partners SET pos = pos -1");
}
if ($nps >= $anz) {
db_query("UPDATE prefix_partners SET pos = -1 WHERE id = ".$id);
db_query("UPDATE prefix_partners SET pos = pos +1");
}
if ( $nps < $anz AND $nps >= 0 ) {
db_query("UPDATE prefix_partners SET pos = ".$pos." WHERE pos = ".$nps);
db_query("UPDATE prefix_partners SET pos = ".$nps." WHERE id = ".$id);
}
}
# aendern vorbereiten.
if ( $menu->getA(2) == 'e' ) {
$erg = db_query("SELECT id,name,banner,link FROM prefix_partners 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-partners' , 'partners' );
$anfang = ($page - 1) * $limit;
$abf = "SELECT id,name,link, pos FROM prefix_partners 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;
}
?>
betroffene Homepage: www.dsk2007.de
