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); }