#!/usr/bin/perl
use strict;
use Carp;
use English;
use DBI;
use CGI ':standard';
use Encode;
use File::Basename;
#require "ctime.pl";
#use String::Random;
use CGI::Carp qw ( fatalsToBrowser );
#########################################################
# eigene Module einbinden
#########################################################
#use lib "/local/perlmodule";
use lib "./perl";
use Netcity::Templates;
use Netcity::DB;
use Netcity::Login;
use Netcity::Datum;
# query-Objekt initialisieren
my $query_cgi = new CGI;
my $params = $query_cgi->Vars; # Vars-Methode liefert tied hash reference
my $dbh;
my $query = "";
my $sth;
my $rv;
my @row;
my $template;
my $redirect_url;
my %zuordnungen;
#my %wert;
# zu Datenbank connecten
$dbh = DBI->connect('DBI:mysql:database=tfanzeiger;host=localhost;3306','tfanzeiger','Yrfj7^76');
$query = qq[set names 'utf8'];
$sth = $dbh->prepare($query);
$rv = $sth->execute;
# Formular-/Tabellenfelder zuordnen
init_zuordnungen();
if ($params->{page} eq "start") {
show_start();
}
elsif ($params->{page} eq "news-liste") {
show_news_liste();
}
elsif ($params->{page} eq "news") {
show_news();
}
elsif ($params->{page} eq "news-suche") {
show_news_liste();
#show_news_suche();
}
elsif ($params->{page} eq "news-include") {
get_news_liste({rubrik=>$params->{rubrik}, anzahl=>3, typ=>"include"});
}
elsif ($params->{page} eq "impressum") {
show_impressum();
}
else {
show_start();
}
sub show_start {
###########################################################################
# Liste der vorhandenen News anzeigen
my $liste_nachrichten = "";
my $liste_termine = "";
my $liste_sonstiges = "";
$liste_nachrichten = get_news_liste({rubrik=>1, anzahl=>5, typ=>"start"});
$liste_termine = get_news_liste({rubrik=>2, anzahl=>5, typ=>"start"});
$liste_sonstiges = get_news_liste({rubrik=>3, anzahl=>5, typ=>"start"});
$template = get_template({page=>'start', directory=>'./templates'});
$template =~ s//$liste_nachrichten/eg;
$template =~ s//$liste_termine/eg;
$template =~ s//$liste_sonstiges/eg;
print "Content-type: text/html; charset=utf-8\n\n";
print $template;
exit;
}
sub show_news_liste {
###########################################################################
# Liste der vorhandenen News anzeigen
my $anzahl = 25;
my $query = "";
my $sth;
my $rv;
my @row;
my $template;
my $subtemplate_vorlage;
my $subtemplate;
my $liste = "";
my $news_id = "";
my $news_rubrik = "";
my $news_rubrik_name = "";
my $news_headline = "";
my $news_kurztext = "";
my $news_bild1 = "";
my $news_bild1_titel = "";
my $news_bild1_credit = "";
my $news_datum_von = "";
my $news_datum_bis = "";
my $news_beginn = "";
my $news_datum = "";
my $rubrik;
my $termin;
my $bild1;
my $filter_suche = qq{and news.rubrik=$params->{rubrik}};
my $filter_rubrik = "";
#my $limit = qq{LIMIT $anzahl};
#my $order = "if(isnull(news.erscheint_von),news.datum_created,news.erscheint_von) DESC, news.datum_created DESC";
my $order = "news.erscheint_von DESC, news.id DESC";
#if ($rubrik == 2) {
# # Termine
# $order = "news.datum_von ASC"; # nach Termin-Datum aufsteigend sortieren
#}
if ($params->{page} eq "news-suche") {
# Such-Filter
$filter_suche = qq{and (MATCH (news.headline, news.kurztext, news.inhalt) AGAINST ('$params->{search}' IN BOOLEAN MODE))};
#$filter_suche = qq{and (MATCH (news.headline, news.kurztext, news.inhalt) AGAINST ('$params->{search}'))};
$filter_rubrik = "";
}
if ($rubrik == 2) {
# Termine
#$filter = qq{$filter and (news.datum_von >= date(NOW()))}; # abgelaufene Termine ausblenden
}
# Limit
if ($params->{start} <= 0) {
$params->{start} = 1;
}
my $start_mysql = $params->{start} - 1; # MySQL beginnt bei 0 an zu zaehlen...
my $limit = qq{LIMIT $start_mysql, $anzahl};
# Limit Ende
# Anzahl ermitteln
$query = qq{select count(news.id)
from news
where news.unsichtbar != "x"
and (isnull(news.erscheint_von) or news.erscheint_von <= date(NOW()))
and (isnull(news.erscheint_bis) or news.erscheint_bis >= date(NOW()))
$filter_rubrik
$filter_suche
order by $order
};
$sth = $dbh->prepare($query);
$rv = $sth->execute;
@row = $sth->fetchrow_array;
my $gesamtanzahl = $row[0];
# Ende Anzahl ermitteln
#####################################################################################
# ggf. noch Name der Rubrik ermitteln (nicht noetig bei Suche z.B.)
if ($params->{rubrik} ne "") {
$query = qq{select
newsrubriken.name
from newsrubriken
where newsrubriken.id=$params->{rubrik}
};
$sth = $dbh->prepare($query);
$rv = $sth->execute;
if ($rv ne "0E0") {
@row = $sth->fetchrow_array;
$news_rubrik_name = $row[0];
}
else {
$news_rubrik_name = "";
}
}
else {
if ($params->{search} ne "") {
$news_rubrik_name = qq{Suchergebnis für '$params->{search}'};
}
else {
$news_rubrik_name = "";
}
}
# ENDE Name der Rubrik
#####################################################################################
$query = qq{select
news.id,
news.rubrik,
news.headline,
news.kurztext,
news.bild1,
news.bild1_titel,
news.bild1_credit,
news.datum_von,
news.datum_bis,
news.beginn
from news
where news.unsichtbar != "x"
and (isnull(news.erscheint_von) or news.erscheint_von <= date(NOW()))
and (isnull(news.erscheint_bis) or news.erscheint_bis >= date(NOW()))
$filter_rubrik
$filter_suche
order by $order
$limit
};
$sth = $dbh->prepare($query);
$rv = $sth->execute;
if ($rubrik == 2) {
$termin = "yes";
}
else {
$termin = "no";
}
$subtemplate_vorlage = get_template({page=>'subtemplate_news_liste', directory=>'./templates', variables=>{termin=>$termin}});
if ($rv ne "0E0") {
while (@row = $sth->fetchrow_array) {
$news_id = $row[0];
$news_rubrik = $row[1];
$news_headline = $row[2];
$news_kurztext = $row[3];
$news_bild1 = $row[4];
$news_bild1_titel = $row[5];
$news_bild1_credit = $row[6];
$news_datum_von = $row[7];
$news_datum_bis = $row[8];
$news_beginn = $row[9];
if ($news_headline eq "") {
$news_headline = "ohne Titel";
}
if ($news_datum_von ne "") {
if ($news_datum_bis eq "") {
$news_datum = qq{$news_datum_von: };
}
else {
$news_datum = qq{$news_datum_von - $news_datum_bis: };
}
}
else {
$news_datum = "";
}
$subtemplate = $subtemplate_vorlage;
#if ($news_bild1 ne "") {
# $bild1 = "yes";
#}
#else {
# $bild1 = "no";
#}
$subtemplate = get_template({page=>'subtemplate_news_liste', directory=>'./templates', variables=>{termin=>$termin, bild1=>$news_bild1}});
$subtemplate =~ s//$news_id/eg;
$subtemplate =~ s//$news_headline/eg;
$subtemplate =~ s//$news_kurztext/eg;
$subtemplate =~ s//$news_bild1/eg;
$subtemplate =~ s//$news_bild1_titel/eg;
$subtemplate =~ s//$news_bild1_credit/eg;
$subtemplate =~ s//$news_datum_von/eg;
$subtemplate =~ s//$news_datum_bis/eg;
$subtemplate =~ s//$news_datum/eg;
$subtemplate =~ s//$news_beginn/eg;
$liste .= $subtemplate;
}
}
else {
#(noch) keine News...
$liste = qq{
Meldungen in dieser Rubrik folgen in Kürze
};
}
# Blaettern neu
my $blaetterstep = 25;
my $blaetter_element = "";
if ($gesamtanzahl > $blaetterstep) {
# nur wenn auch mehrere Seiten!
my $blaetterseite = 1;
my $vorblaettern = 1;
my $zurueckblaettern = 1;
my $blaetterseite_anzeige = "";
$liste .= qq{};
}
# ende Blaettern neu
$template = get_template({page=>'news_liste', directory=>'./templates'});
$template =~ s//$liste/eg;
$template =~ s//$blaetter_element/eg;
$template =~ s//$news_rubrik_name/eg;
print "Content-type: text/html; charset=utf-8\n\n";
print $template;
exit;
}
sub get_news_liste {
###########################################################################
# Liste der vorhandenen News anzeigen
my ($arg_ref) = @_; # uebergebene Argumente
my $rubrik = $arg_ref->{rubrik};
my $anzahl = $arg_ref->{anzahl};
my $typ = $arg_ref->{typ};
my $query = "";
my $sth;
my $rv;
my @row;
my $template;
my $subtemplate_vorlage;
my $subtemplate;
my $liste = "";
my $bild1;
my $news_id = "";
my $news_rubrik = "";
my $news_rubrik_name = "";
my $news_headline = "";
my $news_kurztext = "";
my $news_bild1 = "";
my $news_bild1_titel = "";
my $news_bild1_credit = "";
my $news_datum_created = "";
my $news_datum_von = "";
my $news_datum_bis = "";
my $news_beginn = "";
my $news_datum = "";
my $filter = "";
my $limit = qq{LIMIT $anzahl};
#my $order = "if(isnull(news.erscheint_von),news.datum_created,news.erscheint_von) DESC, news.datum_created DESC";
my $order = "news.erscheint_von DESC, news.id DESC";
#if ($rubrik == 2) {
# # Termine
# $order = "news.datum_von ASC"; # nach Termin-Datum aufsteigend sortieren
#}
$filter = qq{news.rubrik=$rubrik};
if ($filter ne "") {
$filter = qq{and $filter};
}
if ($rubrik == 2) {
# Termine wird zu diverses RAND
$filter = qq{and (news.rubrik=9 or news.rubrik=13 or news.rubrik=10 or news.rubrik=11) and not isnull(news.bild1)};
$order = "rand()";
}
if ($rubrik == 3) {
# Sonstiges/Vermischtes wird zu Eigenwerbung RAND
$order = "rand()";
}
$query = qq{select
news.id,
news.rubrik,
news.headline,
news.kurztext,
news.bild1,
news.bild1_titel,
news.bild1_credit,
news.datum_created,
news.datum_von,
news.datum_bis,
news.beginn
from news
where news.unsichtbar != "x"
and (isnull(news.erscheint_von) or news.erscheint_von <= date(NOW()))
and (isnull(news.erscheint_bis) or news.erscheint_bis >= date(NOW()))
$filter
order by $order
$limit
};
$sth = $dbh->prepare($query);
$rv = $sth->execute;
if ($typ eq "start") {
$subtemplate_vorlage = get_template({page=>'subtemplate_news_liste_start', directory=>'./templates'});
}
elsif ($typ eq "include") {
$subtemplate_vorlage = get_template({page=>'subtemplate_news_liste_include', directory=>'./templates'});
}
elsif ($typ eq "list") {
$subtemplate_vorlage = get_template({page=>'subtemplate_news', directory=>'./templates'});
}
else {
$subtemplate_vorlage = get_template({page=>'subtemplate_news', directory=>'./templates'});
}
if ($rv ne "0E0") {
while (@row = $sth->fetchrow_array) {
$news_id = $row[0];
$news_rubrik = $row[1];
$news_headline = $row[2];
$news_kurztext = $row[3];
$news_bild1 = $row[4];
$news_bild1_titel = $row[5];
$news_bild1_credit = $row[6];
$news_datum_created = $row[7];
$news_datum_von = $row[8];
$news_datum_bis = $row[9];
$news_beginn = $row[10];
if ($news_headline eq "") {
$news_headline = "ohne Titel";
}
if ($news_datum_von ne "") {
if ($news_datum_bis eq "") {
$news_datum = qq{$news_datum_von: };
}
else {
$news_datum = qq{$news_datum_von - $news_datum_bis: };
}
}
else {
$news_datum = "";
}
#$subtemplate = $subtemplate_vorlage;
if ($news_bild1 ne "") {
$bild1 = "yes";
}
else {
$bild1 = "no";
}
if ($typ eq "start") {
$subtemplate = get_template({page=>'subtemplate_news_liste_start', directory=>'./templates', variables=>{bild1=>$bild1}});
}
elsif ($typ eq "include") {
$subtemplate = get_template({page=>'subtemplate_news_liste_include', directory=>'./templates', variables=>{bild1=>$bild1}});
}
elsif ($typ eq "list") {
$subtemplate = get_template({page=>'subtemplate_news', directory=>'./templates', variables=>{bild1=>$bild1}});
}
else {
$subtemplate = get_template({page=>'subtemplate_news', directory=>'./templates', variables=>{bild1=>$bild1}});
}
$subtemplate =~ s//$news_id/eg;
$subtemplate =~ s//$news_headline/eg;
$subtemplate =~ s//$news_kurztext/eg;
$subtemplate =~ s//$news_bild1/eg;
$subtemplate =~ s//$news_bild1_titel/eg;
$subtemplate =~ s//$news_bild1_credit/eg;
$subtemplate =~ s//$news_datum_created/eg;
$subtemplate =~ s//$news_datum_von/eg;
$subtemplate =~ s//$news_datum_bis/eg;
$subtemplate =~ s//$news_datum/eg;
$subtemplate =~ s//$news_beginn/eg;
$liste .= $subtemplate;
}
}
else {
#(noch) keine News...
$liste = qq{Meldungen in dieser Rubrik folgen in Kürze
};
}
#$template = get_template({page=>'include_news_vorschau', directory=>'./templates'});
#$template =~ s//$liste/eg;
#return $template;
if ($typ eq "include") {
print "Content-type: text/html; charset=utf-8\n\n";
print $liste;
exit;
}
return $liste;
}
sub show_news {
my $template;
my $news_datum = "";
my $liste_sonstiges = "";
my $news_kurztext_200 = "";
# Liefert Hash-Referenz zurueck, deren Inhalt(Hash) wird dann gleich an Hash kopiert
my %wert = %{load_felder ({seite=>"news", id=>$params->{'id'}, zuordnungen=>\%zuordnungen, dbh=>$dbh, table=>"news"})};
#load_felder('behaelter', $params->{'id'});
# Zeilenumbrüche wiederherstellen
$wert{inhalt} =~ s/\n/
/g;
if ($wert{datum_von} ne "") {
if ($wert{datum_bis} eq "") {
$news_datum = qq{$wert{datum_von}};
}
else {
$news_datum = qq{$wert{datum_von} - $wert{datum_bis}};
}
}
if ($wert{link1} ne "" && $wert{link1_titel} eq "") {
$wert{link1_titel} = $wert{link1};
}
if ($wert{link2} ne "" && $wert{link2_titel} eq "") {
$wert{link2_titel} = $wert{link2};
}
if ($wert{download1} ne "" && $wert{download1_titel} eq "") {
$wert{download1_titel} = "Download 1";
}
if ($wert{download2} ne "" && $wert{download2_titel} eq "") {
$wert{download2_titel} = "Download 2";
}
$liste_sonstiges = get_news_liste({rubrik=>3, anzahl=>5, typ=>"start"});
$news_kurztext_200 = substr($wert{kurztext},0,200); # fuer META Description maximal 200 Zeichen aus dem Kurztext nehmen...
if (index($news_kurztext_200, '<') != -1 || index($news_kurztext_200, '>') != -1) {
$news_kurztext_200 = $wert{headline}; # erstmal Notloesung
}
$news_kurztext_200 =~ s/"/'/g; # " durch ' ersetzen
$template = get_template({page=>'news', directory=>'./templates', variables=>{bild1=>$wert{bild1}, bild2=>$wert{bild2}, bild3=>$wert{bild3}, bild4=>$wert{bild4}, bild5=>$wert{bild5}, bild6=>$wert{bild6}, bild7=>$wert{bild7}, bild8=>$wert{bild8}, bild9=>$wert{bild9}, bild10=>$wert{bild10}, bild11=>$wert{bild11}, bild12=>$wert{bild12}, bild13=>$wert{bild13}, bild14=>$wert{bild14}, bild15=>$wert{bild15}, link1=>$wert{link1}, link2=>$wert{link2}, download1=>$wert{download1}, download2=>$wert{download2}}});
$template =~ s//$params->{'id'}/eg;
#$template = replace_login_tags ({session=>$params->{'session'}, user=>\%user, template=>$template});
$template = replace_form_fields ({template=>$template, namespace=>'news', zuordnungen=>\%zuordnungen, wert=>\%wert, seite=>'news'});
$template =~ s//$news_datum/eg;
# "Werbespalte" mit speziellen Beitraegen
$template =~ s//$liste_sonstiges/eg;
$template =~ s//$news_kurztext_200/eg;
print "Content-type: text/html; charset=utf-8\n\n";
print $template;
exit;
}
sub show_impressum {
###########################################################################
$template = get_template({page=>'impressum', directory=>'./templates'});
print "Content-type: text/html; charset=utf-8\n\n";
print $template;
exit;
}
sub init_zuordnungen
# Initialisierung der Feld-Zuordnungen Formular<->Datenbank
{
%zuordnungen =
(
id =>
{
form_type => "text",
db_field => "id",
db_type => "int",
content_type=> "int",
page => q{},
},
rubrik =>
{
form_type => "select",
ref_table => "newsrubriken",
ref_column => "name",
db_field => "rubrik",
db_type => "int",
content_type=> "int",
page => 'news:rw, newsupdate:rw',
},
headline =>
{
form_type => "text",
db_field => "headline",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
kurztext =>
{
form_type => "text",
db_field => "kurztext",
db_type => "text",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
inhalt =>
{
form_type => "text",
db_field => "inhalt",
db_type => "text",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
quelle =>
{
form_type => "text",
db_field => "quelle",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild1 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild1.jpg",
db_field => "bild1",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild1_titel =>
{
form_type => "text",
db_field => "bild1_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild1_credit =>
{
form_type => "text",
db_field => "bild1_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild2 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild2.jpg",
db_field => "bild2",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild2_titel =>
{
form_type => "text",
db_field => "bild2_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild2_credit =>
{
form_type => "text",
db_field => "bild2_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild3 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild3.jpg",
db_field => "bild3",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild3_titel =>
{
form_type => "text",
db_field => "bild3_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild3_credit =>
{
form_type => "text",
db_field => "bild3_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild4 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild4.jpg",
db_field => "bild4",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild4_titel =>
{
form_type => "text",
db_field => "bild4_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild4_credit =>
{
form_type => "text",
db_field => "bild4_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild5 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild5.jpg",
db_field => "bild5",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild5_titel =>
{
form_type => "text",
db_field => "bild5_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild5_credit =>
{
form_type => "text",
db_field => "bild5_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild6 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild6.jpg",
db_field => "bild6",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild6_titel =>
{
form_type => "text",
db_field => "bild6_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild6_credit =>
{
form_type => "text",
db_field => "bild6_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild7 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild7.jpg",
db_field => "bild7",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild7_titel =>
{
form_type => "text",
db_field => "bild7_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild7_credit =>
{
form_type => "text",
db_field => "bild7_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild8 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild8.jpg",
db_field => "bild8",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild8_titel =>
{
form_type => "text",
db_field => "bild8_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild8_credit =>
{
form_type => "text",
db_field => "bild8_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild9 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild9.jpg",
db_field => "bild9",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild9_titel =>
{
form_type => "text",
db_field => "bild9_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild9_credit =>
{
form_type => "text",
db_field => "bild9_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild10 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild10.jpg",
db_field => "bild10",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild10_titel =>
{
form_type => "text",
db_field => "bild10_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild10_credit =>
{
form_type => "text",
db_field => "bild10_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild11 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild11.jpg",
db_field => "bild11",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild11_titel =>
{
form_type => "text",
db_field => "bild11_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild11_credit =>
{
form_type => "text",
db_field => "bild11_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild12 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild12.jpg",
db_field => "bild12",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild12_titel =>
{
form_type => "text",
db_field => "bild12_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild12_credit =>
{
form_type => "text",
db_field => "bild12_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild13 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild13.jpg",
db_field => "bild13",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild13_titel =>
{
form_type => "text",
db_field => "bild13_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild13_credit =>
{
form_type => "text",
db_field => "bild13_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild14 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild14.jpg",
db_field => "bild14",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild14_titel =>
{
form_type => "text",
db_field => "bild14_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild14_credit =>
{
form_type => "text",
db_field => "bild14_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild15 =>
{
form_type => "file",
basedir => "../../files/news",
filename => "bild15.jpg",
db_field => "bild15",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
bild15_titel =>
{
form_type => "text",
db_field => "bild15_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
bild15_credit =>
{
form_type => "text",
db_field => "bild15_credit",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
link1 =>
{
form_type => "text",
db_field => "link1",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
link1_titel =>
{
form_type => "text",
db_field => "link1_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
link1_target =>
{
form_type => "text",
db_field => "link1_target",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
link2 =>
{
form_type => "text",
db_field => "link2",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
link2_titel =>
{
form_type => "text",
db_field => "link2_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
link2_target =>
{
form_type => "text",
db_field => "link2_target",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
download1 =>
{
form_type => "file",
basedir => "../../files/news",
db_field => "download1",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
download1_titel =>
{
form_type => "text",
db_field => "download1_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
download2 =>
{
form_type => "file",
basedir => "../../files/news",
db_field => "download2",
db_type => "varchar",
content_type=> "file",
page => 'news:rw, newsupdate:rw',
},
download2_titel =>
{
form_type => "text",
db_field => "download2_titel",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
datum_created =>
{
form_type => "text",
db_field => "datum_created",
db_type => "datetime",
content_type=> "datetime",
page => 'news:rw, newsupdate:r',
},
created_by =>
{
form_type => "text",
db_field => "created_by",
db_type => "int",
content_type=> "int",
page => 'news:rw, newsupdate:r',
},
datum_changed =>
{
form_type => "text",
db_field => "datum_changed",
db_type => "datetime",
content_type=> "datetime",
page => 'news:rw, newsupdate:rw',
},
changed_by =>
{
form_type => "text",
db_field => "changed_by",
db_type => "int",
content_type=> "int",
page => 'news:rw, newsupdate:rw',
},
erscheint_von =>
{
form_type => "text",
db_field => "erscheint_von",
db_type => "date",
content_type=> "date",
page => 'news:rw, newsupdate:rw',
},
erscheint_bis =>
{
form_type => "text",
db_field => "erscheint_bis",
db_type => "date",
content_type=> "date",
page => 'news:rw, newsupdate:rw',
},
unsichtbar =>
{
form_type => "checkbox",
db_field => "unsichtbar",
db_type => "char",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
datum_von =>
{
form_type => "text",
db_field => "datum_von",
db_type => "date",
content_type=> "date",
page => 'news:rw, newsupdate:rw',
},
datum_bis =>
{
form_type => "text",
db_field => "datum_bis",
db_type => "date",
content_type=> "date",
page => 'news:rw, newsupdate:rw',
},
ausblenden_nach_ablauf=>
{
form_type => "checkbox",
db_field => "ausblenden_nach_ablauf",
db_type => "char",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
beginn =>
{
form_type => "text",
db_field => "beginn",
db_type => "varchar",
content_type=> "text",
page => 'news:rw, newsupdate:rw',
},
);
return;
}