02.07.2015, 14:35
I'm using mysql script. But I have some error at cmd Can They Help Me?
Error:
Line:
Error:
PHP код:
[02/07/2015 17:26:38] ==========================================
[02/07/2015 17:26:38] | |
[02/07/2015 17:26:38] | A new version (v3.09.0684) of YSI is |
[02/07/2015 17:26:38] | available from: |
[02/07/2015 17:26:38] | |
[02/07/2015 17:26:38] | www.y-less.com/YSI/YSI_1.0.zip |
[02/07/2015 17:26:38] | |
[02/07/2015 17:26:38] | Changelog: |
[02/07/2015 17:26:38] | |
[02/07/2015 17:26:38] | 1.04.0000: |
[02/07/2015 17:26:38] | |
[02/07/2015 17:26:38] | RC 1 for YSI 3.0. Available from: |
[02/07/2015 17:26:38] | http://www.y-less.com/YSI/YSI_3.0.rar |
[02/07/2015 17:26:38] | - includes MANY new libraries and |
[02/07/2015 17:26:38] | fixes, see |
[02/07/2015 17:26:38] | http://forum.sa-mp.com/showthread.php? |
[02/07/2015 17:26:38] | p=1425938 for more information, with |
[02/07/2015 17:26:38] | more topics and updates due over the |
[02/07/2015 17:26:38] | next few weeks. In brief: Added |
[02/07/2015 17:26:38] | "y_inline", "y_text", "y_users", |
[02/07/2015 17:26:38] | "y_uvar", "y_svar", "y_remote"; |
[02/07/2015 17:26:38] | updated "y_timers", "y_iter"; MANY |
[02/07/2015 17:26:38] | MANY fixes and tweaks in almost every |
[02/07/2015 17:26:38] | other library. |
[02/07/2015 17:26:38] | |
[02/07/2015 17:26:38] | 3.00.0000: |
[02/07/2015 17:26:38] | |
[02/07/2015 17:26:38] | YSI 3.0 released! Now includes the |
[02/07/2015 17:26:38] | "y_text" library for better messages, |
[02/07/2015 17:26:38] | and a reworked "y_classes" library. |
[02/07/2015 17:26:38] | Largely documented here |
[02/07/2015 17:26:38] | "http://forum.sa-mp.com/showthread.php |
[02/07/2015 17:26:38] | ?t=321092". |
[02/07/2015 17:26:38] | |
[02/07/2015 17:26:38] | 3.01.0002: |
[02/07/2015 17:26:38] | |
[02/07/2015 17:26:38] | Small fixes to "y_text" and |
[02/07/2015 17:26:38] | "y_classes". |
[02/07/2015 17:26:38] | |
[02/07/2015 17:26:38] | 3.09.0684: |
[02/07/2015 17:26:38] | |
[02/07/2015 17:26:38] | Reverted to old download location. |
[02/07/2015 17:26:38] | Improved (and fixed) version checks; |
[02/07/2015 17:26:38] | added y_bitmap, y_areas, y_races, |
[02/07/2015 17:26:38] | y_zonenames, better documentation; |
[02/07/2015 17:26:38] | MANY other bug fixes - see the github |
[02/07/2015 17:26:38] | repository for more details: |
[02/07/2015 17:26:38] | |
[02/07/2015 17:26:38] ==========================================
[02/07/2015 17:26:38]
[02/07/2015 17:26:38] errorid: 1651 | Hata: Query cache is disabled; restart the server with query_cache_type=1 to enable it | callback: OnQueryFinish | query: set session query_cache_type=0; | connection handle: 1 | resultid: 1 | extraid: 0
[02/07/2015 17:27:28] [connection] 127.0.0.1:64446 requests connection cookie.
[02/07/2015 17:27:29] Incoming connection: 127.0.0.1:64446 id: 0
[02/07/2015 17:27:29] [join] Arthur_Steve has joined the server (0:127.0.0.1)
[02/07/2015 17:27:40] errorid: 1064 | Hata: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ID = 82' at line 1 | callback: OnQueryFinish | query: UPDATE players SET SMSLog = 0, TriageTime = 0, Married = 0, MarriedTo = 'Nobody', Flag = '', ReferredBy = '0', RefTokens = 0, RefTokensOffline = 0, Helper = 0, GangMod = 0, LiveBanned = 0, WHERE ID = 82 | connection handle: 1 | resultid: 10 | extraid: 0
[02/07/2015 17:27:51] [part] Arthur_Steve has left the server (0:1)
[02/07/2015 17:27:52] errorid: 1064 | Hata: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ID = 82' at line 1 | callback: OnQueryFinish | query: UPDATE players SET SMSLog = 0, TriageTime = 0, Married = 0, MarriedTo = 'Nobody', Flag = '', ReferredBy = '0', RefTokens = 0, RefTokensOffline = 0, Helper = 0, GangMod = 0, LiveBanned = 0, WHERE ID = 82 | connection handle: 1 | resultid: 10 | extraid: 0
[02/07/2015 17:28:16] [connection] 127.0.0.1:64447 requests connection cookie.
[02/07/2015 17:28:17] Incoming connection: 127.0.0.1:64447 id: 0
[02/07/2015 17:28:18] [join] Alessio_Giani_Alfio has joined the server (0:127.0.0.1)
[02/07/2015 17:30:24] [part] Alessio_Giani_Alfio has left the server (0:1)
[02/07/2015 17:30:25] errorid: 1064 | Hata: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ID = 67' at line 1 | callback: OnQueryFinish | query: UPDATE players SET SMSLog = 0, TriageTime = 0, Married = 0, MarriedTo = 'Nobody', Flag = '', ReferredBy = '0', RefTokens = 0, RefTokensOffline = 0, Helper = 0, GangMod = 0, LiveBanned = 0, WHERE ID = 67 | connection handle: 1 | resultid: 10 | extraid: 0
PHP код:
format(szQuery, sizeof(szQuery), "UPDATE players SET SMSLog = %d, TriageTime = %d, Married = %d, MarriedTo = '%s', Flag = '%s', ReferredBy = '%s', RefTokens = %d, RefTokensOffline = %d, Helper = %d, GangMod = %d, LiveBanned = %d, WHERE ID = %d",
PlayerInfo[extraid][pSmslog], PlayerInfo[extraid][pTriageTime], PlayerInfo[extraid][pMarried], szMarriedTo, szFlag, szReferredBy, PlayerInfo[extraid][pRefTokens], PlayerInfo[extraid][pRefTokensOffline], PlayerInfo[extraid][pHelper],
PlayerInfo[extraid][pGangMod], PlayerInfo[extraid][pLiveBanned], PlayerInfo[extraid][pID]);
