Ich habe aus Zeile 88 der charts.php
Code: Alles auswählen
$sql = 'SELECT chart_id, chart_hot, chart_not, chart_song_name, chart_artist, chart_album, chart_last_pos, chart_best_pos, username FROM '.CHARTS_TABLE.', '.USERS_TABLE.' WHERE chart_poster_id=user_id ORDER BY (chart_hot-chart_not) DESC, chart_not ASC, chart_artist LIMIT 0,'.$v_num;
Code: Alles auswählen
ORDER BY (chart_hot-chart_not) DESC, chart_not ASC, chart_artist LIMIT 0,'.$v_num;
Code: Alles auswählen
$sql = 'SELECT chart_id, chart_hot, chart_not, chart_song_name, chart_artist, chart_album, chart_last_pos, chart_best_pos, username FROM '.CHARTS_TABLE.', '.USERS_TABLE.' WHERE chart_poster_id=user_id';