Change member's usergroup after admin votes

[grog6]

With this hack you will be able, if you are more than 1 admin (or supermoderator) to establish a vote system where you can will choose to change a member's usergroup.

You have in the change_sergroup.php a variable wich define how many positive votes are required to change a member's usergroup. If enough valid votes are recorded, the member will automatically change of usergroup.

This hack is a vote system in your admin CP ... Once you've voted for a member, you can't vote for the same again and have to wait others admins (or supermodo) votes.

Files to modify : 2
Query ro run : 1
Files to upload : 1

Installation time : 5 min

Avec ce hack vous allez pouvoir si vous etes plusieurs administrateurs (ou supermoderateurs) sur votre forum a etablir un systeme de vote ou vous choisissez le nombre de votes positifs minimum necessaires pour que le membre choisi puisse changer de groupe, et ainsi chaque admin peut valider ou non ce choix ...

Ce hack est en fait un systeme de vote via votre admin CP pour changer un membre de usergroup ... Une fois que vous avez vote, vous ne pouvez plus le faire pour le meme membre et devez attendre que les autres utilisateurs ayant axx au CP ai fait leur choix


Fichiers a modifier : 2
Requete a executer : 1
Fichier a uploader : 1

Temps d'installation : 5 min



HERE IS THE FRENCH VERSION
Voici la version francaise

[grog6]

HERE IS THE ENGLISH VERSION
Voici la version anglaise

[grog6]

ALL FRENCH Screenshots are in the archive
Tous les SC sont dans le zip


1st SC, in the admin CP if you have users awaiting usergroup's validation
SC1 si des membres sont en attente de changement de usergroup sur l'accueil du CP admin

[grog6]

1st page of the hack
page d'accueil du hack

[grog6]

Vote for a user's awaiting usergroup's modification
Voter pr un member en attente de changement de usergroup

[grog6]

Show all validated users
Affichage de tous les memres deja valides

[grog6]

Here are options of a user you have already voted for
Affichage des options d'un membre pour lequel vous avez deja vot?

[Dean C]

Wow keep these hacks coming fast and furiously buddy - this is awesome !

- miSt

[iggy123]

Cool hack - is there anyway of adding this to the moderators group, we have only got 2 admins but we have 5 moderators.
I help run a gaming clan and this would be cool for voting people in to the clan - the main thing is I have only allowed 2 people access to the admin cp all the other "gaming admins" have access to the moderator panel

I also recieved this error message as well


Invalid SQL: SELECT * FROM change_usergroup WHERE (username='[TxM]BuLL'sEye' AND valide=1)
mysql error: You have an error in your SQL syntax near 'sEye' AND valide=1)' at line 1

mysql error number: 1064

Date: Friday 28th of March 2003 04:02:13 AM
Script: http://XXXX/forums/forums/admin/change_usergroup.php
Referer: http://XXXX/forums/admin/change_usergroup.php?

Is it something to do with his username? if so how can i stop people registering with invalid characters
----------
Update -- removed the ' from his username and tried again, didn't get the error message. Is this a "Feature" of the hack or can it be fixed? :confused:

[Limitter]

Nice Hack

can i modify the Time Limit for Poll ???

[grog6]

@ iggy123 : Replace in the file change_usergroup.php this :

SELECT * FROM user WHERE (username='$name')


by

SELECT * FROM user WHERE (username='".addslashes($name)."')

In fact, you just have to add addslashes() around the username in all the DB queries, this will automatically add a \ before the ' which is in the member's username, and so there should be no error ;)

@ Limitter, you can't for the moment, try to add one by yourself, it shouldn't be too hard ;)

[sebastien69]

not work properly

Still have somme part that not showing

admin/index.php you have

https://vborg.vbsupport.ru/attachment.php?s=&postid=374055

when you click on the link you have the list of the members awaiting vote but haven't got the option to vote ( yes ,no, no descision) ... Why ??...

I didn't changed your script maybe an error from your part...

Sorry for my bad english