Styles for Premium Members

This Hack allows you to set styles for use only by premium members. (Premium members are people that you decide are premium either because they have paid or because you like them or for whatever reason you determine they are premium)

This hack does not use the usergroup system because it allows premium users to be in any usergroup. This enables me to keep moderators in a mods group, Epinions members in an Epinions group, and everybody else in the registered group and still mark them as a contributor.

Premium members on my board have paid a membership fee. My nonpaid members have the default style that has ad banners and few if any hacks.

My premium members have 5 styles to choose from. None have Ad Banners and there are more hacks and features.

If you want to see a live demo: Join my forum, look at the styles available to you. Then pay to become a premium member and look to see the available styles once you have paid.

KNOWN ISSUES:
None.

I will include screenshots in a few minutes.

NOTE: I will support this hack for users who know how to run queries and edit files. I will not explain the basics of hacking. I will support bugs. I will also refine the instructions if they are incorrect.


Custom Avatars Addon: https://vborg.vbsupport.ru/showthrea...084#post366084


No PM Quota for Premium Addon:
https://vborg.vbsupport.ru/showthrea...882#post364882

[amykhar]

Screenshot of making the style premium:

[amykhar]

Here is the screenshot of making the user premium:

this looks very nice. I am not sure if I will install it though.
If I ever get a donation thing up and running it will come in very handy

[EchoHype.com]

This is a very nice hack.

Good job!

[amykhar]

I got over my lazy spell and updated this hack so that you can change premium member's styles from the admin control panel. The text file has been updated.

If you have already installed it, you simply need to do this in user.php:

Find:

// returns a combo box containing a list of titles in the $tablename table.
// allows specification of selected value in $selvalue
  global $DB_site,$bgcounter;

Replace With:

// returns a combo box containing a list of titles in the $tablename table.
// allows specification of selected value in $selvalue
  global $DB_site,$bgcounter,$user;

Find:

$result=$DB_site->query("SELECT title,$tableid FROM $tablename WHERE userselect=1 ORDER BY title");

Replace With:

  if ($user[premium]){
     $result=$DB_site->query("SELECT title,$tableid FROM $tablename WHERE userselect>0 ORDER BY title");
  }
  else {
     $result=$DB_site->query("SELECT title,$tableid FROM $tablename WHERE userselect=1 ORDER BY title");
  }

[N9ne]

Question: There's a drop down menu for style sets in register.php and member.php. Does this make it so users who are registering cannot select premium styles?

Also, how would I go about making this work with the change style drop-down menu hack, located: here.

[amykhar]

I did not incorporate it into register.php because my members have to register first before they can become premium members. The paypal integration requires that their username already exist. Therefore, people registering can only choose from the non-premium styles.

Regarding the second question, I would simply change This:

$allstyles=$DB_site->query("SELECT style.title, user.styleid, COUNT(*) AS count FROM user LEFT JOIN style USING (styleid) WHERE style.styleid IS NOT NULL AND style.userselect=1 GROUP BY user.styleid");

to this:

if ($bbuserinfo[premium]{
$allstyles=$DB_site->query("SELECT style.title, user.styleid, COUNT(*) AS count FROM user LEFT JOIN style USING (styleid) WHERE style.styleid IS NOT NULL AND style.userselect>0 GROUP BY user.styleid");
}
else {
 $allstyles=$DB_site->query("SELECT style.title, user.styleid, COUNT(*) AS count FROM user LEFT JOIN style USING (styleid) WHERE style.styleid IS NOT NULL AND style.userselect=1 GROUP BY user.styleid");
}

[amykhar]

I don't think I ever mentioned, this code prevents non-premium members from simply setting the styleid in their url and viewing the premium styles that way. The hack treats it just like they tried to use a non-selectable style.

[N9ne]

Oops! lol, of course! How can you make a guest a premium member ! I was having a dumb moment, sorry.

Also, thanks for that code for the drop down change style hack by FireFly, very helpful. Will install this later .