john ackers

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?

You can manually create the table and the SQL is in the EcampaignLog.class.php. It looks something like:
CREATE TABLEwp_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.

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.

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?

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.

Sorry not supported in this plugin and a significant piece of work to support it. Will try to accommodate in future version.

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.

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!

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.

OK here is a link to the codex page that describes how placeholders %d, %s, %f are used. Dbview uses the wpdb class. Hope this helps.

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!

Try this:

$url=trim($value);
return empty($url) ? "" : "<a href='".$url."' target='_blank' > Amazon</a>";

Lots of possibilities. Suspect that the links don’t start with https:// or https://.

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.

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.