[Lepraaah]

Originally Posted by thetwistedpanda It does work actually; world record may not function properly (it varies, for some it does for some it doesnt), but everything else functions peachy.

yep, im using sql with 0.0 problems, nothing with my world record either.

[vodka00]

Originally Posted by thetwistedpanda (it varies, for some it does for some it doesnt)

What would the cause for such variation?

[moode]

i want Timer for mg server !!

[cREANy0]

Originally Posted by moode i want Timer for mg server !!

just use this one?

[moode]

Originally Posted by cREANy0 just use this one?

I have tried Edited but i cant hide timer Message When you have finished the map
Any idea ?

[venomz]

There is a problemen with the timer i think. i run this plugin on a minigames server and i've ahd to remove two maps because off lagg/laggspikes appearing while playing on those maps. And those maps both had over 100 records. now the same problem has appeared on two other maps and they have 100-150 wr's to. Is this something you could look into alongub?

[venomz]

bump?

[Masog]

What about add a ranks in chat which is based on player's points? (And of course add points for finishing maps)
I mean like "[New]Nick" etc..
It would be nice.

[shavit]

I've found a lag fix for finishing maps/connecting to the server.

timer-core.sp
Modify FinishRound to use threaded SQL queries.

FinishRound(client, const String:map[], Float:time, jumps, flashbangs, physicsDifficulty, fpsmax)
{
    if(!IsClientInGame(client))
    {
        return;
    }
    
    if(!IsPlayerAlive(client))
    {
        return;
    }
    
    new Float:fLastTime;
    new iLastJumps, iLastFlashbangs;
    decl String:sTimeDiff[32], String:sBuffer[32];
    new bool:bOverwrite = false;
    
    Timer_GetBestRound(client, map, fLastTime, iLastJumps, iLastFlashbangs);
    
    if(fLastTime == 0.0)
    {
        g_bestTimeCache[client][Time] = time;
        bOverwrite = true;
    }
    
    fLastTime -= time;
    
    if(fLastTime < 0.0)
    {
        fLastTime *= -1.0;
        Timer_SecondsToTime(fLastTime, sBuffer, sizeof(sBuffer), true);
        FormatEx(sTimeDiff, sizeof(sTimeDiff), "+%s", sBuffer);
    }
    
    else if(fLastTime > 0.0)
    {
        g_bestTimeCache[client][Time] = time;
        bOverwrite = true;
        Timer_SecondsToTime(fLastTime, sBuffer, sizeof(sBuffer), true);
        FormatEx(sTimeDiff, sizeof(sTimeDiff), "-%s", sBuffer);
    }
    
    else if(fLastTime == 0.0)
    {
        Timer_SecondsToTime(fLastTime, sBuffer, sizeof(sBuffer), true);
        FormatEx(sTimeDiff, sizeof(sTimeDiff), "%s", sBuffer);
    }
    
    decl String:sAuthID[MAX_AUTHID_LENGTH];
    GetClientAuthString(client, sAuthID, sizeof(sAuthID));

    decl String:sName[MAX_NAME_LENGTH];
    GetClientName(client, sName, sizeof(sName));
    
    decl String:sSafeName[2 * strlen(sName) + 1];
    SQL_LockDatabse(g_hSQL);
    SQL_EscapeString(g_hSQL, sName, sSafeName, 2 * strlen(sName) + 1);
    SQL_UnlockDatabse(g_hSQL);

    decl String:sQuery[256];
    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_TQuery(g_hSQL, EmptyCallback, sQuery);
    
    g_bestTimeCache[client][IsCached] = false;
    
    GetTotalRank(g_sCurrentMap);
    GetCurrentRank(client, g_sCurrentMap);
    
    decl String:sTimeString[32];
    Timer_SecondsToTime(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_Finish();
}

public EmptyCallback(Handle:owner, Handle:hndl, const String:error[], any:client)
{
    if(hndl == INVALID_HANDLE)
    {
        LogError("SQL Error on FinishRound: %s", error);
        
        return;
    }
    
    CloseHandle(hndl);
}

timer-worldrecord.sp
Using an high database priority because the round table can be huge.

public OnClientAuthorized(client, const String:auth[])
{
    if(IsFakeClient(client) || IsClientSourceTV(client))
    {
        return;
    }
    
    decl String:sName[MAX_NAME_LENGTH];
    GetClientName(client, sName, MAX_NAME_LENGTH);

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

    decl String:sQuery[256];
    FormatEx(sQuery, sizeof(sQuery), "UPDATE round SET name = '%s' WHERE auth = '%s';", sSafeName, auth);
    SQL_TQuery(g_hSQL, ChangeNameCallback, sQuery, 0, DBPrio_High);
}

Originally Posted by Masog What about add a ranks in chat which is based on player's points? (And of course add points for finishing maps) I mean like "[New]Nick" etc.. It would be nice.

This is already done by me and probably by some other coders, but all of them are private plugins.
You need to create your own or contact a coder that will do it for you, if you're creating your own and having problems contact me and I will help you.

[cREANy0]

Originally Posted by shavit I've found a lag fix for finishing maps/connecting to the server. timer-core.sp Modify FinishRound to use threaded SQL queries. FinishRound(client, const String:map[], Float:time, jumps, flashbangs, physicsDifficulty, fpsmax) { if(!IsClientInGame(client)) { return; } if(!IsPlayerAlive(client)) { return; } new Float:fLastTime; new iLastJumps, iLastFlashbangs; decl String:sTimeDiff[32], String:sBuffer[32]; new bool:bOverwrite = false; Timer_GetBestRound(client, map, fLastTime, iLastJumps, iLastFlashbangs); if(fLastTime == 0.0) { g_bestTimeCache[client][Time] = time; bOverwrite = true; } fLastTime -= time; if(fLastTime < 0.0) { fLastTime *= -1.0; Timer_SecondsToTime(fLastTime, sBuffer, sizeof(sBuffer), true); FormatEx(sTimeDiff, sizeof(sTimeDiff), "+%s", sBuffer); } else if(fLastTime > 0.0) { g_bestTimeCache[client][Time] = time; bOverwrite = true; Timer_SecondsToTime(fLastTime, sBuffer, sizeof(sBuffer), true); FormatEx(sTimeDiff, sizeof(sTimeDiff), "-%s", sBuffer); } else if(fLastTime == 0.0) { Timer_SecondsToTime(fLastTime, sBuffer, sizeof(sBuffer), true); FormatEx(sTimeDiff, sizeof(sTimeDiff), "%s", sBuffer); } decl String:sAuthID[MAX_AUTHID_LENGTH]; GetClientAuthString(client, sAuthID, sizeof(sAuthID)); decl String:sName[MAX_NAME_LENGTH]; GetClientName(client, sName, sizeof(sName)); decl String:sSafeName[2 * strlen(sName) + 1]; SQL_LockDatabse(g_hSQL); SQL_EscapeString(g_hSQL, sName, sSafeName, 2 * strlen(sName) + 1); SQL_UnlockDatabse(g_hSQL); decl String:sQuery[256]; 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_TQuery(g_hSQL, EmptyCallback, sQuery); g_bestTimeCache[client][IsCached] = false; GetTotalRank(g_sCurrentMap); GetCurrentRank(client, g_sCurrentMap); decl String:sTimeString[32]; Timer_SecondsToTime(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_Finish(); } public EmptyCallback(Handle:owner, Handle:hndl, const String:error[], any:client) { if(hndl == INVALID_HANDLE) { LogError("SQL Error on FinishRound: %s", error); return; } CloseHandle(hndl); } timer-worldrecord.sp Using an high database priority because the round table can be huge. public OnClientAuthorized(client, const String:auth[]) { if(IsFakeClient(client) || IsClientSourceTV(client)) { return; } decl String:sName[MAX_NAME_LENGTH]; GetClientName(client, sName, MAX_NAME_LENGTH); 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); decl String:sQuery[256]; FormatEx(sQuery, sizeof(sQuery), "UPDATE round SET name = '%s' WHERE auth = '%s';", sSafeName, auth); SQL_TQuery(g_hSQL, ChangeNameCallback, sQuery, 0, DBPrio_High); } This is already done by me and probably by some other coders, but all of them are private plugins. You need to create your own or contact a coder that will do it for you, if you're creating your own and having problems contact me and I will help you.

This works really?
I will test it.


greetz cREANy0