1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
|
<?php
/**
* Bayonet Content Management System
* Copyright (C) 2008 Joseph Hunkeler & Evan O'Connell
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
function EditNews($news_id){
global $db;
if(isset($_POST['processed'])){
return;
}
$result = $db->Query("SELECT `author_id`, `title`, `message`, `date`, `category_id` FROM `bayonet_news` WHERE `news_id` = '$news_id' LIMIT 1");
$row = $db->Fetch($result);
?>
<h3>Edit Event</h3>
<form action="<?php $_SERVER['PHP_SELF']?>" method="post">
<table>
<tr><th>Author</th><td><?php SelectAuthor($row['author_id']); ?></td></tr>
<tr><th>Title</th><td><input type="text" name="title" value="<?php echo $row['title']; ?>" /></td></tr>
<tr><th>Date</th><td><?php SelectDate($row['date']); ?></td></tr>
<tr><th>Time</th><td><input type="text" name="time" value="<?php echo substr($row['time'],0,-3); ?>" maxlength="5" size="5" /></td></tr>
<tr><th>Text</th><td><textarea id="markItUp" rows="30" cols="80" name="text"><?php echo $row['message']; ?></textarea></td>
<tr><th colspan="2"><input type="submit" name="processed" value="Submit" /></th></tr>
</table>
</form>
<?php
}
/**
* SelectDate($date)
* Function for outputing an html form for selecting a month day and year
* @param date - formatted date string yyyy-mm-dd (optional)
*/
function SelectDate($date = NULL){
$date_arr = date_parse($date); //returns an associative array $array['year']
//List Months
echo '<select name="month">';
for($m = 1;$m <= 12; $m++){
$month = date("F", mktime(0, 0, 0, $m));
if($date_arr['month'] == $m)
echo "<option value='$m' selected=\"selected\">$month</option>";
else
echo "<option value='$m'>$month</option>";
}
echo "</select>";
//List Days
echo '<select name="day">';
for($d = 1;$d <= 31; $d++){
if($date_arr['day'] == $d)
echo "<option value='$d' selected=\"selected\">$d</option>";
else
echo "<option value='$d'>$d</option>";
}
echo "</select>";
//List Years [CurYear, CurYear+5]
echo '<select name="year">';
$y = date('Y', time());
$max = $y+5;
for(;$y<$max; $y++){
if($date_arr['year'] == $y)
echo "<option value='$y' selected=\"selected\">$y</option>";
else
echo "<option value='$y'>$y</option>";
}
echo "</select>";
}
function SelectAuthor($author_id){
global $db;
echo "<select name=\"author\">";
$result = $db->Query("SELECT `user_id`, `lastname` FROM `bayonet_users` WHERE `active` = 1 ORDER BY `username` ASC");
while(($row = $db->Fetch($result))!= false){
if($author_id == $row['user_id'])
echo "<option value=\"{$row['user_id']}\" selected>{$row['lastname']}</option>";
else
echo "<option value=\"{$row['user_id']}\">{$row['lastname']}</option>";
}
echo "</select>";
}
?>
|
