[use select+SQL query] New custom plugin like create_by

Hello team,

I'd like to create a plugin with the same result of create_by plugin. The objective is to read and display a value dynamically from a specific table based on the user id.

I tried to copy and modify core plugin but without result

Thanks for your help.

Regards,

Ehy

please ... go to faq and you can find this
flexicontent.org/documentation/faq/70-de...-new-field-type.html
regards

Hello

1. may you do not need to create a new field type

-- you can create a FLEXIcontent field of type "select" and enable parameter "Use SQL query"
and inside fields enter (to use username):
"SELECT id AS value, username AS text FROM #__users"

OR enter (to use user's full name)

"SELECT id AS value, name AS text FROM #__users"


2. but after that what do you need to do?
only display in frontend a username?
if you want to do more complex things then yes you may need to create a new field type, this is not difficult for a developer:
(you will need to duplicate the TEXT or WEBLINK field type and the alter it to make the SQL query and other stuff that you will need)
How to Duplicate a Flexicontent Field to create a new Field Type

Hello team,

Thank you for your feedback.

I found a solution based on core.php.

Everything works fine.

Regards,

Ehy.