} $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; } $trend_value = calculateTrendForProject($project['project_id']); if ($trend_value <= 0) { continue; } if (!checkProjectInTrend($project['project_id'])) { global $db_con; $db_con->query('INSERT INTO `trend`(project_id) VALUES(' . $project['project_id'] . ')'); } } $trended = getAllProjectsInTrend(); if ($trended == null) { exit; } foreach ($trended as $project) { $cycle = getTrendCycle($project['project_id']); $hr = ''; $dt = time(); $times = new DateTime("@{$dt}"); $time = $times->format('Y-m-d H:i:s'); //echo gettype($time);
function updateFundablesTable() { global $db_con; $q = "SELECT * FROM `fundables` WHERE 1 ORDER BY `created_on` DESC"; $res = $db_con->query($q); // print_r($res); while ($row = $db_con->fetch_array($res)) { $date1 = strtotime($row['created_on']); $id = $row['fundable_id']; $project_id = $row['project_id']; $date2 = $date1 + 31 * 24 * 60 * 60; $remdays = intval(ceil(($date2 - time()) / (60 * 60 * 24))); $fund_status = $row['fund_status']; $cycle = $row['cycle']; if ($fund_status == 1) { continue; } else { echo "status"; if ($remdays < 1) { $checktrend = checkProjectInTrend($project_id); if ($checktrend == true) { // $cycle="SELECT `cycle` FROM `fundables` WHERE `fundable_id`=".$id."LIMIT 1"; // $res=$db_con->fetch_array($db_con->query($cycle)); if ($cycle == 0) { $cycle = 1; $x = $remdays + 31 * 24 * 60 * 60; print_r($x); $qu = "UPDATE `fundables` SET `days_rem`='" . $x . "',`cycle`='" . $cycle . "'WHERE `fundable_id`=" . $id; //does not work //print_r($qu); $db_con->query($qu); } else { updateNotFundStatusProject($project_id); $quer = "DELETE `fundable_id` FROM `fundables` WHERE `fundable_id`=" . $id; $db_con->query($quer); } echo "yasma"; } else { updateNotFundStatusProject($project_id); $quer = "DELETE `fundable_id` FROM `fundables` WHERE `fundable_id`=" . $id; $db_con->query($quer); } } else { $qu = "UPDATE `fundables` SET `days_rem`='" . $remdays . "',`cycle`='" . $cycle . "'WHERE `fundable_id`=" . $id; //does not work //print_r($qu); $db_con->query($qu); } } } }