Page 3 of 4
Posted: 2014-01-22 18:02:25
by 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.
Posted: 2014-01-23 11:24:59
by droopy57
Hi !
In files
- cover_view.tpl
cover_view2.tpl
cover_view.tpl
details.tpl
detail_view.tpl
Replaces: $ MOVIE [TRANSLATEDTITLE]
by $ MOVIE [ORIGINALTITLE]
Posted: 2014-01-23 14:32:26
by 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.
Posted: 2014-01-24 14:16:09
by 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
Posted: 2014-01-25 15:06:43
by 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.
Posted: 2014-01-26 13:17:45
by 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 :
'
Posted: 2014-01-26 13:39:21
by the_observer
Oh , i see .
Posted: 2014-02-23 20:31:39
by Wikio22
Merci!
Posted: 2014-03-04 13:11:29
by Wirtick
Thank you very much. This is very useful!
some modifications
Posted: 2014-03-08 18:18:44
by 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]
Posted: 2014-03-09 09:45:25
by 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
Posted: 2014-03-09 23:21:45
by pele
droopy57 wrote: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.
Posted: 2014-03-10 21:29:52
by pele
pele wrote:droopy57 wrote: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
Posted: 2014-03-10 23:32:40
by 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.
Posted: 2014-03-11 11:52:46
by 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);
Posted: 2014-03-11 19:19:03
by pele
antp wrote: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.
Posted: 2014-03-11 19:21:34
by pele
droopy57 wrote: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.
Posted: 2014-03-14 09:27:56
by Witko
Keep up the good work mate!
add + signs at the left column mde by Droopy57 template
Posted: 2014-03-14 15:04:01
by 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
Re: add + signs at the left column mde by Droopy57 template
Posted: 2014-03-16 10:37:48
by droopy57
pele wrote: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