<?php

class texte{
	private $db;
	private $art;
	private $post = array();
	
	function __construct(){
		global $datenbank;
		$this->db = $datenbank;
	}
	
	public function Ausgabe(){
		$aus = array("kopf" => '', "body" => '');
		$i = 0;
		foreach($this->db->get_results("SELECT * FROM ". PREFIX . TEXTE ." WHERE name != 'awerbung' ") AS $res){
			if($i == 0){ $aktive = 'active';}else{ $aktive = '';}
			$aus['kopf'] .= '
				<li class="nav-item">
					<a class="nav-link '. $aktive .'" id="home-tab" data-toggle="tab" href="#'. $res->name .'" role="tab" aria-controls="home" aria-selected="true">'. $res->name .'</a>
				</li>
			';
			$aus['body'] .= '
			<div class="tab-pane fade show '. $aktive .'" id="'. $res->name .'" role="tabpanel" aria-labelledby="home-tab">
				<form action="" method="post">
					<input type="hidden" name="name" value="'. $res->name .'">
					<textarea class="ckeditor" name="text" style="width:90%; height:500px;">'. $res->text.'</textarea><br>
					<input type="Submit" name="run[TexteUpdaten]" class="btn btn-default" value="Updaten !">
				</form>
			</div>
			';
			$i++;
		}
		return $aus;
	}
	
	public function update($post){
		if($this->db->update(PREFIX . TEXTE, array("text" => $this->db->escape($post['text'])), array("name" => $this->db->escape($post['name']))) == true){
			meldung(0,TEXTE_SAVE_TRUE);
		}else{
			meldung(1,TEXTE_SAVE_FALSE);
		}
	}
	
	public function AWerbung(){
		$row = $this->db->get_row("SELECT text FROM ". PREFIX . TEXTE ." WHERE name = 'awerbung' ");
		$row = json_decode($row[0]);
		return $row;
	}
	
	private function make_array($post){
		foreach($post AS $key => $value){
			if($key != '' && $key != 'run'){
				$this->post[$key] = $this->db->escape(base64_encode($value));
			}
		}
	}
	
	public function AWerbungSave($post){
		$this->make_array($post);
		$string = json_encode($this->post);
		if($this->db->update(PREFIX . TEXTE, array("text" => $string), array("name" => "awerbung") ) == true){
			meldung(0,WERBUNG_EXTRA_SAVE_TRUE);
		}else{
			meldung(1,WERBUNG_EXTRA_SAVE_FALSE);
		}
	}
}