@ 2014-06-29T21:35:49Z <?php
ini_set('display_errors', 'On');
error_reporting(E_ALL);
$time = microtime();
$time = explode(' ', $time);
$time = $time[1] + $time[0];
$start = $time;
session_start();
include 'connect.php';
// Connect to MySQLi
$sqli = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME) or die("Error: ".mysqli_error($sqli));
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
//NEWS
$limit = 1;
$headlinenewsquery = mysqli_query($sqli, "SELECT * FROM news ORDER BY timestamp DESC LIMIT 0, 1") or die("Error: ".mysqli_error($sqli));
$newsquery = mysqli_query($sqli, "SELECT * FROM news ORDER BY timestamp DESC LIMIT 1, 2") or die("Error: ".mysqli_error($sqli));
$headlinenews = array();
while ($row = mysqli_fetch_array($headlinenewsquery))
{
$uid = $row['userid'];
$userquery = mysqli_query($sqli, "SELECT * FROM members WHERE id='$uid'") or die("Error: ".mysqli_error($sqli));
$userexists = mysqli_num_rows($userquery);
if ($userexists == 0)
{
$username = "<deleted user>";
}
else
{
$userrow = mysqli_fetch_assoc($userquery);
$username = $userrow['username'];
}
$headlinenews[] = array(
"id" => $row['id'],
"headline" => $row['headline'],
"story" => $row['story'],
"timestamp" => $row['timestamp'],
"userid" => $row['userid'],
"username" => $username
);
}
$news = array();
while ($row = mysqli_fetch_array($newsquery))
{
$uid = $row['userid'];
$userquery = mysqli_query($sqli, "SELECT * FROM members WHERE id='$uid'") or die("Error: ".mysqli_error($sqli));
$userexists = mysqli_num_rows($userquery);
if ($userexists == 0)
{
$username = "<deleted user>";
}
else
{
$userrow = mysqli_fetch_assoc($userquery);
$username = $userrow['username'];
}
$secondarynews[] = array(
"id" => $row['id'],
"headline" => $row['headline'],
"story" => $row['story'],
"timestamp" => $row['timestamp'],
"userid" => $row['userid'],
"username" => $username
);
}
//FORUMS
$limit = 5;
$forumquery = mysqli_query($sqli, "SELECT * FROM forumtopics ORDER BY lastpost DESC LIMIT 0, $limit") or die("Error: ".mysqli_error($sqli));
$forumposts = array();
while ($row = mysqli_fetch_array($forumquery))
{
$uid = $row['lastpostuserid'];
$userquery = mysqli_query($sqli, "SELECT * FROM members WHERE id='$uid'") or die("Error: ".mysqli_error($sqli));
$userexists = mysqli_num_rows($userquery);
if ($userexists == 0)
{
$username = "<deleted user>";
}
else
{
$userrow = mysqli_fetch_assoc($userquery);
$username = $userrow['username'];
}
$forumposts[] = array(
"id" => $row['id'],
"threadname" => $row['threadname'],
"text" => $row['text'],
"lastpost" => $row['lastpost'],
"userid" => $row['userid'],
"username" => $username
);
}
//EVENT
$limit = 1;
$eventquery = mysqli_query($sqli, "SELECT * FROM events ORDER BY id DESC LIMIT 0, $limit") or die("Error: ".mysqli_error($sqli));
$events = array();
while ($row = mysqli_fetch_array($forumquery))
{
$events[] = array(
"id" => $row['id'],
"name" => $row['name'],
"timestamp" => $row['timestamp']
);
}
//TOPINFOTEXT
$textquery = mysqli_query($sqli, "SELECT * FROM toptext ORDER BY id") or die("Error: ".mysqli_error($sqli));
$textresult = mysqli_fetch_assoc($textquery);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
<title>indiehjaerta.com ♥</title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<!-- Font's -->
<link href='http://fonts.googleapis.com/css?family=Oswald:400,300' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Open+Sans:300italic,300,400' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Roboto:300,300italic' rel='stylesheet' type='text/css'>
<link href="stylesheet/style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<script type="text/javascript">
$(function() {
$('#TopBarLogin').click(function() {
$('#LoginPopUp').show();
return false;
});
});
</script>
<script type="text/javascript">
$(document).mouseup(function (e)
{
var container = $("#LoginPopUp");
if (!container.is(e.target) && container.has(e.target).length === 0)
{
container.hide();
}
});
</script>
<script type="text/javascript">
$(function() {
if (navigator.userAgent.toLowerCase().indexOf("chrome") >= 0) {
var intervalId = 0;
$(window).load(function() {
intervalId = setInterval(function () { // << somehow this does the trick!
if ($('input:-webkit-autofill').length > 0) {
clearInterval(intervalId);
$('input:-webkit-autofill').each(function () {
var text = $(this).val();
var name = $(this).attr('name');
$(this).after(this.outerHTML).remove();
$('input[name=' + name + ']').val(text);
});
}
}, 1);
});
}
});
</script>
<div id="TopBarImageContainer">
<div id="TopBarImage"></div>
</div>
<div id="MainContent">
<a href="#">
<span class="DivLink">
<div id="TopBarLogin">
<span class="TopBarText">LOGIN
<div id="TopBarTriangleDown"></div>
</span>
</div>
</span>
</a>
<a href="register.php">
<span class="DivLink">
<div id="TopBarCreateAccount">
<span class="TopBarText">CREATE AN ACCOUNT</span>
</div>
</span>
</a>
<div id="TopBarUserMenu">
<div id="TopBarUserMenuProfile">
<a href="profile.php">
<span class="TopBarText">
<div id="TopBarUserMenuProfileImage"></div>
<span class="DivLink">
PROFILE
</span>
</span>
</a>
</div>
<div id="TopBarUserMenuMessages">
<a href="messages.php">
<span class="TopBarText">
<div id="TopBarUserMenuMessagesImage"></div>
<span class="DivLink">
MESSAGES
</span>
</span>
</a>
</div>
<div id="TopBarUserMenuSupport">
<a href="support.php">
<span class="TopBarText">
<div id="TopBarUserMenuSupportImage"></div>
<span class="DivLink">
SUPPORT
</span>
</span>
</a>
</div>
</div>
<div id="LoginPopUp">
<form method="post" action="">
<input name="username" type="text" id="username" placeholder="Username" style="display: none" />
<input name="password" type="password" id="password" placeholder="Password" style="display: none" />
<input class="LoginInput" name="username" type="text" id="username" placeholder="Username" /><br />
<input class="LoginInput" name="password" type="password" id="password" placeholder="Password" /><br />
<input class="LoginButton" type="submit" name="login" value="">
</form>
</div>
<div id="LogoMenu">
<div id="SocialTopLinks">
<div id="SocialTopTwitterLink">
<a href="http://www.twitter.com/indiehjaerta">
<span class="DivLink"></span>
</a>
</div>
<div id="SocialTopFacebookLink">
<a href="http://www.facebook.com/indiehjaerta">
<span class="DivLink"></span>
</a>
</div>
<div id="SocialTopYouTubeLink">
<a href="https://www.youtube.com/indiehjaerta">
<span class="DivLink"></span>
</a>
</div>
<div id="SocialTopInstagramLink">
<a href="http://www.instagram.com/indiehjaerta">
<span class="DivLink"></span>
</a>
</div>
<div id="SocialTopTwitchLink">
<a href="http://www.twitch.tv/indiehjaerta">
<span class="DivLink"></span>
</a>
</div>
</div>
<div id="TopLogo">
<a href="#"><span class="DivLink"></span></a>
</div>
<div id="MenuLinkSeparator"></div>
<div id="MenuLinks">
<a href="" class="Menu">HOME</a>
<a href="news.php" class="Menu">ABOUT</a>
<a href="blog.php" class="Menu">BLOG</a>
<a href="events.php" class="Menu">EVENTS</a>
<a href="forums.php" class="Menu">FORUMS</a>
<a href="" class="Menu">CONTACT</a>
</div>
</div>
<div id="Container">
<div id="InfoHeader">
<span class="TopInfoText"><?php echo $textresult['text']?></span>
</div>
<div id="Content">
<div id="NewsHeadline">
<?php
foreach ($headlinenews as $news)
{
?>
<span class="NewsTopNewsHeadline">
<?php echo strtoupper($news['headline'])?>
</span>
<br />
<span class="NewsTopNewsInfo">
written by <?php echo $news['username']?> on <?php echo $news['timestamp']?>
</span>
<br />
<div id="NewsHeadlineText">
<span class="NewsText">
<?php echo $news['story']?>
</span>
</div>
<div class="NewsButtonContainer">
<img src="images/buttoncomments.png" class="ButtonComment"/>
</div>
<?php
}
?>
</div>
<img src="images/newsseparator-horizontal.png" id="NewsSeparatorHorizontal" />
<div id="NewsSecondaryContainer">
<?php
$counter = 0;
foreach ($secondarynews as $news)
{
$counter++;
?>
<div class="NewsSecondaryNews">
<span class="NewsSecondaryNewsHeadline">
<?php echo $news['headline'] ?>
</span>
<br />
<span class="NewsSecondaryNewsInfo">
written by <?php echo $news['username']?> on <?php echo $news['timestamp']?>
</span>
<br />
<div id="NewsSecondaryText">
<span class="NewsText">
<?php echo $news['story']?>
</span>
</div>
<div class="NewsButtonContainer">
<img src="images/buttoncomments.png" class="ButtonComment"/>
</div>
</div>
<?php
if ($counter == 1)
{
?>
<img src="images/newsseparator-vertical.png" id="NewsSeparatorVertical" />
<?php
}
}
?>
</div>
</div>
<div id="NewsLetterBanner">
</div>
<div id="SiteInfoContainer">
<div id="ForumPostsContainer">
<img src="images/icon-forum-large.png" class="ForumPostsIcon" />
<span class="ForumPostsText">FORUM POSTS</span><br />
<?php
$counter = 0;
foreach ($forumposts as $posts)
{
$counter++;
?>
<div class="ForumPostContainer">
<a href="" class="FrontpageForumLink"><?php echo $posts['threadname'] ?></a>
<span class="ForumPostInfo">posted by <?php echo $posts['username'] ?> at 7:38PM on June 1, 2014</span>
</div>
<?php
if ($counter != 5)
{
?>
<img src="images/forumpostsseparator.png" class="ForumPostsSeparator" />
<?php
}
}
?>
</div>
<img src="images/shortseparator2.png" class="ShortSeparator" />
<div id="EventContainer">
<img src="images/icon-calendar-large.png" class="EventsIcon" />
<span class="ForumPostsText">UPCOMING EVENT</span><br />
<?php
foreach ($events as $event)
{
$dateandtime = getdate($event['timestamp']);
echo $dateandtime['year'] '.' $dateandtime['mon'] '.' $dateandtime['mday'];
echo $event['name'];
}
?>
</div>
</div>
</div>
<div id="Bot">
<div class="BotLinkDiv">
<span class="BotLinkHeadline">LINK-TEXTS</span><br />
<a href="" class="BotLinkText">LINK1</a><br />
<a href="" class="BotLinkText">LINK2</a><br />
<a href="" class="BotLinkText">LINK3</a><br />
<a href="" class="BotLinkText">LINK4</a><br />
<a href="" class="BotLinkText">LINK5</a><br />
<a href="" class="BotLinkText">LINK6</a><br />
</div>
<div class="BotLinkDiv">
<span class="BotLinkHeadline">LINK-TEXTS</span><br />
<a href="" class="BotLinkText">LINK1</a><br />
<a href="" class="BotLinkText">LINK2</a><br />
<a href="" class="BotLinkText">LINK3</a><br />
<a href="" class="BotLinkText">LINK4</a><br />
<a href="" class="BotLinkText">LINK5</a><br />
<a href="" class="BotLinkText">LINK6</a><br />
</div>
<div class="BotLinkDiv">
<span class="BotLinkHeadline">ACCOUNT</span><br />
<a href="" class="BotLinkText">LOGIN</a><br />
<a href="" class="BotLinkText">CREATE ACCOUNT</a><br />
<a href="" class="BotLinkText">FORGOT PASSWORD</a><br />
<a href="" class="BotLinkText">PROFILE</a><br />
</div>
<div class="BotLinkDiv">
<span class="BotLinkTextJoin">NOT A MEMBER?</span>
<a href=""><img src="images/buttonjoinnow.png" clas="BotButtonJoinNow" /></a>
</div>
<div class="BotLinkDiv">
<span class="BotLinkHeadline">SOCIAL</span><br />
<a href="http://www.twitch.tv/indiehjaerta" class="BotLinkText">TWITCH</a><br />
<a href="http://www.facebook.com/indiehjaerta" class="BotLinkText">FACEBOOK</a><br />
<a href="http://www.twitter.com/indiehjaerta" class="BotLinkText">TWITTER</a><br />
<a href="http://www.youtube.com/indiehjaerta" class="BotLinkText">YOUTUBE</a><br />
<a href="http://www.instagram.com/indiehjaerta" class="BotLinkText">INSTAGRAM</a><br />
</div>
<div class="BotLinkDiv">
<span class="BotLinkHeadline">SUPPORT</span><br />
<a href="" class="BotLinkText">LINK1</a><br /><!-- CONTACT FORM -->
<a href="" class="BotLinkText">LINK2</a><br /><!-- TWITCH MESSAGE -->
<a href="" class="BotLinkText">LINK3</a><br /><!-- F.A.Q. -->
<a href="" class="BotLinkText">LINK4</a><br /><!-- SUPPORT FORUMS -->
<a href="" class="BotLinkText">LINK5</a><br />
<a href="" class="BotLinkText">LINK6</a><br />
</div>
<div id="BotLogo">
<a href="#"><span class="DivLink"></span></a>
</div>
<?php
$time = microtime();
$time = explode(' ', $time);
$time = $time[1] + $time[0];
$finish = $time;
$total_time = round(($finish - $start), 4);
?>
<span class="BotLogoText">Page generated in <?php echo $total_time ?> seconds.</span>
</div>
</div>
</body>
</html>
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).
Version System time (s) User time (s) Memory (MiB) 5.4.30 0.008 0.057 12.57 5.4.29 0.013 0.068 12.57 5.4.28 0.009 0.065 12.46 5.4.27 0.008 0.054 12.46 5.4.26 0.005 0.044 12.46 5.4.25 0.009 0.039 12.46 5.4.24 0.008 0.040 12.46 5.4.23 0.009 0.044 12.45 5.4.22 0.010 0.064 12.45 5.4.21 0.009 0.068 12.45 5.4.20 0.014 0.048 12.45 5.4.19 0.003 0.058 12.45 5.4.18 0.011 0.120 12.45 5.4.17 0.007 0.070 12.46 5.4.16 0.005 0.052 12.45 5.4.15 0.007 0.050 12.45 5.4.14 0.010 0.050 12.14 5.4.13 0.006 0.043 12.12 5.4.12 0.009 0.050 12.08 5.4.11 0.014 0.078 12.08 5.4.10 0.011 0.045 12.09 5.4.9 0.017 0.076 12.08 5.4.8 0.011 0.044 12.08 5.4.7 0.008 0.044 12.07 5.4.6 0.013 0.086 12.07 5.4.5 0.011 0.056 12.08 5.4.4 0.010 0.040 12.07 5.4.3 0.007 0.059 12.06 5.4.2 0.008 0.049 12.05 5.4.1 0.005 0.044 12.06 5.4.0 0.006 0.056 11.55 5.3.28 0.004 0.047 12.71 5.3.27 0.007 0.045 12.72 5.3.26 0.010 0.054 12.72 5.3.25 0.011 0.043 12.72 5.3.24 0.007 0.045 12.72 5.3.23 0.005 0.047 12.70 5.3.22 0.009 0.041 12.68 5.3.21 0.008 0.045 12.68 5.3.20 0.013 0.050 12.68 5.3.19 0.007 0.040 12.68 5.3.18 0.007 0.047 12.68 5.3.17 0.006 0.065 12.67 5.3.16 0.007 0.058 12.68 5.3.15 0.008 0.057 12.68 5.3.14 0.010 0.051 12.66 5.3.13 0.007 0.047 12.66 5.3.12 0.007 0.041 12.66 5.3.11 0.009 0.040 12.66 5.3.10 0.009 0.052 12.14 5.3.9 0.013 0.050 12.13 5.3.8 0.008 0.041 12.11 5.3.7 0.009 0.038 12.11 5.3.6 0.004 0.039 12.10 5.3.5 0.005 0.040 12.04 5.3.4 0.003 0.042 12.05 5.3.3 0.013 0.049 12.01 5.3.2 0.006 0.055 11.79 5.3.1 0.014 0.071 11.75 5.3.0 0.006 0.039 11.74
preferences:dark mode live preview
166.24 ms | 1394 KiB | 7 Q