Beiträge von RaPTiiC

Ich weiß nicht ob das dass richtige ist der mysql log:

[23:02:57] [DEBUG] mysql_close(1)

[23:02:57] [DEBUG] CHandleManager::Destroy(this=0x72b280, handle=0x739f68)

[23:02:57] [DEBUG] CHandle::~CHandle(this=0x739f68)

[23:02:57] [DEBUG] CConnection::~CConnection(this=0x72c208, connection=0x701130)

[23:02:57] [DEBUG] CThreadedConnection::~CThreadedConnection(this=0xa19020, connection=0xa19020)

[23:02:57] [DEBUG] CThreadedConnection::WorkerFunc(this=0xa19020, connection=0xa19020) - shutting down

[23:02:57] [DEBUG] CConnection::~CConnection(this=0xa19020, connection=0x7644b0)

[23:02:57] [DEBUG] CConnectionPool::~CConnectionPool(this=0x72c5c8)

[23:02:57] [DEBUG] CThreadedConnection::~CThreadedConnection(this=0x382f020, connection=0x382f020)

[23:02:57] [DEBUG] CThreadedConnection::WorkerFunc(this=0x382f020, connection=0x382f020) - shutting down

[23:02:57] [DEBUG] CConnection::~CConnection(this=0x382f020, connection=0x740ca0)

[23:02:57] [DEBUG] CThreadedConnection::~CThreadedConnection(this=0x39c2020, connection=0x39c2020)

[23:02:57] [DEBUG] CThreadedConnection::WorkerFunc(this=0x39c2020, connection=0x39c2020) - shutting down

[23:02:57] [DEBUG] CConnection::~CConnection(this=0x39c2020, connection=0x74d518)

[23:02:57] [DEBUG] mysql_close: return value: '1'

[23:03:09] [INFO] changed log level from 'debug, info, warning, error' to 'debug, info, warning, error'

[23:03:09] [DEBUG] mysql_connect("127.0.0.1", "root", "*****", "samp_db", 0)

[23:03:09] [DEBUG] CHandleManager::Create(this=0x72b280, host='127.0.0.1', user='root', pass='****', db='samp_db', options=0x7203a8)

[23:03:09] [INFO] Creating new connection handle...

[23:03:09] [WARNING] mysql_connect: no password specified

[23:03:09] [DEBUG] CConnection::CConnection(this=0x72c488, host='127.0.0.1', user='root', passw='****', db='samp_db', options=0x7203a8)

[23:03:09] [DEBUG] CConnection::CConnection - new connection = 0x74e0d0

[23:03:09] [DEBUG] CConnection::CConnection(this=0xa12020, host='127.0.0.1', user='root', passw='****', db='samp_db', options=0x7203a8)

[23:03:09] [DEBUG] CConnection::CConnection - new connection = 0x74c578

[23:03:09] [DEBUG] CThreadedConnection::WorkerFunc(this=0xa12020, connection=0xa12020)

[23:03:09] [DEBUG] CThreadedConnection::CThreadedConnection(this=0xa12020, connection=0xa12020)

[23:03:09] [DEBUG] CConnectionPool::CConnectionPool(size=2, this=0x72bf08)

[23:03:09] [DEBUG] CConnection::CConnection(this=0x382e020, host='127.0.0.1', user='root', passw='****', db='samp_db', options=0x7203a8)

[23:03:09] [DEBUG] CConnection::CConnection - new connection = 0x74c960

[23:03:09] [DEBUG] CThreadedConnection::WorkerFunc(this=0x382e020, connection=0x382e020)

[23:03:09] [DEBUG] CThreadedConnection::CThreadedConnection(this=0x382e020, connection=0x382e020)

[23:03:09] [DEBUG] CConnection::CConnection(this=0x39b2020, host='127.0.0.1', user='root', passw='****', db='samp_db', options=0x7203a8)

[23:03:09] [DEBUG] CConnection::CConnection - new connection = 0x74d130

[23:03:09] [DEBUG] CThreadedConnection::WorkerFunc(this=0x39b2020, connection=0x39b2020)

[23:03:09] [DEBUG] CThreadedConnection::CThreadedConnection(this=0x39b2020, connection=0x39b2020)

[23:03:09] [INFO] Connection handle with id '1' successfully created.

[23:03:09] [DEBUG] CHandleManager::Create - new handle = 0x739da8

[23:03:09] [DEBUG] mysql_connect: return value: '1'

[23:03:09] [DEBUG] mysql_errno(1)

[23:03:09] [DEBUG] CHandle::GetErrorId(this=0x739da8)

[23:03:09] [DEBUG] CConnection::GetError(this=0x72c488, connection=0x74e0d0)

[23:03:09] [DEBUG] CHandle::GetErrorId - return value: true, error id: '0', error msg: ''

[23:03:09] [DEBUG] mysql_errno: return value: '0'

[23:03:09] [DEBUG] mysql_format(1, 0x02B8E654, 128, "SELECT id FROM users WHERE name = '%e'")

[23:03:09] [DEBUG] CHandle::EscapeString(this=0x739da8, src='Dustin_West')

[23:03:09] [DEBUG] CConnection::EscapeString(src='Dustin_West', this=0x72c488, connection=0x74e0d0)

[23:03:09] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Dustin_West'

[23:03:09] [DEBUG] mysql_format: return value: '47'

[23:03:09] [DEBUG] mysql_pquery(1, "SELECT id FROM users WHERE name = 'Dustin_West'", "OnUserCheck", "d")

[23:03:09] [DEBUG] CCallback::Create(amx=0x29ba860, name='OnUserCheck', format='d', params=0x2b8e63c, param_offset=5)

[23:03:09] [DEBUG] CCallback::Create - callback index for 'OnUserCheck': 33

[23:03:09] [DEBUG] processing specifier 'd' with parameter index 0

[23:03:09] [DEBUG] retrieved and pushed value '0'

[23:03:09] [INFO] Callback 'OnUserCheck' set up for delayed execution.

[23:03:09] [DEBUG] created delayed callback with 1 parameter

[23:03:09] [DEBUG] CHandle::Execute(this=0x739da8, type=2, query=0x739a58)

[23:03:09] [DEBUG] CConnectionPool::Queue(query=0x739a58, this=0x72bf08)

[23:03:09] [DEBUG] CHandle::Execute - return value: true

[23:03:09] [DEBUG] mysql_pquery: return value: '1'

[23:03:09] [DEBUG] CConnection::Execute(query=0x739a58, this=0x382e020, connection=0x74c960)

[23:03:09] [DEBUG] CQuery::Execute(this=0x739a58, connection=0x74c960)

[23:03:09] [INFO] query "SELECT id FROM users WHERE name = 'Dustin_West'" successfully executed within 0.385 milliseconds

[23:03:09] [DEBUG] CResultSet::Create(connection=0x74c960, query_str='SELECT id FROM users WHERE name = 'Dustin_West'')

[23:03:09] [DEBUG] created new resultset '0x7405c8'

[23:03:09] [DEBUG] fetched MySQL result '0x7014a0'

[23:03:09] [DEBUG] allocated 20 bytes for PAWN result

[23:03:09] [DEBUG] CCallback::Execute(amx=0x29ba860, index=33, num_params=1)

[23:03:09] [INFO] Executing callback 'OnUserCheck' with 1 parameter...

[23:03:09] [DEBUG] processing internal specifier 'c'

[23:03:09] [DEBUG] pushed value '0' onto AMX stack

[23:03:09] [DEBUG] executing AMX callback with index '33'

[23:03:09] [DEBUG] cache_get_row_count(0x02B8E854)

[23:03:09] [DEBUG] cache_get_row_count: return value: '1'

[23:03:09] [DEBUG] AMX callback executed with error '0'

[23:03:09] [INFO] Callback successfully executed.

[23:03:11] [DEBUG] mysql_format(1, 0x02B8E448, 256, "SELECT * FROM users WHERE name = '%e' AND password = MD5('%e')")

[23:03:11] [DEBUG] CHandle::EscapeString(this=0x739da8, src='Dustin_West')

[23:03:11] [DEBUG] CConnection::EscapeString(src='Dustin_West', this=0x72c488, connection=0x74e0d0)

[23:03:11] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Dustin_West'

[23:03:11] [DEBUG] CHandle::EscapeString(this=0x739da8, src='Dustin')

[23:03:11] [DEBUG] CConnection::EscapeString(src='Dustin', this=0x72c488, connection=0x74e0d0)

[23:03:11] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Dustin'

[23:03:11] [DEBUG] mysql_format: return value: '75'

[23:03:11] [DEBUG] mysql_pquery(1, "SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('Dustin')", "OnUserLogin", "d")

[23:03:11] [DEBUG] CCallback::Create(amx=0x29ba860, name='OnUserLogin', format='d', params=0x2b8e430, param_offset=5)

[23:03:11] [DEBUG] CCallback::Create - callback index for 'OnUserLogin': 34

[23:03:11] [DEBUG] processing specifier 'd' with parameter index 0

[23:03:11] [DEBUG] retrieved and pushed value '0'

[23:03:11] [INFO] Callback 'OnUserLogin' set up for delayed execution.

[23:03:11] [DEBUG] created delayed callback with 1 parameter

[23:03:11] [DEBUG] CHandle::Execute(this=0x739da8, type=2, query=0x738d48)

[23:03:11] [DEBUG] CConnectionPool::Queue(query=0x738d48, this=0x72bf08)

[23:03:11] [DEBUG] CHandle::Execute - return value: true

[23:03:11] [DEBUG] mysql_pquery: return value: '1'

[23:03:11] [DEBUG] CConnection::Execute(query=0x738d48, this=0x39b2020, connection=0x74d130)

[23:03:11] [DEBUG] CQuery::Execute(this=0x738d48, connection=0x74d130)

[23:03:11] [INFO] query "SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('Dustin')" successfully executed within 0.313 milliseconds

[23:03:11] [DEBUG] CResultSet::Create(connection=0x74d130, query_str='SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('Dustin')')

[23:03:11] [DEBUG] created new resultset '0x7354e0'

[23:03:11] [DEBUG] fetched MySQL result '0x7333b8'

[23:03:11] [DEBUG] allocated 124 bytes for PAWN result

[23:03:11] [DEBUG] CCallback::Execute(amx=0x29ba860, index=34, num_params=1)

[23:03:11] [INFO] Executing callback 'OnUserLogin' with 1 parameter...

[23:03:11] [DEBUG] processing internal specifier 'c'

[23:03:11] [DEBUG] pushed value '0' onto AMX stack

[23:03:11] [DEBUG] executing AMX callback with index '34'

[23:03:11] [DEBUG] cache_get_row_count(0x02B8E854)

[23:03:11] [DEBUG] cache_get_row_count: return value: '1'

[23:03:11] [DEBUG] cache_get_value_name_int(0, "id", 0x02B4C410)

[23:03:11] [DEBUG] cache_get_value_name_int: assigned value: '1'

[23:03:11] [DEBUG] cache_get_value_name_int: return value: '1'

[23:03:11] [DEBUG] cache_get_value_name_int(0, "level", 0x02B4C478)

[23:03:11] [DEBUG] cache_get_value_name_int: assigned value: '20'

[23:03:11] [DEBUG] cache_get_value_name_int: return value: '1'

[23:03:11] [DEBUG] cache_get_value_name_int(0, "money", 0x02B4C48C)

[23:03:11] [DEBUG] cache_get_value_name_int: assigned value: '30000'

[23:03:11] [DEBUG] cache_get_value_name_int: return value: '1'

[23:03:11] [DEBUG] cache_get_value_name_int(0, "kills", 0x02B4C490)

[23:03:11] [DEBUG] cache_get_value_name_int: assigned value: '0'

[23:03:11] [DEBUG] cache_get_value_name_int: return value: '1'

[23:03:11] [DEBUG] cache_get_value_name_int(0, "deaths", 0x02B4C498)

[23:03:11] [DEBUG] cache_get_value_name_int: assigned value: '0'

[23:03:11] [DEBUG] cache_get_value_name_int: return value: '1'

[23:03:11] [DEBUG] cache_get_value_name_int(0, "adminlevel", 0x02B4C47C)

[23:03:11] [DEBUG] cache_get_value_name_int: assigned value: '3'

[23:03:11] [DEBUG] cache_get_value_name_int: return value: '1'

[23:03:11] [DEBUG] cache_get_value_name_int(0, "fraktion", 0x02B4C480)

[23:03:11] [DEBUG] cache_get_value_name_int: assigned value: '0'

[23:03:11] [DEBUG] cache_get_value_name_int: return value: '1'

[23:03:11] [DEBUG] cache_get_value_name_int(0, "rang", 0x02B4C484)

[23:03:11] [DEBUG] cache_get_value_name_int: assigned value: '6'

[23:03:11] [DEBUG] cache_get_value_name_int: return value: '1'

[23:03:11] [DEBUG] cache_get_value_name_int(0, "spawnchange", 0x02B4C488)

[23:03:11] [DEBUG] cache_get_value_name_int: assigned value: '0'

[23:03:11] [DEBUG] cache_get_value_name_int: return value: '1'

[23:03:11] [DEBUG] mysql_format(1, 0x02B8E524, 200, "SELECT * FROM autos WHERE besitzer=%d")

[23:03:11] [DEBUG] mysql_format: return value: '36'

[23:03:11] [DEBUG] mysql_tquery(1, "SELECT * FROM autos WHERE besitzer=1", "OnPlayerCarsLoad", "i")

[23:03:11] [DEBUG] CCallback::Create(amx=0x29ba860, name='OnPlayerCarsLoad', format='i', params=0x2b8e50c, param_offset=5)

[23:03:11] [DEBUG] CCallback::Create - callback index for 'OnPlayerCarsLoad': 5

[23:03:11] [DEBUG] processing specifier 'i' with parameter index 0

[23:03:11] [DEBUG] retrieved and pushed value '0'

[23:03:11] [INFO] Callback 'OnPlayerCarsLoad' set up for delayed execution.

[23:03:11] [DEBUG] created delayed callback with 1 parameter

[23:03:11] [DEBUG] CHandle::Execute(this=0x739da8, type=1, query=0x739338)

[23:03:11] [DEBUG] CHandle::Execute - return value: true

[23:03:11] [DEBUG] mysql_tquery: return value: '1'

[23:03:11] [DEBUG] CConnection::Execute(query=0x739338, this=0xa12020, connection=0x74c578)

[23:03:11] [DEBUG] CQuery::Execute(this=0x739338, connection=0x74c578)

[23:03:11] [DEBUG] AMX callback executed with error '0'

[23:03:11] [INFO] Callback successfully executed.

[23:03:11] [INFO] query "SELECT * FROM autos WHERE besitzer=1" successfully executed within 0.274 milliseconds

[23:03:11] [DEBUG] CResultSet::Create(connection=0x74c578, query_str='SELECT * FROM autos WHERE besitzer=1')

[23:03:11] [DEBUG] created new resultset '0x74c1d8'

[23:03:11] [DEBUG] fetched MySQL result '0x7180e0'

[23:03:11] [DEBUG] allocated 0 bytes for PAWN result

[23:03:11] [DEBUG] CCallback::Execute(amx=0x29ba860, index=5, num_params=1)

[23:03:11] [INFO] Executing callback 'OnPlayerCarsLoad' with 1 parameter...

[23:03:11] [DEBUG] processing internal specifier 'c'

[23:03:11] [DEBUG] pushed value '0' onto AMX stack

[23:03:11] [DEBUG] executing AMX callback with index '5'

[23:03:11] [DEBUG] cache_get_row_count(0x02B8E854)

[23:03:11] [DEBUG] cache_get_row_count: return value: '1'

[23:03:11] [DEBUG] AMX callback executed with error '0'

[23:03:11] [INFO] Callback successfully executed.

Kaliber wie könnte ich das Problem denn beheben? damit aus 0, 1 wird?

Kaliber aber besitzer wurder doch als INT gespeichert

pasted-from-clipboard.png

So sieht die Datenbank aus

Wo kann ich sehen was die Querys "sagen"?

geprintet habe ich das hier:

loadPlayerCars(playerid)
{
    new query[200];
    mysql_format(handle, query, sizeof(query), "SELECT * FROM autos WHERE besitzer=%d",PlayerInfo[playerid][p_id]); //966
    mysql_tquery(handle, query, "OnPlayerCarsLoad","i",playerid);
    print("loadPlayerCars");
    return 1;
}

und das

public OnPlayerCarsLoad()
{
    new num_rows;
    cache_get_row_count(num_rows);
    if(!num_rows) return 1;
    for(new i,id; i<num_rows; i++)
    {
        id=getFreeCarID();
        cache_get_value_name_int(i, "model", cInfo[id][model]);
        cache_get_value_name_int(i, "besitzer", cInfo[id][besitzer]);
        cache_get_value_name_float(i, "x", cInfo[id][c_x]);
        cache_get_value_name_float(i, "y", cInfo[id][c_y]);
        cache_get_value_name_float(i, "z", cInfo[id][c_z]);
        cache_get_value_name_float(i, "r", cInfo[id][c_r]);
        cache_get_value_name_int(i, "id", PlayerInfo[id][db_id]);
        cInfo[id][id_x]=CreateVehicle(cInfo[id][model],cInfo[id][c_x],cInfo[id][c_y],cInfo[id][c_z],cInfo[id][c_r],-1,-1,-1);
        print("OnPlayerCarsLoad");
    }
    return 1;
}

Logs spucken das aus:

[MySQL] Verbindungsaufbau...

[MySQL] Die Verbindung zur Datenbank wurde erfolgreich hergestellt! Handle: 1

============================================================

Das Script Revive the Generation wurde Erfolgreich geladen!

============================================================

Number of vehicle models: 1

loadPlayerCars

Kaliber

Also nach einem reconnect sind die Fahrzeuge noch da, bei einem gmx sind diese leider komplett weg Kaliber

Kaliber

Jetzt musste ich noch ein paar mehr änderungen vornehmen aber jetzt sollte alles ohne Probleme funktionieren?

Kaliber

enum carEnum{
    id_x,
    model,
    besitzer,
    Float:c_x,
    Float:c_y,
    Float:c_z,
    Float:c_r,
    db_id,
    carcolor,
    carcolor2
    
}
new cInfo[MAX_VEHICLES][carEnum];

Maho hab kein MySQL log in meinem Ordner

Nach dem Einloggen vor einem gmx extra noch ein Fahrzeug erstellt sehen die Logs derzeit nur so aus

[MySQL] Verbindungsaufbau...

[MySQL] Die Verbindung zur Datenbank wurde erfolgreich hergestellt! Handle: 1

============================================================

Das Script Revive the Generation wurde Erfolgreich geladen!

============================================================

Number of vehicle models: 1

loadPlayerCars

Maho

So?

loadPlayerCars(playerid)
{
    new query[200];
    mysql_format(handle, query, sizeof(query), "SELECT * FROM autos WHERE besitzer=%d",PlayerInfo[playerid][p_id]); //966
    mysql_tquery(handle, query, "OnPlayerCarsLoad","i",playerid);
    print("loadPlayerCars");
    return 1;
}

Mein derzeitiger Stats befehl sieht so aus:

ocmd:stats(playerid, params[])
{
    new string[128];
    format(string,sizeof(string),"SpielerName:[%d]",PlayerInfo[playerid][pName]);
    ShowPlayerDialog(playerid, 3, DIALOG_STYLE_MSGBOX, "Statistiken",string, "Bestätigen", "");
    return 1;
}

Jedoch wenn ich im Spiel /stats eingebe kommt in der MSGBOX Spielername: [68]

Ich habe es ebenfalls auch schon so versucht

format(string,sizeof(string),"SpielerName:[%d]",playerid); //Da dachte ich mir jedoch ich will ja nicht die Playerid sondern den Spielernamen auslesen

Dann habe ich das wieder so versucht nur mit %i

format(string,sizeof(string),"SpielerName:[%i]",PlayerInfo[playerid][pName]);

wobei wenn mich nicht alles täuscht es keinen Unterschied zwischen %i und %d gibt

Noch eine Frage nebenher, bspw. Ich möchte jetzt nachdem Ich den Spielernamen auslesen lassen habe noch ID[x] in der MSGBOX anzeigen lassen müsste es dann so aussehen?

format(string,sizeof(string),"SpielerName:[%d], ID[%i]",PlayerInfo[playerid][pName], playerid);

??

Bekomme 2 Warnings jedoch nicht da durch habe bisschen was bearbeitet etc.

public OnPlayerDisconnect(playerid, reason)
{
    SaveUserStats(playerid);
    //Tank Textdraw löschen
    PlayerTextDrawDestroy(playerid, tankLabel[playerid]);
    for(new i=0; i<sizeof(cInfo); i++)
    {
        if(cInfo[i][id_x]==0)continue;
        if(cInfo[i][besitzer]!=PlayerInfo[playerid][db_id])continue; //Tag Mismatch
        GetVehiclePos(cInfo[i][id_x],cInfo[i][c_x],cInfo[i][c_y],cInfo[i][c_z]);
        GetVehicleZAngle(cInfo[i][id_x],cInfo[i][c_r]);
        new query[256];
        format(query,sizeof(query),"UPDATE autos SET x='%f',y='%f',z='%f',r='%f' WHERE id='%i'",cInfo[i][c_x],cInfo[i][c_y],cInfo[i][c_z],cInfo[i][c_r],cInfo[i][db_id]);
        mysql_tquery(handle, query);
        DestroyVehicle(cInfo[i][id_x]);
        cInfo[i][id_x]=0;
    }
    return 1;
}

saveCarToDB(playerid, carid)
{
    new query[200];
    mysql_format(handle, query, sizeof(query), "INSERT INTO autos (besitzer,model,x,y,z,r) VALUES('%i','%i','%f','%f','%f','%f')",PlayerInfo[playerid][db_id],cInfo[carid][model],cInfo[carid][c_x],cInfo[carid][c_y],cInfo[carid][c_z],cInfo[carid][c_r]); //Tag Mismatch
    mysql_tquery(handle, query);
    return 1;
}

Also mit den zwei Warnings passiert leider nichts bspw. /createcar [playerid [modelid] wird ausgeführt

Werden zur Datenbank hinzugefügt

Sieht so aus

pasted-from-clipboard.png

Jedoch wenn ich Disconnecte und Neu connecte oder ein GMX ausführe wird bisher kein Fahrzeug gespawnt

Kaliber  Maho werde ich mir in ca 15min genauer anschauen bin grade Unterwegs

/edit Kaliber

Jetzt blicke ich gar nicht mehr durch

er hat auch die loadPlayerCars funktion sieht so aus:

1. loadPlayerCars(playerid)
2. {
3. new query[128];
4. format(query,sizeof(query),"SELECT * FROM autos WHERE besitzer='%i'",sInfo[playerid][db_id]);
5. mysql_function_query(dbhandle,query,true,"OnPlayerCarsLoad","i",playerid);
6.     return 1;
7. }

meine sieht so aus

loadPlayerCars(playerid,carid)
{
    new query[200];
    mysql_format(handle, query, sizeof(query), "INSERT INTO autos SET besitzer=%d, model='%d', x='%f', y='%f', z='%f', r='%f'",PlayerInfo[playerid][p_id],cInfo[carid][model],cInfo[carid][c_x],cInfo[carid][c_y],cInfo[carid][c_z],cInfo[carid][c_r]); //966
    mysql_tquery(handle, query);
    return 1;
}

Ahhhhh ich glaub jetzt rall ich es falls falsch einfach drauf hinweisen ist jetzt einfach ein test

Sollte mein Funktion so aussehen?

loadPlayerCars(playerid,carid)
{
    new query[200];
    mysql_format(handle, query, sizeof(query), "SELECT * FROM autos WHERE besitzer=%d, model='%d', x='%f', y='%f', z='%f', r='%f'",PlayerInfo[playerid][p_id],cInfo[carid][model],cInfo[carid][c_x],cInfo[carid][c_y],cInfo[carid][c_z],cInfo[carid][c_r]); //966
    mysql_tquery(handle, query);
    return 1;
}

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1061) : warning 202: number of arguments does not match definition

Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

1 Warning.

loadPlayerCars(playerid);

hab es auch schon mit loadPlayerCars(playerid,carid);

dann kommt jedoch

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1061) : error 017: undefined symbol "carid"

Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

1 Error.

Zitat

Dein Insert INTO Query ist völliger Quatsch, sollte das eventuell ein Update sein?

Hab es mehr oder weniger copy&pasted (selbst eingegeben etc.)

Kann ich dir leider nicht genau sagen ist von MrMonat :

Kaliber habe gerade in der Datenbank den besitzer von INT auf VARCHAR geändert und an meinem enum bei besitzer[MAX_PLAYER_NAME] dran gehangen ist das so besser?

Wäre es trotzdem so wie du es geschrieben hast nutzbar?

Vielen Dank! Größtenteils alle Fehler behoben bis auf:

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(966) : error 017: undefined symbol "carid"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1069) : warning 202: number of arguments does not match definition

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1073) : error 025: function heading differs from prototype

Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

2 Errors.

loadPlayerCars(playerid)
{
    new query[200];
    mysql_format(handle, query, sizeof(query), "INSERT INTO autos SET besitzer=%d, model='%d', x='%f', y='%f', z='%f', r='%f'",PlayerInfo[playerid][p_id],cInfo[carid][model],cInfo[carid][c_x],cInfo[carid][c_y],cInfo[carid][c_z],cInfo[carid][c_r]); //966
    mysql_tquery(handle, query);
    return 1;
}

public carSavedToDB(carid)
{
    cInfo[carid][db_id]= cache_insert_id(handle); //1068
    return 1;
}

public OnPlayerCarsLoad(playerid) //1073
{
    new num_rows;
    cache_get_row_count(num_rows);
    if(!num_rows) return 1;
    for(new i,id; i<num_rows; i++)
    {
        id=getFreeCarID();
        cache_get_value_name_int(i, "model", cInfo[id][model]);
        cache_get_value_name(i, "besitzer", cInfo[id][besitzer]);
        cache_get_value_name_float(i, "x", cInfo[id][c_x]);
        cache_get_value_name_float(i, "y", cInfo[id][c_y]);
        cache_get_value_name_float(i, "z", cInfo[id][c_z]);
        cache_get_value_name_float(i, "r", cInfo[id][c_r]);
        cache_get_value_name_int(i, "id", cInfo[id][db_id]);

        CreateVehicle(cInfo[id][model],cInfo[id][c_x],cInfo[id][c_y],cInfo[id][c_z],cInfo[id][c_r],-1,-1,-1);
    }
    return 1;
}

Okay jetzt habe ich nur noch 6 Errors

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(966) : error 017: undefined symbol "carid"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1069) : warning 202: number of arguments does not match definition

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1073) : error 025: function heading differs from prototype

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1083) : error 017: undefined symbol "x"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1084) : error 017: undefined symbol "y"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1085) : error 017: undefined symbol "z"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1086) : error 017: undefined symbol "r"

Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

6 Errors.

hier ist auch noch mein Enum falls notwendig:

enum carEnum{
    id_x,
    model,
    besitzer,
    Float:c_x,
    Float:c_y,
    Float:c_z,
    Float:c_r,
    db_id,
    carcolor,
    carcolor2
    
}
new cInfo[MAX_VEHICLES][carEnum];

Kaliber

kommt dann das bei rum nachdem ich das zu float geändert habe bei x y z r bei besitzer bleibt ja int richtig?

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(569) : error 017: undefined symbol "COLOR_DARK_RED"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(570) : error 017: undefined symbol "COLOR_DARK_RED"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(966) : error 017: undefined symbol "carid"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1069) : warning 202: number of arguments does not match definition

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1073) : error 025: function heading differs from prototype

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1076) : error 017: undefined symbol "cache_get_data"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1078) : error 036: empty statement

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1081) : error 017: undefined symbol "i"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1082) : error 017: undefined symbol "i"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1083) : error 017: undefined symbol "i"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1084) : error 017: undefined symbol "i"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1085) : error 017: undefined symbol "i"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1086) : error 017: undefined symbol "i"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1086) : error 029: invalid expression, assumed zero

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1086 -- 1087) : warning 215: expression has no effect

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1075) : warning 203: symbol is never used: "num_fields"

Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

13 Errors.

R41-4 Kaliber

Maho

Hey hab wieder paar Probleme hab aber auch schon die ein oder anderen sachen selbst versucht wirst du wahrscheinlich irgendwo finden wenn nicht schreib ich es noch hinter

die Errors:

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(955) : error 017: undefined symbol "carid"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1058) : warning 202: number of arguments does not match definition

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1062) : error 025: function heading differs from prototype

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1065) : error 017: undefined symbol "cache_get_data"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1067) : error 036: empty statement

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1070) : error 017: undefined symbol "cache_get_field_content_int"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1071) : error 017: undefined symbol "cache_get_field_content_int"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1072) : error 017: undefined symbol "cache_get_field_content_int"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1073) : error 017: undefined symbol "cache_get_field_content_int"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1074) : error 017: undefined symbol "cache_get_field_content_int"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1075) : error 017: undefined symbol "cache_get_field_content_int"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1076) : error 017: undefined symbol "cache_get_field_content_int"

C:\Users\Dustin\Desktop\Samp Scripting\gamemodes\reallife.pwn(1064) : warning 203: symbol is never used: "num_fields"

Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

11 Errors.

mysql_format(handle, query, sizeof(query), "INSERT INTO autos SET besitzer=%d, model='%d', x='%f', y='%f', z='%f', r='%f'",PlayerInfo[playerid][p_id],cInfo[carid][model],cInfo[carid][c_x],cInfo[carid][c_y],cInfo[carid][c_z],cInfo[carid][c_r]); //955

mysql_tquery(handle, query);

public carSavedToDB(carid)
{
    cInfo[carid][db_id]= cache_insert_id(handle); //1058
    return 1;
}

public OnPlayerCarsLoad(playerid) //1062
{
    new num_fields, num_rows; //1064
    cache_get_data(num_rows,num_fields,handle); //1065
    if(!num_rows)return 1;
    for(new i=0; i<num_rows; i++; //1067
    {
        new id=getFreeCarID();
        cInfo[id][model]=cache_get_field_content_int(i,"model",handle); //1070
        cInfo[id][besitzer]=cache_get_field_content_int(i,"besitzer",handle); //1071
        cInfo[id][c_x]=cache_get_field_content_int(i,"x",handle); //1072
        cInfo[id][c_y]=cache_get_field_content_int(i,"y",handle); //1073
        cInfo[id][c_z]=cache_get_field_content_int(i,"z",handle); //1074
        cInfo[id][c_r]=cache_get_field_content_int(i,"r",handle); //1075
        cInfo[id][db_id]=cache_get_field_content_int(i,"id",handle); //1076
        CreateVehicle(cInfo[id][model],cInfo[id][c_x],cInfo[id][c_y],cInfo[id][c_z],cInfo[id][c_r],-1,-1,-1);
        /* Eigener Versuch hier drunter bspw. cache_get_value_name_int(blablabla)
        cache_get_value_name_int(0, "model", cInfo[id][model]);
        cache_get_value_name_int(0, "besitzer", cInfo[id][besitzer]);
        cache_get_value_name_int(0, "x", cInfo[id][x]);
        cache_get_value_name_int(0, "y", cInfo[id][y]);
        cache_get_value_name_int(0, "z", cInfo[id][z]);
        cache_get_value_name_int(0, "r", cInfo[id][r]);*/
    }
    return 1;
}