15.11.2011, 19:14
Hi Guyґs my sql code donґt save i have the string on 5.000 and edit the Savecode hereґs:
Whatґs Wrong on this Code?
Код:
function SaveAccount(playerid) {
GetPlayerPos(playerid, SpielerInfo[playerid][Spawn][0],SpielerInfo[playerid][Spawn][1],SpielerInfo[playerid][Spawn][2]);
GetPlayerFacingAngle(playerid, SpielerInfo[playerid][Spawn][3]);
SpielerInfo[playerid][InteriorSpawn] = GetPlayerInterior(playerid);
SpielerInfo[playerid][WorldSpawn] = GetPlayerVirtualWorld(playerid);
new Query[5000];
format(Query,sizeof(Query),"UPDATE spieler SET AdminLevel='%i',Money='%i',Bank='%i',Faction='%i',Rank='%i',HouseKey='%i',BizKey='%i',Skin='%i', \
Spawn1='%f',Spawn2='%f',Spawn3='%f',Spawn4='%f',Spawn5='%i',Reg='%i' WHERE Name='%s'",SpielerInfo[playerid][AdminLevel],GetPlayerCash(playerid),SpielerInfo[playerid][Bank],
SpielerInfo[playerid][Faction],SpielerInfo[playerid][Rank],SpielerInfo[playerid][HouseKey],
SpielerInfo[playerid][BizKey],GetPlayerSkin(playerid),SpielerInfo[playerid][Spawn][0],SpielerInfo[playerid][Spawn][1],SpielerInfo[playerid][Spawn][2],SpielerInfo[playerid][Spawn][3],
SpielerInfo[playerid][InteriorSpawn],SpielerInfo[playerid][Reg],GetUserName(playerid));
printf(Query);
mysql_query(Query);
mysql_store_result();
format(Query,sizeof(Query),"UPDATE spieler SET Sex='%i',Wallet='%i',Renting='%i',Products='%i',PhoneNumber='%i',Minutes='%i',Spawn6='%i',Arrested='%i',Prisoned='%i', \
Jailed='%i',JailTime='%i',Cell='%i',Towe='%i',License='%i',Linked='%i',ForumName='%s' WHERE Name='%s'",SpielerInfo[playerid][Sex],GetPlayerWalletCash(playerid),SpielerInfo[playerid][Renting],SpielerInfo[playerid][Products],
SpielerInfo[playerid][PhoneNumber],SpielerInfo[playerid][Minutes],SpielerInfo[playerid][WorldSpawn],SpielerInfo[playerid][Arrested],SpielerInfo[playerid][Prisoned],SpielerInfo[playerid][Jailed],
SpielerInfo[playerid][JailTime],SpielerInfo[playerid][Cell],SpielerInfo[playerid][Towe],SpielerInfo[playerid][License], SpielerInfo[playerid][Linked], SpielerInfo[playerid][ForumName],GetUserName(playerid));
printf(Query);
mysql_query(Query);
mysql_store_result();
format(Query,sizeof(Query),"UPDATE spieler SET ForumPassword='%s',wLicense='%i',Job='%i',Donator='%i',CarParts='%i',PlayingTime='%i',FightingStyle='%i', \
Materials='%i',GesuchtLevel='%i' WHERE Name='%s'",SpielerInfo[playerid][ForumPassword],SpielerInfo[playerid][wLicense],SpielerInfo[playerid][pJob], SpielerInfo[playerid][Donator], SpielerInfo[playerid][CarParts], SpielerInfo[playerid][PlayingTime],
SpielerInfo[playerid][FightingStyle],SpielerInfo[playerid][Materials],GetPlayerWantedLevel(playerid),GetUserName(playerid));
printf(Query);
mysql_query(Query);
mysql_store_result();
mysql_free_result();
format(Query, sizeof(Query), "UPDATE enrolled SET Classes=%i WHERE Name = '%s'", SpielerInfo[playerid][Classes],
GetUserName(playerid));
mysql_query(Query);
mysql_store_result();
format(Query, sizeof(Query), "UPDATE scholarships SET Psychology=%i,Criminal_Justice=%i,Medicine=%i WHERE Name = '%s'", UniversityData[playerid][Psychology], UniversityData[playerid][Criminal_Justice],
UniversityData[playerid][Medicine],GetUserName(playerid));
mysql_query(Query);
mysql_store_result();
format(Query, sizeof(Query), "UPDATE drugs SET Cocaine=%i,Crack=%i,Heroin=%i,Hydrocodone=%i,\
Inhalants=%i,LSD=%i,Marijuana=%i,MDMA=%i,Methamphetamine=%i,Anabolic_Steroids=%i,Needles=%i,Blunts=%i WHERE Name = '%s'",
PlayerDrugData[playerid][Cocaine],PlayerDrugData[playerid][Crack],PlayerDrugData[playerid][Heroin],PlayerDrugData[playerid][Hydrocodone],
PlayerDrugData[playerid][Inhalants],PlayerDrugData[playerid][LSD],PlayerDrugData[playerid][Marijuana],PlayerDrugData[playerid][MDMA],
PlayerDrugData[playerid][Methamphetamine],PlayerDrugData[playerid][Anabolic_Steroids],PlayerDrugData[playerid][Needles],PlayerDrugData[playerid][Blunts],GetUserName(playerid));
mysql_query(Query);
mysql_store_result();
format(Query, sizeof(Query), "UPDATE Settings SET Turfs=%i,SAN=%i,Phone=%i,Room=%i WHERE Name = '%s'", PlayerSettingsData[playerid][TurfTog], PlayerSettingsData[playerid][SANTog],
PlayerSettingsData[playerid][PhoneTog], PlayerSettingsData[playerid][RoomTog],GetUserName(playerid));
mysql_query(strring);
mysql_store_result();
mysql_free_result();
SavePlayerWeapons(playerid);
SavePlayerWeaponsAmmo(playerid);
}

