Feature Request: Remote Database and/or Movie List Export (3 Viewers)

Status
Not open for further replies.

Tine

Portal Pro
October 9, 2008
56
0
Kranj
Home Country
Slovenia Slovenia
Actualy no :)

But i'm using copy of DB right now so no harm ;)


If there's interest i can finnish this thing with fixing all stuff and adding few features.


Regards, Tine
 

shackrock

Portal Pro
December 27, 2008
291
12
Raleigh, NC
Home Country
United States of America United States of America
Hey LRF - I downloaded this SQLITE database reader....and was looking through my db3 file to see what might be going wrong with the 2 table thing.

Anyway, it turns out that the IDs on the table with the user rating are somewhat random (161-180) instead of the same IDs that the actualy movies use (1-whatever). I think this is what your T1.id=T2.id tag may be addressing, but i dont know...

Also, in the "movie_info" table, there's a column called user_score. I think it would be more obvious for the database to put my scores in THAT table, is there anyway I can make this happen through the program's config screen? If not, maybe this is a change request for next versions?
 

LRFalk01

Portal Pro
August 27, 2007
257
92
39
Home Country
United States of America United States of America
There is something not right with your DB. I would move it to let moving pictures recreate it.

-LRFalk01
 

rolls1400

Portal Pro
August 26, 2007
132
3
Home Country
United States of America United States of America
So attached is a small updated program which includes:

-Creates the IMDB link for Details_Url
-Added a css"style.css"" link so when you you can change the style of the
page and not lose it whenever you create a new index.html (must be in same directory as index.html)
-Added sort by Title



**for css info go to http://www.w3schools.com/css/default.asp**
 

Attachments

  • MovieListOutput.zip
    30.6 KB

Rico

Portal Pro
December 23, 2008
188
12
Straelen
Home Country
Germany Germany
thanks rolls1400

for the update but the tool doesnt work it doesnt create any html file to the C: drive
also if i check the box order by title the program crashes

hope you can fix it
 

rolls1400

Portal Pro
August 26, 2007
132
3
Home Country
United States of America United States of America
thanks rolls1400

for the update but the tool doesnt work it doesnt create any html file to the C: drive
also if i check the box order by title the program crashes

hope you can fix it

Thats weird, I tested on a few peoples comps and had no problems. ill take a look at it again and add some error logging also.
 

joz

Portal Pro
March 17, 2008
1,353
306
Home Country
Netherlands Netherlands
awesome just set this up on my server/htpc. Thanks a lot, never really thought of this. Also my first experience with the php sqlite combination. Use php a lot but mostly mysql based
:D again!
 

LRFalk01

Portal Pro
August 27, 2007
257
92
39
Home Country
United States of America United States of America
awesome just set this up on my server/htpc. Thanks a lot, never really thought of this. Also my first experience with the php sqlite combination. Use php a lot but mostly mysql based
:D again!

You should try this out:
movingpicturesxml - Google Code

I made a process plugin that exports to an xml.

-LRFalk01
 

joz

Portal Pro
March 17, 2008
1,353
306
Home Country
Netherlands Netherlands
thanks but it's not for my use.

I like your php script. Improving on it a lot, when I'm done i'll post what I thrown together
 
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom