[IndependentGaming]

Hello, when i start my server the server is running but when there is someone who trying to join the server is crashing and this is in my server log, i tried to upgrade the sql plugin from R5 to R7 but then my gamemode gives many errors,

PHP код:

[19/07/2015 16:20:19] Number of vehicle models: 115
[19/07/2015 16:20:49] [connection] requests connection cookie.
[19/07/2015 16:20:50] Incoming connection:  id: 0
[19/07/2015 16:20:50] [join] Koen_Brown has joined the server ()
[19/07/2015 16:20:51] [debug] Server crashed while executing SGRP.amx
[19/07/2015 16:20:51] [debug] AMX backtrace:
[19/07/2015 16:20:51] [debug] #0 native mysql_real_escape_string () [10006af0] from mysql.DLL
[19/07/2015 16:20:51] [debug] #1 001fa33c in public Login () from SGRP.amx
[19/07/2015 16:20:51] [debug] System backtrace:
[19/07/2015 16:20:51] [debug] #0 746d4951 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.8387_none_5094ca96bcb6b2bb\MSVCR90.dll
[19/07/2015 16:20:51] [debug] #1 746d4996 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.8387_none_5094ca96bcb6b2bb\MSVCR90.dll
[19/07/2015 16:20:51] [debug] #2 10005b71 in ?? () from C:\Users\Koen\Desktop/sgrp\plugins\mysql.DLL
[19/07/2015 16:20:51] [debug] #3 10005d7d in ?? () from C:\Users\Koen\Desktop/sgrp\plugins\mysql.DLL
[19/07/2015 16:20:51] [debug] #4 10008bd8 in ?? () from C:\Users\Koen\Desktop/sgrp\plugins\mysql.DLL
[19/07/2015 16:20:51] [debug] #5 10006bd6 in ?? () from C:\Users\Koen\Desktop/sgrp\plugins\mysql.DLL
[19/07/2015 16:20:51] [debug] #6 004010b6 in ?? () from C:\Users\Koen\Desktop/sgrp\samp-server.exe
[19/07/2015 16:20:51] [debug] #7 719a3c32 in ?? () from C:\Users\Koen\Desktop/sgrp\plugins\crashdetect.DLL
[19/07/2015 16:20:51] [debug] #8 719a6076 in ?? () from C:\Users\Koen\Desktop/sgrp\plugins\crashdetect.DLL
[19/07/2015 16:20:51] [debug] #9 7199c05a in ?? () from C:\Users\Koen\Desktop/sgrp\plugins\crashdetect.DLL
[19/07/2015 16:20:51] [debug] #10 719a3c5e in ?? () from C:\Users\Koen\Desktop/sgrp\plugins\crashdetect.DLL
[19/07/2015 16:20:51] [debug] #11 00481638 in ?? () from C:\Users\Koen\Desktop/sgrp\samp-server.exe
[19/07/2015 16:20:51] [debug] #12 0048ea0a in ?? () from C:\Users\Koen\Desktop/sgrp\samp-server.exe 


how to fix this ?

[BigBrainAFK]

there is a problem with the mysql_real_escape_string function in the Login() function of your script

[IndependentGaming]

Thanks, and how can i fix this problem ?

[IndependentGaming]

Quote:

Originally Posted by BigBrainAFK there is a problem with the mysql_real_escape_string function in the Login() function of your script

Do you mean this ?

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


[IndependentGaming]

i can join now but getting this

PHP код:

errorid: 1146 | error: Table 'sgrp.connections' doesn't exist | callback: OnQueryFinish | query: INSERT INTO connections (PlayerID, AccountID, Username, TimeLoggedIn) VALUES(0, 0, 'Koen_Brown', UNIX_TIMESTAMP(now())) | connection handle: 1 | resultid: 1 | extraid: 0
[19/07/2015 17:08:51] errorid: 1146 | error: Table 'sgrp.connections' doesn't exist | callback: OnQueryFinish | query: UPDATE connections SET AccountID = 162 WHERE PlayerID = 0 | connection handle: 1 | resultid: 1 | extraid: 0 


My account is not saving, i need to register everytime.

what to do ?

[IndependentGaming]

bump

[SilentSoul]

[19/07/2015 17:08:51] errorid: 1146 | error: Table 'sgrp.connections' doesn't exist | callback: OnQueryFinish | query: UPDATE connections SET AccountID = 162 WHERE PlayerID = 0 | connection handle: 1 | resultid: 1 | extraid: 0

Are you sure you've got a table called 'sgrp.connections' in your database?

[IndependentGaming]

No there is not but if i want to create it what need to be in it ?

[SilentSoul]

PlayerID, AccountID, Username, TimeLoggedIn