Frequently Asked Questions

Discussion in 'Article Script / Article Directory Script' started by Vasily_B., Oct 13, 2008.

  1. Vasily_B.

    Vasily_B. Project Manager

    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
    Code (Text):
    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:

    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:

    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 *}
    Last edited by a moderator: Oct 21, 2008
  2. Vasily_B.

    Vasily_B. Project Manager

    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".

Share This Page