[AarabMoney]

I've started using the MySQL plugin R7 From BlueG for a while now in my gamemode and I've been able to use it properly un til I came across a few things that caused my server to crash. One function and one callback basically that killed my gamemode.

One of them was mysql_format, whenever I used %e in the string to protect the variables with mysql_real_escape_string, it caused the server to crash, but when I changed %e to %s it worked like a charm. Anyway to fix this?

Second one was, whenever I placed this little piece of snippet below in my filterscript it crashes the whole server when starting up the gamemode WITH the filterscript but when I load it in through RCON it works correctly. What I try to achieve is, is that I want to be able to load this filterscript when the gamemode gets resetted or loads as well.

Код:

public OnQueryFinish(query[], resultid, extraid, connectionHandle)
{
   
    return 1;
}

I'd appreciate help here if you know what might cause the issue, if I need to post more details then please say so, thanks in advance.

[azzerking]

1st Problem

%e doesn't stand for anything in pawn.

%s stands for string
%d stands for decimal
etc

%e isn't a data type.

2nd Problem

Im not quite sure I understand, what you mean? try explaining better.

[AarabMoney]

In the second problem this is what happens.

1) I place OnQueryFinish in my filterscript and compile it with no errors.
2) I go to server.cfg adding the filterscript in.
3) I start the server and I go in-game.
4) The first thing that I'm supposed to see is a login dialog from my gamemode but it doesn't.
5) I tab out to find out that my server is not on anymore, thus crashed.

When I remove the callback OnQueryFinish from my filterscript, the whole things loads properly as it should. It also works when I go in-game without loading in the filterscript first and then call the filterscript by using /rcon loadfs filterscript

[azzerking]

Please use the crash detector and post the errors from the log file located in the sa-mp directory.

LINK >> https://sampforum.blast.hk/showthread.php?tid=262796

[Stevo127]

OnQueryFinish is not meant to be used with R7 I don't think.
You have to use mysql_function_query(); and send it to a function, created by yourself such as:

pawn Код:

mysql_function_query(connectionHandle, query, true, "OnQueryFinish", "i", playerid);

pawn Код:

forward OnQueryFinish(extraid);
public OnQueryFinish(extraid)
{
    return 1;
}

[AarabMoney]

Thanks for the help, I fixed it in a similar way as Stevo said