getting a user rank from database?

[davellaman]

I want users to be able to see their current rank amongst other users. I am somewhat stuck on how exactly I would query my database and retrieve this information. Any ideas?

[Don Vaillancourt]

Hi all,

Where does CF store cached cfform flash forms? I've searched on every
computer which has CF7 installed and I can't find it.

I'll do a view source of the page which has the form in it and do a
search for the file, '/541738542.mxml.cfswf' which should contain the
flash form, but can't find that file.

It seems that CF7 doesn't cache the forms on any of our servers because
the forms take way too long to reload.

I'm looking at the flex-config.xml file and turning on the production
switch, but it's not helping.

Anyone have a clue?

Thanks

[mxstu]

Don,

Did your message get posted to the wrong thread? The forums seem to be a bit flaky this weekend.

[mxstu]

Originally posted by: davellaman
I want users to be able to see their current rank amongst other users. I am
somewhat stuck on how exactly I would query my database and retrieve this
information. Any ideas?

What determines user rank in your application/database and what do you want to
display to the user (ex. Your rank is #10 out of 100, etc..)?

[davellaman]

we would be displaying rank as 5 out of 500. Rank in database would be
determined by user points.

So if i were to order a query by points, i would then have the list in point
order, however, how do I then select the exact user I want to find and also how
do I get their exact spot in the points list?


Thanks,

Mark

[mxstu]

And do you want to display the ranking for just the current user:

you are 5 out of 500

OR highlight the current user within a ranking of all users :

xxxx xxxxxx 1 out of 500
xxxx xxxxxx 2 out of 500
xxxx xxxxxx 3 out of 500
xxxx xxxxxx 4 out of 500

>>you are 5 out of 500<<

xxxx xxxxxx 6 out of 500

[baz]

After getting your query by points, you can do a QofQ (query of
queries) on that data for each user that you need. So for example, if
you want Ted's rank you would write:

<cfquery name="anything" dbtype="query">
select Rank
from (originalquery)
where Username='Ted'
</cfquery>

Now you have a second query with ted's rank without hitting the DB
again.

[mxstu]

One more thing, the code in the last post assumes that the scores for each user
will be unique. If they are not, you will need to add an additional clause to
determine the ranking when the scores are the same.