phpBB.de

Code: Alles auswählen

                  <div id="cont">
					<table width="100%" border="0" cellspacing="0" cellpadding="0" class="login">
						  <?$query = "SELECT id FROM ".$tbl['user'].
									 " WHERE UNIX_TIMESTAMP(lastaction) > ".(time() - $skript['actiontime']);
							$sql = mysql_query($query);
						  ?>
						<?#aktuell online?>  
						<tr><td align="center" colspan="2"><b><?=mysql_num_rows($sql)?></b> User online</td></tr>
					<?if($_SESSION['s_status']) {?>
						<tr>
						  <td align="center" colspan="2"><br><a href="index.php?site=user_online">Wer ist online?</a></td>
						</tr>
					<?}?>
						<tr><td colspan="2"><hr style="border:1px dotted #cccccc;"></td></tr>
						<?$query = "SELECT id FROM ".$tbl['counter'];
						  $sql = mysql_query($query);
						?>
						<tr>
							<td style="text-align:left; padding-left:5px;">Gesamt
							<td style="text-align:right; padding-right:5px;font-weight:bold;">
								<?=mysql_num_rows($sql) + $skript['counteroffset']?>
							</td>
						</tr>
						<?$now = time();
						  $query = "SELECT id FROM ".$tbl['counter'].
								   " WHERE UNIX_TIMESTAMP(datum) > ".
										mktime(23,59,59,date("m",$now),date("d",$now)-1,date("Y",$now));
						  $sql = mysql_query($query);
						?>
						<tr>
							<td style="text-align:left; padding-left:5px;">Heute
							<td style="text-align:right; padding-right:5px;font-weight:bold;"><?=mysql_num_rows($sql)?></td>
						</tr>
						<?$query = "SELECT id FROM ".$tbl['counter'].
								   " WHERE UNIX_TIMESTAMP(datum) BETWEEN ".
										mktime(23,59,59,date("m",$now),date("d",$now)-2,date("Y",$now)).
								   " AND ".
										mktime(0,0,0,date("m",$now),date("d",$now),date("Y",$now));
						  $sql = mysql_query($query);
						?>
						<tr>
							<td style="text-align:left; padding-left:5px;">Gestern
							<td style="text-align:right; padding-right:5px;font-weight:bold;"><?=mysql_num_rows($sql)?></td>
						</tr>
				    </table>