checkboxes как поле, связанное с таблицей - страница 5 - Разработка расширений для Joomla 3.x

$db = JFactory::getDbo();
$tables = $db->getTableList();
foreach ( $tables as $table ) {
	$db->truncateTable($table);
}

<?php defined('JPATH_PLATFORM') or die;

include_once JPATH_SITE.'/libraries/joomla/form/fields/checkboxes.php';

class JFormFieldCheckboxesDB extends JFormFieldCheckboxes
{
  protected $type = 'Checkboxesdb';

  protected function getOptions()
  {
    $options = array();
    $src = (string)$this->element['src'];
    if (!empty($src)) {
      $db = JFactory::getDBO();
      $items = $db->setQuery($src)->loadObjectList();
      if (isset($items)) {
        foreach ($items as $i => $item) {
          $option = JHtml::_('select.option', (string)$item->key, (string)$item->value, 'value', 'text', $this->disabled);
          $option->checked = in_array($item->value, (array)$this->value);
          $option->onclick = $this->onclick;
          $option->onchange = $this->onchange;
          $options[] = $option;
        }
      }
    }
    return $options;
  }
}

select id as `key`, name as `value` from #__users order by name