Beiträge von The Sensei


    Wenn ich /be eingebe Crasht mein GTA?

    Guten Tag,


    ich habe ein Kleines Problem
    Ich habe mein GodFather in MYSQL umgeschrieben bzw. bin ich dabei.
    Hier der MYSQL QUERY STRING:

    VORSICHT VIEL
    stock SpielerSpeichern(playerid)
    {
    new query[700], pmaname[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pmaname, sizeof(pmaname);
    if(IsPlayerConnected(playerid) == false) return 1;//15695
    format(query, sizeof(query), "UPDATE players SET username='%s',password='%s',Level='%d',Adminlevel='%d',DonateRank='%d',UpgradePoints='%d',ConnectedTime='%d',Registered='%d',Sex='%d',Age='%d',Origin='%d',Muted='%d',Respect='%d',Money='%d',Bank='%d',Crimes='%d',Kills='%d',Deaths='%d',Arrested='%d',WantedDeaths='%d',Phonebook='%d',LottoNr='%d',Fishes='%d',BiggestFish='%d',Job='%d',Paycheck='%d',Jailed='%d',GangJailed='%d',Mauled='%d',Jailtime='%d',Materials='%d',Drugs='%d',Cokain='%d',nonworkedcocain='%d',BoxMaterials='%d',BoxDrugs='%d',FightingStyle='%d',Char='%d',ContractTime='%d',DetSkill='%d',SexSkill='%d',BoxSkill='%d',LawSkill='%d',MechSkill='%d',JackSkill='%d',CarSkill='%d',NewsSkill='%d',DrugsSkill='%d',CookSkill='%d',FishSkill='%d',pSHealth='%f',pHealth='%f',Int='%d',Local='%d',Team='%d',Model='%d',GWD='%f',PhoneNr='%d',House='%d',Bizz='%d',HandyGeld='%d',HandyVer='%d',Pos_x=='%f',Pos_y='%f',Pos_z='%f',CarLic='%d',NewLic='%d',FlyLic='%d',BoatLic='%d',FishLic='%d',GunLic='%d',LKWLic='%d',RollerLic='%d'")
    format(query, sizeof(query), "UPDATE players SET MotoLic='%d',SchwarzmarktLic='%d',KopfgeldSumme='%d',Kopfgeld='%d',Zig='%d',Kekse='%d',ZigSucht='%d',Gun1='%d',Gun2='%d',Gun3='%d',Gun4='%d',Ammo1='%d',Ammo2='%d',Ammo3='%d',Ammo4='%d',CarTime='%d',Mulltime='%d',PayDay='%d',PayDayHad='%d',CDPlayer='%d',Wins='%d',Loses='%d',AlcoholPerk='%d',DrugPerk='%d',MiserPerk='%d',PainPerk='%d',TraderPerk='%d',Tutorial='%d',Warnings='%d',Adjustable='%d',Fuel='%d',Married='%d',MarriedTo='%s',SpawnChange='%d',WantedLevel='%d',WantedPoints='%d',PlayMinutes='%d',GesamtMinutes='%d',MinutesSinceAn='%d',SFPASS='%d',LSVPASS='%d',Offflucht='%d',Knast='%d',Uhr='%d',Handy='%d',KnastTime='%d',Perso='%d',FrakSperre='%d',Gehalt='%d',InvWeapon='%d',InvAmmo='%d',InvWeapon2='%d',InvAmmo2='%d',InvMats='%d',InvDrugs='%d',FlugTime='%d',FarmTime='%d',GDeaths='%d',GKills='%d',Meldung='%d',Tanke='%d',Zollpass='%d',ZollpassTime='%d',Gesperrt='%d',waffenslot1='%d',ammoslot1='%d',waffenslot2='%d',ammoslot2='%d',waffenslot3='%d',ammoslot3='%d'")
    format(query, sizeof(query), "UPDATE players SET waffenslot4='%d',ammoslot4='%d',waffenslot5='%d',ammoslot5='%d',waffenslot6='%d',ammoslot6='%d',waffenslot7='%d',ammoslot7='%d',waffenslot8='%d',ammoslot8='%d',waffenslot9='%d',ammoslot9='%d',waffenslot10='%d',ammoslot10='%d',waffenslot11='%d',ammoslot11='%d',waffenslot12='%d',ammoslot12='%d',waffenslot13='%d',ammoslot13='%d' WHERE username='%s'",PlayerInfo[playerid][pKey],PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pDonateRank],PlayerInfo[playerid][gPugrade],PlayerInfo[playerid][pConnectTime],PlayerInfo[playerid][pReg],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pOrigin],PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pCash],PlayerInfo[playerid][pBank],PlayerInfo[playerid][pCrimes],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pArrested],PlayerInfo[playerid][pWantedDeaths],PlayerInfo[playerid][pPhoneBook],
    PlayerInfo[playerid][pLottoNr],PlayerInfo[playerid][pFishes],PlayerInfo[playerid][pBiggestFish],PlayerInfo[playerid][pJob],PlayerInfo[playerid][pPayCheck],PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pGangJailed],PlayerInfo[playerid][pMauled],PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pMaterials],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pKokain],PlayerInfo[playerid][pUnverarbeitetesKokain],PlayerInfo[playerid][pBoxMats],PlayerInfo[playerid][pBoxDrugs],GetPlayerFightingStyle(playerid),PlayerInfo[playerid][pChar],PlayerInfo[playerid][pContractTime],PlayerInfo[playerid][pDetSkill],PlayerInfo[playerid][pSexSkill],PlayerInfo[playerid][pBoxSkill],PlayerInfo[playerid][pLawSkill],PlayerInfo[playerid][pMechSkill],PlayerInfo[playerid][pJackSkill],PlayerInfo[playerid][pCarSkill],PlayerInfo[playerid][pNewsSkill],PlayerInfo[playerid][pCookSkill],PlayerInfo[playerid][pFishSkill],PlayerInfo[playerid][pCookSkill],PlayerInfo[playerid][pFishSkill],PlayerInfo[playerid][pSHealth],
    PlayerInfo[playerid][pHealth],PlayerInfo[playerid][pInt],PlayerInfo[playerid][pLocal],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pModel],PlayerInfo[playerid][pPnumber],PlayerInfo[playerid][pPhousekey],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pGWD],PlayerInfo[playerid][pHandyGeld],PlayerInfo[playerid][pHandyVer],PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z],PlayerInfo[playerid][pCarLic],PlayerInfo[playerid][pNewLic],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pFishLic],PlayerInfo[playerid][pGunLic],PlayerInfo[playerid][pLKWLic],PlayerInfo[playerid][pRollerLic],PlayerInfo[playerid][pMotoLic],PlayerInfo[playerid][pZig],PlayerInfo[playerid][pKekse],PlayerInfo[playerid][pZigSucht],PlayerInfo[playerid][pGun1],PlayerInfo[playerid][pGun2],PlayerInfo[playerid][pGun3],PlayerInfo[playerid][pGun4],PlayerInfo[playerid][pAmmo1],PlayerInfo[playerid][pAmmo2],PlayerInfo[playerid][pAmmo3],PlayerInfo[playerid][pAmmo4],
    PlayerInfo[playerid][pCarTime],PlayerInfo[playerid][pMulltime],PlayerInfo[playerid][pPayDay],PlayerInfo[playerid][pPayDayHad],PlayerInfo[playerid][pCDPlayer],PlayerInfo[playerid][pWins],PlayerInfo[playerid][pLoses],PlayerInfo[playerid][pAlcoholPerk],PlayerInfo[playerid][pDrugPerk],PlayerInfo[playerid][pMiserPerk],PlayerInfo[playerid][pPainPerk],PlayerInfo[playerid][pTraderPerk],PlayerInfo[playerid][pTut],PlayerInfo[playerid][pWarns],PlayerInfo[playerid][pAdjustable],PlayerInfo[playerid][pFuel],PlayerInfo[playerid][pMarried],PlayerInfo[playerid][pMarriedTo],SpawnChange[playerid],WantedLevel[playerid],WantedPoints[playerid],PlayerInfo[playerid][pPlayMinutes],PlayerInfo[playerid][pGesamtMinutes],PlayerInfo[playerid][pMinutesSinceAn],PlayerInfo[playerid][pSFPASS],PlayerInfo[playerid][pLVPASS],OfflineFlucht[playerid],Knast[playerid],PlayerInfo[playerid][pUhrID],PlayerInfo[playerid][pHandyID],KnastTime[playerid],PlayerInfo[playerid][pOwnPerso],PlayerInfo[playerid][pFrakSperre],PlayerInfo[playerid][pGehalt],
    PlayerInfo[playerid][pInWeapon],PlayerInfo[playerid][pInvAmmo],PlayerInfo[playerid][pInvWeapon2],PlayerInfo[playerid][pInvAmmo2],PlayerInfo[playerid][pInvMats],PlayerInfo[playerid][pInvDrugs],PlayerInfo[playerid][pFlugTime],PlayerInfo[playerid][pFarmTime],PlayerInfo[playerid][pGDeaths],PlayerInfo[playerid][pGKills],PlayerInfo[playerid][pMeldung],PlayerInfo[playerid][pPtankekey],PlayerInfo[playerid][pZollPass],PlayerInfo[playerid][pZollPassTime],PlayerInfo[playerid][pGesperrt],WantedLevel[playerid],pmaname);
    mysql_tquery(mysqlHandle, query);
    printf("Acc gespeichert (%s)",NamePlayer(playerid));
    return 1;
    }


    Dies hab ich mit der Hand umgeschrieben.


    Aber es sind diese Warning/Fehler Meldungen:


    Bitte um Hilfe.

    Code
    C:\Users\Patrick\Desktop\IRP-City\gamemodes\T2R.pwn(11919) : error 017: undefined symbol "mysql_log"
    C:\Users\Patrick\Desktop\IRP-City\gamemodes\T2R.pwn(15632) : error 017: undefined symbol "cache_get_data"
    C:\Users\Patrick\Desktop\IRP-City\gamemodes\T2R.pwn(15631) : warning 203: symbol is never used: "num_fields"
    C:\Users\Patrick\Desktop\IRP-City\gamemodes\T2R.pwn(15654) : error 017: undefined symbol "mysql_function_query"


    Jeffry: vielleicht :?
    Habe diese 3 Errors doch weiß nicht warum...

    Spoiler anzeigen
    Gamemode Init
    mysqlHandle = mysql_connect(db_host,db_user,db_db,db_pass);
    if(mysql_errno() < 1)print("MySQL: Die Verbindung wurde erfolgreich hergestellt."),mysql_log(LOG_ALL); else print("MySQL: Die Verbindung zur MySQL Datenbank konnte nicht hergestellt werden | Der Server wird nun heruntergefahren."), SendRconCommand("exit");

    UserCheck:
    public OnUserCheck(playerid)
    {
    new num_rows, num_fields;
    cache_get_data(num_rows, num_fields, mysqlHandle);
    if(num_rows == 0)
    {
    //Registrierung
    ShowPlayerDialog(playerid,DIALOG_REG,DIALOG_STYLE_MSGBOX,"Regristrierung","Herzlich Willkommen auf Time2Rush Reallife.\nDamit du auf dem Server spielen kannst musst du dich\nzunächst einmal Regristrieren.Bitte gib dein gewünschtes Passwort ein.","Erstellen","Abbrechen");
    }
    else
    {
    //Login
    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_INPUT,"Login","Willkommen auf Time2Rush Reallifelife,\n\n\n\n Bitte Logge dich nun ein!\n\n\n","Login","Abbrechen");
    }
    return 1;
    }

    if(strcmp(cmd,"/wiederbeleben",true) == 0)
    {
    if(IsPlayerConnected(playerid))
    {
    tmp = strtok(cmdtext, idx);
    if(!strlen(tmp))
    {
    SendClientMessage(playerid,F_Gray,"Befehl: /wiederbeleben [SpielerID/Name]");
    return 1;
    }
    new para1;
    para1 = ReturnUser(tmp);
    if(PlayerInfo[playerid][pMember] >= 4 || PlayerInfo[playerid][pLeader] >= 4)
    {
    if(IsPlayerConnected(para1))
    {
    if(para != INVALID_PLAYER_ID)
    {
    new Float:x, Float:y, Float:z,string[128];
    GetPlayerPos(para1, x, y, z);
    if(IsPlayerInRangeOfPoint(2, x, y, z)
    {
    PlayerInfo[para1][pTot] = 0;
    SetPlayerSpawn(para1);
    format(string,sizeof,(string),"Du hast Spieler %s wiederbelebt.",para1);//31818
    SendClientMessage(playerid,COLOR_GREEN,string);
    GivePlayerMoney(playerid, 600);
    }
    else
    {
    SendClientMessage(playerid,F_Gray,"Du bist nicht beim Opfer.");
    }
    }
    }
    }
    else
    {
    SendClientMessage(playerid,F_Red,"Du bist kein Sanitäter!");
    }
    }
    return 1;
    }


    Fehlercode:

    Ok ich mach das so das im Label Name und Wantedzahl steht und dann mit Dini in die Dateireinschreiben.
    Aber beim label kommt ein Fehler:
    new Float:x, Float:y, Float:z,name[MAX_PLAYER_NAME],string[128];
    if(WantedLevel[playerid] >= 1)
    {
    GetPlayerName(playerid, name, sizeof(name));
    GetPlayerPos(playerid, x, y, z);
    CreatePickup(1247, 4, x, y, z, GetPlayerVirtualWorld(playerid));
    format(string,sizeof,(string),"Tippe Spieler: %s | Wantedlevel: %d",name, WantedLevel[name]);//Fehler Zeile
    Create3DTextLabel(string,COLOR_YELLOW,x,y,z,7.0,0,0);
    }



    Weißt du was falsch ist ..

    Hat wer eine Idee wie ich Offlinearrest per dini machen könnte?
    Hab schonmal so das er ein Pickup und ein Label da erstellt wo er Offline gegangen ist ist.

    Spoiler anzeigen
    new Float:x, Float:y, Float:z;
    if(WantedLevel[playerid] >= 1)
    {
    GetPlayerPos(playerid, x, y, z);
    CreatePickup(1247, 4, x, y, z, GetPlayerVirtualWorld(playerid));
    Create3DTextLabel("Tippe /Offline Arrest",COLOR_YELLOW,x,y,z,7.0,0,0);
    }
    und hier was passiert wenn er ins Pickup rein läuft:
    if(pickupid == 1247)
    {
    if(IsACop(playerid))
    {
    SendClientMessage(playerid,F_Gray,"Du hast das Pickup erreicht.");
    }
    else
    {
    SendClientMessage(playerid,F_Gray,"Du bist kein Beamter.");
    }
    }

    Brauche Anstoß