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]

@ Metrosports82 : Replace in the index.php

PHP Code:

$styles=$DB_site->query("SELECT styleid,title FROM `style` ORDER by styleid"); 


by

PHP Code:

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


[HIGH]Archive updated [/HIGH]

[MetroSports82]

thanks mate. great job on the hack.

[Alien]

Hey nice work.

May I ask exactly what needs to be removed to take out the number of users using a style? Thanks!

-Jason

Yesterday at 07:26 PM grog6 said this in Post #8
1 query to get the number of styles,

1 other which is run X times (depends of your number of styles to display how many users use the style, but you can remove this query and not show the number of users who use styles,

and 1 to update the user's table which is ONLY run if the user modify his style

[grog6]

@ Alien : Remove it from the index.php modification :

PHP Code:

$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=''; 


And it from the style_liste template : ($nombre)

[-Sidekick-]

Here is a problem I'm having with this hack...

If I use the style change hack to change my style, then I go into my usercp options and try to change it to something else, it won't take effect on the style I pick in my usercp options unless I pick it twice in a row.

Did I explain that okay? -.-

[o0stephane0o]

Side click, the bug you are experioencing have nothing to see with that hack, you have just noticed it now but it was there before installing that hack.

[Edgar]

Nice hack, but the numbers are not coming up correct for me.
To see what I mean see: http://www.avalancheonline.com/forums/index.php?s=
I have close to 1900 members yet only 200 or so users are showing up in the menu. And these are the only 3 styles there are.

[grog6]

@ Edgar : Take a look into your database, and look if other users don't have a wrong styleid recorded in their profile which may correspond to an old style you could have removed

[Edgar]

Ah, that will probably be it. I had a duplicate on one of my styles I later removed. So I guess the number will only update when people use that dropdownbox now or change it in their profile again, I see it already increased by a few numbers.

But I can live with it. Nice job with your hacks man, I already installed a few of them. They're small but usefull hacks, I like it that way.

[grog6]

Cliks install if you like it