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.