[otrs-cvs] FAQ/Kernel/System/FAQ Language.pm,1.2,1.3

Comments:
Update of /home/cvs/FAQ/Kernel/System/FAQ
In directory lancelot:/tmp/cvs-serv2310/Kernel/System/FAQ

Modified Files:
	Language.pm 
Log Message:
Updated SQL Style.

Author: cr

Index: Language.pm
===================================================================
RCS file: /home/cvs/FAQ/Kernel/System/FAQ/Language.pm,v
retrieving revision 1.2
retrieving revision 1.3
diff -2 -u -d -r1.2 -r1.3
--- Language.pm	29 Jun 2013 15:48:26 -0000	1.2
+++ Language.pm	29 Jun 2013 19:54:22 -0000	1.3
@@ -59,5 +59,7 @@
 
     return if !$Self->{DBObject}->Do(
-        SQL  => 'INSERT INTO faq_language (name) VALUES (?)',
+        SQL => '
+            INSERT INTO faq_language (name)
+            VALUES (?)',
         Bind => [ \$Param{Name} ],
     );
@@ -97,5 +99,7 @@
     # delete the language
     return if !$Self->{DBObject}->Do(
-        SQL  => 'DELETE FROM faq_language WHERE id = ? ',
+        SQL => '
+            DELETE FROM faq_language
+            WHERE id = ?',
         Bind => [ \$Param{LanguageID} ],
     );
@@ -137,10 +141,13 @@
 
     # build sql
-    my $SQL = 'SELECT id FROM faq_language WHERE ';
+    my $SQL = '
+        SELECT id
+        FROM faq_language
+        WHERE';
     if ( defined $Param{Name} ) {
-        $SQL .= "name = '$Param{Name}' ";
+        $SQL .= " name = '$Param{Name}'";
     }
     if ( defined $Param{LanguageID} ) {
-        $SQL .= "AND id != '$Param{LanguageID}' ";
+        $SQL .= " AND id != '$Param{LanguageID}'";
     }
 
@@ -194,5 +201,8 @@
     # sql
     return if !$Self->{DBObject}->Prepare(
-        SQL   => 'SELECT id, name FROM faq_language WHERE id = ?',
+        SQL => '
+            SELECT id, name
+            FROM faq_language
+            WHERE id = ?',
         Bind  => [ \$Param{LanguageID} ],
         Limit => 1,
@@ -242,5 +252,7 @@
     # build sql
     return if !$Self->{DBObject}->Prepare(
-        SQL => 'SELECT id, name FROM faq_language',
+        SQL => '
+            SELECT id, name
+            FROM faq_language',
     );
 
@@ -309,5 +321,8 @@
     if ( $Param{LanguageID} ) {
         return if !$Self->{DBObject}->Prepare(
-            SQL   => 'SELECT name FROM faq_language WHERE id = ?',
+            SQL => '
+                SELECT name
+                FROM faq_language
+                WHERE id = ?',
             Bind  => [ \$Param{LanguageID} ],
             Limit => 1,
@@ -316,5 +331,8 @@
     elsif ( $Param{Name} ) {
         return if !$Self->{DBObject}->Prepare(
-            SQL   => 'SELECT id FROM faq_language WHERE name = ?',
+            SQL => '
+                SELECT id
+                FROM faq_language
+                WHERE name = ?',
             Bind  => [ \$Param{Name} ],
             Limit => 1,
@@ -363,5 +381,8 @@
     # build sql
     return if !$Self->{DBObject}->Do(
-        SQL => 'UPDATE faq_language SET name = ? WHERE id = ?',
+        SQL => '
+            UPDATE faq_language
+            SET name = ?
+            WHERE id = ?',
         Bind => [ \$Param{Name}, \$Param{LanguageID} ],
     );
---------------------------------------------------------------------
OTRS mailing list: cvs-log - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/cvs-log
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/cvs-log