Beiträge von SoichiroYagami

  • Script bleibt einfach "stehen"...

    Habe das Script jetzt auf 1 String umgeschrieben. geht immernoch nicht nach new Query Hängt das Script wieder



    printf("1");
    new query[5000];
    printf("create Query");
    format(query, sizeof(query), "%s%s%s%s%s%s%s%s%s%s%s%s",
    "INSERT INTO Clients (name, pKey, pLevel, pAdmin, pDonateRank, gPupgrade, pConnectTime, pReg, pSex,",
    "pAge, pOrigin, pCK, pMuted, pExp, pCash, pAccount, pCrimes, pKills, pDeaths, pArrested, pWantedDeaths,",
    "pPhoneBook, pLottoNr, pFishes, pJob, PPayCheck, pHeadValue, pJailed, pJailTime, pMats, pDrugs, pLeader,",
    "pMember, pFMember, pRank, pChar, pContractTime, pDetSkill, pSexSkill, pBoxSkill, pLawSkill, pMechSkill,",
    "pJackSkill, pCarSkill, pNewsSkill, pDrugsSkill, pCookSkill, pFishSkill, pHealth, pSHealth, pInt,",
    "pLocal, pTeam, pModel, pPnumber, pPhousekey, pPbiskey, pPos_x, pPos_y, pPos_z, pCarLic, pNewLic,",
    "pFlyLic, pBoatLic, pFishLic, pGunLic, pLKWLic, pMotoLic, pZig, pZigSucht, pGun1, pGun2, pGun3, pGun4,",
    "pAmmo1, pAmmo2, pAmmo3, pAmmo4, pCarTime, pPayDay, pPayDayHad, pCDPlayer, pWins, pLoses, pAlcoholPerk,",
    "pDrugPerk, pMiserPerk, pPainPerk, pTraderPerk, pTut, pWarns, pAdjustable, pFuel, pMarried, pMarriedTo,",
    "pRoadblock, pPlayMinutes, pGesamtMinutes, pMinutesSinceLogin, pMinutesSinceAn, pSFPASS, pLVPASS,",
    "pHandyGeld, pHandyVer, pUhrID, pHandyID, pTot, pTx, pTy, pTz, pOwnPerso, pOwnAntrag, pPersoStop,pFrakSperre, pWantedLevel, pWantedPoints, pKnastTime, pKnast, pOfflineFlucht, pSpawnChange) ");



    printf(query);

    format(query, sizeof(query), "%sVALUES ('%s','%s',%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,",
    query,
    playername3,
    PlayerInfo[playerid][pKey],
    PlayerInfo[playerid][pLevel],
    PlayerInfo[playerid][pAdmin],
    PlayerInfo[playerid][pDonateRank],
    PlayerInfo[playerid][gPupgrade],
    PlayerInfo[playerid][pConnectTime],
    PlayerInfo[playerid][pReg],
    PlayerInfo[playerid][pSex],
    PlayerInfo[playerid][pAge],
    PlayerInfo[playerid][pOrigin],
    PlayerInfo[playerid][pCK],
    PlayerInfo[playerid][pMuted],
    PlayerInfo[playerid][pExp],
    PlayerInfo[playerid][pCash],
    PlayerInfo[playerid][pAccount],
    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][pJob],
    PlayerInfo[playerid][pPayCheck],
    PlayerInfo[playerid][pHeadValue],
    PlayerInfo[playerid][pJailed],
    PlayerInfo[playerid][pJailTime],
    PlayerInfo[playerid][pMats],
    PlayerInfo[playerid][pDrugs]);
    printf(query);
    format(query, sizeof(query), "%s%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%f,%f,%i,%i,%i,%i,%i,%i,%i,%f,%f,%f,%i,%i,%i,%i,%i,%i,",
    query,
    PlayerInfo[playerid][pLeader],
    PlayerInfo[playerid][pMember],
    PlayerInfo[playerid][pFMember],
    PlayerInfo[playerid][pRank],
    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][pDrugsSkill],
    PlayerInfo[playerid][pCookSkill],
    PlayerInfo[playerid][pFishSkill],
    PlayerInfo[playerid][pHealth],
    PlayerInfo[playerid][pSHealth],
    PlayerInfo[playerid][pInt],
    PlayerInfo[playerid][pLocal],
    PlayerInfo[playerid][pTeam],
    PlayerInfo[playerid][pModel],
    PlayerInfo[playerid][pPnumber],
    PlayerInfo[playerid][pPhousekey],
    PlayerInfo[playerid][pPbiskey],
    PlayerInfo[playerid][pPos_x],
    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]);
    printf(query);
    format(query, sizeof(query), "%s%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,'%s',%i,%i,%i,%i,%i,",
    query,
    PlayerInfo[playerid][pLKWLic],
    PlayerInfo[playerid][pMotoLic],
    PlayerInfo[playerid][pZig],
    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][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],
    PlayerInfo[playerid][pRoadblock],
    PlayerInfo[playerid][pPlayMinutes],
    PlayerInfo[playerid][pGesamtMinutes],
    PlayerInfo[playerid][pMinutesSinceLogin],
    PlayerInfo[playerid][pMinutesSinceAn]);
    printf(query);
    format(query, sizeof(query), "%s%i,%i,%i,%i,%i,%i,%i,%f,%f,%f,%i,%i,%i,%i, %i, %i, %i, %i, %i, %i)",
    query,
    PlayerInfo[playerid][pSFPASS],
    PlayerInfo[playerid][pLVPASS],
    PlayerInfo[playerid][pHandyGeld],
    PlayerInfo[playerid][pHandyVer],
    PlayerInfo[playerid][pUhrID],
    PlayerInfo[playerid][pHandyID],
    PlayerInfo[playerid][pTot],
    PlayerInfo[playerid][pTx],
    PlayerInfo[playerid][pTy],
    PlayerInfo[playerid][pTz],
    PlayerInfo[playerid][pOwnPerso],
    PlayerInfo[playerid][pOwnAntrag],
    PlayerInfo[playerid][pPersoStop],
    PlayerInfo[playerid][pFrakSperre],
    WantedLevel[playerid],
    WantedPoints[playerid],
    KnastTime[playerid],
    Knast[playerid],
    OfflineFlucht[playerid],
    SpawnChange[playerid]);



    printf(query);
    mysql_tquery(SQLHandel, query);

  • 4 Errors

    Zitat von Danny_

    C:\Users\Betim\Desktop\LoS Script\Backup LoR\LoR\gamemodes\LoR.pwn(3063) : warning 213: tag mismatch
    C:\Users\Betim\Desktop\LoS Script\Backup LoR\LoR\gamemodes\LoR.pwn(42789) : error 017: undefined symbol "SortDeepArray"
    C:\Users\Betim\Desktop\LoS Script\Backup LoR\LoR\gamemodes\LoR.pwn(42789) : error 017: undefined symbol "SORT_DESC"
    C:\Users\Betim\Desktop\LoS Script\Backup LoR\LoR\gamemodes\LoR.pwn(42789) : error 029: invalid expression, assumed zero
    C:\Users\Betim\Desktop\LoS Script\Backup LoR\LoR\gamemodes\LoR.pwn(42789) : fatal error 107: too many error messages on one line


    C:\Users\Betim\Desktop\LoS Script\Backup LoR\LoR\gamemodes\LoR.pwn(3063) : warning 213: tag mismatch <-- Einrückungs fehler(Leerzeichen stat Tab)
    C:\Users\Betim\Desktop\LoS Script\Backup LoR\LoR\gamemodes\LoR.pwn(42789) : error 017: undefined symbol "SortDeepArray" <-- Funktion nicht Gefunden ggf. Fehlen Includes
    C:\Users\Betim\Desktop\LoS Script\Backup LoR\LoR\gamemodes\LoR.pwn(42789) : error 017: undefined symbol "SORT_DESC" <-- Warscheinlich ein Define was es nicht gibt
    C:\Users\Betim\Desktop\LoS Script\Backup LoR\LoR\gamemodes\LoR.pwn(42789) : error 029: invalid expression, assumed zero <-- Klammer Fehler
    C:\Users\Betim\Desktop\LoS Script\Backup LoR\LoR\gamemodes\LoR.pwn(42789) : fatal error 107: too many error messages on one line <-- Einfache nachricht das zu viele Fehler in der Zeile sind


    //Edit: Schreib bitte nächstes mal die Zeilen nummer vor oder Beschreib wo welcher fehler ist.

  • Script bleibt einfach "stehen"...

    new query[2000]; <-- Ab hier new valuesquery1[2000]; new valuesquery2[2000]; new valuesquery3[2000]; new valuesquery4[2000];


    nachdem new query[2000]; im Script kommt bleibt die Funktion stehen...


    Danke im Vorraus.


    //Edit: Falscher bereich Bitte verschieben in den Scripting Bereich von SAMP

  • error 033: array must be indexed (variable "-unknown-")

    @Jeffry geht leichter ^^


    format(query, sizeof(query), "%s%s%s%s%s%s%s%s%s%s",
    "CREATE TABLE IF NOT EXISTS Clients (id INT NOT NULL AUTO_INCREMENT,name VARCHAR(25),pKey VARCHAR(128),pLevel INT,",
    "pAdmin INT,pDonateRank INT,gPupgrade INT,pConnectTime INT,pReg INT,pSex INT,pAge INT,pOrigin INT,pCK INT,pMuted INT,",
    "pExp INT,pCash INT,pAccount INT,pCrimes INT,pKills INT,pDeaths INT,pArrested INT,pWantedDeaths INT,pPhoneBook INT,",
    "pLottoNr INT,pFishes INT,pJob INT,PPayCheck INT,pHeadValue INT,pJailed INT,pJailTime INT,pMats INT,pDrugs INT,",
    "pLeader INT,pMember INT,pFMember INT,pRank INT,pChar INT,pContractTime INT,pDetSkill INT,pSexSkill INT,pBoxSkill INT,",
    "pLawSkill INT,pMechSkill INT,pJackSkill INT,pCarSkill INT,pNewsSkill INT,pDrugsSkill INT,pCookSkill INT,pFishSkill INT,",
    "pHealth FLOAT,pSHealth FLOAT,pInt INT,pLocal INT,pTeam INT,pModel INT,pPnumber INT,pPhousekey INT,pPbiskey INT,",
    "pPos_x FLOAT,pPos_y FLOAT,pPos_z FLOAT,pCarLic INT,pNewLic INT,pFlyLic INT,pBoatLic INT,pFishLic INT,pGunLic INT,",
    "pLKWLic INT,pMotoLic INT,pZig INT,pZigSucht INT,pGun1 INT,pGun2 INT,pGun3 INT,pGun4 INT,pAmmo1 INT,pAmmo2 INT,pAmmo3 INT,pAmmo4 INT,pCarTime INT,pPayDay INT,pPayDayHad INT,pCDPlayer INT,pWins INT,",
    "pLoses INT,pAlcoholPerk INT,pDrugPerk INT,pMiserPerk INT,pPainPerk INT,pTraderPerk INT,pTut INT,pWarns INT,pAdjustable INT,pFuel INT,pMarried INT,pMarriedTo VARCHAR(128),pRoadblock INT,pPlayMinutes INT,pGesamtMinutes INT,pMinutesSinceLogin INT,pMinutesSinceAn INT,pSFPASS INT,pLVPASS INT,pHandyGeld INT,pHandyVer INT,pUhrID INT,pHandyID INT,pTot INT,pTx FLOAT,pTy FLOAT,pTz FLOAT,pOwnPerso INT,pOwnAntrag INT,pPersoStop INT,pFrakSperre INT,PRIMARY KEY (id))");

  • error 033: array must be indexed (variable "-unknown-")

    (12583) : error 075: input line too long (after substitutions)
    (12584) : error 037: invalid string (possibly non-terminated string)
    (12584) : error 017: undefined symbol "CREATE"
    (12584) : error 017: undefined symbol "TABLE"
    (12584) : fatal error 107: too many error messages on one line


    format(query, sizeof(query), "CREATE TABLE IF NOT EXISTS Clients (id INT NOT NULL AUTO_INCREMENT,name VARCHAR(25),pKey VARCHAR(128),pLevel INT,pAdmin INT,pDonateRank INT,gPupgrade INT,pConnectTime INT,pReg INT,pSex INT,pAge INT,pOrigin INT,pCK INT,pMuted INT,pExp INT,pCash INT,pAccount INT,pCrimes INT,pKills INT,pDeaths INT,pArrested INT,pWantedDeaths INT,pPhoneBook INT,pLottoNr INT,pFishes INT,pJob INT,PPayCheck INT,pHeadValue INT,pJailed INT,pJailTime INT,pMats INT,pDrugs INT,pLeader INT,pMember INT,pFMember INT,pRank INT,pChar INT,pContractTime INT,pDetSkill INT,pSexSkill INT,pBoxSkill INT,pLawSkill INT,pMechSkill INT,pJackSkill INT,pCarSkill INT,pNewsSkill INT,pDrugsSkill INT,pCookSkill INT,pFishSkill INT,pHealth FLOAT,pSHealth FLOAT,pInt INT,pLocal INT,pTeam INT,pModel INT,pPnumber INT,pPhousekey INT,pPbiskey INT,pPos_x FLOAT,pPos_y FLOAT,pPos_z FLOAT,pCarLic INT,pNewLic INT,pFlyLic INT,pBoatLic INT,pFishLic INT,pGunLic INT,pLKWLic INT,pMotoLic INT,pZig INT,pZigSucht INT,pGun1 INT,pGun2 INT,pGun3 INT,pGun4 INT,pAmmo1 INT,pAmmo2 INT,pAmmo3 INT,pAmmo4 INT,pCarTime INT,pPayDay INT,pPayDayHad INT,pCDPlayer INT,pWins INT,pLoses INT,pAlcoholPerk INT,pDrugPerk INT,pMiserPerk INT,pPainPerk INT,pTraderPerk INT,pTut INT,pWarns INT,pAdjustable INT,pFuel INT,pMarried INT,pMarriedTo VARCHAR(128),pRoadblock INT,pPlayMinutes INT,pGesamtMinutes INT,pMinutesSinceLogin INT,pMinutesSinceAn INT,pSFPASS INT,pLVPASS INT,pHandyGeld INT,pHandyVer INT,pUhrID INT,pHandyID INT,pTot INT,pTx FLOAT,pTy FLOAT,pTz FLOAT,pOwnPerso INT,pOwnAntrag INT,pPersoStop INT,pFrakSperre INT,PRIMARY KEY (id))");

  • error 033: array must be indexed (variable "-unknown-")

    public CreateTabels() { new query[1000]; query = "CREATE TABLE IF NOT EXISTS Clients (id INT NOT NULL AUTO_INCREMENT,name VARCHAR(25),pKey VARCHAR(128),pLevel INT,pAdmin INT,pDonateRank INT,gPupgrade INT,pConnectTime INT,pReg INT,pSex INT,pAge INT,pOrigin INT,pCK INT,pMuted INT,pExp INT,pCash INT,pAccount INT,pCrimes INT,pKills INT,pDeaths INT,pArrested INT," + "pWantedDeaths INT,pPhoneBook INT,pLottoNr INT,pFishes INT,pJob INT,PPayCheck INT,pHeadValue INT,pJailed INT,pJailTime INT,pMats INT,pDrugs INT,pLeader INT,pMember INT,pFMember INT,pRank INT,pChar INT,pContractTime INT,pDetSkill INT,pSexSkill INT,pBoxSkill INT,pLawSkill INT,pMechSkill INT,pJackSkill INT,pCarSkill INT,pNewsSkill INT," + "pDrugsSkill INT,pCookSkill INT,pFishSkill INT,pHealth FLOAT,pSHealth FLOAT,pInt INT,pLocal INT,pTeam INT,pModel INT,pPnumber INT,pPhousekey INT,pPbiskey INT,pPos_x FLOAT,pPos_y FLOAT,pPos_z FLOAT,pCarLic INT,pNewLic INT,pFlyLic INT,pBoatLic INT,pFishLic INT,pGunLic INT,pLKWLic INT,pMotoLic INT,pZig INT,pZigSucht INT,pGun1 INT,pGun2 INT," + "pGun3 INT,pGun4 INT,pAmmo1 INT,pAmmo2 INT,pAmmo3 INT,pAmmo4 INT,pCarTime INT,pPayDay INT,pPayDayHad INT,pCDPlayer INT,pWins INT,pLoses INT,pAlcoholPerk INT,pDrugPerk INT,pMiserPerk INT,pPainPerk INT,pTraderPerk INT,pTut INT,pWarns INT,pAdjustable INT,pFuel INT,pMarried INT,pMarriedTo VARCHAR(128),pRoadblock INT,pPlayMinutes INT," + "pGesamtMinutes INT,pMinutesSinceLogin INT,pMinutesSinceAn INT,pSFPASS INT,pLVPASS INT,pHandyGeld INT,pHandyVer INT,pUhrID INT,pHandyID INT,pTot INT," + "pTx FLOAT,pTy FLOAT,pTz FLOAT,pOwnPerso INT,pOwnAntrag INT,pPersoStop INT,pFrakSperre INT,PRIMARY KEY (id))"; mysql_tquery(SQLHandel,query);}


    (12584 -- 12586) : error 033: array must be indexed (variable "-unknown-")
    (12584 -- 12589) : error 033: array must be indexed (variable "-unknown-")


    Der Große Query String gibt mir die Errors aus.Kann mir da jemand Helfen ?


    Danke im Vorraus.