Beiträge von PawnLike


    [12:37:31]
    [12:37:31] ---------------------------
    [12:37:31] MySQL Debugging activated (10/15/12)
    [12:37:31] ---------------------------
    [12:37:31]
    [12:37:31] >> mysql_connect( )
    [12:37:31] CMySQLHandler::CMySQLHandler() - constructor called.
    [12:37:31] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "ni79979_1_DB" | Username: "ni79979_1_DB" ...
    [12:37:31] CMySQLHandler::Connect() - Connection was successful.
    [12:37:31] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
    [12:37:31] >> mysql_ping( Connection handle: 1 )
    [12:37:31] CMySQLHandler::Ping() - Connection is still alive.
    [12:38:18] >> mysql_real_escape_string( Connection handle: 1 )
    [12:38:18] CMySQLHandler::EscapeString(Steven); - Escaped 6 characters to Steven.
    [12:38:18] >> mysql_query( Connection handle: 1 )
    [12:38:18] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:18] >> mysql_store_result( Connection handle: 1 )
    [12:38:18] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:18] >> mysql_num_rows( Connection handle: 1 )
    [12:38:18] CMySQLHandler::NumRows() - Returned 0 row(s)
    [12:38:18] >> mysql_free_result( Connection handle: 1 )
    [12:38:18] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:20] >> mysql_real_escape_string( Connection handle: 1 )
    [12:38:20] CMySQLHandler::EscapeString(Steven); - Escaped 6 characters to Steven.
    [12:38:20] >> mysql_real_escape_string( Connection handle: 1 )
    [12:38:20] CMySQLHandler::EscapeString(test); - Escaped 4 characters to test.
    [12:38:20] >> mysql_query( Connection handle: 1 )
    [12:38:20] CMySQLHandler::Query(INSERT INTO `accounts` (`Name`, `Passwort`) VALUES ('Steven', 'test')) - Successfully executed.
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:38:35] >> mysql_store_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:35] >> mysql_retrieve_row( Connection handle: 1 )
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(UPDATE accounts SET `Level` = '0' WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:35] >> mysql_free_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:38:35] >> mysql_store_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:35] >> mysql_retrieve_row( Connection handle: 1 )
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(UPDATE accounts SET `Geld` = '0' WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:35] >> mysql_free_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:38:35] >> mysql_store_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:35] >> mysql_retrieve_row( Connection handle: 1 )
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(UPDATE accounts SET `Fraktion` = '0' WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:35] >> mysql_free_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:38:35] >> mysql_store_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:35] >> mysql_retrieve_row( Connection handle: 1 )
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(UPDATE accounts SET `Health` = '0.000000' WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:35] >> mysql_free_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:38:35] >> mysql_store_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:35] >> mysql_retrieve_row( Connection handle: 1 )
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(UPDATE accounts SET `Banned` = '0' WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:35] >> mysql_free_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:38:35] >> mysql_store_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:35] >> mysql_retrieve_row( Connection handle: 1 )
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(UPDATE accounts SET `Adminlevel` = '0' WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:35] >> mysql_free_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:38:35] >> mysql_store_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:35] >> mysql_retrieve_row( Connection handle: 1 )
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(UPDATE accounts SET `Respekt` = '0' WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:35] >> mysql_free_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:38:35] >> mysql_store_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:35] >> mysql_retrieve_row( Connection handle: 1 )
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(UPDATE accounts SET `Payday` = '1' WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:35] >> mysql_free_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:38:35] >> mysql_store_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:35] >> mysql_retrieve_row( Connection handle: 1 )
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(UPDATE accounts SET `Death` = '0' WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:35] >> mysql_free_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:38:35] >> mysql_store_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:35] >> mysql_retrieve_row( Connection handle: 1 )
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(UPDATE accounts SET `Kill` = '0' WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:35] >> mysql_free_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:38:35] >> mysql_store_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:35] >> mysql_retrieve_row( Connection handle: 1 )
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(UPDATE accounts SET `BusDuty` = '0' WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:35] >> mysql_free_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:38:35] >> mysql_store_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:35] >> mysql_retrieve_row( Connection handle: 1 )
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(UPDATE accounts SET `Job` = '0' WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:35] >> mysql_free_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:38:35] >> mysql_store_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:35] >> mysql_retrieve_row( Connection handle: 1 )
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(UPDATE accounts SET `BusExp` = '0' WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:35] >> mysql_free_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:35] >> mysql_query( Connection handle: 1 )
    [12:38:35] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:38:35] >> mysql_store_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:35] >> mysql_retrieve_row( Connection handle: 1 )
    [12:38:35] >> mysql_free_result( Connection handle: 1 )
    [12:38:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:58] >> mysql_real_escape_string( Connection handle: 1 )
    [12:38:58] CMySQLHandler::EscapeString(Steven); - Escaped 6 characters to Steven.
    [12:38:58] >> mysql_query( Connection handle: 1 )
    [12:38:58] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:58] >> mysql_store_result( Connection handle: 1 )
    [12:38:58] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:58] >> mysql_num_rows( Connection handle: 1 )
    [12:38:58] CMySQLHandler::NumRows() - Returned 1 row(s)
    [12:38:58] >> mysql_free_result( Connection handle: 1 )
    [12:38:58] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:38:58] >> mysql_real_escape_string( Connection handle: 1 )
    [12:38:58] CMySQLHandler::EscapeString(Steven); - Escaped 6 characters to Steven.
    [12:38:58] >> mysql_query( Connection handle: 1 )
    [12:38:58] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Name` = 'Steven') - Successfully executed.
    [12:38:58] >> mysql_store_result( Connection handle: 1 )
    [12:38:58] CMySQLHandler::StoreResult() - Result was stored.
    [12:38:58] >> mysql_num_rows( Connection handle: 1 )
    [12:38:58] CMySQLHandler::NumRows() - Returned 1 row(s)
    [12:38:58] >> mysql_free_result( Connection handle: 1 )
    [12:38:58] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:39:00] >> mysql_real_escape_string( Connection handle: 1 )
    [12:39:00] CMySQLHandler::EscapeString(Steven); - Escaped 6 characters to Steven.
    [12:39:00] >> mysql_query( Connection handle: 1 )
    [12:39:00] CMySQLHandler::Query(SELECT `passwort` FROM `accounts` WHERE `Name` = 'Steven') - Successfully executed.
    [12:39:00] >> mysql_store_result( Connection handle: 1 )
    [12:39:00] CMySQLHandler::StoreResult() - Result was stored.
    [12:39:00] >> mysql_fetch_row_format( Connection handle: 1 )
    [12:39:00] CMySQLHandler::FetchRow() - Return: test
    [12:39:00] >> mysql_free_result( Connection handle: 1 )
    [12:39:00] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [12:39:00] >> mysql_query( Connection handle: 1 )
    [12:39:00] CMySQLHandler::Query(SELECT * FROM accounts WHERE `Name`='Steven') - Successfully executed.
    [12:39:00] >> mysql_store_result( Connection handle: 1 )
    [12:39:00] CMySQLHandler::StoreResult() - Result was stored.
    [12:39:00] >> mysql_retrieve_row( Connection handle: 1 )
    [12:39:00] >> mysql_fetch_field_row( Connection handle: 1 )
    [12:39:10]
    [12:39:10] ---------------------------
    [12:39:10] MySQL Debugging activated (10/15/12)
    [12:39:10] ---------------------------
    [12:39:10]
    [12:39:10] >> mysql_connect( )
    [12:39:10] CMySQLHandler::CMySQLHandler() - constructor called.
    [12:39:10] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "ni79979_1_DB" | Username: "ni79979_1_DB" ...
    [12:39:10] CMySQLHandler::Connect() - Connection was successful.
    [12:39:10] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
    [12:39:10] >> mysql_ping( Connection handle: 1 )
    [12:39:10] CMySQLHandler::Ping() - Connection is still alive.


    Soo, ich habe nun ein paar Stellen eingebaut um festzustellen wo das Problem liegt.
    Das Problem ist: Die erste Registrierung in der LEEREN Datenbank funktioniert, aber sobald man einen zweiten Account in der Datenbank anlegt, wird dieser nicht gespeichert.


    Der erste Account funktioniert auch nur nach der Registrierung, ein erneuter Login nach dem Registrieren ist nicht möglich.

    Tag auch,
    ich habe folgendes Problem:


    In unserer MySQL Datenbank wird immer der erste Account überschrieben. Desweiteren wird nach dem eigl. erfolgreichen Login der OnPlayerRequestSpawn(); Bildschirm angezeigt, und der Spieler wird nicht gespawnt. Ich poste hier einfach mal die Codes in der Hoffnung jemand kann mir helfen :thumbup:

    public OnPlayerConnect(playerid)
    {
    //PLAYERSTATS
    SetPlayerVirtualWorld(playerid,0);
    if(IsPlayerNPC(playerid))return 1;
    if(mysql_CheckAccount(playerid) == 0)
    {
    ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Register Vorgang","Herzlich Willkommen.\nBevor du loslegen kannst musst du dich zuerst registrieren.\nGib unten dein gewünschtes Passwort an!","Register","Abbrechen");
    }
    else if(mysql_CheckAccount(playerid) == 1)
    {
    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login Vorgang","Herzlich Willkommen zurück auf meinem Server!\nGib bitte unten dein Passwort ein","Login","Abbrechen");
    }
    return 1;
    }



    public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
    {
    if(dialogid == DIALOG_LOGIN)
    {
    if(response == 0)
    {
    SendClientMessage(playerid,ROT,"Du hast den Login Vorgang abgebrochen und wirst deshalb nun gekickt!");
    Kick(playerid);
    }
    if(response == 1)
    {
    if(!strcmp(inputtext,mysql_ReturnPasswort(SpielerName(playerid)),true))
    {
    SpielerLaden(playerid);
    SetPVarInt(playerid,"eingeloggt",1);
    GivePlayerMoney(playerid,SpielerInfo[playerid][pGeld]);
    SetPlayerScore(playerid,SpielerInfo[playerid][pLevel]);
    SetTimerEx("SpawnMich", 10, 0, "i", playerid);
    return 1;
    }
    else if(!strlen(inputtext))
    {
    SendClientMessage(playerid,ROT,"Du musst auch ein Passwort angeben!");
    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gib unten dein korrektes Passwort ein!","Login","Abbrechen");
    return 1;
    }
    else
    {
    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Das Passwort war leider falsch!\nGib unten dein korrektes Passwort ein!","Login","Abbrechen");
    }
    }
    }
    if(dialogid == DIALOG_REGISTER)
    {
    if(response == 0)
    {
    SendClientMessage(playerid,ROT,"Du hast den Vorgang abgebrochen und wirst gekickt!");
    Kick(playerid);
    return 1;
    }
    if(response == 1)
    {
    if(!strlen(inputtext))
    {
    SendClientMessage(playerid,ROT,"Dein Passwort war nicht lang genug!\nBitte versuche es erneut!");
    ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Register","Herzlich Willkommen.\n Da dies dein 1.Besuch bei uns ist, musst du dich zuerst registrieren.\nGib bitte unten dein gewünschtes Passwort ein!","Register","Abbrechen");
    return 1;
    }
    else
    {
    CreateAccount(playerid,inputtext); // Erstellen eines Accounts
    SetPVarInt(playerid,"eingeloggt",1);
    return 1;
    }
    }
    }
    return 1;
    }



    stock SpielerLaden(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    GetPlayerName(playerid,SpielerInfo[playerid][pName],MAX_PLAYER_NAME);
    if(r_LoadSQLEntrance("accounts","Name",SpielerInfo[playerid][pName]))
    {


    SpielerInfo[playerid][pLevel] = r_mysql_GetInt("Level");
    SpielerInfo[playerid][pHealth] = r_mysql_GetFloat("Health");
    SpielerInfo[playerid][pAdminlevel] = r_mysql_GetInt("Adminlevel");
    SpielerInfo[playerid][pFraktion] = r_mysql_GetInt("Fraktion");
    SpielerInfo[playerid][pGeld] = r_mysql_GetInt("Geld");
    SpielerInfo[playerid][pBanned] = r_mysql_GetInt("Banned");
    SpielerInfo[playerid][pRespekt] = r_mysql_GetInt("Respekt");
    SpielerInfo[playerid][pPayday] = r_mysql_GetInt("Payday");
    SpielerInfo[playerid][pDeath] = r_mysql_GetInt("Death");
    SpielerInfo[playerid][pKill] = r_mysql_GetInt("Kill");
    SpielerInfo[playerid][pBusDuty] = r_mysql_GetInt("BusDuty");
    SpielerInfo[playerid][pJob] = r_mysql_GetInt("Job");
    SpielerInfo[playerid][pBusExp] = r_mysql_GetInt("BusExp");
    printf("Spielerdaten vom Spieler %s erfolgreich aus der Datenbank geladen",SpielerName(playerid));
    if(SpielerInfo[playerid][pBanned] == 1)
    {
    Kick(playerid);
    }
    r_UnloadSQLEntrance();
    }


    }
    return 1;
    }



    stock SpielerSpeichern(playerid)
    {
    if(GetPVarInt(playerid,"eingeloggt") == 1)
    {
    GetPlayerName(playerid,SpielerInfo[playerid][pName],MAX_PLAYER_NAME);
    if(r_LoadSQLEntrance("accounts","Name",SpielerInfo[playerid][pName]))
    {
    r_mysql_SetInt("Level",SpielerInfo[playerid][pLevel]);
    r_mysql_SetInt("Geld",SpielerInfo[playerid][pGeld]);
    r_mysql_SetInt("Fraktion",SpielerInfo[playerid][pFraktion]);
    r_mysql_SetFloat("Health",SpielerInfo[playerid][pHealth]);
    r_mysql_SetInt("Banned",SpielerInfo[playerid][pBanned]);
    r_mysql_SetInt("Adminlevel",SpielerInfo[playerid][pAdminlevel]);
    r_mysql_SetInt("Respekt",SpielerInfo[playerid][pRespekt]);
    r_mysql_SetInt("Payday",SpielerInfo[playerid][pPayday]);
    r_mysql_SetInt("Death",SpielerInfo[playerid][pDeath]);
    r_mysql_SetInt("Kill",SpielerInfo[playerid][pKill]);
    r_mysql_SetInt("BusDuty",SpielerInfo[playerid][pBusDuty]);
    r_mysql_SetInt("Job",SpielerInfo[playerid][pJob]);
    r_mysql_SetInt("BusExp",SpielerInfo[playerid][pBusExp]);
    printf("Spielerdaten vom Spieler %s erfolgreich in der Datenbank gespeichert.",SpielerName(playerid));
    r_UnloadSQLEntrance();
    }
    }
    return 1;
    }



    stock CreateAccount(playerid, pass[])
    {
    new query[256],Name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
    mysql_real_escape_string(Name,Name);
    mysql_real_escape_string(pass,pass);
    format(query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Passwort`) VALUES ('%s', '%s')", Name, pass);
    mysql_query(query);
    return true;
    }



    public OnPlayerRequestClass(playerid, classid)
    {
    SetPlayerPos(playerid,1415.3909,-1626.0238,20.6056);
    SetPlayerCameraPos(playerid,1418.9369,-1629.8965,54.6056);
    SetPlayerCameraLookAt(playerid,1521.6505,-1706.4551,13.5469);
    SpawnPlayer(playerid);
    return 0;
    }


    Guten Morgen,
    ich habe derzeit mal wieder ein kleines Problem.


    Ich definiere in meinem Script, die Fahrzeuge für den Job "Trucker" mit


    truck[0] = AddStaticVehicleEx(403,2113.50000000,1396.69995117,11.50000000,180.00000000,-1,-1,15); //Linerunner



    Mein Tanksystem ist immoment noch für alle Fahrzeuge gleich. Das heißt, z.B: Ein Roller hat 50l. Tank, ein Auto hat 50l. Tank, ein Flugzeug hat 50l. Tank... usw....
    Das will ich jetzt aber ändern.


    Mein Tank wird so berechnet / eingestellt:


    for (new i=0; i< MAX_VEHICLES; i++)
    {
    GetVehicleParamsEx(i,engine,lights,alarm,doors,bonnet,boot,objective);
    SetVehicleParamsEx(i,VEHICLE_PARAMS_OFF,lights,alarm,doors,bonnet,boot,objective);
    Motor[i] = false;
    Tank[i] = 50;
    }
    return 1;


    Meine Frage ist nun, "Kann ich eine Abfrage oder eine Schleife o.A erstellen damit nur für die Trucks ein anderer Tankwert angezeigt wird? z.B 100l.?"


    MfG PawnLike :thumbup:

    Hallo Breadfishes, ich habe mal wieder ein kleines Problem.


    Mein Code:

    public givepayday()
    {
    for(new i,j=GetMaxPlayers();i<j;i++)
    {
    Spieler[i][PayDay] ++;
    return 1;
    }
    return 1;
    }


    ... soll allen Spielern durch einen Timer jede Minute eine PayDay-Minute geben. Jetzt wird aber nur ID 0 immer eine Minute gegeben. Könnte mir jemand verraten wie man es macht, das jeder Spieler jede Minute einen PayDay-Punkt bekommt?



    MfG PawnLike :thumbup: