Aide pour bridger des tables utilisateurs de 2 cms

SELECT id,user,name,email,password
FROM _table1_users
UNION
SELECT id as uid, uname as user, uname as name, pass as password
FROM table2_users

MySQL déclare:
Unknown column 'id' in 'field list'

Erreur de demande:
SELECT id,user,name,email,password FROM table1_users UNION SELECT id as uid, uname as user, uname as name, pass as password FROM table2_users LIMIT 0, 30;

SELECT id,user,name,email,password 
FROM table1_users
 UNION 
SELECT id as uid, uname as user, uname as name, pass as password 
FROM table2_users 
LIMIT 0, 30;

Je pensait qu'une nouvelle table avec un nom différent (`users UNION` comme mentionné au dessus) avait peut-être été créé mais non.

ais quand j'essaye de me connecter avec un des scripts il me dit que l'utilisateur n'existe pas.

<?php
if (empty($global['systemRootPath'])) {
    $global['systemRootPath'] = '../';
}
require_once $global['systemRootPath'] . 'videos/configuration.php';
require_once $global['systemRootPath'] . 'objects/bootGrid.php';

class User {

    private $id;
    private $user;
    private $name;
    private $email;
    private $password;
    private $isAdmin;
    private $canStream;
    private $canUpload;
    private $status;
    private $photoURL;
    private $backgroundURL;
    private $recoverPass;
    private $userGroups = array();

    function __construct($id, $user = "", $password = "") {
        if (empty($id)) {
            // get the user data from user and pass
            $this->user = $user;
            if ($password !== false) {
                $this->password = $password;
            } else {
                $this->loadFromUser($user);
            }
        } else {
            // get data from id
            $this->load($id);
        }
    }

    function getEmail() {
        return $this->email;
    }

    function getUser() {
        return $this->user;
    }
    function getPassword() {
        return $this->password;
    }
    function getCanStream() {
        return $this->canStream;
    }
    function setCanStream($canStream) {
        $this->canStream = $canStream;
    }
    function getCanUpload() {
        return $this->canUpload;
    }

    function setCanUpload($canUpload) {
        $this->canUpload = $canUpload;
    }

private function load($id) {
        $user = self::getUserDb($id);
        if (empty($user))
            return false;
        foreach ($user as $key => $value) {
            $this->$key = $value;
        }
        return true;
    }

    private function loadFromUser($user) {
        $user = self::getUserDbFromUser($user);
        if (empty($user))
            return false;
        foreach ($user as $key => $value) {
            $this->$key = $value;
        }
        return true;
    }

    function loadSelfUser() {
        $this->load($this->getId());
    }

    static function getId() {
        if (self::isLogged()) {
            return $_SESSION['user']['id'];
        } else {
            return false;
        }
    }

    function getBdId() {
        return $this->id;
    }

    static function updateSessionInfo() {
        if (self::isLogged()) {
            $user = self::getUserDb($_SESSION['user']['id']);
            $_SESSION['user'] = $user;
        }
    }

    static function getName() {
        if (self::isLogged()) {
            return $_SESSION['user']['name'];
        } else {
            return false;
        }
    }

    static function getUserName() {
        if (self::isLogged()) {
            return $_SESSION['user']['user'];
        } else {
            return false;
        }
    }    
    /**

• return an name to identify the user * @return String */ static function getNameIdentification(){ if(self::isLogged()){ if(!empty(self::getName())){ return self::getName(); } if(!empty(self::getMail())){ return self::getMail(); } if(!empty(self::getUserName())){ return self::getUserName(); } } return __("Unknown User"); } /** * return an name to identify the user from database * @return String */ function getNameIdentificationBd(){ if(!empty($this->name)){ return $this->name; } if(!empty($this->email)){ return $this->email; } if(!empty($this->user)){ return $this->user; } return __("Unknown User"); } static function getUserPass() { if (self::isLogged()) { return $_SESSION['user']['password']; } else { return false; } } function _getName(){ return $this->name; } static function getPhoto($id = "") { global $global; if (!empty($id)) { $user = self::findById($id); if (!empty($user)) { $photo = $user['photoURL']; } } elseif (self::isLogged()) { $photo = $_SESSION['user']['photoURL']; } if(!empty($photo) && preg_match("/videos\/userPhoto\/.*/", $photo)){ $photo = $global['webSiteRootURL'].$photo; } if (empty($photo)) { $photo = $global['webSiteRootURL'] . "img/userSilhouette.jpg"; } return $photo; } static function getMail() { if (self::isLogged()) { return $_SESSION['user']['email']; } else { return false; } } function save($updateUserGroups = false) { global $global; if (empty($this->user) || empty($this->password)) { die('Error : ' . __("You need a user and passsword to register")); } if (empty($this->isAdmin)) { $this->isAdmin = "false"; } if (empty($this->canStream)) { $this->canStream = "false"; } if (empty($this->canUpload)) { $this->canUpload = "false"; } if (empty($this->status)) { $this->status = 'a'; } if (!empty($this->id)) { $sql = "UPDATE users SET user = '{$this->user}', password = '{$this->password}', email = '{$this->email}', name = '{$this->name}', isAdmin = {$this->isAdmin},canStream = {$this->canStream},canUpload = {$this->canUpload}, status = '{$this->status}', photoURL = '{$this->photoURL}', backgroundURL = '{$this->backgroundURL}', recoverPass = '{$this->recoverPass}' , modified = now() WHERE id = {$this->id}"; } else { $sql = "INSERT INTO users (user, password, email, name, isAdmin, canStream, canUpload, status,photoURL,recoverPass, created, modified) VALUES ('{$this->user}','{$this->password}','{$this->email}','{$this->name}',{$this->isAdmin}, {$this->canStream}, {$this->canUpload}, '{$this->status}', '{$this->photoURL}', '{$this->recoverPass}', now(), now())"; } //echo $sql; $insert_row = $global['mysqli']->query($sql); if ($insert_row) { if (empty($this->id)) { $id = $global['mysqli']->insert_id; } else { $id = $this->id; } if ($updateUserGroups) { require_once './userGroups.php'; // update the user groups UserGroups::updateUserGroups($id, $this->userGroups); } return $id; } else { die($sql . ' Error : (' . $global['mysqli']->errno . ') ' . $global['mysqli']->error); } } function delete() { if (!self::isAdmin()) { return false; } // cannot delete yourself if (self::getId() === $this->id) { return false; } global $global; if (!empty($this->id)) { $sql = "DELETE FROM users WHERE id = {$this->id}"; } else { return false; } $resp = $global['mysqli']->query($sql); if (empty($resp)) { die('Error : (' . $global['mysqli']->errno . ') ' . $global['mysqli']->error); } return $resp; } function login($noPass = false, $encodedPass=false) { if ($noPass) { $user = $this->find($this->user, false, true); } else { $user = $this->find($this->user, $this->password, true, $encodedPass); } if ($user) { $_SESSION['user'] = $user; $this->setLastLogin($_SESSION['user']['id']); } else { unset($_SESSION['user']); } } private function setLastLogin($user_id) { global $global; if (empty($user_id)) { die('Error : setLastLogin '); } $sql = "UPDATE users SET lastLogin = now(), modified = now() WHERE id = {$user_id}"; return $global['mysqli']->query($sql); } static function logoff() { unset($_SESSION['user']); } static function isLogged() { return !empty($_SESSION['user']); } static function isAdmin() { return !empty($_SESSION['user']['isAdmin']); } static function canStream() { return !empty($_SESSION['user']['isAdmin']) || !empty($_SESSION['user']['canStream']); } function thisUserCanStream() { return !empty($this->isAdmin) || !empty($this->canStream); } private function find($user, $pass, $mustBeactive = false, $encodedPass=false) { global $global; $user = $global['mysqli']->real_escape_string($user); $sql = "SELECT * FROM users WHERE user = '$user' "; if ($mustBeactive) { $sql .= " AND status = 'a' "; } if ($pass !== false) { if (!$encodedPass || $encodedPass === 'false') { $pass = md5($pass); } $sql .= " AND password = '$pass' "; } $sql .= " LIMIT 1"; $res = $global['mysqli']->query($sql); if ($res) { $user = $res->fetch_assoc(); } else { $user = false; } return $user; } static private function findById($id) { global $global; $sql = "SELECT * FROM users WHERE id = '$id' LIMIT 1"; $res = $global['mysqli']->query($sql); if ($res) { $user = $res->fetch_assoc(); } else { $user = false; } return $user; } static private function getUserDb($id) { global $global; $id = intval($id); $sql = "SELECT * FROM users WHERE id = $id LIMIT 1"; $res = $global['mysqli']->query($sql); if ($res) { $user = $res->fetch_assoc(); } else { $user = false; } return $user; } static private function getUserDbFromUser($user) { global $global; $sql = "SELECT * FROM users WHERE user = '$user' LIMIT 1"; $res = $global['mysqli']->query($sql); if ($res) { $user = $res->fetch_assoc(); } else { $user = false; } return $user; } function setUser($user) { $this->user = strip_tags($user); } function setName($name) { $this->name = strip_tags($name); } function setEmail($email) { $this->email = strip_tags($email); } function setPassword($password) { if (!empty($password)) { $this->password = md5($password); } } function setIsAdmin($isAdmin) { if (empty($isAdmin) || $isAdmin === "false") { $isAdmin = "false"; } else { $isAdmin = "true"; } $this->isAdmin = $isAdmin; } function setStatus($status) { $this->status = strip_tags($status); } function getPhotoURL() { return $this->photoURL; } function setPhotoURL($photoURL) { $this->photoURL = strip_tags($photoURL); } static function getAllUsers() { if (!self::isAdmin()) { return false; } //will receive //current=1&rowCount=10&sort[sender]=asc&searchPhrase= global $global; $sql = "SELECT * FROM users WHERE 1=1 "; $sql .= BootGrid::getSqlFromPost(array('name', 'email', 'user')); $res = $global['mysqli']->query($sql); $user = array(); require_once $global['systemRootPath'] . 'objects/userGroups.php'; if ($res) { while ($row = $res->fetch_assoc()) { $row['groups'] = UserGroups::getUserGroups($row['id']); $row['tags'] = self::getTags($row['id']); $user[] = $row; } //$user = $res->fetch_all(MYSQLI_ASSOC); } else { $user = false; die($sql . '\nError : (' . $global['mysqli']->errno . ') ' . $global['mysqli']->error); } return $user; } static function getTotalUsers() { if (!self::isAdmin()) { return false; } //will receive //current=1&rowCount=10&sort[sender]=asc&searchPhrase= global $global; $sql = "SELECT id FROM users WHERE 1=1 "; $sql .= BootGrid::getSqlSearchFromPost(array('name', 'email', 'user')); $res = $global['mysqli']->query($sql); return $res->num_rows; } static function userExists($user) { global $global; $user = $global['mysqli']->real_escape_string($user); $sql = "SELECT * FROM users WHERE user = '$user' LIMIT 1"; $res = $global['mysqli']->query($sql); if ($res->num_rows > 0) { $user = $res->fetch_assoc(); return $user['id']; } else { return false; } } static function createUserIfNotExists($user, $pass, $name, $email, $photoURL, $isAdmin = false) { global $global; $user = $global['mysqli']->real_escape_string($user); if (!$userId = self::userExists($user)) { if (empty($pass)) { $pass = rand(); } $pass = md5($pass); $userObject = new User(0, $user, $pass); $userObject->setEmail($email); $userObject->setName($name); $userObject->setIsAdmin($isAdmin); $userObject->setPhotoURL($photoURL); $userId = $userObject->save(); return $userId; } return false; } function getRecoverPass() { return $this->recoverPass; } function setRecoverPass($recoverPass) { $this->recoverPass = $recoverPass; } static function canUpload() { global $global, $config; if ($config->getAuthCanUploadVideos()) { return self::isLogged(); } if(self::isLogged() && !empty($_SESSION['user']['canUpload'])){ return true; } return self::isAdmin(); } static function canComment() { global $global, $config; if ($config->getAuthCanComment()) { return self::isLogged(); } return self::isAdmin(); } function getUserGroups() { return $this->userGroups; } function setUserGroups($userGroups) { if (is_array($userGroups)) { $this->userGroups = $userGroups; } } function getIsAdmin() { return $this->isAdmin; } function getStatus() { return $this->status; } /** * * @param type $user_id * text * label Default Primary Success Info Warning Danger */ static function getTags($user_id){ $user = new User($user_id); $tags = array(); if ($user->getIsAdmin()) { $obj = new stdClass(); $obj->type = "info"; $obj->text = __("Admin"); $tags[] = $obj; } else { $obj = new stdClass(); $obj->type = "default"; $obj->text = __("Regular User"); $tags[] = $obj; } if ($user->getStatus() == "a") { $obj = new stdClass(); $obj->type = "success"; $obj->text = __("Active"); $tags[] = $obj; } else { $obj = new stdClass(); $obj->type = "danger"; $obj->text = __("Inactive"); $tags[] = $obj; } require_once 'userGroups.php'; $groups = UserGroups::getUserGroups($user_id); foreach ($groups as $value) { $obj = new stdClass(); $obj->type = "warning"; $obj->text = $value['group_name']; $tags[] = $obj; } return $tags; } function getBackgroundURL() { if (empty($this->backgroundURL)) { $this->backgroundURL = "view/img/background.png"; } return $this->backgroundURL; } function setBackgroundURL($backgroundURL) { $this->backgroundURL = strip_tags($backgroundURL); }}