Title: john ackers's Replies | WordPress.org --- # john ackers [ ](https://wordpress.org/support/users/john-ackers/) * [Profile](https://wordpress.org/support/users/john-ackers/) * [Topics Started](https://wordpress.org/support/users/john-ackers/topics/) * [Replies Created](https://wordpress.org/support/users/john-ackers/replies/) * [Reviews Written](https://wordpress.org/support/users/john-ackers/reviews/) * [Topics Replied To](https://wordpress.org/support/users/john-ackers/replied-to/) * [Engagements](https://wordpress.org/support/users/john-ackers/engagements/) * [Favorites](https://wordpress.org/support/users/john-ackers/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 150 total) 1 [2](https://wordpress.org/support/users/john-ackers/replies/page/2/?output_format=md) [3](https://wordpress.org/support/users/john-ackers/replies/page/3/?output_format=md)… [8](https://wordpress.org/support/users/john-ackers/replies/page/8/?output_format=md) [9](https://wordpress.org/support/users/john-ackers/replies/page/9/?output_format=md) [10](https://wordpress.org/support/users/john-ackers/replies/page/10/?output_format=md) [→](https://wordpress.org/support/users/john-ackers/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] View are loaded on startup](https://wordpress.org/support/topic/view-are-loaded-on-startup/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [8 years, 8 months ago](https://wordpress.org/support/topic/view-are-loaded-on-startup/#post-9619868) * That’s extraordinary. I am struggling to understand how or why dbview plugin would get to run at all if it’s not explicitly included in the page (or widget) that’s being display. I don’t think I understand what exactly is happening. Can you give me some more specific links? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[ecampaign] Table ‘xx_wpxxx.wpxj_ecampaign_log’ doesn’t exist](https://wordpress.org/support/topic/table-xx_wpxxx-wpxj_ecampaign_log-doesnt-exist/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [8 years, 8 months ago](https://wordpress.org/support/topic/table-xx_wpxxx-wpxj_ecampaign_log-doesnt-exist/#post-9598352) * You can manually create the table and the SQL is in the EcampaignLog.class.php. It looks something like: `CREATE TABLE`wp_ecampaign_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `state` char(20) NOT NULL, `visitorName` varchar(50) NOT NULL,` visitorEmail` varchar(50) NOT NULL, `address` varchar(100) NOT NULL, `checkbox1` tinyint(1) NOT NULL, `checkbox2` tinyint(1) NOT NULL, `target` varchar(50) NOT NULL, `info` varchar(1024) NOT NULL, `postID` bigint(20) NOT NULL, PRIMARY KEY(` id`), KEY `postID_visitorEmail` (`postID`,`visitorEmail`) ) ;` * Not sure why your new site didn’t recognise that you had a virgin install. Anyway hope this helps. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] Form pass value to DBView](https://wordpress.org/support/topic/form-pass-value-to-dbview/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [10 years, 2 months ago](https://wordpress.org/support/topic/form-pass-value-to-dbview/#post-7222794) * DBView doesn’t handle get/post queries from the client out of the box. I think you could add some javascript to your form that called dbview.executeQuery() which would load/reload a particular table with the Division specified ‘arg1’ in the query. I might be able to provide more complete solution later in the week. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[ecampaign] is eCampaign php5.3 compatible?](https://wordpress.org/support/topic/is-ecampaign-php53-compatible/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [10 years, 6 months ago](https://wordpress.org/support/topic/is-ecampaign-php53-compatible/#post-6814215) * I’m using it with HP 5.3 without problem. * If you are using the standard template(s), can you see “Please contact {campaignEmail} if you have any difficulties or queries.” and does {campaignEmail} get substituted correctly with the email address you set up? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] Shortcode for Admin Pages](https://wordpress.org/support/topic/shortcode-for-admin-pages/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [10 years, 7 months ago](https://wordpress.org/support/topic/shortcode-for-admin-pages/#post-6718810) * The table data is requested via ajax call and returned in a JSON format. Don’t know the answer but I’d check the browser error log and requests and responses e.g. by looking in the apache access log or perhaps using the browser debugger. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] show vertical table instead of horizontal table](https://wordpress.org/support/topic/show-vertical-table-instead-of-horizontal-table/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [10 years, 9 months ago](https://wordpress.org/support/topic/show-vertical-table-instead-of-horizontal-table/#post-6555450) * Sorry not supported in this plugin and a significant piece of work to support it. Will try to accommodate in future version. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] Interaction with Form Elements added](https://wordpress.org/support/topic/interaction-with-form-elements-added/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [10 years, 9 months ago](https://wordpress.org/support/topic/interaction-with-form-elements-added/#post-5835290) * maiersoft did send me a set of patches for dbview and they do work. However they would be difficult for me to support. If I updated the plugin and it no longer worked with particular form elements, it would be more tricky to sort out. So I don’t want to integrate into dbview. Instead I want to add a search box(es) that appear at the top of the table when the SQL includes some specific token. It’s obviously not as flexible but easier to set up. But if you email me at the address in header of dbview.php, I’d be happy to forward maiersoft’s email including attachments. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] Variable Cell Color by Data](https://wordpress.org/support/topic/variable-cell-color-by-data/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [10 years, 11 months ago](https://wordpress.org/support/topic/variable-cell-color-by-data/#post-6354086) * Yes, you could add some thing like that to handleDOMUpdates() in dbview.js; it will run after the table is loaded but it’s a bodge! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] Variable Cell Color by Data](https://wordpress.org/support/topic/variable-cell-color-by-data/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [10 years, 11 months ago](https://wordpress.org/support/topic/variable-cell-color-by-data/#post-6353935) * Sorry, don’t think cell background can be controlled programmatically. You can wrap the the cell contents in DIV or SPAN tags and set the background colour using a STYLE attribute but that’s not quite the same thing. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] Date type filter](https://wordpress.org/support/topic/date-type-filter/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [10 years, 11 months ago](https://wordpress.org/support/topic/date-type-filter/#post-6324190) * OK here is a link to [the codex page](https://codex.wordpress.org/Class_Reference/wpdb#Placeholders) that describes how placeholders %d, %s, %f are used. Dbview uses the wpdb class. Hope this helps. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] Date type filter](https://wordpress.org/support/topic/date-type-filter/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [10 years, 11 months ago](https://wordpress.org/support/topic/date-type-filter/#post-6324168) * To show users who registered today: * ``` select ID, user_login, user_email, user_registered, user_status from wp_users where user_registered > curdate() ``` * If you want to show users registered on the same day think you’d need to use an MSSQL subquery and some date math functions to check that user_registered fell inside the same 24 hour window. That’s not really anything to do with dbview and a bit pushed for time! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] External Links to Open in New Window](https://wordpress.org/support/topic/external-links-to-open-in-new-window/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [10 years, 11 months ago](https://wordpress.org/support/topic/external-links-to-open-in-new-window/#post-6137576) * Try this: * ``` $url=trim($value); return empty($url) ? "" : " Amazon"; ``` * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] External Links to Open in New Window](https://wordpress.org/support/topic/external-links-to-open-in-new-window/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [11 years ago](https://wordpress.org/support/topic/external-links-to-open-in-new-window/#post-6137563) * Lots of possibilities. Suspect that the links don’t start with http:// or [https://](https://wordpress.org/support/users/john-ackers/replies/?output_format=md). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] Pass page title through to SQL query](https://wordpress.org/support/topic/pass-page-title-through-to-sql-query/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [11 years ago](https://wordpress.org/support/topic/pass-page-title-through-to-sql-query/#post-6148396) * I was thinking that you wanted to reference the page_title from the PHP snippet. I think the only way to do this is to save the page_title in a global variable then access as a global variable in the PHP snippet – an enormous bodge. But I am wondering if the problem is simply getting into edit mode – which you do by ‘load’ ing the DBView then clicking the ‘execute query’ button. Sorry that’s not obvious. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[dbview] How to hide the report page header](https://wordpress.org/support/topic/how-to-hide-the-report-page-header/) * Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/) * (@john-ackers) * [11 years ago](https://wordpress.org/support/topic/how-to-hide-the-report-page-header/#post-6137557) * Hi, i’m working on an update at the moment. What if I add a header=XX option to the shortcode that determine whether the 1) title/search bar (in upcoming release) or 2) column names are shown ? Or do you think this property should be set/reset on the admin page. Any suggestions welcome. Thanks. * By the way, on the CSS, you should be able to wrap the dbview with DIV tags with different classes/IDs and adjust the CSS applied to each embedded DBView. Viewing 15 replies - 1 through 15 (of 150 total) 1 [2](https://wordpress.org/support/users/john-ackers/replies/page/2/?output_format=md) [3](https://wordpress.org/support/users/john-ackers/replies/page/3/?output_format=md)… [8](https://wordpress.org/support/users/john-ackers/replies/page/8/?output_format=md) [9](https://wordpress.org/support/users/john-ackers/replies/page/9/?output_format=md) [10](https://wordpress.org/support/users/john-ackers/replies/page/10/?output_format=md) [→](https://wordpress.org/support/users/john-ackers/replies/page/2/?output_format=md)