/[LeafOK_CVS]/fenglin/www/journal.php
ViewVC logotype

Annotation of /fenglin/www/journal.php

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.17 - (hide annotations)
Sun Apr 13 05:06:37 2025 UTC (11 months ago) by sysadm
Branch: MAIN
CVS Tags: HEAD
Changes since 1.16: +0 -0 lines
FILE REMOVED 
Remove legacy feature
1 sysadm 1.1 <?
2 sysadm 1.13 require_once "../lib/common.inc.php";
3 sysadm 1.12 require_once "../lib/db_open.inc.php";
4 sysadm 1.15 require_once "../bbs/session_init.inc.php";
5 sysadm 1.12 ?>
6     <?
7 sysadm 1.1 if (isset($_GET["jid"]))
8     $jid=intval($_GET["jid"]);
9     else
10     $jid=0;
11     if (isset($_GET["uid"]))
12     $uid=intval($_GET["uid"]);
13     else
14     $uid=0;
15     if (isset($_GET["as_email"]))
16 sysadm 1.12 $base_url="https://" . $BBS_host_name;
17 sysadm 1.1 else
18     $base_url="";
19    
20     $rs=mysql_query("select * from journal_index where JID=$jid and enable")
21     or die("Query journal_index error!");
22     if ($row=mysql_fetch_array($rs))
23     {
24     $dt=$row["dt"];
25     }
26     else
27     {
28     echo ("Journal ID not exists!");
29     exit();
30     }
31     mysql_free_result($rs);
32    
33     $f_section_list="-1,";
34     if ($uid==0)
35     {
36     $rs=mysql_query("select SID from section_config where enable")
37     or die("Query section_config error!");
38     }
39     else
40     {
41     $rs=mysql_query("select SID,UID from section_favorite where UID=$uid")
42     or die("Query section_favorite error!");
43     if (mysql_num_rows($rs)==0)
44     {
45     mysql_free_result($rs);
46     $rs=mysql_query("select SID from section_config where enable")
47     or die("Query section_config error!");
48     }
49     }
50     while($row=mysql_fetch_array($rs))
51     {
52     $f_section_list=$f_section_list.$row["SID"].",";
53     }
54     mysql_free_result($rs);
55     $f_section_list=substr($f_section_list,0,strlen($f_section_list)-1);
56    
57     $section_list="-1,";
58     $rs=mysql_query("select SID from journal_data inner join bbs on journal_data.AID=bbs.AID".
59     " where journal_data.JID=$jid and bbs.SID in ($f_section_list)")
60     or die("Query journal_data error!");
61     while($row=mysql_fetch_array($rs))
62     {
63     $section_list=$section_list.$row["SID"].",";
64     }
65     mysql_free_result($rs);
66     $section_list=substr($section_list,0,strlen($section_list)-1);
67    
68     $class_list="-1,";
69     $rs=mysql_query("select CID from section_config where SID in ($section_list) and enable")
70     or die("Query section_config error!");
71     while($row=mysql_fetch_array($rs))
72     {
73     $class_list=$class_list.$row["CID"].",";
74     }
75     mysql_free_result($rs);
76     $class_list=substr($class_list,0,strlen($class_list)-1);
77     ?>
78     <html>
79     <head>
80 sysadm 1.7 <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
81 sysadm 1.13 <title><? echo $BBS_name; ?> -- 精品导读</title>
82 sysadm 1.1 </head>
83     <body marginheight="15" marginwidth="15" leftmargin="15" topmargin="15" link="#000066" bgcolor="#FFFFFF" alink="#990000" vlink="#444464">
84     <center>
85     <a name="top"></a>
86     <table cellpadding="0" cellspacing="0" border="0" width="600">
87     <tr>
88 sysadm 1.15 <td width="600" colspan="3" align="center">
89 sysadm 1.1 <?
90     if (isset($_GET["as_email"]))
91     {
92     ?>
93 sysadm 1.7 <font color="#CCCCCC" size="-2">如果您无法阅读本邮件，请访问<a href="<? echo $base_url; ?>/www/journal.php?jid=<? echo $jid; ?>&uid=<? echo $uid; ?>" target="_blank"><? echo $base_url; ?>/www/journal.php?jid=<? echo $jid; ?>&uid=<? echo $uid; ?></a></font><br>&nbsp;</td>
94 sysadm 1.1 <?
95     }
96     ?>
97     </tr>
98     <tr>
99 sysadm 1.15 <td width="1" colspan="3" bgcolor="#999999"><img src="<? echo $base_url; ?>/www/images/spacer.gif" width="1" height="1" border="0"></td>
100 sysadm 1.1 </tr>
101     <tr>
102 sysadm 1.15 <td width="1" bgcolor="#999999"><img src="<? echo $base_url; ?>/www/images/spacer.gif" width="1" height="1" border="0"></td>
103     <td width="598">
104 sysadm 1.1 <table width="598" border="0" cellspacing="0" cellpadding="0">
105 sysadm 1.15 <tr>
106     <td background="<? echo $base_url; ?>/www/images/spacer_bkgd.gif" height="55" colspan="6">
107 sysadm 1.1 <table cellpadding="0" cellspacing="0" border="0">
108     <tr>
109     <td>
110     <img src="<? echo $base_url; ?>/www/images/spacer.gif" width="198" height="1" border="0" alt=""><br>
111     <font face="Times New Roman,Times,Serif" size="-1" color="#333333">&nbsp;&nbsp;<? echo date ("l, F d, Y",strtotime($dt)); ?><br>
112 sysadm 1.15 </font></td>
113 sysadm 1.1 <td align="center"><img src="<? echo $base_url; ?>/images/logo/fenglinonline.gif" alt="" width="130" height="50" border="0"></td>
114     <td><img src="<? echo $base_url; ?>/www/images/spacer.gif" width="198" height="1" border="0" alt=""></td>
115     </tr>
116     </table>
117     </td>
118 sysadm 1.15 </tr>
119 sysadm 1.1 <tr>
120     <td colspan="6"><img src="<? echo $base_url; ?>/www/images/line.gif" alt="" width="598" height="4" border="0"></td>
121     </tr>
122 sysadm 1.15 <tr>
123     <td width="5" bgcolor="#ffffff"><img src="<? echo $base_url; ?>/www/images/spacer.gif" width="5" height="1" border="0" alt=""></td>
124     <td width="393" valign="top">
125     <table width="393" border="0" cellpadding="0" cellspacing="0">
126 sysadm 1.1 <tr>
127 sysadm 1.15 <td width="393">
128 sysadm 1.1 <table border="0" width="393" cellpadding="0" cellspacing="0">
129     <tr>
130 sysadm 1.15 <td width="131" colspan="2"><font face="Times New Roman,Times,Serif" size="-1"><strong>本期推荐：</strong></font></td>
131 sysadm 1.1 </tr>
132     <tr>
133     <td width="393" colspan="2"><br></td>
134     </tr>
135     <tr>
136     <td width="393" colspan="2" valign="top" align="left">
137 sysadm 1.15 <font face="Times New Roman,Times,Serif" size="-1">
138 sysadm 1.1 <?
139     $cl_index=0;
140     $rs=mysql_query("select * from section_class where CID in ($class_list)".
141     " and enable order by sort_order")
142     or die("Query section_class error!");
143     while($row=mysql_fetch_array($rs))
144     {
145     ?>
146     <a href="#<? echo $row["cname"]; ?>"><? echo $row["title"]; ?></a>&nbsp;|&nbsp;
147     <?
148     $cl_index++;
149     if ($cl_index>=5)
150     {
151     echo ("<br>");
152     $cl_index=0;
153     }
154     }
155     mysql_free_result($rs);
156     ?>
157     </font><br><br>
158 sysadm 1.7 <font face="Times New Roman,Times,Serif" size="-1" color="#333333"><a href="<? echo $base_url; ?>/bbs/s_favor.php" target="_blank">设定我喜欢的栏目</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="<? echo $base_url; ?>/bbs/search_form.php" target="_blank">查找</a><br><br></font>
159 sysadm 1.1 </td>
160 sysadm 1.15 </tr>
161 sysadm 1.1 </table>
162     </td>
163     </tr>
164     <?
165     $rs=mysql_query("select * from section_class where CID in ($class_list)".
166     " and enable order by sort_order")
167     or die("Query section_class error!");
168     while($row=mysql_fetch_array($rs))
169     {
170     ?>
171     <tr>
172 sysadm 1.15 <td width="393">
173 sysadm 1.1 <table border="0" width="393" cellpadding="0" cellspacing="0">
174 sysadm 1.15 <tr>
175     <td width="393" bgcolor="#e4e4e4" height="24" valign="center" colspan="2">
176     <a name="<? echo $row["cname"]; ?>"></a>
177     <img src="<? echo $base_url; ?>/www/images/spacer.gif" width="1" height="1" border="0">&nbsp;<font face="times, times new roman, sans serif" size="-1"><strong><? echo $row["title"]; ?></strong></font> </td>
178     </tr>
179     <tr>
180     <td width="393" colspan="2"> <br> <font size="-1">
181 sysadm 1.1 <?
182     $rs_article=mysql_query("select journal_data.abstract,bbs.*,section_config.title as s_title".
183     " from journal_data inner join bbs on journal_data.AID=bbs.AID".
184     " inner join section_config on bbs.SID=section_config.SID inner join section_class".
185     " on section_config.CID=section_class.CID".
186     " where journal_data.JID=$jid and section_class.CID=".$row["CID"].
187     " and bbs.SID in ($section_list) order by section_config.sort_order,bbs.sub_dt")
188     or die("Query journal_data error!");
189     while($row_article=mysql_fetch_array($rs_article))
190     {
191     ?>
192 sysadm 1.16 <font size="3"><strong><a href="<? echo $base_url; ?>../bbs/view_article.php?tn=portal&id=<? echo $row_article["AID"]; ?>" target="_blank"><? echo $row_article["title"]; ?></a></strong></font><br>
193 sysadm 1.15 <font color="#666666" size="-1"><? echo $row_article["s_title"]; ?>&nbsp;&nbsp;
194     By <? echo $row_article["nickname"]; ?></font><br>
195     <? echo str_replace(" ", "&nbsp;", str_replace("\n", "<br>", htmlspecialchars($row_article["abstract"], ENT_HTML401, 'UTF-8'))); ?><br>
196     <br>
197 sysadm 1.1 <?
198     }
199     mysql_free_result($rs_article);
200     ?>
201 sysadm 1.15 </font>
202 sysadm 1.10 </td>
203 sysadm 1.15 </tr>
204     <tr>
205     <td width="393" align="left"><br></td>
206     <td width="100" align="right"><br></td>
207     </tr>
208     </table>
209 sysadm 1.1 </td>
210     </tr>
211     <?
212     }
213     mysql_free_result($rs);
214     ?>
215     </table>
216     </td>
217     <td width="5" bgcolor="#ffffff"><img src="<? echo $base_url; ?>/www/images/spacer.gif" width="1" height="1" border="0" alt=""></td>
218     <td width="1" bgcolor="#eeeeee"><img src="<? echo $base_url; ?>/www/images/spacer.gif" width="1" height="1" border="0" alt=""></td>
219     <td width="5" bgcolor="#ffffff"><img src="<? echo $base_url; ?>/www/images/spacer.gif" width="1" height="1" border="0" alt=""></td>
220     <td width="184" valign="top" align="center"><br clear="all">
221 sysadm 1.15 <br clear="all">
222 sysadm 1.1 <br>
223 sysadm 1.15 </td>
224 sysadm 1.1 </tr>
225     </table>
226     <table border="0" width="598" cellspacing="0" cellpadding="0">
227     <tr>
228 sysadm 1.15 <td width="598" colspan="3" bgcolor="#999999"><img src="<? echo $base_url; ?>/www/images/spacer.gif" width="1" height="1" border="0"></td>
229 sysadm 1.1 </tr>
230     <tr>
231 sysadm 1.15 <td width="5"><img src="<? echo $base_url; ?>/www/images/spacer.gif" width="1" height="1" border="0"></td>
232 sysadm 1.1 <td width="588"> <p>&nbsp;</p>
233 sysadm 1.15 <p><font face="Times New Roman,Times,Serif" size="-1"><strong>枫林在线论坛精华区</strong><br>
234     <br>
235     枫林在线除了向您推荐近期的优秀文章外，还提供以往的精彩文章的<a href="<? echo $base_url; ?>/gen_ex/">在线浏览</a>服务。</font>
236     </p>
237     <hr width="588" size="1">
238     <p> <font face="Times New Roman,Times,Serif" size="-1"> <strong>关于本邮件</strong><br>
239     <br>
240     感谢您订阅枫林在线的《精品导读》，您可以从我们提供的<a href="<? echo $base_url; ?>/bbs/preference.php">个人设定</a>功能中订阅/取消订阅本刊物。<br>
241     <br>
242     如果您对我们的工作有什么意见或建议，请<a href="<? echo $base_url; ?>/www/contact_us.php">与我们联系</a>。</font></p>
243     <p><br>
244     </p></td>
245     <td width="5"><img src="<? echo $base_url; ?>/www/images/spacer.gif" width="1" height="1" border="0"></td>
246 sysadm 1.1 </tr>
247     <tr>
248 sysadm 1.15 <td width="598" colspan="3" bgcolor="#999999"><img src="<? echo $base_url; ?>/www/images/spacer.gif" width="1" height="1" border="0"></td>
249 sysadm 1.1 </tr>
250     <tr>
251 sysadm 1.15 <td width="598" colspan="3" bgcolor="#e4e4e4" height="25"> <img src="<? echo $base_url; ?>/www/images/spacer.gif" width="5" height="1" border="0">
252     <font face="Times New Roman,Times,Serif" size="-1"> Copyright &copy;
253     2003-2025 <a href="<? echo $base_url; ?>/" target="_blank">枫林在线</a> | <a href="<? echo $base_url; ?>/www/privacy.php">隐私保护</a> </font> </td>
254 sysadm 1.1 </tr>
255     </table>
256     </td>
257 sysadm 1.15 <td width="1" bgcolor="#999999"><img src="<? echo $base_url; ?>/www/images/spacer.gif" width="1" height="1" border="0"></td>
258 sysadm 1.1 </tr>
259     <tr>
260 sysadm 1.15 <td width="1" colspan="3" bgcolor="#999999"><img src="<? echo $base_url; ?>/www/images/spacer.gif" width="1" height="1" border="0"></td>
261 sysadm 1.1 </tr>
262     </table>
263     </center>
264     </body>
265     </html>
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1