XMarries

//Script Created By Senior S
//You are able to edit it as you pleasure

//Translation: PLEASE RESPECT THE SPACES! Thanks to Meedic Bear for the translation :3
xgendermale = "Your gender is male";
xgenderfemale = "Your gender is female";
xgenderselect = "What is your gender?";
xpartnerfalse = "You have no partner";
xpartnertrue = "Your partner is: ";
xmarried1 = "You have accepted the marriage proposal!";
xmarried2 = "Congratulations now you're in a couple!";
xmarried3 = " has accepted you proposal, Congratulations!";
xmarried4 = " Now are in a couple with ";
xproposefailed = "Insert a valid name!";
xproposesend1 = "The proposal has been submitted, wait for it to accept!";
xproposesend2 = " wants to marry you, to accept use /accept";
xsuggestionfalse = "You have no proposal!";

// Script code
event onLoad(){
    database.execute("CREATE TABLE married(
    id VARCHAR(17) PRIMARY KEY,
    partner INT NOT NULL DEFAULT 0,
    gender INT NOT NULL DEFAULT 0,
    gselected INT NOT NULL DEFAULT 0,
    suggestion INT NOT NULL DEFAULT 0,
    notpartner INT NOT NULL DEFAULT 0
    );");
}

event onPlayerJoined(player){
    x = database.execute("SELECT * FROM married WHERE id = '" + player.id + "';");
    if(x.count == 0){
        database.execute("INSERT INTO married (id, partner, gender, suggestion) VALUES ('" + player.id + "', 0, 0, 0);");
    }
}

event onPlayerJoined(player){
    a = database.execute("SELECT * FROM married WHERE id = '" + player.id + "';");
    a = a[0];
    partner = a[1];
    gender = a[2];
    gselected = a[3];
    suggestion = a[4];
    notpartner = a[5];
    if(gselected == 0){
        effectManager.sendUI(16250, 1, player.id, xgenderselect);
    }
}

event onEffectButtonClicked(player, key){
    if(key == "Male"){
        database.execute(str.format("UPDATE married SET gender = 1 WHERE id = '{0}';", player.id));
        effectManager.clearUIbyID(16250, player.id);
        database.execute(str.format("UPDATE married SET gselected = 1 WHERE id = '{0}';", player.id));
    }
    if(key == "Female"){
        database.execute(str.format("UPDATE married SET gender = 2 WHERE id = '{0}';", player.id));
        effectManager.clearUIbyID(16250, player.id);
        database.execute(str.format("UPDATE married SET gselected = 1 WHERE id = '{0}';", player.id));
    }
}

command gender(){
    permission = "XMarriages.user";
    execute(){
        b = database.execute(str.format("Select * FROM married WHERE id = '{0}';", player.id));
        b = b[0];
        partner = b[1];
        gender = b[2];
        gselected = b[3];
        suggestion = b[4];
        notpartner = b[5];
        if(gender == 1){
            player.message(xgendermale);
        }
        if(gender == 2){
            player.message(xgenderfemale);
        }
    }
}

command partner(){
    permission = "XMarriages.user";
    execute(){
        c = database.execute(str.format("Select * FROM married WHERE id = '{0}';", player.id));
        c = c[0];
        partner = c[1];
        gender = c[2];
        gselected = c[3];
        suggestion = c[4];
        notpartner = c[5];
        if(partner == 0){
            player.message(xpartnerfalse);
            return;
        }
        player.message(xpartnertrue + partner);
    }
}

command accept(){
    permission = "XMarriages.user";
    execute(){
        d = database.execute(str.format("Select * FROM married WHERE id = '{0}';", player.id));
        d = d[0];
        partner = d[1];
        gender = d[2];
        gselected = d[3];
        suggestion = d[4];
        notpartner = d[5];
        if(suggestion == 1 and partner == 0){
            e = database.execute(str.format("Select * FROM married WHERE id = '{0}';", notpartner));
            e = e[0];
            partner = e[1];
            gender = e[2];
            gselected = e[3];
            suggestion = e[4];
            notpartner = e[5];
            player.message(xmarried1);
            player.message(xmarried2);
            database.execute(str.format("UPDATE married SET partner = '{0}' WHERE id = '{1}';", notpartner, player.id));
            target = toPlayer(notpartner);
            target.message(player.name + xmarried3);
            broadcast(target.name + xmarried4 + player.name);
            return;
        }
        if(suggestion == 0){
            player.message(xsuggestionfalse, "red");
        }
    }
}

command Propose(arg){
    permission = "XMarriages.user";
    execute(){
        propos = toPlayer(arg);
        if(propos == null){
            player.message(xproposefailed, "red");
            return;
        }
        if(isPlayer(propos) == "True"){
            player.message(xproposesend1);
            propos.message(xproposesend2);
            pareja = player.id;
            database.execute(str.format("UPDATE married SET suggestion = 1 WHERE id = '{1}';", player.id));
            database.execute(str.format("UPDATE married SET notpartner = '{0}' WHERE id = '{1}';", pareja, player.id));
        }
    }
}