Cookies help us provide better user experience. By using our website, you agree to the use of cookies.

Pandao CMS pro - 3.8.0 (Jan 1, 2017)

Replace the following files and execute the queries in your SQL manager to perform the updates.

NEW FEATURES/IMPROVEMENTS

New article status "archived"

/admin/includes/lang.ini
/admin/includes/fn_actions.php
/admin/modules/default/list.php
/admin/modules/default/form.php
/index.php

New model Blog

/common/db.sql
>> new entries in the table pm_text (!replace with your translation and lang ids):

INSERT INTO pm_text (id, lang, name, value) VALUES
(63, 1, 'TAGS', 'Tags'),
(63, 2, 'TAGS', 'Tags'),
(63, 3, 'TAGS', 'Tags'),
(64, 1, 'ARCHIVES', 'Archives'),
(64, 2, 'ARCHIVES', 'Archives'),
(64, 3, 'ARCHIVES', 'Archives');

>> Copy the following PHP script (add the opening php tag at the beginning) in a new file (e.g. update.php) in the root of your website (beside index.php) and execute the script (e.g. in your browser: http//www.mywebsite.tld/update.php), then remove the file:

require("common/lib.php");
require("common/define.php");

$result_lang = $db->query("SELECT id, title FROM pm_lang");
if($result_lang !== false){
    $total_lang = $db->last_row_count();
    $langs = $result_lang->fetchAll(PDO::FETCH_ASSOC);
}
$i = 0;
$id = null;
$i++;
foreach($langs as $lang){
    $data = array();
    $data['id'] = $id;
    $data['lang'] = $lang['id'];
    $data['name'] = "Blog";
    $data['title'] = "Blog";
    $data['title_tag'] = "Blog";
    $data['alias'] = "blog";
    $data['robots'] = "index,follow";
    $data['page_model'] = "blog";
    $data['article_model'] = "article-blog";
    $data['home'] = 0;
    $data['checked'] = 1;
    $data['rank'] = 2;
    $data['add_date'] = 1482486274;
    
    $result_insert = db_prepareInsert($db, "pm_page", $data);
    if($result_insert !== false){
        if($result_insert->execute() !== false) $id = $db->lastInsertId();
    }
}
echo "$i pages successfully inserted!";

if(!is_null($id)){
    $page_id = $id;
    $i = 0;
    $id = null;
    $i++;
    foreach($langs as $lang){
        $data = array();
        $data['id'] = $id;
        $data['lang'] = $lang['id'];
        $data['title'] = "Blog side";
        $data['showtitle'] = 0;
        $data['pos'] = "right";
        $data['allpages'] = 0;
        $data['pages'] = $page_id;
        $data['type'] = "blog_side";
        $data['home'] = 0;
        $data['checked'] = 1;
        $data['rank'] = 5;
        
        $result_insert = db_prepareInsert($db, "pm_widget", $data);
        if($result_insert !== false){
            if($result_insert->execute() !== false) $id = $db->lastInsertId();
        }
    }
    echo "$i widgets successfully inserted!";
}

/common/lib.php
/templates/default/models/blog.php
/templates/default/models/article-blog.php
/templates/default/common/get_articles_blog.php
/templates/default/widgets/blog_side.php

Modules ranking

/admin/modules/social/config.xml
/admin/includes/config.xsd
/admin/includes/inc_top.php
/admin/includes/inc_header_common.php
/admin/includes/fn_form.php

FIXED ISSUES

Underline missing in CKEditor

/admin/js/plugins/ckeditor/config.js

Special caracters escaped

/admin/setup.php
/admin/settings.php

Latest articles layout in the footer

/templates/default/widgets/latest_articles.php