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:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
|
<?
class Forum_section {
private $sectionID;
private $type; # 1-> Bereich, 2->
private $title;
private $autor;
private $insection;
private $timeofcreation;
private $priority;
private $desc;
public function __construct($sectionID='', $type='', $title='', $autor='', $insection='', $timeofcreation='', $priority='', $desc='') {
if($sectionID == '') {
$sql = 'SELECT MAX(id) AS c FROM forumtopics';
$row = db_fetch_assoc(db_query($sql));
$sectionID = $row['c'] + 1;
}
$this->sectionID = $sectionID;
if($type !='' && $title != '') {
$this->type = $type;
$this->title = $title;
$this->autorID = $autor;
$this->insection = $insection;
$this->timeofcreation = $timeofcreation;
$this->priority = $priority;
$this->desc = $desc;
if($autor) {
$sql = 'SELECT name FROM accounts WHERE acctid = '.$this->autorID;
$row = db_fetch_assoc(db_query($sql));
$this->autorName = $row['name'];
}
output('Blubbublub');
}
else {
$sql = 'SELECT * FROM forumtopics WHERE id='.$this->sectionID;
$row = db_fetch_assoc(db_query($sql));
$this->type = $row['type'];
$this->title = $row['title'];
$this->autorID = $row['autorID'];
$this->insection = $row['insection'];
$this->timeofcreation = $row['timeofcreation'];
$this->priority = $row['priority'];
$this->desc = $row['desc'];
$sql = 'SELECT name FROM accounts WHERE acctid = '.$this->autorID;
$res = db_query($sql);
$row = db_fetch_assoc($res);
if($row['name']!='') {
$this->autorName = $row['name'];
}
}
}
public function save_section($type=2) {
$sql = 'INSERT INTO
forumtopics
(type,
title,
autor,
insection,
timeofcreation,
priority,
desc)
VALUES
('.$this->type.',
"'.$this->title.'",
"'.$this->autorID.'",
"'.$this->insection.'",
"'.$this->timeofcreation.'",
'.$this->priority.',
"'.$this->desc.'")';
db_query($sql);
}
public function load_section() {
$sql = 'SELECT * FROM forumtopics WHERE id = '.$this->sectionID;
$row = db_fetch_assoc(db_query($sql));
return $row;
}
}
class Forum_Post {
private $postID;
private $body;
private $postdate;
private $autorID;
private $autorName;
private $intopic;
public function __construct($postID=0, $body='', $postdate='', $autor='', $intopic='') {
$this->postID = (int)$postID;
if($body != '' && $postdate != '' && $autor != '' && $intopic != '') {
$this->body = $body;
$this->postdate = $postdate;
$this->autorID = $autor;
$this->intopic = $intopic;
$sql = 'SELECT name FROM accounts WHERE acctid = '.$this->autorID;
$row = db_fetch_assoc(db_query($sql));
$this->autorName = $row['name'];
}
else {
// Daten aus der Datenbank
$sql = 'SELECT * FROM forumposts WHERE postID = '.$this->postID;
$row = db_fetch_assoc(db_query($sql));
$this->body = $row['body'];
$this->postdate = $row['postdate'];
$this->autorID = $row['autor'];
$this->intopic = $row['intopic'];
$sql = 'SELECT name FROM accounts WHERE acctid = '.$this->autorID;
$res = db_query($sql);
$row = db_fetch_assoc($res);
if($row['name']!='') {
$this->autorName = $row['name'];
}
}
}
public function save_post() {
$sql = 'UPDATE forumposts SET body = "'.$this->body.'" WHERE postID = '.$this->postid;
db_query($sql);
if(db_affected_rows()==0) {
$sql = 'INSERT INTO
forumposts
VALUER
('.$this->autorID.',
"'.$this->body.'",
'.$this->postdate.')';
db_query($res);
}
}
public function change_post_body($newcontent) {
if($newcontent != '') {
$this->body = $newcontent;
return true;
}
else {
return false;
}
}
public function delete_post() {
$sql = 'DELETE FROM forumposts WHERE postID = '.$this->postID;
db_query($sql);
if(db_affected_rows()==0) {
return false;
}
else {
return true;
}
}
public function get_infos() {
$infos = array('postID' => $this->postID,
'autorID' => $this->autorID,
'autorName' => $this->autorName,
'body' => $this->body,
'postdate' => $this->postdate);
return $infos;
}
}
class Forum_Setting {
private $name;
private $value;
public function __construct($name, $value='') {
$this->name = $name;
if($value == '') {
$sql = 'SELECT value FROM forumsettings WHERE name = '.$this->name;
$row = db_fetch_assoc(db_query($sql));
$this->value = $row['value'];
}
else {
$this->value = $value;
}
}
public function save_setting() {
$sql = 'UPDATE forumsettings SET value = "'.$this->value.'" WHERE name = "'.$this->name.'"';
db_query($sql);
}
public function insert_setting() {
$sql = 'INSERT INTO
forumsettings (name, value)
VALUES ("'.$this->name.'", "'.$this->value.'")';
db_query($sql);
}
public function delete_setting() {
$sql = 'DELETE FROM forumsettings WHERE name = "'.$this->name.'"';
db_query($sql);
if(db_affected_rows()==0) {
return false;
}
else {
return true;
}
}
public function change_setting_value($newvalue) {
if($newvalue != '') {
$this->value = $newvalue;
return true;
}
else {
return false;
}
}
public function show_value() {
return $this->value;
}
}
function get_forum_settings($name='') {
$sql = 'SELECT * FROM forumsettings'.($name?' WHERE name = '.$name:' ORDER BY name ASC');
$res = db_query($sql);
if($name) {
$row = db_fetch_assoc($res);
return $row;
}
else {
return $res;
}
}
?>
|