#pragma semicolon 1
 
#define DEBUG
 
#define TAG " \x04//     \x02Only AWP + LvL     \x04//\x01"
#define aTAG " \x04// \x04// \x04// \x04// \x04// \x04// \x04// \x04// \x04// \x04// \x04// \x04// \x04// \x04// \x04// \x04// \x04// \x04// \x04// \x04//"
 
#include <sourcemod>
#include <sdktools>
#include <sdkhooks>
#include <cstrike>
 
#pragma newdecls required
 
char g_sWeaponsCanUse [][] =
{
    "weapon_knife",
    "weapon_awp",
};
 
int awp_requirements[20] =
{
    0,      // 1
    500,    // 2
    1200,   // 3
    2000,   // 4
    3000,   // 5
    4300,   // 6
    6600,   // 7
    8800,   // 8
    10300,  // 9
    12000,  // 10
    14000,  // 11
    17000,  // 12
    21000,  // 13
    26000,  // 14
    33000,  // 15
    42000,  // 16
    50000,  // 17
    65000,  // 18
    80000,  // 19
    100000  // 20
};
 
int awp_lvl[65];
int awp_exp[65];
int awp_punktylv[65];
int awp_zycie[65];
int awp_grawitacja[65];
int awp_predkosc[65];
int awp_dj[65];
int awp_timer[65];
 
// Pod baze danych
 
int g_iBazaSql = 0;
int g_iIsDataLoaded[65];
 
bool g_bSaveData[65];
 
Handle DB;
 
// ===============
 
public Plugin myinfo =
{
    name = "[DSH] Only AWP + LvL",
    author = "Deshayiere",
    description = "Plugin dodaje na serwer tryb Only AWP + LvL",
    version = "1.0",
    url = "https://steamcommunity.com/id/deszableble/"
};
 
public void OnPluginStart()
{
    HookEvent("player_spawn", Event_PlayerSpawn);
    CreateTimer(1.0, timerhud, _, TIMER_REPEAT);
    CreateTimer(300.0, timerautor, _, TIMER_REPEAT);
    HookEvent("player_death", Event_PlayerDeath);
    RegConsoleCmd("sm_poziom", awp_poziom);
    RegConsoleCmd("sm_lvl", awp_poziom);
    RegConsoleCmd("sm_level", awp_poziom);
    RegConsoleCmd("sm_givepoints", awp_givepoints);
    DatabaseConnect();
    for(int i = 1; i <= MaxClients; i ++)
        if(IsValidClient(i))
            OnClientPutInServer(i);
}
 
public Action timerautor(Handle timer, int client)
{
    PrintToChatAll("%s Autorem paczki AWP + LVL jest Deshayiere.", TAG);
}
 
public void OnClientPutInServer(int client)
{
    SDKHook(client, SDKHook_WeaponCanUse, WeaponCanUse);
    awp_lvl[client] = 1;
    awp_exp[client] = 0;
    awp_punktylv[client] = 0;
    awp_zycie[client] = 0;
    awp_grawitacja[client] = 0;
    awp_predkosc[client] = 0;
    awp_dj[client] = 0;
    awp_timer[client] = 0;
    PrepareLoad(client);
}
 
public void OnMapEnd()
{
    for(int i = 1; i <= MaxClients; i++)
        if(IsValidClient(i))
            PrzygotujZapisanieDanych(i);
}
 
public Action PrzygotujZapisanieDanych(int client)
{
    if(!IsValidClient(client))
    {
        return;
    }
    if (g_bSaveData[client])
    {
        SaveAll(client);
        g_bSaveData[client] = true;
    }
}
 
public void OnClientDisconnect(int client)
{
    SDKUnhook(client, SDKHook_WeaponCanUse, WeaponCanUse);
    SaveAll(client);  
}
 
public void OnMapStart()
{
    ServerCommand("sv_gravity 800");
    ServerCommand("mp_maxmoney 0");
    ServerCommand("mp_freezetime 3");
    ServerCommand("mp_timelimit 30");
    ServerCommand("mp_roundtime 3");
    ServerCommand("mp_buytime 0");
    ServerCommand("mp_warmuptime 3");
    ServerCommand("mp_t_default_secondary 0");
    ServerCommand("mp_ct_default_secondary 0");
}
 
public Action WeaponCanUse(int client, int weapon)
{
    if(!IsValidClient(client) || !IsPlayerAlive(client))
        return Plugin_Continue;
 
    char weapons[32];
    GetEdictClassname(weapon, weapons, sizeof(weapons));
   
    for(int i = 0; i < sizeof(g_sWeaponsCanUse); i ++)
    {
        if(StrEqual(g_sWeaponsCanUse[i], weapons))
            return Plugin_Continue;
    }
   
    return Plugin_Handled;
}
 
public Action awp_givepoints(int client, int args)
{
    if (GetUserFlagBits(client) && ADMFLAG_ROOT)
    {
        awp_punktylv[client] += 40;
        SaveAll(client);
    }
}
 
public Action Event_PlayerSpawn(Event event, const char[] name, bool dontBroadcast)
{
    int client = GetClientOfUserId(GetEventInt(event, "userid"));
    GivePlayerItem(client, "weapon_awp");
    SetEntProp(client, Prop_Send, "m_ArmorValue", 100);
    SetEntProp(client, Prop_Send, "m_bHasHelmet", 1);
    if (IsValidClient(client))
    {
        SetEntityHealth(client, GetClientHealth(client)+(1 * awp_zycie[client]));
        SetEntityGravity(client, GetGravity(client));
        SetEntPropFloat(client, Prop_Send, "m_flLaggedMovementValue", GetSpeed(client));
        CreateTimer(1.0, Timer_CheckSetGravity, GetClientUserId(client), TIMER_FLAG_NO_MAPCHANGE|TIMER_REPEAT);
    }
    char buffer[32];
    Format(buffer, sizeof(buffer), "[ Poziom %i ]", awp_lvl[client]);
    CS_SetClientClanTag(client, buffer);
}
 
float GetSpeed(int client)
{
    float fGetSpeed;
    fGetSpeed = (1 + (0.02*awp_predkosc[client]));
    return fGetSpeed;
}
 
float GetGravity(int client)
{
    float fGetGravity;
    fGetGravity = (1 - (0.02*awp_grawitacja[client]));
    return fGetGravity;
}
 
public Action Timer_CheckSetGravity(Handle event, int iUserid)
{
    int client = GetClientOfUserId(iUserid);
    if (awp_timer[client] == 0)
    {
        if (GetEntityGravity(client) != GetGravity(client))
        {
            SetEntityGravity(client, GetGravity(client));
        }
    }
    return Plugin_Continue;
}

public Action OnPlayerRunCmd(int client, int &buttons, int &impulse, float vel[3], float angles[3], int &weapon)
{
	if(awp_dj[client] == 1)
	{
		static int awp_fLastButtons[MAXPLAYERS + 1], awp_fLastFlags[MAXPLAYERS + 1], awp_jumps[MAXPLAYERS + 1], fCurFlags, fCurButtons;
		fCurFlags = GetEntityFlags(client);
		fCurButtons = GetClientButtons(client);
		if(awp_fLastFlags[client] & FL_ONGROUND && !(fCurFlags & FL_ONGROUND) && !(awp_fLastButtons[client] & IN_JUMP) && fCurButtons & IN_JUMP)awp_jumps[client]++;
		else if(fCurFlags & FL_ONGROUND)awp_jumps[client] = 0;
		else if(!(awp_fLastButtons[client] & IN_JUMP) && fCurButtons & IN_JUMP && awp_jumps[client] == 1)
		{
			awp_jumps[client]++;
			float vVel[3];
			GetEntPropVector(client, Prop_Data, "m_vecVelocity", vVel);
			vVel[2] = 250.0;
			TeleportEntity(client, NULL_VECTOR, NULL_VECTOR, vVel);
		}

		awp_fLastFlags[client] = fCurFlags;
		awp_fLastButtons[client] = fCurButtons;
	}
}
 
public Action timerhud(Handle timer, int client)
{
    for (int i = 1; i <= MaxClients; i++)
    {
        if (IsClientInGame(i) && !IsFakeClient(i))
        {
            PrintHintText(i, "<font color='#00ff12'>//</font> <font color='#ff0000'>Only AWP + LvL</font> <font color='#00ff12'>//</font>\n<font color='#00c0ff'>» <font color='#ff9c00'>Poziom: %i\n<font color='#00c0ff'>» <font color='#ff9c00'>Doswiadczenie: %i", awp_lvl[i], awp_exp[i]);
        }
    }
}
 
public Action Event_PlayerDeath(Event event, const char[] name, bool dontBroadcast)
{
    char weapons[65];
    char NoScopeHSInfo[256];
    char NoScopeInfo[256];
    char KnifeInfo[256];
 
    bool hs = GetEventBool(event, "headshot");
 
    int attacker = GetClientOfUserId(event.GetInt("attacker"));
    int victim = GetClientOfUserId(event.GetInt("userid"));
    int scope = GetEntProp(attacker, Prop_Send, "m_bIsScoped");
 
    GetEventString(event, "weapon", weapons, sizeof(weapons));
    if(StrEqual(weapons, "awp"))
    {
        if(hs && !scope)
        {
			awp_exp[attacker] += 40;
			PrintToChat(attacker, "%s Dostajesz 40 EXPa za \x02zabicie HS + NS \x01gracza \x04%N \x02[ \x04Poziom %i \x02]", TAG, victim, awp_lvl[victim]);
			Format(NoScopeHSInfo, sizeof(NoScopeHSInfo), "%s Gracz %N \x02[ \x04Poziom %i \x02]\x01 zabił gracza %N \x02[ \x04Poziom %i \x02]\x01 używając \x02HS + NS.", TAG, attacker, awp_lvl[attacker], victim, awp_lvl[victim]);
			PrintToChatAll(NoScopeHSInfo);
			LvlUp(attacker);
			PrepareSaveData(attacker);
			SaveAll(attacker);
        }
        else if(!hs && !scope)
        {
			awp_exp[attacker] += 30;
			PrintToChat(attacker, "%s Dostajesz 30 EXPa za \x02zabicie NS \x01gracza \x04%N \x02[ \x04Poziom %i \x02]", TAG, victim, awp_lvl[victim]);
			Format(NoScopeInfo, sizeof(NoScopeInfo), "%s Gracz %N \x02[ \x04Poziom %i \x02]\x01 zabił gracza %N \x02[ \x04Poziom %i \x02]\x01 używając \x02NS.", TAG, attacker, awp_lvl[attacker], victim, awp_lvl[victim]);
			PrintToChatAll(NoScopeInfo);
			LvlUp(attacker);
			PrepareSaveData(attacker);
			SaveAll(attacker);
        }
        else if(scope && !hs)
        {
			awp_exp[attacker] += 20;
			PrintToChat(attacker, "%s Dostajesz 20 EXPa za \x02zabicie \x01gracza \x04%N \x02[ \x04Poziom %i \x02]", TAG, victim, awp_lvl[victim]);
			LvlUp(attacker);
			PrepareSaveData(attacker);
			SaveAll(attacker);
        }
        else if(scope && hs)
        {
			awp_exp[attacker] += 30;
			PrintToChat(attacker, "%s Dostajesz 30 EXPa za \x02zabicie HS \x01gracza \x04%N \x02[ \x04Poziom %i \x02]", TAG, victim, awp_lvl[victim]);
			LvlUp(attacker);
			PrepareSaveData(attacker);
			SaveAll(attacker);
        }
    }
    if (StrEqual(weapons, "knife_default_ct") || StrEqual(weapons, "knife_default_t") || StrEqual(weapons, "knife_t") || StrEqual(weapons, "knife_ct") || StrEqual(weapons, "knifegg") || StrEqual(weapons, "knife_flip") || StrEqual(weapons, "knife_gut") || StrEqual(weapons, "knife_karambit") || StrEqual(weapons, "bayonet") || StrEqual(weapons, "knife_m9_bayonet") || StrEqual(weapons, "knife_butterfly") || StrEqual(weapons, "knife_tactical") || StrEqual(weapons, "knife_falchion") || StrEqual(weapons, "knife_push") || StrEqual(weapons, "knife") || StrEqual(weapons, "knife_survival_bowie"))
    {
		awp_exp[attacker] += 35;
		PrintToChat(attacker, "%s Dostajesz 35 EXPa za \x02zabicie nozem \x01gracza \x04%N \x02[ \x04Poziom %i \x02]", TAG, victim, awp_lvl[victim]);
		Format(KnifeInfo, sizeof(KnifeInfo), "%s Gracz %N \x02[ \x04Poziom %i \x02]\x01 zabił gracza %N \x02[ \x04Poziom %i \x02]\x01 używając \x02noża.", TAG, attacker, awp_lvl[attacker], victim, awp_lvl[victim]);
		PrintToChatAll(KnifeInfo);
		LvlUp(attacker);
		PrepareSaveData(attacker);
		SaveAll(attacker);
    }
}
 
public Action LvlUp(int client)
{
    char LvlUpInfo[256];
    if (awp_exp[client] >= awp_requirements[awp_lvl[client]] && awp_lvl[client] < 20 )
    {
        awp_lvl[client]++;
        PrintToChat(client, "%s Gratulacje! Awansowałeś do %i poziomu.", TAG, awp_lvl[client]);
        Format(LvlUpInfo, sizeof(LvlUpInfo), "%s Gracz %N osiągnął %i poziom!", TAG, client, awp_lvl[client]);
        PrintToChatAll(LvlUpInfo);
        awp_punktylv[client] += 2;
        PrepareSaveData(client);
        SaveAll(client);
    }
}
 
public Action awp_poziom(int client, int args)
{
    Menu poziom = new Menu(poziom_Handler);
   
    char buffer[512];
    FormatEx(buffer, 512, "Poziomy - OnlyAWP + LvL");
    Format(buffer, 512, "%s\n » Poziom: %i", buffer, awp_lvl[client]);
    Format(buffer, 512, "%s\n » EXP: %i", buffer, awp_exp[client]);
    Format(buffer, 512, "%s\n » Wymagany EXP na nastepny LvL: %i", buffer, awp_requirements[awp_lvl[client]]);
    Format(buffer, 512, "%s\n » Dostepne punkty ulepszen: %i", buffer, awp_punktylv[client]);
   
    poziom.SetTitle(buffer);
    poziom.AddItem("1", "Rozdaj punkty umiejetnosci");
    poziom.AddItem("2", "Wyjdz");
    poziom.ExitButton = false;
    poziom.Display(client, 60);
    return Plugin_Handled;
}
 
public int poziom_Handler(Menu menu, MenuAction action, int client, int position)
{
    if(action == MenuAction_Select)
    {
        char Item[32];
        GetMenuItem(menu, position, Item, sizeof(Item));
       
        if(StrEqual(Item, "1"))
            awp_upgrade(client, 0);
    }
    else if(action == MenuAction_End)
        CloseHandle(menu);
}
 
public Action awp_upgrade(int client, int args)
{
    Menu poziomx = new Menu(poziomx_Handler);
   
    char sBuffer[512];
    Format(sBuffer, sizeof(sBuffer), "Ulepszenia - OnlyAWP + LvL");
    Format(sBuffer, sizeof(sBuffer), "%s\n » Kazde ulepszenie zycia dodaje +1 punkt", sBuffer);
    Format(sBuffer, sizeof(sBuffer), "%s\n » Kazde ulepszenie grawitacji zmniejsza ja o -0,02", sBuffer);
    Format(sBuffer, sizeof(sBuffer), "%s\n » Kazde ulepszenie predkosci zwieksza ja o +0,02", sBuffer);
    Format(sBuffer, sizeof(sBuffer), "%s\n » Koszt Double Jumpa wynosi 10 punktów umiejętności!", sBuffer);
   
    poziomx.SetTitle(sBuffer);
    Format(sBuffer, sizeof(sBuffer), "Ulepsz zycie! [%i/10]", awp_zycie[client]);
    poziomx.AddItem("1", sBuffer, awp_zycie[client] != 10 ? ITEMDRAW_DEFAULT : ITEMDRAW_DISABLED);
    Format(sBuffer, sizeof(sBuffer), "Ulepsz grawitacje! [%i/10]", awp_grawitacja[client]);
    poziomx.AddItem("2", sBuffer, awp_grawitacja[client] != 10 ? ITEMDRAW_DEFAULT : ITEMDRAW_DISABLED);
    Format(sBuffer, sizeof(sBuffer), "Ulepsz predkosc! [%i/10]", awp_predkosc[client]);
    poziomx.AddItem("3", sBuffer, awp_predkosc[client] != 10 ? ITEMDRAW_DEFAULT : ITEMDRAW_DISABLED);
    Format(sBuffer, sizeof(sBuffer), "Ulepsz Double Jumpa! [%i/1]", awp_dj[client]);
    poziomx.AddItem("4", sBuffer, awp_dj[client] != 1 ? ITEMDRAW_DEFAULT : ITEMDRAW_DISABLED);
    poziomx.AddItem("5", "Wyjdz");
    poziomx.ExitButton = false;
    poziomx.Display(client, 60);
    return Plugin_Handled;
}
 
public int poziomx_Handler(Menu menu, MenuAction action, int client, int position)
{
    if(action == MenuAction_Select)
    {
        char Item[32];
        GetMenuItem(menu, position, Item, sizeof(Item));
       
        if(StrEqual(Item, "1"))
            awp_healthup(client, 0);
        else if(StrEqual(Item, "2"))
            awp_gravityup(client, 0);
        else if(StrEqual(Item, "3"))
            awp_speedup(client, 0);
        else if(StrEqual(Item, "4"))
            awp_djup(client, 0);
    }
    else if(action == MenuAction_End)
        CloseHandle(menu);
}
 
public Action awp_healthup(int client, int args)
{
    if (awp_zycie[client] < 10 && awp_punktylv[client] > 0)
    {
        awp_zycie[client]++;
        PrintToChat(client, "%s", aTAG);
        PrintToChat(client, "%s Pomyslnie ulepszyles zycie. Pozostale punkty umiejetnosci: %i", TAG, awp_punktylv[client]);
        PrintToChat(client, "%s", aTAG);
        awp_punktylv[client]--;
        PrepareSaveData(client);
        SaveAll(client);
        awp_upgrade(client, 0);
    }
    else
    {
        PrintToChat(client, "%s", aTAG);
        PrintToChat(client, "%s Nie spelniasz wymagan!", TAG);
        PrintToChat(client, "%s", aTAG);
    }
}
 
public Action awp_gravityup(int client, int args)
{
    if (awp_grawitacja[client] < 10 && awp_punktylv[client] > 0)
    {
        awp_grawitacja[client]++;
        PrintToChat(client, "%s", aTAG);
        PrintToChat(client, "%s Pomyslnie ulepszyles grawitacje. Pozostale punkty umiejetnosci: %i", TAG, awp_punktylv[client]);
        PrintToChat(client, "%s", aTAG);
        awp_punktylv[client]--;
        PrepareSaveData(client);
        SaveAll(client);
        awp_upgrade(client, 0);
    }
    else
    {
        PrintToChat(client, "%s", aTAG);
        PrintToChat(client, "%s \x02Nie spelniasz wymagan!", TAG);
        PrintToChat(client, "%s", aTAG);
    }
}
 
public Action awp_speedup(int client, int args)
{
    if (awp_predkosc[client] < 10 && awp_punktylv[client] > 0)
    {
        awp_predkosc[client]++;
        PrintToChat(client, "%s", aTAG);
        PrintToChat(client, "%s Pomyslnie ulepszyles predkosc. Pozostale punkty umiejetnosci: %i", TAG, awp_punktylv[client]);
        PrintToChat(client, "%s", aTAG);
        awp_punktylv[client]--;
        PrepareSaveData(client);
        SaveAll(client);
        awp_upgrade(client, 0);
    }
    else
    {
        PrintToChat(client, "%s", aTAG);
        PrintToChat(client, "%s \x02Nie spelniasz wymagan!", TAG);
        PrintToChat(client, "%s", aTAG);
    }
}
 
public Action awp_djup(int client, int args)
{
    if(awp_dj[client] < 1 && awp_punktylv[client] >= 10)
    {
        awp_dj[client]++;
        PrintToChat(client, "%s", aTAG);
        PrintToChat(client, "%s Pomyslnie ulepszyles Double Jumpa. Pozostale punkty umiejetnosci: %i", TAG, awp_punktylv[client]);
        PrintToChat(client, "%s", aTAG);
        awp_punktylv[client] -= 10;
        PrepareSaveData(client);
        SaveAll(client);
        awp_upgrade(client, 0);
    }
    else
    {
        PrintToChat(client, "%s", aTAG);
        PrintToChat(client, "%s \x02Nie spelniasz wymagan!", TAG);
        PrintToChat(client, "%s", aTAG);
    }
}
 
//     ================= Baza Danych =================     //
public Action DatabaseConnect()
{
    char error[512];
    DB = SQL_Connect("AWPLVL", true, error, sizeof(error));
    if(DB == INVALID_HANDLE)
    {
        LogError("Could not connect: %s", error);
        g_iBazaSql = 0;
    }
    else if(g_iBazaSql < 1)
    {
        g_iBazaSql++;
        char zapytanie[1024];
        Format(zapytanie, sizeof(zapytanie), "CREATE TABLE IF NOT EXISTS `AWPLVL` (`sid` VARCHAR(64) NOT NULL, `EXP` INT NOT NULL, `Level` INT NOT NULL, `PunktyUm` INT NOT NULL, `HealthPointsAdded` INT NOT NULL, `GravityPointsAdded` INT NOT NULL, `SpeedPointsAdded` INT NOT NULL, `DJPointsAdded` INT NOT NULL,  UNIQUE KEY `sid` (`sid`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;");
       
        SQL_LockDatabase(DB);
        SQL_FastQuery(DB, zapytanie);
        SQL_UnlockDatabase(DB);
        DatabaseConnect();
    }
}
 
public void PrepareLoad(int client)
{
    if(!IsValidClient(client))
        return;
       
    if(!g_iBazaSql)
        return;
   
    char zapytanie[1024], authid[64];
    GetClientAuthId(client, AuthId_Steam2, authid, sizeof(authid));
   
    Format(zapytanie, sizeof(zapytanie), "SELECT `EXP`, `Level`, `PunktyUm`, `HealthPointsAdded`, `GravityPointsAdded`, `SpeedPointsAdded`, `DJPointsAdded` FROM `AWPLVL` WHERE `sid` LIKE '%s';", authid);
    SQL_TQuery(DB, Load, zapytanie, client);
}
 
public void Load(Handle owner, Handle query, const char[] error, any client)
{
    if(query == INVALID_HANDLE)
    {
        LogError("Load error: %s", error);
        return;
    }
    if(SQL_GetRowCount(query))
    {
        while(SQL_MoreRows(query))
        {
            while(SQL_FetchRow(query))
            {
                awp_exp[client] = SQL_FetchInt(query, 0);
                awp_lvl[client] = SQL_FetchInt(query, 1);
                awp_punktylv[client] = SQL_FetchInt(query, 2);
                awp_zycie[client] = SQL_FetchInt(query, 3);
                awp_grawitacja[client] = SQL_FetchInt(query, 4);
                awp_predkosc[client] = SQL_FetchInt(query, 5);
                awp_dj[client] = SQL_FetchInt(query, 6);
            }
        }
    }
    else
    {
        if(!IsValidClient(client))
            return;
       
        char zapytanie[1024], authid[64];
        GetClientAuthId(client, AuthId_Steam2, authid, sizeof(authid));
       
        Format(zapytanie, sizeof(zapytanie), "INSERT INTO `AWPLVL` (`sid`, `EXP`, `Level`, `PunktyUm`, `HealthPointsAdded`, `GravityPointsAdded`, `SpeedPointsAdded`, `DJPointsAdded`) VALUES ('%s', '%i', '%i', '%i', '%i', '%i', '%i', '%i');", authid, awp_exp[client], awp_lvl[client], awp_punktylv[client], awp_zycie[client], awp_grawitacja[client], awp_predkosc[client], awp_dj[client]);
        SQL_TQuery(DB, SaveData_Handler, zapytanie, client);
    }
    g_iIsDataLoaded[client] = true;
}
 
public Action PrepareSaveData(int client)
{
    if(!IsValidClient(client))
    {
        return;
    }
    if (g_bSaveData[client])
    {
        SaveData(client);
        g_bSaveData[client] = true;
    }
}
 
public Action SaveData(int client)
{
    if(!g_iBazaSql) return;
    if(!IsValidClient(client)) return;
    if(g_iIsDataLoaded[client]) return;
   
    char authid[64], zapytanie[1024];
    GetClientAuthId(client, AuthId_Steam2, authid, sizeof(authid));
   
    Format(zapytanie, sizeof(zapytanie), "INSERT INTO `AWPLVL` (`sid`, `EXP`, `Level`, `PunktyUm`, `HealthPointsAdded`, `GravityPointsAdded`, `SpeedPointsAdded`, `DJPointsAdded`) VALUES ('%s', '%i', '%i', '%i', '%i', '%i', '%i', '%i') ON DUPLICATE KEY UPDATE `EXP`=VALUES(`EXP`), `Level`=VALUES(`Level`), `PunktyUm`=VALUES(`PunktyUm`), `HealthPointsAdded`=VALUES(`HealthPointsAdded`), `GravityPointsAdded`=VALUES(`GravityPointsAdded`), `SpeedPointsAdded`=VALUES(`SpeedPointsAdded`), `DMGPointsAdded`=VALUES(`DMGPointsAdded`);", authid, awp_exp[client], awp_lvl[client], awp_punktylv[client], awp_zycie[client], awp_grawitacja[client], awp_predkosc[client], awp_dj[client]);
    SQL_TQuery(DB, SaveData_Handler, zapytanie, client);
}
 
public Action SaveAll(int client)
{
    if(!g_iBazaSql) return;
    if(!IsValidClient(client)) return;
   
    char authid[64], zapytanie[1024];
    GetClientAuthId(client, AuthId_Steam2, authid, sizeof(authid));
   
    Format(zapytanie, 1024, "UPDATE `AWPLVL` SET `EXP`='%i', `Level`='%i', `PunktyUm`='%i', `HealthPointsAdded`='%i', `GravityPointsAdded`='%i', `SpeedPointsAdded`='%i', `DJPointsAdded`='%i' WHERE `sid`='%s';", awp_exp[client], awp_lvl[client], awp_punktylv[client], awp_zycie[client], awp_grawitacja[client], awp_predkosc[client], awp_dj[client], authid);
    SQL_TQuery(DB, SaveData_Handler, zapytanie, client);
}
 
public void SaveData_Handler(Handle owner, Handle query, const char[] error, any client)
{
    if(query == INVALID_HANDLE)
    {
        LogError("Save error: %s", error);
        return;
    }
}
 
stock bool IsValidClient(int client)
{
    if(client <= 0 ) return false;
    if(client > MaxClients) return false;
    if(!IsClientConnected(client)) return false;
    if(IsFakeClient(client)) return false;
    return IsClientInGame(client);
}