@ 2014-07-01T13:52: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';
function ord($a) {
// return English ordinal number
return $a.substr(date('jS', mktime(0,0,0,1,($a%10==0?9:($a%100>20?$a%10:$a%100)),2000)),-2);
}
// 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();
$counter = 0;
while ($row = mysqli_fetch_array($eventquery))
{
$events[] = array(
"id" => $row['id'],
"name" => $row['name'],
"timestamp" => $row['timestamp'],
"picturethumbnail" => $row['picturethumbnail']
);
}
//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/separator-horizontal-long.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/separator-vertical-long.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++;
$dateandtime = getdate(strtotime($posts['lastpost']));
$min = $dateandtime['minutes'];
$hr = $dateandtime['hours'];
$d = $dateandtime['mday'];
$m = $dateandtime['mon'];
$y = $dateandtime['year'];
$hr = str_pad($hr, 2, '0', STR_PAD_LEFT);
$min = str_pad($min, 2, '0', STR_PAD_LEFT);
$monthName = date("F", mktime(0, 0, 0, $m, 10));
?>
<div class="ForumPostContainer">
<a href="" class="FrontpageForumLink"><?php echo $posts['threadname'] ?></a>
<span class="ForumPostInfo">
<?php
echo 'posted by ' .$posts['username']. ' at ' .$hr. ':' .$min. ' on ' .$monthName. ' ' .ord($a). ', ' .$y;
?>
</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(strtotime($event['timestamp']));
$d = $dateandtime['mday'];
$m = $dateandtime['mon'];
$y = $dateandtime['year'];
echo '<span class="EventDate">'.$y.'.'.$m.'.'.$d.'</span>';
echo '<span class="EventTitle">' .strtoupper($event['name']). '</span>';
if (strlen($event['picturethumbnail']) > 4)
{
echo '<img src="images/' .$event['picturethumbnail']. '" class="EventThumbnail" />';
}
echo '<img src="images/buttonreadmoreevent.png" class="ButtonReadMoreEvent" />';
}
?>
</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.5.14 0.103 0.063 20.29 5.5.13 0.110 0.053 20.30 5.5.12 0.113 0.047 20.28 5.5.11 0.110 0.053 20.13 5.5.10 0.113 0.060 20.17 5.5.9 0.117 0.043 20.04 5.5.8 0.093 0.057 20.02 5.5.7 0.120 0.060 20.17 5.5.6 0.110 0.053 20.06 5.5.5 0.100 0.063 20.18 5.5.4 0.113 0.070 20.01 5.5.3 0.123 0.050 20.16 5.5.2 0.123 0.060 20.14 5.5.1 0.120 0.047 20.15 5.5.0 0.113 0.080 20.04 5.4.30 0.107 0.057 18.84 5.4.29 0.107 0.053 19.29 5.4.28 0.107 0.060 18.93 5.4.27 0.103 0.057 19.18 5.4.26 0.103 0.053 19.19 5.4.25 0.133 0.077 18.95 5.4.24 0.097 0.077 19.02 5.4.23 0.113 0.057 18.86 5.4.22 0.100 0.063 19.18 5.4.21 0.103 0.080 19.16 5.4.20 0.113 0.043 19.23 5.4.19 0.113 0.050 19.25 5.4.18 0.100 0.057 19.18 5.4.17 0.097 0.057 19.15 5.4.16 0.120 0.073 19.16 5.4.15 0.097 0.053 19.13 5.4.14 0.093 0.053 16.45 5.4.13 0.143 0.063 16.50 5.4.12 0.123 0.057 16.34 5.4.11 0.137 0.057 16.53 5.4.10 0.103 0.043 16.40 5.4.9 0.027 0.060 16.55 5.4.8 0.143 0.060 16.41 5.4.7 0.130 0.047 16.55 5.4.6 0.103 0.070 16.36 5.4.5 0.100 0.047 16.50 5.4.4 0.100 0.053 16.43 5.4.3 0.110 0.053 16.50 5.4.2 0.093 0.057 16.39 5.4.1 0.107 0.067 16.24 5.4.0 0.127 0.043 15.88 5.3.28 0.130 0.060 14.70 5.3.27 0.113 0.060 14.71 5.3.26 0.107 0.063 14.59 5.3.25 0.123 0.060 14.64 5.3.24 0.073 0.057 14.53 5.3.23 0.117 0.057 14.71 5.3.22 0.120 0.043 14.55 5.3.21 0.110 0.057 14.69 5.3.20 0.117 0.080 14.44 5.3.19 0.020 0.043 14.70 5.3.18 0.127 0.057 14.58 5.3.17 0.107 0.053 14.43 5.3.16 0.107 0.053 14.68 5.3.15 0.100 0.067 14.56 5.3.14 0.100 0.063 14.55 5.3.13 0.100 0.057 14.55 5.3.12 0.117 0.077 14.64 5.3.11 0.120 0.053 14.66 5.3.10 0.047 0.047 14.07 5.3.9 0.000 0.063 14.01 5.3.8 0.083 0.057 14.00 5.3.7 0.100 0.053 14.16 5.3.6 0.093 0.057 14.15 5.3.5 0.110 0.053 13.87 5.3.4 0.110 0.053 13.95 5.3.3 0.117 0.050 13.91 5.3.2 0.110 0.060 13.79 5.3.1 0.090 0.067 13.77 5.3.0 0.110 0.057 13.64
preferences:dark mode live preview
145 ms | 1394 KiB | 7 Q