source: trunk/home/mylinks.php @ 1874

<?php
require_once( dirname(__file__) . '/../common/omconfig.php' );
//require_once( FS_COMMON_SKIN_DIRECTORY . '/common.php' );
require_once( FS_COMMON_DIRECTORY.'/utils.php');
//require_once('includes/config.php');
require_once ('includes/classes/DB.php' );

class myLinks {

        private $bIsLoggedOn;
        private $oDb;   //Wiki DB Connection

        public function __construct(){

                $this->bIsLoggedOn = GetLoggedInStateFromWikiCookies();

                $this->oDb          = &newDb( 'wiki',true );
                if( $this->bIsLoggedOn ){
                        $this->iUserId      = $_COOKIE[ OMWIKI_DATABASE_NAME . '_' . OMWIKI_DB_TABLE_PREFIX . 'UserID' ];
                        $this->sUserName    = $_COOKIE[ OMWIKI_DATABASE_NAME . '_' . OMWIKI_DB_TABLE_PREFIX . 'UserName' ];
                }
        }
        
        public function isLoggedOn(){
                return $this->bIsLoggedOn;
        }

        public function loadlinks(){
                echo $this->loaddata($this->iUserId); // Get limited links of user_id
        }

        public function savelinks($url, $title){
                //$title = $this->getUrlTitle($url); // Get title by using url
                // If it is already registered url, remove original and enter again. (to put it top)
                $sSql = "DELETE FROM " . OMWIKI_DB_TABLE_PREFIX . "user_mylinks WHERE user_id='" . $this->iUserId . "' AND url='" . $url . "' AND title='" . $title . "'";
                $rows = $this->oDb->ExecuteSql($sSql);
                
                // Register url data to database
                $sSql = "INSERT INTO ". OMWIKI_DB_TABLE_PREFIX . "user_mylinks(user_id,url,title,registered_date) VALUES('" . $this->iUserId . "', '" . $url . "', '" . $title . "', '" . date("YmdHis") . "')";
                $rows = $this->oDb->ExecuteSql($sSql);

                echo $this->loaddata($this->iUserId);
        }

        public function deletelinks($articleurl) {
                $sSql = "DELETE FROM " . OMWIKI_DB_TABLE_PREFIX . "user_mylinks WHERE user_id='" . $this->iUserId . "' AND url='" . $articleurl . "'";
                $rows = $this->oDb->ExecuteSql($sSql);
                
                echo $this->loaddata($this->iUserId);
        }
        
        public function loaddata() {
                $sSql = "SELECT * FROM ". OMWIKI_DB_TABLE_PREFIX . "user_mylinks WHERE user_id='" . $this->iUserId . "' ORDER BY registered_date DESC LIMIT 5";
                $rows = $this->oDb->GetRows( $sSql );
                if (count($rows) > 0) {
                        $html = '';
                        for ($i=0; $i<count($rows); $i++) {
                                $html .= '<div>&bull;&nbsp;<a href="' . $rows[$i]['url'] . '">' . $rows[$i]['title'] . '</a><br /></div>';
                        }
                        return $html;
                } else {
                        return "false";
                }
        }

        public function getUrlTitle($url) {
                $fd = @fopen($url, 'r');
                if ($fd) {
                        $html = fread($fd, 1750);
                        fclose($fd);

                        // Get title from title tag
                        preg_match_all('/<title>(.*)<\/title>/si', $html, $matches);
                        $title = $matches[1][0];

                        // Get encoding from charset attribute
                        preg_match_all('/<meta.*charset=([^;"]*)">/i', $html, $matches);
                        $encoding = strtoupper($matches[1][0]);

                        // Convert to UTF-8 from the original encoding
                        if (function_exists('mb_convert_encoding') ) {
                                $title = @mb_convert_encoding($title, 'UTF-8', $encoding);
                        }

                        if (mb_strlen($title, 'utf-8') > 0) {
                                return $title;
                        } else {
                                // No title, so return filename
                                $uriparts = explode('/', $url);
                                $filename = end($uriparts);
                                unset($uriparts);

                                return $filename;
                        }
                } else {
                        return false;
                }
        }
}

$mylinks = new myLinks();

if( $mylinks->isLoggedOn()&&isset($_GET['action']) ){

        $action = $_GET['action'];
        if ($action == 'savelinks'){
                $url = mysql_escape_string($_GET['url']);
                $title = mysql_escape_string($_GET['title']);
                $mylinks->savelinks($url, $title);
        }
        if ($action == 'loadlinks'){
                $mylinks->loadlinks();
        }
        if ($action == 'deletelinks') {
                $articleurl = mysql_escape_string($_GET['url']);
                $mylinks->deletelinks($articleurl);
        }
}
?>