public function moveFile($fileId, $id, $fromFileId = false)
{
if ($fromFileId) {
$folderId = $this->connection->fetchSingle("SELECT [folder_id] FROM [:vd:pages_files] WHERE [file_id]=%i", $fromFileId);
if ($folderId) {
return $this->connection->query("UPDATE [:vd:pages_files] SET [folder_id]=%i WHERE [file_id]=%i", $folderId, $fileId);
} else {
throw new \Exception('Destination folder not found.');
}
}
return $this->connection->query("UPDATE [:vd:pages_files] SET [folder_id]=%i WHERE [file_id]=%i", $id, $fileId);
}
<?php
require_once 'vendor/autoload.php';
require_once 'config.php';
use Dibi\Dibi;
$db = new DibiConnection($database_configuration);
if (isset($_COOKIE['language'])) {
$locale = $db->fetchSingle('SELECT locale FROM Languages WHERE code="' . $_COOKIE['language'] . '"');
putenv("LC_ALL={$locale}");
setlocale(LC_ALL, $locale);
bindtextdomain($text_domain, $base_dir . "/i18n");
textdomain($text_domain);
}
switch (isset($_GET['q']) ? $_GET['q'] : '') {
case "selectlanguage":
$rows = $db->query("SELECT code, name FROM Languages WHERE supported = 1");
echo "<option value='' selected></option>";
foreach ($rows as $row) {
echo "<option value='" . $row['code'] . "'>" . $row['name'] . "</option>";
}
break;
case "savetext":
$language = mysql_real_escape_string(isset($_POST['language']) ? $_POST['language'] : '');
// It will be possible to use Null Coalesce Operator in PHP 7, see: https://wiki.php.net/rfc/isset_ternary
$title = mysql_real_escape_string(isset($_POST['title']) ? $_POST['title'] : '');
$text = mysql_real_escape_string(isset($_POST['text']) ? $_POST['text'] : '');
$level = mysql_real_escape_string(isset($_POST['level']) ? $_POST['level'] : '');
$source = mysql_real_escape_string(isset($_POST['source']) ? $_POST['source'] : '');
$url = mysql_real_escape_string(isset($_POST['url']) ? $_POST['url'] : '');
$public = mysql_real_escape_string(isset($_POST['pub']) ? $_POST['pub'] : '');
$db->query("INSERT INTO Texts (language,title,text,level,source,url,public) VALUES ('" . $language . "','" . $title . "','" . $text . "','" . $level . "','" . $source . "','" . $url . "','" . $public . "')");
/**
* @param string $repositoryName
* @return boolean
*/
protected function existsRepositoryWithName($repositoryName)
{
return (bool) $this->dibiConnection->fetchSingle("SHOW TABLES LIKE %s;", $repositoryName);
}
<?php
require_once '../vendor/autoload.php';
require_once '../config.php';
use Dibi\Dibi;
$db = new DibiConnection($database_configuration);
if (isset($_COOKIE['language'])) {
$currentLanguage = $_COOKIE['language'];
} else {
$currentLanguage = $default_language;
}
$locale = $db->fetchSingle('SELECT locale FROM Languages WHERE code="' . $currentLanguage . '"');
putenv("LC_ALL={$locale}");
setlocale(LC_ALL, $locale);
bindtextdomain($text_domain, $base_dir . "/i18n");
textdomain($text_domain);
echo 'var currentLanguageI18n = "' . $currentLanguage . '",';
echo 'showSolutionI18n = "' . _('Show the solution') . '",';
echo 'showOriginI18n = "' . _('Show the original text') . '",';
echo 'showTestI18n = "' . _('Show the test') . '",';
echo 'checkTestI18n = "' . _('Check the test') . '",';
echo 'textIsPerfectI18n = "' . _('The text is perfect now.') . '",';
echo 'textIsNotCorrectI18n = "' . _('The text is not quite correct yet.') . '",';
echo 'selectLanguageI18n = "' . _('Choose your language') . '",';
echo 'selectLevelI18n = "' . _('Choose your language level') . '",';
echo 'levelI18n = "' . _('Language level') . '",';
echo 'selectTextI18n = "' . _('Choose a text') . '",';
echo 'selectTestTypeI18n = "' . _('Choose a test type') . '",';
echo 'formTextI18n = "' . _('or insert a text here.') . '",';
echo 'formTitleInfoTextI18n = "' . _('Would you like to save the text to the database?') . '",';
echo 'formTitleInfoTestI18n = "' . _('Would you like to save the test to the database?') . '",';
$minimise = ".min";
} else {
$minimise = "";
}
$row = $db->fetch('SELECT * FROM Tests WHERE secret="' . $secret . '" LIMIT 1');
$language = $row->language;
$textId = (int) $row->text;
$testTypeId = (int) $row->testtype;
$testText = $row->test;
$solution = $row->solution;
$level = $row->level;
$save = (bool) $row->save;
$public = (bool) $row->public;
if (strlen($language) == 2) {
setcookie('language', $language);
$locale = $db->fetchSingle('SELECT locale FROM Languages WHERE code="' . $language . '"');
} else {
$language = $default_language;
if (isset($_COOKIE['language'])) {
$locale = $db->fetchSingle('SELECT locale FROM Languages WHERE code="' . $_COOKIE['language'] . '"');
} else {
setcookie('language', $default_language);
$locale = $db->fetchSingle('SELECT locale FROM Languages WHERE code="' . $default_language . '"');
}
}
if ($language != "en") {
putenv("LC_ALL={$locale}");
setlocale(LC_ALL, $locale);
bindtextdomain($text_domain, $base_dir . "/i18n");
textdomain($text_domain);
}
