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

cobracio · Post by **cobracio** » 2007-01-28 13:02:04

Hey MJS,

pretty nice.
Looking forward to 4.0.
PHP in scripts would be nice

.

kazgor · Post by **kazgor** » 2007-01-29 23:41:51

mjs7231 wrote:Thanks kazgor,

The border around images will be in 3.4. I haven't found a decent PHP4 server to test this script on, and I just have been too lazy to do so..

I'm still working on client work with my nights, when I actually feel like touching a PC after 8 hours of it at work, so releases are spreading apart.

- Mike

Oh i know how you feel.. i work as an IT manager so get to spend all day on a PC so usually dead knackered at nights.

for PHP4 server, i do recommend Awardspace.com, its pretty easy to get a test site up so you can test out PHP4. if you wish to just run a local server then give EASYPHP.FR a try it comes prepackage with all u need.

some suggestions before you release the 3.0.4 package (if you have the time).

1. On-hover over IMDB rating show IMDB link rather than the text External Link.
2. Remove the blue borders around cover&imdb (nice simple css tweak)
3. Make IMDB link open in a new window (perhaps an option in config?) for those that don't care about w3c XHTML strict standards.
4. in detail view.. make the Starring/Roles table 100% and cells 50% each, it just alot looks neater

if you can do it great, but no worries if you can't.

lestatou · Post by **lestatou** » 2007-01-30 11:51:19

Hi friends, finally I have moved to awardspace.com, jeje.

I have a problem at http://lestatou.awardspace.com/mdb3.php, If I click on a movie, it doesn't shows the details... it returns to "index".
I don't have edited the code, so I don't know what it happens.

Probably I'll wait to new version.

PD: Kazgor, thanks for your explanation about font on templates... I haven't had any time to experiment, but thanks !

Thermal Ions · Post by **Thermal Ions** » 2007-01-30 14:04:30

@lestatou

I note that the movie number is not appearing in the top right hand corner of each of your movie summaries on the index.php page. Check out where it's supposed to appear here - http://pkwebstudio.com/apps/moviedb/index.php (I'll eventually get mine db off my local server and onto the web).

I also tried to view your movies by pasting in the link that should be appearing e.g. http://lestatou.awardspace.com/index.php?num=2, however ended up with

SELECT * FROM `lestatou_movies`.`movies` WHERE NUM=2
Invalid Query: Unknown column 'NUM' in 'where clause'

This leads me to believe that you maybe haven't exported the complete database from AMC - specifically, you haven't exported the Number field (or alternatively, haven't imported it into your MySQL database table).

Cheers.....Thermal Ions

mjs7231 · Post by **mjs7231** » 2007-01-30 14:19:31

if you can do it great, but no worries if you can't.

Hehe,

Don't worry worry about touching any sensitive spots Kazdor. I can take it. I will surly get these out within the week. Having a list helps, so thanks.

- Mike

lestatou · Post by **lestatou** » 2007-01-30 15:51:06

Sorry, I knew that i had to export all fields... Thanks Thermal Ions. It was the problem.

Know I'm going to translate the file english.inc to spanish.inc and send to mjs7231

Thermal Ions · Post by **Thermal Ions** » 2007-01-31 08:31:42

Have set up 3.0.3, and come up with a few comments / suggestions etc

very professional looking
I've tweaked the width to 90% in index.php to maximise the display efficiency on my widescreen monitor. As the covers view is hardcoded to display 4 covers across there's as much gap either side as there is space taken up by the covers. I've settled for the moment on changing it to display 6 covers across as this is passable on WS display and still works on wife's standard width display. What I'd like to be able to have the script do is to read the width of the browser window, and based upon that dynamically display an appropriate number of covers across (e.g. <=800 - 4 across, 1024 - 6 across, >=1280 - 8 across). I've found that it can apparently be done in javascript, but could such a thing be incorporated into the php?
If you are on say page two of your unfiltered movies ("showing 11-20 of ...") and apply a filter by clicking on a link within one of the displayed movies, that returns less than 10 movies (e.g. 5 movies) then you end up with page "2 of 1", "showing 11-5 of 5" and no movies displayed. You need to click on the previous link to actually display the movies. Don't know how easy it is to rectify that to have it automatically go to page one in such cases
By the way, what's the (Queries: 15) bit in the footer for?

Cheers.............Thermal Ions

kazgor · Post by **kazgor** » 2007-01-31 17:09:05

@lestatou

You may notice that on your site, your country panel is not seperating
the different countries. so you are getting a very big panel.

You can fix this by editting your mdb_config.inc file and change the following line from

Code: Select all

$this->config['options']['comma_seperated']     = array("TRANSLATEDTITLE", "DIRECTOR", "PRODUCER", "CATEGORY", "ACTORS", "LANGUAGES", "SUBTITLES");

to

Code: Select all

$this->config['options']['comma_seperated']     = array("COUNTRY", "TRANSLATEDTITLE", "DIRECTOR", "PRODUCER", "CATEGORY", "ACTORS", "LANGUAGES", "SUBTITLES");

Basically you're telling MDB3 that the country field contains commas and should be treated the same way it does the Category field.

lestatou · Post by **lestatou** » 2007-01-31 23:46:24

Thanks a lot Kazgor. Anytime you are my master, jeje.

Do you know how can I change the order of "original title" and "translated title". Now it shows this.

Somebody Up There Likes Me (original)
Marcado Por El Odio (translated)

and I want to show

Marcado Por El Odio (translated)
Somebody Up There Likes Me (original)

mjs7231 · Post by **mjs7231** » 2007-02-01 14:41:33

very professional looking

Thanks.

What I'd like to be able to have the script do is to read the width of the browser window, and based upon that dynamically display an appropriate number of covers across (e.g. <=800 - 4 across, 1024 - 6 across, >=1280 - 8 across).

An easier method might be to play around with the template a bit. Remove the table that displays the movies covers, put each one into a DIV. In your CSS, you can set this div as the following. Of course you may have to play with the width and height values. this should auto-wrap as many movies as fit.

display: block;
float: left;
width: 100px;
height: 150px;

If you are on say page two of your unfiltered movies ("showing 11-20 of ...") and apply a filter by clicking on a link within one of the displayed movies, that returns less than 10 movies (e.g. 5 movies) then you end up with page "2 of 1", "showing 11-5 of 5" and no movies displayed.

Already fixed in version 3.4, just need to release this..

By the way, what's the (Queries: 15) bit in the footer for?

This is mostly a debugging thing, but I'm a sucker for stats, so I left it in there. It's a simple counter showing the number of times I ran an SQL query against the database. Most the of the queries are small, but these add up and can slow down the script if we do too many.

xbirdtrip · Post by **xbirdtrip** » 2007-02-02 02:27:49

lestatou wrote: Do you know how can I change the order of "original title" and "translated title". Now it shows this.

Somebody Up There Likes Me (original)
Marcado Por El Odio (translated)

and I want to show

Marcado Por El Odio (translated)
Somebody Up There Likes Me (original)

In the french translation that i send by PM at mjs7231, i make that.

You can take this file here :
http://xbird.free.fr/Script_PHP/modif_moviedb_3.03.rar

The modifications which you want are here :

In detail_view.tpl lines 119 and 120
And in details.tpl lines 31 and 32

[/list]

lestatou · Post by **lestatou** » 2007-02-02 12:32:46

Thanks xbirdtrip

If I choose this view

http://lestatou.awardspace.com/index.php?view=LISTVIEW

it shows original title. I suppose that I can change it at files tpl... I'll take a look after launch, tranks again.

PD: i have no idea about php, jeje

xbirdtrip · Post by **xbirdtrip** » 2007-02-03 09:14:20

lestatou wrote:Thanks xbirdtrip

If I choose this view

http://lestatou.awardspace.com/index.php?view=LISTVIEW

it shows original title. I suppose that I can change it at files tpl... I'll take a look after launch, tranks again.

PD: i have no idea about php, jeje

In list_view.tpl

Line 111 replace

Code: Select all

<th class='title'>$LANG[ORIGINALTITLE]</th>

By

Code: Select all

<th class='title'>$LANG[TRANSLATEDTITLE]</th>

Line 119 replace

Code: Select all

<td class='title'><a href='$MOVIE[HREF]'>$MOVIE[ORIGINALTITLE]</a></td>

By

Code: Select all

<td class='title'><a href='$MOVIE[HREF]'>{TRANSLATEDTITLES;3}$TRANSLATEDTITLE[TITLE] $TRANSLATEDTITLE[PAREN]{/TRANSLATEDTITLES}</a></td>

Line 125 replace

Code: Select all

<td class='title'><a href='$MOVIE[HREF]'>$MOVIE[ORIGINALTITLE]</a></td>

By

Code: Select all

<td class='title'><a href='$MOVIE[HREF]'>{TRANSLATEDTITLES;3}$TRANSLATEDTITLE[TITLE] $TRANSLATEDTITLE[PAREN]{/TRANSLATEDTITLES}</a></td>

And read your PM please

lestatou · Post by **lestatou** » 2007-02-04 13:31:06

Done

Thanks a lot. See your pm. I'm very very happy !

Sat_Wolf · Post by **Sat_Wolf** » 2007-02-09 11:27:22

Thanks for the great Template!

I have a litle problem....I have separated the CATEGORY fields with "/"...all other field´s with ",". Is this possible to change the Code so that the Category field´s separate with "/"? or must I change in all my movies (600) the / to ,? Or if there a tool to change this automatically?

lestatou · Post by **lestatou** » 2007-02-09 11:45:38

Hi Sat_Wolf, I suppose you can change the code, but I don't know how now.

However, you can try to "replace" all yours "/" with "," with a software like "word - microsoft office". Theres is an option to do it. Search and replace... Try it (of courser wiht a backup of your files).

See you.

Sat_Wolf · Post by **Sat_Wolf** » 2007-02-09 12:43:53

I mean that is a bad idea. When i do this, than all url´s convertet also.

mjs7231 · Post by **mjs7231** » 2007-02-09 17:47:15

Sat_Wolf wrote:I mean that is a bad idea. When i do this, than all url´s convertet also.

Once you have the information in a database, its easy to fix. Maybe its worth writing a 3 or 4 line script to do this for you. You should be able to execute the below query to fix the values using SQLYog, or PHPMyAdmin..

*** This is an untested SQL query ***
UPDATE `<dbname>`.`<tbname>` SET CATEGORIES=REPLACE(CATEGORIES, "/", ",");

If you want this done automatically, you might consider adding to the portion of code that does the auto-import. Add the 3 lines of code to execute this additional query after the auto import.

If I get a chance, I may be able to help you with more than just the theory of how this will work..

Sat_Wolf · Post by **Sat_Wolf** » 2007-02-10 09:08:52

THX, is a fine idea and it functionally very well.

The next problem...i will change TRANSLATEDTITLE and ORIGINALTITLE in all views. What must i change?

Kraviec · Post by **Kraviec** » 2007-02-13 20:08:03

hi !
i really love this template, but im a total noob in php, sql etc... so i have one question:

is there any chance to make an instruction "how to set up everything to make this work fine" with screens or something....

Please help me beacouse i love the look of this template !!!

ohh and sorry for my english im still learning.