Personal Video Database

English => Development => Scripts and Templates => Topic started by: dan16326 on July 14, 2009, 11:20:51 am

Title: html export question
Post by: dan16326 on July 14, 2009, 11:20:51 am
hey guys i'm just wondering how to fix an issue. everything works fine when i export but for each movie the title is stated twice ie. Watchmen - Watchmen (2009). how do i fix this so the title doesn't show twice? thx

also how would i setup a hyperlink in the details page to a url (like a trailer on youtube)

sorry i'm pretty clueless with html.

here's my current setup for refferance:

%OPTIONS%
filter="HTML Files|*.html;*.htm"
encoding="UTF8"
sortby="0"
sortdir="sdDecending"
itemsperpage="50"
recordtemplate="pages\movie.ptm"
recordfilename="movie%d.html"
pagestpl="pages\pg.ptm"
prevtpl="pages\prev_pg.ptm"
nexttpl="pages\next_pg.ptm"
pagelinktpl="pages\link_pg.ptm"
pagecurtpl="pages\cur_pg.ptm"
imagepath="images\"
fullstar="images\star_on.gif"
halfstar="images\star_on_half.gif"
nonestar="images\star_off.gif"
copyfile="images\star_on.gif<->images\star_on.gif"
copyfile="images\star_on_half.gif<->images\star_on_half.gif"
copyfile="images\star_off.gif<->images\star_off.gif"
%OPTIONS%
%HEAD%<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>My Video Database</title>
<style type="text/css">
<!--
.style1 {
   font-size: 24px;
   font-weight: bold;
   color: #FFFFFF;
}
.style2 {
   font-size: 12px
}
.style3 {font-size: 14px}
.style4 {color: #FFFFFF}
.style5 {
   color: #000000;
}
.border {
   border-bottom-width: 1px;
   border-top-style: none;
   border-right-style: none;
   border-bottom-style: solid;
   border-left-style: none;
   border-bottom-color: #999999;
}
.center {
   vertical-align: middle;
}
body {
   background-color: #CCCCCC;
}
-->
</style>
</head>

<body>
<table width="760" border="0" align="center" cellspacing="0" cellpadding="0">
  <tr>
    <td bgcolor="#003399"><div align="center" class="style1">My Video Database</div></td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="0" cellpadding="5">
      <tr>
        <td><table width="100%" border="0" cellspacing="0" cellpadding="5">%HEAD%

          <tr>
            <td width="50" class="border"><div align="right"><span class="style3">{%value=203}</span>.&nbsp; </div></td>
            <td width="50" class="border"><img src="{%value=poster width="48" height="62"}" /></td>
            <td width="710" class="border"> &nbsp;<a href="movie{%value=mid}.html" class="style5">{%value=origtitle} - {%value=title} ({%value=year})</a><br />
               &nbsp;<span class="style2">{%value=genre}</span><br /></td>
          </tr>         
        %FOOT%</table></td>
      </tr>
      {%value=211}
    </table></td>
  </tr>
  <tr>
    <td bgcolor="#003399"><div align="center" class="style2"><a href="http://www.videodb.info" class="style4">Generated by Personal Video Database</a></div></td>
  </tr>
</table>
</body>
</html>%FOOT%
Title: Re: html export question
Post by: nostra on July 14, 2009, 01:20:51 pm
Quote
hey guys i'm just wondering how to fix an issue. everything works fine when i export but for each movie the title is stated twice ie. Watchmen - Watchmen (2009). how do i fix this so the title doesn't show twice?

replace this text:
Code: [Select]
{%value=origtitle} - {%value=title} ({%value=year})with this one:
Code: [Select]
{%value=title} ({%value=year})
Quote
also how would i setup a hyperlink in the details page to a url (like a trailer on youtube)

How are these links stored in the database?
Title: Re: html export question
Post by: dan16326 on July 15, 2009, 11:12:59 am
thank you new code worked like a charm.


i currently don't have links in my database but i could put them in my comments field as i don't use them.
Title: Re: html export question
Post by: dan16326 on July 15, 2009, 11:31:03 am
sorry i lied the movie is still being double listed but now it's only like that in the details page
Title: Re: html export question
Post by: Luke_S on July 15, 2009, 10:09:05 pm
Hey Dan,

You need to change the following line inside the movie.ptm file as well:

Code: [Select]
<title>{%value=origtitle} - {%value=title} ({%value=year})</title>
to

Code: [Select]
<title>{%value=origtitle} ({%value=year})</title>
This is just one of the minor annoyances that I fixed in my own version of the html-export page. Seeing as some users might already find it agreeable I will put a link for a zip-file with the changes I made (and a short description) under this post:

http://www.videodb.info/forum_en/index.php?topic=1414.0 (http://www.videodb.info/forum_en/index.php?topic=1414.0)


/Luke
Title: Re: html export question
Post by: dan16326 on July 17, 2009, 11:43:23 am
in my database i have my trailers hyper-linked in my comments section i tried to move it to the url section for the sake of it showing up in my detailed pages when exporting html. but it shows up as the entire code instead of it being mask by the word "trailer" like in my comments. any ideas?

nostra is there a way i could get my comments section to appear at all? and if so is there a way to place it under the imdb ratings?

thx for the help guys i really appreciate it.
Title: Re: html export question
Post by: dan16326 on July 17, 2009, 12:05:34 pm
okay after playing with it for a while and looking up html code. i was able to get it to work using <a
href= yadda yadda. but i had to put it in the description which ultimately i don't want to do. i'd settle for it working in the links section but due to the programing of it, it won't work because once there is a space in the text it tries to create a separate link.
Title: Re: html export question
Post by: dan16326 on July 17, 2009, 02:10:51 pm
okay so a solution has been found thx to the help of luke

what i did was put an html code in my comment in PVD ie. <a href="url">Trailer</a>

then in the ptm file below the imdb rating line i put:

             
                  <td width="100" class="top"><div align="right"><strong>Trailer:</strong></div></td>
                  <td>{%value=comment}</td>
      

this gave me the result i was looking for. also just as a note the html code that gets entered in the comment field does not work in PVD but it works on the exported files.

thx again everyone.
Title: Re: html export question
Post by: rick.ca on July 17, 2009, 08:06:49 pm
Quote
the html code that gets entered in the comment field does not work in PVD but it works on the exported files.

Can't you save the trailer URL in its own custom field, and then pass that value in the template? In other words, use

     <td><a href="url">{%value=trailer}</a></td>

instead of

     <td>{%value=comment}</td>.
Title: Re: html export question
Post by: dan16326 on July 18, 2009, 11:51:11 am
 :-\ i've only had PVD for about a week and i know next to nothing about html so i have no idea how to create a custom field in the database.
Title: Re: html export question
Post by: rick.ca on July 18, 2009, 08:14:11 pm
Preferences - Movies - Custom items.
Title: Re: html export question
Post by: dan16326 on July 19, 2009, 08:18:45 am
hmm interesting thx for that. i would have done that to start had i known but as i have it set up right now it does what i want so i don't think i'm going to mess with it.

cheers though.