Updated Stars Hack

Here is an update to my stars hack - this one allows you different colored stars for admins/moderators

edit showthread.php

find:

$userinfo=$DB_site->query_first("SELECT userid,email,username,usertitle,signature,showemail,homepage,icq,aim,yahoo,joindate,posts FROM user WHERE userid=$userid");

If you have installed the avatar hack, this line will be modified. Just look for ' $userid=$post[userid]; ' and the line listed above will be 3-4 lines below that.

Edit that line listed above and add

usergroupid,

after the "SELECT" in that line. Make sure there is a space between the word you added and "SELECT". Make sure there is a comma after the word you added and before the next. It looks like this:

$userinfo=$DB_site->query_first("SELECT usergroupid,userid, (...) etc etr

find:

$userpostcount=$userinfo[posts];

Add this after it:

    // --- Stars Hack by rangersfan

     $stars = "";
     $s_usergroup = $userinfo[usergroupid];
     $moderator=$DB_site->query_first("SELECT usergroupid FROM forumpermission WHERE usergroupid = $s_usergroup AND canadminedit=1");
     if ($moderator[usergroupid] == $s_usergroup)  // This is a Normal Mod!
     {
        $starsgif = "<img src=\"images/star2.gif\" border=\"0\" width=\"15\" height=\"15\">";
     }
     else if ($s_usergroup==6) // This is an Admin!
     {
        $starsgif = "<img src=\"images/star2.gif\" border=\"0\" width=\"15\" height=\"15\">";
     }
     else if ($s_usergroup==5) // This is a SuperMod!
     {
        $starsgif = "<img src=\"images/star2.gif\" border=\"0\" width=\"15\" height=\"15\">";
     }
     else
     {
        $starsgif = "<img src=\"images/star.gif\" border=\"0\" width=\"15\" height=\"15\">";
     }
     if ($userpostcount > 1999)
     {      $stars .= $starsgif . $starsgif . $starsgif . $starsgif . $starsgif;   }
     elseif ($userpostcount > 999)
     {      $stars .= $starsgif . $starsgif . $starsgif . $starsgif;   }
     elseif ($userpostcount > 399)
     {      $stars .= $starsgif . $starsgif . $starsgif;   }
     elseif ($userpostcount > 99)
     {      $stars .= $starsgif . $starsgif;   }
     elseif ($userpostcount > 19) 
     {      $stars .= $starsgif;   }
     if ($stars == "")
     {   
        $stars .= "<br>";
     }   
     else
     {      
        $stars .= "<br><br>";
     }  
   // - Stars Hack

You need to supply your own stars names "star.gif" and "star2.gif". "star2.gif" is for admins/moderators. Put them in forums/images.

To modify how many stars correspond to how many posts you will need to change the if ($userpostcount > ..) parts. If you don't want stars, but galagas or such, change the parts that say '$stars .= $starsgif . $starsgif . $starsgif . $starsgif . $starsgif;' to something like '$stars .= (path to my image for x number of posts);'

Edit the postbit template and put $stars where you want them to appear.

[Edited by freddie on 11-04-2000 at 04:56 PM]

Doh! Feeling pretty dumb now...

Hehehe. Thanks RangersFan

-Tom

Hm... I've run into another problem, and I'm not quite sure what's wrong. I changed the code a little so if the user is Admin/Mod it automatically gives them 5 yellow stars, and if it's just a regular user, it gives them blue stars depending on how many posts they have. For some reason though, it's only giving the Administrator the yellow stars, and not the moderators (who are actually Super Moderators). Does it not work with Super Moderators?

-Tom

Change this line

if (($moderator[usergroupid] == $s_usergroup)||($s_usergroup==6))

to

if (($moderator[usergroupid] == $s_usergroup)||($s_usergroup==6)||($s_usergroup==5 ))

I have installed this hack and it works great! thanks a lot.
But I want to have it do mods get 9 silver stars and supper mods get 9 gold stars and admins get 10 gold

how can I do this? I have beed trying and i can't get it to work.

Con_Man I have changed the code above and if check you will see it now has sections of Mod/SuperMod and Admin. Just put the stars you want for each into each section.

I will optimize the SQL in this hack when v2.0 is released if there are no stars in v2.0 by default.

[Edited by freddie on 11-04-2000 at 05:03 PM]

Originally posted by freddie


I will optimize the SQL in this hack when v2.0 is released if there are no stars in v2.0 by default.

[Edited by freddie on 11-04-2000 at 05:03 PM]

I sure hope there is, should be

thanx.
great hack. i changed it a little. i added that admins get 8 stars and mods 7, no matter how many posts they have.

i get this when i upload the updated showthread.php

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

any ideas?

Throughout the entire showthread.php file I did not find

$userinfo=$DB_site->query_first("SELECT userid,email,username,usertitle,signature,showemail,homepage,icq,aim,yahoo,joindate,posts FROM user WHERE userid=$userid");

Nor anything close

Line changed in 1.1.5.

Look for $posts=$DB_site->query_first..........

Hope I'm correct.