Help ** [MySQL]: Unknown column 'VB-1' in 'where clause'

Započeo worametguy
25. Avg. 2020.
425
pregleda
3
postova
worametguy
2
Rookie
25. Avg. 2020.
Problem(error/warning): ** : Unknown column 'VB-1' in 'where clause'

Part of script :
forward SaveValue(id);
public SaveValue(id)
{
new query;
new id2;
  id2 = ValueInfo;
format(query, sizeof(query), "UPDATE `broker` SET `amount` = '%d', `buyer` = '%d' WHERE `id` = '%d'",
    ValueInfo, ValueInfo, id2);
mysql_tquery(g_iHandle, query);

format(query, sizeof(query), "UPDATE `broker` SET `price` = '%f' WHERE `id` = '%d'",
    ValueInfo,id2);
mysql_tquery(g_iHandle, query);

format(query, sizeof(query), "UPDATE `broker` SET `percent` = '%f' WHERE `id` = '%d'",
    ValueInfo,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 = myRandomFloat;
  if(ValueInfo < 1)
{
foreach (new x : Player)
{
PlayerData = 0;
    }
    new query;
    format(query, sizeof(query), "UPDATE `characters` SET `VB%d` = '0' WHERE `VB%d` > '0'",
    ValueInfo-1,
      ValueInfo-1);
    SendClientMessageEx(i, COLOR_RED, "[Share Market] share %s is bankrupt, all shares are released", ValueInfo);
      mysql_tquery(g_iHandle, query);
ValueInfo = 100;
ValueInfo = 0;
ValueInfo = 100;
SaveValue(i);
}
}
new change;
change = random(100000 - 1000) + 1000;
change = random(1000000 - 100000) + 100000;
SetTimer("UpdateValue2", change, false);
//SetTimer("LostValue", change, false);
UnUpdate = 0;
}
}


I don't know which part of the script to check.
Thanks for help
Alhemičar v2
4
Shot Caller
25. Avg. 2020.
format(query, sizeof(query), "UPDATE `characters` SET `VB%d` = '0' WHERE `VB%d` > '0'",
    ValueInfo-1,
      ValueInfo-1);


bID = 0
bID - 1 = -1
verzija.2
2
Wheel Man
28. Avg. 2020.
Od MySQL znam samo da ga izgovorim  😎

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava

© 2026 SmartShark. All rights reserved.

Powered by Momentum|v2026.3.001 Alpha