$LEADS_ALL = $allLeads; $searchstatus = true; } else { $errors['e1'] = $tl['search']['s2']; $errors = $errors; } } } } if (!$searchstatus) { // Leads $sqlw = ''; $rowts['total_support'] = 0; $rowtc['totalAll'] = 0; $bounce_percentage = 0; if (!ls_get_access("leads_all", $lsuser->getVar("permissions"), LS_SUPERADMINACCESS)) { $sqlw = ' WHERE operatorid = "' . LS_USERID_RHINO . '"'; } $total = $lsdb->query('SELECT COUNT(*) as totalAll FROM ' . $lstable . $sqlw); $rowt = $total->fetch_assoc(); //break total records into pages $total_pages = ceil($rowt['totalAll'] / 20); $sqlw1 = $sqlw ? $sqlw . ' AND fcontact = 1' : ' WHERE fcontact = 1'; $totalc = $lsdb->query('SELECT COUNT(*) as totalAll FROM ' . $lstable . $sqlw1 . ''); $rowtc = $totalc->fetch_assoc(); // Get percentage if ($rowtc['totalAll']) { $bounce_percentage = round($rowtc['totalAll'] / $rowt['totalAll'] * 100, 2, PHP_ROUND_HALF_UP); } $sqlw2 = $sqlw ? $sqlw . ' AND ended != 0 AND initiated != 0' : ' WHERE ended != 0 AND initiated != 0'; $totals = $lsdb->query('SELECT SUM(ended - initiated) AS total_support FROM ' . $lstable . $sqlw2 . '');
/*======================================================================*\ || #################################################################### || || # Rhino Socket 2.0 # || || # ---------------------------------------------------------------- # || || # Copyright 2014 Rhino All Rights Reserved. # || || # This file may not be redistributed in whole or significant part. # || || # ---------------- Rhino IS NOT FREE SOFTWARE ---------------- # || || # http://www.livesupportrhino.com # || || #################################################################### || \*======================================================================*/ // Check if the file is accessed only via index.php if not stop the script from running if (!defined('LS_ADMIN_PREVENT_ACCESS')) { die('You cannot access this file directly.'); } // Check if the user has access to this file if (!ls_get_access("files", $lsuser->getVar("permissions"), LS_SUPERADMINACCESS)) { ls_redirect(BASE_URL); } // All the tables we need for this plugin $errors = array(); $lstable = DB_PREFIX . 'files'; // Now start with the plugin use a switch to access all pages switch ($page1) { case 'delete': // Check if the file can be deleted if (is_numeric($page2)) { $result = $lsdb->query('SELECT path FROM ' . $lstable . ' WHERE id = "' . smartsql($page2) . '"'); $row = $result->fetch_assoc(); // Now delete the record from the database $result = $lsdb->query('DELETE FROM ' . $lstable . ' WHERE id = "' . smartsql($page2) . '"'); // Now let us delete the file
/*======================================================================*\ || #################################################################### || || # Rhino Socket 2.0 # || || # ---------------------------------------------------------------- # || || # Copyright 2014 Rhino All Rights Reserved. # || || # This file may not be redistributed in whole or significant part. # || || # ---------------- Rhino IS NOT FREE SOFTWARE ---------------- # || || # http://www.livesupportrhino.com # || || #################################################################### || \*======================================================================*/ // Check if the file is accessed only via index.php if not stop the script from running if (!defined('LS_ADMIN_PREVENT_ACCESS')) { die('You cannot access this file directly.'); } // Check if the user has access to this file if (!ls_get_access("departments", $lsuser->getVar("permissions"), LS_SUPERADMINACCESS)) { ls_redirect(BASE_URL); } // All the tables we need for this plugin $errors = array(); $lstable = DB_PREFIX . 'departments'; // Now start with the plugin use a switch to access all pages switch ($page1) { case 'delete': // Check if user exists and can be deleted if (is_numeric($page2) && $page2 != 1) { // Now check how many languages are installed and do the dirty work $result = $lsdb->query('DELETE FROM ' . $lstable . ' WHERE id = "' . smartsql($page2) . '"'); if (!$result) { ls_redirect(BASE_URL . 'index.php?p=error&sp=mysql'); } else {
/*======================================================================*\ || #################################################################### || || # Rhino Socket 2.0 # || || # ---------------------------------------------------------------- # || || # Copyright 2014 Rhino All Rights Reserved. # || || # This file may not be redistributed in whole or significant part. # || || # ---------------- Rhino IS NOT FREE SOFTWARE ---------------- # || || # http://www.livesupportrhino.com # || || #################################################################### || \*======================================================================*/ // Check if the file is accessed only via index.php if not stop the script from running if (!defined('LS_ADMIN_PREVENT_ACCESS')) { die('You cannot access this file directly.'); } // Check if the user has access to this file if (!ls_get_access("maintenance", $lsuser->getVar("permissions"), LS_SUPERADMINACCESS)) { ls_redirect(BASE_URL); } include_once 'dbbackup/class.dbie.php'; $dbimpexp = new dbimpexp(); // Flag to select step if ($_SERVER['REQUEST_METHOD'] == 'POST') { $defaults = $_POST; if (isset($defaults['delCache'])) { // Now let us delete the all the cache file $cacheallfiles = '../' . LS_CACHE_DIRECTORY . '/'; $msfi = glob($cacheallfiles . "*.php"); if ($msfi) { foreach ($msfi as $filen) { if (file_exists($filen)) { unlink($filen);
$tl = parse_ini_file(APP_PATH . 'operator/lang/' . LS_LANG . '.ini', true); } else { $tl = parse_ini_file(APP_PATH . 'operator/lang/en.ini', true); } // Get the special lang var once for the time define('LS_DAY', $tl['general']['g74']); define('LS_HOUR', $tl['general']['g75']); define('LS_MINUTE', $tl['general']['g76']); define('LS_MULTITIME', $tl['general']['g77']); define('LS_AGO', $tl['general']['g78']); //get current starting point of records $position = $page_number * 10; // Operator Access $sqlw = ''; $loadcontent = ''; if (!ls_get_access("ochat_all", $lsuser->getVar("permissions"), $_SESSION['ls_superoperator'])) { $sqlw = ' WHERE fromid = "' . smartsql($_SESSION['ls_opid']) . '" OR toid = "' . smartsql($_SESSION['ls_opid']) . '"'; } if ($_POST["page2"] && ($_POST["page3"] == "ASC" || $_POST["page3"] == "DESC")) { $sqlorderby = $_POST["page2"] . ' ' . $_POST["page3"]; } else { $sqlorderby = 'sent DESC'; } $result = $lsdb->query('SELECT t1.id, t1.fromid, t1.toid, t1.message, t1.sent, t2.username, t3.username AS touser FROM ' . DB_PREFIX . 'operatorchat AS t1 LEFT JOIN ' . DB_PREFIX . 'user AS t2 ON (t1.fromid = t2.id) LEFT JOIN ' . DB_PREFIX . 'user AS t3 ON (t1.toid = t3.id)' . $sqlw . ' ORDER BY ' . $sqlorderby . ' LIMIT ' . $position . ', 10'); while ($row = $result->fetch_assoc()) { // refresh vars $superop = ''; if (LS_SUPERADMINACCESS) { $superop = '<a class="btn btn-default btn-xs" href="index.php?p=chats&sp=delete&ssp=' . $row["id"] . '" onclick="if(!confirm(' . $tl["error"]["e33"] . '))return false;"><span class="glyphicon glyphicon-trash"></span></a>'; } $loadcontent .= '<tr>
\*======================================================================*/ // Check if the file is accessed only via index.php if not stop the script from running if (!defined('LS_ADMIN_PREVENT_ACCESS')) { die('You cannot access this file directly.'); } // Check if the user has access to this file if (!ls_get_access("statistic", $lsuser->getVar("permissions"), LS_SUPERADMINACCESS)) { ls_redirect(BASE_URL); } // All the tables we need for this plugin $errors = array(); $lstable = DB_PREFIX . 'sessions'; $lstable1 = DB_PREFIX . 'user_stats'; $lstable2 = DB_PREFIX . 'user'; $lstable3 = DB_PREFIX . 'departments'; if (ls_get_access("statistic_all", $lsuser->getVar("permissions"), LS_SUPERADMINACCESS)) { $country_sql = ""; $support_sql = ""; $feedback_sql = ""; $button_sql = ""; $result = $lsdb->query('SELECT id, title FROM ' . $lstable3 . ' ORDER BY dorder ASC'); while ($row = $result->fetch_assoc()) { // collect each record into $_data $LS_DEPARTMENTS[] = $row; } } else { $country_sql = ' operatorid = "' . LS_USERID_RHINO . '" AND'; $support_sql = ' operatorid = "' . LS_USERID_RHINO . '" AND'; $feedback_sql = ' userid = "' . LS_USERID_RHINO . '" AND'; $button_sql = ' WHERE opid = "' . LS_USERID_RHINO . '"'; }