phpMyFAQ

Hi all,

Just want to add a tip which might help someone using the API for front end.

api.php?action=getCategories

Above call returns catagories ordered by their ID and since moving categories around in the top level will effectively change their ID, the ordering will break for when looping ...

Worth mentioning that I noticed some inconstancy with the queries passed through PMF\Search\Database.php

When you do a full text search, the query says FROM faqdata while when opening a FAQ entry, it says FROM faqdata AS fd

Had to rebuild public function search($searchterm, $allLanguages = true ...

Managed to iron out the workflow :D

In PMF\Search\Database.php

Working draft
public function getJoinedTable()
{
//CUSTOM SEARCH JOINEDTABLE
if(isset($_SESSION['bmlfaq'])){
$currentBrand = $_SESSION["bmlfaq"];
}
elseif(isset($_COOKIE["bmlfaq"])){
$currentBrand = $_COOKIE["bmlfaq"];
}
else ...

Hi,

Might have expressed myself a bit weird.

In PMF\Search.php, the function search() creates an object that contains the search query in various keys.
It's not a SQL query string. So somewhere, I assume there is a function that takes the data in the keys and creates the complete SQL query string ...

Hi,

I am modifying phpMyFaq for a multi-brand version where multiple brands share a large portion of the FAQ but where certain FAQ's have to be hidden depending on certain parameters.
I've added 3 custom tables to the phpMyFaq DB for Category -> Brand & FAQ -> Brand and all is set for Categories ...