function ownddns_generateActivatedCustomers($tpl, $resellerId) { /** @var $cfg iMSCP_Config_Handler_File */ $cfg = iMSCP_Registry::get('config'); $rowsPerPage = $cfg->DOMAIN_ROWS_PER_PAGE; if (isset($_GET['psi']) && $_GET['psi'] == 'last') { unset($_GET['psi']); } $startIndex = isset($_GET['psi']) ? (int) $_GET['psi'] : 0; $countQuery = "\n\t\tSELECT COUNT(`t1`.`admin_id`) AS `cnt` \n\t\tFROM \n\t\t\t`admin` AS `t1`\n\t\tLEFT JOIN\n\t\t\t`ownddns` AS `t2` ON(`t2`.`admin_id` = `t1`.`admin_id`)\n\t\tWHERE\n\t\t\t`t1`.`created_by` = ?\n\t\tAND\n\t\t\t`t1`.`admin_id` IN (SELECT `admin_id` FROM `ownddns`)\n\t"; $stmt = exec_query($countQuery, $resellerId); $recordsCount = $stmt->fields['cnt']; $query = "\n\t\tSELECT\n\t\t\t`t2`.*\n\t\tFROM\n\t\t\t`admin` AS `t1`\n\t\tLEFT JOIN\n\t\t\t`ownddns` AS `t2` ON(`t2`.`admin_id` = `t1`.`admin_id`)\n\t\tWHERE\n\t\t\t`t1`.`created_by` = ?\n\t\tAND\n\t\t\t`t1`.`admin_id` IN (SELECT `admin_id` FROM `ownddns`)\n\t\tORDER BY\n\t\t\t`t2`.`admin_name` ASC\n\t\tLIMIT\n\t\t\t{$startIndex}, {$rowsPerPage}\n\t"; $stmt = exec_query($query, $resellerId); if ($recordsCount > 0) { $prevSi = $startIndex - $rowsPerPage; if ($startIndex == 0) { $tpl->assign('SCROLL_PREV', ''); } else { $tpl->assign(array('SCROLL_PREV_GRAY' => '', 'PREV_PSI' => $prevSi)); } $nextSi = $startIndex + $rowsPerPage; if ($nextSi + 1 > $recordsCount) { $tpl->assign('SCROLL_NEXT', ''); } else { $tpl->assign(array('SCROLL_NEXT_GRAY' => '', 'NEXT_PSI' => $nextSi)); } while ($data = $stmt->fetchRow()) { if ($data['ownddns_status'] == $cfg->ITEM_OK_STATUS) { $statusIcon = 'ok'; } elseif ($data['ownddns_status'] == $cfg->ITEM_DISABLED_STATUS) { $statusIcon = 'disabled'; } elseif ($data['ownddns_status'] == $cfg->ITEM_TOADD_STATUS || $data['ownddns_status'] == $cfg->ITEM_TOCHANGE_STATUS || $data['ownddns_status'] == $cfg->ITEM_TODELETE_STATUS || ($data['ownddns_status'] == $cfg->ITEM_TOADD_STATUS || $data['ownddns_status'] == $cfg->ITEM_TORESTORE_STATUS || $data['ownddns_status'] == $cfg->ITEM_TOCHANGE_STATUS || $data['ownddns_status'] == $cfg->ITEM_TOENABLE_STATUS || $data['ownddns_status'] == $cfg->ITEM_TODISABLE_STATUS || $data['ownddns_status'] == $cfg->ITEM_TODELETE_STATUS)) { $statusIcon = 'reload'; } else { $statusIcon = 'error'; } $tpl->assign(array('OWNDDNS_CUSTOMER_NAME' => decode_idna($data['admin_name']), 'OWNDDNS_STATUS' => translate_dmn_status($data['ownddns_status']), 'OWNDDNS_ACCOUNT_LIMIT' => get_ownddnsAccountLimit($data['admin_id']), 'OWNDDNS_ADMIN_ID' => $data['admin_id'], 'STATUS_ICON' => $statusIcon)); $tpl->parse('OWNDDNS_CUSTOMER_ITEM', '.ownddns_customer_item'); } $tpl->assign('OWNDDNS_NO_CUSTOMER_ITEM', ''); } else { $tpl->assign(array('OWNDDNS_CUSTOMER_LIST' => '', 'SCROLL_PREV' => '', 'SCROLL_PREV_GRAY' => '', 'SCROLL_NEXT' => '', 'SCROLL_NEXT_GRAY' => '')); } $tpl->assign('OWNDDNS_EDIT', ''); }
if ($accountID != '') { if (ownddns_EditAccount($tpl, $_SESSION['user_id'], $accountID)) { set_page_message(tr('OwnDDNS account successfully scheduled for update'), 'success'); redirectTo('ownddns.php'); } } } elseif ($action === 'delete') { $accountID = isset($_GET['ownddns_account_id']) ? clean_input($_GET['ownddns_account_id']) : ''; if ($accountID != '') { if (ownddns_DeleteAccount($tpl, $pluginManager, $_SESSION['user_id'], $accountID)) { set_page_message(tr('OwnDDNS account successfully scheduled for deletion'), 'success'); redirectTo('ownddns.php'); } } } else { showBadRequestErrorPage(); } } generateNavigation($tpl); get_ownddnsAccountLimit($tpl, $_SESSION['user_id']); ownddns_generateSelect($tpl, $_SESSION['user_id']); if (!isset($_REQUEST['action']) || isset($_REQUEST['action']) && clean_input($_REQUEST['action']) !== 'edit') { ownddns_generateAccountsList($tpl, $pluginManager, $_SESSION['user_id']); } generatePageMessage($tpl); $tpl->parse('LAYOUT_CONTENT', 'page'); iMSCP_Events_Manager::getInstance()->dispatch(iMSCP_Events::onClientScriptEnd, array('templateEngine' => $tpl)); $tpl->prnt(); } else { showBadRequestErrorPage(); }