CONTENIDO Forum

Code: Alles auswählen

DROP TABLE IF EXISTS con_events; 
CREATE TABLE con_events ( 
  id int(11) NOT NULL auto_increment, 
  titel varchar(50) NOT NULL default '', 
  datum varchar(14) NOT NULL default '', 
  desc text NOT NULL, 
  ort varchar(50) default NULL, 
  online tinyint(1) NOT NULL default '1', 
  url varchar(50) default NULL, 
  datum2 varchar(14) NOT NULL default '', 
  PRIMARY KEY  (id) 
) TYPE=MyISAM;

Code: Alles auswählen

CREATE TABLE con_events ( 
  id int(11) NOT NULL auto_increment, 
  titel varchar(50) NOT NULL default '', 
  datum varchar(14) NOT NULL default '', 
  xxx text NOT NULL, 
  ort varchar(50) default NULL, 
  online tinyint(1) NOT NULL default '1', 
  url varchar(50) default NULL, 
  datum2 varchar(14) NOT NULL default '', 
  PRIMARY KEY  (id) 
) TYPE=MyISAM;

Code: Alles auswählen

$meineseite=$auth->url(); 


//wenn "online" als aktion übergeben wird und wir noch im edit-modus sind 

if (($online > -1) && $perm->have_perm("admin")) { 
    $sql = "UPDATE con_events SET online=".$online." WHERE id='".$eventid."'"; 
    //echo $sql; 
    $db->query($sql); 
} 

if (($delete) && $perm->have_perm("admin")) { 
    $sql = " DELETE FROM con_events WHERE id='".$eventid."' AND online='0'"; 
    //echo $sql; 
    $db->query($sql); 
} 

//neuer eintrag 

if ($send && $perm->have_perm("admin")) { 
    $datum1 = str_replace(".", "-", $datum1); 
    $datum1 = str_replace("/", "-", $datum1); 
    $datum2 = str_replace(".", "-", $datum2); 
    $datum2 = str_replace("/", "-", $datum2); 
    $uhrzeit = str_replace(".", ":", $uhrzeit); 
    $uhrzeit = str_replace("-", ":", $uhrzeit); 
    
    $arr = split('-',$datum1); 
    $date1 = sprintf("%04d",$arr[2]).sprintf("%02d",$arr[1]).sprintf("%02d",$arr[0]); 
    $arr = split(":",$uhrzeit); 
    $date1 .= sprintf("%02d",$arr[0]).sprintf("%02d",$arr[1])."00"; 
    $arr = split(".",$datum2); 
    $date2 = sprintf("%04d",$arr[2]).sprintf("%02d",$arr[1]).sprintf("%02d",$arr[0])."000000"; 
    $sql = "INSERT INTO con_events (titel,datum,mydesc,ort,online,url,datum2) VALUES ('".$titel."', '".$date1."', '".$mydesc."', '".$ort."', '".$online."', '".$url."', '".$date2."') "; 
    $db->query($sql); 
} 



if($perm->have_perm("admin")) 
    $sql = "SELECT * FROM con_events WHERE datum > ".date("Ymd")."000000 ORDER BY datum"; 
else 
    $sql = "SELECT * FROM con_events WHERE datum > ".date("Ymd")."000000 AND online=1 ORDER BY datum"; 
    
$db->query($sql); 

//echo $sql; 

$monat = array("Januar", "Februar", "März", "April", "Mai", "Juni", "Juli", "August", "September", "Oktober", "November", "Dezember"); 

$aktmon = "000000"; 

// Auslesen des Ergebnisse pro Reihe und Generierung der Seite 
while ($db->next_record()) { 
    echo '<a name="event'.$db->f("id").'"></a>'; 
    if ($aktmon < substr($db->f("datum"),0,6)) { 
        $aktmon = substr($db->f("datum"),0,6); 
        echo '<p class="hl3">'.$monat[substr($aktmon,4,2)-1].' '.substr($aktmon,0,4).'</p>'; 
    } 
    echo '<p><b>'.$db->f("titel").'</b></p>'; 
    echo '<p><i>'; 
    $mydatum = substr($db->f("datum"),6,2).".".substr($db->f("datum"),4,2).".".substr($db->f("datum"),0,4); 
    $mytime = substr($db->f("datum"),8,2).".".substr($db->f("datum"),10,2); 
    echo $mydatum." - ".$mytime." Uhr"; 
    if ($db->f("datum2")>0) { 
       $mydatum = substr($db->f("datum2"),6,2).".".substr($db->f("datum2"),4,2).".".substr($db->f("datum2"),0,4); 
       $mytime = substr($db->f("datum2"),8,2).".".substr($db->f("datum2"),10,2); 
       echo " bis ".$mydatum." - ".$mytime." Uhr"; 
    } 
    echo ", ".$db->f("ort"); 
    echo ".</i> "; 
    echo $db->f("mydesc"); 
    if ($db->f("url")!="") { 
        echo "<br><br>"; 
        echo '<a href="'.$db->f("url").'" target="_blank">Weitere Informationen</a>'; 
    } 
    if($perm->have_perm("admin")) { 
        if ($db->f("online") == 0) { $imgsrc = "online stellen"; } 
        if ($db->f("online") == 1) { $imgsrc = "offline stellen"; } 
        echo "<br><br><a href=$meineseite&online=".(($db->f("online")*-1)+1)."&eventid=".$db->f("id").">$imgsrc</a>"; 
        if ($db->f("online") == 0) echo " | <a href=$meineseite&delete=1&eventid=".$db->f("id").">Löschen</a>"; 
    } 
    echo "</p>"; 
    
    echo "</a></p>\n";    

} 

if ($perm->have_perm("admin")) { 
echo ' 
<p class="hl3">Neue Veranstaltung</p> 
<form name="form1" method="post" action="'.$meineseite.'"> 
  <table width="400" border="0" cellspacing="2" cellpadding="2"> 
    <tr> 
      <td width="152">Titel</td> 
      <td width="234"><input name="titel" type="text" id="titel" size="30"></td> 
    </tr> 
    <tr> 
      <td>Start-Datum</td> 
      <td><input name="datum1" type="text" id="datum1" size="30"></td> 
    </tr> 
    <tr> 
      <td>End-Datum</td> 
      <td><input name="datum2" type="text" id="datum2" size="30"></td> 
    </tr> 
    <tr> 
      <td>Uhrzeit</td> 
      <td><input name="uhrzeit" type="text" id="uhrzeit" size="30"></td> 
    </tr> 
    <tr> 
      <td>Beschreibung</td> 
      <td><text'; 
      echo 'area name="mydesc" cols="30" rows="5" id="mydesc"></text'; 
      echo 'area></td> 
    </tr> 
    <tr> 
      <td>Ort</td> 
      <td><input name="ort" type="text" id="ort" size="30"></td> 
    </tr> 
    <tr> 
      <td>Url</td> 
      <td><input name="url" type="text" id="url" size="30"></td> 
    </tr> 
    <tr> 
      <td>Online</td> 
      <td><input name="online" type="checkbox" id="online" value="1" checked></td> 
    </tr> 
    <tr> 
      <td> </td> 
      <td><input type="submit" name="send" value="eintragen"></td> 
    </tr> 
  </table> 
</form> 
';}