andig / videodb

The videoDB media collection software

videoDB

VideoDB is a PHP-based web application to manage a personal video collection. Multiple video types are supported, ranging from VHS tapes and DVDs to Blu-ray discs and DivX files on hard-disc. Even video games are supported.

Introduction

Browse

You can use videoDB to manage your video and CD collection, be it DVD, BluRay or plain Files:

View

Edit

All data is editable in nice layed out forms:

IMDB

New movies are easily added directly from IMDB or other sources:

Config

videoDB is also highly customizable- almost every aspect can be changed from template selection to detailed customization:

videodb's Issues

Fetching Movie images not working anymore with IMDB

IMDB seems to have change its image binding pattern again. This time the images appear to be located at amazon.

Elegant Statistics Page Style

The statistic page has no style. The background is completely gray. Seem like the element template folder is missing the file stat.tpl. I would assume it's needed due to the fact that all the other templates contains it.

Thanks

Top Bar collapses, but does not show hidden items

When the window width is below approx 980px, the top bar simplifies, with the dropdown control on the rightmost edge, which seems reasonable.

However, the Menu control does not show the now-hidden menu items.

No pictures / No IMDB Cast V4.0.0

I have 2 problems atm, the first is IMDB casts doesn't pull through. The second is no picture is showing, ie No covers and no pictures also showing when I go to the IMDB tab, however when I click open in browser it does show (it then goes to the actual website in a new window).

Feature request: Filestube.com search

Hello,
it would be great, if in addition to the isohunt search it would be possible to search on filestube.com
I tried playing around with the isohunt.php in the engines folder and kind of got some results, but they where not always correct and I didn't manage to get the filesize to show up.

Can someone help with this? I am willing to provide my modded isohunt.php, but it's not terribly nice... I'm not a programmer, I just try my best to hack things to work they I'd like them to...

Thanks!

Nexgen permission update

Hello again :)

With the nexgen template if you want to change permissions the update button always takes away all the users permissions. Admin's perms as well. Tried with IE9 and FF 20.0.1.

Regards,
Laszlo

4.1 add_recommended_movies.php - returns error as - Fetching recommendations for ###### (IMDB Id imdb:0213890) Server returned wrong status.

Movie Recommendation script returns error like below..
Fetching recommendations for Mohabbatein (IMDB Id imdb:0213890)
Server returned wrong status.

Cover Image Fetching / IMDB and Google / not working anymore

Hello

Since a couple of days I notice that the fetching of cover images from Google and (sometimes) als from IMDB does not work anymore..

I have the latest version of files installed and it used to work just fine a few weeks ago..

an example where IMDB has a coverimage, but videodb would not fetch:
http://www.imdb.com/title/tt0099850/

another example where it HAS fetched ok:
http://www.imdb.com/title/tt0081182/

please help

thx

Upgrade to V4.1

How do I upgrade to version 4.1 ?

Fix PHP 5.5 compatibility

PHP 5.5 marks the MySQL extension as deprecated- this needs to be handled.

imdb.php not fetching movie pictures again

I don't know if this is working for you. But imdb seems to have change its structure again.

contrib/clean_unused_images.php does not work

contrib/clean_unused_images.php is invoking the function analyzeCacheFolder that does not exist anymore.

It once existed in core/set.core.php

thru google I found.
http://www.phpkode.com/source/p/videodb/videodb/core/setup.core.php

Import from IMDB in template Nexgen

Hello,

I installed the updated videodb with the great Nexgen template over my old videodb-database (3.1). Everything works great, except for one thing: when I try to add a movie via IMDB, accessed via the IMDB-link in the header bar, this seems to fail. When I enter a name in the search bar of the IMDB page, a new and fresh IMDB-frame is opened inside the existing frame, with incorrect search results: the search action added '?s=all' to the query, resulting in weird and incorrect results. I have attached a screenshot to this post to show. I have this issue in all my browsers (Firefox, Chrome, Explorer). The old videodb-templates work correctly for the import.
Am I doing something wrong?

IMDB engine broken after latest site update

javascript error in title lookup ( click on lens)

After making a search in the lookup popup and retrieving a movies list I get a javascript error when I click on a movie:

Uncaught ReferenceError: returnData is not defined lookup.php:1

doesn't happen in the videodb-4_0_0.tgz release on sourceforge.

refetch all external engine info is broken

contrib/refetchAllInfos.php has an error in line 78.

SELECT * FROM TBL_DATA AND owner_id = 1;

AND is not allowed after table name.

suggestion : create engines for OMDB API , IMBD json api, TMDB api , rotten tomatoes api

omdb api: http://www.omdbapi.com/
imdb json api : http://stackoverflow.com/questions/1966503/does-imdb-provide-an-api
themoviedb ap ( TMDb ) i: http://www.themoviedb.org/documentation/api
rotten tomatoes api : http://developer.rottentomatoes.com/

omdb api is available as a mysql database. We could include a remote install mechanism to download/install/activate the db locally in videodb.

Actors missing from IMDB data fetch

Cast data fetch/populated upon IMDB data lookup.

ps. using version pre-4.0

IMDB engine needs update

Currently IMDB search doesn't work (e.g. http://localhost/videodb/lookup.php?find=rambo&engine=imdb).

Allocine

Retrieve information from allocine is not working.
The api is here https://github.com/gromez/allocine-api/tree/master/PHP
It would be nice if it worked

Upgrade from old database v13 to current one failed

I have a rather old installation which I try to setup again. Now the database upgrade fails. There are many database entries inside, so populating and reinsatlling from scratch is not an option. The following thing fails:

Upgrading tables...

Old database version: 13

Error upgrading database, try full install instead of upgrade:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT IGNORE INTO `mediatypes` (id, name) VALUES (17,'AVCHD')' at line 2

UPDATE mediatypes SET id=18 WHERE id=17 AND name='CD'
INSERT IGNORE INTO mediatypes (id, name) VALUES (17,'AVCHD');

REPLACE INTO config (opt,value) VALUES ('dbversion', 36);

Performing

mysql> select * from mediatypes;

on my old database will give me:

+----+--------+
| id | name |
+----+--------+
| 1 | DVD |
| 2 | SVCD |
| 3 | VCD |
| 4 | CD-R |
| 5 | CD-RW |
| 6 | VHS |
| 7 | DVD-R |
| 8 | DVD-RW |
| 9 | DVD+R |
| 10 | DVD+RW |
| 50 | wanted |
+----+--------+
11 rows in set (0.00 sec)

I hope you can give me a hint how to convert the old data.

OK, found the solution, there should be a ';' at the end of the line after UPDATE mediatypes SET id=18 WHERE id=17 AND name='CD'
Has nobody tried it before me?

Not within the allowed path

Hi!

I got the following error for some of the movies:
PHP Warning: is_link(): open_basedir restriction in effect. File(D:\VideoDB/D:\VideoDB\cache\img\9\9b119862ecff3fcb0f2b8f401a68fd9d.jpg) is not within the allowed path(s): (D:\VideoDB;D:\Temp\Win) in D:\VideoDB\lib\phpthumb\phpthumb.class.php on line 1094 PHP Warning: getimagesize(): open_basedir restriction in effect. File(D:/VideoDB/D:/VideoDB/cache/img/9/9b119862ecff3fcb0f2b8f401a68fd9d.jpg) is not within the allowed path(s): (D:\VideoDB;D:\Temp\Win) in D:\VideoDB\lib\phpthumb\phpthumb.class.php on line 1403 PHP Warning: getimagesize(D:/VideoDB/D:/VideoDB/cache/img/9/9b119862ecff3fcb0f2b8f401a68fd9d.jpg): failed to open stream: Operation not permitted in D:\VideoDB\lib\phpthumb\phpthumb.class.php on line 1403 PHP Warning: is_link(): open_basedir restriction in effect. File(D:\VideoDB/D:\VideoDB\cache\img\9\98b6213c0fbe0e80415abf889d25e396.jpg) is not within the allowed path(s): (D:\VideoDB;D:\Temp\Win) in D:\VideoDB\lib\phpthumb\phpthumb.class.php on line 1094 PHP Warning: getimagesize(): open_basedir restriction in effect. File(D:/VideoDB/D:/VideoDB/cache/img/9/98b6213c0fbe0e80415abf889d25e396.jpg) is not within the allowed path(s): (D:\VideoDB;D:\Temp\Win) in D:\VideoDB\lib\phpthumb\phpthumb.class.php on line 1403 PHP Warning: getimagesize(D:/VideoDB/D:/VideoDB/cache/img/9/98b6213c0fbe0e80415abf889d25e396.jpg): failed to open stream: Operation not permitted in D:\VideoDB\lib\phpthumb\phpthumb.class.php on line 1403

It looks like the paths are broken: "D:\VideoDB/D:\VideoDB\cache..."

Have a nice day! ^^

Filter to IMDB rating

Hello,

It would be a good enhancement to add a filter to IMDB rating as well at the search page.

Cheers,
Laszlo

PHP Error Log

Hi,

I have the following problem within my VideoDB folder. There is an error log that contains the following message:

[27-Jun-2013 14:32:40 America/New_York] PHP Warning: getimagesize(/home/core1/public_html/videodb/lib/phpthumb/home/core1/public_html/videodb/cache/img/1/17914465ea04063a747f6e33912fa014.jpg) [function.getimagesize]: failed to open stream: No such file or directory in /home/core1/public_html/videodb/lib/phpthumb/phpthumb.class.php on line 1403

It seems like these messages are created when my browser tries to load the thumbnails. I don't know why the getimagesize is pointing to /home/core1/public_html/videodb/lib/phpthumb/home/core1/public_html/videodb/cache/img/1/17914465ea04063a747f6e33912fa014.jpg. All the cache images are located in /home/core1/public_html/videodb/cache/img/. I'm stumped.

I'm a bit concern because within one day my error log got as big as 25MB. Any help to resolve this would be greatly appreciated.

Thank you.

Suggestion: Multiple MediaTypes

Many movies now offer that you can purchase a movie on Blu-Ray, DVD and UV/download, I would like to make the comment to update MediaType so you can add multiple types of movie types instead of making duplicate items.

This would come in very handy when you have a Blu Ray and DVD of a movie.

Statistics with user without movies

Hello,

If I try to view statistics with a user who has no movies owned I got the following error (500):
PHP Warning: Division by zero in D:\VideoDB\lib\smarty\plugins\function.math.php(70) : eval()'d code on line 1

Regards,
Laszlo

IMDB localization

Hello,

I spend a day to install your application to a windows box with IIS7, but it is working after all. :) It looks great, but now i have a problem with the imdb engine. Every time I search for a title the result language displayed localized by my IP address. I am in Hungary so the titles are all Hungarians witch is really annoying to me. I am behind a proxy so I can't use different proxies. Can I set up somehow that the search brings up the original movie titles (not the localized ones)?

Best regards,
Laszlo

Enhanced rating support with Allocine/Filmstarts/Screenrush

Hi,

I'm currently looking to improve the rating support.

My reference engine is allocine and this engine provide two ratings (user rating and press rating) which are very useful
I would like to show both on list (read only), show (read only) and edit (RW) pages.
And next to that I would like to be able to sort entries in list page based on either one or the other rating.

Next to it, Allocine can also provide press rating from various newspapers.
In that perspective I'm enhancing allocine.php to use directly Allocine API.

Now my approach for implementation:

• Update allocine.php (based on Etienne Gauvin API)
• Dual rating: Easy step is to add a new table entry for press rating (ok if only 2 ratings)
  Otherwise I need to make a new table with all ratings per movie
• Adapt filter stuff on index.php for the ordering options

I'm currently only using elegant template, but I'll adapt the other as well when get it stable..
Support of other variants like filmstart.de or screenrush,co.uk is also planned later on as it relies on same allocine API.

Any advise is welcome

I'm new to Git so I didn't release my files yet.

Arnaud

videodb doesn't work with PHP7

There are some issues with the breaking changes in the newly release PHP7. A few of them were quite easy to solve because an error/warning-message was shouting at me :-)

But I'm currently stuck with an error on adding/editing videos, where all fields are empty when using PHP7, but without any obvious error. The think I tracked down the error to prepareSQL so far. Will try to have a look at it tomorrow again.

I'm collecting the changes at the php7-fixes branch in my fork: master...Boris-de:php7-fixes

upgrade issue

overwrote all files into existing dir as readme says. Ran install.php, no errors during upgrade. When I click start to visit site, I get this error.

Fatal error: Uncaught exception 'SmartyException' with message 'property 'rendered_template' does not exist.' in /home4/cetadmin/ramndump/video/lib/smarty/sysplugins/smarty_internal_templatebase.php:798 Stack trace: #0 /home4/cetadmin/ramndump/video/cache/smarty/elegant^ff601db8198d7042dd587dde8aae7d58bdf1b498.file.header.tpl.php(24): Smarty_Internal_TemplateBase->__call('getRenderedTemp...', Array) #1 /home4/cetadmin/ramndump/video/cache/smarty/elegant^ff601db8198d7042dd587dde8aae7d58bdf1b498.file.header.tpl.php(24): Smarty_Internal_Template->getRenderedTemplate() #2 /home4/cetadmin/ramndump/video/lib/smarty/sysplugins/smarty_internal_templatebase.php(161): include('/home4/cetadmin...') #3 /home4/cetadmin/ramndump/video/lib/smarty/sysplugins/smarty_internal_templatebase.php(374): Smarty_Internal_TemplateBase->fetch('header.tpl', NULL, 'elegant', NULL, true) #4 /home4/cetadmin/ramndump/video/core/functions.php(363): Smarty_Internal_TemplateBase->display('header.tpl', NULL, 'elegant') #5 /home4/cetadmin/ramndump/video/inde in /home4/cetadmin/ramndump/video/lib/smarty/sysplugins/smarty_internal_templatebase.php on line 798

Why keep outdated engines?

When updating videodb without copying all engines, showing a record with missing engine results in a blank screen.

I've modified function engineGetContentUrl and changed required_once to include_once. It works. Why keep outdated engines?

automatic disk id

Another suggestion to assign the automatic disk id.
If the the diskid is numeric in my opinion it is better to add a sql query like:
$tmpSql = “SELECT max(diskid) AS tmpID FROM videodb_videodata WHERE owner_id = ‘”.get_current_user_id().”‘”;
The advantage is that every User has his own incrementation of diskids.
Otherwise nice work!

Borrow movie is incompatible with MySql 5.7

Select a movie and click Borrow.

This is what borrow.php displays:

Database Problem

Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'videodb.videodb_videodata.subtitle' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT who, DATE_FORMAT(dt,'%d.%m.%Y') as dt, videodb_lent.diskid, CASE WHEN subtitle = '' THEN title ELSE CONCAT(title,' - ',subtitle) END AS title, videodb_videodata.id, COUNT(videodb_lent.diskid) AS count, videodb_users.name AS owner FROM videodb_lent, videodb_videodata LEFT JOIN videodb_users ON owner_id = videodb_users.id WHERE videodb_lent.diskid = videodb_videodata.diskid AND videodb_users.name = 'klaus' GROUP BY videodb_lent.diskid ORDER BY who, videodb_lent.diskid

URL in Plot

If there is a URL in the plot videoDB will just the plot off at the begining of the URL and not record the whole plot. Some examples are imdb:2024432 and imdb:2140373

Amazon AWS searches but always blank result

After activating the Amazon AWS search with the API access keys, the search for a video title run but no matter for what searched title, always the result: "Nothing found"

javascript error on "Create" (http://localhost/videodbfork/edit.php )

I am getting in firefox & chrome:

error performing selector: "#[object HTMLInputElement]add_flag1" zepto.js:1793
Uncaught Error: SyntaxError: DOM Exception 12 zepto.js:1794

when I try to create a new entry. This doesn't happen with the videodb-4_0_0.tgz release on sourceforge.

Fetching data not working anymore with IMDB

Help.
It seems that fetching data from imdb is completely down.

Borrowask on raspberry pi

I have installed videoDB on a raspberry pi, it all works, except if I want to borrow a movie, after clicking on Ask to borrow I get the following message:

"The sending of your request failed for some reason. You should contact the movies owner your self."

Before I had it installed on a MacBook and it worked "out of the box".
Do I have to install something extra to make it work on the rpi?

Default owner for browsing

Hello,

I try to configure a multiuser setup here with 1 admin and 1 guest account right now. All the movies owned by the admin per default. If the guest go to default.php he always got the owner filter on Guest and he always need to set it to Any if he wants to see the movies. Can I force Any as the default owner filter in the browser area somehow?

Best regards,
Laszlo

suggestion : generate poster image with text of title instead of default question mark image

In the "Browse" view there is no way to tell which movie is represented by the "question mark image" for movies that have no poster available, unless one clicks on it and checks the details. S
Suggestion: generate an image with the text of the title

Too many actors

Hi,
Adding titles like Sopranos gives an error message about too many actors.
Cheers!

Feature request: checkbox for 'Seen' in movie's main details page in Nexgen template

Hello,

The excellent Nexgen template seems to be missing a handy feature that exists in the older videodb-templates: a checkbox for 'Seen' on the movie's main details page. Now you have to open the edit-page of the movie to indicate whether you saw the movie or not and save that update. Not as handy as a checkbox on the regular main details page :)

Elegant Templete

Hi,

I've been using the elegant template and my error log is producing the following error: "File does not exist: /home/user/public_html/videodb/javascript/prototype/control.modal.js"" This message always pops up when I click the New(Create) button. I've located the file which was causing the problem. edit.tpl.

Which is located in videodb/templates/elegant.

On line 31 it calls the javascript: <script language="JavaScript" type="text/javascript" src="./javascript/prototype/control.modal.js"></script>

The file "/javascript/prototype/control.modal.js" does not exist. Hence why I'm receiving the errors. Within the same location I've notice other file called edit.tpl.new.

I replaced edit.tpl with edit.tpl.new. Removing the .new and it fixed the problem.

Is it okay to replace edit.tpl with edit.tpl.new? Should edit.tpl.new be rename to edit.tpl so other don't get the same error?

Thanks

getting Episodes list in IMDB seems to be not working

when trying to display or change the episode listing in imbd brings back none of the episodes. this occurrs on all series i have tried

Links in summey might be a problem

I'm trying to fetch the summery/storyline from IMDB for "The Chronicles Of Riddick", but I only get part of it.

This is what I get:
"Riddick, now a hunted man, finds himself in the middle of two opposing forces in a major crusade."

This is what is on IMDB:
"Riddick, now a hunted man, finds himself in the middle of two opposing forces in a major crusade. Colm Feore plays Lord Marshal, a warrior priest who is the leader of a sect that is waging the tenth and perhaps final crusade 500 years in the future. Judi Dench is Aereon, an ambassador from the Elemental race. She is an ethereal being who helps Riddick unearth his origins. Written by Jade Maxim"

I think the problem lies in the link to "Colm Feore".

imdb online

imdb online is not adding the add movie option

Fetching summry contains parentheses fails

Fetching summary data using IMDB on "Safe House".

Got:
Matt Weston (

Wantend:
Matt Weston (Ryan Reynolds) is a CIA rookie who is manning a safe house in Cape Town, South Africa, when Tobin Frost (Denzel Washington) the CIA's most wanted rogue agent is captured and taken to the safe house. During Frost's interrogation, the safe house is overtaken by mercenaries who want Frost. Weston and Frost escape and must stay out of the gunmen's sight until they can get to another safe house. Written by Douglas Young (the-movie-guy)

Note:
Parentheses may not be the only special character that breaks fetcing.
Summary may not be the only field that has this problem.

ps. using version pre-4.0

Country missing with IMDB

I believe that it has been a while now, when using IMDB as a source, the country of origin is not imported anymore.

IMDB seems to be broken.

Hi,

since today IMDB seems to be broken. I wasn't sure so I tried to add a new Movie using directly the IMDB Id and got

"Engine Error
Engine does not properly return encoding"

Am I the only one to see this ?

Cover Image

The cover image is always blank unless I manually choose an alternative image from the bottom. Is the IMDB fetch for cover image not working?