wen ich im Admin-Bereich auf "Downloads" gehe kommt das hier:
chiv/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; } ?>
Siehe auch: externer Link
Wie kann ich das beheben?
Zuletzt modifiziert von SeToY am 26.01.2007 - 17:41:49
