$query .= "AND {$pilihan} LIKE '{$tekscari}%' "; } } $query .= "ORDER BY p.productname asc "; $query1 = $query; $query .= "LIMIT {$posisi},{$batas}"; $result = mysql_query($query); while ($row = mysql_fetch_array($result)) { echo '<tr bgcolor> <td align="right">' . $row["idproduct"] . '</td> <td align="left">' . $row["productname"] . '</b><br><br><br><span class="keterangan">'; echo " » added "; $nowtime = time(); //echo $row["inputdate"]; $oldtime = strtotime($row["inputdate"]); echo time_elapsed_B($nowtime - $oldtime); echo '</span></td> <td align="left">'; $gambar = "../imgz_product/" . $row["idproduct"] . ".jpg"; if (file_exists($gambar)) { echo '<img src="" width="100%" height="">'; } else { echo '<img src="../images/noimage.jpg" width="100%" height="">'; } echo '</td> <td align="left">' . $row["categoryname"] . '</td> <td align="left">' . $row["subcategoryname"] . '</td>'; echo '<td align="center">' . $row['symbol'] . ' ' . number_format($row["productprice"], 0, ",", ".") . '</td>'; echo '<td align="center">' . $row["membername"] . '</td>'; echo '<td align="center">' . $row["cityname"] . '</td>'; }
echo '<div class="alert alert-danger">'; } else { echo '<div class="alert alert-success">'; } } } echo '<h4>' . getBansPlayerName($bhcon, $row["creator_id"]) . " Banned " . getBansPlayerName($bhcon, $row["player_id"]) . "</h4><h5> For " . $row["reason"] . "</h5>"; echo '<br>Ban issued on: ' . $row["created_at"]; if ($row["expires_at"] != NULL) { $banlength = strtotime($row["expires_at"]) - strtotime($row["created_at"]); if (strtotime($row["expires_at"]) > time()) { echo '<br>Ban expiry on: ' . $row["expires_at"]; echo '<br>Ban lenght: ' . time_elapsed_B($banlength); } else { echo '<br>Ban expired on: ' . $row["expires_at"]; echo '<br>Ban lasted: ' . time_elapsed_B($banlength); } } echo '</div>'; echo '</div>'; $count = $count + 1; if ($count == 3) { $count = 0; echo '</div>'; } } } else { echo '<div class="alert alert-danger"> BanHammer Database has not been setup</a> </div><br>'; }