public OnUserCheck(playerid)
{
    new num_rows, num_fields;
    cache_get_data(num_rows, num_fields, manomysql);
    if(num_rows == 0)
    {
        //Register
        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Registracija", "Prašome įvesti sugalvotą slaptažodį!", "Registruotis", "Išeiti");
    }
    else
    {
        //Login
        ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Prisijungimas", "Prašome įvesti slaptažodį!", "Prisijungti", "Išeiti");
    }
    return 1;
}





public OnPlayerConnect(playerid)
{
    TogglePlayerSpectating(playerid, 1);

    new vardas [MAX_PLAYER_NAME], query[64];
    GetPlayerName(playerid, vardas, sizeof(vardas));
    format(query, sizeof(query), "SELECT * FROM `user` WHERE `vardas` = '%s'", vardas);
    mysql_function_query(manomysql, query, true, "OnUserCheck", "i", playerid);
    ResetPlayerInfo(playerid);
    SetPlayerColor(playerid, 0xFFFFFF00);
}



public OnPlayerDisconnect(playerid, reason)
{
    SavePlayerInfo(playerid);
    return 1;
}






ResetPlayerInfo(playerid)
{
    sInfo[playerid][kazkas] = 0;
    sInfo[playerid][id] = 0;
    sInfo[playerid][lytis] = 0;
    sInfo[playerid][adminlevel] = 0;
    sInfo[playerid][XP] = 0;
    sInfo[playerid][pinigai] = 0;
    sInfo[playerid][skinas] = 0;
    sInfo[playerid][zskinas] = 0;
    sInfo[playerid][dskinas] = 0;
    sInfo[playerid][VIP] = 0;
    sInfo[playerid][p_x] = 0.0;
    sInfo[playerid][p_y] = 0.0;
    sInfo[playerid][p_y] = 0.0;
    sInfo[playerid][MedikuDarbas] = 0;
    sInfo[playerid][MedDirektorius] = 0;
    sInfo[playerid][MedPavaduotojas] = 0;
    sInfo[playerid][MedRangas] = 0;
    sInfo[playerid][TaxiDarbas] = 0;
    sInfo[playerid][TaxDirektorius] = 0;
    sInfo[playerid][TaxPavaduotojas] = 0;
    sInfo[playerid][TaxRangas] = 0;
    return 1;
}
SavePlayerInfo(playerid)
{
    if(sInfo[playerid][kazkas] == 0) return 1;
    sInfo[playerid][skinas] = GetPlayerSkin(playerid);
    sInfo[playerid][XP] = GetPlayerScore(playerid);
    sInfo[playerid][pinigai] = GetPlayerMoney(playerid);
    new Float:xp, Float:yp, Float:zp;
    GetPlayerPos(playerid, xp, yp, zp);
    if(xp == 0.0 && yp == 0.0 && zp == 0.0)
    {
        sInfo[playerid][p_x] = -3725.1089;
        sInfo[playerid][p_y] = -1440.9119;
        sInfo[playerid][p_z] = 4.5870;
    } else {
        sInfo[playerid][p_x] = xp;
        sInfo[playerid][p_y] = yp;
        sInfo[playerid][p_z] = zp;
    }
    if(sInfo[playerid][kazkas] == 0) return 1;
    new queryy[380];
    format(queryy, sizeof(queryy), "UPDATE `user` SET lytis='%d', XP='%d', pinigai='%d', adminlevel='%d', skinas='%d', zskinas='%d', dskinas='%d', VIP='%d', x='%f', y='%f', z='%f', MedikuDarbas='%d', MedDirektorius='%d', MedRangas='%d', MedPavaduotojas='%d', TaxiDarbas='%d', TaxDirektorius='%d', TaxRangas='%d', TaxPavaduotojas='%d' WHERE id='%d'", sInfo[playerid][lytis], sInfo[playerid][XP], sInfo[playerid][pinigai], sInfo[playerid][adminlevel], sInfo[playerid][skinas], sInfo[playerid][zskinas], sInfo[playerid][dskinas], sInfo[playerid][VIP], sInfo[playerid][p_x], sInfo[playerid][p_y], sInfo[playerid][p_z], sInfo[playerid][MedikuDarbas], sInfo[playerid][MedDirektorius], sInfo[playerid][MedRangas], sInfo[playerid][MedPavaduotojas], sInfo[playerid][TaxiDarbas], sInfo[playerid][TaxDirektorius], sInfo[playerid][TaxRangas], sInfo[playerid][TaxPavaduotojas], sInfo[playerid][id]);
    mysql_function_query(manomysql, queryy, false, "", "");

    printf(" Zaidejas atsijungdamas turėjo: %i xp ir %i pinigu.", sInfo[playerid][XP], sInfo[playerid][pinigai]);

    return 1;
}


public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    if(dialogid == DIALOG_LOGIN)
    {
        if(response)
        {
            new Vardas[MAX_PLAYER_NAME], query[256], slaptazodis[32];
            GetPlayerName(playerid, Vardas, sizeof(Vardas));
            if(strlen(inputtext) >= 0)
            {
                mysql_escape_string(inputtext, slaptazodis, manomysql);
                format(query, sizeof(query), "SELECT * FROM `user` WHERE vardas='%s' AND slaptazodis='%s'", Vardas, slaptazodis);
                TogglePlayerSpectating(playerid, false);
                SetSpawnInfo(playerid, 0, sInfo[playerid][skinas], sInfo[playerid][p_x], sInfo[playerid][p_y], sInfo[playerid][p_z], 0, 0, 0, 0, 0, 0, 0);
                SpawnPlayer(playerid);
            }
            else
            {
                SendClientMessage(playerid, RAUDONA, "Jūs nieko neįvedėte!");
                ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Prisijungimas", "Prašome įvesti slaptažodį!", "Prisijungti", "Išeiti");
            }
        }
        else
        {
            Kick(playerid);
        }
        return 1;
    }
}