}
if ($stmt = $dbh->prepare("SELECT * FROM " . $table_prefix . "_categories")) {
$stmt->execute();
$categories = $stmt->fetchAll();
}
include 'search.php';
?>
<div id="projects_holder">
<?php
if ($_GET['opt'] == 'project_filter') {
?>
<script>
scroolto("search");
</script>
<?php
}
foreach ($results as $project) {
$project_percent_funded = round($backed_amount[$project['projectID']] / $project['pledge_amount'] * 100);
$ended = false;
$now = time();
$End_date = strtotime($project['project_duration']);
$datediff = $End_date - $now;
$days_remaining = floor($datediff / (60 * 60 * 24)) . " " . spravne_cislovanie($days_remaining, " deň", " dni", " dní");
if ($days_remaining < 0) {
$days_remaining = 'Ukončený';
$ended = true;
}
echo "\n\t\t<div class='project'>\n\t\t\t<a href='?opt=project&id=" . $project['projectID'] . "'>\n\t\t\t<img src='files/" . $project['projectID'] . "/img/thumb/thumb_" . $project['project_image'] . "' alt='Obrazok'>\n\t\t\t<h1>" . $project['project_title'] . "</h1>\n\t\t\t<div class='project_content'>\n\t\t\t\t" . $project['short_description'] . "\n\t\t\t</div>\n\t\t\t<div class='progress_bar'>\n\t\t\t\t<div class='progress_bar_overlay' style='width:" . ($project_percent_funded >= 100 ? "100" : $project_percent_funded) . "%'>\n\t\t\t\t\t\t\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t\t</a>\n\t\t\t<div class='project_footer'>\n\t\t\t\t<table>\n\t\t\t\t\t<tbody>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td>Vyzbieraných</td>\n\t\t\t\t\t\t\t<td>Suma</td>\n\t\t\t\t\t\t\t<td>Do ukončenia</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td>" . $project_percent_funded . " %</td>\n\t\t\t\t\t\t\t<td>" . $project['pledge_amount'] . "€</td>\n\t\t\t\t\t\t\t<td>" . $days_remaining . "</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</tbody>\n\t\t\t\t</table>\n\t\t\t</div>\n\t\t</div>\n\t";
}
?>
</div>
echo $usr->web_page;
?>
</a></p>
<div class="button">
Kontaktovať autora
</div>
</div>
</div>
<?php
foreach ($results_awards as $award) {
$rew_class = "reward";
$color = "green";
$delivery = sk_datum(strtotime($award['delivery_date']));
if ($award['available'] <= 0) {
$available = " ";
} else {
$available = $award['available'] - $award['backers'] . " z " . $award['available'] . " dostupných";
if ($award['available'] == $award['backers']) {
$rew_class = "reward_all_gone";
$color = "red";
}
}
echo "\n\t\t\t\t<div class='" . $rew_class . "'>\n\t\t\t\t\t<div class='content'>\n\t\t\t\t\t\t<h1>Prispieť " . $award['amount'] . "€</h1>\n\t\t\t\t\t\t " . $award['description'] . "\n\t\t\t\t\t\t<hr>\n\t\t\t\t\t\t<h2>" . $award['backers'] . " " . spravne_cislovanie($award['backers'], " príspevok", " príspevky", " príspevkov") . "</h2>\n\t\t\t\t\t\t<hr>\n\t\t\t\t\t\t<p class='" . $color . "'>" . $available . "</p>\n\t\t\t\t\t\t<p>Dátum dodania: " . $delivery . "</p>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t";
}
?>
</div>
</div>
<?php
}
?>
<div class="clear"></div>
