ein wenig? kannst du haben xD
default.php
<?php
$tpl = new tpl ( 'gbook',1 );
// Anfang Gästebuchmod
$ei1 = @db_query("SELECT COUNT(ID) FROM prefix_gbook");
$ein = @db_result($ei1,0);
$koms1 = @db_query("SELECT COUNT(ID) FROM prefix_koms");
$koms = @db_result($koms1,0);
$durchschnitt1 = @db_query("SELECT COUNT(RATING) FROM prefix_gbook WHERE !rating='Keine Angabe'");
$ds1 = @db_result($durchschnitt1,0);
$durchschnitt2 = @db_query("SELECT sum(RATING) FROM prefix_gbook");
$ds2 = @db_result($durchschnitt2,0);
if ( $ds1 > "0" && $ds2 > "0" ) {
$ds = $ds2 / $ds1;
} else {
$ds = '-';
}
$get_gesperrt = db_query("SELECT * FROM prefix_gbook WHERE status='0'");
$gesperrt = db_num_rows($get_gesperrt);
$get_free = db_query("SELECT * FROM prefix_gbook WHERE status='1'");
$free = db_num_rows($get_free);
$get_last = db_query("SELECT * FROM prefix_gbook ORDER by id DESC");
$last = db_fetch_assoc($get_last);
if ( $last['status'] == 1 ) {
$status = '<a href="?gbook-1">Frei</a>';
} else {
$status = '<a href="?gbook-2">Gesperrt</a>';
};
$ar = array ('EINTRAGE' => $ein, 'KOMMENTARE' => $koms, 'DURCHSCHNITT' => $ds, 'GESPERRT' => $gesperrt, 'ENTSPERRT' => $free, 'LAST' => $last['txt'], 'ID' => $last['id'], 'STATUS' => $status, 'NEWEST' => $newest );
$tpl->set_ar_out($ar,0);
echo '<br />Mod by <a href="http://tr3icio.de">Tr3icio</a>';
?>
case.php
<?php
if (isset($_POST['sub'])) {
$name = escape($_POST['name'], 'string');
$mail = escape($_POST['mail'], 'string');
$page = escape($_POST['page'], 'string');
$text = escape($_POST['text'], 'string');
$gavatar = escape($_POST['avatar'], 'string');
$rating = escape($_POST['rating'], 'string');
if (empty($_POST['gid'])) {
db_query("INSERT INTO prefix_gbook (name, mail, page, txt, time, avatar, rating, status) VALUES ('".$name."','".$mail."','".$page."','".$text."', '".time()."', '".$gavatar."', '".$rating."', '1')");
} else {
$gid = escape($_POST['gid'], 'integer');
db_query("UPDATE prefix_gbook SET name = '".$name."', mail = '".$mail."', page = '".$page."', txt = '".$text."' WHERE id = ".$gid);
}
}
$r = array ('name'=>'','mail'=>'','page'=>'','text'=>'','id'=>'');
if (isset($_GET['edit'])) {
$id = escape($_GET['edit'], 'integer');
$r = db_fetch_assoc(db_query("SELECT id, name, mail, page, txt as text FROM prefix_gbook WHERE id = ".$id));
}
$tpl = new tpl ('gbook', 1);
$tpl->set_ar_out($r,1);
?>
case1.php
<?php
$design->header();
// Ab hier Gästebuchmod
$tpl = new tpl ( 'gbook', 1);
if ( !empty ($_GET['del']) ) {
$id = escape($_GET['del'], 'integer');
db_query("DELETE FROM `prefix_gbook` WHERE id = ".$id." LIMIT 1");
db_query("DELETE FROM prefix_koms WHERE uid = ".$id." AND cat = 'GBOOK'");
}
if (isset($_POST['submit1'])) {
echo '<meta http-equiv="refresh" content="0; URL=index.php?gbook">';
echo '
<table width="300" border="0" cellspacing="1" cellpadding="3" align="center" class="border">
<tr>
<th class="Chead">Weiterleitung</th>
</tr><tr>
<td class="Cnorm">
Sie werden automatisch weitergeleitet.
<br />
<br />
Dieser Vorgang nimmt eine gewisse Zeit in Anspruch. Bitte haben sie Geduld.
</td>
</tr>
</table>';
};
echo '<tr><td width="50%" style="vertical-align:top;" class="case"><table width="100%" class="border">
<td colspan="4" class="Chead">Freigegebene Eintraege</td>
<form method="post" action="">';
$erg = db_query('SELECT name, mail, txt, id FROM `prefix_gbook` WHERE status = "1" ORDER BY time DESC');
while ($r = db_fetch_assoc($erg) ) {
$text = substr(preg_replace("/\015\012|\015|\012/", " ", htmlentities(strip_tags(stripslashes($r['txt'])))),0,75);
echo '<tr class="Cmite">
<td width="20px;"><a href="admin.php?gbook=0&edit='.$r['id'].'"><img src="include/images/icons/edit.gif" /></a></td>
<td width="20px;"><a href="?gbook-1&del='.$r['id'].'"><img src="include/images/icons/del.gif"></a></td>
<td><b><a href="mailto:'.$r['mail'].'">'.$r['name'].'</a></b> <span class="smalfont">
'.$text.' </span></td>
<td width="20"><form action="" method="post">
<input type="checkbox" name="'.$r['id'].'" id="check1" />
</td>
</tr>';
if (isset($_POST['submit1'])) {
while ( isset($_POST['submit1']) ) {
db_query("UPDATE prefix_gbook SET status = '0' WHERE id = ".$r['id']);
};
};
};
echo '<tr>
<td colspan="4" class="Cmite" style="text-align:center;">
<input type="submit" name="submit1" /></form>
</td>
</tr>
</table></td>';
// Bis hier
$design->footer();
?>
case2.php
<?php
$design->header();
// Gästebuchmod von hier
$tpl = new tpl ( 'gbook', 1);
if ( !empty ($_GET['del']) ) {
$id = escape($_GET['del'], 'integer');
db_query("DELETE FROM `prefix_gbook` WHERE id = ".$id." LIMIT 1");
db_query("DELETE FROM prefix_koms WHERE uid = ".$id." AND cat = 'GBOOK'");
}
if (isset($_POST['submit2'])) {
echo '<meta http-equiv="refresh" content="0; URL=index.php?gbook">';
echo '
<table width="300" border="0" cellspacing="1" cellpadding="3" align="center" class="border">
<tr>
<th class="Chead">Weiterleitung</th>
</tr><tr>
<td class="Cnorm">
Sie werden automatisch weitergeleitet.
<br />
<br />
Dieser Vorgang nimmt eine gewisse Zeit in Anspruch. Bitte haben sie Geduld.
</td>
</tr>
</table>';
};
echo '<td width="50%" style="vertical-align:top;" class="case"><table width="100%" class="border">
<td colspan="4" class="Chead">Gesperrte Eintraege</td>';
$erg = db_query('SELECT name, mail, txt, id FROM `prefix_gbook` WHERE status = "0" ORDER BY time DESC');
while ($r = db_fetch_assoc($erg) ) {
$text = substr(preg_replace("/\015\012|\015|\012/", " ", htmlentities(strip_tags(stripslashes($r['txt'])))),0,75);
echo '<tr class="Cmite">';
echo '<td width="20px;"><a href="admin.php?gbook=0&edit='.$r['id'].'"><img src="include/images/icons/edit.gif" /></a></td>';
echo '<td width="20px;"><a href="?gbook-2&del='.$r['id'].'"><img src="include/images/icons/del.gif"></a></td>';
echo '<td><b><a href="mailto:'.$r['mail'].'">'.$r['name'].'</a></b> <span class="smalfont">';
echo $text.'</span></td>
<td width="20"><form action="" method="post">
<input type="checkbox" name="'.$r['id'].'" id="check2" />
</td>
</tr>';
if (isset($_POST['submit2'])) {
while ( isset($_POST['submit2']) ) {
db_query("UPDATE prefix_gbook SET status = '1' WHERE id = ".$r['id']);
};
};
};
echo '<tr>
<td colspan="4" class="Cmite" style="text-align:center;">
<input type="submit" name="submit2" /></form>
</td>
</tr>
</table></td></tr>';
// Bis hier
$design->footer();
?>
gbook.php
<?php
# Copyright by: Manuel
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
defined ('admin') or die ( 'only admin access' );
$design = new design ( 'Admins Area', 'Admins Area', 2 );
$design->header();
$page = ( $menu->getA(1) == 'p' ? escape($menu->getE(1), 'integer') : 1 );
$anfang = ($page - 1);
switch($menu->get(1)) {
default:
include("gbook/default.php");
include("gbook/case.php");
break;
case 1 :
include("gbook/case1.php");
break;
case 2 :
include("gbook/case2.php");
break;
};
$design->footer();
?>
