/**
 * @author NORGUET Thibaud
 */
var v_x;
var v_y;
$(document).ready(function(){
    f_detecteTailleEcran();
    f_dimentionne();
}); //--- Fin de $(document).ready…
/*    ______________________ Événements ___
 /____________________________________/
 */
$(window).resize(function(){
    f_detecteTailleEcran();
    f_dimentionne();
});

/*     _____________________________________________________________ Fonctions ___
 /                                                                          /
 /__________________________________________________________________________/
 __________ f_detecteTailleEcran() ___
 /____________________________________/
 */
function f_detecteTailleEcran(){
    v_x = document.body.clientWidth; // || window.innerWidth || self.innerWidth;
    if (self.innerHeight) {
        v_y = self.innerHeight; // tous sauf IE
    }
    else 
        if (document.documentElement && document.documentElement.clientHeight) {
            v_y = document.documentElement.clientHeight; // IE6 Strict Mode
        }
        else 
            if (document.body) {
                v_y = document.body.clientHeight; // Autre IE
            }
}

/*    _ FIN ____ f_detecteTailleEcran() ___
 /____________________________________/
 _________________ f_dimentionne() ___
 /____________________________________/
 */
function f_dimentionne(){
    var v_yContenuC;
    
    v_yContenuC = v_y + "px";
    v_xFooter = (v_x / 2) - 300 + "px";
    
    $('#content').css({
        "min-height": v_yContenuC
    });
    
    $('#footer').css({
        "margin-left": v_xFooter
    });
}

/*    _ FIN ___________ f_dimentionne() ___
 /____________________________________/
 */
/*  /__________________________________________________________________________/
 __________ Infobulle___
 /____________________________________/
 */
//affiche le rectangle flottant du onmousemove
var _id_Guild;
var IdInstance;
function f_affiche(_nom){
    document.getElementById("rect").style.left = m_x + 15 + "px";
    document.getElementById("rect").style.top = m_y + "px";
    document.getElementById("rect").style.visibility = "visible";
    document.getElementById("rect").innerHTML = _nom;
}

//cache le rectangle du onmousemove
function f_cache(){
    document.getElementById("rect").style.visibility = "hidden";
    document.getElementById("rect").innerHTML = "";
}

/*    _ FIN ___________ Infobulle ___
 
 /____________________________________/
 
 */
function maGuilde(_id){
    _id_Guild = _id;
    $("#main").load("./php/load_guilde.php", {
        "id_guilde": _id
    });
}

function sonAvancee(_id_guilde){
    var _html = "<h1>Edition Avancée</h1><br /><form action='' onsubmit='editAvancee(); return false;'>";
    _html += "</form><div id='div_instance'></div><div id='chargement'></div><div id='boss_instance'></div>";
    $('#main').html(_html);
    _id_Guild = _id_guilde;
    $.getJSON("./php/select.php", {
        "quoi": "instances",
        "nb_joueur": "25"
    }, function(json){
    
        var _chaine = '<select name="instance" onchange="loadKill(this.value)"><option value="">Choisir une instance</option>';
        
        for (var i = 0; i < json.length; i++) {
        
            _chaine += '<option value="' + json[i]["id_instance"] + '">' + json[i]["nom_instance"] + '</option>';
        }
        
        _chaine += '</select>';
        
        $("#div_instance").html(_chaine);
    });
}

function combatLog(_pos){
    $("#main").load("./php/load_log.php", {
        "pos": _pos
    });
}

var _nb_boss;
function add(_quoi){
    if (_quoi == "instance") {
        var _html = "<h1>Nouvelle instance</h1><br /><form action='' onsubmit='saveAdd(\"instance\"); return false;'><table border='0'>";
        _html += "<div><tr><td>Nom de l'instance &nbsp; </td><td><input type='text' id='nom_instance' id= size='15' onblur='testBoss(\"nom\");'></td></tr>";
        _html += "<tr><td>Nombre de boss &nbsp;</td><td> <input type='text' id='nombre_boss' size='5' onblur='addBoss();'></td></tr></div>";
        _html += "<div id='nb_boss'></div></table></form>";
        $('#main').html(_html);
    }
    else 
        if (_quoi == "guilde") {
            var _html = "<h1>Nouvelle Guilde</h1><br /><form action='' onsubmit='saveAdd(\"guilde\"); return false;'><table border='0'>";
            _html += "<tr><td colspan='2'><select id='faction'><option value=''>Faction</option><option value='ALLY'>Alliance</option><option value='HORD'>Horde</option></select></td></tr><tr><td>Nom de la guilde &nbsp; </td><td><input type='text' id='nom_guilde' id= size='15' onblur='testGuilde(\"nom_guilde\");'></td></tr>";
            _html += "<tr><td>Diminutif </td><td> <input type='text' id='diminutif' size='20' onblur='testGuilde(\"diminutif\");'></td></tr>";
            _html += "<tr><td>Site internet </td><td><input type='text' id='site' size='20' onblur='testGuilde(\"site\");' value='http://'></td></tr>";
            _html += "<tr><td>Données </td><td><textarea id='data' cols='30' rows='10'>Nom : \rSite : \rObjectifs : \r </textarea></td></tr>";
            _html += "<tr><td></td><td><input type='submit' value='Enregistrer'></td></tr></table></form>";
            $('#main').html(_html);
        }
        else 
            if (_quoi == "user") {
                var _html = "<h1>Nouvel Utilisateur</h1><br /><form action='' onsubmit='saveAdd(\"user\"); return false;'><table border='0'>";
                _html += "<tr><td colspan='2'><select id='faction' onchange='loadGuilde3(this.value)'><option value=''>Choisir une faction</option><option value='ALLY'>Alliance</option><option value='HORD'>Horde</option></select>";
                _html += "</td></tr><tr><td>Nom de l'utilisateur &nbsp; </td><td><input type='text' id='nom_user' id= size='15' onblur='testUser(\"nom_user\");'></td></tr>";
                _html += "<tr><td>Mot de passe </td><td> <input type='text' id='pass' size='20' onblur='testUser(\"pass\");'></td></tr>";
                _html += "<tr><td>Site internet </td><td><input type='text' id='site' size='20' onblur='testGuilde(\"site\");'></td></tr>";
                _html += "<tr><td>Email </td><td><input type='text' id='mail' size='20' onblur='testUser(\"mail\");'></td></tr></table>";
                _html += "<div id='div_guilde'></div><td><input type='submit' value='Enregistrer'></form>";
                $('#main').html(_html);
                $.ajax({
                    type: "POST",
                    url: "./php/genereMdp.php",
                    success: function(_msg){
                        document.getElementById('pass').value = _msg;
                    }
                });
            }
}

function addBoss(){
    _nb_boss = document.getElementById('nombre_boss').value;
    var _html = "";
    for (var _i = 0; _i < _nb_boss; _i++) {
        _html += "<tr><td>Nom du boss " + _i + " &nbsp; </td><td><input type='text' size='15' id='boss_" + _i + "' onblur='testBoss(\"" + _i + "\");'></td></tr>";
    }
    _html += "<input type='submit'>";
    $('#nb_boss').html(_html);
}

function testBoss(x){
    if (x == "nom") {
        if (document.getElementById("nom_instance").value == "") {
            document.getElementById("nom_instance").style.backgroundColor = "#3366CC";
        }
        else {
            document.getElementById("nom_instance").style.backgroundColor = "white";
        }
    }
    else {
        if (document.getElementById("boss_" + x).value == "") {
            document.getElementById("boss_" + x).style.backgroundColor = "#3366CC";
        }
        else {
            document.getElementById("boss_" + x).style.backgroundColor = "white";
        }
    }
}

function testUser(x){
    if (document.getElementById(x).value == "") {
        document.getElementById(x).style.backgroundColor = "#3366CC";
    }
    else {
        document.getElementById(x).style.backgroundColor = "white";
    }
}

function testGuilde(x){
    if (x == 'mail') {
        var v_mail = document.getElementById("mail").value;
        if (v_mail == "" || v_mail.match(/^[a-z0-9._-]+@[a-z0-9.-]{2,}[.][a-z]{2,3}$/) == null) {
            document.getElementById("mail").style.backgroundColor = "#3366CC";
        }
        else {
            document.getElementById(x).style.backgroundColor = "white";
        }
    }
    if (document.getElementById(x).value == "") {
        document.getElementById(x).style.backgroundColor = "#3366CC";
    }
    else {
        document.getElementById(x).style.backgroundColor = "white";
    }
}

function saveAdd(_quoi){

    if (_quoi == 'instance') {
    
        var tab = new Array;
        
        if (document.getElementById("nom_instance").value == "") {
            tab.push("nom de l'instance invalide");
            document.getElementById("nom_instance").style.backgroundColor = "#3366CC";
        }
        for (var _i = 0; _i < _nb_boss; _i++) {
        
            if (document.getElementById("boss_" + _i).value == "") {
                tab.push("boss " + _i + " invalide");
                document.getElementById("boss_" + _i).style.backgroundColor = "#3366CC";
            }
        }
        
        if (tab.length == 0) {
        
            var _nom = document.getElementById('nom_instance').value;
            var _tab = new Array;
            var _params = '';
            for (var _i = 0; _i < _nb_boss; _i++) {
                _params += "&boss_" + _i + "=" + document.getElementById('boss_' + _i).value;
            }
            $.ajax({
                type: "POST",
                url: "./php/saveInstance.php",
                data: "nom=" + _nom + "&nb_boss=" + _nb_boss + _params,
                success: function(_msg){
                    $('#main').html(_msg);
                }
            });
            
        }
        else {
        
            /*tab = tab.join("\n");
             alert(tab);*/
            return false;
        }
    }
    else 
        if (_quoi == 'guilde') {
        
            var tab = new Array;
            if (document.getElementById("faction").value == "") {
                tab.push("faction de la guilde invalide");
                document.getElementById("faction").style.backgroundColor = "#3366CC";
            }
            if (document.getElementById("nom_guilde").value == "") {
                tab.push("nom de la guilde invalide");
                document.getElementById("nom_guilde").style.backgroundColor = "#3366CC";
            }
            if (document.getElementById("diminutif").value == "") {
                tab.push("diminutif de la guilde invalide");
                document.getElementById("diminutif").style.backgroundColor = "#3366CC";
            }
            if (document.getElementById("site").value == "") {
                tab.push("site de la guilde invalide");
                document.getElementById("site").style.backgroundColor = "#3366CC";
            }
            if (tab.length == 0) {
                var _faction = document.getElementById("faction").value;
                var _nom = document.getElementById('nom_guilde').value;
                var _diminutif = document.getElementById('diminutif').value;
                var _site = document.getElementById('site').value;
                var _datas = document.getElementById('data').value;
                $.ajax({
                    type: "POST",
                    url: "./php/saveGuilde.php",
                    data: "nom=" + _nom + "&faction=" + _faction + "&diminutif=" + _diminutif + "&site=" + _site + "&datas=" + _datas,
                    success: function(_msg){
                        $('#main').html(_msg);
                    }
                });
                
            }
            else {
                /* tab = tab.join("\n");
             alert(tab);*/
                return false;
            }
        }
        else 
            if (_quoi == 'user') {
            
                var tab = new Array;
                if (document.getElementById("faction").value == "") {
                    tab.push("faction de la guilde invalide");
                    document.getElementById("faction").style.backgroundColor = "#3366CC";
                    
                }
                else 
                    if (document.getElementById("guildes").value == "") {
                        tab.push("guilde invalide");
                        document.getElementById("guildes").style.backgroundColor = "#3366CC";
                    }
                if (document.getElementById("nom_user").value == "") {
                    tab.push("nom d'utilisateur invalide");
                    document.getElementById("nom_user").style.backgroundColor = "#3366CC";
                }
                if (document.getElementById("pass").value == "") {
                    tab.push("Mot de passe invalide");
                    document.getElementById("pass").style.backgroundColor = "#3366CC";
                }
                if (document.getElementById("site").value == "") {
                    tab.push("site de la guilde invalide");
                    document.getElementById("site").style.backgroundColor = "#3366CC";
                }
                
                var v_mail = document.getElementById("mail").value;
                if (v_mail == "" || v_mail.match(/^[a-z0-9._-]+@[a-z0-9.-]{2,}[.][a-z]{2,3}$/) == null) {
                    tab.push("Mail invalide");
                    document.getElementById("mail").style.backgroundColor = "#3366CC";
                }
                if (tab.length == 0) {
                    var _guilde = document.getElementById("guildes").value;
                    var _nom = document.getElementById('nom_user').value;
                    var _pass = document.getElementById('pass').value;
                    var _site = document.getElementById('site').value;
                    var _mail = document.getElementById('mail').value;
                    $.ajax({
                        type: "POST",
                        url: "./php/saveUser.php",
                        data: "nom=" + _nom + "&id_guilde=" + _guilde + "&pass=" + _pass + "&site=" + _site + "&mail=" + _mail,
                        success: function(_msg){
                            $('#main').html(_msg);
                        }
                    });
                    
                }
                else {
                    /* tab = tab.join("\n");
             alert(tab);*/
                    return false;
                }
            }
}

function edit(_quoi){
    if (_quoi == "instance") {
        var _html = "<h1>Edition Instances et Boss</h1><br /><form action='' onsubmit=''><div id='div_instance'></div></form><div id='boss_instance'></div>";
        $('#main').html(_html);
        $.getJSON("./php/select.php", {
            "quoi": "instances",
            "nb_joueur": "25"
        }, function(json){
        
            var _chaine = '<select name="couleur" onchange="loadBoss(this.value)"><option value="">Choisir une instance</option>';
            
            for (var i = 0; i < json.length; i++) {
            
                _chaine += '<option value="' + json[i]["id_instance"] + '">' + json[i]["nom_instance"] + '</option>';
            }
            
            _chaine += '</select>';
            
            $("#div_instance").html(_chaine);
        });
    }
    else 
        if (_quoi == "guilde") {
            var _html = "<h1>Edition Guilde</h1><br /><form action='' onsubmit='editGuilde(); return false;'><select id='faction' onchange='loadGuilde(this.value)'><option value=''>Choisir une faction</option><option value='ALLY'>Alliance</option><option value='HORD'>Horde</option></select>";
            _html += "<div id='div_guilde'></div><div id='div_info'></div></form><div id='div_instance'></div><div id='chargement'></div><div id='boss_instance'></div>";
            $('#main').html(_html);
            
        }
        else 
            if (_quoi == "user") {
                var _html = "<h1>Édition Utilisateurs</h1><br /><select id='faction' onchange='loadGuilde5(this.value)'><option value=''>Choisir une faction</option><option value='ALLY'>Alliance</option><option value='HORD'>Horde</option></select>";
                _html += "<div id='div_guilde'></div><div id='div_user'></div>";
                $('#main').html(_html);
                
            }
}

function loadGuilde(_faction){
    $("#div_instance").html("");
    $.getJSON("./php/select.php", {
        "quoi": "guildes",
        "faction": _faction
    }, function(json){
    
        var _chaine = '<select id="guildes" onchange="loadInfoGuilde(this.value)"><option value="">Choisir une guilde</option>';
        
        for (var i = 0; i < json.length; i++) {
            var _nom;
            if (json[i]['nom_guilde'] == null) {
                _nom = json[i]['pseudo_guilde'];
            }
            else {
                _nom = json[i]['nom_guilde'];
            }
            _chaine += '<option value="' + json[i]["id_guilde"] + '">' + _nom + '</option>';
        }
        
        _chaine += '</select>';
        
        $("#div_instance").html(_chaine);
    });
}


function loadInfoGuilde(_id_guilde){
    $("#div_instance").html("")
    _id_Guild = _id_guilde;
    $("#div_info").load("./php/load_guilde.php", {
        "id_guilde": _id_guilde,
        "edit": true
    });
    $.getJSON("./php/select.php", {
        "quoi": "instances",
        "nb_joueur": "25"
    }, function(json){
    
        var _chaine = '<select name="couleur" onchange="loadKill(this.value)"><option value="">Choisir une instance</option>';
        
        for (var i = 0; i < json.length; i++) {
        
            _chaine += '<option value="' + json[i]["id_instance"] + '">' + json[i]["nom_instance"] + '</option>';
        }
        
        _chaine += '</select>';
        
        $("#div_instance").html(_chaine);
    });
}


function mapause(time){
    d = new Date();
    diff = 0;
    while (diff < time) 
        n = new Date();
    diff = n - d;
}

function pausecomp(millis){
    var date = new Date();
    var curDate = null;
    
    do {
        curDate = new Date();
    }
    while (curDate - date < millis);
}

function submitonEnter(evt, id_guilde, _indice, _mode){

    var charCode = (evt.which) ? evt.which : event.keyCode
    if (charCode == "13") {
        _changeKill(_id_Guild, _indice, _mode);
    }
}

function loadKill(_id_instance){
    IdInstance = _id_instance;
    document.getElementById("boss_instance").innerHTML = "";
    document.getElementById("chargement").innerHTML = "";
    
    
    
    $.ajax({
        url: "./php/select.php",
        type: "GET", // GET ou POST
        data: {
            quoi: "boss",
            id_instance: _id_instance,
            id_Guild: _id_Guild
        }, 
        success: function(json){
            //loadOptiKill(json);
            document.getElementById("boss_instance").innerHTML = json;
        }
    });
    
}

function loadOptiKill(json){


    var _boss;
    var _indice;
    _indice = json[0]['id_boss'];
    for (var i = 0; i < json.length; i++) {
        _boss = json[i]['nom_boss'];
        var _j = 0;
        document.getElementById("boss_instance").innerHTML += "<div id='" + json[i]['id_boss'] + "'><div style='width:230px; height:15px; float:left'>" + _boss + " :</div> </div>";
        $.getJSON("./php/select.php", {
            "quoi": "kills",
            "id_boss": json[i]['id_boss'],
            "id_guilde": _id_Guild
        }, function(_json){
        
            if (_json != "") {
                var _check = "checked";
                var _hm = (_json[0]['hm'] == 0) ? "disable" : "checked";
                var _ff = (_json[0]['first_faction'] == 0) ? "disable" : "checked";
                var _fs = (_json[0]['first_server'] == 0) ? "disable" : "checked";
                var _date = _json[0]['date'];
                
            }
            else {
                var _check = "disable";
                var _hm = "disable";
                var _ff = "disable";
                var _fs = "disable";
                var _date = "";
                
            }
            
            //<input type="checkbox" id="" value="' + _json[i]['id_boss'] + '" ' + _droit + ' onmouseup="_changeDroit()">
            var _chaine = 'Tué <input type="checkbox" id="' + _indice + '_kill" value="kill" ' + _check + ' onmouseup="_changeKill(\'' + _id_Guild + '\',\'' + _indice + '\',\'kill\')">';
            _chaine += '&nbsp; &nbsp; HM<input type="checkbox" id="' + _indice + '_hm" value="hm" ' + _hm + ' onmouseup="_changeKill(\'' + _id_Guild + '\',\'' + _indice + '\',\'hm\')">';
            _chaine += '&nbsp; &nbsp; First faction<input type="checkbox" id="' + _indice + '_ff" value="ff" ' + _ff + ' onmouseup="_changeKill(\'' + _id_Guild + '\',\'' + _indice + '\',\'ff\')">';
            _chaine += '&nbsp; &nbsp; First serveur<input type="checkbox" id="' + _indice + '_fs" value="fs" ' + _fs + ' onmouseup="_changeKill(\'' + _id_Guild + '\',\'' + _indice + '\',\'fs\')">';
            _chaine += '&nbsp; &nbsp; Date et heure (aaaa-mm-jj hh-mm-ss)  &nbsp; <input type="text" size="16" id="' + _indice + '_date" value="' + _date + '" onblur="_changeKill(\'' + _id_Guild + '\',\'' + _indice + '\',\'date\')" onKeyDown="return submitonEnter(event,\'' + _id_Guild + '\',\'' + _indice + '\',\'date\');">';
            document.getElementById(_indice).innerHTML += _chaine;
            _indice++;
            
            
        });
        //il faut sleep 1 seconde fs !!
        //pausecomp(500);
        document.getElementById("chargement").innerHTML += "";
    }
    
}

function _changeKill(_id_guilde, _id_boss, _mode){
    if (_mode == "date") {
    
        var _date = document.getElementById(_id_boss + "_date").value;
        
        $.ajax({
            type: "POST",
            url: "./php/addKill.php",
            data: "id_boss=" + _id_boss + "&id_user=" + _ID_user + "&id_guilde=" + _id_guilde + "&mode=" + _mode + "&date=" + _date,
            success: function(){
                loadKill(IdInstance);
                
            }
        });
    }
    else {
        $.ajax({
            type: "POST",
            url: "./php/addKill.php",
            data: "id_boss=" + _id_boss + "&id_user=" + _ID_user + "&id_guilde=" + _id_guilde + "&mode=" + _mode,
            success: function(_msg){
                loadKill(IdInstance);
                document.getElementById("main").innerHTML += _msg;
            }
        });
    }
}

function editGuilde(){
    var _nom = document.getElementById('nom').value;
    var _site = document.getElementById('site').value;
    var _data = document.getElementById('datas').value;
    
    jQuery.ajax({
        type: "POST",
        url: "./php/editGuilde.php",
        data: "nom=" + _nom + "&id_guilde=" + _id_Guild + "&site=" + _site + "&data=" + _data,
        success: function(_rez){
        
            /* $("#div_info").load("./php/load_guilde.php", {
             "id_guilde": _id_Guild,
             "edit": true
             });*/
            $("#main").html(_rez);
        }
    });
}

function del(_quoi){
    if (_quoi == "instance") {
        var _html = "<h1>Suppression Instances</h1><br /><form action='' onsubmit=''><div id='div_instance'></div></form>";
        $('#main').html(_html);
        $.getJSON("./php/select.php", {
            "quoi": "instances",
            "nb_joueur": "25"
        }, function(json){
        
            var _chaine = '<select name="couleur" onchange="delInstance(this.value)"><option value="">Choisir une instance</option>';
            
            for (var i = 0; i < json.length; i++) {
            
                _chaine += '<option value="' + json[i]["id_instance"] + '">' + json[i]["nom_instance"] + '</option>';
            }
            
            _chaine += '</select>';
            
            $("#div_instance").html(_chaine);
        });
    }
    else 
        if (_quoi == "guilde") {
            var _html = "<h1>Suppression Guildes</h1><br /><form action='' onsubmit='editGuilde(); return false;'><select id='faction' onchange='loadGuilde2(this.value)'><option value=''>Choisir une faction</option><option value='ALLY'>Alliance</option><option value='HORD'>Horde</option></select>";
            _html += "<div id='div_guilde'></form>";
            $('#main').html(_html);
            
        }
        else 
            if (_quoi == "user") {
                var _html = "<h1>Suppression Utilisateurs</h1><br /><select id='faction' onchange='loadGuilde4(this.value)'><option value=''>Choisir une faction</option><option value='ALLY'>Alliance</option><option value='HORD'>Horde</option></select>";
                _html += "<div id='div_guilde'></div><div id='div_user'></div>";
                $('#main').html(_html);
                
            }
}

function loadUsers2(_id_guilde){
    $("#div_instance").html("");
    $.getJSON("./php/select.php", {
        "quoi": "users",
        "id_guilde": _id_guilde
    }, function(json){
    
        var _chaine = '<select id="users" onchange="loadUserInfo(this.value)"><option value="">Choisir un utilisteur</option>';
        
        for (var i = 0; i < json.length; i++) {
            _chaine += '<option value="' + json[i]["id_user"] + '">' + json[i]['login'] + '</option>';
        }
        
        _chaine += '</select>';
        
        $("#div_user").html(_chaine);
    });
}

function loadGuilde5(_faction){
    $("#div_instance").html("");
    $.getJSON("./php/select.php", {
        "quoi": "guildes",
        "faction": _faction
    }, function(json){
    
        var _chaine = '<select id="guildes" onchange="loadUsers2(this.value)"><option value="">Choisir une guilde</option>';
        
        for (var i = 0; i < json.length; i++) {
            var _nom;
            if (json[i]['nom_guilde'] == null) {
                _nom = json[i]['pseudo_guilde'];
            }
            else {
                _nom = json[i]['nom_guilde'];
            }
            _chaine += '<option value="' + json[i]["id_guilde"] + '">' + _nom + '</option>';
        }
        
        _chaine += '</select>';
        
        $("#div_guilde").html(_chaine);
    });
}

function loadUsers(_id_guilde){
    $("#div_instance").html("");
    $.getJSON("./php/select.php", {
        "quoi": "users",
        "id_guilde": _id_guilde
    }, function(json){
    
        var _chaine = '<select id="users" onchange="delUser(this.value)"><option value="">Choisir un utilisteur</option>';
        
        for (var i = 0; i < json.length; i++) {
            _chaine += '<option value="' + json[i]["id_user"] + '">' + json[i]['login'] + '</option>';
        }
        
        _chaine += '</select>';
        
        $("#div_user").html(_chaine);
    });
}

function loadGuilde4(_faction){
    $("#div_instance").html("");
    $.getJSON("./php/select.php", {
        "quoi": "guildes",
        "faction": _faction
    }, function(json){
    
        var _chaine = '<select id="guildes" onchange="loadUsers(this.value)"><option value="">Choisir une guilde</option>';
        
        for (var i = 0; i < json.length; i++) {
            var _nom;
            if (json[i]['nom_guilde'] == null) {
                _nom = json[i]['pseudo_guilde'];
            }
            else {
                _nom = json[i]['nom_guilde'];
            }
            _chaine += '<option value="' + json[i]["id_guilde"] + '">' + _nom + '</option>';
        }
        
        _chaine += '</select>';
        
        $("#div_guilde").html(_chaine);
    });
}

function loadGuilde2(_faction){
    $("#div_instance").html("");
    $.getJSON("./php/select.php", {
        "quoi": "guildes",
        "faction": _faction
    }, function(json){
    
        var _chaine = '<select id="guildes" onchange="delGuilde(this.value)"><option value="">Choisir une guilde</option>';
        
        for (var i = 0; i < json.length; i++) {
            var _nom;
            if (json[i]['nom_guilde'] == null) {
                _nom = json[i]['pseudo_guilde'];
            }
            else {
                _nom = json[i]['nom_guilde'];
            }
            _chaine += '<option value="' + json[i]["id_guilde"] + '">' + _nom + '</option>';
        }
        
        _chaine += '</select>';
        
        $("#div_guilde").html(_chaine);
    });
}

function loadGuilde3(_faction){
    $.getJSON("./php/select.php", {
        "quoi": "guildes",
        "faction": _faction
    }, function(json){
    
        var _chaine = '<select id="guildes"><option value="">Choisir une guilde</option>';
        
        for (var i = 0; i < json.length; i++) {
            var _nom;
            if (json[i]['nom_guilde'] == null) {
                _nom = json[i]['pseudo_guilde'];
            }
            else {
                _nom = json[i]['nom_guilde'];
            }
            _chaine += '<option value="' + json[i]["id_guilde"] + '">' + _nom + '</option>';
        }
        
        _chaine += '</select>';
        
        $("#div_guilde").html(_chaine);
    });
}

function delGuilde(_id, x){
    if (x == 0) {
        $.getJSON("./php/select.php", {
            "quoi": "guildes",
            "id_guilde": _id
        }, function(json){
            for (var i = 0; i < json.length; i++) {
                if (confirm("Voulez-vous supprimer la guilde " + json[i]['nom_guilde'] + " ?")) { // Clic sur OK
                    $.ajax({
                        type: "POST",
                        url: "./php/delGuilde.php",
                        data: "id_guilde=" + json[i]['id_guilde'],
                        success: function(_msg){
                            document.location.replace("?p=guilde");
                        }
                    });
                }
            }
        });
    }
    else {
        $.getJSON("./php/select.php", {
            "quoi": "guildes",
            "id_guilde": _id
        }, function(json){
            for (var i = 0; i < json.length; i++) {
                if (confirm("Voulez-vous supprimer la guilde " + json[i]['nom_guilde'] + " ?")) { // Clic sur OK
                    $.ajax({
                        type: "POST",
                        url: "./php/delGuilde.php",
                        data: "id_guilde=" + json[i]['id_guilde'],
                        success: function(_msg){
                            del("guilde");
                            document.getElementById("main").innerHTML += _msg;
                        }
                    });
                }
            }
        });
    }
}

function loadBoss(_value){
    $.getJSON("./php/select.php", {
        "quoi": "boss",
        "id_instance": _value
    }, function(json){
    
        var _html = '';
        
        for (var i = 0; i < json.length; i++) {
        
            _html += '<h3>' + json[i]["nom_boss"] + ' &nbsp; <a onclick="Boss(\'' + json[i]['id_boss'] + '\',\'' + _value + '\',\'edit\'); return false;" href="#" >Modifier</a> | <a onclick="Boss(\'' + json[i]['id_boss'] + '\',\'' + _value + '\',\'del\'); return false;" href="#" >Supprimer</a></h3>';
        }
        
        $("#boss_instance").html(_html);
    });
}

function Boss(_id_boss, _id_instance, x){

    if (x == "del") {
        $.ajax({
            type: "POST",
            url: "./php/delBoss.php",
            data: "id_boss=" + _id_boss,
            success: function(){
                loadBoss(_id_instance);
            }
        });
    }
    else 
        if (x == "edit") {
        
            $.getJSON("./php/editBoss.php", {
                "id_boss": _id_boss
            }, function(json){
                var _html = '<form action="" onsubmit="Boss(\'' + json['id_boss'] + '\',\'' + json['id_instance'] + '\',\'submit\')">Nom : <input type="text" id="nom_boss" value="' + json['nom_boss'] + '"><input type="submit" value="Éditer"></form>';
                document.getElementById("main").innerHTML += _html;
            });
        }
        else 
            if (x == "submit") {
                var _nom = document.getElementById("nom_boss").value;
                if (_nom != "") {
                    $.ajax({
                        type: "POST",
                        url: "./php/editBoss.php",
                        data: "id_boss=" + _id_boss + "&nom=" + _nom,
                        success: function(_msg){
                            loadBoss(_id_instance);
                            document.getElementById("main").innerHTML += _msg;
                        }
                    });
                }
            }
}

function delInstance(id){
    $.getJSON("./php/select.php", {
        "quoi": "instances",
        "id_instance": id
    }, function(json){
        for (var i = 0; i < json.length; i++) {
            if (confirm("Voulez-vous supprimer l'instance " + json[i]['nom_instance'] + " ?")) { // Clic sur OK
                $.ajax({
                    type: "POST",
                    url: "./php/delInstance.php",
                    data: "id_instance=" + json[i]['id_instance'],
                    success: function(_msg){
                        del("instance");
                        document.getElementById("main").innerHTML += _msg;
                    }
                });
            }
        }
    });
}

function delUser(id){
    $.getJSON("./php/select.php", {
        "quoi": "users",
        "id_user": id
    }, function(json){
        for (var i = 0; i < json.length; i++) {
            if (confirm("Voulez-vous supprimer l'utilisateur " + json[i]['login'] + " ?")) { // Clic sur OK
                $.ajax({
                    type: "POST",
                    url: "./php/delUser.php",
                    data: "id_user=" + json[i]['id_user'],
                    success: function(_msg){
                        del("user");
                        document.getElementById("main").innerHTML += _msg;
                    }
                });
            }
        }
    });
}

function loadUserInfo(id){
    $.getJSON("./php/select.php", {
        "quoi": "users",
        "id_user": id
    }, function(json){
        var _html = "";
        for (var i = 0; i < json.length; i++) {
            _html += "<form onsubmit='editUser(\"" + json[i]['id_user'] + "\"); return false;'><table border='0'><tr><td>Nom d'utilisateur</td><td><input type='text' size='25' id='nom' value='" + json[i]['login'] + "'></td></tr>";
            _html += "<tr><td>Mot de passe</td><td><input type='text' size='25' id='pass' value='" + json[i]['pass'] + "'></td></tr>";
            _html += "<tr><td>Email</td><td><input type='text' size='25' id='mail' value='" + json[i]['mail'] + "'></td></tr></table><div id='div_guildes'></div>";
            _html += "<input type='submit' value='Enregistrer'></form>";
        }
        document.getElementById("main").innerHTML += _html;
        $.getJSON("./php/selectGuildes.php", {
            "id_guilde": json[0]['id_guilde']
        }, function(_json){
        
            var _chaine = 'Guilde <select id="guild_name"><option value="">Choisir une guilde</option>';
            
            for (var j = 0; j < _json.length; j++) {
                var _nom;
                var _param;
                if (_json[j]['nom_guilde'] == null) {
                    _nom = _json[j]['pseudo_guilde'];
                }
                else {
                    _nom = _json[j]['nom_guilde'];
                }
                if (_json[j]['id_guilde'] == json[0]['id_guilde']) {
                    _param = "SELECTED";
                }
                else {
                    _param = "";
                }
                _chaine += '<option value="' + _json[j]["id_guilde"] + '" ' + _param + '>' + _nom + '</option>';
            }
            
            _chaine += '</select>';
            
            $("#div_guildes").html(_chaine);
        });
    });
}

function editUser(_id_user){
    var _nom = document.getElementById("nom").value;
    var _pass = document.getElementById("pass").value;
    var _mail = document.getElementById("mail").value;
    var _guilde = document.getElementById("guild_name").value;
    $.ajax({
        type: "POST",
        url: "./php/editUser.php",
        data: "id_guilde=" + _guilde + "&nom=" + _nom + "&pass=" + _pass + "&mail=" + _mail + "&id_user=" + _id_user,
        success: function(_msg){
            edit("user");
            document.getElementById("main").innerHTML += _msg;
        }
    });
}