Problem(error/warning): ** [MySQL]: Unknown column 'VB-1' in 'where clause'
Part of script :
forward SaveValue(id);
public SaveValue(id)
{
new query[128];
new id2;
id2 = ValueInfo[id][bID];
format(query, sizeof(query), "UPDATE `broker` SET `amount` = '%d', `buyer` = '%d' WHERE `id` = '%d'",
ValueInfo[id][bAmount], ValueInfo[id][bBuyer], id2);
mysql_tquery(g_iHandle, query);
format(query, sizeof(query), "UPDATE `broker` SET `price` = '%f' WHERE `id` = '%d'",
ValueInfo[id][bPrice],id2);
mysql_tquery(g_iHandle, query);
format(query, sizeof(query), "UPDATE `broker` SET `percent` = '%f' WHERE `id` = '%d'",
ValueInfo[id][bPercent],id2);
mysql_tquery(g_iHandle, query);
}
forward UpdateValue();
public UpdateValue()
{
if(UnUpdate == 1)
{
for (new i = 0; i != MAX_VALUE; i ++)
{
new myRandomFloat = 4;
ValueInfo[i][bPercent] = myRandomFloat;
if(ValueInfo[i][bPrice] < 1)
{
foreach (new x : Player)
{
PlayerData[x][pBroker][i] = 0;
}
new query[2048];
format(query, sizeof(query), "UPDATE `characters` SET `VB%d` = '0' WHERE `VB%d` > '0'",
ValueInfo[i][bID]-1,
ValueInfo[i][bID]-1);
SendClientMessageEx(i, COLOR_RED, "[Share Market] share %s is bankrupt, all shares are released", ValueInfo[i][bName]);
mysql_tquery(g_iHandle, query);
ValueInfo[i][bPrice] = 100;
ValueInfo[i][bBuyer] = 0;
ValueInfo[i][bAmount] = 100;
SaveValue(i);
}
}
new change[2];
change[0] = random(100000 - 1000) + 1000;
change[1] = random(1000000 - 100000) + 100000;
SetTimer("UpdateValue2", change[0], false);
//SetTimer("LostValue", change[1], false);
UnUpdate = 0;
}
}
I don't know which part of the script to check.
Thanks for help
[pawn]format(query, sizeof(query), "UPDATE `characters` SET `VB%d` = '0' WHERE `VB%d` > '0'",
ValueInfo[bID]-1,
ValueInfo[bID]-1);
[/pawn]
bID = 0
bID - 1 = -1
Od MySQL znam samo da ga izgovorim 8)