[ColdRain]

Here i got problem in mysql like everything work when i register my name come in the DataBase

but when i use gmx in my server to restart it its say for me register again help me

[Mandrakke]

without the codes we can not do anything.

[ColdRain]

What codes should i give there is 1 million codes!

[Mandrakke]

perhaps the codes who makes the register and login functions?

in advance, put it anywhere in to your script;

pawn Код:

public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle)
{
    printf("%d %s %d %d %s %s %d", errorid, error, resultid, extraid, callback, query, connectionHandle);
    return 1;
}

and paste here the console output.

[Shabi RoxX]

Use mysql_close(); in OnGameModeInt();

Best way is to make a cmd save your data and settimer to restart server and Mysql_close();


An example :

pawn Код:

CMD:gmx(playerid,params[])
{
    if(GetP_VarInt(playerid,p_Adminlevel)  > 4)
    {
        foreach(Player,i)
        {
            UpdatePlayer(i);
        }
        SendClientMessageToAll(C_WHITE,"Server Restarting in 1 minutes for Maintenance.");
        TogglePlayerControllable(playerid, 0);
        DeleteAllTextDraws();
        SetTimer("RestartServer",12000,false);
    }
    return 1;
}
public RestartServer()
{
    mysql_close();
    GameTextForAll("~w~Server ReStarting",2000,0);
    SendRconCommand("gmx");
    return 1;
}

[Mandrakke]

I have sure that mysql_close() missing is not the source of the problem, once that function is not really necessary. My server uses MySQL and don't have mysql_close() in any callback or function (because the MySQL connection is in an FS and if I reload it with mysql_close(), the server crashes) and it works fine.

[ColdRain]

i got mysql_close also i try the OnQueryError No Problems Found

[ColdRain]

Hey i solve my problem but i got other problem

how i can make this ---> DrugHouseOwner[i]=dUserINT(PlayerName(i)).("DrugHouseOwner");

to mysql help me please