Esempio n. 1
0
function getCData()
{
    //$news = dbMassData("SELECT * FROM news WHERE dateT !='0000-00-00 00:00:00' GROUP BY dateT ORDER BY dateT ASC");
    $prices = dbMassData("SELECT * FROM minuteCoin WHERE tDate != '0000-00-00 00:00:00' AND current != 0 AND bid != 0 ORDER BY timestamp DESC LIMIT 240");
    $resp = array("prices" => $prices);
    return $resp;
}
function addGetChat($userN, $mes)
{
    dbQuery("INSERT INTO chat (username, message) VALUES ('{$userN}', '{$mes}')");
    $chatHistory = dbMassData("SELECT * FROM chat ORDER BY timestamp DESC LIMIT 10");
    $resp = array("status" => "success", "reason" => "chat added", "data" => $chatHistory);
    return $resp;
}
Esempio n. 3
0
function getCData()
{
    $news = dbMassData("SELECT * FROM news WHERE dateT !='0000-00-00 00:00:00' GROUP BY dateT ORDER BY dateT ASC");
    $prices = dbMassData("SELECT * FROM minuteCoin WHERE tDate != '0000-00-00 00:00:00' GROUP BY tDate ORDER BY timestamp DESC LIMIT 100");
    $resp = array("news" => $news, "prices" => $prices);
    return $resp;
}
Esempio n. 4
0
function register($name, $email, $password)
{
    //check for user table
    //if it doesn't exist, create it (first time this script is run)
    //validation
    if (!isset($email)) {
        $response = array("status" => "fail", "resp" => "Please send afRegEmail ");
        return $response;
    }
    if (!isset($name)) {
        $response = array("status" => "fail", "resp" => "Please send a afRegName ");
        return $response;
    }
    if (!isset($password)) {
        $response = array("status" => "fail", "resp" => "Please send a afRegPassword ");
        return $response;
    }
    //encrpyt password
    $password = md5($password);
    $ipAddress = $_SERVER['REMOTE_ADDR'];
    //echo('ip='.$ipAddress);
    $allUsers = dbMassData("SELECT * FROM users WHERE email = '{$email}'");
    if ($allUsers == null) {
        dbQuery("INSERT INTO users (name, email, password, ipAddress) VALUES ('{$name}', '{$email}', '{$password}', '{$ipAddress}')");
        $resp = array("status" => "success");
        //now login user
        return $resp;
        //return $response;
    } else {
        $response = array("status" => "fail", "resp" => "emailTaken");
        return $response;
    }
}
Esempio n. 5
0
function loginUser($email, $password)
{
    if (!isset($email)) {
        $response = array("status" => "fail", "resp" => "Please send afLoginEmail ");
        return $response;
    }
    if (!isset($password)) {
        $response = array("status" => "fail", "resp" => "Please send a afLoginPassword ");
        return $response;
    }
    //encrpyt password
    $password = md5($password);
    $ipAddress = $_SERVER['REMOTE_ADDR'];
    //echo('ip='.$ipAddress);
    $userInfo = dbMassData("SELECT * FROM users WHERE email = '{$email}' AND password='******'");
    if ($userInfo != null) {
        session_id();
        session_start();
        $_SESSION['userId'] = $userInfo[0]['rId'];
        $_SESSION['uId'] = $userInfo[0]['rId'];
        $_SESSION['name'] = $userInfo[0]['name'];
        $_SESSION['email'] = $userInfo[0]['email'];
        $_SESSION['originalIP'] = $userInfo[0]['ipAddress'];
        $response = array("status" => "success", "resp" => $_SESSION);
        return $response;
    } else {
        $response = array("status" => "fail", "resp" => "notValidPair");
        return $response;
    }
}
function getFeatItems($category = "kitchen")
{
    $results = dbMassData("SELECT * FROM itemsForSale WHERE active = 'true' AND category LIKE '%{$category}%' ORDER BY timeAdded DESC LIMIT 50");
    if ($results == NULL) {
        $resp = array("status" => "failed", "reason" => "no  items found for sale in our inventory from that category");
        return $resp;
    } else {
        return array("status" => "success", "data" => $results, "reason" => "found results");
        return $response;
    }
}
function getColItems($userId)
{
    $results = dbMassData("SELECT * FROM myCollection WHERE removed != 'true' AND userId = {$userId} ORDER BY timestamp DESC LIMIT 200");
    if ($results == NULL) {
        $resp = array("status" => "failed", "reason" => "no  items found for users' collection...");
        return $resp;
    } else {
        return array("status" => "success", "data" => $results, "reason" => "found photos in your collection");
        return $response;
    }
}
Esempio n. 8
0
function getUserInfo()
{
    session_start();
    if (isset($_SESSION['email'])) {
        $email = $_SESSION['email'];
        $userInfo = dbMassData("SELECT * FROM users WHERE email = '{$email}'");
        $response = array("status" => "success", "resp" => $_SESSION);
        return $response;
    } else {
        $response = array("status" => "fail", "resp" => "notSignedIn");
        return $response;
    }
}
Esempio n. 9
0
function getSent()
{
    $data = dbMassData("SELECT * FROM news ORDER BY dateT DESC");
    for ($i = 0; $i < count($data); $i++) {
        $info1 = $data[$i]['headline'] . " " . $data[$i]['beginning'];
        $senti = file_get_contents("http://alina-prod.apigee.net/sentiment?info1=" . urlencode($info1) . "&apikey=npIZYYxsfzE0DOVX92oEPwGTV95wg7X6");
        $sentiment = json_decode($senti, true);
        $score = $sentiment['data']['score'];
        $cScore = $sentiment['data']['comparative'];
        $rId = $data[$i]['rId'];
        dbQuery("UPDATE news SET sentiment = {$score}, comparative= {$cScore} WHERE rId = {$rId} ");
        echo "UPDATE news SET sentiment = {$score}, comparative= {$cScore} WHERE rId = {$rId} ";
        echo "<br>";
    }
    return true;
}
Esempio n. 10
0
function loginUser($email, $pass)
{
    $pass = md5($pass);
    $userAccount = dbMassData("SELECT * FROM settings WHERE email = '{$email}' AND passwd= '{$pass}'");
    if ($userAccount == NULL) {
        $resp = array("status" => "fail", "reason" => "invalid credentials");
        return $resp;
        //password/email not valid
    } else {
        $resp = array("status" => "success", "data" => $userAccount[0], "reason" => "invalid credentials");
        session_id();
        session_start();
        $_SESSION['userId'] = $userAccount[0]['userId'];
        $_SESSION['rId'] = $userAccount[0]['rId'];
        $_SESSION['email'] = $userAccount[0]['email'];
        return $resp;
    }
}
Esempio n. 11
0
function seeIf($whichId)
{
    $resp1 = dbMassData("SELECT * FROM transactions WHERE id = {$whichId} ORDER BY timestamp DESC LIMIT 1");
    $theResp = array();
    if ($resp1 == null) {
        $thePrice = dbMassData("SELECT * FROM minuteCoin ORDER BY timestamp DESC LIMIT 1");
        //not there
        $priceOh = floatval($thePrice[0]['ask']) * 1.01;
        $thePrice = floatval($thePrice[0]['ask']);
        $thePrice = $thePrice + 0.05;
        $buyPriceNow = floatval($thePrice[0]['ask']);
        dbQuery("INSERT INTO transactions (price, sellPrice, active, id, which) VALUES ({$thePrice}, {$priceOh}, 'true', {$whichId}, 'buy' ) ");
        $theResp = array("active" => "true", "bidWaiting" => $priceOh, "buyPrice" => $thePrice);
        return $theResp;
    } else {
        if ($resp1[0]['active'] == "false") {
            $thePrice = dbMassData("SELECT * FROM minuteCoin ORDER BY timestamp DESC LIMIT 1");
            //not there
            $priceOh = floatval($thePrice[0]['ask']) * 1.01;
            $thePrice = floatval($thePrice[0]['ask']);
            //ten cents higher
            $buyPriceNow = floatval($thePrice[0]['ask']);
            //place order for price oh
            dbQuery("INSERT INTO transactions (price, sellPrice, active, id, which) VALUES ({$thePrice}, {$priceOh}, 'true', {$whichId}, 'buy' ) ");
            //active is set to true but we return false so node triggers the buy order, and then the sell
            $theResp = array("active" => "false", "bidWaiting" => $priceOh, "buyPrice" => $thePrice);
            return $theResp;
        } else {
            //
            $thePrice = dbMassData("SELECT * FROM minuteCoin ORDER BY timestamp DESC LIMIT 1");
            //set all to false to prevent bullshit
            if (floatval($thePrice[0]['current']) >= floatval($resp1[0]['sellPrice'])) {
                //time to trade!
                dbQuery("UPDATE transactions SET active = 'false', which='sold' WHERE id={$whichId}");
                $theResp = array("active" => "false");
            } else {
                dbQuery("UPDATE transactions SET active = 'true' WHERE id = {$whichId}");
                $theResp = array("active" => "true", "waitingFor" => floatval($resp1[0]['sellPrice']));
            }
            return $theResp;
        }
    }
}
Esempio n. 12
0
function retData($which, $col, $tick, $start, $end)
{
    if (!isset($start)) {
        $start = '2014-11-06 00:00:00';
    }
    if (!isset($end)) {
        $end = date('Y-m-d H:i:s');
    }
    if (!isset($tick)) {
        $tick = 5;
    }
    $tick = intval($tick);
    $resp = dbMassData("SELECT * FROM {$which} WHERE mod(minute(timestamp),{$tick}) = 0 AND timestamp < '{$end}' AND timestamp > '{$start}'");
    $resArr = array();
    for ($i = 0; $i < count($resp); $i++) {
        array_push($resArr, $resp[$i][$col]);
    }
    return $resArr;
}
Esempio n. 13
0
        $link = explode('"', $linkArr[1]);
        $link = $link[0];
        echo '<br>';
        echo $link;
        echo '<br><br>';
        $id = $link;
        $link = 'http://' . $city . '.craigslist.org/reply/' . $link;
        $contactLink = $link;
        $contactPage = file_get_contents($link);
        $linkArr = explode('readonly="readonly" value="', $contactPage);
        $email = explode('"', $linkArr[1]);
        $email = $email[0];
        echo $email;
        echo '<br><br>';
        $fieldsArr = array('id' => $id, 'email' => $email, 'contactLink' => $contactLink, 'title' => $title, 'info' => $body);
        $source = "craigslist";
        $tableName = 'postings';
        $fieldsArr = $fieldsArr;
        $checkExists = true;
        $print = true;
        $checkAdded = false;
        $updateBool = false;
        $addNewFields = true;
        $exists = dbMassData("SELECT * FROM postings WHERE id ='{$id}'");
        if ($exists == null) {
            if (isset($email)) {
                rollAdd($tableName, $fieldsArr, $checkExists, $print, $checkAdded, $updateBool, $addNewFields);
            }
        }
    }
}
Esempio n. 14
0
<?php

include_once '/var/www/html/cloud/models/db/dbLib.php';
include_once '/var/www/html/cloud/models/db/dbShortcuts.php';
include_once '/var/www/html/cloud/models/db/session.php';
extract($_REQUEST);
if (isset($userId) && ($fbId == "" || !isset($fbId))) {
    //$userEdits = dbMassData("SELECT * FROM userEdits WHERE userId = '$userId' ORDER BY timestamp DESC LIMIT 1");
    //echo(json_encode($userEdits[0]));
} else {
    if (isset($userId) && isset($fbId)) {
        $userEdits = dbMassData("SELECT * FROM userEdits WHERE fbId='{$fbId}'  ORDER BY timestamp DESC LIMIT 1");
        echo json_encode($userEdits[0]);
    } else {
        if (!isset($userId) && isset($fbId)) {
            $userEdits = dbMassData("SELECT * FROM userEdits WHERE fbId='{$fbId}' ORDER BY timestamp DESC LIMIT 1");
            echo json_encode($userEdits[0]);
        } else {
            return;
        }
    }
}
Esempio n. 15
0
function getCData($limit, $tick, $whatBetter)
{
    $limit = intval($limit);
    //$news = dbMassData("SELECT * FROM news WHERE dateT !='0000-00-00 00:00:00' GROUP BY dateT ORDER BY dateT ASC");
    $prices = dbMassData("SELECT * FROM minuteCoin WHERE mod(minute(timestamp),{$tick}) AND tDate != '0000-00-00 00:00:00' ORDER BY timestamp DESC LIMIT 1000");
    $prices = array_reverse($prices);
    $respArr = array("buy" => array(), "dont" => array());
    for ($i = 0; $i < count($prices); $i++) {
        $outOne = $i + $limit;
        $startPrice = floatval($prices[$i]['ask']);
        $endPrice = floatval($prices[$outOne]['bid']);
        if ($endPrice > $startPrice + $startPrice * $whatsBetter) {
            $thisBlock = array("bidsAfter" => array(), "bidsRateBefore" => array(), "bidsRateAfter" => array(), "bidsBefore" => array(), "asksAfter" => array(), "asksBefore" => array(), "asksRateBefore" => array(), "asksRateAfter" => array(), "pricesAfter" => array(), "pricesBefore" => array(), "pricesRateBefore" => array(), "pricesRateAfter" => array(), "spreadAfter" => array(), "spreadBefore" => array());
            $startingPoint = $i;
            try {
                for ($j = 0; $j < $limit; $j++) {
                    $thisOne = $startingPoint + $j;
                    $oneBefore = $thisOne - 1;
                    array_push($thisBlock['bidsAfter'], floatval($prices[$thisOne]['bid']));
                    array_push($thisBlock['asksAfter'], floatval($prices[$thisOne]['ask']));
                    array_push($thisBlock['pricesAfter'], floatval($prices[$thisOne]['current']));
                    $bidsRateAfter = sqrt(floatval($prices[$thisOne]['bid']) / floatval($prices[$oneBefore]['bid'])) * 0.5;
                    $asksRateAfter = sqrt(floatval($prices[$thisOne]['ask']) / floatval($prices[$oneBefore]['ask'])) * 0.5;
                    $pricesRateAfter = sqrt(floatval($prices[$thisOne]['current']) / floatval($prices[$oneBefore]['current'])) * 0.5;
                    $spreadAfter = floatval($prices[$thisOne]['bid']) / floatval($prices[$thisOne]['ask']);
                    array_push($thisBlock['bidsRateAfter'], $bidsRateAfter);
                    array_push($thisBlock['asksRateAfter'], $asksRateAfter);
                    array_push($thisBlock['pricesRateAfter'], $pricesRateAfter);
                    array_push($thisBlock['spreadAfter'], $spreadAfter);
                }
                //get fifteen before
                for ($j = $limit; $j > 0; $j--) {
                    $thisOne = $startingPoint - $j;
                    $oneBefore = $thisOne - 1;
                    array_push($thisBlock['bidsBefore'], floatval($prices[$thisOne]['bid']));
                    array_push($thisBlock['asksBefore'], floatval($prices[$thisOne]['ask']));
                    array_push($thisBlock['pricesBefore'], floatval($prices[$thisOne]['current']));
                    $bidsRateBefore = sqrt(floatval($prices[$thisOne]['bid']) / floatval($prices[$oneBefore]['bid'])) * 0.5;
                    $asksRateBefore = sqrt(floatval($prices[$thisOne]['ask']) / floatval($prices[$oneBefore]['ask'])) * 0.5;
                    $pricesRateBefore = sqrt(floatval($prices[$thisOne]['current']) / floatval($prices[$oneBefore]['current'])) * 0.5;
                    $spreadBefore = floatval($prices[$thisOne]['bid']) / floatval($prices[$thisOne]['ask']);
                    array_push($thisBlock['bidsRateBefore'], $bidsRateBefore);
                    array_push($thisBlock['asksRateBefore'], $asksRateBefore);
                    array_push($thisBlock['pricesRateBefore'], $pricesRateBefore);
                    array_push($thisBlock['spreadBefore'], $spreadBefore);
                }
            } catch (Exception $e) {
            }
            array_push($respArr['buy'], $thisBlock);
        } else {
            $thisBlock = array("bidsAfter" => array(), "bidsRateBefore" => array(), "bidsRateAfter" => array(), "bidsBefore" => array(), "asksAfter" => array(), "asksBefore" => array(), "asksRateBefore" => array(), "asksRateAfter" => array(), "pricesAfter" => array(), "pricesBefore" => array(), "pricesRateBefore" => array(), "pricesRateAfter" => array(), "spreadBefore" => array(), "spreadAfter" => array());
            $startingPoint = $i;
            try {
                for ($j = 0; $j < $limit; $j++) {
                    $thisOne = $startingPoint + $j;
                    $oneBefore = $thisOne - 1;
                    array_push($thisBlock['bidsAfter'], floatval($prices[$thisOne]['bid']));
                    array_push($thisBlock['asksAfter'], floatval($prices[$thisOne]['ask']));
                    array_push($thisBlock['pricesAfter'], floatval($prices[$thisOne]['current']));
                    $bidsRateAfter = sqrt(floatval($prices[$thisOne]['bid']) / floatval($prices[$oneBefore]['bid'])) * 0.5;
                    $asksRateAfter = sqrt(floatval($prices[$thisOne]['ask']) / floatval($prices[$oneBefore]['ask'])) * 0.5;
                    $pricesRateAfter = sqrt(floatval($prices[$thisOne]['current']) / floatval($prices[$oneBefore]['current'])) * 0.5;
                    $spreadAfter = floatval($prices[$thisOne]['bid']) / floatval($prices[$thisOne]['ask']);
                    array_push($thisBlock['bidsRateAfter'], $bidsRateAfter);
                    array_push($thisBlock['asksRateAfter'], $asksRateAfter);
                    array_push($thisBlock['pricesRateAfter'], $pricesRateAfter);
                    array_push($thisBlock['spreadAfter'], $spreadAfter);
                }
                //get fifteen before
                for ($j = $limit; $j > 0; $j--) {
                    $thisOne = $startingPoint - $j;
                    $oneBefore = $thisOne - 1;
                    array_push($thisBlock['bidsBefore'], floatval($prices[$thisOne]['bid']));
                    array_push($thisBlock['asksBefore'], floatval($prices[$thisOne]['ask']));
                    array_push($thisBlock['pricesBefore'], floatval($prices[$thisOne]['current']));
                    $bidsRateBefore = sqrt(floatval($prices[$thisOne]['bid']) / floatval($prices[$oneBefore]['bid'])) * 0.5;
                    $asksRateBefore = sqrt(floatval($prices[$thisOne]['ask']) / floatval($prices[$oneBefore]['ask'])) * 0.5;
                    $pricesRateBefore = sqrt(floatval($prices[$thisOne]['current']) / floatval($prices[$oneBefore]['current'])) * 0.5;
                    $spreadBefore = floatval($prices[$thisOne]['bid']) / floatval($prices[$thisOne]['ask']);
                    array_push($thisBlock['bidsRateBefore'], $bidsRateBefore);
                    array_push($thisBlock['asksRateBefore'], $asksRateBefore);
                    array_push($thisBlock['pricesRateBefore'], $pricesRateBefore);
                    array_push($thisBlock['spreadBefore'], $spreadBefore);
                }
            } catch (Exception $e) {
            }
            array_push($respArr['dont'], $thisBlock);
        }
    }
    $resp = array("blocks" => $respArr);
    return $resp;
}
Esempio n. 16
0
function renderConvo($sent)
{
    $userId = $_SESSION['userId'];
    $correctTerms = array("wrong", "incorrect", "no,", "not correct", "next", "->", "-->", "another");
    $lastConversation = dbMassData("SELECT * FROM conversations WHERE userId = '{$userId}' ORDER BY timestamp DESC LIMIT 2");
    if ($lastConversation == null) {
    }
    //echo("Last is ".$lastConversation[1]['type'] );
    if ($lastConversation[1]['type'] == "question") {
        $words = explode(" ", $sent);
        $firstWord = $words[0];
        for ($i = 0; $i < count($correctTerms); $i++) {
            if (strpos($sent, $correctTerms[$i]) !== false) {
                // containts the terms we're looking for in order to know that we need to render as question but get next result;
                $resp = renderAnswer($lastConversation[1]['statement'], 1);
                return $resp;
            }
        }
    }
    $resu = json_decode(file_get_contents('http://chat-maybe588.rhcloud.com/chatbot/?msg=' . urlencode($sent) . '&user=1&room=1'), true);
    if (isset($resu['status'])) {
        return array("status" => "fail");
    } else {
        if (strpos($resu['content'], "what") !== false && strpos($resu['content'], "called") !== false || strpos($resu['content'], "what") !== false && strpos($resu['content'], "name") !== false) {
            return renderConvo("mike");
        }
        return array("status" => "success", "answer" => $resu['content'], "bot" => $resu['which'], "answerType" => "convo", "original" => "convo");
    }
}
Esempio n. 17
0
<?php

include_once '/var/www/html/cloud/models/db/dbLib.php';
include_once '/var/www/html/cloud/models/db/dbShortcuts.php';
include_once '/var/www/html/cloud/models/db/session.php';
extract($_REQUEST);
if (isset($liId)) {
    //$userEdits = dbMassData("SELECT * FROM userEdits WHERE userId = '$userId' ORDER BY timestamp DESC LIMIT 1");
    //echo(json_encode($userEdits[0]));
    $userEdits = dbMassData("SELECT * FROM userEdits WHERE linkedInId='{$liId}' ORDER BY timestamp DESC LIMIT 1");
    echo json_encode($userEdits[0]);
} else {
    return;
}