Erro de script sql

[maciel]

Good evening everyone, I'm trying to put a pvp rank npc script, but I don't know how to put this SQL file, can anyone help me?

[Akbare-2nd]

1 hour ago, maciel said:

Good evening everyone, I'm trying to put a pvp rank npc script, but I don't know how to put this SQL file, can anyone help me?

input ni mysql use phpmyadmin or other

[maciel]

That's the problem friend, I don't know how to do this, could you tell me how to configure NPC in the database?

[hendra814]

7 hours ago, maciel said:

That's the problem friend, I don't know how to do this, could you tell me how to configure NPC in the database?

check in the npc script are there have sql script, if exist run it at your sql database.

[maciel]

4 hours ago, hendra814 said:

verifique no script npc se há script sql, se houver execute-o no seu banco de dados sql.

This npc script is the one that already comes in the emulator when downloaded from the official rathena, I didn't find any sql file bro, I only have this file below

pvp_kyo.txt

[hendra814]

10 hours ago, maciel said:

This npc script is the one that already comes in the emulator when downloaded from the official rathena, I didn't find any sql file bro, I only have this file below

pvp_kyo.txt 3.86 kB · 1 download

found it at this page 

insert this sql script into your sql database

ALTER TABLE `char` ADD `pvp_kill` INT(11) UNSIGNED NOT NULL DEFAULT '0'  AFTER `fame`;

 

[maciel]

18 hours ago, hendra814 said:

achei nessa pagina 

insira este script sql em seu banco de dados sql

 

Good afternoon friends, resolved, for those who don't know or don't understand, it's very simple, put I enter my paid phpmyadmin database or vertrigo or whatever you use, you look for the line called "char" you click on it to open, it will open all your acc's = user accounts, don't mess with that, at the top there is a file called "SQL" you click on it and it will open a screen in which you can put lines of SQL commands, well I don't know anything about scripting or programming I went to chatgpt and it even generated a compatible file for me to put there in the "write SQL" option 

 ALTER TABLE `char` ADD `pvp_kill` INT(11) NOT NULL DEFAULT 0;

This file is responsible for creating the column 
"pvp_kill"

in your database because initially it doesn't exist, after that you click on execute, ready if you go to the "char" tab, open it and go to the second column option there a column will be created with the name "pvp_kill" it is responsible for counting player kills. I hope I helped with details for new people who are after this, because I don't understand anything I had a lot of difficulty, thanks to the guy above my post, you made me go back until I resolved it.

Apparently everything worked correctly, although a message "nothing found in the selected map" is appearing, I still don't know the reason but without any errors in the emulator so far.