MySQL Donґt save
#1

Hi Guyґs my sql code donґt save i have the string on 5.000 and edit the Savecode hereґs:
Код:
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);
}
Whatґs Wrong on this Code?
Reply


Messages In This Thread
MySQL Donґt save - by AirPlus - 15.11.2011, 19:14
Re: MySQL Donґt save - by BlackWolf120 - 15.11.2011, 19:28
Re: MySQL Donґt save - by AirPlus - 15.11.2011, 19:31
Re: MySQL Donґt save - by TheArcher - 15.11.2011, 19:32
Re: MySQL Donґt save - by AirPlus - 15.11.2011, 19:40
Re: MySQL Donґt save - by BlackWolf120 - 15.11.2011, 19:45
Re: MySQL Donґt save - by AirPlus - 15.11.2011, 19:59
Re: MySQL Donґt save - by BlackWolf120 - 15.11.2011, 20:04
Re: MySQL Donґt save - by AirPlus - 15.11.2011, 20:06
Re : Re: MySQL Donґt save - by decondelite - 15.11.2011, 20:13

Forum Jump:


Users browsing this thread: 1 Guest(s)