<?php

/***************************************************************************
*                            Dolphin Smart Community Builder
*                              -----------------
*     begin                : Mon Mar 23 2006
*     copyright            : (C) 2006 BoonEx Group
*     website              : http://www.boonex.com/
* This file is part of Dolphin - Smart Community Builder
*
* Dolphin is free software. This work is licensed under a Creative Commons Attribution 3.0 License. 
* http://creativecommons.org/licenses/by/3.0/
*
* Dolphin is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
* without even the implied warranty of  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
* See the Creative Commons Attribution 3.0 License for more details. 
* You should have received a copy of the Creative Commons Attribution 3.0 License along with Dolphin, 
* see license.txt file; if not, write to marketing@boonex.com
***************************************************************************/

require_once(BX_DIRECTORY_PATH_INC . 'db.inc.php');

define('SHARED_SITES_TABLE', 'sys_shared_sites');
define('SHARED_SITES_CACHE', 'sys_shared_sites.inc');

function getSitesArray ($sLink) {
    $sLink = htmlentities(($sLink));
    if ( file_exists(BX_DIRECTORY_PATH_CACHE . SHARED_SITES_CACHE) && filesize(BX_DIRECTORY_PATH_CACHE . SHARED_SITES_CACHE) )
        $aSites = unserialize( file_get_contents(BX_DIRECTORY_PATH_CACHE . SHARED_SITES_CACHE) );
    else {
        $aSites = array();
        // cache is empty | load data from DB
        $sqlQuery  = "SELECT * FROM `" . SHARED_SITES_TABLE . "`";
        $rResult = db_res($sqlQuery);
        if (mysql_num_rows($rResult) > 0) {
            while( $aRow = mysql_fetch_assoc($rResult) ) {
                $aSites[$aRow['Name']] = array(
                    'id'    => $aRow['ID'],
                    'url' => $aRow['URL'],
                    'icon'  => $aRow['Icon'],
                );
            }
            // write data into cache file
            $fHandle = fopen(BX_DIRECTORY_PATH_CACHE . SHARED_SITES_CACHE, 'w'); 
            fwrite($fHandle, serialize($aSites));
            fclose($fHandle);
        }    
    }
    
    foreach ($aSites as $sKey => $aValue)
    	$aSites[$sKey]['url'] .= $sLink;
    
	return $aSites;
}

?>