İçeriğe geç
ShiftDelete.Net
Haber ara/ SDN'ye SorGiriş
Haber Akışı SDNTV İnceleme Forum Yapay Zeka Akıllı Telefon Elektrikli Otomobil Oyun ShiftDelete.Net Global Teknoloji Haberleri Mobil Otomobil Donanım Savunma Bilim Sosyal Medya İnternet Giyilebilir Teknoloji Rehber Ürünler Son dakika Yazarlar
  1. Ana sayfa
  2. Topluluk
  3. Webmaster Dünyası
  4. Web Tasarımı
Web Tasarımı

MySQL sorunu

TRcowboy10.09.20141 cevap8.915 görüntüleme
2014'den beri29 mesaj
#1
Forumuma Cometchat eklentisini kurdum , install.php ' ye girince bu hata çıkıyor :





cometchat/integration.php kodları :
<?php


/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////


/* ADVANCED */


define('SET_SESSION_NAME','');            // Oturum adı
define('DO_NOT_START_SESSION','0');        // Set to 1 if you have already started the session
define('DO_NOT_DESTROY_SESSION','0');    // Set to 1 if you do not want to destroy session on logout
define('SWITCH_ENABLED','1');        
define('INCLUDE_JQUERY','1');    
define('FORCE_MAGIC_QUOTES','0');


/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////


/* DATABASE */






include_once dirname(dirname(__FILE__))."/includes/config.php";


// DO NOT EDIT DATABASE VALUES BELOW
// DO NOT EDIT DATABASE VALUES BELOW
// DO NOT EDIT DATABASE VALUES BELOW


define('DB_SERVER',                    $config['MasterServer']['servername']    );
define('DB_PORT',                    $config['MasterServer']['port']            );
define('DB_USERNAME',                $config['MasterServer']['username']        );
define('DB_PASSWORD',                $config['MasterServer']['password']        );
define('DB_NAME',                    $config['Database']['dbname']            );
define('TABLE_PREFIX',                $config['Database']['tableprefix']        );
define('DB_USERTABLE',                'user'                                    );
define('DB_USERTABLE_NAME',            'username'                                );
define('DB_USERTABLE_USERID',        'userid'                                );
define('DB_USERTABLE_LASTACTIVITY',    'lastactivity'                            );


/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////


/* FUNCTIONS */


function getUserID() {
    $userid = 0;
    global $config;


    $cookie = $config['Misc']['cookieprefix'].'sessionhash';


    if (!empty($_COOKIE[$cookie])) {
        $sql = ("select userid from ".TABLE_PREFIX."session where sessionhash = '".mysql_real_escape_string($_COOKIE[$cookie])."'");
        $query = mysql_query($sql);
        $session = mysql_fetch_array($query);
        $userid = $session['userid'];
    }


    $cookie = $config['Misc']['cookieprefix'].'_sessionhash';


    if (!empty($_COOKIE[$cookie])) {
        $sql = ("select userid from ".TABLE_PREFIX."session where sessionhash = '".mysql_real_escape_string($_COOKIE[$cookie])."'");
        $query = mysql_query($sql);
        $session = mysql_fetch_array($query);
        $userid = $session['userid'];
    }


    return $userid;
}


function getFriendsList($userid,$time) {


    $sql = ("select DISTINCT ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." userid, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_NAME." username, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_LASTACTIVITY." lastactivity, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." avatar, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." link, cometchat_status.message, cometchat_status.status from ".TABLE_PREFIX."userlist join ".TABLE_PREFIX.DB_USERTABLE." on  ".TABLE_PREFIX."userlist.relationid = ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." left join cometchat_status on ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." = cometchat_status.userid where ".TABLE_PREFIX."userlist.friend = 'yes' and ".TABLE_PREFIX."userlist.userid = '".mysql_real_escape_string($userid)."' order by username asc");


    if (defined('DISPLAY_ALL_USERS') && DISPLAY_ALL_USERS == 1) {


        $sql = ("select DISTINCT ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." userid, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_NAME." username, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_LASTACTIVITY." lastactivity, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." avatar, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." link, cometchat_status.message, cometchat_status.status from ".TABLE_PREFIX.DB_USERTABLE." left join cometchat_status on ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." = cometchat_status.userid where ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." <> '".mysql_real_escape_string($userid)."' and ('".$time."'-lastactivity < '".((ONLINE_TIMEOUT)*2)."') and (cometchat_status.status IS NULL OR cometchat_status.status <> 'invisible' OR cometchat_status.status <> 'offline') order by username asc");


    }
    
    return $sql;
}


function getUserDetails($userid) {
    $sql = ("select ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." userid, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_NAME." username, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_LASTACTIVITY." lastactivity,  ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." link,  ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." avatar, cometchat_status.message, cometchat_status.status from ".TABLE_PREFIX.DB_USERTABLE." left join cometchat_status on ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." = cometchat_status.userid where ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." = '".mysql_real_escape_string($userid)."'");
    return $sql;
}


function updateLastActivity($userid) {
    $sql = ("update `".TABLE_PREFIX.DB_USERTABLE."` set ".DB_USERTABLE_LASTACTIVITY." = '".getTimeStamp()."' where ".DB_USERTABLE_USERID." = '".mysql_real_escape_string($userid)."'");
    return $sql;
}


function getUserStatus($userid) {
     $sql = ("select cometchat_status.message, cometchat_status.status from cometchat_status where userid = '".mysql_real_escape_string($userid)."'");
     return $sql;
}


function getLink($link) {
    return BASE_URL."../member.php?u=".$link;
}


function getAvatar($image) {
    return BASE_URL."../ccpic.php?userid=".$image;
}


function getTimeStamp() {
    return time();
}


function processTime($time) {
    return $time;
}


function processName($name) {
//    For vBulletin users ONLY
//    Uncomment the next two lines and change only ISO-8859-9 to your site encoding type


//    $name = iconv("ISO-8859-9", "ISO-8859-9", $name);
//    $name = iconv("ISO-8859-9", "ISO-8859-9", $name);


    return $name;
}


/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////


/* HOOKS */


function hooks_statusupdate($userid,$unsanitizedmessage) {
    
}


function hooks_forcefriends() {
    
}


function hooks_activityupdate($userid,$unsanitizedstatus) {


}


function hooks_message($fromid,$toid,$unsanitizedmessage) {
    
}


function hooks_displaybar($currentstate) {
    return $currentstate;
}


/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////


/* LICENSE */


include_once(dirname(__FILE__).'/license.php');
$x="\x62a\x73\x656\x34\x5fd\x65c\157\144\x65";
eval($x('JHI9ZXhwbG9kZSgnLScsJGxpY2Vuc2VrZXkpOyRwXz0wO2lmKCFlbXB0eSgkclsyXSkpJHBfPWludHZhbChwcmVnX3JlcGxhY2UoIi9bXjAtOV0vIiwnJywkclsyXSkpOw'));


///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// 
Cevaplar
2013'den beri4 mesaj
#2
İzinlerini 777 Yap

Cevabını yaz

Cevap yazmak için giriş yap ya da üye ol. Eski forum kullanıcı adın ve parolanla girebilirsin.