$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']);