Where Files sizes are stored in Mysql database ?

Kytrix · 2012-07-19 22:45

Hi, I'm want to make a little gui in php to list my movies, I actualy use a centralised mysql database to syncrhonize my xbmc clients.

I search in the video tables and didn't find a column who give me the file size, but xbmc show this information in the movies list ! So it rescant all the movies at every launch ? or keep this information in another place ?

Thanks for helping guys !

**jmarshall** · 2012-07-20 01:17

It gets it from the file.

Kytrix · 2012-07-23 12:35

Okay, I thinks it was not efficient to get like this, instead of storing it at the first file scan.
The file size might not change between xbmc launching ...

Thanks. I'm going to read file length so Wink

jmarshall Team-XBMC Developer Posts: 24,523 Joined: Oct 2003 Reputation: 138	2012-07-20 01:17 Post: #2 It gets it from the file. Always read the XBMC online-manual, FAQ and search the forum before posting. Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules. For troubleshooting and bug reporting please make sure you read this first.
	find quote

Kytrix Junior Member Posts: 25 Joined: Sep 2009 Reputation: 0	2012-07-23 12:35 Post: #3 Okay, I thinks it was not efficient to get like this, instead of storing it at the first file scan. The file size might not change between xbmc launching ... Thanks. I'm going to read file length so My XBMC Box \| my DIY Videoprojector integration
	find quote