larry.bradley

Thanks, Michael.

For my own purposes, I have managed to change the source in lists.php and controls.php to do what I need (for now).

In controls.php I defined new functions (e.g. textDisabled, based on text) that set the disabled attribute on the items I need.

Then in lists.php, for each column, based on the list number (in my case an list number < 4) I use the disabled version of the control.

It works like a charm.

Stefano, I have my upload stuff working just fine now. The newsletter database now has all our customers in it. What happens if someone tries to subscribe via the popup, and their email address is already in the database (i.e. via our upload)?

Second question, for testing, I want to delete the cookie the popup uses, so I can force the popup to appear. How do I identify the cookie in Chrome’s cookie list? What is the name of the cookie?

OK. I can add a column to the newsletter table safely. Good news.

I don’t think the lists are an option, as you would normally think of options. The email rate (emails/hour) is an option. The lists are actually “tables” in a database sense. There is one row for each list, with the list number, the list name, the list flags as columns. I assume that you read in the list data from the options table at startup, and write it back out when the user changes the name, or one of the flags. Smells like a database table to me! (an aside … I am a database person … that’s what I do))

If it looks like a duck, walks like a duck, and talks like a duck, maybe it should be a duck!

Don’t think I am criticizing the plugin … I think it is great. We have been using it quite a lot. The subscription stuff, the way it works, is very clever. Nothing is more annoying than something that pops up every time you connect. I love the mail bounce addition! And I can live with the way the lists work. We are a small company, and we can enforce rules such as “Don’t change the name of the following lists, ever!” I just thought you might look at my ideas to see if they make sense to a wider customer base. I suspect there are a lot of customers who are similar to us. There are subscribers, and then there are others you get in via the import addition, of via database manipulation.

Just some thoughts. Great product.

Thanks for discussing these things with me.

I have everything working fine. Via my program that uses mySQL to manipulate the newsletter data base, I can add and delete people, add or remove them from lists.

I have some suggestions to make it easier for people like me who want to manipulate the database externally.

First, it would be useful to have a flag in the database to distinguish subscribers from people added externally. This would not be seen by the plugin users.

Second, having the list data in a newsletter table rather than in the wp-options table would make life a lot easier for external access. It would then be easier to have more flags for list entries. One flag that would be useful is a “lock” flag. If this flag is set, the list can’t have its name changed via the plugin, and probably its contents can’t be changed either.

This stuff would only be useful to people like me who have a need to manipulate the newsletter database externally.

Thanks

Found the problem. It turns out that on my development machine, I was using the PHP-supplied tzdata time zone database, which must have got messed up during the update. By installing and updated on, all is well.

Neither of these worked. I have full access … it is on my personal machine, so I can try anything.

Thanks, Stefano.

I found out where the list names are kept … in the wp_options table. I am able to extract them and display them in my program with their names, if any.

The reason I don’t want to use a list to distinguish “users” from “subscribers” is that the plugin lets the admin change the list names, add/delete addresses from the lists. But I might look into that. It does, indeed, make more sense.

The other question was about the token. As I said, I create a token for users I add to the database using the PHP uniqid() function. It seems to work OK. How does the system use that token?

Also, I asked how the subscribe popup knows not to popup again for the same person each time he connects to our system?

Thanks.

I actually found the problem, thanks to you pointing me in the right direction. The plugin was doing the add_filter thing to register the 2 minute interval. And that was working. The problem occurred in the wp_schedule_event() call. The interval name was not in quotes:

wp_schedule_event( time(), $this->cron_id . ‘_interval’, $this->cron_id );

I changed it to

wp_schedule_event( time(), ‘ns_cloner_cron_interval’, $this->cron_id );

and all is well. No errors, the event shows up in the cron schedule. Now I will pass this on to the plugin author.

Thanks again!

Many thanks for taking the time to discuss this with me. I obviously do not understand completely how the cron stuff works, but you have given me some ideas as to where to look at the plugin code to see what is going on there.

That does not appear to be the problem in my case. There are several plugins that schedule events at a non-standard interval, and none of them result in the error message. It is only plugins that have a hook, but have not scheduled anything to run. There are no entries in the “cron” row in the options file. One plugin has the hook, but only sets up a schedule for the “pro” version. Another admin-only plugin has the hook, but only sets up a schedule if there is a situation where there may be a queue of requests.

I think that this is a legitimate situation. You set up the hook in case you need it later.

In the case of the admin plugin, which wants to run every 2 minutes, I just disabled the plugin, and the messages go away, since the plugin never gets loaded. I will just enable it when I need it, and put up with the errors. In the case of the other plugin, it only happens every day or so. I contact these people, and they will fix the problem.

Thanks, Patel, but those tables do not exist in our database. Our popups consist of an image, with popup on click. When I edit the popup in the behaviour section, there is a place where I have uploaded a picture, and it shows me the URL for that picture. This is the data that I would like to be able to change via mySQL when I move to another site. I have found a reference to this in the wp_postmeta table, and if I change the URL in the edit of the popup, then the data in wp_postmeta changes. But if I change it in wp_postmeta, then the image in the editing of the popup is gone, and it is not there on the web page either. I have a screenshot of the editing of the popup, but I don’t see how to upload that here.

Thanks.