Hallo Community,
ich habe ein Problem mit meinem MySQL er kann die daten nicht in der datenbank Speicher aber er hat zugriff auf die datenbank warum kann er es nicht schrieben
public OnPlayerUpdate(playerid)
{
return 1;
}
public OnPlayerAccUpdate(playerid)
{
if(gPlayerLogged[playerid] == 1)
{
CheckMySQL();
new string1[500], string2[500], string3[500], string4[500];
format(string1, sizeof(string1), "UPDATE users SET reg='%d',admin='%d',donate='%d', model='%d',warns='%d',level='%d',connecttime='%d',exp='%d',paycheck='%d',paydayhad='%d',cash='%d',account='%d',leader='%d',member='%d',rank='%d',job='%d',joblock='%d',im='%d',id='%d',contracttime='%d' WHERE name='%s'",
PlayerInfo[playerid][pReg],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pDonateRank],
PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pWarns],
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pConnectTime],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pPayCheck],
PlayerInfo[playerid][pPayDayHad],
PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pAccount],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pJobLock],
PlayerInfo[playerid][pIM],
PlayerInfo[playerid][pID],
PlayerInfo[playerid][pContractTime],
PlayerName[playerid]);
mysql_query(string1);
format(string2, sizeof(string2), "UPDATE users SET alcoholperk='%d',drugperk='%d',miserperk='%d',painperk='%d',traderperk='%d',detskill='%d',sexskill='%d',busskill='%d',lawskill='%d',mechskill='%d',jackskill='%d',carskill='%d',newsskill='%d',drugsskill='%d',cookskill='%d',fishskill='%d',carlic='%d',bikelic='%d',fishlic='%d',boatlic='%d',gunlic='%d',nitrolic='%d',lkwlic='%d',flylic='%d',drivelock='%d' WHERE name='%s'",
PlayerInfo[playerid][pAlcoholPerk],
PlayerInfo[playerid][pDrugPerk],
PlayerInfo[playerid][pMiserPerk],
PlayerInfo[playerid][pPainPerk],
PlayerInfo[playerid][pTraderPerk],
PlayerInfo[playerid][pDetSkill],
PlayerInfo[playerid][pSexSkill],
PlayerInfo[playerid][pBusSkill],
PlayerInfo[playerid][pLawSkill],
PlayerInfo[playerid][pMechSkill],
PlayerInfo[playerid][pJackSkill],
PlayerInfo[playerid][pCarSkill],
PlayerInfo[playerid][pNewsSkill],
PlayerInfo[playerid][pDrugsSkill],
PlayerInfo[playerid][pCookSkill],
PlayerInfo[playerid][pFishSkill],
PlayerInfo[playerid][pCarLic],
PlayerInfo[playerid][pBikeLic],
PlayerInfo[playerid][pFishLic],
PlayerInfo[playerid][pBoatLic],
PlayerInfo[playerid][pGunLic],
PlayerInfo[playerid][pNitroLic],
PlayerInfo[playerid][pLKWLic],
PlayerInfo[playerid][pFlyLic],
PlayerInfo[playerid][pDriveLock],
PlayerName[playerid]);
mysql_query(string2);
format(string3, sizeof(string3), "UPDATE users SET wantedlevel='%d',points='%d',jail='%d',jailtime='%d',crimes='%d',arrested='%d',wanteddeaths='%d',prisoned='%d',upgrade='%d',house='%d',renthouse='%d',biz='%d',bombbiz='%d',carkey='%d',cars='%d',carsreg='%d' WHERE name='%s'",
WantedLevel[playerid],
PlayerInfo[playerid][pPoints],
PlayerInfo[playerid][pJail],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pCrimes],
PlayerInfo[playerid][pArrested],
PlayerInfo[playerid][pWantedDeaths],
PlayerInfo[playerid][pPrisoned],
PlayerInfo[playerid][gPupgrade],
PlayerInfo[playerid][pPhousekey],
PlayerInfo[playerid][pRentHouse],
PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pBombBiz],
PlayerInfo[playerid][pCarKey],
PlayerInfo[playerid][pCars],
PlayerInfo[playerid][pCarsReg],
PlayerName[playerid]);
mysql_query(string3);
format(string4, sizeof(string4), "UPDATE users SET perso='%d',number='%d',phonebook='%d',phonesound='%d',mats='%d',drugs='%d',armor='%d',bombs='%d',fishes='%d',biggestfish='%d',spawn='%d',shealth='%f',headvalue='%d',married='%d',marriedto='%s',post1='%d',post2='%d',package1='%d',package2='%d',delivered='%d', payday='%d', firefighter='%d' WHERE name='%s'",
PlayerInfo[playerid][pPerso],
PlayerInfo[playerid][pPnumber],
PlayerInfo[playerid][pPhoneBook],
PlayerInfo[playerid][pPhoneSound],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pArmor],
PlayerInfo[playerid][pBombs],
PlayerInfo[playerid][pFishes],
PlayerInfo[playerid][pBiggestFish],
PlayerInfo[playerid][pSpawn],
PlayerInfo[playerid][pSHealth],
PlayerInfo[playerid][pHeadValue],
PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pMarriedTo],
PlayerInfo[playerid][pPost1],
PlayerInfo[playerid][pPost2],
PlayerInfo[playerid][pPackage1],
PlayerInfo[playerid][pPackage2],
PlayerInfo[playerid][pDelivered],
PlayerInfo[playerid][pPayDay],
PlayerInfo[playerid][pFireFighter],
PlayerName[playerid]);
mysql_query(string4);
}
else
{
printf("Fehler bei OnPlayerUpdate!");
}
return 1;
}
Bekomme immer diese Meldung in der Console
printf("Fehler bei OnPlayerUpdate!");
Mit Freundlichen Grüßen
Dragonfly
