function listGuestBook()
{
global $toC_Json, $osC_Database, $osC_Language;
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];
$limit = empty($_REQUEST['limit']) ? MAX_DISPLAY_SEARCH_RESULTS : $_REQUEST['limit'];
$QguestBook = $osC_Database->query('select guest_books_id, title, email, url, guest_books_status, languages_id, content, date_added from :table_guest_books order by guest_books_id desc');
$QguestBook->bindTable(':table_guest_books', TABLE_GUEST_BOOKS);
$QguestBook->setExtBatchLimit($start, $limit);
$QguestBook->execute();
$records = array();
while ($QguestBook->next()) {
$records[] = array('guest_books_id' => $QguestBook->valueInt('guest_books_id'), 'title' => $QguestBook->value('title'), 'email' => $QguestBook->value('email'), 'url' => $QguestBook->value('url'), 'guest_books_status' => $QguestBook->value('guest_books_status'), 'languages' => $osC_Language->showImage(osC_Language_Admin::getData($QguestBook->valueInt('languages_id'), 'code')), 'content' => $QguestBook->value('content'), 'date_added' => osC_DateTime::getDate($QguestBook->value('date_added')));
}
$QguestBook->freeResult();
$response = array(EXT_JSON_READER_TOTAL => $QguestBook->getBatchSize(), EXT_JSON_READER_ROOT => $records);
echo $toC_Json->encode($response);
}
function deleteDefinitions($language_id, $group, $keys)
{
global $osC_Database;
$error = false;
$osC_Database->startTransaction();
foreach ($keys as $id) {
$Qdel = $osC_Database->query('delete from :table_languages_definitions where id = :id');
$Qdel->bindTable(':table_languages_definitions', TABLE_LANGUAGES_DEFINITIONS);
$Qdel->bindValue(':id', $id);
$Qdel->setLogging($_SESSION['module'], $id);
$Qdel->execute();
if ($osC_Database->isError()) {
$error = true;
break;
}
}
if ($error === false) {
$osC_Database->commitTransaction();
osC_Cache::clear('languages-' . osC_Language_Admin::getData($language_id, 'code') . '-' . $group);
return true;
}
$osC_Database->rollbackTransaction();
return false;
}
function loadLanguage()
{
global $toC_Json;
$data = osC_Language_Admin::getData($_REQUEST['languages_id']);
$data['default'] = $data['code'] == DEFAULT_LANGUAGE ? true : false;
$response = array('success' => true, 'data' => $data);
echo $toC_Json->encode($response);
}
