Original Message                 Date: 25-May-02  @  12:13 PM   -   ++chartvote updated++

k

Posts: 12353

Link?:  Link
File?:  No file

ok ahem... you'll notice the frontpage chart has suddenly changed a bit, i fixed it - sorry it took time, but other stuff has been more important... anyways i sat down this morning with a a quality bazooka and spent a few hours trying to re-write the query & cracked it finaly by luck - it was a very complicated sql query for me at least anyways - to join 3 tables, count & total the totalvotes per listed unique track_id but only within a certain date range & group all included output columns ordered by counted totalvotes per id number... g-gulp!

anyways it's sorted & yes, KIKI is still at the top, but that is because it IS actualy getting regular votes every day, but without giving away the figures it'll only take a few extra votes cast for one of it's challengers to knock it off the top now.

___________________________________

I had an idea for a script once. It's basically Jaws except when the guys in the boat are going after Jaws, they look around and there's an even bigger Jaws. The guys have to team up with Jaws to get Bigger Jaws.... I call it... Big Jaws!!!

[ back to forum ]                           [quote]

Message 31/42                 Date: 28-May-02  @  08:45 PM   -   RE: ++chartvote updated++

Breakerbox

Posts: 426

Link?: Link

File?:  No file

HEY K! great job you are doing with the site.. I appreciate it a lot...
Here is an Idea.. Would it be possible to put a link/button of some sort right next to the top 20, that will stream the top 20 to your computer... but not on media player, winamp, etc.. but when you click on it it opens a java app that streams the track with the name and the link to traCK webpage and tell you where it is on the chart and lets you vote for it in the same window and it shold have Skip track maybe FF,RWN functions... So it can play the top 20 or maybe random tracks fro genres in DT or just random.. and if the user likes it he can vote for it or not, if he skips it, it plays another track, etc..
Actually this sounds kinda hard to implement.. well I dont shit anyway..
Just an idea.

[ back to forum ]               [quote]

Message 32/42                 Date: 28-May-02  @  09:31 PM   -   RE: ++chartvote updated++

Maarten

Posts: 2082

Link?: Link

File?:  No file

hehe, I said "Ack!" and I though you thought I got kicked by wooden sh.... ah, forget it...  

[ back to forum ]               [quote]

Message 33/42                 Date: 29-May-02  @  12:23 PM   -   RE: ++chartvote updated++

k

Posts:

Link?:  No link

File?:  No file

ing GREAT idea Breakerbox !!! - now THAT is what I call 'creative imagineering' !!   lol!

[ back to forum ]               [quote]

Message 34/42                 Date: 29-May-02  @  04:16 PM   -   RE: ++chartvote updated++

k

Posts:

Link?:  No link

File?:  No file

ok you now have a likkle movment thing... no flaming icons tho sorry  

[ back to forum ]               [quote]

Message 35/42                 Date: 29-May-02  @  05:08 PM   -   RE: ++chartvote updated++

Maarten

Posts: 2082

Link?: Link

File?:  No file

Yay! My arow is green!  >?

[ back to forum ]               [quote]

Message 36/42                 Date: 29-May-02  @  08:28 PM   -   RE: ++chartvote updated++

xoxos

Posts: 6231

Link?: Link

File?:  No file

i could do like convoluting toroid forms that sput out orange blobs for each vote if you're not stuck on arrows.

[ back to forum ]               [quote]

Message 37/42                 Date: 29-May-02  @  10:24 PM   -   RE: ++chartvote updated++

sitar

Posts: 3872

Link?:  Link

File?:  No file

LOL!

[ back to forum ]               [quote]

Message 38/42                 Date: 08-Jun-02  @  08:32 PM   -   RE: ++chartvote updated++

admin

Posts: 11382

Link?:  No link

File?:  No file

ok done another update, this is the last and now it should be more precise.

It needs a few days to add the new data - each track in the chart needs one more vote to set the feild before we can reset the chart.

After that it can show total position moves from the last vote previous position to the current 'post-new-vote' position, grand total votes, highest position achieved, and votes in last 7 days.

___________________________________

"In other countries, art and literature are left to a lot of shabby bums living in attics and feeding on booze and spaghetti, but in America the successful writer or picture-painter is indistinguishable from any other decent business man!" - Babbit

[ back to forum ]               [quote]

Message 39/42                 Date: 12-Jun-02  @  03:08 PM   -   RE: ++chartvote updated++

k

Posts: 12353

Link?: Link

File?:  No file

still tweaking the chart - we need to wait until some of the older tracks get a new vote to add-in the necessary starting default parameters for the maths calculations, but here's the big MAIN chart which is partly fixed and shows more accuracy - the front-page chart will be updated the same soon and will show more accuracy for tracks re-entering chart which were previously there but went out and back in again...

___________________________________

I had an idea for a script once. It's basically Jaws except when the guys in the boat are going after Jaws, they look around and there's an even bigger Jaws. The guys have to team up with Jaws to get Bigger Jaws.... I call it... Big Jaws!!!

[ back to forum ]               [quote]

Message 40/42                 Date: 12-Jun-02  @  03:22 PM   -   RE: ++chartvote updated++

Maarten

Posts: 2082

Link?: Link

File?:  No file

Cool... now go vote for my older tracks for progress to follow! ;)

[ back to forum ]               [quote]