[Exolent[jNr]]

Originally Posted by funfel If I write "`key2` = 'level'" in sqlv_read_set_ex, sqlv_read_set_ex returns a value for key2 (level) in variable eVaultData[ i ][ SQLVEx_Data ]?

Yes.

[funfel]

Ok, thanks, and It returns in string? Or If key2 is num, I receive num? If key2 is float, I receive float? Sorry for dumbish question but I am newbie

[Exolent[jNr]]

It will always return as a string, regardless if you set as num, float, etc.

[funfel]

Problems never die :/ sqlv_read_set_ex works only in last problem (with this "level"), but here it doesnt works (1st place with 600$, second with 1500$, thrid place with 1000$, etc.), so I tried to do Top by sqlv_read_ex, here is the code:

case _motd_MONEY:
        {
            iLen += formatex( sText[ iLen ], sizeof( sText ) - iLen - 1, "<tr style=^"color:white;background:#0e0e0e;^"><td>#</td><td class=^"l^">Nick</td><td>Cala kasa</td></tr>" );
            
            new iMoney;
            
            for( new i = 0; i < 10; i++ )
            {
                sqlv_read_ex( g_hVault, i, sKey1, sizeof( sKey1 ) - 1, "", 0, sData, sizeof( sData ) - 1, iTimeStamp, "`key2` = 'totalmoney'", "`data` DESC" );
                
                sqlv_get_data_ex( g_hVault, sKey1, "name", sData, sizeof( sData ) - 1 );
                iMoney = sqlv_get_num_ex( g_hVault, sKey1, "totalmoney" );
                
                iLen += formatex( sText[ iLen ], sizeof( sText ) - iLen - 1, "<tr><td>%d</td><td class=^"l^">%s</td><td>%d</td></tr>", i + 1, sData, iMoney );
            }
            
            iLen += formatex( sText[ iLen ], sizeof( sText ) - iLen - 1, "</table></center></body>" );
            
            show_motd( id, sText, "Top10 graczy w calej kasie" );
        }

I cleaned table with "totalmoney", and I with my friend added money for us (500 for me, 1500 for him - for sure we changed map a few times, did much reconnects, and problem is still the same - srsly I dont know what is wrong...

SCREEN:[IMG]http://img855.**************/img855/2286/76823298.png[/IMG] [IMG]http://img854.**************/img854/846/91574257.png[/IMG]

(If I am onerous, I can create a new thread)

[Exolent[jNr]]

Change your sort clause to this (might not work for local databases since SQLite has quirks):

CONVERT(`data`, DECIMAL) DESC

EDIT:

CAST(`data` AS DECIMAL) DESC

That works for both MySQL and SQLite, so you should just use that one.

[funfel]

Now is:

sqlv_read_set_ex( g_hVault, eVaultMoney, sizeof( eVaultMoney ), _, "`key2` = 'totalmoney'", "CAST(`data` AS DECIMAL) DESC" );

And sometimes all are okey, but sometimes for all places name is empty and money are 0, and sometimes top looks like this old (with didnt sort data)



EDIT: These empty names and money are rare, wrong sorted places too, so I am happy, I am satisfacted (I dont know if this word exists >.<).

[Aooka]

It's like nVault but i try it's better. More easier ! Thx

[funfel]

Next easy question to you Exolent - If i wanna delete all values (inserts) for key2 "XXX" I should do:

sqlv_remove_ex( hVault, "*", "XXX" )

? I am not sure, I read .inc much times and still I am not sure And this remove_ex will clear only table XXX from values?

[Exolent[jNr]]

Originally Posted by funfel Now is: sqlv_read_set_ex( g_hVault, eVaultMoney, sizeof( eVaultMoney ), _, "`key2` = 'totalmoney'", "CAST(`data` AS DECIMAL) DESC" ); And sometimes all are okey, but sometimes for all places name is empty and money are 0, and sometimes top looks like this old (with didnt sort data) EDIT: These empty names and money are rare, wrong sorted places too, so I am happy, I am satisfacted (I dont know if this word exists >.<).

Really interesting. If you could post your code so I could see how you are saving data, it might help debug it.

The word you were looking for is "satisfied"

Originally Posted by funfel Next easy question to you Exolent - If i wanna delete all values (inserts) for key2 "XXX" I should do: sqlv_remove_ex( hVault, "*", "XXX" ) ? I am not sure, I read .inc much times and still I am not sure And this remove_ex will clear only table XXX from values?

Yes.

[EpicMonkey]

Originally Posted by Exolent[jNr] Use the sqlv_read_set() and sort by value.

PHP Code:

sqlv_read_set(g_hVault, eVaultData, sizeof(eVaultData) - 1,_,_, "desc"); 


you mean like this?