forward OnPlayerLoad(playerid, step);
public OnPlayerLoad(playerid, step) {
new rows, fields, lResult[128], lStart = GetTickCount(), geld, query[2048];
cache_get_data(rows, fields);
switch(step) {
case 0:
{//Accountdaten: Allgemein
if(rows != 0) {
cache_get_field_content(0,"EventUnix", lResult), PlayerInfo[playerid][pEventUnix]=strval(lResult);
cache_get_field_content(0,"EventPicked", lResult), PlayerInfo[playerid][pEventPicked]=strval(lResult);
cache_get_field_content(0,"Level", lResult), PlayerInfo[playerid][pLevel] = strval(lResult);
cache_get_field_content(0,"Geld", lResult), geld = strval(lResult);
cache_get_field_content(0,"Admin", lResult), PlayerInfo[playerid][pAdmin] = strval(lResult);
cache_get_field_content(0,"Morde", lResult), PlayerInfo[playerid][pMorde] = strval(lResult);
cache_get_field_content(0,"Tode", lResult), PlayerInfo[playerid][pTode] = strval(lResult);
cache_get_field_content(0,"Heal", lResult), PlayerInfo[playerid][pHeal] = floatstr(lResult);
cache_get_field_content(0,"Armor", lResult), PlayerInfo[playerid][pArmor] = floatstr(lResult);
cache_get_field_content(0,"Upgrade", lResult), PlayerInfo[playerid][pUpgrade] = strval(lResult);
cache_get_field_content(0,"Geschlecht", lResult), PlayerInfo[playerid][pGeschlecht] = strval(lResult);
cache_get_field_content(0,"Muted", lResult), PlayerInfo[playerid][pMuted] = strval(lResult);
cache_get_field_content(0,"MuteTime", lResult), PlayerInfo[playerid][pMuteTime] = strval(lResult);
cache_get_field_content(0,"Respekt", lResult), PlayerInfo[playerid][pRespekt] = strval(lResult);
cache_get_field_content(0,"Verbrechen", lResult), PlayerInfo[playerid][pVerbrechen] = strval(lResult);
cache_get_field_content(0,"WantedLevel", lResult), PlayerInfo[playerid][pWantedLevel] = strval(lResult);
cache_get_field_content(0,"Verlassen", lResult), strmid(PlayerInfo[playerid][pVerlassen], lResult, 0, strlen(lResult), 128);
cache_get_field_content(0,"Knast", lResult), PlayerInfo[playerid][pKnast] = strval(lResult);
cache_get_field_content(0,"KnastZeit", lResult), PlayerInfo[playerid][pKnastZeit] = strval(lResult);
cache_get_field_content(0,"KnastAFKZeit", lResult), PlayerInfo[playerid][pKnastAFKZeit] = strval(lResult);
cache_get_field_content(0,"Telefonbuch", lResult), PlayerInfo[playerid][pTelefonbuch] = strval(lResult);
cache_get_field_content(0,"Nummer", lResult), PlayerInfo[playerid][pNummer] = strval(lResult);
cache_get_field_content(0,"Telefon", lResult), PlayerInfo[playerid][pTelefon] = strval(lResult);
cache_get_field_content(0,"Job", lResult), PlayerInfo[playerid][pJob] = strval(lResult);
cache_get_field_content(0,"GehaltCheck", lResult), PlayerInfo[playerid][pGehaltCheck] = strval(lResult);
cache_get_field_content(0,"JobDone", lResult), PlayerInfo[playerid][pJobDone] = strval(lResult);
cache_get_field_content(0,"Kopfgeld", lResult), PlayerInfo[playerid][pKopfgeld] = strval(lResult);
cache_get_field_content(0,"TodStatus", lResult), PlayerInfo[playerid][pTodStatus] = strval(lResult);
cache_get_field_content(0,"TodZeit", lResult), PlayerInfo[playerid][pTodZeit] = strval(lResult);
cache_get_field_content(0,"Rang", lResult), PlayerInfo[playerid][pRang] = strval(lResult);
cache_get_field_content(0,"Member", lResult), PlayerInfo[playerid][pMember] = strval(lResult);
cache_get_field_content(0,"Leader", lResult), PlayerInfo[playerid][pLeader] = strval(lResult);
cache_get_field_content(0,"PersoZeit", lResult), PlayerInfo[playerid][pPersoZeit] = strval(lResult);
cache_get_field_content(0,"Dienst", lResult), PlayerInfo[playerid][pDienst] = strval(lResult);
cache_get_field_content(0,"FSkin", lResult), PlayerInfo[playerid][pFSkin] = strval(lResult);
cache_get_field_content(0,"Skin", lResult), PlayerInfo[playerid][pSkin] = strval(lResult);
cache_get_field_content(0,"PayDay", lResult), PlayerInfo[playerid][pPayDay] = strval(lResult);
cache_get_field_content(0,"GesamtMinutes", lResult), PlayerInfo[playerid][pGesamtMinutes] = strval(lResult);
cache_get_field_content(0,"GesamtAFK", lResult), PlayerInfo[playerid][pGesamtAFK] = strval(lResult);
cache_get_field_content(0,"Uhr", lResult), PlayerInfo[playerid][pUhr] = strval(lResult);
cache_get_field_content(0,"Kanister", lResult), PlayerInfo[playerid][pKanister] = strval(lResult);
cache_get_field_content(0,"KanisterInhalt", lResult), PlayerInfo[playerid][pKanisterInhalt] = strval(lResult);
cache_get_field_content(0,"KanisterArt", lResult), PlayerInfo[playerid][pKanisterArt] = strval(lResult);
cache_get_field_content(0,"SEKLevel", lResult), PlayerInfo[playerid][pSEKLevel] = strval(lResult);
cache_get_field_content(0,"KSKLevel", lResult), PlayerInfo[playerid][pKSKLevel] = strval(lResult);
cache_get_field_content(0,"KSKDuty", lResult), PlayerInfo[playerid][pKSKDuty] = strval(lResult);
cache_get_field_content(0,"Zigaretten", lResult), PlayerInfo[playerid][pZigaretten] = strval(lResult);
cache_get_field_content(0,"Stadtkarte", lResult), PlayerInfo[playerid][pStadtkarte] = strval(lResult);
cache_get_field_content(0,"IPAdresse", lResult), strmid(PlayerInfo[playerid][pIPAdresse], lResult, 0, strlen(lResult), 128);
cache_get_field_content(0,"RegDate", lResult), strmid(PlayerInfo[playerid][pRegDatum], lResult, 0, strlen(lResult), 128);
cache_get_field_content(0,"SozialHilfe", lResult), PlayerInfo[playerid][pSozialHilfe] = strval(lResult);
cache_get_field_content(0,"AFKZeit", lResult), PlayerInfo[playerid][pAFKZeit] = strval(lResult);
cache_get_field_content(0,"Fahrerpunkte", lResult), PlayerInfo[playerid][pFahrerpunkte] = strval(lResult);
cache_get_field_content(0,"TogPhone", lResult), PlayerInfo[playerid][pTogPhone] = strval(lResult);
cache_get_field_content(0,"GWNote", lResult), PlayerInfo[playerid][pGWNote] = strval(lResult);
cache_get_field_content(0,"ZiviNote", lResult), PlayerInfo[playerid][pZiviNote] = strval(lResult);
cache_get_field_content(0,"Krank", lResult), PlayerInfo[playerid][pKrank] = strval(lResult);
cache_get_field_content(0,"ConnectSeconds", lResult), PlayerInfo[playerid][pConnectSeconds] = strval(lResult);
cache_get_field_content(0,"Warns", lResult), PlayerInfo[playerid][pWarns] = strval(lResult);
cache_get_field_content(0,"TogMySQL", lResult), PlayerInfo[playerid][pTogMySQL] = strval(lResult);
cache_get_field_content(0,"Registriert", lResult), PlayerInfo[playerid][pRegistriert] = strval(lResult);
cache_get_field_content(0,"DropTime", lResult), PlayerInfo[playerid][pDropTime] = strval(lResult);
cache_get_field_content(0,"RefillKanister", lResult), PlayerInfo[playerid][pRefillKanister] = strval(lResult);
cache_get_field_content(0,"RepairKits", lResult), PlayerInfo[playerid][pRepairKits] = strval(lResult);
cache_get_field_content(0,"KnastAufenthalte", lResult), PlayerInfo[playerid][pKnastAufenthalte] = strval(lResult);
cache_get_field_content(0,"ReloadBats", lResult), PlayerInfo[playerid][pReloadBats] = strval(lResult);
cache_get_field_content(0,"LastSeen", lResult), strmid(PlayerInfo[playerid][pLastSeen], lResult, 0, strlen(lResult), 128);
cache_get_field_content(0,"KripoLevel", lResult), PlayerInfo[playerid][pKripoLevel] = strval(lResult);
cache_get_field_content(0,"Vertragszeit", lResult), PlayerInfo[playerid][pVertragszeit] = strval(lResult);
cache_get_field_content(0,"EigenesRadio1", lResult), strmid(PlayerInfo[playerid][pEigenesRadio1], lResult, 0, strlen(lResult), 128);
cache_get_field_content(0,"EigenesRadio2", lResult), strmid(PlayerInfo[playerid][pEigenesRadio2], lResult, 0, strlen(lResult), 128);
cache_get_field_content(0,"EigenesRadio1Aktiviert", lResult), PlayerInfo[playerid][pEigenesRadio1Aktiviert] = strval(lResult);
cache_get_field_content(0,"EigenesRadio2Aktiviert", lResult), PlayerInfo[playerid][pEigenesRadio2Aktiviert] = strval(lResult);
cache_get_field_content(0,"Kopfhoehrer", lResult), PlayerInfo[playerid][pKopfhoehrer] = strval(lResult);
cache_get_field_content(0,"FlugID", lResult), strmid(PlayerInfo[playerid][pFlugID], lResult, 0, strlen(lResult), 128);
cache_get_field_content(0,"Premium", lResult), PlayerInfo[playerid][pPremium] = strval(lResult);
cache_get_field_content(0,"Donator", lResult), PlayerInfo[playerid][pDonator] = strval(lResult);
cache_get_field_content(0,"Rucksack", lResult), PlayerInfo[playerid][pRucksack] = strval(lResult);
cache_get_field_content(0,"Flaschen", lResult), PlayerInfo[playerid][pFlaschen] = strval(lResult);
cache_get_field_content(0,"VertragPartner", lResult), PlayerInfo[playerid][pVertragPartner] = strval(lResult);
cache_get_field_content(0,"VertragArt", lResult), PlayerInfo[playerid][pVertragArt] = strval(lResult);
cache_get_field_content(0,"Guthaben", lResult), PlayerInfo[playerid][pGuthaben] = strval(lResult);
cache_get_field_content(0,"AmmunationZeit", lResult), PlayerInfo[playerid][pAmmunationZeit] = strval(lResult);
cache_get_field_content(0,"FahrschuleZeit", lResult), PlayerInfo[playerid][pFahrschuleZeit] = strval(lResult);
cache_get_field_content(0,"FahrschuleAngemeldet", lResult), PlayerInfo[playerid][pFahrschuleAngemeldet] = strval(lResult);
cache_get_field_content(0,"TheorieBestanden", lResult), PlayerInfo[playerid][pTheorieBestanden] = strval(lResult);
cache_get_field_content(0,"PraxisBestanden", lResult), PlayerInfo[playerid][pPraxisBestanden] = strval(lResult);
cache_get_field_content(0,"TheorieStunden", lResult), PlayerInfo[playerid][pTheorieStunden] = strval(lResult);
cache_get_field_content(0,"ScheinSperre", lResult), PlayerInfo[playerid][pScheinSperre] = strval(lResult);
cache_get_field_content(0,"FrakSperreEnde", lResult), PlayerInfo[playerid][pFrakSperreEnde] = strval(lResult);
cache_get_field_content(0,"Werber", lResult), PlayerInfo[playerid][pWerber] = strval(lResult);
cache_get_field_content(0,"wSpielzeit", lResult), PlayerInfo[playerid][pWSpielzeit] = strval(lResult);
cache_get_field_content(0,"C4", lResult), PlayerInfo[playerid][pC4Inv] = strval(lResult);
cache_get_field_content(0,"Bombe", lResult), PlayerInfo[playerid][pBombe] = strval(lResult);
cache_get_field_content(0,"RucksackBombe", lResult), PlayerInfo[playerid][pRucksackBombe] = strval(lResult);
cache_get_field_content(0,"SprengsatzSmall", lResult), PlayerInfo[playerid][pSprengsatzSmall] = strval(lResult);
cache_get_field_content(0,"Medikamente", lResult), PlayerInfo[playerid][pMedikamente] = strval(lResult);
cache_get_field_content(0,"SaveMats", lResult), PlayerInfo[playerid][pSaveMats] = strval(lResult);
cache_get_field_content(0,"SaveEisen", lResult), PlayerInfo[playerid][pSaveEisen] = strval(lResult);
cache_get_field_content(0,"AktivTime", lResult), PlayerInfo[playerid][pAktivTime] = strval(lResult);
cache_get_field_content(0,"RespektMultiplikator", lResult), PlayerInfo[playerid][pRespektMultiplikator] = strval(lResult);
cache_get_field_content(0,"XPBoost", lResult), PlayerInfo[playerid][pXPBoost] = strval(lResult);
cache_get_field_content(0,"LottoLos1", lResult), PlayerInfo[playerid][pLottoLos][0] = strval(lResult);
cache_get_field_content(0,"LottoLos2", lResult), PlayerInfo[playerid][pLottoLos][1] = strval(lResult);
//Drogensystem
cache_get_field_content(0,"CannSamen", lResult), PlayerInfo[playerid][pCannSamen] = strval(lResult);
cache_get_field_content(0,"CannGramm", lResult), PlayerInfo[playerid][pCannGramm] = strval(lResult);
cache_get_field_content(0,"Wasserflasche", lResult), PlayerInfo[playerid][pWasserflasche] = strval(lResult);
cache_get_field_content(0,"CannDunger", lResult), PlayerInfo[playerid][pCannDunger] = strval(lResult);
cache_get_field_content(0,"CannIntus", lResult), PlayerInfo[playerid][pCannIntus] = strval(lResult);
////Aktivitätsevent
cache_get_field_content(0,"Samstag", lResult), PlayerInfo[playerid][pSamstag] = strval(lResult);
cache_get_field_content(0,"Sonntag", lResult), PlayerInfo[playerid][pSonntag] = strval(lResult);
cache_get_field_content(0,"Montag", lResult), PlayerInfo[playerid][pMontag] = strval(lResult);
cache_get_field_content(0,"Dienstag", lResult), PlayerInfo[playerid][pDienstag] = strval(lResult);
cache_get_field_content(0,"Mittwoch", lResult), PlayerInfo[playerid][pMittwoch] = strval(lResult);
cache_get_field_content(0,"Donnerstag", lResult), PlayerInfo[playerid][pDonnerstag] = strval(lResult);
cache_get_field_content(0,"Freitag", lResult), PlayerInfo[playerid][pFreitag] = strval(lResult);
//Osterevent
cache_get_field_content(0,"Osterei", lResult), PlayerInfo[playerid][pOsterei] = strval(lResult);
cache_get_field_content(0,"OstereiFound", lResult), PlayerInfo[playerid][pOstereiFound] = strval(lResult);
// Spawn Infos
cache_get_field_content(0,"PosX", lResult), PlayerInfo[playerid][pPosX] = floatstr(lResult);
cache_get_field_content(0,"PosY", lResult), PlayerInfo[playerid][pPosY] = floatstr(lResult);
cache_get_field_content(0,"PosZ", lResult), PlayerInfo[playerid][pPosZ] = floatstr(lResult);
cache_get_field_content(0,"PosR", lResult), PlayerInfo[playerid][pPosR] = floatstr(lResult);
cache_get_field_content(0,"TodX", lResult), PlayerInfo[playerid][pTodX] = floatstr(lResult);
cache_get_field_content(0,"TodY", lResult), PlayerInfo[playerid][pTodY] = floatstr(lResult);
cache_get_field_content(0,"TodZ", lResult), PlayerInfo[playerid][pTodZ] = floatstr(lResult);
cache_get_field_content(0,"TodR", lResult), PlayerInfo[playerid][pTodR] = floatstr(lResult);
cache_get_field_content(0,"Interior", lResult), PlayerInfo[playerid][pInterior] = strval(lResult);
cache_get_field_content(0,"VirWorld", lResult), PlayerInfo[playerid][pVirWorld] = strval(lResult);
cache_get_field_content(0,"KampfStyle", lResult), PlayerInfo[playerid][pKampfStyle] = strval(lResult);
// Duty
cache_get_field_content(0,"SEKDuty", lResult), PlayerInfo[playerid][pSEKDuty] = strval(lResult);
cache_get_field_content(0,"KripoDuty", lResult), PlayerInfo[playerid][pKripoDuty] = strval(lResult);
cache_get_field_content(0,"FeuerwehrDuty", lResult), PlayerInfo[playerid][pFeuerwehrDuty] = strval(lResult);
cache_get_field_content(0,"FFeuerwehr", lResult), PlayerInfo[playerid][pFFeuerwehr] = strval(lResult);
cache_get_field_content(0,"Konfer", lResult), PlayerInfo[playerid][pKonfer] = strval(lResult);
cache_get_field_content(0,"Verheiratet", lResult), PlayerInfo[playerid][pVerheiratet] = strval(lResult);
cache_get_field_content(0,"Ehepartner", lResult), strmid(PlayerInfo[playerid][pEhepartner], lResult, 0, strlen(lResult), MAX_PLAYER_NAME);
cache_get_field_content(0,"Bigears", lResult), PlayerInfo[playerid][pBigears] = strval(lResult);
cache_get_field_content(0,"Gecufft", lResult), PlayerInfo[playerid][pGecufft] = strval(lResult);
cache_get_field_content(0,"Organisation", lResult), PlayerInfo[playerid][pOrganisation] = strval(lResult);
cache_get_field_content(0,"Partei", lResult), PlayerInfo[playerid][pPartei] = strval(lResult);
cache_get_field_content(0,"TimeBan", lResult), PlayerInfo[playerid][pTimeBan] = strval(lResult);
cache_get_field_content(0,"Gebannt", lResult), PlayerInfo[playerid][pGebannt] = strval(lResult);
cache_get_field_content(0,"SpawnChange", lResult), PlayerInfo[playerid][pSpawnChange] = strval(lResult);
cache_get_field_content(0,"SpawnInterior", lResult), PlayerInfo[playerid][pSpawnInterior] = strval(lResult);
cache_get_field_content(0,"MaxWanteds", lResult), PlayerInfo[playerid][pMaxWanteds] = strval(lResult);
cache_get_field_content(0,"PaintballMorde", lResult), PlayerInfo[playerid][pPaintballMorde] = strval(lResult);
cache_get_field_content(0,"FlaschenGesamt", lResult), PlayerInfo[playerid][pFlaschenGesamt] = strval(lResult);
cache_get_field_content(0,"FischeGefangen", lResult), PlayerInfo[playerid][pFischeGefangen] = strval(lResult);
cache_get_field_content(0,"AmateurAngel", lResult), PlayerInfo[playerid][pAmateurAngel] = strval(lResult);
cache_get_field_content(0,"FortgeschrittenenAngel", lResult), PlayerInfo[playerid][pFortgeschrittenenAngel] = strval(lResult);
cache_get_field_content(0,"ProfiAngel", lResult), PlayerInfo[playerid][pProfiAngel] = strval(lResult);
cache_get_field_content(0,"ExpertenAngel", lResult), PlayerInfo[playerid][pExpertenAngel] = strval(lResult);
cache_get_field_content(0,"Koeder", lResult), PlayerInfo[playerid][pKoeder] = strval(lResult);
cache_get_field_content(0,"PremiumKoeder", lResult), PlayerInfo[playerid][pPremiumKoeder] = strval(lResult);
cache_get_field_content(0,"C4Abgabe", lResult), PlayerInfo[playerid][pC4Abgabe] = strval(lResult);
cache_get_field_content(0,"ReheGenutzt", lResult), PlayerInfo[playerid][pReheGenutzt] = strval(lResult);
SetPlayerScore(playerid, PlayerInfo[playerid][pLevel]);
PlayerInfo[playerid][pGeld] = geld;
GivePlayerMoney(playerid, geld);
SetPVarInt(playerid,"Leader",PlayerInfo[playerid][pLeader]);
SetPVarInt(playerid,"Member",PlayerInfo[playerid][pMember]);
SetPVarInt(playerid,"Geld",PlayerInfo[playerid][pGeld]);
SetPVarInt(playerid,"Admin",PlayerInfo[playerid][pAdmin]);
if(PlayerInfo[playerid][pMember] == 1 || PlayerInfo[playerid][pMember] == 2 ||PlayerInfo[playerid][pMember] == 3 ||PlayerInfo[playerid][pLeader] == 1 ||PlayerInfo[playerid][pLeader] ==2 ||PlayerInfo[playerid][pLeader] == 3 ){SetPVarInt(playerid,"IsACop",1);}else{SetPVarInt(playerid,"IsACop",0);}
mysql_function_query(sqlHandle, query, true, "OnPlayerLoad", "ii", playerid, 1);
}
case 1: //61694
{//Skills und Fähigkeiten
if(rows != 0)
{
cache_get_field_content(0,"Mechaniker", lResult), PlayerInfo[playerid][pMechanikerSkill] = strval(lResult);
cache_get_field_content(0,"Busfahrer", lResult), PlayerInfo[playerid][pBusfahrerSkill] = strval(lResult);
cache_get_field_content(0,"Feger", lResult), PlayerInfo[playerid][pFegerSkill] = strval(lResult);
cache_get_field_content(0,"Farmer", lResult), PlayerInfo[playerid][pFarmerSkill] = strval(lResult);
cache_get_field_content(0,"Erzarbeiter", lResult), PlayerInfo[playerid][pErzarbeiterSkill] = strval(lResult);
cache_get_field_content(0,"Pilot", lResult), PlayerInfo[playerid][pPilotSkill] = strval(lResult);
cache_get_field_content(0,"Kapitan", lResult), PlayerInfo[playerid][pKapitanSkill] = strval(lResult);
cache_get_field_content(0,"Holzfaller", lResult), PlayerInfo[playerid][pHolzfallerSkill] = strval(lResult);
cache_get_field_content(0,"Lokfuhrer", lResult), PlayerInfo[playerid][pLokfuhrerSkill] = strval(lResult);
cache_get_field_content(0,"Anwalt", lResult), PlayerInfo[playerid][pAnwaltSkill] = strval(lResult);
cache_get_field_content(0,"Mullmann", lResult), PlayerInfo[playerid][pMullmannSkill] = strval(lResult);
cache_get_field_content(0,"Angeln", lResult), PlayerInfo[playerid][pAngelSkill] = strval(lResult);
cache_get_field_content(0,"KStyleBOXING", lResult), PlayerInfo[playerid][pKStyleBOXING] = strval(lResult);
cache_get_field_content(0,"KStyleKUNGFU", lResult), PlayerInfo[playerid][pKStyleKUNGFU] = strval(lResult);
cache_get_field_content(0,"KStyleKNEEHEAD", lResult), PlayerInfo[playerid][pKStyleKNEEHEAD] = strval(lResult);
cache_get_field_content(0,"KStyleGRABKICK", lResult), PlayerInfo[playerid][pKStyleGRABKICK] = strval(lResult);
cache_get_field_content(0,"KStyleELBOW", lResult), PlayerInfo[playerid][pKStyleELBOW] = strval(lResult);
cache_get_field_content(0,"DesertEagle", lResult), PlayerInfo[playerid][pDesertEagleSkill] = strval(lResult);
cache_get_field_content(0,"Shotgun", lResult), PlayerInfo[playerid][pShotgunSkill] = strval(lResult);
cache_get_field_content(0,"MP5", lResult), PlayerInfo[playerid][pMP5Skill] = strval(lResult);
cache_get_field_content(0,"M4", lResult), PlayerInfo[playerid][pM4Skill] = strval(lResult);
cache_get_field_content(0,"AK47", lResult), PlayerInfo[playerid][pAK47Skill] = strval(lResult);
cache_get_field_content(0,"SniperRifle", lResult), PlayerInfo[playerid][pSniperRifleSkill] = strval(lResult);
}
format(query, sizeof(query), "SELECT * FROM `accounts_scheine` WHERE `userID` = '%i'", PlayerInfo[playerid][pSaveID]);
mysql_function_query(sqlHandle, query, true, "OnPlayerLoad", "ii", playerid, 3);
}
case 2:
{//Scheine und Lizenzen
if(rows != 0) {
cache_get_field_content(0,"AutoLic", lResult), PlayerInfo[playerid][pAutoLic] = strval(lResult);
cache_get_field_content(0,"BikeLic", lResult), PlayerInfo[playerid][pBikeLic] = strval(lResult);
cache_get_field_content(0,"FlugLic", lResult), PlayerInfo[playerid][pFlugLic] = strval(lResult);
cache_get_field_content(0,"BootLic", lResult), PlayerInfo[playerid][pBootLic] = strval(lResult);
cache_get_field_content(0,"LKWLic", lResult), PlayerInfo[playerid][pLKWLic] = strval(lResult);
cache_get_field_content(0,"WaffenLic", lResult), PlayerInfo[playerid][pWaffenLic] = strval(lResult);
cache_get_field_content(0,"Perso", lResult), PlayerInfo[playerid][pPerso] = strval(lResult);
cache_get_field_content(0,"Reisepass", lResult), PlayerInfo[playerid][pReisepass] = strval(lResult);
}
format(query, sizeof(query), "SELECT * FROM `accounts_waffen` WHERE `userID` = '%i'", PlayerInfo[playerid][pSaveID]);
mysql_function_query(sqlHandle, query, true, "OnPlayerLoad", "ii", playerid, 4);
}
case 3:
{//Waffen
if(rows != 0) {
for(new i = 0; i < 13; i++)
{
new lWaffe, lAmmu, feld[24];
format(feld, sizeof(feld), "Waffe%i", i);
cache_get_field_content(0,feld, lResult), lWaffe = strval(lResult);
format(feld, sizeof(feld), "Ammu%i", i);
cache_get_field_content(0,feld, lResult), lAmmu = strval(lResult);
GivePlayerWeapon(playerid, lWaffe, lAmmu);
/*format(feld, sizeof(feld), "Waffe%i", i);
cache_get_field_content(0,feld, lResult), PlayerInfo[playerid][pWaffe][i] = strval(lResult);
format(feld, sizeof(feld), "Ammu%i", i);
cache_get_field_content(0,feld, lResult), PlayerInfo[playerid][pAmmu][i] = strval(lResult);*/
}
}
format(query, sizeof(query), "SELECT * FROM `accounts_bank` WHERE `userID` = '%i'", PlayerInfo[playerid][pSaveID]);
mysql_function_query(sqlHandle, query, true, "OnPlayerLoad", "ii", playerid, 5);
}
case 4:
{
if(rows != 0) {//Finanzen: Bank
cache_get_field_content(0,"GiroKonto", lResult), PlayerInfo[playerid][pGiroKonto] = strval(lResult);
cache_get_field_content(0,"GirokontoNummer", lResult), PlayerInfo[playerid][pGirokontoNummer] = strval(lResult);
cache_get_field_content(0,"GirokontoPin", lResult), PlayerInfo[playerid][pGirokontoPin] = strval(lResult);
cache_get_field_content(0,"GirokontoStand", lResult), PlayerInfo[playerid][pGirokontoStand] = strval(lResult);
cache_get_field_content(0,"SparKonto", lResult), PlayerInfo[playerid][pSparKonto] = strval(lResult);
cache_get_field_content(0,"SparkontoStand", lResult), PlayerInfo[playerid][pSparkontoStand] = strval(lResult);
cache_get_field_content(0,"KreditOption", lResult), PlayerInfo[playerid][pKreditOption] = strval(lResult);
cache_get_field_content(0,"KreditMenge", lResult), PlayerInfo[playerid][pKreditMenge] = strval(lResult);
}
format(query, sizeof(query), "SELECT * FROM `accounts_settings` WHERE `userID` = '%i'", PlayerInfo[playerid][pSaveID]);
mysql_function_query(sqlHandle, query, true, "OnPlayerLoad", "ii", playerid, 6);
}
case 5:
{//Einstellungen
if(rows != 0) {
cache_get_field_content(0,"HealTDPosX", lResult), PlayerInfo[playerid][pHealTDPosX] = floatstr(lResult);
cache_get_field_content(0,"HealTDPosY", lResult), PlayerInfo[playerid][pHealTDPosY] = floatstr(lResult);
cache_get_field_content(0,"ArmorTDPosX", lResult), PlayerInfo[playerid][pArmorTDPosX] = floatstr(lResult);
cache_get_field_content(0,"ArmorTDPosY", lResult), PlayerInfo[playerid][pArmorTDPosY] = floatstr(lResult);
cache_get_field_content(0,"WantedTDPosX", lResult), PlayerInfo[playerid][pWantedTDPosX] = floatstr(lResult);
cache_get_field_content(0,"WantedTDPosY", lResult), PlayerInfo[playerid][pWantedTDPosY] = floatstr(lResult);
cache_get_field_content(0,"DatumTDPosX", lResult), PlayerInfo[playerid][pDatumTDPosX] = floatstr(lResult);
cache_get_field_content(0,"DatumTDPosY", lResult), PlayerInfo[playerid][pDatumTDPosY] = floatstr(lResult);
cache_get_field_content(0,"UhrzeitTDPosX", lResult), PlayerInfo[playerid][pUhrzeitTDPosX] = floatstr(lResult);
cache_get_field_content(0,"UhrzeitTDPosY", lResult), PlayerInfo[playerid][pUhrzeitTDPosY] = floatstr(lResult);
cache_get_field_content(0,"Hitsound", lResult), PlayerInfo[playerid][pHitsound] = strval(lResult);
cache_get_field_content(0,"NewsChannel", lResult), PlayerInfo[playerid][pNewsChannel] = strval(lResult);
cache_get_field_content(0,"MapIcons", lResult), PlayerInfo[playerid][pMapIcons] = strval(lResult);
cache_get_field_content(0,"PaketVerlust", lResult), PlayerInfo[playerid][pPaketVerlust] = strval(lResult);
cache_get_field_content(0,"Wantedliste", lResult), PlayerInfo[playerid][pWantedliste] = strval(lResult);
cache_get_field_content(0,"HealAnzeige", lResult), PlayerInfo[playerid][pHealAnzeige] = strval(lResult);
cache_get_field_content(0,"ArmorAnzeige", lResult), PlayerInfo[playerid][pArmorAnzeige] = strval(lResult);
cache_get_field_content(0,"MotorTaste", lResult), PlayerInfo[playerid][pMotorTaste] = strval(lResult);
cache_get_field_content(0,"LichtTaste", lResult), PlayerInfo[playerid][pLichtTaste] = strval(lResult);
cache_get_field_content(0,"ICPTaste", lResult), PlayerInfo[playerid][pICPTaste] = strval(lResult);
}
format(query, sizeof(query), "SELECT * FROM `accounts_fische` WHERE `userID` = '%i'", PlayerInfo[playerid][pSaveID]);
mysql_function_query(sqlHandle, query, true, "OnPlayerLoad", "ii", playerid, 7);
}
case 6: //Fische
{
if(rows != 0)
{
new FischString[32];
new GewichtString[32];
for(new i = 0; i < 15; i++)
{
format(FischString, sizeof(FischString), "Fisch_%d", i);
format(GewichtString, sizeof(GewichtString), "Gewicht_%d", i);
cache_get_field_content(0, FischString, lResult), SpielerFische[playerid][i][0] = strval(lResult);
cache_get_field_content(0, GewichtString, lResult), SpielerFische[playerid][i][1] = strval(lResult);
}
}
format(query, sizeof(query), "SELECT * FROM `accounts_erfolge` WHERE `userID` = '%i'", PlayerInfo[playerid][pSaveID]);
mysql_function_query(sqlHandle, query, true, "OnPlayerLoad", "ii", playerid, 8);
}
case 7:
{
//Erfolge
cache_get_field_content(0,"LandwirtTutorial", lResult), PlayerInfo[playerid][pLandwirtTutorial] = strval(lResult);
cache_get_field_content(0,"AmmunationTutorial", lResult), PlayerInfo[playerid][pAmmunationTutorial] = strval(lResult);
cache_get_field_content(0,"FirstICPOpen", lResult), PlayerInfo[playerid][pFirstICPOpen] = strval(lResult);
cache_get_field_content(0,"PfandflaschenTutorial", lResult), PlayerInfo[playerid][pPfandflaschenTutorial] = strval(lResult);
cache_get_field_content(0,"LieferantTutorial", lResult), PlayerInfo[playerid][pLieferantTutorial] = strval(lResult);
cache_get_field_content(0,"MechanikerTutorial", lResult), PlayerInfo[playerid][pMechanikerTutorial] = strval(lResult);
cache_get_field_content(0,"MullmannTutorial", lResult), PlayerInfo[playerid][pMullmannTutorial] = strval(lResult);
cache_get_field_content(0,"StadtreinigerTutorial", lResult), PlayerInfo[playerid][pStadtreinigerTutorial] = strval(lResult);
cache_get_field_content(0,"ErzarbeiterTutorial", lResult), PlayerInfo[playerid][pErzarbeiterTutorial] = strval(lResult);
cache_get_field_content(0,"ScheinDrunkTutorial", lResult), PlayerInfo[playerid][pScheinDrunkTutorial] = strval(lResult);
cache_get_field_content(0,"HunterTutorial", lResult), PlayerInfo[playerid][pHunterTutorial] = strval(lResult);
new geldquery[512];
format(geldquery, sizeof(geldquery), "INSERT INTO `log_geld` (`userID`, `Geldmenge`, `UNIX`, `login`, `logout`, `Bargeld`, `Girokonto`, `Sparkonto`) VALUES ('%d', '0', '%d', '1', '0', '%d', '%d', '%d')", PlayerInfo[playerid][pSaveID], gettime(), PlayerInfo[playerid][pGeld], PlayerInfo[playerid][pGirokontoStand], PlayerInfo[playerid][pSparkontoStand]);
mysql_function_query(sqlHandle, geldquery, false, "", "");
//format(string, sizeof(string), "[ - LOGIN - ] Der Account von %s wurde mit einer Geschwindigkeit von %d Millisekunden geladen!", sendername, GetTickCount() - count);
//SendMySQLMessage(string);
format(query, sizeof(query), "SELECT * FROM `accounts_blacklist` WHERE `userID` = '%i'", PlayerInfo[playerid][pSaveID]);
mysql_function_query(sqlHandle, query, true, "OnPlayerLoad", "ii", playerid, 9);
}
case 8: // Blacklist
{
new lCount;
if(rows)
{
while(lCount < rows)
{
cache_get_field_content(lCount, "FraktionsID", lResult), PlayerInfo[playerid][pBlacklist][strval(lResult)] = 1;
lCount++;
}
}
format(query, sizeof(query), "SELECT * FROM `spielercars` WHERE `ID` = '%i'", PlayerInfo[playerid][pSaveID]);
mysql_function_query(sqlHandle, query, true, "OnPlayerLoad", "ii", playerid, 10);
}
case 9:// Fahrzeuge
{
new lCount, lID, ModelID, Color[2], Float:Pos[4], tmp_databaseid;
if(rows)
{
while(lCount < rows)
{
cache_get_field_content(lCount, "ID", lResult), tmp_databaseid = strval(lResult);
cache_get_field_content(lCount, "ModelID", lResult); ModelID = strval(lResult);
if(ModelID < 400 || ModelID > 611) continue;
cache_get_field_content(lCount, "Farbe1", lResult); Color[0] = strval(lResult);
cache_get_field_content(lCount, "Farbe2", lResult); Color[1] = strval(lResult);
cache_get_field_content(lCount, "PosX", lResult); Pos[0] = floatstr(lResult);
cache_get_field_content(lCount, "PosY", lResult); Pos[1] = floatstr(lResult);
cache_get_field_content(lCount, "PosZ", lResult); Pos[2] = floatstr(lResult);
cache_get_field_content(lCount, "PosA", lResult); Pos[3] = floatstr(lResult);
new vid = CreateVehicleEx(ModelID, Pos[0], Pos[1], Pos[2], Pos[3], Color[0], Color[1]);
cache_get_field_content(lCount, "AnmeldungsOrt", lResult); SpielerAutoInfo[vid][saAnmeldungsOrt] = strval(lResult);
cache_get_field_content(lCount, "KFZNummer", lResult); SpielerAutoInfo[vid][saKFZNummer] = strval(lResult);
cache_get_field_content(lCount, "KennzeichenFarbe", lResult), SpielerAutoInfo[vid][saKennzeichenFarbe] = strval(lResult);
SetVehicleRightNumberPlate(vid);
IsSpielerCar[vid] = true;
SpielerAutoInfo[vid][saDatabaseID] = tmp_databaseid;
SpielerAutoInfo[vid][saFarbe1] = Color[0];
SpielerAutoInfo[vid][saFarbe2] = Color[1];
SpielerAutoInfo[vid][saModelID] = ModelID;
SpielerAutoInfo[vid][saPosX] = Pos[0];
SpielerAutoInfo[vid][saPosY] = Pos[1];
SpielerAutoInfo[vid][saPosZ] = Pos[2];
SpielerAutoInfo[vid][saPosA] = Pos[3];
cache_get_field_content(lCount, "KaufPreis", lResult); SpielerAutoInfo[vid][saKaufPreis] = strval(lResult);
cache_get_field_content(lCount, "Besitzer", lResult), format(SpielerAutoInfo[vid][saBesitzer], 128, "%s", lResult);
cache_get_field_content(lCount, "ParkPosX", lResult), SpielerAutoInfo[vid][saParkPosX] = floatstr(lResult);
cache_get_field_content(lCount, "ParkPosY", lResult), SpielerAutoInfo[vid][saParkPosY] = floatstr(lResult);
cache_get_field_content(lCount, "ParkPosZ", lResult), SpielerAutoInfo[vid][saParkPosZ] = floatstr(lResult);
cache_get_field_content(lCount, "ParkPosA", lResult), SpielerAutoInfo[vid][saParkPosA] = floatstr(lResult);
cache_get_field_content(lCount, "Paintjob", lResult), SpielerAutoInfo[vid][saPaintjob] = strval(lResult);
cache_get_field_content(lCount, "Abgeschlossen", lResult), SpielerAutoInfo[vid][saAbgeschlossen] = strval(lResult);
cache_get_field_content(lCount, "Versichert", lResult), SpielerAutoInfo[vid][saVersichert] = strval(lResult);
cache_get_field_content(lCount, "Abgeschleppt", lResult), SpielerAutoInfo[vid][saAbgeschleppt] = strval(lResult);
cache_get_field_content(lCount, "TankInhalt", lResult), SpielerAutoInfo[vid][saTankInhalt] = strval(lResult);
cache_get_field_content(lCount, "TankArt", lResult), SpielerAutoInfo[vid][saTankArt] = strval(lResult);
cache_get_field_content(lCount, "Batterie", lResult), SpielerAutoInfo[vid][saBatterie] = strval(lResult);
cache_get_field_content(lCount, "MeterStand", lResult), SpielerAutoInfo[vid][saMeterStand] = strval(lResult);
cache_get_field_content(lCount, "Motor", lResult), SpielerAutoInfo[vid][saMotor] = strval(lResult);
cache_get_field_content(lCount, "Light", lResult), SpielerAutoInfo[vid][saLights] = strval(lResult);
cache_get_field_content(lCount, "Handbremse", lResult), SpielerAutoInfo[vid][saHandbremse] = strval(lResult);
cache_get_field_content(lCount, "TagesMeterStand", lResult), SpielerAutoInfo[vid][saTagesMeterStand] = strval(lResult);
cache_get_field_content(lCount, "FRadio", lResult), SpielerAutoInfo[vid][saFRadio] = strval(lResult);
cache_get_field_content(lCount, "Zustand", lResult), SpielerAutoInfo[vid][saZustand] = floatstr(lResult);
cache_get_field_content(lCount, "Mod1", lResult), SpielerAutoInfo[vid][saMod1] = strval(lResult);
cache_get_field_content(lCount, "Mod2", lResult), SpielerAutoInfo[vid][saMod2] = strval(lResult);
cache_get_field_content(lCount, "Mod3", lResult), SpielerAutoInfo[vid][saMod3] = strval(lResult);
cache_get_field_content(lCount, "Mod4", lResult), SpielerAutoInfo[vid][saMod4] = strval(lResult);
cache_get_field_content(lCount, "Mod5", lResult), SpielerAutoInfo[vid][saMod5] = strval(lResult);
cache_get_field_content(lCount, "Mod6", lResult), SpielerAutoInfo[vid][saMod6] = strval(lResult);
cache_get_field_content(lCount, "Mod7", lResult), SpielerAutoInfo[vid][saMod7] = strval(lResult);
cache_get_field_content(lCount, "Mod8", lResult), SpielerAutoInfo[vid][saMod8] = strval(lResult);
cache_get_field_content(lCount, "Mod9", lResult), SpielerAutoInfo[vid][saMod9] = strval(lResult);
cache_get_field_content(lCount, "Mod10", lResult), SpielerAutoInfo[vid][saMod10] = strval(lResult);
cache_get_field_content(lCount, "Mod11", lResult), SpielerAutoInfo[vid][saMod11] = strval(lResult);
cache_get_field_content(lCount, "Mod12", lResult), SpielerAutoInfo[vid][saMod12] = strval(lResult);
cache_get_field_content(lCount, "Mod13", lResult), SpielerAutoInfo[vid][saMod13] = strval(lResult);
cache_get_field_content(lCount, "Mod14", lResult), SpielerAutoInfo[vid][saMod14] = strval(lResult);
cache_get_field_content(lCount, "Panels", lResult), SpielerAutoInfo[vid][saPanels] = strval(lResult);
cache_get_field_content(lCount, "Doors", lResult), SpielerAutoInfo[vid][saDoors] = strval(lResult);
cache_get_field_content(lCount, "Lights", lResult), SpielerAutoInfo[vid][saLights] = strval(lResult);
cache_get_field_content(lCount, "Tires", lResult), SpielerAutoInfo[vid][saTires] = strval(lResult);
cache_get_field_content(lCount, "Panzerung", lResult), SpielerAutoInfo[vid][saPanzerung] = strval(lResult);
cache_get_field_content(lCount, "Autogas", lResult), SpielerAutoInfo[vid][saAutogas] = strval(lResult);
cache_get_field_content(lCount, "GPSSystem", lResult), SpielerAutoInfo[vid][saGPSSystem] = strval(lResult);
cache_get_field_content(lCount, "ID", lResult), SpielerAutoInfo[vid][saUserID] = strval(lResult);
if(SpielerAutoInfo[vid][saZustand] > 300) SetVehicleHealth(vid, SpielerAutoInfo[vid][saZustand]);
else SetVehicleHealth(vid, 300);
TankInhalt[vid] = SpielerAutoInfo[vid][saTankInhalt];
Batterie[vid] = SpielerAutoInfo[vid][saBatterie];
MeterStand[vid] = SpielerAutoInfo[vid][saMeterStand];
Motor[vid] = SpielerAutoInfo[vid][saMotor];
Licht[vid] = SpielerAutoInfo[vid][saLights];
HandbremsePos[vid][0] = Pos[0];
HandbremsePos[vid][1] = Pos[1];
HandbremsePos[vid][2] = Pos[2];
HandbremsePos[vid][3] = Pos[3];
Handbremse[vid] = SpielerAutoInfo[vid][saHandbremse];
TagesMeterStand[vid] = SpielerAutoInfo[vid][saTagesMeterStand];
FRadio[vid] = SpielerAutoInfo[vid][saFRadio];
TankInhaltArt[vid] = SpielerAutoInfo[vid][saTankArt];
AddSpielerCarComponents(vid);
UpdateVehicleDamageStatus(vid, SpielerAutoInfo[vid][saPanels], SpielerAutoInfo[vid][saDoors], SpielerAutoInfo[vid][saLights], SpielerAutoInfo[vid][saTires]);
new engine, light, alarm, door, bonnet, boot, objective;
GetVehicleParamsEx(vid, engine, light, alarm, door, bonnet, boot, objective);
SetVehicleParamsEx(vid, Motor[vid], Licht[vid], alarm, SpielerAutoInfo[vid][saAbgeschlossen], bonnet, boot, objective);
lID++; lCount++;
}
}
new Jahr, Monat, Tag, Stunde, Minute, Sekunde;
getdate(Jahr, Monat, Tag);
gettime(Stunde, Minute, Sekunde);
printf("[%02d.%02d.%d | %02d:%02d:%02d] [ - LOGIN - ] Der Account von %s wurde mit einer Geschwindigkeit von %d Millisekunden geladen!\n",Tag,Monat,Jahr,Stunde,Minute,Sekunde,PlayerInfo[playerid][pName], (GetTickCount() - lStart));
OnPlayerConnectEx(playerid);
}
}
}
mysql_escape_string(query, query, sqlHandle);
}
Alles anzeigen