User avatar
zag
Site Admin
Posts: 182
Joined: Tue Oct 11, 2016 9:43 am

[£20 Bounty Claimed] Push user ratings to TheAudioDB.com

Wed Mar 08, 2017 2:40 pm

I've put up another £20 for anyone who can push up the song track and album ratings to TADB.

Some more details here

User avatar
robwebset
Site Mod
Posts: 281
Joined: Fri Dec 02, 2016 12:39 pm

Re: [£20 Bounty] Push user ratings to TheAudioDB.com

Wed Mar 08, 2017 7:08 pm

Hi Zag,

I'm happy to do the updates to support more things with this - may take me a little longer than usual - I've got a few things on at the moment.

From my point of view - no need for the bounty (I don't want to come over as a mercenary) - I'm happy to go just on donations - if I do it and you like it - then feel free to make a donation - or not - it doesn't matter ;)

Thanks
Rob

User avatar
robwebset
Site Mod
Posts: 281
Joined: Fri Dec 02, 2016 12:39 pm

Re: [£20 Bounty] Push user ratings to TheAudioDB.com

Tue Apr 04, 2017 4:47 pm

Is there a problem with TAD website at the moment?

Thanks
Rob

User avatar
zag
Site Admin
Posts: 182
Joined: Tue Oct 11, 2016 9:43 am

Re: [£20 Bounty] Push user ratings to TheAudioDB.com

Wed Apr 05, 2017 9:34 am

Yep my bad! I was testing the api and forgot to restart the webserver after the tests! doh!

sorry.

User avatar
robwebset
Site Mod
Posts: 281
Joined: Fri Dec 02, 2016 12:39 pm

Re: [£20 Bounty] Push user ratings to TheAudioDB.com

Wed Apr 05, 2017 8:21 pm

Hi Zag,

Is it possible you left some debug in the response code when it is the first track rating being set?

Request returned <br>INSERT INTO scores (username, trackscore, artistid, albumid, trackid, strArtist, strAlbum, strTrack, mbidArtist, mbidAlbum, mbidTrack, rateddate) VALUES ('robwebset','9','117315','2148164','33194857', 'Michelle Shocked','Short Sharp Shocked','Anchorage', 'e2f41b6e-7045-44e8-86bf-deee758532e2', 'fa74ba78-b760-3aa5-aac7-702fe7a2d8f8', '55283fd8-7c3d-4054-a174-239ce1758a2d', NOW()){"result":"SUCCESS New rating"}


Thanks
Rob

User avatar
robwebset
Site Mod
Posts: 281
Joined: Fri Dec 02, 2016 12:39 pm

Re: [£20 Bounty] Push user ratings to TheAudioDB.com

Wed Apr 05, 2017 9:02 pm

Hi Zag,

Just doing the Album stuff and I'm not sure It's working as I'd expect.

If I call:

http://www.theaudiodb.com/api/v1/json/<REMOVED>/submit-album.php?user=robwebset&artist=Michelle+Shocked&album=Short+Sharp+Shocked&rating=8&api=<REMOVED>


I get a reply:

{"result":"SUCCESS Updated rating"}


However the item is not updated:
http://www.theaudiodb.com/album/2148164

Thanks
Rob

User avatar
robwebset
Site Mod
Posts: 281
Joined: Fri Dec 02, 2016 12:39 pm

Re: [£20 Bounty] Push user ratings to TheAudioDB.com

Wed Apr 05, 2017 9:17 pm

Hi Zag,

First draft of the enhanced feature to upload the Track ratings:

<More recent one later in the thread>

For Albums it does make the call, which gets a success back - but no values seem to change on the website (as per previous post).

It takes a "Safety first" approach - so, if the value on TADB has changed since the last time it checked - it will not push the new value - but will instead update Kodi with the changed value.

Something that still remains is, at the moment - if the Kodi rating is set to zero, when it was previously something else - then it will not push the zero value to TADB (when it should really).

This also only works in Kodi v17 at the moment. (I'm not sure if we should support it any earlier as earlier versions do not have the user rating - just a global rating).

Thanks
Rob

User avatar
robwebset
Site Mod
Posts: 281
Joined: Fri Dec 02, 2016 12:39 pm

Re: [£20 Bounty] Push user ratings to TheAudioDB.com

Thu Apr 06, 2017 7:05 am

Actually, on second thoughts - I think it should support v16 as well as I think there is a valid case of "Upload all ratings vrom v16" - then resync them with a clean install of v17.

Now I just need to remember how I did support for v16 in the first place :)

Rob

User avatar
robwebset
Site Mod
Posts: 281
Joined: Fri Dec 02, 2016 12:39 pm

Re: [£20 Bounty] Push user ratings to TheAudioDB.com

Thu Apr 06, 2017 7:52 am

OK, new version available:

<More recent one later in the thread>

This one adds v16 support for setting the ratings.

It also adds an option to remove the resync history - this will result with every track being checked again rather than just the changed tracks.

Thanks
Rob

User avatar
zag
Site Admin
Posts: 182
Joined: Tue Oct 11, 2016 9:43 am

Re: [£20 Bounty] Push user ratings to TheAudioDB.com

Thu Apr 06, 2017 8:13 am

robwebset wrote:Hi Zag,

Is it possible you left some debug in the response code when it is the first track rating being set?

Request returned <br>INSERT INTO scores (username, trackscore, artistid, albumid, trackid, strArtist, strAlbum, strTrack, mbidArtist, mbidAlbum, mbidTrack, rateddate) VALUES ('robwebset','9','117315','2148164','33194857', 'Michelle Shocked','Short Sharp Shocked','Anchorage', 'e2f41b6e-7045-44e8-86bf-deee758532e2', 'fa74ba78-b760-3aa5-aac7-702fe7a2d8f8', '55283fd8-7c3d-4054-a174-239ce1758a2d', NOW()){"result":"SUCCESS New rating"}


Thanks
Rob


Yep forgot to remove the debug line. Fixed.

Return to “Bounties”