[OciXCrom]

I made the check the wrong way around. Check now, I updated my code.

[karaulov]

@OciXCrom, you use SQL_ExecuteQuery in "Load data" function, this is not async, if latency between game server and mysql > 10ms, in game can be lags. You can fix it ?

[OciXCrom]

Originally Posted by karaulov @OciXCrom, you use SQL_ExecuteQuery in "Load data" function, this is not async, if latency between game server and mysql > 10ms, in game can be lags. You can fix it ?

Which one is async? And what would happen if it fails to connect to the server? Pretty sure that would lead do data loss.

[karaulov]

@OciXCrom, you use SQL_Execute twice in plugin when player join to server or change name. If mysql server has delay 50ms, it takes 100ms time (server just stop work at 100ms).

It also can be used for ddos attack to server (auto change name hack).

[OciXCrom]

Alright, I see what you mean. Looks like SQL_ThreadQuery is what you're looking for.

SQL_ThreadQuery > Note This will not interrupt gameplay in the event of a poor/lossed connection, however, the interface is more complicated and asynchronous. Furthermore, a new connection/disconnection is made for each query to simplify driver support.

I will switch the functions and test this out very soon.

[Will2]

Originally Posted by OciXCrom I made the check the wrong way around. Check now, I updated my code.

It still doesn't work.

[OciXCrom]

#include <amxmodx>
#include <crxranks>
#include <fakemeta>

#if !defined MAX_PLAYERS
const MAX_PLAYERS = 32
#endif

const SPEAK_LEVEL = 5

new g_iLevel[MAX_PLAYERS + 1]

public plugin_init()
{
    register_plugin("CRXRanks: Speak On Level", "1.0", "OciXCrom")
    register_forward(FM_Voice_SetClientListening, "OnPlayerTalk")
}

public OnPlayerTalk(iReceiver, iSender)
{
    if(g_iLevel[iSender] < SPEAK_LEVEL)
    {
        engfunc(EngFunc_SetClientListening, iReceiver, iSender, 0)
        return FMRES_SUPERCEDE
    }
    
    return FMRES_IGNORED
}

public crxranks_user_level_updated(id, iLevel)
{
    g_iLevel[id] = iLevel
}

[Nito]

I have one little problem. When someone reaches for example 30 lvl in the new round he gets ''S'' flag like i set up, but when the map changes ''S'' flag disappears. Can sameone help me? I just need it to stay for next reset (1st day every month).

[OciXCrom]

Are you using AMXBans or some other admin privilege system?

[Will2]

Originally Posted by OciXCrom #include <amxmodx> #include <crxranks> #include <fakemeta> #if !defined MAX_PLAYERS const MAX_PLAYERS = 32 #endif const SPEAK_LEVEL = 5 new g_iLevel[MAX_PLAYERS + 1] public plugin_init() {     register_plugin("CRXRanks: Speak On Level", "1.0", "OciXCrom")     register_forward(FM_Voice_SetClientListening, "OnPlayerTalk") } public OnPlayerTalk(iReceiver, iSender) {     if(g_iLevel[iSender] < SPEAK_LEVEL)     {         engfunc(EngFunc_SetClientListening, iReceiver, iSender, 0)         return FMRES_SUPERCEDE     }         return FMRES_IGNORED } public crxranks_user_level_updated(id, iLevel) {     g_iLevel[id] = iLevel }

Very good, it works now. Thank you for your help!