<?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());