×

info

Dear guests,
You are currently on the old forum we kept as a knowledge base. You will find the new community forum here
Welcome, Guest
Username: Password: Remember me
Keyword

TOPIC: include information from db in the text?

include information from db in the text? 10 years 9 months ago #457

  • Anonymous user
  • fraggyaut's Avatar
  • Posts: 3
  • Karma: 0
Hey guys!

At first, sry for my english, its not the best (:

What I want to:
I want to send out a newsletter, which includes information from the db.
Background: A list of all users who downloaded attachment xy should be sent...
I already have a table with 3 columns: id|attachmentid|userid (many to many)
So what i want is a simple "select userid from <table> where attachmentid = <number>"

So my question:
is this possible? if not, what way would you choose? how would you solve this problem?

Thanks in advance and best regards

fraggy
Please log in to post a reply

Re:include information from db in the text? 10 years 9 months ago #458

  • Anonymous user
  • john's Avatar
  • Posts: 10494
  • Thank you received: 2
  • Karma: 242
Hello Fraggy,

I'm not sure I understood what you wanted to do so let me know I'm right...

Option A:
You have a database table id|attachmentid|userid.
You want to send a Newsletter to your users including the information of who downloaded an attachment x.

Option B:
You have a database table id|attachmentid|userid.
You want to send a special Newsletter to all users who downloaded attachment x.


Which option do you want to do?
In the first case you will have to create an AcyMailing plugin (the documentation will be published very soon)
In the second case, it will have to execute a query to create your list based on your own table.
Please have a look at our official documentation before posting a new message!

If you use AcyMailing, please post a rating and a review at the Joomla! Extensions Directory.
Please log in to post a reply

Re:include information from db in the text? 10 years 9 months ago #459

  • Anonymous user
  • fraggyaut's Avatar
  • Posts: 3
  • Karma: 0
Hello john!

First case...
I hoped, it can be donewithout writing a plugin...

AFAIK its possible to include php code in articles with a plugin..
Does that work to with the newsletter?

Or maybe its possible to create an article with php code, and send this article with the newsletter?!

fraggy
Please log in to post a reply

Re:include information from db in the text? 10 years 9 months ago #460

  • Anonymous user
  • john's Avatar
  • Posts: 10494
  • Thank you received: 2
  • Karma: 242
Hello Fraggy,

The content plugin system is not triggered before sending the Newsletter.
We are still testing if we could trigger it... that would be really powerful but we have some issues with non compatible plugins (because we send the Newsletter from the back-end or from the front-end).

Anyway, what you want to achieve will be done with a plugin.
But we may reproduce the same Joomla plugin (in order to execute php code) for a Newsletter... so we create ourselves a general AcyMailing plugin to give you the possibility to include php code in your Newsletter. That's something possible too and may be interesting for other users.

I'm gonna add it to our todo list but can not give you any deadline as our list of planned feature is already quite long for the next AcyMailing version.
Please have a look at our official documentation before posting a new message!

If you use AcyMailing, please post a rating and a review at the Joomla! Extensions Directory.
Please log in to post a reply

Re:include information from db in the text? 10 years 9 months ago #465

  • Anonymous user
  • fraggyaut's Avatar
  • Posts: 3
  • Karma: 0
Hello john,

So, let's wait for the next release, and hope it will be included!
Looking forward to that (:

Thanks for your answers, really nice support here!

fraggy

EDIT:
Would it be possible with a plugin like that?
Last Edit: 10 years 9 months ago by Anonymous user.
Please log in to post a reply
Time to create page: 0.083 seconds
Powered by Kunena Forum