but only in the compilation took 11 Seconds so i just don't want to thing how much time will take on server
Code:
for (new i=1;i<= g_iNumPlayers + g_subs; i++) {
for (new a=1;a<= g_TeamAScore + g_TeamBScore;a++) {
for (new p=1;p<= g_iNumPlayers + g_subs;p++) {
if (i != p) {
for (new k=0;k < 32;k++) {
for (new z=0;z < 9;z++) {
if (d{RoundData[ i ][ p ][ k ][ z ][ Kills ][ a ]}) {
format( szQuery, 900,"INSERT INTO `stats_roundstats` VALUES ('%d', '%s', '%d', '1', '0', '0', '%s','%d','%d');",g_id,g_player[i],a,g_player[p],k,z)
query = SQL_PrepareQuery( g_DB, szQuery );
SQL_Execute( query )
}
else if (d{RoundData[ i ][ p ][ k ][ z ][ Deaths ][ a ]}) {
format( szQuery, 900,"INSERT INTO `stats_roundstats` VALUES ('%d', '%s', '%d', '0', '1', '0', '%s','%d','%d');",g_id,g_player[i],a,g_player[p],k,z)
query = SQL_PrepareQuery( g_DB, szQuery );
SQL_Execute( query )
}
else if (d{RoundData[ i ][ p ][ k ][ z ][ Tks ][ a ]}) {
format( szQuery, 900,"INSERT INTO `stats_roundstats` VALUES ('%d', '%s', '%d', '0', '0', '1', '%s','%d','%d');",g_id,g_player[i],a,g_player[p],k,z)
query = SQL_PrepareQuery( g_DB, szQuery );
SQL_Execute( query )
}
}
}
}
}
}
}