VGMdb
Go Back   VGMdb Forums > VGMdb Site Related > Questions and Comments
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old Jul 11, 2012, 04:39 PM
Phonograph's Avatar
Phonograph Phonograph is offline
Senior Member
 
Join Date: Jun 2010
Posts: 4,329
Default about site stats / user stats

while discussing with dag on the chat, I discovered something strange about statistics, for example

New Tracklists
site stats: 1547 (Phonograph)
user stats: 412

I'd like to know how stats work, because dag spoke about stats and after checking mine I saw the difference

edit: maybe site stats count deleted tracklists but not user stats?

Last edited by Phonograph; Jul 11, 2012 at 04:44 PM.
Reply With Quote
  #2  
Old Jul 11, 2012, 04:54 PM
Dag's Avatar
Dag Dag is offline
VGMdb Advisor
 
Join Date: Dec 2007
Posts: 1,348
Default

I have "Scan Metadata Edits: 0 | | ", something funny is going on.
Reply With Quote
  #3  
Old Jul 11, 2012, 04:58 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,242
Default

See if it's fixed now.

Originally, it counted items in the moderation queue, but the tally for staff and trusted editors was wrong because they bypass the queue. I later remedied that by just counting what's in the database for them. That's more accurate except it misses anything that was deleted. The tracklists that were missing were the ones you submitted while you had the elevated account privilege.

It doesn't make sense to use both ways, so I just modified it so that it always counts the data instead of the queue.
Reply With Quote
  #4  
Old Jul 11, 2012, 05:04 PM
Phonograph's Avatar
Phonograph Phonograph is offline
Senior Member
 
Join Date: Jun 2010
Posts: 4,329
Default

nothing changed to me (if you spoke to me about whether it's fixed)
Reply With Quote
  #5  
Old Jul 11, 2012, 05:08 PM
Dag's Avatar
Dag Dag is offline
VGMdb Advisor
 
Join Date: Dec 2007
Posts: 1,348
Default

Looks the same to me too, "Scan Metadata Edits 0" and all (I'm pretty sure I edited a bunch of captions in the past, i've editted some album now and nothing).

Maybe it's not taking into account anime or something?

(not sure about the rest of the stats)

Last edited by Dag; Jul 11, 2012 at 05:14 PM.
Reply With Quote
  #6  
Old Jul 11, 2012, 05:13 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,242
Default

I fixed 3 different bugs on the profile stats, but I think I may need to re-generate some kind of cached data from the user profiles.
Reply With Quote
  #7  
Old Jul 11, 2012, 05:31 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,242
Default

I don't see any way to rebuild the cache, but your next VGMdb submission will force an update and fix the numbers. Besides the problem above, I also fixed the Scan Metadata field (was missing most of them), and the Org Edit field (was always zero).

EDIT -- Dag's looks fixed now. It must refresh on a timer.
Reply With Quote
  #8  
Old Jul 11, 2012, 05:42 PM
Phonograph's Avatar
Phonograph Phonograph is offline
Senior Member
 
Join Date: Jun 2010
Posts: 4,329
Default

it has changed my stats, and now it has uneven numbers (bleh I hate uneven numbers, will have to submit again to round the shit :/)

I give 9 new artists, 7 artist edits and 2 new artist images to whom wants
Reply With Quote
  #9  
Old Jul 11, 2012, 06:17 PM
Phonograph's Avatar
Phonograph Phonograph is offline
Senior Member
 
Join Date: Jun 2010
Posts: 4,329
Default

is Approved become Approved+Pending (-> Total) ?
because I had 1547 new tracklists added, so to get 1548 I submitted a new one
but now it shows 1548 | 1 when it should be 1547 | 1 (same remark for new scans)
Reply With Quote
  #10  
Old Jul 11, 2012, 06:54 PM
Phonograph's Avatar
Phonograph Phonograph is offline
Senior Member
 
Join Date: Jun 2010
Posts: 4,329
Default

another thing too
in total submissions page, I have 13812 but when I count my personal stats I have 15969 (+3 pending)
Reply With Quote
  #11  
Old Jul 11, 2012, 06:57 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,242
Default

Quote:
Originally Posted by Phonograph View Post
is Approved become Approved+Pending (-> Total) ?
because I had 1547 new tracklists added, so to get 1548 I submitted a new one
but now it shows 1548 | 1 when it should be 1547 | 1 (same remark for new scans)
Yeah, I'm going to have to manually subtract the pending submissions from the total.
Reply With Quote
  #12  
Old Jul 11, 2012, 10:36 PM
ilef's Avatar
ilef ilef is offline
Senior Member
 
Join Date: Apr 2008
Location: Italy
Posts: 378
Default

I believe the following is somewhat related to the issue submitted in this thread, so I'll leave the screen here:
Spoiler:

In case the above image fails to load, when I go and visit my profile's page this line of text is shown at the top, above stuff like the logo:
Quote:
Parse error: syntax error, unexpected T_VARIABLE in /home/vgmdb/public_html/forums/member.php(463) : eval()'d code on line 148
and the Submission tab which lists album/scan/etc. approved/rejected is not there, any more. EDIT: The My Submissions page still lists album edits and covers correctly.
__________________
Are you miserable? Good.
last.fm | Discord: Dark Slayer#8440

Last edited by ilef; Jul 11, 2012 at 10:41 PM.
Reply With Quote
  #13  
Old Jul 12, 2012, 03:39 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,242
Default

This page caching is making it horrible to debug problems.

Anyway, I think it's working for everyone now. If it's not, then I'll just turn off the plugin. Integrating with the vBulletin profile was a bad idea, and all this stuff should be moved the the VGMdb user page.
Reply With Quote
  #14  
Old Jul 12, 2012, 04:02 AM
ilef's Avatar
ilef ilef is offline
Senior Member
 
Join Date: Apr 2008
Location: Italy
Posts: 378
Default

Everything seems to be fine here, now, the error disappeared and the tabs have returned. Thanks for fixing the issue
__________________
Are you miserable? Good.
last.fm | Discord: Dark Slayer#8440

Last edited by ilef; Jul 12, 2012 at 04:04 AM. Reason: redundancy
Reply With Quote
  #15  
Old Jul 12, 2012, 11:31 AM
Phonograph's Avatar
Phonograph Phonograph is offline
Senior Member
 
Join Date: Jun 2010
Posts: 4,329
Default

I don't know for other people but I noticed 3 errors in my stats (the rest is ok)

New Albums: 1308 (should be 1309) | 1 | 0
New Scans: 1180 (should be 1181) | 1 | 0
Album Edits: 4629 (should be 4630) | 0 | 0
Reply With Quote
  #16  
Old Jul 15, 2012, 10:43 AM
Phonograph's Avatar
Phonograph Phonograph is offline
Senior Member
 
Join Date: Jun 2010
Posts: 4,329
Default

another thing, concerning total submissions
when I calculate my submissions from My Profile I have 16025 + 32 pending
but the total submissions site stats show 13863 (2162/2194 missing)

edit: plus there are 9 pending for albums but only 8 visible on submissions page

Last edited by Phonograph; Jul 15, 2012 at 11:16 AM.
Reply With Quote
  #17  
Old Jul 21, 2012, 11:12 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,242
Default

Just a note: the "Approved" submissions column has been changed to "Total" submission. There was just no way to accurately track the approved submissions for people who in and out of the Trusted Editor (and above) rank.
Reply With Quote
  #18  
Old Aug 28, 2012, 12:04 AM
Nisto's Avatar
Nisto Nisto is offline
VGMdb Advisor
 
Join Date: Sep 2009
Posts: 1,189
Default

Wow. I've just noticed that my Tracklist Edits has sunk by at least 1000. What happened here?
Reply With Quote
  #19  
Old Aug 28, 2012, 02:49 AM
Efendija's Avatar
Efendija Efendija is offline
VGMdb Staff
 
Join Date: Aug 2011
Location: Serbia
Posts: 2,009
Default

That thing happened last month I think and it's something like this: if you (example) entered track times and the tracklist has like 20 tracks, you get 20 edits. Since the change, it will increase only by one edit, meaning where the unit for edit count was a track, it's now whole tracklist.
The change was also retroactive, so it decreased overall tracklist edit count, but it was for approved edits only, I remember I messed up some track names for Arrietty OST (when I was a normal user), some 13 tracks to be exact, and the edits were rightfully rejected, but the new count system hasn't changed those 13 to 1 (by the tracks -> tracklist logic), so number of rejected submissions stayed the same

Though it's all good, stats are just numbers, and I've always hated maths XDDDD
Reply With Quote
  #20  
Old Aug 28, 2012, 08:45 PM
Nisto's Avatar
Nisto Nisto is offline
VGMdb Advisor
 
Join Date: Sep 2009
Posts: 1,189
Default

Quote:
Originally Posted by Efendija View Post
The change was also retroactive, so it decreased overall tracklist edit count, but it was for approved edits only, I remember I messed up some track names for Arrietty OST (when I was a normal user), some 13 tracks to be exact, and the edits were rightfully rejected, but the new count system hasn't changed those 13 to 1 (by the tracks -> tracklist logic), so number of rejected submissions stayed the same
Bah, that's kinda unfair! But also, I feel your pain, man. I made a change to the English tracklist on the Zelda Wind Waker soundtrack way back when I didn't know anything about what "literal" / "localized" translations were, and didn't have any understanding of Japanese at all. I made an edit (instead of submitting it) on the tracklist back then, so I got myself over 100 rejected edits <_<. What's worse is they decided to use it anyway. Oh well. Today, I guess we would: approve the edits, submit it as a new tracklist instead, and simply manually revert the changes on the default tracklist.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
last secondary stats Phonograph Questions and Comments 2 Apr 24, 2014 01:53 PM
Now post some music, some stats quintin3265 Game Remixes Forum Archive 2009-2012 1 Jul 29, 2009 08:41 PM
User ratings BahamutZ Questions and Comments 7 Dec 13, 2007 05:41 AM
Unknown User Megavolt Questions and Comments 2 Oct 7, 2007 07:34 PM