[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    bugs/bugz
From:       Dirk Mueller <mueller () kde ! org>
Date:       2005-03-31 22:41:34
Message-ID: 20050331224134.E548465B () office ! kde ! org
[Download RAW message or body]

CVS commit by mueller: 

allow to search for words with 3 letters


  M +6 -2      bug_email.pl   1.45
  M +2 -2      simple_search.pl   1.24


--- bugs/bugz/bug_email.pl  #1.44:1.45
@@ -567,7 +567,11 @@
     if( $critical_err == 0 && $testMode == 0 )
     {
+        SendSQL("LOCK TABLES bugs WRITE, longdescs WRITE");
+        # update "last modifed" field
+        SendSQL("UPDATE bugs SET delta_ts=NOW() WHERE bug_id=" . SqlQuote($id) . \
";");  # shove the new comment into the table
-        my $long_desc_query = "INSERT INTO longdescs SET bug_id= $found_id, \
                who=$::userid, bug_when=NOW(), thetext=" . SqlQuote($Body) . ";";
-        SendSQL($long_desc_query);
+        SendSQL("INSERT INTO longdescs SET bug_id= $found_id, who=$::userid, " .
+                "bug_when=NOW(), thetext=" . SqlQuote($Body) . ";");
+        SendSQL("UNLOCK TABLES");
 
         # update timestamp (#58843)

--- bugs/bugz/simple_search.pl  #1.23:1.24
@@ -48,5 +48,5 @@
     $terms = "";
     foreach my $term (@uterms) {
-        if( length($term) < 4 ) {        # 4 is a MySQL compile-time constant
+        if( length($term) < 3 ) {        # 4 is a MySQL compile-time constant
             push(@ignored_terms, $term);
         } else {
@@ -57,5 +57,5 @@
     if( scalar(@ignored_terms) > 0 ) {
         $vars->{'warning'} = '<p>The following words have been ignored because '.
-            'of they are shorter than the minimum word length (4 characters): '.
+            'of they are shorter than the minimum word length (3 characters): '.
             html_quote(join(', ', @ignored_terms)).
             '</p>';


[prev in list] [next in list] [prev in thread] [next in thread]