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