[zipcore]

[CSS/CSGO] Anti Strafe Hack

I hope you enjoy this module

[Himynamesaustin]

Anyone having an issue that after 1000+ records the world records dont come up anymore?

[Glite]

There is a hardcoded maximum for record cache (1000).

[zipcore]

Originally Posted by Glite There is a hardcoded maximum for record cache (1000).

Just recompile and increase this limit. My timers cache is much bigger "new g_cache[MAX_MODES][MAX_BONUS][MAX_CACHE][RecordCache]"

CHANGE NEEDED: (timer-worldrecord.sp)

PHP Code:

new g_cache[1024][RecordCache];

to

new g_cache[5000][RecordCache];

AND

FormatEx(sQuery, sizeof(sQuery), "SELECT m.id, m.auth, m.time, MAX(m.jumps) jumps, m.physicsdifficulty, m.name, MAX(m.flashbangs) flashbangs FROM round AS m INNER JOIN (SELECT MIN(n.time) time, n.auth FROM round n WHERE n.map = '%s' GROUP BY n.physicsdifficulty, n.auth) AS j ON (j.time = m.time AND j.auth = m.auth) WHERE m.map = '%s' GROUP BY m.physicsdifficulty, m.auth ORDER BY m.time ASC LIMIT 0, 1000", g_sCurrentMap, g_sCurrentMap);   

to

FormatEx(sQuery, sizeof(sQuery), "SELECT m.id, m.auth, m.time, MAX(m.jumps) jumps, m.physicsdifficulty, m.name, MAX(m.flashbangs) flashbangs FROM round AS m INNER JOIN (SELECT MIN(n.time) time, n.auth FROM round n WHERE n.map = '%s' GROUP BY n.physicsdifficulty, n.auth) AS j ON (j.time = m.time AND j.auth = m.auth) WHERE m.map = '%s' GROUP BY m.physicsdifficulty, m.auth ORDER BY m.time ASC LIMIT 0, 5000", g_sCurrentMap, g_sCurrentMap); 


[shavit]

I think that the record saving in this plugin should be updated and be threaded, or atleast fix that every map finish is being saved to database. I tried doing it by doing some checks with bOverwrite, but seems that if you don't get a better time in SW for example than your normal mode time, it will be counted as not overwrote and I can't get it to save SW/W only records because of that.

Edit: Fixed it.

FinishRound(client, const String:map[], Float:time, jumps, flashbangs, physicsDifficulty, fpsmax)
{
    if(!IsClientInGame(client) || !IsPlayerAlive(client) || IsFakeClient(client))
    {
        return;
    }
    
    new Float:fLastTime;
    new iLastJumps, iLastFlashbangs, iLastFps;
    decl String:sTimeDiff[32], String:sBuffer[32];
    new bool:bOverwrite = false;
    
    Timer_GetBestRecord(client, map, physicsDifficulty, fLastTime, iLastJumps, iLastFps, iLastFlashbangs);
    
    SQL_LockDatabase(g_hSQL);
    
    decl String:sAuthID[MAX_AUTHID_LENGTH];
    GetClientAuthString(client, sAuthID, sizeof(sAuthID));
    
    decl String:sTimeQuery[256];
    FormatEx(sTimeQuery, 256, "SELECT time FROM round WHERE auth = '%s' AND map = '%s' AND physicsdifficulty = '%d' ORDER BY time LIMIT 1", sAuthID, map, physicsDifficulty);
    
    new Handle:hTimeQuery = SQL_Query(g_hSQL, sTimeQuery);
    
    decl String:sError[255];
    
    if(hTimeQuery == INVALID_HANDLE)
    {
        SQL_GetError(g_hSQL, sError, sizeof(sError));
        Timer_LogError("SQL Error on FinishRound: %s", sError);
        SQL_UnlockDatabase(g_hSQL);
        
        return;
    }
    
    if(SQL_FetchRow(hTimeQuery))
    {
        fLastTime = SQL_FetchFloat(hTimeQuery, 0);
    }
    
    else
    {
        fLastTime = 0.0;
    }
    
    SQL_UnlockDatabase(g_hSQL); 
    
    CloseHandle(hTimeQuery);
    
    if(fLastTime == 0.0)
    {
        g_bestTimeCache[client][Time] = time;
        bOverwrite = true;
    }
    fLastTime -= time;            
    if(fLastTime < 0.0)
    {
        fLastTime *= -1.0;
        Timer_SecondsToTimeWr(fLastTime, sBuffer, sizeof(sBuffer), true);
        FormatEx(sTimeDiff, sizeof(sTimeDiff), "+%s", sBuffer);
    }
    else if(fLastTime > 0.0)
    {
        g_bestTimeCache[client][Time] = time;
        bOverwrite = true;
        Timer_SecondsToTimeWr(fLastTime, sBuffer, sizeof(sBuffer), true);
        FormatEx(sTimeDiff, sizeof(sTimeDiff), "-%s", sBuffer);
    }
    else if(fLastTime == 0.0)
    {
        Timer_SecondsToTimeWr(fLastTime, sBuffer, sizeof(sBuffer), true);
        FormatEx(sTimeDiff, sizeof(sTimeDiff), "%s", sBuffer);
    }
    
    decl String:sName[MAX_NAME_LENGTH];
    GetClientName(client, sName, sizeof(sName));
    
    decl String:sSafeName[2 * strlen(sName) + 1];
    SQL_LockDatabase(g_hSQL);
    SQL_EscapeString(g_hSQL, sName, sSafeName, 2 * strlen(sName) + 1);
    SQL_UnlockDatabase(g_hSQL);
    
    if(bOverwrite)
    {
        decl String:sQuery[256];
        FormatEx(sQuery, sizeof(sQuery), "DELETE FROM round WHERE map = '%s' AND auth = '%s' AND physicsdifficulty = '%d';", map, sAuthID, physicsDifficulty);
        
        SQL_LockDatabase(g_hSQL);
        
        new Handle:hQuery = SQL_Query(g_hSQL, sQuery);
        
        if (hQuery == INVALID_HANDLE)
        {
            SQL_GetError(g_hSQL, sError, sizeof(sError));
            Timer_LogError("SQL Error on FinishRound: %s", sError);
            SQL_UnlockDatabase(g_hSQL);
            return;
        }
        
        CloseHandle(hQuery);
        
        SQL_UnlockDatabase(g_hSQL); 
        
        FormatEx(sQuery, sizeof(sQuery), "INSERT INTO round (map, auth, time, jumps, physicsdifficulty, name, fpsmax, flashbangs) VALUES ('%s', '%s', %f, %d, %d, '%s', %d, %d);", map, sAuthID, time, jumps, physicsDifficulty, sSafeName, fpsmax, flashbangs);
        
        SQL_LockDatabase(g_hSQL);
        
        new Handle:hQuery2 = SQL_Query(g_hSQL, sQuery);
        
        if(hQuery2 == INVALID_HANDLE)
        {
            SQL_GetError(g_hSQL, sError, sizeof(sError));
            Timer_LogError("SQL Error on FinishRound: %s", sError);
            SQL_UnlockDatabase(g_hSQL);
            return;
        }
        
        SQL_UnlockDatabase(g_hSQL); 
        
        CloseHandle(hQuery2);
        
        g_bestTimeCache[client][IsCached] = false;
        
        GetTotalRank(g_sCurrentMap);
        GetCurrentRank(client, g_sCurrentMap);
    }
    
    decl String:sTimeString[32];
    Timer_SecondsToTimeWr(time, sTimeString, sizeof(sTimeString), true);
    
    Call_StartForward(g_hFinishRoundForward);
    Call_PushCell(client);
    Call_PushString(map);
    Call_PushCell(jumps);
    Call_PushCell(flashbangs);
    Call_PushCell(physicsDifficulty);
    Call_PushCell(fpsmax);
    Call_PushString(sTimeString);
    Call_PushString(sTimeDiff);
    Call_PushCell(Timer_GetCurrentRank(client, false));
    Call_PushCell(Timer_GetTotalRank(false));
    Call_PushCell(bOverwrite);
    //Call_PushFloat(time);
    Call_Finish();
}

Sorry for the uglyness of that code.

[Himynamesaustin]

Originally Posted by zipcore Just recompile and increase this limit. My timers cache is much bigger "new g_cache[MAX_MODES][MAX_BONUS][MAX_CACHE][RecordCache]" CHANGE NEEDED: (timer-worldrecord.sp) PHP Code: new g_cache[1024][RecordCache]; to new g_cache[5000][RecordCache]; AND FormatEx(sQuery, sizeof(sQuery), "SELECT m.id, m.auth, m.time, MAX(m.jumps) jumps, m.physicsdifficulty, m.name, MAX(m.flashbangs) flashbangs FROM round AS m INNER JOIN (SELECT MIN(n.time) time, n.auth FROM round n WHERE n.map = '%s' GROUP BY n.physicsdifficulty, n.auth) AS j ON (j.time = m.time AND j.auth = m.auth) WHERE m.map = '%s' GROUP BY m.physicsdifficulty, m.auth ORDER BY m.time ASC LIMIT 0, 1000", g_sCurrentMap, g_sCurrentMap);    to FormatEx(sQuery, sizeof(sQuery), "SELECT m.id, m.auth, m.time, MAX(m.jumps) jumps, m.physicsdifficulty, m.name, MAX(m.flashbangs) flashbangs FROM round AS m INNER JOIN (SELECT MIN(n.time) time, n.auth FROM round n WHERE n.map = '%s' GROUP BY n.physicsdifficulty, n.auth) AS j ON (j.time = m.time AND j.auth = m.auth) WHERE m.map = '%s' GROUP BY m.physicsdifficulty, m.auth ORDER BY m.time ASC LIMIT 0, 5000", g_sCurrentMap, g_sCurrentMap);

I was told the limit for the array was 1000 and that change is impossible. can anyone confirm or deny?

[shavit]

Originally Posted by Himynamesaustin I was told the limit for the array was 1000 and that change is impossible. can anyone confirm or deny?

I confirm that you can change it.

[Himynamesaustin]

Originally Posted by shavit I confirm that you can change it.

get on skype, i have something for you

[goapsytrancer]

thanks for the upload!

i try it online on gameserver
without mysql database can it be the problem
why i didnt see it like in the video on my admin menu ?




or need i command to activate this plugin

[extremeg]

Hei, when a player finish the map my server lags. I have over 5000 rounds tracked