<?php
define('REQUEST_MICROTIME', microtime(1));
require 'env.php';
require 'inc.functions.php';
require '../inc/db/db_sqlite.php'; // https://github.com/rudiedirkx/db_generic
//$db = db_mysql::open(array('user' => 'usagerplus', 'pass' => 'usager', 'database' => 'tests'));
$db = db_sqlite::open(array('database' => 'db/series.sqlite3'));
if ( !$db ) {
exit("<p>Que pasa, amigo!? I can't read from or write to the database! Do you have a writable ./db/ folder? <strong>No bueno!</strong></p>");
}
// Everything. UTF-8. Always. Everywhere.
mb_internal_encoding('UTF-8');
header('Content-type: text/html; charset=utf-8');
// Env constants
define('AJAX', strtolower(@$_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest');
define('MOBILE', is_int(strpos(strtolower($_SERVER['HTTP_USER_AGENT']), 'mobile')));
// Load config structure
require 'inc.config.php';
$cfg = new Config;
// Verify db schema
if ( !$cfg->last_db_schema_sync || $cfg->last_db_schema_sync < strtotime('-1 hour') ) {
$schema = require 'inc.db-schema.php';
<?php
require_once __DIR__ . '/include/inc.cls.db_sqlite.php';
require_once __DIR__ . '/inc.functions.php';
header('Content-type: text/html; charset=utf-8');
header('X-XSS-Protection: 0');
$master = db_sqlite::open(__DIR__ . '/config/config.db');
if (!$master->connected()) {
exit("Can't connect to master.");
}
// Better speed and no need for writable dirs.
$master->query('PRAGMA synchronous=OFF');
$master->query('PRAGMA journal_mode=OFF');
session_start();
function ensureMasterStructure($act = true)
{
global $master;
$schema = (require 'inc.db-schema.php');
$mustExistTables = array_keys($schema['tables']);
$exist = $master->select_fields('sqlite_master', 'tbl_name, tbl_name', array('type' => 'table', 'tbl_name' => $mustExistTables));
if (count($exist) < count($mustExistTables)) {
// No structure
if (!$act) {
exit("Can't setup master structure.");
}
foreach (array_diff_key($schema['tables'], $exist) as $tableName => $columns) {
$master->createTable($tableName, $columns);
}
return ensureMasterStructure(false);
}
return true;
<?php
// Select db meta record
$objDb = $g_objUser->getAliasByAlias($_db);
if (!$objDb) {
return missingParams(array('db'));
}
// Actual db connection
$db = db_sqlite::open($objDb->path);
if (!$db->connected()) {
exit("Can't connect: " . html($db->error));
}
// set encoding
$db->query('PRAGMA encoding="UTF-8"');
// screw ACID, go SPEED!
$db->query('PRAGMA synchronous=OFF');
$db->query('PRAGMA journal_mode=OFF');
$g_objUser->loadAlias($objDb->alias);
<?php
// Init
error_reporting(E_ALL & ~E_STRICT);
header('Content-type: text/plain');
$start = microtime(1);
if ( isset($_GET['mysql']) ) {
require '../db_mysql.php';
$db = db_mysql::open(array('user' => $_GET['user'], 'pass' => $_GET['pass'], 'db' => $_GET['db']));
}
else {
require '../db_sqlite.php';
$db = db_sqlite::open(array('database' => './stuff.sqlite3'));
}
<?php
require 'env.php';
$_start = microtime(1);
define('REQUEST_TIME', time());
header('Content-type: text/html; charset=utf-8');
define('BLOGSFEED_KEEP_BLOGS', 50);
// prerequisites
require WHERE_DB_GENERIC_AT . '/db_sqlite.php';
// db connection
$db = db_sqlite::open(array('database' => dirname(__FILE__) . '/db/blogs.sqlite3'));
if (!$db) {
exit('No database connecto...');
}
// Screw ACID, go SPEED!
$db->execute('PRAGMA synchronous=OFF');
$db->execute('PRAGMA journal_mode=OFF');
require 'inc.args.php';
// db schema
$schema = (require 'inc.db-schema.php');
$db->schema($schema);
// class
spl_autoload_register(function ($class) {
require __DIR__ . '/inc.' . strtolower($class) . '.php';
});
// template stuff
require 'inc.tpl.php';
