[Micko123]

Hey guys. I have problem with MySQL it won't update table

PHP код:

new query[72];
mysql_format(g_SQL, query, sizeof(query), "UPDATE `players` SET `OrgJoined` = %d `OrgLeader` = %d `OrgRank` = 6", org, org);
        mysql_tquery(g_SQL, query); 


It is compiling nicely. Command is working but it won't set anything in table.. Any ideas?

[F1N4L]

WHERE column = 'value'

[Micko123]

But I am not using it here and it is working perfectly

PHP код:

mysql_format(g_SQL, query, sizeof(query), "UPDATE `players` SET `Money` = %d", ammount);
    mysql_tquery(g_SQL, query); 


I don't get it..

[F1N4L]

Код:

mysql_tquery(g_SQL, query, "CallBack", "specifiers", parameters);

example

Код:

mysql_tquery(g_SQL, query, "CallBack", "d", playerid);

[Bolex_]

1.Check your mysql log using mysql_debug(1); (inside OnGameModeInit)
2. Try to increase the string

[Konstantinos]

As Scripter18 said, you should always check your mysql logs because apparently it gives an error in syntax. The fix is what F1N4L said.

Quote:

Originally Posted by Micko123 But I am not using it here and it is working perfectly PHP код: mysql_format(g_SQL, query, sizeof(query), "UPDATE `players` SET `Money` = %d", ammount);     mysql_tquery(g_SQL, query);  I don't get it..

Without specifying a WHERE clause, it will set the money for ALL the rows (accounts).

[Micko123]

Should I write it like this

Код:

mysql_format(g_SQL, query, sizeof(query), "UPDATE `players` SET `Money` = %d WHERE `ID` = %d LIMIT 1", ammount, PlayerInfo[target][ID]);

or like this

Код:

mysql_format(g_SQL, query, sizeof(query), "UPDATE `players` SET `Money` = %d WHERE `ID` = %d LIMIT 1", ammount, PlayerInfo[playerid][ID]);

[Micko123]

Okay so I have new problem
I made another acc on localhost and it is created in DB. Problem is when I give myself an admin on one acc another acc is getting the same admin level. Before making second acc /setmoney worked fine. Now it won't add at all. I just have same ammout on both accs.. Here are /setmoney and /setadmin

PHP код:

CMD:setmoney(playerid, params[])
{
    if(PlayerInfo[playerid][Admin] < 4)
    {
        ERROR(playerid, "You are not allowed to use this command");
        return 1;
    }
    new target, ammount;
    if(sscanf(params, "ui", target, ammount))
    {
        USAGE(playerid, "/setmoney [ID/Name] [Ammount]");
        return 1;
    }
    if(!IsPlayerConnected(target))
    {
        ERROR(playerid, "That player is not connected");
        return 1;
    }
    ResetPlayerMoney(target);
    GivePlayerMoney(target, ammount);
    PlayerInfo[target][Money] = ammount;
    new string[128], string2[128], query[90];
    format(string, sizeof(string), ""YELLOW"[INFO] "WHITE"Admin "SERVERBLUE"%s "WHITE"setted your money to "SERVERBLUE"%d", GetName(playerid), ammount);
    SCM(target, -1, string);
    format(string2, sizeof(string2), "[INFO] Admin %s setted %s %d$", GetName(playerid), GetName(target), ammount);
    AdminMessage(-1, string2);
    WriteLog(MONEY, string2);
    mysql_format(g_SQL, query, sizeof(query), "UPDATE `players` SET `Money` = %d WHERE `ID` = %d LIMIT 1", ammount, PlayerInfo[target][ID]);
    mysql_tquery(g_SQL, query);
    return 1;
}
//=============================== Admin Level 5 ================================//
CMD:setadmin(playerid, params[])
{
    if(PlayerInfo[playerid][Admin] < 5)
    {
        ERROR(playerid, "You are not allowed to use this command");
        return 1;
    }
    new target, level;
    if(sscanf(params, "ui", target, level))
    {
        USAGE(playerid, "/setadmin [ID/Name] [Level]");
        return 1;
    }
    if(!IsPlayerConnected(target))
    {
        ERROR(playerid, "That player is not online");
        return 1;
    }
    if(PlayerInfo[target][Admin] >= 1)
    {
        ERROR(playerid, "That player already has that admin level. Use /apromote or /ademote");
        return 1;
    }
    PlayerInfo[target][Admin] = level;
    new string[128], string2[128], query[128];
    mysql_format(g_SQL, query, sizeof(query), "UPDATE `players` SET `Admin` = %d WHERE `ID` = %d LIMIT 1", level, PlayerInfo[playerid][ID]);
    mysql_tquery(g_SQL, query);
    format(string, sizeof(string), ""YELLOW"[INFO] "WHITE"Admin "SERVERBLUE"%s "WHITE" gave you Admin Level "SERVERBLUE"%d", GetName(playerid), level);
    SCM(target, -1, string);
    format(string2, sizeof(string2), "[INFO] Admin %s gave %s Admin Level %d", GetName(playerid), GetName(target), level);
    AdminMessage(-1, string2);
    WriteLog(SET, string2);
    return 1;
} 


Any ideas??