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