[nGen.SoNNy]

Hi guys! I want to edit my gamemode ... my gamemode is on mysql and i want to make it better! I want some examples and some tricks about how to make server to work faster
And about database... what type i should use? innodb or MyISAM ? I have this site for Charts and Panel / Statistics and i want to know which type is better! www.stunt-evo.com

This code is unde callback OnPlayerDeath! Have something to say about this?

pawn Код:

// (Update Kills/Deaths)
    if( killerid != INVALID_PLAYER_ID )
    {
    new clanquery[300];
    AccInfo[killerid][Kills]++;
    format(clanquery, sizeof(clanquery), "UPDATE `users` SET `Kills` = %d WHERE `Name` = '%s'", AccInfo[killerid][Kills], PlayerName2(killerid));
    mysql_query( clanquery );
    AccInfo[playerid][Deaths]++;
    format(clanquery, sizeof(clanquery), "UPDATE `users` SET `Deaths` = %d WHERE `Name` = '%s'", AccInfo[playerid][Deaths], PlayerName2(playerid));
    mysql_query( clanquery );
    }
    else
    {
    new clanquery[300];
    AccInfo[playerid][Deaths]++;
    format(clanquery, sizeof(clanquery), "UPDATE `users` SET `Deaths` = %d WHERE `Name` = '%s'", AccInfo[playerid][Deaths], PlayerName2(playerid));
    mysql_query( clanquery );
    }
    // (Clan Kills/Deaths)
    if( IsPlayerAnyClanMember(playerid) && IsPlayerAnyClanMember(killerid) )
    {
    new clanquery[300];
    format(clanquery, sizeof(clanquery), "UPDATE clans SET clankills = %d WHERE clanname = '%s'", GetClanKills(GetPlayerClan(killerid)) + 1, GetPlayerClan(killerid));
    mysql_query( clanquery );
    format(clanquery, sizeof(clanquery), "UPDATE clans SET clandeaths = %d WHERE clanname = '%s'", GetClanDeaths(GetPlayerClan(playerid)) + 1, GetPlayerClan(playerid));
    mysql_query( clanquery );
    }

[ikkentim]

innoDB, definetely. http://stackoverflow.com/questions/2...-versus-innodb
Use mysql_query_callback (if you are using BlueG's mysql plugin)

[nGen.SoNNy]

Any others hints?