Actually, using foo_playlist_tree, I was able to squeeze the Hotness code into a single line to be put in the "Population Order" field of a query.
This is very rough, and the first 200 or so characters will have to be customized to fit your statistics tag names, but I'll paste it anyway.
$puts(baselinefrequency,45)$puts(baselinedecay,28)$puts(lp,[%last_played_ci%])$puts(fp,[%first_played_ci%])$puts(pc,[%play_count_ci%])$puts(rating,[%rating%])$puts(avgrating,3)$puts(baselinefrequency,$mul($get(baselinefrequency),24))$puts(baselinedecay,$mul($get(baselinedecay),24))$puts(lp_age,$add($substr($get(lp),12,13),$mul(24,$cwb_datediff($get(lp),2000-01-01))))$puts(fp_age,$add($substr($get(fp),12,13),$mul(24,$cwb_datediff($get(fp),2000-01-01))))$puts(age,$sub($get(lp_age),$get(fp_age)))$puts(now_age,$add($substr(%cwb_systemdatetime%,12,13),$mul(24,$cwb_datediff(%cwb_systemdate%,2000-01-01))))$puts(recentness,$sub($get(now_age),$get(lp_age)))$puts(decay,$div($div($mul($get(pc),$get(baselinefrequency),$get(baselinedecay),$if2($get(rating),$get(avgrating)),100),$mul($max($get(age),$get(baselinefrequency)),$get(avgrating))),100))$puts(rawhotness,$div($mul($max($sub($get(decay),$get(recentness)),0),1000),$get(decay)))$puts(forecast,$div($mul($max($sub($get(decay),$add($div($max(0,$sub($get(baselinedecay),$get(recentness))),2),$get(recentness))),0),1000),$get(decay)))$num($div($add($get(rawhotness),$get(forecast)),2),4)
I plan to update the Hotness thread with this code as well, and make it a little more friendly.
Topic: Autoplaylist: Sort by Hotness? (Read 3085 times)
previous topic - next topic