getQueryLog();
$modal = openmodal('querylogsModal', "Database Query Performance Logs \n";
$modal_body .= "
SQL run#$i : ".($highlighted ? "".$sql[0]." " : "".$sql[0]." ")." seconds \n\r";
$modal_body .= "[code]".$sql[1].($sql[2] ? " [Parameters -- ".implode(',', $sql[2])." ]" : '')."[/code]\n\r";
$modal_body .= "
\n";
$end_sql = end($sql[3]);
$modal_body .= "
".$end_sql['file']." Line #".$end_sql['line'].", ".$end_sql['function']." -
Toggle Backtrace \n";
if (is_array($sql[3])) {
$modal_body .= "
";
foreach ($sql[3] as $id => $debug_backtrace) {
$modal_body .= "Stack Trace #$id - ".$debug_backtrace['file']." @ Line ".$debug_backtrace['line']." [$key] => $value, ";
}
$debug_param .= "$debug_line".($debug_param ?: "--")."
\n";
}
$modal_body .= "
\n";
$modal_body .= "
Total Time Expended in ALL SQL Queries: ".$time." seconds PHP-Fusion Copyright © ".date("Y")." PHP-Fusion Inc";
$res .= ($nobreak ? " " : "GNU Affero GPL v3.\n";
return $res;
}
function showcounter() {
$locale = fusion_get_locale();
$settings = fusion_get_settings();
if ($settings['visitorcounter_enabled']) {
return "".number_format($settings['counter'])." ".($settings['counter'] == 1 ? $locale['global_170'] : $locale['global_171']);
} else {
return "";
}
}
function showprivacypolicy() {
$html = '';
if (!empty(fusion_get_settings('privacy_policy'))) {
$html .= "".fusion_get_locale('global_176')." ";
$modal = openmodal('privacy_policy', fusion_get_locale('global_176'), ['button_id' => 'privacy_policy']);
$modal .= parse_textarea(\PHPFusion\QuantumFields::parse_label(fusion_get_settings('privacy_policy')));
$modal .= closemodal();
add_to_footer($modal);
}
return $html;
}
/**
* Creates an alert bar
*
* @param $title
* @param array $options
*
* @return string
*/
if (!function_exists("alert")) {
function alert($title, array $options = []) {
$options += [
"class" => !empty($options['class']) ? $options['class'] : 'alert-danger',
"dismiss" => !empty($options['dismiss']) && $options['dismiss'] == TRUE ? TRUE : FALSE
];
if ($options['dismiss'] == TRUE) {
$html = "× $title
";
} else {
$html = "$title
";
}
add_to_jquery("$('div.alert a').addClass('alert-link');");
return $html;
}
}
// Get the widget settings for the theme settings table
if (!function_exists('get_theme_settings')) {
function get_theme_settings($theme_folder) {
$settings_arr = [];
$set_result = dbquery("SELECT settings_name, settings_value FROM ".DB_SETTINGS_THEME." WHERE settings_theme=:themeset", [':themeset' => $theme_folder]);
if (dbrows($set_result)) {
while ($set_data = dbarray($set_result)) {
$settings_arr[$set_data['settings_name']] = $set_data['settings_value'];
}
return $settings_arr;
} else {
return FALSE;
}
}
}
/**
* Java script that transform html table sortable
*
* @param $table_id - table ID
*
* @return string
*/
function fusion_sort_table($table_id) {
add_to_footer("\n");
add_to_jquery("$('#".$table_id."').tablesorter();");
return "tablesorter";
}
if (!function_exists("label")) {
function label($label, array $options = []) {
$options += [
"class" => !empty($array['class']) ? $array['class'] : '',
"icon" => !empty($array['icon']) ? "".$options['icon'].$label." \n";
}
}
if (!function_exists("badge")) {
function badge($label, array $options = []) {
$options += [
"class" => !empty($array['class']) ? $array['class'] : "",
"icon" => !empty($array['icon']) ? "".$options['icon'].$label." \n";
}
}
if (!function_exists("openmodal") && !function_exists("closemodal") && !function_exists("modalfooter")) {
/**
* To get the best results for Modal z-index overlay, try :
* ob_start();
* ... insert and echo ...
* add_to_footer(ob_get_contents()).ob_end_clean();
*/
/**
* Generate modal
*
* @param $id - unique CSS id
* @param $title - modal title
* @param array $options
*
* @return string
*/
function openmodal($id, $title, $options = []) {
$locale = fusion_get_locale();
$options += [
'class' => !empty($options['class']) ?: 'modal-lg',
'button_id' => '',
'button_class' => '',
'static' => FALSE,
'hidden' => FALSE, // force a modal to be hidden at default, you will need a jquery trigger $('#your_modal_id').modal('show'); manually
];
$modal_trigger = '';
if (!empty($options['button_id']) || !empty($options['button_class'])) {
$modal_trigger = !empty($options['button_id']) ? "#".$options['button_id'] : ".".$options['button_class'];
}
if ($options['static'] && !empty($modal_trigger)) {
OutputHandler::addToJQuery("$('".$modal_trigger."').bind('click', function(e){ $('#".$id."-Modal').modal({backdrop: 'static', keyboard: false}).modal('show'); e.preventDefault(); });");
} else if ($options['static'] && empty($options['button_id'])) {
OutputHandler::addToJQuery("$('#".$id."-Modal').modal({ backdrop: 'static', keyboard: false }).modal('show');");
} else if ($modal_trigger && empty($options['static'])) {
OutputHandler::addToJQuery("$('".$modal_trigger."').bind('click', function(e){ $('#".$id."-Modal').modal('show'); e.preventDefault(); });");
} else {
if (!$options['hidden']) {
OutputHandler::addToJQuery("$('#".$id."-Modal').modal('show');");
}
}
$html = '';
$html .= "\n";
$html .= "
\n";
$html .= "
\n";
if ($title) {
$html .= "\n";
}
$html .= "
\n";
return $html;
}
/**
* Adds a modal footer in between openmodal and closemodal.
*
* @param $content
* @param bool|FALSE $dismiss
*
* @return string
*/
function modalfooter($content, $dismiss = FALSE) {
$html = "
\n\n
\n
\n
\n";
$cNum .= "
\n";
$cNum .= "".$c2Title." ".$value."
\n";
$chtml .= "\n";
$chtml .= "
\n";
$i++;
}
$html .= ($options['hide_info'] == FALSE ? "$cTitle $cNum
\n" : "");
$html .= "\n";
$html .= $chtml;
$html .= "
\n";
$html .= "\n";
} else {
$int = intval($num);
if ($options['disabled'] == TRUE) {
$num = "∞";
} else {
$num = $num > 0 ? $num.' ' : '0 ';
$num .= $options['as_percent'] ? '%' : '';
}
$auto_class = bar_color($int, $options['reverse']);
$class = (!$options['class']) ? $auto_class : $options['class'];
$html .= ($options['hide_info'] === FALSE ? "$title $num
\n" : "");
$html .= "\n";
$html .= "
\n";
$html .= "
".profile_link($info['user_id'], $info['user_name'], $info['user_status'])." ";
$res .= $locale['global_071'].showdate("newsdate", $info['news_date']);
$res .= $info['news_ext'] == "y" || $info['news_allow_comments'] ? $sep."\n" : "\n";
return "".$res;
}
}
if (!function_exists("newsopts")) {
function newsopts($info, $sep, $class = "") {
$locale = fusion_get_locale();
$res = "";
$link_class = $class ? "class='$class'" : "";
if (!isset($_GET['readmore']) && $info['news_ext'] == "y") {
$res = "".$locale['global_072']." ".$sep." ";
}
if ($info['news_allow_comments'] && fusion_get_settings('comments_enabled') == "1") {
$res .= "".$info['news_comments'].($info['news_comments'] == 1 ? $locale['global_073b'] : $locale['global_073'])." ".$sep." ";
}
if ($info['news_ext'] == "y" || ($info['news_allow_comments'] && fusion_get_settings('comments_enabled') == "1")) {
$res .= $info['news_reads'].$locale['global_074']."\n ".$sep;
}
$res .= "".$info['cat_name']." ";
} else {
$res .= "".$locale['global_080']." ";
}
return "".$res." $sep ";
}
}
if (!function_exists("articleposter")) {
function articleposter($info, $sep = "", $class = "") {
$locale = fusion_get_locale();
$link_class = $class ? "class='$class'" : "";
$res = THEME_BULLET." ".$locale['global_070']."".profile_link($info['user_id'], $info['user_name'], $info['user_status'])." \n";
$res .= $locale['global_071'].showdate("newsdate", $info['article_date']);
$res .= ($info['article_allow_comments'] && fusion_get_settings('comments_enabled') == "1" ? $sep."\n" : "\n");
return "".$res;
}
}
if (!function_exists("articleopts")) {
function articleopts($info, $sep) {
$locale = fusion_get_locale();
$res = "";
if ($info['article_allow_comments'] && fusion_get_settings('comments_enabled') == "1") {
$res = "".$info['article_comments'].($info['article_comments'] == 1 ? $locale['global_073b'] : $locale['global_073'])." ".$sep."\n";
}
$res .= $info['article_reads'].$locale['global_074']." ".$sep."\n";
$res .= "".$info['cat_name']." ";
} else {
$res .= "".$locale['global_080']." ";
}
return "".$res." $sep ";
}
}
if (!function_exists("itemoptions")) {
function itemoptions($item_type, $item_id) {
$locale = fusion_get_locale();
$res = "";
if ($item_type == "N") {
if (iADMIN && checkrights($item_type)) {
$res .= " · '.$first_char.'
';
}
}
return $link ? sprintf("%s ", $img) : $img;
}
}
function stringToColorCode($text) {
$min_brightness = 50; // integer between 0 and 100
$spec = 3; // integer between 2-10, determines how unique each color will be
$hash = sha1(md5(sha1($text)));
$colors = [];
for ($i = 0; $i < 3; $i++) {
$colors[$i] = max([round(((hexdec(substr($hash, $spec * $i, $spec))) / hexdec(str_pad('', $spec, 'F'))) * 255), $min_brightness]);
}
if ($min_brightness > 0) {
while (array_sum($colors) / 3 < $min_brightness) {
for ($i = 0; $i < 3; $i++) {
$colors[$i] += 10;
}
}
}
$output = '';
for ($i = 0; $i < 3; $i++) {
$output .= str_pad(dechex($colors[$i]), 2, 0, STR_PAD_LEFT);
}
return $output;
}
function get_brightness($hex) {
$hex = str_replace('#', '', $hex);
$r = hexdec(substr($hex, 0, 2));
$g = hexdec(substr($hex, 2, 2));
$b = hexdec(substr($hex, 4, 2));
return (($r * 299) + ($g * 587) + ($b * 114)) / 1000;
}
if (!function_exists('colorbox')) {
function colorbox($img_path, $img_title, $responsive = TRUE, $class = '', $as_text = FALSE) {
if (!defined('COLORBOX')) {
define('COLORBOX', TRUE);
$colorbox_css = file_exists(THEME.'colorbox/colorbox.css') ? THEME.'colorbox/colorbox.css' : INCLUDES.'jquery/colorbox/colorbox.css';
add_to_head("".($as_text ? $img_title : " ";
}
}
/**
* Thumbnail function
*
* @param $src
* @param $size
* @param bool $url
* @param bool $colorbox
* @param bool $responsive
* @param string $class
*
* @return string
*/
if (!function_exists("thumbnail")) {
function thumbnail($src, $size, $url = FALSE, $colorbox = FALSE, $responsive = TRUE, $class = "m-2") {
$_offset_w = 0;
$_offset_h = 0;
if (!$responsive && $src) {
// get the size of the image and centrally aligned it
$image_info = @getimagesize($src);
$width = $image_info[0];
$height = $image_info[1];
$_size = explode('px', $size);
if ($width > $_size[0]) {
$_offset_w = floor($width - $_size[0]) * 0.5;
} // get surplus and negative by half.
if ($height > $_size[0]) {
$_offset_h = ($height - $_size[0]) * 0.5;
} // get surplus and negative by half.
}
$html = "\n";
if ($colorbox && $src && !defined('colorbox')) {
define('colorbox', TRUE);
add_to_head("Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum aliquam felis nunc, in dignissim metus suscipit eget. Nunc scelerisque laoreet purus, in ullamcorper magna sagittis eget. Aliquam ac rhoncus orci, a lacinia ante. Integer sed erat ligula. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce ullamcorper sapien mauris, et tempus mi tincidunt laoreet. Proin aliquam vulputate felis in viverra.
\n";
$text .= "Duis sed lorem vitae nibh sagittis tempus sed sed enim. Mauris egestas varius purus, a varius odio vehicula quis. Donec cursus interdum libero, et ornare tellus mattis vitae. Phasellus et ligula velit. Vivamus ac turpis dictum, congue metus facilisis, ultrices lorem. Cras imperdiet lacus in tincidunt pellentesque. Sed consectetur nunc vitae fringilla volutpat. Mauris nibh justo, luctus eu dapibus in, pellentesque non urna. Nulla ullamcorper varius lacus, ut finibus eros interdum id. Proin at pellentesque sapien. Integer imperdiet, sapien nec tristique laoreet, sapien lacus porta nunc, tincidunt cursus risus mauris id quam.
\n";
$text .= "Ut vulputate mauris in facilisis euismod. Ut id libero vitae neque laoreet placerat a id mi. Integer ornare risus placerat, interdum nisi sed, commodo ligula. Integer at ipsum id magna blandit volutpat. Sed euismod mi odio, vitae molestie diam ornare quis. Aenean id ligula finibus, convallis risus a, scelerisque tellus. Morbi quis pretium lectus. In convallis hendrerit sem. Vestibulum sed ultricies massa, ut tempus risus. Nunc aliquam at tellus quis lobortis. In hac habitasse platea dictumst. Vestibulum maximus, nibh at tristique viverra, eros felis ultrices nunc, et efficitur nunc augue a orci. Phasellus et metus mauris. Morbi ut ex ut urna tincidunt varius eu id diam. Aenean vestibulum risus sed augue vulputate, a luctus ligula laoreet.
\n";
$text .= "Nam tempor sodales mi nec ullamcorper. Mauris tristique ligula augue, et lobortis turpis dictum vitae. Aliquam leo massa, posuere ac aliquet quis, ultricies eu elit. Etiam et justo et nulla cursus iaculis vel quis dolor. Phasellus viverra cursus metus quis luctus. Nulla massa turpis, porttitor vitae orci sed, laoreet consequat urna. Etiam congue turpis ac metus facilisis pretium. Nam auctor mi et auctor malesuada. Mauris blandit nulla quis ligula cursus, ut ullamcorper dui posuere. Fusce sed urna id quam finibus blandit tempus eu tellus. Vestibulum semper diam id ante iaculis iaculis.
\n";
$text .= "Fusce suscipit maximus neque, sed consectetur elit hendrerit at. Sed luctus mi in ex auctor mollis. Suspendisse ac elementum tellus, ut malesuada purus. Mauris condimentum elit at dolor eleifend iaculis. Aenean eget faucibus mauris. Pellentesque fermentum mattis imperdiet. Donec mattis nisi id faucibus finibus. Vivamus in eleifend lorem, vel dictum nisl. Morbi ut mollis arcu.
\n";
return trim_text($text, $length);
}
}
if (!function_exists("timer")) {
function timer($updated = FALSE) {
$locale = fusion_get_locale();
if (!$updated) {
$updated = time();
}
$updated = stripinput($updated);
$current = time();
$calculated = $current - $updated;
$second = 1;
$minute = $second * 60;
$hour = $minute * 60;
$day = 24 * $hour;
$month = days_current_month() * $day;
$year = (date("L", $updated) > 0) ? 366 * $day : 365 * $day;
if ($calculated < 1) {
return "".$locale['just_now']." \n";
}
// $timer = array($year => $locale['year'], $month => $locale['month'], $day => $locale['day'], $hour => $locale['hour'], $minute => $locale['minute'], $second => $locale['second']);
// $timer_b = array($year => $locale['year_a'], $month => $locale['month_a'], $day => $locale['day_a'], $hour => $locale['hour_a'], $minute => $locale['minute_a'], $second => $locale['second_a']);
$timer = [
$year => $locale['fmt_year'],
$month => $locale['fmt_month'],
$day => $locale['fmt_day'],
$hour => $locale['fmt_hour'],
$minute => $locale['fmt_minute'],
$second => $locale['fmt_second']
];
foreach ($timer as $arr => $unit) {
$calc = $calculated / $arr;
if ($calc >= 1) {
$answer = round($calc);
// $string = ($answer > 1) ? $timer_b[$arr] : $unit;
$string = \PHPFusion\Locale::format_word($answer, $unit, ['add_count' => FALSE]);
return "".$answer." ".$string." ".$locale['ago']." ";
}
}
return NULL;
}
}
if (!function_exists("days_current_month")) {
function days_current_month() {
$year = showdate("%Y", time());
$month = showdate("%m", time());
return $month == 2 ? ($year % 4 ? 28 : ($year % 100 ? 29 : ($year % 400 ? 28 : 29))) : (($month - 1) % 7 % 2 ? 30 : 31);
}
}
if (!function_exists("countdown")) {
function countdown($time) {
$locale = fusion_get_locale();
$updated = stripinput($time);
$second = 1;
$minute = $second * 60;
$hour = $minute * 60;
$day = 24 * $hour;
$month = days_current_month() * $day;
$year = (date("L", $updated) > 0) ? 366 * $day : 365 * $day;
$timer = [
$year => $locale['year'],
$month => $locale['month'],
$day => $locale['day'],
$hour => $locale['hour'],
$minute => $locale['minute'],
$second => $locale['second']
];
$timer_b = [
$year => $locale['year_a'],
$month => $locale['month_a'],
$day => $locale['day_a'],
$hour => $locale['hour_a'],
$minute => $locale['minute_a'],
$second => $locale['second_a']
];
foreach ($timer as $arr => $unit) {
$calc = $updated / $arr;
if ($calc >= 1) {
$answer = round($calc);
$string = ($answer > 1) ? $timer_b[$arr] : $unit;
return "$answer ".$string." ";
}
}
if (!isset($answer)) {
return "".$locale['now']." ";
}
}
}
if (!function_exists("opencollapse")
&& !function_exists("opencollapsebody")
&& !function_exists("closecollapsebody")
&& !function_exists("collapse_header_link")
&& !function_exists("collapse_footer_link")
&& !function_exists("closecollapse")
) {
/**
* Accordion template
*
* @param $id - unique accordion id name
*
* @return string
*/
function opencollapse($id) {
return "\n";
}
function opencollapsebody($title, $unique_id, $grouping_id, $active = 0, $class = FALSE) {
$html = "
\n";
$html .= "
\n";
$html .= "
\n";
$html .= "
\n";
$html .= "
\n"; // body.
return $html;
}
function closecollapsebody() {
$html = "
\n"; // panel container
$html .= "
\n"; // panel default
return $html;
}
function collapse_header_link($id, $title, $active, $class = '') {
$active = ($active) ? '' : 'collapsed';
$title_id_cc = preg_replace('/[^A-Z0-9-]+/i', "-", $title);
return "class='$class $active' data-toggle='collapse' data-parent='#".$id."' href='#".$title_id_cc."-".$id."' aria-expanded='true' aria-controls='".$title_id_cc."-".$id."'";
}
function collapse_footer_link($id, $title, $active, $class = '') {
$active = ($active) ? 'in' : '';
$title_id_cc = preg_replace('/[^A-Z0-9-]+/i', "-", $title);
return "id='".$title_id_cc."-".$id."' class='panel-collapse collapse ".$active." ".$class."' role='tabpanel' aria-labelledby='headingOne'";
}
function closecollapse() {
return "
\n";
$html .= "
\n";
foreach ($tab_title['title'] as $arr => $v) {
$v_title = $v;
$tab_id = $tab_title['id'][$arr];
$icon = (isset($tab_title['icon'][$arr])) ? $tab_title['icon'][$arr] : "";
$link_url = '#';
if ($link) {
$link_url = $link.(stristr($link, '?') ? '&' : '?').$getname."=".$tab_id; // keep all request except GET array
if ($link === TRUE) {
$link_url = clean_request($getname.'='.$tab_id.(defined('ADMIN_PANEL') ? "&aid=".$_GET['aid'] : ""), $getArray, FALSE);
}
$html .= ($link_active_arrkey == $tab_id) ? "\n" : " \n";
} else {
$html .= ($link_active_arrkey == "".$tab_id) ? " \n" : " \n";
}
$html .= "\n".($icon ? " \n";
$html .= " \n";
}
$html .= " \n";
$html .= "
\n";
if (empty($link) && $this->remember) {
if (!defined('JS_COOKIES')) {
define('JS_COOKIES', TRUE);
OutputHandler::addToFooter('');
}
OutputHandler::addToJQuery("
$('#".$id." > li').on('click', function() {
var cookieName = '".$this->cookie_name."';
var cookieValue = $(this).find(\"a[role='tab']\").attr('id');
Cookies.set(cookieName, cookieValue);
});
var cookieName = 'tab_js-".$id."';
if (Cookies.get(cookieName)) {
$('#".$id."').find('#'+Cookies.get(cookieName)).click();
}
");
}
return (string)$html;
}
/*
* Deprecated $tab_title.
* Deprecated $link
*
* Commit title:
* Using globals without adding parameter to pass $id set on previous opentabs() to next opentabbody()
*/
public function opentabbody($id, $link_active_arrkey = FALSE, $key = FALSE) {
$key = $key ? $key : 'section';
$bootstrap = defined('BOOTSTRAP4') ? ' show' : '';
if (isset($_GET[$key]) && $this->link_mode) {
if ($link_active_arrkey == $id) {
$status = 'in active'.$bootstrap;
} else {
$status = '';
}
} else {
if (!$this->link_mode) {
if ($this->remember) {
if (isset($_COOKIE[$this->cookie_name])) {
$link_active_arrkey = str_replace('tab-', '', $_COOKIE[$this->cookie_name]);
}
}
}
$status = ($link_active_arrkey == $id ? " in active".$bootstrap : '');
}
return "
\n";
}
public function closetab(array $options = []) {
$locale = fusion_get_locale();
$default_options = [
"tab_nav" => FALSE,
];
$options += $default_options;
if ($options['tab_nav'] == TRUE) {
$nextBtn = "
".$locale['next']." ";
$prevBtn = "
".$locale['previous']." ";
OutputHandler::addToJQuery("
$('.btnNext').click(function(){
$('.nav-tabs > .active').next('li').find('a').trigger('click');
});
$('.btnPrevious').click(function(){
$('.nav-tabs > .active').prev('li').find('a').trigger('click');
});
");
echo "
\n".$prevBtn.$nextBtn."
\n";
}
return "
\n
\n";
}
public function closetabbody() {
return "