mysql_format: no value for specifier '%d' passed
#1

Hi, How Can I solve this error ?

Код:
[22:43:43] [ERROR] mysql_format: no value for specifier '%d' passed (D:\Server\filterscripts\****.pwn:727)
[22:43:43] [ERROR] error #1065 while executing query "": Query was empty (D:\Server\filterscripts\****.pwn:737)
Код:
new id = Iter_Free(Atmler);
		        DestroyDynamicObject(ATMObje[id][atmid]);
		        ATMObje[id][objeID] = 2942;
		        ATMObje[id][objeX] = x;
		        ATMObje[id][objeY] = y;
		        ATMObje[id][objeZ] = z;
		        ATMObje[id][objeRX] = rx;
		        ATMObje[id][objeRY] = ry;
		        ATMObje[id][objeRZ] = rz;
		        ATMObje[id][objeVirtual] = GetPlayerVirtualWorld(playerid);
		        ATMObje[id][objeInterior] = GetPlayerInterior(playerid);
		        ATMObje[id][atmid] = CreateDynamicObject(2942, x, y, z, rx, ry, rz, GetPlayerVirtualWorld(playerid), GetPlayerInterior(playerid));
		        if(IsValidDynamicCP(ATMObje[id][atm_cp_id]))
		        {
		            DestroyDynamicCP(ATMObje[id][atm_cp_id]);
		        	ATMObje[id][atm_cp_id] = CreateDynamicCP(x-0.5, y, z, 1.5, GetPlayerVirtualWorld(playerid), GetPlayerInterior(playerid));
				}
				Streamer_Update(playerid);
		        Iter_Add(Atmler, id);
		        ATMDurum[playerid] = false;
		        SendClientMessage(playerid, 0x44a5ffFF, "[ATM] {FFFFFF}ATM kayıt edildi.");
                               // Error
				new query[600];
				mysql_format(_xSQL, query, sizeof(query),"INSERT INTO `atmler` (id, ObjeID, ObjeX, ObjeY, ObjeZ, ObjeRX, ObjeRY, ObjeRZ, VirtualWorld, Interior) VALUES ('%d', '%d', '%f', '%f', '%f', '%f', '%f', '%f', '%d', '%d')",
				id,
				ATMObje[id][objeID] = 2942,
				ATMObje[id][objeX],
				ATMObje[id][objeY],
				ATMObje[id][objeZ],
				ATMObje[id][objeRX],
				ATMObje[id][objeRY],
				ATMObje[id][objeRZ],
				ATMObje[id][objeVirtual]);
				mysql_tquery(_xSQL, query, "", "");
Reply
#2

I count 10 specifiers and 9 variables. I believe you're missing a variable for your Interior value.
Reply
#3

Which variable is missing ?
Reply
#4

PHP код:
mysql_format(_xSQLquerysizeof(query),"INSERT INTO `atmler` (id, ObjeID, ObjeX, ObjeY, ObjeZ, ObjeRX, ObjeRY, ObjeRZ, VirtualWorld, Interior) VALUES ('%d', '%d', '%f', '%f', '%f', '%f', '%f', '%f', '%d', '%d')",
                
id,
                
ATMObje[id][objeID] = 2942,
                
ATMObje[id][objeX],
                
ATMObje[id][objeY],
                
ATMObje[id][objeZ],
                
ATMObje[id][objeRX],
                
ATMObje[id][objeRY],
                
ATMObje[id][objeRZ],
                
ATMObje[id][objeVirtual],
                                
ATMObje[id][objeInterior]); 
Reply
#5

Thanks.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)