How do I add data to the mysql database?

[MATTYOne]

Is it possible to somehow add (update a row) in the database from the server script?

For example:

File: HaramelInstance.java (GameServer\data\scripts\system\handlers\instance)

Update the value in the players_bosskill table (Which I created in advance in the game server database)

Need to change the value from 2 to 3 in the kill_hamerun column (you can see in the screenshot)

The request itself looks like this:

UPDATE players_bosskill SET kill_hamerun = kill_hamerun +1 WHERE player_id = 320140

 

[ALeKsIuS]

It's easy, just get connection, than prepared statement and use update. Example you can see in MYSQL5Dao scripts

 

[MATTYOne]

It's easy, just get connection, than prepared statement and use update. Example you can see in MYSQL5Dao scripts

God, I'm an idiot... Why didn't I guess myself to go to the DAO scripts, see... TY!

it works