STK Add-Ons - Reports

[sj04736]

As of today, you can go to http://stkaddons.net/reports/ and you will find a list of various reports (currently only files.php).

In the files report, you can find download counts for all of the uploaded files.
It should be able to fairly easily implement any other sort of report that can be generated with an sql query. Suggestions? The complete table schema is in the stkaddons svn trunk, as is the code for files.php, so you can see just how easy it is to generate these pages (queries, not so much...)

[qubodup]

Idea: all time popularity ( = dl/add_date )

Since date is missing in many submissions perhaps you could add an approximation?

[sj04736]

Idea: all time popularity ( = dl/add_date )

I can try, but I'll have to brush up on my advanced SQL and enter in all those dates (sigh, a lot of work) - no promises, but this sounds interesting enough that I'd have the motivation to follow through

[hiker]

Hi,

very interesting - thanks a lot. It seems to confirm my suspicion: players are mostly interested in more tracks, not in more karts: of the top 10 downloaded addons, 8 are tracks, only 2 are karts (and that's with 19 tracks all in all, and >40 karts - though some items are duplicated in the list).

So: more tracks please

Cheers,
Joerg

[Kinsu]

How do you think about adding some recommendations in the wiki, to tell contributors what STK needs the most currently ?

e.g. On the kart tutorial : "If you want to contribute, please also consider making tracks (link to track tutorial), as STK currently needs tracks more than karts"...

EDIT : English errror

[Funto]

Thing is, personally, I find making karts simpler, faster and maybe more fun, that might explain why people prefer to make karts (but play tracks )

[Kinsu]

Of course to start it's more easy to make a kart than a track... This is what I did too ^^
But maybe if people know STK really needs tracks right now (so there are also more chances to have a track included in the core package), and if the track tutorial is improved a little, it could be more appealing to make a -- little -- track... I think it's worth trying it

[qubodup]

does anybody happen to have layout ideas for tracks or even concept art/drawings? Posting such things might be effective at inspiring people to create tracks.

[Kinsu]

You can find ideas here and here.

[qubodup]

very interesting - thanks a lot. It seems to confirm my suspicion: players are mostly interested in more tracks, not in more karts: of the top 10 downloaded addons, 8 are tracks, only 2 are karts (and that's with 19 tracks all in all, and >40 karts - though some items are duplicated in the list).

sj04736: When the ad on counter started, were there both karts and tracks available?
hiker: I think you might be making conclusions too quickly. In total there are >33,000 kart downloads but only > 22,000 track downloads.

On the other hand there are 41 karts and 20 tracks/arenas, so perhaps the right number to look at are averages (33,000/41 karts vs 22,000/20 tracks/arenas = 805 dl each kart vs 1100 dl each track.

On the other, OTHER hand I have not considered date of addition yet..

[Crendgrim]

But maybe if people know STK really needs tracks right now (so there are also more chances to have a track included in the core package)

I still wait for Rudy's new Iceberg track being added in the core game, and I'm quite curios: Why isn't that done yet? I can see only one minor flaw with it, except from maybe its length...

[Kinsu]

Maybe also the number of polys...

[Crendgrim]

Ah, okay, don't know how many it has..

[Iridium]

I have a TON of concept track drawings that I could upload if anyone wants to see them.

[Kinsu]

Please go on ! It could help track designers to make original tracks

[sj04736]

I think the counter for tracks started slightly before the counter for karts. But only by about a day and a half (I put off karts because there were more db entries to manually modify).

I think the best solution for consistent stats would be if I wiped out everything, and set all of the file creation dates to today. That way everything is properly measurable (but we lose old stats). Right now, missing information could be a bit of an issue interpreting stats tho.

[Kinsu]

Could you backup the database before clearing it ? This way, no data loss, and we will be able to compare the 2 sets of data when it will be filled again ...

[sj04736]

Any objections? I haven't done it yet :P Waiting for feedback first

[Arthur]

I dunno, is it that important to have completely accurate numbers?
People may install and then uninstall an addon anyway, so it doesn't really tell the userbase. E.g my own track has been downloaded quite a few times, but I think many might have regretted it afterwards, and done away with it pretty quickly.

[qubodup]

instead of deleting, how about starting a new counter?

Can be done by saving the current DL in one column "dl 2011Aug12" and subtracting it from the DL count and showing that in a new column "dl since 2011Aug12"

[sj04736]

I don't know... that sounds like a really unclean way to do things. I don't really think a reset is necessary though, because the download counter came before 0.7.2 was released (before rc2 even), so you might only be ~100 downloads off at most.