From d3f8bf365e5b93f58497a25e07fde7ce30884f9d Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Fri, 18 Feb 2005 05:57:26 +0000
Subject: Bug 280503: Replace "LOCK/UNLOCK TABLES" with Bugzilla::DB function
 call Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat,a=myk

---
 whine.pl | 13 ++++++-------
 1 file changed, 6 insertions(+), 7 deletions(-)

(limited to 'whine.pl')

diff --git a/whine.pl b/whine.pl
index 920b27d05..0e469e8ad 100755
--- a/whine.pl
+++ b/whine.pl
@@ -220,12 +220,11 @@ sub get_next_event {
     # Loop until there's something to return
     until (scalar keys %{$event}) {
 
-        $dbh->do("LOCK TABLE " .
-                 "whine_schedules WRITE, " .
-                 "whine_events READ, " .
-                 "profiles READ, " .
-                 "groups READ, " .
-                 "user_group_map READ");
+        $dbh->bz_lock_tables('whine_schedules WRITE',
+                             'whine_events READ',
+                             'profiles READ',
+                             'groups READ',
+                             'user_group_map READ');
 
         # Get the event ID for the first pending schedule
         $sth_next_scheduled_event->execute;
@@ -262,7 +261,7 @@ sub get_next_event {
             reset_timer($sid);
         }
 
-        $dbh->do("UNLOCK TABLES");
+        $dbh->bz_unlock_tables();
 
         # Only set $event if the user is allowed to do whining
         if ($owner->in_group('bz_canusewhines')) {
-- 
cgit v1.2.3-24-g4f1b