?> </dd> <dt><?php echo $lang["MPuptime"]; ?> </dt> <dd><?php echo secondsToWords(round($uptime[0])); ?> </dd> <dt><?php echo $lang["mineruptime"]; ?> </dt> <dd><?php echo secondsToWords($summary['SUMMARY'][0]['Elapsed']); ?> </dd> </dl> </div> <div class="col-lg-4"> <dl class="dl-horizontal"> <dt><?php echo $lang["MPversion"]; ?> </dt> <dd><?php echo $version; ?> </dd> <dt><?php
$sqlcountonlycomments = $sqlcountonlycomments . " profile ON comments.profileid = profile.profileid LEFT OUTER JOIN"; $sqlcountonlycomments = $sqlcountonlycomments . " wallpost ON comments.publishid = wallpost.postid"; $sqlcountonlycomments = $sqlcountonlycomments . " WHERE (comments.publishid = {$rs['0']}) AND (comments.commenttype = 'Wallpost')"; $resultcountonlycomments = mysqli_query($con, $sqlcountonlycomments); $countcomments = mysqli_num_rows($resultcountonlycomments); //ommnents code ends here //$result1 = mysqli_query($con, "SELECT * FROM comments "); while ($rs1 = mysqli_fetch_array($result1)) { //Times ago Commentbox: Coding to compare the date $date1 = $rs1[dattime]; $date2 = date("Y-m-d h:i:s"); $ts1 = strtotime($date1); $ts2 = strtotime($date2); $seconds_diff = $ts2 - $ts1; $timesago = floor($seconds_diff / 3600 / 24); $hdmago = secondsToWords($seconds_diff); //Times ago Commentbox: Coding to compare date ends here echo "<div class='comments info' ><li class='one_fifth'>"; //Code for comment profile image starts here $resultprofileimg = mysqli_query($con, "SELECT * FROM images WHERE imgid ='{$rs1['20']}' "); $rsprofileimg = mysqli_fetch_array($resultprofileimg); echo $profileimgid; if (mysqli_num_rows($resultprofileimg) == 0) { echo "<div class='one_fourth'><img src='images/profilepic.jpg' width=10 height=10 class='icon-desktop icon-3x' ></div>"; } else { echo "<div class='one_fourth'><img src='uploads/{$rsprofileimg['imagepath']}' width=10 height=10 class='icon-desktop icon-3x' ></div>"; } //Code for comment profile image ends here echo "</li>\r\n\t\t\t<strong>{$rs1['firstname']} {$rs1['lastname']} </strong>wrote <a style='float: right;vertical-align:top' href='{$pagename}?wallpostsinglepostid={$_GET['wallpostsinglepostid']}&delcmntid={$rs1['0']}'><strong>X</strong></a><br>\r\n\t\t\t{$rs1['comment']} <br>"; //Likes Comments code starts here $resultcmtlikes = mysqli_query($con, "SELECT * FROM likes WHERE publishid ='{$rs1['0']}' AND type='WallComment' ");
} echo "\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t\t\t<td><b>Totaal</b></td>\n\t\t\t\t\t\t\t\t<td><b>" . $totaalHoeveel . "</b></td>\n\t\t\t\t\t\t\t\t<td><b>" . number_format($totaalAfstand / 1000, 2, ',', '.') . " km</b></td>\n\t\t\t\t\t\t\t\t<td><b>" . number_format($totaalHoogte, 0, ',', '.') . " m</b></td>\n\t\t\t\t\t\t\t\t<td><b>" . secondsToWords($totaalTijd) . "</b></td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</tbody></b>"; $tel = 1; echo "\t\t\t</table>\n\t\t\t\t</div>"; echo "</td>"; echo "<td>"; $totaalAfstand = 0; $totaalHoeveel = 0; $totaalHoogte = 0; $totaalTijd = 0; echo "\t\t\t<h1><center>Zwemmers</center></h1>"; echo "\t\t\t<div class=\"datagrid\">\n\t\t\t\t<table>\n\t\t\t\t\t<thead> \n\t\t\t\t\t\t<th>#</th>\n\t\t\t\t\t\t<!-- th>Weeknummer</th -->\n\t\t\t\t\t\t<th>Wie</th>\n\t\t\t\t\t\t<th>Aantal</th>\n\t\t\t\t\t\t<th>Km</th>\n\t\t\t\t\t\t<th>Tijd</th>\n\t\t\t\t\t</thead>\n\t\t\t\t<tbody>"; while ($row = $testZwemmen->fetch_assoc()) { echo "\t\t\t<tr>"; echo "\t\t\t\t<td>" . $tel . "</td>\n\t\t\t\t\t\t<!-- td> " . $row["Weeknummer"] . "</td -->\n\t\t\t\t\t\t<td>" . $row["lFname"] . " " . $row["lName"] . "</td>\n\t\t\t\t\t\t<!-- td>" . $row["aType"] . "</td -->\n\t\t\t\t\t\t<td>" . $row["Oeveel"] . "</td>\n\t\t\t\t\t\t<td>" . number_format($row["Oever"] / 1000, 2) . " km</td>\n\t\t\t\t\t\t<td>" . gmdate("H:i:s", $row["Oelang"]) . "</td>"; echo "\t\t\t</tr>"; $totaalHoeveel = $totaalHoeveel + $row["Oeveel"]; $totaalAfstand = $totaalAfstand + $row["Oever"]; $totaalTijd = $totaalTijd + $row["Oelang"]; $tel++; } echo "\t\t\t<tr>\n\t\t\t\t\t\t<td></td>\n\t\t\t\t\t\t<td><b>Totaal</b></td>\n\t\t\t\t\t\t<td><b>" . $totaalHoeveel . "</b></td>\n\t\t\t\t\t\t<td><b>" . number_format($totaalAfstand / 1000, 2, ',', '.') . " km</b></td>\n\t\t\t\t\t\t<td><b>" . secondsToWords($totaalTijd) . "</b></td>\n\t\t\t\t\t</tr>\n\t\t\t\t</tbody></b>"; echo "\t\t</table>"; echo "</td>"; // End main table. echo "</tr>"; echo "</table>"; echo "<input type=\"submit\" value=\"screenshotjeu\" onclick=\"capture();\" id=\"screenshot\"/>\n\t\t<form method=\"POST\" enctype=\"multipart/form-data\" action=\"save.php\" id=\"myForm\">\n\t\t<input type=\"hidden\" name=\"img_val\" id=\"img_val\" value=\"\" />\n\t\t<input type=\"hidden\" name=\"w\" id=\"w\" value=\"" . $_GET['w'] . "\">\n\t\t</form>"; ?> </div> </html>