|
PCCS MySQLDatabase Admin Tool version 1.3.4
|
/ -> mysqldb_create_newssys.php
1 <?php
2 /************************************************************************
3 PCCS MySQLDatabase Admin Tool
4 Copyright (C) Chauncey Thorn
5
6 This program is free software; you can redistribute it and/or
7 modify it under the terms of the GNU General Public License
8 as published by the Free Software Foundation; either version 2
9 of the License, or (at your option) any later version.
10
11 This program is distributed in the hope that it will be useful,
12 but WITHOUT ANY WARRANTY; without even the implied warranty of
13 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 GNU General Public License for more details.
15
16 You should have received a copy of the GNU General Public License
17 along with this program; if not, write to the Free Software
18 Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA , USA.
19 **************************************************************************/
20
21
22 // News System
23 // Files included
24 // movenews.php
25 // newsfunction.php
26 // testnews.php
27
28 // Create testnews.php
29 // Used to test news items as they are displayed
30 if($new_system == "Y"):
31
32 $testnews_filename="testnews.php";
33
34 $testnews = fopen($appfiledir . $backup_filename,"w");
35 fputs($testnews,"<?php\n//** Generated by PCCS-MyAppGen $today\n");
36 fputs($testnews,"/////////////////////////////////////////////////////////////////////////////////////\n");
37 fputs($testnews,"// coder: cthorn\n");
38 fputs($testnews,"////////////////////////////////////////////////////////////////////////////\n");
39 fputs($testnews,"//\n");
40 fputs($testnews,"//\n");
41 fputs($testnews,"require('newsfunction.php');\n");
42 fputs($testnews,"\n");
43 fputs($testnews,"displayNewsStories(10,\"440\");\n");
44 fputs($testnews,"\n");
45 fputs($testnews,"\n");
46
47 fputs($testnews,"//\n");
48 fputs($testnews,"//////////////////////////////////////////////////////////////////////////\n");
49 fputs($testnews,"?>\n");
50 fclose($testnews);
51
52
53 // Create newsfunction.php
54
55 $newsfunction_filename="newsfunction.php";
56
57 $newsfunction = fopen($appfiledir . $newsfunction_filename,"w");
58 fputs($newsfunction,"<?php\n//** Generated by PCCS-MyAppGen $today\n");
59 fputs($newsfunction,"/////////////////////////////////////////////////////////////////////////////////////\n");
60 fputs($newsfunction,"// coder: cthorn\n");
61 fputs($newsfunction,"////////////////////////////////////////////////////////////////////////////\n");
62 fputs($newsfunction,"//\n");
63 fputs($newsfunction,"//\n");
64 fputs($newsfunction,"function displayNewsStories(\$MAX_NUM_STORIES_TO_SHOW = \"\",\$tbl_width=\"\")\n");
65 fputs($newsfunction,"{\n");
66 fputs($newsfunction,"// global \$dbhandle,\$bgcolor,\$bgtext,\$tcolor,\$ttext,\$fcolor,\$ftext,\$link;\n");
67 fputs($newsfunction,"\n");
68 fputs($newsfunction," if (\$tbl_width == \"\"){\n");
69 fputs($newsfunction," \$tbl_width = 300 ;\n");
70 fputs($newsfunction," }\n");
71 fputs($newsfunction," if (\$MAX_NUM_STORIES_TO_SHOW == \"\"){\n");
72 fputs($newsfunction," \$MAX_NUM_STORIES_TO_SHOW = 6 ;\n");
73 fputs($newsfunction," }\n");
74 fputs($newsfunction,"?> \n");
75 fputs($newsfunction,"\n");
76 fputs($newsfunction,"<?php\n");
77 fputs($newsfunction,"require('dbinclude.php');\n");
78 fputs($newsfunction,"\n");
79 fputs($newsfunction," \$SQLText = \"SELECT news_id, news_story_date, news_story_title,\n");
80 fputs($newsfunction," news_story_active, news_story_test,\n");
81 fputs($newsfunction," news_story_author, news_story_html\n");
82 fputs($newsfunction," FROM news \n");
83 fputs($newsfunction," WHERE news_story_active = 1 order by\n");
84 fputs($newsfunction," news_story_date desc\";\n");
85 fputs($newsfunction,"\n");
86 fputs($newsfunction,"\n");
87 fputs($newsfunction,"\n");
88 fputs($newsfunction,"\$news_query = mysql_query(\$SQLText, \$dbhandle);\n");
89 fputs($newsfunction,"\n");
90 fputs($newsfunction,"if (\$news_query == 0 ) {\n");
91 fputs($newsfunction," \$error=1;\n");
92 fputs($newsfunction,"}\n");
93 fputs($newsfunction,"\n");
94 fputs($newsfunction,"if (\$error != 1){\n");
95 fputs($newsfunction," \$num_rows = mysql_num_rows(\$news_query);\n");
96 fputs($newsfunction," if (\$num_rows > \$MAX_NUM_STORIES_TO_SHOW){\n");
97 fputs($newsfunction," \$num_rows = \$MAX_NUM_STORIES_TO_SHOW;\n");
98 fputs($newsfunction," }\n");
99 fputs($newsfunction,"} \n");
100 fputs($newsfunction," \n");
101 fputs($newsfunction,"?>\n");
102
103 fputs($newsfunction,"<? if (\$test_view == 1) {?><a href=\"newsadmin.php\">\n");
104 fputs($newsfunction,"<font color=\"#FF0000\" face=\"arial,helvetica\" size=2>Testing - Go Back To\n");
105 fputs($newsfunction,"News Admin</font></a><br><?}?>\n");
106 fputs($newsfunction,"<?\n");
107 fputs($newsfunction,"if (\$error != 1){\n");
108 fputs($newsfunction," for (\$i=0; \$i < \$num_rows; \$i++){\n");
109 fputs($newsfunction," \$row = mysql_fetch_array(\$news_query);\n");
110 fputs($newsfunction," \$datetime = \$row["news_story_date"];\n");
111 fputs($newsfunction," \$year = strtok($datetime, \"- :\");\n");
112 fputs($newsfunction," \$month = strtok(\"- :\");\n");
113 fputs($newsfunction," \$day = strtok(\"- :\");\n");
114 fputs($newsfunction," \$hour = strtok(\"- :\");\n");
115 fputs($newsfunction," \$minute = strtok(\"- :\");\n");
116 fputs($newsfunction," \$second = strtok(\"- :\");\n");
117 fputs($newsfunction," \$timestamp = mktime((int)\$hour, (int)\$minute, (int)\$second, (int)\$month,
118 (int)\$day, (int)\$year);\n");
119 fputs($newsfunction,"?>\n");
120 fputs($newsfunction,"\n");
121 fputs($newsfunction,"<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"<?echo $tbl_width;?>\">\n");
122 fputs($newsfunction,"<tr bgcolor=#<?echo \$bgcolor;?>>\n");
123 fputs($newsfunction,"<td width=\"<?echo \$tbl_width;?>\" height=\"20\" align=\"LEFT\" valign=\"TOP\">\n");
124 fputs($newsfunction,"<font face=\"arial,helvetica\" size=\"2\" >\n");
125 fputs($newsfunction,"<b> <? echo \$row[\"news_story_title\"] ?> </font></b>\n");
126 fputs($newsfunction,"<b><i> Posted by <? echo $row[\"news_story_author\"] ?></i></b>\n");
127 fputs($newsfunction,"</td>\n");
128 fputs($newsfunction,"<td>\n");
129 fputs($newsfunction,"<font face=\"arial,helvetica\" size=\"-1\" >\n");
130 fputs($newsfunction,"\n");
131 fputs($newsfunction,"<b><i><? echo date(\"m.d.Y H:i\", \$timestamp) ?></i></b><br>\n");
132 fputs($newsfunction,"</font>\n");
133 fputs($newsfunction,"</td>\n");
134 fputs($newsfunction,"</tr>\n");
135 fputs($newsfunction,"</table>\n");
136 fputs($newsfunction,"<table border=\"0\" cellpadding=\"7\" cellspacing=\"0\" width=\"<?echo \$tbl_width;?>\">\n");
137 fputs($newsfunction,"<tr>\n");
138 fputs($newsfunction,"<td background=\"images/index_news_content.gif\">\n");
139 fputs($newsfunction,"<font face=\"arial,helvetica\" size=\"2\" >\n");
140 fputs($newsfunction,"<? echo \$row[\"news_story_html\"] ?>\n");
141 fputs($newsfunction,"<p>\n");
142 fputs($newsfunction,"</td>\n");
143 fputs($newsfunction,"</font></tr>\n");
144 fputs($newsfunction,"</table>\n");
145 fputs($newsfunction,"<?\n");
146 fputs($newsfunction," }\n");
147 fputs($newsfunction,"}\n");
148 fputs($newsfunction,"?>\n");
149 fputs($newsfunction,"\n");
150 fputs($newsfunction,"<?\n");
151 fputs($newsfunction,"} // End of displayNewsStories\n");
152 fputs($newsfunction,"//\n");
153 fputs($newsfunction,"//////////////////////////////////////////////////////////////////////////\n");
154 fputs($newsfunction,"?>\n");
155 fclose($newsfunction);
156 ///
157
158 // Create editnews.php
159 // Begin Edit news
160 $editnews_filename="editnews.php";
161
162 $editnews = fopen($appfiledir . $editnews_filename,"w");
163 fputs($editnews,"<?php\n//** Generated by PCCS-MyAppGen $today\n");
164 fputs($editnews,"/////////////////////////////////////////////////////////////////////////////////////\n");
165 fputs($editnews,"// coder: cthorn\n");
166 fputs($editnews,"////////////////////////////////////////////////////////////////////////////\n");
167 fputs($editnews,"//\n");
168 fputs($editnews,"require('./webnews_include.inc');\n");
169 fputs($editnews,"\n");
170 fputs($editnews,"\$LIST_STORIES_PAGE = \"newsadmin.php\";\n");
171 fputs($editnews,"\n");
172 fputs($editnews,"\n");
173 fputs($editnews,"if (\$running_form != \"\") {\n");
174 fputs($editnews," if (\$story_id == \"\"){\n");
175 fputs($editnews," \$story_id = 0;\n");
176 fputs($editnews," }\n");
177 fputs($editnews," \$strTitle = ereg_replace(\"'\", \"''\", \$strTitle);\n");
178 fputs($editnews," \$strHTML = ereg_replace(\"'\", \"''\", \$strHTML);\n");
179 fputs($editnews," \$strAuthor = ereg_replace(\"'\", \"''\", \$strAuthor);\n");
180 fputs($editnews,"\n");
181 fputs($editnews," //see if new record\n");
182 fputs($editnews," if (\$story_id > 0){\n");
183 fputs($editnews," //'Update current Story\n");
184 fputs($editnews," \$SQLText = \"Update news set news_story_title = '\" . \$strTitle . "',
185 news_story_author = '" . \$strAuthor . \"' , news_story_date = '\" . date(\"Y-m-d H:i:s\") . \"',
186 news_story_html = '\" . \$strHTML . \"' where news_id = \" . \$story_id;\n");
187 fputs($editnews," }\n");
188 fputs($editnews," else {\n");
189 fputs($editnews," //Insert New Story\n");
190 fputs($editnews," \$SQLText = \"Insert into news (news_story_title, news_story_active, news_story_test, news_story_author, news_story_date, news_story_html) " .
191 fputs($editnews," \"values ('\" . \$strTitle . \"',0,0,'\" . \$strAuthor . \"','\" .
192 date(\"Y-m-d H:i:s\") . \"','\" . \$strHTML . \"')\";\n");
193 fputs($editnews,"\n");
194 fputs($editnews," }\n");
195 fputs($editnews,"\n");
196 fputs($editnews,"\n");
197 fputs($editnews," \$rs_handle = mysql_query(\$SQLText, \$dbhandle) or\n");
198 fputs($editnews," die(\"Query Failed\");\n");
199 fputs($editnews," \$num_affected = mysql_affected_rows(\$dbhandle);\n");
200 fputs($editnews,"\n");
201 fputs($editnews,"\n");
202 fputs($editnews,"\n");
203 fputs($editnews," if (\$num_affected != 1) {\n");
204 fputs($editnews," print \"There was an Error\";\n");
205 fputs($editnews," print mysql_error();\n");
206 fputs($editnews," exit;\n");
207 fputs($editnews," }\n");
208 fputs($editnews," else {\n");
209 fputs($editnews," header(\"Location: \$LIST_STORIES_PAGE\");\n");
210 fputs($editnews," exit;\n");
211 fputs($editnews," }\n");
212 fputs($editnews,"}\n");
213 fputs($editnews,"\n");
214 fputs($editnews,"else{\n");
215 fputs($editnews," if ((\$story_id != \"\") or (\$story_id > 0)) {\n");
216 fputs($editnews," //Edit Curtent Story\n");
217 fputs($editnews," \$SQLText = \"Select news_id, news_story_title, news_story_active, news_story_test,
218 news_story_author, news_story_html from news where news_id = \" . \$story_id;\n");
219 fputs($editnews,"\n");
220 fputs($editnews," \$rs_handle = mysql_query(\$SQLText, \$dbhandle);\n");
221 fputs($editnews,"\n");
222 fputs($editnews," if (\$rs_handle == 0) {\n");
223 fputs($editnews," header(\"Location: \$ERROR_PAGE\");\n");
224 fputs($editnews," exit;\n");
225 fputs($editnews," }\n");
226 fputs($editnews," \$num_affected = mysql_num_rows(\$rs_handle);\n");
227 fputs($editnews," if (\$num_affected == 0 ) {\n");
228 fputs($editnews," header(\"Location: \$ERROR_PAGE\");\n");
229 fputs($editnews," exit;\n");
230 fputs($editnews," }\n");
231 fputs($editnews," \$rs = mysql_fetch_array(\$rs_handle);\n");
232 fputs($editnews," if (\$rs[\"news_story_active\"] == 1) {\n");
233 fputs($editnews," header(\"Location: \" . \$LIST_STORIES_PAGE . \"?errortype=active\");\n");
234 fputs($editnews," exit;\n");
235 fputs($editnews," }\n");
236 fputs($editnews,"\n");
237 fputs($editnews," \$story_id = \$rs[\"news_id\"];\n");
238 fputs($editnews," \$strTitle = \$rs[\"news_story_title\"];\n");
239 fputs($editnews," \$strHTML = \$rs[\"news_story_html\"];\n");
240 fputs($editnews," \$strAuthor = \$rs[\"news_story_author\"];\n");
241 fputs($editnews," }\n");
242 fputs($editnews," else {\n");
243 fputs($editnews," \$story_id = \"\";\n");
244 fputs($editnews," \$strTitle = \"\";\n");
245 fputs($editnews," \$strHTML = \"\";\n");
246 fputs($editnews," \$strAuthor = \"\";\n");
247 fputs($editnews," }\n");
248 fputs($editnews,"}\n");
249 fputs($editnews,"?>\n");
250 fputs($editnews,"<?\n");
251 fputs($editnews,"/* Read in constants used over the whole site */\n");
252 fputs($editnews,"require('site_const.phi');\n");
253 fputs($editnews,"?>\n");
254 fputs($editnews,"<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">\n");
255 fputs($editnews,"\n");
256 fputs($editnews,"<html>\n");
257 fputs($editnews,"<head>\n");
258 fputs($editnews," <title>News - <? If (\$strTitle =="") {?>Untitled<? }else{ ?><?echo \$strTitle ?><? } ?></title>\n");
259 fputs($editnews,"</head>\n");
260 fputs($editnews,"\n");
261 fputs($editnews," <BODY BGCOLOR= \"#<?echo \$bgcolor;?>\"\n");
262 fputs($editnews," TEXT=\"#<?echo \$bgtext;?>\"\n");
263 fputs($editnews," LINK=\"#<?echo \$link;?>\"\n");
264 fputs($editnews," VLINK=\"#<?echo \$link;?>\"\n");
265 fputs($editnews," ALINK=\"#ffffff\">\n");
266 fputs($editnews,"<div align=\"center\">\n");
267 fputs($editnews,"\n");
268 fputs($editnews,"<table border=\"4\" cellpadding=\"7\" cellspacing=\"0\" width=\"581\">\n");
269 fputs($editnews,"<tr bgcolor=#<?echo \$tcolor;?>>\n");
270 fputs($editnews,"<td> </td>\n");
271 fputs($editnews,"</tr>\n");
272 fputs($editnews,"<tr bgcolor=#<?echo \$fcolor;?>>\n");
273 fputs($editnews,"<td><font face=\"arial,helvetica\" size=\"2\">\n");
274 fputs($editnews,"<form action=\"editnews.php\" method=\"POST\">\n");
275 fputs($editnews,"<input type=\"Hidden\" name=\"running_form\" value=\"true\">\n");
276 fputs($editnews,"<input type=\"Hidden\" name=\"story_id\" value=\"<? echo \$story_id ?>\">\n");
277 fputs($editnews,"<table border=0 cellpadding=3 cellspacing=0 background=\"\">\n");
278 fputs($editnews,"<tr>\n");
279 fputs($editnews,"<td align=\"RIGHT\" bgcolor=#<?echo \$fcolor;?>><font face=\"arial,helvetica\" size=\"2\" >Title</font></td>\n");
280 fputs($editnews,"<td bgcolor=#<?echo \$fcolor;?>><input type=\"Text\" name=\"strTitle\" value=\"<? echo \$strTitle ?>\"
281 size=\"58\" maxlength=\"80\"><font face=\"arial,helvetica\" size=\"1\"> </font></td>\n");
282 fputs($editnews,"</tr>\n");
283 fputs($editnews,"<tr>\n");
284 fputs($editnews,"<td bgcolor=#<?echo \$fcolor;?> align=\"right\"><font face=\"arial,helvetica\" size=\"2\" >Author</font></td>\n");
285 fputs($editnews,"<td bgcolor=#<?echo \$fcolor;?>><input type=\"Text\" name=\"strAuthor\" value=\"<? echo \$strAuthor
286 ?>\" size=\"20\" maxlength=\"20\"><font face=\"arial,helvetica\" size=\"1\"> </font></td>\n");
287 fputs($editnews,"</tr>\n");
288 fputs($editnews,"<tr>\n");
289 fputs($editnews,"<td bgcolor=#<?echo \$fcolor;?> align=\"right\" valign=\"top\">\n");
290 fputs($editnews,"<font face=\"arial,helvetica\" size=\"2\" ><br><br>News in HTML</font></td>\n");
291 fputs($editnews,"<td bgcolor=#<?echo \$fcolor;?>><TEXTAREA NAME=\"strHTML\" ROWS=25 COLS=88><?echo \$strHTML ?></TEXTAREA></td>\n");
292 fputs($editnews,"</tr>\n");
293 fputs($editnews,"</table><center>\n");
294 fputs($editnews,"<input type=submit value=\"Post News Story\" border=0>\n");
295 fputs($editnews,"</center>\n");
296 fputs($editnews,"</form>\n");
297 fputs($editnews,"</td>\n");
298 fputs($editnews,"</font></tr>\n");
299 fputs($editnews,"<tr bgcolor=#<?echo \$tcolor;?>>\n");
300 fputs($editnews,"<td> </td>\n");
301 fputs($editnews,"</tr>\n");
302 fputs($editnews,"</table>\n");
303 fputs($editnews,"\n");
304 fputs($editnews,"</div>\n");
305 fputs($editnews,"</body>\n");
306 fputs($editnews,"</html>\n");
307 fputs($editnews,"//\n");
308 fputs($editnews,"//////////////////////////////////////////////////////////////////////////\n");
309 fputs($editnews,"?>\n");
310 fclose($editnews);
311
312 // end Edit news
313
314
315
316
317 // Create movenews.php
318 // begin move news
319 $movenews_filename="movenews.php";
320
321 $movenews = fopen($appfiledir . $movenews_filename,"w");
322 fputs($movenews,"<?php\n//** Generated by PCCS-MyAppGen $today\n");
323 fputs($movenews,"/////////////////////////////////////////////////////////////////////////////////////\n");
324 fputs($movenews,"// coder: cthorn\n");
325 fputs($movenews,"////////////////////////////////////////////////////////////////////////////\n");
326 fputs($movenews,"//\n");
327 fputs($movenews,"\n");
328 fputs($movenews,"\$ERROR_PAGE = \"site_admin_error.html\";\n");
329 fputs($movenews,"\$LIST_STORIES_PAGE = \"newsadmin.php\";\n");
330 fputs($movenews,"\n");
331 fputs($movenews,"\n");
332 fputs($movenews,"require('./webnews_include.inc');\n");
333 fputs($movenews,"\n");
334 fputs($movenews,"\n");
335 fputs($movenews,"/*Move Story from active to test*/\n");
336 fputs($movenews,"if (\$active_to_test > 0) {\n");
337 fputs($movenews," \$SQLText = \"Update news set news_story_active = 0 where news_id =\" . \$active_to_test;\n");
338 fputs($movenews," \$atot_query_handle = mysql_query(\$SQLText, \$dbhandle);\n");
339 fputs($movenews," header(\"Location: \$LIST_STORIES_PAGE\");\n");
340 fputs($movenews," if (\$atot_query_handle > 0){\n");
341 fputs($movenews," \$error=0;\n");
342 fputs($movenews," }\n");
343 fputs($movenews," else {\n");
344 fputs($movenews," \$error=1;\n");
345 fputs($movenews," }\n");
346 fputs($movenews,"}\n");
347 fputs($movenews,"/* Move Story From test to Active */\n");
348 fputs($movenews,"if (\$test_to_active > 0) {\n");
349 fputs($movenews," \$SQLText = \"Update news set news_story_active = 1 where news_id =\" . \$test_to_active;\n");
350 fputs($movenews," \$ttoa_query_handle = mysql_query(\$SQLText, \$dbhandle);\n");
351 fputs($movenews," if (\$ttoa_query_handle > 0){\n");
352 fputs($movenews," \$error=0;\n");
353 fputs($movenews," }\n");
354 fputs($movenews," else {\n");
355 fputs($movenews," \$error=1;\n");
356 fputs($movenews," }\n");
357 fputs($movenews,"}\n");
358 fputs($movenews,"\n");
359 fputs($movenews,"/*Move Story From test to working*/\n");
360 fputs($movenews,"if (\$test_to_working > 0) {\n");
361 fputs($movenews," \$SQLText = \"Update news set news_story_test = 0 where news_id =\" . \$test_to_working;\n");
362 fputs($movenews," \$ttow_query_handle = mysql_query(\$SQLText, \$dbhandle);\n");
363 fputs($movenews," if (\$ttow_query_handle > 0){\n");
364 fputs($movenews," \$error=0;\n");
365 fputs($movenews," }\n");
366 fputs($movenews," else {\n");
367 fputs($movenews," \$error=1;\n");
368 fputs($movenews," }\n");
369 fputs($movenews,"}\n");
370 fputs($movenews,"\n");
371 fputs($movenews,"\n");
372 fputs($movenews,"/*'Move Story from working to test*/\n");
373 fputs($movenews,"if (\$working_to_test > 0) {\n");
374 fputs($movenews," \$SQLText = \"Update news set news_story_test = 1 where news_id =\" . \$working_to_test;\n");
375 fputs($movenews," \$wtot_query_handle = mysql_query(\$SQLText, \$dbhandle);\n");
376 fputs($movenews," if (\$wtot_query_handle > 0){\n");
377 fputs($movenews," \$error=0;\n");
378 fputs($movenews," }\n");
379 fputs($movenews," else {\n");
380 fputs($movenews," \$error=1;\n");
381 fputs($movenews," }\n");
382 fputs($movenews,"}\n");
383 fputs($movenews,"\n");
384 fputs($movenews,"/*'Move Story from working to test*/\n");
385 fputs($movenews,"if (\$delete > 0) {\n");
386 fputs($movenews," \$SQLText = \"delete from news where news_story_active=0 and news_id=\" . \$delete;\n");
387 fputs($movenews," \$delete_query_handle = mysql_query(\$SQLText, \$dbhandle);\n");
388 fputs($movenews," if (\$delete_query_handle > 0){\n");
389 fputs($movenews," \$error=0;\n");
390 fputs($movenews," }\n");
391 fputs($movenews," else {\n");
392 fputs($movenews," \$error=1;\n");
393 fputs($movenews," }\n");
394 fputs($movenews,"}\n");
395 fputs($movenews,"if (\$error == 0){\n");
396 fputs($movenews," header(\"Location: \$LIST_STORIES_PAGE\");\n");
397 fputs($movenews,"}\n");
398 fputs($movenews,"else {\n");
399 fputs($movenews," header(\"Location: \$ERROR_PAGE\");\n");
400 fputs($movenews,"}\n");
401 fputs($movenews,"\n");
402 fputs($movenews,"//\n");
403 fputs($movenews,"//////////////////////////////////////////////////////////////////////////\n");
404 fputs($movenews,"?>\n");
405 fclose($movenews);
406 // End move news
407
408
409 // Create newsadmin file
410 $newsadmin_filename="newsadmin.php";
411
412 $newsadmin = fopen($appfiledir . $newsadmin_filename,"w");
413 fputs($newsadmin,"<?php\n//** Generated by PCCS-MyAppGen $today\n");
414 fputs($newsadmin,"/////////////////////////////////////////////////////////////////////////////////////\n");
415 fputs($newsadmin,"// coder: cthorn\n");
416 fputs(newsadmin,"////////////////////////////////////////////////////////////////////////////\n");
417 fputs($newsadmin,"//\n");
418 fputs($newsadmin,"require('./webnews_include.inc');\n");
419 fputs($newsadmin,"\n");
420 fputs($newsadmin,"\$MAX_NUM_STORIES_TO_SHOW = 10;\n");
421 fputs($newsadmin,"\n");
422 fputs($newsadmin,"//Active Stories.....\n");
423 fputs($newsadmin,"\$SQLText = \"Select news_id, news_story_title, news_story_active, news_story_test, news_story_author,
424 news_story_html from news where news_story_active = 1 order by news_story_date desc\";\n");
425 fputs($newsadmin,"\$active_query_handle = mysql_query(\$SQLText, \$dbhandle);\n");
426 fputs($newsadmin,"if (\$active_query_handle > 0){\n");
427 fputs($newsadmin," \$num_active_stories = mysql_num_rows(\$active_query_handle);\n");
428 fputs($newsadmin,"}\n");
429 fputs($newsadmin,"\n");
430 fputs($newsadmin,"// Test Stories\n");
431 fputs($newsadmin,"\$testsql = \"Select news_id, news_story_title, news_story_active, news_story_test, news_story_author
432 from news where news_story_test = 1 and news_story_active = 0 order by news_id\";\n");
433 fputs($newsadmin,"\$test_query_handle = mysql_query(\$testsql, \$dbhandle);\n");
434 fputs($newsadmin,"if (\$test_query_handle >0){\n");
435 fputs($newsadmin," \$num_test_stories = mysql_num_rows(\$test_query_handle);\n");
436 fputs($newsadmin,"}\n");
437 fputs($newsadmin,"\n");
438 fputs($newsadmin,"// Working Stories\n");
439 fputs($newsadmin,"\n");
440 fputs($newsadmin,"\$worksql = \"Select news_id, news_story_title, news_story_active, news_story_test, news_story_author,
441 news_story_html from news where news_story_test = 0 and news_story_active = 0 order by news_story_date\";\n");
442 fputs($newsadmin,"\$working_query_handle = mysql_query(\$worksql, \$dbhandle);\n");
443 fputs($newsadmin,"if (\$working_query_handle >0){\n");
444 fputs($newsadmin," \$num_working_stories = mysql_num_rows(\$working_query_handle);\n");
445 fputs($newsadmin,"}\n");
446 fputs($newsadmin,"\n");
447 fputs($newsadmin,"?>\n");
448 fputs($newsadmin,"\n");
449 fputs($newsadmin,"<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">\n");
450 fputs($newsadmin,"\n");
451 fputs($newsadmin,"<html>\n");
452 fputs($newsadmin,"<head>\n");
453 fputs($newsadmin," <title>Site News -> Admin -> News Admin</title>\n");
454 fputs($newsadmin,"</head>\n");
455 fputs($newsadmin,"\n");
456 fputs($newsadmin," <BODY BGCOLOR= \"#<?echo \$bgcolor;?>\" \n");
457 fputs($newsadmin," TEXT=\"#<?echo \$bgtext;?>\"\n");
458 fputs($newsadmin," LINK=\"#<?echo \$link;?>\"\n");
459 fputs($newsadmin," VLINK=\"#<?echo \$link;?>\"\n");
460 fputs($newsadmin," ALINK=\"#ffffff\">\n");
461 fputs($newsadmin,"\n");
462 fputs($newsadmin,"<div align=\"center\">\n");
463 fputs($newsadmin,"\n");
464 fputs($newsadmin," <table border=\"4\" cellpadding=\"0\" cellspacing=\"0\" width=\"500\"\n");
465 fputs($newsadmin,"bgcolor=\"#FFFFFF\">\n");
466 fputs($newsadmin," <tr bgcolor=#<?echo \$tcolor;?>>\n");
467 fputs($newsadmin," <td> </td>\n");
468 fputs($newsadmin," </tr>\n");
469 fputs($newsadmin," <tr valign=\"TOP\" bgcolor=#<?echo \$fcolor;?>>\n");
470 fputs($newsadmin,"\n");
471 fputs($newsadmin," <!-- Top of left menu -->\n");
472 fputs($newsadmin," <!-- Bottom of left menu -->\n");
473 fputs($newsadmin," <!-- Begin Content Area -->\n");
474 fputs($newsadmin," <td valign=\"TOP\" align=\"CENTER\">\n");
475 fputs($newsadmin," [ <a href=\"newsadmin.php\">News Admin</a> \n");
476 fputs($newsadmin," - <a href=\"editnews.php\">Add New Story</a> \n");
477 fputs($newsadmin," - <a href=\"testnews.php?test_view=1\">News Test</a> ]\n");
478 fputs($newsadmin,"\n");
479 fputs($newsadmin," <center>\n");
480 fputs($newsadmin," <font face=\"arial,helvetica\" color=\"#ffffff\"><strong> NEWS ADMIN</strong></font><br>\n");
481 fputs($newsadmin,"\n");
482 fputs($newsadmin,"<? if (\$errortype != ""){ ?>\n");
483 fputs($newsadmin,"\n");
484 fputs($newsadmin," <? If (\$errortype == \"active\") { ?>\n");
485 fputs($newsadmin," <table cellpadding=2 cellspacing=1 border=0>\n");
486 fputs($newsadmin,"\n");
487 fputs($newsadmin," <tr bgcolor=#<?echo \$fcolor;?>>\n");
488 fputs($newsadmin," <td><font face=\"arial,helvetica\" color=\"#000000\">\n");
489 fputs($newsadmin," <strong>Error: Cannot Edit an Active Story - Move it Back to Test</strong></font></td>\n");
490 fputs($newsadmin," </tr>\n");
491 fputs($newsadmin," </table>\n");
492 fputs($newsadmin," <? } ?>\n");
493 fputs($newsadmin,"<? } ?>\n");
494 fputs($newsadmin,"\n");
495 fputs($newsadmin," <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n");
496 fputs($newsadmin,"\n");
497 fputs($newsadmin," <!-- Begin Content -->\n");
498 fputs($newsadmin," <tr>\n");
499 fputs($newsadmin,"\n");
500 fputs($newsadmin," <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"640\">\n");
501 fputs($newsadmin," <tr bgcolor=#<?echo \$tcolor;?>>\n");
502 fputs($newsadmin," <td> </td>\n");
503 fputs($newsadmin," </tr>\n");
504 fputs($newsadmin," <tr bgcolor=#<?echo \$fcolor;?>>\n");
505 fputs($newsadmin," <td width=\"581\" height=\"20\" align=\"LEFT\" valign=\"MIDDLE\" >\n");
506 fputs($newsadmin," <font face=\"arial,helvetica\" size=\"2\"><b> Active Stories</b></font></td>\n");
507 fputs($newsadmin," </tr>\n");
508 fputs($newsadmin," </table>\n");
509 fputs($newsadmin,"\n");
510 fputs($newsadmin," <table border=\"0\" cellpadding=\"7\" cellspacing=\"0\" width=\"581\">\n");
511 fputs($newsadmin," <tr bgcolor=#<?echo \$fcolor;?>>\n");
512 fputs($newsadmin," <td><font face=\"arial,helvetica\" size=\"2\">\n");
513 fputs($newsadmin," <!-- Title Font -->\n");
514 fputs($newsadmin," <font face=\"arial,helvetica\" size=\"2\">Note: Only the Latest <? echo \$MAX_NUM_STORIES_TO_SHOW ?> stories are available</font><br>\n");
515 fputs($newsadmin," <center>\n");
516 fputs($newsadmin," <table width=\"550\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\" >\n");
517 fputs($newsadmin,"<? if (\$num_active_stories == 0 ) {?>\n");
518 fputs($newsadmin,"\n");
519 fputs($newsadmin," <tr bgcolor=\"#000000\">\n");
520 fputs($newsadmin," <td colspan=5 bgcolor=\"white\">\n");
521 fputs($newsadmin," <font face=\"arial,helvetica\" size=\"1\" color=\"#000000\"><b>Warning!! No Current Active Stories</b></font></td>\n");
522 fputs($newsadmin," </tr>\n");
523 fputs($newsadmin,"<?}\n");
524 fputs($newsadmin," else {\n");
525 fputs($newsadmin," ?>\n");
526 fputs($newsadmin," <tr bgcolor=#<?echo \$fcolor;?>>\n");
527 fputs($newsadmin," <td align=\"CENTER\" ><font face=\"arial,helvetica\" size=\"1\"><b>Story ID</b></font></td>\n");
528 fputs($newsadmin," <td ><font face=\"arial,helvetica\" size=\"1\" ><b>Title</b></font></td>\n");
529 fputs($newsadmin," <td ><font face=\"arial,helvetica\" size=\"1\"><b>Author</b></font></td>\n");
530 fputs($newsadmin," <td ><font face=\"arial,helvetica\" size=\"1\"><b>Status</b></font></td>\n");
531 fputs($newsadmin," <td align=\"CENTER\" bgcolor=#<?echo \$fcolor;?>>\n");
532 fputs($newsadmin," <font face=\"arial,helvetica\" size=\"1\" color=\"RED\"><b>Demote to Test</b></font></td>\n");
533 fputs($newsadmin," </tr>\n");
534 fputs($newsadmin,"<?\n");
535 fputs($newsadmin," if (\$num_active_stories >= \$MAX_NUM_STORIES_TO_SHOW){\n");
536 fputs($newsadmin," \$num_active_stories = \$MAX_NUM_STORIES_TO_SHOW;\n");
537 fputs($newsadmin," }\n");
538 fputs($newsadmin," for (\$i=0; \$i < \$num_active_stories; \$i++){\n");
539 fputs($newsadmin," \$row = mysql_fetch_array(\$active_query_handle);\n");
540 fputs($newsadmin,"?>\n");
541 fputs($newsadmin," <tr bgcolor=\"White\">\n");
542 fputs($newsadmin," <td align=\"CENTER\"><font face=\"arial,helvetica\" size=\"1\"><? echo \$row[\"news_id\"] ?></font></td>\n");
543 fputs($newsadmin," <td><font face=\"arial,helvetica\" size=\"1\"><? echo \$row[\"news_story_title\"] ?></td>\n");
544 fputs($newsadmin," <td><font face=\"arial,helvetica\" size=\"1\"><? echo \$row[\"news_story_author\"] ?></font></td>\n");
545 fputs($newsadmin," <td><font face=\"arial,helvetica\" size=\"1\"><b>ACTIVE</b></font></td>\n");
546 fputs($newsadmin," <td align=\"CENTER\"><font face=\"arial,helvetica\" size=\"1\">\n");
547 fputs($newsadmin," <a href=\"movenews.php?active_to_test=<? echo \$row[\"news_id\"] ?>\">\n");
548 fputs($newsadmin," Demote to Test</a></font></td>\n");
549 fputs($newsadmin," </tr>\n");
550 fputs($newsadmin,"<?\n");
551 fputs($newsadmin," } // end of active story for loop\n");
552 fputs($newsadmin,"} // end of else statement for # of active stories\n");
553 fputs($newsadmin,"?>\n");
554 fputs($newsadmin," </table>\n");
555 fputs($newsadmin," </center>\n");
556 fputs($newsadmin," </td>\n");
557 fputs($newsadmin," </font></tr>\n");
558 fputs($newsadmin," </table>\n");
559 fputs($newsadmin," </tr>\n");
560 fputs($newsadmin," <tr bgcolor=#<?echo \$tcolor;?>>\n");
561 fputs($newsadmin," <td> </td>\n");
562 fputs($newsadmin," </tr>\n");
563 fputs($newsadmin," <!-- End Item -->\n");
564 fputs($newsadmin," <tr bgcolor=#<?echo \$fcolor;?>>\n");
565 fputs($newsadmin," <td>\n");
566 fputs($newsadmin," <center>\n");
567 fputs($newsadmin," <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"640\">\n");
568 fputs($newsadmin," <tr>\n");
569 fputs($newsadmin," <td width=\"640\" height=\"20\" align=\"LEFT\" valign=\"MIDDLE\" \"><font
570 face=\"arial,helvetica\" size=\"2\">\n");
571 fputs($newsadmin," <b> Test Stories</b></font></td>\n");
572 fputs($newsadmin," </tr>\n");
573 fputs($newsadmin," </table>\n");
574 fputs($newsadmin," <table border=\"0\" cellpadding=\"7\" cellspacing=\"0\" width=\"581\">\n");
575 fputs($newsadmin," <tr>\n");
576 fputs($newsadmin," <td><font face=\"arial,helvetica\" size=\"2\">\n");
577 fputs($newsadmin," <!-- Title Font -->\n");
578 fputs($newsadmin," <font face=\"arial,helvetica\" size=\"2\">[ <a\n");
579 fputs($newsadmin,"href=\"testnews.php?test_view=1\">Access Test Page</a> ] Note: The Test Page show active stories as well as test stories</font><br>\n");
580 fputs($newsadmin," <center>\n");
581 fputs($newsadmin," <table width=\"550\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\" background="http://www.pccs-linux.com/2002">\n");
582 fputs($newsadmin,"<? \n");
583 fputs($newsadmin,"\n");
584 fputs($newsadmin," if (\$num_test_stories == 0) {?>\n");
585 fputs($newsadmin," <tr bgcolor=\"white\">\n");
586 fputs($newsadmin," <td colspan=5 bgcolor=\"white\"><font face=\"arial,helvetica\" size=\"1\"><b>Warning!! No Current Test Stories</b></font></td>\n");
587 fputs($newsadmin," </tr>\n");
588 fputs($newsadmin,"<?}\n");
589 fputs($newsadmin," else {\n");
590 fputs($newsadmin," ?>\n");
591 fputs($newsadmin," <tr bgcolor=#<?echo \$fcolor;?>>\n");
592 fputs($newsadmin," <td align=\"CENTER\" bgcolor=#<?echo \$fcolor;?>><font face=\"arial,helvetica\" size=\"1\"
593 color=\"#000000\"><b>Story ID</b></font></td>\n");
594 fputs($newsadmin," <td bgcolor=#<?echo \$fcolor;?>><font face=\"arial,helvetica\" size=\"1\" color=\"#000000\"><b>Title</b></font></td>\n");
595 fputs($newsadmin," <td bgcolor=#<?echo \$fcolor;?>><font face=\"arial,helvetica\" size=\"1\" color=\"#000000\"><b>Author</b></font></td>\n");
596 fputs($newsadmin," <td align=\"CENTER\" bgcolor=#<?echo \$fcolor;?>><font face=\"arial,helvetica\" size=\"1\"
597 color=\"#000000\"><b>Promote to Active</b></font></td>\n");
598 fputs($newsadmin," <td align=\"CENTER\" bgcolor=#<?echo \$fcolor;?>><font face=\"arial,helvetica\" size=\"1\"
599 color=\"#000000\"><b>Demote to Draft</b></font></td>\n");
600 fputs($newsadmin," </tr>\n");
601 fputs($newsadmin,"<?php\n");
602 fputs($newsadmin," if (\$num_test_stories >= \$MAX_NUM_STORIES_TO_SHOW){\n");
603 fputs($newsadmin," \$num_test_stories = \$MAX_NUM_STORIES_TO_SHOW;\n");
604 fputs($newsadmin," }\n");
605 fputs($newsadmin," for (\$i=0; \$i < \$num_test_stories; \$i++){\n");
606 fputs($newsadmin," \$rstest = mysql_fetch_array(\$test_query_handle);\n");
607 fputs($newsadmin,"?>\n");
608 fputs($newsadmin," <tr bgcolor=\"white\">\n");
609 fputs($newsadmin," <td align=\"CENTER\"><font face=\"arial,helvetica\" size=\"1\"><? echo \$rstest[\"news_id\"] ?></font></td>\n");
610 fputs($newsadmin," <td><font face=\"arial,helvetica\" size=\"1\"><a href=\"editnews.php?story_id=<? echo
611 \$rstest[\"news_id\"] ?>\">\n");
612 fputs($newsadmin," <? echo \$rstest[\"news_story_title\"] ?></a></font></td>\n");
613 fputs($newsadmin," <td><font face=\"arial,helvetica\" size=\"1\"><? echo \$rstest[\"news_story_author\"] ?></font></td>\n");
614 fputs($newsadmin," <td align=\"CENTER\"><a href=\"movenews.php?test_to_active=<? echo \$rstest[\"news_id\"] ?>\">\n");
615 fputs($newsadmin," Promote Active</a></td>\n");
616 fputs($newsadmin," <td align=\"CENTER\"><a href=\"movenews.php?test_to_working=<? echo \$rstest[\"news_id\"] ?>\">\n");
617 fputs($newsadmin," Demote Draft</a></td>\n");
618 fputs($newsadmin," </tr>\n");
619 fputs($newsadmin,"<?php\n");
620 fputs($newsadmin," } // end of test story for loop\n");
621 fputs($newsadmin,"} // end of else statement for # of test stories\n");
622 fputs($newsadmin,"?>\n");
623 fputs($newsadmin," </table>\n");
624 fputs($newsadmin," </center>\n");
625 fputs($newsadmin," </td>\n");
626 fputs($newsadmin," </font></tr>\n");
627 fputs($newsadmin," </table>\n");
628 fputs($newsadmin," </tr>\n");
629 fputs($newsadmin," <tr bgcolor=#<?echo $tcolor;?>>\n");
630 fputs($newsadmin," <td> </td>\n");
631 fputs($newsadmin," </tr>\n");
632 fputs($newsadmin," <!-- End Item -->\n");
633 fputs($newsadmin," <tr>\n");
634 fputs($newsadmin," <td>\n");
635 fputs($newsadmin," <center>\n");
636 fputs($newsadmin," <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"640\">\n");
637 fputs($newsadmin," <tr bgcolor=#<?echo \$fcolor;?>>\n");
638 fputs($newsadmin," <td width=\"581\" height=\"20\" align=\"LEFT\" valign=\"MIDDLE\">\n");
639 fputs($newsadmin," <font face=\"arial,helvetica\" size=\"2\"><b> Draft Stories</b></font></td>\n");
640 fputs($newsadmin," </tr>\n");
641 fputs($newsadmin," </table>\n");
642 fputs($newsadmin," <table border=\"0\" cellpadding=\"7\" cellspacing=\"0\" width=\"640\">\n");
643 fputs($newsadmin," <tr bgcolor=#<?echo \$fcolor;?>>\n");
644 fputs($newsadmin," <td><font face=\"arial,helvetica\" size="2">\n");
645 fputs($newsadmin," <center>\n");
646 fputs($newsadmin," <table width=\"550\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\" background=\"\">\n");
647 fputs($newsadmin,"\n");
648 fputs($newsadmin,"<? if (\$num_working_stories == 0) {?>\n");
649 fputs($newsadmin," <tr bgcolor=\"#000000\">\n");
650 fputs($newsadmin," <td colspan=5 bgcolor=\"White\"><font face=\"arial,helvetica\" size=\"1\" ><b>No Current Draft Stories</b></font></td>\n");
651 fputs($newsadmin," </tr>\n");
652 fputs($newsadmin,"<?}\n");
653 fputs($newsadmin," else {\n");
654 fputs($newsadmin," ?>\n");
655 fputs($newsadmin," <tr bgcolor=#<?echo \$fcolor;?>>\n");
656 fputs($newsadmin," <td align=\"CENTER\" bgcolor=#<?echo \$fcolor;?>><font face=\"arial,helvetica\" size=\"1\"><b>Story ID</b></font></td>\n");
657 fputs($newsadmin," <td bgcolor=#<?echo \$fcolor;?>><font face=\"arial,helvetica\" size=\"1\"><b>Title</b></font></td>\n");
658 fputs($newsadmin," <td bgcolor=#<?echo \$fcolor;?>><font face=\"arial,helvetica\" size=\"1\"><b>Author</b></font></td>\n");
659 fputs($newsadmin," <td align=\"CENTER\" bgcolor=#<?echo \$fcolor;?>><font face=\"arial,helvetica\" size=\"1\"><b>Promote to Test</b></font></td>\n");
660 fputs($newsadmin," <td align=\"CENTER\" bgcolor=#<?echo \$fcolor;?>><font face=\"arial,helvetica\" size=\"1\"
661 color=\"RED\"><b>Delete Story</b></font></td>\n");
662 fputs($newsadmin," </tr>\n");
663 fputs($newsadmin,"<?php\n");
664 fputs($newsadmin," if (\$num_working_stories >= \$MAX_NUM_STORIES_TO_SHOW){\n");
665 fputs($newsadmin," \$num_working_stories = \$MAX_NUM_STORIES_TO_SHOW;\n");
666 fputs($newsadmin," }\n");
667 fputs($newsadmin," for (\$i=0; \$i < \$num_working_stories; \$i++){\n");
668 fputs($newsadmin," \$rsgeneral = mysql_fetch_array(\$working_query_handle);\n");
669 fputs($newsadmin,"?>\n");
670 fputs($newsadmin," <tr bgcolor=\"white\">\n");
671 fputs($newsadmin," <td align=\"CENTER\"><font face=\"verdana,arial,helvetica\" size=\"1\"><? echo
672 \$rsgeneral[\"news_id\"]?></font></td>\n");
673 fputs($newsadmin," <td><font face=\"verdana,arial,helvetica\" size=\"1\"><a href=\"editnews.php?story_id=<? echo
674 \$rsgeneral[\"news_id\"]?>\">\n");
675 fputs($newsadmin," <?echo \$rsgeneral[\"news_story_title\"] ?></a></font></td>\n");
676 fputs($newsadmin," <td><font face=\"verdana,arial,helvetica\" size=\"1\"><?echo \$rsgeneral[\"news_story_author\"] ?></font></td>\n");
677 fputs($newsadmin," <td align=\"CENTER\"><a href=\"movenews.php?working_to_test=<?echo \$rsgeneral[\"news_id\"]?>\">\n");
678 fputs($newsadmin," Promote to Test</a></td>\n");
679 fputs($newsadmin," <td align=\"CENTER\"><a href=\"movenews.php?delete=<? echo \$rsgeneral[\"news_id\"]?>\">Delete</a></td>\n");
680 fputs($newsadmin," </tr>\n");
681 fputs($newsadmin,"<?php\n");
682 fputs($newsadmin," } // end of draft story for loop\n");
683 fputs($newsadmin,"} // end of else statement for # of draft stories\n");
684 fputs($newsadmin,"?>\n");
685 fputs($newsadmin," </table>\n");
686 fputs($newsadmin," </center>\n");
687 fputs($newsadmin," </td>\n");
688 fputs($newsadmin," </font></tr>\n");
689 fputs($newsadmin," </table>\n");
690 fputs($newsadmin," </tr>\n");
691 fputs($newsadmin," <tr bgcolor=#<?echo \$tcolor;?>>\n");
692 fputs($newsadmin," <td> </td>\n");
693 fputs($newsadmin," </tr>\n");
694 fputs($newsadmin," <!-- End Item -->\n");
695 fputs($newsadmin," </table>\n");
696 fputs($newsadmin," </td>\n");
697 fputs($newsadmin,"\n");
698 fputs($newsadmin,"\n");
699 fputs($newsadmin," <td> </td>\n");
700 fputs($newsadmin,"</tr>\n");
701 fputs($newsadmin,"\n");
702 fputs($newsadmin,"</table>\n");
703 fputs($newsadmin,"</div>\n");
704 fputs($newsadmin,"</body>\n");
705 fputs($newsadmin,"</html>\n");
706 fputs($newsadmin,"\n");
707 fputs($newsadmin,"\n");
708 fclose($newsadmin);
709
710 endif;
711
712
713
714 ?>
| |