Re: [INC] SQLVault
Quote:
|
Re: [INC] SQLVault
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 :(
|
Re: [INC] SQLVault
It will always return as a string, regardless if you set as num, float, etc.
|
Re: [INC] SQLVault
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:
Code:
case _motd_MONEY: 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) |
Re: [INC] SQLVault
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. |
Re: [INC] SQLVault
Now is:
Code:
sqlv_read_set_ex( g_hVault, eVaultMoney, sizeof( eVaultMoney ), _, "`key2` = 'totalmoney'", "CAST(`data` AS DECIMAL) DESC" ); 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 >.<). |
Re: [INC] SQLVault
It's like nVault but i try it's better. More easier ! Thx
|
Re: [INC] SQLVault
Next easy question to you Exolent - If i wanna delete all values (inserts) for key2 "XXX" I should do:
Code:
sqlv_remove_ex( hVault, "*", "XXX" ) |
Re: [INC] SQLVault
Quote:
The word you were looking for is "satisfied" Quote:
|
Re: [INC] SQLVault
Quote:
PHP Code:
|
All times are GMT -4. The time now is 00:46. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.