Mark Orie

John, I will work on the suggestions, for now I will start with a bi-lingual mail I guess.

It will be a while before I can crack my head about this one.

for those who have not seen John’s other plugins: I use eCampaign and DB view together.

You were right: I checked for activation but did not de- and reactivate before. It seems to have solved all problems at once.

The update also solved the problem with the link in the other thread

Sorry to have caused this small scare. Great!

I suspect “Public flag added to each view.”in the changelog has something to do with this. I upgraded from 0.3.2.

Can I set this flag in the database manually? Or is there more to it?

yep, that works just fine.

Tried one more thing, but that didn’t work. Can’t seem to figure out why not:

SELECT
  CONCAT('<a href="', f.deelnemendeorganisatieurl, '" target="_blank"><IMG SRC="', f.deelnemendeorganisatielogourl, '" width=100 /></a>') AS Logo

Gives me the desired HTML, but as text. Adding a snippet

$a= html_entity_decode($row['Logo']);
return($a);

which should do something (even if it is not the right thing 🙂 offers no change

I used to do them by hand. Those are stored in the media library.

Then I wanted to automate things, especially the count (before, I had to update the count manually on every subscription. It seemed like a good plan to store everything I needed in a table. I made that user (read co-administrator with no coding skills whatsoever) by making a Form manager form containing 3 fields: organisation, status (active= active participant/passive=available for projects but not yet involved in any) and logo. The fields are respectively text field, dropdown list and file upload. the logo is stored in the database as a blob.

I now realise it will be much easier to just add the logo’s to the media library and store the hyperlinks to them in the database. I might even be able to use a PHP snippet to transform the url into an img tag pointing to the same file using just the snippet you proposed or even only the last line of that. Adding the url seems easier than trying to identify the right logo in a query, especially since I need the extra table to read the status anyway.

Just learned SQL today to do this, so I was rather glad it worked at all :-). Your solution seems elegant.

oh, and strike the
AND m.meta_value= 0
I do not know what I was thinking there 🙂