function compute_ratio($stimulus_word, $cooccurring_word)
{
$result = array();
$window_frequency_sql = "SELECT COUNT(keywords) FROM keywords_from_userinfo WHERE keywords LIKE '% " . $stimulus_word . " %' and keywords LIKE '% " . $cooccurring_word . " %';";
$window_frequency = query_count($window_frequency_sql);
$cooccurring_word_total_frequency_sql = "SELECT COUNT(keywords) FROM keywords_from_userinfo WHERE keywords LIKE '% " . $cooccurring_word . " %';";
$cooccurring_word_total_frequency = query_count($cooccurring_word_total_frequency_sql);
$residual_frequency = $cooccurring_word_total_frequency - $window_frequency;
$total_window_size_sql = "SELECT COUNT(keywords) FROM keywords_from_userinfo WHERE keywords LIKE '% " . $stimulus_word . " %';";
$total_window_size = query_count($total_window_size_sql);
$residual_window_size = $total_window_size - $window_frequency;
$total_corpus_size_sql = "SELECT COUNT(keywords) FROM keywords_from_userinfo";
$total_corpus_size = query_count($total_corpus_size_sql);
$residual_corpus_size = $total_corpus_size - $total_window_size - $cooccurring_word_total_frequency + $window_frequency;
$ratio = 0;
if ($window_frequency == 0) {
$ratio = 0;
} else {
if ($residual_frequency == 0 || $residual_window_size == 0) {
$ratio = 1000;
// represent infinite
} else {
$ratio = 2 * ($window_frequency * log($window_frequency) + $residual_window_size * log($residual_window_size) + $residual_frequency * log($residual_frequency) + $residual_corpus_size * log($residual_corpus_size) + $total_corpus_size * log($total_corpus_size) - ($window_frequency + $residual_window_size) * log($window_frequency + $residual_window_size) - ($window_frequency + $residual_frequency) * log($window_frequency + $residual_frequency) - ($residual_window_size + $residual_corpus_size) * log($residual_window_size + $residual_corpus_size) - ($residual_frequency + $residual_corpus_size) * log($residual_frequency + $residual_corpus_size));
}
}
$result['window_frequency'] = $window_frequency;
$result['total_window_size'] = $total_window_size;
$result['residual_window_size'] = $residual_window_size;
$result['cooccurring_word_total_frequency'] = $cooccurring_word_total_frequency;
$result['residual_frequency'] = $residual_frequency;
$result['residual_corpus_size'] = $residual_corpus_size;
$result['total_corpus_size'] = $total_corpus_size;
$result['ratio'] = $ratio;
return $result;
}
public function display_asset_definition($repo)
{
$query = "SELECT * FROM asset WHERE asset_id = '" . escape($repo) . "'";
if (!query_count($query)) {
$this->store_asset($repo);
}
$r = query_assoc($query);
if (!is_array($r)) {
die("{'error':'No Asset'}");
}
$arr = array('asset_ids' => array($r['public_id']), 'contract_url' => $r['contract_url'], 'name_short' => $r['name_short'], 'name' => $r['name'], 'issuer' => $r['issuer'], 'description' => $r['description'], 'description_mime' => $r['description_mime'], 'type' => $r['type'], 'divisibility' => $r['divisibility'], 'link_to_website' => $r['link_to_website'], 'icon_url' => $r['icon_url'], 'image_url' => $r['image_url'], 'version' => $r['version']);
return json_encode($arr);
}
}
//$main_query = $q->get_select_query($entries_to_show, $start_at);
if (!$bUseCSV && !$bDownloadAll && $entries_to_show) {
if ($start_at) {
$main_query = $query . " limit {$start_at},{$entries_to_show}";
} else {
$main_query = $query . " limit {$entries_to_show}";
}
} else {
$main_query = $query;
}
//$count = 1e6;
//print "<BR><BR>$query<BR><BR>";
if (!$bUseCSV && !$bDownloadAll) {
// don't count for big query
$count = query_count($query);
// CMC HERE
//print "<BR><BR>" . $query . "<BR><BR>";
if ($count < $start_at + $entries_to_show) {
$entries_to_show = $count - $start_at;
}
$last = $start_at + $entries_to_show;
}
// query count
// For display, convert query string characters < and > into 'html form' so
// that they will be displayed.
//
//$html_text=str_replace('<', '<', str_replace('>', '>', $main_query));
//echo "<p>Query: <b>$html_text</b><p>\n";
echo "\n<script type=\"text/javascript\">\n \nfunction SetAllCheckBoxes(FormName, FieldName, CheckValue)\n{\n\tif(!document.forms[FormName])\n\t\treturn;\n\tvar objCheckBoxes = document.forms[FormName].elements[FieldName];\n\tif(!objCheckBoxes)\n\t\treturn;\n\tvar countCheckBoxes = objCheckBoxes.length;\n\tif(!countCheckBoxes)\n\t\tobjCheckBoxes.checked = CheckValue;\n\telse\n\t\t// set the check value for all check boxes\n\t\tfor(var i = 0; i < countCheckBoxes; i++)\n\t if (! objCheckBoxes[i].disabled)\n objCheckBoxes[i].checked = CheckValue;\n}\n</script>\n<HR>\n";
$start_1_offset = $start_at + 1;
protected function store_user($user_array)
{
if (is_numeric($user_array['github_id'])) {
$exists = query_count("SELECT * FROM user WHERE github_id = '" . $user_array['github_id'] . "'");
if ($exists) {
$q = "UPDATE user SET ";
foreach ($user_array as $k => $v) {
$q .= $k . " = '" . escape($v) . "', ";
}
$q .= " last_update = NOW() WHERE github_id = '" . $user_array['github_id'] . "'";
query($q);
} else {
$q = "INSERT INTO user(";
foreach ($user_array as $k => $v) {
$q .= $k . ', ';
}
$q .= "last_update) VALUES (";
foreach ($user_array as $k => $v) {
$q .= "'" . escape($v) . "', ";
}
$q .= "NOW())";
query($q);
}
} else {
die;
}
$_SESSION['user'] = $user_array;
return 1;
}
$week->new_user_growth_fmt = round($week->new_user_growth * 100) . '%';
$week->churn = $last_week->active_user_count > 0 ? (double) $week->gone_user_count / $last_week->active_user_count : 0;
$week->churn_fmt = round($week->churn * 100) . '%';
}
$last_week = $week;
}
array_shift($weeks);
// remove the first week, it was only used to compute futher stats
return $weeks;
}
function format_grouped_stats($period_length, $period_count, $name, $title)
{
$weeks = grouped_stats($period_length, $period_count);
return inv_table($title, array('start_fmt' => '', 'users_this_week' => "Total this {$name}", 'active_user_count' => 'Active users', 'new_user_count' => 'New active users', 'gone_user_count' => 'Previously active users gone', 'growth_fmt' => '% increase in active users (growth)', 'delta' => '∆ active users', 'new_user_growth_fmt' => '% increase in new users', 'churn_fmt' => '% previously active users gone (churn)'), $weeks);
}
$count = query_count('SELECT COUNT(DISTINCT ip) AS count FROM stats');
$by_date = query_rows('SELECT date, COUNT(DISTINCT ip) AS count FROM stats GROUP BY date ORDER BY date');
$by_ver_30 = query_rows('SELECT version, COUNT(DISTINCT ip) AS count FROM stats WHERE date > DATE_SUB(NOW(), INTERVAL 30 DAY) GROUP BY version ORDER BY version');
$by_ver_7 = query_rows('SELECT version, COUNT(DISTINCT ip) AS count FROM stats WHERE date > DATE_SUB(NOW(), INTERVAL 7 DAY) GROUP BY version ORDER BY version');
$by_ver_2 = query_rows('SELECT version, COUNT(DISTINCT ip) AS count FROM stats WHERE date > DATE_SUB(NOW(), INTERVAL 2 DAY) GROUP BY version ORDER BY version');
$latest = query_rows('SELECT time, version, ip, agent FROM stats ORDER BY time DESC LIMIT 10');
foreach ($latest as &$row) {
$row->time_fmt = strftime('%Y-%m-%d %H:%M', $row->time);
}
$data = array();
foreach ($by_date as $row) {
$data[] = $row->count;
}
$data = array_slice($data, -30 * 3);
array_pop($data);
echo html_tag('h1', array(), "Total unique IPs: {$count}");
public function check_status($addr)
{
$q = "SELECT * FROM incoming WHERE input_address = '" . escape($addr) . "' ORDER BY incoming_id DESC";
if (!query_count($q)) {
return -1;
} else {
$arr = query_assoc($q);
$this->transaction_hash = $arr['transaction_hash'];
query("UPDATE address SET status = ' " . escape($arr['confirmations']) . "' WHERE input_address = '" . escape($addr) . "'");
return $arr['confirmations'];
}
}
