forum category fout
Code (php)
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
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
<?php
}elseif(isset($_GET['cat'])) {
?>
<?php
$sql_c = mysql_query("SELECT * FROM forum_categorie WHERE categorie_id='".$_GET['cat']."'");
$row_c = mysql_fetch_assoc($sql_c);
?>
<tr>
<th colspan="2"><?php echo $row_c['titel']; ?></th>
</tr>
<tr>
<td colspan="2"><br /><a href='?p=forum'>forum</a> >> <a href='?p=forum&cat=<?php echo $_GET['cat']; ?>'><?php echo $row_c['titel']; ?></a><br /><br /></td>
<br/>
<center><table style="border:1px solid #000000;" width="800" cellpadding="0" cellspacing="0">
<td colspan="5" background="images/rood.png" width="800" height="24"><font color="white" size='1' face="verdana"><b>Vaste Topics</b></font></td>
</tr>
<?php
$sql = mysql_query("SELECT * FROM forum_berichten WHERE categorie='".$_GET['cat']."' AND sp='1'");
while($row = mysql_fetch_assoc($sql)) {
$sql_l = mysql_query("SELECT gebruikersnaam FROM leden WHERE member_id='".$row['member_id']."'");
$row_l = mysql_fetch_assoc($sql_l);
$sql_aantal_r = mysql_query("SELECT reactie_id FROM forum_reacties WHERE categorie_id='".$row['categorie']."' AND bericht_id='".$row['bericht_id']."'");
$aantal_r = mysql_num_rows($sql_aantal_r);
?>
<tr>
<td style="border-top:1px solid #000000;" width="5%">
<?php
echo'<img src="images/druk.png" border="0"></a> ';
?>
</td>
<td style="border-top:1px solid #000000;" height="25" width="50%"><a href='?p=forum&cat=<?php echo $_GET['cat']; ?>&b=<?php echo $row['bericht_id']; ?>'><b>vast: </b><?php echo $row['titel']; ?></a></td>
<td style="border-top:1px solid #000000;" width="30%">
Gepost: <strong><?php echo $row_l['gebruikersnaam']; ?></strong><br />
<strong><?php echo $aantal_r; ?></strong> Reacties</td>
</tr>
</table></center>
<br/><br/>
<center><table style="border:1px solid #000000;" width="800" cellpadding="0" cellspacing="0">
<td colspan="5" background="images/rood.png" width="800" height="24"><font color="white" size='1' face="verdana"><b>Topics</b></font></td>
<?php
$sql2 = mysql_query("SELECT * FROM forum_berichten WHERE categorie='".$_GET['cat']."' AND sp='0'");
$sql_c2 = mysql_query("SELECT * FROM forum_categorie WHERE categorie_id='".$_GET['cat']."'");
$row_c2 = mysql_fetch_assoc($sql_c2);
?>
<tr>
</tr>
<tr>
</tr>
<?php
}
?>
<?php
while($row2 = mysql_fetch_assoc($sql2)) {
$sql_l2 = mysql_query("SELECT gebruikersnaam FROM leden WHERE member_id='".$row2['member_id']."'");
$row_l2 = mysql_fetch_assoc($sql_l2);
$sql_aantal_r2 = mysql_query("SELECT reactie_id FROM forum_reacties WHERE categorie_id='".$row2['categorie']."' AND bericht_id='".$row2['bericht_id']."'");
$aantal_r2 = mysql_num_rows($sql_aantal_r2);
?>
<tr>
<td style="border-top:1px solid #000000;" width="5%">
<?php
if($row2['offline'] == 1){
echo'<img src="images/dicht.png" border="0"></a> ';
}
elseif($aantal_r2 > "4" ){
echo'<img src="images/druk.png" border="0"></a> ';
}else{
echo'<img src="images/open.png" border="0"></a> ';
}
?>
</td>
<td style="border-top:1px solid #000000;" height="25" width="50%"><a href='?p=forum&cat=<?php echo $_GET['cat']; ?>&b=<?php echo $row2['bericht_id']; ?>'><?php echo $row2['titel']; ?></a></td>
<td style="border-top:1px solid #000000;" width="30%">
Gepost: <strong><?php echo $row_l2['gebruikersnaam']; ?></strong><br />
<strong><?php echo $aantal_r2; ?></strong> Reacties</td>
</tr>
<?php
}
?>
</table></center>
<br/><br/>
<p align="right"><a href="?p=forum&cat=<?php echo $_GET['cat']; ?>&a=toevoegen"><img src="images/plaats_bericht.PNG" border="0"></a></p>
<?php
}else{
?>
}elseif(isset($_GET['cat'])) {
?>
<?php
$sql_c = mysql_query("SELECT * FROM forum_categorie WHERE categorie_id='".$_GET['cat']."'");
$row_c = mysql_fetch_assoc($sql_c);
?>
<tr>
<th colspan="2"><?php echo $row_c['titel']; ?></th>
</tr>
<tr>
<td colspan="2"><br /><a href='?p=forum'>forum</a> >> <a href='?p=forum&cat=<?php echo $_GET['cat']; ?>'><?php echo $row_c['titel']; ?></a><br /><br /></td>
<br/>
<center><table style="border:1px solid #000000;" width="800" cellpadding="0" cellspacing="0">
<td colspan="5" background="images/rood.png" width="800" height="24"><font color="white" size='1' face="verdana"><b>Vaste Topics</b></font></td>
</tr>
<?php
$sql = mysql_query("SELECT * FROM forum_berichten WHERE categorie='".$_GET['cat']."' AND sp='1'");
while($row = mysql_fetch_assoc($sql)) {
$sql_l = mysql_query("SELECT gebruikersnaam FROM leden WHERE member_id='".$row['member_id']."'");
$row_l = mysql_fetch_assoc($sql_l);
$sql_aantal_r = mysql_query("SELECT reactie_id FROM forum_reacties WHERE categorie_id='".$row['categorie']."' AND bericht_id='".$row['bericht_id']."'");
$aantal_r = mysql_num_rows($sql_aantal_r);
?>
<tr>
<td style="border-top:1px solid #000000;" width="5%">
<?php
echo'<img src="images/druk.png" border="0"></a> ';
?>
</td>
<td style="border-top:1px solid #000000;" height="25" width="50%"><a href='?p=forum&cat=<?php echo $_GET['cat']; ?>&b=<?php echo $row['bericht_id']; ?>'><b>vast: </b><?php echo $row['titel']; ?></a></td>
<td style="border-top:1px solid #000000;" width="30%">
Gepost: <strong><?php echo $row_l['gebruikersnaam']; ?></strong><br />
<strong><?php echo $aantal_r; ?></strong> Reacties</td>
</tr>
</table></center>
<br/><br/>
<center><table style="border:1px solid #000000;" width="800" cellpadding="0" cellspacing="0">
<td colspan="5" background="images/rood.png" width="800" height="24"><font color="white" size='1' face="verdana"><b>Topics</b></font></td>
<?php
$sql2 = mysql_query("SELECT * FROM forum_berichten WHERE categorie='".$_GET['cat']."' AND sp='0'");
$sql_c2 = mysql_query("SELECT * FROM forum_categorie WHERE categorie_id='".$_GET['cat']."'");
$row_c2 = mysql_fetch_assoc($sql_c2);
?>
<tr>
</tr>
<tr>
</tr>
<?php
}
?>
<?php
while($row2 = mysql_fetch_assoc($sql2)) {
$sql_l2 = mysql_query("SELECT gebruikersnaam FROM leden WHERE member_id='".$row2['member_id']."'");
$row_l2 = mysql_fetch_assoc($sql_l2);
$sql_aantal_r2 = mysql_query("SELECT reactie_id FROM forum_reacties WHERE categorie_id='".$row2['categorie']."' AND bericht_id='".$row2['bericht_id']."'");
$aantal_r2 = mysql_num_rows($sql_aantal_r2);
?>
<tr>
<td style="border-top:1px solid #000000;" width="5%">
<?php
if($row2['offline'] == 1){
echo'<img src="images/dicht.png" border="0"></a> ';
}
elseif($aantal_r2 > "4" ){
echo'<img src="images/druk.png" border="0"></a> ';
}else{
echo'<img src="images/open.png" border="0"></a> ';
}
?>
</td>
<td style="border-top:1px solid #000000;" height="25" width="50%"><a href='?p=forum&cat=<?php echo $_GET['cat']; ?>&b=<?php echo $row2['bericht_id']; ?>'><?php echo $row2['titel']; ?></a></td>
<td style="border-top:1px solid #000000;" width="30%">
Gepost: <strong><?php echo $row_l2['gebruikersnaam']; ?></strong><br />
<strong><?php echo $aantal_r2; ?></strong> Reacties</td>
</tr>
<?php
}
?>
</table></center>
<br/><br/>
<p align="right"><a href="?p=forum&cat=<?php echo $_GET['cat']; ?>&a=toevoegen"><img src="images/plaats_bericht.PNG" border="0"></a></p>
<?php
}else{
?>
als je op het forum kijkt heb ik 2 onder de categorie vast en 1 onder normaal maar als maar nu gebeut het het volgende er komt een met de kopje vaste topic en dan maakt hij en nieuwe aan onder het kopje topic en met de titel vast ervoor maar die moeten bij een onder het kopje vast en dan doet he normaal onder het kopje topic dat doet hij dan goed
ik hoop dat jullie het begrijpen
Gewijzigd op 01/01/1970 01:00:00 door Rick geenidee
Er zijn nog geen reacties op dit bericht.