Add ability to ban users from guestbook (by IP)

1 files changed, 6 insertions, 0 deletions

diff --git a/app/Http/Controllers/GuestbookController.php b/app/Http/Controllers/GuestbookController.php
index aff30ed..da5391d 100644
--- a/app/Http/Controllers/GuestbookController.php
+++ b/app/Http/Controllers/GuestbookController.php
@@ -16,6 +16,12 @@ class GuestbookController extends Controller {
             'message' => 'required'
         ]);
 
+        $matching_bans = DB::select('SELECT reason FROM guestbook_bans WHERE ip_address = ?', array($request->ip()));
+
+        if (count($matching_bans) > 0 ) {
+            return view('errors.guestbook-ban')->with('reason', $matching_bans[0]->reason);
+        }
+
         DB::insert('INSERT INTO guestbook_entries (name, timestamp, ip_address, agent, message) values (?, ?, ?, ?, ?)', array(
             htmlspecialchars($request->get('name')),
             time(),