problem eval with 3.92

[merlino68]

a pre-calculated field with this:
$user =& JFactory::getUser();
$userid = $user->get('id');
$db =& JFactory::getDBO();
$ip =str_replace(".","",$_SERVER['REMOTE_ADDR']);
$db->setQuery("SELECT id_allen FROM tm_sessioni_attive WHERE `id_ins` = $userid AND `ip_now` = '{session.token}'");
$result_val = $db->loadResult();
return $result_val;

"returns this error: Debug: Caught exception on eval of id_allen: Only variables should be assigned by reference"

eval is yes

 

[troester]

I don't think this is related to 3.9.2 but to you php version.

But & JFactory:: is very outdated.
Use just JFactory::

For DB access see http://fabrikar.com/forums/index.php?wiki/php-common-tasks/&redirect=common-php-tasks

 

[merlino68]

php is 7.2

I changed this way, but if I put the number (es 226 )instead of $userid, it works
If I put $userid, it doesn't work

$myDb = JFactory::getDbo();
$myQuery = $myDb->getQuery(true);
$userid = JFactory::getUser();

$myQuery
->select('id_allen')
->from('tm_sessioni_attive')
->where('id_ins = ' . $myDb->quote('$userid'));

$myDb->setQuery($myQuery);
$id_allen = $myDb->loadResult();

return $id_allen;

 

[troester]

Now you skipped getting the userid.
$user = JFactory::getUser();
$userid = $user->id;

 

[merlino68]

damn it is true ... sorry
now works
Thanks

 

[troester]

You can close solved threads by unchecking "open" in Thread Tools.

 

[merlino68]

ok thanks