function SendTopPickTwits($debug)
{
global $hd;
global $config;
$default = 0;
$Yesterday = mktime(0, 0, 0, date("m"), date("d") - (1 - $default), date("Y"));
$LocalTime = localtime();
if ($LocalTime[2] < 6) {
$Today = $Yesterday;
$Yesterday = mktime(0, 0, 0, date("m"), date("d") - (2 - $default), date("Y"));
} else {
$Today = mktime(0, 0, 0, date("m"), date("d") - $default, date("Y"));
}
$ThisDate = date("Y-m-d", $Today);
$qq = "select *,New_opinion.id as Oid, New_company.name as CompanyName from New_opinion,New_company,New_expert where\n\t\tNew_opinion.company_id = New_company.id and \n\t\tNew_opinion.expert_id=New_expert.id and New_opinion.signal_id=16 and New_opinion.Date=\"{$ThisDate}\"";
/*$qq = "select *,New_opinion.id as Oid, New_company.name as CompanyName from New_opinion,New_company,New_expert where
New_opinion.company_id = New_company.id and
New_opinion.expert_id=New_expert.id and New_opinion.signal_id=16 and New_opinion.Date=\"2016-04-11\"";
*/
// New_opinion.signal_id==3 is comment
// New_opinion.signal_id==3 is comment
if ($debug) {
echo "Query is <br>{$qq}<br>";
}
$result1 = $hd->query($qq);
// print_r($hd->errorInfo());
$NumAlerts = $result1->rowCount();
//($result1);
// print_r($hd->errorInfo());
echo "Number of alerts is {$NumAlerts}<br>";
if ($debug) {
echo '<br>Debug';
}
for ($an = 0; $an < $NumAlerts; $an++) {
$row1 = $result1->fetch();
//$result1);
// foreach ($row1 as $key => $ra)
// echo "<br>$key is $ra";
//$cl = slink('http://www.stockchase.com/Company?ID='. $row1['company'],'','','','',$row1['company']);
$cl = '#stockaction #' . $row1['symbol'] . ' http://www.stockchase.com';
$companyline = 'http://www.stockchase.com/company/view/' . $row1['company_id'] . '/' . $row1['Oid'];
if ($debug) {
echo '<br>' . $companyline;
}
$companyline = getBitUrl($companyline);
$companyname = $row1['CompanyName'];
if (strlen($companyname > 10)) {
$companyname = substr($companyname, 0, 7);
$companyname .= '...';
}
$companyname = str_replace(" ", "-", $companyname);
if ($row1['CompanyName'] == $companyname) {
$companyname = "@" . $companyname;
}
$cl = $companyname . ' ' . $companyline . ' #stocks $' . $row1['symbol'];
$symbol = $row1['symbol'];
// $cl = 'http://www.stockchase.com/Opinion.php';
// $cl = 'http://tinyurl.com/5dqmwd';
$twitterStatus = strip_tags($row1['comment']);
$twitterStatus = str_replace(' ', ' ', $twitterStatus);
$twitterStatus = str_replace(';', ' ', $twitterStatus);
$twitterStatus = str_replace(' are ', ' r ', $twitterStatus);
$twitterStatus = str_replace(' wait ', ' W8 ', $twitterStatus);
$twitterStatus = str_replace(' ate ', ' 8 ', $twitterStatus);
$twitterStatus = str_replace(' late ', ' L8 ', $twitterStatus);
$twitterStatus = str_replace(' ', ' ', $twitterStatus);
if (strlen($twitterStatus . $cl) >= 129) {
$twitterStatus1 = substr($twitterStatus, 0, 126 - strlen($cl));
$twitterStatus = $twitterStatus1 . "...";
}
$twitterStatus .= $cl;
echo '<br>
';
echo $twitterStatus;
echo '
';
if ($debug) {
echo "<br>{$an} Would send to twitter <b>{$twitterStatus}</b>";
} else {
try {
$twitter = new Twitter($config['consumer_key'], $config['consumer_secret'], $config['access_token'], $config['access_token_secret']);
$twitter->send($twitterStatus);
} catch (Exception $e) {
echo 'Caught Exception: ', $e->getMessage(), '\\n';
// mail('*****@*****.**','stockchase twitter error');
//die('here');
}
//echo shell_exec('/home/stockchase/EditorFunctions/python/mytweet.py "'. $twitterStatus. '"');
flush();
sleep(5);
}
$tocompany = $companyname . " is Top Pick at StockChase http://www.stockchase.com/opinions/recent #stockaction \$" . $symbol;
echo '<br>
' . $tocompany . '
';
if ($debug) {
echo "<br>{$an} Would send to twitter <b>{$tocompany}</b>";
} else {
try {
$twitter = new Twitter($config['consumer_key'], $config['consumer_secret'], $config['access_token'], $config['access_token_secret']);
$twitter->send($tocompany);
} catch (Exception $e) {
echo 'Caught Exception: ', $e->getMessage(), '\\n';
// mail('*****@*****.**','stockchase twitter error company');
//die('here');
}
//echo shell_exec('/home/stockchase/EditorFunctions/python/mytweet.py "', $tocompany. '"');
flush();
sleep(10);
}
}
}
function SendCommentsTwits($debug)
{
global $hd;
$default = 0;
try {
$Yesterday = mktime(0, 0, 0, date("m"), date("d") - (1 - $default), date("Y"));
$LocalTime = localtime();
if ($LocalTime[2] < 6) {
$Today = $Yesterday;
$Yesterday = mktime(0, 0, 0, date("m"), date("d") - (2 - $default), date("Y"));
} else {
$Today = mktime(0, 0, 0, date("m"), date("d") - $default, date("Y"));
}
$ThisDate = date("Y-m-d", $Yesterday);
$qq = "select *,New_opinion.id as Oid, New_company.name as CompanyName from New_opinion,New_company,New_expert where\n\t\t\tNew_opinion.company_id = New_company.id and \n\t\t\tNew_opinion.expert_id=New_expert.id and New_opinion.signal_id=6 and New_opinion.Date>=\"{$ThisDate}\"";
// New_opinion.signal_id==3 is comment
if ($debug) {
echo "Query is <br>{$qq}<br>";
}
$result1 = $hd->query($qq);
$NumAlerts = $result1->rowCount();
//mysql_num_rows($result1);
echo "Number of alerts is {$NumAlerts}<br>";
if ($debug) {
echo '<br>Debug';
}
for ($an = 0; $an < $NumAlerts; $an++) {
//$row1=mysql_fetch_assoc($result1);
$row1 = $result1->fetch();
// foreach ($row1 as $key => $ra)
// echo "<br>$key is $ra";
//$cl = slink('http://www.stockchase.com/Company?ID='. $row1['company'],'','','','',$row1['company']);
$cl = '#stocks http://www.stockchase.com';
$companyline = 'http://www.stockchase.com/company/view/' . $row1['company_id'] . '/' . $row1['Oid'];
$companyline = getBitUrl($companyline);
$companyname = $row1['CompanyName'];
if (strlen($companyname > 10)) {
$companyname = substr($companyname, 0, 7);
$companyname .= '...';
}
$cl = $companyline . ' #trading #finance';
// $cl = 'http://www.stockchase.com/Opinion.php';
// $cl = 'http://tinyurl.com/5dqmwd';
$twitterStatus = strip_tags($row1['comment']);
$twitterStatus = str_replace(' ', ' ', $twitterStatus);
if (strlen($twitterStatus . $cl) > 140) {
$twitterStatus1 = substr($twitterStatus, 0, 137 - strlen($cl));
$twitterStatus = $twitterStatus1 . "...";
}
$twitterStatus .= $cl;
echo '<br>';
echo $twitterStatus;
if ($debug) {
echo "<br>{$an} Would send to twitter <b>{$twitterStatus}</b>";
} else {
// $this->tweet->call('post','statuses/update',array('status' => $twitterStatus));
echo shell_exec('/home/stockchase/EditorFunctions/python/mytweet.py "' . $twitterStatus . '"');
flush();
sleep(60 * 5);
}
}
} catch (PDOException $ex) {
echo $ex->getMessage();
}
}
