Spielerfarben in case festlegen

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • Wahrscheinlich wird dir die Farbe erst nach dem Tot gesetzt, weil bei dem ersten Aufruf die Fraktion noch auf 0 steht.
    Setze die Farbe da, wo du dich erfolgreich eingeloggt hast.

  • Also ich habe jetzt das hier gefunden, dort ist auch alles drin was du brauchst denke ich.


    public LoadAccount(playerid,pass[],passwortstate)
    {
    new query[356],result[25],rows,fields;
    if(/*mysql_ping() == 0*/mysql_errno(MySqlConnection) != 0)
    {
    getdate(tag,monat,jahr);
    gettime(stunde,minute,sekunde);
    ForEachPlayer(i)
    {
    if(IsPlayerConnected(i) && !IsPlayerNPC(i) && GetPVarInt(i,"Eingeloggt") == 1)
    {
    SaveAccount(i);
    }
    }
    Log("Restartssqllog","Admin: System hat den Server gerestartet(Dead MySql Connection)!");
    OnGameModeSave();
    GameModeExit();
    return 1;
    }
    cache_get_data(rows,fields);
    if(rows)
    {
    if(passwortstate == 1)
    {
    cache_get_field_content(0,"Passwort",result);
    new tmpp[25];
    strmid(tmpp, MD5_Hash(pass), 0, 24, 25);
    if(!strcmp(/*MD5_Hash(pass)*/tmpp,result,true))
    {
    format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_main WHERE Name='%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,query,true,"LoadAccount","isi",playerid," ",0);
    return 1;
    }
    format(query,sizeof(query),"{C9C9C9}Willkommen zurück "#SERVERFARBE"%s {C9C9C9}!\n{C9C9C9}Dein Account ist registriert.\nBitte Logge dich mit deinem entsprechendem Passwort ein.\n\n"#SERVERFARBE"** "#SERVERNAME" **{C9C9C9}",SpielerName(playerid));
    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Login",query,"Login","Abbrechen");
    return 1;
    }
    cache_get_field_content(0,"Tutorial",result);
    Spieler[playerid][pViewTutorial] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Admin",result);
    Spieler[playerid][pAdmin] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Verwarnungen",result);
    Spieler[playerid][pWarns] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FLeaderRechte",result);
    Spieler[playerid][pLeader] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Fraktion",result);
    Spieler[playerid][pFraktion] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FraktionsRang",result);
    Spieler[playerid][pFraktRang] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FraktionsURang",result);
    Spieler[playerid][pFraktURang] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FraktionsSperre",result);
    Spieler[playerid][pFraktionSperre] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FraktionsGehalt",result);
    Spieler[playerid][pFraktionsGehalt] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Job",result);
    Spieler[playerid][pJob] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"JobWarns",result);
    Spieler[playerid][JobWarns] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"JobSperre",result);
    Spieler[playerid][pJobSperre] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"ArbeitslosenGeld",result);
    Spieler[playerid][pWorkLess] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Geschlecht",result);
    Spieler[playerid][pSex] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"SpielerAlter",result);
    Spieler[playerid][pYearsOld] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Level",result);
    SetPlayerLevel(playerid,strval(result));
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Geld",result);
    ACMoney(playerid,strval(result));
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"GWD",result);
    Spieler[playerid][pGrundwehrdienst] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Zivinote",result);
    Spieler[playerid][pZiviNote] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FAbteilung",result);
    Spieler[playerid][pFraktABTInvite] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Bankguthaben",result);
    Spieler[playerid][pBank] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"BankPin",result);
    Spieler[playerid][pBankPin] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"WantedSterne",result);
    SetPlayerWantedLevel(playerid,strval(result));
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"WantedPunkte",result);
    Spieler[playerid][pWantedPoints] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Suspects",result);
    Spieler[playerid][pSuspectPoints] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Wanted_Grund1",result);
    strmid(pWantedReason1[playerid],result,0,strlen(result),64);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Wanted_Grund2",result);
    strmid(pWantedReason2[playerid],result,0,strlen(result),64);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Wanted_Grund3",result);
    strmid(pWantedReason3[playerid],result,0,strlen(result),64);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Wanted_Grund4",result);
    strmid(pWantedReason4[playerid],result,0,strlen(result),64);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Wanted_Grund5",result);
    strmid(pWantedReason5[playerid],result,0,strlen(result),64);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Crimes",result);
    Spieler[playerid][pLastSuspects] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"STVOcrimes",result);
    Spieler[playerid][pSTVOpoints] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"KampfStyle",result);
    SetPlayerFightingStyle(playerid,strval(result));
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Handy",result);
    Spieler[playerid][pHandy] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Handycoins",result);
    Spieler[playerid][pHandyCoins] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"HandyStatus",result);
    Spieler[playerid][pHandystate] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"HandyAkku",result);
    Spieler[playerid][pHandyakku] = floatstr(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"HandyNummer",result);
    Spieler[playerid][pPhonenumber] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Handyflat",result);
    Spieler[playerid][pHandyFlat] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Handyflatbuyinbiz",result);
    Spieler[playerid][pHandyBuyByBiz] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Letzte_X",result);
    Spieler[playerid][LastInGamePos_x] = floatstr(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Letzte_Y",result);
    Spieler[playerid][LastInGamePos_y] = floatstr(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Letzte_Z",result);
    Spieler[playerid][LastInGamePos_z] = floatstr(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Letzte_Interior",result);
    Spieler[playerid][LastInGamePos_int] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Letzte_VirtualWorld",result);
    Spieler[playerid][LastInGamePos_world] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pSelectHome",result);
    Spieler[playerid][pSelectHome] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"HausMieter",result);
    Spieler[playerid][pRentHome] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Spawn",result);
    Spieler[playerid][pSpawn] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Hotel",result);
    Spieler[playerid][pHotel] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Tod",result);
    Spieler[playerid][pDeath] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Tot_X",result);
    Spieler[playerid][tot_x] = floatstr(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Tot_Y",result);
    Spieler[playerid][tot_y] = floatstr(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Tot_Z",result);
    Spieler[playerid][tot_z] = floatstr(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Tot_Interior",result);
    Spieler[playerid][tot_int] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Tot_VirtualWorld",result);
    Spieler[playerid][tot_world] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"TotZeit",result);
    Spieler[playerid][pDeathTime] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Friedhof",result);
    Spieler[playerid][pFriedhof] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FriedhofZeit",result);
    Spieler[playerid][pFriedhofTime] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"ImKnast",result);
    Spieler[playerid][pJailed] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"KnastZeit",result);
    Spieler[playerid][pJailTime] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"KnastKaution",result);
    Spieler[playerid][pKaution] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Muted",result);
    Spieler[playerid][pMuted] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"MuteZeit",result);
    Spieler[playerid][pMuteTime] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"ImPrison",result);
    Spieler[playerid][pInPrison] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"PrisonCheckPointsAbgelaufen",result);
    Spieler[playerid][pPrisonCPsgelaufen] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"PrisonCheckPointsGegeben",result);
    Spieler[playerid][pPrisonCPsgegeben] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Morde",result);
    Spieler[playerid][pMorde] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Tode",result);
    Spieler[playerid][pTode] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"SkinID",result);
    Spieler[playerid][pSkin] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"FraktionSkinID",result);
    Spieler[playerid][pFraktSkin] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"PaintBallKills",result);
    Spieler[playerid][pPBKills] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"PaintBallTode",result);
    Spieler[playerid][pPBDeaths] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"PaintBallRang",result);
    Spieler[playerid][pPBRang] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"PaintBallBesuche",result);
    Spieler[playerid][pPBVisits] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"AngenommeneReports",result);
    Spieler[playerid][Reports] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"KopfGeld",result);
    Spieler[playerid][pHeadMoney] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pWantedDeaths",result);
    Spieler[playerid][pWantedDeaths] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pBuyTickets",result);
    Spieler[playerid][pBuyTickets] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pJailedCount",result);
    Spieler[playerid][pJailedCount] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Bankkonto",result);
    Spieler[playerid][pBankkonto] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pArmyPlaneOrder",result);
    Spieler[playerid][pArmyPlaneOrder] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pArmyHeliOrder",result);
    Spieler[playerid][pArmyHeliOrder] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pArmyWaffenOrder",result);
    Spieler[playerid][pArmyWaffenOrder] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"LevelUPKosten",result);
    Spieler[playerid][pLevelKosten] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"RespectForLevelUp",result);
    Spieler[playerid][pRespektToLevelUp] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"RespectFromPayday",result);
    Spieler[playerid][pRespektFromPayday] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"TimeAfterRegister",result);
    Spieler[playerid][pTimeAfterRegister] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Time4Payday",result);
    Spieler[playerid][pMinutesAfterPayday] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"TimeoutCrashExeorKick",result);
    Spieler[playerid][pAntiOfflineFlucht] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"RpChat",result);
    Spieler[playerid][pAntiOfflineFlucht] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"HabGeworben",result);
    Spieler[playerid][HatGeworben] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pPremium",result);
    Spieler[playerid][pPremium] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"GeworbenerSpieler",result);
    strmid(Spieler[playerid][GeworbenPlaya],result,0,strlen(result),24);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pScheinSperre",result);
    Spieler[playerid][pScheinSperre] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"DigiHud",result);
    Spieler[playerid][DigiHud] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pDHitsound",result);
    Spieler[playerid][pDHitsound] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Bonus",result);
    Spieler[playerid][pStartbonus] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"Gutschein",result);
    Spieler[playerid][pGutschein] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pCoins",result);
    Spieler[playerid][pCoins] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pFirmaLeader",result);
    Spieler[playerid][pFirmaLeader] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pFirmaMember",result);
    Spieler[playerid][pFirmaMember] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pOrgLeader",result);
    Spieler[playerid][pOrgLeader] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pOrgMember",result);
    Spieler[playerid][pOrgMember] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pParteiLeader",result);
    Spieler[playerid][pParteiLeader] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pParteiMember",result);
    Spieler[playerid][pParteiMember] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pLohn",result);
    Spieler[playerid][pLohn] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"WaitPerso",result);
    Spieler[playerid][WaitPerso] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pMarried",result);
    strmid(Spieler[playerid][pMarried],result,0,strlen(result),sizeof(result));
    strdel(result,0,sizeof(result));
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pBuyClothes",result);
    Spieler[playerid][pBuyClothes] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pTsIdent",result);
    strmid(Spieler[playerid][pTsIdent],result,0,strlen(result),24);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pIll",result);
    Spieler[playerid][pIll] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pConterminatedTime",result);
    Spieler[playerid][pConterminatedTime] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pBitchSkill",result);
    Spieler[playerid][pBitchSkill] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pBitchFuckCount",result);
    Spieler[playerid][pBitchFuckCount] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pMedicHealplayerSkill",result);
    Spieler[playerid][pMedicHealplayerSkill] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pMedicHealCount",result);
    Spieler[playerid][pMedicHealCount] = strval(result);
    strdel(result,0,sizeof(result));
    new stringlogin[256];
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_weapons WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountWeapons","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_fish WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountFish","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_koffer WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountKoffer","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_blacklist WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountBlacklists","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_inventar WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountInventar","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_licenses WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountLicenses","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_banksafe WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountBankSafe","i",playerid);
    for(new slot=0;slot<MAX_PLAYER_VEHS;slot++)
    {
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_vehicle WHERE name = '%s' AND slot = '%d'",SpielerName(playerid),slot);
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountVehicles","ii",playerid,slot);
    }
    mysql_SetInt(""#DATENBANKTAG"_account_main","Online",1,"Name",Spieler[playerid][pName]);
    AddToAutoLogin(playerid);
    StopPlayerPlaySound(playerid);
    PlayerPlaySound(playerid,1188,0.0,0.0,10.0);
    if(isPlayerAnAdmin(playerid,1))
    {
    format(stringlogin,sizeof(stringlogin),"{FF0000}<< {FFFFFF}%s %s #{FF0000} >>",Adminrang(playerid),SpielerName(playerid));
    SendAdminMessage(WEISS,stringlogin);
    switch(Spieler[playerid][pAdmin])
    {
    case 1:
    {
    TextDrawShowForPlayer(playerid,Reportdraw[0]);
    TextDrawShowForPlayer(playerid,Reportdraw[1]);
    }
    case 2,3,4:
    {
    TextDrawShowForPlayer(playerid,Reportdraw[0]);
    TextDrawShowForPlayer(playerid,Reportdraw[1]);
    TextDrawShowForPlayer(playerid,Reportdraw[2]);
    }
    case 5,6,7,8,9:
    {
    for(new i=0;i<sizeof(Reportdraw);i++)
    {
    TextDrawShowForPlayer(playerid,Reportdraw[i]);
    }
    }
    }
    format(stringlogin,sizeof(stringlogin),"Art: Login Admin: %s (Adminlevel: %i) * IP: %s - ID/PlayerID : %i",SpielerName(playerid),Spieler[playerid][pAdmin],SpielerIP(playerid),playerid);
    Log("Admin-Loginsqllog",stringlogin);
    }
    if(Spieler[playerid][pKoffer] == 1) SetPlayerAttachedObject(playerid,9,1210,5,0.310000,0.066999,0.000000,0.000000,-91.900009,0.000000,1.000000,1.000000,1.000000);
    if(Spieler[playerid][pHandy] != 0)
    {
    if(Spieler[playerid][pHandystate] == 1 && Spieler[playerid][pHandyakku] > 0.0)
    {
    PlayerTextDrawShow(playerid,HandyInfodraw[playerid]);
    HandyAkku(playerid);
    AkkuTimer[playerid] = SetTimerEx("HandyAkku",120000,1,"i",playerid);
    }
    }
    if(Spieler[playerid][pFraktion] != 0)
    {
    format(stringlogin,sizeof(stringlogin),"{00FFFF}<< Fraktionsmitglied{FF0000} %s {00FFFF}hat sich eingeloggt >>",SpielerName(playerid));
    SendFraktionsMessage(Spieler[playerid][pFraktion],HELLBLAU,stringlogin);
    }
    format(stringlogin,sizeof(stringlogin),"Name:%s | IP:%s",SpielerName(playerid),SpielerIP(playerid));
    Log("Player-Loginsql",stringlogin);
    if(Spieler[playerid][pViewTutorial] == 0)return ImTutorial[playerid] = 1;
    TogglePlayerControllable(playerid,1);
    TogglePlayerSpectating(playerid,0);
    SpawnPlayerEx(playerid);
    PlayerSpawned[playerid] = 1;
    TextDrawHideForPlayer(playerid,Introdraw[0]);
    TextDrawHideForPlayer(playerid,Introdraw[1]);
    format(stringlogin,sizeof(stringlogin),"{A91400}SERVER{FFFFFF}: Willkommen %s",SpielerName(playerid));
    SendClientMessage(playerid,WEISS,stringlogin);
    switch(monat)
    {
    case 1:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Januar");
    case 2:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Februar");
    case 3:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist März");
    case 4:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist April");
    case 5:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Mai");
    case 6:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Juni");
    case 7:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Juli");
    case 8:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist August");
    case 9:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist September");
    case 10:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Oktober");
    case 11:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist November");
    case 12:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Dezember");
    }
    if(tag == 31 && monat == 3) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Die Sommerzeit hat begonnen");
    if(tag == 27 && monat == 10) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Die Winterzeit hat begonnen");
    if(tag == 31 && monat == 10) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Halloween");
    if(tag == 24 && monat == 12) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Frohe Weihnachten");
    if(tag == 31 && monat == 12) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Das neue Jahr steht vor der Tür");
    if(tag == 1 && monat == 1) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Frohes Neues Jahr");
    TextDrawShowForPlayer(playerid,Version);
    TextDrawShowForPlayer(playerid,InfoSign);
    format(stringlogin,sizeof(stringlogin),"~w~Willkommen ~y~%s",SpielerName(playerid));
    PlayerTextDrawSetString(playerid,INFOdraw[playerid][2],stringlogin);
    StopAudioStreamForPlayer(playerid);
    PlayAudioStreamForPlayer(playerid,ServerSounds[13],0.0,0.0,0.0);
    PlayerTextDrawShow(playerid,INFOdraw[playerid][2]);
    SetTimerEx("HideInfoBox",4000,0,"i",playerid);
    MakeRace[playerid] = -1;
    SetPlayerWaffenSkill(playerid);
    if(!isPlayerInFrakt(playerid,0))
    {
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_fraktion_motd WHERE fID='%d'",Spieler[playerid][pFraktion]);
    mysql_function_query(MySqlConnection,stringlogin,true,"OnQueryFinish","siii",stringlogin,_SQL_FRAKTIONSMOTD_SELECT,playerid,MySqlConnection);
    }
    else ShowPlayerDialog(playerid,DIALOG_4ALL_SONSTIGES,DIALOG_STYLE_MSGBOX,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Info","Herzlich Willkommen auf "#SERVERNAME",\nbitte denke immer daran dich an die Regeln zu halten.\nBugs/Fehler im Spiel bitte im Forum melden.\n\nViel Spaß beim spielen!","Verlassen","");
    if(GetPlayerLevel(playerid) <= ENABLE_KILLORPAY_BYLEVEL)
    {
    format(stringlogin,sizeof(stringlogin),"ACHTUNG: Solltest du als Level %i´er einen Spieler töten,",GetPlayerLevel(playerid));
    SendClientMessage(playerid,LEUCHTENDESROT,stringlogin);
    SendClientMessage(playerid,LEUCHTENDESROT,"wirst du Automatisch vom System gebannt!");
    }
    if(Spieler[playerid][HatGeworben] == 0)
    {
    if(GetPlayerLevel(playerid) <= 3)
    {
    SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Niemand hat dich geworben ?");
    SendClientMessage(playerid,WEISS,"{FFFFFF} Falls doch Benutze: /geworben.");
    }
    else Spieler[playerid][HatGeworben] = 1;
    }
    new zeitdauer = gettime()+(60*60*24*7*2);//2 wochen
    mysql_SetInt(""#DATENBANKTAG"_account_main","PropertyClearTime",zeitdauer,"Name",SpielerName(playerid));
    SetPVarInt(playerid,"Eingeloggt",1);
    OnlinePlayer(playerid,true);
    printf("LOAD: %s Account hat geladen!",SpielerName(playerid));
    }
    return 1;
    }

  • Jetzt fügst du einfach deinen Code (switch(Spieler[playerid][Fraktion])) in den Code ein, am besten hier drunter:
    cache_get_field_content(0,"pMedicHealplayerSkill",result);
    Spieler[playerid][pMedicHealplayerSkill] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(0,"pMedicHealCount",result);
    Spieler[playerid][pMedicHealCount] = strval(result);
    strdel(result,0,sizeof(result));

  • Funktioniert nicht, ist immer noch so, dass die Farben erst kommen wenn man tot am boden liegt mit der crack animation.
    Wenn ich dann auch jemanden mit dem spawnbefehl spawne, wird die farbe auch wieder auf weis gesetzt.


    Jetzt weis ich gar nicht mehr was ich machen soll.
    Ich glaube es hängt auch mit SpawnPlayerEx(pID); zusammen, das steht auch beim spawn befehl, und wenn man sich einloggt usw.

    3 Mal editiert, zuletzt von Tobi_Wayne ()

  • Versuch es einfach mal mit der Funktion SpawnPlayer(playerid); bzw. SpawnPlayer(pID);


    Normalerweise sollte es beim einloggen direkt gesetzt werden.
    Ansonste lasse dir den Code mal debuggen, beim einloggen natürlich. :thumbup:

  • do.de - Domain-Offensive - Domains für alle und zu super Preisen
  • SpawnPlayerEx(pID); -> SpawnPlayer(pID);


    Und debugge dir mal den Code mit den Farben durch.

  • Ach schwachsinn... Sorry..


    Schicke uns bitte mal den Code, wo du switch(Spieler[playerid][pFraktion]) nun stehen hast, mit paar Zeilen oben und drunter.

  • Hier:


    //if(Spieler[playerid][DigiHud] == 0) PlayerTextDrawShow(playerid,HPdraw[playerid]),PlayerTextDrawShow(playerid,ARMOURdraw[playerid]);
    if(Spieler[playerid][pKoffer] == 1) SetPlayerAttachedObject(playerid,9,1210,5,0.310000,0.066999,0.000000,0.000000,-91.900009,0.000000,1.000000,1.000000,1.000000);


    SyncFperson(playerid);


    switch(Spieler[playerid][pFraktion])
    {
    case 0:{SetPlayerSkin(playerid,Spieler[playerid][pSkin]);}//
    case 1:{SetPlayerSkin(playerid,Spieler[playerid][pSkin]);}//SAPD
    case 2:{SetPlayerSkin(playerid,Spieler[playerid][pSkin]);}//FBI
    case 3:{SetPlayerSkin(playerid,Spieler[playerid][pSkin]);}//MEDIC
    case 4:{SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]),SetPlayerColor(playerid,VAGOSFARBE);}//LSV
    case 5:{SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]),SetPlayerColor(playerid,GROVEFARBE);}//GSF
    case 6:{SetPlayerSkin(playerid,Spieler[playerid][pSkin]);}//ARMY
    case 7:{SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]),SetPlayerColor(playerid,BALLASFARBE);}//BALLAS
    case 8:{SetPlayerSkin(playerid,Spieler[playerid][pSkin]),SetPlayerColor(playerid,ALARABIFARBE);}//TERRORS
    case 9:{SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]),SetPlayerColor(playerid,YAKUZAFARBE);}//YAKUZA
    case 10:{SetPlayerSkin(playerid,Spieler[playerid][pSkin]);}//SANEWSAG
    case 11:{SetPlayerSkin(playerid,Spieler[playerid][pSkin]);}//OAMT
    case 12:{SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]),SetPlayerColor(playerid,LCNFARBE);}//LCN
    case 13:{SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]),SetPlayerColor(playerid,BIKERFARBE);}//Sons of Anarchy
    case 14:{SetPlayerSkin(playerid,Spieler[playerid][pSkin]);}//FAHRSCHULE
    case 15:{SetPlayerSkin(playerid,Spieler[playerid][pSkin]);}//SA ELEKTRONIK GmBh
    case 16:{SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]),Spieler[playerid][pDuty] = 1;}//Regierung
    case 17:{SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]);}//Sureño Syndikat
    case 18:{SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]);}//Die Sekte
    }


    if(BombState == true)
    {
    if((isPlayerInFrakt(playerid,1) && Spieler[playerid][pFraktABTInvite] != 0) || isPlayerInFrakt(playerid,2) || isPlayerInFrakt(playerid,6) || isPlayerInFrakt(playerid,8))
    {
    TextDrawShowForPlayer(playerid,Bombdraw);
    }
    }



    Das steht halt alles unter OnPlayerSpawn

  • Dann hast du meine Anleitung nicht richtig befolgt.


    Das schreibst du dann erst einmal wieder so:
    //if(Spieler[playerid][DigiHud] == 0) PlayerTextDrawShow(playerid,HPdraw[playerid]),PlayerTextDrawShow(playerid,ARMOURdraw[playerid]);
    if(Spieler[playerid][pKoffer] == 1) SetPlayerAttachedObject(playerid,9,1210,5,0.310000,0.066999,0.000000,0.000000,-91.900009,0.000000,1.000000,1.000000,1.000000);
    SyncFperson(playerid);
    if(BombState == true)
    {
    if((isPlayerInFrakt(playerid,1) && Spieler[playerid][pFraktABTInvite] != 0) || isPlayerInFrakt(playerid,2) || isPlayerInFrakt(playerid,6) || isPlayerInFrakt(playerid,8))
    {
    TextDrawShowForPlayer(playerid,Bombdraw);
    }
    }
    Und das Callback zum Laden schreibst du so:
    public LoadAccount(playerid,pass[],passwortstate)
    {
    new query[356],result[25],rows,fields;
    if(mysql_errno(MySqlConnection) != 0)
    {
    getdate(tag,monat,jahr);
    gettime(stunde,minute,sekunde);
    ForEachPlayer(i)
    {
    if(IsPlayerConnected(i) && !IsPlayerNPC(i) && GetPVarInt(i,"Eingeloggt") == 1)
    {
    SaveAccount(i);
    }
    }
    Log("Restartsqllog","Admin: System hat den Server restartet (Dead MySQL Connection)!");
    OnGameModeSave();
    GameModeExit();
    return 1;
    }
    cache_get_data(rows,fields,MySqlConnection);
    if(rows > 0)
    {
    if(passwortstate == 1)
    {
    cache_get_field_content(0,"Passwort",result);
    new tmpp[25];
    strmid(tmpp,MD5_Hash(pass),0,24,25);
    if(!strcmp(tmpp,result,true))
    {
    format(query,sizeof query,"SELECT * FROM "#DATENBANKTAG"_account_main WHERE `Name`='%s'",SpielerName(playerid);
    mysql_function_query(MySqlConnection,query,true,"LoadAccount","isi",playerid," ",0);
    return 1;
    }
    format(query,sizeof query,"{C9C9C9}Willkommen zurück "#SERVERFARBE"%s{C9C9C9}!\nDein Account ist registriert.\nBitte Logge dich mit deinem entsprechendem Passwort ein.\n\n"#SERVERFARBE"** "#SERVERNAME" **",SpielerName(playerid);
    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Login",query,"Login","Abbrechen");
    return 1;
    }
    else if(passwortstate == 0)
    {
    cache_get_field_content(0,"Tutorial",result);
    Spieler[playerid][pViewTutorial] = strval(result);
    cache_get_field_content(0,"Admin",result);
    Spieler[playerid][pAdmin] = strval(result);
    cache_get_field_content(0,"Verwarnungen",result);
    Spieler[playerid][pWarns] = strval(result);
    cache_get_field_content(0,"FLeaderRechte",result);
    Spieler[playerid][pLeader] = strval(result);
    cache_get_field_content(0,"Fraktion",result);
    Spieler[playerid][pFraktion] = strval(result);
    cache_get_field_content(0,"FraktionsRang",result);
    Spieler[playerid][pFraktRang] = strval(result);
    cache_get_field_content(0,"FraktionsURang",result);
    Spieler[playerid][pFraktURang] = strval(result);
    cache_get_field_content(0,"FraktionsSperre",result);
    Spieler[playerid][pFraktionSperre] = strval(result);
    cache_get_field_content(0,"FraktionsGehalt",result);
    Spieler[playerid][pFraktionsGehalt] = strval(result);
    cache_get_field_content(0,"Job",result);
    Spieler[playerid][pJob] = strval(result);
    cache_get_field_content(0,"JobWarns",result);
    Spieler[playerid][JobWarns] = strval(result);
    cache_get_field_content(0,"JobSperre",result);
    Spieler[playerid][pJobSperre] = strval(result);
    cache_get_field_content(0,"ArbeitslosenGeld",result);
    Spieler[playerid][pWorkLess] = strval(result);
    cache_get_field_content(0,"Geschlecht",result);
    Spieler[playerid][pSex] = strval(result);
    cache_get_field_content(0,"SpielerAlter",result);
    Spieler[playerid][pYearsOld] = strval(result);
    cache_get_field_content(0,"Level",result);
    SetPlayerLevel(playerid,strval(result));
    cache_get_field_content(0,"Geld",result);
    ACMoney(playerid,strval(result));
    cache_get_field_content(0,"GWD",result);
    Spieler[playerid][pGrundwehrdienst] = strval(result);
    cache_get_field_content(0,"Zivinote",result);
    Spieler[playerid][pZiviNote] = strval(result);
    cache_get_field_content(0,"FAbteilung",result);
    Spieler[playerid][pFraktABTInvite] = strval(result);
    cache_get_field_content(0,"Bankguthaben",result);
    Spieler[playerid][pBank] = strval(result);
    cache_get_field_content(0,"BankPin",result);
    Spieler[playerid][pBankPin] = strval(result);
    cache_get_field_content(0,"WantedSterne",result);
    SetPlayerWantedLevel(playerid,strval(result));
    cache_get_field_content(0,"WantedPunkte",result);
    Spieler[playerid][pWantedPoints] = strval(result);
    cache_get_field_content(0,"Suspects",result);
    Spieler[playerid][pSuspectPoints] = strval(result);
    cache_get_field_content(0,"Wanted_Grund1",result);
    strcat(pWantedReason1[playerid],result);
    cache_get_field_content(0,"Wanted_Grund2",result);
    strcat(pWantedReason2[playerid],result);
    cache_get_field_content(0,"Wanted_Grund3",result);
    strcat(pWantedReason3[playerid],result);
    cache_get_field_content(0,"Wanted_Grund4",result);
    strcat(pWantedReason4[playerid],result);
    cache_get_field_content(0,"Wanted_Grund5",result);
    strcat(pWantedReason5[playerid],result);
    cache_get_field_content(0,"Crimes",result);
    Spieler[playerid][pLastSuspects] = strval(result);
    cache_get_field_content(0,"STVOcrimes",result);
    Spieler[playerid][pSTVOpoints] = strval(result);
    cache_get_field_content(0,"KampfStyle",result);
    SetPlayerFightingStyle(playerid,strval(result));
    cache_get_field_content(0,"Handy",result);
    Spieler[playerid][pHandy] = strval(result);
    cache_get_field_content(0,"Handycoins",result);
    Spieler[playerid][pHandyCoins] = strval(result);
    cache_get_field_content(0,"HandyStatus",result);
    Spieler[playerid][pHandystate] = strval(result);
    cache_get_field_content(0,"HandyAkku",result);
    Spieler[playerid][pHandyakku] = floatstr(result);
    cache_get_field_content(0,"HandyNummer",result);
    Spieler[playerid][pPhonenumber] = strval(result);
    cache_get_field_content(0,"Handyflat",result);
    Spieler[playerid][pHandyFlat] = strval(result);
    cache_get_field_content(0,"Handyflatbuyinbiz",result);
    Spieler[playerid][pHandyBuyByBiz] = strval(result);
    cache_get_field_content(0,"Letzte_X",result);
    Spieler[playerid][LastInGamePos_x] = floatstr(result);
    cache_get_field_content(0,"Letzte_Y",result);
    Spieler[playerid][LastInGamePos_y] = floatstr(result);
    cache_get_field_content(0,"Letzte_Z",result);
    Spieler[playerid][LastInGamePos_z] = floatstr(result);
    cache_get_field_content(0,"Letzte_Interior",result);
    Spieler[playerid][LastInGamePos_int] = strval(result);
    cache_get_field_content(0,"Letzte_VirtualWorld",result);
    Spieler[playerid][LastInGamePos_world] = strval(result);
    cache_get_field_content(0,"pSelectHome",result);
    Spieler[playerid][pSelectHome] = strval(result);
    cache_get_field_content(0,"HausMieter",result);
    Spieler[playerid][pRentHome] = strval(result);
    cache_get_field_content(0,"Spawn",result);
    Spieler[playerid][pSpawn] = strval(result);
    cache_get_field_content(0,"Hotel",result);
    Spieler[playerid][pHotel] = strval(result);
    cache_get_field_content(0,"Tod",result);
    Spieler[playerid][pDeath] = strval(result);
    cache_get_field_content(0,"Tot_X",result);
    Spieler[playerid][tot_x] = floatstr(result);
    cache_get_field_content(0,"Tot_Y",result);
    Spieler[playerid][tot_y] = floatstr(result);
    cache_get_field_content(0,"Tot_Z",result);
    Spieler[playerid][tot_z] = floatstr(result);
    cache_get_field_content(0,"Tot_Interior",result);
    Spieler[playerid][tot_int] = strval(result);
    cache_get_field_content(0,"Tot_VirtualWorld",result);
    Spieler[playerid][tot_world] = strval(result);
    cache_get_field_content(0,"TotZeit",result);
    Spieler[playerid][pDeathTime] = strval(result);
    cache_get_field_content(0,"Friedhof",result);
    Spieler[playerid][pFriedhof] = strval(result);
    cache_get_field_content(0,"FriedhofZeit",result);
    Spieler[playerid][pFriedhofTime] = strval(result);
    cache_get_field_content(0,"ImKnast",result);
    Spieler[playerid][pJailed] = strval(result);
    cache_get_field_content(0,"KnastZeit",result);
    Spieler[playerid][pJailTime] = strval(result);
    cache_get_field_content(0,"KnastKaution",result);
    Spieler[playerid][pKaution] = strval(result);
    cache_get_field_content(0,"Muted",result);
    Spieler[playerid][pMuted] = strval(result);
    cache_get_field_content(0,"MuteZeit",result);
    Spieler[playerid][pMuteTime] = strval(result);
    cache_get_field_content(0,"ImPrison",result);
    Spieler[playerid][pInPrison] = strval(result);
    cache_get_field_content(0,"PrisonCheckPointsAbgelaufen",result);
    Spieler[playerid][pPrisonCPsgelaufen] = strval(result);
    cache_get_field_content(0,"PrisonCheckPointsGegeben",result);
    Spieler[playerid][pPrisonCPsgegeben] = strval(result);
    cache_get_field_content(0,"Morde",result);
    Spieler[playerid][pMorde] = strval(result);
    cache_get_field_content(0,"Tode",result);
    Spieler[playerid][pTode] = strval(result);
    cache_get_field_content(0,"SkinID",result);
    Spieler[playerid][pSkin] = strval(result);
    cache_get_field_content(0,"FraktionSkinID",result);
    Spieler[playerid][pFraktSkin] = strval(result);
    cache_get_field_content(0,"PaintBallKills",result);
    Spieler[playerid][pPBKills] = strval(result);
    cache_get_field_content(0,"PaintBallTode",result);
    Spieler[playerid][pPBDeaths] = strval(result);
    cache_get_field_content(0,"PaintBallRang",result);
    Spieler[playerid][pPBRang] = strval(result);
    cache_get_field_content(0,"PaintBallBesuche",result);
    Spieler[playerid][pPBVisits] = strval(result);
    cache_get_field_content(0,"AngenommeneReports",result);
    Spieler[playerid][Reports] = strval(result);
    cache_get_field_content(0,"KopfGeld",result);
    Spieler[playerid][pHeadMoney] = strval(result);
    cache_get_field_content(0,"pWantedDeaths",result);
    Spieler[playerid][pWantedDeaths] = strval(result);
    cache_get_field_content(0,"pBuyTickets",result);
    Spieler[playerid][pBuyTickets] = strval(result);
    cache_get_field_content(0,"pJailedCount",result);
    Spieler[playerid][pJailedCount] = strval(result);
    cache_get_field_content(0,"Bankkonto",result);
    Spieler[playerid][pBankkonto] = strval(result);
    cache_get_field_content(0,"pArmyPlaneOrder",result);
    Spieler[playerid][pArmyPlaneOrder] = strval(result);
    cache_get_field_content(0,"pArmyHeliOrder",result);
    Spieler[playerid][pArmyHeliOrder] = strval(result);
    cache_get_field_content(0,"pArmyWaffenOrder",result);
    Spieler[playerid][pArmyWaffenOrder] = strval(result);
    cache_get_field_content(0,"LevelUPKosten",result);
    Spieler[playerid][pLevelKosten] = strval(result);
    cache_get_field_content(0,"RespectForLevelUp",result);
    Spieler[playerid][pRespektToLevelUp] = strval(result);
    cache_get_field_content(0,"RespectFromPayday",result);
    Spieler[playerid][pRespektFromPayday] = strval(result);
    cache_get_field_content(0,"TimeAfterRegister",result);
    Spieler[playerid][pTimeAfterRegister] = strval(result);
    cache_get_field_content(0,"Time4Payday",result);
    Spieler[playerid][pMinutesAfterPayday] = strval(result);
    cache_get_field_content(0,"TimeoutCrashExeorKick",result);
    Spieler[playerid][pAntiOfflineFlucht] = strval(result);
    cache_get_field_content(0,"RpChat",result);
    Spieler[playerid][pAntiOfflineFlucht] = strval(result);
    cache_get_field_content(0,"HabGeworben",result);
    Spieler[playerid][HatGeworben] = strval(result);
    cache_get_field_content(0,"pPremium",result);
    Spieler[playerid][pPremium] = strval(result);
    cache_get_field_content(0,"GeworbenerSpieler",result);
    strcat(Spieler[playerid][GeworbenPlaya],result);
    cache_get_field_content(0,"pScheinSperre",result);
    Spieler[playerid][pScheinSperre] = strval(result);
    cache_get_field_content(0,"DigiHud",result);
    Spieler[playerid][DigiHud] = strval(result);
    cache_get_field_content(0,"pDHitsound",result);
    Spieler[playerid][pDHitsound] = strval(result);
    cache_get_field_content(0,"Bonus",result);
    Spieler[playerid][pStartbonus] = strval(result);
    cache_get_field_content(0,"Gutschein",result);
    Spieler[playerid][pGutschein] = strval(result);
    cache_get_field_content(0,"pCoins",result);
    Spieler[playerid][pCoins] = strval(result);
    cache_get_field_content(0,"pFirmaLeader",result);
    Spieler[playerid][pFirmaLeader] = strval(result);
    cache_get_field_content(0,"pFirmaMember",result);
    Spieler[playerid][pFirmaMember] = strval(result);
    cache_get_field_content(0,"pOrgLeader",result);
    Spieler[playerid][pOrgLeader] = strval(result);
    cache_get_field_content(0,"pOrgMember",result);
    Spieler[playerid][pOrgMember] = strval(result);
    cache_get_field_content(0,"pParteiLeader",result);
    Spieler[playerid][pParteiLeader] = strval(result);
    cache_get_field_content(0,"pParteiMember",result);
    Spieler[playerid][pParteiMember] = strval(result);
    cache_get_field_content(0,"pLohn",result);
    Spieler[playerid][pLohn] = strval(result);
    cache_get_field_content(0,"WaitPerso",result);
    Spieler[playerid][WaitPerso] = strval(result);
    cache_get_field_content(0,"pMarried",result);
    strcat(Spieler[playerid][pMarried],result);
    cache_get_field_content(0,"pBuyClothes",result);
    Spieler[playerid][pBuyClothes] = strval(result);
    cache_get_field_content(0,"pTsIdent",result);
    strcat(Spieler[playerid][pTsIdent],result);
    cache_get_field_content(0,"pIll",result);
    Spieler[playerid][pIll] = strval(result);
    cache_get_field_content(0,"pConterminatedTime",result);
    Spieler[playerid][pConterminatedTime] = strval(result);
    cache_get_field_content(0,"pBitchSkill",result);
    Spieler[playerid][pBitchSkill] = strval(result);
    cache_get_field_content(0,"pBitchFuckCount",result);
    Spieler[playerid][pBitchFuckCount] = strval(result);
    cache_get_field_content(0,"pMedicHealplayerSkill",result);
    Spieler[playerid][pMedicHealplayerSkill] = strval(result);
    cache_get_field_content(0,"pMedicHealCount",result);
    Spieler[playerid][pMedicHealCount] = strval(result);
    switch(Spieler[playerid][pFraktion])
    {
    case 0:SetPlayerSkin(playerid,Spieler[playerid][pSkin]);//
    case 1:SetPlayerSkin(playerid,Spieler[playerid][pSkin]);// SAPD
    case 2:SetPlayerSkin(playerid,Spieler[playerid][pSkin]);// FBI
    case 3:SetPlayerSkin(playerid,Spieler[playerid][pSkin]);// MEDIC
    case 4:SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]),SetPlayerColor(playerid,VAGOSFARBE);// LSV
    case 5:SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]),SetPlayerColor(playerid,GROVEFARBE);// GSF
    case 6:SetPlayerSkin(playerid,Spieler[playerid][pSkin]);// ARMY
    case 7:SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]),SetPlayerColor(playerid,BALLASFARBE);// BALLAS
    case 8:SetPlayerSkin(playerid,Spieler[playerid][pSkin]),SetPlayerColor(playerid,ALARABIFARBE);// TERRORS
    case 9:SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]),SetPlayerColor(playerid,YAKUZAFARBE);// YAKUZA
    case 10:SetPlayerSkin(playerid,Spieler[playerid][pSkin]);// SANNEWSAG
    case 11:SetPlayerSkin(playerid,Spieler[playerid][pSkin]);// OAMT
    case 12:SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]),SetPlayerColor(playerid,LCNFARBE);// LCN
    case 13:SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]),SetPlayerColor(playerid,BIKERFARBE);// Sons of Anarchy
    case 14:SetPlayerSkin(playerid,Spieler[playerid][pSkin]);// FAHRSCHULE
    case 15:SetPlayerSkin(playerid,Spieler[playerid][pSkin]);// SA ELEKTRONIK GmbH
    case 16:SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]),Spieler[playerid][pDuty] = 1;// Regierung
    case 17:SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]);// Sureño Syndikat
    case 18:SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]);// Die Sekte
    }
    new stringlogin[256];
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_weapons WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountWeapons","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_fish WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountFish","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_koffer WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountKoffer","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_blacklist WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountBlacklists","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_inventar WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountInventar","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_licenses WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountLicenses","i",playerid);
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_banksafe WHERE Name = '%s'",SpielerName(playerid));
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountBankSafe","i",playerid);
    for(new slot;slot<MAX_PLAYER_VEHS;slot++)
    {
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_vehicle WHERE name = '%s' AND slot = '%d'",SpielerName(playerid),slot);
    mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountVehicles","ii",playerid,slot);
    }
    mysql_SetInt(""#DATENBANKTAG"_account_main","Online",1,"Name",Spieler[playerid][pName]);
    AddToAutoLogin(playerid);
    StopPlayerPlaySound(playerid);
    PlayerPlaySound(playerid,1188,0.0,0.0,10.0);
    if(isPlayerAnAdmin(playerid,1))
    {
    format(stringlogin,sizeof stringlogin,"{FF0000}<< {FFFFF}%s %s #{FF0000} >>",Adminrang(playerid),SpielerName(playerid));
    SendAdminMessage(WEISS,stringlogin);
    switch(Spieler[playerid][pAdmin])
    {
    case 1:TextDrawShowForPlayer(playerid,Reportdraw[0]),TextDrawShowForPlayer(playerid,Reportdraw[1]);
    case 2,3,4:TextDrawShowForPlayer(playerid,Reportdraw[0]),TextDrawShowForPlayer(playerid,Reportdraw[1]),TextDrawShowForPlayer(playerid,Reportdraw[2]);
    case 5,6,7,8,9:for(new i;i<sizeof Reportdraw;i++)TextDrawShowForPlayer(playerid,Reportdraw[i]);
    }
    format(stringlogin,sizeof(stringlogin),"Art: Login Admin: %s (Adminlevel: %i) * IP: %s - ID/PlayerID : %i",SpielerName(playerid),Spieler[playerid][pAdmin],SpielerIP(playerid),playerid);
    Log("Admin-Loginsqllog",stringlogin);
    }
    if(Spieler[playerid][pKoffer] == 1) SetPlayerAttachedObject(playerid,9,1210,5,0.310000,0.066999,0.000000,0.000000,-91.900009,0.000000,1.000000,1.000000,1.000000);
    if(Spieler[playerid][pHandy] != 0)
    {
    if(Spieler[playerid][pHandystate] == 1 && Spieler[playerid][pHandyakku] > 0.0)
    {
    PlayerTextDrawShow(playerid,HandyInfodraw[playerid]);
    HandyAkku(playerid);
    AkkuTimer[playerid] = SetTimerEx("HandyAkku",120000,1,"i",playerid);
    }
    }
    if(Spieler[playerid][pFraktion] != 0)
    {
    format(stringlogin,sizeof(stringlogin),"{00FFFF}<< Fraktionsmitglied{FF0000} %s {00FFFF}hat sich eingeloggt >>",SpielerName(playerid));
    SendFraktionsMessage(Spieler[playerid][pFraktion],HELLBLAU,stringlogin);
    }
    format(stringlogin,sizeof(stringlogin),"Name:%s | IP:%s",SpielerName(playerid),SpielerIP(playerid));
    Log("Player-Loginsql",stringlogin);
    if(Spieler[playerid][pViewTutorial] == 0)return ImTutorial[playerid] = 1;
    TogglePlayerControllable(playerid,1);
    TogglePlayerSpectating(playerid,0);
    SpawnPlayerEx(playerid);
    PlayerSpawned[playerid] = 1;
    TextDrawHideForPlayer(playerid,Introdraw[0]);
    TextDrawHideForPlayer(playerid,Introdraw[1]);
    format(stringlogin,sizeof(stringlogin),"{A91400}SERVER{FFFFFF}: Willkommen %s",SpielerName(playerid));
    SendClientMessage(playerid,WEISS,stringlogin);
    switch(monat)
    {
    case 1:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Januar");
    case 2:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Februar");
    case 3:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist März");
    case 4:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist April");
    case 5:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Mai");
    case 6:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Juni");
    case 7:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Juli");
    case 8:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist August");
    case 9:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist September");
    case 10:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Oktober");
    case 11:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist November");
    case 12:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Dezember");
    }
    if(tag == 31 && monat == 3) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Die Sommerzeit hat begonnen");
    if(tag == 27 && monat == 10) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Die Winterzeit hat begonnen");
    if(tag == 31 && monat == 10) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Halloween");
    if(tag == 24 && monat == 12) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Frohe Weihnachten");
    if(tag == 31 && monat == 12) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Das neue Jahr steht vor der Tür");
    if(tag == 1 && monat == 1) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Frohes Neues Jahr");
    }
    TextDrawShowForPlayer(playerid,Version);
    TextDrawShowForPlayer(playerid,InfoSign);
    format(stringlogin,sizeof(stringlogin),"~w~Willkommen ~y~%s",SpielerName(playerid));
    PlayerTextDrawSetString(playerid,INFOdraw[playerid][2],stringlogin);
    StopAudioStreamForPlayer(playerid);
    PlayAudioStreamForPlayer(playerid,ServerSounds[13],0.0,0.0,0.0);
    PlayerTextDrawShow(playerid,INFOdraw[playerid][2]);
    SetTimerEx("HideInfoBox",4000,0,"i",playerid);
    MakeRace[playerid] = -1;
    SetPlayerWaffenSkill(playerid);
    if(!isPlayerInFrakt(playerid,0))
    {
    format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_fraktion_motd WHERE fID='%d'",Spieler[playerid][pFraktion]);
    mysql_function_query(MySqlConnection,stringlogin,true,"OnQueryFinish","siii",stringlogin,_SQL_FRAKTIONSMOTD_SELECT,playerid,MySqlConnection);
    }
    else ShowPlayerDialog(playerid,DIALOG_4ALL_SONSTIGES,DIALOG_STYLE_MSGBOX,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Info","Herzlich Willkommen auf "#SERVERNAME",\nbitte denke immer daran dich an die Regeln zu halten.\nBugs/Fehler im Spiel bitte im Forum melden.\n\nViel Spaß beim spielen!","Verlassen","");
    if(GetPlayerLevel(playerid) <= ENABLE_KILLORPAY_BYLEVEL)
    {
    format(stringlogin,sizeof(stringlogin),"ACHTUNG: Solltest du als Level %i´er einen Spieler töten,",GetPlayerLevel(playerid));
    SendClientMessage(playerid,LEUCHTENDESROT,stringlogin);
    SendClientMessage(playerid,LEUCHTENDESROT,"wirst du Automatisch vom System gebannt!");
    }
    if(Spieler[playerid][HatGeworben] == 0)
    {
    if(GetPlayerLevel(playerid) <= 3)
    {
    SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Niemand hat dich geworben ?");
    SendClientMessage(playerid,WEISS,"{FFFFFF} Falls doch Benutze: /geworben.");
    }
    else Spieler[playerid][HatGeworben] = 1;
    }
    new zeitdauer = gettime()+(60*60*24*7*2);//2 wochen
    mysql_SetInt(""#DATENBANKTAG"_account_main","PropertyClearTime",zeitdauer,"Name",SpielerName(playerid));
    SetPVarInt(playerid,"Eingeloggt",1);
    OnlinePlayer(playerid,true);
    printf("LOAD: %s Account hat geladen!",SpielerName(playerid));
    }
    return 1;
    }
    Sorry, hat etwas länger gedauert, war ja auch viel Code ^^

  • Naja, habe das nun so eingefügt, aber dann kommen folgende errors:



    error 001: expected token: ",", but found ";"
    error 001: expected token: ",", but found ";"
    error 017: undefined symbol "stringlogin"
    error 017: undefined symbol "stringlogin"
    error 029: invalid expression, assumed zero
    fatal error 107: too many error messages on one line

    Einmal editiert, zuletzt von Tobi_Wayne ()

  • Die Zeilen:



    format(query,sizeof query,"SELECT * FROM "#DATENBANKTAG"_account_main WHERE `Name`='%s'",SpielerName(playerid);
    format(query,sizeof query,"{C9C9C9}Willkommen zurück "#SERVERFARBE"%s{C9C9C9}!\nDein Account ist registriert.\nBitte Logge dich mit deinem entsprechendem Passwort ein.\n\n"#SERVERFARBE"** "#SERVERNAME" **",SpielerName(playerid);
    format(stringlogin,sizeof(stringlogin),"~w~Willkommen ~y~%s",SpielerName(playerid));



    In der letzten Zeile sind 4 Errors