format(query,sizeof(query)," %s`Perso`=%i WHERE `Id`='%i'",query,[*]PlayerInfo[playerid][pPerso],PlayerInfo[playerid][dbid]); //fehlerzeile
Zu
format(query,sizeof(query),"%s, `Perso`=%i WHERE `Id`='%i'",query,PlayerInfo[playerid][pPerso],PlayerInfo[playerid][dbid]);
ich bekomme immer diesen warning in der log
:[22:30:41] [WARNING] CMySQLConnection::Disconnect - no connection available
Dann hast du keine aktive Verbindung.
Prüfe deine Login Daten und was im Log steht, wenn die Verbindung aufgebaut wird.
@Jeffry
hier:
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team
[22:29:27] filterscripts = "" (string)
[22:29:27] weburl = "www.sa-mp.com" (string)
[22:29:27]
[22:29:27] Server Plugins
[22:29:27] --------------
[22:29:27] Loading plugin: crashdetect
[22:29:27] CrashDetect v4.15.1 is OK.
[22:29:27] Loaded.
[22:29:27] Loading plugin: jit
[22:29:27] JIT must be loaded before 'crashdetect.DLL'
[22:29:27] Failed.
[22:29:27] Loading plugin: mysql
[22:29:27] >> plugin.mysql: R39-4 successfully loaded.
[22:29:27] Loaded.
[22:29:27] Loading plugin: sscanf
[22:29:27]
[22:29:27] ===============================
[22:29:27] sscanf plugin loaded.
[22:29:27] Version: 2.8.1
[22:29:27] (c) 2012 Alex "Y_Less" Cole
[22:29:27] ===============================
[22:29:27] Loaded.
[22:29:27] Loading plugin: streamer
[22:29:27]
*** Streamer Plugin v2.7.9 by Incognito loaded ***
[22:29:27] Loaded.
[22:29:27] Loading plugin: timerfix
[22:29:27] >> TimerFix v1.5 successfully loaded.
[22:29:27] Loaded.
[22:29:27] Loading plugin: YSF
[22:29:27] logprintf = 0x0048C8D0
[22:29:27]
[22:29:27] ===============================
[22:29:27] YSF - kurta999 version R16 loaded
[22:29:27] (c) 2008 Alex "Y_Less" Cole - (c) 2010 - 2015 kurta999
[22:29:27] Server version: 0.3.7 R2-1
[22:29:27] Operating System: Windows
[22:29:27] Built on: Feb 2 2016 at 22:53:45
[22:29:27] ===============================
[22:29:27] Loaded.
[22:29:27] Loaded 6 plugins.
[22:29:28]
[22:29:28] Filterscripts
[22:29:28] ---------------
[22:29:28] Loaded 0 filterscripts.
[22:29:28] Number of vehicle models: 51
[22:29:28] [connection] 127.0.0.1:63347 requests connection cookie.
[22:29:29] [connection] incoming connection: 127.0.0.1:63347 id: 0
[22:29:29] [npc:join] Walton has joined the server (0:127.0.0.1)
[22:29:57] [connection] 127.0.0.1:60596 requests connection cookie.
[22:29:58] [connection] incoming connection: 127.0.0.1:60596 id: 1
[22:29:58] [join] DerHazeing has joined the server (1:127.0.0.1)
[22:30:32] UPDATE `Benutzerkonten` SET `Geld`=13500,`Level`=10,`Adminlevel`=5,`Geschlecht`=1,`Kleidung`=19,`Kills`=0,`Deaths`=0,`Beruf`=0,`Fuehrerschein`=1,`Flugschein`=0,`Angelschein`=0,`Waffenschein`=0,`Fightingstyle`=0,`Bootsschein`=0,`Zollpass`=0,`Motorradschein`=0 ,`Mats`=0 ,`Weed`=0 ,`Savedweed`=0 ,`Savedmats`=0 ,`Drugknollen`=0 ,`Matspakete`=0 ,`Waffengebuehr`=0 ,`Drogengebuehr`=0,`Selledmats`=0,`Selledweed`=0,`Mutezeit`=0, `Perso`=0 WHERE `Id`='9'
[22:30:32] [part] DerHazeing has left the server (1:1)
Console input: exit
[22:30:41] --- Server Shutting Down.
[22:30:41] [npc:part] Walton has left the server (0:0)
[22:30:41] plugin.mysql: Unloading plugin...
[22:30:41] plugin.mysql: Plugin unloaded.
[22:30:41]
[22:30:41] ===============================
[22:30:41] sscanf plugin unloaded.
[22:30:41] ===============================
[22:30:41]
*** Streamer Plugin v2.7.9 by Incognito unloaded ***
[22:30:41] [plugin.timerfix] Plugsin successfully unloaded!
[22:30:41]
[22:30:41] ==============
[22:30:41] YSF unloaded
[22:30:41] ==============
Poste bitte den MySQL Log (vor dem Start des Servers bitte löschen, und dann alles posten).
