1. maax99
  2. Support
  3. Friday, March 18 2016, 09:44 AM
hi
I have question how display longitude and latitude form different table in database ? Its possible Our is in user my is from resume ?

thank you
admin Accepted Answer
Admin
Hi,
our HTML delimiter fields support Joomla Content Plugin (see docs at http://docs.easy-profile.com/index.php/article/html-delimiter-field-type), so to do this you can use a workaround.

Example:
You can use NoNumber Sourcerer (https://www.nonumber.nl/extensions/sourcerer) to add PHP code to get values from DB query, so you can put in HTML delimiter fields something like:
{source}
<?php
$user_id=JRequest::getVar('id', JFactory::getUser( )->id );
$db=JFactory::getDbo( );
$query='SELECT latitude FROM your_table WHERE user_id='.$user_id;
$db->setQuery( $query );
$latitude=$db->loadResult( );
echo $latitude;
?>
{/source}


NOTE: This code is not tested and not supported, this is only for example purpose.
  1. more than a month ago
  2. Support
  3. # 1
maax99 Accepted Answer
Pro
Thank you

ps your job is awesome
  1. more than a month ago
  2. Support
  3. # 2
maax99 Accepted Answer
Pro
hi again last question maybe you know how change your code from module mod_jsnmap to display my resume (name of table is resume ) on maps my columns is longitude and latitude

thank you
  1. more than a month ago
  2. Support
  3. # 3
admin Accepted Answer
Admin
Hi,
sorry we do not provide custom code and customizations. Anyway this is too complex, it would be more simple to write a new module.

Another way is to sync data from table resume and our table #__jsn_users.
  1. more than a month ago
  2. Support
  3. # 4
maax99 Accepted Answer
Pro
ok thank you any way
  1. more than a month ago
  2. Support
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.