MySQL Donґt save - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Donґt save (/showthread.php?tid=297396)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Donґt save (/showthread.php?tid=297396)
MySQL Donґt save - AirPlus - 15.11.2011
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);
}
Re: MySQL Donґt save - BlackWolf120 - 15.11.2011
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?
Re: MySQL Donґt save - AirPlus - 15.11.2011
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.
Re: MySQL Donґt save - TheArcher - 15.11.2011
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.
Re: MySQL Donґt save - AirPlus - 15.11.2011
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
Код:
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();
Re: MySQL Donґt save - BlackWolf120 - 15.11.2011
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);
Re: MySQL Donґt save - AirPlus - 15.11.2011
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();
Re: MySQL Donґt save - BlackWolf120 - 15.11.2011
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.
Re: MySQL Donґt save - AirPlus - 15.11.2011
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);
Donґt save anything with this Code...
Re : Re: MySQL Donґt save - decondelite - 15.11.2011
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. |