[guipatinador]

As I understand, you want something like this,

PHP Code:

public CallThis( )
{
    // Call this on plugin_init or plugin_cfg
    
    // Your SQL Stuff goes here
    
    new szAuthID[ 32 ]
    
    while( SQL_MoreResults( Query ) )
    {
        SQL_ReadResult( Query, 0, szAuthID, charsmax( szAuthID ) )
        
        TrieSetCell( g_YourTrie, szAuthID, 1 )
        
        SQL_NextRow( Query )
    }
}

public client_putinserver( id )
{
    new szAuthID[ 32 ]; get_user_authid( id, szAuthID, charsmax( szAuthID ) )
    
    if( TrieKeyExists( g_YourTrie, szAuthID ) )
    {
        // Your Steam ID exists in the trie / database    
    }
} 


If not, give more information.

[fysiks]

Originally Posted by Mucx Good tutorial, was searching a way to save data. Can i set multiple key's to TrieSetString, if yes, then how? For example i have Name and Steam in my table. Idea is when Name or Steam is valid then plugin takes action, gives the rest data that is taken from mysql.

No, you cannot have two keys that point to the same data (literally). Use only SteamID, there is no good reason to use anything else.

[Mucx]

Originally Posted by guipatinador As I understand, you want something like this, PHP Code: public CallThis( ) {     // Call this on plugin_init or plugin_cfg          // Your SQL Stuff goes here          new szAuthID[ 32 ]          while( SQL_MoreResults( Query ) )     {         SQL_ReadResult( Query, 0, szAuthID, charsmax( szAuthID ) )                  TrieSetCell( g_YourTrie, szAuthID, 1 )                  SQL_NextRow( Query )     } } public client_putinserver( id ) {     new szAuthID[ 32 ]; get_user_authid( id, szAuthID, charsmax( szAuthID ) )          if( TrieKeyExists( g_YourTrie, szAuthID ) )     {         // Your Steam ID exists in the trie / database         } }  If not, give more information.

Would something like this work in client_putinserver( id ) part.

PHP Code:

public CallThis( ) {
    // Call this on plugin_init or plugin_cfg
    
    // Your SQL Stuff goes here
    
new szAuthID[ 32 ], szName[ 32 ], szSomeThing[ 32 },

while( SQL_MoreResults( Query ) ) {
    SQL_ReadResult( Query, 0, szAuthID, charsmax( szAuthID ) )
    SQL_ReadResult( Query, 1, szName, charsmax( szName ) )
    SQL_ReadResult( Query, 0, szSomeThing, charsmax( szSomeThing ) )
    
    TrieSetCell( g_YourTrie, szAuthID, 1 )
    TrieSetCell( g_YourTrie, szName, 1 )
    TrieSetCell( g_YourTrie, szSomeThing, 1 )
    
    SQL_NextRow( Query )
}
}

public client_putinserver( id ) {
new szAuthID[ 32 ]; get_user_authid( id, szAuthID, charsmax( szAuthID ) )
new szName[ 32 ]; get_user_authid( id, szName, charsmax( szName ) )

if( TrieKeyExists( g_YourTrie, szAuthID ) || TrieKeyExists( g_YourTrie, szName ) ) {
    // Use szSomeThing 
}
} 


Originally Posted by fysiks No, you cannot have two keys that point to the same data (literally). Use only SteamID, there is no good reason to use anything else.

Well there is a reason for me. Some via name, some steamid or both.

[guipatinador]

How many columns have your table?
I will assume the table have 2 columns, one for the player name or Steam ID, and other for the data.

PHP Code:

public CallThis( )
{
    // Call this on plugin_init or plugin_cfg
    // Your SQL Stuff goes here
    
    new szIdentification[ 32 ] // For Steam ID or Name
    new szSomeThing[ 32 ]
    
    while( SQL_MoreResults( Query ) )
    {
        SQL_ReadResult( Query, 0, szIdentification, charsmax( szIdentification ) ) // first column of the table
        SQL_ReadResult( Query, 1, szSomeThing, charsmax( szSomeThing ) ) // second column
        
        TrieSetString( g_YourTrie, szIdentification, szSomeThing )
        
        SQL_NextRow( Query )
    }
}

public client_putinserver( id )
{
    new szAuthID[ 32 ]; get_user_authid( id, szAuthID, charsmax( szAuthID ) )
    new szName[ 32 ]; get_user_name( id, szName, charsmax( szName ) )
    
    if( TrieKeyExists( g_YourTrie, szAuthID ) || TrieKeyExists( g_YourTrie, szName ) )
    {
        // Steam ID or Name exists in the trie / database 
        // You can use the szSomeThing for what you want
        // Just an example...
        
        new szSomeThing[ 32 ]
        
        if( TrieGetString( g_YourTrie, szAuthID, szSomeThing, charsmax( szSomeThing ) ) )
        {
            client_print( 0, print_chat, "Steam ID = %s | Data = %s", szAuthID, szSomeThing )
        }
        
        if( TrieGetString( g_YourTrie, szName, szSomeThing, charsmax( szSomeThing ) ) )
        {
            client_print( 0, print_chat, "Name = %s | Data = %s", szName, szSomeThing )
        }
    }
} 


[Mucx]

I have Name, Steam, Password, Flags columns in my table.
I'm tryng to create a bit custom admin plugin for my needs.

[guipatinador]

You need something like this,

PHP Code:

public CallThis( )
{
    // Call this on plugin_init or plugin_cfg
    // Your SQL Stuff goes here
    
    new szName[ 32 ], szAuthID[ 32 ], szPassword[ 32 ], szFlags[ 32 ]
    new FormattedData[ 64 ]
    
    while( SQL_MoreResults( Query ) )
    {
        SQL_ReadResult( Query, 0, szName, charsmax( szName ) )
        SQL_ReadResult( Query, 1, szAuthID, charsmax( szAuthID ) )
        SQL_ReadResult( Query, 2, szPassword, charsmax( szPassword ) )
        SQL_ReadResult( Query, 3, szFlags, charsmax( szFlags ) )
        
        formatex( FormattedData, charsmax( FormattedData ), "%s#%s", szPassword, szFlags )
        
        TrieSetString( g_TrieWithNames, szName, FormattedData )
        TrieSetString( g_TrieWithAuthIDs, szAuthID, FormattedData )
        
        SQL_NextRow( Query )
    }
}

public client_putinserver( id )
{
    new szName[ 32 ]; get_user_name( id, szName, charsmax( szName ) )
    new szAuthID[ 32 ]; get_user_authid( id, szAuthID, charsmax( szAuthID ) )
    
    if( !( TrieKeyExists( g_TrieWithNames, szName ) || TrieKeyExists( g_TrieWithAuthIDs, szAuthID ) ) )
        return PLUGIN_CONTINUE
    
    new szData[ 64 ]
    new szPassword[ 32 ]
    new szFlags[ 32 ]
    
    if( TrieGetString( g_TrieWithNames, szName, szData, charsmax( szData ) ) )
    {
        replace_all( szData, charsmax( szData ), "#", " " )
        parse( szData, szPassword, charsmax( szPassword ), szFlags, charsmax( szFlags ) )
        
        new szPW[ 32 ]; get_user_info( id, "password", szPW, charsmax( szPW ) )
        
        if( equal( szPW, szPassword ) )
        {
            set_user_flags( id, szFlags )
        }
        
    }
    
    if( TrieGetString( g_TrieWithAuthIDs, szAuthID, szData, charsmax( szData ) ) )
    {
        replace_all( szData, charsmax( szData ), "#", " " )
        parse( szData, szPassword, charsmax( szPassword ), szFlags, charsmax( szFlags ) )
        
        set_user_flags( id, szFlags )
    }
    
    return PLUGIN_CONTINUE
} 


That password can't contain spaces or #

[Mucx]

Thank you. If i get the time then i will try and post feedback.

[guipatinador]

I've made a benchmark with Tries and Arrays.

The plugin...
1 - writes to a file with random Steam IDs (STEAM_0:0:XXXXXXXX)
2 - saves the Steam IDs to an Trie and an Array
3 - loops through the Trie / Array and search for this Steam ID -> STEAM_0:0:12345678
4 - uses this timer http://forums.alliedmods.net/showthread.php?t=67752







X axis is the number of Steam IDs
Y axis is the time in seconds

[Arkshine]

Why would you make a [speed] comparaison between tries and arrays ? I don't understand how it's useful, both are used for different purposes. It's just irrelevant. All you need to know are both are dynamic, slow on insertion, fast on getting item, and that's all. Also, it's about a Trie tutorial here.

[guipatinador]

I did it because I wanted to know the behavior of Tries with a lot of keys. I have found that between 1000 and 10000 it becomes slower (don't know why). The Array benchmark is just for curiosity.
I'm not telling that Tries are better, of course it depends on the situation.