ChFaceBookConnectDb.php

Go to the documentation of this file.

<?php
 
ch_import('ChWsbConnectDb');
 
class ChFaceBookConnectDb extends ChWsbConnectDb
{
    function __construct(&$oConfig)
    {
        parent::__construct($oConfig);
    }
 
    function _processBigNumber($mValue)
    {
        return preg_replace('/[^0-9]/', '', $mValue);
    }
 
    function getProfileId($iFbUid)
    {
        $iFbUidCopy = (int) $iFbUid;
        $iFbUid = $this -> _processBigNumber($iFbUid);
 
 
        //-- handle 64 bit number on 32bit system ( will need remove it in a feature version)--//
        if($iFbUidCopy != $iFbUid) {
            //update id
            $sQuery = "UPDATE `{$this -> sTablePrefix}accounts` SET `fb_profile` = '{$iFbUid}'
                WHERE `fb_profile` = '{$iFbUidCopy}'";
 
            $this -> query($sQuery);
        }
        //--
 
        //-- new auth method --//
        $sQuery = "SELECT `id_profile` FROM `{$this -> sTablePrefix}accounts` WHERE
            `fb_profile` = '{$iFbUid}' LIMIT 1";
 
        $iProfileId = $this -> getOne($sQuery);
        //--
 
        return $iProfileId;
    }
 
    function saveRemoteId($iProfileId, $iFbUid)
    {
        $iFbUid = $this -> _processBigNumber($iFbUid);
        $iProfileId = (int) $iProfileId;
 
        $sQuery = "REPLACE INTO `{$this -> sTablePrefix}accounts`
                    SET `id_profile` = {$iProfileId}, `fb_profile` = '{$iFbUid}'";
 
        $this -> query($sQuery);
    }
 
    function deleteRemoteAccount($iProfileId)
    {
        $iProfileId = (int) $iProfileId;
        $sQuery = "DELETE FROM `{$this -> sTablePrefix}accounts`
            WHERE `id_profile` = {$iProfileId}";
 
        $this -> query($sQuery);
    }
}