hilfe mein biz system geht nicht wen ich ein biz erstellen möchte steht da
ERROR
[20:09:29] Error-ID: 1062 | Error: Duplicate entry '1' for key 'PRIMARY' | Callback: | Query: INSERT INTO biz (id,name,besitzer,x,y,z,kostet) VALUES (1,'','Niemand',1480.241699,-1809.249877,18.795742,1)
[20:09:36] Error-ID: 1062 | Error: Duplicate entry '2' for key 'PRIMARY' | Callback: | Query: INSERT INTO biz (id,name,besitzer,x,y,z,kostet) VALUES (2,'AMENA KOI','Niemand',1480.249633,-1809.519287,18.795742,1)
[20:09:40] Error-ID: 1062 | Error: Duplicate entry '3' for key 'PRIMARY' | Callback: | Query: INSERT INTO biz (id,name,besitzer,x,y,z,kostet) VALUES (3,'AMENA KOI','Niemand',1480.481201,-1809.247680,18.795742,1)
SYSTEM
if(strcmp(cmd, "/newbiz", true) == 0) {
if(PlayerInfo[playerid][ALevel] == 1){
SendClientMessage(playerid, COLOR_GREEN, "Supporter sind nur zum supporten da");
return 1;
}
if(IsPlayerAdmin(playerid)){
if(PlayerInfo[playerid][ALevel] == 0) {
MeldungText(playerid, "Du bist kein Admin!", 5);
return 1;
}
tmp = strtok(cmdtext, idx);
if(!strlen(tmp)){
MeldungText(playerid, "Benutze: /newbiz [Kosten] [Name]", 6);
return 1;
}
new player1;
player1 = strval(tmp);
new length = strlen(cmdtext);
while ((idx < length) && (cmdtext[idx] <= ' ')){
idx++;
}
new offset = idx;
new result[128];
while ((idx < length) && ((idx - offset) < (sizeof(result) - 1))){
result[idx - offset] = cmdtext[idx];
idx++;
}
result[idx - offset] = EOS;
tmp = strtok(cmdtext, idx);
ladebize++;
new Float: spx, Float: spy, Float: spz;
GetPlayerPos(playerid, spx, spy,spz);
new sql[128];
format(sql, sizeof(sql), "INSERT INTO biz (id,name,besitzer,x,y,z,kostet) VALUES (%d,'%s','Niemand',%f,%f,%f,%d)",ladebize,result,spx,spy,spz,player1);
mysql_query(sql);
}
return 1;
}
