Extend registration page

[Dynadata]

Hi,

I want to extend my registration page by adding the choise of departments.
So I was thinking of the following:



But does anyone know how to get those departments into the register form?
It should be possible with a foreach statement....something like:

 
<{foreach key=key value=modification from=$departments}>
<input type="radio" name="<{$modification[title]}>"><{$modification[title]}> />
<{/foreach}>

Anyone can give me the correct code?

[Dynadata]

I only need to know how to get the name of the departments from the table.
So what is the code to see the column 'title' from the table 'swdepartments'.
I need this piece of code in a foreach lus.

Any guys who know how to do this?

[welch]

Are you looking to hand code the query?

Without looking up the class for kayako query, i would just write a simple loop.

PHP Code:

$query = mysql_query("SELECT departmentid, title FROM swdepartments ORDER BY displayorder");


while($results = mysql_fetch_array($query)){
echo "<input type=\"radio\" name=\"department\" value=\"".$results['title']."\">".$results['title']."<br />";
} 


[Dewak]

Hello,

If you are going to use the query posted by welch please add a WHERE sentence to include only ticket departments, otherwise your clients will submit tickets to LiveSupport department which makes no sense.

There's another solution but you will need to modify the client_submit.php file and pass the department name to the smarty template. Then in the template you just use that variable in the foreach statement that list the deparments.

Best

[Dynadata]

@Welch: Thank you for your input. I'm sure your code will be usefull to create this function.

@Dewak: In the first place I was planning to do this by your way but I was unable to do this.
I don't know how to pass the department name to the smarty template.
I could use the query welch said in the client_submit.php but how to pass on the variable to the smarty template?

[Dynadata]

If I look by the Admin CP >> Templates I can edit the register form.
But where is that file located? I can't seem to find that file.

I found the file which contains the insert query (\includes\functions_users.php) with the function "insertUser"
Below you will see the query for it:

 
$dbCore->query("INSERT INTO `". TABLE_PREFIX ."users` (`usergroupid`, `fullname`, `userpassword`, `userpasswordtxt`, `dateline`, `lastvisit`, `lastactivity`, `enabled`, `loginapi_moduleid`, `loginapi_userid`, `languageid`, `timezoneoffset`, `enabledst`, `useremailcount`, `allowemail`, `ismanager`) VALUES ('". intval($usergroupid) ."', '". $dbCore->escape(iif(empty($fullname), $email, $fullname)) ."', '". iif($ismd5==true, $password, md5($password)) ."', '". $dbCore->escape($txtpassword) ."', '". DATENOW ."', '0', '0', '". iif($enabled==true, "1", "0") ."', '". intval($loginapi_moduleid) ."', '". $dbCore->escape($loginapi_userid) ."', '". intval($languageid) ."', '". $dbCore->escape($timezone) ."', '". iif($enabledst==true, "1", "0") ."', '1', '". intval($allowemail) ."', '". iif($ismanager==true, "1", "0") ."');");

The value for the usergroupid is "intval($usergroupid)".
Where will that variable be filled?

[Dynadata]

In my first post I descriped my intension on the wrong way.
I want clients that register by the client support interface, can choose which user group they want.
So I have now the following:



The numbers you see are the usergroupid's. This is the code I used:

 
$query = mysql_query("SELECT usergroupid, title FROM swusergroups WHERE grouptype = 'registered' ORDER BY title");
 
while ($results = mysql_fetch_array($query))
{
 echo "<input type=\"radio\" name=\"usergroupid\" value=\"".$results['usergroupid']."\"><span class=\"smalltext\">".$results['usergroupid']."</span><br />";
}

So your selection of the group can be accessed from $_POST['usergroupid'].
How to get that value into the table by clicking on register?

[Matthew]

Originally Posted by Dynadata

In my first post I descriped my intension on the wrong way.
I want clients that register by the client support interface, can choose which user group they want.

I have so wanted this, and now I am watching these developments eagerly. Go man, go!

[Dynadata]

The problem at this moment, is inserting the $_POST['usergroupid'] value into the table. So any help would greatly be appriciated.

EDIT:
The input fields that need to be inserted into the table users are:
- fullname
- email
- password
- passwordagain

I've added one field which name is:
- usergroupid

In "\includes\functions_users.php" you'll find "function renderUserForm($type)".
Inside this function you'll find
- $_POST["fullname"]
- $_POST["email"]
- $_POST["password"]
- $_POST["passwordconfirm"]


I've added after this line:

printTextRow("passwordconfirm", $_SWIFT["language"]["usrpasswordconfirm"], $_SWIFT["language"]["desc_usrpasswordconfirm"], "password", $_POST["passwordconfirm"]); 

The following:

printTextRow("usergroupid", $_SWIFT["language"]["usrformgroup"], $_SWIFT["language"]["desc_usrformgroup"], "text", $_POST["usergroupid"]); 

Still nothing changed after I placed that line in the function.
So where should I look to fill the variable "$usergroupid" which is used in the "insertUser" function?