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

[bobrap]

I with Kraviec, tried setting this up but I guess the code is smarter than me

[kazgor]

what hosting site are u both using.. i could probably knock something up for AWARDSPACE.com.. not sure about screenshots but a general overview.

[Sat_Wolf]

I have ad a "Comments" field in details.tpl, but how can i ad the "return lines" for the comments?

[Kraviec]

@kazgor, i was just trying to setup and run this template on local machine. Any instructions on how to set up this database will be helpfull.

[Delusion]

The application itself is great, good job

All my movies are xvids burned on DVDRs (5-6 per DVD).
Unfortunately its not handling well multi numbers. the SQL export only exports the first image of the CD, therefore I'm missing all ~4/5 of the images.

Also the php application it self, only can handle one number therefore, when I click on an ID link of some movie it always shows me the first movie on the CD.

Example of the current structure attached:


Is there any solution for that?

Regards,
Oleg G.

[bobrap]

what hosting site are u both using.. i could probably knock something up for AWARDSPACE.com.. not sure about screenshots but a general overview.

I'm using 1and1. I had been using dvdprofiler and the phpdvdprofiler. Got that to work, but I just can't get this. When importing the database with dvdprofiler, I remember using a schema.sql. Maybe I'm just not importing correctly. Any help is really appreciated.

p.s. REALLY like your movie site. Any chance of doing one for me? Is there a feature for just a list and then jump to the page with the cover? Smack me if I ask too much.

[blue334]

Just thought I'd mention a few things I noticed (and tweaked) when working with this template (which is so great btw, thanks):

- Translated titles are by default comma separated lists, and handled as such. This naturally does not work for those translated titles containing a comma. Since my catalog doesn't store more than one translation per movie anyway, I disabled the list and just print the whole string.

- Imdb ratings can be stored as real numbers now (and mine are). That means the default way of displaying the ratings doesn't work for me. My solution was to instead print the rating as a number.

- If you're on, say, page 4 and add a sort parameter so that the new selection is only 2 pages long, you remain on "Page 4 of 2". I think it would be better if it always jumped back to page 1 when changing sort parameters (but I don't know how to do that personally)

One odd thing I experienced which I don't think is the fault of the template, is with having the word "Proxy" in a movie title (as in "The Hudsucker Proxy"). Apparently MySQL or php doesn't allow that word, it chrashes the page.

[Thermal Ions]

- If you're on, say, page 4 and add a sort parameter so that the new selection is only 2 pages long, you remain on "Page 4 of 2". I think it would be better if it always jumped back to page 1 when changing sort parameters (but I don't know how to do that personally)

mjs7231 has already fixed this in 3.0.4 (viewtopic.php?p=22239#22239)- guess we'll all check out how once he has time to release it in between work.

On the "proxy" issue, I've seen cases where several other words or character combinations can play havoc when posting in forums ("python" being one). Forum admin indicated it was related to "low level apps" running on the server (apparently for security purposes).
________________________
Cheers.............Thermal

[J.P.]

I don's get it work.
I get te message Cannot connect to database with login
In mdb_config.inc i change
$this->config['mysql']['server'] = "<localhost>";
$this->config['mysql']['username'] = "<pal...>";
$this->config['mysql']['password'] = "<..........";
$this->config['mysql']['database'] = "<pal...>";
$this->config['mysql']['table'] = "<movies>";
The old one works ok with the samedatabase.
I have uploaded the new directory and used the database off the version 2.2.
What do i wrong...

[kazgor]

I don's get it work.
I get te message Cannot connect to database with login
In mdb_config.inc i change
$this->config['mysql']['server'] = "<localhost>";
$this->config['mysql']['username'] = "<pal...>";
$this->config['mysql']['password'] = "<..........";
$this->config['mysql']['database'] = "<pal...>";
$this->config['mysql']['table'] = "<movies>";
The old one works ok with the samedatabase.
I have uploaded the new directory and used the database off the version 2.2.
What do i wrong...

Get rid of the < and > inside the quotes eg

$this->config['mysql']['server'] = "localhost";

[J.P.]

I did it but now i get the message
Cannot connect to database localhost with login pal....

[kazgor]

I did it but now i get the message
Cannot connect to database localhost with login pal....

Did you remove the < and > for all your other database details? not just the localhost

[J.P.]

yes

Code: Select all

$this->config['mysql']['server']    = "localhost";
$this->config['mysql']['username']  = "pal...";
$this->config['mysql']['password']  = "........";
$this->config['mysql']['database']  = "pal...";
$this->config['mysql']['table']     = "movies";

The old 2.2 i used localhost
That must be here the same?
The version 2.2 was

Code: Select all

$db = new mysql_db("localhost", "pal...", "......");
$moviedb = new Moviedb($db, "pal...", "movies");

Maybe i do something else wrong...
Must i change somthing on index.php

I have only upload the file and change mdb_config.inc.

[xyncro]

nice template, i must say..

i have some questions thoo..

would it be possible to replace country box on the left side
with a box of letters instead? - how?

how do i change where the boxes are located?
i would like to have it like this instead..
[Category]
[Letter] - (# | A-Z | Å | Ä | Ö)
[Year]
[Language]

thx..

[J.P.]

I did it but now i get the message
Cannot connect to database localhost with login pal....

Did you remove the < and > for all your other database details? not just the localhost

I have ask what version i have and i have PHP 4.3.9 en MySQL 3.23.58.
Is that the reasen that it not work?

[s4m1]

HI!

Is there a way add Languages and Subtitles in the movie info?

this is what i mean...

Year:
Date Added:
Video Format:
Languages:
Subtitles:
Category:
Length:
Director:
Producer:

My movie gatalog is only dvd movies ~400 and i could use those infos.

Sorry my BAD english

[blue334]

I made a few modifications like that for my site, don't know if it is "correct" but it works. In your case the change to detail_view.tpl would be (additions spaced out):

Code: Select all

          # --- RESULTS MOVIES --------------------------
          <div class='movies MAINVIEW'>
            {MOVIES}
              <div class='movie num_$MOVIE[NUM] curvy1'>
                <div class="bl"><div class="br"><div class="tl"><div class="tr content">
                  <table cellpadding='0' cellspacing='0' border='0'><tr><td class='images' valign='top'>
                    <a class='cover' href='$MOVIE[HREF]'>
                      <img src='$TEMPLATEDIR/images/resize.php?img=$UNIXDIR$COVERSDIR$MOVIE[PICTURENAME]&w=75' alt='$MOVIE[FORMATTEDTITLE]' title='$MOVIE[FORMATTEDTITLE]' />
                    </a>
                  </td><td class='details' valign='top' width='100%'>
                      <div class='num'>$MOVIE[NUM]</div>
                      <div class='title'><a href='$MOVIE[HREF]'>$MOVIE[ORIGINALTITLE]</a></div>
                      {TRANSLATEDTITLES;1}<div class='translated'>$TRANSLATEDTITLE[TITLE] $TRANSLATEDTITLE[PAREN]</div>{/TRANSLATEDTITLES}
                      <div class='imdb'><a class='rating_$MOVIE[RATING]' href='$MOVIE[URL]'><span>$MOVIE[RATING]</span></a></div>
                      <div class='quickinfo'>
                        <div class='year'><b>$LANG[YEAR]: </b><a href='$MOVIE[YEAR_HREF]'>$MOVIE[YEAR]</a></div>
                        <div class='dateadd'><b>$LANG[DATEADD]: </b>$MOVIE[DATEADD]</div>
                        <div class='videoformat'><b>$LANG[VIDEOFORMAT]: </b><a href='$MOVIE[VIDEOFORMAT_HREF]'>$MOVIE[VIDEOFORMAT]</a></div>

				<div class='languages'><b>$LANG[LANGUAGES]: </b><a href='$MOVIE[LANGUAGES_HREF]'>$MOVIE[LANGUAGES]</a></div>
				<div class='subtitles'><b>$LANG[SUBTITLES]: </b><a href='$MOVIE[SUBTITLES_HREF]'>$MOVIE[SUBTITLES]</a></div>

                        <div class='category'><b>$LANG[CATEGORY]: </b>
                          {CATEGORYS;, }<a href='$CATEGORY[HREF]'>$CATEGORY[TEXT]</a>{/CATEGORYS}
                        </div>
                      </div>
                      <div class='description'>$MOVIE[DESCRIPTION](400)</div>
                      <div class='actors'><b>$LANG[ACTORS]: </b>{ACTORS;3;, }<a href='$ACTOR[HREF]'>$ACTOR[NAME]</a>{/ACTORS}</div>
                  </td></tr></table>
                  <div class='err err_$MOVIE[NUM]'>No movies found with selected criteria.</div>
                </div></div></div></div>
                <div class="iefix"> </div>
              </div>
            {/MOVIES}
          </div>

In the same manner I added full specifications for each movie entry to the details pages of my site (it's mostly dvd rips though, for dvds this amount of detail makes less sense):
http://blue334.awardspace.com

[s4m1]

Thanks, that did the trick.

[blue334]

A couple additional problems...

There seems to be some unwanted behavior related to the Side panel configuration in mdb_config.inc. If I set e.g. YEAR panel not to display, and then click a year (e.g. 1947) in the details list, the link becomes
.../index.php?search=1947
not
.../index.php?year=1947 which would have been much better.
This seems to apply to all panels. Is there any way to change this behavior?

A related problem occurs with the setting of the MINIMUM option in the side panels. For instance, I have set the minimum for COUNTRY to 10. If I click a country name link for a country below the target value, it returns all _OTHER country movies (a huge useless selection). The minimum option is a must-have for the panels, but shouldn't override a regular and sensible query for a country selection.

[J.P.]

Is er niemand die mij kan helpen met mijn probleem?