2011-07-11, 14:51
I am using Confluence with the imdb scraper. I am hosting the XBMC database in mySQL on my NAS. I am knowledgeable about programming in general but not XBMC skinning.
When the IMDB scraper pulls down the ratings, they are stored in column c05 in mySQL. I would like to use my own ratings in e.g. Media Info view. Initially this will be the Critics rating from Rotten Tomatoes. I've written a script that will pull down the Rotten Tomatoes rating and store it in column c05 in the Movies table. Unfortunately, the default Media Info view in XBMC formats the rating as xx.x, so for example a rating of 71% on RT is displayed as "71.0".
Basically, I just need to change Confluence to format the rating as a whole integer and not try to format using a decimal point.
Any suggestions?
When the IMDB scraper pulls down the ratings, they are stored in column c05 in mySQL. I would like to use my own ratings in e.g. Media Info view. Initially this will be the Critics rating from Rotten Tomatoes. I've written a script that will pull down the Rotten Tomatoes rating and store it in column c05 in the Movies table. Unfortunately, the default Media Info view in XBMC formats the rating as xx.x, so for example a rating of 71% on RT is displayed as "71.0".
Basically, I just need to change Confluence to format the rating as a whole integer and not try to format using a decimal point.
Any suggestions?