public function getPreviewHtml()
{
?>
<?php
$name_sk = $this->name_sk;
$name_eng = is_null($this->name_eng) ? $name_sk : $this->name_eng;
$text_sk = $this->text_sk;
$text_eng = is_null($this->text_eng) ? $text_sk : $this->text_eng;
?>
<h2 data-trans-lang="<?php
echo SK;
?>
"> <?php
echo $name_sk;
?>
</h2>
<h2 data-trans-lang="<?php
echo ENG;
?>
"> <?php
echo $name_eng;
?>
</h2>
<h3><span data-trans-key="assignment-page"></span> <?php
echo $this->deadline;
?>
</h3>
<div data-trans-lang="<?php
echo SK;
?>
"> <?php
echo $text_sk;
?>
</div>
<div data-trans-lang="<?php
echo ENG;
?>
"> <?php
echo $text_eng;
?>
</div>
<br>
<br>
<?php
if (Date("Y-m-d H:i:s") < $this->deadline && isset($_SESSION['loggedUser']) && is_a($_SESSION['loggedUser'], 'Team')) {
$idecko = getSolutionId($_SESSION['loggedUser']->getId(), $this->id);
if ($idecko == 0) {
?>
<a href="addSolution.php" data-trans-key="add-solution"></a> <?php
} else {
?>
<a href="addSolution.php" data-trans-key="edit-solution"></a>
<br>
<br>
<a href="solution.php?id=<?php
echo $idecko;
?>
" data-trans-key="view-solution"></a>
<?php
}
} else {
if (isset($_SESSION['loggedUser']) && is_a($_SESSION['loggedUser'], 'Administrator')) {
?>
<table> <?php
if ($link = db_connect()) {
?>
<tr>
<th></th>
<?php
$sql = "SELECT * FROM users as s INNER JOIN organisators as o on (o.user_id=s.user_id) WHERE o.admin=0 AND o.validated = 1 ORDER BY s.user_id";
$result = mysqli_query($link, $sql);
?>
<br>
<a href="bestSolution.php?id=<?php
echo $this->id;
?>
" data-trans-key="select-best-solution"></a>
<br><br>
<?php
if ($result != false) {
$pocet = 1;
$rozhodcovia = array();
while ($row = mysqli_fetch_assoc($result)) {
?>
<th><span data-trans-key="jury"></span>
<?php
echo " " . $pocet . "<br>" . substr($row['mail'], 0, 10) . "</th>";
array_push($rozhodcovia, $row['user_id']);
$pocet++;
}
}
?>
</tr> <?php
for ($i = 0; $i < count($this->solutions); $i++) {
?>
<tr>
<th><a href="solution.php?id=<?php
echo $this->solutions[$i]->getId();
?>
"> <?php
echo $this->solutions[$i]->getTeam()->getName();
?>
</a></th>
<?php
for ($j = 0; $j < count($rozhodcovia); $j++) {
$sql = "SELECT * FROM comments c WHERE c.solution_id=" . $this->solutions[$i]->getId() . " AND c.user_id=" . $rozhodcovia[$j];
$result = mysqli_query($link, $sql);
if ($result != false) {
$arrayResult = mysqli_fetch_array($result);
if ($arrayResult != null && $arrayResult['text'] != null && $arrayResult['points'] != null) {
?>
<td data-trans-key="finished"></td> <?php
} else {
?>
<td data-trans-key="not-rated"></td> <?php
}
}
}
?>
</tr> <?php
}
}
?>
</table> <?php
} else {
if (Date("Y-m-d H:i:s") > $this->deadline) {
?>
<h3><span data-trans-key="solutions"></span>:</h3>
<ul>
<?php
for ($i = 0; $i < count($this->solutions); $i++) {
$team = $this->solutions[$i];
$team2 = $team->getTeam();
$team3 = $team2->getName();
?>
<li><a href="solution.php?id=<?php
echo $team->getId();
?>
"> <?php
echo $team3;
?>
</a> </li>
<?php
}
?>
</ul> <?php
}
}
}
}
<label class="left" for="language"><?php
print $PMF_LANG["ad_entry_locale"];
?>
:</label>
<?php
print selectLanguages($lang);
?>
<br />
<label class="left" for="solution_id"><?php
print $PMF_LANG['ad_entry_solution_id'];
?>
:</label>
<input name="solution_id" id="solution_id" style="width: 50px; text-align: right;" value="<?php
print isset($solution_id) ? $solution_id : getSolutionId();
?>
" size="5" readonly="readonly" /><br />
<?php
if (isset($active) && $active == 'yes') {
$suf = ' checked="checked"';
unset($sul);
} else {
unset($suf);
$sul = ' checked="checked"';
}
?>
<label class="left" for="active"><?php
print $PMF_LANG["ad_entry_active"];
?>
$content = $db->escape_string(safeHTML(nl2br($_POST["content"])));
$contentlink = $db->escape_string(safeHTML($_POST["contentlink"]));
if (substr($contentlink, 7) != "") {
$content = $content . "<br />" . $PMF_LANG["msgInfo"] . "<a href=\"http://" . substr($contentlink, 7) . "\" target=\"_blank\">" . $contentlink . "</a>";
}
if (isset($_SERVER["HTTP_ACCEPT_LANGUAGE"])) {
$lang = trim(strtolower(substr($_SERVER["HTTP_ACCEPT_LANGUAGE"], 0, 2)));
} else {
$lang = "en";
}
$thema = $db->escape_string(safeHTML($_POST["thema"]));
$selected_category = $_POST["rubrik"];
$keywords = $db->escape_string(safeHTML($_POST["keywords"]));
$author = $db->escape_string(safeHTML($_POST["username"]));
$usermail = $IDN->encode($db->escape_string(safeHTML($_POST["usermail"])));
$db->query(sprintf("INSERT INTO %sfaqdata (id, lang, solution_id, revision_id, active, thema, content, keywords, author, email, comment, datum) VALUES (%d, '%s', %d, %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", SQLPREFIX, $db->nextID(SQLPREFIX . "faqdata", "id"), $lang, getSolutionId(), 0, 'no', $thema, $content, $keywords, $author, $usermail, 'y', $datum));
foreach ($selected_category as $_category) {
$db->query(sprintf("INSERT INTO %sfaqcategoryrelations (category_id, category_lang, record_id, record_lang) VALUES (%d, '%s', %d, '%s')", SQLPREFIX, intval($_category), $lang, $db->insert_id(SQLPREFIX . 'faqdata', 'id'), $lang));
}
$db->query(sprintf("INSERT INTO %sfaqvisits (id, lang, visits, last_visit) VALUES (%d, '%s', %d, %d)", SQLPREFIX, $db->insert_id(SQLPREFIX . 'faqdata', 'id'), $lang, 1, time()));
$additional_header = array();
$additional_header[] = 'MIME-Version: 1.0';
$additional_header[] = 'Content-Type: text/plain; charset=' . $PMF_LANG['metaCharset'];
if (strtolower($PMF_LANG['metaCharset']) == 'utf-8') {
$additional_header[] = 'Content-Transfer-Encoding: 8bit';
}
$additional_header[] = 'From: ' . $usermail;
$subject = unhtmlentities($PMF_CONF["title"]);
if (function_exists('mb_encode_mimeheader')) {
$subject = mb_encode_mimeheader($subject);
}
