<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
set_time_limit(0);
require_once __DIR__ . '/../vendor/autoload.php';
if (session_status() !== PHP_SESSION_ACTIVE) {
session_start();
}
Grosona\Config::setBase(__DIR__ . '/../app/config');
$grosona = new Grosona\GrosonaDriver();
$config = Grosona\Config::getConfig();
$dba = new Grosona\Comm\DatabaseAccessor($config['dbServerName'], $config['dbUserName'], $config['dbPassword'], $config['dbName'], $config['groupId'], 0, new Grosona\Utility\Logger($config['logFile'], ''));
$funct = filter_input(INPUT_GET, 'f');
if ('get' === $funct) {
$fids = $dba->queryAssoc("SELECT `feed_id` FROM `grosona__images` WHERE `image_path`='aa' ORDER BY RAND() LIMIT 1");
while ($fids) {
$fid = $fids[0]['feed_id'];
$syntax = "/{$fid}?fields=id, from, message, type, created_time, updated_time, attachments";
$query = new Grosona\FacebookQuery();
$query->setProperty(SYNTAX, $syntax);
$query->setProperty(ITERATE_COUNT, 0);
$query->setProperty(TYPE, TYPE_FEED);
$query->setProperty(FEED_ID, $fid);
$query->setProperty(CONTINUED_INDEX, 0);
$grosona->getFacebookQuerier()->setQuery($query);
$result = $grosona->getFacebookQuerier()->execute();
if ($result) {
$feed = $result->toAssoc();
foreach ($feed['imageSet'] as $imgInfo) {
$grosona->getFeedQuerier()->updateImage($imgInfo);
<?php
if (!isset($_SERVER['HTTP_HOST'])) {
exit('This script cannot be run from the CLI. Run it from a browser.');
}
require_once __DIR__ . '/../vendor/autoload.php';
if (session_status() !== PHP_SESSION_ACTIVE) {
session_start();
}
Grosona\Config::setBase(__DIR__ . '/../app/config');
$grosona = new Grosona\GrosonaDriver();
if (!$grosona->getStatus()['isAdmin']) {
header('HTTP/1.0 403 Forbidden');
exit('This script is only accessible from localhost.');
}
?>
<!DOCTYPE html>
<!--
Description:
This page is a simple command-based manager tool for admin.
-->
<html>
<head>
<title>Grosona</title>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<?php
$token = $grosona->getSystemQuerier()->getToken();
$loginUri = $grosona->getFacebookQuerier()->getLoginUrl();
echo '<script>var checkTokenUri = "https://developers.facebook.com/tools/debug/accesstoken?q=' . $token . '";</script>';
echo '<script>var loginUri = "' . $loginUri . '";</script>';
echo '<script>var __grosona_appId = "' . $grosona->getConfig()['fbAppId'] . '";</script>';
<?php
require_once __DIR__ . '/../vendor/autoload.php';
Grosona\Config::setBase(__DIR__ . '/../app/config');
if (session_status() !== PHP_SESSION_ACTIVE) {
session_start();
}
$grosona = new Grosona\GrosonaDriver();
if ($grosona->getStatus()['userId']) {
if ($grosona->getStatus()['isUser']) {
$_SESSION['aaa'] = 'yesiam';
header("Location: app.php/");
} else {
header("Location: https://www.facebook.com/groups/451890044925648/");
}
} else {
header("Location: app.php/login");
}
`item_status` varchar(1024) DEFAULT NULL,
`item_description` varchar(1024) DEFAULT NULL,
`item_note` varchar(1024) DEFAULT NULL,
`item_global` varchar(1024) DEFAULT NULL,
`feed_id` varchar(64) NOT NULL,
PRIMARY KEY (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
$mysqli->query('ALTER TABLE xdb__items ADD FOREIGN KEY (feed_id) REFERENCES grosona__feeds (feed_id);');
$mysqli->query('CREATE TABLE IF NOT EXISTS `xdb__subscriptions` (
`subscription_id` int(11) NOT NULL AUTO_INCREMENT,
`token` varchar(1024) NOT NULL,
PRIMARY KEY (`subscription_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
$mysqli->query('CREATE TABLE IF NOT EXISTS `xdb__user_subscription_relation` (
`subscription_id` int(11) NOT NULL,
`user_id` varchar(64) NOT NULL,
PRIMARY KEY (`subscription_id`, `user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
$mysqli->query('ALTER TABLE xdb__user_subscription_relation ADD FOREIGN KEY (subscription_id) REFERENCES xdb__subscriptions (subscription_id);');
$mysqli->query('ALTER TABLE xdb__user_subscription_relation ADD FOREIGN KEY (user_id) REFERENCES grosona__users (user_id);');
$mysqli->query('CREATE TABLE IF NOT EXISTS `xdb__notifiers` (
`notifier_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` varchar(64) NOT NULL,
`uri` varchar(256) NOT NULL,
PRIMARY KEY (`notifier_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
$mysqli->query('ALTER TABLE xdb__notifiers ADD FOREIGN KEY (user_id) REFERENCES grosona__users (user_id);');
session_start();
$grosona = new Grosona\GrosonaDriver();
$grosona->getSystemQuerier()->setSystemHealthy(true);
header("Location: " . $grosona->getFacebookQuerier()->getLoginUrl());
