Server crashes on joining - 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: Server crashes on joining (/showthread.php?tid=664129)
+- 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: Server crashes on joining (/showthread.php?tid=664129)
Server crashes on joining - IndependentGaming - 19.02.2019
Hello, when I start the server and I try to join it it show me welcome to the server, and before you type in your password the server crashes
Server Logs
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3.7-R2, ©2005-2015 SA-MP Team [21:31:32] filterscripts = "" (string) [19/02/2019 21:31:32] [19/02/2019 21:31:32] Server Plugins [19/02/2019 21:31:32] -------------- [19/02/2019 21:31:32] Loading plugin: crashdetect [19/02/2019 21:31:32] CrashDetect v4.16 is OK. [19/02/2019 21:31:32] Loaded. [19/02/2019 21:31:32] Loading plugin: mysql [19/02/2019 21:31:32] > MySQL plugin R6-2 successfully loaded. [19/02/2019 21:31:32] Loaded. [19/02/2019 21:31:32] Loading plugin: sscanf [19/02/2019 21:31:32] [19/02/2019 21:31:32] =============================== [19/02/2019 21:31:32] sscanf plugin loaded. [19/02/2019 21:31:32] Version: 2.8.1 [19/02/2019 21:31:32] © 2012 Alex "******" Cole [19/02/2019 21:31:32] =============================== [19/02/2019 21:31:32] Loaded. [19/02/2019 21:31:32] Loading plugin: streamer [19/02/2019 21:31:32] *** Streamer Plugin v2.8.2 by Incognito loaded *** [19/02/2019 21:31:32] Loaded. [19/02/2019 21:31:32] Loading plugin: Whirlpool [19/02/2019 21:31:32] [19/02/2019 21:31:32] ================== [19/02/2019 21:31:32] [19/02/2019 21:31:32] Whirlpool loaded [19/02/2019 21:31:32] [19/02/2019 21:31:32] ================== [19/02/2019 21:31:32] [19/02/2019 21:31:32] Loaded. [19/02/2019 21:31:32] Loaded 5 plugins. [19/02/2019 21:31:32] [19/02/2019 21:31:32] Filterscripts [19/02/2019 21:31:32] --------------- [19/02/2019 21:31:32] Loaded 0 filterscripts. [19/02/2019 21:31:38] ---------------------------------- [19/02/2019 21:31:38] Gamemode Roleplay [19/02/2019 21:31:38] ---------------------------------- [19/02/2019 21:31:38] Number of vehicle models: 115 [19/02/2019 21:32:04] [connection] 127.0.0.1:61387 requests connection cookie. [19/02/2019 21:32:05] [connection] incoming connection: 127.0.0.1:61387 id: 0 [19/02/2019 21:32:05] [join] Jeffery_Jenkens has joined the server (0:127.0.0.1) [19/02/2019 21:32:06] [debug] Server crashed while executing Gamemode.amx [19/02/2019 21:32:06] [debug] AMX backtrace: [19/02/2019 21:32:06] [debug] #0 native mysql_real_escape_string () from mysql.DLL [19/02/2019 21:32:06] [debug] #1 00200be4 in public Login (0) from Gamemode.amx [19/02/2019 21:32:07] [debug] Native backtrace: [19/02/2019 21:32:07] [debug] #0 64a21bb0 in ?? () from C:\WINDOWS\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.9415_none_508df7e2bcbccb90\MSVCR90.dll [19/02/2019 21:32:07] [debug] #1 64a04951 in ?? () from C:\WINDOWS\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.9415_none_508df7e2bcbccb90\MSVCR90.dll [19/02/2019 21:32:07] [debug] #2 64a04996 in ?? () from C:\WINDOWS\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.9415_none_508df7e2bcbccb90\MSVCR90.dll [19/02/2019 21:32:07] [debug] #3 10005b71 in ?? () from plugins\mysql.DLL [19/02/2019 21:32:07] [debug] #4 10005d7d in ?? () from plugins\mysql.DLL [19/02/2019 21:32:07] [debug] #5 10008bd8 in ?? () from plugins\mysql.DLL [19/02/2019 21:32:07] [debug] #6 10006bd6 in ?? () from plugins\mysql.DLL [19/02/2019 21:32:07] [debug] #7 004010b6 in ?? () from samp-server.exe [19/02/2019 21:32:07] [debug] #8 5bf6c6fa in ?? () from plugins\crashdetect.DLL [19/02/2019 21:32:07] [debug] #9 5bf72278 in ?? () from plugins\crashdetect.DLL [19/02/2019 21:32:07] [debug] #10 5bf6a0d7 in ?? () from plugins\crashdetect.DLL [19/02/2019 21:32:07] [debug] #11 5bf6c74a in ?? () from plugins\crashdetect.DLL [19/02/2019 21:32:07] [debug] #12 5be94509 in ?? () from plugins\streamer.DLL [19/02/2019 21:32:07] [debug] #13 00482a68 in ?? () from samp-server.exe [19/02/2019 21:32:07] [debug] #14 004912ba in ?? () from samp-server.exe
Код:
[21:31:32] [21:31:32] --------------------------- [21:31:32] MySQL Debugging activated (02/19/19) [21:31:32] --------------------------- [21:31:32] [21:31:32] >> mysql_query( Connection handle: 1 ) [21:31:32] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead) [21:32:06] >> mysql_real_escape_string( Connection handle: 1 )
PHP код:
forward Login(playerid);
public Login(playerid)
{
// Display the main menu
ShowMainMenuGUI(playerid);
ClearChatbox(playerid);
SetPlayerVirtualWorld(playerid, 0);
SetPlayerCameraPos(playerid, 2022.083740, -1308.260620, 80.478797);
SetPlayerCameraLookAt(playerid, 1970.506103, -1201.447143, 25.596593);
new
szQuery[128],
szPlayerName[MAX_PLAYER_NAME],
szPlayerName2[MAX_PLAYER_NAME];
GetPlayerName(playerid, szPlayerName, sizeof(szPlayerName));
mysql_real_escape_string(szPlayerName, szPlayerName2, g_MySQLConnections[0]);
// Check MySQL to see if any accounts exist with the specified username on login.
format(szQuery, sizeof(szQuery), "SELECT COUNT(*) FROM players WHERE Username = '%s'", szPlayerName);
mysql_query(szQuery, THREAD_CONFIRM_USERNAME, playerid, g_MySQLConnections[0]);
//ConnectionLog(playerid, PlayerInfo[playerid][pID], szPlayerName);
return 1;
}
Re: Server crashes on joining - SymonClash - 19.02.2019
Just remove mysql_real_escape_string and replace %s with '%e'.
Also i don't understand why are you doing:
new szPlayerName, szPlayerName2, but retrieving just the first szPlayerName and escaping the second.
Doesn't make sense.