vb.org Archive - Users choose Usergroup on reg...

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)

- - Users choose Usergroup on reg... (https://vborg.vbsupport.ru/showthread.php?t=54501)

Users choose Usergroup on reg...

I need a hack that lets users choose their usergroup on registration... but never change it after that.

Run this query:
[sql]ALTER TABLE usergroup ADD userchoose smallint(6) NOT NULL DEFAULT '0'[/sql]
Open admin/usergroup.php:
Find:

PHP Code:


		
			
  makeyesnocode("Viewable on <a href=\"../showgroups.php?s=$session[sessionhash]\" target=\"_blank\">Show Groups</a>?","showgroup",1);

Add below:

PHP Code:


		
			
  makeyesnocode("User can select to join this group on registration?","userchoose",0);

Find:

PHP Code:


		
			
usergroup (usergroupid,title,usertitle,

Replace with:

PHP Code:


		
			
usergroup (usergroupid,title,usertitle,userchoose,

Find:

PHP Code:


		
			
NULL,'".addslashes($title)."','".addslashes($usertitle)."',

Replace with:

PHP Code:


		
			
NULL,'".addslashes($title)."','".addslashes($usertitle)."','$userchoose',

Find:

PHP Code:


		
			
  if (($usergroupid != 1 and $usergroupid != 2 and $usergroupid != 3 and $usergroupid != 4 and $usergroupid != 7) or $usergroup['showgroup'] == 1) {

      makeyesnocode("Viewable on <a href=\"../showgroups.php?s=$session[sessionhash]\" target=\"_blank\">Show Groups</a>?","showgroup",$usergroup[showgroup]);

  } else {

        makehiddencode("showgroup",0);

    }

Add below:

PHP Code:


		
			
  makeyesnocode("User can select to join this group on registration?","userchoose",$usergroup[userchoose]);

Find:

PHP Code:


		
			
usergroup SET title='".addslashes($title)."',usertitle='".addslashes($usertitle)."',

Replace with:

PHP Code:


		
			
usergroup SET title='".addslashes($title)."',usertitle='".addslashes($usertitle)."',userchoose='$userchoose',

Open root/register.php:
Find:

PHP Code:


		
			
    // User selectable style sets

    $stylesetlist = "";

    if ($allowchangestyles==1) {

        $stylesets=$DB_site->query("SELECT * FROM style WHERE userselect=1");

        while($thisset=$DB_site->fetch_array($stylesets)) {

            if ($bbuserinfo[styleid]==$thisset[styleid]) {

                $selected = "selected";

            } else {

                $selected = "";

            }

            $thisid = $thisset[styleid];

            $thisstylename = $thisset[title];



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

            altbgcolor($prf_bgcolor);

            eval ("\$stylecell = \"".gettemplate("register_stylecell")."\";");

        }

    } else {

        $stylecell = "";

    }

Add below:

PHP Code:


		
			
    // User selectable usergroups

    $usergrouplist = "";

        $usergroups=$DB_site->query("SELECT * FROM usergroup WHERE userchoose=1");

        while($thisgroup=$DB_site->fetch_array($usergroups)) {



            $thisisid = $thisgroup[usergroupid];

            $thisisgroupname = $thisgroup[title];



            eval ("\$usergrouplist .= \"".gettemplate("modifyoptions_usergroup")."\";");

            altbgcolor($prf_bgcolor);

            eval ("\$groupcell = \"".gettemplate("register_groupcell")."\";");

        }

Find:

PHP Code:


		
			
  if ($allowchangestyles==1) {

    $newstylefield = "styleid,";

    $newstyleval = "'".intval($newstyleset)."',";

  } else {

    $newstylefield = "";

    $newstyleval = "";

  }

Add below:

PHP Code:


		
			
    $newgroupid = "'".intval($newusergroup)."',";

Find:

PHP Code:


		
			
'$newusergroupid',

Replace with:

PHP Code:


		
			
'$newgroupid',

Create new template: register_groupcell

Code:

<tr>

        <td bgcolor="{ firstaltcolor }"><normalfont><b>Usergroup:</b><br>

        <smallfont>You make pick a usergroup from the list to belong to.</smallfont></normalfont></td>

        <td bgcolor="{ firstaltcolor }"><smallfont><select name="newusergroup">

        $usergrouplist

        </select></smallfont></td>

[high]Remember:[/high] Remove the spaces in [high]{ firstaltcolor }[/high]
Create new template: modifyoptions_usergroup

Code:

<option value="$thisisid" $selected> $thisisgroupname </option>

Edit template: registeradult (and registercoppa)
Find:

Code:

$stylecell

Replace with:

Code:

$stylecell

$groupcell

:)

All should work;):)

Satan

Thanks so much... I've been needing this forever! Anyways... I got one little error when trying to register

Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO user
(userid,username,password,email,parentemail,coppau ser,homepage,icq,aim,yahoo,signature,adminemail,sh owemail,invisible,usertitle,joindate,cookieuser,da ysprune,lastvisit,lastactivity,usergroupid,timezon eoffset,emailnotification,receivepm,emailonpm,opti ons,birthday,maxposts,startofweek,ipaddress,pmpopu p,referrerid,nosessionhash,avatarid)
VALUES
(NULL,'seahawkin','d8927d2b97ba50b1f48f711177c62f5 a','sigpics@nfl-world.com','','0','http://','','','','','1','1','0','Rookie','1056681936','1 ','-1','1056681936','1056681936',''25',','0','0','1',' 0','15','0','-1','1','65.34.95.31','0','0','1','0')
mysql error: You have an error in your SQL syntax near
'25',','0','0','1','0','15','0','-1','1','65.34.95.31','0','0','1','0')' at line
1

mysql error number: 1064

Date: Thursday 26th of June 2003 07:45:36 PM
Script: http://www.nfl-world.com/forums/forums/register.php
Referer: http://www.nfl-world.com/forums/register.php

Thanks again!

Quote:

''25',','0'

That looks like there may be an extra set of '' s that are either in the wrong place or should not be there - Can you post the code from register.php where it inserts the user?:)

Satan

PHP Code:


		
			
  $DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield."parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,showemail,invisible,usertitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,usergroupid,timezoneoffset,emailnotification,receivepm,emailonpm,options,birthday,maxposts,startofweek,ipaddress,pmpopup,referrerid,nosessionhash,avatarid) VALUES (NULL,'".addslashes(htmlspecialchars($username))."','".addslashes(md5($password))."','".addslashes(htmlspecialchars($email))."',".$newstyleval."'".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','".time()."','$cookieuser','".addslashes($prunedays)."','".time()."','".time()."','$newgroupid','".addslashes($timezoneoffset)."','$emailnotification','$receivepm','$emailonpm','$options','".addslashes($birthday)."','".addslashes($umaxposts)."','".addslashes($startofweek)."','".addslashes($ipaddress)."','$pmpopup','".addslashes($testreferrerid['userid'])."','$nosessionhash','$avatarid')");

  $userid=$DB_site->insert_id();

That?

Hmm it all appears to be ok...

:confused:

Satan

Quote:

Today at 11:52 AM Logician said this in Post #5
also might help:
https://vborg.vbsupport.ru/showthrea...ht=register%2A

That's exactly what I need it for... but I'll just use this one from Satan... since he already took the time to start it, and, previewing it, it is exactly what i need.

Thanks anyways :)

Quote:

Today at 06:56 PM hellsatan said this in Post #8
Hmm it all appears to be ok...

:confused:

Satan

hm....

Quote:

Yesterday at 08:56 PM hellsatan said this in Post #8
Hmm it all appears to be ok...

:confused:

Satan

Chris you are adding ' to new usergroupid here:

PHP Code:


		
			
$newgroupid = "'".intval($newusergroup)."',";

and thus making it a string, then you are trying to insert its value into database as if its an integer:

PHP Code:


		
			
'".time()."','$newgroupid','".addslashes($timezoneoffset)."',

It is not an integer anymore, it holds value:

'11',

which is a string and 's in it clashes with query string..

Quote:

Today at 09:25 AM Logician said this in Post #11
Chris you are adding ' to new usergroupid here:

PHP Code:

$newgroupid = "'".intval($newusergroup)."',";

and thus making it a string, then you are trying to insert its value into database as if its an integer:

PHP Code:

'".time()."','$newgroupid','".addslashes($timezoneoffset)."',

It is not an integer anymore, it holds value:

'11',

which is a string and 's in it clashes with query string..

What do I need to change to fix it? Thanks... :)

bump, need it to work.

Also, just wondering... if they select a group that has full forum access, will it eliminate the E-Mail Confirmation? Is there a way to get around this if so? If not, that's ok... this hack is more important to me :)

did we ever figure this out???

Ill be using this hack soon aswell, Buczilla if your still around i think he means to replace the ' witht eh usergroup ID number, which is why he referenced the #11.

Does this work on 3.5.1 or .2?

Quote:

Originally Posted by DDad

Does this work on 3.5.1 or .2?

nope

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (21)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (17)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01311 seconds Memory Usage 1,843KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (21)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (17)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: