Easy Profile - Joomla Extension

Support

Support is currently Offline

Support Offline

It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!

Official support hours:

Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Friday 6:43 pm

Add a reply View Replies (2)

Resolved Use SQL queries as field

pat01
General
Thursday, November 23 2017, 03:13 PM

Hi

I need to run some SQL queries to get and display data in a profile tab.

Is there a way to do so? I don't see a field of type "Use SQL" or similar.

Thank you very much!

Responses (2)

admin Accepted Answer

Admin

Is there a way to do so?

Yes but not natively,
our delimiter field type allow you to use Joomla content plugins (docs about this field type at http://docs.easy-profile.com/index.php/article/html-delimiter-field-type).

You can use some free plugin like Sourcerer (https://www.regularlabs.com/extensions/sourcerer) to get usergroups and display with some code like this:

{source}

<?php

global $JSNLIST_DISPLAYED_ID;

if($JSNLIST_DISPLAYED_ID) $owner_id=$JSNLIST_DISPLAYED_ID;

else $owner_id=JRequest::getVar( 'id' , JFactory::getUser()->id ); 

$db=JFactory::getDbo();

$query='YOUR-QUERY'

$db->setQuery($query);

$result=$db->loadObjectList();

?>

{/source}

Customize and put this code in a HTML delimiter field type.

NOTE: this code is not tested and not supported, this is only for example purpose, you need to have PHP and Joomla devs knowledges.

more than a month ago
General
# 1

pat01 Accepted Answer

Pro

Thanks a lot!

more than a month ago
General
# 2

Page :
1

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

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

Request Support

Ask a Question

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.