[Banditul18]

Hello i have a problem about a query, i know it's mysql_query but i need the result "instant"

PHP код:

new Cache:csalt,squery[128];
    mysql_format(SQL, squery, sizeof(squery), "SELECT `salt` FROM `users` WHERE `name` = '%e'", GetName(playerid));
    csalt = mysql_query(SQL, squery);
    if(cache_num_rows() > 0)
    {
        cache_get_field_content(0, "salt", PlayerInfo[playerid][pSalt], SQL);
    }
    cache_delete(csalt, SQL);
    format(squery, sizeof(squery), "Salt: %s",PlayerInfo[playerid][pSalt]);
    print(squery); 


I try to get the salt from database , but always return as a empty string adn the login system not working becasue there is no salt , how to make this query work?

[BroZeus]

If you store the string in enum you need to provide max length of string yourself.
Use this :

Quote:

cache_get_field_content(0, "salt", PlayerInfo[playerid][pSalt], SQL, 256);

Change 256 to whatever max length of salt is, then it should work.

[Banditul18]

Quote:

Originally Posted by BroZeus If you store the string in enum you need to provide max length of string yourself. Use this : Change 256 to whatever max length of salt is, then it should work.

That i do not know it about provide size for enum arrays, thank you for tell me this, much appreciate