mysql_format(handle, query, sizeof(query), "INSERT INTO Hotelzimmer (Hotel, Zimmernummer, Spawn_Out[0], Spawn_Out[1], Spawn_Out[2], Spawn_Out[3], Spawn_In[0], Spawn_In[1], Spawn_In[2], Spawn_In[3], Interior_In, Interior_Out, VirtuelleWelt_In, VirtuelleWelt_Out) VALUES ('%d', '%d', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%d', '%d', '%d', '%d')", 1, zimmerid, Pos[0], Pos[1], Pos[2], Pos[3], 443.0924, 509.3115, 1001.4195, 274.1910, 12, 18, 1000-i, 5);
mysql_pquery(handle, query);
[14:17:10] [ERROR] error #1064 while executing query "INSERT INTO Hotelzimmer (Hotel, Zimmernummer, Spawn_Out[0], Spawn_Out[1], Spawn_Out[2], Spawn_Out[3], Spawn_In[0], Spawn_In[1], Spawn_In[2], Spawn_In[3], Interior_In, Interior_Out, VirtuelleWelt_In, VirtuelleWelt_Out) VALUES ('0', '1', '0.000000', '1734.788452', '-1660.140015', '23.718327', '90.200233', '443.092407', '509.311493', '1001.419495', '1133058163', '12', '18', '1000')": You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[0], Spawn_Out[1], Spawn_Out[2], Spawn_Out[3], Spawn_In[0], Spawn_In[1], Spawn_I' at line 1
Ich finde irgendwie den Fehler nicht