Aktuell sind 123 Gäste und keine Mitglieder online
Bitte Anmelden oder Registrieren um der Konversation beizutreten.
Bitte Anmelden oder Registrieren um der Konversation beizutreten.
<?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);
?>
Bitte Anmelden oder Registrieren um der Konversation beizutreten.
Bitte Anmelden oder Registrieren um der Konversation beizutreten.
Bitte Anmelden oder Registrieren um der Konversation beizutreten.
Bitte Anmelden oder Registrieren um der Konversation beizutreten.