Wie geht dieser Fehler weg bzw wie behebe ich ihn ?
[01:53:26] Error-ID: 1054 | Error: Unknown column 'Meth_Sucktfaktor' in 'field list' | Callback: | Query: UPDATE `server_user` SET `Meth_Sucktfaktor` = '3' WHERE `id` = '1980601'
Die Spalte existiert in der Datenbank bei server_user
hier ist noch der Code wo das kommt
if(strcmp(cmd, "/usedrugs", true) == 0){
if(IsACop(playerid) || PlayerInfo[playerid][Team] == 6){
SendClientMessage(playerid, COLOR_RED, "Nur für Gangs/Mafien und Zivis!");
return 1;
}
new tmp22[128];
new phonenumb;
tmp22 = strtok(cmdtext, idx);
if(!strlen(tmp22)) {
SendClientMessage(playerid, COLOR_WHITE, "Benutze: /usedrugs [Drogensorte 1,2,3,4,5 oder 6]");
return 1;
}
phonenumb = strval(tmp22);
for (new i=0; i < MAX_Z_ZONAS; i++)
{
if(ZoneInfo[i][war] == 1)
{
if(isPlayerInArea19(playerid, ZoneInfo[i][zMinX],ZoneInfo[i][zMinY],ZoneInfo[i][zMaxX],ZoneInfo[i][zMaxY]))
{
if(ZoneInfo[i][war] == 1 && ZoneInfo[i][only_zonefight] == 0)
{
SendClientMessage(playerid, COLOR_RED, "In einer Kampf Zone wird nicht gehealt!");
return 1;
}
}
}
}
if(PlayerInfo[playerid][healpause] == 1)
{
SendClientMessage(playerid, COLOR_RED, "Du hast 1 min. ''Heal-Pause''");
return 1;
}
if(phonenumb == 1){
if(PlayerInfo[playerid][drogens] > 1){
if(PlayerStoned[playerid] >= 4) {
PlayerStoned[playerid] += 1;
GameTextForPlayer(playerid, "~w~Bekifft", 4000, 1);
return 1;
}
new Float:health;
GetPlayerHealth(playerid, health);
new hp = 10;
PlayerInfo[playerid][healpause] = 1;
SetPlayerHealthk(playerid, health + hp);
SendClientMessage(playerid, COLOR_GREY, "2 gramm Hanf benutzt");
SetPlayerSpecialAction(playerid,SPECIAL_ACTION_SMOKE_CIGGY);
PlayerInfo[playerid][drogens] -= 2;
new string348901[128];
format(string348901, sizeof(string348901), "* %s benutzt Hanf", PlayerName(playerid));
ProxDetector(30.0, playerid, string348901, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
}
else{
SendClientMessage(playerid, COLOR_GREY, "Du hast keine Drogen!");
}
}
else if(phonenumb == 2){
if(PlayerInfo[playerid][drogens1] > 1){
if(PlayerStoned[playerid] >= 4) {
PlayerStoned[playerid] += 1;
GameTextForPlayer(playerid, "~w~Bekifft", 4000, 1);
return 1;
}
new Float:health;
GetPlayerHealth(playerid, health);
new hp = 15;
PlayerInfo[playerid][healpause] = 1;
SetPlayerHealthk(playerid, health + hp);
SendClientMessage(playerid, COLOR_GREY, "2 gramm Cannabis benutzt");
SetPlayerSpecialAction(playerid,SPECIAL_ACTION_SMOKE_CIGGY);
PlayerInfo[playerid][drogens1] -= 2;
new string348901[128];
format(string348901, sizeof(string348901), "* %s raucht Cannabis", PlayerName(playerid));
ProxDetector(30.0, playerid, string348901, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
}
else{
SendClientMessage(playerid, COLOR_GREY, "Du hast keine Drogen!");
}
}
else if(phonenumb == 3){
if(PlayerInfo[playerid][drogens2] > 1){
if(PlayerStoned[playerid] >= 4) {
PlayerStoned[playerid] += 1;
GameTextForPlayer(playerid, "~w~Bekifft", 4000, 1);
return 1;
}
new Float:health;
GetPlayerHealth(playerid, health);
new hp = 22;
PlayerInfo[playerid][healpause] = 1;
SetPlayerHealthk(playerid, health + hp);
SendClientMessage(playerid, COLOR_GREY, "2 gramm Whitewidow benutzt");
SetPlayerSpecialAction(playerid,SPECIAL_ACTION_SMOKE_CIGGY);
PlayerInfo[playerid][drogens2] -= 2;
new string348901[128];
format(string348901, sizeof(string348901), "* %s benutzt Whitewidow", PlayerName(playerid));
ProxDetector(30.0, playerid, string348901, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
}
else{
SendClientMessage(playerid, COLOR_GREY, "Du hast keine Drogen!");
}
}
else if(phonenumb == 4){
if(PlayerInfo[playerid][drogens3] > 1){
if(PlayerStoned[playerid] >= 4) {
PlayerStoned[playerid] += 1;
GameTextForPlayer(playerid, "~w~Bekifft", 4000, 1);
return 1;
}
new Float:health;
GetPlayerHealth(playerid, health);
new hp = 30;
PlayerInfo[playerid][healpause] = 1;
SetPlayerHealthk(playerid, health + hp);
SendClientMessage(playerid, COLOR_GREY, "2 gramm Koks benutzt");
SetPlayerSpecialAction(playerid,SPECIAL_ACTION_SMOKE_CIGGY);
PlayerInfo[playerid][drogens3] -= 2;
new string348901[128];
format(string348901, sizeof(string348901), "* %s schnupft 'ne Line Koks", PlayerName(playerid));
ProxDetector(30.0, playerid, string348901, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
if(PlayerInfo[playerid][meth_Suchtfaktor] == 0) PlayerInfo[playerid][meth_Suchtfaktor] = 3;
PlayerInfo[playerid][meth_Suchtfaktor]+=1;
UpdateSpieler("Meth_Sucktfaktor",PlayerInfo[playerid][meth_Suchtfaktor],playerid);
}
else{
SendClientMessage(playerid, COLOR_GREY, "Du hast keine Drogen!");
}
}
else if(phonenumb == 5){
if(PlayerInfo[playerid][drogens4] > 1){
if(PlayerStoned[playerid] >= 4) {
PlayerStoned[playerid] += 1;
GameTextForPlayer(playerid, "~w~Bekifft", 4000, 1);
return 1;
}
new Float:health;
GetPlayerHealth(playerid, health);
new hp = 45;
PlayerInfo[playerid][healpause] = 1;
SetPlayerHealthk(playerid, health + hp);
SendClientMessage(playerid, COLOR_GREY, "2 gramm Heroin benutzt");
SetPlayerSpecialAction(playerid,SPECIAL_ACTION_SMOKE_CIGGY);
PlayerInfo[playerid][drogens4] -= 2;
new string348901[128];
format(string348901, sizeof(string348901), "* %s spritzt sich Heroin", PlayerName(playerid));
ProxDetector(30.0, playerid, string348901, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
PlayerInfo[playerid][meth_Suchtfaktor]+=2;
UpdateSpieler("Meth_Sucktfaktor",PlayerInfo[playerid][meth_Suchtfaktor],playerid);
}
else{
SendClientMessage(playerid, COLOR_GREY, "Du hast keine Drogen!");
}
}
else if(phonenumb == 6){
if(PlayerInfo[playerid][drogens5] > 1){
if(PlayerStoned[playerid] >= 4) {
PlayerStoned[playerid] += 1;
GameTextForPlayer(playerid, "~w~Bekifft", 4000, 1);
return 1;
}
new Float:health;
GetPlayerHealth(playerid, health);
new hp = 65;
PlayerInfo[playerid][healpause] = 1;
SetPlayerHealthk(playerid, health + hp);
SendClientMessage(playerid, COLOR_GREY, "2 gramm Meth benutzt");
SetPlayerSpecialAction(playerid,SPECIAL_ACTION_SMOKE_CIGGY);
PlayerInfo[playerid][drogens5] -= 2;
new string348901[128];
format(string348901, sizeof(string348901), "* %s schnupft 'ne Line Crystal Meth", PlayerName(playerid));
ProxDetector(30.0, playerid, string348901, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
if(PlayerInfo[playerid][meth_Suchtfaktor] == 0) PlayerInfo[playerid][meth_Suchtfaktor] = 5;
PlayerInfo[playerid][meth_Suchtfaktor]+=2;
methuse[playerid]=4;
UpdateSpieler("Meth_Sucktfaktor",PlayerInfo[playerid][meth_Suchtfaktor],playerid);
}
else{
SendClientMessage(playerid, COLOR_GREY, "Du brauscht schon was, damit das ballert...");
}
}
return 1;
}
Und hier ist das Update
format(updval, sizeof(updval), "UPDATE `server_user` SET `zeit`='%d',`punkte`='%d',`drogens3`='%d',`NCheckpoints`='%d',`drogens1`='%d',`apris`='%d',`drogens`='%d',`mietezeit`='%d',`kopfgeld`='%d',`Meth_Suchtfaktor`='%d', ",PlayerInfo[playerid][GesamtZ],PlayerInfo[playerid][punkte],ddas2,PlayerInfo[playerid][NCheckpoints],drog,pris,PlayerInfo[playerid][drogens], PlayerInfo[playerid][mietezeit], PlayerInfo[playerid][kopfgeld],PlayerInfo[playerid][meth_Suchtfaktor]);
format(temp, sizeof(temp), "mutePC = '%d', muteNC = '%d', muteO = '%d', muteL = '%d', muteSMS = '%d', muteF = '%d', tja = '%d', tnein = '%d' WHERE `id` = '%d'", mute[0], mute[1], mute[2], mute[3], mute[4],mute[5], PlayerInfo[playerid][treffen_ja], PlayerInfo[playerid][treffen_nein],PlayerInfo[playerid][Spielerzid]);
strcat(updval, temp);
mysql_query(updval);
cache_get_field_content(0, "Meth_Suchtfaktor", query); PlayerInfo[playerid][meth_Suchtfaktor] = strval(query);