server admins will love the
speed SQLite had given this ranking system.
:jumping:
Thanks again.
Dennis Cote wrote:
>
> Pejayuk wrote:
>> Thanks Dennis,
>> I get the gist of it.
>>
>> I am getting duplicate records though using insert or replace.
>> I was usin
is is a better explanation than before.
Many thanks for all your help so far.
:-D
-------
Dennis Cote wrote:
>
> Pejayuk wrote:
>> I still can't get this to work.
>> Can someone help please.
>>
&
I still can't get this to work.
Can someone please help.
:working:
I don't understand how to do this.
Many thanks in advance.
Pejayuk wrote:
>
> That is fantastic Igor.
> Thankyou.
> All I need to do now is work out how to get an update query to use a
> select query t
I still can't get this to work.
Can someone help please.
:working:
Pejayuk wrote:
>
> That is fantastic Igor.
> Thankyou.
> All I need to do now is work out how to get an update query to use a
> select query to update the records from stats_memory to stats_static after
&
:
>
> "Pejayuk" <[EMAIL PROTECTED]> wrote in
> message news:[EMAIL PROTECTED]
>> Is it possible to have a single SQL query execute on the stats_static
>> stats database and have it update from the records in stats_memory
>> stats database?.
>
> http://ww
Hi,
I'm new to sqlite.
I use it on my Counter Strike Source Zombie Mod game server.
I use eventscripts to access sqlite.
In eventscripts you can open memory databases like so.
es_xsql open stats_memory ":memory:"
And static databases like so.
es_xsql open stats_static |zmstats
In the stats_memor
(*) + 1 from stats b where b.points >
stats.points);
Many thanks the both of you for your help with this. I realy needed it.
ö¿ô
\_/
Gerry Snyder-4 wrote:
>
> Igor Tandetnik wrote:
>> "Pejayuk" <[EMAIL PROTECTED]> wrote in
>> message news:[EMAIL PROTECTED]
I have a player stats table with a points field.
I want to update the rank in this using a single query based on the points
in the row.
I am not that good at complex sql but I have managed to get the result I
want from the following select query.
SELECT points,(SELECT COUNT(*) FROM stats b WHERE
8 matches
Mail list logo