Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
<?php
defined('_JEXEC') or die('Restricted access');
$lib = JPATH_ROOT . "/php-apps/RGraph/lib/rgraph_chart.php";
require_once ($lib);
$db_config_file = $_SERVER["DOCUMENT_ROOT"] . "/configuration.php";
$sql="SELECT
title,
round(substr(extra_fields,
((locate('{qqidqq:qq29qq,qqvalueqq:qq',extra_fields))+(char_length('{qqidqq:qq29qq,qqvalueqq:qq'))),
((locate('qq}',extra_fields,((locate('{qqidqq:qq29qq,qqvalueqq:qq',extra_fields)+(char_length('{qqidqq:qq29qq,qqvalueqq:qq'))))))-(locate('{qqidqq:qq29qq,qqvalueqq:qq',extra_fields))-(char_length('{qqidqq:qq29qq,qqvalueqq:qq')))
))
as final
FROM umhtg_k2_items where substr(extra_fields,
((locate('{qqidqq:qq29qq,qqvalueqq:qq',extra_fields))+(char_length('{qqidqq:qq29qq,qqvalueqq:qq'))),
((locate('qq}',extra_fields,((locate('{qqidqq:qq29qq,qqvalueqq:qq',extra_fields)+(char_length('{qqidqq:qq29qq,qqvalueqq:qq'))))))-(locate('{qqidqq:qq29qq,qqvalueqq:qq',extra_fields))-(char_length('{qqidqq:qq29qq,qqvalueqq:qq')))
) >1
order by
cast(substr(extra_fields,
((locate('{qqidqq:qq29qq,qqvalueqq:qq',extra_fields))+(char_length('{qqidqq:qq29qq,qqvalueqq:qq'))),
((locate('qq}',extra_fields,((locate('{qqidqq:qq29qq,qqvalueqq:qq',extra_fields)+(char_length('{qqidqq:qq29qq,qqvalueqq:qq'))))))-(locate('{qqidqq:qq29qq,qqvalueqq:qq',extra_fields))-(char_length('{qqidqq:qq29qq,qqvalueqq:qq')))) as decimal) desc";
$sql = str_replace('qq', '"', $sql);
$dbdata = rgraph_chart::getDataFromDB($db_config_file, $sql);
$data = array("labels"=>$dbdata[0], "data"=>$dbdata[1]);
echo json_encode($data);
?>
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.