[ecca]

You can name the cookie whatever you want. But developers mostly name it like mypluginname_cookie

A big guess where they are saved is sourcemod/data but i actually dont know.

[GsiX]

I dont know where went wrong but it not in there.

PHP Code:

new Handle:g_Health_cookie;
new Handle:g_Streangth_cookie;
new Handle:g_Endurance_cookie;
new Handle:g_Agility_cookie;

public OnPluginStart()
{
    g_Health_cookie        = RegClientCookie( "luffy_health_cookie",        "L4D2 Luffy", CookieAccess_Protected );
    g_Streangth_cookie    = RegClientCookie( "luffy_strength_cookie",        "L4D2 Luffy", CookieAccess_Protected );
    g_Endurance_cookie    = RegClientCookie( "luffy_endurance_cookie",    "L4D2 Luffy", CookieAccess_Protected );
    g_Agility_cookie    = RegClientCookie( "luffy_agility_cookie",        "L4D2 Luffy", CookieAccess_Protected );
}

public OnClientCookiesCached( client )
{
    decl String:rStorage[11];
    
    GetClientCookie( client, g_Health_cookie, rStorage, sizeof( rStorage ));
    g_CleintHP[client][0] = StringToInt( rStorage );
    
    GetClientCookie( client, g_Streangth_cookie, rStorage, sizeof( rStorage ));
    g_ClientSTR[client] = StringToInt( rStorage );
    
    GetClientCookie( client, g_Endurance_cookie, rStorage, sizeof( rStorage ));
    g_ClientAGI[client] = StringToInt( rStorage );
    
    GetClientCookie( client, g_Agility_cookie, rStorage, sizeof( rStorage ));
    g_ClientEDN[client] = StringToInt( rStorage );
}

public OnClientDisconnect_Post( client )
{
    decl String:sStorage[11];
    
    IntToString( g_CleintHP[client][0], sStorage, sizeof( sStorage ));
    SetClientCookie( client, g_Health_cookie, sStorage );
    g_CleintHP[client][0] = 0;
    
    IntToString( g_ClientSTR[client], sStorage, sizeof( sStorage ));
    SetClientCookie( client, g_Streangth_cookie, sStorage );
    g_ClientSTR[client] = 0;
    
    IntToString( g_ClientAGI[client], sStorage, sizeof( sStorage ));
    SetClientCookie( client, g_Endurance_cookie, sStorage );
    g_ClientAGI[client] = 0;
    
    IntToString( g_ClientEDN[client], sStorage, sizeof( sStorage ));
    SetClientCookie( client, g_Agility_cookie, sStorage );
    g_ClientEDN[client] = 0;
} 


[FaTony]

Check databases.cfg. You'd probably want clientprefs to use SQLite when testing.

[GsiX]

Originally Posted by FaTony Check databases.cfg. You'd probably want clientprefs to use SQLite when testing.

How m i do that?

EDIT: ahh.. you talking about the content of the databases.cfg.. what i saw there is empty?

"clientprefs" { "driver" "sqlite" "host" "localhost" "database" "clientprefs-sqlite" "user" "root" "pass" "" //"timeout" "0" //"port" "0" }

EDIT2: Do i need sever.. and must be server in order to do that? Because i m testing it via map <mapname>.

[FaTony]

Example:

"clientprefs"
    {
        "driver"            "sqlite"
        "database"            "clientprefs"
    }

[GsiX]

What i m saying that i don't have a sever. Mostly i m making plugin on.. how to say this.. single player (lan game) or what ever the name is.

EDIT: m i still possible to do the test with this method?

PHP Code:

new Handle:g_hDataBase;

public OnPluginStart()
{
    CreateDataBase();
}

public CreateDataBase()
{
    ServerCommand( "clear" );
    PrintToServer( "[LUFFY]: Creating Data Base" );
    new String:error[255];
    g_hDataBase = SQLite_UseDatabase( "l4d2_luffy_database", error, sizeof( error ));
    
    if ( g_hDataBase == INVALID_HANDLE)
    {
        SetFailState( "[LUFFY]; SQL error: %s", error );
    }
    
    SQL_LockDatabase( g_hDataBase );
    SQL_FastQuery( g_hDataBase, "VACUUM" );
    SQL_FastQuery( g_hDataBase, "CREATE TABLE IF NOT EXISTS savepoint_health (steamid TEXT PRIMARY KEY, timestamp INTEGER);");
    SQL_UnlockDatabase( g_hDataBase );
} 


[FaTony]

SQLite doesn't need a separate server and works completely inside Sourcemod. Set clientprefs to SQLite and have fun.

If you want full power of MySQL I suggest you XAMPP.

[GsiX]

Thanks for the suggestion but my net connection is 6k - 36k/s.. so no way i gonna own a sever..

[GsiX]

Where i go wrong? I use player_hurt to save data and it does print to sever but the data never saved.

PHP Code:

new Handle:g_hDataBase;

public OnPluginStart()
{
    CreateDataBase();
}

public CreateDataBase()
{
    ServerCommand( "clear" );
    PrintToServer( "[LUFFY]: Creating Data Base" );
    new String:error[255];
    g_hDataBase = SQLite_UseDatabase( "clientprefs", error, sizeof( error ));
    
    if ( g_hDataBase == INVALID_HANDLE)
    {
        SetFailState( "[LUFFY]; SQL error: %s", error );
    }
    
    SQL_LockDatabase( g_hDataBase );
    SQL_FastQuery( g_hDataBase, "VACUUM" );
    SQL_FastQuery( g_hDataBase, "CREATE TABLE IF NOT EXISTS savepoint_health (steamid TEXT PRIMARY KEY, test1 SMALLINT, test2 SMALLINT, test3 SMALLINT, timestamp INTEGER);");
    SQL_UnlockDatabase( g_hDataBase );
}

public SaveToDataBase()
{
    for ( new i = 1; i <= MaxClients; i++)
    {
        if ( IsClientInGame( i ) && !IsFakeClient( i ) && IsClientAuthorized( i ))
        {
            decl String:steamId[30];
            decl String:query[200];
            
            GetClientAuthString( i, steamId, sizeof(steamId));
            new test1 = 100;
            new test2 = 200;
            new test3 = 300;
            
            Format( query, sizeof( query ), "INSERT OR REPLACE INTO savepoint_health VALUES ('%s', %d, %d, %d, %d);", steamId, test1, test2, test3, GetTime());
            SQL_FastQuery( g_hDataBase, query );
            PrintToServer( "[LUFFY]: Syncronize data base for %N", i );
        }
    }
}

public Action:EVENT_PlayerHurt(Handle:event, const String:name[], bool:dontBroadcast)
{
    SaveToDataBase();
} 


[FaTony]

So why don't you use clientprefs?