function test_3_more_inserts()
{
DB::insert('`accounts`', array('username' => 'Bart', 'password' => 'hello', 'age' => 15, 'height' => 10.371));
$dbname = DB::$dbName;
DB::insert("`{$dbname}`.`accounts`", array('username' => 'Charlie\'s Friend', 'password' => 'goodbye', 'age' => 30, 'height' => 155.23, 'favorite_word' => null));
$this->assert(DB::insertId() === 3);
$counter = DB::queryFirstField("SELECT COUNT(*) FROM accounts");
$this->assert($counter === strval(3));
DB::insert('`accounts`', array('username' => 'Deer', 'password' => '', 'age' => 15, 'height' => 10.371));
$username = DB::queryFirstField("SELECT username FROM accounts WHERE password=%s0", null);
$this->assert($username === 'Deer');
$password = DB::queryFirstField("SELECT password FROM accounts WHERE favorite_word IS NULL");
$this->assert($password === 'goodbye');
DB::$usenull = false;
DB::insertUpdate('accounts', array('id' => 3, 'favorite_word' => null));
$password = DB::queryFirstField("SELECT password FROM accounts WHERE favorite_word=%s AND favorite_word=%s", null, '');
$this->assert($password === 'goodbye');
DB::$usenull = true;
DB::insertUpdate('accounts', array('id' => 3, 'favorite_word' => null));
DB::$param_char = '###';
$bart = DB::queryFirstRow("SELECT * FROM accounts WHERE age IN ###li AND height IN ###ld AND username IN ###ls", array(15, 25), array(10.371, 150.123), array('Bart', 'Barts'));
$this->assert($bart['username'] === 'Bart');
DB::insert('accounts', array('username' => 'f_u'));
DB::query("DELETE FROM accounts WHERE username=###s", 'f_u');
DB::$param_char = '%';
$charlie_password = DB::queryFirstField("SELECT password FROM accounts WHERE username IN %ls AND username = %s", array('Charlie', 'Charlie\'s Friend'), 'Charlie\'s Friend');
$this->assert($charlie_password === 'goodbye');
$charlie_password = DB::queryOneField('password', "SELECT * FROM accounts WHERE username IN %ls AND username = %s", array('Charlie', 'Charlie\'s Friend'), 'Charlie\'s Friend');
$this->assert($charlie_password === 'goodbye');
$passwords = DB::queryFirstColumn("SELECT password FROM accounts WHERE username=%s", 'Bart');
$this->assert(count($passwords) === 1);
$this->assert($passwords[0] === 'hello');
$username = $password = $age = null;
list($age, $username, $password) = DB::queryOneList("SELECT age,username,password FROM accounts WHERE username=%s", 'Bart');
$this->assert($username === 'Bart');
$this->assert($password === 'hello');
$this->assert($age == 15);
$mysqli_result = DB::queryRaw("SELECT * FROM accounts WHERE favorite_word IS NULL");
$this->assert($mysqli_result instanceof MySQLi_Result);
$row = $mysqli_result->fetch_assoc();
$this->assert($row['password'] === 'goodbye');
$this->assert($mysqli_result->fetch_assoc() === null);
}
public static function lookup_with_survey_tag($survey_tag)
{
$query = "SELECT * FROM credentials_stu WHERE survey_tag = %s";
$survey_id = DB::queryOneField('survey_id', $query, $survey_tag);
if (!is_null($survey_id)) {
// Hack to convert strings to ints but keep null as null.
$survey_id = (int) $survey_id;
}
return $survey_id;
}
public static function isTokenValid($newTokenValue)
{
$datetimeValid = "P1D";
// valid for 1 day
$result = false;
$lastAccess = CWM_API::getDateTime(strtotime(DB::queryOneField('LastAccess', 'SELECT * FROM CWM_ApiKeySession WHERE TokenValue=%?', $newTokenValue)));
$lastAccess = new DateTime($lastAccess);
$lastAccess->add(new DateInterval($datetimeValid));
$result = new DateTime(CWM_API::getDateTime(time())) < $lastAccess;
// if not valid, update the date to be in the past
if (!$result) {
CWM_API::resetToken($datetimeValid, $newTokenValue);
}
return $result;
}
public function getId()
{
return DB::queryOneField("Id", "SELECT * FROM CWM_Solution WHERE UserId=%? AND Name=%?", $this->UserId, $this->Name);
}
<?php
require_once $GLOBALS['dirLibs'] . '/external/meekrodb.2.2.class.php';
require_once $GLOBALS['dirCore'] . '/dbConfig.inc.php';
require_once $GLOBALS['dirRoot'] . '/api/ApiAuth.class.php';
$results = array();
$tokenValue = $f3->get('PARAMS.tokenValue');
if (CWM_API::IsTokenValid($tokenValue)) {
$userId = DB::queryOneField("Id", "SELECT * FROM CWM_ApiKeySession aks JOIN CWM_User as u ON aks.UserId = u.Id WHERE TokenValue=%?", $tokenValue);
$results = DB::query("SELECT * FROM CWM_Solution WHERE UserId=%?", $userId);
}
echo json_encode($results);
<?php
require_once '../../../../core/dirHandler.php';
require_once $GLOBALS['dirLibs'] . '/external/meekrodb.2.2.class.php';
require_once $GLOBALS['dirCore'] . '/dbConfig.inc.php';
require_once $GLOBALS['dirCore'] . '/config.inc.php';
require_once $GLOBALS['dirCore'] . '/common.inc.php';
$url = $_POST['url'];
$content = $_POST['content'];
$theme = $_POST['theme'];
$ID = DB::queryOneField('Id', "SELECT * FROM CWM_SourceDraft WHERE Url=%?", $url);
if (!is_null($ID)) {
DB::update('CWM_SourceDraft', array('Content' => $content, 'Theme' => $theme), "Id=%?", $ID);
}
<?php
require_once '../../../../core/dirHandler.php';
require_once $GLOBALS['dirLibs'] . '/external/meekrodb.2.2.class.php';
require_once $GLOBALS['dirCore'] . '/dbConfig.inc.php';
require_once $GLOBALS['dirCore'] . '/config.inc.php';
require_once $GLOBALS['dirCore'] . '/common.inc.php';
$selectId = $_POST['selectId'];
$file = $_POST['fileFullName'];
$content = DB::queryOneField('Content', "SELECT * FROM CWM_SourceDraft WHERE Url=%?", $selectId);
echo file_put_contents($file, $content);
<?php
require_once '../dirHandler.php';
require_once $GLOBALS['dirLibs'] . '/external/meekrodb.2.2.class.php';
require_once $GLOBALS['dirCore'] . '/dbConfig.inc.php';
$projectId = $_GET['projectId'];
$results = DB::query("SELECT * FROM CWM_File WHERE ProjectId=%? AND UserId=%?", $projectId, $_GET['uid']);
$data = array();
foreach ($results as $row) {
$shareId = $row['ShareId'];
$shareUrl = "";
if (!is_null($shareId)) {
$shareUrl = DB::queryOneField("Url", "SELECT * FROM CWM_Share WHERE FileId=%?", $row['Id']);
}
array_push($data, array('name' => $row['Name'], 'solutionName' => $row['SolutionName'], 'projectName' => $row['ProjectName'], 'shareUrl' => $shareUrl));
}
echo json_encode($data);
