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;
    }