Ban List PCP Mysql - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Ban List PCP Mysql (/showthread.php?tid=625641)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Ban List PCP Mysql (/showthread.php?tid=625641)
Ban List PCP Mysql - DandyCorleone - 04.01.2017
I think it is correct, but why always do not have the data from the table bans? always considered empty tables
PHP код:
<section class="page-section parallax directions" id="location" style="padding-top:15%">
<div class="container div-table">
<div class="parallax-bg" data-stellar-background-ratio="0.5" data-stellar-vertical-offset="-150"></div>
<div class="parallax-overlay"></div>
<div class="parallax-inner text-center">
<table class="table table-bordered">
<thead>
<td>Username</td>
<td>IP</td>
<td>Banner</td>
<td>Reason</td>
<td>Banned From</td>
<td>Unbanned</td>
</thead>
<?php
$query = $koneksi->prepare("SELECT user_banned, bIP, ban_reason, ban_time, (ban_timestamp + (ban_time * 60) - strftime('%%s', 'now')) as banTimeLeft, strftime('%%d-%%m-%%Y %%H:%%M', datetime(ban_timestamp + (ban_time * 60), 'unixepoch')) as banExpired, strftime('%%d-%%m-%%Y %%H:%%M', datetime(ban_timestamp, 'unixepoch')) as bannedFrom, user_banner FROM `bans`");
$query->execute();
if($query->rowCount() == 0)
{
echo "<tr><td colspan='6'><small>There's no player on ban list</small></td></tr>";
}
while($data = $query->fetch())
{
if($data['ban_time'] == 0)
{
$data['banExpired'] = "Never";
}
echo "<tr><td>".$data['user_banned']."</td>";
echo "<td>".$data['bIP']."</td>";
echo "<td>".$data['user_banner']."</td>";
echo "<td>".$data['ban_reason']."</td>";
echo "<td>".$data['bannedFrom']."</td>";
echo "<td>".$data['banExpired']."</td></tr>";
}
?>
</table>
</div>
</div>
</section>
PHP код:
CREATE TABLE IF NOT EXISTS `bans` (
`BanID` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_banned` varchar(50) NOT NULL,
`bIP` varchar(50) NOT NULL,
`user_banner` varchar(50) NOT NULL DEFAULT '*',
`ban_reason` varchar(50) NOT NULL DEFAULT '*',
`ban_timestamp` int(11) unsigned NOT NULL,
`ban_time` int(11) unsigned NOT NULL,
PRIMARY KEY (`BanID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=122 ;
--
-- Dumping data for table `bans`
--
INSERT INTO `bans` (`BanID`, `user_banned`, `bIP`, `user_banner`, `ban_reason`, `ban_timestamp`, `ban_time`) VALUES
(1, 'Naswara', '140.0.44.94', 'Server Ban', 'Vehicle Spawning', 1481960211, 0),
(2, 'AK59', '119.30.39.51', 'Prodigy', 'aimbot', 1481966183, 0),
(3, 'AK59', '119.30.39.51', 'TheOneShooT', 'aimbot (ip ban)', 1481966225, 0),
Re: Ban List PCP Mysql - Yaa - 04.01.2017
----
Re: Ban List PCP Mysql - Yaa - 04.01.2017
----
Re: Ban List PCP Mysql - Yaa - 04.01.2017
here you go
PHP код:
<section class="page-section parallax directions" id="location" style="padding-top:15%">
<div class="container div-table">
<div class="parallax-bg" data-stellar-background-ratio="0.5" data-stellar-vertical-offset="-150"></div>
<div class="parallax-overlay"></div>
<div class="parallax-inner text-center">
<table class="table table-bordered">
<thead>
<td>Username</td>
<td>IP</td>
<td>Banner</td>
<td>Reason</td>
<td>Banned From</td>
<td>Unbanned</td>
</thead>
<?php
$query = $koneksi->prepare("SELECT user_banned, bIP, ban_reason, ban_time, (ban_timestamp + (ban_time * 60) - DATE_FORMAT('now', '%%s')) AS banTimeLeft, DATE_FORMAT( TIMESTAMP(ban_timestamp + (ban_time * 60), 'unixepoch'), '%%d-%%m-%%Y %%H:%%M') AS banExpired, DATE_FORMAT( TIMESTAMP(ban_timestamp, 'unixepoch'), '%%d-%%m-%%Y %%H:%%M') AS bannedFrom, user_banner FROM `bans` ");
$query->execute();
if($query->rowCount() == 0)
{
echo "<tr><td colspan='6'><small>There's no player on ban list</small></td></tr>";
}
while($data = $query->fetch())
{
if($data['ban_time'] == 0)
{
$data['banExpired'] = "Never";
}
echo "<tr><td>".$data['user_banned']."</td>";
echo "<td>".$data['bIP']."</td>";
echo "<td>".$data['user_banner']."</td>";
echo "<td>".$data['ban_reason']."</td>";
echo "<td>".$data['bannedFrom']."</td>";
echo "<td>".$data['banExpired']."</td></tr>";
}
?>
</table>
</div>
</div>
</section>
PHP код:
CREATE TABLE IF NOT EXISTS `bans` (
`BanID` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_banned` varchar(50) NOT NULL,
`bIP` varchar(50) NOT NULL,
`user_banner` varchar(50) NOT NULL DEFAULT '*',
`ban_reason` varchar(50) NOT NULL DEFAULT '*',
`ban_timestamp` int(11) unsigned NOT NULL,
`ban_time` int(11) unsigned NOT NULL,
PRIMARY KEY (`BanID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=122 ;
--
-- Dumping data for table `bans`
--
INSERT INTO `bans` (`BanID`, `user_banned`, `bIP`, `user_banner`, `ban_reason`, `ban_timestamp`, `ban_time`) VALUES
(1, 'Naswara', '140.0.44.94', 'Server Ban', 'Vehicle Spawning', 1481960211, 0),
(2, 'AK59', '119.30.39.51', 'Prodigy', 'aimbot', 1481966183, 0),
(3, 'AK59', '119.30.39.51', 'TheOneShooT', 'aimbot (ip ban)', 1481966225, 0)
Re: Ban List PCP Mysql - oMa37 - 04.01.2017
Can't you just fucking edit your first post and stop post hunting?
Re: Ban List PCP Mysql - Yaa - 04.01.2017
Quote:
|
Originally Posted by oMa37
 Can't you just fucking edit your first post and stop post hunting?
|
*FAQ How you edit it : i edited it from pc after 5 min
Re: Ban List PCP Mysql - Vince - 04.01.2017
Put this on top while developing PHP scripts:
PHP код:
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
?>
Re: Ban List PCP Mysql - DandyCorleone - 05.01.2017
Quote:
|
Originally Posted by Yaa
here you go
PHP код:
PHP код:
|
