MYSQL Duplicating Issue
#1

Hi Everyone,

I'm having one issue now, with a MYSQL Issue. Can you solve this, or at-least help me understand whats wrong.

pawn Код:
/* @FUTURE */
        mysql_format(dbhandle, query, sizeof query, "INSERT INTO vehicles VALUES (%d, %d, %.2f, %.2f, %.2f, %.2f, %d, %d, %d, '%e', %d, %d, %d, %d, '%e') \
        ON DUPLICATE KEY UPDATE id = LAST_INSERT_ID(id), model = VALUES(model), "
,
        CarInfo[idx][cdbID], CarInfo[idx][cModel], CarInfo[idx][cLocationx],    CarInfo[idx][cLocationy],
        CarInfo[idx][cLocationz], CarInfo[idx][cAngle], CarInfo[idx][cColorOne], CarInfo[idx][cColorTwo],
        0, CarInfo[idx][cOwner], CarInfo[idx][cLock], CarInfo[idx][cPaintjob], CarInfo[idx][cVirWorld], CarInfo[idx][cCode], CarInfo[idx][cPlate]);
       
        strcat(query, "locX = VALUES(locX), \
        locY = VALUES(locY), locZ = VALUES(locZ), angle = VALUES(angle), \
        color1 = VALUES(color1), color2 = VALUES(color2), ownerId = VALUES(ownerId), \
        owner = VALUES(owner),\
        locked = VALUES(locked), paintjob = VALUES(paintjob), \
        virtualworld = VALUES(virtualworld), code = VALUES(code), plate = VALUES(plate)"
);     
       
        mysql_tquery_inline(dbhandle, query, using CarHandler, "");
/imageshack/img69/6205/x2lq.png That's the issue.
Reply


Messages In This Thread
MYSQL Duplicating Issue - by UnknownGamer - 07.01.2014, 21:36
Re: MYSQL Duplicating Issue - by sammp - 07.01.2014, 22:27
Re: MYSQL Duplicating Issue - by UnknownGamer - 07.01.2014, 22:55
Re: MYSQL Duplicating Issue - by ikey07 - 07.01.2014, 23:51
Re: MYSQL Duplicating Issue - by UnknownGamer - 08.01.2014, 20:34
Re: MYSQL Duplicating Issue - by sammp - 08.01.2014, 21:00

Forum Jump:


Users browsing this thread: 4 Guest(s)