Title: Mark Orie's Replies | WordPress.org --- # Mark Orie [ ](https://wordpress.org/support/users/mnorie/) * [Profile](https://wordpress.org/support/users/mnorie/) * [Topics Started](https://wordpress.org/support/users/mnorie/topics/) * [Replies Created](https://wordpress.org/support/users/mnorie/replies/) * [Reviews Written](https://wordpress.org/support/users/mnorie/reviews/) * [Topics Replied To](https://wordpress.org/support/users/mnorie/replied-to/) * [Engagements](https://wordpress.org/support/users/mnorie/engagements/) * [Favorites](https://wordpress.org/support/users/mnorie/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 28 total) 1 [2](https://wordpress.org/support/users/mnorie/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/mnorie/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[ecampaign] [ecampaign] multilingual use](https://wordpress.org/support/topic/ecampaign-multilingual-use/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years ago](https://wordpress.org/support/topic/ecampaign-multilingual-use/#post-2670334) * 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. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[DB view] no management](https://wordpress.org/support/topic/db-view-no-management/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years, 3 months ago](https://wordpress.org/support/topic/db-view-no-management/#post-2531052) * John, * You did a poor job at not alarming me, and I thank you for it 🙂 Setting the public checkbox solved it. I did indeed see everything because of my administrator status. A warning might be in order. * My first instinct would be to set the default for “Public” to checked. In my case, I generate a view because I want to show something, and I only put it on a page once it does show what I like. I do not know whether there would be a way to call a view which has not been officially published (i.e. put on a post/ page with a shortcode), that would change things * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] [Plugin: dbview] [db view] displaying of images](https://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years, 3 months ago](https://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images/#post-2512199) * for those who have not seen John’s other plugins: I use eCampaign and DB view together. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] [Plugin: dbview] [db view] displaying of images](https://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years, 3 months ago](https://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images/#post-2512198) * it is. Should have posted that here too. No problems whatsoever anymore. Just two awesome plugins. Thanx! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[DB view] no management](https://wordpress.org/support/topic/db-view-no-management/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years, 3 months ago](https://wordpress.org/support/topic/db-view-no-management/#post-2530999) * 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! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] [Plugin: dbview] [db view] displaying of images](https://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years, 3 months ago](https://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images/#post-2512189) * After a little pause I tried to fix it, but the upgrade posed some major problems. I’ve started a new thread for that on [http://wordpress.org/support/topic/db-view-no-management?replies=2](http://wordpress.org/support/topic/db-view-no-management?replies=2) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[DB view] no management](https://wordpress.org/support/topic/db-view-no-management/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years, 3 months ago](https://wordpress.org/support/topic/db-view-no-management/#post-2530826) * 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? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] [Plugin: dbview] [db view] displaying of images](https://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years, 3 months ago](https://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images/#post-2512112) * Sorry for the dirty hacks, inexperienced makes for the odd interesting solution. Did it to avoid the extra column (since I have to combine site URL and LogoURL in one cell) * I tried this with 0.3.0. it didn’t work. I tried the same snippet before, but that didn’t work either. * Slight problem at the moment: I upgraded to 0.3.1, but the listview seems to have stopped working, so i can not see wether the upgrade improved things. will try with just the “load”function tomorrow. Some sleep would be in order at this moment, I think. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] [Plugin: dbview] [db view] displaying of images](https://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years, 3 months ago](https://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images/#post-2512107) * yep, that works just fine. * Tried one more thing, but that didn’t work. Can’t seem to figure out why not: * ``` SELECT CONCAT('') 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 * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] [Plugin: dbview] [db view] displaying of images](https://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years, 3 months ago](https://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images/#post-2512102) * > I made that user (read co-administrator with no coding skills whatsoever * should be * > I made that user (read co-administrator with no coding skills whatsoever)-** > friendly** * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] [Plugin: dbview] [db view] displaying of images](https://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years, 3 months ago](https://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images/#post-2512101) * 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. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[eCampaign] experience and thoughts](https://wordpress.org/support/topic/ecampaign-experience-and-thoughts/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years, 4 months ago](https://wordpress.org/support/topic/ecampaign-experience-and-thoughts/page/2/#post-2449165) * had one more question, but since it relates to DB View alone, I opened a new topic on [here](http://wordpress.org/support/topic/plugin-dbview-db-view-displaying-of-images) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[eCampaign] experience and thoughts](https://wordpress.org/support/topic/ecampaign-experience-and-thoughts/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years, 4 months ago](https://wordpress.org/support/topic/ecampaign-experience-and-thoughts/page/2/#post-2449164) * Just learned SQL today to do this, so I was rather glad it worked at all :-). Your solution seems elegant. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[eCampaign] experience and thoughts](https://wordpress.org/support/topic/ecampaign-experience-and-thoughts/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years, 4 months ago](https://wordpress.org/support/topic/ecampaign-experience-and-thoughts/page/2/#post-2449163) * Update fixed it! Everything works brilliantly, and not a moment to soon, since the rate of signing is growing dramatically * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[eCampaign] experience and thoughts](https://wordpress.org/support/topic/ecampaign-experience-and-thoughts/) * Thread Starter [Mark Orie](https://wordpress.org/support/users/mnorie/) * (@mnorie) * [14 years, 4 months ago](https://wordpress.org/support/topic/ecampaign-experience-and-thoughts/page/2/#post-2449160) * oh, and strike the `AND m.meta_value= 0` I do not know what I was thinking there 🙂 Viewing 15 replies - 1 through 15 (of 28 total) 1 [2](https://wordpress.org/support/users/mnorie/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/mnorie/replies/page/2/?output_format=md)