<?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; }