Vbuletin 3.8.x Global Variables not found

[s_cocis]

Hi
in style "whosonlinebit" I would like to insert the date of registration "joindata" (in the new column ) in addition to

$userinfo[aimicon]
$userinfo[icqicon]
$userinfo[msnicon]
$userinfo[yahooicon]
$userinfo[skypeicon]

that are already present.

The variable $userinfo[joindata] does not work and does not work even the variable $globals[joindata].

can you help me ?

THZ
Sandro

[kh99]

Try this: create a new plugin using hook location online_query and this code:

$hook_query_fields .= " , FROM_UNIXTIME(user.joindate, '%M %D, %Y') as join_date ";


Then use {vb:raw userinfo.join_date} $userinfo[join_date] in the template.

[s_cocis]

Try this: create a new plugin using hook location online_query and this code:

$hook_query_fields .= " , FROM_UNIXTIME(user.joindate, '%M %D, %Y') as join_date ";


Then use {vb:raw userinfo.join_date} in the template.

with VB3 ?

[kh99]

with VB3 ?

Oops - sorry. I fixed it.

Also I should have mentioned, you can format the date however you want by changing the '%M %D, %Y' string. Here's the mysql doc page for the FROM_UNIXTIME() function: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_from-unixtime

...and a page that shows the tokens available for the format string: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

[s_cocis]

Oops - sorry. I fixed it.

Also I should have mentioned, you can format the date however you want by changing the '%M %D, %Y' string. Here's the mysql doc page for the FROM_UNIXTIME() function: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_from-unixtime

...and a page that shows the tokens available for the format string: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format


THANK YOU VERY MUCH ! :D