Change style on index with UPDATE

This hack displays a small box at the top of your forum's index, where you can change easily of style.
The number of users who used is too displayed just next the Style's name.

This hacks was already existed :

https://vborg.vbsupport.ru/showthrea...tyle+AND+index

but it didn't updat the user's table in the database, and if you use others hacks which display the user's style in the postbit, or an other hack to list hacks used on your board (such as mine or Lesane's), information which was displayed was false ! Now, it's updated when the user uses this scroll menu, and so, no pb with other hacks :-)

Moreover, the style directly shown in the scroll menu, is the style that the user uses, so he knows which style he used
A simple changement in this scroll menu, and the user is automatically redirected to the forum's index with the new style selected




Ce hack affiche en haut de votre forum une petite boite, ou vous pouvez facilement changer de style.
Le nombre d'utilisateurs utilisant ce style est egalement montre a cote du nom du style.

Ce genre de hack existait deja :

https://vborg.vbsupport.ru/showthrea...tyle+AND+index

mais il ne mettait pas a jour les infos du membre dans la table user, et si vous utilisez d'autres hacks qui montre le style de chaque membre dans le postbit, ou mon hack qui liste les styles utilises sur votre forum, les infos affichees auraient alors pu etre fausses ! Maintenant c'est mis a jour quand le user utilise ce petit menu, et ainsi, plus de pb avec les autres hacks :-)

De plus, le style actuellement utilis? par le membre est directement affiche, ainsi il sait quel style il utilise a tout moment.
Un simple changement dans ce menu, redirige le membre vers l'accueil du forum avec le nouveau style choisi



[HIGH]Here is the english version.
I could understand a mod or Firefly want to remove this hack (which is only a modification of an other one)

Voici la version anglaise.
Je pourrais comprendre qu'un modo ou un Firefly veuille supprimer ce hack, etant donne que ce n'est que la modification d'un hack de Firefly[/HIGH]

[grog6]

I can nothing for you at the moment ... haven't any time ...

See it later (at the end of the week ! )

[Raz]

There is a security issue with this hack. I won't release the detail just yet, but here is what mine currently looks like:

PHP Code:

if ($bbuserinfo['userid'] > 0 and $_GET['styleid'] > 0) {
        $newstyleset = intval($_GET['styleid']);
        if ($allowchangestyles==1) {
                        $DB_site->query("UPDATE session SET styleid='$newstyleset' WHERE sessionhash='".addslashes($session['dbsessionhash'])."'");
                        $DB_site->query("UPDATE user SET styleid='$newstyleset' WHERE userid='$bbuserinfo[userid]' LIMIT 1");
                        vbsetcookie("bbstyleid","",1);
        }
          standardredirect("Style settings have been updated.", $bburl);
        exit;
} 


There extra code is how vB itself deals with changing styles i.e. expiring the style cookie and updating the sessions table.

[BigJohnson]

Hey SideKick. I have fixed that problem you have been tlaking about with the having to sumbit twice. Well that problem is due to this hack.

I have fixed it. And I think vbulletin.org should actually use this hack as well.

Ok go to member.php.

change this

  $stylesetlist = "";
  if ($allowchangestyles==1) {
    $stylesets=$DB_site->query("SELECT * FROM style WHERE userselect=1 ORDER BY title");
    if ( !isset($bbuserinfo['realstyleid']) ) {
      $bbuserinfo['realstyleid'] = $bbuserinfo['styleid'];
    }
    while($thisset=$DB_site->fetch_array($stylesets)) {
      if ($bbuserinfo['realstyleid']==$thisset['styleid']) {
        $selected = "selected";
      } else {
        $selected = "";
      }
      $thisid = $thisset['styleid'];
      $thisstylename = $thisset['title'];
      eval ("\$stylesetlist .= \"".gettemplate("modifyoptions_styleset")."\";");
      eval ("\$stylecell = \"".gettemplate("modifyoptions_stylecell")."\";");
    }
  } else {
    $stylecell = "";
  }

to this

 $stylesetlist = "";
  if ($allowchangestyles==1) {
$styles=$DB_site->query("SELECT styleid,title FROM `style` WHERE userselect='1'  ORDER by styleid");
while ($style=$DB_site->fetch_array($styles)) {

$listes=$DB_site->query_first("SELECT COUNT(*) AS nombre FROM `user` WHERE styleid='$style[styleid]'");
$nombre=$listes[nombre];

if ($bbuserinfo[styleid] == $style[styleid]) $select='selected'; else $select='';

eval ("\$stylesetlist .= \"".gettemplate("modifyoptions_styleset")."\";");

}
eval ("\$stylecell = \"".gettemplate("modifyoptions_stylecell")."\";");

if ($styleid!='')
{
$DB_site->query("UPDATE user SET styleid='$styleid' WHERE userid='$bbuserinfo[userid]'");
}
}else{
$stylecell = "";
  }

and then change in the templates

modifyoptions_styleset
to this

<option value="$style[styleid]" $select> $style[title] ($nombre)</option>

This works 100%. I hope u enjoy it.

[-Sidekick-]

Thank you very much for looking into it Big, but I think I'm gonna hold off untill this security issue is looked into, and someone can modify it so it will work in the header as well.

[Kamui Shirou]

now ive got 45 queries instead of 35

[Kamui Shirou]

hm some kind of wierd. with out this hack i've got 33 queries, with it i've got 45 queries. with the one firefly posted 41 queries..... what the hell please help me ^^

[DB8 MissingLink]

I know this has been asked and vaguely responded to, but it would be awesome if I could add this to the header instead of forumhome...

Anyone...?

Please

jEd

[-Sidekick-]

08-11-03 at 11:30 PM DB8 MissingLink said this in Post #47
I know this has been asked and vaguely responded to, but it would be awesome if I could add this to the header instead of forumhome...

Anyone...?

Please

jEd

This hack was ditched by the hacker a couple of months ago. =\

[trinitym]

Is someone distributing this hack for vb3? I'd love to add this type of functionality to my board. I noticed it's on this [vb.org] board.

[I did a search and all I could find were vb2x versions, sorry if I'm blind.]

[grog6]

Hurm, haven't you seen at the bottom of each page on vb3 a similar thing ??