The Arcive of Official vBulletin Modifications Site.

Buczilla · #1 06-18-2003, 09:04 PM

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

Buczilla · #2 06-26-2003, 12:36 AM

bump

Chris M · #3 06-26-2003, 07:32 PM

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

Buczilla · #4 06-27-2003, 01:46 AM

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!

Logician · #5 06-27-2003, 09:52 AM

also might help:
https://vborg.vbsupport.ru/showthrea...ht=register%2A

Chris M · #6 06-27-2003, 04:43 PM

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

Buczilla · #7 06-27-2003, 04:53 PM

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?

Chris M · #8 06-27-2003, 04:56 PM

Hmm it all appears to be ok...

Satan

Buczilla · #9 06-27-2003, 04:57 PM

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

Buczilla · #10 06-27-2003, 05:06 PM

Quote:

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

Satan

hm....

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04462 seconds Memory Usage 2,328KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (4)bbcode_code (17)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!