Beiträge von Fabi.StaR

    Hir der Warning:


    Spoiler anzeigen
    C:\Users\Fabian\Desktop\Mein Server\gamemodes\Selfmade.pwn(4026) : warning 208: function with tag result used before definition, forcing reparse
    Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

    Spoiler anzeigen
    1 Warning.


    Hir der stock:


    Spoiler anzeigen
    stock Float:mysql_GetFloatWithInt(Table[], Field[], Where[], Is)//Die Zeile
    {
    new query[128], Float:sqlfloat;
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    format(query, 128, "SELECT %s FROM %s WHERE %s = '%d'", Field, Table, Where, Is);
    mysql_query(query);
    mysql_store_result();
    mysql_fetch_float(sqlfloat);
    mysql_free_result();
    return sqlfloat;
    }

    mach es do ;)


    Spoiler anzeigen
    #include <a_samp>
    #include <Dini>

    Spoiler anzeigen
    #pragma tabsize 0
    #define DIALOG_LOGIN 1
    #define DIALOG_REGISTER 2

    Spoiler anzeigen
    #define COLOR_RED 0xAA3333AA
    #define COLOR_GREEN 0x33AA33AA

    Spoiler anzeigen
    main()
    {
    print("\n----------------------------------");
    print(" ~~~");
    print("----------------------------------\n");
    }

    Spoiler anzeigen
    public OnGameModeInit()
    {
    // Don't use these lines if it's a filterscript
    SetGameModeText("Hallo");
    AddPlayerClass(0,1104.9427,-1796.1571,15.9093,86.5387,0,0,0,0,0,0); // start
    AddPlayerClass(1,1104.9427,-1796.1571,15.9093,86.5387,0,0,0,0,0,0); // start
    AddStaticVehicle(494,2037.8944,1342.9401,10.6356,179.2003,42,30); // auto1
    AddStaticVehicle(415,1098.4344,-1775.6050,13.2404,89.0712,42,30); // car

    Spoiler anzeigen
    return 1;
    }

    Spoiler anzeigen
    public OnGameModeExit()
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerRequestClass(playerid, classid)
    {
    SetPlayerPos(playerid,1104.9427,-1796.1571,15.9093);
    SetPlayerFacingAngle(playerid,86.5387);
    SetPlayerCameraPos(playerid,1104.9427,-1796.1571,15.9093);
    SetPlayerCameraLookAt(playerid,1104.9427,-1796.1571,15.9093);
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerConnect(playerid)
    {
    ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Regeistrieren","Gib bitte das Passwort ein!","Register","Abbrechen");
    RemoveBuildingForPlayer(playerid, 3777, 831.9609, -1191.1406, 25.0391, 0.25);
    RemoveBuildingForPlayer(playerid, 3777, 868.1328, -1191.1406, 25.0391, 0.25);
    RemoveBuildingForPlayer(playerid, 5926, 816.3359, -1217.1484, 26.4453, 0.25);
    RemoveBuildingForPlayer(playerid, 3777, 902.3359, -1191.1406, 25.0391, 0.25);
    RemoveBuildingForPlayer(playerid, 6005, 895.2578, -1256.9297, 31.2344, 0.25);
    RemoveBuildingForPlayer(playerid, 5836, 816.3359, -1217.1484, 26.4453, 0.25);
    RemoveBuildingForPlayer(playerid, 3776, 831.9609, -1191.1406, 25.0391, 0.25);
    RemoveBuildingForPlayer(playerid, 3776, 868.1328, -1191.1406, 25.0391, 0.25);
    RemoveBuildingForPlayer(playerid, 5838, 895.2578, -1256.9297, 31.2344, 0.25);
    RemoveBuildingForPlayer(playerid, 3776, 902.3359, -1191.1406, 25.0391, 0.25);
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerDisconnect(playerid, reason)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerSpawn(playerid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerDeath(playerid, killerid, reason)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnVehicleSpawn(vehicleid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnVehicleDeath(vehicleid, killerid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerText(playerid, text[])
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerCommandText(playerid, cmdtext[])
    {
    if(strcmp("/help", cmdtext, true, 10) == 0)
    {
    SendClientMessage(playerid, COLOR_GREEN, "Allgemein");
    SendClientMessage(playerid, COLOR_GREEN, ".....");
    return 1;
    }

    Spoiler anzeigen
    return 0;
    }

    Spoiler anzeigen
    public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerExitVehicle(playerid, vehicleid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerStateChange(playerid, newstate, oldstate)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerEnterCheckpoint(playerid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerLeaveCheckpoint(playerid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerEnterRaceCheckpoint(playerid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerLeaveRaceCheckpoint(playerid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnRconCommand(cmd[])
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerRequestSpawn(playerid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnObjectMoved(objectid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerObjectMoved(playerid, objectid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerPickUpPickup(playerid, pickupid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnVehicleMod(playerid, vehicleid, componentid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnVehicleRespray(playerid, vehicleid, color1, color2)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerSelectedMenuRow(playerid, row)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerExitedMenu(playerid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnRconLoginAttempt(ip[], password[], success)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerUpdate(playerid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerStreamIn(playerid, forplayerid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnPlayerStreamOut(playerid, forplayerid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnVehicleStreamIn(vehicleid, forplayerid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnVehicleStreamOut(vehicleid, forplayerid)
    {
    return 1;
    }

    Spoiler anzeigen
    public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
    {
    if(dialogid==DIALOG_REGISTER)
    {
    if(response== 0)
    {
    SendClientMessage(playerid,COLOR_RED,"Du hast den Vorgang abgebrochen.");
    Kick(playerid);
    return 1;
    }
    else
    {
    if(!strlen(inputtext))
    {
    SendClientMessage(playerid,COLOR_RED,"Das Passwort war nicht lang genug");
    ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Regeistrieren","Gib bitte das Passwort ein!","Register","Abbrechen");
    return 1;
    }
    Register(playerid,inputtext);
    return 1;
    }
    }
    return 1;
    }

    public OnPlayerClickPlayer(playerid, clickedplayerid, source)
    {
    return 1;
    }

    Spoiler anzeigen
    stock Register(playerid,key[])
    {
    new Spielerdatei[64];
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid,name,sizeof(name));
    format(Spielerdatei,sizeof(Spielerdatei),"/Accounts/%s.txt",name);
    dini_Create(Spielerdatei);
    dini_Set(Spielerdatei,"Passwort",key);
    SendClientMessage(playerid,COLOR_RED,"Erfolgreich Regestriert");
    return 1;
    }

    Hir das Connect

    Spoiler anzeigen
    stock Connect_To_Database()
    {
    mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
    if(mysql_ping() == 1)
    {
    print("<-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!");
    return true;
    }
    else
    {
    print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
    print("<-| [MYSQL] Es wird erneut versucht eine Verbindung zur Datenbank herzustellen!");
    mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
    if(mysql_ping() == 1)
    {
    print("<-| [MYSQL] Es konnte im 2 Versuch eine Verbindung hergestellt werden!");
    return true;
    }
    else
    {
    print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
    print("<-| [MYSQL] Der Server wird nun beendet!");
    SendRconCommand("exit");
    return true;
    }
    }
    }

    Bei mir ist der debug log so:


    stock mysql_GetFloat(Table[], Field[], Where[], Is[])
    {
    new query[128], Float:sqlfloat;
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Is, Is);
    format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
    mysql_query(query);
    mysql_store_result();
    mysql_fetch_float(sqlfloat);
    mysql_free_result();
    return true; //Zeile
    }

    Mein Vehicle id wird net gespeiert aber warum???


    ihr der stock:


    Spoiler anzeigen
    stock CreateCar(playerid, car[])
    {
    new query[1024],Name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
    mysql_real_escape_string(Name,Name);
    mysql_real_escape_string(car,car);
    format(query, sizeof(query), "INSERT INTO `PrivatCars` (`Name`, `CarID`) VALUES ('%s', '%d')", Name, car);
    mysql_query(query);
    return true;
    }


    und ihr die verwändung:


    Spoiler anzeigen
    ocmd:buycar(playerid, params[])
    {
    for(new i=0; i<sizeof(SellCar); i++)
    {
    if(GetPlayerVehicleID(playerid)==SellCar[i][vehid])
    {
    new geld = SellCar[i][CarPreis];
    if(GetPlayerMoney(playerid) >= geld)
    {
    GivePlayerMoney(playerid,-geld);
    CreateVehicle(SellCar[i][Carid],742.2209,-1344.2977,13.2459,268.1639,-1,-1,60000);
    PrivatCar[playerid][PrivatCarName] = SellCar[i][CarName];
    PrivatCar[playerid][privatmodelid]= SellCar[i][Carid];//hir
    PrivatCar[playerid][ParkX] = 742.2209;
    PrivatCar[playerid][ParkY] = -1344.2977;
    PrivatCar[playerid][ParkZ] = 13.2459;
    PrivatCar[playerid][ParkA] = 268.1639;
    SaveCar(playerid);
    CreateCar(playerid,PrivatCar[playerid][privatmodelid]);// hir
    TogglePlayerControllable(playerid,1);
    RemovePlayerFromVehicle(playerid);
    }
    else
    {
    SendClientMessage(playerid,Rot,"Du hast nicht genung Geld dabei!");
    TogglePlayerControllable(playerid,1);
    RemovePlayerFromVehicle(playerid);
    }
    }
    }
    return 1;
    }

    Bitte um hilfe


    Hir die stocks:


    Spoiler anzeigen
    stock SavePark(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    if(GetPVarInt(playerid,"Eingeloggt") == 1)
    {
    new Float:X,Float:Y,Float:Y,Float:A;
    GetPlayerName(playerid,PrivatCar[playerid][PrivatNAme], MAX_PLAYER_NAME);
    GetPlayerPos(playerid,X,Y,Z)
    GetPlayerFacingAngle(playerid,A)
    mysql_SetFloat("privatcars","CarPosX",PrivatCar[playerid][ParkX],"Name", PrivatCar[playerid][PrivatNAme]);
    mysql_SetFloat("privatcars","CarPosY",PrivatCar[playerid][ParkY],"Name", PrivatCar[playerid][PrivatNAme]);
    mysql_SetFloat("privatcars","CarPosZ",PrivatCar[playerid][ParkZ],"Name", PrivatCar[playerid][PrivatNAme]);
    mysql_SetFloat("privatcars","CarPosA",PrivatCar[playerid][ParkA],"Name", PrivatCar[playerid][PrivatNAme]);
    }
    }
    return 1;
    }
    stock SaveCar(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    GetPlayerName(playerid,PrivatCar[playerid][PrivatNAme], MAX_PLAYER_NAME);
    mysql_SetInt("privatcars","Color1",PrivatCar[playerid][privatColor1],"Name", PrivatCar[playerid][PrivatNAme]);
    mysql_SetInt("privatcars","Color2",PrivatCar[playerid][privatColor2],"Name", PrivatCar[playerid][PrivatNAme]);
    mysql_SetString("privatcars","CarName",PrivatCar[playerid][PrivatCarName],"Name", PrivatCar[playerid][PrivatNAme]);
    }
    }
    stock LoadCar(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    GetPlayerName(playerid,PrivatCar[playerid][PrivatNAme], MAX_PLAYER_NAME);
    PrivatCar[playerid][privatColor1] = mysql_GetInt("privatcars", "Color1", "Name",PrivatCar[playerid][PrivatNAme]);
    PrivatCar[playerid][privatColor2] = mysql_GetInt("privatcars", "Color2", "Name",PrivatCar[playerid][PrivatNAme]);
    PrivatCar[playerid][PrivatCarName] = mysql_GetInt("privatcars", "CarName", "Name",PrivatCar[playerid][PrivatNAme]);
    }
    return 1;
    }

    stock CreateAccount(playerid, pass[]



    Irgendwie nicht so das richtige.


    hir der richtige:

    Spoiler anzeigen
    stock CreateCar(playerid, car[])
    {
    new query[1024],Name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
    mysql_real_escape_string(Name,Name);
    mysql_real_escape_string(car,car);
    format(query, sizeof(query), "INSERT INTO `PrivatCars` (`Name`, `CarName`) VALUES ('%s', '%s')", Name, car);
    mysql_query(query);
    return true;
    }

    Hir mein CreateCar:


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


    hir mein SaveCar:


    Spoiler anzeigen
    stock SavePark(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    if(GetPVarInt(playerid,"Eingeloggt") == 1)
    {
    new Float:X,Float:Y,Float:Y,Float:A;
    GetPlayerName(playerid,PrivatCar[playerid][PrivatNAme], MAX_PLAYER_NAME);
    GetPlayerPos(playerid,X,Y,Z)
    GetPlayerFacingAngle(playerid,A)
    mysql_SetFloat("privatcars","CarPosX",PrivatCar[playerid][ParkX],"Name", PrivatCar[playerid][PrivatNAme]);
    mysql_SetFloat("privatcars","CarPosY",PrivatCar[playerid][ParkY],"Name", PrivatCar[playerid][PrivatNAme]);
    mysql_SetFloat("privatcars","CarPosZ",PrivatCar[playerid][ParkZ],"Name", PrivatCar[playerid][PrivatNAme]);
    mysql_SetFloat("privatcars","CarPosA",PrivatCar[playerid][ParkA],"Name", PrivatCar[playerid][PrivatNAme]);
    }
    }
    return 1;
    }
    stock SaveCar(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    GetPlayerName(playerid,PrivatCar[playerid][PrivatNAme], MAX_PLAYER_NAME);
    mysql_SetInt("privatcars","Color1",PrivatCar[playerid][privatColor1],"Name", PrivatCar[playerid][PrivatNAme]);
    mysql_SetInt("privatcars","Color2",PrivatCar[playerid][privatColor2],"Name", PrivatCar[playerid][PrivatNAme]);
    mysql_SetString("privatcars","CarName",PrivatCar[playerid][PrivatCarName],"Name", PrivatCar[playerid][PrivatNAme]);
    }
    }


    hir mein LoadCar:


    Spoiler anzeigen
    stock LoadCar(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    GetPlayerName(playerid,PrivatCar[playerid][PrivatNAme], MAX_PLAYER_NAME);
    PrivatCar[playerid][privatColor1] = mysql_GetInt("privatcars", "Color1", "Name",PrivatCar[playerid][PrivatNAme]);
    PrivatCar[playerid][privatColor2] = mysql_GetInt("privatcars", "Color2", "Name",PrivatCar[playerid][PrivatNAme]);
    PrivatCar[playerid][PrivatCarName] = mysql_GetInt("privatcars", "CarName", "Name",PrivatCar[playerid][PrivatNAme]);
    }
    return 1;
    }