$projs = getRecentProjects();
foreach ($projs as $project) {
$seedrating = calculate_mr($project['project_id']);
if ($seedrating == 'N/A') {
continue;
}
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;
<?php
include 'includes/header.php';
require_once DIR_APP . 'projects.php';
require_once DIR_APP . 'users.php';
//print_r($_POST);
$user_id = getProjectAuthor($_POST['pid']);
$date = $_POST['month'] . '/' . $_POST['year'];
global $db_con;
//checkBalance($user);
if (empty($_POST['fin_pro']) && empty($_POST['user_choice'])) {
$reward_type = $_POST['eq_pc'];
} else {
if (empty($_POST['fin_pro'])) {
$reward_type = $_POST['user_choice'];
} else {
$reward_type = $_POST['fin_pro'];
}
}
$query = "INSERT INTO `payment_process`(`transaction_id`, `type`, `reward_type`,`description`, `amount` , `user_id` , `balance` , `project_id`, `created_by`,`card_no`,`ccv`,`zip`,`expiry_date`)\n\t\t VALUES ( '" . $db_con->escape($_POST['stripeToken']) . "' , '" . $db_con->escape($_POST['type']) . "', '" . $db_con->escape($reward_type) . "', 'Description' , '" . $db_con->escape($_POST['amount']) . "' , '" . $user_id . "' , '0' , '" . $db_con->escape($_POST['pid']) . "' , '" . $db_con->escape($_POST['user_id']) . "','" . $db_con->escape($_POST['cardname']) . "','" . $db_con->escape($_POST['cvc']) . "','" . $db_con->escape($_POST['zip_code']) . "','" . $date . "')";
$db_con->query($query);
$id = $db_con->insert_id();
//$query1 = "UPDATE `users` SET balance=" . $balance . " WHERE user_id=" . $user['user_id'];
//$db_con->query($query1);
updateFundStatusProject($_POST['pid']);
updateFundableStatus($_POST['pid']);
updateFundingsStatus($_POST['pid'], $_POST['amount'], $_POST['type'], $reward_type);
//return $id;
//echo "Payment Succesfull!";
$url = SITE_URL . '/project_details.php?pid=' . $_POST['pid'];
echo $url;
$value['sta'] = $_POST['s_value'];
$value['pro'] = $_POST['p_value'];
$value['ris'] = $_POST['r_value'];
$value['tim'] = $_POST['t_value'];
$value['red'] = $_POST['rd_value'];
$value['imp'] = $_POST['i_value'];
$value['prf'] = $_POST['pr_value'];
// print_r($value);
$data = json_encode($value, true);
$id = AdminRateProject($value);
//print_r($id);
if ($id) {
$score = calculate_mr($_POST['project_id']);
updateProjectSeed($_POST['project_id'], $score);
$project_title = getProjectTitle($_POST['project_id']);
$sent_to = getProjectAuthor($_POST['project_id']);
$author = getUserNameById($_SESSION['uid']);
$url = SITE_URL . '/home.php?pid=' . $_POST['project_id'];
$text = $author . ' rated project ' . $project_title;
addNotification($sent_to, $text, $_SESSION['uid'], $url);
addInteraction($_SESSION['uid'], 'rate', $sent_to, 'project', $_POST['project_id']);
$responce['result'] = 'OK';
} else {
$responce['result'] = '';
}
echo json_encode($responce);
break;
case 'assign-rater':
require_once DIR_APP . 'users.php';
require_once DIR_APP . 'projects.php';
$id = AddRaterToProject($_POST['project_id'], $_SESSION['uid'], $_POST['sent_to']);
