Question Kunena Rank - MySQL database - Solved by author :)

Hello everyone!
I have a simple little question, where can I find the part of mysql database that links the user with his rank. By links I mean userID - rank, I want to use the rank in kunenadiscussbot but I can't find the ranks. I found the ranks database its #__fb_ranks if I remember right but that does not link the userID to the ranks.
Now there's a table #__fb_users that has userID and ranks in it too, but only the special ranks appear those that go on posts (ex. 0 posts - newbie, 50 posts - regular visitor) don't appear there.
And btw how do I select something from a table?
Is it:

$db->setQuery("SELECT rank FROM #__fb_users WHERE userid=$userid");

$userrank = $db->loadResult();

and after that I would like to write that number somewhere - would echo Jtext:"userrank") in php but the discussbot uses $post->.

How could I make all these work?

Thank you for any respons!

Getting rank is not trivial -- actually it involves many different operations and some calculation.

That said, there will be an easy way to get user rank in K1.6.

Matias wrote:

Getting rank is not trivial -- actually it involves many different operations and some calculation.

That said, there will be an easy way to get user rank in K1.6.

Hmm, that sounds like it is too hard for me :laugh: That is why I couldn't do it.
But there is a plugin for Community Board that can get the ranks...so it isn't impossible.
I tried to look into that but couldn't really understand it.
By operations and calculations do you mean that ranks are always calculated from user posts and isn't preset in the database?

Could anyone help me out with this...it would be really really important for me at the site that I'm building...
I need to get ranks into the kunenadiscussbot, it only displays avatar and username right now.

Could someone lend me a hand? Maybe a Kunena developer...

And thank you Matias for your reply!
I'm guessing K 1.6 won't be out too soon?

Cheers and thanks,
Arpi

Isn't there anyone out there?
I've tried everything that I can and nothing works...please any developer out there who knows how this can be done please lend me a hand...
This is a sort of a school project and I have to be done by next Friday till the local festival starts...and people don't really understand that I can't do it...grrrr
Anyone?

P.S. It's not really a school project, more like a "Boyscout" project at our local school.

I would love to help you out of your predicament but I am flat-out busy myself. Unless you can sort this problem yourself, or if there happens to be a good samaritan who comes along, if your need is urgent and a "must-have" then you should seek the professional help of freelance programmer. You've already made some important discoveries about user ranks that I was unaware of and so full credit to you for that. I agree with Matias: this whole ranks management stuff a coder's nightmare.

You may have to accept that this is not something that can be achieved within your project's timeframe. I'm sorry, but disappointment is a reality in life.

K 1.6 will not be available in the imminent future, no.

Actually I think I can figure it out myself but thanks for your reply.
I've just learned how to source date from mysql in php so now I can get users postcount, which means that I can make an if - if - if thing (sorry don't know what the name is in english, maybe something called conditional statements) so if something is within 0-50 (posts of a user) do something, and in that do something I'm going to extract from the mysql database (as I did with postcount using userID) the name of the rank and the rank image (these are all in the mysql database under #__fb_rank) given that I have the minimum postcounts there too.
So I have everything in my mind now I only have to translate it into php. The little problem is that I only know Pascal programing :laugh: but php in structure as I've seen it is a little similar. So I'll have a look at some other php's from around joomla and kunena and I'll have to learn fast how I can make those "if"'s work.
So I'll be getting there, thanks for your help!
I love this forum, it's so complex. Thank you for it!
You've been doing a great job! And BTW if I can make this work I'll post it up here.

Cheers to everyone,
Arpi