* (at your option) any later version.
*
**/
# Details for the grepper to pick up on
#name SQLite Database Module
#author Rob Lemley
#description Use a SQLite database (file-based, requires no additional database server)
#type database
#extension sqlite
# Must be here so 2.1 knows it can create and drop.
# Although preg_grep just looks for the create_bhdb stuff.
$dbmoduleversion = 2;
# Define what configuration you want. Key = what the dbconfig key will be. Value = array, with Data type (string / password) and description.
$dbconfigneeded = array("filename" => array("type" => "string", "name" => "SQLite Database Filename", "description" => "The filename of the SQLite database file.<br>You may leave it as the default unless you want more than one program sharing the same database.<br>If you use a relative filepath, it will be taken relative to the main ByteHoard directory.", "default" => "bytehoard.sqlite"), "prefix" => array("type" => "string", "name" => "Table Prefix", "description" => "The prefix ByteHoard should use on its tables. <br>Leave it as the default unless you're doing multiple installations using the same database.", "default" => "bh2_"));
# Dynamically load extension in case (this will do addition of .dll or .so and only load if needed)
bh_dl("sqlite");
function bhdb_sqlite_correct_filename($filename)
{
if (substr($filename, 0, 1) == "/" || substr($filename, 1, 1) == ":") {
return $filename;
} else {
return str_replace("//", "/", realpath(dirname(__FILE__) . "/../../") . "/" . $filename);
}
}
function insert_bhdb($table, $values)
{
global $dbconfig;
# Login to MySQL database
$dblink = sqlite_open(bhdb_sqlite_correct_filename($dbconfig['filename']));
# Parse given variables into SQL statement.
$sql = "INSERT INTO '" . $dbconfig['prefix'] . $table . "' ";
if (IN_BH != 1) {
header("Location: ../index.php");
die;
}
# Details for the grepper to pick up on
#name MySQL Database Module (Native)
#author Andrew Godwin
#description Old, native version of the MySQL library. Use if you have problems with the new one.
#type database
#extension mysql
# Must be here so 2.1 knows it can create and drop.
# Although preg_grep just looks for the create_bhdb stuff.
$dbmoduleversion = 2;
# Define what configuration you want. Key = what the dbconfig key will be. Value = array, with Data type (string / password) and description.
$dbconfigneeded = array("host" => array("type" => "string", "name" => "MySQL Hostname", "description" => "The hostname of your MySQL server. If it's running on the same machine, this will be 'localhost'.", "default" => "localhost"), "username" => array("type" => "string", "name" => "MySQL Username", "description" => "The username you use to connect to this server."), "password" => array("type" => "password", "name" => "MySQL Password", "description" => "The password you use to connect to this server."), "db" => array("type" => "string", "name" => "MySQL Database", "description" => "The database you want ByteHoard to use."), "prefix" => array("type" => "string", "name" => "Table Prefix", "description" => "The prefix ByteHoard should use on its tables. <br>Leave it as the default unless you're doing multiple installations using the same database.", "default" => "bh2_"));
bh_dl("mysql");
function insert_bhdb($table, $values)
{
global $dbconfig;
# Login to MySQL database
$dblink = mysql_connect($dbconfig['host'], $dbconfig['username'], $dbconfig['password']);
# Select the database
mysql_select_db($dbconfig['db']);
# Parse given variables into SQL statement.
$sql = "INSERT INTO `" . $dbconfig['prefix'] . $table . "` ";
$csql = "( ";
$vsql = " VALUES ( ";
$n = 0;
foreach ($values as $column => $data) {
if ($n == 0) {
$csql .= "`" . $column . "`";
if (IN_BH != 1) {
header("Location: ../index.php");
die;
}
# Details for the grepper to pick up on
#name PostgreSQL Database Module (Alpha)
#author Andrew Godwin
#description Uses a PostgreSQL (local or remote) database to store configuration. <br>(Note: This module is alpha quality. Use at your own risk)
#type database
#extension pgsql
# Must be here so 2.1 knows it can create and drop.
# Although preg_grep just looks for the create_bhdb stuff.
$dbmoduleversion = 2;
# Define what configuration you want. Key = what the dbconfig key will be. Value = array, with Data type (string / password) and description.
$dbconfigneeded = array("host" => array("type" => "string", "name" => "PostgreSQL Hostname", "description" => "The hostname of your PostgreSQL server. If it's running on the same machine, this will be 'localhost'.", "default" => "localhost"), "username" => array("type" => "string", "name" => "PostgreSQL Username", "description" => "The username you use to connect to this server."), "password" => array("type" => "password", "name" => "PostgreSQL Password", "description" => "The password you use to connect to this server."), "db" => array("type" => "string", "name" => "PostgreSQL Database", "description" => "The database you want ByteHoard to use."), "prefix" => array("type" => "string", "name" => "Table Prefix", "description" => "The prefix ByteHoard should use on its tables. <br>Leave it as the default unless you're doing multiple installations using the same database.", "default" => "bh2_"));
bh_dl("pgsql");
# Load ADOdb
require_once realpath(dirname(__FILE__) . "/../adodb/adodb.inc.php");
function insert_bhdb($table, $values)
{
global $dbconfig;
# Create DSN
$dsn = "postgres://" . $dbconfig['username'] . ":" . $dbconfig['password'] . "@" . $dbconfig['host'] . "/" . $dbconfig['db'];
$db = NewADOConnection($dsn);
# Parse given variables into SQL statement.
$sql = "INSERT INTO " . $dbconfig['prefix'] . $table . " ";
$csql = "( ";
$vsql = " VALUES ( ";
$n = 0;
foreach ($values as $column => $data) {
if ($n == 0) {
