function validatelicense()
{
if (isset($_POST['instantcode'])) {
ChronoFormsAdminVersion::validatelicensedata();
} else {
$database = JFactory::getDBO();
$query = "SELECT * FROM `#__components` WHERE `option` = 'com_chronoforms' AND parent='0' AND admin_menu_link='option=com_chronoforms'";
$database->setQuery($query);
$result = $database->loadObject();
$params = new JParameter($result->params);
HTML_Admin_ChronoForms::validatelicense($params);
}
}
function validatelicense()
{
if (isset($_POST['instantcode'])) {
ChronoFormsAdminVersion::validatelicensedata();
} else {
$database =& JFactory::getDBO();
$query = "SELECT * FROM `#__extensions` WHERE `element` = 'com_chronoforms' AND `type` = 'component'";
$database->setQuery($query);
$result = $database->loadObject();
$params = new JParameter($result->params);
HTML_Admin_ChronoForms::validatelicense($params);
}
}
break;
case "list_data":
ChronoFormsAdmin::list_data($task);
break;
case "show_data":
ChronoFormsAdmin::show_data($task);
break;
case "delete_data":
ChronoFormsAdmin::delete_data($task);
break;
case "publish":
case "unpublish":
ChronoFormsAdmin::publish($task);
break;
case "validatelicense":
ChronoFormsAdminVersion::validatelicense($task);
break;
case "backup_forms":
ChronoFormsAdmin::backup_forms();
break;
case "restore_forms":
ChronoFormsAdmin::restore_forms();
break;
case "install_action":
ChronoFormsAdmin::install_action();
break;
case "updates":
ChronoFormsAdmin::updates();
break;
case "action_task":
ChronoFormsAdmin::action_task();
function index()
{
$mainframe =& JFactory::getApplication();
$database =& JFactory::getDBO();
//prepare the pagination
$option = 'com_chronoforms';
$limit = $mainframe->getUserStateFromRequest($option . '.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
$limitstart = $mainframe->getUserStateFromRequest($option . '.limitstart', 'limitstart', 0, 'int');
//get apps
$app = $mainframe->getUserStateFromRequest($option . '.app', 'select_app', '', 'string');
$apps = array('' => 'Default');
$database->setQuery("SELECT DISTINCT app FROM #__chronoforms");
$all = $database->loadObjectList();
foreach ($all as $one) {
if (!in_array($one->app, array_keys($apps))) {
$apps[$one->app] = $one->app;
}
}
// count entries
$database->setQuery("SELECT count(*) FROM #__chronoforms WHERE `app` = '" . $app . "'");
//$database->setQuery("SELECT count(*) FROM #__chronoforms");
$total = $database->loadResult();
jimport('joomla.html.pagination');
$pageNav = new JPagination($total, $limitstart, $limit);
//load forms data
$val = ChronoFormsAdminVersion::__getValStatus();
$database->setQuery("SELECT * FROM #__chronoforms WHERE `app` = '" . $app . "' ORDER BY id LIMIT {$pageNav->limitstart},{$pageNav->limit}");
//$database->setQuery("SELECT * FROM #__chronoforms ORDER BY id LIMIT $pageNav->limitstart,$pageNav->limit");
$forms = $database->loadObjectList();
if (!empty($forms)) {
foreach ($forms as $k => $form) {
//load actions
$query = "SELECT * FROM `#__chronoform_actions` WHERE `chronoform_id` = '" . $form->id . "' AND `enabled` = '1' ORDER BY `order`";
$database->setQuery($query);
$forms[$k]->form_actions = $database->loadObjectList();
}
}
HTML_Admin_ChronoForms::index($forms, $pageNav, $apps, $val);
}
