include("db.php3");
include("config.php3");
$acc = $_REQUEST["acc"];
$limitstart = $_GET["limitstart"];
$sql = "select * from $tblAccounts where account='".$acc."'";
db_connect();
$res = send_sql($db, $sql);
$row = mysql_fetch_array($res, MYSQL_ASSOC);
$cBREITE = $row["cBREITE"];
$cFONT = $row["cFONT"];
$cLINIE = $row["cLINIE"];
$cLIMIT = $row["cLIMIT"];
$cFONTCOLOR = $row["cFONTCOLOR"];
$cBGCOLOR = $row["cBGCOLOR"];
$cBGIMAGE = $row["cBGIMAGE"];
$cTITLE = $row["cTITLE"];
$cACCOUNT = $row["account"];
$cLAYOUT = $row["cLAYOUT"];
$cLINK = $row["cLINK"];
$cALINK = $row["cALINK"];
$cVLINK = $row["cVLINK"];
$cHEADER = $row["cHEADER"];
$cFRONTER = $row["cFRONTER"];
$cFOOTER = $row["cFOOTER"];
$cWERBUNG = $row["werbung"];
$aWECHSELFARBE = explode(";", $row["cWECHSELFARBE"]);
$cEXTERNURL = $row["extern_url"];
if (empty($cFONT)) $cFONT = "Times New Roman";
if (empty($cFONTCOLOR)) $cFONTCOLOR = "#000000";
if (empty($cWechselfarbe)) $aWechselfarbe[0] = $cBGCOLOR;
if (!empty($cEXTERNURL)) {
$sEXTERN = implode("", file($cEXTERNURL));
list ($sEXTERN1, $sEXTERN2) = @split('', $sEXTERN);
}
switch ($cLAYOUT) {
case 1:
include("layout/layout_01.php3");
break;
case 2:
include("layout/layout_02.php3");
break;
case 3:
include("layout/layout_03.php3");
break;
case 4:
include("layout/layout_04.php3");
break;
}
if (!empty($cEXTERNURL)) {
print $sEXTERN1;
} else {
?>
>
}
echo $cFRONTER;
$sql = "SELECT count(*) as anzahl from ".$tblGaestebuch." where account='$cACCOUNT' AND gb_status=1";
db_connect();
$res = send_sql($db, $sql);
$row = mysql_fetch_array($res, MYSQL_ASSOC);
if ($limitstart == "") {
$limitstart = 0;
}
$i = $row["anzahl"] - $limitstart;
?>
if (($limitstart) > 0) echo "neuere Einträge"; else echo "neuere Einträge";?> |
[add.php3?acc=">Eintrag hinzufügen] |
if (($limitstart+$cLIMIT) < $row["anzahl"]) echo "ältere Einträge"; else echo "ältere Einträge";?> |
grafik/leer.gif" width="90" height="15"> |
grafik/leer.gif" width="" height="15"> |
grafik/leer.gif" width="90" height="15"> |
grafik/leer.gif" width="" height="10"> |
$sql = "SELECT * from ".$tblGaestebuch." where account='$cACCOUNT' AND gb_status=1 order by datetime DESC LIMIT ".$limitstart.", ".$cLIMIT;
db_connect();
$res = send_sql($db, $sql);
$schleife = 0;
$aktfarbe = 0;
$farbanzahl = count($aWECHSELFARBE);
while ($row2 = mysql_fetch_array($res, MYSQL_ASSOC)) {
$jahr = substr($row2["datetime"], 0, 4);
$monat = substr($row2["datetime"], 5, 2);
$tag = substr($row2["datetime"], 8, 2);
$zeit = substr($row2["datetime"], 11, 8);
##################################################################
#
# Farbe der Eintraege
#
if ($farbanzahl>0) {
if ($aktfarbe >= $farbanzahl) $aktfarbe = 0;
$cWECHSELFARBE = $aWECHSELFARBE[$aktfarbe];
$aktfarbe++;
}
else {
$cWECHSELFARBE = $cBGCOLOR;
}
##################################################################
#
# URL-Check
#
$www = $row2["www"];
if (strlen($www)>=5) {
if (substr($www, 0, 7) != "http://") $www = "http://".$www;
}
showGB($i, $row2["name"], $row2["wohnort"], $row2["icq"], $www, encodeString($row2["email"], 1), $row2["text"], $tag.".".$monat.".".$jahr, $zeit, $row2["IP"]);
$i--;
$schleife++;
}
?>
grafik/leer.gif" width="" height="1"> |
|
if (($limitstart) > 0) echo "neuere Einträge"; else echo "neuere Einträge";?> |
|
if (($limitstart+$cLIMIT) < $row["anzahl"]) echo "ältere Einträge"; else echo "ältere Einträge";?> |
|
grafik/leer.gif" width="150" height="15"> |
grafik/leer.gif" width="" height="15"> |
grafik/leer.gif" width="150" height="15"> |