Beiträge von EllBundy

Ich bin da eben auf einen Befehl gestoßen wie SetPVar und GetPVar.
Ich sehe das als gute alternative für Variablen zu speichern, habe aber dazu noch paar Fragen.

Ist diese Variante besser als
enum pSpieler
{
//...
}
new Spieler[MAX_PLAYERS][pSpieler];

Des weiteren habe ich auf der SAMP Wiki seite gelesen, das nach Aufruf von OnPlayerDisconnect die PVar Variablen resettet werden. Stimmt das ?
Variables aren't reset until after OnPlayerDisconnect is called, so the values are still accessible in OnPlayerDisconnect.

Ich sehe da eigentlich einen Zeilenersparniss dabei, was nichts zu bedeuten hat. Was mich aber mehr Interessiert ist ob die Variante scriptschonender ist ?!
Freue mich auf eine Aufklärung

MFG EllBundy

https://picload.org/view/dclordog/westsidestart.png.html

Bekomme diese Meldung sobald ich auf Ausführen klicke, wenn ich nichts mache, wird anscheinend ein NPC Gekickt... Bei mehrerer Ausführung schließt sich iwann der Server

Woran könnte das liegen ?

ERRORMELDUNG in server_log.cfg
FEHLER » Die Scriptlizenz wurde nicht gefunden, das Script wurde nun gesperrt.

EDIT: Errormeldung beigefügt

So die Einträge werden nun gezählt, danke dafür.

Jjetzt habe ich das Problem das der DB-Eintrag "ID" nicht richtig wiedergeben wird !
[14:28:46] [LOAD]BIZ: Es wurde das Business 167772160 geladen.

Ich habe folgendes Problem, das der DB Eintrag nicht gezählt und somit auch nicht im Script geladen wird, da ja kein Eintrag vorhanden ist. Ich hoffe ihr könnt mir weiterhelfen.

Error Meldung der mysql.log
[ERROR] cache_get_row_count: no active cache

Bei ongamemodeinit:
LoadBiz(false, false); // Wird verwendet um alle bestehenden zu laden
LoadBiz(1, true) // Wird verwendet eine Bestimmte ID aus der DB zu laden
Übermittelte MYSQL:
printf Legende = rows/menu(true or false) - MYSQL-Befehl
[13:39:48] TEST: 0/0 - SELECT * FROM 'biz' // bei allen bestehenden
[13:51:25] TEST: 0/1 - SELECT * FROM `biz` WHERE `ID` = '1' // Bei einer Bestimmten ID

Script Business laden:

public LoadBiz(bID, bool:menu)
{
new str[256];
if(!menu){ mysql_format(handle, str, sizeof(str), "SELECT * FROM `biz`"); }
else{ mysql_format(handle, str, sizeof(str), "SELECT * FROM `biz` WHERE `ID` = '%d'", bID); }
new rows;
cache_get_row_count(rows);
printf("TEST: %d/%d - %s", rows, menu, str);
if(rows)
{
for(new i; i!=rows; i++)
{
cache_get_value_name_int(i, "ID", BizInfo[i][b_id]);
cache_get_value_name_int(i, "art", BizInfo[i][bArt]);
cache_get_value_name_int(i, "name", BizInfo[i][bName]);
cache_get_value_name_int(i, "preis", BizInfo[i][bPreis]);
cache_get_value_name_int(i, "besitzerID", BizInfo[i][bBesitzerID]);
cache_get_value_name(i, "besitzer", BizInfo[i][bBesitzer]);
cache_get_value_name_int(i, "pickupid", BizInfo[i][bPickupID]);
cache_get_value_name_float(i, "coordsX", BizInfo[i][bX]);
cache_get_value_name_float(i, "coordsY", BizInfo[i][bY]);
cache_get_value_name_float(i, "coordsZ", BizInfo[i][bZ]);
cache_get_value_name_float(i, "coordsX2", BizInfo[i][bX2]);
cache_get_value_name_float(i, "coordsY2", BizInfo[i][bY2]);
cache_get_value_name_float(i, "coordsZ2", BizInfo[i][bZ2]);
cache_get_value_name_int(i, "interiorID", BizInfo[i][bInteriorID]);
cache_get_value_name_int(i, "mapicon", BizInfo[i][bMapIcon]);
BizInfo[i][bPickup] = CreatePickup(BizInfo[i][bPickupID], 1, BizInfo[i][bX], BizInfo[i][bY], BizInfo[i][bZ], -1);
if(BizInfo[i][bBesitzerID])
{
format(str, sizeof(str), "%s\nBesitzer: %s\nDrücke ENTER für\neine Interaktion",BizInfo[i][bName], BizInfo[i][bBesitzer]);
BizInfo[i][bText] = Create3DTextLabel(str, COLOR_RED, BizInfo[i][bX], BizInfo[i][bY], BizInfo[i][bZ], 20.0, 0, 0);
}
else
{
format(str, sizeof(str), "%s\nPreis: %d\nDrücke ENTER für\neine Interaktion");
BizInfo[i][bText] = Create3DTextLabel(str, COLOR_LIMEGREEN, BizInfo[i][bX], BizInfo[i][bY], BizInfo[i][bZ], 20.0, 0, 0);
}
for(new pID; pID!=MAX_PLAYERS; pID++)
{
if(!IsPlayerNPC(pID)){ SetPlayerMapIcon(pID, i, BizInfo[i][bX], BizInfo[i][bY], BizInfo[i][bZ], BizInfo[i][bMapIcon], 0, MAPICON_LOCAL); }
}
printf("[LOAD]BIZ: Es wurde das Business %d geladen.", BizInfo[i][b_id]);
BizLoaded++;
}
printf("[BIZ] Es wurden %d Business geladen !", BizLoaded);
}
return 1;

MYSQL Eintrag:

Hi ich möchte bei einer IF Abfrage einen bestimmten Stringnamen abfragen, bekomme es aber leider nicht hin bzw. gefunden.

Meine Versuche/Beispiel
if(strlen(menu) == "admin"){ //... };

Diese Funktion funktoniert leider nicht, ich hoffe Ihr könnt mir behilflich sein

MFG EllBundy

case DIALOG_ADMINHAUSC3:
{
HausCreate[playerid][chIntID] = strval(inputtext);
CreateHouse(playerid, 3);
if(strval(inputtext) <= 0)
{
new string[1024], kaufstr[8];
if(HausCreate[playerid][chKaufart] == 1){ kaufstr = "Coins"; }
else if(HausCreate[playerid][chKaufart] == 2){ kaufstr = "SA$"; }
format(string, sizeof(string), "Interior-ID:\t%d\nKaufpreis:\t%d %s\nCoordsX:\t%f\nCoordsY:\t%f\nCoordsZ:\t%f\nCoordsFA:\t%f",inputtext,HausCreate[playerid][chKaufpreis],HausCreate[playerid][chKaufart],HausCreate[playerid][chX],HausCreate[playerid][chY],HausCreate[playerid][chZ],HausCreate[playerid][chFA]);
ShowPlayerDialog(playerid, DIALOG_ADMINHAUSC4, DIALOG_STYLE_MSGBOX, "Haussystem -> Informationen", string, "Erstellen", "Abbrechen");} //<- hier ist der Copy&Paste fehler :D
}
}

Danke für die hilfreiche antwort, immer solche kleine dinge !!

pastebin is addet !
Danke für den Tipp, ist wirklich übersichtlicher

D:\samp\Server\pawno\include\ocmd.inc(9) : warning 217: loose indentation
D:\samp\Server\gamemodes\reallife.pwn(518) : warning 217: loose indentation
D:\samp\Server\gamemodes\reallife.pwn(518) : error 014: invalid statement; not in switch
D:\samp\Server\gamemodes\reallife.pwn(579) : warning 209: function "OnDialogResponse" should return a value
D:\samp\Server\gamemodes\reallife.pwn(518) : warning 203: symbol is never used: "DIALOG_ADMINHAUSC4"
D:\samp\Server\gamemodes\reallife.pwn(518 -- 580) : error 010: invalid function or declaration
Pawn compiler 3.2.3664	 	 	Copyright (c) 1997-2006, ITB CompuPhase




2 Errors.

dialoge als enum:
enum
{
DIALOG_REGISTER,
DIALOG_LOGIN,
DIALOG_ADMINMENU,
DIALOG_ADMINHAUS,
DIALOG_ADMINHAUSC,
DIALOG_ADMINHAUSC1,
DIALOG_ADMINHAUSC2,
DIALOG_ADMINHAUSC3,
DIALOG_ADMINHAUSC4,
DIALOG_ADMINHAUSE,
DIALOG_ADMINHAUSCPLAYER,
DIALOG_ADMINFRAK,
DIALOG_ADMINBIZ
}

OnDialogRespone:
https://pastebin.com/QitrJXFd

Ich verstehe diese Errors nicht und komm einfach nicht auf deren Grund, DIALOG_ADMINHAUSC4 exestiert und wird auch genutzt.
Und den Error mit dem return für DialogRespone hatte ich auch nicht, bis ich den DIALOG_ADMINHAUSC4 eingefügt habe.

Ich hoffe ihr könnt mir helfen

MFG
EllBundy

habe sonst keinen log eintrag !!
oder gibt es noch eine log datei ??

die Query spuckt mir ja 2 Einträge aus, d.h. ja das die query bisher korrekt ist

public GetInteriorList(playerid)
{
printf("Test2");
new rows;
cache_get_row_count(rows);
printf("rows: %d", rows);
new dialogstr[4096],addstr[32],intname[32],intid;
for(new i = 0; i != rows; i++)
{
cache_get_value_name_int(i, "ID", intid);
cache_get_value_name(i, "name", intname);
format(addstr, sizeof(addstr),"%d\t%s\n",intid, intname);
strcat(dialogstr, addstr);
printf("Test3");
}
ShowPlayerDialog(playerid, DIALOG_ADMINHAUSC3, DIALOG_STYLE_TABLIST, "Haussystem -> Interior", dialogstr, "Weiter", "Abbrechen");
printf("Test4");
return 1;
}

case DIALOG_ADMINHAUSC2:
{
if(!response){ return CreateHouse(playerid, 0); }
switch(HausCreate[playerid][chKaufart])
{
case 1:
{
if(strval(inputtext) > 250){ HausCreate[playerid][chKaufpreis] = strval(inputtext); CreateHouse(playerid, 2); }
else{ return ShowPlayerDialog(playerid, DIALOG_ADMINHAUSC2, DIALOG_STYLE_INPUT, "Haussystem -> Kaufart -> Coins", "Gebe nun den Betrag ein:\nDer Betrag muss höher als 250 Coins sein !", "Weiter", "Abbrechen");}
}
case 2:
{
if(strval(inputtext) > 500000){ HausCreate[playerid][chKaufpreis] = strval(inputtext); CreateHouse(playerid, 2); }
else{ return ShowPlayerDialog(playerid, DIALOG_ADMINHAUSC2, DIALOG_STYLE_INPUT, "Haussystem -> Kaufart -> SA$", "Gebe nun den Betrag ein:\nDer Betrag muss höher als 500000 Coins sein !", "Weiter", "Abbrechen");}
}
}
mysql_tquery(handle,"SELECT * FROM `interior` WHERE `art` = 'haus'", "GetInteriorList", "d", playerid);
mysql_log();
printf("Test");
}
case DIALOG_ADMINHAUSC3:
{
HausCreate[playerid][chInterior] = listitem;
CreateHouse(playerid, 3);
}

[20:44:06] [WARNING] mysql_connect: no password specified
[20:47:29] [WARNING] mysql_connect: no password specified
[20:48:53] [WARNING] mysql_connect: no password specified
[20:57:06] [WARNING] mysql_connect: no password specified
[21:27:45] [WARNING] mysql_connect: no password specified
[21:30:34] [WARNING] mysql_connect: no password specified
[21:33:11] [WARNING] mysql_connect: no password specified
[21:34:58] [WARNING] mysql_connect: no password specified
[21:59:16] [WARNING] mysql_connect: no password specified
[22:00:52] [WARNING] mysql_connect: no password specified

nix neues, ausser das ein pw fehlt

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[22:00:52] filterscripts = "" (string)
[22:00:52]
[22:00:52] Server Plugins
[22:00:52] --------------
[22:00:52] Loading plugin: mysql
[22:00:52] >> plugin.mysql: R41-4 successfully loaded.
[22:00:52] Loaded.
[22:00:52] Loaded 1 plugins.

[22:00:52]
[22:00:52] Filterscripts
[22:00:52] ---------------
[22:00:52] Loaded 0 filterscripts.

[22:00:52]
--------------------------------------
[22:00:52] Reallife Gamemode by EllBundy
[22:00:52] --------------------------------------

[22:00:52] [MySQL] Verbindungsaufbau...
[22:00:52] [MySQL] Die Verbindung zur Datenbank wurde erfolgreich hergestellt! Handle: 1
[22:00:52] Script[gamemodes/Reallife.amx]: Run time error 20: "Invalid index parameter (bad entry point)"
[22:00:52] Number of vehicle models: 0
[22:00:52] LOAD: Haus[1] | X[0.000000] | Y[0.000000] | Z[0.000000] | Int[3]
[22:00:52] LOAD: Haus[2] | X[0.000000] | Y[0.000000] | Z[0.000000] | Int[2]
[22:00:52] LOAD: Haus[3] | X[0.000000] | Y[0.000000] | Z[0.000000] | Int[2]
[22:00:52] LOAD: Haus[4] | X[1105.630004] | Y[-311.832000] | Z[73.985099] | Int[2]
[22:00:52] LOAD: Haus[5] | X[1102.530029] | Y[-311.401000] | Z[73.992202] | Int[0]
[22:00:52] [HAUSSYSTEM] Es wurden 5 Häuser geladen.
[22:01:14] [connection] 127.0.0.1:62393 requests connection cookie.
[22:01:15] [connection] incoming connection: 127.0.0.1:62393 id: 0
[22:01:15] [join] Ellbundy has joined the server (0:127.0.0.1)
[22:01:30] Test
[22:01:30] Test2
[22:01:30] rows: 2

ich habe nun den debug entfernt ! dennoch bleibe ich bei der row anzeige stehen

Nein kein error mehr ! Aber funktioniert dennoch nicht

public GetInteriorList(playerid)
{
printf("Test2");
new rows;
cache_get_row_count(rows);
printf("rows: %d", rows);
new dialogstr[4096],addstr[32],intname[32],intid;
for(new i = 0; i != rows; i++)
{
cache_get_value_name_int(i, "ID", intid);
cache_get_value_name(i, "name", intname);
format(addstr, sizeof(addstr),"%d\t%s\n",intid, intname);
strcat(dialogstr, addstr);
mysql_log();
printf("Test3");
}
ShowPlayerDialog(playerid, DIALOG_ADMINHAUSC3, DIALOG_STYLE_TABLIST, "Haussystem -> Interior", dialogstr, "Weiter", "Abbrechen");
printf("Test4");
return 1;
}

Also habe nun testprint´s eingefügt, "Test2" und die Row anzahl werden korrekt angezeigt !
"Test 3" und "Test 4" werden nicht ausgegeben

[20:15:31] [WARNING] mysql_connect: no password specified
[20:16:27] [ERROR] error #1054 while executing query "INSERT INTO user (name, password) VALUES ('Ellbundy', MD5('Steven90'))": Unknown column 'password' in 'field list'
[20:16:39] [ERROR] error #1054 while executing query "INSERT INTO user (name, password) VALUES ('Ellbundy', MD5('steven90'))": Unknown column 'password' in 'field list'
[20:18:31] [WARNING] mysql_connect: no password specified
[20:24:59] [WARNING] mysql_connect: no password specified
[20:25:44] [WARNING] mysql_connect: no password specified
[20:30:46] [WARNING] mysql_connect: no password specified
[20:57:32] [WARNING] mysql_connect: no password specified
[22:09:35] [WARNING] mysql_connect: no password specified
[22:17:14] [WARNING] mysql_connect: no password specified
[22:19:41] [WARNING] mysql_connect: no password specified
[22:23:55] [WARNING] mysql_connect: no password specified
[18:01:05] [WARNING] mysql_connect: no password specified
[18:06:01] [WARNING] mysql_connect: no password specified
[16:05:48] [WARNING] mysql_connect: no password specified
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:05:48] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:09:49] [WARNING] mysql_connect: no password specified
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:09:49] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:10:28] [WARNING] mysql_connect: no password specified
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_float: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name_int: invalid row index '5' (number of rows: '5')
[16:10:28] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:12:04] [WARNING] mysql_connect: no password specified
[16:12:04] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:12:04] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:12:04] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:12:05] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:12:05] [ERROR] cache_get_value_name: invalid row index '5' (number of rows: '5')
[16:27:26] [WARNING] mysql_connect: no password specified
[19:41:06] [WARNING] mysql_connect: no password specified
[19:42:33] [ERROR] error #1064 while executing query "SELECT name FROM 'interior' WHERE art = 'haus'": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''interior' WHERE art = 'haus'' at line 1
[19:42:57] [ERROR] error #1064 while executing query "SELECT name FROM 'interior' WHERE art = 'haus'": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''interior' WHERE art = 'haus'' at line 1
[19:45:45] [WARNING] mysql_connect: no password specified
[19:47:42] [ERROR] error #1064 while executing query "SELECT * FROM 'interior' WHERE art = 'haus'": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''interior' WHERE art = 'haus'' at line 1
[19:48:55] [WARNING] mysql_connect: no password specified
[19:50:12] [ERROR] error #1064 while executing query "SELECT * FROM 'interior' WHERE art = 'haus'": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''interior' WHERE art = 'haus'' at line 1
[20:05:02] [WARNING] mysql_connect: no password specified
[20:05:11] [WARNING] mysql_connect: no password specified
[20:14:56] [WARNING] mysql_connect: no password specified
[20:22:36] [WARNING] mysql_connect: no password specified
[20:23:12] [ERROR] error #1054 while executing query "SELECT * FROM `interior` WHERE art = `haus`": Unknown column 'haus' in 'where clause'
[20:24:07] [WARNING] mysql_connect: no password specified
[20:24:58] [WARNING] mysql_connect: no password specified
[20:25:38] [ERROR] error #1054 while executing query "SELECT * FROM `interior` WHERE art = `haus`": Unknown column 'haus' in 'where clause'
[20:41:25] [WARNING] mysql_connect: no password specified
[20:44:06] [WARNING] mysql_connect: no password specified
[20:47:29] [WARNING] mysql_connect: no password specified
[20:48:53] [WARNING] mysql_connect: no password specified
[20:57:06] [WARNING] mysql_connect: no password specified

log_ core.txt
[20:43:53] [INFO] received Windows console close event; shutting log-core down

warnings.txt
[20:41:25] [plugins/mysql] mysql_connect: no password specified // Ist glaube ich weil ich kein passwort habe

Habe nun folgende Anfragen ausprobiert, aber die TABLIST erscheint immer noch nicht

tquery
mysql_tquery(handle,"SELECT * FROM `interior` WHERE `art` = 'haus'", "GetInteriorList", "d", playerid);

mysql_tquery(handle,"SELECT * FROM `interior` WHERE art = 'haus'", "GetInteriorList", "d", playerid);

pquery
mysql_pquery(handle,"SELECT * FROM `interior` WHERE `art` = 'haus'", "GetInteriorList", "d", playerid);
mysql_pquery(handle,"SELECT * FROM `interior` WHERE art = 'haus'", "GetInteriorList", "d", playerid);

Das kann doch nicht so schwer sein

Habe nun mal die funktion mysql_log(); eingefügt und er spuckt folgendes aus

[20:25:38] [plugins/mysql] error #1054 while executing query "SELECT * FROM `interior` WHERE art = `haus`": Unknown column 'haus' in 'where clause'

Datenbank ausschnitt
https://picload.org/view/dcocgpod/hausdb.png.html

Werde ich so abändern, aber zum Testen müsste ich den Dialog angezeigt bekommen, was ja erstmal mein Hauptproblem ist.

mysql_tquery(handle,"SELECT * FROM 'interior' WHERE art = 'haus'", "GetInteriorList", "d", playerid);

mysql_pquery(handle,"SELECT * FROM 'interior' WHERE art = 'haus'", "GetInteriorList", "d", playerid);

Beide Varianten funktionieren nicht. Der letzte Dialog wird ausgeführt, aber die Interiorliste erscheint nicht.

Hey danke für deine Antwort, aber bleibe nun bei meinem Letzten erstell Dialog stehen !

Response Dialog:
case DIALOG_ADMINHAUSC2:
{
if(!response){ return ShowPlayerDialog(playerid, DIALOG_ADMINHAUSC2, DIALOG_STYLE_INPUT, str, "Gebe nun den Betrag ein:", "Weiter", "Zurück"); }
switch(HausCreate[playerid][chKaufart])
{
case 1:
{
if(strval(inputtext) > 250){ HausCreate[playerid][chKaufpreis] = strval(inputtext); CreateHouse(playerid, 2); }
else{ return ShowPlayerDialog(playerid, DIALOG_ADMINHAUSC2, DIALOG_STYLE_INPUT, "Haussystem -> Kaufart -> Coins", "Gebe nun den Betrag ein:\nDer Betrag muss höher als 250 Coins sein !", "Weiter", "Zurück");}
}
case 2:
{
if(strval(inputtext) > 500000){ HausCreate[playerid][chKaufpreis] = strval(inputtext); CreateHouse(playerid, 2); }
else{ return ShowPlayerDialog(playerid, DIALOG_ADMINHAUSC2, DIALOG_STYLE_INPUT, "Haussystem -> Kaufart -> SA$", "Gebe nun den Betrag ein:\nDer Betrag muss höher als 500000 Coins sein !", "Weiter", "Zurück");}
} // Bis hier hin wird alles ausgeführt !!!
}
mysql_pquery(handle,"SELECT * FROM 'interior' WHERE art = 'haus'", "GetInteriorList", "d", playerid);
}

GetInteriorList:
public GetInteriorList(playerid)
{
new rows;
cache_get_row_count(rows);
new dialogstr[4096],addstr[32],intname[32];
for(new i; i<rows; i++)
{
cache_get_value_name_int(i, "ID", HausCreate[playerid][chIntID]);
cache_get_value_name(i, "name", intname);
format(addstr, sizeof(addstr),"[%d]%s\n",HausCreate[playerid][chIntID], intname);
strcat(dialogstr, addstr);
}
ShowPlayerDialog(playerid, DIALOG_ADMINHAUSC3, DIALOG_STYLE_LIST, "Haussystem -> Interior", dialogstr, "Weiter", "Zurück");
return 1;
}

Eine weitere Frage !
Wie kann ich die ID übermitteln, damit ich bei dem listitem die richtige ID bekomme ?