Haus System Fehler

Guten Tag liebe Leute,
Ich habe das Problem, das wenn ich ein Haus per Befehl erstellen möchte, dies auch teils funktioniert er mir dann aber ~10 Einträge von verschieden Häusern in die Datenbank knallt.

InteriorInfo:
enum interEnum
{
int_ID,
Float:int_exitX,
Float:int_exitY,
Float:int_exitZ,
int_type
};

new InteriorInfo[][interEnum] =
{
//Apartments
{12,444.646911,508.239044,1001.419494,1},
{1,244.411987,305.032989,999.148437,1},
{2,271.884979,306.631988,999.148437,1},
{2,1523.509887,-47.821197,1002.130981,1},
{},
//Houses
{8,2807.619873,-1171.899902,1025.570312,2},
{3,2496.049804,-1695.238159,1014.742187,2},
{5,318.564971,1118.209960,1083.882812,2},
{5,2350.339843,-1181.649902,1027.976562,2},
{1,2527.654052,-1679.388305,1015.498596,2},
//Villas
{12,2324.419921,-1145.568359,1050.710083,3},
{5,1267.663208,-781.323242,1091.906250,3}
};
Btw: Ist natürlich alles eingereiht.

Bilder der Datenbank:

Schonmal danke im vorraus.

Klappt soweit außer dass, er nicht die richtigen Exit Daten aus dem Enum ausliest. Also er trägt nicht die richtigen Daten ein sondern immer die gleichen wo er mich beim eintreten dann ich einen Schwarzen Raum mit einen Spiegel setzt.
Wenn ich /interior nutze gibt er mir auch den richtigen aus

//EDIT:
@Mencent:
Jeffry:

Alles rund um Häuser sieht gerade so aus:

Jeffry:
Ich habe das Problem gefunden kann es aber nicht beheben, da ich nicht weiß wie.
Es liegt an dem Enum, er liest immer nur die erste Zeile aus dem InteriorInfo Enum aus und trägt die Exit/Interior Positionen in die Datenbank ein.
Leider weiß ich halt nicht wie ich durch dieses enum switche.

//EDIT:

Und ich habe gemerkt, dass er bei dem erstellen keine neuen PickUps und TextLables macht.

Nein und Ja.
Guck mal:
Ist ein Haus aus dem Enum mit der Interior ID: 5
{5,2350.339843,-1181.649902,1027.976562},
Ist ein Villen Interior aus dem Enum mit der Interior ID: 5
{5,1267.663208,-781.323242,1091.906250}

Wenn ich nun diese Villa erstellen möchte, sucht er nichtmal nach der 5 er geht einfach das Enum runter bis er Zahlen hat die noch unverwendet sind. Da weiß ich nicht wie ich überprüfen soll ob die Variable "inter" mit der Interior ID und der Variable Type übereinstimmt.
Ich habe mir das so gedacht:
Jede Zeile erhält nochmal einen Typen also Apartment Haus oder Villa.
Nun weiß ich nicht wie ich in einer if Abfrage abfragen soll ob Interior ID und Type übereinstimmen. Habe da bis jetzt nur Errors bekommen.
Und wenn ich das schon wieder so sehe weiß ich das meine Methode wieder zu 90% nicht funktionieren wird weil, es die Interior ID: 2 schon 2x allein in Apartments existiert also: Bei Abfrage gleiche Interior ID und gleicher Type.

enum interEnum
{
int_ID,
Float:int_exitX,
Float:int_exitY,
Float:int_exitZ,
int_type
};

new InteriorInfo[][interEnum] =
{
//Apartments
{12,444.646911,508.239044,1001.419494,1},
{1,244.411987,305.032989,999.148437,1},
{2,271.884979,306.631988,999.148437,1},
{2,1523.509887,-47.821197,1002.130981,1},
{},
//Houses
{8,2807.619873,-1171.899902,1025.570312,2},
{3,2496.049804,-1695.238159,1014.742187,2},
{5,318.564971,1118.209960,1083.882812,2},
{5,2350.339843,-1181.649902,1027.976562,2},
{1,2527.654052,-1679.388305,1015.498596,2},
//Villas
{12,2324.419921,-1145.568359,1050.710083,3},
{5,1267.663208,-781.323242,1091.906250,3}
};

//EDIT:
Siehst du auch bei dem Screenshot das Haus-ID: 1 keine Einträge außer Koordinaten hat was an sich schon ein Fehler ist, da dies beim erstellen eingetragen wird etc.

Aber es besteht doch trotzdem noch das Problem welches ich //EDIT: habe.
//EDITwelchesNichtsMitDemEditImSatzDrüberZuTuhenHat::
Ich bin mir gar nicht sicher ob man dieses Problem auf eine leichte Weise umgehen kann.

Befehl:
ocmd:hcreate(playerid,params[])
{
if(!IsPlayerAnAdmin(playerid))return SendClientMessage(playerid,Rot,"Error: {FFFFFF}You are not allowed to use this Command.");
if(!IsPlayerAdminRank(playerid,4))return SendClientMessage(playerid,Rot,"Error: {FFFFFF}You are not allowed to use this Command.");
new inter,price,type;
if(sscanf(params,"iii",inter,type,price))return SendClientMessage(playerid,Rot,"Error: {FFFFFF}Use /hcreate [Interior ID] [Type] [BuyPrice]"),
SendClientMessage(playerid,Grau,"[Types]: 1: Apartment, 2: House, 3: Villa");
//if(inter != InteriorInfo[inter][int_ID])return SendClientMessage(playerid,Rot,"Error: {FFFFFF}This isn't a Valid Interior. Use /validint to see what Interiors are Valid.");
for(new i=0;i<MAX_HOUSES;i++)
{
if(strlen(HouseInfo[i][h_owner]))continue;
{
new query[512];
new Float:pos[3];
GetPlayerPos(playerid,pos[0],pos[1],pos[2]);
HouseInfo[i][h_enterX] = pos[0];
HouseInfo[i][h_enterY] = pos[1];
HouseInfo[i][h_enterZ] = pos[2];
new count, tmp;
for(new j=0; j<sizeof(HouseInfo); j++) if(HouseInfo[j][h_int] == inter && HouseInfo[j][h_type] == type) count++;
for(new j=0; j<sizeof(HouseInfo); j++)
{
if(InteriorInfo[j][int_ID] == inter && InteriorInfo[j][int_type] == type)
{
if(tmp == count)
{
HouseInfo[i][h_exitX] = InteriorInfo[j][int_exitX];
HouseInfo[i][h_exitY] = InteriorInfo[j][int_exitY];
HouseInfo[i][h_exitZ] = InteriorInfo[j][int_exitZ];
}
}
tmp++;
}
HouseInfo[i][h_int] = inter;
format(HouseInfo[i][h_owner], 24, " ");
format(query,sizeof(query),"INSERT INTO Houses (id,Owner,EnterPosX,EnterPosY,EnterPosZ,ExitPosX,ExitPosY,ExitPosZ,Interior) VALUES ('%i','%s','%f','%f','%f','%f','%f','%f','%i')",
i,HouseInfo[i][h_owner],HouseInfo[i][h_enterX],HouseInfo[i][h_enterY],HouseInfo[i][h_enterZ],HouseInfo[i][h_exitX],HouseInfo[i][h_exitY],HouseInfo[i][h_exitZ],HouseInfo[i][h_int]);
mysql_pquery(Handle,query);
HouseInfo[i][h_vw] = cache_get_field_content_int(i,"VirtualWorld");
HouseInfo[i][h_buyprice] = price;
HouseInfo[i][h_rentprice] = 100;
HouseInfo[i][h_bought] = 0;
HouseInfo[i][h_rentable] = 0;
HouseInfo[i][h_locked] = 1;
HouseInfo[i][h_money] = 0;
HouseInfo[i][h_type] = type;
format(query,sizeof(query),"UPDATE Houses SET BuyPrice='%i',RentPrice='%i',Bought='%i',IsLocked='%i',Money='%i',`Type`='%i',RentAble='%i' WHERE id='%i'",
HouseInfo[i][h_buyprice],HouseInfo[i][h_rentprice],HouseInfo[i][h_bought],HouseInfo[i][h_locked],HouseInfo[i][h_money],HouseInfo[i][h_type],HouseInfo[i][h_rentable],i);
mysql_pquery(Handle,query);
if(HouseInfo[i][h_type] == 0)
{
new str[128];
format(str,sizeof(str),"This Apartment has NO Owner.Type /buyhouse to buy it.\nPrice: %i$",HouseInfo[i][h_buyprice]);
Create3DTextLabel(str,Weiß,HouseInfo[i][h_enterX],HouseInfo[i][h_enterY],HouseInfo[i][h_enterZ],10,0,0);
CreatePickup(1274,0,HouseInfo[i][h_enterX],HouseInfo[i][h_enterY],HouseInfo[i][h_enterZ],0);
}
else if(HouseInfo[i][h_type] == 1)
{
new str[128];
format(str,sizeof(str),"This House has NO Owner.Type /buyhouse to buy it.\nPrice: %i$",HouseInfo[i][h_buyprice]);
Create3DTextLabel(str,Weiß,HouseInfo[i][h_enterX],HouseInfo[i][h_enterY],HouseInfo[i][h_enterZ],10,0,0);
CreatePickup(1274,0,HouseInfo[i][h_enterX],HouseInfo[i][h_enterY],HouseInfo[i][h_enterZ],0);
}
else if(HouseInfo[i][h_type] == 2)
{
new str[128];
format(str,sizeof(str),"This Villa has NO Owner.Type /buyhouse to buy it.\nPrice: %i$",HouseInfo[i][h_buyprice]);
Create3DTextLabel(str,Weiß,HouseInfo[i][h_enterX],HouseInfo[i][h_enterY],HouseInfo[i][h_enterZ],10,0,0);
CreatePickup(1274,0,HouseInfo[i][h_enterX],HouseInfo[i][h_enterY],HouseInfo[i][h_enterZ],0);
}
return 1;
}
}
return 1;
}
Datenbank:

Klappt so halbwegs:

//EDIT:
Debug:

[19:06:25] count: 0
[19:06:25] 12 == 12 | 1 == 1
[19:06:25] 0 == 0
[19:06:25] Nutze InteriorInfo 0
[19:06:25] 1 == 12 | 1 == 1
[19:06:25] 2 == 12 | 1 == 1
[19:06:25] 2 == 12 | 1 == 1
[19:06:25] 0 == 12 | 0 == 1
[19:06:25] 8 == 12 | 2 == 1
[19:06:25] 3 == 12 | 2 == 1
[19:06:25] 5 == 12 | 2 == 1
[19:06:25] 5 == 12 | 2 == 1
[19:06:25] 1 == 12 | 2 == 1
[19:06:25] 12 == 12 | 3 == 1
[19:06:25] 5 == 12 | 3 == 1
[19:06:44] count: 0
[19:06:44] 12 == 8 | 1 == 2
[19:06:44] 1 == 8 | 1 == 2
[19:06:44] 2 == 8 | 1 == 2
[19:06:44] 2 == 8 | 1 == 2
[19:06:44] 0 == 8 | 0 == 2
[19:06:44] 8 == 8 | 2 == 2
[19:06:44] 5 == 0
[19:06:44] 3 == 8 | 2 == 2
[19:06:44] 5 == 8 | 2 == 2
[19:06:44] 5 == 8 | 2 == 2
[19:06:44] 1 == 8 | 2 == 2
[19:06:44] 12 == 8 | 3 == 2
[19:06:44] 5 == 8 | 3 == 2
[19:07:02] count: 0
[19:07:02] 12 == 5 | 1 == 3
[19:07:02] 1 == 5 | 1 == 3
[19:07:02] 2 == 5 | 1 == 3
[19:07:02] 2 == 5 | 1 == 3
[19:07:02] 0 == 5 | 0 == 3
[19:07:02] 8 == 5 | 2 == 3
[19:07:02] 3 == 5 | 2 == 3
[19:07:02] 5 == 5 | 2 == 3
[19:07:02] 5 == 5 | 2 == 3
[19:07:02] 1 == 5 | 2 == 3
[19:07:02] 12 == 5 | 3 == 3
[19:07:02] 5 == 5 | 3 == 3
[19:07:02] 11 == 0

Ich glaube momentan besteht eine 50/50 Chance ein Haus richtig zu erstellen


ocmd:hcreate(playerid,params[])
{
if(!IsPlayerAnAdmin(playerid))return SendClientMessage(playerid,Rot,"Error: {FFFFFF}You are not allowed to use this Command.");
if(!IsPlayerAdminRank(playerid,4))return SendClientMessage(playerid,Rot,"Error: {FFFFFF}You are not allowed to use this Command.");
new inter,price,type;
if(sscanf(params,"iii",inter,type,price))return SendClientMessage(playerid,Rot,"Error: {FFFFFF}Use /hcreate [Interior ID] [Type] [BuyPrice]"),
SendClientMessage(playerid,Grau,"[Types]: 1: Apartment, 2: House, 3: Villa");
if(type < 1 || type > 3)return SendClientMessage(playerid,Rot,"Error: Something's wrong with the Type");
//if(inter != InteriorInfo[inter][int_ID])return SendClientMessage(playerid,Rot,"Error: {FFFFFF}This isn't a Valid Interior. Use /validint to see what Interiors are Valid.");
for(new i=0;i<MAX_HOUSES;i++)
{
if(strlen(HouseInfo[i][h_owner]))continue;
{
new query[512];
new Float:pos[3];
GetPlayerPos(playerid,pos[0],pos[1],pos[2]);
HouseInfo[i][h_enterX] = pos[0];
HouseInfo[i][h_enterY] = pos[1];
HouseInfo[i][h_enterZ] = pos[2];
new count, tmp;
for(new j=0; j<sizeof(HouseInfo); j++) if(HouseInfo[j][h_int] == inter && HouseInfo[j][h_type] == type) count++;
printf("count: %d", count);
for(new j=0; j<sizeof(InteriorInfo); j++)
{
printf("%d == %d | %d == %d", InteriorInfo[j][int_ID], inter, InteriorInfo[j][int_type], type);
if(InteriorInfo[j][int_ID] == inter && InteriorInfo[j][int_type] == type)
{
printf("%d == %d", tmp, count);
if(tmp == count)
{
printf("Nutze InteriorInfo %d", j);
HouseInfo[i][h_exitX] = InteriorInfo[j][int_exitX];
HouseInfo[i][h_exitY] = InteriorInfo[j][int_exitY];
HouseInfo[i][h_exitZ] = InteriorInfo[j][int_exitZ];
}
tmp++;
}
}
HouseInfo[i][h_int] = inter;
format(HouseInfo[i][h_owner], 24, " ");
format(query,sizeof(query),"INSERT INTO Houses (id,Owner,EnterPosX,EnterPosY,EnterPosZ,ExitPosX,ExitPosY,ExitPosZ,Interior) VALUES ('%i','%s','%f','%f','%f','%f','%f','%f','%i')",
i,HouseInfo[i][h_owner],HouseInfo[i][h_enterX],HouseInfo[i][h_enterY],HouseInfo[i][h_enterZ],HouseInfo[i][h_exitX],HouseInfo[i][h_exitY],HouseInfo[i][h_exitZ],HouseInfo[i][h_int]);
mysql_pquery(Handle,query);
HouseInfo[i][h_vw] = cache_get_field_content_int(i,"VirtualWorld");
HouseInfo[i][h_buyprice] = price;
HouseInfo[i][h_rentprice] = 100;
HouseInfo[i][h_bought] = 0;
HouseInfo[i][h_rentable] = 0;
HouseInfo[i][h_locked] = 1;
HouseInfo[i][h_money] = 0;
HouseInfo[i][h_type] = type;
format(query,sizeof(query),"UPDATE Houses SET BuyPrice='%i',RentPrice='%i',Bought='%i',IsLocked='%i',Money='%i',`Type`='%i',RentAble='%i' WHERE id='%i'",
HouseInfo[i][h_buyprice],HouseInfo[i][h_rentprice],HouseInfo[i][h_bought],HouseInfo[i][h_locked],HouseInfo[i][h_money],HouseInfo[i][h_type],HouseInfo[i][h_rentable],i);
mysql_pquery(Handle,query);
if(HouseInfo[i][h_type] == 1)
{
new str[128];
format(str,sizeof(str),"This Apartment has NO Owner.Type /buyhouse to buy it.\nPrice: %i$",HouseInfo[i][h_buyprice]);
Create3DTextLabel(str,Weiß,HouseInfo[i][h_enterX],HouseInfo[i][h_enterY],HouseInfo[i][h_enterZ],10,0,0);
CreatePickup(1274,0,HouseInfo[i][h_enterX],HouseInfo[i][h_enterY],HouseInfo[i][h_enterZ],0);
}
else if(HouseInfo[i][h_type] == 2)
{
new str[128];
format(str,sizeof(str),"This House has NO Owner.Type /buyhouse to buy it.\nPrice: %i$",HouseInfo[i][h_buyprice]);
Create3DTextLabel(str,Weiß,HouseInfo[i][h_enterX],HouseInfo[i][h_enterY],HouseInfo[i][h_enterZ],10,0,0);
CreatePickup(1274,0,HouseInfo[i][h_enterX],HouseInfo[i][h_enterY],HouseInfo[i][h_enterZ],0);
}
else if(HouseInfo[i][h_type] == 3)
{
new str[128];
format(str,sizeof(str),"This Villa has NO Owner.Type /buyhouse to buy it.\nPrice: %i$",HouseInfo[i][h_buyprice]);
Create3DTextLabel(str,Weiß,HouseInfo[i][h_enterX],HouseInfo[i][h_enterY],HouseInfo[i][h_enterZ],10,0,0);
CreatePickup(1274,0,HouseInfo[i][h_enterX],HouseInfo[i][h_enterY],HouseInfo[i][h_enterZ],0);
}
return 1;
}
}
return 1;
}

mysql_log:

[19:54:15] [DEBUG] mysql_pquery - connection: 1, query: "INSERT INTO Houses (id,Owner,EnterPosX,EnterPosY,EnterPosZ,ExitP", callback: "(null)", format: "(null)"
[19:54:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: "VirtualWorld", connection: 1
[19:54:15] [WARNING] cache_get_field_content_int - no active cache
[19:54:15] [DEBUG] mysql_pquery - connection: 1, query: "UPDATE Houses SET BuyPrice='10000',RentPrice='100',Bought='0',Is", callback: "(null)", format: "(null)"
[19:54:15] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:54:15] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:54:15] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 6.121 milliseconds
[19:54:15] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[19:54:15] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 5.861 milliseconds
[19:54:15] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[19:54:46] [DEBUG] mysql_pquery - connection: 1, query: "INSERT INTO Houses (id,Owner,EnterPosX,EnterPosY,EnterPosZ,ExitP", callback: "(null)", format: "(null)"
[19:54:46] [DEBUG] cache_get_field_content_int - row: 1, field_name: "VirtualWorld", connection: 1
[19:54:46] [WARNING] cache_get_field_content_int - no active cache
[19:54:46] [DEBUG] mysql_pquery - connection: 1, query: "UPDATE Houses SET BuyPrice='25000',RentPrice='100',Bought='0',Is", callback: "(null)", format: "(null)"
[19:54:46] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:54:46] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.208 milliseconds
[19:54:46] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[19:54:46] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:54:46] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 4.860 milliseconds
[19:54:46] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[19:54:54] [DEBUG] mysql_pquery - connection: 1, query: "INSERT INTO Houses (id,Owner,EnterPosX,EnterPosY,EnterPosZ,ExitP", callback: "(null)", format: "(null)"
[19:54:54] [DEBUG] cache_get_field_content_int - row: 2, field_name: "VirtualWorld", connection: 1
[19:54:54] [WARNING] cache_get_field_content_int - no active cache
[19:54:54] [DEBUG] mysql_pquery - connection: 1, query: "UPDATE Houses SET BuyPrice='50000',RentPrice='100',Bought='0',Is", callback: "(null)", format: "(null)"
[19:54:54] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:54:54] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.178 milliseconds
[19:54:54] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[19:54:54] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:54:54] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 6.258 milliseconds
[19:54:54] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

Koordinaten passen soweit ich das sehe auch, aber wie du siehst werden die End-Daten nicht mehr übermittel beim erstellen des Hauses.

Server_log:

[19:54:15] count: 0
[19:54:15] 12 == 2 | 1 == 1
[19:54:15] 1 == 2 | 1 == 1
[19:54:15] 2 == 2 | 1 == 1
[19:54:15] 0 == 0
[19:54:15] Nutze InteriorInfo 2
[19:54:15] 2 == 2 | 1 == 1
[19:54:15] 1 == 0
[19:54:15] 0 == 2 | 0 == 1
[19:54:15] 8 == 2 | 2 == 1
[19:54:15] 3 == 2 | 2 == 1
[19:54:15] 5 == 2 | 2 == 1
[19:54:15] 5 == 2 | 2 == 1
[19:54:15] 1 == 2 | 2 == 1
[19:54:15] 12 == 2 | 3 == 1
[19:54:15] 5 == 2 | 3 == 1
[19:54:46] count: 0
[19:54:46] 12 == 5 | 1 == 2
[19:54:46] 1 == 5 | 1 == 2
[19:54:46] 2 == 5 | 1 == 2
[19:54:46] 2 == 5 | 1 == 2
[19:54:46] 0 == 5 | 0 == 2
[19:54:46] 8 == 5 | 2 == 2
[19:54:46] 3 == 5 | 2 == 2
[19:54:46] 5 == 5 | 2 == 2
[19:54:46] 0 == 0
[19:54:46] Nutze InteriorInfo 7
[19:54:46] 5 == 5 | 2 == 2
[19:54:46] 1 == 0
[19:54:46] 1 == 5 | 2 == 2
[19:54:46] 12 == 5 | 3 == 2
[19:54:46] 5 == 5 | 3 == 2
[19:54:54] count: 0
[19:54:54] 12 == 12 | 1 == 3
[19:54:54] 1 == 12 | 1 == 3
[19:54:54] 2 == 12 | 1 == 3
[19:54:54] 2 == 12 | 1 == 3
[19:54:54] 0 == 12 | 0 == 3
[19:54:54] 8 == 12 | 2 == 3
[19:54:54] 3 == 12 | 2 == 3
[19:54:54] 5 == 12 | 2 == 3
[19:54:54] 5 == 12 | 2 == 3
[19:54:54] 1 == 12 | 2 == 3
[19:54:54] 12 == 12 | 3 == 3
[19:54:54] 0 == 0
[19:54:54] Nutze InteriorInfo 10
[19:54:54] 5 == 12 | 3 == 3