Multiple ranking System

Following features

You can add so many rankingsystems you want extremly easy
The users can switch the systems at the cp and choose his own rankingsystem at the registration
complet admintool support
a possible ramified rankingsystem

i hope u like all

sigh, wrong board, pls move :stupid:

Update 24.11.2001:
The following bugs are handled

When a new user registered to the forum, the user would get the first title from the OLD usertitles. This is fixed.
When a user changed the ranksystem, he would only changed the title then he post something. This is also fixed.

Here are the Bugfixcode, the zipfile is now the bugfixed full release

*******************
* files, which will be edit by the bugfix
*******************

register.php 
member.php


*******************
* file
* member.php
* -------------
* modify the display for the field Ranksystem
* -------------
*******************

***
*search:
***

  // Custom User Title Code!

  if ($resettitle) {
    $group=$DB_site->query_first("SELECT usertitle FROM usergroup WHERE usergroupid=$bbuserinfo[usergroupid]");
    if ($group[usertitle]=="") {

      $gettitle=$DB_site->query_first("SELECT title FROM usertitle WHERE minposts<=$bbuserinfo[posts] ORDER BY minposts DESC LIMIT 1");
      $usertitle=$gettitle[title];
    } else {
      $usertitle=$group[usertitle];
    }
    $bbuserinfo[usertitle] = $usertitle;
    $bbuserinfo[customtitle] = 0;
    unset($customtext);
    
  }

***
*replace with
***

  // Custom User Title Code!

  $group=$DB_site->query_first("SELECT usertitle FROM usergroup WHERE usergroupid=$bbuserinfo[usergroupid]");
  if ($group[usertitle]=="") {

      $getprofilefield=$DB_site->query_first("SELECT profilefieldid from profilefield where 1 and title = 'Ranksystem' LIMIT 0, 1");
      $varname="field$getprofilefield[profilefieldid]";
      $rankid = $$varname;
      $gettitle=$DB_site->query_first("Select rankdetail.title from user, rankdetail left join userfield on user.userid = userfield.userid where user.userid= $bbuserinfo[userid] and rankdetail.rankid = $rankid and rankdetail.minposts <= user.posts ORDER BY rankdetail.minposts DESC LIMIT 1");

      $usertitle=$gettitle[title];
  } else {
    $usertitle=$group[usertitle];
  }
  $bbuserinfo[usertitle] = $usertitle;
  $bbuserinfo[customtitle] = 0;
  unset($customtext);
    
  $customtext = $usertitle;


*******************
* file
* register.php
* -------------
* modify the display for the field Ranksystem
* -------------
*******************

***
*search
***

  $usergroup=$DB_site->query_first("SELECT usertitle FROM usergroup WHERE usergroupid='$newusergroupid'");
  if ($usergroup[usertitle]=="") {

    $gettitle=$DB_site->query_first("SELECT title FROM usertitle WHERE minposts<=0 ORDER BY minposts DESC LIMIT 1");
    $usertitle=$gettitle[title];
  } else {
    $usertitle=$usergroup[usertitle];
  }

***
*replace with
***

  $usergroup=$DB_site->query_first("SELECT usertitle FROM usergroup WHERE usergroupid='$newusergroupid'");
  if ($usergroup[usertitle]=="") {

    $getprofilefield=$DB_site->query_first("SELECT profilefieldid from profilefield where 1 and title = 'Ranksystem' LIMIT 0, 1");
    $varname="field$getprofilefield[profilefieldid]";
    $rankid = $$varname;
    $gettitle=$DB_site->query_first("Select rankdetail.title from rankdetail where rankdetail.minposts <= 0 and rankdetail.rankid = $rankid ORDER BY rankdetail.minposts DESC LIMIT 1");

    $usertitle=$gettitle[title];
  } else {
    $usertitle=$usergroup[usertitle];
  }

[Neo]

umm k

[over]

has anyone tried this on 2.2.1 yet?

[Mike Gaidin]

Yes, it works perfectly.

[over]

Originally posted by J-OST
Yes, it works perfectly.

cheers for letting me know im gonna see how it looks along side the rest of my hacks

[Psychdrone]

could some one please explain this to me, I looked at thats guys board, and did nto notice anythign differemt?

[Wilhelm]

help, i think i did not all right. All works fine, i can add new rankings and it works in forum. But in my cp all "users" options(add, find...) except the last 2 one(email building list..) dont work any more. I get always an parse error in user.php on line 107. Please can anyone look after my problem? copy of the edited code in user.php

$profilefields=$DB_site->query("SELECT profilefieldid,title FROM profilefield");
while ($profilefield=$DB_site->fetch_array($profilefields)) {

if ($profilefield[title] == "Ranksystem") {
makechoosercode("Ranksystem","field".$profilefield[profilefieldid],"rank");
}
else {
makeinputcode($profilefield[title],"field".$profilefield[profilefieldid]);
}
{
doformfooter("Save");
}

if no one knows, can anyone send me his good working hacked user.php file? Before i installed this hack i updated to 2.2.1. in moment its not fine that the whole users cp dont work, i cant manage my users any more Would be very happy for help.

Wilhelm from germany

[Tho007]

I have install it but new user can not register/signup.

<<<
Database error in vBulletin 2.2.1:

Invalid SQL: Select rankdetail.title from rankdetail where rankdetail.minposts <= 0 and rankdetail.rankid = ORDER BY rankdetail.minposts DESC LIMIT 1 mysql error: You have an error in your SQL syntax near 'ORDER BY rankdetail.minposts DESC LIMIT 1' at line 1
>>>

can me anybody help.Whats wrong?
Thank you

[Zamora]

Originally posted by Tho007
I have install it but new user can not register/signup.

<<<
Database error in vBulletin 2.2.1:

Invalid SQL: Select rankdetail.title from rankdetail where rankdetail.minposts <= 0 and rankdetail.rankid = ORDER BY rankdetail.minposts DESC LIMIT 1 mysql error: You have an error in your SQL syntax near 'ORDER BY rankdetail.minposts DESC LIMIT 1' at line 1
>>>

can me anybody help.Whats wrong?
Thank you

Sorry, but i wasn?t able to post here until yet. I see the problem within the sql-statement, but i don?t know where it comes from. We use this hack on our board without complications, so i need more information to find a posible bug.
Perhaps you can get me via ICQ [42732369], so we can talk in a faster way?
I will test the hack-installation again, to find posible errors.

Your Error here:
rankdetail.rankid = ORDER
just after = there is missing the choosen RankID.
I cannot say why this is so. Can you please post me a link to this forum, so i can test the signup. I think i can find this bug faster, when i see it "live".

@Wilhelm: I?m just writing an email to you. But if you use ICQ, you can also try to catch me.

[null shinji]

but if you dont want it to just disable ur customtitle function you should then put a
if ($resettitle) {
before the if ($group[usertitle]=") { statement and close it just after the unset($customtext);
and dont forget to delete the $customtext = $usertitle; that is just after u must close the if ($resettitle) statement.....

[Minimazz]

Great hack, it works perfectly and no problem to the installation