Help MySQL DataBase saving kills

[EnVi Sweden Rocks]

coz we're pro's?

[yokai134]

Just do

Code:

OnPlayerDamaged if damage > victim health then { try { create and open a sql connection create a sql command tell it to update the table containing the points where the xuid matches close the connection } catch (sql exception) {} }

You're doing more work than you should in your code


to read

Code:

try { create and open a sql connection create a sql command create an int to store the points set the sql command to read read the table where the xuid matches set the int to the result column close the connection print out the value to server/chat } catch (sql exception) {}

[SgtLegend]

Opening and closing the connection uses a lot more server resource and isn't efficient, using a persistent connection is just as safe and saves having the extra overhead of re-creating the same connection.