';
if (isset($_GET['register']))
echo '
' . sprintf(__('The %s was successfully registered.', 'activehelper_livehelp'), __('domain', 'activehelper_livehelp')) . '
';
if (isset($_GET['update']))
echo '
' . sprintf(__('The %s was successfully updated.', 'activehelper_livehelp'), __('domain', 'activehelper_livehelp')) . '
';
if (isset($_GET['delete']))
echo '
' . sprintf(__('The %s was deleted permanently.', 'activehelper_livehelp'), __('domain', 'activehelper_livehelp')) . '
';
if (isset($_GET['miss']))
echo '
' . sprintf(__('The %s was not found.', 'activehelper_livehelp'), __('domain', 'activehelper_livehelp')) . '
';
echo '
';
}
function activeHelper_liveHelp_domainsDeletePost()
{
global $wpdb, $activeHelper_liveHelp;
$_REQUEST['id'] = !empty($_REQUEST['id']) ? (int) $_REQUEST['id'] : 0;
if (empty($_REQUEST['id']))
{
wp_redirect('admin.php?page=' . strtolower('activeHelper_liveHelp_domains') . '&miss');
exit;
}
$domain = $wpdb->get_row("
SELECT COUNT(*)
FROM {$wpdb->prefix}livehelp_domains
WHERE id_domain = '{$_REQUEST['id']}'
LIMIT 1
", ARRAY_A);
if (empty($domain))
{
wp_redirect('admin.php?page=' . strtolower('activeHelper_liveHelp_domains') . '&miss');
exit;
}
$wpdb->query("
DELETE FROM {$wpdb->prefix}livehelp_accounts_domain
WHERE id_domain = '{$_REQUEST['id']}'
");
$wpdb->query("
DELETE FROM {$wpdb->prefix}livehelp_languages_domain
WHERE Id_domain = '{$_REQUEST['id']}'
");
$wpdb->query("
DELETE FROM {$wpdb->prefix}livehelp_settings
WHERE id_domain = '{$_REQUEST['id']}'
");
activeHelper_liveHelp_filesDelete($activeHelper_liveHelp['domainsDir'] . '/' . $_REQUEST['id']);
wp_redirect('admin.php?page=' . strtolower('activeHelper_liveHelp_domains') . '&delete');
exit;
}
function activeHelper_liveHelp_domainsRegisterPost()
{
global $wpdb, $activeHelper_liveHelp;
$_POST['domain_name'] = !empty($_POST['domain_name']) ? (string) $_POST['domain_name'] : '';
$_POST['domain_status'] = !empty($_POST['domain_status']) ? 1 : 0;
$_POST['domain_global_configuration'] = !empty($_POST['domain_global_configuration']) ? (string) $_POST['domain_global_configuration'] : '';
$errors = array();
$activeHelper_liveHelp['errors'] = &$errors;
while (isset($_POST['submit']))
{
unset($_POST['submit']);
if (empty($_POST['domain_name']))
$errors['domain_name'] = sprintf(__('You must insert a %s', 'activehelper_livehelp'), __('name', 'activehelper_livehelp')); // error
// errors ...
if (!empty($errors))
break;
$wpdb->query("
INSERT INTO {$wpdb->prefix}livehelp_domains
(name, status, configuration)
VALUES
('{$_POST['domain_name']}', '{$_POST['domain_status']}', '{$_POST['domain_global_configuration']}')
");
$insert_id = $wpdb->get_row("
SELECT id_domain AS ID
FROM {$wpdb->prefix}livehelp_domains
ORDER BY id_domain DESC
LIMIT 1
", ARRAY_A);
$insert_id = $insert_id['ID'];
$settingsQuery = activeHelper_liveHelp_domainsSettingsQuery($insert_id);
$wpdb->query($settingsQuery);
activeHelper_liveHelp_filesDuplicate($activeHelper_liveHelp['domainsDir'] . '/0',
$activeHelper_liveHelp['domainsDir'] . '/' . $insert_id);
$wpdb->query("
INSERT INTO {$wpdb->prefix}livehelp_languages_domain
(Id_domain, code, name, welcome_message)
VALUES
('{$insert_id}', 'en', 'English', 'Welcome to our LiveHelp, one moment please.')
");
$wpdb->query("
INSERT INTO {$wpdb->prefix}livehelp_accounts_domain
(id_account, id_domain, status)
VALUES
('1', '{$insert_id}', '1')
");
wp_redirect('admin.php?page=' . strtolower('activeHelper_liveHelp_domains') . '®ister');
exit;
}
}
function activeHelper_liveHelp_domainsEditPost()
{
global $wpdb, $activeHelper_liveHelp;
$_REQUEST['id'] = !empty($_REQUEST['id']) ? (int) $_REQUEST['id'] : 0;
$_POST['domain_name'] = !empty($_POST['domain_name']) ? (string) $_POST['domain_name'] : '';
$_POST['domain_status'] = !empty($_POST['domain_status']) ? 1 : 0;
$_POST['domain_global_configuration'] = !empty($_POST['domain_global_configuration']) ? (string) $_POST['domain_global_configuration'] : '';
if (empty($_REQUEST['id']))
{
wp_redirect('admin.php?page=' . strtolower('activeHelper_liveHelp_domains') . '&miss');
exit;
}
$errors = array();
$activeHelper_liveHelp['errors'] = &$errors;
$domain = $wpdb->get_row("
SELECT name AS domain_name, status AS domain_status,
configuration AS domain_global_configuration
FROM {$wpdb->prefix}livehelp_domains
WHERE id_domain = '{$_REQUEST['id']}'
LIMIT 1
", ARRAY_A);
if (empty($domain))
{
wp_redirect('admin.php?page=' . strtolower('activeHelper_liveHelp_domains') . '&miss');
exit;
}
if (!isset($_POST['submit']))
$_POST = array_merge($_POST, $domain);
while (isset($_POST['submit']))
{
unset($_POST['submit']);
if (empty($_POST['domain_name']))
$errors['domain_name'] = sprintf(__('You must insert a %s', 'activehelper_livehelp'), __('name', 'activehelper_livehelp')); // error
// errors ...
if (!empty($errors))
break;
$wpdb->query("
UPDATE {$wpdb->prefix}livehelp_domains
SET name = '{$_POST['domain_name']}',
status = '{$_POST['domain_status']}',
configuration = '{$_POST['domain_global_configuration']}'
WHERE id_domain = '{$_REQUEST['id']}'
LIMIT 1
");
wp_redirect('admin.php?page=' . strtolower('activeHelper_liveHelp_domains') . '&update');
exit;
}
}
function activeHelper_liveHelp_domainsRegister()
{
global $activeHelper_liveHelp;
if (!empty($activeHelper_liveHelp['errors']))
$errors = $activeHelper_liveHelp['errors'];
$tabindex = 1;
echo '