<?php
if (!defined('DC')) {
die("!defined('DC')");
}
if (!isset($tpl['cf_url'])) {
$tpl['cf_url'] = '';
}
$tpl['category_id'] = intval($_REQUEST['parameters']['category_id']);
$add_sql = '';
if ($tpl['category_id']) {
$add_sql = " AND `category_id` = '{$tpl['category_id']}' ";
}
$res = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\tSELECT `" . DB_PREFIX . "cf_projects`.*\n\t\tFROM `" . DB_PREFIX . "cf_projects`\n\t\tLEFT JOIN `" . DB_PREFIX . "cf_projects_data` ON `" . DB_PREFIX . "cf_projects_data`.`project_id` = `" . DB_PREFIX . "cf_projects`.`id`\n\t\tWHERE `del_block_id` = 0 AND\n\t\t\t\t\t `end_time` > " . time() . " AND\n\t\t\t\t\t `lang_id` = {$lang}\n\t\t\t\t \t {$add_sql}\n\t\tORDER BY `funders` DESC\n\t\tLIMIT 100\n\t\t");
while ($row = $db->fetchArray($res)) {
$row = array_merge(project_data($row, $tpl['cf_url']), $row);
$tpl['projects'][$row['id']] = $row;
}
asort($lng['cf_category']);
$tpl['currency_list'] = get_currency_list($db);
if (isset($_REQUEST['parameters']['category_id'])) {
$tpl['cur_category'] = $lng['cf_category'][$tpl['category_id']];
} else {
$tpl['cur_category'] = false;
}
require_once ABSPATH . 'templates/cf_catalog.tpl';
$script_name = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\tSELECT `script_name`\n\t\tFROM `" . DB_PREFIX . "main_lock`\n\t\t", 'fetch_one');
if ($script_name == 'my_lock') {
$tpl['demons_status'] = 'OFF';
} else {
$tpl['demons_status'] = 'ON';
}
if (isset($db) && get_community_users($db)) {
$pool_admin_user_id = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\t\tSELECT `pool_admin_user_id`\n\t\t\t\tFROM `" . DB_PREFIX . "config`\n\t\t\t\t", 'fetch_one');
if ((int) $_SESSION['user_id'] === (int) $pool_admin_user_id) {
define('POOL_ADMIN', true);
}
}
// несколько краудфандинговых проектов
$res = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\tSELECT `" . DB_PREFIX . "cf_projects`.*\n\t\tFROM `" . DB_PREFIX . "cf_projects`\n\t\tLEFT JOIN `" . DB_PREFIX . "cf_projects_data` ON `" . DB_PREFIX . "cf_projects_data`.`project_id` = `" . DB_PREFIX . "cf_projects`.`id`\n\t\tWHERE `del_block_id` = 0 AND\n\t\t\t\t\t `end_time` > " . time() . " AND\n\t\t\t\t\t `lang_id` = {$lang}\n\t\tORDER BY `funders` DESC\n\t\tLIMIT 3\n\t\t");
while ($row = $db->fetchArray($res)) {
$row = array_merge(project_data($row), $row);
$tpl['projects'][$row['id']] = $row;
}
// история операций по кошелькам
if (empty($_SESSION['restricted'])) {
// получаем последние транзакции по кошелькам
$res = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\t\tSELECT *\n\t\t\t\tFROM `" . DB_PREFIX . MY_PREFIX . "my_dc_transactions`\n\t\t\t\tWHERE `status` = 'approved'\n\t\t\t\tORDER BY `id` DESC\n\t\t\t\tLIMIT 0, 10\n\t\t\t\t");
while ($row = $db->fetchArray($res)) {
$tpl['my_dc_transactions'][] = $row;
}
}
$res = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\tSELECT *\n\t\tFROM `" . DB_PREFIX . "credits`\n\t\tWHERE (`from_user_id` = {$user_id} OR `to_user_id` = {$user_id}) AND\n\t\t\t\t\t `del_block_id` = 0 AND\n\t\t\t\t\t `amount` > 0\n\t\t");
while ($row = $db->fetchArray($res)) {
if ($user_id == $row['from_user_id']) {
$tpl['I_debtor'][] = $row;
} else {
die('!user_id');
}
$user_id = intval($_SESSION['user_id']);
define('DC', TRUE);
define('ABSPATH', dirname(dirname(__FILE__)) . '/');
set_time_limit(0);
//require_once( ABSPATH . 'includes/errors.php' );
require_once ABSPATH . 'db_config.php';
require_once ABSPATH . 'includes/autoload.php';
$db = new MySQLidb(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME, DB_PORT);
$lang = get_lang();
$project_id = intval($_REQUEST['project_id']);
$cf_project = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\tSELECT *\n\t\tFROM `" . DB_PREFIX . "cf_projects`\n\t\tWHERE `del_block_id`=0 AND\n\t\t\t\t\t `id` = {$project_id}\n\t\t", 'fetch_array');
if (!$cf_project) {
die(json_encode(array('error' => 'No project')));
}
$cf_project = array_merge(project_data($cf_project), $cf_project);
// сколько у нас есть DC данной валюты
$wallet = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\tSELECT *\n\t\t\tFROM `" . DB_PREFIX . "wallets`\n\t\t\tWHERE `user_id` = {$user_id} AND\n\t\t\t\t\t\t `currency_id` = {$cf_project['currency_id']}\n\t\t\t", 'fetch_array');
if ($wallet) {
$wallet['amount'] += calc_profit_($wallet['currency_id'], $wallet['amount'], $user_id, $db, $wallet['last_update'], time(), 'wallet');
$wallet['amount'] = floor(round($wallet['amount'], 3) * 100) / 100;
$forex_orders_amount = $db->query(__FILE__, __LINE__, __FUNCTION__, __CLASS__, __METHOD__, "\n\t\t\t\t\tSELECT sum(`amount`)\n\t\t\t\t\tFROM `" . DB_PREFIX . "forex_orders`\n\t\t\t\t\tWHERE `user_id` = {$user_id} AND\n\t\t\t\t\t\t\t\t `sell_currency_id` = {$wallet['currency_id']} AND\n\t\t\t\t\t\t\t\t `del_block_id` = 0\n\t\t\t\t\t", 'fetch_one');
$wallet['amount'] -= $forex_orders_amount;
} else {
$wallet['amount'] = 0;
}
$cf_project['wallet_amount'] = $wallet['amount'];
$currency_list = get_currency_list($db);
$cf_project['currency'] = $currency_list[$cf_project['currency_id']];
print json_encode($cf_project);
