[Stevolas]

Quote:

Originally Posted by Sascha at which part should the function be called? I didn't find a line that actually calls the function

Under OnDialogResponse. Right here

pawn Код:

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    if(dialogid == LOGIN_DIALOG)
    {
        if(!response) return Kick(playerid);
        if(strcmp(inputtext, PlayerInfo[playerid][pPass], true) == 0)
        {
            SetSpawnInfo(playerid, 0, PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pPosX], PlayerInfo[playerid][pPosY], PlayerInfo[playerid][pPosZ], PlayerInfo[playerid][pAngle], 0, 0, 0, 0, 0, 0);
            SpawnPlayer(playerid);

            new string[64];
            format(string, sizeof(string), "{8080FF}UnknownRP: {FFFFFF}Welcome back, %s!", GetName(playerid));
            SendClientMessage(playerid, COLOR_WHITE, string);
            mysql_format(sqldb, query, sizeof(query), "SELECT * FROM vehicles WHERE owner = '%e' LIMIT 2", GetName(playerid));
            mysql_tquery(sqldb, query, "VehicleCheck", "i", playerid);
        }
        else
        {
            ShowPlayerDialog(playerid, LOGIN_DIALOG, DIALOG_STYLE_PASSWORD, "Login", "Wrong password! Try again!", "Login", "Disconnect");
        }
        return 1;
    }

Quote:

Originally Posted by gtakillerIV pawn Код: stock SavePlayer(playerid) {     mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET adminlevel ='%d' WHERE accname ='%e'", PlayerInfo[playerid][pAdmin], GetName(playerid));     mysql_query(sqldb, query);     //     new Float: x, Float: y, Float: z, Float: angle;     GetPlayerPos(playerid, x, y, z);     GetPlayerFacingAngle(playerid, angle);         mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET posx ='%f' WHERE accname ='%e'", x, GetName(playerid));     mysql_query(sqldb, query);         mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET posy ='%f' WHERE accname ='%e'", y, GetName(playerid));     mysql_query(sqldb, query);         mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET posz ='%f' WHERE accname ='%e'", z, GetName(playerid));     mysql_query(sqldb, query);         mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET angle ='%f' WHERE accname ='%e'", angle, GetName(playerid));     mysql_query(sqldb, query);     //     mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET skin ='%d' WHERE accname ='%e'", GetPlayerSkin(playerid), GetName(playerid));     mysql_query(sqldb, query);         mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET faction ='%d' WHERE accname ='%e'", PlayerInfo[playerid][pFaction], GetName(playerid));     mysql_query(sqldb, query);         mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET division ='%d' WHERE accname ='%e'", PlayerInfo[playerid][pDivision], GetName(playerid));     mysql_query(sqldb, query);         mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET rank ='%d' WHERE accname ='%e'", PlayerInfo[playerid][pRank], GetName(playerid));     mysql_query(sqldb, query);     return 1; } Just why? You can run just 1 query. Use strcat to append the other parts of the query. Would be nice if you also showed us the MySQL debug log.

I haven't used mysql in a while and wanted to learn how to do it differently (with the newest releases and features). I downloaded a basic script and edited it myself a little. However, understand what you are talking about.