og her er min kode for lige at få et indblik i hvordan den fungerer :)
<?
require('req/functions.php');
$table = 'debate_'.$_GET['topic'];
$limit2 = 10;
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
</head>
<body onload="parent.write_to_div('div_debate_overview', document.getElementById('overview').innerHTML); parent.write_to_div('div_debate_threads', document.getElementById('threads').innerHTML)">
<div id="overview">
<?
$sql = "SELECT debate.id, IFNULL(MAX(debate2.time), debate.time) AS last_time
FROM $DB.$table debate
LEFT JOIN $DB.$table debate2 ON debate.id=debate2.thread_id && debate2.reply_id!=0
WHERE debate.reply_id=0
GROUP BY debate.thread_id
ORDER BY last_time DESC";
$list_arr = view_list($sql, $_GET['limit'], $limit2);
echo page_overview($list_arr['num_page'], $list_arr['cur_page'], $limit2, 'iframe_debate_threads', 'iframe.debate_threads.php', 'parent.write_to_div(\'div_debate_threads\', initHTML[\'div_debate_threads\'])', 'topic');
?>
</div>
<div id="threads">
<?
function thread($reply_id, $table)
{
global $DB, $NO_USER, $threads;
$i = 1;
$sql = "SELECT debate.id, debate.subject, debate.user_id, debate.time, COUNT(debate2.reply_id) AS replies, user.name
FROM ($DB.$table debate LEFT JOIN $DB.user user ON debate.user_id=user.id)
LEFT JOIN $DB.$table debate2 ON debate.id=debate2.reply_id
WHERE debate.reply_id=$reply_id
GROUP BY debate.id
ORDER BY debate.time DESC";
$get = mysql_query($sql);
$num = mysql_num_rows($get);
while($row = mysql_fetch_array($get))
{
if(!$row['name']) $name = $NO_USER;
else $name = sql2txt($row['name'], 0);
?>
<table>
<tr valign="top">
<?
if($row['replies'])
{
if($num == $i) echo '<td><a href="java script:thread_expand('.$row['id'].')"><img id="img'.$row['id'].'" src="gfx/obj.debate_thread_closed.gif"></a>';
else echo '<td style="background:url(\'gfx/obj.debate_thread_bg.gif\')"><a href="java script:thread_expand('.$row['id'].')"><img id="img'.$row['id'].'" src="gfx/obj.debate_thread_closed.gif"></a>';
$threads .= ','.$row['id'];
}
else
{
if($num == $i) echo '<td><img src="gfx/obj.debate_thread_end.gif">';
else echo '<td style="background:url(\'gfx/obj.debate_thread_bg.gif\')"><img src="gfx/obj.debate_thread.gif">';
}
?>
</td>
<td>
<table>
<tr valign="top">
<td id="td<?=$row['id']?>"><img src="gfx/obj.debate_thread_msg.gif"></td>
<td style="padding-bottom:6px">
<a href="iframe.debate_contribution.php?topic=<?=$_GET['topic']?>&thread=<?=$row['id']?>" target="iframe_debate_contribution" onclick="document.getElementById('div_debate_contribution').style.display = 'block'; write_to_div('div_debate_contribution', initHTML['div_debate_contribution'])" class="marked thread"><?=sql2txt($row['subject'], 0)?></a><br>
<?=time2date($row['time'], 1, 1)?> - <?=$name?></td>
</tr>
</table>
</td>
</tr>
<tr>
<?
if($num != $i) echo '<td style="background:url(\'gfx/obj.debate_thread_bg.gif\')">';
else echo '<td>';
?>
</td>
<td colspan="2">
<div id="div<?=$row['id']?>" style="display:none">
<?
thread($row['id'], $table);
?>
</div>
</td>
</tr>
</table>
<?
$i++;
}
}
if($list_arr['rows'])
{
foreach($list_arr['rows'] as $value)
{
$sql = "SELECT debate.subject, debate.user_id, debate.time, user.name
FROM $DB.$table debate
LEFT JOIN $DB.user user ON debate.user_id=user.id
WHERE debate.id=$value";
$get = mysql_query($sql);
$row = mysql_fetch_array($get);
if(!$row['name']) $name = $NO_USER;
else $name = sql2txt($row['name'], 0);
$get2 = mysql_query("SELECT COUNT(id) FROM $DB.$table WHERE thread_id=$value");
$row2 = mysql_fetch_array($get2);
$replies = $row2[0] - 1;
$get3 = mysql_query("SELECT id, time FROM $DB.$table WHERE thread_id=$value ORDER BY time DESC LIMIT 1");
$last_thread = mysql_fetch_array($get3);
?>
<table>
<tr valign="top">
<td style="background:url('gfx/obj.debate_thread_bg.gif');">
<?
if($replies)
{
echo '<a href="java script:thread_expand('.$value.')"><img id="img'.$value.'" src="gfx/obj.debate_thread_closed.gif"></a>';
$threads = $value;
}
else echo '<img src="gfx/obj.debate_thread.gif">';
?>
</td>
<td>
<table>
<tr valign="top">
<td id="td<?=$value?>"><img src="gfx/obj.debate_thread_msg.gif"></td>
<td style="padding-bottom:6px"><a href="iframe.debate_contribution.php?topic=<?=$_GET['topic']?>&thread=<?=$value?>" target="iframe_debate_contribution" onclick="document.getElementById('div_debate_contribution').style.display = 'block'; write_to_div('div_debate_contribution', initHTML['div_debate_contribution'])" class="marked thread"><?=sql2txt($row['subject'], 0)?></a><br>
<?=time2date($row['time'], 1, 1)?> - <?=$name?><br>
<?
if($replies)
{
?>
<a href="java script:threads(<?=$value?>, 1)">Åbn</a> | <a href="java script:threads(<?=$value?>, 0)">Luk</a> - <?=$replies?> indlæg<br>
Seneste indlæg: <a href="iframe.debate_contribution.php?topic=<?=$_GET['topic']?>&thread=<?=$last_thread['id']?>" target="iframe_debate_contribution" onclick="document.getElementById('div_debate_contribution').style.display = 'block'; write_to_div('div_debate_contribution', initHTML['div_debate_contribution'])" class="thread"><?=time2date($last_thread['time'], 1, 1)?></a>
<?
}
?>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="background:url('gfx/obj.debate_thread_bg.gif')"></td>
<td colspan="2">
<div id="div<?=$value?>" style="display:none">
<?
thread($value, $table);
?>
</div>
</td>
</tr>
</table>
<?
if($threads)
{
if(count(explode(',', $threads)) > 1) echo '<script type="text/javascript">parent.thread_arr['.$value.'] = new Array('.$threads.');</script>';
else echo '<script type="text/javascript">parent.thread_arr['.$value.'] = new Array(); parent.thread_arr['.$value.'][parent.thread_arr['.$value.'].length] = '.$threads.';</script>';
}
unset($threads);
$i++;
}
}
else echo 'Ingen tråde...';
?>
</div>
</body>
</html>
<?
php_end(0);
?>
