/**
* Get the database for this challenge.
* @return GDO_Database
*/
function auth2_db()
{
if (false === ($db = gdo_db_instance('localhost', WCC_AUTH_BYPASS2_USER, WCC_AUTH_BYPASS2_PASS, WCC_AUTH_BYPASS2_DB))) {
die('Database error 0815_2!');
}
$db->setLogging(false);
$db->setEMailOnError(false);
return $db;
}
function gdo_db()
{
global $SINGLE_GDO_DB;
if ($SINGLE_GDO_DB === null) {
if (false !== ($SINGLE_GDO_DB = gdo_db_instance(GWF_DB_HOST, GWF_DB_USER, GWF_DB_PASSWORD, GWF_DB_DATABASE, GWF_DB_TYPE))) {
GDO::setCurrentDB($SINGLE_GDO_DB);
}
}
return $SINGLE_GDO_DB;
}
/**
* Get the database object.
* @return GDO_Database
*/
function blightDB()
{
static $db;
if (!isset($db)) {
if (false === ($db = gdo_db_instance('localhost', BLIGHT_USER, BLIGHT_PASS, BLIGHT_DB))) {
die('Cannot connect to db!');
}
$db->setVerbose(false);
$db->setLogging(false);
$db->setDieOnError(false);
$db->setEMailOnError(false);
}
return $db;
}
<?php # WeChall DB global $db1, $db2; $db1 = GDO::getCurrentDB(); # Challenge DB $db2 = gdo_db_instance(DLDC_DB_HOST, DLDC_DB_USER, DLDC_DB_PASS, DLDC_DB_NAME); # Set to challenge db GDO::setCurrentDB($db2);
function warchall1createAccountB(WC_Challenge $chall)
{
if (false === ($db = gdo_db_instance(WARBOX_DB_HOST, WARBOX_DB_USER, WARBOX_DB_PASS, WARBOX_DB_DB))) {
return GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__));
}
$user = GWF_Session::getUser();
$username = $db->escape(strtolower($user->getVar('user_name')));
$pass = $db->escape(crypt($_POST['password1']));
if (false === $db->queryWrite("REPLACE INTO war_audit_add_user VALUES('{$username}', '{$pass}')")) {
return GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__));
}
return GWF_HTML::message('Let the Warchall begin', $chall->lang('msg_creating_account', $username, $_POST['password1']));
}
public static function wizard_test_db_2()
{
$pv = Common::getPostArray(GWF_InstallConfig::POSTVARS, array());
$host = isset($pv['GWF_DB_HOST']) ? $pv['GWF_DB_HOST'] : '';
$user = isset($pv['GWF_DB_USER']) ? $pv['GWF_DB_USER'] : '';
$pass = isset($pv['GWF_DB_PASSWORD']) ? $pv['GWF_DB_PASSWORD'] : '';
$db = isset($pv['GWF_DB_DATABASE']) ? $pv['GWF_DB_DATABASE'] : '';
$type = isset($pv['GWF_DB_TYPE']) ? $pv['GWF_DB_TYPE'] : 'mysql';
if (false !== ($db = gdo_db_instance($host, $user, $pass, $db, $type, 'utf8', false))) {
define('GWF_WIZARD_HAS_DB', true);
}
return self::wizard_bool($db !== false);
}
<?php
$data = (require 'data.php');
$solution = (require 'solution.php');
require 'expdb.php';
chdir('../../../../');
define('GWF_PAGE_TITLE', 'Experience');
require_once 'challenge/html_head.php';
require_once GWF_CORE_PATH . 'module/WeChall/solutionbox.php';
if (false === ($chall = WC_Challenge::getByTitle(GWF_PAGE_TITLE))) {
$chall = WC_Challenge::dummyChallenge(GWF_PAGE_TITLE, 3, 'challenge/training/php/experience/index.php', $solution);
}
$chall->showHeader();
$chall->onCheckSolution();
$user = GWF_User::getStaticOrGuest();
$username = $user->isGuest() ? $chall->lang('guest') : $user->displayUsername();
$hint = '<span style="color:#fff;">' . $chall->lang('hint') . '</span>' . PHP_EOL;
echo GWF_Box::box($chall->lang('descr', array($username, $hint)));
if (!($db = gdo_db_instance(EXP_DB_HOST, EXP_DB_USER, EXP_DB_PASS, EXP_DB_NAME))) {
echo GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__));
} else {
require 'blackbox.php';
formSolutionbox($chall);
}
echo $chall->copyrightFooter();
require_once 'challenge/html_foot.php';
chdir('../../../');
define('GWF_PAGE_TITLE', 'Table Names II');
require_once 'challenge/html_head.php';
require GWF_CORE_PATH . 'module/WeChall/solutionbox.php';
if (false === ($chall = WC_Challenge::getByTitle(GWF_PAGE_TITLE))) {
$chall = WC_Challenge::dummyChallenge(GWF_PAGE_TITLE, 6, 'challenge/nurfed/more_table_names/index.php', $secret['flag']);
}
$chall->showHeader();
$chall->onCheckSolution();
if (false !== Common::getGet('login')) {
$username = Common::getGetString('username', '');
$password = Common::getGetString('password', '');
if (preg_match('/statistics|tables|columns|table_constraints|key_column_usage|partitions|schema_privileges|schemata|database|schema\\(\\)/i', $username . $password)) {
echo GWF_HTML::error(GWF_PAGE_TITLE, $chall->lang('on_match'));
} else {
if (false === ($db = gdo_db_instance($secret['host'], $secret['username'], $secret['password'], $secret['database']))) {
die('Database error.');
}
$db->setVerbose(false);
$db->setLogging(false);
$db->setEMailOnError(false);
$query = "SELECT * FROM {$secret['database']}.{$secret['table_name']} WHERE username='******' AND password='******'";
if (false === ($result = $db->queryFirst($query, false))) {
echo GWF_HTML::error(GWF_PAGE_TITLE, $chall->lang('on_login_fail'));
} else {
echo GWF_HTML::message(GWF_PAGE_TITLE, $chall->lang('on_logged_in', array(GWF_HTML::display($result['username']), GWF_HTML::display($result['message']))));
}
}
}
?>
<div class="box box_c">
#!/usr/bin/php
<?php
if (PHP_SAPI !== 'cli') {
die('CLI Please');
}
# GWF_PATH
chdir('../../../www');
require_once '../core/inc/GDO/GDO.php';
define('GWF_CORE_PATH', '../core/');
define('GWF_USER_STACKTRACE', true);
define('GWF_DB_TYPE', 'mysqli');
$oldfix = 'hes2013_';
$newfix = 'wc4_';
$db = gdo_db_instance('localhost', 'nsc2013', 'nsc2013', 'nsc2013');
GDO::setCurrentDB($db);
if (false === ($result = $db->queryRead("SHOW TABLES"))) {
die('ERROR 1');
}
while (false !== ($row = $db->fetchRow($result))) {
$tablename = $row[0];
$new_tablename = preg_replace("/^{$oldfix}/", $newfix, $tablename);
echo "{$tablename} => {$new_tablename}\n";
$db->renameTable($tablename, $new_tablename);
}
/**
* @return GDO_Database
*/
function merge_db($argv)
{
$db = gdo_db_instance('localhost', $argv[1], $argv[2], $argv[3]);
return $db;
}
