PKs Movie Database 3.0.3 modification by sweborn

[the_observer]

Thanks droopy57 ,

it is working quite alright.

The only problem is that when in covers view (mini ,normal or xxl) when i mouse over, the title is not displayed ,only the year.

I will try to figure out where this can be fixed from but if you can advice something i will be much obliged.

Thank you for your time.

Regards,
the_observer.

[droopy57]

Hi !

In files

• cover_view.tpl
  cover_view2.tpl
  cover_view.tpl
  details.tpl
  detail_view.tpl

Replaces: $ MOVIE [TRANSLATEDTITLE]

by $ MOVIE [ORIGINALTITLE]

[the_observer]

Thank you very much droopy57.

It is working like a charm now except one small glitch.
When in list view if i click on a translated name it will open up the window with movie details.But since i have many movies with empty translated titles i can not click them.
Of course i am quite happy with your help and how is working the modification for me right now so this is not bothering for me.

Also since i do not know much i also try to learn so if i may ask are the below correspondents correct?

cover_view.tpl is small covers
cover_view2.tpl is covers (medium size)
cover_view3.tpl is coversXL
details.tpl is details view
detail_view.tpl is list view

Much obliged,
the_observer.

[droopy57]

Hi

I will look tomorrow to your problem of links

• cover_view.tpl is small covers Yes
  cover_view2.tpl is covers (medium size) Yes
  cover_view3.tpl is coversXL yes
  details.tpl is details view No : is details view in lightbox
  detail_view.tpl is list view No : is details view
  list_view.tpl is list view

[the_observer]

Thank you droopy57.

Also i would like to ask by which field does it sort when we choose date added.

It seems that it does not sort by date added field of AMC.
It seems it sorts by number field of AMC.

UPDATE
With phpmyadmin i notice that all DATEADDED fields are 0000-00-00
Maybe this is why it does not sort by date added.
This is strange.The values for this field shouldn't have been imported as well?

UPDATE2
From help of AMC i read:
For movie fields, the date is stored using Borland's TDateTime: number of days since 30/12/1899.
but in db the fields shows as 0000-00-00
Can this be why the values are not importing in the DATEADDED field?

Regards,
the_observer.

[droopy57]

Hi the_observer

It is a small 'bug' of AMC
This will be corrected in the next version
viewtopic.php?t=5634

In the meantime:

Before uploading to your server
- Open your sql file
- Research : '''
- Replace all by : '

[the_observer]

Oh , i see .

[Wikio22]

Merci!

[Wirtick]

Thank you very much. This is very useful!

[pele]

Hi,

I want to make some modifications but don't know where to start .

Can someone give me some useful hints where to start.

1. I want to translate some english/french words in dropdown menu "view list" and "sort by" in the main view
For example : liste ==> lijst
2. How can i change the description size of the movie not the whole text is seen.
3. how can i add the antmoviecatalog field checked (yes/no) to the template?
i use this field in antp to know if i have seen the movie yes or no.

thanks,
bianca [/code]

[droopy57]

Hi pele

For your first question :

- download and replace the file: "languages/english.inc"
- opens the file, making the changes in your language and saves it as "dutch.inc" for example
- change your config in "mdb_config.inc.php" : $this->config['options']['language'] = "dutch";


For other questions I will look later
Good day

[pele]

Hi pele

For your first question :

- download and replace the file: "languages/english.inc"
- opens the file, making the changes in your language and saves it as "dutch.inc" for example
- change your config in "mdb_config.inc.php" : $this->config['options']['language'] = "dutch";


For other questions I will look later
Good day

Thanks droopy57 i downloaded and changed some words. It works sofar.

[pele]

Hi

For other questions I will look later
Good day

Hi,

Question 2 i found out what the problem is. Parently strange signs like ë etc. aren't accepted. I import the sql db with option utf8. Is there a solution?

Question 3 i add in the left side pannel a checked (this is for movies i watched or not .

Thanks,
Bianca

[antp]

AMC's export is not UTF8.
If you use a west-european language, the right character set would be most likely windows-1252, iso-8859-1, or latin-1
If you wish to be able to import as UTF8, you have to open the SQL file in notepad (or another text editor) then in the Save As dialog select UTF8 as encoding.

[droopy57]

Question 2 i found out what the problem is. Parently strange signs like ë etc. aren't accepted. I import the sql db with option utf8. Is there a solution?

It is possible to encode the sql file online. try this:
in your mdb3.php, search

Code: Select all

if (rename($sqlfile, $rn_sqlfile)) {

and add this below

Code: Select all

# encode sql file to utf8
$fp = fopen($rn_csvfile,"r");
while (!feof($fp)) {
	$ligne .= iconv("WINDOWS-1252", "UTF-8", fgets($fp));
} 
fclose($fp);
$fp=fopen($rn_csvfile,"w+");
fwrite($fp,$ligne);
fclose($fp);

[pele]

AMC's export is not UTF8.
If you use a west-european language, the right character set would be most likely windows-1252, iso-8859-1, or latin-1
If you wish to be able to import as UTF8, you have to open the SQL file in notepad (or another text editor) then in the Save As dialog select UTF8 as encoding.

Above workaround is working, i see now the whole movie description however the text changed from: Eén (text in ANTP) to Eén (in pk's moviedb) which is not correct.

[pele]

Question 2 i found out what the problem is. Parently strange signs like ë etc. aren't accepted. I import the sql db with option utf8. Is there a solution?

It is possible to encode the sql file online. try this:
in your mdb3.php, search

Code: Select all

if (rename($sqlfile, $rn_sqlfile)) {

and add this below

Code: Select all

# encode sql file to utf8
$fp = fopen($rn_csvfile,"r");
while (!feof($fp)) {
	$ligne .= iconv("WINDOWS-1252", "UTF-8", fgets($fp));
} 
fclose($fp);
$fp=fopen($rn_csvfile,"w+");
fwrite($fp,$ligne);
fclose($fp);

I changed it into this :

Code: Select all

if (rename($sqlfile, $rn_sqlfile)) {
# encode sql file to utf8 
$fp = fopen($rn_csvfile,"r"); 
while (!feof($fp)) { 
   $ligne .= iconv("WINDOWS-1252", "UTF-8", fgets($fp)); 
} 
fclose($fp); 
$fp=fopen($rn_csvfile,"w+"); 
fwrite($fp,$ligne); 
fclose($fp);
                    # Select our Database (Ant's export doesn't know the DB)

However this is not working the text ends just before the beginning of the word Eén.

[Witko]

Keep up the good work mate!

[pele]

Hi Droopy57,

I don't know if it's to much to ask however i can't get your template working.
(get the error SELECT * FROM `moviesbc`.`moviesbc` ORDER BY DATEADDED DESC, NUM DESC LIMIT 0,20
Invalid Query: Unknown column 'DATEADDED' in 'order clause')

So i use the template created by Sweborn and it's working (thanks to you too). I changed the template a little bit here and the there (i'm still learning).

What i want is your + signs at the left column to expand/ collapse a particular header implement in the Sweborn template. The header category is very long .

Can you tell me what i should change in which file?
If it's to much to ask then don't hesitate to so no.

Thanks Bianca

[droopy57]

Hi Droopy57,

I don't know if it's to much to ask however i can't get your template working.
(get the error SELECT * FROM `moviesbc`.`moviesbc` ORDER BY DATEADDED DESC, NUM DESC LIMIT 0,20
Invalid Query: Unknown column 'DATEADDED' in 'order clause')

So i use the template created by Sweborn and it's working (thanks to you too). I changed the template a little bit here and the there (i'm still learning).

What i want is your + signs at the left column to expand/ collapse a particular header implement in the Sweborn template. The header category is very long .

Can you tell me what i should change in which file?
If it's to much to ask then don't hesitate to so no.

Thanks Bianca

Hi
Ok, I'll try to explain :

- First you need to download these files:
ddaccordion.js - minus.png - minus_over.png - plus.png - plus_over.png - loading2.gif.
The "js" should be placed in: templates/default/javascript/
The images files must be placed in: templates/default/images/panel/

- In your index.php you need to have these lines

Code: Select all

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript" src="templates/default/javascript/ddaccordion.js">
/***********************************************
* Accordion Content script- (c) Dynamic Drive DHTML code library (www.dynamicdrive.com)
* Visit http://www.dynamicDrive.com for hundreds of DHTML scripts
* This notice must stay intact for legal use
***********************************************/
</script>
<script type="text/javascript">
ddaccordion.init({ //top level headers initialization
	headerclass: "expandable", //Shared CSS class name of headers group that are expandable
	contentclass: "categoryitems", //Shared CSS class name of contents group
	revealtype: "click", //Reveal content when user clicks or onmouseover the header? Valid value: "click", "clickgo", or "mouseover"
	mouseoverdelay: 200, //if revealtype="mouseover", set delay in milliseconds before header expands onMouseover
	collapseprev: false, //Collapse previous content (so only one open at any time)? true/false 
	defaultexpanded: [0], //index of content(s) open by default [index1, index2, etc]. [] denotes no content
	onemustopen: false, //Specify whether at least one header should be open always (so never all headers closed)
	animatedefault: false, //Should contents open by default be animated into view?
	persiststate: true, //persist state of opened contents within browser session?
	toggleclass: ["", "openheader"], //Two CSS classes to be applied to the header when it's collapsed and expanded, respectively ["class1", "class2"]
	togglehtml: ["prefix", "", ""], //Additional HTML added to the header when it's collapsed and expanded, respectively  ["position", "html1", "html2"] (see docs)
	animatespeed: "normal", //speed of animation: integer in milliseconds (ie: 200), or keywords "fast", "normal", or "slow"
	oninit:function(headers, expandedindices){ //custom code to run when headers have initalized
		//do nothing
	},
	onopenclose:function(header, index, state, isuseractivated){ //custom code to run whenever a header is opened or closed
		//do nothing
	}
})

ddaccordion.init({ //2nd level headers initialization
	headerclass: "subexpandable", //Shared CSS class name of sub headers group that are expandable
	contentclass: "subcategoryitems", //Shared CSS class name of sub contents group
	revealtype: "click", //Reveal content when user clicks or onmouseover the header? Valid value: "click" or "mouseover
	mouseoverdelay: 200, //if revealtype="mouseover", set delay in milliseconds before header expands onMouseover
	collapseprev: true, //Collapse previous content (so only one open at any time)? true/false 
	defaultexpanded: [], //index of content(s) open by default [index1, index2, etc]. [] denotes no content
	onemustopen: false, //Specify whether at least one header should be open always (so never all headers closed)
	animatedefault: false, //Should contents open by default be animated into view?
	persiststate: true, //persist state of opened contents within browser session?
	toggleclass: ["opensubheader", "closedsubheader"], //Two CSS classes to be applied to the header when it's collapsed and expanded, respectively ["class1", "class2"]
	togglehtml: ["none", "", ""], //Additional HTML added to the header when it's collapsed and expanded, respectively  ["position", "html1", "html2"] (see docs)
	animatespeed: "normal", //speed of animation: integer in milliseconds (ie: 200), or keywords "fast", "normal", or "slow"
	oninit:function(headers, expandedindices){ //custom code to run when headers have initalized
		//do nothing
	},
	onopenclose:function(header, index, state, isuseractivated){ //custom code to run whenever a header is opened or closed
		//do nothing
	}
})
</script>

- In your style.css add this:

Code: Select all

#mdb .panels .expandable{ /*CSS class for menu headers expandable */
background: url(images/panel/plus.png) no-repeat center right #383838 ;
}
#mdb .panels .expandable:hover{ /*CSS class for menu headers expandable */
background: url(images/panel/plus_over.png) no-repeat center right #383838 ;
}
#mdb .panels .openheader{ /*CSS class to apply to expandable header when it's expanded*/
background: url(images/panel/minus.png)  no-repeat  center right #383838 ;
}
#mdb .panels .openheader:hover{ /*CSS class to apply to expandable header when it's expanded*/
background: url(images/panel/minus_over.png)  no-repeat  center right #383838 ;
}

- In all your templates except "details.tpl" , You need this :

# --- PANELS (LEFT SIDE) ----------------------
<table cellpadding='0' cellspacing='0' border='0' width='100%'><tr>
<td valign='top'>
<div class='panels'>
{PANELS}
<div class='panel curvy2'>
<div class="bl"><div class="br"><div class="tl"><div class="tr">
<div class='haut'></div>
<div class='header expandable'>$PANEL[TITLE]</div>
<div class="categoryitems">
{CATEGORIES}<div class='cat $CATEGORY[SELECTED]'>$CATEGORY[LINKCNT]</div>{/CATEGORIES}
</div>
<div class='footer'></div>
</div></div></div></div>
<div class="iefix"> </div>
</div>
{/PANELS}
</div>
</td>

I hope I have not forgotten