02.11.2012, 14:26
Hi!
I've got a little problem with MySQL.
When I start my server on Windows, it all works fine. I've got the R6 MySQL plugin. (On Windows, it says, that it's R5) But on Linux host, when I log in, the server crashes.
Here's the OnPlayerLogin code:
Windows server log:
Linux server log:
I've got a little problem with MySQL.
When I start my server on Windows, it all works fine. I've got the R6 MySQL plugin. (On Windows, it says, that it's R5) But on Linux host, when I log in, the server crashes.
Here's the OnPlayerLogin code:
Код:
public OnPlayerLogin(playerid,password[]) // by Luk0r v1.0
{
MySQLCheckConnection();
new tmp2[256];
new string2[64];
new str[128];
new
string[256]
;
new playername2[MAX_PLAYER_NAME];
new playernamesplit[3][MAX_PLAYER_NAME];
GetRPName(playerid, playername2, sizeof(playername2));
split(playername2, playernamesplit, '_');
MySQLFetchAcctSingle(KasutajaInfo[playerid][pSQLID], "Password", KasutajaInfo[playerid][pKey]);
if(!strcmp(KasutajaInfo[playerid][pKey],password, true ) )
{
new Query[1024];
new Field[64];
format(Query, sizeof(Query), "SELECT * FROM `players` WHERE `id` = '%d'", KasutajaInfo[playerid][pSQLID] );
mysql_query(Query);
mysql_store_result();
if(mysql_fetch_row_format(Query,"|"))
{
mysql_fetch_field_row(Field,"PlayerLevel"); KasutajaInfo[playerid][pLevel] = strval(Field);
mysql_fetch_field_row(Field,"AdminLevel"); KasutajaInfo[playerid][pAdmin] = strval(Field);
//A Couple of more lines.
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3e-R2, ©2005-2012 SA-MP Team [16:31:12] [16:31:12] Server Plugins [16:31:12] -------------- [16:31:12] Loading plugin: mysql [16:31:13] > MySQL plugin R5 successfully loaded. [16:31:13] Loaded. [16:31:13] Loading plugin: sscanf [16:31:13] [16:31:13] =============================== [16:31:13] sscanf plugin loaded. [16:31:13] © 2009 Alex "******" Cole [16:31:13] 0.3d-R2 500 Players "dnee" [16:31:13] =============================== [16:31:13] Loaded. [16:31:13] Loading plugin: streamer [16:31:14] *** Streamer Plugin v2.6.1 by Incognito loaded *** [16:31:14] Loaded. [16:31:14] Loading plugin: nativechecker [16:31:14] Loaded. [16:31:14] Loaded 4 plugins. [16:31:14] [16:31:14] Ban list [16:31:14] -------- [16:31:14] Loaded: samp.ban [16:31:14] [16:31:14] [16:31:14] Filterscripts [16:31:14] --------------- [16:31:14] Loading filterscript 'Kiirusehoidja.amx'... [16:31:14] Loaded 1 filterscripts. [20:21:24] MYSQL: Connecting... [20:21:24] MYSQL: Connected. [16:31:14] Gameode - On [20:38:28] _____________________________ [20:38:28] 162 cars loaded. (MySQL) [20:38:28] _____________________________ [20:38:28] 50 bikes loaded. (MySQL) [20:38:28] _____________________________ [20:38:28] 0 aCars loaded. (MySQL) [20:38:28] _____________________________ [20:38:28] 9 caravans loaded. (MySQL) [20:38:28] _____________________________ [20:38:29] 3 aHelis loaded. (MySQL) [20:38:29] _____________________________ [20:38:29] 14 boats loaded. (MySQL) [20:38:29] _____________________________ [20:38:29] 11 helis loaded. (MySQL) [20:38:29] _____________________________ [20:38:29] 39 bizzes loaded. (MySQL) [20:38:29] _____________________________ [20:38:29] 109 houses loaded. (MySQL) [20:38:29] _____________________________ [20:38:29] 5 points loaded. (MySQL) [20:38:29] _____________________________ [20:38:29] Pickups limit = 400, Pickups loaded = 4 [16:32:05] [16:32:05] Server's GM v1.0 [16:32:05] _____________________________ [16:32:05] [16:32:05] Number of vehicle models: 103 [16:32:18] Incoming connection: 192.168.1.64:51120 [16:32:19] [join] Scripter_Scripter has joined the server (0:192.168.1.64) [16:32:53] Scripter_Scripter has logged in. [16:33:37] Scripter_Scripter has left the server (Disconnected). [16:33:37] [part] Scripter_Scripter has left the server (0:1)
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3e, ©2005-2012 SA-MP Team [20:21:24] filterscripts = "" (string) [20:21:24] [20:21:24] Server Plugins [20:21:24] -------------- [20:21:24] Loading plugin: mysql.so [20:21:24] > MySQL plugin R6 successfully loaded. [20:21:24] Loaded. [20:21:24] Loading plugin: sscanf.so [20:21:24] [20:21:24] =============================== [20:21:24] sscanf plugin loaded. [20:21:24] © 2009 Alex "******" Cole [20:21:24] 0.3d-R2 500 Players "dnee" [20:21:24] =============================== [20:21:24] Loaded. [20:21:24] Loaded 2 plugins. [20:21:24] [20:21:24] Ban list [20:21:24] -------- [20:21:24] Loaded: samp.ban [20:21:24] [20:21:24] [20:21:24] Filterscripts [20:21:24] --------------- [20:21:24] Loaded 0 filterscripts. [20:21:24] MYSQL: Connecting... [20:21:24] MYSQL: Connected. [16:31:14] Gameode - On [20:38:28] _____________________________ [20:38:28] 162 cars loaded. (MySQL) [20:38:28] _____________________________ [20:38:28] 50 bikes loaded. (MySQL) [20:38:28] _____________________________ [20:38:28] 0 aCars loaded. (MySQL) [20:38:28] _____________________________ [20:38:28] 9 caravans loaded. (MySQL) [20:38:28] _____________________________ [20:38:29] 3 aHelis loaded. (MySQL) [20:38:29] _____________________________ [20:38:29] 14 boats loaded. (MySQL) [20:38:29] _____________________________ [20:38:29] 11 helis loaded. (MySQL) [20:38:29] _____________________________ [20:38:29] 39 bizzes loaded. (MySQL) [20:38:29] _____________________________ [20:38:29] 109 houses loaded. (MySQL) [20:38:29] _____________________________ [20:38:29] 5 points loaded. (MySQL) [20:38:29] _____________________________ [20:38:29] Pickups limit = 400, Pickups loaded = 4 [16:32:05] [16:32:05] Server's GM v1.0 [16:32:05] _____________________________ [20:21:27] [20:21:27] Number of vehicle models: 103 [20:22:00] Incoming connection: 90.190.220.124:56523 [20:22:00] [join] Scripter_Scripter has joined the server (0:90.190.220.124) //This is the part, where I log in and the server crashes.