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


Započeo worametguy, Avgust 25, 2020, 12:24:16 POSLE PODNE

prethodna tema - sledeća tema

0 članova i 1 gost pregledaju ovu temu.

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
Poslednja Izmena: Avgust 25, 2020, 12:26:43 POSLE PODNE od worametguy

format(query, sizeof(query), "UPDATE `characters` SET `VB%d` = '0' WHERE `VB%d` > '0'",
 	    		ValueInfo[i][bID]-1,
      			ValueInfo[i][bID]-1);


bID = 0
bID - 1 = -1


Od MySQL znam samo da ga izgovorim  8)


NAJTAN IN HOUSE ! - PROFI TROLLER , PROFI MIRODJIJA !
JEDAN JEDINI PRODRAMER !
PRODRAMER JE PROFI LICE KOJE PRAVI DRAME KAKO BI SE ZABAVILO JER MU JE DOSADNO NAMERNO PRAVI GRESKE I JEBE MU SE STA DRUGI MISLE JER CEKA DA MU BAN ISTEKNE NA DRUGOM PROFILU !