You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
419 lines
17 KiB
419 lines
17 KiB
<?php
|
|
|
|
/*===============================================*\
|
|
|| ############################################# ||
|
|
|| # JAKWEB.CH / Version 2.0.5 # ||
|
|
|| # ----------------------------------------- # ||
|
|
|| # Copyright 2022 JAKWEB All Rights Reserved # ||
|
|
|| ############################################# ||
|
|
\*===============================================*/
|
|
|
|
// Filter widget settings input
|
|
function jak_widget_settings($value) {
|
|
return filter_var($value, FILTER_SANITIZE_FULL_SPECIAL_CHARS);
|
|
}
|
|
|
|
// Get the data per array for page,newsletter with limit
|
|
function jak_get_page_info($table, $opid = 0, $limit = "")
|
|
{
|
|
global $jakdb;
|
|
if (!empty($limit) && $opid) {
|
|
$datatable = $jakdb->select($table, "*", ["opid" => $opid, "ORDER" => ["id" => "DESC"], "LIMIT" => $limit]);
|
|
} elseif ($opid) {
|
|
$datatable = $jakdb->select($table, "*", ["opid" => $opid, "ORDER" => ["id" => "DESC"]]);
|
|
} elseif (!empty($limit)) {
|
|
$datatable = $jakdb->select($table, "*", ["ORDER" => ["id" => "DESC"], "LIMIT" => $limit]);
|
|
} else {
|
|
$datatable = $jakdb->select($table, "*", ["ORDER" => ["id" => "DESC"]]);
|
|
}
|
|
|
|
if (!empty($datatable)) return $datatable;
|
|
}
|
|
|
|
// Get the available front end packages
|
|
function jak_get_templates() {
|
|
|
|
// Get the template folder
|
|
$packdir = '../'.'template/';
|
|
|
|
return array_diff(scandir($packdir), array('..', '.', 'index.html', '.DS_Store'));
|
|
}
|
|
|
|
// Search for lang files in the admin folder, only choose .ini files.
|
|
function jak_get_chat_templates() {
|
|
|
|
// Get the chat template folder
|
|
$packdir = '../'.'lctemplate/';
|
|
|
|
return array_diff(scandir($packdir), array('..', '.', 'index.html', '.DS_Store'));
|
|
}
|
|
|
|
// Make the filename beautiful
|
|
function jak_tpl_name($tpl) {
|
|
|
|
// First we remove the .php
|
|
$tpl = substr($tpl, 0, -4);
|
|
|
|
// Then we remove the _
|
|
$tpl = str_replace("_", " ", $tpl);
|
|
|
|
// Finally we make each first letter uppercase
|
|
$tpl = ucwords($tpl);
|
|
|
|
return $tpl;
|
|
}
|
|
|
|
// Get files
|
|
function jak_get_templates_files($directory) {
|
|
|
|
foreach (glob($directory."*.php") as $file) {
|
|
$getTPL[] = basename($file);
|
|
}
|
|
|
|
if (!empty($getTPL)) return $getTPL;
|
|
}
|
|
|
|
// Get avatar sets
|
|
function jak_get_avatar_sets($template) {
|
|
|
|
// Get the avatar folder
|
|
$packdir = '../'.'lctemplate/'.$template.'/avatar/';
|
|
|
|
return array_diff(scandir($packdir), array('..', '.', 'index.html', '.DS_Store'));
|
|
}
|
|
|
|
// Get avatar images
|
|
function jak_get_avatar_images($template, $avatarset) {
|
|
|
|
// Get the avatar folder
|
|
$packdir = '../lctemplate/'.$template.'/avatar/'.$avatarset.'/';
|
|
|
|
foreach (glob($packdir."*.jpg") as $file) {
|
|
$getAva[] = $file;
|
|
}
|
|
|
|
if (!empty($getAva)) return $getAva;
|
|
}
|
|
|
|
// Search for lang files in the admin folder, only choose .ini files.
|
|
function jak_get_sound_files() {
|
|
|
|
$getsound = array();
|
|
|
|
global $jakdb;
|
|
// Get the sounds from the installed packages
|
|
$packsound = $jakdb->select("chatwidget", "template", ["GROUP" => "template"]);
|
|
|
|
if (isset($packsound) && !empty($packsound)) {
|
|
|
|
foreach ($packsound as $v) {
|
|
|
|
$packagef = 'lctemplate/'.$v.'/';
|
|
if (file_exists('../'.$packagef.'config.php')) {
|
|
|
|
include_once '../'.$packagef.'config.php';
|
|
|
|
if (isset($jakgraphix["sound"]) && !empty($jakgraphix["sound"])) {
|
|
|
|
// Get the general sounds
|
|
$dynsound = '../'.$packagef.$jakgraphix["sound"];
|
|
|
|
if ($dynhandle = opendir($dynsound)) {
|
|
|
|
/* This is the correct way to loop over the directory. */
|
|
while (false !== ($dynfile = readdir($dynhandle))) {
|
|
$dynshowsound = substr($dynfile, strrpos($dynfile, '.'));
|
|
if ($dynfile != '.' && $dynfile != '..' && $dynshowsound == '.mp3') {
|
|
|
|
$getsound[] = $packagef.$jakgraphix["sound"].substr($dynfile, 0, -4);
|
|
|
|
}
|
|
}
|
|
closedir($dynhandle);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
// Get the general sounds
|
|
$soundir = '../sound/';
|
|
|
|
if ($handle = opendir($soundir)) {
|
|
|
|
/* This is the correct way to loop over the directory. */
|
|
while (false !== ($file = readdir($handle))) {
|
|
$showsound = substr($file, strrpos($file, '.'));
|
|
if ($file != '.' && $file != '..' && $showsound == '.mp3') {
|
|
|
|
$getsound[] = 'sound/'.substr($file, 0, -4);
|
|
|
|
}
|
|
}
|
|
closedir($handle);
|
|
return $getsound;
|
|
|
|
}
|
|
}
|
|
|
|
// Remove chat options because of the template
|
|
function jak_remove_chat_options($opid, $formtype, $widgetid)
|
|
{
|
|
global $jakdb;
|
|
if ($jakdb->delete("chatsettings", ["AND" => ["opid" => $opid, "widgetid" => $widgetid, "formtype" => $formtype]])) {
|
|
return true;
|
|
}
|
|
}
|
|
|
|
// Get all user out the database limited with the paginator
|
|
function jak_get_user_all($table, $userid, $limit = '') {
|
|
|
|
global $jakdb;
|
|
if ($userid) {
|
|
if ($limit == "meandsibling") {
|
|
$datausr = $jakdb->select($table, "*", ["OR" => ["id" => $userid, "opid" => $userid]]);
|
|
} elseif ($limit == "siblings") {
|
|
$datausr = $jakdb->select($table, "*", ["AND" => ["opid" => $userid, "extraop" => 1]]);
|
|
} else {
|
|
$datausr = $jakdb->select($table, "*", ["id" => $userid]);
|
|
}
|
|
} else {
|
|
$datausr = $jakdb->select($table, "*", ["LIMIT" => $limit]);
|
|
}
|
|
|
|
return $datausr;
|
|
}
|
|
|
|
// Check if user exist and it is possible to delete ## (config.php)
|
|
function jak_user_exist_deletable($id) {
|
|
$useridarray = explode(',', JAK_SUPERADMIN);
|
|
// check if userid is protected in the config.php
|
|
if (in_array($id, $useridarray)) {
|
|
return false;
|
|
} else {
|
|
global $jakdb;
|
|
if ($jakdb->has("user", ["id" => $id])) return true;
|
|
}
|
|
return false;
|
|
}
|
|
|
|
function secondsToTime($seconds,$time) {
|
|
$singletime = explode(",", $time);
|
|
if (is_numeric($seconds)) {
|
|
$dtF = new DateTime("@0");
|
|
$dtT = new DateTime("@$seconds");
|
|
return $dtF->diff($dtT)->format('%a '.$singletime[0].', %h '.$singletime[1].', %i '.$singletime[2].' '.$singletime[4].' %s '.$singletime[3]);
|
|
} else {
|
|
return '0 '.$singletime[0].', 0 '.$singletime[1].', 0 '.$singletime[2].' '.$singletime[4].' 0 '.$singletime[3];
|
|
}
|
|
}
|
|
|
|
// Get the custom fields ready to serve
|
|
function jak_get_custom_fields_tpl($opid, $widgetid, $template, $formtype, $formfields, $buttons, $slideimg) {
|
|
|
|
global $jakdb;
|
|
$fields = $translations = '';
|
|
|
|
if (isset($formfields) && !empty($formfields)) {
|
|
|
|
foreach ($formfields as $v) {
|
|
|
|
// We explode each form
|
|
$fvalue = explode(":#:", $v);
|
|
|
|
// Get the correct fields
|
|
$formdata = $jakdb->get('chatsettings', ["lang", "settname", "settvalue"], ["AND" => ["opid" => $opid, "widgetid" => $widgetid, "template" => $template, "formtype" => $formtype, "settname" => jak_clean_string($fvalue[4])]]);
|
|
|
|
if ($fvalue[0] == 3 || $fvalue[0] == 4 || $fvalue[0] == 5) {
|
|
$fieldoptions = explode(",", $fvalue[2]);
|
|
// Set translation to false because it does not exist
|
|
$tl = false;
|
|
}
|
|
|
|
// We will need a hidden input fields to find out what we need to save
|
|
$fields .= '<input type="hidden" name="chatsettings[]" value="'.jak_clean_string($fvalue[4]).':#:'.$formtype.'">';
|
|
|
|
if ($fvalue[0] == 1) {
|
|
// INPUT
|
|
$fields .= '<div class="form-group">
|
|
<label class="control-label" for="'.jak_clean_string($fvalue[4]).'">'.$fvalue[1].'</label>
|
|
'.(isset($fvalue[2]) && $fvalue[2] == "icon" ? '<div class="input-group">' : '').'
|
|
<input type="text" name="'.jak_clean_string($fvalue[4]).'" id="'.jak_clean_string($fvalue[4]).'" class="form-control'.(isset($fvalue[2]) && $fvalue[2] == "colour" ? ' colour_changer' : '').'" value="'.(isset($formdata["settname"]) && $formdata["settname"] == jak_clean_string($fvalue[4]) ? $formdata["settvalue"] : '').'">
|
|
'.(isset($fvalue[2]) && $fvalue[2] == "icon" ? '<div class="input-group-append"><span class="input-group-text"><a href="https://fontawesome.com/v5/search" target="_blank"><i class="fa fa-link"></i></a></span></div></div>' : '').'</div>';
|
|
} elseif ($fvalue[0] == 2) {
|
|
// TEXTAREA
|
|
$fields .= '<div class="form-group">
|
|
<label class="control-label" for="'.jak_clean_string($fvalue[4]).'">'.$fvalue[1].'</label>
|
|
<textarea class="form-control" name="'.jak_clean_string($fvalue[4]).'">'.(isset($formdata["settname"]) && $formdata["settname"] == jak_clean_string($fvalue[4]) ? $formdata["settvalue"] : '').'</textarea></div>';
|
|
} elseif ($fvalue[0] == 3) {
|
|
// RADIO
|
|
$fields .= '<div class="form-group"><label class="control-label" for="'.jak_clean_string($fvalue[4]).'">'.$fvalue[1].'</label>';
|
|
if (isset($fieldoptions) && !empty($fieldoptions)) foreach ($fieldoptions as $k => $z) {
|
|
$value = ($tl ? $k : $z);
|
|
$fields .= '<div class="form-check">
|
|
<label class="form-check-label">
|
|
<input class="form-check-input" type="radio" name="'.jak_clean_string($fvalue[4]).'" value="'.$value.'"'.(isset($formdata["settname"]) && $formdata["settname"] == jak_clean_string($fvalue[4]) && $formdata["settvalue"] == $value ? ' checked' : '').'> '.$z.'
|
|
<span class="circle">
|
|
<span class="check"></span>
|
|
</span>
|
|
</label>
|
|
</div>';
|
|
}
|
|
$fields .= '</div>';
|
|
} elseif ($fvalue[0] == 4) {
|
|
// CHECKBOX
|
|
$fields .= '<div class="form-group"><label class="control-label" for="'.jak_clean_string($fvalue[4]).'">'.$fvalue[1].'</label>';
|
|
if (isset($fieldoptions) && !empty($fieldoptions)) foreach ($fieldoptions as $k => $z) {
|
|
$value = ($tl ? $k : $z);
|
|
$fields .= '<div class="form-check">
|
|
<label class="form-check-label">
|
|
<input class="form-check-input" type="checkbox" name="'.jak_clean_string($fvalue[4]).'[]" value="'.$value.'"'.(isset($formdata["settname"]) && $formdata["settname"] == jak_clean_string($fvalue[4]) && in_array($value, explode(',', $formdata["settvalue"])) ? ' checked' : '').'> '.$z.'
|
|
<span class="form-check-sign">
|
|
<span class="check"></span>
|
|
</span>
|
|
</label>
|
|
</div>';
|
|
}
|
|
$fields .= '</div>';
|
|
} elseif ($fvalue[0] == 5) {
|
|
// SELECT
|
|
$fields .= '<div class="form-group"><label class="control-label" for="'.jak_clean_string($fvalue[4]).'">'.$fvalue[1].'</label><select name="'.jak_clean_string($fvalue[4]).'" class="selectpicker" data-style="select-with-transition" data-live-search="true">';
|
|
if (isset($fieldoptions) && !empty($fieldoptions)) foreach ($fieldoptions as $k => $z) {
|
|
if ($z == "btn") {
|
|
|
|
if (isset($buttons) && is_array($buttons)) foreach($buttons as $k) { if (getimagesize(APP_PATH.JAK_FILES_DIRECTORY.'/buttons/'.$k) && strpos($k,"_on")) {
|
|
$fields .= '<option value="'.$k.'"'.(isset($formdata["settname"]) && $formdata["settname"] == jak_clean_string($fvalue[4]) && $formdata["settvalue"] == $k ? ' selected="selected"' : '').'>'.$k.'</option>';
|
|
} }
|
|
|
|
} elseif ($z == "slideimg") {
|
|
|
|
if (isset($slideimg) && is_array($slideimg)) foreach($slideimg as $k) { if (getimagesize(APP_PATH.JAK_FILES_DIRECTORY.'/slideimg/'.$k) && strpos($k,"_on")) {
|
|
$fields .= '<option value="'.$k.'"'.(isset($formdata["settname"]) && $formdata["settname"] == jak_clean_string($fvalue[4]) && $formdata["settvalue"] == $k ? ' selected="selected"' : '').'>'.$k.'</option>';
|
|
} }
|
|
|
|
} else {
|
|
$value = ($tl ? $k : $z);
|
|
$fields .= '<option value="'.$value.'"'.(isset($formdata["settname"]) && $formdata["settname"] == jak_clean_string($fvalue[4]) && $formdata["settvalue"] == $value ? ' selected' : '').'>'.$z.'</option>';
|
|
}
|
|
}
|
|
$fields .= '</select></div>';
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
|
|
return $fields;
|
|
}
|
|
|
|
// Update main operators after purchasing a package
|
|
function update_main_operator($subs, $pack, $currency, $amount, $paygateid, $subscribeid, $subscribed, $subscribe_id, $paidhow, $opid, $locationid) {
|
|
|
|
global $jakdb;
|
|
global $jakdb1;
|
|
// Ok we have less operators therefore we remove the oldest ones.
|
|
if ($subs['operators'] > $pack['operators']) {
|
|
|
|
$opremove = $subs['operators'] - $pack['operators'];
|
|
|
|
$oldops = $jakdb->select("user", "id", ["opid" => $opid, "ORDER" => ["lastactivity" => "ASC"], "LIMIT" => $opremove]);
|
|
if (isset($oldops) && !empty($oldops)) foreach ($oldops as $o) {
|
|
|
|
// Delete the stuff from this user
|
|
$jakdb->delete("user", ["id" => $o]);
|
|
$jakdb->delete("push_notification_devices", ["userid" => $o]);
|
|
$jakdb->delete("user_stats", ["userid" => $o]);
|
|
}
|
|
|
|
}
|
|
|
|
// Ok we have less department therefore we remove the newest ones.
|
|
if ($subs['departments'] > $pack['departments']) {
|
|
|
|
$dpremove = $subs['departments'] - $pack['departments'];
|
|
|
|
$olddep = $jakdb->select("departments", "id", ["opid" => $opid, "ORDER" => ["id" => "DESC"], "LIMIT" => $dpremove]);
|
|
if (isset($olddep) && !empty($olddep)) foreach ($olddep as $d) {
|
|
|
|
// Delete the stuff from this user
|
|
$jakdb->delete("departments", ["id" => $d]);
|
|
}
|
|
|
|
}
|
|
|
|
// Ok we have less php imap connections therefore we remove the newest ones.
|
|
if (isset($subs['phpimap']) && $subs['phpimap'] > $pack['phpimap']) {
|
|
|
|
$dpremove = $subs['phpimap'] - $pack['phpimap'];
|
|
|
|
$oldpi = $jakdb->select("php_imap", "id", ["opid" => $opid, "ORDER" => ["id" => "DESC"], "LIMIT" => $dpremove]);
|
|
if (isset($oldpi) && !empty($oldpi)) foreach ($oldpi as $p) {
|
|
|
|
// Delete the stuff from this user
|
|
$jakdb->delete("php_imap", ["id" => $p]);
|
|
}
|
|
|
|
}
|
|
|
|
$paidunix = strtotime("+".$pack["validfor"]." days");
|
|
// get the nice time
|
|
$paidtill = date('Y-m-d H:i:s', $paidunix);
|
|
|
|
// Ok, we have removed the old stuff and now we update the user subscription table
|
|
$jakdb->update("subscriptions", ["packageid" => $pack["id"], "operators" => $pack["operators"], "departments" => $pack["departments"], "tickets" => $pack["tickets"], "blog" => $pack["blog"], "faq" => $pack["faq"], "chatwidgets" => $pack["chatwidgets"], "groupchats" => $pack["groupchats"], "operatorchat" => $pack["operatorchat"], "files" => $pack["files"], "activechats" => $pack["activechats"], "chathistory" => $pack["chathistory"], "phpimap" => $pack["phpimap"], "clients" => $pack["clients"], "islc3" => $pack["islc3"], "ishd3" => $pack["ishd3"], "validfor" => $pack["validfor"], "paygateid" => $paygateid, "subscribeid" => $subscribeid, "subscribed" => $subscribed, "planid" => $subscribe_id, "amount" => $amount, "currency" => $currency, "paidhow" => $paidhow, "paidwhen" => $jakdb->raw("NOW()"), "paidtill" => $paidtill, "trial" => 0], ["opid" => $opid]);
|
|
|
|
return true;
|
|
|
|
}
|
|
|
|
// Update Operator CC
|
|
function updateOperatorCC($opidcc, $opid, $ticketid) {
|
|
|
|
global $jakdb;
|
|
|
|
if (empty($opidcc)) {
|
|
|
|
// Delete all entries if we have none
|
|
$jakdb->delete("support_tickets_cc", ["ticketid" => $ticketid]);
|
|
} else {
|
|
|
|
// Get all operators in cc
|
|
$currentcc = $jakdb->select("support_tickets_cc", "operatorid", ["AND" => ["opid" => $opid, "ticketid" => $ticketid]]);
|
|
|
|
// We check the difference
|
|
$opccremove = array_diff($currentcc, $opidcc);
|
|
$opccadd = array_diff($opidcc, $currentcc);
|
|
|
|
// We run the foreach to remove
|
|
if (!empty($opccremove)) foreach ($opccremove as $or) {
|
|
$jakdb->delete("support_tickets_cc", ["AND" => ["opid" => $opid, "ticketid" => $ticketid, "operatorid" => $or]]);
|
|
}
|
|
|
|
if (!empty($opccadd)) foreach ($opccadd as $oa) {
|
|
$jakdb->insert("support_tickets_cc", ["opid" => $opid, "ticketid" => $ticketid, "operatorid" => $oa, "created" => $jakdb->raw("NOW()")]);
|
|
}
|
|
|
|
}
|
|
|
|
return true;
|
|
|
|
}
|
|
|
|
// Load the currency converter
|
|
function convertCurrency($apikey, $amount, $from_currency, $to_currency) {
|
|
|
|
$from_Currency = urlencode($from_currency);
|
|
$to_Currency = urlencode($to_currency);
|
|
$query = "{$from_Currency}_{$to_Currency}";
|
|
|
|
// change to the free URL if you're using the free version
|
|
$json = file_get_contents("https://free.currconv.com/api/v7/convert?q={$query}&compact=ultra&apiKey={$apikey}");
|
|
$obj = json_decode($json, true);
|
|
|
|
$val = floatval($obj["$query"]);
|
|
|
|
|
|
$total = $val * $amount;
|
|
return number_format($total, 2, '.', '');
|
|
}
|
|
?>
|
|
|