Adding Security Question to the Admin Client Summary Page

[rodeoXtreme]

Hello,

 

We are trying to add Client's Security Question and Answer to the Admin Portal Client Summary Page. We are using the following code but there is nothing being displayed

 

SELECT tbladminsecurityquestions.question,
tblclients.securityqans 
FROM tblclients, tbladminsecurityquestions WHERE
tblclients.id=".$this->_tpl_vars['clientsdetails']['userid']."
AND tblclients.securityqid =
tbladminsecurityquestions.id

 

This is the code that use to work but are now getting MySQL syntax errors:

$result = mysql_query("SELECT tbladminsecurityquestions.question,
tblclients.securityqans FROM tblclients, tbladminsecurityquestions WHERE
tblclients.id=".$this->_tpl_vars['clientsdetails']['userid']." AND tblclients.securityqid =
tbladminsecurityquestions.id");

 

Does anyone know how to properly display this on the Client Summary?

 

Thanks,

[zomex]

Hello,

 

to the Admin Portal Client Summary Page

 

This information should already be present under the profile tab of the client summary page.

 

Jack

[rodeoXtreme]

Thanks Jack,

 

That is correct, it is available under profile page; however, we need to grant a Level1 user access to that page and by doing so, everyone has the ability to make changes to a critical part of a client's account. We are not willing to allow everyone in our organization to have that kind of access (especially new hires) without experience, bonded, etc.

 

We have customized the Client Summary page that provides enough details for each of our Departments to do their job without granting them direct (editable) access to areas that they do not need to have.

 

We actually had this working a few years ago with Matt's help but unfortunately with updates to php and mySQL it doesn't query anymore.

 

This is the code that Matt provided 3 years ago:

 

$result = mysql_query("SELECT tbladminsecurityquestions.question,
tblclients.securityqans FROM tblclients, tbladminsecurityquestions WHERE
tblclients.id=".$this->_tpl_vars['clientsdetails']['userid']." AND tblclients.securityqid =
tbladminsecurityquestions.id");

 

Thanks,

Keith

[rodeoXtreme]

We finally solved the Security Question and Answer on the Client Summary Page.

 

Reason for the need? Our Staff does not have access to a Client's Profile (security) but we need them to verify the identity.

 

By adding the following code we have been able to add it to the Client Summary Code:

 

<div id="errorbox" class="errorbox" style="font-size:14px;" style="display:none;"><p>The Security Question and Answer MUST be EXACT:</p>
<p>Security Question: <style="font-weight: bold;color: #cc0000;font-size:10px;text-align: left;">{php}
$result = mysql_query("SELECT tbladminsecurityquestions.question,
tblclients.securityqans FROM tblclients, tbladminsecurityquestions WHERE
tblclients.id=".$this->_tpl_vars['clientsdetails']['userid']." AND tblclients.securityqid =
tbladminsecurityquestions.id");
while($row = @mysql_fetch_array( $result )) {
$question = decrypt($row['question']);
}
if (!$question) {
echo 'NO QUESTION - please update!';
}else{
echo $question;
}
{/php}</style>
</p>
<p>Security Answer:  {$clientsdetails.securityqans}</p></div>

 

Here is a couple of screenshoots: