AutoExpire::FillDBOrdered uses ints for filesizes

[Robert Tsai <rtsai1111>]

Change [7944] casts a string to an "int" for filesize, which is bad for files > 2GB. The code should use QString::toLongLong() instead of QString::toInt()

This manifests itself as negative numbers being output by "mythbackend --printexpire".

[Isaac Richards]

toLongLong doesn't exist in older versions of Qt.

[anonymous]

Can you make and test a patch that in MySQL does the divide by 1024 and then multiply the toInt() by 1024 and see if you can work around it that way? If that works, check programinfo.cpp to see if another change is necessary there when/if we load the filesize.

[Robert Tsai <rtsai1111>]

Dividing by 1024 in the SQL query (and re-multiplying the result by 1024) works, but I don't like it. The code in programinfo.cpp does something different:

filesize = stringToLongLong(query.value(xx).toString());

So I'll do that.

QString::stringToLongLong appears to be new to qt-3.2; I assume its use in programinfo.cpp means it's OK? The QT version prerequisites and/or support requirements are not in the mythtv.org documentation for compiling source code ...

[Robert Tsai <rtsai1111>]

Use stringToLongLong instead of toLongLong

[cpinkham]

(In [8017]) Close #699 by applying Robert Tsai's patch. AutoExpire wasn't properly handling filesizes over ~2GB because of overflow using toInt() when the filesize is really a long long.

[cpinkham]

stringToLongLong() is actually a Myth function in libs/libmyth/util.cpp. I should have remembered that from when we put the filesize in the DB.