[MySQL] Storing data without duplicates.
#5

There is internal check which makes WHERE invalid, my mistake.

pawn Код:
format(query, sizeof(query),
    "INSERT INTO `"MYSQL_PREFIX"aop` (pid,modelid,slot,boneid,fOffsetX,fOffsetY,fOffsetZ,fRotX,fRotY,fRotZ,fScaleX,fScaleY,fScaleZ) \
     VALUES (%i,%i,%i,%i,%f,%f,%f,%f,%f,%f,%f,%f,%f) \
         ON DUPLICATE KEY \
     UPDATE modelid=%i,boneid=%i,fOffsetX=%f,fOffsetY=%f,fOffsetZ=%f,fRotX=%f,fRotY=%f,fRotZ=%f,fScaleX=%f,fScaleY=%f,fScaleZ=%f"
,
               
    Player[playerid][PID], AOP[playerid][i][ao_model], i, AOP[playerid][i][ao_bone], AOP[playerid][i][ao_x], AOP[playerid][i][ao_y], AOP[playerid][i][ao_z], AOP[playerid][i][ao_rx],AOP[playerid][i][ao_ry], AOP[playerid][i][ao_rz], AOP[playerid][i][ao_sx], AOP[playerid][i][ao_sy], AOP[playerid][i][ao_sz],
    AOP[playerid][i][ao_model], AOP[playerid][i][ao_bone], AOP[playerid][i][ao_x], AOP[playerid][i][ao_y], AOP[playerid][i][ao_z], AOP[playerid][i][ao_rx], AOP[playerid][i][ao_ry], AOP[playerid][i][ao_rz], AOP[playerid][i][ao_sx], AOP[playerid][i][ao_sy], AOP[playerid][i][ao_sz]);
Reply


Messages In This Thread
[MySQL] Storing data without duplicates. - by CherryMond - 20.02.2019, 13:18
Re: [MySQL] Storing data without duplicates. - by CherryMond - 20.02.2019, 13:25
Re: [MySQL] Storing data without duplicates. - by Calisthenics - 20.02.2019, 14:25
Re: [MySQL] Storing data without duplicates. - by CherryMond - 20.02.2019, 17:53
Re: [MySQL] Storing data without duplicates. - by Calisthenics - 21.02.2019, 08:04
Re: [MySQL] Storing data without duplicates. - by CherryMond - 21.02.2019, 08:18

Forum Jump:


Users browsing this thread: 2 Guest(s)