PK's MovieDB Release.V2.0 (Dynamic PHP View)

[gekoo]

Hello,
thanks again for your template, it's finaly working perfectly for me.
The field "number" wasn't exported because it was selected as the last field for advanced filter, after "insertion date" and "original title".
I removed it and now my sql export looks better :
DROP TABLE IF EXISTS movies;
CREATE TABLE movies (NUM INT NOT NULL, CHECKED TEXT, MEDIA TEXT, MEDIATYPE TEXT, SOURCE TEXT, DATEADD DATE, BORROWER TEXT, RATING INT, ORIGINALTITLE TEXT, TRANSLATEDTITLE TEXT, FORMATTEDTITLE TEXT, DIRECTOR TEXT, PRODUCER TEXT, COUNTRY TEXT, CATEGORY TEXT, YEAR INT, LENGTH INT, ACTORS TEXT, URL TEXT, DESCRIPTION TEXT, COMMENTS TEXT, VIDEOFORMAT TEXT, VIDEOBITRATE INT, AUDIOFORMAT TEXT, AUDIOBITRATE INT, RESOLUTION TEXT, FRAMERATE TEXT, LANGUAGES TEXT, SUBTITLES TEXT, FILESIZE TEXT, DISKS INT, PICTURENAME TEXT, PRIMARY KEY (NUM));
INSERT INTO movies (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, PRODUCER, COUNTRY, CATEGORY, YEAR, LENGTH, ACTORS, URL, DESCRIPTION, COMMENTS, VIDEOFORMAT, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, RESOLUTION, FRAMERATE, LANGUAGES, SUBTITLES, FILESIZE, DISKS, PICTURENAME) VALUES ('264', 'True', '', 'DVD', '', '2005-03-21', '', '8.8', 'The Lord Of The Rings (the Fellowship Of The Ring)', 'Le seigneur des anneaux (la communauté de l''anneau)', 'The Lord Of The Rings (the Fellowship Of The Ring) (Le seigneur des anneaux (la communauté de l''anneau))', 'Peter Jackson', '', 'Américain', 'Fantastique', '2001', '165', 'Elijah Wood, Ian Mac Kellen, Viggo Mortensen, Sean Astin', 'http://www.cinefil.com/cinefil2005/fich ... ?ref=33475', 'Frodon, un jeune Hobbit, hérite d''un anneau magique qui, s''il venait à tomber entre les mains du sinistre Sauron, le seigneur des ténèbres, donnerait à ce dernier le pouvoir absolu sur la Terre du Milieu. Sur les conseils du magicien Gandalf, Frodon et ses amis entament le dangereux périple qui doit les conduire à détruire l''anneau...', '', '', '', '', '', '', '', '', '', '', '', 'movie_264.gif');

[shadowbikes]

Hi J.P.

Wich program do you use on your pda to run mysql, i can't find anything on the internet.
could you give the link for it.

thanks Rene

[lestatou]

On the pc the program works great but on the pda not.
When i put text in the Search blok there is no button to klik on.
How can i add a button so i can click on it so it's send the search request.

The second question, what must i change to make it better visseble on the pda.

Hi.

I'v copy-pasted your code posted in the first page of this forum. It runs, but I can't see the modifications you have made on the original moviedb.inc.

the view of my http://lestatou.iespana.es/example.php is exactly than the original. There are not your modifications.

Sorry for my english.

[kazgor]

On the pc the program works great but on the pda not.
When i put text in the Search blok there is no button to klik on.
How can i add a button so i can click on it so it's send the search request.

The second question, what must i change to make it better visseble on the pda.

Hi.

I'v copy-pasted your code posted in the first page of this forum. It runs, but I can't see the modifications you have made on the original moviedb.inc.

the view of my http://lestatou.iespana.es/example.php is exactly than the original. There are not your modifications.

Sorry for my english.

hi,

a while back i uploaded my mod too http://www.geocities.com/kazgor_uk/moviedb.zip are you using that one? it is slightly different to the original. i recommend you go back a few pages to when i post the link as there are instructions that you will need to know

[pollewops]

Will there be a PRINT option in the future, so you can print the complete list of movies, with some additional fields ?

Or does someone already created such an option ?

[-=[WeBsEcReTa]=-]

This template is very COOL..

Single a suggestion for a next update, serious interesting to have a Control Panel similar to this:

[mjs7231]

Its not quite worth an admin page, but I am creating a much easier to use configuration system.. and a whole lot more.. (I'm thinking next week)..

[kazgor]

Its not quite worth an admin page, but I am creating a much easier to use configuration system.. and a whole lot more.. (I'm thinking next week)..

MJS, nice to see you again.. and to hear V3 is on the way..

Hope you include some of my idea's, such as the

..Nice Hover highlight over the Menu's
..5 Random films at top (on first page only)
..Config.inc file rather than have the setting in the Index.html
..Search box Tweaks (submit button, highlight red when searchbox is filled in)
.. Fixed JUMP TO box, right edge was pushing the box out a little, just needed to set the TABLE CSS to 98% instead of 100%

Would love to see a browse by DVD covers, maybe with just the title and year under each of them.

I was thinking of doing it myself but only way i can see it is to add another variable onto the URL line

I keep an eye out for the v3

Kaz.

http://kazgor.awardspace.com/

[lestatou]

Finally I've my catalog with kazgor's code.

Thaks a lot Kazgor. Great job.

Now i'm pefectioning it... do you have some news?? jeje.

http://lestatou.iespana.es/example.php

[Legion]

Hi there,

it is really a beautiful template and works great.

Just a question: Could someone upload the actual files, so that is looks like this: http://kazgor.awardspace.com/

I like the new Outfit (Header) and the new option "Random films".

It would be really great, if you upload it, that others can use it, too.

Greetings & Nice job
Legion

[kazgor]

Hi Legion, glad you liked my tweaks to the templates, i've uploaded a copy of the latest version onto:

http://www.mytempdir.com/1091001

you will need to modify config.inc with your database details.

[lestatou]

Hi all from spain, jeje.

I haven't idea about php, sorry... I want to add more "things" at the view of the movie. Now my php displays:

http://lestatou.iespana.es/example.php

Year: 1969
Date added: 07-Dec-2006
Format...: Dvd Original
Director: George Roy Hill
Category: Western ....

How can I add more "labels"? Can you tell me the code i must put on moviedb.inc ?

Great job friends

[xbirdtrip]

Hello, I have a fatal error when my list exceeds 1949 entries.

Code: Select all

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 39561 bytes) in /home/.sites/56/site60/.users/44/xbirdtrip/web/liste2/moviedb.inc on line 149

If somebody has an idea from which comes the error that would help me much

[mjs7231]

Code: Select all

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 39561 bytes) in /home/.sites/56/site60/.users/44/xbirdtrip/web/liste2/moviedb.inc on line 149

That sucks. The PHP script is using up all the memory. The problem is in my SQL logic. To create the filter's on the left side, I actually download the complete database into an array. As you can imagine, this could take up ALOT of memory. In your case, more than PHP will allow. It was just easier to code at the time.. and I wasn't even thinking about CPU memory.

I am on vacation next week, but will see what I can do about this when I get back. version3 is a complete rewrite from version2, and also contains this same bug. Fixing this should also make the process a big faster as well for databases with large movies. GOOD FIND!

PS. A quick fix in the mean time, if you have admin rights to your PHP install is to increase the allowed memory allocation for PHP. A quick Google search should let you know how to do this. (If you can do this, let me know. I would prefer not to have to fix v2, to allow me more time on getting v3 out the door).

[xbirdtrip]

PS. A quick fix in the mean time, if you have admin rights to your PHP install is to increase the allowed memory allocation for PHP. A quick Google search should let you know how to do this. (If you can do this, let me know. I would prefer not to have to fix v2, to allow me more time on getting v3 out the door).

Sorry, i don't have the admin rights

[Thermal Ions]

Hi, a big thanks to mjs7231 for such a professional template - I'm using version 2.2 (2006.04.22).

As many of us here like to do, I've tried to tweak it slightly so it's just how I want it. I've had mixed results:

1. Successful: Adjusted main page width to 98% instead of 670pixels. Removed the 'Date Added' field from the short movie description display. Changed the label for 'Media Type' to read 'Classification' as that's what I store in the field in AMC.

2. Frustratingly Stumped: I wanted to reduce the height that the short movie description takes up, and seeing as I now have it displaying wider, I wanted to change it from looking like

this:

to this:


However, when I attempt to introduce a 1 row 2 column table into the created html code to display the statistical type info on the left, and the text description to the right, I lose the .css formatting of the text. My .css skills aren't the best, but combine them with my lack of any real php skill, and I just can't get anything in the table cells to format properly. I'm hoping some kind soul can help me with this.

3. Utopian Dream that I gave up on within a few hours: I was wanting to make the database in MySQL into a linked table database where I could have multiple genre's per movie. That bit was easy. The dream part was then to bring that into the template so that if you browsed the 'All Categories' list then each movie would only appear once. If I had a movie which was in the MySQL database as having separate genre's of 'Sci-Fi' and 'Thriller' then it would appear if I selected either of these from the list of Categories. It became apparent that this would require a major rewrite - way out of my league and way out of what I could ask someone to help with.

If anyone is so inclined, please feel free to help me out with #2 though.

Cheers.................Thermal
The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it. (Terry Pratchett, Diggers)

[Thermal Ions]

/cheer With a bit more perseverence I successfully incorporated the table layout I was looking for. I just needed to incorporate the following code into the moviedb.css,

Code: Select all

#mdb_content TD.short_detail {
        BORDER: 0px black solid;
        PADDING: 0px 5px 0px 5px;
	MARGIN-BOTTOM: 0px;
	FONT: 400 11px arial, serif; 
	BACKGROUND-COLOR: #b8ad91;
	VERTICAL-ALIGN: Top
}

and amend the html creation section of 'get_short_description_html' function in moviedb.inc to include the appropriate table code.

Code: Select all

$html .= "    <table><tr><td nowrap class='short_detail'>\n";
$html .= "      <span>".$this->lang['year'].": </span> <a href='".$this->THISPAGE."?mdb_page=1&mdb_npp=".$this->mdb_npp."&mdb_order=".$this->mdb_order."&mdb_search=".$movieinfo['YEAR'].$non_mdb_gets."'>".$movieinfo['YEAR']."</a>\n";
$html .= "      <br /><span>".$this->lang['mediatype'].": </span>".$movieinfo['MEDIATYPE']."\n";
$html .= "      <br /><span>".$this->lang['category'].": </span> <a href='".$this->THISPAGE."?mdb_cat=".$movieinfo['CATEGORY']."&mdb_page=1&mdb_npp=".$this->mdb_npp."&mdb_order=".$this->mdb_order.$non_mdb_gets."'>".$movieinfo['CATEGORY']."</a>\n";
$html .= "    </td>\n";        
$html .= "  <td rowspan='2' class='short_detail'>\n";
$html .=      $movieinfo['DESCRIPTION'];
$html .= "  </td></tr>\n";
$html .= "     <tr><td class='short_detail'><span>".$this->lang['director'].": </span>\n".$directors_string."<br>\n";
$html .= "    <span>".$this->lang['starring'].":</span>\n";
$html .=      $actors_string;
$html .= "  </td></tr></table>\n";

Cheers..........Thermal

[kazgor]

I do love this script.. you can pretty much tweak it even if you dont know what you're doing..

Im looking forward to V3 hopefully its have all the tweak made to this one and a few new ones..

[Snille]

Hi mjs7231,

I'm also working on a PHP template, but I like the layout of yours, it's very compact and informative. In my template system there is a possibility to select the layout you want to use. So, I'm just wondering if it would be ok with you if I copy your layout and add it to my WebTrack system as a selectable layout? You will of course get credits for the layout and a link to where ever you want.

Let me know.

[mjs7231]

Not a problem at all Snille. The layout I used was actually based off the old layout from blockbuster.com. So I'm not sure how much credit I can really take from that.