PDA

View Full Version : MySQL Donīt save


AirPlus
15/11/2011, 07:14 PM
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',Sp awn5='%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',Ph oneNumber='%i',Minutes='%i',Spawn6='%i',Arrested=' %i',Prisoned='%i', \
Jailed='%i',JailTime='%i',Cell='%i',Towe='%i',Lice nse='%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(player id));
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,Methamphe tamine=%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, 07:28 PM
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, 07:31 PM
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|N ULL|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, 07:32 PM
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, 07:40 PM
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',Sp awn5='%i',Reg='%i',Sex='%i',Wallet='%i',Renting='% i',Products='%i',PhoneNumber='%i',Minutes='%i',Spa wn6='%i',Arrested='%i',Prisoned='%i', \
Jailed='%i',JailTime='%i',Cell='%i',Towe='%i',Lice nse='%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, 07:45 PM
just put them into one single long query like:

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, 07:59 PM
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',Sp awn5='%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',Ph oneNumber='%i',Minutes='%i',Spawn6='%i',Arrested=' %i',Prisoned='%i', \
Jailed='%i',JailTime='%i',Cell='%i',Towe='%i',Lice nse='%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(player id));
mysql_query(Query);
mysql_store_result();
mysql_free_result();

BlackWolf120
15/11/2011, 08:04 PM
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, 08:06 PM
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',Sp awn5='%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',Ph oneNumber='%i',Minutes='%i',Spawn6='%i',Arrested=' %i',Prisoned='%i', \
Jailed='%i',JailTime='%i',Cell='%i',Towe='%i',Lice nse='%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(player id));
mysql_query(Query);

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

decondelite
15/11/2011, 08:13 PM
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.

AirPlus
15/11/2011, 08:21 PM
Can anyone help me?