Login

AirPlus · 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:

Код:

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?

BlackWolf120 · 15.11.2011, 19:28

why do u use that many queries, instead of send only one long one?
Also u dont need to store/free the results and rows if ure only using the "UPDATE" query.
Did u check the log? There should be some errors logged for sure...
Also ive seen u printf the query... Does the printf display the correct data?

AirPlus · 15.11.2011, 19:31

Here it is the Log is a little bit Long:

Код:

[21:20:12] ---------------------------

[21:20:12] MySQL Debugging activated (11/15/11)

[21:20:12] ---------------------------

[21:20:12]  

[21:20:12] >> mysql_ping( Connection handle: 1 )

[21:20:12] CMySQLHandler::Ping() - Connection is still alive.

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(resultID) - Threaded query with id 1 started. (Extra ID: -1)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(resultID) - Threaded query with id 4 started. (Extra ID: -1)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(resultID) - Threaded query with id 5 started. (Extra ID: -1)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(resultID) - Threaded query with id 6 started. (Extra ID: -1)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(resultID) - Threaded query with id 8 started. (Extra ID: -1)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(resultID) - Threaded query with id 7 started. (Extra ID: -1)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::ProcessQueryThread(SELECT * FROM Vehicles) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[21:20:12] CMySQLHandler::Query(resultID) - Threaded query with id 9 started. (Extra ID: -1)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(resultID) - Threaded query with id 10 started. (Extra ID: -1)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(resultID) - Threaded query with id 11 started. (Extra ID: -1)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(resultID) - Threaded query with id 12 started. (Extra ID: -1)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(resultID) - Threaded query with id 13 started. (Extra ID: -1)

[21:20:12] OnQueryFinish(1,"SELECT * FROM Vehicles") - Called.

[21:20:12] >> mysql_store_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::StoreResult() - Result was stored.

[21:20:12] >> mysql_fetch_row_format( Connection handle: 1 )

[21:20:12] CMySQLHandler::FetchRow() - Return: 0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|WayNe TraiiN|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0

[21:20:12] >> mysql_num_rows( Connection handle: 1 )

[21:20:12] CMySQLHandler::NumRows() - Returned 3 row(s)

[21:20:12] CMySQLHandler::ProcessQueryThread(SELECT * FROM Mapicons) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[21:20:12] OnQueryFinish(4,"SELECT * FROM Mapicons") - Called.

[21:20:12] >> mysql_store_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::StoreResult() - Result was stored.

[21:20:12] >> mysql_fetch_row_format( Connection handle: 1 )

[21:20:12] >> mysql_free_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::FreeResult() - Result was successfully free'd.

[21:20:12] CMySQLHandler::ProcessQueryThread(SELECT * FROM OOCRooms) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[21:20:12] OnQueryFinish(5,"SELECT * FROM OOCRooms") - Called.

[21:20:12] >> mysql_store_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::StoreResult() - Result was stored.

[21:20:12] >> mysql_num_rows( Connection handle: 1 )

[21:20:12] CMySQLHandler::NumRows() - Returned 0 row(s)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_query( Connection handle: 1 )

[21:20:12] CMySQLHandler::Query(INSERT INTO OOCRooms (Owned, Locked, Owner, Password, Owner) VALUES(0,0,'None','None', 'None')) - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_fetch_row_format( Connection handle: 1 )

[21:20:12] CMySQLHandler::FetchRow() - An error has occured. (Error ID: 1110, Column 'Owner' specified twice)

[21:20:12] >> mysql_free_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::FreeResult() - Result was successfully free'd.

[21:20:12] CMySQLHandler::ProcessQueryThread(SELECT * FROM Gas_Stations) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[21:20:12] OnQueryFinish(6,"SELECT * FROM Gas_Stations") - Called.

[21:20:12] >> mysql_store_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::StoreResult() - Result was stored.

[21:20:12] >> mysql_fetch_row_format( Connection handle: 1 )

[21:20:12] >> mysql_free_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::FreeResult() - Result was successfully free'd.

[21:20:12] CMySQLHandler::ProcessQueryThread(SELECT * FROM Businesses) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[21:20:12] OnQueryFinish(8,"SELECT * FROM Businesses") - Called.

[21:20:12] >> mysql_store_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::StoreResult() - Result was stored.

[21:20:12] >> mysql_fetch_row_format( Connection handle: 1 )

[21:20:12] CMySQLHandler::FetchRow() - Return: NULL|1316|-898|40|NULL|NULL|NULL|NULL|302322|None|NULL|NULL|NULL|NULL|NULL|NULL|NULL

[21:20:12] >> mysql_num_rows( Connection handle: 1 )

[21:20:12] CMySQLHandler::NumRows() - Returned 1 row(s)

[21:20:12] >> mysql_fetch_row_format( Connection handle: 1 )

[21:20:12] >> mysql_free_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::FreeResult() - Result was successfully free'd.

[21:20:12] CMySQLHandler::ProcessQueryThread(SELECT * FROM Houses) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[21:20:12] OnQueryFinish(7,"SELECT * FROM Houses") - Called.

[21:20:12] >> mysql_store_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::StoreResult() - Result was stored.

[21:20:12] >> mysql_fetch_row_format( Connection handle: 1 )

[21:20:12] >> mysql_free_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::FreeResult() - Result was successfully free'd.

[21:20:12] CMySQLHandler::ProcessQueryThread(SELECT * FROM Buildings) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[21:20:12] OnQueryFinish(9,"SELECT * FROM Buildings") - Called.

[21:20:12] >> mysql_store_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::StoreResult() - Result was stored.

[21:20:12] >> mysql_fetch_row_format( Connection handle: 1 )

[21:20:12] >> mysql_free_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::FreeResult() - Result was successfully free'd.

[21:20:12] CMySQLHandler::ProcessQueryThread(SELECT * FROM Factions) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[21:20:12] OnQueryFinish(10,"SELECT * FROM Factions") - Called.

[21:20:12] >> mysql_store_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::StoreResult() - Result was stored.

[21:20:12] >> mysql_fetch_row_format( Connection handle: 1 )

[21:20:12] >> mysql_free_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::FreeResult() - Result was successfully free'd.

[21:20:12] CMySQLHandler::ProcessQueryThread(SELECT * FROM Dorms) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[21:20:12] OnQueryFinish(11,"SELECT * FROM Dorms") - Called.

[21:20:12] >> mysql_store_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::StoreResult() - Result was stored.

[21:20:12] >> mysql_fetch_row_format( Connection handle: 1 )

[21:20:12] >> mysql_free_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::FreeResult() - Result was successfully free'd.

[21:20:12] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[21:20:12] CMySQLHandler::ProcessQueryThread(SELECT * FROM GangZones) - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[21:20:12] OnQueryFinish(13,"SELECT * FROM GangZones") - Called.

[21:20:12] >> mysql_store_result( Connection handle: 1 )

[21:20:12] CMySQLHandler::StoreResult() - Result was stored.

[21:20:12] >> mysql_fetch_row_format( Connection handle: 1 )

[21:21:18] >> mysql_ping( Connection handle: 1 )

[21:21:18] CMySQLHandler::Ping() - Connection is still alive.

[21:22:25] >> mysql_ping( Connection handle: 1 )

[21:22:25] CMySQLHandler::Ping() - Connection is still alive.

[21:23:32] >> mysql_ping( Connection handle: 1 )

[21:23:32] CMySQLHandler::Ping() - Connection is still alive.

[21:24:39] >> mysql_ping( Connection handle: 1 )

[21:24:39] CMySQLHandler::Ping() - Connection is still alive.

[21:25:45] >> mysql_ping( Connection handle: 1 )

[21:25:45] CMySQLHandler::Ping() - Connection is still alive.

[21:26:52] >> mysql_ping( Connection handle: 1 )

[21:26:52] CMySQLHandler::Ping() - Connection is still alive.

[21:27:59] >> mysql_ping( Connection handle: 1 )

[21:27:59] CMySQLHandler::Ping() - Connection is still alive.

[21:29:06] >> mysql_ping( Connection handle: 1 )

[21:29:06] CMySQLHandler::Ping() - Connection is still alive.

[21:30:12] >> mysql_ping( Connection handle: 1 )

[21:30:12] CMySQLHandler::Ping() - Connection is still alive.

[21:31:19] >> mysql_ping( Connection handle: 1 )

[21:31:19] CMySQLHandler::Ping() - Connection is still alive.

[21:32:25] >> mysql_ping( Connection handle: 1 )

[21:32:25] CMySQLHandler::Ping() - Connection is still alive.

[21:33:32] >> mysql_ping( Connection handle: 1 )

[21:33:32] CMySQLHandler::Ping() - Connection is still alive.

TheArcher · 15.11.2011, 19:32

Yup your problem is that you have to use multiple queries instead of one with many cells. Then you have to store and free the results for every query.

AirPlus · 15.11.2011, 19:40

i have Errors:

Код:

C:\Users\WayNeTraiiN\Desktop\nyrp\gamemodes\ny-rp.pwn(2537) : error 075: input line too long (after substitutions)
C:\Users\WayNeTraiiN\Desktop\nyrp\gamemodes\ny-rp.pwn(2538) : error 037: invalid string (possibly non-terminated string)
C:\Users\WayNeTraiiN\Desktop\nyrp\gamemodes\ny-rp.pwn(2538) : error 017: undefined symbol "UPDATE"
C:\Users\WayNeTraiiN\Desktop\nyrp\gamemodes\ny-rp.pwn(2538) : error 017: undefined symbol "spieler"
C:\Users\WayNeTraiiN\Desktop\nyrp\gamemodes\ny-rp.pwn(2538) : fatal error 107: too many error messages on one line

heres the Scriptcode

Код:

    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',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',ForumPassword='%s',wLicense='%i',Job='%i',Donator='%i',CarParts='%i',PlayingTime='%i', \
	FightingStyle='%i',Materials='%i',GesuchtLevel='%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],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],
	SpielerInfo[playerid][ForumPassword],SpielerInfo[playerid][wLicense],SpielerInfo[playerid][pJob], SpielerInfo[playerid][Donator], SpielerInfo[playerid][CarParts], SpielerInfo[playerid][PlayingTime],
	SpielerInfo[playerid][FightingStyle],SpielerInfo[playerid][Materials],GetUserName(playerid));
	printf(Query);
	mysql_query(Query);
	mysql_store_result();

BlackWolf120 · 15.11.2011, 19:45

just put them into one single long query like:

pawn Код:

new query[800], pname[24];//You have to adjust everything to ur needs ofc ;)
        GetPlayerName(playerid, pname, 24);
        format(query, sizeof(query), "UPDATE Table SET field1=%d, field2=%d, field3=%d, field4=%d,",field1[playerid],field2[playerid],field3[playerid],field4[playerid]);
        format(query, sizeof(query), "%s field5=%d, field6=%d, field7=%d, field8=%d,",query,field5[playerid],field6[playerid],field7[playerid],field8[playerid]);
        format(query, sizeof(query), "%s field9=%d, field10=%d WHERE name='%s'",query,field9[playerid],field10[playerid],pname);
        mysql_query(query);

AirPlus · 15.11.2011, 19:59

no it save all variables on 0
hereґs my code:

Код:

    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'",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]);
	format(Query,sizeof(Query),"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'",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]);
	format(Query,sizeof(Query),"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));
	mysql_query(Query);
	mysql_store_result();
	mysql_free_result();

BlackWolf120 · 15.11.2011, 20:04

u dont need to set up multiple queries, just set up a single one like in my example above.
U also dont need to use free_result and store_result then.

AirPlus · 15.11.2011, 20:06

itґs one Query:

Код:

    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'",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]);
//Next Part
	format(Query,sizeof(Query),"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'",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]);
//Next part
	format(Query,sizeof(Query),"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));
	mysql_query(Query);

better?
Donґt save anything with this Code...

decondelite · 15.11.2011, 20:13

Quote:

Originally Posted by BlackWolf120

u dont need to set up multiple queries, just set up a single one like in my example above.
U also dont need to use free_result and store_result then.

In case you don't know, we're forced to use several queries after each other, because having a giant string would display a memory warning when compiling.

Login
Username:
Password:	Lost Password?
	Remember me