Forummet
Hvis man har problemer, er det jo altid rart at have et sted, hvor man kan få hjælp.
Her i HTMLkoder.dk's forum, kan du få hjælp af alle de andre brugere. Vi bruger point som handelsvare. Det gør, at alle bidrager til fællesskabet og at der ikke er nogen der "nasser" på andres viden.
|
if($cat != "")
{
$catnameSQL = mysql_query("SELECT * FROM forum_kategorier WHERE ID='$cat'");
$catnameROW = mysql_fetch_array($catnameSQL);
$catID = $catnameROW['ID'];
$catname = $catnameROW['navn'];
$catdescription = $catnameROW['beskrivelse'];
?>
Forum » =$catname;?>
=$catdescription;?>
Spørgsmål / tråde
|

|
| |
Overskrift |
Seneste aktivitet: |
Points: |
#: |
$threadsSQL = mysql_query("SELECT * FROM forum_threads WHERE cat='$cat' AND slettet='' ORDER BY ID DESC");
while($threadsROW = mysql_fetch_array($threadsSQL))
{
if(mysql_num_rows(mysql_query("SELECT * FROM forum_posts WHERE thread='$threadsROW[ID]'")) == "0")
{
$flag_color = "green"; $flag_text = "Ubesvaret";
}
elseif(mysql_num_rows(mysql_query("SELECT * FROM forum_posts WHERE thread='$threadsROW[ID]' AND svar = '1'")) != "0")
{
$flag_color = "blue"; $flag_text = "Besvaret med accepteret svar";
}
else
{
$flag_color = "yellow"; $flag_text = "Besvaret uden accepteret svar";
}
$time = time();
$last_sql = mysql_query("SELECT * FROM forum_posts WHERE thread='$threadsROW[ID]' ORDER BY ID DESC LIMIT 1");
while($lastROW = mysql_fetch_array($last_sql))
{
$today = date("d-m-Y");
$yesterday = date("d-m-Y",time()-86400);
if(date("d-m-Y", $lastROW['time']) == $today) $day = "I dag";
elseif(date("d-m-Y", $lastROW['time']) == $yesterday) $day = "I går";
else $day = date("d-m-Y", $lastROW['time']);
$printdate = $day . ", " . date("H:i",$lastROW['time']);
}
if(mysql_num_rows($last_sql) == "0")
{
$today = date("d-m-Y");
$yesterday = date("d-m-Y",time()-86400);
if(date("d-m-Y", $threadsROW['time']) == $today) $day = "I dag";
elseif(date("d-m-Y", $threadsROW['time']) == $yesterday) $day = "I går";
else $day = date("d-m-Y", $threadsROW['time']);
$printdate = $day . ", " . date("H:i",$threadsROW['time']);
}
?>
 |
=$threadsROW['overskrift'];?> |
=$printdate;?> |
=$threadsROW['point'];?> |
=mysql_num_rows(mysql_query("SELECT * FROM forum_posts WHERE thread='$threadsROW[ID]'"));?> |
}
if(mysql_num_rows($threadsSQL) == "0")
{
?>Ingen tråde oprettet endnu |
}
?>
Kategorier
$count = "0";
$overcatsSQL = mysql_query("SELECT * FROM forum_kategorier WHERE overID='' AND aktiv='1' ORDER BY ID ASC");
$tdwidth = round(100/mysql_num_rows($overcatsSQL)*2);
while($overcatsROW = mysql_fetch_array($overcatsSQL))
{ $count++; $overID = $overcatsROW['ID'];
?>
=$overcatsROW['navn'];?>
$undercatsSQL = mysql_query("SELECT * FROM forum_kategorier WHERE overID='$overID' AND aktiv='1' ORDER BY navn ASC");
while($undercatsROW = mysql_fetch_array($undercatsSQL))
{
if($cat == $undercatsROW[ID])
{
?>
- =$undercatsROW['navn'];?>
}
else
{
?>
- =$undercatsROW['navn'];?>
}
}
?>
|
if($count == "3")
{
echo " ";
}
}
?>
|
|
Signaturforklaring
 | Ubesvaret |
 | Besvaret med accepteret svar |
 | Besvaret uden accepteret svar |
|
}
else
{
?>
Forum
Kategorier
$count = "0";
$overcatsSQL = mysql_query("SELECT * FROM forum_kategorier WHERE overID='' AND aktiv='1' ORDER BY ID ASC");
$tdwidth = round(100/mysql_num_rows($overcatsSQL)*2);
while($overcatsROW = mysql_fetch_array($overcatsSQL))
{ $count++; $overID = $overcatsROW['ID'];
?>
=$overcatsROW['navn'];?>
$undercatsSQL = mysql_query("SELECT * FROM forum_kategorier WHERE overID='$overID' AND aktiv='1' ORDER BY navn ASC");
while($undercatsROW = mysql_fetch_array($undercatsSQL))
{
?>
- =$undercatsROW['navn'];?>
}
?>
|
if($count == "3")
{
echo " ";
}
}
?>
|
|
Signaturforklaring
 | Ubesvaret |
 | Besvaret med accepteret svar |
 | Besvaret uden accepteret svar |
|
Seneste spørgsmål / tråde
| |
Overskrift |
Points: |
Kategori: |
#: |
$threadsSQL = mysql_query("SELECT * FROM forum_threads WHERE slettet='' ORDER BY ID DESC");
while($threadsROW = mysql_fetch_array($threadsSQL))
{
$catnameSQL = mysql_query("SELECT * FROM forum_kategorier WHERE ID='$threadsROW[cat]'");
$catnameROW = mysql_fetch_array($catnameSQL);
$catID = $catnameROW['ID'];
$catname = $catnameROW['navn'];
$catdescription = $catnameROW['beskrivelse'];
if(mysql_num_rows(mysql_query("SELECT * FROM forum_posts WHERE thread='$threadsROW[ID]'")) == "0")
{
$flag_color = "green"; $flag_text = "Ubesvaret";
}
elseif(mysql_num_rows(mysql_query("SELECT * FROM forum_posts WHERE thread='$threadsROW[ID]' AND svar = '1'")) != "0")
{
$flag_color = "blue"; $flag_text = "Besvaret med accepteret svar";
}
else
{
$flag_color = "yellow"; $flag_text = "Besvaret uden accepteret svar";
}
?>
 |
=$threadsROW['overskrift'];?> |
=$threadsROW['point'];?> |
=$catname;?> |
=mysql_num_rows(mysql_query("SELECT * FROM forum_posts WHERE thread='$threadsROW[ID]'"));?> |
}
?>
}
/*
?>
*/
?>
|