PHP-Fusion Facebook Connect Entegrasyonu [BETA]

define("FB_API_KEY","facebookapikeyhere");
define("FB_SECRET","facebooksecretkeyhere");

<?php
$soul=dbquery("ALTER TABLE ".DB_USERS." ADD user_fb_userid BIGINT(16) UNSIGNED NOT NULL DEFAULT '0'");
$soul=dbquery("ALTER TABLE ".DB_USERS." ADD user_fb_hash VARCHAR(32) NOT NULL DEFAULT ''");
$soul=dbquery("ALTER TABLE ".DB_SETTINGS." ADD facebook_salt VARCHAR(32) NOT NULL DEFAULT ''");
$soul=dbquery("UPDATE ".DB_SETTINGS." SET facebook_salt='".md5(rand(0,9999999))."'");
?>

$user_pass = md5($_POST['user_pass']);

if (isset($_POST['user_fb_hash'])) { $user_pass = $_POST['user_fb_hash']; } else if (isset($_POST['user_pass'])) { $user_pass = md5($_POST['user_pass']); }

$cookie_value = $data['user_id'].".".$user_pass;
Üzerine Ekleyin:
        //update facebook hash if not done yet
        if ($data['user_fb_hash']=="") { $result2=dbquery("UPDATE ".DB_USERS." SET user_fb_hash='".md5($data['user_password'])."' WHERE user_id='".$data['user_id']."'"); }    
        //update facebook hash

if (isset($_POST['login']) && isset($_POST['user_name']) && isset($_POST['user_pass'])) {

if (isset($_POST['login']) && isset($_POST['user_name']) && (isset($_POST['user_pass']) || isset($_POST['user_fb_hash']))) {

    $result = dbquery("SELECT * FROM ".DB_USERS." WHERE user_name='".$user_name."' AND user_password='".md5($user_pass)."' LIMIT 1");

if (isset($_POST['user_fb_hash'])) {
        $result = dbquery("SELECT * FROM ".DB_USERS." WHERE user_name='".$user_name."' AND user_fb_hash='".facebook_crypt($_POST['user_fb_hash'])."' LIMIT 1");
    } else {
        $result = dbquery("SELECT * FROM ".DB_USERS." WHERE user_name='".$user_name."' AND user_password='".md5($user_pass)."' LIMIT 1");    
    }

$result = dbquery("SELECT * FROM ".DB_USERS." WHERE user_id='$cookie_1' AND user_password='".md5($cookie_2)."' LIMIT 1");

$result = dbquery("SELECT * FROM ".DB_USERS." WHERE user_id='$cookie_1' AND (user_password='".md5($cookie_2)."' OR user_fb_hash='".facebook_crypt($cookie_2)."') LIMIT 1");

// Initialise the $locale array
$locale = array();
Üzerine Ekleyin:
//this function is to inprove security of user_fb_hash column.
function facebook_crypt($string) {
global $settings;
    return md5($string.$settings['facebook_salt']);
}
//function end

$new_pass = " user_password='".md5(md5($user_new_password))."', ";

$new_pass = " user_password='".md5(md5($user_new_password))."', user_fb_hash='".facebook_crypt(md5(md5($user_new_password)))."'";

if ($user_new_password) { $new_pass = " user_password='".md5(md5($user_new_password))."', "; } else { $new_pass = " "; }

if ($user_new_password) { $new_pass = " user_password='".md5(md5($user_new_password))."', user_fb_hash='".facebook_crypt(md5(md5($user_new_password)))."'"; } else { $new_pass = " "; }