dump_postgresql.sql

实现网站投票功能

\
  <tr>
\
    <td>
\
      <table border="0" cellspacing="0" cellpadding="5" align="center" bgcolor="#F3F3F3" width="200">
\
        <tr>
\
          <td width="149">
\
            <form method="post" action="$this->form_forward">
\
              <table border="0" cellspacing="0" cellpadding="2" bgcolor="" align="center">
\
                <tr>
\
                  <td class="td1" height="40"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1">$question</font></b></td>
\
                </tr>
\
                <tr>
\
                  <td class="td1"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Name:</font><br>
\
                    <input type="text" name="name" maxlength="25" class="input" size="23">
\
                  </td>
\
                </tr>
\
                <tr>
\
                  <td class="td1"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">e-mail:</font><br>
\
                    <input type="text" name="email" size="23" maxlength="50" class="input">
\
                  </td>
\
                </tr>
\
                <tr>
\
                  <td class="td1"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Comment(*):</font><br>
\
                    <font face="MS Sans Serif" size="1">
\
                    <textarea name="message" cols="19" wrap="VIRTUAL" rows="6" class="textarea"></textarea>
\
                    </font>
\
                  </td>
\
                </tr>
\
                <tr valign="top">
\
                  <td>
\
                    <input type="submit" value="Submit" class="button">
\
                    <input type="reset" value="Reset" class="button">
\
                    <input type="hidden" name="action" value="add">
\
                    <input type="hidden" name="id" value="$poll_id">
\
                  </td>
\
                </tr>
\
              </table>
\
            </form>
\
          </td>
\
        </tr>
\
      </table>
\
    </td>
\
  </tr>
\
</table>
\

15	3	display_head	<table width="$pollvars[table_width]" border="0" cellspacing="0" cellpadding="1" bgcolor="$pollvars[bgcolor_fr]">
\
  <tr align="center">
\
    <td>
\
      <style type="text/css">
\
 <!--
\
  .input { font-family: $pollvars[font_face]; font-size: 8pt}
\
 -->
\
</style>
\
      <font face="$pollvars[font_face]" size="-1" color="#FFFFFF"><b>$pollvars[title]</b></font></td>
\
  </tr>
\
  <tr align="center"> 
\
    <td> 
\
      <table width="100%" border="0" cellspacing="0" cellpadding="2" align="center" bgcolor="$pollvars[bgcolor_tab]">
\
        <tr> 
\
          <td height="40" valign="middle"><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1"><b>$question</b></font></td>
\
        </tr>
\
        <tr align="right" valign="top"> 
\
          <td>
\
            <form method="post" name="poll_$poll_id" onsubmit="return poll_results_$poll_id('vote','$pollvars[base_url]/popup.php','Poll','500','350','toolbar=no,scrollbars=yes');">
\
              <script language="JavaScript">
\
<!--
\
function poll_results_$poll_id(action,theURL,winName,winWidth,winHeight,features) {      
\
    var w = (screen.width - winWidth)/2;
\
    var h = (screen.height - winHeight)/2 - 20;
\
    features = features+',width='+winWidth+',height='+winHeight+',top='+h+',left='+w;
\
    var poll_ident = self.document.poll_$poll_id.poll_ident.value;
\
    option_id = '';
\
    for (i=0; i<self.document.poll_$poll_id.option_id.length; i++) {
\
        if(self.document.poll_$poll_id.option_id[i].checked == true) {
\
            option_id = self.document.poll_$poll_id.option_id[i].value;
\
            break;
\
        }
\
    }
\
    option_id = (option_id != '') ? '&option_id='+option_id : '';
\
    if (action=='results' || (option_id != '' && action=='vote')) {
\
        theURL = theURL+'?action='+action+'&poll_ident='+poll_ident+option_id;
\
        poll_popup = window.open(theURL,winName,features);
\
        poll_popup.focus();
\
    }
\
    return false;
\
}
\
//-->
\
        </script>
\
              <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
\
                <tr valign="top" align="center"> 
\
                  <td> 
\
                    <table width="100%" border="0" cellspacing="0" cellpadding="1" align="center">
\

16	3	display_loop	 <tr> 
\
   <td width="15%"><input type="radio" name="option_id" value="$data[option_id]"></td>
\
   <td width="85%"><font face="$pollvars[font_face]" size="1" color="$pollvars[font_color]">$data[option_text]</font></td>
\
 </tr>
\

17	3	display_foot	                    </table>
\
                    <input type="hidden" name="action" value="vote">
\
                    <input type="hidden" name="poll_ident" value="$poll_id">
\
                    <input type="submit" value="$pollvars[vote_button]" class="input">
\
                    <br>
\
                    <br>
\
                    <font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1"><a href="javascript:void(poll_results_$poll_id('results','$pollvars[base_url]/popup.php','Poll','500','350','toolbar=no,scrollbars=yes'))">$pollvars[result_text]</a><br>
\
                    </font></td>
\
                </tr>
\
              </table>
\
            </form>
\
            <font face="$pollvars[font_face]" size="1"><a href="http://www.proxy2.de" target="_blank" title="Advanced Poll">Version $pollvars[poll_version]</a></font>
\
          </td>
\
        </tr>
\
      </table>
\
    </td>
\
  </tr>
\
</table>
\

18	3	result_head	  <table width="400" border="0" cellspacing="0" cellpadding="1" bgcolor="$pollvars[bgcolor_fr]">
\
    <tr align="center"> 
\
      <td> 
\
        <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#FFFFFF">
\
          <tr valign="middle"> 
\
            <td height="25" align="center" bgcolor="$pollvars[bgcolor_fr]">
\
              <style type="text/css">
\
<!--
\
 .input { font-family: $pollvars[font_face]; font-size: 8pt}
\
 .links { font-family: $pollvars[font_face]; font-size: 7.5pt; color: #000000}
\
-->
\
</style>
\
\
            <font face="$pollvars[font_face]" color="#FFFFFF" size="1"><b>$question</b></font></td>
\
          </tr>
\
          <tr align="right" valign="bottom"> 
\
            <td> 
\
              <table border="0" cellspacing="0" cellpadding="1" width="100%" align="center">
\
                <tr valign="top"> 
\
                  <td> 
\
                    <table width="100%" border="0" cellspacing="0" cellpadding="1" align="center">
\

19	3	result_loop	<tr> 
\
   <td height="22" bgcolor="#EAEAEA"><font face="$pollvars[font_face]" color="#000000" size="1">$option_text</font></td>
\
   <td height="22" bgcolor="#D8D8EB"><font face="$pollvars[font_face]" color="#000000" size="1"><img src="$pollvars[base_gif]/$poll_color.gif" width="$img_width" height="$pollvars[img_height]"> $vote_val</font></td>
\
</tr>
\

20	3	result_foot	                  </table>
\
                  <font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1"><br>
\
                  $pollvars[total_text]: <font color="#CC0000">$total_votes</font><br>
\
                  $VOTE<br><div align="center">
\
                  $COMMENT&nbsp;</div></font></td>
\
              </tr>
\
              <tr> 
\
                <td>&nbsp;</td>
\
              </tr>
\
            </table>
\
            <font face="$pollvars[font_face]" size="1"><a href="http://www.proxy2.de" target="_blank" title="Advanced Poll">Version $pollvars[poll_version]</a></font>
\
          </td>
\
        </tr>
\
      </table>
\
    </td>
\
  </tr>
\
</table>
\

21	3	comment	<table border="0" cellspacing="0" cellpadding="1" align="center" bgcolor="#666699">
\
  <tr align="center">
\
    <td>
\
     <style type="text/css">
\
      <!--
\
       .button {  font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 8pt}
\
       .textarea {  font-family: "MS Sans Serif"; font-size: 9pt; width: 195px}
\
       .input {  width: 195px}
\
      -->
\
    </style><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Submit Your Comment</b></font></td>
\
  </tr>
\
  <tr>
\
    <td>
\
      <table border="0" cellspacing="0" cellpadding="5" align="center" bgcolor="#FFFFFF" width="200">
\
        <tr>
\
          <td width="149">
\
            <form method="post" action="$this->form_forward">
\
              <table border="0" cellspacing="0" cellpadding="2" bgcolor="" align="center">
\
                <tr>
\
                  <td class="td1" height="40"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="1">$question</font></b></td>
\
                </tr>
\
                <tr>
\
                  <td class="td1"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Name:</font><br>
\
                    <input type="text" name="name" maxlength="25" class="input" size="23">
\
                  </td>
\
                </tr>
\
                <tr>
\
                  <td class="td1"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">e-mail:</font><br>
\
                    <input type="text" name="email" size="23" maxlength="50" class="input">
\
                  </td>
\
                </tr>
\
                <tr>
\
                  <td class="td1"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Comment(*):</font><br>
\
                    <font face="MS Sans Serif" size="1">
\
                    <textarea name="message" cols="19" wrap="VIRTUAL" rows="6" class="textarea"></textarea>
\
                    </font>
\
                  </td>
\
                </tr>
\
                <tr valign="top">
\
                  <td>
\
                    <input type="submit" value="Submit" class="button">
\
                    <input type="reset" value="Reset" class="button">
\
                    <input type="hidden" name="action" value="add">
\
                    <input type="hidden" name="id" value="$poll_id">
\
                  </td>
\
                </tr>
\
              </table>
\
            </form>
\
          </td>
\
        </tr>
\
      </table>
\
    </td>
\
  </tr>
\
</table>
\

22	4	display_head	<table width="$pollvars[table_width]" border="0" cellspacing="0" cellpadding="1" bgcolor="$pollvars[bgcolor_fr]">
\
  <tr align="center">
\
    <td>
\
      <style type="text/css">
\
 <!--
\
  .input { font-family: $pollvars[font_face]; font-size: 8pt}
\
 -->
\
</style>
\
      <font face="$pollvars[font_face]" size="-1" color="#FFFFFF"><b>$pollvars[title]</b></font></td>
\
  </tr>
\
  <tr align="center"> 
\
    <td> 
\
      <table width="100%" border="0" cellspacing="0" cellpadding="2" align="center" bgcolor="$pollvars[bgcolor_tab]">
\
        <tr> 
\
          <td height="40" valign="middle"><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1"><b>$question</b></font></td>
\
        </tr>
\
        <tr align="right" valign="top"> 
\
          <td>
\
            <form method="post" action="$this->form_forward">
\
               <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
\
                <tr valign="top" align="center"> 
\
                  <td> 
\
                    <table width="100%" border="0" cellspacing="0" cellpadding="1" align="center">
\

23	4	display_loop	<tr> 
\
   <td width="15%"><input type="radio" name="option_id" value="$data[option_id]"></td>
\
   <td width="85%"><font face="$pollvars[font_face]" size="1" color="$pollvars[font_color]">$data[option_text]</font></td>
\
 </tr>
\

24	4	display_foot	                    </table>
\
                    <input type="hidden" name="action" value="vote">
\
                    <input type="hidden" name="poll_ident" value="$poll_id">
\
                    <input type="submit" value="$pollvars[vote_button]" class="input">
\
                    <br>
\
                    <br>
\
                    <font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1"><a href="$this->form_forward?action=results&amp;poll_ident=$poll_id">$pollvars[result_text]</a><br>
\
                    </font></td>
\
                </tr>
\
              </table>
\
            </form>
\
            <font face="$pollvars[font_face]" size="1"><a href="http://www.proxy2.de" target="_blank" title="Advanced Poll">Version $pollvars[poll_version]</a></font>
\
          </td>
\
        </tr>
\
      </table>