Beiträge von Corvus

Das ist dann egal welche Marke oder?

Ich habe derzeit 1x8GB und folgendes Mainboard:
H87-Plus von ASUS

Guten Tag,
Ich habe derzeit 8gb Ram undd möchte gerne auf 16 erhöhen.
Was kann man nun machen einen 16gb kaufen oder geht auch 2x8gb?
Danke im vorraus,

Woher kommt der?
[18:51:21] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE FROM db_firmagrundstuck SET `firmenid` = '-1', igekauft =", callback: "(null)", format: "(null)"
[18:51:21] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[18:51:21] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM db_firmagrundstuck SET `firmenid` = '-1', igekauft = '1', firmenname = 'Cry' at line 1
[18:51:21] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[18:51:21] [DEBUG] Calling callback "OnQueryError"..

Was macht dieser Code?
strmid(GFirmaInfo[gfirma][firmenname],OrgInfo[Spieler[playerid][OrgID]][orgname],0,strlen(OrgInfo[Spieler[playerid][OrgID]][orgname]),64);

Wie heist due funktion um die Camera auf diesen Punkt zu setzen so dass er sich selber nicht mehr sieht.

Zitat von Blu3scReeN

1. Nein, du wirst im Endeffekt höchstwahrscheinlich Verlust machen. Kauf dir Waffen und wette dich über z.B. csgolounge hoch.
2. Kommt auf deinen Rang an, du bist wahrscheinlich < Master Guardian, da ist das sehr wahrscheinlich dass du gegen Smurfs spielst und nur Idioten im Team hast, über MG wird es besser

Was ist MG?

Wann wird der Timer immer gemacht.
Bei OneGamemodeinit
SetTimer("FahrzeugUpdater2",600000,true);
public FahrzeugUpdater2()
{
for(new playerid=0;playerid<MAX_PLAYERS;playerid++)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid) && IsPlayerInAnyVehicle(playerid))
{
if(Motor[GetPlayerVehicleID(playerid)] == true)
{
vFahrzeug[GetPlayerVehicleID(playerid)][Tank] -= FahrzeugInfoModel[GetVehicleModel(GetPlayerVehicleID(playerid))-400][ftverbrauch];
}
}
}
return true;
}

Poste mal OnPlayerSpawn und die Serverlog.
Besteht einen MySQL verbindung?

So Könnte man da er ja eine ID verschiebung hat jede ID extra speichern?

Zitat von Jeffry

Dann musst du wahrscheinlich überall dort wo du ein query zwecks Fraktionen sendest die frakid um eins erhöhen, weil in deiner Tabelle fängt es mit 1 an, die Arrays aber mit 0, entsprechend ist frakid 0 im Code in der Tabelle die 1.
Oder du änderst deine Tabelle so ab, dass die IDs bei 0 anfangen.

Kann man auch jede Zeile einzeln Updaten und Laden?

Jetzt packt er das eine Tabelle weiter oben hin Code beim Einzahlen:
case DIALOG_FRAKBANK_EINZAHLEN:
{
for(new frakid=0;frakid<MAX_FRAKTIONEN;frakid++)
if(response == 0) return ShowPlayerDialog(playerid,DIALOG_FRAKBANK,DIALOG_STYLE_LIST,"Fraktionsbank","Ausrüsten\nEinzahlen\nAuszahlen\nMaterial\nDrogen","Weiter","Abbruch");
new cmd = strval(inputtext),string[350],frakid = Spieler[playerid][pFraktion];
if((Spieler[playerid][pGeld] - cmd) < 0) return SendClientMessage(playerid,ROT,"Du hast nicht genug Geld!");
if(!IsNumeric(inputtext))
{
format(string,sizeof(string),"Gebe bitte nun den Betrag ein, welchen du in die Fraktionkasse einzahlen möchtest!\nDerzeitiger Fraktionskassen Stand: %i$",FrakInfo[frakid][frakgeld]);
ShowPlayerDialog(playerid,DIALOG_FRAKBANK_EINZAHLEN,DIALOG_STYLE_INPUT,"Fraktionsbank Einzahlung",string,"Weiter","Abbruch");
return SendClientMessage(playerid,ROT,"Es sind nur Zahlen möglich!");
}
if(cmd < 1 || cmd > 10000)
{
format(string,sizeof(string),"Gebe bitte nun den Betrag ein, welchen du in die Fraktionkasse einzahlen möchtest!\nDerzeitiger Fraktionskassen Stand: %i$",FrakInfo[frakid][frakgeld]);
ShowPlayerDialog(playerid,DIALOG_FRAKBANK_EINZAHLEN,DIALOG_STYLE_INPUT,"Fraktionsbank Einzahlung",string,"Weiter","Abbruch");
return SendClientMessage(playerid,ROT,"Betrag nur zwischen 1 und 10.000$ möglich!");
}
FrakInfo[frakid][frakgeld] += cmd,ACMoney(playerid, -cmd);
format(string,sizeof(string),""#HTML_WHITE"[ "#HTML_LOGIN"FrakBank: "#HTML_WHITE"Das Mitglied "#HTML_ORANGE"%s "#HTML_WHITE"hat so eben "#HTML_GREEN"%i$ "#HTML_WHITE"in der Fraktionkasse eingezahlt! "#HTML_WHITE"Neuer Stand: "#HTML_ORANGE"%i$ ]",SpielerName(playerid),cmd,FrakInfo[frakid][frakgeld]);
FraktionsChat(Spieler[playerid][pFraktion],WEISS,string);
format(string,sizeof(string),"INSERT INTO "#DATENBANK"_frakgeldlog (`fID`,`name`,`count`,`timestamp`,`op`) VALUES ('%d','%s','%d','%d','1')",frakid,SpielerName(playerid),cmd,gettime());
mysql_function_query(MYSQLVerbindung,string,false,"","");
ShowPlayerDialog(playerid,DIALOG_FRAKBANK,DIALOG_STYLE_LIST,"Fraktionsbank","Ausrüsten\nEinzahlen\nAuszahlen\nMaterial\nDrogen","Weiter","Abbruch");
return true;
}

So:

Guten Abend,
Ich benutze das MySQL Plugin 39 und es macht probleme beim Updaten:
Hier weise ich das Geld zu und es wird in einer Log Perfekt gepseichert.

FrakInfo[frakid][frakgeld] += cmd,ACMoney(playerid, -cmd);
format(string,sizeof(string),""#HTML_WHITE"[ "#HTML_LOGIN"FrakBank: "#HTML_WHITE"Das Mitglied "#HTML_ORANGE"%s "#HTML_WHITE"hat so eben "#HTML_GREEN"%i$ "#HTML_WHITE"in der Fraktionkasse eingezahlt! "#HTML_WHITE"Neuer Stand: "#HTML_ORANGE"%i$ ]",SpielerName(playerid),cmd,FrakInfo[frakid][frakgeld]);
FraktionsChat(Spieler[playerid][pFraktion],WEISS,string);
format(string,sizeof(string),"INSERT INTO "#DATENBANK"_frakgeldlog (`fID`,`name`,`count`,`timestamp`,`op`) VALUES ('%d','%s','%d','%d','1')",frakid,SpielerName(playerid),cmd,gettime());

Nun ist das Problem dass sich das ganze ganz Random mäßig verschiebt:
stock SaveFraktion()
{
new query[275],
frak = 0;
for(;frak<MAX_FRAKTIONEN;frak++)
{
format(query,sizeof(query),"UPDATE "#DATENBANK"_fraktionen SET frakmaterial = '%d', frakgeld = '%d', marihuana = '%d', koks = '%d', crystle = '%d', lsd = '%d', gras = '%d' WHERE id = '%d'",FrakInfo[frak][frakmaterial],FrakInfo[frak][frakgeld],FrakInfo[frak][fMarihuana],FrakInfo[frak][fKoks],FrakInfo[frak][fCrystle],FrakInfo[frak][fLSD],FrakInfo[frak][fGras],frak);
mysql_function_query(MYSQLVerbindung,query,false,"","");
}
return 1;
}

Screen der MySQL Tabelle:
http://www11.pic-upload.de/07.06.15/qfq8c1a54wjs.png
Danke im vorraus,
Mfg,

Erstellt wird das so:
if(strcmp(cmd,"Marihuana",true) == 0)
{
if(Spieler[playerid][pMariSamen] < MAX_MARI) return SendClientMessage(playerid,GRAU,"Benötigte Samen: "#MAX_MARI"");
Spieler[playerid][pMariSamen] -= MAX_MARI;
ErstellungDrogenPflanze(1,Pos[0],Pos[1],Pos[2],frakid,SpielerName(playerid),playerid);
OnePlayAnim(playerid,"BOMBER","BOM_Plant",4.0,0,0,0,0,0);
format(string,sizeof(string),"* %s pflanzt etwas *",SpielerName(playerid));
PlayerTalk(playerid,MEFARBE,string,10);
SetTimerEx("AnimationEntfernen",5000, false, "i", playerid);
return true;
}

Und das der stock dazu:
tock ErstellungDrogenPflanze(drogenart,Float:drugPosX,Float:drugPosY,Float:drugPosZ,fraktionsid,drogendealer[MAX_PLAYER_NAME+1],spielerid)
{
new string[275],drugname[25],frakname[25],query[500];
for(new drug=0;drug<MAX_DROGEN;drug++)
{
DrogenInfo[drug][druggepflanzt] = 1;
DrogenInfo[drug][druggegossen] = 100;
DrogenInfo[drug][drugzustand] = 100;
DrogenInfo[drug][drugausbeute] = random(10)+10;
DrogenInfo[drug][drugreife] = 90;
switch(drogenart)
{
case 1: { drugname="Marihuana";}
case 2: { drugname="Koks";}
case 3: { drugname="Crystle Meth";}
case 4: { drugname="Gras";}
default: { drugname="Fehler";}
}
switch(fraktionsid)
{
case 7:{frakname="Grove Street";}
case 8:{frakname="Ballas";}
case 9:{frakname="Vagos";}
case 10:{frakname="Rifa";}
case 11:{frakname="Yakuza";}
case 12:{frakname="Triaden";}
}
if(fraktionsid != 0)
{
if(drug == MAX_DROGEN+1) return SendClientMessage(spielerid,GRAU,"Die Maximale Anzahl an Drogenpflanzen wurde bereits gepflanzt!");
DrogenInfo[drug][DrugX] = drugPosX;
DrogenInfo[drug][DrugY] = drugPosY;
DrogenInfo[drug][DrugZ] = drugPosZ;
DrogenInfo[drug][drugfrakid] = fraktionsid;
DrogenInfo[drug][drugart] = drogenart;
DrogenInfo[drug][drogenid] = drug;
format(string,sizeof(string),""#HTML_RED"%s\n"#HTML_WHITE"Besitzer: %s\nGesamt Drogen: %i\nReif in: %i Minuten\nZustand: "#HTML_GREEN"IIIII"#HTML_WHITE"\nWasserzustand: "#HTML_GREEN"IIIII",
drugname,frakname,DrogenInfo[drug][drugausbeute],DrogenInfo[drug][drugreife]);
DrugText[drug] = Create3DTextLabel(string,GRAU,DrogenInfo[drug][DrugX],DrogenInfo[drug][DrugY],DrogenInfo[drug][DrugZ],10.0,0,0);
format(query,sizeof(query),"INSERT INTO "#DATENBANK"_drogen (`drugfrakid`,`drugbesitzer`,`drugreife`,`drugart`,`drugausbeute`,`drugzustand`,`druggegossen`,`druggepflanzt`,`DrugX`,`DrugY`,`DrugZ`,`drogenid`) VALUES ('%i','%s','%i','%i','%i','%i','%i','%i','%f','%f','%f','%i')",
fraktionsid,Fraktionsname(spielerid),DrogenInfo[drug][drugreife],drogenart,DrogenInfo[drug][drugausbeute],DrogenInfo[drug][drugzustand],DrogenInfo[drug][druggegossen],DrogenInfo[drug][druggepflanzt],DrogenInfo[drug][DrugX],DrogenInfo[drug][DrugY],DrogenInfo[drug][DrugZ],drug);
mysql_function_query(MYSQLVerbindung,query,false,"","");
if(drogenart == 1) { DrogenInfo[drug][drugobjekt] = CreateDynamicObject(826,DrogenInfo[drug][DrugX],DrogenInfo[drug][DrugY],DrogenInfo[drug][DrugZ],0.0,0.0,0.0); }
if(drogenart == 2) { DrogenInfo[drug][drugobjekt] = CreateDynamicObject(825,DrogenInfo[drug][DrugX],DrogenInfo[drug][DrugY],DrogenInfo[drug][DrugZ],0.0,0.0,0.0); }
if(drogenart == 3) { DrogenInfo[drug][drugobjekt] = CreateDynamicObject(866,DrogenInfo[drug][DrugX],DrogenInfo[drug][DrugY],DrogenInfo[drug][DrugZ],0.0,0.0,0.0); }
if(drogenart == 4) { DrogenInfo[drug][drugobjekt] = CreateDynamicObject(822,DrogenInfo[drug][DrugX],DrogenInfo[drug][DrugY],DrogenInfo[drug][DrugZ],0.0,0.0,0.0); }
return true;
}

Guten Tag,
Warum wird hier der TextLabel und die Pflanzen nicht gelöscht:
if(DrogenInfo[drug][drugart] == 1) {
DrogenInfo[drug][geerntet] = 1;
Spieler[playerid][pMarihuana] += DrogenInfo[drug][drugausbeute];
format(string,sizeof(string),""#HTML_RED"Info: "#HTML_WHITE"Du hast %i Droge (Marihuana) abgeerntet!",DrogenInfo[drug][drugausbeute]);
format(query,sizeof(query),"DELETE FROM "#DATENBANK"_drogen WHERE drogenid = '%d'",DrogenInfo[drug][drogenid]);
Delete3DTextLabel(DrugText[drug]);
DestroyObject(DrogenInfo[drug][drugobjekt]);
SendClientMessage(playerid,GRAU,string);
return true;
}

Warum wird der textlabel und die Pflanze nicht gelöscht?
if(DrogenInfo[drug][drugart] == 1) {
DrogenInfo[drug][geerntet] = 1;
Spieler[playerid][pMarihuana] += DrogenInfo[drug][drugausbeute];
format(string,sizeof(string),""#HTML_RED"Info: "#HTML_WHITE"Du hast %i Droge (Marihuana) abgeerntet!",DrogenInfo[drug][drugausbeute]);
format(query,sizeof(query),"DELETE FROM "#DATENBANK"_drogen WHERE drogenid = '%d'",DrogenInfo[drug][drogenid]);
Delete3DTextLabel(DrugText[drug]);
DestroyObject(DrogenInfo[drug][drugobjekt]);
SendClientMessage(playerid,GRAU,string);
return true;
}

Habs gelöst.

Nein

Hier:
cache_get_data(rows,fields);
if(rows)
{
if(passwortstate == 1)
{
cache_get_field_content(0,"Passwort",result);
new tmpp[25];
strmid(tmpp,(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}!\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][RpChat] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(0,"Autologin",result);
Spieler[playerid][Autologin] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(0,"Newschat",result);
Spieler[playerid][Newschat] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(0,"Jobchat",result);
Spieler[playerid][Jobchat] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(0,"Neulingschat",result);
Spieler[playerid][Neulingschat] = strval(result);
strdel(result,0,sizeof(result));
cache_get_field_content(0,"Premiumchat",result);
Spieler[playerid][Premiumchat] = strval(result);
strdel(result,0,sizeof(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);
}