Suggestion: Add “Gatha Path” under Sundar Gutka page in STTM Web

[uttamdeepk22]

User Request

A user reported that the Sundar Gutka page currently does not include Gatha Path.

Feedback

“Sat Sri Akal, I noticed there is no ‘Gatha Path’ under Sundar Gutka page. Usually most of the people read Gatha, Funhe, and Chaubole together. Please add this on the page if possible. Thank you.”

Suggested Change:

Add Gatha Path to the Sundar Gutka section/page alongside:

• Funhe
• Chaubole

[Giansingh4710]

I noticed this as well. used this to fix for my end so sharing here as well:

echo "=== Adding Gatha as Bani ===="
mysql -u "$MYSQL_USER" "$MYSQL_DB" -e "
INSERT INTO Banis (ID,TOKEN,Gurmukhi,GurmukhiUni,English) Values (202,'gatha','mhlw 5 gwQw','ਮਹਲਾ ੫ ਗਾਥਾ','Fifth Mehl, Gaathaa');
SET @seq := 0;
SET @seqNow := 0;
INSERT INTO Banis_Shabad (Bani, Seq, header, Paragraph, ShabadID, VerseID)
SELECT
    202 AS Bani,
    (@seqNow := @seq := @seq + 1) AS Seq,
    CASE
        WHEN v.Gurmukhi LIKE '%<>%' THEN 1
        WHEN v.Gurmukhi LIKE '%mhlw 5 gwQw%' THEN 2
        ELSE 0
    END AS header,
    CASE
        WHEN v.Gurmukhi LIKE '%<>%' THEN 1
        WHEN v.Gurmukhi LIKE '%mhlw 5 gwQw%' THEN 2
        ELSE 3
    END AS Paragraph,
    sh.ShabadID,
    v.ID AS VerseID
FROM Verse v
INNER JOIN Shabad sh ON v.ID = sh.VerseID
LEFT JOIN Raag r ON v.RaagID = r.RaagID
WHERE r.RaagID = 37      -- CHANGE THIS IF NEEDED
ORDER BY v.ID;
"