echo '</td>';
echo '<td>';
echo '<a class="video_link" href="#" id="video_link" data-type="textarea" data-pk="' . $rank . '" data-url="mysql_chart_update.php" data-title="Edit official Video link">' . $value['video_link'] . '</a>';
echo '<a href="' . $value['video_link'] . '" target="_blank"><span class="glyphicon icon-link-widgetapi"></span></a>';
echo '</td>';
echo '</tr>';
$rank++;
}
echo '</tbody>';
echo '</table>';
echo '<script type="text/javascript">
$(document).ready(function(){ ';
echo '$(\'.itunes_link\').editable({params: {\'modid\': \'101\',\'tunit\': \'W\',\'tkey\': \'' . get_max_default_key() . '\'}});';
echo '$(\'.amazon_phys_link\').editable({params: {\'modid\': \'101\',\'tunit\': \'W\',\'tkey\': \'' . get_max_default_key() . '\'}});';
echo '$(\'.amazon_dwn_link\').editable({params: {\'modid\': \'101\',\'tunit\': \'W\',\'tkey\': \'' . get_max_default_key() . '\'}});';
echo '$(\'.video_link\').editable({params: {\'modid\': \'101\',\'tunit\': \'W\',\'tkey\': \'' . get_max_default_key() . '\'}});';
echo '});
</script>';
/**
END Manage Charts Tab
*/
}
?>
</div>
</div>
</div>
<!--Exa get new Charts Tab -->
<div class="tab-pane " ng-class="exasolTab">
<div class="row">
<div class="col-md-12">
<h4>
function get_chart($modul_id = 101, $time_unit = 'W', $time_key = 0)
{
global $mysql_db_dsn;
$mysql_db = MDB2::connect($mysql_db_dsn);
if (MDB2::isError($mysql_db)) {
die($mysql_db->getMessage());
}
$time_key = $time_key == 0 ? get_max_default_key() : $time_key;
$ar = array();
$query = "SELECT * FROM `GE_CHART` WHERE modul_id = {$modul_id} and time_unit = '" . $time_unit . "' and time_key = " . $time_key . " ORDER BY rank asc";
$quid = $mysql_db->query($query);
if (MDB2::isError($quid)) {
die("Error in query: " . $query);
} else {
while ($row = $quid->fetchRow(MDB2_FETCHMODE_ASSOC)) {
$ar[] = array('rank' => $row['rank'], 'titel' => $row['titel'], 'artist' => $row['artist'], 'itunes_link' => $row['itunes_link'], 'amazon_phys_link' => $row['amazon_phys_link'], 'amazon_dwn_link' => $row['amazon_dwn_link'], 'video_link' => $row['video_link']);
}
return $ar;
}
$mysql_db->disconnect();
}
