public function clear()
{
$this->columns = array();
parent::clear();
}
$sql = 'SELECT * FROM ' . TBL_LISTS . '
WHERE lst_org_id = ' . $gCurrentOrganization->getValue('org_id') . '
AND ( lst_usr_id = ' . $gCurrentUser->getValue('usr_id') . '
OR lst_global = 1)
ORDER BY lst_global ASC, lst_name ASC, lst_timestamp DESC ';
$lst_result = $gDb->query($sql);
if ($gDb->num_rows() > 0) {
$list_global_flag = '';
$list_name_flag = '';
$optgroup_flag = 0;
$counterUnsavedLists = 0;
$tableListGlobalFlag = null;
$tableListNameFlag = null;
$tableList = new TableLists($gDb);
while ($row = $gDb->fetch_array($lst_result)) {
$tableList->clear();
$tableList->setArray($row);
// maximal nur die letzten 5 Konfigurationen ohne Namen speichern
if (strlen($tableList->getValue('lst_name')) == 0) {
$counterUnsavedLists++;
}
if ($counterUnsavedLists > 5 && strlen($tableList->getValue('lst_name')) == 0) {
// alle weiteren Konfigurationen ohne Namen loeschen
$del_list = new ListConfiguration($gDb, $tableList->getValue('lst_id'));
$del_list->delete();
} else {
// erst mal schauen, ob eine neue Gruppe von Konfigurationen angefangen hat
if ($tableList->getValue('lst_global') != $tableListGlobalFlag || $tableList->getValue('lst_name') != $tableListNameFlag && strlen($tableListNameFlag) == 0) {
if ($optgroup_flag == 1) {
$page->addHtml('</optgroup>');
}
