Language Change NPC

[ZelosAvalon]

can some one help me with this script ?

Spoiler

prt_in,290,137,6    script    Tradutor    768,{

/* Use this SQL table
CREATE TABLE IF NOT EXISTS `acc_lang` (
  `id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(30) NOT NULL DEFAULT '',
  `language` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;
*/

    mes "[Tradutor]";
    mes "Eu sou o Tradutor!";
    mes "I'm the Translator!";
    next;
    mes "Escolha sua linguagem:";
    mes "Choose your language:";
    switch(select("Português Brazil:English")) {
        case 1:
            query_sql "SELECT `language` FROM `acc_lang` WHERE `id` = '"+getcharid(0)+"'", .@language;
            if (.@language = 2)
                {
                    mes "Sorry, you already have the active English language!";
                    close;
                }
            else
                {
                    query_sql "UPDATE `acc_lang` SET `language` = '2' WHERE `id` = '"+getcharid(0)+"'";
                    mes "Ready, active english language!";
                    close;
                }
        case 2:
            query_sql "SELECT `language` FROM `acc_lang` WHERE `id` = '"+getcharid(0)+"'", .@language;
            if (.@language = 2)
                {
                    mes "Sorry, you already have the active English language!";
                    close;
                }
            else
                {
                    query_sql "UPDATE `acc_lang` SET `language` = '2' WHERE `id` = '"+getcharid(0)+"'";
                    mes "Ready, active english language!";
                    close;
                }
            
    }

}
prt_in,282,138,6    script    Teste    768,{

    query_sql "SELECT `language` FROM `acc_lang` WHERE `id` = '"+getcharid(0)+"'", .@language;
    if (.@language = 1){
        // if language English - language = 1
        mes "[Teste]";
        mes "Welcome ^3355FF"+strcharinfo(0)+"^000000";
        close;
    }
    else
    {
        //if language Português Brazil - language = 2
        mes "[Teste]";
        mes "Bem vindo ^3355FF"+strcharinfo(0)+"^000000";
        close;
    }
}

 

[Akbare]

excute mysql table

and add this script for your server npc

[ZelosAvalon]

On 22/02/2018 at 11:19 PM, Akbare said:

excute mysql table

and add this script for your server npc

what script ?

Edited February 24, 2018 by ZelosAvalon
miss words

[Alayne]

Well the one you gave in your first post. It contains in comment (/* [...] */ section) the sql command to execute on server's database, and the global script to include on your server.