// includes/login.inc

<?php
$sql = "select thread.nr, thread.title, s1.cpost, s1,mdate, user.name from thread 
	   inner join (select thread, count(post) as cpost, max(date) as mdate from post group by thread) s1 on thread.nr = s1.thread
	   inner join (select thread, user, date from post) s2 on s1.thread = s2.thread and s1.mdate=s2.date
	   inner join user on s2.user = user.id";
ask(2);
$ret = '[';
$a = array();
$keys = array('i:','t:','c:','r:','n:');
while( $row = $res->fetch_row() ){
	$a[] = $row;
}
foreach( $a as $b ){
	$ret .= '{';
	for($i=0; $i<5; $i++ ){
		$ret .= $keys[$i] .'"'. $b[$i] .'",';
	}
	$ret[ strlen($ret) - 1 ] = '},';
}
$ret[ strlen($ret) - 1 ] = ']';
?>

// js/login.js

sd.login = {
	session : null,
	
	init : function(){
		var n = Math.round(Math.random()*16) + 16;
		sd.login.session = new Uint8Array(n);
		var i = 0, b, c, s = "";
		while( i < n ){
			 b = Math.floor(Math.random()*90) + 35;
			 c = String.fromCharCode(b);
			 if( c == "\'" || c == "\"" ) continue;
			 sd.login.session[i] = b;
			 s += c;
			 i++;
		};
		sd.post(sd.pass + s, sd.login.setup);
	},
	
	setup : function(str){
		var div = documentGetElementById('thread');
		var a = JSON.parse(str);
		var	btn = document.createElement('span');
		var t = documentCreateTextNode('ansehen');
			btn.appendChild(t);
			btn.class = 'btn';
		for(var i=0; i<themes.length; i++){
			var p = document.createElement('p');
			p.class = "thema";
			p.setAttribute('nr', a[i].i);
			var s = document.createElement('p');
			t = documentCreateTextNode( a[i].c * " Beiträge, der letzte am " + a[i].r + " von " + a[i].n );
			s.appendChild(t);
			p.appendChild(s);
			t = documentCreateTextNode( a[i].t );
			p.appendChild(t);
			p.appendChild(btn);
			div.appendChild(p);
		}
	}
}