// CRONで動かす場合は、ここをサーバールートからのフルパスにする
require_once "twitter_bot.php";
require_once "Util.php";
$con;
$user;
$consumer_key;
$consumer_secret;
$access_token;
$access_token_secret;
$app_name = "dick_bot";
$logFile = dirname(__FILE__) . "/" . $app_name . ".log";
if (!($fp = fopen("{$logFile}", 'a'))) {
return;
}
try {
$dbInfo = getDBInfo();
$dsn = $dbInfo['dsn'];
$user = $dbInfo['user'];
$password = $dbInfo['password'];
$con = new PDO($dsn, $user, $password);
$sql = "SELECT user, consumer_key, consumer_secret, access_token, access_token_secret\n FROM twitter_users\n WHERE No = 0";
$query = $con->prepare($sql);
$query->execute();
foreach ($query->fetchAll() as $row) {
$user = $row['user'];
$consumer_key = $row['consumer_key'];
$consumer_secret = $row['consumer_secret'];
$access_token = $row['access_token'];
$access_token_secret = $row['access_token_secret'];
}
} catch (Exception $e) {
<input type="submit" name="submit" value="Submit" class="btn btn-default"/>
</form>
</div>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if (empty($_POST['username'])) {
return false;
}
if (empty($_POST['password'])) {
return false;
}
$username = trim($_POST['username']);
$password = trim($_POST['password']);
$destination = $_SERVER['DOCUMENT_ROOT'];
require_once "{$destination}/Frameworks-ExtScripting/app/shared/dbConnection/db_connection.php";
$db_conn = getDBInfo('user');
if (!checklogin($username, $password, $db_conn)) {
return false;
}
echo "Succes";
$user_id = $db_conn->excecuteQuery("SELECT `UserID` FROM `users` WHERE Username = '******'");
$row = mysqli_fetch_assoc($user_id);
session_start();
$_SESSION['userId'] = $row['UserID'];
header('Location: ../../../index.html');
}
function checklogin($username, $password, $db_conn)
{
$userResult = $db_conn->login($username, $password);
if ($userResult->num_rows > 0) {
return true;
function uninstallPatchText($text)
{
$dba = getDBInfo();
$data = parsePackage($text);
if (!is_array($dba[$data["fn"]])) {
$dba[$data["fn"]] = array('firstinstall' => -1, 'lastinstall' => -1, 'lastuninstall' => -1, 'firstuninstall' => microtime(true), 'uninstalltimes' => -1, 'installtimes' => -1);
}
$dba[$data["fn"]]['uninstalltimes']++;
$dba[$data["fn"]]['fn'] = $data["fn"];
$dba[$data["fn"]]['name'] = $data["name"];
$dba[$data["fn"]]['version'] = $data["version"];
$dba[$data["fn"]]['summary'] = $data["summary"];
$dba[$data["fn"]]['lastuninstall'] = microtime(true);
$dba[$data["fn"]]['installed'] = false;
setDBInfo($dba);
return applyPatch($text, $data["fn"], true);
}
<?php
require_once 'library/global.php';
require_once 'library/BFL/BFL_Loader.php';
//初始化自動加載器
BFL_Loader::setBFLPath('./library/BFL/');
BFL_Loader::setControllerPath('./library/application/controller/');
BFL_Loader::setModelPath('./library/application/model/');
//初始化計時器
BFL_Timer::initialize();
//設置運行時全局變量
BFL_Register::setVar('password_encode_word', PWD_ENCWORD);
BFL_Register::setVar('db_info', getDBInfo());
//初始化數據庫事務處理
$db = BFL_Database::getInstance();
$db->beginTransaction();
//初始化參數表
$config = MDL_Config::getInstance();
//設置全局異常捕捉函數
set_exception_handler(array('MDL_GlobalControl', 'exceptionHandler'));
//設置退出回調函數
register_shutdown_function(array('MDL_GlobalControl', 'shutdownHandler'));
//檢查地址綁定
$bind_address = $config->getVar('site_address');
if ($bind_address != '' && $bind_address != BFL_General::getServerAddress()) {
BFL_Controller::redirect($bind_address);
}
//初始化用戶會話
MDL_ACL::getInstance()->initialize(SESSION_PREFIX, 'guest');
MDL_User_Auth::getLoginedUserInformation();
//加載插件
<?php
$destination = $_SERVER['DOCUMENT_ROOT'];
require_once "{$destination}/Frameworks-ExtScripting/app/shared/dbConnection/db_connection.php";
session_start();
$postdata = file_get_contents("php://input");
$request = json_decode($postdata);
@($email = "{$request->email}");
$i = 0;
$arr = [];
$userInfo = getDBInfo("project");
if ($userInfo->insert($email, $_SESSION['userId'])) {
header('Location: test.html');
}
$projectresult = $userInfo->getProjectUserId($_SESSION['userId']);
while ($row = $projectresult->fetch_object()) {
$arr[$i] = $row;
$i++;
}
$json = json_encode($arr);
echo $json;
<?php
session_start();
$destination = $_SERVER['DOCUMENT_ROOT'];
require_once "{$destination}/Frameworks-ExtScripting/app/shared/dbConnection/db_connection.php";
$i = 0;
$arr = [];
$db_conn = getDBInfo('project');
$projectresult = $db_conn->getProjectUserId($_SESSION['userId']);
while ($row = $projectresult->fetch_object()) {
$arr[$i] = $row;
$i++;
}
header('Content-Type: application/json');
$json = json_encode($arr);
echo $json;
