@ 2014-07-10T21:51:28Z <?php
ini_set('display_errors', 'On');
error_reporting(E_ALL);
$time = microtime();
$time = explode(' ', $time);
$time = $time[1] + $time[0];
$starttime = $time;
session_start();
require 'connect.php';
require 'functions.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();
}
if (isset($_GET['id']) && is_numeric($_GET['id']) )
{
$id = mysqli_real_escape_string($sqli, $_GET['id']);
$query = mysqli_query($sqli, "SELECT * FROM blog WHERE id='$id'") or die("Error: ".mysqli_error($sqli));
$checknumblogs = mysqli_num_rows($query);
if($checknumblogs == 0)
{
$noBlogPostsFound = TRUE;
}
else
{
$row = mysqli_fetch_assoc($query);
$headline = $row['headline'];
$story = $row['story'];
$timestamp = $row['timestamp'];
$userid = $row['userid'];
$userquery = mysqli_query($sqli, "SELECT * FROM members WHERE id='$userid'") 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'];
}
}
}
else
{
if (!isset($_GET['page']) || !is_numeric($_GET['page']) || ($_GET['page'] < 0))
{
$page = 0;
}
else
{
$page = (int)$_GET['page'];
}
$limit = 3;
$postsperpage = $limit;
$start = $page * $limit;
$query = mysqli_query($sqli, "SELECT * FROM blog ORDER BY timestamp DESC LIMIT $start, $limit") or die("Error: ".mysqli_error($sqli));
$checknumblogs = mysqli_num_rows($query);
// Check if any blog posts exists
if($checknumblogs == 0)
{
$noBlogPostsFound = TRUE;
}
else
{
$blogposts = array();
while ($row = mysqli_fetch_array($query))
{
$userid = $row['userid'];
$userquery = mysqli_query($sqli, "SELECT * FROM members WHERE id='$userid'") 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'];
}
$blogposts[] = array(
"id" => $row['id'],
"headline" => $row['headline'],
"story" => $row['story'],
"timestamp" => $row['timestamp'],
"userid" => $row['userid'],
"username" => $username
);
}
}
$totalquery = mysqli_query($sqli, "SELECT * FROM blog") or die("Error: ".mysqli_error($sqli));
$totalblogposts = mysqli_num_rows($totalquery);
}
//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,
"categoryid" => $row['categoryid']
);
}
//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" />
<link href="stylesheet/blog.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="TopLoginInput" name="username" type="text" id="username" placeholder="Username" /><br />
<input class="TopLoginInput" name="password" type="password" id="password" placeholder="Password" /><br />
<input class="TopLoginButton" 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="default.php"><span class="DivLink"></span></a>
</div>
<div id="MenuLinkSeparator"></div>
<div id="MenuLinks">
<a href="default.php" class="Menu">HOME</a>
<a href="about.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="contact.php" 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="BlogContent">
<?php
//WRITE OUT IF NO BLOG POSTS FOUND!
if (isset($_GET['id']) && is_numeric($_GET['id']) )
{
?>
<span class="BlogPostHeadlineSingle"><?php echo strtoupper($headline) ?></span><br />
<span class="BlogPostInfoSingle">posted by <a href="profile.php?id=<?php echo $userid ?>"><?php echo $username ?></a> at <?php echo $timestamp ?></span><br /><br />
<div id="BlogContentTextSingle">
<span class="BlogPostTextSingle"><?php echo $story ?></span><br />
</div>
<img src="images/separator-horizontal-long.png" id="SeparatorHorizontal1100" /><br />
<span class="BlogComments">Comments:</span>
<?php
}
else
{
if (isset($noBlogPostsFound) && $noBlogPostsFound == TRUE)
{
echo '<span class="BlogPostHeadlineList">NO BLOG POSTS FOUND<br /> IF YOU THINK YOU\'VE REACHED THIS PAGE BY ACCIDENT CONTACT WEBMASTER</span>'
}
else
{
$counter = 0;
foreach ($blogposts as $post)
{
$counter++;
?>
<a href="?id=<?php echo $post['id'] ?>" class="BlogPostHeadlineList"><?php echo strtoupper($post['headline']) ?></a><br />
<span class="BlogPostInfoList">posted by <a href="profile.php?id=<?php echo $post['userid'] ?>"><?php echo $post['username'] ?></a> at <?php echo $post['timestamp'] ?></span><br />
<div id="BlogContentText">
<span class="BlogPostTextList"><?php echo rtrim(tokenTruncate($post['story'], 550)); if (strlen($post['story']) > 550) { echo '...'; } ?></span><br />
</div>
<div class="BlogButtonContainer">
<?php
if (strlen($post['story']) > 550)
{
?>
<a href="<?php echo $_SERVER['PHP_SELF'].'?id='.$post['id'] ?>"><img src="images/buttonreadmore.png" class="ButtonReadMore" /></a>
<?php
}
?>
<a href="<?php echo $_SERVER['PHP_SELF'].'?id='.$post['id']. '#comments' ?>"><img src="images/buttoncomments.png" class="ButtonComment" /></a>
</div>
<?php
if ($counter < $postsperpage)
{
?>
<img src="images/separator-horizontal-long.png" id="SeparatorHorizontal1100" /><br />
<?php
}
}
?>
</div>
<div id="BlogLinks">
<span class="BlogNavigationLink">
<?php
if ($page > 0)
{
$prev = $start - $limit;
echo '<a href="'.$_SERVER['PHP_SELF'].'?page='.$prev.'" class="BlogNavigationLink">« Newer posts</a> ';
}
else
{
echo '« Newer posts ';
}
$maxpages = floor($totalblogposts/$postsperpage);
echo '<span class="BlogNavigationLink">';
for ($i = 0; $i <= $maxpages; $i++)
{
if ($page != $i)
{
echo '<a href="'.$_SERVER['PHP_SELF'].'?page='.$i.'" class="BlogNavigationLink">' .($i+1). '</a> ';
}
else
{
echo $i+1;
}
}
echo '</span>';
if ($page < $maxpages)
{
$nextpage = $page+1;
echo ' <a href="'.$_SERVER['PHP_SELF'].'?page='.$nextpage.'" class="BlogNavigationLink">Older Posts »</a>';
}
else
{
echo ' Older Posts »';
}
}
}
?>
</span>
</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));
$ordinaldate = ordinal($d);
?>
<div class="ForumPostContainer">
<a href="forums.php?fid=<?php echo $posts['categoryid'] ?>&tid=<?php echo $posts['id'] ?>" class="FrontpageForumLink"><?php echo $posts['threadname'] ?></a>
<span class="ForumPostInfo">
<?php
echo 'posted by <a href="profile.php?id=' .$posts['userid']. '">' .$posts['username']. '</a> at ' .$hr. ':' .$min. ' on ' .$monthName. ' ' .$ordinaldate. ', ' .$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'];
$d = str_pad($d, 2, '0', STR_PAD_LEFT);
$m = str_pad($m, 2, '0', STR_PAD_LEFT);
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 '<a href="events.php?id=' .$event['id']. '"><img src="images/buttonreadmoreevent.png" class="ButtonReadMoreEvent" /></a>';
}
?>
</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="register.php"><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 - $starttime), 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.006 0.037 12.57 5.4.29 0.009 0.037 12.56 5.4.28 0.004 0.037 12.46 5.4.27 0.006 0.037 12.46 5.4.26 0.005 0.038 12.46 5.4.25 0.006 0.039 12.46 5.4.24 0.008 0.035 12.46 5.4.23 0.008 0.036 12.45 5.4.22 0.008 0.034 12.45 5.4.21 0.006 0.038 12.45 5.4.20 0.005 0.050 12.45 5.4.19 0.007 0.035 12.45 5.4.18 0.006 0.040 12.45 5.4.17 0.009 0.036 12.46 5.4.16 0.005 0.038 12.45 5.4.15 0.004 0.041 12.45 5.4.14 0.006 0.037 12.14 5.4.13 0.003 0.040 12.12 5.4.12 0.006 0.035 12.09 5.4.11 0.006 0.035 12.08 5.4.10 0.002 0.038 12.08 5.4.9 0.009 0.044 12.08 5.4.8 0.007 0.039 12.08 5.4.7 0.004 0.036 12.08 5.4.6 0.007 0.034 12.08 5.4.5 0.004 0.038 12.08 5.4.4 0.003 0.039 12.07 5.4.3 0.008 0.034 12.06 5.4.2 0.007 0.035 12.05 5.4.1 0.006 0.037 12.06 5.4.0 0.007 0.039 11.55 5.3.28 0.013 0.034 12.71 5.3.27 0.014 0.034 12.73 5.3.26 0.007 0.037 12.72 5.3.25 0.009 0.034 12.72 5.3.24 0.009 0.034 12.72 5.3.23 0.009 0.038 12.71 5.3.22 0.006 0.039 12.68 5.3.21 0.004 0.044 12.68 5.3.20 0.007 0.035 12.68 5.3.19 0.014 0.042 12.68 5.3.18 0.012 0.046 12.67 5.3.17 0.012 0.046 12.68 5.3.16 0.008 0.042 12.67 5.3.15 0.006 0.039 12.67 5.3.14 0.013 0.038 12.66 5.3.13 0.007 0.039 12.65 5.3.12 0.011 0.037 12.66 5.3.11 0.007 0.048 12.66 5.3.10 0.013 0.034 12.14 5.3.9 0.005 0.042 12.13 5.3.8 0.007 0.042 12.12 5.3.7 0.007 0.035 12.12 5.3.6 0.005 0.037 12.10 5.3.5 0.004 0.038 12.05 5.3.4 0.008 0.035 12.05 5.3.3 0.004 0.044 12.01 5.3.2 0.006 0.039 11.79 5.3.1 0.008 0.033 11.75 5.3.0 0.006 0.038 11.74
preferences:dark mode live preview
141.5 ms | 1394 KiB | 7 Q