';
if (isset($_GET['register']))
echo '
' . sprintf(__('The %s was successfully registered.', 'activehelper_livehelp'), __('agent', 'activehelper_livehelp')) . '
';
if (isset($_GET['update']))
echo '
' . sprintf(__('The %s was successfully updated.', 'activehelper_livehelp'), __('agent', 'activehelper_livehelp')) . '
';
if (isset($_GET['delete']))
echo '
' . sprintf(__('The %s was deleted permanently.', 'activehelper_livehelp'), __('agent', 'activehelper_livehelp')) . '
';
if (isset($_GET['miss']))
echo '
' . sprintf(__('The %s was not found.', 'activehelper_livehelp'), __('agent', 'activehelper_livehelp')) . '
';
echo '
';
}
function activeHelper_liveHelp_agentsRegisterPost()
{
global $wpdb, $activeHelper_liveHelp;
$_POST['agent_username'] = !empty($_POST['agent_username']) ? (string) $_POST['agent_username'] : '';
$_POST['agent_password'] = !empty($_POST['agent_password']) ? (string) $_POST['agent_password'] : '';
$_POST['agent_firstname'] = !empty($_POST['agent_firstname']) ? (string) $_POST['agent_firstname'] : '';
$_POST['agent_lastname'] = !empty($_POST['agent_lastname']) ? (string) $_POST['agent_lastname'] : '';
$_POST['agent_email'] = !empty($_POST['agent_email']) ? (string) $_POST['agent_email'] : '';
$_POST['agent_department'] = !empty($_POST['agent_department']) ? (string) $_POST['agent_department'] : '';
$_POST['agent_status'] = !empty($_POST['agent_status']) ? 1 : 0;
$_POST['agent_privilege'] = !empty($_POST['agent_privilege']) ? 1 : 0;
$_POST['agent_domains'] = !empty($_POST['agent_domains']) ? (array) $_POST['agent_domains'] : array();
$errors = array();
$activeHelper_liveHelp['errors'] = &$errors;
while (isset($_POST['submit']))
{
unset($_POST['submit']);
if (empty($_POST['agent_username']))
$errors['agent_username'] = sprintf(__('You must insert a %s', 'activehelper_livehelp'), __('user name', 'activehelper_livehelp')); // error
if (empty($_POST['agent_email']))
$errors['agent_email'] = sprintf(__('You must insert an %s', 'activehelper_livehelp'), __('email', 'activehelper_livehelp')); // error
// errors ...
if (!empty($errors))
break;
if ($agent['agent_username'] != $_POST['agent_username'])
{
$agent_exists = $wpdb->get_var("
SELECT id
FROM {$wpdb->prefix}livehelp_users
WHERE username = '{$_POST['agent_username']}'
LIMIT 1
");
if (!empty($agent_exists))
$errors['agent_username'] = __('The username is already in use', 'activehelper_livehelp'); // error
}
// errors ...
if (!empty($errors))
break;
$_POST['agent_password'] = !empty($_POST['agent_password']) ? md5($_POST['agent_password']) : '';
$wpdb->query("
INSERT INTO {$wpdb->prefix}livehelp_users
(username, password, firstname, lastname, email, department, privilege, status)
VALUES
('{$_POST['agent_username']}', '{$_POST['agent_password']}',
'{$_POST['agent_firstname']}', '{$_POST['agent_lastname']}',
'{$_POST['agent_email']}', '{$_POST['agent_department']}',
'{$_POST['agent_privilege']}', '{$_POST['agent_status']}')
");
$agent_ID = $wpdb->get_var("
SELECT MAX(id)
FROM {$wpdb->prefix}livehelp_users
");
foreach ($_POST['agent_domains'] as $domain_ID => $domain_status)
{
if (empty($domain_status))
continue;
$wpdb->query("
INSERT INTO {$wpdb->prefix}livehelp_domain_user
(id_domain, id_user, status)
VALUES
('{$domain_ID}', '{$agent_ID}', '1')
");
$relation_ID = $wpdb->get_var("
SELECT MAX(id_domain_user)
FROM {$wpdb->prefix}livehelp_domain_user
");
$wpdb->query("
INSERT INTO {$wpdb->prefix}livehelp_sa_domain_user_role
(id_domain_user, id_role)
VALUES
('{$relation_ID}', '1')
");
}
$agent_picture = '';
while (!empty($_FILES['agent_picture']['tmp_name']))
{
$image = activeHelper_liveHelp_imagesUpload($activeHelper_liveHelp['agentsDir'], 'a' . $agent_ID, $_FILES['agent_picture']);
unset($_FILES['agent_picture']);
if ($image === false)
break;
$agent_picture = $image;
}
$wpdb->query("
UPDATE {$wpdb->prefix}livehelp_users
SET photo = '{$agent_picture}'
WHERE id = '{$agent_ID}'
");
wp_redirect('admin.php?page=' . strtolower('activeHelper_liveHelp_agents') . '®ister');
exit;
}
}
function activeHelper_liveHelp_agentsEditPost()
{
global $wpdb, $activeHelper_liveHelp;
$_REQUEST['id'] = !empty($_REQUEST['id']) ? (int) $_REQUEST['id'] : 0;
$_POST['agent_username'] = !empty($_POST['agent_username']) ? (string) $_POST['agent_username'] : '';
$_POST['agent_password'] = !empty($_POST['agent_password']) ? (string) $_POST['agent_password'] : '';
$_POST['agent_firstname'] = !empty($_POST['agent_firstname']) ? (string) $_POST['agent_firstname'] : '';
$_POST['agent_lastname'] = !empty($_POST['agent_lastname']) ? (string) $_POST['agent_lastname'] : '';
$_POST['agent_email'] = !empty($_POST['agent_email']) ? (string) $_POST['agent_email'] : '';
$_POST['agent_department'] = !empty($_POST['agent_department']) ? (string) $_POST['agent_department'] : '';
$_POST['agent_status'] = !empty($_POST['agent_status']) ? 1 : 0;
$_POST['agent_privilege'] = !empty($_POST['agent_privilege']) ? 1 : 0;
$_POST['agent_domains'] = !empty($_POST['agent_domains']) ? (array) $_POST['agent_domains'] : array();
if (empty($_REQUEST['id']))
{
wp_redirect('admin.php?page=' . strtolower('activeHelper_liveHelp_agents') . '&miss');
exit;
}
$errors = array();
$activeHelper_liveHelp['errors'] = &$errors;
$agent = $wpdb->get_row("
SELECT username AS agent_username, firstname AS agent_firstname, lastname AS agent_lastname,
email AS agent_email, department AS agent_department, privilege AS agent_privilege,
status AS agent_status, photo AS agent_picture
FROM {$wpdb->prefix}livehelp_users
WHERE id = '{$_REQUEST['id']}'
LIMIT 1
", ARRAY_A);
if (empty($agent))
{
wp_redirect('admin.php?page=' . strtolower('activeHelper_liveHelp_agent') . '&miss');
exit;
}
$agents_domains = $wpdb->get_results("
SELECT id_domain, status
FROM {$wpdb->prefix}livehelp_domain_user
WHERE id_user = '{$_REQUEST['id']}'
", ARRAY_A);
$_POST['agent_domains_old'] = array();
foreach ($agents_domains as $agents_domain)
if ($agents_domain['status'] == 1)
$_POST['agent_domains_old'][$agents_domain['id_domain']] = 1;
if (!isset($_POST['submit']))
{
$_POST = array_merge($_POST, $agent);
$_POST['agent_domains'] = $_POST['agent_domains_old'];
}
$_POST['agent_picture'] = $agent['agent_picture'];
while (isset($_POST['submit']))
{
unset($_POST['submit']);
if (empty($_POST['agent_username']))
$errors['agent_username'] = sprintf(__('You must insert a %s', 'activehelper_livehelp'), __('user name', 'activehelper_livehelp')); // error
if (empty($_POST['agent_email']))
$errors['agent_email'] = sprintf(__('You must insert an %s', 'activehelper_livehelp'), __('email', 'activehelper_livehelp')); // error
// errors ...
if (!empty($errors))
break;
if ($agent['agent_username'] != $_POST['agent_username'])
{
$agent_exists = $wpdb->get_var("
SELECT id
FROM {$wpdb->prefix}livehelp_users
WHERE username = '{$_POST['agent_username']}'
LIMIT 1
");
if (!empty($agent_exists))
$errors['agent_username'] = __('The username is already in use', 'activehelper_livehelp'); // error
}
// errors ...
if (!empty($errors))
break;
$_POST['agent_password'] = !empty($_POST['agent_password']) ? "'" . md5($_POST['agent_password']) . "'" : 'password';
$agent_picture = '';
while (!empty($_FILES['agent_picture']['tmp_name']))
{
if (!empty($_POST['agent_picture']))
activeHelper_liveHelp_imagesDelete($activeHelper_liveHelp['agentsDir'], $_POST['agent_picture']);
$image = activeHelper_liveHelp_imagesUpload($activeHelper_liveHelp['agentsDir'], 'a' . $_REQUEST['id'], $_FILES['agent_picture']);
unset($_FILES['agent_picture']);
if ($image === false)
break;
$agent_picture = $image;
}
$wpdb->query("
UPDATE {$wpdb->prefix}livehelp_users
SET
username = '{$_POST['agent_username']}',
password = {$_POST['agent_password']},
firstname = '{$_POST['agent_firstname']}',
lastname = '{$_POST['agent_lastname']}',
email = '{$_POST['agent_email']}',
department = '{$_POST['agent_department']}',
privilege = '{$_POST['agent_privilege']}',
status = '{$_POST['agent_status']}'" . (!empty($agent_picture) ? ",
photo = '{$agent_picture}'" : "") . "
WHERE id = '{$_REQUEST['id']}'
LIMIT 1
");
$_POST['agent_domains_change'] = array();
foreach ($_POST['agent_domains'] as $domain_ID => $domain_status)
if (isset($_POST['agent_domains_old'][$domain_ID]) && empty($domain_status))
$_POST['agent_domains_change'][$domain_ID] = 0;
else if (!isset($_POST['agent_domains_old'][$domain_ID]) && !empty($domain_status))
$_POST['agent_domains_change'][$domain_ID] = 1;
foreach ($_POST['agent_domains_change'] as $domain_ID => $domain_status)
if (!empty($domain_status))
{
$wpdb->query("
INSERT INTO {$wpdb->prefix}livehelp_domain_user
(id_domain, id_user, status)
VALUES
('{$domain_ID}', '{$_REQUEST['id']}', '1')
");
$relation_ID = $wpdb->get_var("
SELECT MAX(id_domain_user)
FROM {$wpdb->prefix}livehelp_domain_user
");
$wpdb->query("
INSERT INTO {$wpdb->prefix}livehelp_sa_domain_user_role
(id_domain_user, id_role)
VALUES
('{$relation_ID}', '1')
");
}
else
{
$relation_ID = $wpdb->get_var("
SELECT id_domain_user
FROM {$wpdb->prefix}livehelp_domain_user
WHERE id_domain = '{$domain_ID}'
AND id_user = '{$_REQUEST['id']}'
LIMIT 1
");
$wpdb->query("
DELETE FROM {$wpdb->prefix}livehelp_sa_domain_user_role
WHERE id_domain_user = '{$relation_ID}'
LIMIT 1
");
$wpdb->query("
DELETE FROM {$wpdb->prefix}livehelp_domain_user
WHERE id_domain = '{$domain_ID}'
AND id_user = '{$_REQUEST['id']}'
LIMIT 1
");
}
wp_redirect('admin.php?page=' . strtolower('activeHelper_liveHelp_agents') . '&update');
exit;
}
}
function activeHelper_liveHelp_agentsRegister()
{
global $wpdb, $activeHelper_liveHelp;
if (!empty($activeHelper_liveHelp['errors']))
$errors = $activeHelper_liveHelp['errors'];
$domainsList = $wpdb->get_results("
SELECT id_domain AS ID, name AS domain_name, status AS domain_status,
configuration AS domain_global_configuration
FROM {$wpdb->prefix}livehelp_domains
ORDER BY id_domain
", ARRAY_A);
$tabindex = 1;
echo '