[ Avaa Bypassed ]

<?php
class NewsDatabaseHandler extends DatabaseHandler {

	function __construct($botUsername){
		parent::__construct($botUsername);
	}
	public function addNewsToDb($news){
		$newsLink=$news['link'];
		$catchedNews = $this->getNewsFromDb($newsLink);
		if(empty($catchedNews['id'])){
			$this->createNewsInDb($news);		
			$catchedNews = $this->getNewsFromDb($newsLink);		
		}
		return $catchedNews['id'];
	}
	public function addNewsTranslation($translation){
		$newsLink=$news['link'];
		$this->getNewsFromDb($newsLink);
// 		if(empty($this->getNewsFromDb($newsLink)))
// 			$this->updateNewsInDb($newsId,$translation);
		
		
	}
	public function getNewsFromDb($newsLink) {
		$sql = "SELECT * FROM  `".DatabaseHandler::$databaseName."`.`news` where link='" . $newsLink . "'";
		$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
		$newsId = mysqli_fetch_assoc($result);
		return $newsId;
	}
	public function getNewsFromDbById($newsId) {
		$sql = "SELECT * FROM  `".DatabaseHandler::$databaseName."`.`news` where id=$newsId";
		$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
		$news = mysqli_fetch_assoc($result);
		return $news;
	}
	public function createNewsInDb($news){
		echo $status ="waiting";
		$botDatabaseId =$this->botDatabaseId;
		$sql = "INSERT INTO  `".DatabaseHandler::$databaseName."`.`news` (`botsId` ,`receiverUserId` ,`title` ,`alt`,`link`  ,`description` ,`pubdate`,`media`,`media2`,`enclosure`,`status`)
					VALUES ('" . 
					$botDatabaseId . "','000000', '" 
					. $news ['title'] . "', '" 
					. $news ['alt'] . "', '" 
					. $news ['link'] . "', '" 
					. $news ['desc'] . "', '" 
					. $news ['pubdate'] . "', '" 
					. $news ['media'] . "', '" 
					. $news ['media2'] . "', '" 
					. $news ['enclosure'] . "', '" 
					. $status . "'" 
					.");";
		
// `title` ,`alt` ,`desc` ,`pubdate`,`media`,`media2`,`enclosure`,`status`

		$result = $this->connection->query ( $sql ) or die( $this->connection->error );
		
	}
	public function updateNewsInDb($newsId,$translation){
		$status ="ready";
		$sql = "UPDATE `".DatabaseHandler::$databaseName."`.`news` set translation ='".$translation
		."' AND status='ready' where id=".$newsId;

		$result = $this->connection->query ( $sql );
		echo $this->connection->error();
		
	}
	
}