mambax7 /
smartfaq
| @@ 479-483 (lines=5) @@ | ||
| 476 | $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); |
|
| 477 | } |
|
| 478 | ||
| 479 | if (false !== $force) { |
|
| 480 | $result = $this->db->queryF($sql); |
|
| 481 | } else { |
|
| 482 | $result = $this->db->query($sql); |
|
| 483 | } |
|
| 484 | ||
| 485 | if (!$result) { |
|
| 486 | return false; |
|
| @@ 514-518 (lines=5) @@ | ||
| 511 | ||
| 512 | //echo "<br>" . $sql . "<br>"; |
|
| 513 | ||
| 514 | if (false !== $force) { |
|
| 515 | $result = $this->db->queryF($sql); |
|
| 516 | } else { |
|
| 517 | $result = $this->db->query($sql); |
|
| 518 | } |
|
| 519 | if (!$result) { |
|
| 520 | return false; |
|
| 521 | } |
|
| @@ 342-346 (lines=5) @@ | ||
| 339 | $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, |
|
| 340 | $this->db->quoteString($name), $this->db->quoteString($description), $total, $weight, $created, $categoryid); |
|
| 341 | } |
|
| 342 | if (false !== $force) { |
|
| 343 | $result = $this->db->queryF($sql); |
|
| 344 | } else { |
|
| 345 | $result = $this->db->query($sql); |
|
| 346 | } |
|
| 347 | if (!$result) { |
|
| 348 | return false; |
|
| 349 | } |
|
| @@ 389-393 (lines=5) @@ | ||
| 386 | $smartModule = sf_getModuleInfo(); |
|
| 387 | $module_id = $smartModule->getVar('mid'); |
|
| 388 | ||
| 389 | if (false !== $force) { |
|
| 390 | $result = $this->db->queryF($sql); |
|
| 391 | } else { |
|
| 392 | $result = $this->db->query($sql); |
|
| 393 | } |
|
| 394 | ||
| 395 | xoops_groupperm_deletebymoditem($module_id, 'category_read', $category->categoryid()); |
|
| 396 | //xoops_groupperm_deletebymoditem ($module_id, "category_admin", $categoryObj->categoryid()); |
|
| @@ 778-782 (lines=5) @@ | ||
| 775 | $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, |
|
| 776 | $this->db->quoteString($modulelink), $this->db->quoteString($contextpage), $exacturl, $partialview, $faqid); |
|
| 777 | } |
|
| 778 | if (false !== $force) { |
|
| 779 | $result = $this->db->queryF($sql); |
|
| 780 | } else { |
|
| 781 | $result = $this->db->query($sql); |
|
| 782 | } |
|
| 783 | ||
| 784 | if (!$result) { |
|
| 785 | return false; |
|
| @@ 822-826 (lines=5) @@ | ||
| 819 | ||
| 820 | $sql = sprintf('DELETE FROM %s WHERE faqid = %u', $this->db->prefix('smartfaq_faq'), $faq->getVar('faqid')); |
|
| 821 | ||
| 822 | if (false !== $force) { |
|
| 823 | $result = $this->db->queryF($sql); |
|
| 824 | } else { |
|
| 825 | $result = $this->db->query($sql); |
|
| 826 | } |
|
| 827 | if (!$result) { |
|
| 828 | return false; |
|
| 829 | } |
|
