|
De Polderster => Forum => <%=breadcrumb%> |
||||
|
<%
set rs = conn.execute("select count(*) as aantaltreads, sum(views) as aantalBekeken, sum(numberReplies) as replies from item")
response.Write(rs.fields("aantaltreads")&" treads werden "&rs.fields("aantalBekeken")& " maal gelezen ") response.write("Er werd in totaal "&rs.fields("replies")&" keer gereageerd") %> |
Gebruikers die de laatste 10 minuten actief waren: <% set rs = conn.execute("select username from users natural join logboek group by users.userid having TO_DAYS(NOW()) - TO_DAYS(max(tijdstip)) <=0 AND DATE_FORMAT( CURRENT_TIMESTAMP( ) , '%H%i' ) - DATE_FORMAT( max(tijdstip), '%H%i' ) <= 10") do while not rs.eof response.Write(rs.fields("username")) rs.movenext if not rs.eof then response.Write(", ") end if loop %> |
|||