<?php
include_once 'config.php';
include_once 'app/projects.php';
include_once 'app/users.php';
if (empty($_SESSION['logged_in'])) {
redirect('index.php');
}
if (isset($_GET['uid'])) {
$uid = intval($_GET['uid']);
} else {
$uid = $_SESSION['uid'];
}
$projects = getAllRecentProjects($uid);
if ($projects) {
foreach ($projects as $project) {
$title = $project['project_title'];
$user = getUserData($project['created_by']);
if (strlen($title) < 20) {
$short_title = $title;
} else {
$short_title = substr($title, 0, 19) . '...';
}
?>
<div class="recent-project-item">
<?php
$image = getFeaturingImage($project['project_id']);
if (!empty($image)) {
?>
<a href="home.php?pid=<?php
}
if ($project['status'] == '1') {
continue;
}
$user = '******';
//automatically published need to define user
$query = "UPDATE `projects` SET `status`='1',`accepted_by`=" . $user . " WHERE `project_id`=" . $project['project_id'];
$db_con->query($query);
$project_title = getProjectTitle($project['project_id']);
$url = SITE_URL . '/home.php?pid=' . $project['project_id'];
$sent_to = getProjectAuthor($project['project_id']);
$text = 'Your Project "' . $project_title . '" has been Published.';
addNotification($sent_to, $text, 168, $url);
//automatically published need to define user
}
$projects = getAllRecentProjects();
foreach ($projects as $project) {
$seedrating = calculate_mr($project['project_id']);
if ($seedrating == 'N/A') {
continue;
}
$likes = getLikesCount($project_id);
$comments = getCommentsCount($project_id);
$query = 'SELECT `routed_by` FROM `routed_projects` WHERE `project_id` = ' . $project_id;
$users1 = count($db_con->sql2array($query));
$query = 'SELECT DISTINCT(`sent_to`) FROM `suggestions` WHERE `project_id` = ' . $project_id;
$routers1 = count($db_con->sql2array($query));
$routers = $users1 + $routers1;
if ($likes <= 1 && $comments <= 1 && $routers <= 1) {
continue;
}
