Sorry for the delayed response. My email delivery is messed up somewhere along the lines so I haven’t been getting notifications for a couple weeks. Publisher is using the native cp_url function, which looks at the cp_url config item, which defaults to the db, but then can be overwritten in your config file, e.g. $config[‘cp_url’] = ‘foo’;

I don’t know how their master config is setup. You’ll need to figure that one out yourself. I assume its whatever file is holding your production variables.

It shouldn’t affect current or newly saved content to change the url in the db. The approval script grabs the value from the config upon save and uses it in the email, so its separate from the content.

If you’re wanting to change it in the db you’ll just need to edit the settings and save it in the cp. If you want to change it in the db without editing the cp, then you’ll need to base64_decode(), then deserialize() the row in the exp_site table, edit, serialize(), then base64_encode() it again.

Its possible I’m not understanding what you’re trying to do?

It shouldn’t matter what is in the db b/c if its defined in the config file then that will override what is in the db. So if the dev and live config environments define the cp_url correctly, then Publisher should pick up on that and disregard what is set in the cp/db.

Try something like this:

$env_config[‘cp_url’] = ‘http://whatever.com’; $env_config[‘base_url’] . ‘http://somethingelse.com/admin.php’;

If that doesn’t work you may need to talk to Focus Lab b/c this seems more like a config issue than Publisher issue.