dump_postgresql.sql

实现网站投票功能

\
    </td>
\
  </tr>
\
</table>
\

25	4	result_head	<table border="0" cellspacing="0" cellpadding="2" width="360">
\
  <tr> 
\
    <td colspan="2"><font face="$pollvars[font_face]" size="2">$question</font></td>
\
  </tr>
\
  <tr> 
\
    <td><img src="$pollvars[base_url]/png.php?poll_id=$poll_id"></td>
\
    <td> 
\
      <table width="100%" border="0" cellspacing="0" cellpadding="1" bgcolor="#000000">
\
        <tr> 
\
          <td> 
\
            <table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="#EBEBEB">
26	4	result_loop	            <tr> 
\
                <td width="12"><font size="1" face="$pollvars[font_face]"><img src="$pollvars[base_gif]/$poll_color.gif" width="8" height="10"></font></td>
\
                <td><font size="1" face="$pollvars[font_face]">$option_text -
\
                  $vote_val</font></td>
\
              </tr>
27	4	result_foot	              <tr> 
\
                <td>&nbsp;</td>
\
                <td><font face="$pollvars[font_face]" size="1">$pollvars[total_text]: 
\
                 <font color="#990000">$total_votes</font><br>
\
                 $COMMENT&nbsp;</font></td>
\
              </tr>
\
            </table>
\
          </td>
\
        </tr>
\
      </table>
\
    </td>
\
  </tr>
\
</table>
28	4	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>
\

29	5	display_head	<table width="450" border="0" cellspacing="0" cellpadding="2" bgcolor="#CCCCCC">
\
  <tr>
\
    <td align="center">
\
     <style type="text/css">
\
       <!--
\
        .input { font-family: $pollvars[font_face]; font-size: 9pt}
\
       -->
\
      </style> 
\
      <table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="#F6F6F6">
\
        <tr align="center"> 
\
          <td colspan="2" height="40"><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1"><b>$question</b></font></td>
\
        </tr>
\
        <tr align="center"> 
\
          <td colspan="2"> 
\
            <form method="post" action="$this->form_forward">
\
              <table width="100%" border="0" cellspacing="0" cellpadding="1">
30	5	display_loop	 <tr> 
\
   <td width="11%" align="center"><input type="radio" name="option_id" value="$data[option_id]"></td>
\
   <td width="89%"><font face="$pollvars[font_face]" size="1" color="$pollvars[font_color]">$data[option_text]</font></td>
\
 </tr>
31	5	display_foot	                <tr align="center" valign="bottom"> 
\
                  <td colspan="2"> 
\
                    <input type="submit" value="$pollvars[vote_button]" class="input" name="submit">
\
                    <input type="hidden" name="action" value="vote">
\
                    <input type="hidden" name="poll_ident" value="$poll_id">
\
                  </td>
\
                </tr>
\
                <tr valign="bottom"> 
\
                  <td colspan="2" height="30" align="center"><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>]</font></td>
\
                </tr>
\
              </table>
\
            </form>
\
          </td>
\
        </tr>
\
      </table>
\
    </td>
\
  </tr>
\
</table>
\

32	5	result_head	<table width="450" border="0" cellspacing="0" cellpadding="2" bgcolor="#CCCCCC">
\
  <tr>
\
    <td align="center"> 
\
      <table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="#F6F6F6">
\
        <tr align="center"> 
\
          <td colspan="3" height="40"><font face="$pollvars[font_face]" size="1" color="#000000"><b>$question</b></font></td>
\
        </tr>
\

33	5	result_loop	        <tr>
\
          <td width="3%">&nbsp;</td>
\
          <td><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1">$option_text</font></td>
\
          <td><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1"><img src="$pollvars[base_gif]/$poll_color.gif" width="$img_width" height="$pollvars[img_height]"> $vote_percent % ($vote_count)</font></td>
\
        </tr>
\

34	5	result_foot	        <tr> 
\
          <td colspan="3" valign="bottom" align="center"><b><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1">$pollvars[total_text]: 
\
            $total_votes</font></b></td>
\
        </tr>
\
        <tr align="center"> 
\
          <td colspan="3" valign="top"><font face="$pollvars[font_face]" color="$pollvars[font_color]" size="1">$VOTE 
\
            <br>
\
            $COMMENT</font></td>
\
        </tr>
\
        <tr align="right"> 
\
          <td colspan="3"><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>
\

35	5	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>Send Your Comment</b></font></td>
\
  </tr>
\
  <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>
\

36	0	poll_comment	<table border="0" cellspacing="1" cellpadding="2" width="450">
\
  <tr bgcolor="#E4E4E4"> 
\
    <td bgcolor="#F2F2F2"><b><font size="1" face="Verdana, Arial, Helvetica, sans-serif">$data[name]</font></b> 
\
      <i><font size="1" face="Verdana, Arial, Helvetica, sans-serif">$data[email]</font></i> 
\
      - <font size="1" face="Verdana, Arial, Helvetica, sans-serif">$data[time]</font><br>
\
      <font size="1" face="Arial, Helvetica, sans-serif">$data[host] - $data[browser]</font> 
\
    </td>
\
  </tr>
\
  <tr>
\
    <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">$data[message]</font> 
\
    </td>
\
  </tr>
\
  <tr> 
\
    <td height="15">&nbsp;</td>
\
  </tr>
\
</table>
\

37	0	poll_list	<table border="0" cellspacing="0" cellpadding="4" width="450">
\
  <tr> 
\
    <td width="80" valign="top"> &#0149; <font size="2" face="Arial, Helvetica, sans-serif"><i>$data[timestamp]</i></font></td>
\
    <td width="354"><font face="Arial, Helvetica, sans-serif" size="2"><a href="$PHP_SELF?poll_id=$data[poll_id]">$data[question]</a></font></td>
\
  </tr>
\
</table>
\

\.
COPY "poll_data" FROM stdin;
1	1	1	Linux	blue	49
2	1	2	Solaris	yellow	12
3	1	3	FreeBSD	green	29
4	1	4	WindowsNT	brown	17
5	1	5	Unix	grey	10
6	1	6	BSD	red	15
7	1	7	other	purple	9
8	2	5	Sybase	orange	2
9	2	4	MS SQL	green	9
10	2	3	Oracle	blue	17
11	2	2	PostgreSQL	gold	6
12	2	1	MySQL	pink	23
13	2	6	other	brown	3
14	2	7	DB/2	grey	4
15	3	1	PHP	red	65
16	3	2	Perl	orange	34
17	3	3	ASP	green	17
18	3	4	JSP	purple	20
19	3	5	Python	gold	7
20	3	6	other	aqua	16
\.
COPY "poll_ip" FROM stdin;
\.
COPY "poll_comment" FROM stdin;
1	1	1018815036	localhost	Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)	nobody	[e-mail]	This is the first comment!
\.
COPY "poll_log" FROM stdin;
\.
COPY "poll_user" FROM stdin;
1	admin	b0f6dfb42fa80caee6825bfecd30f094	d8f826b3b6c938e6e6ff6d9c099ee2b3	1018815068
\.
COPY "poll_templateset" FROM stdin;
1	default	2002-04-14 22:10:36
2	simple	2002-04-14 22:10:36
3	popup	2002-04-14 22:10:36
4	graphic	2002-04-14 22:10:36
5	plain	2002-04-14 22:10:36
\.
CREATE  INDEX "tplset_id_poll_templates_key" on "poll_templates" using btree ( "tplset_id" "int4_ops" );
CREATE  INDEX "poll_id_poll_data_key" on "poll_data" using btree ( "poll_id" "int4_ops" );
CREATE  INDEX "poll_id_poll_ip_key" on "poll_ip" using btree ( "poll_id" "int4_ops" );
CREATE UNIQUE INDEX "config_id_poll_config_ukey" on "poll_config" using btree ( "config_id" "int2_ops" );
CREATE  INDEX "option_id_poll_log_key" on "poll_log" using btree ( "option_id" "int4_ops" );
CREATE  INDEX "poll_id_poll_log_key" on "poll_log" using btree ( "poll_id" "int4_ops" );