da ich mich nicht so gut mit msql auskenne und mein bruder mir das von dini auf msql umgeschrieben hat
ich habe folgendes Problem der SPeichert 1 abschnitt nicht ab und das ist der
CSS
format(query, sizeof(query), "UPDATE `users` SET `GKills`='%d', `Meldung`='%d', `HatIrgenteinHome`='%d', `Pin`='%d' \
, `Bombe`='%d', `Guertel`='%d', `SpawnChange`='%d', `HotelLS`='%d', `HotelSF`='%d', `HotelLV`='%d', `CarPunkt`='%d', `BikePunkt`='%d', `Kanister`='%d', `KreditRechnung`='%d', `jobkuendigen`='%d' WHERE `id` = '%d'",
PlayerInfo[playerid][pGKills], PlayerInfo[playerid][pMeldung], PlayerInfo[playerid][pHatIrgenteinHome], PlayerInfo[playerid][pPin], PlayerInfo[playerid][pBombe], PlayerInfo[playerid][pGuertel],
PlayerInfo[playerid][pSpawnChange], PlayerInfo[playerid][plseingemietet], PlayerInfo[playerid][psfeingemietet], PlayerInfo[playerid][plveingemietet], PlayerInfo[playerid][pCarP], PlayerInfo[playerid][pBikeP],
PlayerInfo[playerid][pKanister], PlayerInfo[playerid][pKreditRechnung],PlayerInfo[playerid][pjobkuendigen], PlayerInfo[playerid][p_id]);
mysql_pquery(handle, query);hier noch mal das ganze
CSS
public SpielerUpdate(playerid)
{
if(IsPlayerConnected(playerid) && gPlayerLogged[playerid] == 1) {
M_OnPlayerUpdate(playerid);
new PDIP[20];
GetPlayerIp(playerid,PDIP,sizeof(PDIP));
GetPlayerHealth(playerid,PlayerInfo[playerid][pHealth]);
if ((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0))
{
PlayerInfo[playerid][pPos_x] = 1684.9;
PlayerInfo[playerid][pPos_y] = -2244.5;
PlayerInfo[playerid][pPos_z] = 13.5;
}
if(Spectate[playerid] != 255)
{
PlayerInfo[playerid][pPos_x] = Unspec[playerid][sPx];
PlayerInfo[playerid][pPos_y] = Unspec[playerid][sPy];
PlayerInfo[playerid][pPos_z] = Unspec[playerid][sPz];
PlayerInfo[playerid][pInt] = Unspec[playerid][sPint];
PlayerInfo[playerid][pLocal] = Unspec[playerid][sLocal];
}
PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
new query[2048];
format(query, sizeof(query), "UPDATE `users` SET `Level`='%d', `Adminlevel`='%d', `DonateRank`='%d', `UpgradePoints`='%d', `ConnectedTime`='%d' \
, `Registered`='%d', `Sex`='%d', `Age`='%d', `Origin`='%d', `CK`='%d', `Muted`='%d', `Respect`='%d', `Money`='%d', `Bank`='%d', `Kredit`='%s', `KreditDauer`='%d' \
, `Crimes`='%d' WHERE `id` = '%d'", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][gPupgrade],
PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pOrigin], PlayerInfo[playerid][pCK],
PlayerInfo[playerid][pMuted], PlayerInfo[playerid][pExp], PlayerInfo[playerid][pCash], PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pPlayerKredit], PlayerInfo[playerid][pPlayerKreditDauer],
PlayerInfo[playerid][pCrimes], PlayerInfo[playerid][p_id]);
mysql_pquery(handle, query);
format(query, sizeof(query), "UPDATE `users` SET `Kills`='%d', `Deaths`='%d', `Arrested`='%d', `WantedDeaths`='%d', `Phonebook`='%d', `Fishes`='%d', \
`BiggestFish`='%d' , `Job`='%d', `HeadValue`='%d', `Jailed`='%d', `GangJailed`='%d', `wJailed`='%d', `Mauled`='%d', `JailTime`='%d', `Materials`='%d' WHERE `id` = '%d'",
PlayerInfo[playerid][pKills], PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][pArrested], PlayerInfo[playerid][pWantedDeaths],
PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pBiggestFish], PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pHeadValue], PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pGangJailed], PlayerInfo[playerid][pwJailed], PlayerInfo[playerid][pMauled],
PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pMats], PlayerInfo[playerid][p_id]);
mysql_pquery(handle, query);
format(query, sizeof(query), "UPDATE `users` SET `Drugs`='%d', `BoxMaterials`='%d', `BoxDrugs`='%d', `FightingStyle`='%d', `Leader`='%d', `Member`='%d', `FMember`='%d' \
, `Rank`='%d', `GWD`='%d', `pChar`='%d', `ContractTime`='%d', `DetSkill`='%d', `SexSkill`='%d', `BoxSkill`='%d', `LawSkill`='%d', `MechSkill`='%d', `JackSkill`='%d' WHERE `id` = '%d'",
PlayerInfo[playerid][pDrugs], PlayerInfo[playerid][pBoxMats], PlayerInfo[playerid][pBoxDrugs], GetPlayerFightingStyle(playerid), PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember], PlayerInfo[playerid][pFMember], PlayerInfo[playerid][pRank], PlayerInfo[playerid][pGWD], PlayerInfo[playerid][pChar], PlayerInfo[playerid][pContractTime],
PlayerInfo[playerid][pDetSkill], PlayerInfo[playerid][pSexSkill], PlayerInfo[playerid][pBoxSkill], PlayerInfo[playerid][pLawSkill], PlayerInfo[playerid][pMechSkill],PlayerInfo[playerid][pJackSkill], PlayerInfo[playerid][p_id]);
mysql_pquery(handle, query);
format(query, sizeof(query), "UPDATE `users` SET `NewsSkill`='%d', `DrugsSkill`='%d', `CookSkill`='%d', `FishSkill`='%d', `FlugSkill`='%d', `pSHealth`='%f', `pHealth`='%d', `pInt`='%d', `Local`='%d', `Team`='%d', `Model`='%d' \
, `PhoneNr`='%d', `House`='%d', `Bizz`='%d', `HandyGeld`='%d', `HandyVer`='%d', `Pos_x`='%f', `Pos_y`='%f', `Pos_z`='%f', `CarLic`='%d', `NewLic`='%d' WHERE `id` = '%d'", PlayerInfo[playerid][pNewsSkill],
PlayerInfo[playerid][pDrugsSkill],PlayerInfo[playerid][pCookSkill], PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pFlugSkill], PlayerInfo[playerid][pHealth], PlayerInfo[playerid][pSHealth], PlayerInfo[playerid][pInt],
PlayerInfo[playerid][pLocal], PlayerInfo[playerid][pTeam], PlayerInfo[playerid][pModel], PlayerInfo[playerid][pPnumber], PlayerInfo[playerid][pPhousekey], PlayerInfo[playerid][pPbiskey], PlayerInfo[playerid][pHandyGeld],
PlayerInfo[playerid][pHandyVer], PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z], PlayerInfo[playerid][pCarLic], PlayerInfo[playerid][pNewLic], PlayerInfo[playerid][p_id]);
mysql_pquery(handle, query);
format(query, sizeof(query), "UPDATE `users` SET `FlyLic`='%d', `BoatLic`='%d', `FishLic`='%d', `GunLic`='%d', `LKWLic`='%d', `RollerLic`='%d', `Taxischein`='%d' \
, `MotoLic`='%d', `Abschlepperschein`='%d' , `Zig`='%d', `Kekse`='%d' WHERE `id` = '%d'", PlayerInfo[playerid][pFlyLic], PlayerInfo[playerid][pBoatLic], PlayerInfo[playerid][pFishLic],
PlayerInfo[playerid][pGunLic], PlayerInfo[playerid][pLKWLic], PlayerInfo[playerid][pRollerLic], PlayerInfo[playerid][pTaxiLic], PlayerInfo[playerid][pMotoLic],
PlayerInfo[playerid][pAbschlepperschein], PlayerInfo[playerid][pZig], PlayerInfo[playerid][pKekse], PlayerInfo[playerid][p_id]);
mysql_pquery(handle, query);
format(query, sizeof(query), "UPDATE `users` SET `ZigSucht`='%d', `Gun1`='%d', `Gun2`='%d', `Gun3`='%d', `Gun4`='%d', `Ammo1`='%d', `Ammo2`='%d' \
, `Ammo3`='%d', `Ammo4`='%d' , `Mulltime`='%d' WHERE `id` = '%d'", PlayerInfo[playerid][pZigSucht], PlayerInfo[playerid][pGun1],
PlayerInfo[playerid][pGun2], PlayerInfo[playerid][pGun3], PlayerInfo[playerid][pGun4], PlayerInfo[playerid][pAmmo1], PlayerInfo[playerid][pAmmo2],
PlayerInfo[playerid][pAmmo3], PlayerInfo[playerid][pAmmo4], PlayerInfo[playerid][pMulltime], PlayerInfo[playerid][p_id]);
mysql_pquery(handle, query);
format(query, sizeof(query), "UPDATE `users` SET `PayDay`='%d', `PayDayHad`='%d', `CDPlayer`='%d', `Wins`='%d', `Loses`='%d', `AlcoholPerk`='%d'\
, `DrugPerk`='%d', `MiserPerk`='%d', `PainPerk`='%d', `TraderPerk`='%d', `Tutorial`='%d', `Warnings`='%d', `Adjustable`='%d', `Fuel`='%d' WHERE `id` = '%d'",
PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pPayDayHad], PlayerInfo[playerid][pCDPlayer], PlayerInfo[playerid][pWins], PlayerInfo[playerid][pLoses], PlayerInfo[playerid][pAlcoholPerk],
PlayerInfo[playerid][pDrugPerk], PlayerInfo[playerid][pMiserPerk], PlayerInfo[playerid][pPainPerk], PlayerInfo[playerid][pTraderPerk], PlayerInfo[playerid][pTut], PlayerInfo[playerid][pWarns], PlayerInfo[playerid][pAdjustable],
PlayerInfo[playerid][pFuel], PlayerInfo[playerid][p_id]);
mysql_pquery(handle, query);
format(query, sizeof(query), "UPDATE `users` SET `Married`='%d', `MarriedTo`='%s', `WantedLevel`='%d', `WantedPoints`='%d', `PlayMinutes`='%d', `GesamtMinutes`='%d', `MinutesSinceAn`='%d' \
, `SFPASS`='%d', `LVPASS`='%d', `Offflucht`='%d', `Knast`='%d', `Handy`='%d', `Uhr`='%d' WHERE `id`='%d'",PlayerInfo[playerid][pMarried], PlayerInfo[playerid][pMarriedTo], WantedLevel[playerid],
WantedPoints[playerid], PlayerInfo[playerid][pPlayMinutes], PlayerInfo[playerid][pGesamtMinutes], PlayerInfo[playerid][pMinutesSinceAn],
PlayerInfo[playerid][pSFPASS], PlayerInfo[playerid][pLVPASS], OfflineFlucht[playerid], Knast[playerid], PlayerInfo[playerid][pHandyID], PlayerInfo[playerid][pUhrID], PlayerInfo[playerid][p_id]);
mysql_pquery(handle, query);
format(query, sizeof(query), "UPDATE `users` SET `KnastTime`='%d', `Perso`='%d', `FrakSperre`='%d', `Gehalt`='%d' \
, `InvWeapon`='%d', `InvAmmo`='%d', `InvWeapon2`='%d', `InvAmmo2`='%d', `InvMats`='%d', `InvDrugs`='%d', `FlugTime`='%d', `TruckTime`='%d', `FarmTime`='%d', `GDeaths`='%d', `JobLevel`='%d', `FarmerLimit`='%d' WHERE `id` = '%d'",
KnastTime[playerid], PlayerInfo[playerid][pOwnPerso], PlayerInfo[playerid][pFrakSperre], PlayerInfo[playerid][pGehalt], PlayerInfo[playerid][pInvWeapon], PlayerInfo[playerid][pInvAmmo],
PlayerInfo[playerid][pInvWeapon2], PlayerInfo[playerid][pInvAmmo2], PlayerInfo[playerid][pInvMats], PlayerInfo[playerid][pInvDrugs], PlayerInfo[playerid][pFlugTime], PlayerInfo[playerid][pTruckTime],
PlayerInfo[playerid][pFarmTime], PlayerInfo[playerid][pGDeaths],PlayerInfo[playerid][pJobLevel],PlayerInfo[playerid][FarmerLimit], PlayerInfo[playerid][p_id]);
mysql_pquery(handle, query);
format(query, sizeof(query), "UPDATE `users` SET `GKills`='%d', `Meldung`='%d', `HatIrgenteinHome`='%d', `Pin`='%d' \
, `Bombe`='%d', `Guertel`='%d', `SpawnChange`='%d', `HotelLS`='%d', `HotelSF`='%d', `HotelLV`='%d', `CarPunkt`='%d', `BikePunkt`='%d', `Kanister`='%d', `KreditRechnung`='%d', `jobkuendigen`='%d' WHERE `id` = '%d'",
PlayerInfo[playerid][pGKills], PlayerInfo[playerid][pMeldung], PlayerInfo[playerid][pHatIrgenteinHome], PlayerInfo[playerid][pPin], PlayerInfo[playerid][pBombe], PlayerInfo[playerid][pGuertel],
PlayerInfo[playerid][pSpawnChange], PlayerInfo[playerid][plseingemietet], PlayerInfo[playerid][psfeingemietet], PlayerInfo[playerid][plveingemietet], PlayerInfo[playerid][pCarP], PlayerInfo[playerid][pBikeP],
PlayerInfo[playerid][pKanister], PlayerInfo[playerid][pKreditRechnung],PlayerInfo[playerid][pjobkuendigen], PlayerInfo[playerid][p_id]);
mysql_pquery(handle, query);
format(query, sizeof(query), "UPDATE `users` SET `Tot`='%d', `Neulingsvip`='%d', `Maske`='%d', `Waschen`='%d', `Waschgeld`='%d', `C4`='%d', `Dietrich`='%d', `InvDietrich`='%d', `Donatortime`='%d', `Verdienst`='%d', `BusSkill`='%d', `CarRepairPacks`='%d' WHERE `id` = '%d'",
PlayerInfo[playerid][pDonatortime], PlayerInfo[playerid][pJobgeld], PlayerInfo[playerid][pBusSkill], PlayerInfo[playerid][pCarRepairPacks], PlayerInfo[playerid][pTot], PlayerInfo[playerid][pneulingsvip], PlayerInfo[playerid][pmaske], PlayerInfo[playerid][pGeldwasch], PlayerInfo[playerid][pWaschgeld],
PlayerInfo[playerid][pC4], PlayerInfo[playerid][pDietrich], PlayerInfo[playerid][pInvDietrich], PlayerInfo[playerid][p_id]);
mysql_pquery(handle, query);
new weapon[14];
new ammo[14];
for(new i = 1;i< 14;i++) {
new tmpstring[1024];
GetPlayerWeaponData(playerid, i, weapon[i-1], ammo[i-1]);
format(tmpstring,sizeof tmpstring, "UPDATE `users` SET `waffenslot%d`='%d', `ammoslot%d`='%d' WHERE `id`='%d'",i, weapon[i-1], i, ammo[i-1], PlayerInfo[playerid][p_id]);
mysql_pquery(handle, tmpstring);
}
}
return 1;
}MFG Paddy87
