Miscellaneous Hacks - vS-IP - Sort by Vote Number/Score

This hack requires a working installation of Psionic Vision's Interactive Profiles Script, that can be found here:
https://vborg.vbsupport.ru/showthrea...hreadid=150028

Here is instructions on how to make your memberlist to be sorted by users with highest score/number of votes.
You can see example here:
http://www.tdotzone.com/forums/memberlist.php

/////////////////////Here we go//////////////////////////
Requires:
- 1 file edit
- 1 template edit
///////////////////////////////////////////////////////////

Open your memberlist.php and FIND:

PHP Code:

case 'username':
            $sqlsort = 'user.username';
            break; 

Add UNDER:

PHP Code:

    case 'popular':
            $sqlsort = 'user.iprof_votenum';
            break;
    case 'vote':
            $sqlsort = 'user.iprof_votetotal / user.iprof_votenum';
            break; 

Save.

In template memberlist ADD (anywhere you wish I have it right after $navbar):

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt2" align="center">


<a rel="nofollow" href="$vboptions[bburl]/memberlist.php?sort=vote&order=desc">Top Members</a> 
| 
<a rel="nofollow" href="$vboptions[bburl]/memberlist.php?sort=popular&order=desc">Popular Members</a> 


  

</td>
</tr>
</table>

<br/>

Save.

Done. This adds a nice bar where your members can sort users by their rating/number of votes.

[jedisct1]

Hello !

Nice work dude.

What is the script you are using in order to display the login/registration form for guest users?

[Sychev_S]

It was custom made.

[akanevsky]

Спасибо что опубликовал.
Может быть, стоит отметить эту публикацию как дополнение к моей теме, чтобы она там показывалась.

[Shazz]

Originally Posted by Psionic Vision

Спасибо что опубликовал.
Может быть, стоит отметить эту публикацию как дополнение к моей теме, чтобы она там показывалась.

English

[akanevsky]

Originally Posted by Shazz

English

I thanked, and I said is that he should set this publication to be a mod of the main thread. That's all.

[hcmagix]

Originally Posted by Shazz

English

Where is the prolem ?
Im from old GDR and we must learn russian at school

[Shazz]

Originally Posted by hcmagix

Where is the prolem ?
Im from old GDR and we must learn russian at school

Some people aren't smart enough to learn russian

[FleaBag]

How did you get the dropdown filter boxes on the right? Would you mind releasing that?

[Sychev_S]

Originally Posted by Psionic Vision

Спасибо что опубликовал.
Может быть, стоит отметить эту публикацию как дополнение к моей теме, чтобы она там показывалась.

Да без вопросов. Ты же всё-таки хозяин.