<?php
// use function Google\Cloud\Samples\PubSub\publish_message;
class QuizDatabaseHandler extends DatabaseHandler {
function __construct(){
parent::__construct("quizmaker");
}
public function lookForRelatedWordInContributionTable($word){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dicusers_contribution` where word='" . $word . "' AND relatedWord !='' AND adminOpinion ='adminConfirmed'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
while ($wordArrayResult[] = mysqli_fetch_assoc($result));
// $word = mysqli_fetch_assoc($result);
// return $this->lookForWordInDictionary($word['relatedWord']);
return $wordArrayResult;
}
public function lookForWordInDictionary($word){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dictionary` where searchedWord='" . $word . "'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
while ($wordArrayResult[] = mysqli_fetch_assoc($result));
return $wordArrayResult;
}
public function lookForWordInContributionTable($word){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dicusers_contribution` where word='" . $word . "' AND translation !='' AND adminOpinion ='adminConfirmed'";
// $sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dicusers_contribution` where word='" . $word . "' AND adminOpinion ='adminConfirmed' ";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
while ($wordArrayResult[] = mysqli_fetch_assoc($result));
// $testMessage = var_export ( $wordArrayResult, true );
// file_put_contents ( "databasetest311.html", $testMessage.PHP_EOL, FILE_APPEND | LOCK_EX );
return $wordArrayResult;
}
public function getMyQuizzes($userId) {
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`quiz` where userid='" . $userId . "'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
while ($wordArrayResult[] = mysqli_fetch_assoc($result));
return $wordArrayResult;
}
public function getScore($userId,$quizId ) {
$sql = "SELECT score FROM `".DatabaseHandler::$databaseName."`.`quiz_scores` where usercallbackID='" . $userId . "' AND quizID=".$quizId;
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$wordArrayResult = mysqli_fetch_assoc($result);
return $wordArrayResult['score'];
}
public function getParticipants($quizId ) {
$sql = "SELECT count(userid) as participants FROM (SELECT userid FROM `quiz_users_asnwers` Where `questionID` IN ( SELECT id from quiz_questions where quizID = $quizId) group By userid) as participant;";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$wordArrayResult = mysqli_fetch_assoc($result);
return $wordArrayResult['participants'];
}
public function getQuizChannel($quizId) {
$sql = "SELECT channelName FROM `".DatabaseHandler::$databaseName."`.`quiz` where id=" . $quizId ;
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$wordArrayResult = mysqli_fetch_assoc($result);
return $wordArrayResult['channelName'];
}
public function getQuestions($quizId) {
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`quiz_questions` where quizID=" . $quizId . "";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
while ($wordArrayResult[] = mysqli_fetch_assoc($result));
return $wordArrayResult;
}
public function getAnswers($questionId) {
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`quiz_answers` where questionID=" . $questionId . "";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
while ($wordArrayResult[] = mysqli_fetch_assoc($result));
return $wordArrayResult;
}
public function getQuizId($answerId) {
$sql = "SELECT quizID FROM `quiz_questions` where id = ( SELECT questionID FROM `quiz_answers` WHERE id = ".$answerId." )";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$wordArrayResult= mysqli_fetch_assoc($result);
return $wordArrayResult;
}
public function getQuestionId($questionId) {
$sql = "SELECT questionID FROM `quiz_answers` WHERE id = ".$questionId;
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$wordArrayResult= mysqli_fetch_assoc($result);
return $wordArrayResult;
}
public function getAnswerById($answerId) {
$sql = "SELECT * FROM `quiz_answers` where id = $answerId";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$wordArrayResult = mysqli_fetch_assoc($result);
return $wordArrayResult;
}
public function incScore($quizId, $userId) {
if(!$this->isUserScore($quizId, $userId))
$this->insertUserScore($quizId, $userId);
$sql = "UPDATE `".DatabaseHandler::$databaseName."`.`quiz_scores` set score =score +1 where usercallbackID='".$userId."' AND quizID=$quizId";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
while ($wordArrayResult[] = mysqli_fetch_assoc($result));
return $wordArrayResult;
}
public function makeTranslationTextMessageHtml($noHtmlTag=FALSE) {
$translated ="";
foreach ( $this->wordArrayResult as $word ) {
$perfectForm = "";
if($word['word']){
$artikel = "";
switch (trim($word['artikel'])){
case "n":
$artikel = "Das - ";
break;
case "m":
$artikel = "Der - ";
break;
case "f":
$artikel = "Die - ";
break;
default:
if(substr($word['word'], -1)=="n")
$perfectForm = "<a href='https://telegram.me/translateGerman_bot'>(</a>".
$this->findPerfect($word)."<a href='https://telegram.me/translateGerman_bot'>)</a>";
break;
}
// if(!$this->hasUserSuggested($userId, 2))
// $perfectForm ="(perfekt)";
$translated.=" <a href='https://telegram.me/translateGerman_bot'>".$artikel."</a>" ."<b>". trim($word['word']).":</b> ".$word['translation'].$perfectForm.PHP_EOL;
}
}
if($noHtmlTag)
$translated = strip_tags($translated);
return $translated. " 😊".PHP_EOL;
}
public function makeTranslationTextMessage() {
$translated ="";
if(!is_array($this->wordArrayResult))
return false;
foreach ( $this->wordArrayResult as $word ) {
$perfectForm = "";
if($word['word']){
$artikel = "";
switch (trim($word['artikel'])){
case "n":
$artikel = "Das - ";
break;
case "m":
$artikel = "Der - ";
break;
case "f":
$artikel = "Die - ";
break;
default:
if(substr($word['word'], -1)=="n")
$perfectForm = "(".
$this->findPerfect($word).")";
break;
}
// if(!$this->hasUserSuggested($userId, 2))
// $perfectForm ="(perfekt)";
$translated.=$artikel." ". trim($word['word']).":".$word['translation'].$perfectForm.PHP_EOL;
}
}
if($noHtmlTag)
$translated = strip_tags($translated);
return $translated. " 😊".PHP_EOL." @TranslateGerman_bot";
}
public function getWordFromActivityById($wordId) {
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`user_activities` where id=$wordId";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$activity = mysqli_fetch_assoc($result);
return $activity['searchedWord'];
}
public function getActivity($wordId) {
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`user_activities` where id=$wordId";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$activity = mysqli_fetch_assoc($result);
return $activity;
}
public function getLastContribution($userId, $step) {
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dicusers_contribution` where userid='$userId' AND status = 'open'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$contribution = mysqli_fetch_assoc($result);
return $contribution;
}
public function getContributionByUserId($userId) {
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dicusers_contribution` where userid='$userId' AND status = 'open'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$contribution = mysqli_fetch_assoc($result);
return $contribution;
}
public function getContributionById($contId) {
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dicusers_contribution` where id=$contId";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$contribution = mysqli_fetch_assoc($result);
return $contribution;
}
public function setUserStep($userId, $step) {
$sql = "UPDATE `".DatabaseHandler::$databaseName."`.`dicusers` SET step ='$step' WHERE userid='$userId'";
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
return true;
}
public function setContributionAdminStatus($contId, $adminOpinion) {
$sql = "UPDATE `".DatabaseHandler::$databaseName."`.`dicusers_contribution` SET adminOpinion ='$adminOpinion' WHERE id=$contId";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
return true;
}
public function setContributionStatus($userId, $status, $message_id) {
$sql = "UPDATE `".DatabaseHandler::$databaseName."`.`dicusers_contribution` SET status ='$status' WHERE userid='$userId' AND message_id='$message_id'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
return true;
}
public function setTranslatedWord($translation, $userId) {
$sql = "UPDATE `".DatabaseHandler::$databaseName."`.`dicusers_contribution` SET translation ='$translation' WHERE userid='$userId' AND status='open'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
return true;
}
public function setRelatedWord($relatedWord, $userId) {
$sql = "UPDATE `".DatabaseHandler::$databaseName."`.`dicusers_contribution` SET relatedWord ='$relatedWord' WHERE userid='$userId' AND status='open'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
return true;
}
public function setContributionProblemType($problemType, $userId, $message_id) {
$sql = "UPDATE `".DatabaseHandler::$databaseName."`.`dicusers_contribution` SET problemType ='$problemType' WHERE userid='$userId' AND message_id='$message_id'";
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
return true;
}
public function getUserStep($userId) {
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dicusers` where userid='$userId'";
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$user = mysqli_fetch_assoc($result);
return $user['step'];
}
public function getWordById($wordId) {
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dictionary` where id=$wordId";
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$news = mysqli_fetch_assoc($result);
return $news;
}
public function isSearched($word) {
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`user_activities` where searchedWord='$word'";
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$userSearchedWord = mysqli_fetch_assoc($result);
$this->wordIsSearched = count($userSearchedWord)> 0;
}
public function findPerfect($word) {
// if($word)
$perfect = $word['perfect'];
$word = $word['word'];
if (!$perfect) {
$url = "http://api.verbix.com/conjugator/html?language=deu&tableurl=http://tools.verbix.com/webverbix/personal/template.htm&verb=$word";
$contents = file_get_contents ( $url );
$regex = '/Participio:<\/b> <span class="normal">(.*?)<\/span>/';
preg_match ( $regex, $contents, $treffer, PREG_OFFSET_CAPTURE, 3 );
$regex = '/Participio:<\/b> <span class="irregular">(.*?)<\/span>/';
preg_match ( $regex, $contents, $trefferIre, PREG_OFFSET_CAPTURE, 3 );
if (! empty ( $treffer [1] [0] ) || ! empty ($trefferIre [1] [0])){
$perfect = $treffer [1] [0];
if(empty($perfect))
$perfect= $trefferIre [1] [0];
$perfect = str_replace("ä", "ä", $perfect);
$perfect = str_replace("ü", "ü", $perfect);
$perfect = str_replace("ö", "ö", $perfect);
}
else
$perfect = "-";
$this->updatePerfect($word,$perfect);
}
return $perfect;
}
public function updatePerfect($word,$perfect){
$sql = "UPDATE `".DatabaseHandler::$databaseName."`.`dictionary` SET `perfect`='$perfect' WHERE word='".$word."'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
}
public function insertWordsWithTranslation($translationsArray, $ln, $searchedWord){
$status = $ln;
if(!is_array($translationsArray))
return false;
foreach ($translationsArray as $table){
foreach($table as $tr){
if(!empty($tr[2]))
{
$artikel = trim($tr[1]);
$word = trim($tr[2]);
$translation = $tr[5];
$this->insertWord($word,$translation,$artikel,$status, $searchedWord);
}
}
}
}
public function isWordAndTranslation($word,$translation, $ln, $searchedWord){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dictionary` WHERE word='".$word."'"
." AND translation='".$translation."' AND searchedword='".$searchedWord."' AND status='".$ln."'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$words = mysqli_fetch_assoc($result);
if(count($words)>0)
return true;
else
return false;
}
public function insertWord($word,$translation,$artikel ,$ln , $searchedWord){
if($this->isWordAndTranslation($word,$translation, $ln , $searchedWord))
return false;
$sql = "INSERT INTO `".DatabaseHandler::$databaseName."`.`dictionary` (`word`,`translation`,`artikel`,`status` ,`searchedword`)
VALUES ('"
. $word."' ,'"
. $translation."' ,'"
. $artikel."' ,'"
. $ln."' ,'"
. $searchedWord."'"
.");";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die( $this->connection->error );
return true;
}
public function hasSoundFile($word , &$soundFile, &$foundWord){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dictionary` WHERE searchedWord='".$word."'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$words = mysqli_fetch_assoc($result);
$soundFile = $words['soundFile'];
$foundWord = $words['searchedWord'];
if(!empty($words['soundFile']))
return true;
else
return false;
}
public function saveVoiceAdress($word,$soundAdress){
if($this->hasSoundFile($word, $notusing, $notused2))
return false;
$sql = "UPDATE `".DatabaseHandler::$databaseName."`.`dictionary` SET soundFile='$soundAdress' where searchedWord= '$word'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die( $this->connection->error );
return true;
}
public function addTranslationToWord($wordId,$translation){
$status ="translated";
$sql = "UPDATE `".DatabaseHandler::$databaseName."`.`dictionary` set translation ='".$translation
."' AND status='ready' where id=".$wordId;
$result = $this->connection->query ( $sql );
$this->connection->error();
}
public function incrementInvitationSentNumber($userId){
$sql = "UPDATE `".DatabaseHandler::$databaseName."`.`dicusers` set invitesent =invitesent +1 where userid=".$userId;
$this->connection->query ( $sql );
// return true;
}
public function getSentInviteNumber($userId){
$sql = "SELECT invitesent FROM `".DatabaseHandler::$databaseName."`.`dicusers` where userid=".$userId;
$result = $this->connection->query ( $sql );
$result = mysqli_fetch_assoc( $result );
return $result['invitesent'];
}
public function isQuizUser($userId){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`quiz_users` WHERE userid='".$userId."'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$words = mysqli_fetch_assoc($result);
if(count($words)>0)
return true;
else
return false;
}
public function isUserScore($quizId, $userId){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`quiz_scores` WHERE usercallbackID='".$userId."' AND quizID = $quizId";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$userScores = mysqli_fetch_assoc($result);
if(count($userScores)>0)
return true;
else
return false;
}
public function isAnsweredByUser($userId, $questionId){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`quiz_users_asnwers` WHERE userid='".$userId."' AND questionID = ".$questionId;
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$userAnsweres = mysqli_fetch_assoc($result);
if(count($userAnsweres)>0)
return true;
else
return false;
}
public function insertQuizUser($userId,$userName,$name ,$lastname){
if($this->isQuizUser($userId))
return false;
$sql = "INSERT INTO `".DatabaseHandler::$databaseName."`.`quiz_users` (`userid`,`username`,`name`,`lastname`)
VALUES ('"
. $userId."' ,'"
. $userName."' ,'"
. $name."' ,'"
. $lastname."'"
.");";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die( $this->connection->error );
return true;
}
public function insertUserScore($quizId, $userId){
$sql = "INSERT INTO `".DatabaseHandler::$databaseName."`.`quiz_scores` (`quizID`,`usercallbackID`,`score`)
VALUES ("
. $quizId." ,'"
. $userId."' ,"
."0"
.");";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die( $this->connection->error );
return true;
}
public function insertUserAnswer($userId, $questionId, $answerId){
$sql = "INSERT INTO `".DatabaseHandler::$databaseName."`.`quiz_users_asnwers` (`userid`,`questionID`,`answerID`)
VALUES ('"
. $userId."' ,"
. $questionId.","
. $answerId
.");";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die( $this->connection->error );
return true;
}
public function getSomeNouns(){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dictionary` where artikel !='-' ORDER BY RAND() LIMIT 5";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
while ($wordArrayResult[] = mysqli_fetch_assoc($result));
return $wordArrayResult;
}
public function getSomeWords($limitNumber=5){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dictionary` ORDER BY RAND() LIMIT $limitNumber";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
while ($wordArrayResult[] = mysqli_fetch_assoc($result));
return $wordArrayResult;
}
public function getSomeWrongTranslations($word){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dictionary` where status ='".$word['status']."' ORDER BY RAND() LIMIT 5";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
while ($wordArrayResult[] = mysqli_fetch_assoc($result));
return $wordArrayResult;
}
public function getSomeWrongWords($word){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dictionary` where status ='".$word['status']."' ORDER BY RAND() LIMIT 4";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
while ($wordArrayResult[] = mysqli_fetch_assoc($result));
return $wordArrayResult;
}
public function insertContribution($word, $askedByUser, $userId, $messageId){
$status = 'open';
$sql = "INSERT INTO `".DatabaseHandler::$databaseName."`.`dicusers_contribution` (`word`,`askedByUser`,`userid`,`status`,`message_id`)
VALUES ('"
. $word."' ,'"
. $askedByUser."' ,'"
. $userId."' ,'"
. $status."' ,'"
. $messageId."'"
.");";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die( $this->connection->error );
return true;
}
public function insertQuiz($quizName,$userId,$channelName){
$sql = "INSERT INTO `".DatabaseHandler::$databaseName."`.`quiz` (`name`,`userid`,`channelName`)
VALUES ('"
. $quizName."', '"
. $userId."', '"
. $channelName."'"
.");";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die( $this->connection->error );
return $this->connection->insert_id;
}
public function insertQuestion($questionText,$quizID, $imageUrl=""){
$sql = "INSERT INTO `".DatabaseHandler::$databaseName."`.`quiz_questions` (`question`,`quizID`,`imageUrl`)
VALUES ('"
. $questionText."' ,"
. $quizID.", '"
. $imageUrl."'"
.");";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die( $this->connection->error );
return $this->connection->insert_id;
}
public function insertAnswer($questionID,$answer, $isRight){
$sql = "INSERT INTO `".DatabaseHandler::$databaseName."`.`quiz_answers` (`questionID`,`answer`,`isRight` )
VALUES ("
. $questionID." ,'"
. $answer."' ,"
. $isRight
.");";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die( $this->connection->error );
return $this->connection->insert_id;
}
public function isOverUsage($userId,$limit, &$numberOfTranslated){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`user_activities` WHERE userid='".$userId."' AND trdate = CURDATE()";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$count = mysqli_num_rows($result);
$numberOfTranslated = $count;
if($count > $limit)
return true;
else
return false;
}
public function hasUserSuggested($userId,$suggestedNumber){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dic_suggested_users` WHERE userid='".$userId."'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$count = mysqli_num_rows($result);
$testMessage = var_export ( $userId.":".$count, true );
file_put_contents ( "testsuggestedbot.html", $testMessage.PHP_EOL, FILE_APPEND | LOCK_EX );
if($count >= $suggestedNumber)
return true;
else
return false;
}
public function isUserSuggested($newSuggestedUserId){
$sql = "SELECT * FROM `".DatabaseHandler::$databaseName."`.`dic_suggested_users` WHERE suggestedid='".$newSuggestedUserId."'";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die ( $this->connection->error );
$words = mysqli_fetch_assoc($result);
if(count($words)>0)
return true;
else
return false;
}
public function insertSuggested($userId,$newSuggestedUserId){
if($this->isUserSuggested($newSuggestedUserId))
return false;
$sql = "INSERT INTO `".DatabaseHandler::$databaseName."`.`dic_suggested_users` (`userid`,`suggestedid`,`Datum`)
VALUES ('"
. $userId."' ,'"
. $newSuggestedUserId."' ,"
."now()"
.");";
$this->connection->query ( "SET NAMES utf8" );
$result = $this->connection->query ( $sql ) or die( $this->connection->error );
return true;
}
}
