<?php
# ----------------------------------------------------------------------------
# INIT: Die dB-Zugänge
# ----------------------------------------------------------------------------
	define('MYSQL_DB','chat');
	define('MYSQL_USER','root');
	define('MYSQL_PASS','root');
	define('MYSQL_HOST','localhost');

	$user = 'pieli'; # kommt nachher weg
	$today = date("Y-m-d 00:00:00");
	$error = '';     # Fuer spaeter

# ----------------------------------------------------------------------------
# Verbindungsaufbau (waere gar nicht so schlecht ...)
# ----------------------------------------------------------------------------
	$dB = new PDO('mysql:host=' . MYSQL_HOST . ';dbname=' . MYSQL_DB . ';charset=utf8', MYSQL_USER, MYSQL_PASS) OR die('No MySQL!');

# ----------------------------------------------------------------------------
# msg speichern
# ----------------------------------------------------------------------------
# die hier, Tom?
	if(isset($_POST['submit'])) {
		if(strlen(trim($_POST['msg'])) > 0) {
			$sql = "INSERT INTO msgs (user, msg) VALUES (?, ?);";
			$stmt = $dB->prepare($sql);

			if($stmt->execute(array($user, $_POST['msg']))) { # Fehlertoleranz für den db-Schreiberich; db gut
				$error = '<p>Die Daten wurden erfolgreich in die databse gerammt!</p>';
			} else { # db schlecht
				$error = '<p>Die databse hat heute frei, rufen Sie 110 / Feurio!</p>';
			}
		}
	}

# ----------------------------------------------------------------------------
# msgs aus db lesen
# ----------------------------------------------------------------------------
	$stmt = $dB->prepare('SELECT user,time,msg FROM msgs WHERE time > ' . $today . ' ORDER BY time ASC;');
	//~ $stmt = $dB->prepare('SELECT user,time,msg FROM msgs ORDER BY time ASC;');
	$stmt->execute();
	$chat = $stmt->fetchAll(PDO::FETCH_ASSOC);
	//~ var_dump($chat);
	//~ exit;

# ----------------------------------------------------------------------------
# SMARTY
# ----------------------------------------------------------------------------
	require_once('smarty/cfg/setup.php');
	
# ----------------------------------------------------------------------------
# templating
# ----------------------------------------------------------------------------

	$smarty->assign('chat', $chat);   # Array mit allen msgs aus der query fuer heute
	$smarty->assign('error', $error); # error-msgs fuers schreiben
	$smarty->display('chat_1.tpl');   # wie immer
?>
