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

If you made a template for printing or HTML export, you can offer it to the others here. You can also ask here for help about these templates
sandmanweb
Posts: 96
Joined: 2006-03-12 01:07:41

Post by sandmanweb »

I like your idea about the Rating system pointing to the Movie ID.
I don't delete entries, just adding some ;) So this would be the best choice for me. I just don't know how to do this... I have no knowledge with MySQL and very little in PHP. So your help would be very appreciated :)

Scripts found:

http://www.masugadesign.com/the-lab/scr ... ating-bar/

http://www.getfreesofts.com/script/351/ ... cript.html

http://www.best-php-scripts.com/rating_scripts.htm

With more search in Google we could find more.
I just didn't find the same as last time but some look good.

Thank you !
Tyrell66
Posts: 3
Joined: 2008-04-30 09:00:49
Location: Belgium

Error in installing

Post by Tyrell66 »

Hi everyone.

I installed the PK scripts and followed the install steps.
But I keep having this problem (see picture below). The only "thing" I see is that my php installation does not process "<?" tag, but requires "<?php". I tryed modifying those into every PK files, but it does not work better.

Solution found: I changed my default php setting for the "<?" tag in php.ini & it works directly fine. This point should be added in the requirements of the installation.

For the other having the problem, the php.ini setting is:

Code: Select all

short_open_tag = Off -> On
Cheers,
Tyrell66[/b]

Image
Madzsar
Posts: 1
Joined: 2008-05-01 09:34:56

SQL Injection and Cross-Site Scripting Vulnerabilities!!!

Post by Madzsar »

Warning!

PK-Designs PKs Movie Database 'index.php' SQL Injection and Cross-Site Scripting Vulnerabilities: http://www.securityfocus.com/bid/27713/info

Crackers: HouSSaMix & ToXiC350 [ H-T Team ]
sandmanweb
Posts: 96
Joined: 2006-03-12 01:07:41

Post by sandmanweb »

Do like me and put a password in your web server config to access the directory your PK database is installed ;)
kazgor
Posts: 175
Joined: 2006-05-08 13:13:52
Contact:

Re: SQL Injection and Cross-Site Scripting Vulnerabilities!!

Post by kazgor »

Madzsar wrote:Warning!

PK-Designs PKs Movie Database 'index.php' SQL Injection and Cross-Site Scripting Vulnerabilities: http://www.securityfocus.com/bid/27713/info

Crackers: HouSSaMix & ToXiC350 [ H-T Team ]
yeah i read about this last month, i did try putting a fix in using my not so great PHP knowledge.. haven't actually gotten round to testing this.

Basically it involved truncating those fields so they could only be 4 characters.. max.
sandmanweb
Posts: 96
Joined: 2006-03-12 01:07:41

Post by sandmanweb »

Someone found a solution for a visitors rating system ???
sandmanweb
Posts: 96
Joined: 2006-03-12 01:07:41

Post by sandmanweb »

OK, I did a php script to add ratings and comments on my movie database.

The script uses a mySQL database.

It's working fine as a standalone, but I don't know how to implement it to the PK movie template.

It won't allow anything to work.

The php functions won't work.

What do I need to do ???
robochief
Posts: 10
Joined: 2006-02-25 15:56:26

Post by robochief »

Hi, I downloaded fl0yd's last version, and it's working great except one issue:
when viewing a movie's details, the text in the movie description is out of the page width.
Why could this be happening?

I don't know if this could be a relevant info., but all actors on cast form one single link, not different links for each actor.


Here's an example.
Text is in spanish, but this happens on any language:
Image

EDIT:
Changing in the "Replace linebreaks by:" field, from value "\n" to "<b />" made it look like this:

Image
where actors now look right and text is correctly aligned, but actors links are still in one block. Hovering with the mouse the actors, it highlights all of them, as they form one single link.

and changing it to value "<p>" made it like this:
Image
where link are now seperate for each actor, but the url is all actors together.
For example:

Code: Select all

http://server/movies/index.php?view=LISTVIEW&page=2&search=%22Tommy+Lee+Jones%3Cp%3EJavier+Bardem%3Cp%3EWoody+Harrelson%3Cp%3EJosh+Brolin%3Cp%3EStephen+Root%3Cp%3EKelly+Macdonald%3Cp%3EGarret+Dillahunt%22
sandmanweb
Posts: 96
Joined: 2006-03-12 01:07:41

Post by sandmanweb »

The actors field must be used this way to look good:

caracter name (actor name), etc (etc), etc (etc),...
sandmanweb
Posts: 96
Joined: 2006-03-12 01:07:41

Post by sandmanweb »

sandmanweb wrote:OK, I did a php script to add ratings and comments on my movie database.

The script uses a mySQL database.

It's working fine as a standalone, but I don't know how to implement it to the PK movie template.

It won't allow anything to work.

The php functions won't work.

What do I need to do ???


Nevermind, I found a way to make everything work great.

I added the rating and comments feature for visitors.

They can do it directly from the PK movie database.

Glad of the result ;)

(I used the iframe tag to create a inner frame and allow everything to work)
sandmanweb
Posts: 96
Joined: 2006-03-12 01:07:41

Post by sandmanweb »

voici le résultat ;)

here is the result ;)



Image
robochief
Posts: 10
Joined: 2006-02-25 15:56:26

Post by robochief »

sandmanweb wrote:The actors field must be used this way to look good:

caracter name (actor name), etc (etc), etc (etc),...
Great, thank's for the tip. And reformatting them was a piece of cake with the IMDb script and the BatchMode turned on, matching directly with the URL, and ActorsLayout set with 2. :-D
lafafmentvotre
Posts: 19
Joined: 2007-01-29 19:21:22
Location: France

Post by lafafmentvotre »

Hi everybody

i want to know how to change the direction for my category in the front panel (i want an asc direction) ?

I search in the mdb_config.inc (sorting options)but i don't find

Thanks for help

PS : sorry for my english


Image[/img]
yennik
Posts: 3
Joined: 2008-06-23 13:37:45

Post by yennik »

Hi all,
I was wondering, if anyone using this script on Windows based machine.
I'm running it on my home PC, but cannot get images/covers to work. It uses UNIXPATH, so it works perfectly on UNIX machines, but not on Windows. It puts path to image as C:\Program Files\Apache....., so it leads to correct files, but covers are not displayed on pages.
Anyone solving same problem? I would appriciate any suggestions in that. Thanks.
kazgor
Posts: 175
Joined: 2006-05-08 13:13:52
Contact:

Post by kazgor »

yennik wrote:Hi all,
I was wondering, if anyone using this script on Windows based machine.
I'm running it on my home PC, but cannot get images/covers to work. It uses UNIXPATH, so it works perfectly on UNIX machines, but not on Windows. It puts path to image as C:\Program Files\Apache....., so it leads to correct files, but covers are not displayed on pages.
Anyone solving same problem? I would appriciate any suggestions in that. Thanks.
Can you right click on an image that does not show up and post the link to it.. that should tell you where if THINKS the images are located.

also double check in the MD3.PHP that you have the field is set

$this->UNIXPATH = dirname(__FILE__)."/";

and in the mdb_config.inc file make sure you correctly setup the

$this->config['options']['cover_dir'] = "antexport/";

so the above, in the directory containing mdb_config there a ANTEXPORT dir which is where i have my images.


I use EASYPHP for windows locally and the same files uploaded to my UNIX web host works fine without any mods.
kazgor
Posts: 175
Joined: 2006-05-08 13:13:52
Contact:

Post by kazgor »

[quote="lafafmentvotre"]Hi everybody

i want to know how to change the direction for my category in the front panel (i want an asc direction) ?

I search in the mdb_config.inc (sorting options)but i don't find

Thanks for help

PS : sorry for my english
[quote]

Sorry didn't see this post until now.

You can only sort the panels if you are using PHP5, some people have hosts that support PHP4&5 but defaults to php4.. you can switch to php5 by adding something in the HTACCESS file.. scan a few pages back you should find the exact line.. not sure works 100% time but good starting point.
yennik
Posts: 3
Joined: 2008-06-23 13:37:45

Post by yennik »

kazgor wrote: Can you right click on an image that does not show up and post the link to it.. that should tell you where if THINKS the images are located.

also double check in the MD3.PHP that you have the field is set

$this->UNIXPATH = dirname(__FILE__)."/";

and in the mdb_config.inc file make sure you correctly setup the

$this->config['options']['cover_dir'] = "antexport/";

so the above, in the directory containing mdb_config there a ANTEXPORT dir which is where i have my images.


I use EASYPHP for windows locally and the same files uploaded to my UNIX web host works fine without any mods.
Hi,

thanks for tips. However I have it set this way, but still no luck.

I have Apache/MySQL/PHP configured separately/manually.
Then I tried the EasyPHP and it WORKS! So I guess its some settings in configuration of PHP/Apache.
prikichi
Posts: 3
Joined: 2008-07-06 16:51:54

quote in image name

Post by prikichi »

Hi there,

Great script. Thanks a lot!!

A question. I've got some movies with quotes in the title like "Baby's day out". I'm using formattedtitle as picturename, so the quote is also in the name of the jpg. The quote is in the mysql table and PKmovies represents the name well, including the "'".

The 'default image' is not shown, so I think everything still goes well in the resize.php part:

$default_img = "default_cover.jpg";
$img = $_GET[img];

// Check the file exists, if not use the default
if (file_exists($img) == FALSE) {
$img = $default_img;

But when the file is finally retrieved, all I get is a red cross. I know I can change the picturenames, but is there a solution solving the quote question?
I've played around with htmlentities, add/stripslashes and str_replace, but so far it didn't help. Anyone who can help?

Update: I'm using PK Movie DB on localserver, XAMPP latest version under windows XP SP2

Thanks!!
Last edited by prikichi on 2008-07-11 00:06:50, edited 1 time in total.
prikichi
Posts: 3
Joined: 2008-07-06 16:51:54

Dutch language file

Post by prikichi »

For anyone interested

<?
/** ===============================================================================================
* Dutch Language file for MovieDB by PK-Designs.com
* @author: Prikichi *=============================================================================================== */
# Misc. words that people will find useful
$this->lang['APPNAME'] = "MDB3"; # Name of this application
$this->lang['ALL_MOVIES'] = "Alle Films"; # All Movies
$this->lang['MORE'] = "lees meer"; # More (when needed for cuting description)
$this->lang['UNKNOWN'] = "Onbekend"; # Unknown (Not Available)
$this->lang['ROLE'] = "Rol"; # Actor / Actress Role
$this->lang['MINUTES'] = "min."; # When displaying the length
$this->lang['FIRST'] = "Eerste"; # When linking to the First Page
$this->lang['LAST'] = "Laatste"; # When linking to the Last page

# TITLES - Title refrences for the cooresponding database field
$this->lang['NUM'] = "Index";
$this->lang['CHECKED'] = "Vinkje";
$this->lang['MEDIA'] = "Media";
$this->lang['MEDIATYPE'] = "MediaType";
$this->lang['SOURCE'] = "Serie";
$this->lang['DATEADD'] = "Datum Toegevoegd";
$this->lang['BORROWER'] = "Geleend aan";
$this->lang['RATING'] = "Cijfer";
$this->lang['ORIGINALTITLE'] = "Titel";
$this->lang['TRANSLATEDTITLE'] = "Vertaalde Titel";
$this->lang['FORMATTEDTITLE'] = "Geformatteerde Titel";
$this->lang['DIRECTOR'] = "Regiseur";
$this->lang['PRODUCER'] = "Producer";
$this->lang['COUNTRY'] = "Land";
$this->lang['CATEGORY'] = "Genre";
$this->lang['YEAR'] = "Jaar";
$this->lang['LENGTH'] = "Lengte";
$this->lang['ACTORS'] = "Acteurs";
$this->lang['URL'] = "Link";
$this->lang['DESCRIPTION'] = "Beschrijving";
$this->lang['COMMENTS'] = "Commentaar";
$this->lang['VIDEOFORMAT'] = "Video Formaat";
$this->lang['VIDEOBITRATE'] = "Video Bitrate";
$this->lang['AUDIOFORMAT'] = "Audio Formaat";
$this->lang['AUDIOBITRATE'] = "Audio Bitrate";
$this->lang['RESOLUTION'] = "Resolutie";
$this->lang['FRAMERATE'] = "Framerate";
$this->lang['LANGUAGES'] = "Talen";
$this->lang['SUBTITLES'] = "Ondertitels";
$this->lang['FILESIZE'] = "Bestandsgrootte";
$this->lang['DISKS'] = "Schijven";
$this->lang['PICTURENAME'] = "Afbeelding";
$this->lang['PERIOD'] = "Periode";

# PLURALS - A few dbfields need plurar definitions (Example: Other Contries)
$this->lang['_OTHER'] = "Anders";
$this->lang['MEDIATYPES'] = "Media Types";
$this->lang['SOURCES'] = "Series";
$this->lang['BORROWERS'] = "Leners";
$this->lang['COUNTRYS'] = "Landen";
$this->lang['CATEGORYS'] = "Genres";
$this->lang['YEARS'] = "Jaren";
$this->lang['VIDEOFORMATS'] = "Video Formaten";
$this->lang['AUDIOFORMATS'] = "Audio Formaten";

# PANELS - These words are used for the panels
$this->lang['JUMPTO'] = "Ga naar";
$this->lang['SEARCH'] = "Zoeken";
$this->lang['CLEARSEARCH'] = "Wis Zoekopdracht";
$this->lang['SUBMIT'] = "Uitvoeren";
$this->lang['CLEAR'] = "Wissen";
$this->lang['VIEW'] = "Raadplegen";
$this->lang['_ALL'] = "Alle";
$this->lang['_BLANK'] = "Onbekend";
$this->lang['_OTHER'] = "Andere";

# PAGES - Useful words for the page displays
$this->lang['PAGE'] = "Blz.";
$this->lang['NUMPERPAGE'] = "Aant./Blz.";
$this->lang['PREVIOUS'] = "Vorige";
$this->lang['NEXT'] = "Volgende";
$this->lang['GOTOPAGE'] = "Ga naar blz.";
$this->lang['SHOWING'] = "Actief";
$this->lang['OF'] = "van";

# SORT OPTIONS - (already defined RATING, YEAR, LENGTH)
$this->lang['SORT'] = "Sorteren";
$this->lang['TITLE'] = "Titel";
$this->lang['MOST_RECENT'] = "Nieuwste";

# RANDOM MOVIES
$this->lang['RANDOMMOVIES'] = "Willekeurige films";
sweborn
Posts: 12
Joined: 2007-10-17 23:16:52

Brake between lines

Post by sweborn »

Can you please help me. I want a space <br> between the end of a comment text and the next comment. Like:

Skrivet av: vader 2007-02-28 En riktigt bra sci-fi film,som jag varmt kan rekommendera.Filmen är baserad på serien Firefly som tyvärr bara gjordes i 14 avsnitt.Den här filmen skulle inte blivit till om det inte vore för alla fans som fullständigt exploderade när dom fick veta att serien skulle läggas ner. Det skickades protestbrev till FOX,det gick protest marscher, det samlades in pengar, så till slut gav FOX med sig, Filmen skulle bli av. Så tacka alla fans till serien Firefly för att Serenity blev till. PS:Glöm ej köpa Firefly ni blir inte besvikna. Visa vaders profil

Skrivet av: filmfantomen 2007-01-12 Jag har inte sett serien ( ska skaffa boxen så småningom). Men jag hade läst en hel del om serien och dess på tok för tidiga nerläggning. Så för min del kändes fortsättningsfilmen inte alls så främmande som det kunde ha varit. Det är en riktigt underhållande s-f historia o värld som Joss Whedon petat ihop. Mycket glatt överrasskad för Buffy blev jag aldrig imponerad på. Bra film, jag är väldigt sugen på serien också. Jag tror inte att firefly kommer att ha samma berg o dalbana som ex Family guy men jag hoppas att det görs fler filmer. 4/5 Visa filmfantomens profil

I'm not so good att scripting so please give me a careful description.
You can se what i mean here: http://swedenpirates.mine.nu/moviedb/index.php?num=506
Post Reply