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

lestatou · Post by **lestatou** » 2007-01-16 14:45:23

Great job mjs7231 !!!

I can't download the new version... the url crashes. I have this error

"Warning: require_once(pkdesigns_page.inc) [function.require-once]: failed to open stream: No such file or directory in /home/.hela/mjs7231/pk-designs.com/apps/moviedb/index.php on line 10

Fatal error: require_once() [function.require]: Failed opening required 'pkdesigns_page.inc' (include_path='.:/usr/local/php5/lib/php:/home/mjs7231/pk-designs.com/.modules:/home/mjs7231/pk-designs.com/.views') in /home/.hela/mjs7231/pk-designs.com/apps/moviedb/index.php on line 10"

I hope the error is temporally

lestatou · Post by **lestatou** » 2007-01-16 17:39:05

mjs7231 has told me that tonight he will repair the donwload.

vipyammer · Post by **vipyammer** » 2007-01-16 21:36:03

Hi,

Just saw the working sites...great. So, decided also to use moviedb_v3.0.3.

Created within AMC a small db...Exported into my SQL (Succesfull)...Changed the following lines in mdb_config.inc;
$this->config['mysql']['server'] = "localhost";
$this->config['mysql']['username'] = "vip_film";
$this->config['mysql']['password'] = "xxxx";
$this->config['mysql']['database'] = "vip_film";
$this->config['mysql']['table'] = "jos_filmdb";

Pictures also added into the folder antexport but when starting to browse the following error appears;
SELECT SOURCE,count(*) FROM `vip_film`.`jos_filmdb` GROUP BY SOURCE ORDER BY SOURCE

Invalid Query: Unknown column 'SOURCE' in 'field list'

My SQL knowledge is minimum...but what I'm doing wrong? Forgotten something?

Please...Need some help with this...

Vipyammer

kazgor · Post by **kazgor** » 2007-01-16 22:21:31

Hi Vip.

Sounds like you did not export the Source field from AMC. For less hassel i always export all the fields from AMC.

The Source field is but one of the many side panels that MDB3 supports.

Give it a go

lestatou · Post by **lestatou** » 2007-01-16 22:38:23

can someone send me the new version to my mail? please...

lestatou@gmail.com

Thanks

kazgor · Post by **kazgor** » 2007-01-16 22:48:08

lestatou wrote:can someone send me the new version to my mail? please...

lestatou@gmail.com

Thanks

I've uploaded a copy of 3.0.3 to http://www.mytempdir.com/1170630

Let me know if you have similar problems with the size panels when it should recalculate the numbers when you choose the different fields in the side panels.

lestatou · Post by **lestatou** » 2007-01-17 02:04:33

Thanks kazgor... I've downloaded it...

I don't understand you very well, sorry.

See my php http://lestatou.iespana.es/index.php

As you see, I have some problems...

1º: first of all, I have put images at antexport/ folder, but continues the error.

2º:I want to change the "font size" of the items which are in "englihs.inc" too, but I don't know how. I have read this
"4. Add the following code to the page you want this script to be displayed. Don't forget to
also include the style sheet within the header of your HTML file to get the stylesheet link
you can use the function $moviedb->get_stylesheet().
require_once('mdb3.php');
$moviedb = new MDB3();
print $moviedb->get_html();"

but I don't know how to do this

This version es more difficult to configure for me

I hope to solve my problems step by step...

PD: the "auto import sql" rules ok!! Great job !

vipyammer · Post by **vipyammer** » 2007-01-17 06:23:08

Kazgor,

Thanks...exported all the fields from AMC and working now...

Geez,
Vipyammer

mjs7231 · Post by **mjs7231** » 2007-01-17 15:20:51

Sorry guys, I didn't get to fix the site last night. I have a client project with a tight deadline I need to focus on until early Feb. I should get the main site working shortly, but until then.. here is the release directory.

Development Demo: http://pkwebstudio.com/apps/moviedb/mdb3.php
Download Folder: http://pkwebstudio.com/apps/moviedb/_release/

kazgor · Post by **kazgor** » 2007-01-17 15:29:38

MJS.. hopefully you'll spot this soon..

been experimenting with 3.03, and if i use a webserve with PHP 4.4.4 (latest in php4) then the panels dont recalculate, but if then switch the to PHP5 (5.2.0) it then works.

So guess i now need to track down what the main differences might be between the they two versions.. and try narrow it down further.

Just out of interest, what are the specs of you PHP/MySQL so i know if im on the right track?

cheers matey!

mjs7231 · Post by **mjs7231** » 2007-01-17 15:33:08

I'll look up the exact version numbers tonight. I know I am running PHP5 on both servers, not sure about the MySQL versions.

kazgor · Post by **kazgor** » 2007-01-17 16:18:47

mjs7231 wrote:I'll look up the exact version numbers tonight. I know I am running PHP5 on both servers, not sure about the MySQL versions.

seems the SQL version is not important.. just the PHP.. so guess v3 is possible just PHP5 only

well for the side panels)

I was testing using XAMPP, it comes with PHP4 & 5, and a nice little batch file to flip between the two versions.

ta for checking though.

kazgor · Post by **kazgor** » 2007-01-17 21:07:57

lestatou wrote:Thanks kazgor... I've downloaded it...

I don't understand you very well, sorry.

See my php http://lestatou.iespana.es/index.php

As you see, I have some problems...

1º: first of all, I have put images at antexport/ folder, but continues the error.

2º:I want to change the "font size" of the items which are in "englihs.inc" too, but I don't know how. I have read this
"4. Add the following code to the page you want this script to be displayed. Don't forget to
also include the style sheet within the header of your HTML file to get the stylesheet link
you can use the function $moviedb->get_stylesheet().
require_once('mdb3.php');
$moviedb = new MDB3();
print $moviedb->get_html();"

but I don't know how to do this

This version es more difficult to configure for me

I hope to solve my problems step by step...

PD: the "auto import sql" rules ok!! Great job !

Hi,

first on 1.. i think but not 100% sure but it could be that its because you have exported the Images filenames with spaces eg.. lestat movie list, try naming your catalogue without spaces.

2. you need to go into the Template\default folder and look at style.css to make changes to the appearance such as colour, fonts etc.

eg for the translate title that is small and a darker colour to the main movie title the CSS it uses is

#mdb .DETAILS .translated { font-size: 11px; color: #655D49; }

and for the main title the css is

#mdb .DETAILS .title { font-size: 18px; }

so you can see the main title is 18pixels, compared to 11px for translate title.

You really just need to experiment in here and try some and see what effect it gives.. then read up on CSS to get a better understanding.

Hope that helps

lestatou · Post by **lestatou** » 2007-01-18 00:51:57

Thanks again, kazgor.

I've changed to other domain server, jeje... At iespana the php v3 doesn't runs ok. I only changed my domaing and it goes ok, jeje. Now I'm experimenting about many things... jeje.

I want to add some information about displaying info of every movie like media type, etc.... I have asked some friends but they say that it is very dificult.

See it. jeje.

http://lestatou.orgfree.com/index.php

I have seen that autoexport/import only took 320 movies, not 1045 totally

I'll try any times... The solution to import 1045 movies was copy-paste the code in 3 times

Tele · Post by **Tele** » 2007-01-21 15:53:49

Great template, thank you

One futurerequest; sort by index would be an welcome addition

kazgor · Post by **kazgor** » 2007-01-21 16:16:48

Tele wrote:Great template, thank you

One futurerequest; sort by index would be an welcome addition

You can do this by a simple addition to the MDB_CONFIG.INC file.

just add $this->config['sorts']["NUM"]['direction'] = "ASC"; after all the other $this->config['sorts'] lists.

so it will just look like.

Code: Select all

$this->config['sorts']["ORIGINALTITLE"]['direction'] = "ASC";
$this->config['sorts']["YEAR"]['direction'] = "DESC";
$this->config['sorts']["RATING"]['direction'] = "DESC";
$this->config['sorts']["DATEADD"]['direction'] = "DESC";
$this->config['sorts']["LENGTH"]['direction'] = "ASC";
$this->config['sorts']["NUM"]['direction'] = "ASC";

you can pretty much add any other fields into the above list so you can create your own sort preferences.

Thermal Ions · Post by **Thermal Ions** » 2007-01-24 12:53:11

Looks great mjs

I look forward to replacing my current version 2.2 this weekend (time permitting), and probably doing some tweaking just for the heck of it.

I'm sure that many others feel the same as I do, in thanking you for your kindness in sharing your development work with the amc community.

mjs7231 · Post by **mjs7231** » 2007-01-24 20:10:50

Thanks Thermal
3.4 is pretty much done, I just never packaged it up yet. There are quite a few bug fixes you may want to wait for.
---------

For everyone else.. After 3.4 is released, I may start work on 4.0. I know I said version 3 would probably be my last big release. This whole template idea worked our great, but it also made me realize how much extra code / pain in the but it is over just using a simple PHP file as a template over 'my own' format. In any event, when I rip out this stuff you can look forward to om 4.0 (no planned dates yet)..
- About 1/2 as much code (easier to understand / use)
- Ability to use PHP in templates
- Faster processing times.. (initial guess 1/2 as much time)

kazgor · Post by **kazgor** » 2007-01-24 20:43:13

wow MJS.. its only gets better.. you really are spoilling us.

Will 3.4 work with PHP4? I've pretty much think the Side Panel numbers is down to PHP4 vs PHP5.. i've uploaded the script onto 110mb.com which uses php5 and it works fine.. but on php4 hosts it doesnt

unfortuantly this is as far as my knowledge can take me.. no biggy for me, 110mb actually offer more space & bandwidth compared to awardspace.

I do like you template design, i've had a play around at the moment and its good.. although i wanted to do that alternating colour you have going in the List view but for the Staring/Roles block in the Details template, but it looks like the ACTORS field does not have a $NEXT_ACTORS variable unlike in movies you have $NEXT_MOVIES. well it might have and i did something wrong.

I'll look forward to testing out 3.4

oh on a side note.. you may have notice (or not) that the IMDB and Covers logo have a blue border around them and once clicked they turn magenta.. this is because they are links so a border is showing around the images.. I got rid of it by modifying the CSS and adding border:0

Code: Select all

#mdb .movies A.cover IMG        { border:0; width: 75px; height: 110px; margin: 0; padding: 0px; text-decoration: none; }

mjs7231 · Post by **mjs7231** » 2007-01-27 04:37:06

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