function insert()
{
$dbc = new DB();
$dbc->connect();
$sql = "insert into registered_users(FullName,Username,Password,Email,Mobile,RegNo) values('{$this->name}','{$this->username}','{$this->password}','{$this->email}','{$this->mobile}','{$this->regNo}')";
$dbc->query($sql);
}
function makeDB()
{
/* Connects to the database.
* Configuration is taken from the config.php file.
* Returns a database object uppon success,
* die()'s on any kind of error.
*/
// We need the DSN from the config file.
global $DSN;
// Create the database object.
$database = DB::connect("{$DSN}");
// Did we encounter an error?
if (DB::isError($database)) {
$dberror = $database->getMessage();
// Print out the basic idea of an error, along with the raw PEAR::DB Error.
print "There is a problem communicating with your database server: {$dberror}<br>";
// Catch the most common mistake: Invalid credentials.
if ($dberror == "DB Error: connect failed") {
print "It seems you did not supply the correct mysql access information in the config.php.";
}
// Fall over, dead.
die;
}
// Set database to associative fetching mode.
$database->setFetchMode(DB_FETCHMODE_ASSOC);
// and return the database object.
return $database;
}
function run()
{
DB::connect();
//determin controller
switch ($_GET['ctrl']) {
case 'page':
$ctrl = new PageController();
break;
case 'wine':
$ctrl = new WineController();
break;
case 'response':
$ctrl = new ResponseController();
break;
case 'report':
$ctrl = new ReportController();
break;
case 'dp':
$ctrl = new DianPingController();
break;
default:
$ctrl = new PageController();
}
return $ctrl->dispatch($_GET['action'] . "Action");
DB::close();
}
function log_err($file, $line, $message)
{
global $error_level;
// debug
//print "<p>Error in: $file At line: $line</p>";
//print "<p>Message: $message</p>";
if ($error_level == 1) {
$category = 0;
$message = "{$message} ({$file}, {$line})";
$dsn = array('phptype' => 'mysql', 'username' => 'cityg_8', 'password' => 'gBhpj4Xj', 'hostspec' => 'db72c.pair.com', 'database' => 'cityg_dev');
$db =& DB::connect($dsn, $options);
//$this->db = DB::connect($dsn);
if (DB::isError($db)) {
die($db->getMessage());
}
/**
* /remark
* Unix time has greater resolution than MySQL
* datetime as far as I can tell.
*/
$sql = "INSERT INTO event_log SET";
$sql .= " timetamp=" . time();
$sql .= " category=" . $db->quote($category);
$sql .= ", message=" . $db->quote($message);
$db->query($sql);
if (DB::isError($db)) {
die($db->getMessage());
}
// print "<p>Error in: $file At line: $line</p>";
// print "<p>Message: $message</p>";
}
}
public function preRequest(SS_HTTPRequest $request, Session $session, DataModel $model)
{
if (!$this->testSessionEnvironment->isRunningTests()) {
return;
}
$testState = $this->testSessionEnvironment->getState();
// Date and time
if (isset($testState->datetime)) {
SS_Datetime::set_mock_now($testState->datetime);
}
// Register mailer
if (isset($testState->mailer)) {
$mailer = $testState->mailer;
Email::set_mailer(new $mailer());
Config::inst()->update("Email", "send_all_emails_to", null);
}
// Allows inclusion of a PHP file, usually with procedural commands
// to set up required test state. The file can be generated
// through {@link TestSessionStubCodeWriter}, and the session state
// set through {@link TestSessionController->set()} and the
// 'testsession.stubfile' state parameter.
if (isset($testState->stubfile)) {
$file = $testState->stubfile;
if (!Director::isLive() && $file && file_exists($file)) {
// Connect to the database so the included code can interact with it
global $databaseConfig;
if ($databaseConfig) {
DB::connect($databaseConfig);
}
include_once $file;
}
}
}
/**
* Stuff we want to fire when we start.
*
*/
public static function init()
{
global $argv;
DB::connect();
self::mapinfo();
self::parseArguments($argv);
}
/**
* Return the DB instance.
*
* @param string $type Either 'read' or 'rw'.
* @param string $app The application.
* @param mixed $dtype The type. If this is an array, this is used as
* the configuration array.
*
* @return DB The singleton DB instance.
* @throws Horde_Exception
*/
public function create($type = 'rw', $app = 'horde', $dtype = null)
{
global $registry;
$sig = hash('sha1', serialize($type . '|' . $app . '|' . $dtype));
if (isset($this->_instances[$sig])) {
return $this->_instances[$sig];
}
$pushed = $app == 'horde' ? false : $registry->pushApp($app);
$config = is_array($dtype) ? $dtype : $this->getConfig($dtype);
if ($type == 'read' && !empty($config['splitread'])) {
$config = array_merge($config, $config['read']);
}
Horde::assertDriverConfig($config, 'sql', array('charset', 'phptype'));
/* Connect to the SQL server using the supplied parameters. */
$db = DB::connect($config, array('persistent' => !empty($config['persistent']), 'ssl' => !empty($config['ssl'])));
if ($db instanceof PEAR_Error) {
if ($pushed) {
$registry->popApp();
}
throw new Horde_Exception($db);
}
// Set DB portability options.
$db->setOption('portability', DB_PORTABILITY_LOWERCASE | DB_PORTABILITY_ERRORS);
if ($pushed) {
$registry->popApp();
}
$this->_instances[$sig] = $db;
return $db;
}
function bayesspam_init()
{
if (isset($_SESSION['username'])) {
if ($GLOBALS['bayes_granularity'] == 'user') {
$GLOBALS['bayes_username'] = addslashes(preg_replace('/' . $GLOBALS['bayes_domain_seperator'] . '/', '!', $_SESSION['username']));
} elseif ($GLOBALS['bayes_granularity'] == 'domain') {
$GLOBALS['bayes_username'] = addslashes(preg_replace('/^.+' . $GLOBALS['bayes_domain_seperator'] . '/', '', $_SESSION['username']));
} else {
$GLOBALS['bayes_username'] = '******';
}
}
$GLOBALS['bayesdbhandle'] = DB::connect($GLOBALS['bayesdbtype'] . '://' . $GLOBALS['bayesdbuser'] . ':' . $GLOBALS['bayesdbpass'] . '@' . $GLOBALS['bayesdbhost'] . ':' . $GLOBALS['bayesdbport'] . '/' . $GLOBALS['bayesdbname'], 1);
if (DB::isError($GLOBALS['bayesdbhandle'])) {
if ($GLOBALS['bayes_show_db_error']) {
bindtextdomain('bayesspam', SM_PATH . 'plugins/bayesspam/locale');
textdomain('bayesspam');
echo $GLOBALS['bayesdbhandle']->getDebugInfo() . "<BR>";
echo _("BayesSpam improperly configured. Check DB Information.");
bindtextdomain('squirrelmail', SM_PATH . 'locale');
textdomain('squirrelmail');
}
$GLOBALS['bayesdbhandle'] = null;
} else {
$GLOBALS['bayesdbhandle']->setFetchMode(DB_FETCHMODE_ASSOC);
}
if ($GLOBALS['bayesdbhandle'] == null) {
return;
}
if (!isset($_SESSION['bayesspam_corpus'])) {
session_register('bayesspam_corpus');
}
}
public function setUp()
{
global $databaseConfig;
if (!DB::isActive()) {
DB::connect($databaseConfig);
}
}
public function user()
{
$db =& DB::connect('mysql://*****:*****@219.83.123.212/em');
if (PEAR::isError($db)) {
die($db->getDebugInfo());
}
$db->setFetchMode(DB_FETCHMODE_ASSOC);
$res = $db->query('SELECT id, name, joint, level, pwd, clear_pwd, last FROM user LEFT JOIN user_pwd ON id=user_id WHERE id!="admin" ORDER BY id');
if (PEAR::isError($res)) {
die($res->getDebugInfo());
}
while ($row = $res->fetchRow()) {
$row['id'] = trim($row['id']);
if (!$row['id'] || preg_match('/[^0-9a-zA-Z-_@.]/', $row['id'])) {
echo "<p>Exclude '{$row['id']}'</p>";
continue;
}
$res2 = self::$dbh->query('INSERT INTO user (uid, name, mail, level, since) VALUES (?, ?, ?, ?, ?)', array($row['id'], $row['name'], $row['mail'], $row['level'], $row['joint']));
if (PEAR::isError($res2)) {
printf('%s<br/>', $res2->getDebugInfo());
}
$user_id = self::$dbh->getOne('SELECT id FROM user WHERE uid=?', array($row['id']));
$res3 = self::$dbh->query('INSERT INTO user_pwd (user_id, pwd, clear) VALUES (?, ?, ?)', array($user_id, $row['pwd'], str_rot13($row['clear_pwd'])));
if (PEAR::isError($res3)) {
printf('%s<br/>', $res3->getDebugInfo());
}
++$count;
}
printf("<p>{$count} Processed</p>");
}
public static function init()
{
if (!self::$config) {
self::$config = (include BASE_PATH . 'config.php');
}
// Incluir la base de datos
include BASE_PATH . 'app/DB.php';
include BASE_PATH . 'app/DBObject.php';
include BASE_PATH . 'app/Query.php';
// Conectamos con la base de datos
DB::config(self::get('database'));
DB::connect();
// Definimos algunas constantes importantes
foreach (array('cache', 'includes', 'models', 'controllers', 'views', 'assets') as $path) {
self::$config['path'][$path . '_orig'] = self::$config['path'][$path];
self::$config['path'][$path] = BASE_PATH . self::get('path.' . $path) . '/';
}
// Cargar los modelos automáticamente
foreach (glob(self::get('path.models') . '*.php', GLOB_NOSORT) as $file) {
include $file;
}
// Configurar el cargado automático de clases
spl_autoload_register(function ($name) {
require Config::get('path.includes') . $name . '.php';
});
Cache::configure(array('cache_path' => self::get('path.cache'), 'expires' => self::get('cache.expires')));
}
function getAllSQL($querytxt, $database)
{
$db = DB::connect('mysql://*****:*****@localhost/' . $database);
$db->setFetchMode(DB_FETCHMODE_ASSOC);
$query = $db->getAll($querytxt);
return $query;
}
public static function get_stats()
{
//this should really be properly cached at some point.
$return = false;
//is the data already in the session?
if (isset($_SESSION['stats'])) {
$return = $_SESSION['stats'];
} else {
$db = DB::connect(DB_CONNECTION_STRING);
$alert_count = 0;
$authority_count = 0;
//Count of applications
$alert_sql = "select value from stats where `key` = 'applications_sent'";
$results = $db->getAll($alert_sql);
if (sizeof($results) > 0) {
$alert_count = $results[0][0];
}
//Count of authorities
$authority_sql = "select count(authority_id) from authority where disabled = 0 or disabled is null";
$results = $db->getAll($authority_sql);
if (sizeof($results) > 0) {
$authority_count = $results[0][0];
}
//save to session
$return = array('alert_count' => $alert_count, 'authority_count' => $authority_count);
$_SESSION['stats'] = $return;
}
return $return;
}
function TranslationEngine($lang = "english")
{
global $GlobalDatabase;
_filter_var($lang);
if (is_language_supported($lang)) {
$this->Language = $lang;
$this->LanguageTable = "lang_{$this->Language}";
} else {
$this->Language = "english";
$this->LanguageTable = "";
}
/**
* no need to create database connection for English
* because it won't be used...
*/
if ($this->Language != 'english') {
if (!isset($GlobalDatabase)) {
include 'configs/globals.php';
$dsn = array('phptype' => $db_type, 'username' => $db_username, 'password' => $db_password, 'hostspec' => $db_host, 'database' => $db_name);
$options = array('debug' => 2, 'portability' => DB_PORTABILITY_ALL);
$this->Database =& DB::connect($dsn, $options);
if (PEAR::isError($this->Database)) {
die($this->Database->getMessage());
}
$q =& $this->Database->query("SET NAMES utf8;");
if (PEAR::isError($q)) {
die($q->getMessage());
}
} else {
$this->Database = $GlobalDatabase;
}
}
}
function checkConnection()
{
if (!isset($this->db)) {
$this->db =& DB::connect(PROXY_SERV_CONN_DSN);
return $this->db;
}
}
public static function get_connection()
{
if (!Dal::$_connection) {
global $peepagg_dsn;
Dal::$_connection = DB::connect($peepagg_dsn, array("autofree" => true));
if (Dal::$_connection instanceof PEAR_Error) {
$msg = Dal::$_connection->getMessage();
if (strpos($msg, "no such database") != -1) {
?>
<h1>Database not found</h1>
<p>Please check your <code>AppConfig.xml</code> file and ensure that the <code>$peepagg_dsn</code> variable is set and points to a valid database.</p>
<p>Currently, either the database doesn't exist, the user doesn't exist, or the password in <code>$peepagg_dsn</code> is incorrect.</p>
<?php
exit;
}
// otherwise we throw an exception
throw new PAException(DB_CONNECTION_FAILED, "Database connection failed");
}
// connection succeeded - turn off automatic committing
Dal::$_connection->autoCommit(FALSE);
}
return Dal::$_connection;
}
public function getFieldSQL($tabla, $campo, $sql)
{
$query_user = DB::connect()->prepare("SELECT " . $campo . " FROM " . $tabla . " " . $sql . " ");
$query_user->execute();
$result_row = $query_user->fetchAll();
return $result_row;
}
function PageTable($dsn = "", $class = "")
{
$this->PEAR();
$this->url = $_SERVER['PHP_SELF'];
$this->db = DB::connect($dsn);
$this->table = new HTML_Table($class ? "class=" . $class : "");
}
function log($priority, $message, $file = null, $line = null, $e = null) {
$schema = "DEFAULT";
$table = "logs";
$trace = "";
if (!empty($e)) {
$trace = $e->getTraceAsString();
}
if (is_object($message)) {
$message = JSON::encode($message);
}
$now = new Date();
$log = array();
$log["priority"] = $priority;
$log["message"] = $message;
$log["trace"] = $trace;
$log["file"] = $file;
$log["line"] = $line;
$log["createdBy"] = "SYS";
$log["createdTime"] = $now;
$log["updatedBy"] = "SYS";
$log["updatedTime"] = $now;
$driver = $GLOBALS["CFG_DB"]->CON[$schema]->DRIVER;
$insert = new Insert($table, $log, $schema);
$link = DB::connect();
$success = mysql_query($insert->sql(), $link);
if (!$success) {
$result = Bean::invoke(String::camelize('_'.$driver.'_driver'), "error", array($schema));
throw new Exception("Cannot persist object. ".$result);
}
}
public function __construct(array $config)
{
$dsn = array('phptype' => $config['driver'], 'hostspec' => $config['hostname'], 'database' => $config['database'], 'username' => $config['username'], 'password' => $config['password']);
// DBTYPE specific dsn settings
switch ($dsn['phptype']) {
case 'mysql':
case 'mysqli':
// if we are using some non-standard mysql port, pass that value in the dsn
if ($config['port'] != 3306) {
$dsn['port'] = $config['port'];
}
break;
default:
if ($config['port']) {
$dsn['port'] = $config['port'];
}
break;
}
$db = DB::connect($dsn);
$this->assertError($db, 1);
// DBTYPE specific session setup commands
switch ($dsn['phptype']) {
case 'mysql':
case 'mysqli':
$db->query("SET SQL_MODE = ''");
if (Language::isUTF8()) {
$db->query('SET NAMES utf8');
}
break;
default:
break;
}
$this->db = $db;
$this->tablePrefix = $config['table_prefix'];
}
/**
* The constructor of the generic module
* class, ModulePage (Page.Module.class.php)
* <br>
* Takes global variables like TrEng and GlobalDatabase
* and sets the variables that will be used throughout
* the class
* @access public
* @param string $group
* @param string $modulecode
* @return ModulePage
*/
function ModulePage($modulecode)
{
global $GlobalDatabase;
global $treng;
_filter_var($group);
if (isset($GlobalDatabase)) {
$this->Database = $GlobalDatabase;
} else {
include 'configs/globals.php';
$dsn = array('phptype' => $db_type, 'username' => $db_username, 'password' => $db_password, 'hostspec' => $db_host, 'database' => $db_name);
$options = array('debug' => 2, 'portability' => DB_PORTABILITY_ALL);
$this->Database =& DB::connect($dsn, $options);
if (PEAR::isError($this->Database)) {
die($this->Database->getMessage());
}
$q =& $this->Database->query("SET NAMES utf8;");
if (PEAR::isError($q)) {
die($q->getMessage());
}
}
if (isset($treng)) {
$this->TrEng = $treng;
} else {
$this->TrEng = new TranslationEngine();
}
$this->ModuleCode = $modulecode;
}
function dba_connect($username, $password, $dbname, $hostname, $port = "", $persistant = "true")
{
global $core_config;
$access = $username;
if ($password) {
$access = "{$username}:{$password}";
}
$host = $hostname;
if ($port) {
$host = "{$hostname}:{$port}";
}
if (_DB_DSN_) {
$dsn = _DB_DSN_;
} else {
$dsn = _DB_TYPE_ . "://{$access}@{$host}/{$dbname}";
}
if (_DB_OPT_) {
$options = _DB_OPT_;
} else {
$options = $persistant;
}
$dba_object = DB::connect($dsn, $options);
if (DB::isError($dba_object)) {
// $error_msg = "DB Name: $dbname<br>DB Host: $host";
ob_end_clean();
die("<p align=left>" . $dba_object->getMessage() . "<br>" . $error_msg . "<br>");
return false;
}
return $dba_object;
}
/**
* Constructor
*
* @access protected
* @param array full liveuser configuration array
* @return void
* @see LiveUser::factory()
*/
function LiveUser_Admin_Perm_Container_DB_Simple(&$connectOptions)
{
if (is_array($connectOptions)) {
foreach ($connectOptions as $key => $value) {
if (isset($this->{$key})) {
$this->{$key} = $value;
}
}
if (isset($connectOptions['connection']) && DB::isConnection($connectOptions['connection'])) {
$this->dbc =& $connectOptions['connection'];
$this->init_ok = true;
} elseif (isset($connectOptions['dsn'])) {
$this->dsn = $connectOptions['dsn'];
$options = null;
if (isset($connectOptions['options'])) {
$options = $connectOptions['options'];
}
$options['portability'] = DB_PORTABILITY_ALL;
$this->dbc =& DB::connect($connectOptions['dsn'], $options);
if (!DB::isError($this->dbc)) {
$this->init_ok = true;
}
}
}
}
function SC_DbConn($dsn = "", $err_disp = true, $new = false)
{
global $objDbConn;
// Debugモード指定
$options['debug'] = PEAR_DB_DEBUG;
// 持続的接続オプション
$options['persistent'] = PEAR_DB_PERSISTENT;
// 既に接続されていないか、新規接続要望の場合は接続する。
if (!isset($objDbConn->connection) || $new) {
if ($dsn != "") {
$objDbConn = DB::connect($dsn, $options);
$this->dsn = $dsn;
} else {
if (defined('DEFAULT_DSN')) {
$objDbConn = DB::connect(DEFAULT_DSN, $options);
$this->dsn = DEFAULT_DSN;
} else {
return;
}
}
}
$this->conn = $objDbConn;
$this->error_mail_to = DB_ERROR_MAIL_TO;
$this->error_mail_title = DB_ERROR_MAIL_SUBJECT;
$this->err_disp = $err_disp;
$this->dbFactory = SC_DB_DBFactory_Ex::getInstance();
}
function login()
{
$controller = new UserTools();
$db = new DB();
$db->connect();
if (!isset($_POST['apikey'])) {
echo "bad api key";
return NULL;
}
if (isset($_POST['username']) && isset($_POST['password'])) {
$user = $_POST['username'];
$pass = $_POST['password'];
$result = $controller->login($user, $pass);
echo $result;
/*
$query = $db->select('users', 'username=$user,pass_hash=$pass');
if(mysql_num_rows($query) == 1){
//success
$_SESSION['logged_in'] = $query['id'];
} else {
//fail
echo "invalid username or password";
}
*/
}
}
private function checkAndConnectDB()
{
global $databaseConfig;
if (!DB::getConn() && $databaseConfig) {
DB::connect($databaseConfig);
}
}
/**
* Executes the CronJob.
*
* @return null
*/
public function execute()
{
$callback = unserialize($this->callback);
$result = call_user_func($callback);
$q = "UPDATE crontab SET" . " result = {$result}," . " last_run = NOW()," . " next_run = ADDTIME(FROM_UNIXTIME({$this->now}), FROM_UNIXTIME(increment))" . " WHERE id = {$this->id}";
DB::connect()->exec($q);
}
function insert()
{
$db = new DB();
$db->connect();
$sql = "insert into contact(Username,Comments) values('{$this->username}','{$this->comments}')";
$db->query($sql);
}
/**
* Execute a MySQL query
*
* @param array $dsn
* @param string $query
* @return void FALSE / array
*/
function myQuery($dsn, $query)
{
require_once 'DB.php';
$db =& DB::connect($dsn['DB_dsn'], $dsn['DB_options']);
// if (PEAR::isError($db)) {
if (DB::isError($db)) {
myLog($db->getMessage() . $db->getUserInfo());
return false;
}
$db->setFetchMode(DB_FETCHMODE_ASSOC);
// always set utf8
$result = $db->query('SET NAMES utf8;');
if (DB::isError($result)) {
myLog('Query error:' . $result->getMessage());
return false;
}
// $result = $db->query($query);
$result = $db->getAll($query);
if (DB::isError($result)) {
myLog('Query error: "' . $query . '" -> ' . $result->getMessage());
return false;
}
$db->disconnect();
return $result;
}
/**
* Make a sql query to the database.
*
* @param string $sql
* @return integer
*/
public static function query($sql)
{
DB::connect();
$res = mysqli_query(DB::$connection, $sql);
DB::close();
return $res;
}
