1
flyingtux
Movie DB Module
  • 2004/9/16 9:23

  • flyingtux

  • Not too shy to talk

  • Posts: 146

  • Since: 2004/9/6 1


I'd like to have a module to archive and query a list of movies, i.e: title, year, director, actors, cover_image. etc... Does it exist already? I'm not a programmer, but I'd like to know how difficult could be to build a new module or triyng to port something which already exists.

2
Herko
Re: Movie DB Module
  • 2004/9/16 11:30

  • Herko

  • XOOPS is my life!

  • Posts: 4238

  • Since: 2002/2/4 1


Hsalazar has built a MovieMakers module, which he graciously made available on the XOOPS Module Development Forge. Is this what you're looking for?

Herko

3
flyingtux
Re: Movie DB Module
  • 2004/9/16 14:55

  • flyingtux

  • Not too shy to talk

  • Posts: 146

  • Since: 2004/9/6 1


I haven't been able to find the file and actually don't know if ther's already one. Anyway: I'm running a website which has as main topic, the so called italian b-movies of the seventies. Now: there's a kind of revival on this issue, a lot of these movies are being republished/reprinted on dvd, etc. I'd like to have a module which allows me to create and mantain such a db: only the infos and, at least, cover images. No media files. No divx. Etc...
As long as i can understand, it would be nice something like that:
http://php4flicks.sourceforge.net/
It seems yo be free and nice. I have no ideo of how to port it to xoops.
What do you suggest?

4
hsalazar
Re: Movie DB Module
  • 2004/9/16 15:40

  • hsalazar

  • Just popping in

  • Posts: 78

  • Since: 2003/2/6 1


flyingtux:

I've uploaded version 0.5 of FilmMakers to the developers site. You can try it and see if it suits your needs. Since it's aimed more at the film directors than to the movies themselves, you'll probably need to modify it a bit, so the index page takes you to the movies page instead of to the directors page. Other than that, I think you can use it. Please give us feedback as to its usefulness, and of course any comments or recommendations or suggestions are welcome.

Cheers.

PS: From this module, inquisitive xoopsers can extract parts for different uses: a simple file uploader, the movie player, the code to assign specialties to a filmmaker, the menu for the admin side, the code to have an item list with a simple selectable filter, the code to select the featured item...

More cheers.

5
flyingtux
Re: Movie DB Module
  • 2004/9/16 15:46

  • flyingtux

  • Not too shy to talk

  • Posts: 146

  • Since: 2004/9/6 1


Thanx a lot!
I just downloaded it: I'm gonna test it and give you feedback!
Greetings,
flyingtux

6
flyingtux
Re: Movie DB Module
  • 2004/9/16 15:59

  • flyingtux

  • Not too shy to talk

  • Posts: 146

  • Since: 2004/9/6 1


When trying to install it returns this error:

Installing FilmMakers
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 ') TYPE=MyISAM' at line 6

My Internet Provider appear to run MySQL 4.0.20

I suppose I have to change this line, but don't know how yet.
Bye!

7
wcrwcr
Re: Movie DB Module
  • 2004/9/17 5:26

  • wcrwcr

  • Home away from home

  • Posts: 1114

  • Since: 2003/12/12


Hi hsalazar

Thanks for sharing another one

Unfortunatelly i had the same error:

Quote:

an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=MyISAM' at line 6


Xoops 2.07
====================
Running easyphp 1.6
MySQL 3.23.49-max
PHP 4.2.0
================

I think we are very curious about this module
so any feedback will be very appreciated.

Thanks.


8
2headedpuppy
Re: Movie DB Module

I was also interested in this module but received the same errors. Turned on debugging (Admin/Preferences/General/Debug) for MySQL during installation and ... whaddayaknow ...

There are two things to change in the '/filmmakers/sql/mysql.sql' file:

In the CREATE TABLE `fm_jobs` and CREATE TABLE `fm_genres' remove the comma at the end of the UNIQUE KEY line, just before TYPE=MyISAM. For fm_jobs (i.e.) change this :

CREATE TABLE `fm_jobs` (
    `
jobIDint(4NOT NULL,
    `
namevarchar(100NOT NULL default '',
    
PRIMARY KEY  (`jobID`),
    
UNIQUE KEY jobID (`jobID`),
TYPE=MyISAM;


Into this :

CREATE TABLE `fm_jobs` (
    `
jobIDint(4NOT NULL,
    `
namevarchar(100NOT NULL default '',
    
PRIMARY KEY  (`jobID`),
    
UNIQUE KEY jobID (`jobID`)
TYPE=MyISAM;


I was able to install but haven't played with it much ....

9
wcrwcr
Re: Movie DB Module
  • 2004/9/18 8:53

  • wcrwcr

  • Home away from home

  • Posts: 1114

  • Since: 2003/12/12


Hi 2headedpuppy

Thanks, It works!
As you I only installed the module.
I?m gonna test It now!






Login

Who's Online

80 user(s) are online (45 user(s) are browsing Support Forums)


Members: 0


Guests: 80


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits