理性．感性．影像

升級步驟：
1.備份資料庫及資料。
2.將lifetype 1.2.1 複進到系統資料夾中，取代原有檔案。
3.修改config/config.properties.php 內容及讀取權限
4.執行wizard.php (瀏覽器）

5.刪除wizard.php

6.修改config檔案權限

新生部落格特有功能及函數修改：
（一）修改 /class/summary/dao/summarystatus.class.php
1.getRecentPicture() 最近上傳的圖片檔案
------------程式--------------
/**
* gets all links in the first blog(blogid=1)
* write by cmchuang in Taipei SNES
* 2006.02.28
*/


function getRecentPicture( )
{
include_once( PLOG_CLASS_PATH."class/gallery/dao/galleryresources.class.php" );

$query = "SELECT * from ".$this->getPrefix()."gallery_resources where resource_type = '".GALLERY_RESOURCE_IMAGE."' order by date DESC LIMIT 0, 12";
$result = $this->Execute( $query );
$recentresources = Array();
$resources = new GalleryResources();

if( !$result ){
return Array();
}

while( $row = $result->FetchRow()) {
$recentresource = $resources->mapRow($row);
array_push( $recentresources, $recentresource );
}

$result->Close();
return $recentresources;
}
--------------------------------------------------------------

2.getRecentAnnounce() 最近公告文章(讀取第一個部落格的第一個類別文章)
-----程式------------
/**
* gets all announce article in the first blog (blogid=1 category=1)
* write by cmchuang at Taipei SNES
*/
function getRecentAnnounce( )
{
include_once( PLOG_CLASS_PATH."class/dao/articles.class.php" );

$query = "select ".$this->getPrefix()."articles.* from ".$this->getPrefix()."article_categories_link left join ".$this->getPrefix()."articles on (".$this->getPrefix()."article_categories_link.article_id = ".$this->getPrefix()."articles.id) where ".$this->getPrefix()."article_categories_link.category_id = 1 ORDER BY ".$this->getPrefix()."articles.date DESC LIMIT 0, 2";
$result = $this->Execute( $query );
$blogs = Array();
$posts = Array();
$articles = new Articles();
if( !$result ){
return Array();
}

while( $row = $result->FetchRow()) {
$post = $articles->mapRow($row);
array_push( $posts, $post );
}

$result->Close();
return $posts;
}

-----------------------------------------------------------
3.getViewedTotal()總瀏覽數
-------程式------------------------------------------------
function getViewedTotal()
{
$query = "SELECT SUM(num_reads) as total FROM ".$this->getPrefix()."articles WHERE blog_id >=0";

$result = $this->Execute( $query );

if (!$result)
return false;

$row = $result->FetchRow();

if (!isset($row["total"]))
return 0;

$result->close();

return $row["total"];
}
---------------------------------------------------------------


4.getTotalPosts() 文章總數
---------------程式------------------
/** write by cmchuang in Taipei SNES
* Retrieves the total number of posts in all blogs
*
* @param blogId The identifier of the blog from which we'd like to fetch the settings
* @return Returns an integer with the number of posts
*/
function getTotalPosts()
{
$query = "SELECT COUNT(*) as total FROM ".$this->getPrefix()."articles WHERE blog_id >=0 AND status = ".POST_STATUS_PUBLISHED;
$result = $this->Execute( $query );

if (!$result)
return false;

$row = $result->FetchRow();

if (!isset($row["total"]))
return false;

$posts = intval($row["total"]);

$result->Close();

return( $posts );
}
----------------------------------------------------

5.getNumofBlogs()網誌總數

----------------------------程式-----------------
/* gets number of blogs in this Suite .. Writen by CMchuang in SNES */
function getNumofBlogs()
{
$query = "SELECT COUNT(*) as total FROM ".$this->getPrefix()."blogs WHERE status = ".BLOG_STATUS_ACTIVE;
$result = $this->Execute( $query );

if (!$result)
return false;

$row = $result->FetchRow();

if (!isset($row["total"]))
return false;

$posts = intval($row["total"]);

$result->Close();

return( $posts );
}

---------------------------------------------------


6.getNumofComments() 迴響總數
-----------------------------程式-----------------------
/* gets number of Comments in this Suite .. Writen by CMchuang in SNES */
function getNumofComments()
{
$query = "SELECT COUNT(*) as total FROM ".$this->getPrefix()."articles_comments WHERE status = ".COMMENT_STATUS_NONSPAM;
$result = $this->Execute( $query );

if (!$result)
return false;

$row = $result->FetchRow();

if (!isset($row["total"]))
return false;

$posts = intval($row["total"]);

$result->Close();

return( $posts );
}

-------------------------------------------------------

(二）修改/class/dao/ bloginfo.class.php

1.getViewedTotal() 網誌總瀏覽數

--------程式---------
/* getViewedTotal
Writen by Cmchuang in SNES 2006.09.10
*/
function getViewedTotal()
{
include_once( PLOG_CLASS_PATH."class/dao/model.class.php" );
$db = new Model();
$query = "SELECT SUM(num_reads) as total FROM ".$db->getPrefix()."articles WHERE blog_id =".$this->getId();

$result = $db->Execute( $query );

if (!$result)
return false;

$row = $result->FetchRow();

if (!isset($row["total"]))
return 0;

$result->close();

return $row["total"];
}
----------------------------------------------------

(三)增加lightbox效果

   (1) 新生部落格已將lightbox放置在/js/lightbox 資料夾中，且於header.template中已加入了以下指令

      <script type="text/javascript" src="http://blog.snes.tp.edu.tw/js/lightbox/js/prototype.js"></script>
      <script type="text/javascript" src="http://blog.snes.tp.edu.tw/js/lightbox/js/scriptaculous.js?load=effects"></script>
      <script type="text/javascript" src="http://blog.snes.tp.edu.tw/js/lightbox/js/lightbox.js"></script>
      <link rel="stylesheet" href="http://blog.snes.tp.edu.tw/js/lightbox/css/lightbox.css" type="text/css" media="screen" />

   (2)修改/js/tinymce/tiny_mce-plog-resourcelist.js

-----tiny_mce-plog-resourcelist.js程式碼(黃色為修改部份)---------

function _generateResourceLink( resourceId, resourceLink, targetLink, resourceName, resourceDesc, resourceType, resourceMimeType )
{
    var htmlCode = '';

  if( resourceType == 1 ) {
                if( targetLink != '' ) {
                    htmlCode = '<a id="res_'+resourceId+ '" rel="lightbox[roadtrip]" title="'+resourceDesc+'" href="'+targetLink+'" type="'+resourceMimeType+'">';
                    htmlCode += '<img style="margin: 5px;" border="0" alt="'+resourceDesc+'" src="'+resourceLink+'" />';^M
                    htmlCode += '</a>';
            }
------------------------------------------------------------------