du musst die archiv.php (nclude\admin) aus dem Modulpack von SLJ nochmal hochladen.
Solltest du ander Module benutzen dann nur folgenden Code in die Datei einfügen:
<?php
# partners1
case 'partners1' :
$design = new design ( 'Admins Area', 'Admins Area', 2 );
$design->header();
$tpl = new tpl ( 'archiv/partners1', 1);
# loeschen
if ( $menu->getA(2) == 'd' ) {
$pos = db_result(db_query("SELECT pos FROM prefix_partners1 WHERE id = ".$menu->getE(2)), 0);
db_query("DELETE FROM prefix_partners1 WHERE id = ".$menu->getE(2));
db_query("UPDATE prefix_partners1 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_partners1"),0);
db_query("INSERT INTO prefix_partners1 (name,banner,link,pos) VALUES ('".$_POST['name']."','".$_POST['banner']."','".$_POST['link']."','".$_POST['pos']."')");
} else {
db_query("UPDATE prefix_partners1 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_partners1"),0);
if ($nps < 0) {
db_query("UPDATE prefix_partners1 SET pos = ".$anz." WHERE id = ".$id);
db_query("UPDATE prefix_partners1 SET pos = pos -1");
}
if ($nps >= $anz) {
db_query("UPDATE prefix_partners1 SET pos = -1 WHERE id = ".$id);
db_query("UPDATE prefix_partners1 SET pos = pos +1");
}
if ( $nps < $anz AND $nps >= 0 ) {
db_query("UPDATE prefix_partners1 SET pos = ".$pos." WHERE pos = ".$nps);
db_query("UPDATE prefix_partners1 SET pos = ".$nps." WHERE id = ".$id);
}
}
# aendern vorbereiten.
if ( $menu->getA(2) == 'e' ) {
$erg = db_query("SELECT id,name,banner,link FROM prefix_partners1 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-partners1' , 'partners1' );
$anfang = ($page - 1) * $limit;
$abf = "SELECT id,name,link, pos FROM prefix_partners1 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;
# partners2
case 'partners2' :
$design = new design ( 'Admins Area', 'Admins Area', 2 );
$design->header();
$tpl = new tpl ( 'archiv/partners2', 1);
# loeschen
if ( $menu->getA(2) == 'd' ) {
$pos = db_result(db_query("SELECT pos FROM prefix_partners2 WHERE id = ".$menu->getE(2)), 0);
db_query("DELETE FROM prefix_partners2 WHERE id = ".$menu->getE(2));
db_query("UPDATE prefix_partners2 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_partners2"),0);
db_query("INSERT INTO prefix_partners2 (name,banner,link,pos) VALUES ('".$_POST['name']."','".$_POST['banner']."','".$_POST['link']."','".$_POST['pos']."')");
} else {
db_query("UPDATE prefix_partners2 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_partners2"),0);
if ($nps < 0) {
db_query("UPDATE prefix_partners2 SET pos = ".$anz." WHERE id = ".$id);
db_query("UPDATE prefix_partners2 SET pos = pos -1");
}
if ($nps >= $anz) {
db_query("UPDATE prefix_partners2 SET pos = -1 WHERE id = ".$id);
db_query("UPDATE prefix_partners2 SET pos = pos +1");
}
if ( $nps < $anz AND $nps >= 0 ) {
db_query("UPDATE prefix_partners2 SET pos = ".$pos." WHERE pos = ".$nps);
db_query("UPDATE prefix_partners2 SET pos = ".$nps." WHERE id = ".$id);
}
}
# aendern vorbereiten.
if ( $menu->getA(2) == 'e' ) {
$erg = db_query("SELECT id,name,banner,link FROM prefix_partners2 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-partners2' , 'partners2' );
$anfang = ($page - 1) * $limit;
$abf = "SELECT id,name,link, pos FROM prefix_partners2 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;
# partners3
case 'partners3' :
$design = new design ( 'Admins Area', 'Admins Area', 2 );
$design->header();
$tpl = new tpl ( 'archiv/partners3', 1);
# loeschen
if ( $menu->getA(2) == 'd' ) {
$pos = db_result(db_query("SELECT pos FROM prefix_partners3 WHERE id = ".$menu->getE(2)), 0);
db_query("DELETE FROM prefix_partners3 WHERE id = ".$menu->getE(2));
db_query("UPDATE prefix_partners3 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_partners3"),0);
db_query("INSERT INTO prefix_partners3 (name,banner,link,pos) VALUES ('".$_POST['name']."','".$_POST['banner']."','".$_POST['link']."','".$_POST['pos']."')");
} else {
db_query("UPDATE prefix_partners3 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_partners3"),0);
if ($nps < 0) {
db_query("UPDATE prefix_partners3 SET pos = ".$anz." WHERE id = ".$id);
db_query("UPDATE prefix_partners3 SET pos = pos -1");
}
if ($nps >= $anz) {
db_query("UPDATE prefix_partners3 SET pos = -1 WHERE id = ".$id);
db_query("UPDATE prefix_partners3 SET pos = pos +1");
}
if ( $nps < $anz AND $nps >= 0 ) {
db_query("UPDATE prefix_partners3 SET pos = ".$pos." WHERE pos = ".$nps);
db_query("UPDATE prefix_partners3 SET pos = ".$nps." WHERE id = ".$id);
}
}
# aendern vorbereiten.
if ( $menu->getA(2) == 'e' ) {
$erg = db_query("SELECT id,name,banner,link FROM prefix_partners3 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-partners3' , 'partners3' );
$anfang = ($page - 1) * $limit;
$abf = "SELECT id,name,link, pos FROM prefix_partners3 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;
}
?>
Gr Elmser
Zuletzt modifiziert von Elmser am 12.11.2007 - 16:58:03