SA-MP Forums Archive
MySQL better scripting - Ideas!? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL better scripting - Ideas!? (/showthread.php?tid=372640)


MySQL better scripting - Ideas!? - nGen.SoNNy - 27.08.2012

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 );
    }


Re: MySQL better scripting - Ideas!? - ikkentim - 27.08.2012

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

Re: MySQL better scripting - Ideas!? - nGen.SoNNy - 28.08.2012

Any others hints?