Frequently Asked Questions

[Sergey Hmelevsky]

What is the 'hidden' articles?
It is system record used for autosave and some other things, there are no useful information in it. Hidden articles makes active or approval when user submit it.

How to clear hidden articles?
It is not necessary to clear hidden articles often, once in a month quite enough.
Go to admin panel -> Manage Database and run following query

DELETE FROM `{prefix}articles` WHERE `url`='' AND (TO_DAYS(NOW()) - TO_DAYS(`date`) > 1)

How to change text on home page?
Go to Admin panel -> Language Manager -> Search in Phrases and find 2 phrases by 'Phrase Variable Name'
start_slogan_head
start_slogan_bottom
you should change they values.

How to show articles comments number?
Edit file packages/publishing/includes/classes/sbr.front.common.php, find

PHP Code:

function getArticles($aStart = 0, $aLimit = 0, $aWhere = '', $aShowInactive = false, $aFeaturedOnTop = false)
{
    $sql  = "SELECT SQL_CALC_FOUND_ROWS t1.`id`, t1.`account_id`, t1.`title`, t1.`summary`, t1.`url`, t1.`date` ";
    $sql .= ", t1.`avatar`, t1.`nofollow`, t1.`status`, t1.`num_clicks` "; 


and append ", t1.`comments`". What you should have

PHP Code:

function getArticles($aStart = 0, $aLimit = 0, $aWhere = '', $aShowInactive = false, $aFeaturedOnTop = false)
{
    $sql  = "SELECT SQL_CALC_FOUND_ROWS t1.`id`, t1.`account_id`, t1.`title`, t1.`summary`, t1.`url`, t1.`date` ";
    $sql .= ", t1.`avatar`, t1.`nofollow`, t1.`status`, t1.`num_clicks`, t1.`comments` "; 


Next. Edit file packages/publishing/templates/brief_article.tpl and remove 2 lines those started with {* and *}

[Sergey Hmelevsky]

How to translate Subrion to other language?

• Go to Admin Panel -> Language Manager
• Click on "New Language" button
• Input ISO code and title. Example: for Germany ISO=de, Title=German
• Click "Copy Language" button.

Now you see additional language in Language Manager, but it still contains English phrases and we need to translate them.

• Click on "Edit / Translate German phrases"
• Double click in "Value" cell of the first row, change phrase and click 'Save' button.

Repeat last step for all phrases.
Now you have translated Subrion and can backup language on your computer in "Language Manager".