how do i remove user's home page from profile?

[FourTwenty]

how do i remove user's home page from profile?

i do not want my members promoting other websites anymore, they always abuse it..

therefore, i would like to eliminate the home page field of the user profile..
remove it from even being a choice during signup as well.
how can i do this?

thanks.

[Jake Bunce]

Admin CP -> Styles & Templates -> Style Manager -> « » -> Modify User Option Templates -> modifyprofile

Find and remove this block of code:

			<fieldset class="fieldset">
				<legend><label for="tb_homepage">$vbphrase[home_page_url]</label></legend>
				<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
				<tr>
					<td>$vbphrase[let_other_visitors_know_url]</td>
				</tr>
				<tr>
					<td>$vbphrase[home_page_url]:<br /><input type="text" class="bginput" name="homepage" id="tb_homepage" value="$bbuserinfo[homepage]" size="50" maxlength="200" dir="ltr" /></td>
				</tr>
				</table>
			</fieldset>

Now no one should be able to enter a homepage.

You can clear all existing homepage entries by running this query on your database (backup first):

UPDATE user
SET homepage = ''

[FourTwenty]

thanks bro!

[FourTwenty]

how do i run the query?

[Steve Machol]

To run queries from the Admin CP:

Admin CP -> Maintenance -> Execute SQL Query -> Manual Query

To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = 'x';

...with x being your userid number.

[FourTwenty]

perfect..
got it...
thanks bro!
and was able to do it myself....woohoo!

[Jake Bunce]

The code in the 3.5.x includes/config.php file actually looks like this:

	//	****** USERS WITH QUERY RUNNING PERMISSIONS ******
	//	The users specified here will be allowed to run queries from the control panel.
	//	See the above entries for more information on the format.
	//	Please note that the ability to run queries is quite powerful. You may wish
	//	to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';

[FourTwenty]

for some reason, i already had permission to do this....
so nothing needed to be edited..
thanks bro!

[Total666]

The code in the 3.5.x includes/config.php file actually looks like this:

    //    ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    //    The users specified here will be allowed to run queries from the control panel.
    //    See the above entries for more information on the format.
    //    Please note that the ability to run queries is quite powerful. You may wish
    //    to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';

So I'm id 1 , does this look correct ?? $config['SpecialUsers']['canrunqueries'] = '1'''; Thanks

[Jake Bunce]

$config['SpecialUsers']['canrunqueries'] = '1';