Automatically update User Group ID

[jw4]

I want to automatically put users in a user group when they have confirmed registration, depending on the value of an extra user field.

I want to put the code where the user group value gets updated from 'awaiting email confirmation (ID 3) to 'registered' (ID 2) - but I can't find which php file this is in.

I have looked in userjoin.php and login.php but can't see it - can anyone tell me where this happens?

Any help much appreciated!

[Mike-N-Tosh +]

Register.php

[jw4]

Thank you Mike - I have found the section in Register.php where the user group (level) is updated.

I realise though that my php/sql is not yet very good (learning fast I hope), I wonder if anyone can help.

what I want to do is override the setting of level to 2 (registered user), depending on the value in an extra text field.

e.g. if extra2="Chiswick Community School" - level=6
if extra2="Teddington" - level=7
etc

Here is the section from Register.php, yo ucan see I had inserted an if statement which makes no difference.

If anyone can anyone give me the code to do this, I will very grateful!!

/**
* Confirms a signup against the confirmation code. If it
* matches, changes the user level. Sent by email, and is required
* by an optional setting.
*
* @access private
* @param string $confirmCode
* @return boolean
* @internal should we use _getUserData here too? I think we should
*/
function confirm ($confirmCode)
{
$sql = 'SELECT uVerify FROM ' . PREFIX . 'users WHERE uVerify=' . $this->_db->quoteInto($confirmCode) . ' AND level<>"4"';
$result = $this->_db->query($sql);
if ($result->size() != 1 || $this->_db->isError()) {
return false;
}
$result->freeResult();
$sql = 'UPDATE ' . PREFIX . 'users SET level=2 WHERE uVerify=' . $this->_db->quoteInto($confirmCode);
$result = $this->_db->query($sql);
if ($result->affectedRows() != 1 || $this->_db->isError()) {
$result->freeResult();
return false;
}

// update level (user group id) according to extra2 (school)

if ($extra2="Chiswick Community School")
{
$level=6;
}
else
if ($extra2="Teddington")
{
$level=7;
}
$modules = Library::loadLibrary('Modules');
$modules->call_hook('user_confirm', $userDetails); // Call any module functions
$result->freeResult();
return true;
}

[Lhotch +]

before you can perform any logic on the contents of a variable you have to make sure the variable even exists.

Next, your section of code is AFTER the sql query that updates the user level so altering the conents of the variale $level doesnt do anything because the users level was previously written to the database already.

[jw4]

Thank yoy very much Larry - it's working now. I have made the update value conditional on the value of $extra, as below.
I'm sure it's not the most elegant way of coding this but I understood what you meant and have managed to achieve what I wanted, so thanks again!

Code:

// update level (user group id) according to extra2 (school)

if ($extra2="Chiswick Community School")
{
$result->freeResult();
$sql = 'UPDATE ' . PREFIX . 'users SET level=6 WHERE uVerify=' . $this->_db->quoteInto($confirmCode);
$result = $this->_db->query($sql);
if ($result->affectedRows() != 1 || $this->_db->isError()) {
$result->freeResult();
return false;
}
}
else
if ($extra2="Teddington")
{
$result->freeResult();
$sql = 'UPDATE ' . PREFIX . 'users SET level=7 WHERE uVerify=' . $this->_db->quoteInto($confirmCode);
$result = $this->_db->query($sql);
if ($result->affectedRows() != 1 || $this->_db->isError()) {
$result->freeResult();
return false;
}
}
// end of modified update code