[IndependentGaming]

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

Server Debug log

Код:

[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 )

Public Login

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;
} 


[SymonClash]

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.