[HowToRuski]

Hello, so i have this command where you can get coins from database when entering a custom code, but somehow when i activate the code with the command and while the command is on cooldown, it can be activated again from another player. Here is what im using -

Any help would be appreciated

PHP Code:

public RedeemCodeCommand(id)
{
    if(read_argc()<2){
      client_print(id, print_console, "Usage: bio_bank_activate <code>");
      return PLUGIN_HANDLED;
   }

    if (get_gametime() - g_lastCodeUseTime < 6)
    {
        client_print(id, print_console, "[BANZUKE] Wait a bit before using this command...")
        return PLUGIN_HANDLED;
    }

    g_lastCodeUseTime = get_gametime()

    new szPromoCode[PLATFORM_MAX_PATH]

    read_args(szPromoCode, charsmax(szPromoCode))
    remove_quotes(szPromoCode)
    trim(szPromoCode)

    new szQuery[MAX_FMT_LENGTH]

    formatex(szQuery, charsmax(szQuery), "SELECT * FROM `bank` WHERE `activation_code` = '%s'", szPromoCode)
    SQL_ThreadQuery(g_SqlTuple, "ActivePromoCode_QueryHandler", szQuery)

    return PLUGIN_CONTINUE
} 


[fysiks]

You already have a thread for this exact same question, no need to create another thread.

Did you try debugging the code? Try printing the value of "g_lastCodeUseTime", "get_gametime()", and "get_gametime() - g_lastCodeUseTime" so you can see what is going on while the plugin is running.

Another thing that I do often is to create a small plugin with only the small functionality that you're trying to test so that you can make sure that nothing else in your actual plugin is causing the issue somehow. Basically, prove that the logic works in a test plugin before putting it in your main one.

[Fuck For Fun]

Originally Posted by HowToRuski Hello, so i have this command where you can get coins from database when entering a custom code, but somehow when i activate the code with the command and while the command is on cooldown, it can be activated again from another player. Here is what im using - Any help would be appreciated PHP Code: public RedeemCodeCommand(id) {     if(read_argc()<2){       client_print(id, print_console, "Usage: bio_bank_activate <code>");       return PLUGIN_HANDLED;    }     if (get_gametime() - g_lastCodeUseTime < 6)     {         client_print(id, print_console, "[BANZUKE] Wait a bit before using this command...")         return PLUGIN_HANDLED;     }     g_lastCodeUseTime = get_gametime()     new szPromoCode[PLATFORM_MAX_PATH]     read_args(szPromoCode, charsmax(szPromoCode))     remove_quotes(szPromoCode)     trim(szPromoCode)     new szQuery[MAX_FMT_LENGTH]     formatex(szQuery, charsmax(szQuery), "SELECT * FROM `bank` WHERE `activation_code` = '%s'", szPromoCode)     SQL_ThreadQuery(g_SqlTuple, "ActivePromoCode_QueryHandler", szQuery)     return PLUGIN_CONTINUE }

public RedeemCodeCommand(id)
{
    if (read_argc() < 2)
    {
        client_print(id, print_console, "Usage: bio_bank_activate <code>");
        return PLUGIN_HANDLED;
    }

    new szPromoCode[PLATFORM_MAX_PATH];
    read_args(szPromoCode, charsmax(szPromoCode));
    remove_quotes(szPromoCode);
    trim(szPromoCode);

    new cooldownTime = g_cooldowns[id]; // get the cooldown time for this player
    if (get_gametime() - cooldownTime < 6)
    {
        client_print(id, print_console, "[BANZUKE] Wait a bit before using this command...");
        return PLUGIN_HANDLED;
    }

    g_cooldowns[id] = get_gametime(); // set the new cooldown time for this player

    new szQuery[MAX_FMT_LENGTH];
    
    formatex(szQuery, charsmax(szQuery), "SELECT * FROM `bank` WHERE `activation_code` = '%s'", szPromoCode);
    SQL_ThreadQuery(g_SqlTuple, "ActivePromoCode_QueryHandler", szQuery);

    return PLUGIN_CONTINUE;
}

"as you mentioned that other players can activate the code while the command is on cooldown for one player"
cooldown time for each player separately, instead of using a global variable g_lastCodeUseTime.