mambax7 / smartfaq

class/category.php

Indentation +6 added lines, -6 removed lines

@@ -333,10 +333,10 @@ 
 
         if ($category->isNew()) {
             $sql = sprintf('INSERT INTO %s (categoryid, parentid, name, description, total, weight, created) VALUES (NULL, %u, %s, %s, %u, %u, %u)', $this->db->prefix('smartfaq_categories'),
-                           $parentid, $this->db->quoteString($name), $this->db->quoteString($description), $total, $weight, time());
+                            $parentid, $this->db->quoteString($name), $this->db->quoteString($description), $total, $weight, time());
         } else {
             $sql = sprintf('UPDATE %s SET parentid = %u, name = %s, description = %s, total = %s, weight = %u, created = %u WHERE categoryid = %u', $this->db->prefix('smartfaq_categories'), $parentid,
-                           $this->db->quoteString($name), $this->db->quoteString($description), $total, $weight, $created, $categoryid);
+                            $this->db->quoteString($name), $this->db->quoteString($description), $total, $weight, $created, $categoryid);
         }
         if (false !== $force) {
             $result = $this->db->queryF($sql);
@@ -520,10 +520,10 @@ 
         $ret   = array();
         $limit = $start = 0;
         $sql   = 'SELECT DISTINCT c.categoryid, c.parentid, c.name, c.description, c.total, c.weight, c.created FROM '
-                 . $this->db->prefix('smartfaq_categories')
-                 . ' AS c INNER JOIN '
-                 . $this->db->prefix('smartfaq_faq')
-                 . ' AS f ON c.categoryid = f.categoryid';
+                    . $this->db->prefix('smartfaq_categories')
+                    . ' AS c INNER JOIN '
+                    . $this->db->prefix('smartfaq_faq')
+                    . ' AS f ON c.categoryid = f.categoryid';
         if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
             $sql .= ' ' . $criteria->renderWhere();
             if ($criteria->getSort() != '') {

class/answer.php

Indentation +2 added lines, -2 removed lines

@@ -472,10 +472,10 @@
 
         if ($answerObj->isNew()) {
             $sql = sprintf('INSERT INTO %s (answerid, `status`, faqid, answer, uid, datesub, notifypub) VALUES (NULL, %u, %u, %s, %u, %u, %u)', $this->db->prefix('smartfaq_answers'), $status, $faqid,
-                           $this->db->quoteString($answer), $uid, time(), $notifypub);
+                            $this->db->quoteString($answer), $uid, time(), $notifypub);
         } else {
             $sql = sprintf('UPDATE %s SET STATUS = %u, faqid = %s, answer = %s, uid = %u, datesub = %u, notifypub = %u WHERE answerid = %u', $this->db->prefix('smartfaq_answers'), $status, $faqid,
-                           $this->db->quoteString($answer), $uid, $datesub, $notifypub, $answerid);
+                            $this->db->quoteString($answer), $uid, $datesub, $notifypub, $answerid);
         }
 
         if (false !== $force) {

class/faq.php

Indentation +20 added lines, -20 removed lines

@@ -647,16 +647,16 @@ 
         }
 
         return $text
-               . $xoopsConfig['sitename']
-               . ' : <a href='
-               . XOOPS_URL
-               . '/modules/smartfaq/faq.php?faqid='
-               . $this->faqid()
-               . '>'
-               . XOOPS_URL
-               . '/modules/smartfaq/faq.php?faqid='
-               . $this->faqid()
-               . '</a>';
+                . $xoopsConfig['sitename']
+                . ' : <a href='
+                . XOOPS_URL
+                . '/modules/smartfaq/faq.php?faqid='
+                . $this->faqid()
+                . '>'
+                . XOOPS_URL
+                . '/modules/smartfaq/faq.php?faqid='
+                . $this->faqid()
+                . '</a>';
     }
 
     /**
@@ -778,14 +778,14 @@ 
 
         if ($faq->isNew()) {
             $sql = sprintf('INSERT INTO %s (faqid, categoryid, question, howdoi, diduno, uid, datesub, `status`, counter, weight, html, smiley, xcodes, cancomment, comments, notifypub, modulelink, contextpage, exacturl, partialview) VALUES (NULL, %u, %s, %s, %s, %u, %u, %u, %u, %u, %u, %u, %u, %u, %u, %u, %s, %s, %u, %u)',
-                           $this->db->prefix('smartfaq_faq'), $categoryid, $this->db->quoteString($question), $this->db->quoteString($howdoi), $this->db->quoteString($diduno), $uid, time(), $status,
-                           $counter, $weight, $html, $smiley, $xcodes, $cancomment, $comments, $notifypub, $this->db->quoteString($modulelink), $this->db->quoteString($contextpage), $exacturl,
-                           $partialview);
+                            $this->db->prefix('smartfaq_faq'), $categoryid, $this->db->quoteString($question), $this->db->quoteString($howdoi), $this->db->quoteString($diduno), $uid, time(), $status,
+                            $counter, $weight, $html, $smiley, $xcodes, $cancomment, $comments, $notifypub, $this->db->quoteString($modulelink), $this->db->quoteString($contextpage), $exacturl,
+                            $partialview);
         } else {
             $sql = sprintf('UPDATE %s SET categoryid = %u, question = %s, howdoi = %s, diduno = %s, uid = %u, datesub = %u, `status` = %u, counter = %u, weight = %u, html = %u, smiley = %u, xcodes = %u, cancomment = %u, comments = %u, notifypub = %u, modulelink = %s, contextpage = %s, exacturl = %u, partialview = %u  WHERE faqid = %u',
-                           $this->db->prefix('smartfaq_faq'), $categoryid, $this->db->quoteString($question), $this->db->quoteString($howdoi), $this->db->quoteString($diduno), $uid, $datesub, $status,
-                           $counter, $weight, $html, $smiley, $xcodes, $cancomment, $comments, $notifypub, $this->db->quoteString($modulelink), $this->db->quoteString($contextpage), $exacturl,
-                           $partialview, $faqid);
+                            $this->db->prefix('smartfaq_faq'), $categoryid, $this->db->quoteString($question), $this->db->quoteString($howdoi), $this->db->quoteString($diduno), $uid, $datesub, $status,
+                            $counter, $weight, $html, $smiley, $xcodes, $cancomment, $comments, $notifypub, $this->db->quoteString($modulelink), $this->db->quoteString($contextpage), $exacturl,
+                            $partialview, $faqid);
         }
         if (false !== $force) {
             $result = $this->db->queryF($sql);
@@ -1618,10 +1618,10 @@ 
         $criteria->setOrder('DESC');
 
         $sql = 'SELECT faq.faqid, faq.question, faq.datesub, faq.uid FROM '
-               . $this->db->prefix('smartfaq_faq')
-               . ' AS faq INNER JOIN '
-               . $this->db->prefix('smartfaq_answers')
-               . ' AS answer ON faq.faqid = answer.faqid';
+                . $this->db->prefix('smartfaq_faq')
+                . ' AS faq INNER JOIN '
+                . $this->db->prefix('smartfaq_answers')
+                . ' AS answer ON faq.faqid = answer.faqid';
 
         if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
             $whereClause = $criteria->renderWhere();