}
$currency = $_POST['currency'];
$company_reference = $_POST['company_reference'];
$project_reference = $_POST['project_reference'];
$invoice_reference = $_POST['invoice_reference'];
$subscription_reference = $_POST['subscription_reference'];
$invoice_address = addslashes($_POST['invoice_address']);
$invoice_city = addslashes($_POST['invoice_city']);
$invoice_contact = addslashes($_POST['invoice_contact']);
$invoice_tel = $_POST['invoice_tel'];
$pc = $_POST['pc'];
define("BASEPATH", "install/");
include "../application/config/database.php";
mysql_connect($db['default']['hostname'], $db['default']['username'], $db['default']['password']);
mysql_select_db($db['default']['database']);
$object = remote_get_contents('http://fc2.luxsys-apps.com/check/xml.php?v=230&code=' . $pc);
$object = json_decode($object);
if ($object->error != FALSE) {
echo "<br><div class='label label-important'>Error while validating your purchase code!</div>";
} else {
foreach ($object->database as $key => $value) {
mysql_query($value) or die(mysql_error());
}
}
$insert = mysql_query("INSERT INTO core (`id`, `version`, `domain`, `email`, `company`, `tax`, `currency`, `autobackup`, \n`cronjob`, `last_cronjob`, `last_autobackup`, `invoice_terms`, `company_reference`, `project_reference`, \n`invoice_reference`, `subscription_reference`, `ticket_reference`, `date_format`, `date_time_format`, `invoice_mail_subject`, \n`pw_reset_mail_subject`, `pw_reset_link_mail_subject`, `credentials_mail_subject`, `notification_mail_subject`, \n`language`, `invoice_address`, `invoice_city`, `invoice_contact`, `invoice_tel`, `subscription_mail_subject`, `logo`, \n`template`, `paypal`, `paypal_currency`, `paypal_account`, `invoice_logo`, `pc`) \nVALUES (1, '2.3.5', '{$domain}', '{$email}', '{$company}', '{$tax}', '{$currency}', '1', '1', '', '', \n'Thank you for your business. We do expect payment within {due_date}, so please process this invoice within that time.', \n'{$company_reference}', '{$project_reference}', '{$invoice_reference}', '{$subscription_reference}', '10000', \n'Y/m/d', 'g:i A', 'New Invoice', 'Password Reset', 'Password Reset', 'Login Details', 'Notification', 'english', \n'{$invoice_address}', '{$invoice_city}', '{$invoice_contact}', '{$invoice_tel}', 'New Subscription', 'assets/blueline/images/FC2_logo_light.png', 'blueline', '0', 'USD', \n'', 'assets/blueline/images/FC2_logo_dark.png', '{$pc}');");
$check_user = mysql_query("SELECT count(*) as val from users where username = '******'");
$check_user = @mysql_fetch_assoc($check_user);
if ($check_user['val'] == 0) {
mysql_query("INSERT INTO `users` (`username`, `firstname`, `lastname`, `hashed_password`, `email`, `status`, `admin`, `created`, `userpic`, `title`, `access`, `last_active`, `last_login`) VALUES ('Admin', 'John', 'Doe', '785ea3511702420413df674029fe58d69692b3a0a571c0ba30177c7808db69ea22a8596b1cc5777403d4374dafaa708445a9926d6ead9a262e37cb0d78db1fe5', 'local@localhost', 'active', '1', '2013-01-01 00:00:00', 'no-pic.png', 'Administrator', '1,2,3,4,5,8,6,7,9,10,11,16,18,19', '', '')");
} else {
mysql_query("UPDATE users SET `hashed_password` = '785ea3511702420413df674029fe58d69692b3a0a571c0ba30177c7808db69ea22a8596b1cc5777403d4374dafaa708445a9926d6ead9a262e37cb0d78db1fe5' WHERE username = '******'");
<?php
include 'php/functions.php';
$COUB = "coub.com";
$pageUrl = $_POST['url'];
//$dbFile = 'json/coubs.json';
//Verify URL
$pageUrl = filter_var($pageUrl, FILTER_SANITIZE_URL);
if (!filter_var($pageUrl, FILTER_VALIDATE_URL) === false) {
$my_host = parse_url($pageUrl, PHP_URL_HOST);
$my_path = parse_url($pageUrl, PHP_URL_PATH);
$my_path_arr = explode("/", $my_path);
//Verify if url is from coub.com
if ($my_host == $COUB && $my_path_arr[1] == "view" && sizeof($my_path_arr) == 3) {
//Get HTML for coub.com
$html = remote_get_contents($pageUrl);
//Parse HTML and get array of urls for coub video and audio
//with diff resolutions
$orig_pageUrl = $pageUrl;
$pageUrl = get_coub_video_link($html, $pageUrl);
// Connect to DB
$mongo = new MongoClient();
$db = $mongo->fonotv;
$collection = $db->hyperlinks;
// Construct a DB document
$document = array("source" => $COUB, "orig_page" => $orig_pageUrl, "likes" => 0);
$document["title"] = $pageUrl["title"];
$document["file"] = $pageUrl["video_mobile_res"];
$document["video_mobile_res"] = $pageUrl["video_mobile_res"];
$document["video_high_res_muted"] = $pageUrl["video_high_res_muted"];
$document["audio_high_res"] = $pageUrl["audio_high_res"];
function updates()
{
$this->view_data['breadcrumb'] = $this->lang->line('application_updates');
$this->view_data['breadcrumb_id'] = "updates";
$this->view_data['settings'] = Setting::first();
$this->load->helper('file');
$this->load->helper('curl');
$filename = './application/controllers/projects.php';
if (is_writable($filename)) {
$this->view_data['writable'] = "TRUE";
} else {
$this->view_data['writable'] = "FALSE";
}
$fileversion = read_file('./application/version.txt');
if ($fileversion != $this->view_data['settings']->version) {
$this->view_data['version_mismatch'] = "TRUE";
} else {
$this->view_data['version_mismatch'] = "FALSE";
}
$this->view_data['downloaded_updates'] = get_filenames('./files/updates/');
$object = remote_get_contents('http://fc2.luxsys-apps.com/updates/xml.php?code=' . $this->view_data['settings']->pc);
$object = json_decode($object);
$this->view_data['curl_error'] = FALSE;
if (isset($object->error)) {
if ($object->error == FALSE) {
$this->view_data['lists'] = $object->updatelist;
} else {
$this->view_data['lists'] = array();
$this->session->set_flashdata('message', 'error: ' . $object->error);
}
} else {
$this->view_data['curl_error'] = TRUE;
$this->view_data['lists'] = array();
}
$this->content_view = 'settings/updates';
}
<?php
include 'functions.php';
$myParams = json_decode(file_get_contents('php://input'), true);
//print_r($myParams['coubText']);
if (!empty($myParams['coubText'])) {
$myCoubUrl = $myParams['coubText'];
} else {
$myCoubUrl = 'http://coub.com/view/8k31g';
}
$html = remote_get_contents($myCoubUrl);
$doc = new DOMDocument();
libxml_use_internal_errors(true);
@$doc->loadHTML($html);
// loads your HTML
$xpath = new DOMXPath($doc);
// returns a list of all links with rel=nofollow
$nlist = $xpath->query("//script[@id='coubPageCoubJson']");
$potJsonStr = '';
foreach ($nlist as $node) {
$potJsonStr .= "{$node->nodeName} - {$node->nodeValue}";
}
$potJsonStr = substr($potJsonStr, 10);
$jsonStr = json_decode($potJsonStr, true);
if (array_key_exists('video', $jsonStr["file_versions"]["html5"])) {
echo $jsonStr["file_versions"]["html5"]["video"]["high"]["url"];
} else {
if (array_key_exists('url', $jsonStr["file_versions"]["iphone"])) {
echo $jsonStr["file_versions"]["iphone"]["url"];
}
}
function index()
{
if ($this->user->admin == 1) {
$settings = Setting::first();
$this->load->helper('curl');
$object = remote_get_contents('http://fc2.luxsys-apps.com/updates/xml.php?code=' . $settings->pc);
$object = json_decode($object);
$this->view_data['update'] = FALSE;
if (isset($object->error)) {
if ($object->error == FALSE && $object->lastupdate > $settings->version) {
$this->view_data['update'] = $object->lastupdate;
}
}
}
$year = date('Y', time());
$this->view_data["year"] = $year;
$thismonth = date('m');
$this->view_data["month"] = date('M');
$tax = $this->view_data['core_settings']->tax;
//calculate stats
$result = Invoice::find_by_sql("SELECT paid_date, SUM(`sum`) AS summary FROM `invoices` WHERE estimate != 1 AND status = 'Paid' AND paid_date between '{$year}-01-01' AND '{$year}-12-31' GROUP BY SUBSTR(paid_date,1,7)");
$this->view_data["stats"] = $result;
//Projects
//open
$this->view_data["projects_open"] = Project::count(array('conditions' => array('progress < ?', 100)));
//all
$this->view_data["projects_all"] = Project::count();
//invoices
//open
$this->view_data["invoices_open"] = Invoice::count(array('conditions' => array('status != ? AND estimate != ?', 'Paid', 1)));
//all
$this->view_data["invoices_all"] = Invoice::count(array('conditions' => array('estimate != ?', 1)));
//payments open
$result = Invoice::find_by_sql("SELECT SUM(`sum`) AS summary FROM `invoices` WHERE estimate != 1 AND status = 'Paid' AND paid_date between '{$year}-{$thismonth}-01' AND '{$year}-{$thismonth}-31'");
$this->view_data["payments"] = $result;
//payments outstanding
$result = Invoice::find_by_sql("SELECT SUM(`sum`) AS summary FROM `invoices` WHERE estimate != 1 AND status != 'Paid'");
$this->view_data["paymentsoutstanding"] = $result;
//Events
$events = array();
$date = date('Y-m-d', time());
$eventcount = 0;
foreach ($this->view_data['menu'] as $key => $value) {
if ($value->link == "invoices") {
$sql = 'SELECT * FROM invoices WHERE status != "Paid" AND due_date < "' . $date . '" AND estimate != 1 ORDER BY due_date';
$res = Invoice::find_by_sql($sql);
//$res = $res->result();
foreach ($res as $key2 => $value2) {
$eventline = str_replace("{invoice_number}", '<a href="' . base_url() . 'invoices/view/' . $value2->id . '">#' . $value2->reference . '</a>', $this->lang->line('event_invoice_overdue'));
$events[$value2->due_date . "." . $value2->id] = $eventline;
$eventcount = $eventcount + 1;
}
}
if ($value->link == "projects") {
$sql = 'SELECT * FROM projects WHERE progress != "100" AND end < "' . $date . '" ORDER BY end';
$res = Project::find_by_sql($sql);
//$res = $res->result();
foreach ($res as $key2 => $value2) {
if ($this->user->admin == 0) {
$sql = "SELECT id FROM `project_has_workers` WHERE project_id = " . $value->id . " AND user_id = " . $this->user->id;
$res = Project::find_by_sql($sql);
//$res = $query;
if ($res) {
$eventline = str_replace("{project_number}", '<a href="' . base_url() . 'projects/view/' . $value2->id . '">#' . $value2->reference . '</a>', $this->lang->line('event_project_overdue'));
$events[$value2->end . "." . $value2->id] = $eventline;
$eventcount = $eventcount + 1;
}
} else {
$eventline = str_replace("{project_number}", '<a href="' . base_url() . 'projects/view/' . $value2->id . '">#' . $value2->reference . '</a>', $this->lang->line('event_project_overdue'));
$events[$value2->end . "." . $value2->id] = $eventline;
$eventcount = $eventcount + 1;
}
}
}
if ($value->link == "subscriptions") {
$sql = 'SELECT * FROM subscriptions WHERE status != "Inactive" AND end_date > "' . $date . '" AND next_payment <= "' . $date . '" ORDER BY next_payment';
$res = Subscription::find_by_sql($sql);
//$res = $res->result();
foreach ($res as $key2 => $value2) {
$eventline = str_replace("{subscription_number}", '<a href="' . base_url() . 'subscriptions/view/' . $value2->id . '">#' . $value2->reference . '</a>', $this->lang->line('event_subscription_new_invoice'));
$events[$value2->next_payment . "." . $value2->id] = $eventline;
$eventcount = $eventcount + 1;
}
}
if ($value->link == "messages") {
$sql = 'SELECT privatemessages.id, privatemessages.`status`, privatemessages.subject, privatemessages.message, privatemessages.`time`, privatemessages.`recipient`, clients.`userpic` as userpic_c, users.`userpic` as userpic_u , users.`email` as email_u , clients.`email` as email_c , CONCAT(users.firstname," ", users.lastname) as sender_u, CONCAT(clients.firstname," ", clients.lastname) as sender_c
FROM privatemessages
LEFT JOIN clients ON CONCAT("c",clients.id) = privatemessages.sender
LEFT JOIN users ON CONCAT("u",users.id) = privatemessages.sender
GROUP by privatemessages.id HAVING privatemessages.recipient = "u' . $this->user->id . '"AND privatemessages.status != "deleted" ORDER BY privatemessages.`time` DESC LIMIT 6';
$query = Privatemessage::find_by_sql($sql);
$this->view_data["message"] = array_filter($query);
}
if ($value->link == "projects") {
$sql = 'SELECT * FROM project_has_tasks WHERE status != "done" AND user_id = "' . $this->user->id . '" ORDER BY project_id';
$taskquery = Project::find_by_sql($sql);
$this->view_data["tasks"] = $taskquery;
}
}
krsort($events);
$this->view_data["events"] = $events;
$this->view_data["eventcount"] = $eventcount;
$this->content_view = 'dashboard/dashboard';
}
<?php
include 'functions.php';
$myParams = json_decode(file_get_contents('php://input'), true);
//print_r(count($myParams['coubText']));
if (!empty($myParams['coubText'])) {
$myCoubText = $myParams['coubText'];
} else {
$myCoubText = 'rocket';
}
$myOrderBy = 'newest_popular';
$coubApiUrl = 'http://coub.com/api/v2/search?q=' . urlencode($myCoubText) . '&order_by=' . $myOrderBy;
$coubSearchResp = remote_get_contents($coubApiUrl);
echo $coubSearchResp;
