[Bugsy]

How much data is stored for each player? I personally would try to keep everything in one vault and group data into a single kv pair. If you are storing a ton of data, or have unique queries, I'd go with SQL.

[PreDominance]

Originally Posted by Bugsy How much data is stored for each player? I personally would try to keep everything in one vault and group data into a single kv pair. If you are storing a ton of data, or have unique queries, I'd go with SQL.

Well this is for a warcraft mod. Each player needs to have a few small things (BankXp, bankLevel, current race, player total level). For each race, however, a player needs to have:

• Race XP
• Race Level
• Skill1/2/3/4/5/6/7/8 (stored as a string delimited by ",").

I plan on having over 60 races, so each player might have upwards of 350KV pairs.


I don't have the time to try to work with SQL or SQLite, as I've 0 experience with either, and I've already gotten so much work put into using vault.


For reference, here's how I'm getting/storing data:

//Returns the key of the KV pair. By systematically generating keys, it becomes
//easier to enforce consistency.
vault_getUserKey(id, type[], raceId = 0) 
{
    static szReturn[70];
    static szKeyType[30];
    static szId[30];
    get_user_authid(id, szId, charsmax(szId));
    if (raceId)
    {
        format(szKeyType, charsmax(szKeyType), "%s %i", szKeyType, raceId);
    } else {
        format(szKeyType, charsmax(szKeyType), "%s", type);
    }
    format(szReturn, charsmax(szReturn), "%s %s", szId, szKeyType);
    return szReturn;
}


...constants.inl

#define KEY_CURRACE            "CurRace" //Current race, so server remembers your race upon return
#define KEY_RACE_LEVELS        "RaceLevels" //Levels of skills in a race
#define KEY_RACE_TOTAL        "RaceTotalLevels" //Total level of all skills in a race
#define KEY_RACE_XP            "RaceXp" //Xp in a race
#define KEY_BANKXP            "BankXP" //Xp in gank
#define KEY_BANKLEVEL        "BankLevel" //Levels in bank
#define KEY_NAME            "Name" //Name of user upon first connection

[klippy]

Originally Posted by PreDominance Well this is for a warcraft mod. Each player needs to have a few small things (BankXp, bankLevel, current race, player total level). For each race, however, a player needs to have: Race XP Race Level Skill1/2/3/4/5/6/7/8 (stored as a string delimited by ","). I plan on having over 60 races, so each player might have upwards of 350KV pairs. I don't have the time to try to work with SQL or SQLite, as I've 0 experience with either, and I've already gotten so much work put into using vault. For reference, here's how I'm getting/storing data: //Returns the key of the KV pair. By systematically generating keys, it becomes //easier to enforce consistency. vault_getUserKey(id, type[], raceId = 0) { static szReturn[70]; static szKeyType[30]; static szId[30]; get_user_authid(id, szId, charsmax(szId)); if (raceId) { format(szKeyType, charsmax(szKeyType), "%s %i", szKeyType, raceId); } else { format(szKeyType, charsmax(szKeyType), "%s", type); } format(szReturn, charsmax(szReturn), "%s %s", szId, szKeyType); return szReturn; } ...constants.inl #define KEY_CURRACE "CurRace" //Current race, so server remembers your race upon return #define KEY_RACE_LEVELS "RaceLevels" //Levels of skills in a race #define KEY_RACE_TOTAL "RaceTotalLevels" //Total level of all skills in a race #define KEY_RACE_XP "RaceXp" //Xp in a race #define KEY_BANKXP "BankXP" //Xp in gank #define KEY_BANKLEVEL "BankLevel" //Levels in bank #define KEY_NAME "Name" //Name of user upon first connection

Maybe a vault file for each class, instead for each player? Or maybe, you could change key to

STEAM_0:1:234567-4

where that "4" would be class id, which means, every player can have up to 60(or whatever your class number is) keys in vault.

[PreDominance]

Your 2'nd description is more closer to the one I currently use. With it, the KV Pairs should look like:

• STEAM_0:1;37003168 CurRace 32
• STEAM_0:1;37003168 RaceLevels 0,1,2,3,4,5,6,7
• STEAM_0:1;37003168 Name PreDominance

etc.

Maybe later on once I become more comfortable with the way this language works I'll do something like..

• STEAM_0:1;37003168 RaceInfo 32 64 128 2,5,6,5,1,2,1,0

Where each player has one key per race. <id> KEY_RACE_INFO <raceId> <level> <xp> <skill levels>

[Catastrophe]

How do i save/load a cellarray using nvault ? suppose i have a BUFFER array (i.e array that i change whenever needed) containing steam ids and i get its size using arraysize for saving but then how do i load it into another or the same array in plugin_init or precache ?

[Bugsy]

Originally Posted by PreDominance Your 2'nd description is more closer to the one I currently use. With it, the KV Pairs should look like: STEAM_0:1;37003168 CurRace 32 STEAM_0:1;37003168 RaceLevels 0,1,2,3,4,5,6,7 STEAM_0:1;37003168 Name PreDominance etc. Maybe later on once I become more comfortable with the way this language works I'll do something like.. STEAM_0:1;37003168 RaceInfo 32 64 128 2,5,6,5,1,2,1,0 Where each player has one key per race. <id> KEY_RACE_INFO <raceId> <level> <xp> <skill levels>

This would be an easy scenario to handle with the Array to String include I recently posted. Take a look at that thread, I posted an example for saving player data using an enum to size the array. No parsing needed, simple 2 lines to save and retrieve data into your array.

Originally Posted by Catastrophe How do i save/load a cellarray using nvault ? suppose i have a BUFFER array (i.e array that i change whenever needed) containing steam ids and i get its size using arraysize for saving but then how do i load it into another or the same array in plugin_init or precache ?

You can save\load data to\from nvault into a normal array with ease with array to string include.

[yokomo]

Bugsy can you modify this code so i can show:
Playername rank is 'position' out of 'total entries'.

The code above is to show top10 entries only, I want to show rank. Thanks.

[Bugsy]

Increase the below to accommodate your max.

PHP Code:

const MAX_ENTRIES = 10; 


Then modify this line to show what you want:

PHP Code:

server_print("%d. %-20.20s %d", (i + 1), data[VD_Key], data[VD_Value]); 


[Bugsy]

Added nvault_remove() which I somehow forgot and added return values for each function.

[Corabika]

Bugsy
Please How To Found Rank Pos And Thanks