Beiträge von SlashQ

  • Fehler mit Loginsystem

    Hi das Login System geht nicht mehr und ich weiß nicht warum... Das Passwort wird richtig Gesetzt und ich gebe es auch Richtig ein, doch leider kommt die Meldung das Passwort sei Falsch
    Hier der Code:
    OnPlayerLogin(playerid,password[]){if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid)){new string[144];mysql_real_escape_string(password,string);mysql_real_escape_string(SpielerName(playerid), SpielerName(playerid));format(string, sizeof(string), "SELECT SpielerName FROM `"AccTable"` WHERE SpielerName = '%s' AND Password = md5('%s') LIMIT 1",SpielerName(playerid),string);print(string);mysql_query(string);mysql_store_result();if(mysql_num_rows()){new IP[16];GetPlayerIp(playerid,IP,16);format(string, sizeof(string), "UPDATE "AccTable" SET `LastIP` = '%s' WHERE SpielerName = '%s' LIMIT 1", IP, SpielerName(playerid)); mysql_query(string);LogPlayerIn(playerid, SpielerName(playerid));}else ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD,""#COL_WHITE""#Servername": Login",#COL_RED"Falsches Passwort!"#COL_WHITE" Du hast noch einen Versuch","Login","Verlassen");mysql_free_result();}return false;}




    //Edit kann geschlossen werden. Fehler gefunden

  • Problem mit TSConnector

    Hi, wollte das TSConnector Plugin Testen aber wenn ich auf dem TS bin und InGame /Rechte eingebe Passiert nichts.
    Evtl Nützlicher Code:
    Befehl:
    ocmd:rechte(playerid,params[])
    {
    TSC_SendClientMessage(PlayerInfo[playerid][pTSUID], "Du hast dir Erfolgreich Rechte gegeben!");
    SCM(playerid,COLOR_GREEN,"Rechte?");
    return 1;
    }
    Eindeutige UserId Setzen:
    case DIALOG_TS3:
    {
    new query[200];
    if(!response)return true;
    new ts3id = strval(inputtext);
    format(query,sizeof(query),"UPDATE "AccTable" SET `TS_UID` = '%s' WHERE UserId = '%d'",ts3id,GetPVarInt(playerid,"pDbID")); mysql_query(query);
    format(string,sizeof(string),"Du hast deine Ts3 Identität auf %d Geändert",ts3id);
    SCM(playerid,COLOR_GREEN,string);
    PlayerInfo[playerid][pTSUID] = ts3id;
    SCM(playerid,COLOR_GREEN,"Du hast dir Rechte gegeben!");
    }

  • [SAMMELTHREAD] Kleine Scripting Fragen

    Hi, wollte das TSConnector Plugin Testen aber wenn ich auf dem TS bin und InGame /Rechte eingebe Passiert nichts.
    Evtl Nützlicher Code:
    Befehl:
    ocmd:rechte(playerid,params[])
    {
    TSC_SendClientMessage(PlayerInfo[playerid][pTSUID], "Du hast dir Erfolgreich Rechte gegeben!");
    SCM(playerid,COLOR_GREEN,"Rechte?");
    return 1;
    }


    Eindeutige UserId Setzen:
    case DIALOG_TS3:
    {
    new query[200];
    if(!response)return true;
    new ts3id = strval(inputtext);
    format(query,sizeof(query),"UPDATE "AccTable" SET `TS_UID` = '%s' WHERE UserId = '%d'",ts3id,GetPVarInt(playerid,"pDbID")); mysql_query(query);
    format(string,sizeof(string),"Du hast deine Ts3 Identität auf %d Geändert",ts3id);
    SCM(playerid,COLOR_GREEN,string);
    PlayerInfo[playerid][pTSUID] = ts3id;
    SCM(playerid,COLOR_GREEN,"Du hast dir Rechte gegeben!");
    }

  • [SAMMELTHREAD] Kleine Scripting Fragen

    Es kommt immer noch das: [16:14:53 10/30/16] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 (Query: "UPDATE accounts SET `Level` = '1', `Admin` = '1338', `Ptankekey` = '0', `DonateRank` = '0', `Pupgrade` = '0', `Reg` = '2', `Sex` = '1', `Age` = '0', `Origin` = '0', `Muted` = '0', `Exp` = '0', `Cash` = '50000', `Account` = '0', `PlayerKreditDauer` = '0', `PlayerKredit` = '0', `Crimes` = '0', `Kills` = '0', `Deaths` = '1', `Arrested` = '0', `ConnectTime` = '0',`WantedDeaths` = '0', `PhoneBook` = '0', `LottoNr` = '0', `Fishes` = '0', `BiggestFish` = '0', `Job` = '0', `Paycheck` = '0', `Rest` = '0', `Jailed` = '0', `JailTime` = '0', `GangJailed` = '0', `Mauled` = '0', `Mats` = '0', `Drugs` = '0', `Leader` = '0', `Punkte` = '0', `Member` = '0', `Rank` = '0', `ContractTime` = '0', `DetSkill` = '0',")
    [16:14:53 10/30/16] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty (Query: "")

  • [SAMMELTHREAD] Kleine Scripting Fragen

    Ja das: format(squery,sizeof(squery),"UPDATE accounts SET `Level` = '%d', `Admin` = '%d', `Ptankekey` = '%d', `DonateRank` = '%d', `Pupgrade` = '%d', `Reg` = '%d', `Sex` = '%d', `Age` = '%d', `Origin` = '%d', `Muted` = '%d', `Exp` = '%d', `Cash` = '%d', `Account` = '%d', `PlayerKreditDauer` = '%d', `PlayerKredit` = '%d', `Crimes` = '%d', `Kills` = '%d', `Deaths` = '%d', `Arrested` = '%d', `ConnectTime` = '%d',",
    PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pPtankekey],PlayerInfo[playerid][pDonateRank],PlayerInfo[playerid][pUpgrade],PlayerInfo[playerid][pReg],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pOrigin],PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pRespekt],GetPlayerMoney(playerid),PlayerInfo[playerid][pAccount],
    PlayerInfo[playerid][pPlayerKreditDauer],PlayerInfo[playerid][pPlayerKredit],PlayerInfo[playerid][pCrimes],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pArrested],PlayerInfo[playerid][pConnectTime]);
    strcat(mainquery, squery);
    strdel(squery, 0, sizeof(squery));


    format(squery,sizeof(squery),"UPDATE accounts SET `WantedDeaths` = '%d', `PhoneBook` = '%d', `LottoNr` = '%d', `Fishes` = '%d', `BiggestFish` = '%d', `Job` = '%d', `Paycheck` = '%d', `Rest` = '%d', `Jailed` = '%d', `JailTime` = '%d', `GangJailed` = '%d', `Mauled` = '%d', `Mats` = '%d', `Drugs` = '%d', `Leader` = '%d', `Punkte` = '%d', `Member` = '%d', `Rank` = '%d', `ContractTime` = '%d', `DetSkill` = '%d',",
    squery,PlayerInfo[playerid][pWantedDeaths],PlayerInfo[playerid][pPhoneBook],PlayerInfo[playerid][pLottoNr],PlayerInfo[playerid][pFishes],PlayerInfo[playerid][pBiggestFish],PlayerInfo[playerid][pJob],PlayerInfo[playerid][pPayCheck],PlayerInfo[playerid][pRest], PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pGangJailed],
    PlayerInfo[playerid][pMauled],PlayerInfo[playerid][pMats],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pPunkte], PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRank],PlayerInfo[playerid][pContractTime], PlayerInfo[playerid][pDetSkill]);
    strcat(mainquery, squery);
    strdel(squery, 0, sizeof(squery));


    format(query,sizeof(query),"UPDATE accounts SET `SexSkill` = '%d', `BoxSkill` = '%d', `LawSkill` = '%d', `MechSkill` = '%d', `JackSkill` = '%d', `CarSkill` = '%d', `NewsSkill` = '%d', `DrugsSkill` = '%d', `CookSkill` = '%d', `FishSkill` = '%d', `pHealth` = '%.2f', `pSHealth` = '%.2f', `Local` = '%d', `Team` = '%d', `Model` = '%d', `Pnumber` = '%d', `Phousekey` = '%d', `Pbiskey` = '%d', `Pos_x` = '%.2f', `Pos_y` = '%.2f', `Pos_z` = '%.2f' WHERE Name = '%s'",
    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][pLocal],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pModel],PlayerInfo[playerid][pPhoneNumber],PlayerInfo[playerid][pHouseKey],PlayerInfo[playerid][pBizKey],PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z], pName);
    strcat(mainquery, squery);
    strdel(squery, 0, sizeof(squery));


    mysql_function_query(dbHandle, mainquery, false, "", "");
    strdel(mainquery, 0, sizeof(mainquery));


    //=======: Query 2 :=======//
    format(query,sizeof(query),"UPDATE accounts SET `CarLic` = '%d', `FlyLic` = '%d', `BoatLic` = '%d', `FishLic` = '%d', `GunLic` = '%d', `LKWLic` = '%d', `RollerLic` = '%d', `MotoLic` = '%d', `Zig` = '%d', `Kekse` = '%d', `ZigSucht` = '%d', `CarTime` = '%d',",
    PlayerInfo[playerid][pCarLic],PlayerInfo[playerid][pFlyLic], PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pFishLic],PlayerInfo[playerid][pGunLic],PlayerInfo[playerid][pTruckLic],PlayerInfo[playerid][pMotoLic],PlayerInfo[playerid][pRollerLic],PlayerInfo[playerid][pZig],PlayerInfo[playerid][pKekse],PlayerInfo[playerid][pZigSucht],PlayerInfo[playerid][pCarTime]);
    strcat(mainquery, squery);
    strdel(squery, 0, sizeof(squery));
    format(query,sizeof(query),"`Plastiksprengstoff` = '%d', `PayDay` = '%d', `PayDayHad` = '%d', `CDPlayer` = '%d', `Loses` = '%d', `DrugPerk` = '%d', `MiserPerk` = '%d', `PainPerk` = '%d', `AlcoholPerk` = '%d', `TraderPerk` = '%d', `Warns` = '%d', `GWD` = '%d', `Fuel` = '%d', `Married` = '%d', `MarriedTo` = '%s', `InvDrugs` = '%d', `InvMats` = '%d', `FlugTime` = '%d',",
    PlayerInfo[playerid][pPlastikSprengstoff],PlayerInfo[playerid][pPayDay],PlayerInfo[playerid][pPayDayHad],PlayerInfo[playerid][pCDPlayer],PlayerInfo[playerid][pLoses],PlayerInfo[playerid][pDrugPerk],PlayerInfo[playerid][pMiserPerk],PlayerInfo[playerid][pPainPerk],PlayerInfo[playerid][pAlcoholPerk],PlayerInfo[playerid][pTraderPerk],
    PlayerInfo[playerid][pWarns],PlayerInfo[playerid][pGWD], PlayerInfo[playerid][pFuel],PlayerInfo[playerid][pMarried],PlayerInfo[playerid][pMarriedTo],PlayerInfo[playerid][pInvDrugs],PlayerInfo[playerid][pInvMats],PlayerInfo[playerid][pFlugTime]);
    strcat(mainquery, squery);
    strdel(squery, 0, sizeof(squery));
    format(query,sizeof(query),"`ErntTimer` = '%d', `InvadeTime` = '%d', `Roadblock` = '%d', `PlayMinutes` = '%d', `GesamtMinutes` = '%d', `MinutesSinceLogin` = '%d', `MinutesSinceAn` = '%d', `SFPASS` = '%d', `LVPASS` = '%d', `HandyGeld` = '%d', `HandyVer` = '%d', `UhrID` = '%d', `HandyID` = '%d', `OwnPerso` = '%d', `Tx` = '%.2f', `Ty` = '%.2f', `Tz` = '%.2f',",
    PlayerInfo[playerid][pErntTimer],PlayerInfo[playerid][pInvadeTime],PlayerInfo[playerid][pRoadblock],PlayerInfo[playerid][pPlayMinutes],PlayerInfo[playerid][pGesamtMinutes],PlayerInfo[playerid][pMinutesSinceLogin],PlayerInfo[playerid][pMinutesSinceAn],PlayerInfo[playerid][pSFPASS],PlayerInfo[playerid][pLVPASS],PlayerInfo[playerid][pHandyGeld],PlayerInfo[playerid][pHandyVer], PlayerInfo[playerid][pUhrID],
    PlayerInfo[playerid][pHandyID], PlayerInfo[playerid][pOwnPerso],PlayerInfo[playerid][pTx],PlayerInfo[playerid][pTy],PlayerInfo[playerid][pTz],pName);
    strcat(mainquery, squery);
    strdel(squery, 0, sizeof(squery));
    format(query,sizeof(query),"`Gehalt` = '%d',`FrakSperre` = '%d',`BoxMats` = '%d',`BoxDrugs` = '%d',`ban` = '%d',`Tot` = '%d',`FarmTime` = '%d',`GDeaths` = '%d',`GKills` = '%d',`Meldung` = '%d',`EXP` = '%d',`Akku` = '%d',`Fahrzeuge` = '%d',`Online` = '0',`Fahndungslevel` = '%d',`AcceptTickets` = '%d' WHERE `Name` = '%s'",
    PlayerInfo[playerid][pGehalt],PlayerInfo[playerid][pFrakSperre],PlayerInfo[playerid][pBoxMats],PlayerInfo[playerid][pBoxDrugs],PlayerInfo[playerid][pban],PlayerInfo[playerid][pTot],PlayerInfo[playerid][pFarmTime],PlayerInfo[playerid][pGDeaths],PlayerInfo[playerid][pGKills],PlayerInfo[playerid][pMeldung],PlayerInfo[playerid][pRespekt],PlayerInfo[playerid][pHandyAkku],PlayerInfo[playerid][pVehicles],WantedLevel[playerid],PlayerInfo[playerid][AcceptTickets],pName);
    strcat(mainquery, squery);
    strdel(squery, 0, sizeof(squery));
    mysql_function_query(dbHandle, mainquery, false, "", "");
    strdel(mainquery, 0, sizeof(mainquery));

  • [SAMMELTHREAD] Kleine Scripting Fragen

    format(squery,sizeof(squery),"UPDATE accounts SET `WantedDeaths` = '%d', `PhoneBook` = '%d', `LottoNr` = '%d', `Fishes` = '%d', `BiggestFish` = '%d', `Job` = '%d', `Paycheck` = '%d', `Rest` = '%d', `Jailed` = '%d', `JailTime` = '%d', `GangJailed` = '%d', `Mauled` = '%d', `Mats` = '%d', `Drugs` = '%d', `Leader` = '%d', `Punkte` = '%d', `Member` = '%d', `Rank` = '%d', `ContractTime` = '%d', `DetSkill` = '%d',",
    squery,PlayerInfo[playerid][pWantedDeaths],PlayerInfo[playerid][pPhoneBook],PlayerInfo[playerid][pLottoNr],PlayerInfo[playerid][pFishes],PlayerInfo[playerid][pBiggestFish],PlayerInfo[playerid][pJob],PlayerInfo[playerid][pPayCheck],PlayerInfo[playerid][pRest], PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pGangJailed],
    PlayerInfo[playerid][pMauled],PlayerInfo[playerid][pMats],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pPunkte], PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRank],PlayerInfo[playerid][pContractTime], PlayerInfo[playerid][pDetSkill]);
    strcat(mainquery, squery);
    strdel(squery, 0, sizeof(squery));